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.IBY_CE_BATCH_RECON_PKG dependencies on AP_CHECKS

Line 70: l_pmt_currency_code ap_checks.currency_code%TYPE;

66: l_bank_trxn_amount NUMBER;
67: l_bank_error_amount NUMBER;
68: l_bank_charge_amount NUMBER;
69:
70: l_pmt_currency_code ap_checks.currency_code%TYPE;
71: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;
72: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;
73: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;
74: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;

Line 72: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;

68: l_bank_charge_amount NUMBER;
69:
70: l_pmt_currency_code ap_checks.currency_code%TYPE;
71: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;
72: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;
73: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;
74: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;
75: l_errors_pmt_amount NUMBER;
76: l_charges_pmt_amount NUMBER;

Line 73: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;

69:
70: l_pmt_currency_code ap_checks.currency_code%TYPE;
71: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;
72: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;
73: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;
74: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;
75: l_errors_pmt_amount NUMBER;
76: l_charges_pmt_amount NUMBER;
77: l_trx_base_amount NUMBER;

Line 74: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;

70: l_pmt_currency_code ap_checks.currency_code%TYPE;
71: l_functional_currency_code ap_system_parameters.base_currency_code%TYPE;
72: l_bank_to_base_xrate ap_checks.exchange_rate%TYPE;
73: l_bank_to_base_xrate_type ap_checks.exchange_rate_type%TYPE;
74: l_bank_to_base_xrate_date ap_checks.exchange_date%TYPE;
75: l_errors_pmt_amount NUMBER;
76: l_charges_pmt_amount NUMBER;
77: l_trx_base_amount NUMBER;
78: l_errors_base_amount NUMBER;

Line 80: l_remainder_errors_pmt_amt ap_checks.amount%TYPE;

76: l_charges_pmt_amount NUMBER;
77: l_trx_base_amount NUMBER;
78: l_errors_base_amount NUMBER;
79: l_charges_base_amount NUMBER;
80: l_remainder_errors_pmt_amt ap_checks.amount%TYPE;
81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;
82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:

Line 81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;

77: l_trx_base_amount NUMBER;
78: l_errors_base_amount NUMBER;
79: l_charges_base_amount NUMBER;
80: l_remainder_errors_pmt_amt ap_checks.amount%TYPE;
81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;
82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:
85: l_max_pmt_amt ap_checks.amount%TYPE;

Line 82: l_errors_bank_amount ap_checks.amount%TYPE;

78: l_errors_base_amount NUMBER;
79: l_charges_base_amount NUMBER;
80: l_remainder_errors_pmt_amt ap_checks.amount%TYPE;
81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;
82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:
85: l_max_pmt_amt ap_checks.amount%TYPE;
86: l_pay_sum_amt ap_checks.amount%TYPE;

Line 83: l_charges_bank_amount ap_checks.amount%TYPE;

79: l_charges_base_amount NUMBER;
80: l_remainder_errors_pmt_amt ap_checks.amount%TYPE;
81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;
82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:
85: l_max_pmt_amt ap_checks.amount%TYPE;
86: l_pay_sum_amt ap_checks.amount%TYPE;
87: l_payment_count NUMBER;

Line 85: l_max_pmt_amt ap_checks.amount%TYPE;

81: l_remainder_charges_pmt_amt ap_checks.amount%TYPE;
82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:
85: l_max_pmt_amt ap_checks.amount%TYPE;
86: l_pay_sum_amt ap_checks.amount%TYPE;
87: l_payment_count NUMBER;
88: l_running_total_payments NUMBER := 0;
89: l_runtotal_trx_bank_amount NUMBER := 0;

Line 86: l_pay_sum_amt ap_checks.amount%TYPE;

82: l_errors_bank_amount ap_checks.amount%TYPE;
83: l_charges_bank_amount ap_checks.amount%TYPE;
84:
85: l_max_pmt_amt ap_checks.amount%TYPE;
86: l_pay_sum_amt ap_checks.amount%TYPE;
87: l_payment_count NUMBER;
88: l_running_total_payments NUMBER := 0;
89: l_runtotal_trx_bank_amount NUMBER := 0;
90: l_runtotal_errors_bank_amount NUMBER := 0;

Line 92: l_check_amount ap_checks.amount%TYPE;

88: l_running_total_payments NUMBER := 0;
89: l_runtotal_trx_bank_amount NUMBER := 0;
90: l_runtotal_errors_bank_amount NUMBER := 0;
91: l_runtotal_charges_bank_amount NUMBER := 0;
92: l_check_amount ap_checks.amount%TYPE;
93: l_ind_errors_pmt_amount ap_checks.amount%TYPE;
94: l_ind_charges_pmt_amount ap_checks.amount%TYPE;
95: current_calling_sequence VARCHAR2(2000);
96:

Line 93: l_ind_errors_pmt_amount ap_checks.amount%TYPE;

89: l_runtotal_trx_bank_amount NUMBER := 0;
90: l_runtotal_errors_bank_amount NUMBER := 0;
91: l_runtotal_charges_bank_amount NUMBER := 0;
92: l_check_amount ap_checks.amount%TYPE;
93: l_ind_errors_pmt_amount ap_checks.amount%TYPE;
94: l_ind_charges_pmt_amount ap_checks.amount%TYPE;
95: current_calling_sequence VARCHAR2(2000);
96:
97: l_debug_info VARCHAR2(240);

Line 94: l_ind_charges_pmt_amount ap_checks.amount%TYPE;

90: l_runtotal_errors_bank_amount NUMBER := 0;
91: l_runtotal_charges_bank_amount NUMBER := 0;
92: l_check_amount ap_checks.amount%TYPE;
93: l_ind_errors_pmt_amount ap_checks.amount%TYPE;
94: l_ind_charges_pmt_amount ap_checks.amount%TYPE;
95: current_calling_sequence VARCHAR2(2000);
96:
97: l_debug_info VARCHAR2(240);
98: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Payment_Instruction_Clearing';

Line 105: FROM ap_checks checks, iby_payments_all pmts

101: SELECT distinct check_id,
102: status_lookup_code,
103: amount,
104: 200 app_id
105: FROM ap_checks checks, iby_payments_all pmts
106: WHERE checks.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
107: AND checks.payment_id = pmts.payment_id (+)
108: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
109:

Line 153: FROM ap_checks checks, iby_payments_all pmts

149:
150:
151: CURSOR l_ins_total_cur IS
152: SELECT count(check_id), sum(amount) , max(amount)
153: FROM ap_checks checks, iby_payments_all pmts
154: WHERE checks.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
155: AND checks.payment_id = pmts.payment_id (+)
156: AND Nvl(pmts.logical_group_reference, 'N') = Nvl(P_LOGICAL_GROUP_REFERENCE, nvl(pmts.logical_group_reference,'N'))
157: /* Bug 8340931

Line 573: ap_checks_all chk,

569: SELECT chk.check_id,
570: 200 app_id
571: FROM iby_payments_all pmt,
572: iby_pay_service_requests ppr,
573: ap_checks_all chk,
574: ap_payment_history apha
575: WHERE pmt.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
576: AND pmt.payment_service_request_id = ppr.payment_service_request_id
577: AND ppr.calling_app_id = 200