APPS.EAM_OPERATIONS_PKG dependencies on STANDARD

Line 15: X_Standard_Operation_Id NUMBER,

11: X_Creation_Date DATE,
12: X_Created_By NUMBER,
13: X_Last_Update_Login NUMBER,
14: X_Operation_Sequence_Id NUMBER,
15: X_Standard_Operation_Id NUMBER,
16: X_Department_Id NUMBER,
17: X_Shutdown_Type VARCHAR2,
18: X_Operation_Completed VARCHAR2,
19: X_Description VARCHAR2,

Line 65: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);

61: x_login_id number := FND_GLOBAL.LOGIN_ID;
62: x_request_id number := FND_GLOBAL.CONC_REQUEST_ID;
63: x_appl_id number := FND_GLOBAL.PROG_APPL_ID;
64: x_program_id number := FND_GLOBAL.CONC_PROGRAM_ID;
65: x_standard_op boolean := (X_Standard_Operation_Id is NOT NULL);
66:
67: l_return_status VARCHAR2(1);
68: l_msg_count NUMBER;
69: l_msg_data VARCHAR2(1000);

Line 124: l_eam_op_rec.STANDARD_OPERATION_ID := X_Standard_Operation_Id;

120: l_eam_op_rec.BATCH_ID := 1;
121: l_eam_op_rec.WIP_ENTITY_ID := X_Wip_Entity_Id;
122: l_eam_op_rec.ORGANIZATION_ID := X_Organization_Id;
123: l_eam_op_rec.OPERATION_SEQ_NUM := X_Operation_Seq_Num;
124: l_eam_op_rec.STANDARD_OPERATION_ID := X_Standard_Operation_Id;
125: l_eam_op_rec.DEPARTMENT_ID := X_Department_Id;
126: l_eam_op_rec.OPERATION_SEQUENCE_ID := X_Operation_Sequence_Id;
127: l_eam_op_rec.DESCRIPTION := X_Description;
128: l_eam_op_rec.MINIMUM_TRANSFER_QUANTITY := X_Minimum_Transfer_Quantity;

Line 230: X_Standard_Operation_Id NUMBER,

226: X_Last_Update_Date DATE,
227: X_Last_Updated_By NUMBER,
228: X_Last_Update_Login NUMBER,
229: X_Operation_Sequence_Id NUMBER,
230: X_Standard_Operation_Id NUMBER,
231: X_Department_Id NUMBER,
232: X_Shutdown_Type VARCHAR2,
233: X_Operation_Completed VARCHAR2,
234: X_Description VARCHAR2,

Line 323: l_eam_op_rec.STANDARD_OPERATION_ID := X_Standard_Operation_Id;

319: l_eam_op_rec.BATCH_ID := 1;
320: l_eam_op_rec.WIP_ENTITY_ID := X_Wip_Entity_Id;
321: l_eam_op_rec.ORGANIZATION_ID := X_Organization_Id;
322: l_eam_op_rec.OPERATION_SEQ_NUM := X_Operation_Seq_Num;
323: l_eam_op_rec.STANDARD_OPERATION_ID := X_Standard_Operation_Id;
324: l_eam_op_rec.DEPARTMENT_ID := X_Department_Id;
325: l_eam_op_rec.OPERATION_SEQUENCE_ID := X_Operation_Sequence_Id;
326: l_eam_op_rec.DESCRIPTION := X_Description;
327: l_eam_op_rec.SHUTDOWN_TYPE := X_Shutdown_Type;

Line 424: X_Standard_Operation_Id NUMBER,

420: X_Wip_Entity_Id NUMBER,
421: X_Operation_Seq_Num NUMBER,
422: X_Organization_Id NUMBER,
423: X_Operation_Sequence_Id NUMBER,
424: X_Standard_Operation_Id NUMBER,
425: X_Department_Id NUMBER,
426: X_Shutdown_Type VARCHAR2,
427: X_Operation_Completed VARCHAR2,
428: X_Description VARCHAR2,

Line 475: AND (nvl(Recinfo.standard_operation_id, 1) =

471: AND (Recinfo.operation_seq_num = X_Operation_Seq_Num)
472: AND (Recinfo.organization_id = X_Organization_Id)
473: AND (nvl(Recinfo.operation_sequence_id, 1) =
474: nvl(X_Operation_Sequence_Id, 1))
475: AND (nvl(Recinfo.standard_operation_id, 1) =
476: nvl(X_Standard_Operation_Id, 1))
477: AND (Recinfo.department_id = X_Department_Id)
478: AND (nvl(Recinfo.shutdown_type, 'xxx') =
479: nvl(X_Shutdown_Type,'xxx'))

Line 476: nvl(X_Standard_Operation_Id, 1))

472: AND (Recinfo.organization_id = X_Organization_Id)
473: AND (nvl(Recinfo.operation_sequence_id, 1) =
474: nvl(X_Operation_Sequence_Id, 1))
475: AND (nvl(Recinfo.standard_operation_id, 1) =
476: nvl(X_Standard_Operation_Id, 1))
477: AND (Recinfo.department_id = X_Department_Id)
478: AND (nvl(Recinfo.shutdown_type, 'xxx') =
479: nvl(X_Shutdown_Type,'xxx'))
480: AND (Recinfo.operation_completed = X_Operation_Completed or