APPS.WSMPLBJI dependencies on WIP_SCHEDULE_GROUPS

Line 5314: insert into wip_schedule_groups (

5310: end if;
5311:
5312: if (v_wlji_source_code(v_index) = 'WICDOL' and v_wlji_schedule_group_name(v_index) IS NULL
5313: and v_wlji_schedule_group_id(v_index) IS NULL) then
5314: insert into wip_schedule_groups (
5315: schedule_group_id,
5316: schedule_group_name,
5317: organization_id,
5318: description,

Line 5323: select wip_schedule_groups_s.nextval,

5319: created_by,
5320: last_updated_by,
5321: creation_date,
5322: last_update_date)
5323: select wip_schedule_groups_s.nextval,
5324: wds.name,
5325: v_wlji_org(v_index),
5326: to_char(sysdate),
5327: l_user,

Line 5335: from wip_schedule_groups wsg

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

Line 5341: from wip_schedule_groups wsg,

5337: and WSG.schedule_group_name = WDS.name);
5338:
5339: select wsg.schedule_group_name, wsg.schedule_group_id
5340: into v_wlji_schedule_group_name(v_index), v_wlji_schedule_group_id(v_index)
5341: from wip_schedule_groups wsg,
5342: wsh_new_deliveries wds
5343: where wds.delivery_id = v_wlji_delivery_id(v_index)
5344: and wsg.schedule_group_name = wds.name
5345: and wsg.organization_id = v_wlji_org(v_index);

Line 5351: from wip_schedule_groups_val_v wsg

5347:
5348: if ((v_wlji_schedule_group_id(v_index) is not NULL) and (v_wlji_load_type(v_index) in (5,6))) then
5349: begin
5350: select 1 into l_dummy
5351: from wip_schedule_groups_val_v wsg
5352: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_index)
5353: and wsg.organization_id = v_wlji_org(v_index);
5354: exception
5355: when too_many_rows then