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

101: SELECT distinct check_id,
102: status_lookup_code,
103: amount,
104: 200 app_id
105: FROM ap_checks checks
106: WHERE payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
107: and
108: exists (select 1 from iby_payments_all pay
109: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))

Line 149: FROM ap_checks checks

145:
146:
147: CURSOR l_ins_total_cur IS
148: SELECT count(check_id), sum(amount) , max(amount)
149: FROM ap_checks checks
150: WHERE payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
151: AND exists (select 1 from iby_payments_all pay
152: where nvl(logical_group_reference,'N') = nvl(P_LOGICAL_GROUP_REFERENCE,nvl(logical_group_reference,'N'))
153: and checks.payment_instruction_id = pay.payment_instruction_id

Line 566: ap_checks_all chk,

562: SELECT chk.check_id,
563: 200 app_id
564: FROM iby_payments_all pmt,
565: iby_pay_service_requests ppr,
566: ap_checks_all chk,
567: ap_payment_history apha
568: WHERE pmt.payment_instruction_id = P_PAYMENT_INSTRUCTION_ID
569: AND pmt.payment_service_request_id = ppr.payment_service_request_id
570: AND ppr.calling_app_id = 200