APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_DQM_SH_SYNC_INTERFACE_S

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 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 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 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');