APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_STAGED_CONTACTS

Line 334: FROM APPS.HZ_STAGED_CONTACTS

330: CURSOR contact_denorm (cp_party_id NUMBER) IS
331: SELECT distinct
332: TX22||' '||
333: ' '
334: FROM APPS.HZ_STAGED_CONTACTS
335: WHERE party_id = cp_party_id;
336: l_buffer VARCHAR2(4000);
337: l_den_ct VARCHAR2(2000);
338: BEGIN

Line 1488: INSERT INTO HZ_STAGED_CONTACTS (

1484: l_en := H_C_PARTY_ID.COUNT;
1485: LOOP
1486: BEGIN
1487: FORALL I in l_st..l_en
1488: INSERT INTO HZ_STAGED_CONTACTS (
1489: ORG_CONTACT_ID
1490: ,PARTY_ID
1491: ,STATUS_FLAG
1492: , TX2

Line 1581: INSERT INTO HZ_STAGED_CONTACTS (

1577: WHILE (l_tryins OR l_tryupd) LOOP
1578: IF l_tryins THEN
1579: BEGIN
1580: l_tryins:=FALSE;
1581: INSERT INTO HZ_STAGED_CONTACTS (
1582: ORG_CONTACT_ID
1583: ,PARTY_ID
1584: ,STATUS_FLAG
1585: , TX2

Line 1618: UPDATE HZ_STAGED_CONTACTS SET

1614: END IF;
1615: IF l_tryupd THEN
1616: BEGIN
1617: l_tryupd:=FALSE;
1618: UPDATE HZ_STAGED_CONTACTS SET
1619: concat_col = concat_col
1620: ,status_flag = H_STATUS(1)
1621: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1622: ,TX5=decode(H_TX5(1),null,H_TX5(1),H_TX5(1)||' ')

Line 1719: INSERT INTO HZ_STAGED_CONTACTS (

1715: WHILE (l_tryins OR l_tryupd) LOOP
1716: IF l_tryins THEN
1717: BEGIN
1718: l_tryins:=FALSE;
1719: INSERT INTO HZ_STAGED_CONTACTS (
1720: ORG_CONTACT_ID
1721: ,PARTY_ID
1722: ,STATUS_FLAG
1723: ,TX2

Line 1757: UPDATE HZ_STAGED_CONTACTS SET

1753:
1754: IF l_tryupd THEN
1755: BEGIN
1756: l_tryupd:=FALSE;
1757: UPDATE HZ_STAGED_CONTACTS SET
1758: concat_col = concat_col
1759: ,status_flag = H_STATUS(1)
1760: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1761: ,TX5=decode(H_TX5(1),null,H_TX5(1),H_TX5(1)||' ')

Line 3818: log ('Inserting Data into HZ_STAGED_CONTACTS...',FALSE);

3814: l_en := H_ORG_CONTACT_ID.COUNT;
3815:
3816: IF p_operation = 'C' THEN
3817: BEGIN
3818: log ('Inserting Data into HZ_STAGED_CONTACTS...',FALSE);
3819: FORALL I in l_st..l_en SAVE EXCEPTIONS
3820: INSERT INTO HZ_STAGED_CONTACTS (
3821: ORG_CONTACT_ID
3822: ,PARTY_ID

Line 3820: INSERT INTO HZ_STAGED_CONTACTS (

3816: IF p_operation = 'C' THEN
3817: BEGIN
3818: log ('Inserting Data into HZ_STAGED_CONTACTS...',FALSE);
3819: FORALL I in l_st..l_en SAVE EXCEPTIONS
3820: INSERT INTO HZ_STAGED_CONTACTS (
3821: ORG_CONTACT_ID
3822: ,PARTY_ID
3823: ,STATUS_FLAG
3824: ,TX2

Line 3871: log ('Updating Data in HZ_STAGED_CONTACTS...',FALSE);

3867: END LOOP;
3868: END;
3869: ELSIF p_operation = 'U' THEN
3870: BEGIN
3871: log ('Updating Data in HZ_STAGED_CONTACTS...',FALSE);
3872: FORALL I in l_st..l_en SAVE EXCEPTIONS
3873: UPDATE HZ_STAGED_CONTACTS SET
3874: concat_col = concat_col
3875: ,status_flag = H_STATUS(I)

Line 3873: UPDATE HZ_STAGED_CONTACTS SET

3869: ELSIF p_operation = 'U' THEN
3870: BEGIN
3871: log ('Updating Data in HZ_STAGED_CONTACTS...',FALSE);
3872: FORALL I in l_st..l_en SAVE EXCEPTIONS
3873: UPDATE HZ_STAGED_CONTACTS SET
3874: concat_col = concat_col
3875: ,status_flag = H_STATUS(I)
3876: ,TX2=decode(H_TX2(I),null,H_TX2(I),H_TX2(I)||' ')
3877: ,TX5=decode(H_TX5(I),null,H_TX5(I),H_TX5(I)||' ')