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.AP_BANK_CHARGE_PKG dependencies on AP_BANK_CHARGE_LINES

Line 285: from ap_bank_charge_lines

281: CURSOR C_lines(P_bank_charge_id NUMBER) IS
282: select trans_amount_from, nvl(trans_amount_to, 99999999999999),
283: start_date,
284: nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY'))
285: from ap_bank_charge_lines
286: where bank_charge_id = P_bank_charge_id;
287:
288: P_bank_charge_id NUMBER;
289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

Line 289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

285: from ap_bank_charge_lines
286: where bank_charge_id = P_bank_charge_id;
287:
288: P_bank_charge_id NUMBER;
289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
290: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
291: v_start_date ap_bank_charge_lines.start_date%type;
292: v_end_date ap_bank_charge_lines.end_date%type;
293:

Line 290: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;

286: where bank_charge_id = P_bank_charge_id;
287:
288: P_bank_charge_id NUMBER;
289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
290: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
291: v_start_date ap_bank_charge_lines.start_date%type;
292: v_end_date ap_bank_charge_lines.end_date%type;
293:
294: overlap NUMBER;

Line 291: v_start_date ap_bank_charge_lines.start_date%type;

287:
288: P_bank_charge_id NUMBER;
289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
290: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
291: v_start_date ap_bank_charge_lines.start_date%type;
292: v_end_date ap_bank_charge_lines.end_date%type;
293:
294: overlap NUMBER;
295: l_debug_info Varchar2(2000);

Line 292: v_end_date ap_bank_charge_lines.end_date%type;

288: P_bank_charge_id NUMBER;
289: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
290: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
291: v_start_date ap_bank_charge_lines.start_date%type;
292: v_end_date ap_bank_charge_lines.end_date%type;
293:
294: overlap NUMBER;
295: l_debug_info Varchar2(2000);
296: l_api_name CONSTANT VARCHAR2(100) := 'CHECK_RANGE_OVERLAP';

Line 322: from ap_bank_charge_lines

318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
319: END IF;
320:
321: select count(*) INTO overlap
322: from ap_bank_charge_lines
323: where bank_charge_id = X_bank_charge_id
324: and ((trans_amount_from <= v_trans_amount_from
325: and nvl(trans_amount_to, 99999999999999)
326: > v_trans_amount_from)

Line 361: from ap_bank_charge_lines

357:
358: CURSOR C_lines(P_bank_charge_id NUMBER) IS
359: select trans_amount_from, start_date,
360: nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY'))
361: from ap_bank_charge_lines
362: where bank_charge_id = P_bank_charge_id;
363:
364: P_bank_charge_id NUMBER;
365: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

Line 365: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

361: from ap_bank_charge_lines
362: where bank_charge_id = P_bank_charge_id;
363:
364: P_bank_charge_id NUMBER;
365: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
366: v_start_date ap_bank_charge_lines.start_date%type;
367: v_end_date ap_bank_charge_lines.end_date%type;
368:
369: AMOUNT_GAP EXCEPTION;

Line 366: v_start_date ap_bank_charge_lines.start_date%type;

362: where bank_charge_id = P_bank_charge_id;
363:
364: P_bank_charge_id NUMBER;
365: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
366: v_start_date ap_bank_charge_lines.start_date%type;
367: v_end_date ap_bank_charge_lines.end_date%type;
368:
369: AMOUNT_GAP EXCEPTION;
370: START_ZERO EXCEPTION;

Line 367: v_end_date ap_bank_charge_lines.end_date%type;

363:
364: P_bank_charge_id NUMBER;
365: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
366: v_start_date ap_bank_charge_lines.start_date%type;
367: v_end_date ap_bank_charge_lines.end_date%type;
368:
369: AMOUNT_GAP EXCEPTION;
370: START_ZERO EXCEPTION;
371: gap NUMBER;

Line 401: from ap_bank_charge_lines

397: END IF;
398:
399: if (v_trans_amount_from <> 0) then
400: select count(*) INTO gap
401: from ap_bank_charge_lines
402: where bank_charge_id = X_bank_charge_id
403: and trans_amount_to = v_trans_amount_from
404: and ((start_date <= v_start_date
405: and nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')) >

Line 442: from ap_bank_charge_lines

438: PROCEDURE CHECK_LAST_RANGE(X_bank_charge_id IN NUMBER) IS
439: CURSOR C_lines(P_bank_charge_id NUMBER) IS
440: select start_date,
441: nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY'))
442: from ap_bank_charge_lines
443: where bank_charge_id = P_bank_charge_id
444: and trans_amount_to is null;
445:
446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

Line 446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;

442: from ap_bank_charge_lines
443: where bank_charge_id = P_bank_charge_id
444: and trans_amount_to is null;
445:
446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
447: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
448: v_start_date ap_bank_charge_lines.start_date%type;
449: v_end_date ap_bank_charge_lines.end_date%type;
450: cursor_check NUMBER;

Line 447: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;

443: where bank_charge_id = P_bank_charge_id
444: and trans_amount_to is null;
445:
446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
447: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
448: v_start_date ap_bank_charge_lines.start_date%type;
449: v_end_date ap_bank_charge_lines.end_date%type;
450: cursor_check NUMBER;
451: AMOUNT_GAP EXCEPTION;

Line 448: v_start_date ap_bank_charge_lines.start_date%type;

444: and trans_amount_to is null;
445:
446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
447: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
448: v_start_date ap_bank_charge_lines.start_date%type;
449: v_end_date ap_bank_charge_lines.end_date%type;
450: cursor_check NUMBER;
451: AMOUNT_GAP EXCEPTION;
452: AMOUNT_OVERLAP EXCEPTION;

Line 449: v_end_date ap_bank_charge_lines.end_date%type;

445:
446: v_trans_amount_from ap_bank_charge_lines.trans_amount_from%type;
447: v_trans_amount_to ap_bank_charge_lines.trans_amount_to%type;
448: v_start_date ap_bank_charge_lines.start_date%type;
449: v_end_date ap_bank_charge_lines.end_date%type;
450: cursor_check NUMBER;
451: AMOUNT_GAP EXCEPTION;
452: AMOUNT_OVERLAP EXCEPTION;
453: l_debug_info Varchar2(2000);

Line 477: from ap_bank_charge_lines

473: END IF;
474:
475: cursor_check := 1;
476: select trans_amount_from into v_trans_amount_from
477: from ap_bank_charge_lines
478: where bank_charge_id = X_bank_charge_id
479: and trans_amount_to is null
480: and ((start_date <= v_start_date
481: and nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')) >

Line 495: from ap_bank_charge_lines

491: END IF;
492:
493: select max(trans_amount_to)
494: into v_trans_amount_to
495: from ap_bank_charge_lines
496: where bank_charge_id = X_bank_charge_id
497: and ((start_date <= v_start_date
498: and nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')) >
499: v_start_date)

Line 573: FROM ap_bank_charges bc, ap_bank_charge_lines bcl

569: bc.receiving_bank,
570: bc.receiving_branch,
571: bc.transfer_priority,
572: bc.currency_code
573: FROM ap_bank_charges bc, ap_bank_charge_lines bcl
574: WHERE ((bc.transferring_bank_branch_id = X_transferring_bank_branch_id
575: -- bug2242764 added bank_name condition
576: AND bc.transferring_bank_name = X_transferring_bank_name)
577: OR (bc.transferring_bank_name = X_transferring_bank_name

Line 615: FROM ap_bank_charge_lines

611: nvl(trans_amount_to, 99999999999999),
612: bank_charge_standard,
613: bank_charge_negotiated,
614: tolerance_limit
615: FROM ap_bank_charge_lines
616: WHERE bank_charge_id = X_bank_charge_id
617: AND (start_date <= X_transaction_date
618: AND nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')) >
619: X_transaction_date)

Line 847: FROM ap_bank_charge_lines

843: tolerance_limit
844: INTO P_bank_charge_standard,
845: P_bank_charge_negotiated,
846: P_tolerance_limit
847: FROM ap_bank_charge_lines
848: WHERE bank_charge_id = P_bank_charge_id
849: AND trans_amount_from <= v_transaction_amount
850: AND nvl(trans_amount_to, 99999999999999) > v_transaction_amount
851: AND start_date <= P_transaction_date

Line 1014: FROM ap_bank_charges bc, ap_bank_charge_lines bcl

1010: bc.receiving_bank,
1011: bc.receiving_branch,
1012: bc.transfer_priority,
1013: bc.currency_code
1014: FROM ap_bank_charges bc, ap_bank_charge_lines bcl
1015: WHERE ((bc.transferring_bank_branch_id = X_transferring_bank_branch_id
1016: -- bug2242764 added bank_name condition
1017: AND transferring_bank_name = X_transferring_bank_name)
1018: OR (bc.transferring_bank_name = X_transferring_bank_name

Line 1055: FROM ap_bank_charge_lines

1051: nvl(trans_amount_to, 99999999999999),
1052: bank_charge_standard,
1053: bank_charge_negotiated,
1054: tolerance_limit
1055: FROM ap_bank_charge_lines
1056: WHERE bank_charge_id = X_bank_charge_id
1057: AND (start_date <= X_transaction_date
1058: AND nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')) >
1059: X_transaction_date)

Line 1287: FROM ap_bank_charge_lines

1283: tolerance_limit
1284: INTO v_bank_charge_standard,
1285: v_bank_charge_negotiated,
1286: v_tolerance_limit
1287: FROM ap_bank_charge_lines
1288: WHERE bank_charge_id = P_bank_charge_id
1289: AND trans_amount_from <= v_transaction_amount
1290: AND nvl(trans_amount_to, 99999999999999) > v_transaction_amount
1291: AND start_date <= P_transaction_date