eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_PARTY_MERGE_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 209: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

205: -- Enter the procedure variables here. As shown below
206: l_count number(10) := 0;
207: l_ptp_id_from NUMBER;
208: l_ptp_id_to NUMBER;
209: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
210:
211: CURSOR Party_Tax_Profile(p_fk_id hz_merge_parties.from_party_id%type) IS
212: SELECT Party_Tax_Profile_id
213: FROM zx_party_tax_profile prof

Line 222: FROM hz_code_assignments

218: to_ptp_rec Party_Tax_Profile%ROWTYPE;
219:
220: CURSOR Class_Categories_From(p_ptp_id number) IS
221: SELECT code_assignment_id, class_category, class_code, END_DATE_ACTIVE
222: FROM hz_code_assignments
223: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
224: AND owner_table_id = p_ptp_id
225: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
226:

Line 228: p_class_category hz_code_assignments.class_category%type,

224: AND owner_table_id = p_ptp_id
225: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
226:
227: CURSOR Class_Codes_To (p_ptp_id number,
228: p_class_category hz_code_assignments.class_category%type,
229: p_end_date hz_code_assignments.end_date_active%type,
230: p_class_code hz_code_assignments.class_code%type) IS
231: SELECT DISTINCT class_category, class_code, END_DATE_ACTIVE
232: FROM hz_code_assignments

Line 229: p_end_date hz_code_assignments.end_date_active%type,

225: AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;
226:
227: CURSOR Class_Codes_To (p_ptp_id number,
228: p_class_category hz_code_assignments.class_category%type,
229: p_end_date hz_code_assignments.end_date_active%type,
230: p_class_code hz_code_assignments.class_code%type) IS
231: SELECT DISTINCT class_category, class_code, END_DATE_ACTIVE
232: FROM hz_code_assignments
233: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'

Line 230: p_class_code hz_code_assignments.class_code%type) IS

226:
227: CURSOR Class_Codes_To (p_ptp_id number,
228: p_class_category hz_code_assignments.class_category%type,
229: p_end_date hz_code_assignments.end_date_active%type,
230: p_class_code hz_code_assignments.class_code%type) IS
231: SELECT DISTINCT class_category, class_code, END_DATE_ACTIVE
232: FROM hz_code_assignments
233: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
234: AND owner_table_id = p_ptp_id

Line 232: FROM hz_code_assignments

228: p_class_category hz_code_assignments.class_category%type,
229: p_end_date hz_code_assignments.end_date_active%type,
230: p_class_code hz_code_assignments.class_code%type) IS
231: SELECT DISTINCT class_category, class_code, END_DATE_ACTIVE
232: FROM hz_code_assignments
233: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
234: AND owner_table_id = p_ptp_id
235: AND NVL(END_DATE_ACTIVE,SYSDATE) >= NVL(p_end_date,SYSDATE)
236: AND class_category = p_class_category

Line 306: UPDATE hz_code_assignments

302: FETCH Class_Codes_To INTO Class_Codes_To_Rec.Class_Category,
303: Class_Codes_To_Rec.class_code,
304: Class_Codes_To_Rec.END_DATE_ACTIVE;
305: IF Class_Codes_To%NOTFOUND THEN
306: UPDATE hz_code_assignments
307: set owner_table_id = l_ptp_id_to,
308: last_update_date = SYSDATE,
309: last_updated_by = G_USER_ID,
310: last_update_login = G_LOGIN_ID,

Line 658: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

654: l_ptp_id_from NUMBER;
655: l_ptp_id_to NUMBER;
656: l_calculate_tax_from VARCHAR2(1);
657: l_calculate_tax_to VARCHAR2(1);
658: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
659: -- l_hash_key BINARY_INTEGER;
660:
661: -- l_reg_attr_tbl_from reg_attr_tbl_type;
662: -- l_reg_attr_tbl_to reg_attr_tbl_type;

Line 866: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;

862: IS
863: -- Enter the procedure variables here. As shown below
864: l_ptp_id_from NUMBER;
865: l_ptp_id_to NUMBER;
866: l_code_assignment_id hz_code_assignments.owner_table_name%TYPE;
867: l_party_type_from VARCHAR2(30);
868: l_party_type_to VARCHAR2(30);
869: l_merge_yn VARCHAR2(1);
870: