157:
158: procedure get_resource_transaction_arr
159: (
160: p_resource_transaction_rec in GME_RESOURCE_TXNS_GTMP%ROWTYPE
161: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
162: )
163: AS
164: BEGIN
165:
162: )
163: AS
164: BEGIN
165:
166: x_resource_transaction_rec := new fnd_table_of_varchar2_255();
167:
168: x_resource_transaction_rec.extend;
169: x_resource_transaction_rec(1) := p_resource_transaction_rec.POC_TRANS_ID;
170: x_resource_transaction_rec.extend;
281: END get_resource_transaction_arr;
282:
283: procedure get_resource_transaction_rec
284: (
285: p_resource_transaction_rec IN fnd_table_of_varchar2_255
286: ,x_resource_transaction_rec OUT NOCOPY GME_RESOURCE_TXNS_GTMP%ROWTYPE
287: )
288: AS
289: BEGIN
346:
347: END get_resource_transaction_rec;
348:
349: procedure create_resource_transaction (
350: p_resource_transaction_rec IN fnd_table_of_varchar2_255
351: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
352: ,x_return_status OUT NOCOPY VARCHAR2
353: ,x_message_count OUT NOCOPY NUMBER
354: ,x_message_data OUT NOCOPY VARCHAR2
347: END get_resource_transaction_rec;
348:
349: procedure create_resource_transaction (
350: p_resource_transaction_rec IN fnd_table_of_varchar2_255
351: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
352: ,x_return_status OUT NOCOPY VARCHAR2
353: ,x_message_count OUT NOCOPY NUMBER
354: ,x_message_data OUT NOCOPY VARCHAR2
355: )
375: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
376: END create_resource_transaction;
377:
378: procedure update_resource_transaction (
379: p_resource_transaction_rec IN fnd_table_of_varchar2_255
380: ,x_return_status OUT NOCOPY VARCHAR2
381: ,x_message_count OUT NOCOPY NUMBER
382: ,x_message_data OUT NOCOPY VARCHAR2
383: )
396: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
397: END update_resource_transaction;
398:
399: procedure delete_resource_transaction (
400: p_resource_transaction_rec IN fnd_table_of_varchar2_255
401: ,x_return_status OUT NOCOPY VARCHAR2
402: ,x_message_count OUT NOCOPY NUMBER
403: ,x_message_data OUT NOCOPY VARCHAR2
404: )
447: ,p_validate_flexfields IN VARCHAR2
448: ,p_batchstep_no IN NUMBER
449: ,p_activity IN VARCHAR2
450: ,p_parameter IN VARCHAR2
451: ,p_process_param_rec IN fnd_table_of_varchar2_255
452: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_message_count OUT NOCOPY NUMBER
455: ,x_message_data OUT NOCOPY VARCHAR2
448: ,p_batchstep_no IN NUMBER
449: ,p_activity IN VARCHAR2
450: ,p_parameter IN VARCHAR2
451: ,p_process_param_rec IN fnd_table_of_varchar2_255
452: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
453: ,x_return_status OUT NOCOPY VARCHAR2
454: ,x_message_count OUT NOCOPY NUMBER
455: ,x_message_data OUT NOCOPY VARCHAR2
456: ) AS
525: ,p_process_param_rec => l_process_param_rec_in
526: ,x_process_param_rec => l_process_param_rec_out
527: );
528:
529: x_process_param_rec := new fnd_table_of_varchar2_255();
530:
531: x_process_param_rec.extend;
532: x_process_param_rec(1) := l_process_param_rec_out.PROCESS_PARAM_ID ;
533: x_process_param_rec.extend;
1038: END relieve_pending_lot;
1039:
1040:
1041: procedure create_material_transaction(
1042: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1043: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1044: ,x_return_status OUT NOCOPY VARCHAR2
1045: ,x_message_count OUT NOCOPY NUMBER
1046: ,x_message_data OUT NOCOPY VARCHAR2
1039:
1040:
1041: procedure create_material_transaction(
1042: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1043: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1044: ,x_return_status OUT NOCOPY VARCHAR2
1045: ,x_message_count OUT NOCOPY NUMBER
1046: ,x_message_data OUT NOCOPY VARCHAR2
1047: )
1104:
1105:
1106:
1107: procedure update_material_transaction(
1108: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1109: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1110: ,x_return_status OUT NOCOPY VARCHAR2
1111: ,x_message_count OUT NOCOPY NUMBER
1112: ,x_message_data OUT NOCOPY VARCHAR2
1105:
1106:
1107: procedure update_material_transaction(
1108: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1109: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1110: ,x_return_status OUT NOCOPY VARCHAR2
1111: ,x_message_count OUT NOCOPY NUMBER
1112: ,x_message_data OUT NOCOPY VARCHAR2
1113: )
1172: END update_material_transaction;
1173:
1174:
1175: procedure delete_material_transaction(
1176: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1177: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1178: ,x_return_status OUT NOCOPY VARCHAR2
1179: ,x_message_count OUT NOCOPY NUMBER
1180: ,x_message_data OUT NOCOPY VARCHAR2
1173:
1174:
1175: procedure delete_material_transaction(
1176: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1177: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1178: ,x_return_status OUT NOCOPY VARCHAR2
1179: ,x_message_count OUT NOCOPY NUMBER
1180: ,x_message_data OUT NOCOPY VARCHAR2
1181: )
1236: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1237: END delete_material_transaction;
1238:
1239: procedure create_lot(
1240: p_lot_rec IN fnd_table_of_varchar2_255
1241: ,x_return_status OUT NOCOPY VARCHAR2
1242: ,x_message_count OUT NOCOPY NUMBER
1243: ,x_message_data OUT NOCOPY VARCHAR2
1244: )