APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_OPM_TXN_EXTN_HDRS

Line 65: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;

61: l_location_id po_headers_all.ship_to_location_id%TYPE; /* Bug#9088563 */
62:
63: /* Added by Ramananda for removal of SQL LITERALs */
64: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;
65: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;
66:
67: BEGIN
68: pv_return_code := jai_constants.successful ;
69: /*--------------------------------------------------------------------------------------------

Line 140: INSERT INTO JAI_OPM_TXN_EXTN_HDRS

136: /* RAISE_APPLICATION_ERROR('-20009','Purchase Order Not Associated');
137: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Purchase Order Not Associated' ; return ;
138: end if ;
139: lv_tran_name := 'OSP_ISSUE' ;
140: INSERT INTO JAI_OPM_TXN_EXTN_HDRS
141: ( TRANSACTION_NAME,
142: TRANSACTION_HEADER_ID,
143: VENDOR_CUSTOMER_ID,
144: TRANSACTION_DATE,