APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_SCHEDULE_GROUPS

Line 7830: from wip_schedule_groups_val_v

7826: v_wlji_schedule_group_id(v_idx) is null then
7827: begin
7828: select schedule_group_id
7829: into v_wlji_schedule_group_id(v_idx)
7830: from wip_schedule_groups_val_v
7831: where organization_id = v_wlji_org_id(v_idx)
7832: and schedule_group_name =v_wlji_schedule_group_name(v_idx);
7833: exception
7834: when others then

Line 7854: insert into wip_schedule_groups (

7850: v_wlji_schedule_group_name(v_idx) IS NULL and
7851: v_wlji_schedule_group_id(v_idx) IS NULL)
7852: then
7853: l_stmt_num := 170.1;
7854: insert into wip_schedule_groups (
7855: schedule_group_id,
7856: schedule_group_name,
7857: organization_id,
7858: description,

Line 7863: select wip_schedule_groups_s.nextval,

7859: created_by,
7860: last_updated_by,
7861: creation_date,
7862: last_update_date)
7863: select wip_schedule_groups_s.nextval,
7864: wds.name,
7865: v_wlji_org_id(v_idx),
7866: to_char(sysdate),
7867: l_user,

Line 7875: from wip_schedule_groups wsg

7871: from wsh_new_deliveries wds
7872: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7873: and not exists (
7874: select 1
7875: from wip_schedule_groups wsg
7876: where wsg.organization_id = v_wlji_org_id(v_idx)
7877: and wsg.schedule_group_name = wds.name);
7878: l_stmt_num := 170.2;
7879: select wsg.schedule_group_name,

Line 7883: from wip_schedule_groups wsg,

7879: select wsg.schedule_group_name,
7880: wsg.schedule_group_id
7881: into v_wlji_schedule_group_name(v_idx),
7882: v_wlji_schedule_group_id(v_idx)
7883: from wip_schedule_groups wsg,
7884: wsh_new_deliveries wds
7885: where wds.delivery_id = v_wlji_delivery_id(v_idx)
7886: and wsg.schedule_group_name = wds.name
7887: and wsg.organization_id = v_wlji_org_id(v_idx);

Line 7897: from wip_schedule_groups_val_v wsg

7893: l_stmt_num := 170.3;
7894: begin
7895: select 1
7896: into l_temp_num
7897: from wip_schedule_groups_val_v wsg
7898: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_idx)
7899: and wsg.organization_id = v_wlji_org_id(v_idx);
7900: exception
7901: when too_many_rows then

Line 7966: from wip_schedule_groups_val_v

7962: begin
7963:
7964: select schedule_group_id
7965: into v_wlji_schedule_group_id(v_idx)
7966: from wip_schedule_groups_val_v
7967: where organization_id = v_wlji_org_id(v_idx)
7968: and schedule_group_name =v_wlji_schedule_group_name(v_idx);
7969:
7970: exception

Line 7992: from wip_schedule_groups_val_v wsg

7988: l_stmt_num := 170.5;
7989: begin
7990: select 1
7991: into l_temp_num
7992: from wip_schedule_groups_val_v wsg
7993: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_idx)
7994: and wsg.organization_id = v_wlji_org_id(v_idx);
7995: exception
7996: when too_many_rows then