APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_SCHEDULE_GROUPS

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 762: from wip_schedule_groups wsg,

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

Line 778: from wip_schedule_groups wsg,

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

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

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

Line 801: insert into wip_schedule_groups(

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

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: