DBA Data[Home] [Help]

APPS.WIP_DISCRETE_J_PKG dependencies on WIP_DISCRETE_JOBS

Line 89: CURSOR C(we_id NUMBER) IS SELECT rowid FROM WIP_DISCRETE_JOBS

85: x_serialization_start_op NUMBER := null) IS
86: /*X_Project_Costed NUMBER) IS*/
87:
88:
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;

Line 110: INSERT INTO WIP_DISCRETE_JOBS(

106: FETCH C2 INTO X_Wip_Entity_Id;
107: CLOSE C2;
108: end if;
109:
110: INSERT INTO WIP_DISCRETE_JOBS(
111: wip_entity_id,
112: organization_id,
113: last_update_date,
114: last_updated_by,

Line 425: UPDATE WIP_DISCRETE_JOBS SET

421:
422: dummy NUMBER;
423:
424: BEGIN
425: UPDATE WIP_DISCRETE_JOBS SET
426: wip_entity_id = X_Wip_Entity_Id,
427: organization_id = X_Organization_Id,
428: last_update_date = X_Last_Update_Date,
429: last_updated_by = X_Last_Updated_By,