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_ADDRESSES_INT

Line 282: FROM HZ_IMP_ADDRESSES_INT

278:
279: --//Cursor to select the child entities of Site entity
280: CURSOR get_site_rec(p_batch_id IN NUMBER) is
281: SELECT site_orig_system, site_orig_system_reference
282: FROM HZ_IMP_ADDRESSES_INT
283: WHERE batch_id = p_batch_id
284: AND interface_status = 'R';
285:
286: --//Cursor to select the child entities of contact entity

Line 329: UPDATE HZ_IMP_ADDRESSES_INT

325: AND result.entity = 'PARTY');
326:
327: ELSIF p_entity = 'PARTY_SITES' THEN
328: --Mark all the site records to be removed
329: UPDATE HZ_IMP_ADDRESSES_INT
330: SET interface_status = 'R'
331: WHERE batch_id = p_batch_id
332: AND( site_orig_system, site_orig_system_reference ) in
333: ( select dup_record_os, dup_record_osr

Line 442: UPDATE HZ_IMP_ADDRESSES_INT

438: AND WINNER_RECORD_OS = l_rec_os
439: AND WINNER_RECORD_OSR = l_rec_osr );
440:
441: ELSIF p_entity = 'PARTY_SITES' THEN
442: UPDATE HZ_IMP_ADDRESSES_INT
443: SET INTERFACE_STATUS = 'R'
444: WHERE batch_id = p_batch_id
445: AND( site_orig_system, site_orig_system_reference ) in
446: ( select dup_record_os, dup_record_osr

Line 522: UPDATE HZ_IMP_ADDRESSES_INT

518:
519: -- Start of Bug No: 3770319
520: --Update site records
521: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
522: UPDATE HZ_IMP_ADDRESSES_INT
523: SET interface_status = 'R'
524: WHERE batch_id = p_batch_id
525: AND party_orig_system = l_record_os(i)
526: AND party_orig_system_reference = l_record_osr(i);

Line 937: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||

933:
934: -- Choose the action to be performed on sites
935:
936: new_site_sql := 'select int.site_orig_system,int.site_orig_system_reference '||
937: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||
938: 'where int.batch_id = :p_batch_id ' ||
939: 'and int.batch_id = stage.batch_id '||
940: 'and int.rowid = stage.int_row_id '||
941: 'and int.dqm_action_flag IS NULL '||

Line 945: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||

941: 'and int.dqm_action_flag IS NULL '||
942: 'AND stage.action_flag = ''I'' ';
943:
944: existing_site_sql := 'select int.site_orig_system,int.site_orig_system_reference '||
945: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||
946: 'where int.batch_id = :p_batch_id '||
947: 'and int.batch_id = stage.batch_id '||
948: 'and int.rowid = stage.int_row_id '||
949: 'AND stage.action_flag = ''U'' ';

Line 952: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||

948: 'and int.rowid = stage.int_row_id '||
949: 'AND stage.action_flag = ''U'' ';
950:
951: pot_dup_site_sql := 'select int.site_orig_system,int.site_orig_system_reference '||
952: 'from hz_imp_addresses_int int, hz_imp_addresses_sg stage '||
953: 'where int.batch_id = :p_batch_id '||
954: 'and int.batch_id = stage.batch_id '||
955: 'and int.rowid = stage.int_row_id '||
956: 'and int.dqm_action_flag = ''P'' '||

Line 1647: TYPE L_DUP_OSSitesList is TABLE OF HZ_IMP_ADDRESSES_INT.site_orig_system%TYPE;

1643: TYPE L_DUP_OSPartyList is TABLE OF HZ_IMP_PARTIES_INT.party_orig_system%TYPE;
1644: l_dup_os_party L_DUP_OSPartyList;
1645: TYPE L_DUP_OSRPartyList is TABLE OF HZ_IMP_PARTIES_INT.party_orig_system_reference%TYPE;
1646: l_dup_osr_party L_DUP_OSRPartyList ;
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;

Line 1649: TYPE L_DUP_OSRSitesList is TABLE OF HZ_IMP_ADDRESSES_INT.site_orig_system_reference%TYPE;

1645: TYPE L_DUP_OSRPartyList is TABLE OF HZ_IMP_PARTIES_INT.party_orig_system_reference%TYPE;
1646: l_dup_osr_party L_DUP_OSRPartyList ;
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;

Line 1772: UPDATE HZ_IMP_ADDRESSES_INT

1768: EXIT;
1769: END IF;
1770:
1771: FORALL i in l_dup_osr_sites.FIRST..l_dup_osr_sites.LAST
1772: UPDATE HZ_IMP_ADDRESSES_INT
1773: SET interface_status = NULL,dqm_action_flag = NULL
1774: WHERE batch_id = p_batch_id
1775: AND site_orig_system = l_dup_os_sites(i)
1776: AND site_orig_system_reference = l_dup_osr_sites(i)

Line 2312: TYPE L_SITE_ORIG_SYSList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;

2308: l_party_orig_osr L_PARTY_ORIG_SYS_REFList;
2309: TYPE L_PARTY_IDList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ID%TYPE;
2310: l_party_id L_PARTY_IDList;
2311:
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;

Line 2314: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;

2310: l_party_id L_PARTY_IDList;
2311:
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;

Line 2413: UPDATE HZ_IMP_ADDRESSES_INT

2409:
2410: -- Addresses
2411:
2412: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2413: UPDATE HZ_IMP_ADDRESSES_INT
2414: SET interface_status = 'R'
2415: WHERE batch_id = p_batch_id
2416: AND party_orig_system = l_party_orig_os(i)
2417: AND party_orig_system_reference = l_party_orig_osr(i)

Line 2532: TYPE L_SITE_ORIG_SYSList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;

2528: x_return_status OUT NOCOPY VARCHAR2)
2529: IS
2530: sel_addrs sel_cur;
2531:
2532: TYPE L_SITE_ORIG_SYSList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
2533: l_site_orig_os L_SITE_ORIG_SYSList;
2534: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
2535: l_site_orig_osr L_SITE_ORIG_SYS_REFList;
2536:

Line 2534: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;

2530: sel_addrs sel_cur;
2531:
2532: TYPE L_SITE_ORIG_SYSList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM%TYPE;
2533: l_site_orig_os L_SITE_ORIG_SYSList;
2534: TYPE L_SITE_ORIG_SYS_REFList IS TABLE OF HZ_IMP_ADDRESSES_INT.SITE_ORIG_SYSTEM_REFERENCE%TYPE;
2535: l_site_orig_osr L_SITE_ORIG_SYS_REFList;
2536:
2537: commit_counter NUMBER;
2538: l_last_fetch BOOLEAN;

Line 2562: UPDATE HZ_IMP_ADDRESSES_INT

2558: IF (p_action_new_addrs||p_action_existing_addrs||p_action_pot_dup_addrs='REMOVE')
2559: THEN
2560: FORALL i in l_site_orig_osr.FIRST..l_site_orig_osr.LAST
2561: --//Update addresses interface table
2562: UPDATE HZ_IMP_ADDRESSES_INT
2563: SET INTERFACE_STATUS = 'R', dqm_action_flag = NULL
2564: WHERE batch_id = p_batch_id
2565: AND site_orig_system = l_site_orig_os(i)
2566: AND site_orig_system_reference = l_site_orig_osr(i) ;

Line 2593: UPDATE HZ_IMP_ADDRESSES_INT

2589: IF (p_action_pot_dup_addrs <> NULL and p_action_pot_dup_addrs = 'INSERT' )
2590: THEN
2591:
2592: FORALL i in l_site_orig_osr.FIRST..l_site_orig_osr.LAST
2593: UPDATE HZ_IMP_ADDRESSES_INT
2594: SET dqm_action_flag = NULL
2595: WHERE batch_id = p_batch_id
2596: AND site_orig_system = l_site_orig_os(i)
2597: AND site_orig_system_reference = l_site_orig_osr(i) ;