APPS.WSMPLBJI dependencies on WIP_ENTITIES

Line 626: select wip_entities_s.nextval

622: BEGIN
623: l_rtg_op_seq_num := p_rtg_op_seq_num;
624:
625: if (p_explode_header_detail is null) or (p_explode_header_detail = 2) then
626: select wip_entities_s.nextval
627: into p_wip_entity_id
628: from dual;
629: end if;
630:

Line 1165: INSERT INTO WIP_ENTITIES (

1161:
1162: l_stmt_num := 130;
1163: begin
1164:
1165: INSERT INTO WIP_ENTITIES (
1166: wip_entity_id,
1167: organization_id,
1168: last_update_date,
1169: last_updated_by,

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

1262:
1263: end if; -- p_explode_header_detail
1264:
1265:
1266: -- osp begin -- this has to be put after insertion into wip_entities
1267: if p_explode_header_detail is null then
1268:
1269: if p_status_type = 3 and p_po_creation_time <> wip_constants.manual_creation then
1270: if p_src_client_server = 1 then

Line 4415: from wip_entities

4411: -- Be sure the provided JOB_NAME is not already in use.
4412: begin
4413:
4414: select 1 into l_dummy
4415: from wip_entities
4416: where
4417: wip_entity_name = v_wlji_job_name(v_index) and
4418: organization_id = v_wlji_org(v_index);
4419:

Line 4455: from wip_entities

4451:
4452: begin
4453: select wip_entity_id
4454: into v_wlji_wip_entity_id(v_index)
4455: from wip_entities
4456: where
4457: wip_entity_name = v_wlji_job_name(v_index) and
4458: organization_id = v_wlji_org(v_index) ;
4459: exception when others then

Line 7226: UPDATE WIP_ENTITIES WE

7222: end if;
7223:
7224:
7225: l_stmt_num := 1074;
7226: UPDATE WIP_ENTITIES WE
7227: set description = nvl(v_wlji_description(v_index), we.description),
7228: last_updated_by = v_wlji_last_updt_by(v_index),
7229: last_update_login = v_wlji_last_updt_login(v_index),
7230: request_id = v_wlji_request_id(v_index),