DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on IC_TXN_REQUEST_HEADERS

Line 44: l_ic_mo_header_rec ic_txn_request_headers%rowtype;

40:
41: l_wdd_rec wsh_delivery_details%rowtype;
42: l_mo_line_rec ic_txn_request_lines%rowtype;
43: l_order_line oe_order_lines_all%rowtype;
44: l_ic_mo_header_rec ic_txn_request_headers%rowtype;
45: l_mtl_mo_header_rec INV_Move_Order_PUB.Trohdr_Rec_Type := INV_Move_Order_PUB.G_MISS_TROHDR_REC;
46: l_mtl_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type; /*(:= INV_Move_Order_PUB.G_MISS_TROLIN_TBL; */
47:
48: /* MTL Move order header */

Line 195: FROM ic_txn_request_headers h,

191: AND source_line_id = p_line_id;
192:
193: CURSOR get_move_order_header(p_line_id IN NUMBER) IS
194: SELECT h.*
195: FROM ic_txn_request_headers h,
196: ic_txn_request_lines l
197: WHERE l.header_id = h.header_id
198: AND l.line_id = p_line_id;
199:

Line 834: /* Update attribute15 in ic_txn_request_headers */

830: ELSE
831: GMI_RESERVATION_UTIL.PrintLn(' Create_move_order_header succeeded - header_id : '|| l_trohdr_rec.header_id);
832: l_mo_header_id := l_trohdr_rec.header_id;
833: -- only do this if the create move order header above suceeded
834: /* Update attribute15 in ic_txn_request_headers */
835: GMI_RESERVATION_UTIL.PrintLn(' before update to attribute15 of in ic_txn_request_headers: '||to_char(l_trohdr_rec.header_id));
836:
837: UPDATE ic_txn_request_headers
838: SET attribute15 = to_char(l_trohdr_rec.header_id)

Line 835: GMI_RESERVATION_UTIL.PrintLn(' before update to attribute15 of in ic_txn_request_headers: '||to_char(l_trohdr_rec.header_id));

831: GMI_RESERVATION_UTIL.PrintLn(' Create_move_order_header succeeded - header_id : '|| l_trohdr_rec.header_id);
832: l_mo_header_id := l_trohdr_rec.header_id;
833: -- only do this if the create move order header above suceeded
834: /* Update attribute15 in ic_txn_request_headers */
835: GMI_RESERVATION_UTIL.PrintLn(' before update to attribute15 of in ic_txn_request_headers: '||to_char(l_trohdr_rec.header_id));
836:
837: UPDATE ic_txn_request_headers
838: SET attribute15 = to_char(l_trohdr_rec.header_id)
839: WHERE header_id = l_ic_mo_header_rec.header_id;

Line 837: UPDATE ic_txn_request_headers

833: -- only do this if the create move order header above suceeded
834: /* Update attribute15 in ic_txn_request_headers */
835: GMI_RESERVATION_UTIL.PrintLn(' before update to attribute15 of in ic_txn_request_headers: '||to_char(l_trohdr_rec.header_id));
836:
837: UPDATE ic_txn_request_headers
838: SET attribute15 = to_char(l_trohdr_rec.header_id)
839: WHERE header_id = l_ic_mo_header_rec.header_id;
840:
841: GMI_RESERVATION_UTIL.PrintLn(' after update to attribute15 of in ic_txn_request_headers');

Line 841: GMI_RESERVATION_UTIL.PrintLn(' after update to attribute15 of in ic_txn_request_headers');

837: UPDATE ic_txn_request_headers
838: SET attribute15 = to_char(l_trohdr_rec.header_id)
839: WHERE header_id = l_ic_mo_header_rec.header_id;
840:
841: GMI_RESERVATION_UTIL.PrintLn(' after update to attribute15 of in ic_txn_request_headers');
842:
843: END IF; -- IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
844:
845: END IF; -- IF(l_ic_mo_header_rec.attribute15 IS NOT NULL) THEN