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.

[Home] [Help]

APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_CONTACTS_INT

Line 289: FROM HZ_IMP_CONTACTS_INT

285:
286: --//Cursor to select the child entities of contact entity
287: CURSOR get_contacts_rec(p_batch_id IN NUMBER) is
288: SELECT contact_orig_system, contact_orig_system_reference
289: FROM HZ_IMP_CONTACTS_INT
290: WHERE batch_id = p_batch_id
291: AND interface_status = 'R';
292:
293: l_last_fetch BOOLEAN;

Line 342: UPDATE HZ_IMP_CONTACTS_INT

338: AND result.entity = 'PARTY_SITES');
339:
340: ELSIF p_entity = 'CONTACTS' THEN
341: --Mark all the contact records to be removed
342: UPDATE HZ_IMP_CONTACTS_INT
343: SET interface_status = 'R'
344: WHERE batch_id = p_batch_id
345: AND( contact_orig_system,contact_orig_system_reference) in
346: ( select dup_record_os, dup_record_osr

Line 455: UPDATE HZ_IMP_CONTACTS_INT

451: AND WINNER_RECORD_OS = l_rec_os
452: AND WINNER_RECORD_OSR = l_rec_osr ) ;
453:
454: ELSIF p_entity = 'CONTACTS' THEN
455: UPDATE HZ_IMP_CONTACTS_INT
456: SET interface_status = 'R'
457: WHERE batch_id = p_batch_id
458: AND ( contact_orig_system,contact_orig_system_reference ) in
459: ( select dup_record_os, dup_record_osr

Line 539: UPDATE HZ_IMP_CONTACTS_INT

535: */
536: -- Doing this here is redundant as it will be done during p_entity = 'PARTY_SITES' call.
537: --Update contact records
538: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
539: UPDATE HZ_IMP_CONTACTS_INT
540: SET interface_status = 'R'
541: WHERE batch_id = p_batch_id
542: AND ((sub_orig_system = l_record_os(i)
543: AND sub_orig_system_reference = l_record_osr(i))

Line 1031: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||

1027:
1028: -- Choose the action to be performed on sites
1029:
1030: new_cont_sql := 'select int.contact_orig_system,int.contact_orig_system_reference '||
1031: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||
1032: 'where int.batch_id = :p_batch_id ' ||
1033: 'and int.batch_id = stage.batch_id '||
1034: 'and int.rowid= stage.int_row_id '||
1035: 'and int.dqm_action_flag IS NULL '||

Line 1039: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||

1035: 'and int.dqm_action_flag IS NULL '||
1036: 'AND stage.action_flag = ''I'' ';
1037:
1038: existing_cont_sql := 'select int.contact_orig_system,int.contact_orig_system_reference '||
1039: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||
1040: 'where int.batch_id = :p_batch_id '||
1041: 'and int.batch_id = stage.batch_id '||
1042: 'and int.rowid= stage.int_row_id '||
1043: 'AND stage.action_flag = ''U'' ';

Line 1046: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||

1042: 'and int.rowid= stage.int_row_id '||
1043: 'AND stage.action_flag = ''U'' ';
1044:
1045: pot_dup_cont_sql := 'select int.contact_orig_system,int.contact_orig_system_reference '||
1046: 'from hz_imp_contacts_int int, hz_imp_contacts_sg stage '||
1047: 'where int.batch_id = :p_batch_id '||
1048: 'and int.batch_id = stage.batch_id '||
1049: 'and int.rowid= stage.int_row_id '||
1050: 'and int.dqm_action_flag = ''P'' '||

Line 1651: TYPE L_DUP_OSContList is TABLE OF HZ_IMP_CONTACTS_INT.contact_orig_system%TYPE;

1647: TYPE L_DUP_OSSitesList is TABLE OF HZ_IMP_ADDRESSES_INT.site_orig_system%TYPE;
1648: l_dup_os_sites L_DUP_OSSitesList;
1649: TYPE L_DUP_OSRSitesList is TABLE OF HZ_IMP_ADDRESSES_INT.site_orig_system_reference%TYPE;
1650: l_dup_osr_sites L_DUP_OSRSitesList;
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;

Line 1653: TYPE L_DUP_OSRContList is TABLE OF HZ_IMP_CONTACTS_INT.contact_orig_system_reference%TYPE;

1649: TYPE L_DUP_OSRSitesList is TABLE OF HZ_IMP_ADDRESSES_INT.site_orig_system_reference%TYPE;
1650: l_dup_osr_sites L_DUP_OSRSitesList;
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;

Line 1819: UPDATE HZ_IMP_CONTACTS_INT

1815: EXIT;
1816: END IF;
1817:
1818: FORALL i in l_dup_osr_cont.FIRST..l_dup_osr_cont.LAST
1819: UPDATE HZ_IMP_CONTACTS_INT
1820: SET interface_status = NULL,dqm_action_flag = NULL
1821: WHERE batch_id = p_batch_id
1822: AND contact_orig_system = l_dup_os_cont(i)
1823: AND contact_orig_system_reference = l_dup_osr_cont(i)

Line 2316: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;

2312: TYPE L_SITE_ORIG_SYSList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
2313: l_site_orig_os L_SITE_ORIG_SYSList;
2314: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
2315: l_site_orig_osr L_SITE_ORIG_SYS_REFList;
2316: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
2317: l_cont_orig_os L_CONT_ORIG_SYSList;
2318: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
2319: l_cont_orig_osr L_CONT_ORIG_SYS_REFList;
2320:

Line 2318: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;

2314: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
2315: l_site_orig_osr L_SITE_ORIG_SYS_REFList;
2316: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
2317: l_cont_orig_os L_CONT_ORIG_SYSList;
2318: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
2319: l_cont_orig_osr L_CONT_ORIG_SYS_REFList;
2320:
2321: commit_counter NUMBER;
2322: l_last_fetch BOOLEAN;

Line 2452: UPDATE HZ_IMP_CONTACTS_INT

2448:
2449:
2450: -- Contacts
2451: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2452: UPDATE HZ_IMP_CONTACTS_INT
2453: SET interface_status = 'R'
2454: WHERE batch_id = p_batch_id
2455: AND (sub_orig_system = l_party_orig_os(i)
2456: AND sub_orig_system_reference = l_party_orig_osr(i))

Line 2625: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;

2621: x_return_status OUT NOCOPY VARCHAR2)
2622: IS
2623: sel_cont sel_cur;
2624:
2625: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
2626: l_cont_orig_os L_CONT_ORIG_SYSList;
2627: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
2628: l_cont_orig_osr L_CONT_ORIG_SYS_REFList;
2629:

Line 2627: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;

2623: sel_cont sel_cur;
2624:
2625: TYPE L_CONT_ORIG_SYSList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM%TYPE;
2626: l_cont_orig_os L_CONT_ORIG_SYSList;
2627: TYPE L_CONT_ORIG_SYS_REFList IS TABLE OF HZ_IMP_CONTACTS_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
2628: l_cont_orig_osr L_CONT_ORIG_SYS_REFList;
2629:
2630: commit_counter NUMBER;
2631: l_last_fetch BOOLEAN;

Line 2655: UPDATE HZ_IMP_CONTACTS_INT

2651: IF (p_action_new_contacts||p_action_existing_contacts||p_action_pot_dup_contacts='REMOVE')
2652: THEN
2653: FORALL i in l_cont_orig_osr.FIRST..l_cont_orig_osr.LAST
2654: --//Update contact interface table
2655: UPDATE HZ_IMP_CONTACTS_INT
2656: SET INTERFACE_STATUS = 'R', dqm_action_flag = NULL
2657: WHERE batch_id = p_batch_id
2658: AND contact_orig_system = l_cont_orig_os(i)
2659: AND contact_orig_system_reference = l_cont_orig_osr(i) ;

Line 2686: UPDATE HZ_IMP_CONTACTS_INT

2682: IF (p_action_pot_dup_contacts <> NULL and p_action_pot_dup_contacts = 'INSERT' )
2683: THEN
2684:
2685: FORALL i in l_cont_orig_osr.FIRST..l_cont_orig_osr.LAST
2686: UPDATE HZ_IMP_CONTACTS_INT
2687: SET dqm_action_flag = NULL
2688: WHERE batch_id = p_batch_id
2689: AND contact_orig_system = l_cont_orig_os(i)
2690: AND contact_orig_system_reference = l_cont_orig_osr(i) ;