APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_SCHEDULE_GROUPS

Line 7817: insert into wip_schedule_groups (

7813: v_wlji_schedule_group_name(v_idx) IS NULL and
7814: v_wlji_schedule_group_id(v_idx) IS NULL)
7815: then
7816: l_stmt_num := 170.1;
7817: insert into wip_schedule_groups (
7818: schedule_group_id,
7819: schedule_group_name,
7820: organization_id,
7821: description,

Line 7826: select wip_schedule_groups_s.nextval,

7822: created_by,
7823: last_updated_by,
7824: creation_date,
7825: last_update_date)
7826: select wip_schedule_groups_s.nextval,
7827: wds.name,
7828: v_wlji_org_id(v_idx),
7829: to_char(sysdate),
7830: l_user,

Line 7838: from wip_schedule_groups wsg

7834: from wsh_new_deliveries wds
7835: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7836: and not exists (
7837: select 1
7838: from wip_schedule_groups wsg
7839: where wsg.organization_id = v_wlji_org_id(v_idx)
7840: and wsg.schedule_group_name = wds.name);
7841: l_stmt_num := 170.2;
7842: select wsg.schedule_group_name,

Line 7846: from wip_schedule_groups wsg,

7842: select wsg.schedule_group_name,
7843: wsg.schedule_group_id
7844: into v_wlji_schedule_group_name(v_idx),
7845: v_wlji_schedule_group_id(v_idx)
7846: from wip_schedule_groups wsg,
7847: wsh_new_deliveries wds
7848: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7849: and wsg.schedule_group_name = wds.name
7850: and wsg.organization_id = v_wlji_org_id(v_idx);

Line 7858: from wip_schedule_groups_val_v wsg

7854: l_stmt_num := 170.3;
7855: begin
7856: select 1
7857: into l_temp_num
7858: from wip_schedule_groups_val_v wsg
7859: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_idx)
7860: and wsg.organization_id = v_wlji_org_id(v_idx);
7861: exception
7862: when too_many_rows then