APPS.WIP_DISCRETE_J_PKG dependencies on WIP_ENTITIES

Line 93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;

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

Line 95: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES

91: AND organization_id = X_Organization_Id;
92:
93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;
94:
95: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
96: WHERE wip_entity_id = we_id
97: AND organization_id = X_Organization_Id;
98:
99: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;

Line 293: INSERT INTO WIP_ENTITIES(

289: Raise NO_DATA_FOUND;
290: end if;
291: CLOSE C4;
292:
293: INSERT INTO WIP_ENTITIES(
294: wip_entity_id,
295: organization_id,
296: last_update_date,
297: last_updated_by,

Line 400: X_Update_Wip_Entities VARCHAR2,

396: X_We_Rowid IN OUT NOCOPY VARCHAR2,
397: X_end_item_unit_number VARCHAR2,
398: X_Entity_Type NUMBER,
399: X_Wip_Entity_Name VARCHAR2,
400: X_Update_Wip_Entities VARCHAR2,
401: X_Schedule_Group_Id NUMBER,
402: X_Build_Sequence NUMBER,
403: X_Line_Id NUMBER,
404: X_Project_Id NUMBER,

Line 414: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES

410: X_requested_start_date DATE,
411: x_serialization_start_op NUMBER := null) IS
412: /*X_Project_Costed NUMBER) IS*/
413:
414: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
415: WHERE wip_entity_id = we_id
416: AND organization_id = X_Organization_Id;
417:
418: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;

Line 515: FROM wip_entities

511: Raise NO_DATA_FOUND;
512: end if;
513:
514: SELECT count(*) into dummy
515: FROM wip_entities
516: WHERE wip_entity_id = X_Wip_Entity_id;
517:
518: OPEN C4;
519: FETCH C4 INTO X_Gen_Object_Id;

Line 527: INSERT INTO WIP_ENTITIES(

523: end if;
524: CLOSE C4;
525:
526: if dummy = 0 then
527: INSERT INTO WIP_ENTITIES(
528: wip_entity_id,
529: organization_id,
530: last_update_date,
531: last_updated_by,

Line 563: IF X_Update_Wip_Entities = 'Y' THEN

559: end if;
560: CLOSE C3;
561: else
562:
563: IF X_Update_Wip_Entities = 'Y' THEN
564: UPDATE WIP_ENTITIES SET
565: wip_entity_id = X_Wip_Entity_Id,
566: organization_id = X_Organization_Id,
567: last_update_date = X_Last_Update_Date,

Line 564: UPDATE WIP_ENTITIES SET

560: CLOSE C3;
561: else
562:
563: IF X_Update_Wip_Entities = 'Y' THEN
564: UPDATE WIP_ENTITIES SET
565: wip_entity_id = X_Wip_Entity_Id,
566: organization_id = X_Organization_Id,
567: last_update_date = X_Last_Update_Date,
568: last_updated_by = X_Last_Updated_By,