DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 161: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255

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:

Line 166: x_resource_transaction_rec := new fnd_table_of_varchar2_255();

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;

Line 285: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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

Line 350: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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

Line 352: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255

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: )

Line 383: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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

Line 408: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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: )

Line 459: ,p_process_param_rec IN fnd_table_of_varchar2_255

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

Line 460: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255

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

Line 537: x_process_param_rec := new fnd_table_of_varchar2_255();

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;

Line 1050: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1051: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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: )

Line 1250: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1251: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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: )

Line 1325: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1326: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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: )

Line 1389: p_lot_rec IN fnd_table_of_varchar2_255

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: )