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

Line 351: ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255

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

Line 379: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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

Line 400: p_resource_transaction_rec IN fnd_table_of_varchar2_255

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

Line 451: ,p_process_param_rec IN fnd_table_of_varchar2_255

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

Line 452: ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255

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

Line 529: x_process_param_rec := new fnd_table_of_varchar2_255();

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;

Line 1042: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1043: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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

Line 1108: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1109: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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

Line 1176: p_mtl_txn_rec IN fnd_table_of_varchar2_255

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

Line 1177: ,p_mtl_lot_rec IN fnd_table_of_varchar2_255

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

Line 1240: p_lot_rec IN fnd_table_of_varchar2_255

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