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 127: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

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

Line 130: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

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

Line 209: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

205: +==========================================================================+ */
206: PROCEDURE get_transactions (
207: p_transaction_id IN NUMBER
208: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
209: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
210: ,x_return_status OUT NOCOPY VARCHAR2);
211:
212: /* +==========================================================================+
213: | PROCEDURE NAME

Line 233: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl

229: |
230: +==========================================================================+ */
231: PROCEDURE construct_mmti (
232: p_mmt_rec IN mtl_material_transactions%ROWTYPE
233: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
234: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
235: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
236: ,x_return_status OUT NOCOPY VARCHAR2);
237:

Line 235: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

231: PROCEDURE construct_mmti (
232: p_mmt_rec IN mtl_material_transactions%ROWTYPE
233: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
234: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
235: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
236: ,x_return_status OUT NOCOPY VARCHAR2);
237:
238: /* +==========================================================================+
239: | PROCEDURE NAME

Line 259: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl

255: +==========================================================================+ */
256: PROCEDURE get_mat_trans (
257: p_mat_det_id IN NUMBER
258: ,p_batch_id IN NUMBER
259: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl
260: ,x_return_status OUT NOCOPY VARCHAR2);
261:
262: /* +==========================================================================+
263: | PROCEDURE NAME

Line 281: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

277: |
278: +==========================================================================+ */
279: PROCEDURE get_lot_trans (
280: p_transaction_id IN NUMBER
281: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
282: ,x_return_status OUT NOCOPY VARCHAR2);
283:
284: /* +==========================================================================+
285: | PROCEDURE NAME

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

435: | x_msg_count Returns number of error message in the error message stack in case of failure
436: | x_msg_data Returns the error message in case of failure
437: | x_trans_count The count of material transaction interface records processed.
438: | p_table Source of transaction records with value 1 of material transaction interface table and value 2 of material transaction temp table
439: | p_header_id Transaction header id (If not passed in then call gme_common_pvt.get_txn_header_id to populate
440: |
441: | RETURNS
442: | returns via x_ OUT parameters
443: |

Line 457: := gme_common_pvt.get_txn_header_id

453: ,p_validation_level IN NUMBER
454: := fnd_api.g_valid_level_full
455: ,p_table IN NUMBER := 2
456: ,p_header_id IN NUMBER
457: := gme_common_pvt.get_txn_header_id
458: ,x_return_status OUT NOCOPY VARCHAR2
459: ,x_msg_count OUT NOCOPY NUMBER
460: ,x_msg_data OUT NOCOPY VARCHAR2
461: ,x_trans_count OUT NOCOPY NUMBER

Line 500: DEFAULT gme_common_pvt.g_txn_source_type

496: ,p_tree_mode IN INTEGER
497: ,p_is_serial_control IN BOOLEAN DEFAULT FALSE
498: ,p_grade_code IN VARCHAR2
499: ,p_demand_source_type_id IN NUMBER
500: DEFAULT gme_common_pvt.g_txn_source_type
501: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
502: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
503: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
504: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 562: DEFAULT gme_common_pvt.g_txn_source_type

558: ,p_inventory_item_id IN NUMBER
559: ,p_tree_mode IN INTEGER
560: ,p_is_serial_control IN BOOLEAN := FALSE
561: ,p_demand_source_type_id IN NUMBER
562: DEFAULT gme_common_pvt.g_txn_source_type
563: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
564: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
565: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
566: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 628: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

624:
625: PROCEDURE get_mmt_transactions (
626: p_transaction_id IN NUMBER
627: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
628: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
629: ,x_return_status OUT NOCOPY VARCHAR2);
630:
631: /* Bug 5358129 Added procedure */
632: PROCEDURE validate_lot_for_ing(p_organization_id IN NUMBER,

Line 638: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,

634: p_lot_number IN VARCHAR2,
635: x_return_status OUT NOCOPY VARCHAR2);
636: /* Added for bug 5597385 */
637: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
638: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
639: p_mode IN VARCHAR2,
640: x_return_status OUT NOCOPY VARCHAR2);
641: END gme_transactions_pvt;