DBA Data[Home] [Help]

APPS.GME_TRANSACTIONS_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 28: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

24: | Created 02-Feb-05 Pawan Kumar
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:

Line 55: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE

51: |
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: /* +==========================================================================+

Line 129: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

125: | Created 02-Feb-05 Pawan Kumar
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

Line 132: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

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);
135:
136: /* +==========================================================================+

Line 156: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

152: |
153: +==========================================================================+ */
154: /* Bug 4929610 Added new parameter */
155: PROCEDURE build_txn_inter_hdr (
156: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
157: ,p_assign_phantom IN NUMBER DEFAULT 0
158: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE);

Line 158: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

154: /* Bug 4929610 Added new parameter */
155: PROCEDURE build_txn_inter_hdr (
156: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
157: ,p_assign_phantom IN NUMBER DEFAULT 0
158: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,p_insert_hdr IN BOOLEAN DEFAULT TRUE);
161:
162: /* +==========================================================================+

Line 235: | x_mmti_rec mtl_transactions_interface rowtype

231: | p_mmln_tbl -- table of mtl_trans_lots_num_tbl as input
232: |
233: | RETURNS
234: | returns via x_status OUT parameters
235: | x_mmti_rec mtl_transactions_interface rowtype
236: | x_mmli_tbl table of mtl_trans_lots_inter_tbl
237: | HISTORY
238: | Created 02-Feb-05 Pawan Kumar
239: |

Line 244: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

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:
248: /* +==========================================================================+

Line 340: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

336: | Created 20-Sep-05 Shrikant Nene
337: |
338: +==========================================================================+ */
339: PROCEDURE get_returnable_qty (
340: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
341: p_lot_number IN VARCHAR2,
342: p_lot_control IN NUMBER,
343: x_available_qty OUT NOCOPY NUMBER,
344: x_return_status OUT NOCOPY VARCHAR2);

Line 616: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

612: FUNCTION is_lot_expired (p_organization_id IN NUMBER,
613: p_inventory_item_id IN NUMBER,
614: p_lot_number IN VARCHAR2,
615: p_date IN DATE) RETURN BOOLEAN;
616: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
617: x_return_status OUT NOCOPY VARCHAR2);
618: -- nsinghi Bug5176319. Added the proc.
619: /* +==========================================================================+
620: | PROCEDURE NAME

Line 652: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

648: p_inventory_item_id IN NUMBER,
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: