APPS.ZX_TCM_CONTROL_PKG dependencies on MTL_CATEGORY_SETS_B

Line 35: l_category_set_id mtl_category_sets_b.category_set_id%type;

31: l_status varchar2(1);
32: l_db_status varchar2(1);
33: l_reg_fscType_flag varchar2(1);
34: l_inventory_set varchar2(1);
35: l_category_set_id mtl_category_sets_b.category_set_id%type;
36: l_category_id mtl_categories_b.category_id%type;
37: l_structure_id mtl_category_sets_b.structure_id%type;
38: l_allocated_flag varchar2(15);
39: l_tca_class_category_code hz_class_categories.class_category%type;

Line 37: l_structure_id mtl_category_sets_b.structure_id%type;

33: l_reg_fscType_flag varchar2(1);
34: l_inventory_set varchar2(1);
35: l_category_set_id mtl_category_sets_b.category_set_id%type;
36: l_category_id mtl_categories_b.category_id%type;
37: l_structure_id mtl_category_sets_b.structure_id%type;
38: l_allocated_flag varchar2(15);
39: l_tca_class_category_code hz_class_categories.class_category%type;
40: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
41: l_party_id zx_party_tax_profile.party_id%type;

Line 93: from mtl_category_sets_b

89:
90: -- get structure id for the category set
91: cursor c_inventory_structure is
92: select structure_id
93: from mtl_category_sets_b
94: where category_set_id = l_category_set_id;
95:
96: -- get the category id for the category code
97: cursor c_category is

Line 2735: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

2731: PROCEDURE INITIALIZE_LTE (p_return_status OUT NOCOPY VARCHAR2) IS
2732:
2733: l_procedure_name CONSTANT VARCHAR2(30) := 'Initialize LTE';
2734: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2735: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
2736: l_fc_id ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE;
2737:
2738: BEGIN
2739: -- Logging Infra: Setting up runtime level