108:
109:
110: PROCEDURE GET_STEP_MATERIAL_AVAILABILITY (P_BATCHSTEP_ID IN NUMBER,
111: X_MATERIAL_AVAILABLE OUT NOCOPY VARCHAR2,
112: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
113: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
114: X_MSG_COUNT OUT NOCOPY NUMBER,
115: X_MSG_DATA OUT NOCOPY VARCHAR2);
116:
183: -- Type : Private Utility.
184: -- Function : lock the step for the user
185: -- Pre-reqs : None.
186: -- Parameters :
187: -- IN : p_batchstep_id in fnd_table_of_varchar2_255
188: -- p_requestor in number
189: -- OUT : x_return_status out varchar2
190: -- x_msg_count out number
191: -- x_msg_data out varchar2
191: -- x_msg_data out varchar2
192: -- End of comments
193:
194:
195: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
196: P_REQUESTER IN NUMBER,
197: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
198: X_MSG_COUNT OUT NOCOPY NUMBER,
199: X_MSG_DATA OUT NOCOPY VARCHAR2);
229: -- Type : Private Utility.
230: -- Function : unlock the step for the user
231: -- Pre-reqs : None.
232: -- Parameters :
233: -- IN : p_batchstep_id in fnd_table_of_varchar2_255
234: -- p_requestor in number
235: -- OUT : x_return_status out varchar2
236: -- x_msg_count out number
237: -- x_msg_data out varchar2
236: -- x_msg_count out number
237: -- x_msg_data out varchar2
238: -- End of comments
239:
240: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
241: P_REQUESTER IN NUMBER,
242: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
243: X_MSG_COUNT OUT NOCOPY NUMBER,
244: X_MSG_DATA OUT NOCOPY VARCHAR2);
420: P_TASK IN VARCHAR2,
421: P_TASK_ATTRIBUTE IN VARCHAR2,
422: P_INSTRUCTION_ID IN NUMBER ,
423: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
424: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
425: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
426: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
427: P_REQUESTER IN NUMBER,
428: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
421: P_TASK_ATTRIBUTE IN VARCHAR2,
422: P_INSTRUCTION_ID IN NUMBER ,
423: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
424: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
425: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
426: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
427: P_REQUESTER IN NUMBER,
428: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
429: X_MSG_COUNT OUT NOCOPY NUMBER,
422: P_INSTRUCTION_ID IN NUMBER ,
423: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
424: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
425: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
426: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
427: P_REQUESTER IN NUMBER,
428: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
429: X_MSG_COUNT OUT NOCOPY NUMBER,
430: X_MSG_DATA OUT NOCOPY VARCHAR2
468: -- Function : Get batch step nodes
469: -- Pre-reqs : None
470: -- IN : P_BATCH_ID in number
471: -- P_BATCHSTEP_ID in number
472: -- OUT : x_name out fnd_table_of_varchar2_255
473: -- x_entity_name out fnd_table_of_varchar2_255
474: -- x_entity_key out fnd_table_of_varchar2_255
475: -- x_entity_level out fnd_table_of_varchar2_255
476: -- x_return_status out varchar2
469: -- Pre-reqs : None
470: -- IN : P_BATCH_ID in number
471: -- P_BATCHSTEP_ID in number
472: -- OUT : x_name out fnd_table_of_varchar2_255
473: -- x_entity_name out fnd_table_of_varchar2_255
474: -- x_entity_key out fnd_table_of_varchar2_255
475: -- x_entity_level out fnd_table_of_varchar2_255
476: -- x_return_status out varchar2
477: -- x_msg_count out number
470: -- IN : P_BATCH_ID in number
471: -- P_BATCHSTEP_ID in number
472: -- OUT : x_name out fnd_table_of_varchar2_255
473: -- x_entity_name out fnd_table_of_varchar2_255
474: -- x_entity_key out fnd_table_of_varchar2_255
475: -- x_entity_level out fnd_table_of_varchar2_255
476: -- x_return_status out varchar2
477: -- x_msg_count out number
478: -- x_msg_data out varchar2
471: -- P_BATCHSTEP_ID in number
472: -- OUT : x_name out fnd_table_of_varchar2_255
473: -- x_entity_name out fnd_table_of_varchar2_255
474: -- x_entity_key out fnd_table_of_varchar2_255
475: -- x_entity_level out fnd_table_of_varchar2_255
476: -- x_return_status out varchar2
477: -- x_msg_count out number
478: -- x_msg_data out varchar2
479: -- End of comments
479: -- End of comments
480:
481: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
482: P_BATCHSTEP_ID IN NUMBER,
483: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
484: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
485: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
486: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
487: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
480:
481: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
482: P_BATCHSTEP_ID IN NUMBER,
483: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
484: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
485: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
486: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
487: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
488: X_MSG_COUNT OUT NOCOPY NUMBER,
481: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
482: P_BATCHSTEP_ID IN NUMBER,
483: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
484: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
485: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
486: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
487: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
488: X_MSG_COUNT OUT NOCOPY NUMBER,
489: X_MSG_DATA OUT NOCOPY VARCHAR2);
482: P_BATCHSTEP_ID IN NUMBER,
483: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
484: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
485: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
486: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
487: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
488: X_MSG_COUNT OUT NOCOPY NUMBER,
489: X_MSG_DATA OUT NOCOPY VARCHAR2);
490: --Bug 5224634: end