DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_SCHEDULE_GROUPS_VAL_V

Line 716: from wip_schedule_groups_val_v sg

712: WIP_CONSTANTS.CREATE_NS_JOB)
713: and wjsi.schedule_group_id is null
714: and wjsi.schedule_group_name is not null
715: and not exists (select 1
716: from wip_schedule_groups_val_v sg
717: where sg.schedule_group_name = wjsi.schedule_group_name
718: and sg.organization_id = wjsi.organization_id)
719: returning wjsi.interface_id bulk collect into l_interfaceTbl;
720:

Line 730: from wip_schedule_groups_val_v sg

726:
727: update wip_job_schedule_interface wjsi
728: set wjsi.schedule_group_id =
729: (select sg.schedule_group_id
730: from wip_schedule_groups_val_v sg
731: where sg.schedule_group_name = wjsi.schedule_group_name
732: and sg.organization_id = wjsi.organization_id),
733: wjsi.last_update_date = sysdate
734: where wjsi.group_id = p_groupID

Line 842: from wip_schedule_groups_val_v sg

838: WIP_CONSTANTS.RESCHED_JOB,
839: WIP_CONSTANTS.CREATE_NS_JOB)
840: and wjsi.schedule_group_id is not null
841: and not exists (select 1
842: from wip_schedule_groups_val_v sg
843: where sg.schedule_group_id = wjsi.schedule_group_id
844: and sg.organization_id = wjsi.organization_id)
845: returning wjsi.interface_id bulk collect into l_interfaceTbl;
846: