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.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_CONTACTPTS_INT

Line 355: UPDATE HZ_IMP_CONTACTPTS_INT

351: AND result.entity = 'CONTACTS');
352:
353: ELSIF p_entity = 'CONTACT_POINTS' THEN
354: --Mark all the contact point records to be removed
355: UPDATE HZ_IMP_CONTACTPTS_INT
356: SET interface_status = 'R'
357: WHERE batch_id = p_batch_id
358: AND(cp_orig_system ,cp_orig_system_reference) in
359: ( select dup_record_os, dup_record_osr

Line 468: UPDATE HZ_IMP_CONTACTPTS_INT

464: AND WINNER_RECORD_OS = l_rec_os
465: AND WINNER_RECORD_OSR = l_rec_osr ) ;
466:
467: ELSIF p_entity = 'CONTACT_POINTS' THEN
468: UPDATE HZ_IMP_CONTACTPTS_INT
469: SET interface_status = 'R'
470: WHERE batch_id = p_batch_id
471: AND ( cp_orig_system, cp_orig_system_reference ) in
472: ( select dup_record_os, dup_record_osr

Line 552: UPDATE HZ_IMP_CONTACTPTS_INT

548: -- Update contact roles
549: -- Doing this here is redundant as it will be done during p_entity = 'CONTACTS' call.
550: -- Update contact point records
551: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
552: UPDATE HZ_IMP_CONTACTPTS_INT
553: SET interface_status = 'R'
554: WHERE batch_id = p_batch_id
555: AND party_orig_system = l_record_os(i)
556: AND party_orig_system_reference = l_record_osr(i);

Line 1125: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||

1121:
1122: -- Choose the action to be performed on sites
1123:
1124: new_cpts_sql := 'select int.cp_orig_system,int.cp_orig_system_reference '||
1125: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||
1126: 'where int.batch_id = :p_batch_id ' ||
1127: 'and int.batch_id = stage.batch_id '||
1128: 'and int.rowid = stage.int_row_id '||
1129: 'and int.dqm_action_flag IS NULL '||

Line 1133: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||

1129: 'and int.dqm_action_flag IS NULL '||
1130: 'AND stage.action_flag = ''I'' ';
1131:
1132: existing_cpts_sql := 'select int.cp_orig_system,int.cp_orig_system_reference '||
1133: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||
1134: 'where int.batch_id = :p_batch_id '||
1135: 'and int.batch_id = stage.batch_id '||
1136: 'and int.rowid = stage.int_row_id '||
1137: 'AND stage.action_flag = ''U'' ';

Line 1140: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||

1136: 'and int.rowid = stage.int_row_id '||
1137: 'AND stage.action_flag = ''U'' ';
1138:
1139: pot_dup_cpts_sql := 'select int.cp_orig_system,int.cp_orig_system_reference '||
1140: 'from hz_imp_contactpts_int int, hz_imp_contactpts_sg stage '||
1141: 'where int.batch_id = :p_batch_id '||
1142: 'and int.batch_id = stage.batch_id '||
1143: 'and int.rowid = stage.int_row_id '||
1144: 'and int.dqm_action_flag = ''P'' '||

Line 1655: TYPE L_DUP_OSCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system%TYPE;

1651: TYPE L_DUP_OSContList is TABLE OF HZ_IMP_CONTACTS_INT.contact_orig_system%TYPE;
1652: l_dup_os_cont L_DUP_OSContList;
1653: TYPE L_DUP_OSRContList is TABLE OF HZ_IMP_CONTACTS_INT.contact_orig_system_reference%TYPE;
1654: l_dup_osr_cont L_DUP_OSRContList;
1655: TYPE L_DUP_OSCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system%TYPE;
1656: l_dup_os_cp L_DUP_OSCptsList;
1657: TYPE L_DUP_OSRCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system_reference%TYPE;
1658: l_dup_osr_cp L_DUP_OSRCptsList;
1659:

Line 1657: TYPE L_DUP_OSRCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system_reference%TYPE;

1653: TYPE L_DUP_OSRContList is TABLE OF HZ_IMP_CONTACTS_INT.contact_orig_system_reference%TYPE;
1654: l_dup_osr_cont L_DUP_OSRContList;
1655: TYPE L_DUP_OSCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system%TYPE;
1656: l_dup_os_cp L_DUP_OSCptsList;
1657: TYPE L_DUP_OSRCptsList is TABLE OF HZ_IMP_CONTACTPTS_INT.cp_orig_system_reference%TYPE;
1658: l_dup_osr_cp L_DUP_OSRCptsList;
1659:
1660: l_last_fetch BOOLEAN;
1661: commit_counter NUMBER;

Line 1866: UPDATE HZ_IMP_CONTACTPTS_INT

1862: EXIT;
1863: END IF;
1864:
1865: FORALL i in l_dup_osr_cp.FIRST..l_dup_osr_cp.LAST
1866: UPDATE HZ_IMP_CONTACTPTS_INT
1867: SET interface_status = NULL,dqm_action_flag = NULL
1868: WHERE batch_id = p_batch_id
1869: AND cp_orig_system = l_dup_os_cp(i)
1870: AND cp_orig_system_reference = l_dup_osr_cp(i)

Line 2431: UPDATE HZ_IMP_CONTACTPTS_INT

2427:
2428: -- Contact points
2429:
2430: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2431: UPDATE HZ_IMP_CONTACTPTS_INT
2432: SET interface_status = 'R'
2433: WHERE batch_id = p_batch_id
2434: AND party_orig_system = l_party_orig_os(i)
2435: AND party_orig_system_reference = l_party_orig_osr(i) ;

Line 2718: TYPE L_CPTS_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;

2714: x_return_status OUT NOCOPY VARCHAR2)
2715: IS
2716: sel_cpts sel_cur;
2717:
2718: TYPE L_CPTS_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
2719: l_cpts_orig_os L_CPTS_ORIG_SYSList;
2720: TYPE L_CPTS_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
2721: l_cpts_orig_osr L_CPTS_ORIG_SYS_REFList;
2722:

Line 2720: TYPE L_CPTS_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;

2716: sel_cpts sel_cur;
2717:
2718: TYPE L_CPTS_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM%TYPE;
2719: l_cpts_orig_os L_CPTS_ORIG_SYSList;
2720: TYPE L_CPTS_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTPTS_INT.CP_ORIG_SYSTEM_REFERENCE%TYPE;
2721: l_cpts_orig_osr L_CPTS_ORIG_SYS_REFList;
2722:
2723: commit_counter NUMBER;
2724: l_last_fetch BOOLEAN;

Line 2748: UPDATE HZ_IMP_CONTACTPTS_INT

2744: IF (p_action_new_cpts||p_action_existing_cpts||p_action_pot_dup_cpts='REMOVE')
2745: THEN
2746: FORALL i in l_cpts_orig_osr.FIRST..l_cpts_orig_osr.LAST
2747: --//Update contact points interface table
2748: UPDATE HZ_IMP_CONTACTPTS_INT
2749: SET INTERFACE_STATUS = 'R', dqm_action_flag = NULL
2750: WHERE batch_id = p_batch_id
2751: AND cp_orig_system = l_cpts_orig_os(i)
2752: AND cp_orig_system_reference = l_cpts_orig_osr(i) ;

Line 2771: UPDATE HZ_IMP_CONTACTPTS_INT

2767: IF (p_action_pot_dup_cpts <> NULL and p_action_pot_dup_cpts = 'INSERT' )
2768: THEN
2769:
2770: FORALL i in l_cpts_orig_osr.FIRST..l_cpts_orig_osr.LAST
2771: UPDATE HZ_IMP_CONTACTPTS_INT
2772: SET dqm_action_flag = NULL
2773: WHERE batch_id = p_batch_id
2774: AND cp_orig_system = l_cpts_orig_os(i)
2775: AND cp_orig_system_reference = l_cpts_orig_osr(i) ;