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 536: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp

532: ,p.REFERENCE_USE_FLAG
533: ,op.CORPORATION_CLASS
534: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
535: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
536: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
537: WHERE sp.party_id = p.party_id)
538: AND p.party_id = op.party_id
539: AND op.effective_end_date is NULL
540: AND p.PARTY_TYPE ='ORGANIZATION';

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

555: ,p.REFERENCE_USE_FLAG
556: ,NULL
557: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
558: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
559: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
560: WHERE sp.party_id = p.party_id)
561: AND p.party_id = pe.party_id
562: AND pe.effective_end_date is NULL
563: AND p.PARTY_TYPE ='PERSON';

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

578: ,p.REFERENCE_USE_FLAG
579: ,NULL
580: FROM HZ_PARTIES p
581: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
582: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
583: WHERE sp.party_id = p.party_id)
584: AND p.party_type <> 'PERSON'
585: AND p.party_type <> 'ORGANIZATION'
586: AND p.party_type <> 'PARTY_RELATIONSHIP';

Line 689: INSERT INTO HZ_STAGED_PARTIES (

685: l_en := H_P_PARTY_ID.COUNT;
686: LOOP
687: BEGIN
688: FORALL I in l_st..l_en
689: INSERT INTO HZ_STAGED_PARTIES (
690: PARTY_ID
691: ,STATUS
692: , TX2
693: , TX4

Line 762: UPDATE HZ_STAGED_PARTIES SET

758: insert_stage_contacts;
759: insert_stage_party_sites;
760: insert_stage_contact_pts;
761: FORALL I in H_P_PARTY_ID.FIRST..H_P_PARTY_ID.LAST
762: UPDATE HZ_STAGED_PARTIES SET
763: D_PS = H_PS_DEN(I),
764: D_CT = H_CT_DEN(I),
765: D_CPT = H_CPT_DEN(I)
766: WHERE PARTY_ID = H_P_PARTY_ID(I);

Line 928: INSERT INTO HZ_STAGED_PARTIES (

924: WHILE (l_tryins OR l_tryupd) LOOP
925: IF l_tryins THEN
926: BEGIN
927: l_tryins:=FALSE;
928: INSERT INTO HZ_STAGED_PARTIES (
929: PARTY_ID
930: ,STATUS
931: ,D_PS
932: ,D_CT

Line 1005: UPDATE HZ_STAGED_PARTIES SET

1001: END IF;
1002: IF l_tryupd THEN
1003: BEGIN
1004: l_tryupd:=FALSE;
1005: UPDATE HZ_STAGED_PARTIES SET
1006: status =H_STATUS(1)
1007: ,concat_col = concat_col
1008: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1009: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 1244: INSERT INTO HZ_STAGED_PARTIES (

1240: WHILE (l_tryins OR l_tryupd) LOOP
1241: IF l_tryins THEN
1242: BEGIN
1243: l_tryins:=FALSE;
1244: INSERT INTO HZ_STAGED_PARTIES (
1245: PARTY_ID
1246: ,STATUS
1247: ,D_PS
1248: ,D_CT

Line 1322: UPDATE HZ_STAGED_PARTIES SET

1318:
1319: IF l_tryupd THEN
1320: BEGIN
1321: l_tryupd:=FALSE;
1322: UPDATE HZ_STAGED_PARTIES SET
1323: concat_col = concat_col
1324: ,status =H_STATUS(1)
1325: ,TX2=decode(H_TX2(1),null,H_TX2(1),H_TX2(1)||' ')
1326: ,TX4=decode(H_TX4(1),null,H_TX4(1),H_TX4(1)||' ')

Line 1617: UPDATE HZ_STAGED_PARTIES set

1613: END;
1614: END IF;
1615: END LOOP;
1616: --Fix for bug 5048604, to update concat_col during update of denorm column
1617: UPDATE HZ_STAGED_PARTIES set
1618: D_CT = 'SYNC'
1619: ,CONCAT_COL = CONCAT_COL
1620: WHERE PARTY_ID = H_PARTY_ID(1);
1621: END;

Line 1757: UPDATE HZ_STAGED_PARTIES set

1753: END IF;
1754: END LOOP;
1755:
1756: --Fix for bug 5048604, to update concat_col during update of denorm column
1757: UPDATE HZ_STAGED_PARTIES set
1758: D_CT = 'SYNC'
1759: ,CONCAT_COL = CONCAT_COL
1760: WHERE PARTY_ID = H_PARTY_ID(1);
1761:

Line 2082: UPDATE HZ_STAGED_PARTIES set

2078: END;
2079: END IF;
2080: END LOOP;
2081: --Fix for bug 5048604, to update concat_col during update of denorm column
2082: UPDATE HZ_STAGED_PARTIES set
2083: D_CPT = 'SYNC'
2084: ,CONCAT_COL = CONCAT_COL
2085: WHERE PARTY_ID = H_PARTY_ID(1);
2086: END;

Line 2311: UPDATE HZ_STAGED_PARTIES set

2307: END IF;
2308: END LOOP;
2309:
2310: --Fix for bug 5048604, to update concat_col during update of denorm column
2311: UPDATE HZ_STAGED_PARTIES set
2312: D_CPT = 'SYNC'
2313: ,CONCAT_COL = CONCAT_COL
2314: WHERE PARTY_ID = H_PARTY_ID(1);
2315:

Line 2697: UPDATE HZ_STAGED_PARTIES set

2693: END;
2694: END IF;
2695: END LOOP;
2696: --Fix for bug 5048604, to update concat_col during update of denorm column
2697: UPDATE HZ_STAGED_PARTIES set
2698: D_PS = 'SYNC'
2699: ,CONCAT_COL = CONCAT_COL
2700: WHERE PARTY_ID = H_PARTY_ID(1);
2701: END;

Line 2929: UPDATE HZ_STAGED_PARTIES set

2925: END IF;
2926: END LOOP;
2927:
2928: --Fix for bug 5048604, to update concat_col during update of denorm column
2929: UPDATE HZ_STAGED_PARTIES set
2930: D_PS = 'SYNC'
2931: ,CONCAT_COL = CONCAT_COL
2932: WHERE PARTY_ID = H_PARTY_ID(1);
2933:

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

3129: l_en := H_P_PARTY_ID.COUNT;
3130:
3131: IF p_operation = 'C' THEN
3132: BEGIN
3133: log ('Inserting Data into HZ_STAGED_PARTIES...',FALSE);
3134: FORALL I in l_st..l_en SAVE EXCEPTIONS
3135: INSERT INTO HZ_STAGED_PARTIES (
3136: PARTY_ID
3137: ,STATUS

Line 3135: INSERT INTO HZ_STAGED_PARTIES (

3131: IF p_operation = 'C' THEN
3132: BEGIN
3133: log ('Inserting Data into HZ_STAGED_PARTIES...',FALSE);
3134: FORALL I in l_st..l_en SAVE EXCEPTIONS
3135: INSERT INTO HZ_STAGED_PARTIES (
3136: PARTY_ID
3137: ,STATUS
3138: ,D_PS
3139: ,D_CT

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

3222: END LOOP;
3223: END;
3224: ELSIF p_operation = 'U' THEN
3225: BEGIN
3226: log ('Updating Data in HZ_STAGED_PARTIES...',FALSE);
3227: FORALL I in l_st..l_en SAVE EXCEPTIONS
3228: UPDATE HZ_STAGED_PARTIES SET
3229: status =H_STATUS(I)
3230: ,concat_col = concat_col

Line 3228: UPDATE HZ_STAGED_PARTIES SET

3224: ELSIF p_operation = 'U' THEN
3225: BEGIN
3226: log ('Updating Data in HZ_STAGED_PARTIES...',FALSE);
3227: FORALL I in l_st..l_en SAVE EXCEPTIONS
3228: UPDATE HZ_STAGED_PARTIES SET
3229: status =H_STATUS(I)
3230: ,concat_col = concat_col
3231: ,TX2=decode(H_TX2(I),null,H_TX2(I),H_TX2(I)||' ')
3232: ,TX4=decode(H_TX4(I),null,H_TX4(I),H_TX4(I)||' ')

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

3605: END;
3606: END IF;
3607:
3608: IF l_last_fetch THEN
3609: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3610: -- PARTY_SITES (in this case), have been inserted/updated
3611:
3612: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3613: --Fix for bug 5048604, to update concat_col during update of denorm column

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

3608: IF l_last_fetch THEN
3609: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3610: -- PARTY_SITES (in this case), have been inserted/updated
3611:
3612: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3613: --Fix for bug 5048604, to update concat_col during update of denorm column
3614: FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST
3615: UPDATE HZ_STAGED_PARTIES set
3616: D_PS = 'SYNC'

Line 3615: UPDATE HZ_STAGED_PARTIES set

3611:
3612: log ('Updating D_PS column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3613: --Fix for bug 5048604, to update concat_col during update of denorm column
3614: FORALL I IN H_PARTY_SITE_ID.FIRST..H_PARTY_SITE_ID.LAST
3615: UPDATE HZ_STAGED_PARTIES set
3616: D_PS = 'SYNC'
3617: ,CONCAT_COL = CONCAT_COL
3618: WHERE PARTY_ID = H_PS_PARTY_ID(I);
3619: log ('Done');

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

3881: END;
3882: END IF;
3883:
3884: IF l_last_fetch THEN
3885: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3886: -- CONTACTS (in this case), have been inserted/updated
3887:
3888: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3889: --Fix for bug 5048604, to update concat_col during update of denorm column

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

3884: IF l_last_fetch THEN
3885: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
3886: -- CONTACTS (in this case), have been inserted/updated
3887:
3888: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3889: --Fix for bug 5048604, to update concat_col during update of denorm column
3890: FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST
3891: UPDATE HZ_STAGED_PARTIES set
3892: D_CT = 'SYNC'

Line 3891: UPDATE HZ_STAGED_PARTIES set

3887:
3888: log ('Updating D_CT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
3889: --Fix for bug 5048604, to update concat_col during update of denorm column
3890: FORALL I IN H_ORG_CONTACT_ID.FIRST..H_ORG_CONTACT_ID.LAST
3891: UPDATE HZ_STAGED_PARTIES set
3892: D_CT = 'SYNC'
3893: ,CONCAT_COL = CONCAT_COL
3894: WHERE PARTY_ID = H_C_PARTY_ID(I);
3895: log ('Done');

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

4196: END;
4197: END IF;
4198:
4199: IF l_last_fetch THEN
4200: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
4201: -- CONTACT_POINTS (in this case), have been inserted/updated
4202:
4203: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4204: --Fix for bug 5048604, to update concat_col during update of denorm column

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

4199: IF l_last_fetch THEN
4200: -- Update HZ_STAGED_PARTIES, if corresponding child entity records
4201: -- CONTACT_POINTS (in this case), have been inserted/updated
4202:
4203: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4204: --Fix for bug 5048604, to update concat_col during update of denorm column
4205: FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST
4206: UPDATE HZ_STAGED_PARTIES set
4207: D_CPT = 'SYNC'

Line 4206: UPDATE HZ_STAGED_PARTIES set

4202:
4203: log ('Updating D_CPT column to SYNC in HZ_STAGED_PARTIES table for all related records...',FALSE);
4204: --Fix for bug 5048604, to update concat_col during update of denorm column
4205: FORALL I IN H_CONTACT_POINT_ID.FIRST..H_CONTACT_POINT_ID.LAST
4206: UPDATE HZ_STAGED_PARTIES set
4207: D_CPT = 'SYNC'
4208: ,CONCAT_COL = CONCAT_COL
4209: WHERE PARTY_ID = H_CPT_PARTY_ID(I);
4210: log ('Done');