APPS.WSMPLBJI dependencies on WIP_SCHEDULE_GROUPS

Line 5308: insert into wip_schedule_groups (

5304: end if;
5305:
5306: if (v_wlji_source_code(v_index) = 'WICDOL' and v_wlji_schedule_group_name(v_index) IS NULL
5307: and v_wlji_schedule_group_id(v_index) IS NULL) then
5308: insert into wip_schedule_groups (
5309: schedule_group_id,
5310: schedule_group_name,
5311: organization_id,
5312: description,

Line 5317: select wip_schedule_groups_s.nextval,

5313: created_by,
5314: last_updated_by,
5315: creation_date,
5316: last_update_date)
5317: select wip_schedule_groups_s.nextval,
5318: wds.name,
5319: v_wlji_org(v_index),
5320: to_char(sysdate),
5321: l_user,

Line 5329: from wip_schedule_groups wsg

5325: from wsh_new_deliveries wds
5326: where wds.delivery_id = v_wlji_delivery_id(v_index)
5327: and not exists (
5328: select 1
5329: from wip_schedule_groups wsg
5330: where wsg.organization_id = v_wlji_org(v_index)
5331: and WSG.schedule_group_name = WDS.name);
5332:
5333: select wsg.schedule_group_name, wsg.schedule_group_id

Line 5335: from wip_schedule_groups wsg,

5331: and WSG.schedule_group_name = WDS.name);
5332:
5333: select wsg.schedule_group_name, wsg.schedule_group_id
5334: into v_wlji_schedule_group_name(v_index), v_wlji_schedule_group_id(v_index)
5335: from wip_schedule_groups wsg,
5336: wsh_new_deliveries wds
5337: where wds.delivery_id = v_wlji_delivery_id(v_index)
5338: and wsg.schedule_group_name = wds.name
5339: and wsg.organization_id = v_wlji_org(v_index);

Line 5345: from wip_schedule_groups_val_v wsg

5341:
5342: if ((v_wlji_schedule_group_id(v_index) is not NULL) and (v_wlji_load_type(v_index) in (5,6))) then
5343: begin
5344: select 1 into l_dummy
5345: from wip_schedule_groups_val_v wsg
5346: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_index)
5347: and wsg.organization_id = v_wlji_org(v_index);
5348: exception
5349: when too_many_rows then