eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_TRANSACTIONS_PVT dependencies on GME_COMMON_PVT

Line 29: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

25: |
26: +==========================================================================+ */
27: PROCEDURE create_material_txn (
28: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
29: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
30: ,p_phantom_trans IN NUMBER DEFAULT 0
31: ,x_return_status OUT NOCOPY VARCHAR2);
32:
33: /* +==========================================================================+

Line 56: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

52: +==========================================================================+ */
53: PROCEDURE update_material_txn (
54: p_transaction_id IN NUMBER
55: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE
56: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
57: ,x_return_status OUT NOCOPY VARCHAR2);
58:
59: /* +==========================================================================+
60: | PROCEDURE NAME

Line 81: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl

77: |
78: +==========================================================================+ */
79: PROCEDURE update_material_txn (
80: p_mmt_rec IN mtl_material_transactions%ROWTYPE
81: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
82: ,x_return_status OUT NOCOPY VARCHAR2);
83:
84: /* +==========================================================================+
85: | PROCEDURE NAME

Line 130: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

126: |
127: +==========================================================================+ */
128: PROCEDURE build_txn_inter (
129: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
130: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
131: ,p_assign_phantom IN NUMBER DEFAULT 0
132: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
133: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
134: ,x_return_status OUT NOCOPY VARCHAR2);

Line 133: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

129: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
130: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
131: ,p_assign_phantom IN NUMBER DEFAULT 0
132: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
133: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
134: ,x_return_status OUT NOCOPY VARCHAR2);
135:
136: /* +==========================================================================+
137: | PROCEDURE NAME

Line 219: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

215: +==========================================================================+ */
216: PROCEDURE get_transactions (
217: p_transaction_id IN NUMBER
218: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
219: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
220: ,x_return_status OUT NOCOPY VARCHAR2);
221:
222: /* +==========================================================================+
223: | PROCEDURE NAME

Line 243: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl

239: |
240: +==========================================================================+ */
241: PROCEDURE construct_mmti (
242: p_mmt_rec IN mtl_material_transactions%ROWTYPE
243: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
244: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
245: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
246: ,x_return_status OUT NOCOPY VARCHAR2);
247:

Line 245: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

241: PROCEDURE construct_mmti (
242: p_mmt_rec IN mtl_material_transactions%ROWTYPE
243: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
244: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
245: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
246: ,x_return_status OUT NOCOPY VARCHAR2);
247:
248: /* +==========================================================================+
249: | PROCEDURE NAME

Line 274: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl

270: p_mat_det_id IN NUMBER
271: ,p_batch_id IN NUMBER
272: ,p_phantom_line_id IN NUMBER DEFAULT NULL
273: ,p_order_by IN NUMBER DEFAULT 1
274: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl
275: ,x_return_status OUT NOCOPY VARCHAR2);
276:
277: /* +==========================================================================+
278: | PROCEDURE NAME

Line 296: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

292: |
293: +==========================================================================+ */
294: PROCEDURE get_lot_trans (
295: p_transaction_id IN NUMBER
296: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
297: ,x_return_status OUT NOCOPY VARCHAR2);
298:
299: /* +==========================================================================+
300: | PROCEDURE NAME

Line 454: | p_header_id Transaction header id (If not passed in then call gme_common_pvt.get_txn_header_id to populate

450: | x_msg_count Returns number of error message in the error message stack in case of failure
451: | x_msg_data Returns the error message in case of failure
452: | x_trans_count The count of material transaction interface records processed.
453: | p_table Source of transaction records with value 1 of material transaction interface table and value 2 of material transaction temp table
454: | p_header_id Transaction header id (If not passed in then call gme_common_pvt.get_txn_header_id to populate
455: |
456: | RETURNS
457: | returns via x_ OUT parameters
458: |

Line 472: := gme_common_pvt.get_txn_header_id

468: ,p_validation_level IN NUMBER
469: := fnd_api.g_valid_level_full
470: ,p_table IN NUMBER := 2
471: ,p_header_id IN NUMBER
472: := gme_common_pvt.get_txn_header_id
473: ,x_return_status OUT NOCOPY VARCHAR2
474: ,x_msg_count OUT NOCOPY NUMBER
475: ,x_msg_data OUT NOCOPY VARCHAR2
476: ,x_trans_count OUT NOCOPY NUMBER

Line 515: DEFAULT gme_common_pvt.g_txn_source_type

511: ,p_tree_mode IN INTEGER
512: ,p_is_serial_control IN BOOLEAN DEFAULT FALSE
513: ,p_grade_code IN VARCHAR2
514: ,p_demand_source_type_id IN NUMBER
515: DEFAULT gme_common_pvt.g_txn_source_type
516: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
517: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
518: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
519: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 577: DEFAULT gme_common_pvt.g_txn_source_type

573: ,p_inventory_item_id IN NUMBER
574: ,p_tree_mode IN INTEGER
575: ,p_is_serial_control IN BOOLEAN := FALSE
576: ,p_demand_source_type_id IN NUMBER
577: DEFAULT gme_common_pvt.g_txn_source_type
578: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
579: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
580: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
581: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 643: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

639:
640: PROCEDURE get_mmt_transactions (
641: p_transaction_id IN NUMBER
642: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
643: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
644: ,x_return_status OUT NOCOPY VARCHAR2);
645:
646: /* Bug 5358129 Added procedure */
647: PROCEDURE validate_lot_for_ing(p_organization_id IN NUMBER,

Line 653: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,

649: p_lot_number IN VARCHAR2,
650: x_return_status OUT NOCOPY VARCHAR2);
651: /* Added for bug 5597385 */
652: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
653: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
654: p_mode IN VARCHAR2,
655: x_return_status OUT NOCOPY VARCHAR2);
656:
657: /* +==========================================================================+