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.ARP_ARXVASUM2 dependencies on STANDARD

Line 430: -- arp_standard.enable_debug;

426: and rap.applied_payment_schedule_id = -2
427: and rap.display = 'Y');
428:
429: END IF;
430: -- arp_standard.enable_debug;
431: EXCEPTION
432: WHEN OTHERS THEN
433: arp_standard.debug( 'Exception:');
434:

Line 433: arp_standard.debug( 'Exception:');

429: END IF;
430: -- arp_standard.enable_debug;
431: EXCEPTION
432: WHEN OTHERS THEN
433: arp_standard.debug( 'Exception:');
434:
435: end;
436:
437:

Line 501: --arp_standard.enable_debug;

497: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
498: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
499: AND ps.status = nvl(p_status, ps.status);
500:
501: --arp_standard.enable_debug;
502: EXCEPTION
503: WHEN OTHERS THEN
504: arp_standard.debug( 'Exception:');
505: end;

Line 504: arp_standard.debug( 'Exception:');

500:
501: --arp_standard.enable_debug;
502: EXCEPTION
503: WHEN OTHERS THEN
504: arp_standard.debug( 'Exception:');
505: end;
506:
507:
508: procedure get_nsf_stop(

Line 549: --arp_standard.enable_debug;

545: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
546: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
547: AND ps.status = nvl(p_status, ps.status);
548:
549: --arp_standard.enable_debug;
550: EXCEPTION
551: WHEN OTHERS THEN
552: arp_standard.debug( 'Exception:');
553: end;

Line 552: arp_standard.debug( 'Exception:');

548:
549: --arp_standard.enable_debug;
550: EXCEPTION
551: WHEN OTHERS THEN
552: arp_standard.debug( 'Exception:');
553: end;
554:
555:
556: procedure get_adjustments(

Line 601: --arp_standard.enable_debug;

597: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
598: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
599: AND ps.status = nvl(p_status, ps.status);
600:
601: --arp_standard.enable_debug;
602: EXCEPTION
603: WHEN OTHERS THEN
604: arp_standard.debug( 'Exception:');
605: end;

Line 604: arp_standard.debug( 'Exception:');

600:
601: --arp_standard.enable_debug;
602: EXCEPTION
603: WHEN OTHERS THEN
604: arp_standard.debug( 'Exception:');
605: end;
606:
607:
608:

Line 654: --arp_standard.enable_debug;

650: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
651: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
652: AND ps.status = nvl(p_status, ps.status);
653:
654: --arp_standard.enable_debug;
655: EXCEPTION
656: WHEN OTHERS THEN
657: arp_standard.debug( 'Exception:');
658: end;

Line 657: arp_standard.debug( 'Exception:');

653:
654: --arp_standard.enable_debug;
655: EXCEPTION
656: WHEN OTHERS THEN
657: arp_standard.debug( 'Exception:');
658: end;
659:
660:
661: procedure get_discounts(

Line 731: --arp_standard.enable_debug;

727: and ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
728: and nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
729: and ps.status = nvl(p_status, ps.status);
730:
731: --arp_standard.enable_debug;
732: EXCEPTION
733: WHEN OTHERS THEN
734: arp_standard.debug( 'Exception:');
735: end;

Line 734: arp_standard.debug( 'Exception:');

730:
731: --arp_standard.enable_debug;
732: EXCEPTION
733: WHEN OTHERS THEN
734: arp_standard.debug( 'Exception:');
735: end;
736:
737:
738: /* BOE: get information about receipts that are waiting to be confirmed */

Line 785: arp_standard.debug( 'Exception:');

781: and crh.status = 'APPROVED';
782:
783: EXCEPTION
784: WHEN OTHERS THEN
785: arp_standard.debug( 'Exception:');
786: end;
787:
788:
789: /* BOE: get information about receipts that are waiting to be remitted,

Line 937: arp_standard.debug( 'Exception:');

933: END IF;
934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: arp_standard.debug( 'Exception:');
938: end;
939:
940:
941: /* BOE: get information about remitted receipts that are not cleared */

Line 943: p_standard_ori_amt IN OUT NOCOPY NUMBER,

939:
940:
941: /* BOE: get information about remitted receipts that are not cleared */
942: procedure get_remitted(
943: p_standard_ori_amt IN OUT NOCOPY NUMBER,
944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
945: p_standard_rem_amt IN OUT NOCOPY NUMBER,
946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
947: p_standard_count IN OUT NOCOPY NUMBER,

Line 944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,

940:
941: /* BOE: get information about remitted receipts that are not cleared */
942: procedure get_remitted(
943: p_standard_ori_amt IN OUT NOCOPY NUMBER,
944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
945: p_standard_rem_amt IN OUT NOCOPY NUMBER,
946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
947: p_standard_count IN OUT NOCOPY NUMBER,
948: p_factored_ori_amt IN OUT NOCOPY NUMBER,

Line 945: p_standard_rem_amt IN OUT NOCOPY NUMBER,

941: /* BOE: get information about remitted receipts that are not cleared */
942: procedure get_remitted(
943: p_standard_ori_amt IN OUT NOCOPY NUMBER,
944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
945: p_standard_rem_amt IN OUT NOCOPY NUMBER,
946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
947: p_standard_count IN OUT NOCOPY NUMBER,
948: p_factored_ori_amt IN OUT NOCOPY NUMBER,
949: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,

Line 946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,

942: procedure get_remitted(
943: p_standard_ori_amt IN OUT NOCOPY NUMBER,
944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
945: p_standard_rem_amt IN OUT NOCOPY NUMBER,
946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
947: p_standard_count IN OUT NOCOPY NUMBER,
948: p_factored_ori_amt IN OUT NOCOPY NUMBER,
949: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
950: p_factored_rem_amt IN OUT NOCOPY NUMBER,

Line 947: p_standard_count IN OUT NOCOPY NUMBER,

943: p_standard_ori_amt IN OUT NOCOPY NUMBER,
944: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
945: p_standard_rem_amt IN OUT NOCOPY NUMBER,
946: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
947: p_standard_count IN OUT NOCOPY NUMBER,
948: p_factored_ori_amt IN OUT NOCOPY NUMBER,
949: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
950: p_factored_rem_amt IN OUT NOCOPY NUMBER,
951: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,

Line 978: l_type := 'STANDARD';

974: only if include receipts at risk special menu
975: is checked. */
976: WHILE l_counter < 2 LOOP
977: IF l_counter = 0 THEN
978: l_type := 'STANDARD';
979: ELSIF l_counter = 1 THEN
980: l_type := 'FACTORED';
981: END IF;
982:

Line 1032: and crh.factor_flag = decode(l_type, 'STANDARD',

1028: and ps.status = nvl(p_status, ps.status)
1029: and cr.cash_receipt_id = crh.cash_receipt_id
1030: and crh.current_record_flag||'' = 'Y'
1031: and crh.status = 'REMITTED'
1032: and crh.factor_flag = decode(l_type, 'STANDARD',
1033: 'N', 'Y');
1034:
1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;

Line 1035: IF l_type = 'STANDARD' THEN

1031: and crh.status = 'REMITTED'
1032: and crh.factor_flag = decode(l_type, 'STANDARD',
1033: 'N', 'Y');
1034:
1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;

Line 1036: p_standard_ori_amt := l_ori_amount * -1;

1032: and crh.factor_flag = decode(l_type, 'STANDARD',
1033: 'N', 'Y');
1034:
1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;
1040: p_standard_count := l_count;

Line 1037: p_standard_rem_amt := l_rem_amount * -1;

1033: 'N', 'Y');
1034:
1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;
1040: p_standard_count := l_count;
1041: ELSE

Line 1038: p_standard_func_ori_amt := l_func_ori_amt * -1;

1034:
1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;
1040: p_standard_count := l_count;
1041: ELSE
1042: p_factored_ori_amt := l_ori_amount * -1;

Line 1039: p_standard_func_rem_amt := l_func_rem_amt * -1;

1035: IF l_type = 'STANDARD' THEN
1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;
1040: p_standard_count := l_count;
1041: ELSE
1042: p_factored_ori_amt := l_ori_amount * -1;
1043: p_factored_rem_amt := l_rem_amount * -1;

Line 1040: p_standard_count := l_count;

1036: p_standard_ori_amt := l_ori_amount * -1;
1037: p_standard_rem_amt := l_rem_amount * -1;
1038: p_standard_func_ori_amt := l_func_ori_amt * -1;
1039: p_standard_func_rem_amt := l_func_rem_amt * -1;
1040: p_standard_count := l_count;
1041: ELSE
1042: p_factored_ori_amt := l_ori_amount * -1;
1043: p_factored_rem_amt := l_rem_amount * -1;
1044: p_factored_func_ori_amt := l_func_ori_amt * -1;

Line 1052: p_standard_ori_amt := NULL;

1048:
1049: l_counter := l_counter + 1;
1050: END LOOP;
1051: ELSE
1052: p_standard_ori_amt := NULL;
1053: p_standard_rem_amt := NULL;
1054: p_standard_func_ori_amt := 0;
1055: p_standard_func_rem_amt := 0;
1056: p_standard_count := 0;

Line 1053: p_standard_rem_amt := NULL;

1049: l_counter := l_counter + 1;
1050: END LOOP;
1051: ELSE
1052: p_standard_ori_amt := NULL;
1053: p_standard_rem_amt := NULL;
1054: p_standard_func_ori_amt := 0;
1055: p_standard_func_rem_amt := 0;
1056: p_standard_count := 0;
1057: p_factored_ori_amt := NULL;

Line 1054: p_standard_func_ori_amt := 0;

1050: END LOOP;
1051: ELSE
1052: p_standard_ori_amt := NULL;
1053: p_standard_rem_amt := NULL;
1054: p_standard_func_ori_amt := 0;
1055: p_standard_func_rem_amt := 0;
1056: p_standard_count := 0;
1057: p_factored_ori_amt := NULL;
1058: p_factored_rem_amt := NULL;

Line 1055: p_standard_func_rem_amt := 0;

1051: ELSE
1052: p_standard_ori_amt := NULL;
1053: p_standard_rem_amt := NULL;
1054: p_standard_func_ori_amt := 0;
1055: p_standard_func_rem_amt := 0;
1056: p_standard_count := 0;
1057: p_factored_ori_amt := NULL;
1058: p_factored_rem_amt := NULL;
1059: p_factored_func_ori_amt := 0;

Line 1056: p_standard_count := 0;

1052: p_standard_ori_amt := NULL;
1053: p_standard_rem_amt := NULL;
1054: p_standard_func_ori_amt := 0;
1055: p_standard_func_rem_amt := 0;
1056: p_standard_count := 0;
1057: p_factored_ori_amt := NULL;
1058: p_factored_rem_amt := NULL;
1059: p_factored_func_ori_amt := 0;
1060: p_factored_func_rem_amt := 0;

Line 1066: arp_standard.debug( 'Exception:');

1062: END IF;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: arp_standard.debug( 'Exception:');
1067: end;
1068:
1069:
1070: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,

Line 1085: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');

1081: p_min_acc_unit IN NUMBER,
1082: p_status IN ar_payment_schedules.status%TYPE) IS
1083: BEGIN
1084: IF PG_DEBUG in ('Y', 'C') THEN
1085: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');
1086: END IF;
1087:
1088: select decode(p_currency_code,
1089: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

Line 1115: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()- ');

1111: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1112: AND ps.status = nvl(p_status, ps.status);
1113:
1114: IF PG_DEBUG in ('Y', 'C') THEN
1115: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()- ');
1116: END IF;
1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN

Line 1121: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_protested_BR ');

1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: IF PG_DEBUG in ('Y', 'C') THEN
1121: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_protested_BR ');
1122: END IF;
1123: RAISE;
1124:
1125: END get_protested_BR;

Line 1143: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');

1139: p_status IN ar_payment_schedules.status%TYPE) IS
1140: BEGIN
1141:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');
1144: END IF;
1145:
1146: select decode(p_currency_code,
1147: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

Line 1173: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()- ');

1169: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1170: AND ps.status = nvl(p_status, ps.status);
1171:
1172: IF PG_DEBUG in ('Y', 'C') THEN
1173: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()- ');
1174: END IF;
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN

Line 1179: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_unpaid_BR');

1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_unpaid_BR');
1180: END IF;
1181: RAISE;
1182:
1183: END get_unpaid_BR;

Line 1200: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()+ ');

1196: p_min_acc_unit IN NUMBER) IS
1197: BEGIN
1198:
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()+ ');
1201: END IF;
1202:
1203: select decode(p_currency_code,
1204: NULL , NULL , nvl(sum(ctl.extended_amount),0)

Line 1231: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()- ');

1227: and nvl(ct.drawee_site_use_id, -10) = nvl(p_site_use_id, nvl(ct.drawee_site_use_id, -10) )
1228: and ctl.customer_trx_id = ct.customer_trx_id;
1229:
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()- ');
1232: END IF;
1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN

Line 1237: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_pend_acceptance_BR ');

1233:
1234: EXCEPTION
1235: WHEN OTHERS THEN
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_pend_acceptance_BR ');
1238: END IF;
1239: RAISE;
1240:
1241: END get_pend_acceptance_BR;