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 126: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

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

Line 129: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

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);
132:
133: /* +==========================================================================+

Line 153: p_mmti_rec IN mtl_transactions_interface%ROWTYPE

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

Line 155: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

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

Line 225: | x_mmti_rec mtl_transactions_interface rowtype

221: | p_mmln_tbl -- table of mtl_trans_lots_num_tbl as input
222: |
223: | RETURNS
224: | returns via x_status OUT parameters
225: | x_mmti_rec mtl_transactions_interface rowtype
226: | x_mmli_tbl table of mtl_trans_lots_inter_tbl
227: | HISTORY
228: | Created 02-Feb-05 Pawan Kumar
229: |

Line 234: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

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

Line 325: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

321: | Created 20-Sep-05 Shrikant Nene
322: |
323: +==========================================================================+ */
324: PROCEDURE get_returnable_qty (
325: p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
326: p_lot_number IN VARCHAR2,
327: p_lot_control IN NUMBER,
328: x_available_qty OUT NOCOPY NUMBER,
329: x_return_status OUT NOCOPY VARCHAR2);

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

597: FUNCTION is_lot_expired (p_organization_id IN NUMBER,
598: p_inventory_item_id IN NUMBER,
599: p_lot_number IN VARCHAR2,
600: p_date IN DATE) RETURN BOOLEAN;
601: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
602: x_return_status OUT NOCOPY VARCHAR2);
603: -- nsinghi Bug5176319. Added the proc.
604: /* +==========================================================================+
605: | PROCEDURE NAME

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

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