[Home] [Help]
64: , x_msg_data OUT NOCOPY VARCHAR2
65: , p_hdr_rec IN hdr_type
66: , p_line_rec_tbl IN line_type_tbl
67: , p_lot_rec_tbl IN lot_type_tbl
68: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
69: , x_line_row_tbl OUT NOCOPY line_row_tbl
70: , x_lot_row_tbl OUT NOCOPY lot_row_tbl
71: , x_transaction_set_id OUT NOCOPY mtl_material_transactions.transaction_set_id%TYPE
72: )
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: --if the validation of header, lines and lots is successful then
126: --lets construct and post records to gmi_discrete_transfers, gmi_discrete_transfers |
127: --and gmi_discrete_transfer_lots. |
128: --In this call, we will also create lots in OPM and ODM if the lot does not exist.
129: --Transaction tables in OPM/ODM and onhand balcnces in OPM/ODM would also be updated.
130:
294:
295:
296: Cursor Cur_transfer_no_exists (Vtransfer_number VARCHAR2, Vorgn_code VARCHAR2) IS
297: SELECT count(1)
298: FROM gmi_discrete_transfers
299: WHERE transfer_number = Vtransfer_number
300: AND orgn_code = Vorgn_code;
301:
302: /* Jalaj Srivastava Bug 3812701 */
1648: | Private |
1649: | |
1650: | USAGE |
1651: | constructs and posts process/discrete transfer records to |
1652: | tables gmi_discrete_transfers, gmi_discrete_transfers |
1653: | and gmi_discrete_transfer_lots. |
1654: | It will also create lots in OPM and ODM if the lot does not exist. |
1655: | It would created transactions and update balances in OPM inventory |
1656: | and Oracle Inventory |
1675: , x_msg_data OUT NOCOPY VARCHAR2
1676: , p_hdr_rec IN OUT NOCOPY hdr_type
1677: , p_line_rec_tbl IN OUT NOCOPY line_type_tbl
1678: , p_lot_rec_tbl IN OUT NOCOPY lot_type_tbl
1679: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
1680: , x_line_row_tbl OUT NOCOPY line_row_tbl
1681: , x_lot_row_tbl OUT NOCOPY lot_row_tbl
1682: ) IS
1683: