18: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
19: p_tca_class IN VARCHAR2);
20:
21: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
22: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
23: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
24: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
25: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
26: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE);
19: p_tca_class IN VARCHAR2);
20:
21: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
22: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
23: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
24: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
25: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
26: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE);
27:
21: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
22: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
23: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
24: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
25: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
26: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE);
27:
28:
29: PROCEDURE CREATE_MTL_CATEGORIES (l_lookup_type IN VARCHAR2,
22: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
23: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
24: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
25: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
26: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE);
27:
28:
29: PROCEDURE CREATE_MTL_CATEGORIES (l_lookup_type IN VARCHAR2,
30: l_category_name IN VARCHAR2,
55: );
56:
57: -- Bug# 5106298. This procedure is called from zxcfctbc.lct file
58: PROCEDURE FC_CODE_GDF_INSERT(
59: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
60: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
61: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
62: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
63: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
57: -- Bug# 5106298. This procedure is called from zxcfctbc.lct file
58: PROCEDURE FC_CODE_GDF_INSERT(
59: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
60: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
61: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
62: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
63: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
64: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
65: );
60: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
61: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
62: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
63: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
64: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
65: );
66:
67:
68: /*THIS PROECEDURE IS USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
66:
67:
68: /*THIS PROECEDURE IS USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
69: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
70: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
71: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
72: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
73: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
74: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
68: /*THIS PROECEDURE IS USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
69: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
70: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
71: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
72: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
73: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
74: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
75: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
76: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE
69: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
70: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
71: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
72: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
73: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
74: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
75: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
76: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE
77: );