APPS.GMI_MOVE_ORDER_HEADER_UTIL dependencies on IC_TXN_REQUEST_HEADERS

Line 384: UPDATE IC_TXN_REQUEST_HEADERS

380: )
381: IS
382: BEGIN
383:
384: UPDATE IC_TXN_REQUEST_HEADERS
385: SET ATTRIBUTE1 = p_mo_hdr_rec.attribute1
386: , ATTRIBUTE10 = p_mo_hdr_rec.attribute10
387: , ATTRIBUTE11 = p_mo_hdr_rec.attribute11
388: , ATTRIBUTE12 = p_mo_hdr_rec.attribute12

Line 455: INSERT INTO IC_TXN_REQUEST_HEADERS

451: gmi_reservation_util.println('In insert_row in GMIUMOHB.pls');
452: gmi_reservation_util.println('value of l_mo_hdr_rec.organization_id: '||p_mo_hdr_rec.organization_id);
453: gmi_reservation_util.println('Value of l_mo_hdr_rec.operation is '||p_mo_hdr_rec.request_number);
454:
455: INSERT INTO IC_TXN_REQUEST_HEADERS
456: ( ATTRIBUTE1
457: , ATTRIBUTE10
458: , ATTRIBUTE11
459: , ATTRIBUTE12

Line 568: DELETE FROM IC_TXN_REQUEST_HEADERS

564: )
565: IS
566: BEGIN
567:
568: DELETE FROM IC_TXN_REQUEST_HEADERS
569: WHERE HEADER_ID = p_header_id
570: ;
571:
572: EXCEPTION

Line 711: FROM IC_TXN_REQUEST_HEADERS

707: , l_mo_hdr_rec.move_order_type
708: , l_mo_hdr_rec.transaction_type_id
709: , l_mo_hdr_rec.grouping_rule_id
710: , l_mo_hdr_rec.ship_to_location_id
711: FROM IC_TXN_REQUEST_HEADERS
712: WHERE HEADER_ID = p_header_id
713: ;
714: RETURN l_mo_hdr_rec;
715:

Line 821: FROM IC_TXN_REQUEST_HEADERS

817: , l_mo_hdr_rec.move_order_type
818: , l_mo_hdr_rec.transaction_type_id
819: , l_mo_hdr_rec.grouping_rule_id
820: , l_mo_hdr_rec.ship_to_location_id
821: FROM IC_TXN_REQUEST_HEADERS
822: WHERE HEADER_ID = p_mo_hdr_rec.header_id
823: FOR UPDATE NOWAIT;
824:
825: /* Row locked. Compare IN attributes to DB attributes. */