Create Class Category API

Create Class Category API TCA

Name of the API : CREATE CLASS CATEGORY
Base Tables Affected : HZ_CLASS_CATEGORIES
PL/SQL Procedure used : CREATE_CLASS_CATEGORY
Package Used : HZ_CLASSIFICATION_V2PUB

Mandatory Parameters :
Parameter Name Parameter Type Data Type
p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE
p_class_category_rec IN CLASS_CATEGORY_REC_TYPE
x_return_status OUT VARCHAR2
x_msg_count OUT NUMBER
x_msg_data OUT VARCHAR2

Procedure:

 General Tips for Running the Create Class Category API:
a) Save the API in a script file and then run the script from the SQL Prompt
(Example : RUN create_class_category.sql)
b)  Set the organization id before running the script as :
EXEC fnd_client_info.set_org_context(‘<orgid>’); for 11i
OR For R12
EXEC mo_global.init (‘AR’);
EXEC mo_global.set_org_context(<org_id>, NULL, ‘AR’);
EXEC fnd_global.set_nls_context(‘AMERICAN’);
EXEC mo_global.set_policy_context(‘S’, <org_id>);
c) Enter the values for the Parameters :
Class_Category
Allow_Multi_Parent_Flag
Allow_Multi_Assign_Flag
Allow_Leaf_Node_Flag
from the SQL Prompt.
The Value of the Parameter Class_Category must belong to a Lookup
Code YES/NO.
The Value for Parameter Allow_Multi_Parent_Flag must belong to a
Lookup Code YES/NO.
The Value for Parameter Allow_Leaf_Node_Flag must belong to a
Lookup Code YES/NO.

Example For Running Create Class Category API:

 Sample Output of the Create Class Category Script:
x_return_status = S
x_msg_count = 0
Class Category = ACCOUNT_CLASSES
Allow Multi Parent Flag = Y
x_msg_data =

Script To Verify whether the Create Class Category API is successful:

 

Related posts:

Leave a Reply