APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_SCHEDULE_GROUPS

Line 715: from wip_schedule_groups_val_v sg

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

Line 729: from wip_schedule_groups_val_v sg

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

Line 760: from wip_schedule_groups wsg,

756: -- if still null, try to default from the delivery_id provided
757: update wip_job_schedule_interface wjsi
758: set wjsi.schedule_group_id =
759: (select wsg.schedule_group_id
760: from wip_schedule_groups wsg,
761: wsh_new_deliveries wds
762: where wds.delivery_id = wjsi.delivery_id
763: and wsg.schedule_group_name = wds.name
764: and wsg.organization_id = wjsi.organization_id),

Line 776: from wip_schedule_groups wsg,

772: and wjsi.schedule_group_id is null
773: and wjsi.source_code = 'WICDOL'
774: and wjsi.delivery_id is not null
775: and exists (select wsg.schedule_group_id
776: from wip_schedule_groups wsg,
777: wsh_new_deliveries wds
778: where wds.delivery_id = wjsi.delivery_id
779: and wsg.schedule_group_name = wds.name
780: and wsg.organization_id = wjsi.organization_id);

Line 798: select wip_schedule_groups_s.nextval into l_schedGroupID from dual;

794: and wjsi.delivery_id is not null;
795:
796: if ( l_interfaceTbl.count > 0 ) then
797: for i in 1 .. l_interfaceTbl.count loop
798: select wip_schedule_groups_s.nextval into l_schedGroupID from dual;
799: insert into wip_schedule_groups(
800: schedule_group_id,
801: schedule_group_name,
802: organization_id,

Line 799: insert into wip_schedule_groups(

795:
796: if ( l_interfaceTbl.count > 0 ) then
797: for i in 1 .. l_interfaceTbl.count loop
798: select wip_schedule_groups_s.nextval into l_schedGroupID from dual;
799: insert into wip_schedule_groups(
800: schedule_group_id,
801: schedule_group_name,
802: organization_id,
803: description,

Line 840: from wip_schedule_groups_val_v sg

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