[Home] [Help]
62: , x_msg_data OUT NOCOPY VARCHAR2
63: , p_hdr_rec IN hdr_type
64: , p_line_rec_tbl IN line_type_tbl
65: , p_lot_rec_tbl IN lot_type_tbl
66: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
67: , x_line_row_tbl OUT NOCOPY line_row_tbl
68: , x_lot_row_tbl OUT NOCOPY lot_row_tbl
69: , x_transaction_set_id OUT NOCOPY mtl_material_transactions.transaction_set_id%TYPE
70: )
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122:
123: --if the validation of header, lines and lots is successful then
124: --lets construct and post records to gmi_discrete_transfers, gmi_discrete_transfers |
125: --and gmi_discrete_transfer_lots. |
126: --In this call, we will also create lots in OPM and ODM if the lot does not exist.
127: --Transaction tables in OPM/ODM and onhand balcnces in OPM/ODM would also be updated.
128:
287:
288:
289: Cursor Cur_transfer_no_exists (Vtransfer_number VARCHAR2, Vorgn_code VARCHAR2) IS
290: SELECT count(1)
291: FROM gmi_discrete_transfers
292: WHERE transfer_number = Vtransfer_number
293: AND orgn_code = Vorgn_code;
294:
295: /* Jalaj Srivastava Bug 3812701 */
1641: | Private |
1642: | |
1643: | USAGE |
1644: | constructs and posts process/discrete transfer records to |
1645: | tables gmi_discrete_transfers, gmi_discrete_transfers |
1646: | and gmi_discrete_transfer_lots. |
1647: | It will also create lots in OPM and ODM if the lot does not exist. |
1648: | It would created transactions and update balances in OPM inventory |
1649: | and Oracle Inventory |
1668: , x_msg_data OUT NOCOPY VARCHAR2
1669: , p_hdr_rec IN OUT NOCOPY hdr_type
1670: , p_line_rec_tbl IN OUT NOCOPY line_type_tbl
1671: , p_lot_rec_tbl IN OUT NOCOPY lot_type_tbl
1672: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
1673: , x_line_row_tbl OUT NOCOPY line_row_tbl
1674: , x_lot_row_tbl OUT NOCOPY lot_row_tbl
1675: ) IS
1676: