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: , p_actual_resource_count IN NUMBER
352: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_message_count OUT NOCOPY NUMBER
348:
349: procedure create_resource_transaction (
350: p_resource_transaction_rec IN fnd_table_of_varchar2_255
351: , p_actual_resource_count IN NUMBER
352: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_message_count OUT NOCOPY NUMBER
355: ,x_message_data OUT NOCOPY VARCHAR2
356: )
379: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
380: END create_resource_transaction;
381:
382: procedure update_resource_transaction (
383: p_resource_transaction_rec IN fnd_table_of_varchar2_255
384: , p_actual_resource_count IN NUMBER
385: ,x_return_status OUT NOCOPY VARCHAR2
386: ,x_message_count OUT NOCOPY NUMBER
387: ,x_message_data OUT NOCOPY VARCHAR2
404: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
405: END update_resource_transaction;
406:
407: procedure delete_resource_transaction (
408: p_resource_transaction_rec IN fnd_table_of_varchar2_255
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_message_count OUT NOCOPY NUMBER
411: ,x_message_data OUT NOCOPY VARCHAR2
412: )
455: ,p_validate_flexfields IN VARCHAR2
456: ,p_batchstep_no IN NUMBER
457: ,p_activity IN VARCHAR2
458: ,p_parameter IN VARCHAR2
459: ,p_process_param_rec IN fnd_table_of_varchar2_255
460: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_message_count OUT NOCOPY NUMBER
463: ,x_message_data OUT NOCOPY VARCHAR2
456: ,p_batchstep_no IN NUMBER
457: ,p_activity IN VARCHAR2
458: ,p_parameter IN VARCHAR2
459: ,p_process_param_rec IN fnd_table_of_varchar2_255
460: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_message_count OUT NOCOPY NUMBER
463: ,x_message_data OUT NOCOPY VARCHAR2
464: ) AS
533: ,p_process_param_rec => l_process_param_rec_in
534: ,x_process_param_rec => l_process_param_rec_out
535: );
536:
537: x_process_param_rec := new fnd_table_of_varchar2_255();
538:
539: x_process_param_rec.extend;
540: x_process_param_rec(1) := l_process_param_rec_out.PROCESS_PARAM_ID ;
541: x_process_param_rec.extend;
1046: END relieve_pending_lot;
1047:
1048:
1049: procedure create_material_transaction(
1050: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1051: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1052: ,x_return_status OUT NOCOPY VARCHAR2
1053: ,x_message_count OUT NOCOPY NUMBER
1054: ,x_message_data OUT NOCOPY VARCHAR2
1047:
1048:
1049: procedure create_material_transaction(
1050: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1051: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1052: ,x_return_status OUT NOCOPY VARCHAR2
1053: ,x_message_count OUT NOCOPY NUMBER
1054: ,x_message_data OUT NOCOPY VARCHAR2
1055: )
1246:
1247:
1248:
1249: procedure update_material_transaction(
1250: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1251: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1252: ,x_return_status OUT NOCOPY VARCHAR2
1253: ,x_message_count OUT NOCOPY NUMBER
1254: ,x_message_data OUT NOCOPY VARCHAR2
1247:
1248:
1249: procedure update_material_transaction(
1250: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1251: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1252: ,x_return_status OUT NOCOPY VARCHAR2
1253: ,x_message_count OUT NOCOPY NUMBER
1254: ,x_message_data OUT NOCOPY VARCHAR2
1255: )
1321: END update_material_transaction;
1322:
1323:
1324: procedure delete_material_transaction(
1325: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1326: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1327: ,x_return_status OUT NOCOPY VARCHAR2
1328: ,x_message_count OUT NOCOPY NUMBER
1329: ,x_message_data OUT NOCOPY VARCHAR2
1322:
1323:
1324: procedure delete_material_transaction(
1325: p_mtl_txn_rec IN fnd_table_of_varchar2_255
1326: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
1327: ,x_return_status OUT NOCOPY VARCHAR2
1328: ,x_message_count OUT NOCOPY NUMBER
1329: ,x_message_data OUT NOCOPY VARCHAR2
1330: )
1385: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
1386: END delete_material_transaction;
1387:
1388: procedure create_lot(
1389: p_lot_rec IN fnd_table_of_varchar2_255
1390: ,x_return_status OUT NOCOPY VARCHAR2
1391: ,x_message_count OUT NOCOPY NUMBER
1392: ,x_message_data OUT NOCOPY VARCHAR2
1393: )