APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_ENTITIES

Line 1087: from wip_entities

1083: begin
1084: l_stmt_num := 30;
1085: select 1
1086: into l_temp_num
1087: from wip_entities
1088: where wip_entity_name = p_job_name
1089: and organization_id = p_org_id;
1090: if l_temp_num = 1 then
1091: fnd_message.set_name('WIP','WIP_ML_JOB_NAME');

Line 1129: from wip_entities

1125: l_stmt_num := 40;
1126: -- Get wip_entity_id by wip_entity_name
1127: select wip_entity_id
1128: into p_wip_entity_id
1129: from wip_entities
1130: where wip_entity_name = p_job_name
1131: and organization_id = p_org_id;
1132: exception
1133: when others then

Line 1154: wip_entities we

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

Line 1179: from wip_entities

1175: l_temp_num := 0;
1176: begin
1177: select count(wip_entity_id)
1178: into l_temp_num
1179: from wip_entities
1180: where wip_entity_name = p_job_name
1181: and organization_id = p_org_id
1182: and wip_entity_id <> p_wip_entity_id;
1183:

Line 7594: from wip_entities

7590: l_stmt_num := 140.1;
7591: -- Get wip_entity_id by wip_entity_name
7592: select wip_entity_id
7593: into v_wlji_wip_entity_id(v_idx)
7594: from wip_entities
7595: where wip_entity_name = v_wlji_job_name(v_idx)
7596: and organization_id = v_wlji_org_id(v_idx);
7597: exception
7598: when others then

Line 7610: wip_entities we

7606: -- For unreleased jobs allow job name update if wip_entity_id is not null - fix for bug5990761
7607: select decode(wdj.status_type, WIP_CONSTANTS.UNRELEASED, NVL(v_wlji_job_name(v_idx),we.wip_entity_name), we.wip_entity_name)
7608: into v_wlji_job_name(v_idx)
7609: from wip_discrete_jobs wdj,
7610: wip_entities we
7611: where wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
7612: and wdj.status_type in (
7613: WIP_CONSTANTS.UNRELEASED,
7614: WIP_CONSTANTS.RELEASED,

Line 11461: UPDATE WIP_ENTITIES WE

11457: fnd_file.put_line(fnd_file.log,
11458: 'Updated '||SQL%ROWCOUNT||' rows of wdj');
11459: end if;
11460: l_stmt_num := 970.2;
11461: UPDATE WIP_ENTITIES WE
11462: set description = nvl(v_wlji_description(v_idx), we.description),
11463: wip_entity_name = decode(nvl(v_wlji_status_type(v_idx),-1),7,wip_entity_name,
11464: decode(l_cur_status_type,1, v_wlji_job_name(v_idx),wip_entity_name)), --fix for bug5990761
11465: last_updated_by = v_wlji_last_updt_by(v_idx),

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

21488: -- End R12Dev
21489: --
21490:
21491: -- bug 3311985: osp code moved from build_job_header_info
21492: -- osp begin -- this has to be put after insertion into wip_entities
21493: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
21494: if p_src_client_server = 1 then
21495: l_stmt_num := 130;
21496: if wsmputil.check_osp_operation(p_wip_entity_id, l_job_op_seq_num, p_org_id) then

Line 21648: select wip_entities_s.nextval

21644:
21645:
21646: l_stmt_num := 100;
21647: -- get a new wip entity id
21648: select wip_entities_s.nextval
21649: into p_wip_entity_id
21650: from dual;
21651:
21652:

Line 21927: insert into wip_entities (

21923: l_stmt_num := 140;
21924: -- insert into WE
21925: /* Added for bug 6861458.*/
21926: begin
21927: insert into wip_entities (
21928: wip_entity_id,
21929: organization_id,
21930: last_update_date,
21931: last_updated_by,