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_STAGE_MAP_TRANSFORM dependencies on HZ_STAGED_CONTACT_POINTS

Line 357: FROM APPS.HZ_STAGED_CONTACT_POINTS

353: SELECT distinct
354: TX3||' '||
355: TX4||' '||
356: ' '
357: FROM APPS.HZ_STAGED_CONTACT_POINTS
358: WHERE party_id = cp_party_id;
359: l_buffer VARCHAR2(4000);
360: l_den_cpt VARCHAR2(2000);
361: BEGIN

Line 1876: INSERT INTO HZ_STAGED_CONTACT_POINTS (

1872: l_en := H_CPT_PARTY_ID.COUNT;
1873: LOOP
1874: BEGIN
1875: FORALL I in l_st..l_en
1876: INSERT INTO HZ_STAGED_CONTACT_POINTS (
1877: CONTACT_POINT_ID
1878: ,PARTY_ID
1879: ,PARTY_SITE_ID
1880: ,ORG_CONTACT_ID

Line 1996: INSERT INTO HZ_STAGED_CONTACT_POINTS (

1992: WHILE (l_tryins OR l_tryupd) LOOP
1993: IF l_tryins THEN
1994: BEGIN
1995: l_tryins:=FALSE;
1996: INSERT INTO HZ_STAGED_CONTACT_POINTS (
1997: CONTACT_POINT_ID
1998: ,PARTY_ID
1999: ,PARTY_SITE_ID
2000: ,ORG_CONTACT_ID

Line 2051: UPDATE HZ_STAGED_CONTACT_POINTS SET

2047: END IF;
2048: IF l_tryupd THEN
2049: BEGIN
2050: l_tryupd:=FALSE;
2051: UPDATE HZ_STAGED_CONTACT_POINTS SET
2052: concat_col = concat_col
2053: ,status_flag = H_STATUS(1)
2054: ,TX1=decode(H_TX1(1),null,H_TX1(1),H_TX1(1)||' ')
2055: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')

Line 2223: INSERT INTO HZ_STAGED_CONTACT_POINTS (

2219: WHILE (l_tryins OR l_tryupd) LOOP
2220: IF l_tryins THEN
2221: BEGIN
2222: l_tryins:=FALSE;
2223: INSERT INTO HZ_STAGED_CONTACT_POINTS (
2224: CONTACT_POINT_ID
2225: ,PARTY_ID
2226: ,PARTY_SITE_ID
2227: ,ORG_CONTACT_ID

Line 2279: UPDATE HZ_STAGED_CONTACT_POINTS SET

2275:
2276: IF l_tryupd THEN
2277: BEGIN
2278: l_tryupd:=FALSE;
2279: UPDATE HZ_STAGED_CONTACT_POINTS SET
2280: concat_col = concat_col
2281: ,status_flag = H_STATUS(1)
2282: ,TX1=decode(H_TX1(1),null,H_TX1(1),H_TX1(1)||' ')
2283: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')

Line 4083: log ('Inserting Data into HZ_STAGED_CONTACT_POINTS...',FALSE);

4079: l_en := H_CONTACT_POINT_ID.COUNT;
4080:
4081: IF p_operation = 'C' THEN
4082: BEGIN
4083: log ('Inserting Data into HZ_STAGED_CONTACT_POINTS...',FALSE);
4084: FORALL I in l_st..l_en SAVE EXCEPTIONS
4085: INSERT INTO HZ_STAGED_CONTACT_POINTS (
4086: CONTACT_POINT_ID
4087: ,PARTY_ID

Line 4085: INSERT INTO HZ_STAGED_CONTACT_POINTS (

4081: IF p_operation = 'C' THEN
4082: BEGIN
4083: log ('Inserting Data into HZ_STAGED_CONTACT_POINTS...',FALSE);
4084: FORALL I in l_st..l_en SAVE EXCEPTIONS
4085: INSERT INTO HZ_STAGED_CONTACT_POINTS (
4086: CONTACT_POINT_ID
4087: ,PARTY_ID
4088: ,PARTY_SITE_ID
4089: ,ORG_CONTACT_ID

Line 4154: log ('Updating Data in HZ_STAGED_CONTACT_POINTS...',FALSE);

4150: END LOOP;
4151: END;
4152: ELSIF p_operation = 'U' THEN
4153: BEGIN
4154: log ('Updating Data in HZ_STAGED_CONTACT_POINTS...',FALSE);
4155: FORALL I in l_st..l_en SAVE EXCEPTIONS
4156: UPDATE HZ_STAGED_CONTACT_POINTS SET
4157: concat_col = concat_col
4158: ,status_flag = H_STATUS(I)

Line 4156: UPDATE HZ_STAGED_CONTACT_POINTS SET

4152: ELSIF p_operation = 'U' THEN
4153: BEGIN
4154: log ('Updating Data in HZ_STAGED_CONTACT_POINTS...',FALSE);
4155: FORALL I in l_st..l_en SAVE EXCEPTIONS
4156: UPDATE HZ_STAGED_CONTACT_POINTS SET
4157: concat_col = concat_col
4158: ,status_flag = H_STATUS(I)
4159: ,TX1=decode(H_TX1(I),null,H_TX1(I),H_TX1(I)||' ')
4160: ,TX2=decode(H_TX2(I),null,H_TX2(I),H_TX2(I)||' ')