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_DQM_SH_SYNC_INTERFACE

Line 1366: -- insert a record into hz_dqm_sh_sync_interface table for each record

1362: END IF;
1363: END LOOP;
1364:
1365: -- REPURI. Bug 4884742. If shadow staging is completely successfully
1366: -- insert a record into hz_dqm_sh_sync_interface table for each record
1367: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
1368: BEGIN
1369: HZ_DQM_SYNC.insert_sh_interface_rec(p_party_id,null,null,null,'PARTY',p_operation);
1370: EXCEPTION WHEN OTHERS THEN

Line 1763: -- insert a record into hz_dqm_sh_sync_interface table for each record

1759: ,CONCAT_COL = CONCAT_COL
1760: WHERE PARTY_ID = H_PARTY_ID(1);
1761:
1762: -- REPURI. Bug 4884742. If shadow staging is completely successfully
1763: -- insert a record into hz_dqm_sh_sync_interface table for each record
1764: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
1765: BEGIN
1766: HZ_DQM_SYNC.insert_sh_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_operation);
1767: EXCEPTION WHEN OTHERS THEN

Line 2317: -- insert a record into hz_dqm_sh_sync_interface table for each record

2313: ,CONCAT_COL = CONCAT_COL
2314: WHERE PARTY_ID = H_PARTY_ID(1);
2315:
2316: -- REPURI. Bug 4884742. If shadow staging is completely successfully
2317: -- insert a record into hz_dqm_sh_sync_interface table for each record
2318: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
2319: BEGIN
2320: HZ_DQM_SYNC.insert_sh_interface_rec(l_party_id,p_contact_point_id,l_party_site_id, l_org_contact_id, 'CONTACT_POINTS',p_operation);
2321: EXCEPTION WHEN OTHERS THEN

Line 2935: -- insert a record into hz_dqm_sh_sync_interface table for each record

2931: ,CONCAT_COL = CONCAT_COL
2932: WHERE PARTY_ID = H_PARTY_ID(1);
2933:
2934: -- REPURI. Bug 4884742. If shadow staging is completely successfully
2935: -- insert a record into hz_dqm_sh_sync_interface table for each record
2936: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
2937: BEGIN
2938: HZ_DQM_SYNC.insert_sh_interface_rec(l_party_id,p_party_site_id,null,l_org_contact_id,'PARTY_SITES',p_operation);
2939: EXCEPTION WHEN OTHERS THEN

Line 3292: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);

3288: BEGIN
3289: -- REPURI. Bug 4968126.
3290: -- Using the Merge instead of Insert statement
3291: -- so that duplicate records dont get inserted.
3292: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3293: FORALL I in l_st..l_en
3294: MERGE INTO hz_dqm_sh_sync_interface S
3295: USING (
3296: SELECT

Line 3294: MERGE INTO hz_dqm_sh_sync_interface S

3290: -- Using the Merge instead of Insert statement
3291: -- so that duplicate records dont get inserted.
3292: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3293: FORALL I in l_st..l_en
3294: MERGE INTO hz_dqm_sh_sync_interface S
3295: USING (
3296: SELECT
3297: H_P_PARTY_ID(I) AS party_id
3298: FROM dual ) T

Line 3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3328: hz_utility_pub.creation_date,
3329: hz_utility_pub.last_update_login,
3330: hz_utility_pub.last_update_date,
3331: hz_utility_pub.user_id,
3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3333: );
3334: log ('Done');
3335: EXCEPTION WHEN OTHERS THEN
3336: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

Line 3336: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

3332: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3333: );
3334: log ('Done');
3335: EXCEPTION WHEN OTHERS THEN
3336: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3337: log ('Eror Message is - '|| sqlerrm);
3338: END;
3339: END IF;
3340:

Line 3630: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);

3626: BEGIN
3627: -- REPURI. Bug 4968126.
3628: -- Using the Merge instead of Insert statement
3629: -- so that duplicate records dont get inserted.
3630: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3631: FORALL I in l_st..l_en
3632: MERGE INTO hz_dqm_sh_sync_interface S
3633: USING (
3634: SELECT

Line 3632: MERGE INTO hz_dqm_sh_sync_interface S

3628: -- Using the Merge instead of Insert statement
3629: -- so that duplicate records dont get inserted.
3630: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3631: FORALL I in l_st..l_en
3632: MERGE INTO hz_dqm_sh_sync_interface S
3633: USING (
3634: SELECT
3635: H_PS_PARTY_ID(I) AS party_id
3636: ,H_PARTY_SITE_ID(I) AS record_id

Line 3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3670: hz_utility_pub.creation_date,
3671: hz_utility_pub.last_update_login,
3672: hz_utility_pub.last_update_date,
3673: hz_utility_pub.user_id,
3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3675: );
3676: log ('Done');
3677: EXCEPTION WHEN OTHERS THEN
3678: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

Line 3678: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

3674: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3675: );
3676: log ('Done');
3677: EXCEPTION WHEN OTHERS THEN
3678: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3679: log ('Eror Message is - '|| sqlerrm);
3680: END;
3681: END IF;
3682:

Line 3906: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);

3902: BEGIN
3903: -- REPURI. Bug 4968126.
3904: -- Using the Merge instead of Insert statement
3905: -- so that duplicate records dont get inserted.
3906: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3907: FORALL I in l_st..l_en
3908: MERGE INTO hz_dqm_sh_sync_interface S
3909: USING (
3910: SELECT

Line 3908: MERGE INTO hz_dqm_sh_sync_interface S

3904: -- Using the Merge instead of Insert statement
3905: -- so that duplicate records dont get inserted.
3906: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3907: FORALL I in l_st..l_en
3908: MERGE INTO hz_dqm_sh_sync_interface S
3909: USING (
3910: SELECT
3911: H_C_PARTY_ID(I) AS party_id
3912: ,H_ORG_CONTACT_ID(I) AS record_id

Line 3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3944: hz_utility_pub.creation_date,
3945: hz_utility_pub.last_update_login,
3946: hz_utility_pub.last_update_date,
3947: hz_utility_pub.user_id,
3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3949: );
3950: log ('Done');
3951: EXCEPTION WHEN OTHERS THEN
3952: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

Line 3952: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

3948: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3949: );
3950: log ('Done');
3951: EXCEPTION WHEN OTHERS THEN
3952: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3953: log ('Eror Message is - '|| sqlerrm);
3954: END;
3955: END IF;
3956:

Line 4221: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);

4217: BEGIN
4218: -- REPURI. Bug 4968126.
4219: -- Using the Merge instead of Insert statement
4220: -- so that duplicate records dont get inserted.
4221: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
4222: FORALL I in l_st..l_en
4223: MERGE INTO hz_dqm_sh_sync_interface S
4224: USING (
4225: SELECT

Line 4223: MERGE INTO hz_dqm_sh_sync_interface S

4219: -- Using the Merge instead of Insert statement
4220: -- so that duplicate records dont get inserted.
4221: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
4222: FORALL I in l_st..l_en
4223: MERGE INTO hz_dqm_sh_sync_interface S
4224: USING (
4225: SELECT
4226: H_CPT_PARTY_ID(I) AS party_id
4227: ,H_CONTACT_POINT_ID(I) AS record_id

Line 4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

4263: hz_utility_pub.creation_date,
4264: hz_utility_pub.last_update_login,
4265: hz_utility_pub.last_update_date,
4266: hz_utility_pub.user_id,
4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4268: );
4269: log ('Done');
4270: EXCEPTION WHEN OTHERS THEN
4271: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

Line 4271: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

4267: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4268: );
4269: log ('Done');
4270: EXCEPTION WHEN OTHERS THEN
4271: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
4272: log ('Eror Message is - '|| sqlerrm);
4273: END;
4274: END IF;
4275: