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 4409: from wip_entities

4405: -- Be sure the provided JOB_NAME is not already in use.
4406: begin
4407:
4408: select 1 into l_dummy
4409: from wip_entities
4410: where
4411: wip_entity_name = v_wlji_job_name(v_index) and
4412: organization_id = v_wlji_org(v_index);
4413:

Line 4449: from wip_entities

4445:
4446: begin
4447: select wip_entity_id
4448: into v_wlji_wip_entity_id(v_index)
4449: from wip_entities
4450: where
4451: wip_entity_name = v_wlji_job_name(v_index) and
4452: organization_id = v_wlji_org(v_index) ;
4453: exception when others then

Line 7220: UPDATE WIP_ENTITIES WE

7216: end if;
7217:
7218:
7219: l_stmt_num := 1074;
7220: UPDATE WIP_ENTITIES WE
7221: set description = nvl(v_wlji_description(v_index), we.description),
7222: last_updated_by = v_wlji_last_updt_by(v_index),
7223: last_update_login = v_wlji_last_updt_login(v_index),
7224: request_id = v_wlji_request_id(v_index),