APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_DQM_SH_SYNC_INTERFACE_S

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