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_PARTIES_INT

Line 274: FROM HZ_IMP_PARTIES_INT

270:
271: --// Cursor to select the child entities of Party entity
272: CURSOR get_party_rec(p_batch_id IN NUMBER) is
273: SELECT party_orig_system, party_orig_system_reference
274: FROM HZ_IMP_PARTIES_INT
275: WHERE batch_id = p_batch_id
276: AND interface_status = 'R'
277: ;
278:

Line 316: UPDATE HZ_IMP_PARTIES_INT

312:
313: if p_action_on_entity = 'REMOVE_ALL' THEN
314: IF p_entity = 'PARTY' THEN
315: --Mark all the records to be removed
316: UPDATE HZ_IMP_PARTIES_INT
317: SET interface_status = 'R'
318: WHERE batch_id = p_batch_id
319: AND( party_orig_system, party_orig_system_reference ) in
320: ( select dup_record_os, dup_record_osr

Line 429: UPDATE HZ_IMP_PARTIES_INT party

425: --Remove the duplicate records
426: --Hz_parties
427: IF p_entity = 'PARTY' THEN
428:
429: UPDATE HZ_IMP_PARTIES_INT party
430: SET INTERFACE_STATUS = 'R'
431: WHERE batch_id = p_batch_id
432: AND( party_orig_system, party_orig_system_reference ) in
433: ( select dup_record_os, dup_record_osr

Line 830: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||

826:
827: -- Choose the action to be performed
828:
829: new_party_sql := 'select int.party_id,int.party_orig_system,int.party_orig_system_reference '||
830: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||
831: 'where int.batch_id = :p_batch_id ' ||
832: 'and int.batch_id = stage.batch_id '||
833: 'and int.rowid = stage.int_row_id '||
834: 'and int.dqm_action_flag IS NULL '||

Line 838: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||

834: 'and int.dqm_action_flag IS NULL '||
835: 'AND stage.action_flag = ''I'' ';
836:
837: existing_party_sql := 'select int.party_id,int.party_orig_system,int.party_orig_system_reference '||
838: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||
839: 'where int.batch_id = :p_batch_id '||
840: 'and int.batch_id = stage.batch_id '||
841: 'and int.rowid = stage.int_row_id '||
842: 'AND stage.action_flag = ''U'' ';

Line 845: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||

841: 'and int.rowid = stage.int_row_id '||
842: 'AND stage.action_flag = ''U'' ';
843:
844: dup_party_sql := 'select int.party_id,int.party_orig_system,int.party_orig_system_reference '||
845: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||
846: 'where int.batch_id = :p_batch_id '||
847: 'and int.batch_id = stage.batch_id '||
848: 'and int.rowid = stage.int_row_id '||
849: 'and int.dqm_action_flag = ''D'' ' ||

Line 853: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||

849: 'and int.dqm_action_flag = ''D'' ' ||
850: 'AND stage.action_flag = ''I'' ';
851:
852: pot_dup_party_sql := 'select int.party_id,int.party_orig_system,int.party_orig_system_reference '||
853: 'from hz_imp_parties_int int, hz_imp_parties_sg stage '||
854: 'where int.batch_id = :p_batch_id '||
855: 'and int.batch_id = stage.batch_id '||
856: 'and int.rowid = stage.int_row_id '||
857: 'and int.dqm_action_flag = ''P'' '||

Line 1643: TYPE L_DUP_OSPartyList is TABLE OF HZ_IMP_PARTIES_INT.party_orig_system%TYPE;

1639: WHERE batch_id= p_batch_id
1640: AND entity= p_entity
1641: ;
1642:
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;

Line 1645: TYPE L_DUP_OSRPartyList is TABLE OF HZ_IMP_PARTIES_INT.party_orig_system_reference%TYPE;

1641: ;
1642:
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;

Line 1699: UPDATE HZ_IMP_PARTIES_INT

1695: END IF;
1696:
1697:
1698: FORALL i in l_dup_osr_party.FIRST..l_dup_osr_party.LAST
1699: UPDATE HZ_IMP_PARTIES_INT
1700: SET interface_status = NULL,dqm_action_flag = NULL
1701: WHERE batch_id = p_batch_id
1702: AND party_orig_system = l_dup_os_party(i)
1703: AND party_orig_system_reference = l_dup_osr_party(i)

Line 2305: TYPE L_PARTY_ORIG_SYSList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;

2301: x_return_status OUT NOCOPY VARCHAR2)
2302: IS
2303: sel_parties sel_cur;
2304:
2305: TYPE L_PARTY_ORIG_SYSList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
2306: l_party_orig_os L_PARTY_ORIG_SYSList;
2307: TYPE L_PARTY_ORIG_SYS_REFList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%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;

Line 2307: TYPE L_PARTY_ORIG_SYS_REFList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;

2303: sel_parties sel_cur;
2304:
2305: TYPE L_PARTY_ORIG_SYSList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
2306: l_party_orig_os L_PARTY_ORIG_SYSList;
2307: TYPE L_PARTY_ORIG_SYS_REFList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%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:

Line 2309: TYPE L_PARTY_IDList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ID%TYPE;

2305: TYPE L_PARTY_ORIG_SYSList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM%TYPE;
2306: l_party_orig_os L_PARTY_ORIG_SYSList;
2307: TYPE L_PARTY_ORIG_SYS_REFList IS TABLE OF HZ_IMP_PARTIES_INT.PARTY_ORIG_SYSTEM_REFERENCE%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;

Line 2348: UPDATE HZ_IMP_PARTIES_INT party

2344: THEN
2345: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2346:
2347: --//Update parties interface table
2348: UPDATE HZ_IMP_PARTIES_INT party
2349: SET INTERFACE_STATUS = 'R', dqm_action_flag = NULL
2350: WHERE batch_id = p_batch_id
2351: AND ((party_id IS NULL and l_party_id(i) IS NULL)
2352: OR (party_id IS NOT NULL and l_party_id(i) IS NOT NULL and party_id=l_party_id(i)))

Line 2480: UPDATE HZ_IMP_PARTIES_INT

2476: )
2477: THEN
2478:
2479: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2480: UPDATE HZ_IMP_PARTIES_INT
2481: SET dqm_action_flag = NULL
2482: WHERE batch_id = p_batch_id
2483: AND party_id = l_party_id(i)
2484: AND party_orig_system = l_party_orig_os(i)

Line 2491: UPDATE HZ_IMP_PARTIES_INT

2487: ELSIF (p_action_dup_parties <> NULL and p_action_dup_parties = 'REQUEST_MERGE' )
2488: THEN
2489:
2490: FORALL i in l_party_orig_osr.FIRST..l_party_orig_osr.LAST
2491: UPDATE HZ_IMP_PARTIES_INT
2492: SET dqm_action_flag = 'P'
2493: WHERE batch_id = p_batch_id
2494: AND party_id = l_party_id(i)
2495: AND party_orig_system = l_party_orig_os(i)