APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_ENTITIES

Line 1082: from wip_entities

1078: begin
1079: l_stmt_num := 30;
1080: select 1
1081: into l_temp_num
1082: from wip_entities
1083: where wip_entity_name = p_job_name
1084: and organization_id = p_org_id;
1085: if l_temp_num = 1 then
1086: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');

Line 1124: from wip_entities

1120: l_stmt_num := 40;
1121: -- Get wip_entity_id by wip_entity_name
1122: select wip_entity_id
1123: into p_wip_entity_id
1124: from wip_entities
1125: where wip_entity_name = p_job_name
1126: and organization_id = p_org_id;
1127: exception
1128: when others then

Line 1149: wip_entities we

1145: --fix for bug5990761 allow update of job name for unreleased jobs
1146: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED,NVL(p_job_name,we.wip_entity_name),we.wip_entity_name),we.wip_entity_name
1147: into p_job_name,l_old_job_name
1148: from wip_discrete_jobs wdj,
1149: wip_entities we
1150: where wdj.wip_entity_id = p_wip_entity_id
1151: and wdj.status_type in (
1152: WIP_CONSTANTS.UNRELEASED,
1153: WIP_CONSTANTS.RELEASED,

Line 1174: from wip_entities

1170: l_temp_num := 0;
1171: begin
1172: select count(wip_entity_id)
1173: into l_temp_num
1174: from wip_entities
1175: where wip_entity_name = p_job_name
1176: and organization_id = p_org_id
1177: and wip_entity_id <> p_wip_entity_id;
1178:

Line 7578: from wip_entities

7574: l_stmt_num := 140.1;
7575: -- Get wip_entity_id by wip_entity_name
7576: select wip_entity_id
7577: into v_wlji_wip_entity_id(v_idx)
7578: from wip_entities
7579: where wip_entity_name = v_wlji_job_name(v_idx)
7580: and organization_id = v_wlji_org_id(v_idx);
7581: exception
7582: when others then

Line 7594: wip_entities we

7590: -- For unreleased jobs allow job name update if wip_entity_id is not null - fix for bug5990761
7591: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED, NVL(v_wlji_job_name(v_idx),we.wip_entity_name), we.wip_entity_name)
7592: into v_wlji_job_name(v_idx)
7593: from wip_discrete_jobs wdj,
7594: wip_entities we
7595: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
7596: and wdj.status_type in (
7597: WIP_CONSTANTS.UNRELEASED,
7598: WIP_CONSTANTS.RELEASED,

Line 11358: UPDATE WIP_ENTITIES WE

11354: fnd_file.put_line(fnd_file.log,
11355: 'Updated '||SQL%ROWCOUNT||' rows of wdj');
11356: end if;
11357: l_stmt_num := 970.2;
11358: UPDATE WIP_ENTITIES WE
11359: set description = nvl(v_wlji_description(v_idx), we.description),
11360: wip_entity_name = decode(nvl(v_wlji_status_type(v_idx),-1),7,wip_entity_name,
11361: decode(l_cur_status_type,1, v_wlji_job_name(v_idx),wip_entity_name)), --fix for bug5990761
11362: last_updated_by = v_wlji_last_updt_by(v_idx),

Line 20827: -- osp begin -- this has to be put after insertion into wip_entities

20823: -- End R12Dev
20824: --
20825:
20826: -- bug 3311985: osp code moved from build_job_header_info
20827: -- osp begin -- this has to be put after insertion into wip_entities
20828: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
20829: if p_src_client_server = 1 then
20830: l_stmt_num := 130;
20831: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then

Line 20983: select wip_entities_s.nextval

20979:
20980:
20981: l_stmt_num := 100;
20982: -- get a new wip entity id
20983: select wip_entities_s.nextval
20984: into p_wip_entity_id
20985: from dual;
20986:
20987:

Line 21261: insert into wip_entities (

21257: l_stmt_num := 140;
21258: -- insert into WE
21259: /* Added for bug 6861458.*/
21260: begin
21261: insert into wip_entities (
21262: wip_entity_id,
21263: organization_id,
21264: last_update_date,
21265: last_updated_by,