APPS.ZX_TCM_CONTROL_PKG dependencies on ZX_FC_TYPES_B

Line 42: l_table_owner zx_fc_types_b.Owner_Table_Code%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;
42: l_table_owner zx_fc_types_b.Owner_Table_Code%type;
43: l_table_id zx_fc_types_b.owner_id_char%type;
44: l_class_code fnd_lookup_values.lookup_code%type;
45: l_classification_type_code zx_fc_types_b.classification_type_code%type;
46: l_effective_from date;

Line 43: l_table_id zx_fc_types_b.owner_id_char%type;

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;
42: l_table_owner zx_fc_types_b.Owner_Table_Code%type;
43: l_table_id zx_fc_types_b.owner_id_char%type;
44: l_class_code fnd_lookup_values.lookup_code%type;
45: l_classification_type_code zx_fc_types_b.classification_type_code%type;
46: l_effective_from date;
47: l_effective_to date;

Line 45: l_classification_type_code zx_fc_types_b.classification_type_code%type;

41: l_party_id zx_party_tax_profile.party_id%type;
42: l_table_owner zx_fc_types_b.Owner_Table_Code%type;
43: l_table_id zx_fc_types_b.owner_id_char%type;
44: l_class_code fnd_lookup_values.lookup_code%type;
45: l_classification_type_code zx_fc_types_b.classification_type_code%type;
46: l_effective_from date;
47: l_effective_to date;
48: l_Party_Type_Code zx_party_tax_profile.Party_Type_Code%type;
49: l_le_status varchar2(30);

Line 87: from zx_fc_types_b

83: /* Cursors for Inventory Categories related */
84: -- get category set id
85: cursor c_inventory_set is
86: Select owner_id_num
87: from zx_fc_types_b
88: where classification_type_code = p_fsc_rec.classification_type;
89:
90: -- get structure id for the category set
91: cursor c_inventory_structure is

Line 129: from zx_fc_types_b

125: select mtl.category_id
126: from mtl_categories_b_kfv mtl,
127: fnd_id_flex_structures flex,
128: ( select start_position, num_characters
129: from zx_fc_types_b
130: where classification_type_code = p_fsc_rec.classification_type) fc
131: where mtl.structure_id = l_structure_id
132: and flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
133: and flex.APPLICATION_ID = 401

Line 143: from zx_fc_types_b

139:
140: -- get TCA Class Category id
141: cursor c_tca_class_category is
142: Select owner_id_char
143: from zx_fc_types_b
144: where classification_type_code = p_fsc_rec.classification_type;
145:
146: cursor c_party_tax_profile_id is
147: Select party_id ,Party_Type_Code

Line 196: from zx_fc_types_b

192:
193: -- Cursors used for Transaction Fiscal Classification
194: cursor c_classification_type_code is
195: Select classification_type_code
196: from zx_fc_types_b
197: where classification_type_code = p_fsc_rec.classification_type;
198:
199: /*
200: Cursor c_trxbizcat_fiscalclass is

Line 214: zx_fc_types_b fctypes,

210:
211: Cursor c_trxbizcat_fiscalclass is
212: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
213: from zx_fc_codes_categ_assoc assoc,
214: zx_fc_types_b fctypes,
215: zx_fc_codes_denorm_b denorm
216: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
217: and fctypes.classification_type_code = p_fsc_rec.classification_type
218: and assoc.Classification_Code_Concat = p_fsc_rec.condition_value

Line 242: zx_fc_types_b fctypes,

238:
239: Cursor c_parent_trxbizcat_fiscalclass is
240: select 'ALLOCATED',assoc.effective_from, assoc.effective_to
241: from zx_fc_codes_categ_assoc assoc,
242: zx_fc_types_b fctypes,
243: zx_fc_codes_denorm_b denorm
244: where assoc.classification_type_code = nvl(fctypes.owner_id_char,p_fsc_rec.classification_type)
245: and fctypes.classification_type_code = p_fsc_rec.classification_type
246: and assoc.Classification_Code_Concat = p_fsc_rec.condition_value

Line 1254: from zx_fc_types_b

1250: and p_fsc_cat_rec.tax_determine_date between effective_from and nvl(effective_to, p_fsc_cat_rec.tax_determine_date);
1251:
1252: cursor c_delimiter is
1253: select delimiter
1254: from zx_fc_types_b
1255: where Classification_Type_Categ_Code = p_fsc_cat_rec.classification_category
1256: and classification_type_code = p_fsc_cat_rec.classification_type;
1257:
1258: l_Classification_Code zx_fc_codes_b.Classification_Code%type;

Line 1267: l_delimiter zx_fc_types_b.delimiter%type;

1263: l_segment5 Zx_Fc_Codes_Denorm_B.segment1%type;
1264: l_effective_from date;
1265: l_effective_to date;
1266: l_classification_code_level Zx_Fc_Codes_Denorm_B.classification_code_level%type;
1267: l_delimiter zx_fc_types_b.delimiter%type;
1268: l_unconcatenated_code Zx_Fc_Codes_Denorm_B.concat_classif_code%type;
1269:
1270: -- Logging Infra
1271: l_procedure_name CONSTANT VARCHAR2(30) := 'get_prod_trx_cate_value';