DBA Data[Home] [Help]

APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on JAI_OPM_TXN_EXTN_HDRS

Line 64: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;

60: return_days number;
61:
62: /* Added by Ramananda for removal of SQL LITERALs */
63: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;
64: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;
65:
66: BEGIN
67: pv_return_code := jai_constants.successful ;
68: /*--------------------------------------------------------------------------------------------

Line 139: INSERT INTO JAI_OPM_TXN_EXTN_HDRS

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