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 2472: INSERT INTO HZ_STAGED_PARTY_SITES (

2468: l_en := H_PS_PARTY_ID.COUNT;
2469: LOOP
2470: BEGIN
2471: FORALL I in l_st..l_en
2472: INSERT INTO HZ_STAGED_PARTY_SITES (
2473: PARTY_SITE_ID
2474: ,PARTY_ID
2475: ,ORG_CONTACT_ID
2476: ,STATUS_FLAG

Line 2620: INSERT INTO HZ_STAGED_PARTY_SITES (

2616: WHILE (l_tryins OR l_tryupd) LOOP
2617: IF l_tryins THEN
2618: BEGIN
2619: l_tryins:=FALSE;
2620: INSERT INTO HZ_STAGED_PARTY_SITES (
2621: PARTY_SITE_ID
2622: ,PARTY_ID
2623: ,ORG_CONTACT_ID
2624: ,STATUS_FLAG

Line 2685: UPDATE HZ_STAGED_PARTY_SITES SET

2681: END IF;
2682: IF l_tryupd THEN
2683: BEGIN
2684: l_tryupd:=FALSE;
2685: UPDATE HZ_STAGED_PARTY_SITES SET
2686: concat_col = concat_col
2687: ,status_flag = H_STATUS(1)
2688: ,TX3=decode(H_TX3(1),null,H_TX3(1),H_TX3(1)||' ')
2689: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 2850: INSERT INTO HZ_STAGED_PARTY_SITES (

2846: WHILE (l_tryins OR l_tryupd) LOOP
2847: IF l_tryins THEN
2848: BEGIN
2849: l_tryins:=FALSE;
2850: INSERT INTO HZ_STAGED_PARTY_SITES (
2851: PARTY_SITE_ID
2852: ,PARTY_ID
2853: ,ORG_CONTACT_ID
2854: ,STATUS_FLAG

Line 2916: UPDATE HZ_STAGED_PARTY_SITES SET

2912:
2913: IF l_tryupd THEN
2914: BEGIN
2915: l_tryupd:=FALSE;
2916: UPDATE HZ_STAGED_PARTY_SITES SET
2917: concat_col = concat_col
2918: ,status_flag = H_STATUS(1)
2919: ,TX3=decode(H_TX3(1),null,H_TX3(1),H_TX3(1)||' ')
2920: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

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

3497: l_en := H_PARTY_SITE_ID.COUNT;
3498:
3499: IF p_operation = 'C' THEN
3500: BEGIN
3501: log ('Inserting Data into HZ_STAGED_PARTY_SITES...',FALSE);
3502: FORALL I in l_st..l_en SAVE EXCEPTIONS
3503: INSERT INTO HZ_STAGED_PARTY_SITES (
3504: PARTY_SITE_ID
3505: ,PARTY_ID

Line 3503: INSERT INTO HZ_STAGED_PARTY_SITES (

3499: IF p_operation = 'C' THEN
3500: BEGIN
3501: log ('Inserting Data into HZ_STAGED_PARTY_SITES...',FALSE);
3502: FORALL I in l_st..l_en SAVE EXCEPTIONS
3503: INSERT INTO HZ_STAGED_PARTY_SITES (
3504: PARTY_SITE_ID
3505: ,PARTY_ID
3506: ,ORG_CONTACT_ID
3507: ,STATUS_FLAG

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

3578: END LOOP;
3579: END;
3580: ELSIF p_operation = 'U' THEN
3581: BEGIN
3582: log ('Updating Data in HZ_STAGED_PARTY_SITES...',FALSE);
3583: FORALL I in l_st..l_en SAVE EXCEPTIONS
3584: UPDATE HZ_STAGED_PARTY_SITES SET
3585: concat_col = concat_col
3586: ,status_flag = H_STATUS(I)

Line 3584: UPDATE HZ_STAGED_PARTY_SITES SET

3580: ELSIF p_operation = 'U' THEN
3581: BEGIN
3582: log ('Updating Data in HZ_STAGED_PARTY_SITES...',FALSE);
3583: FORALL I in l_st..l_en SAVE EXCEPTIONS
3584: UPDATE HZ_STAGED_PARTY_SITES SET
3585: concat_col = concat_col
3586: ,status_flag = H_STATUS(I)
3587: ,TX3=decode(H_TX3(I),null,H_TX3(I),H_TX3(I)||' ')
3588: ,TX4=decode(H_TX4(I),null,H_TX4(I),H_TX4(I)||' ')