76: | Created 02-Feb-05 Pawan Kumar
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: /* +==========================================================================+
204: |
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: /* +==========================================================================+
228: | Created 02-Feb-05 Pawan Kumar
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);
614: |
615: | RETURNS
616: |
617: | returns via x_status OUT parameters
618: | x_mmt_rec -- mtl_material_transactions rowtype
619: | x_mmln_tbl -- table of mtl_trans_lots_number_tbl
620: | HISTORY
621: | Created 19-Jun-06 Namit S. Created
622: |
623: +==========================================================================+ */
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 */