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_PARTIES

Line 562: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp

558: ,p.REFERENCE_USE_FLAG
559: ,op.CORPORATION_CLASS
560: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
561: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
562: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
563: WHERE sp.party_id = p.party_id)
564: AND p.party_id = op.party_id
565: AND op.effective_end_date is NULL
566: AND p.PARTY_TYPE ='ORGANIZATION';

Line 585: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp

581: ,p.REFERENCE_USE_FLAG
582: ,NULL
583: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
584: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
585: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
586: WHERE sp.party_id = p.party_id)
587: AND p.party_id = pe.party_id
588: AND pe.effective_end_date is NULL
589: AND p.PARTY_TYPE ='PERSON';

Line 608: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp

604: ,p.REFERENCE_USE_FLAG
605: ,NULL
606: FROM HZ_PARTIES p
607: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
608: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
609: WHERE sp.party_id = p.party_id)
610: AND p.party_type <> 'PERSON'
611: AND p.party_type <> 'ORGANIZATION'
612: AND p.party_type <> 'PARTY_RELATIONSHIP';

Line 715: INSERT INTO HZ_STAGED_PARTIES (

711: l_en := H_P_PARTY_ID.COUNT;
712: LOOP
713: BEGIN
714: FORALL I in l_st..l_en
715: INSERT INTO HZ_STAGED_PARTIES (
716: PARTY_ID
717: ,STATUS
718: , TX2
719: , TX4

Line 788: UPDATE HZ_STAGED_PARTIES SET

784: insert_stage_contacts;
785: insert_stage_party_sites;
786: insert_stage_contact_pts;
787: FORALL I in H_P_PARTY_ID.FIRST..H_P_PARTY_ID.LAST
788: UPDATE HZ_STAGED_PARTIES SET
789: D_PS = H_PS_DEN(I),
790: D_CT = H_CT_DEN(I),
791: D_CPT = H_CPT_DEN(I)
792: WHERE PARTY_ID = H_P_PARTY_ID(I);

Line 954: INSERT INTO HZ_STAGED_PARTIES (

950: WHILE (l_tryins OR l_tryupd) LOOP
951: IF l_tryins THEN
952: BEGIN
953: l_tryins:=FALSE;
954: INSERT INTO HZ_STAGED_PARTIES (
955: PARTY_ID
956: ,STATUS
957: ,D_PS
958: ,D_CT

Line 1031: UPDATE HZ_STAGED_PARTIES SET

1027: END IF;
1028: IF l_tryupd THEN
1029: BEGIN
1030: l_tryupd:=FALSE;
1031: UPDATE HZ_STAGED_PARTIES SET
1032: status =H_STATUS(1)
1033: ,concat_col = concat_col
1034: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1035: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 1270: INSERT INTO HZ_STAGED_PARTIES (

1266: WHILE (l_tryins OR l_tryupd) LOOP
1267: IF l_tryins THEN
1268: BEGIN
1269: l_tryins:=FALSE;
1270: INSERT INTO HZ_STAGED_PARTIES (
1271: PARTY_ID
1272: ,STATUS
1273: ,D_PS
1274: ,D_CT

Line 1348: UPDATE HZ_STAGED_PARTIES SET

1344:
1345: IF l_tryupd THEN
1346: BEGIN
1347: l_tryupd:=FALSE;
1348: UPDATE HZ_STAGED_PARTIES SET
1349: concat_col = concat_col
1350: ,status =H_STATUS(1)
1351: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1352: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 1643: UPDATE HZ_STAGED_PARTIES set

1639: END;
1640: END IF;
1641: END LOOP;
1642: --Fix for bug 5048604, to update concat_col during update of denorm column
1643: UPDATE HZ_STAGED_PARTIES set
1644: D_CT = 'SYNC'
1645: ,CONCAT_COL = CONCAT_COL
1646: WHERE PARTY_ID = H_PARTY_ID(1);
1647: END;

Line 1783: UPDATE HZ_STAGED_PARTIES set

1779: END IF;
1780: END LOOP;
1781:
1782: --Fix for bug 5048604, to update concat_col during update of denorm column
1783: UPDATE HZ_STAGED_PARTIES set
1784: D_CT = 'SYNC'
1785: ,CONCAT_COL = CONCAT_COL
1786: WHERE PARTY_ID = H_PARTY_ID(1);
1787:

Line 2108: UPDATE HZ_STAGED_PARTIES set

2104: END;
2105: END IF;
2106: END LOOP;
2107: --Fix for bug 5048604, to update concat_col during update of denorm column
2108: UPDATE HZ_STAGED_PARTIES set
2109: D_CPT = 'SYNC'
2110: ,CONCAT_COL = CONCAT_COL
2111: WHERE PARTY_ID = H_PARTY_ID(1);
2112: END;

Line 2337: UPDATE HZ_STAGED_PARTIES set

2333: END IF;
2334: END LOOP;
2335:
2336: --Fix for bug 5048604, to update concat_col during update of denorm column
2337: UPDATE HZ_STAGED_PARTIES set
2338: D_CPT = 'SYNC'
2339: ,CONCAT_COL = CONCAT_COL
2340: WHERE PARTY_ID = H_PARTY_ID(1);
2341:

Line 2723: UPDATE HZ_STAGED_PARTIES set

2719: END;
2720: END IF;
2721: END LOOP;
2722: --Fix for bug 5048604, to update concat_col during update of denorm column
2723: UPDATE HZ_STAGED_PARTIES set
2724: D_PS = 'SYNC'
2725: ,CONCAT_COL = CONCAT_COL
2726: WHERE PARTY_ID = H_PARTY_ID(1);
2727: END;

Line 2955: UPDATE HZ_STAGED_PARTIES set

2951: END IF;
2952: END LOOP;
2953:
2954: --Fix for bug 5048604, to update concat_col during update of denorm column
2955: UPDATE HZ_STAGED_PARTIES set
2956: D_PS = 'SYNC'
2957: ,CONCAT_COL = CONCAT_COL
2958: WHERE PARTY_ID = H_PARTY_ID(1);
2959:

Line 3159: log ('Inserting Data into HZ_STAGED_PARTIES...',FALSE);

3155: l_en := H_P_PARTY_ID.COUNT;
3156:
3157: IF p_operation = 'C' THEN
3158: BEGIN
3159: log ('Inserting Data into HZ_STAGED_PARTIES...',FALSE);
3160: FORALL I in l_st..l_en SAVE EXCEPTIONS
3161: INSERT INTO HZ_STAGED_PARTIES (
3162: PARTY_ID
3163: ,STATUS

Line 3161: INSERT INTO HZ_STAGED_PARTIES (

3157: IF p_operation = 'C' THEN
3158: BEGIN
3159: log ('Inserting Data into HZ_STAGED_PARTIES...',FALSE);
3160: FORALL I in l_st..l_en SAVE EXCEPTIONS
3161: INSERT INTO HZ_STAGED_PARTIES (
3162: PARTY_ID
3163: ,STATUS
3164: ,D_PS
3165: ,D_CT

Line 3252: log ('Updating Data in HZ_STAGED_PARTIES...',FALSE);

3248: END LOOP;
3249: END;
3250: ELSIF p_operation = 'U' THEN
3251: BEGIN
3252: log ('Updating Data in HZ_STAGED_PARTIES...',FALSE);
3253: FORALL I in l_st..l_en SAVE EXCEPTIONS
3254: UPDATE HZ_STAGED_PARTIES SET
3255: status =H_STATUS(I)
3256: ,concat_col = concat_col

Line 3254: UPDATE HZ_STAGED_PARTIES SET

3250: ELSIF p_operation = 'U' THEN
3251: BEGIN
3252: log ('Updating Data in HZ_STAGED_PARTIES...',FALSE);
3253: FORALL I in l_st..l_en SAVE EXCEPTIONS
3254: UPDATE HZ_STAGED_PARTIES SET
3255: status =H_STATUS(I)
3256: ,concat_col = concat_col
3257: ,TX2=decode(H_TX2(I),null,H_TX2(I),H_TX2(I)||' ')
3258: ,TX4=decode(H_TX4(I),null,H_TX4(I),H_TX4(I)||' ')

Line 3635: -- Update HZ_STAGED_PARTIES, if corresponding child entity records

3631: END;
3632: END IF;
3633:
3634: IF l_last_fetch THEN
3635: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3636: -- PARTY_SITES (in this case), have been inserted/updated
3637:
3638: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3639: --Fix for bug 5048604, to update concat_col during update of denorm column

Line 3638: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);

3634: IF l_last_fetch THEN
3635: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3636: -- PARTY_SITES (in this case), have been inserted/updated
3637:
3638: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3639: --Fix for bug 5048604, to update concat_col during update of denorm column
3640: FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST
3641: UPDATE HZ_STAGED_PARTIES set
3642: D_PS = 'SYNC'

Line 3641: UPDATE HZ_STAGED_PARTIES set

3637:
3638: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3639: --Fix for bug 5048604, to update concat_col during update of denorm column
3640: FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST
3641: UPDATE HZ_STAGED_PARTIES set
3642: D_PS = 'SYNC'
3643: ,CONCAT_COL = CONCAT_COL
3644: WHERE PARTY_ID = H_PS_PARTY_ID(I);
3645: log ('Done');

Line 3911: -- Update HZ_STAGED_PARTIES, if corresponding child entity records

3907: END;
3908: END IF;
3909:
3910: IF l_last_fetch THEN
3911: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3912: -- CONTACTS (in this case), have been inserted/updated
3913:
3914: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3915: --Fix for bug 5048604, to update concat_col during update of denorm column

Line 3914: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);

3910: IF l_last_fetch THEN
3911: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3912: -- CONTACTS (in this case), have been inserted/updated
3913:
3914: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3915: --Fix for bug 5048604, to update concat_col during update of denorm column
3916: FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST
3917: UPDATE HZ_STAGED_PARTIES set
3918: D_CT = 'SYNC'

Line 3917: UPDATE HZ_STAGED_PARTIES set

3913:
3914: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3915: --Fix for bug 5048604, to update concat_col during update of denorm column
3916: FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST
3917: UPDATE HZ_STAGED_PARTIES set
3918: D_CT = 'SYNC'
3919: ,CONCAT_COL = CONCAT_COL
3920: WHERE PARTY_ID = H_C_PARTY_ID(I);
3921: log ('Done');

Line 4226: -- Update HZ_STAGED_PARTIES, if corresponding child entity records

4222: END;
4223: END IF;
4224:
4225: IF l_last_fetch THEN
4226: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
4227: -- CONTACT_POINTS (in this case), have been inserted/updated
4228:
4229: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4230: --Fix for bug 5048604, to update concat_col during update of denorm column

Line 4229: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);

4225: IF l_last_fetch THEN
4226: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
4227: -- CONTACT_POINTS (in this case), have been inserted/updated
4228:
4229: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4230: --Fix for bug 5048604, to update concat_col during update of denorm column
4231: FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST
4232: UPDATE HZ_STAGED_PARTIES set
4233: D_CPT = 'SYNC'

Line 4232: UPDATE HZ_STAGED_PARTIES set

4228:
4229: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4230: --Fix for bug 5048604, to update concat_col during update of denorm column
4231: FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST
4232: UPDATE HZ_STAGED_PARTIES set
4233: D_CPT = 'SYNC'
4234: ,CONCAT_COL = CONCAT_COL
4235: WHERE PARTY_ID = H_CPT_PARTY_ID(I);
4236: log ('Done');