APPS.WSMPDJOB dependencies on WIP_ENTITIES

Line 94: -- CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL; perf. tuning, abb

90: FROM WIP_DISCRETE_JOBS
91: WHERE wip_entity_id = we_id
92: AND organization_id = X_Organization_Id;
93:
94: -- CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL; perf. tuning, abb
95:
96: CURSOR C3(we_id NUMBER) IS
97: SELECT rowid
98: FROM WIP_ENTITIES

Line 98: FROM WIP_ENTITIES

94: -- CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL; perf. tuning, abb
95:
96: CURSOR C3(we_id NUMBER) IS
97: SELECT rowid
98: FROM WIP_ENTITIES
99: WHERE wip_entity_id = we_id
100: AND organization_id = X_Organization_Id;
101:
102: -- Begin WSM Customization

Line 212: decode(X_wip_entity_id, NULL, wip_entities_s.nextval, X_wip_entity_id),

208: coproducts_supply
209: -- End WSM Customization
210: ) VALUES (
211: -- X_wip_entity_id, abedajna, perf.tuning
212: decode(X_wip_entity_id, NULL, wip_entities_s.nextval, X_wip_entity_id),
213: X_organization_id,
214: X_last_update_date,
215: X_last_updated_by,
216: X_creation_date,

Line 305: INSERT INTO WIP_ENTITIES(

301: end if;
302: CLOSE C;
303: l_stat_num := 50;
304:
305: INSERT INTO WIP_ENTITIES(
306: wip_entity_id,
307: organization_id,
308: last_update_date,
309: last_updated_by,

Line 419: X_Update_Wip_Entities VARCHAR2,

415: X_We_Rowid IN OUT NOCOPY VARCHAR2,
416: X_end_item_unit_number VARCHAR2,
417: X_Entity_Type NUMBER,
418: X_Wip_Entity_Name VARCHAR2,
419: X_Update_Wip_Entities VARCHAR2,
420: X_Schedule_Group_Id NUMBER,
421: X_Build_Sequence NUMBER,
422: X_Line_Id NUMBER,
423: X_Project_Id NUMBER,

Line 434: FROM WIP_ENTITIES

430: ) IS
431:
432: CURSOR C3(we_id NUMBER) IS
433: SELECT rowid
434: FROM WIP_ENTITIES
435: WHERE wip_entity_id = we_id
436: AND organization_id = X_Organization_Id;
437:
438: dummy NUMBER;

Line 526: FROM wip_entities

522: end if;
523:
524: l_stat_num := 30;
525: SELECT count(*) into dummy
526: FROM wip_entities
527: WHERE wip_entity_id = X_Wip_Entity_id;
528:
529: l_stat_num := 40;
530: if dummy = 0 then

Line 531: INSERT INTO WIP_ENTITIES(

527: WHERE wip_entity_id = X_Wip_Entity_id;
528:
529: l_stat_num := 40;
530: if dummy = 0 then
531: INSERT INTO WIP_ENTITIES(
532: wip_entity_id,
533: organization_id,
534: last_update_date,
535: last_updated_by,

Line 558: IF X_Update_Wip_Entities = 'Y' THEN

554: X_Description,
555: X_Primary_Item_Id,
556: MTL_GEN_OBJECT_ID_S.nextval);
557: else
558: IF X_Update_Wip_Entities = 'Y' THEN
559: l_stat_num := 50;
560: OPEN C3(X_Wip_Entity_Id);
561: FETCH C3 INTO X_We_Rowid;
562: if (C3%NOTFOUND) then

Line 569: UPDATE WIP_ENTITIES

565: end if;
566: CLOSE C3;
567:
568: l_stat_num := 60;
569: UPDATE WIP_ENTITIES
570: SET
571: wip_entity_id = X_Wip_Entity_Id,
572: organization_id = X_Organization_Id,
573: last_update_date = X_Last_Update_Date,