APPS.ZX_PARTY_MERGE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 232: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

228: l_proc_name varchar2(30) := 'ZX_PARTY_TAX_PROFILE';
229: l_count number(10) := 0;
230: l_ptp_id_from NUMBER;
231: l_ptp_id_to NUMBER;
232: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
233:
234: cursor Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
235: select Party_Tax_Profile_id
236: from zx_party_tax_profile prof

Line 245: from hz_code_assignments

241: to_ptp_rec Party_Tax_Profile%ROWTYPE;
242:
243: cursor Class_Categories_From(p_ptp_id number) IS
244: select code_assignment_id, class_category, class_code, END_DATE_ACTIVE
245: from hz_code_assignments
246: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'
247: and owner_table_id = p_ptp_id
248: and NVL(END_DATE_ACTIVE,SYSDATE) >= sysdate;
249:

Line 251: p_class_category hz_code_assignments.class_category%type,

247: and owner_table_id = p_ptp_id
248: and NVL(END_DATE_ACTIVE,SYSDATE) >= sysdate;
249:
250: cursor Class_Codes_To(p_ptp_id number,
251: p_class_category hz_code_assignments.class_category%type,
252: p_end_date hz_code_assignments.end_date_active%type,
253: p_class_code hz_code_assignments.class_code%type) IS
254: select distinct class_category, class_code, END_DATE_ACTIVE
255: from hz_code_assignments

Line 252: p_end_date hz_code_assignments.end_date_active%type,

248: and NVL(END_DATE_ACTIVE,SYSDATE) >= sysdate;
249:
250: cursor Class_Codes_To(p_ptp_id number,
251: p_class_category hz_code_assignments.class_category%type,
252: p_end_date hz_code_assignments.end_date_active%type,
253: p_class_code hz_code_assignments.class_code%type) IS
254: select distinct class_category, class_code, END_DATE_ACTIVE
255: from hz_code_assignments
256: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'

Line 253: p_class_code hz_code_assignments.class_code%type) IS

249:
250: cursor Class_Codes_To(p_ptp_id number,
251: p_class_category hz_code_assignments.class_category%type,
252: p_end_date hz_code_assignments.end_date_active%type,
253: p_class_code hz_code_assignments.class_code%type) IS
254: select distinct class_category, class_code, END_DATE_ACTIVE
255: from hz_code_assignments
256: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'
257: and owner_table_id = p_ptp_id

Line 255: from hz_code_assignments

251: p_class_category hz_code_assignments.class_category%type,
252: p_end_date hz_code_assignments.end_date_active%type,
253: p_class_code hz_code_assignments.class_code%type) IS
254: select distinct class_category, class_code, END_DATE_ACTIVE
255: from hz_code_assignments
256: where owner_table_name = 'ZX_PARTY_TAX_PROFILE'
257: and owner_table_id = p_ptp_id
258: and NVL(END_DATE_ACTIVE,SYSDATE) >= NVL(p_end_date,SYSDATE)
259: and class_category = p_class_category

Line 332: update hz_code_assignments

328: FETCH Class_Codes_To INTO Class_Codes_To_Rec.Class_Category,
329: Class_Codes_To_Rec.class_code,
330: Class_Codes_To_Rec.END_DATE_ACTIVE;
331: IF Class_Codes_To%NOTFOUND THEN
332: update hz_code_assignments
333: set owner_table_id = l_ptp_id_to,
334: last_update_date = sysdate,
335: last_updated_by = g_user_id,
336: last_update_login = g_login_id,

Line 653: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

649: l_ptp_id_from NUMBER;
650: l_ptp_id_to NUMBER;
651: l_calculate_tax_from VARCHAR2(1);
652: l_calculate_tax_to VARCHAR2(1);
653: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
654: l_hash_key BINARY_INTEGER;
655:
656: l_reg_attr_tbl_from reg_attr_tbl_type;
657: l_reg_attr_tbl_to reg_attr_tbl_type;

Line 782: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

778: l_proc_name varchar2(30) := 'ZX_MERGE';
779: l_count number(10) := 0;
780: l_ptp_id_from NUMBER;
781: l_ptp_id_to NUMBER;
782: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
783: l_party_type_from VARCHAR2(30);
784: l_party_type_to VARCHAR2(30);
785: l_merge_yn VARCHAR2(1);
786: