eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINBBR_XMLP_PKG dependencies on AP_CHECKS_ALL

Line 192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

Line 194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
198: BEGIN

Line 195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
198: BEGIN
199: LV_PAY_SOURCE := 'Payables India';

Line 196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

192: LV_NEGOT_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
198: BEGIN
199: LV_PAY_SOURCE := 'Payables India';
200: LV_RCV_SOURCE := 'Receivables India';

Line 197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;

193: LV_CLEAR_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
194: LV_VOIDED_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
195: LV_REC_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
196: LV_REC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
197: LV_CLEAR_UNACC_LOOKUP AP_CHECKS_ALL.STATUS_LOOKUP_CODE%TYPE;
198: BEGIN
199: LV_PAY_SOURCE := 'Payables India';
200: LV_RCV_SOURCE := 'Receivables India';
201: LV_PAY_SOURCE1 := 'Payables';

Line 303: AP_CHECKS_ALL APC,

299: ,1))
300: INTO V_AMOUNT1
301: FROM
302: AP_INVOICE_PAYMENTS_ALL AIP,
303: AP_CHECKS_ALL APC,
304: CE_BANK_ACCOUNTS CBA
305: WHERE AIP.CHECK_ID = APC.CHECK_ID
306: AND APC.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID
307: AND APC.STATUS_LOOKUP_CODE IN ( LV_NEGOT_LOOKUP , LV_CLEAR_LOOKUP , LV_VOIDED_LOOKUP , LV_REC_UNACC_LOOKUP , LV_REC_LOOKUP , LV_CLEAR_UNACC_LOOKUP )