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 1902: INSERT INTO HZ_STAGED_CONTACT_POINTS (

1898: l_en := H_CPT_PARTY_ID.COUNT;
1899: LOOP
1900: BEGIN
1901: FORALL I in l_st..l_en
1902: INSERT INTO HZ_STAGED_CONTACT_POINTS (
1903: CONTACT_POINT_ID
1904: ,PARTY_ID
1905: ,PARTY_SITE_ID
1906: ,ORG_CONTACT_ID

Line 2022: INSERT INTO HZ_STAGED_CONTACT_POINTS (

2018: WHILE (l_tryins OR l_tryupd) LOOP
2019: IF l_tryins THEN
2020: BEGIN
2021: l_tryins:=FALSE;
2022: INSERT INTO HZ_STAGED_CONTACT_POINTS (
2023: CONTACT_POINT_ID
2024: ,PARTY_ID
2025: ,PARTY_SITE_ID
2026: ,ORG_CONTACT_ID

Line 2077: UPDATE HZ_STAGED_CONTACT_POINTS SET

2073: END IF;
2074: IF l_tryupd THEN
2075: BEGIN
2076: l_tryupd:=FALSE;
2077: UPDATE HZ_STAGED_CONTACT_POINTS SET
2078: concat_col = concat_col
2079: ,status_flag = H_STATUS(1)
2080: ,TX1=decode(H_TX1(1),null,H_TX1(1),H_TX1(1)||' ')
2081: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')

Line 2249: INSERT INTO HZ_STAGED_CONTACT_POINTS (

2245: WHILE (l_tryins OR l_tryupd) LOOP
2246: IF l_tryins THEN
2247: BEGIN
2248: l_tryins:=FALSE;
2249: INSERT INTO HZ_STAGED_CONTACT_POINTS (
2250: CONTACT_POINT_ID
2251: ,PARTY_ID
2252: ,PARTY_SITE_ID
2253: ,ORG_CONTACT_ID

Line 2305: UPDATE HZ_STAGED_CONTACT_POINTS SET

2301:
2302: IF l_tryupd THEN
2303: BEGIN
2304: l_tryupd:=FALSE;
2305: UPDATE HZ_STAGED_CONTACT_POINTS SET
2306: concat_col = concat_col
2307: ,status_flag = H_STATUS(1)
2308: ,TX1=decode(H_TX1(1),null,H_TX1(1),H_TX1(1)||' ')
2309: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')

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

4105: l_en := H_CONTACT_POINT_ID.COUNT;
4106:
4107: IF p_operation = 'C' THEN
4108: BEGIN
4109: log ('Inserting Data into HZ_STAGED_CONTACT_POINTS...',FALSE);
4110: FORALL I in l_st..l_en SAVE EXCEPTIONS
4111: INSERT INTO HZ_STAGED_CONTACT_POINTS (
4112: CONTACT_POINT_ID
4113: ,PARTY_ID

Line 4111: INSERT INTO HZ_STAGED_CONTACT_POINTS (

4107: IF p_operation = 'C' THEN
4108: BEGIN
4109: log ('Inserting Data into HZ_STAGED_CONTACT_POINTS...',FALSE);
4110: FORALL I in l_st..l_en SAVE EXCEPTIONS
4111: INSERT INTO HZ_STAGED_CONTACT_POINTS (
4112: CONTACT_POINT_ID
4113: ,PARTY_ID
4114: ,PARTY_SITE_ID
4115: ,ORG_CONTACT_ID

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

4176: END LOOP;
4177: END;
4178: ELSIF p_operation = 'U' THEN
4179: BEGIN
4180: log ('Updating Data in HZ_STAGED_CONTACT_POINTS...',FALSE);
4181: FORALL I in l_st..l_en SAVE EXCEPTIONS
4182: UPDATE HZ_STAGED_CONTACT_POINTS SET
4183: concat_col = concat_col
4184: ,status_flag = H_STATUS(I)

Line 4182: UPDATE HZ_STAGED_CONTACT_POINTS SET

4178: ELSIF p_operation = 'U' THEN
4179: BEGIN
4180: log ('Updating Data in HZ_STAGED_CONTACT_POINTS...',FALSE);
4181: FORALL I in l_st..l_en SAVE EXCEPTIONS
4182: UPDATE HZ_STAGED_CONTACT_POINTS SET
4183: concat_col = concat_col
4184: ,status_flag = H_STATUS(I)
4185: ,TX1=decode(H_TX1(I),null,H_TX1(I),H_TX1(I)||' ')
4186: ,TX2=decode(H_TX2(I),null,H_TX2(I),H_TX2(I)||' ')