90:
91:
92: PROCEDURE GET_STEP_MATERIAL_AVAILABILITY (P_BATCHSTEP_ID IN NUMBER,
93: X_MATERIAL_AVAILABLE OUT NOCOPY VARCHAR2,
94: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
95: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
96: X_MSG_COUNT OUT NOCOPY NUMBER,
97: X_MSG_DATA OUT NOCOPY VARCHAR2);
98:
165: -- Type : Private Utility.
166: -- Function : lock the step for the user
167: -- Pre-reqs : None.
168: -- Parameters :
169: -- IN : p_batchstep_id in fnd_table_of_varchar2_255
170: -- p_requestor in number
171: -- OUT : x_return_status out varchar2
172: -- x_msg_count out number
173: -- x_msg_data out varchar2
173: -- x_msg_data out varchar2
174: -- End of comments
175:
176:
177: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
178: P_REQUESTER IN NUMBER,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,
181: X_MSG_DATA OUT NOCOPY VARCHAR2);
211: -- Type : Private Utility.
212: -- Function : unlock the step for the user
213: -- Pre-reqs : None.
214: -- Parameters :
215: -- IN : p_batchstep_id in fnd_table_of_varchar2_255
216: -- p_requestor in number
217: -- OUT : x_return_status out varchar2
218: -- x_msg_count out number
219: -- x_msg_data out varchar2
218: -- x_msg_count out number
219: -- x_msg_data out varchar2
220: -- End of comments
221:
222: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
223: P_REQUESTER IN NUMBER,
224: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
225: X_MSG_COUNT OUT NOCOPY NUMBER,
226: X_MSG_DATA OUT NOCOPY VARCHAR2);
402: P_TASK IN VARCHAR2,
403: P_TASK_ATTRIBUTE IN VARCHAR2,
404: P_INSTRUCTION_ID IN NUMBER ,
405: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
406: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
407: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
408: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
409: P_REQUESTER IN NUMBER,
410: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
403: P_TASK_ATTRIBUTE IN VARCHAR2,
404: P_INSTRUCTION_ID IN NUMBER ,
405: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
406: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
407: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
408: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
409: P_REQUESTER IN NUMBER,
410: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
411: X_MSG_COUNT OUT NOCOPY NUMBER,
404: P_INSTRUCTION_ID IN NUMBER ,
405: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
406: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
407: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
408: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
409: P_REQUESTER IN NUMBER,
410: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
411: X_MSG_COUNT OUT NOCOPY NUMBER,
412: X_MSG_DATA OUT NOCOPY VARCHAR2
450: -- Function : Get batch step nodes
451: -- Pre-reqs : None
452: -- IN : P_BATCH_ID in number
453: -- P_BATCHSTEP_ID in number
454: -- OUT : x_name out fnd_table_of_varchar2_255
455: -- x_entity_name out fnd_table_of_varchar2_255
456: -- x_entity_key out fnd_table_of_varchar2_255
457: -- x_entity_level out fnd_table_of_varchar2_255
458: -- x_return_status out varchar2
451: -- Pre-reqs : None
452: -- IN : P_BATCH_ID in number
453: -- P_BATCHSTEP_ID in number
454: -- OUT : x_name out fnd_table_of_varchar2_255
455: -- x_entity_name out fnd_table_of_varchar2_255
456: -- x_entity_key out fnd_table_of_varchar2_255
457: -- x_entity_level out fnd_table_of_varchar2_255
458: -- x_return_status out varchar2
459: -- x_msg_count out number
452: -- IN : P_BATCH_ID in number
453: -- P_BATCHSTEP_ID in number
454: -- OUT : x_name out fnd_table_of_varchar2_255
455: -- x_entity_name out fnd_table_of_varchar2_255
456: -- x_entity_key out fnd_table_of_varchar2_255
457: -- x_entity_level out fnd_table_of_varchar2_255
458: -- x_return_status out varchar2
459: -- x_msg_count out number
460: -- x_msg_data out varchar2
453: -- P_BATCHSTEP_ID in number
454: -- OUT : x_name out fnd_table_of_varchar2_255
455: -- x_entity_name out fnd_table_of_varchar2_255
456: -- x_entity_key out fnd_table_of_varchar2_255
457: -- x_entity_level out fnd_table_of_varchar2_255
458: -- x_return_status out varchar2
459: -- x_msg_count out number
460: -- x_msg_data out varchar2
461: -- End of comments
461: -- End of comments
462:
463: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
464: P_BATCHSTEP_ID IN NUMBER,
465: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
466: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
467: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
468: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
462:
463: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
464: P_BATCHSTEP_ID IN NUMBER,
465: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
466: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
467: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
468: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
470: X_MSG_COUNT OUT NOCOPY NUMBER,
463: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
464: P_BATCHSTEP_ID IN NUMBER,
465: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
466: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
467: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
468: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
470: X_MSG_COUNT OUT NOCOPY NUMBER,
471: X_MSG_DATA OUT NOCOPY VARCHAR2);
464: P_BATCHSTEP_ID IN NUMBER,
465: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
466: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
467: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
468: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
470: X_MSG_COUNT OUT NOCOPY NUMBER,
471: X_MSG_DATA OUT NOCOPY VARCHAR2);
472: --Bug 5224634: end