APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_STAGED_PARTY_SITES

Line 312: FROM APPS.HZ_STAGED_PARTY_SITES

308: TX20||' '||
309: TX21||' '||
310: TX22||' '||
311: ' '
312: FROM APPS.HZ_STAGED_PARTY_SITES
313: WHERE party_id = cp_party_id;
314: l_buffer VARCHAR2(4000);
315: l_den_ps VARCHAR2(2000);
316: BEGIN

Line 2446: INSERT INTO HZ_STAGED_PARTY_SITES (

2442: l_en := H_PS_PARTY_ID.COUNT;
2443: LOOP
2444: BEGIN
2445: FORALL I in l_st..l_en
2446: INSERT INTO HZ_STAGED_PARTY_SITES (
2447: PARTY_SITE_ID
2448: ,PARTY_ID
2449: ,ORG_CONTACT_ID
2450: ,STATUS_FLAG

Line 2594: INSERT INTO HZ_STAGED_PARTY_SITES (

2590: WHILE (l_tryins OR l_tryupd) LOOP
2591: IF l_tryins THEN
2592: BEGIN
2593: l_tryins:=FALSE;
2594: INSERT INTO HZ_STAGED_PARTY_SITES (
2595: PARTY_SITE_ID
2596: ,PARTY_ID
2597: ,ORG_CONTACT_ID
2598: ,STATUS_FLAG

Line 2659: UPDATE HZ_STAGED_PARTY_SITES SET

2655: END IF;
2656: IF l_tryupd THEN
2657: BEGIN
2658: l_tryupd:=FALSE;
2659: UPDATE HZ_STAGED_PARTY_SITES SET
2660: concat_col = concat_col
2661: ,status_flag = H_STATUS(1)
2662: ,TX3=decode(H_TX3(1),null,H_TX3(1),H_TX3(1)||' ')
2663: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 2824: INSERT INTO HZ_STAGED_PARTY_SITES (

2820: WHILE (l_tryins OR l_tryupd) LOOP
2821: IF l_tryins THEN
2822: BEGIN
2823: l_tryins:=FALSE;
2824: INSERT INTO HZ_STAGED_PARTY_SITES (
2825: PARTY_SITE_ID
2826: ,PARTY_ID
2827: ,ORG_CONTACT_ID
2828: ,STATUS_FLAG

Line 2890: UPDATE HZ_STAGED_PARTY_SITES SET

2886:
2887: IF l_tryupd THEN
2888: BEGIN
2889: l_tryupd:=FALSE;
2890: UPDATE HZ_STAGED_PARTY_SITES SET
2891: concat_col = concat_col
2892: ,status_flag = H_STATUS(1)
2893: ,TX3=decode(H_TX3(1),null,H_TX3(1),H_TX3(1)||' ')
2894: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 3475: log ('Inserting Data into HZ_STAGED_PARTY_SITES...',FALSE);

3471: l_en := H_PARTY_SITE_ID.COUNT;
3472:
3473: IF p_operation = 'C' THEN
3474: BEGIN
3475: log ('Inserting Data into HZ_STAGED_PARTY_SITES...',FALSE);
3476: FORALL I in l_st..l_en SAVE EXCEPTIONS
3477: INSERT INTO HZ_STAGED_PARTY_SITES (
3478: PARTY_SITE_ID
3479: ,PARTY_ID

Line 3477: INSERT INTO HZ_STAGED_PARTY_SITES (

3473: IF p_operation = 'C' THEN
3474: BEGIN
3475: log ('Inserting Data into HZ_STAGED_PARTY_SITES...',FALSE);
3476: FORALL I in l_st..l_en SAVE EXCEPTIONS
3477: INSERT INTO HZ_STAGED_PARTY_SITES (
3478: PARTY_SITE_ID
3479: ,PARTY_ID
3480: ,ORG_CONTACT_ID
3481: ,STATUS_FLAG

Line 3556: log ('Updating Data in HZ_STAGED_PARTY_SITES...',FALSE);

3552: END LOOP;
3553: END;
3554: ELSIF p_operation = 'U' THEN
3555: BEGIN
3556: log ('Updating Data in HZ_STAGED_PARTY_SITES...',FALSE);
3557: FORALL I in l_st..l_en SAVE EXCEPTIONS
3558: UPDATE HZ_STAGED_PARTY_SITES SET
3559: concat_col = concat_col
3560: ,status_flag = H_STATUS(I)

Line 3558: UPDATE HZ_STAGED_PARTY_SITES SET

3554: ELSIF p_operation = 'U' THEN
3555: BEGIN
3556: log ('Updating Data in HZ_STAGED_PARTY_SITES...',FALSE);
3557: FORALL I in l_st..l_en SAVE EXCEPTIONS
3558: UPDATE HZ_STAGED_PARTY_SITES SET
3559: concat_col = concat_col
3560: ,status_flag = H_STATUS(I)
3561: ,TX3=decode(H_TX3(I),null,H_TX3(I),H_TX3(I)||' ')
3562: ,TX4=decode(H_TX4(I),null,H_TX4(I),H_TX4(I)||' ')