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 1392: -- insert a record into hz_dqm_sh_sync_interface table for each record

1388: END IF;
1389: END LOOP;
1390:
1391: -- REPURI. Bug 4884742. If shadow staging is completely successfully
1392: -- insert a record into hz_dqm_sh_sync_interface table for each record
1393: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
1394: BEGIN
1395: HZ_DQM_SYNC.insert_sh_interface_rec(p_party_id,null,null,null,'PARTY',p_operation);
1396: EXCEPTION WHEN OTHERS THEN

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

1785: ,CONCAT_COL = CONCAT_COL
1786: WHERE PARTY_ID = H_PARTY_ID(1);
1787:
1788: -- REPURI. Bug 4884742. If shadow staging is completely successfully
1789: -- insert a record into hz_dqm_sh_sync_interface table for each record
1790: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
1791: BEGIN
1792: HZ_DQM_SYNC.insert_sh_interface_rec(l_party_id,p_org_contact_id,null,null,'CONTACTS',p_operation);
1793: EXCEPTION WHEN OTHERS THEN

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

2339: ,CONCAT_COL = CONCAT_COL
2340: WHERE PARTY_ID = H_PARTY_ID(1);
2341:
2342: -- REPURI. Bug 4884742. If shadow staging is completely successfully
2343: -- insert a record into hz_dqm_sh_sync_interface table for each record
2344: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
2345: BEGIN
2346: 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);
2347: EXCEPTION WHEN OTHERS THEN

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

2957: ,CONCAT_COL = CONCAT_COL
2958: WHERE PARTY_ID = H_PARTY_ID(1);
2959:
2960: -- REPURI. Bug 4884742. If shadow staging is completely successfully
2961: -- insert a record into hz_dqm_sh_sync_interface table for each record
2962: IF (HZ_DQM_SYNC.is_shadow_staging_complete) THEN
2963: BEGIN
2964: HZ_DQM_SYNC.insert_sh_interface_rec(l_party_id,p_party_site_id,null,l_org_contact_id,'PARTY_SITES',p_operation);
2965: EXCEPTION WHEN OTHERS THEN

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

3314: BEGIN
3315: -- REPURI. Bug 4968126.
3316: -- Using the Merge instead of Insert statement
3317: -- so that duplicate records dont get inserted.
3318: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3319: FORALL I in l_st..l_en
3320: MERGE INTO hz_dqm_sh_sync_interface S
3321: USING (
3322: SELECT

Line 3320: MERGE INTO hz_dqm_sh_sync_interface S

3316: -- Using the Merge instead of Insert statement
3317: -- so that duplicate records dont get inserted.
3318: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3319: FORALL I in l_st..l_en
3320: MERGE INTO hz_dqm_sh_sync_interface S
3321: USING (
3322: SELECT
3323: H_P_PARTY_ID(I) AS party_id
3324: FROM dual ) T

Line 3358: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3354: hz_utility_pub.creation_date,
3355: hz_utility_pub.last_update_login,
3356: hz_utility_pub.last_update_date,
3357: hz_utility_pub.user_id,
3358: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3359: );
3360: log ('Done');
3361: EXCEPTION WHEN OTHERS THEN
3362: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

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

3358: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3359: );
3360: log ('Done');
3361: EXCEPTION WHEN OTHERS THEN
3362: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3363: log ('Eror Message is - '|| sqlerrm);
3364: END;
3365: END IF;
3366:

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

3652: BEGIN
3653: -- REPURI. Bug 4968126.
3654: -- Using the Merge instead of Insert statement
3655: -- so that duplicate records dont get inserted.
3656: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3657: FORALL I in l_st..l_en
3658: MERGE INTO hz_dqm_sh_sync_interface S
3659: USING (
3660: SELECT

Line 3658: MERGE INTO hz_dqm_sh_sync_interface S

3654: -- Using the Merge instead of Insert statement
3655: -- so that duplicate records dont get inserted.
3656: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3657: FORALL I in l_st..l_en
3658: MERGE INTO hz_dqm_sh_sync_interface S
3659: USING (
3660: SELECT
3661: H_PS_PARTY_ID(I) AS party_id
3662: ,H_PARTY_SITE_ID(I) AS record_id

Line 3700: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3696: hz_utility_pub.creation_date,
3697: hz_utility_pub.last_update_login,
3698: hz_utility_pub.last_update_date,
3699: hz_utility_pub.user_id,
3700: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3701: );
3702: log ('Done');
3703: EXCEPTION WHEN OTHERS THEN
3704: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

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

3700: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3701: );
3702: log ('Done');
3703: EXCEPTION WHEN OTHERS THEN
3704: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3705: log ('Eror Message is - '|| sqlerrm);
3706: END;
3707: END IF;
3708:

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

3928: BEGIN
3929: -- REPURI. Bug 4968126.
3930: -- Using the Merge instead of Insert statement
3931: -- so that duplicate records dont get inserted.
3932: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3933: FORALL I in l_st..l_en
3934: MERGE INTO hz_dqm_sh_sync_interface S
3935: USING (
3936: SELECT

Line 3934: MERGE INTO hz_dqm_sh_sync_interface S

3930: -- Using the Merge instead of Insert statement
3931: -- so that duplicate records dont get inserted.
3932: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
3933: FORALL I in l_st..l_en
3934: MERGE INTO hz_dqm_sh_sync_interface S
3935: USING (
3936: SELECT
3937: H_C_PARTY_ID(I) AS party_id
3938: ,H_ORG_CONTACT_ID(I) AS record_id

Line 3974: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

3970: hz_utility_pub.creation_date,
3971: hz_utility_pub.last_update_login,
3972: hz_utility_pub.last_update_date,
3973: hz_utility_pub.user_id,
3974: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3975: );
3976: log ('Done');
3977: EXCEPTION WHEN OTHERS THEN
3978: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

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

3974: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
3975: );
3976: log ('Done');
3977: EXCEPTION WHEN OTHERS THEN
3978: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
3979: log ('Eror Message is - '|| sqlerrm);
3980: END;
3981: END IF;
3982:

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

4243: BEGIN
4244: -- REPURI. Bug 4968126.
4245: -- Using the Merge instead of Insert statement
4246: -- so that duplicate records dont get inserted.
4247: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
4248: FORALL I in l_st..l_en
4249: MERGE INTO hz_dqm_sh_sync_interface S
4250: USING (
4251: SELECT

Line 4249: MERGE INTO hz_dqm_sh_sync_interface S

4245: -- Using the Merge instead of Insert statement
4246: -- so that duplicate records dont get inserted.
4247: log ('Merging data into HZ_DQM_SH_SYNC_INTERFACE...',FALSE);
4248: FORALL I in l_st..l_en
4249: MERGE INTO hz_dqm_sh_sync_interface S
4250: USING (
4251: SELECT
4252: H_CPT_PARTY_ID(I) AS party_id
4253: ,H_CONTACT_POINT_ID(I) AS record_id

Line 4293: HZ_DQM_SH_SYNC_INTERFACE_S.nextval

4289: hz_utility_pub.creation_date,
4290: hz_utility_pub.last_update_login,
4291: hz_utility_pub.last_update_date,
4292: hz_utility_pub.user_id,
4293: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4294: );
4295: log ('Done');
4296: EXCEPTION WHEN OTHERS THEN
4297: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');

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

4293: HZ_DQM_SH_SYNC_INTERFACE_S.nextval
4294: );
4295: log ('Done');
4296: EXCEPTION WHEN OTHERS THEN
4297: log ('Exception occured while inserting data into HZ_DQM_SH_SYNC_INTERFACE Table');
4298: log ('Eror Message is - '|| sqlerrm);
4299: END;
4300: END IF;
4301: