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_ARXVASUM dependencies on STANDARD

Line 433: -- arp_standard.enable_debug;

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

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

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

Line 505: --arp_standard.enable_debug;

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

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

504:
505: --arp_standard.enable_debug;
506: EXCEPTION
507: WHEN OTHERS THEN
508: arp_standard.debug( 'Exception:');
509: end;
510:
511:
512: procedure get_nsf_stop(

Line 554: --arp_standard.enable_debug;

550: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
551: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
552: AND ps.status = nvl(p_status, ps.status);
553:
554: --arp_standard.enable_debug;
555: EXCEPTION
556: WHEN OTHERS THEN
557: arp_standard.debug( 'Exception:');
558: end;

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

553:
554: --arp_standard.enable_debug;
555: EXCEPTION
556: WHEN OTHERS THEN
557: arp_standard.debug( 'Exception:');
558: end;
559:
560:
561: procedure get_adjustments(

Line 607: --arp_standard.enable_debug;

603: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
604: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
605: AND ps.status = nvl(p_status, ps.status);
606:
607: --arp_standard.enable_debug;
608: EXCEPTION
609: WHEN OTHERS THEN
610: arp_standard.debug( 'Exception:');
611: end;

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

606:
607: --arp_standard.enable_debug;
608: EXCEPTION
609: WHEN OTHERS THEN
610: arp_standard.debug( 'Exception:');
611: end;
612:
613:
614:

Line 661: --arp_standard.enable_debug;

657: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
658: AND nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
659: AND ps.status = nvl(p_status, ps.status);
660:
661: --arp_standard.enable_debug;
662: EXCEPTION
663: WHEN OTHERS THEN
664: arp_standard.debug( 'Exception:');
665: end;

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

660:
661: --arp_standard.enable_debug;
662: EXCEPTION
663: WHEN OTHERS THEN
664: arp_standard.debug( 'Exception:');
665: end;
666:
667:
668: procedure get_discounts(

Line 739: --arp_standard.enable_debug;

735: and ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
736: and nvl(ps.receipt_confirmed_flag,'Y') = 'Y'
737: and ps.status = nvl(p_status, ps.status);
738:
739: --arp_standard.enable_debug;
740: EXCEPTION
741: WHEN OTHERS THEN
742: arp_standard.debug( 'Exception:');
743: end;

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

738:
739: --arp_standard.enable_debug;
740: EXCEPTION
741: WHEN OTHERS THEN
742: arp_standard.debug( 'Exception:');
743: end;
744:
745:
746: /* BOE: get information about receipts that are waiting to be confirmed */

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

790: and crh.status = 'APPROVED';
791:
792: EXCEPTION
793: WHEN OTHERS THEN
794: arp_standard.debug( 'Exception:');
795: end;
796:
797:
798: /* BOE: get information about receipts that are waiting to be remitted,

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

943: END IF;
944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug( 'Exception:');
948: end;
949:
950:
951: /* BOE: get information about remitted receipts that are not cleared */

Line 953: p_standard_ori_amt IN OUT NOCOPY NUMBER,

949:
950:
951: /* BOE: get information about remitted receipts that are not cleared */
952: procedure get_remitted(
953: p_standard_ori_amt IN OUT NOCOPY NUMBER,
954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
955: p_standard_rem_amt IN OUT NOCOPY NUMBER,
956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
957: p_standard_count IN OUT NOCOPY NUMBER,

Line 954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,

950:
951: /* BOE: get information about remitted receipts that are not cleared */
952: procedure get_remitted(
953: p_standard_ori_amt IN OUT NOCOPY NUMBER,
954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
955: p_standard_rem_amt IN OUT NOCOPY NUMBER,
956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
957: p_standard_count IN OUT NOCOPY NUMBER,
958: p_factored_ori_amt IN OUT NOCOPY NUMBER,

Line 955: p_standard_rem_amt IN OUT NOCOPY NUMBER,

951: /* BOE: get information about remitted receipts that are not cleared */
952: procedure get_remitted(
953: p_standard_ori_amt IN OUT NOCOPY NUMBER,
954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
955: p_standard_rem_amt IN OUT NOCOPY NUMBER,
956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
957: p_standard_count IN OUT NOCOPY NUMBER,
958: p_factored_ori_amt IN OUT NOCOPY NUMBER,
959: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,

Line 956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,

952: procedure get_remitted(
953: p_standard_ori_amt IN OUT NOCOPY NUMBER,
954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
955: p_standard_rem_amt IN OUT NOCOPY NUMBER,
956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
957: p_standard_count IN OUT NOCOPY NUMBER,
958: p_factored_ori_amt IN OUT NOCOPY NUMBER,
959: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
960: p_factored_rem_amt IN OUT NOCOPY NUMBER,

Line 957: p_standard_count IN OUT NOCOPY NUMBER,

953: p_standard_ori_amt IN OUT NOCOPY NUMBER,
954: p_standard_func_ori_amt IN OUT NOCOPY NUMBER,
955: p_standard_rem_amt IN OUT NOCOPY NUMBER,
956: p_standard_func_rem_amt IN OUT NOCOPY NUMBER,
957: p_standard_count IN OUT NOCOPY NUMBER,
958: p_factored_ori_amt IN OUT NOCOPY NUMBER,
959: p_factored_func_ori_amt IN OUT NOCOPY NUMBER,
960: p_factored_rem_amt IN OUT NOCOPY NUMBER,
961: p_factored_func_rem_amt IN OUT NOCOPY NUMBER,

Line 988: l_type := 'STANDARD';

984: only if include receipts at risk special menu
985: is checked. */
986: WHILE l_counter < 2 LOOP
987: IF l_counter = 0 THEN
988: l_type := 'STANDARD';
989: ELSIF l_counter = 1 THEN
990: l_type := 'FACTORED';
991: END IF;
992:

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

1039: and ps.status = nvl(p_status, ps.status)
1040: and cr.cash_receipt_id = crh.cash_receipt_id
1041: and crh.current_record_flag||'' = 'Y'
1042: and crh.status = 'REMITTED'
1043: and crh.factor_flag = decode(l_type, 'STANDARD',
1044: 'N', 'Y');
1045:
1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;

Line 1046: IF l_type = 'STANDARD' THEN

1042: and crh.status = 'REMITTED'
1043: and crh.factor_flag = decode(l_type, 'STANDARD',
1044: 'N', 'Y');
1045:
1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;

Line 1047: p_standard_ori_amt := l_ori_amount * -1;

1043: and crh.factor_flag = decode(l_type, 'STANDARD',
1044: 'N', 'Y');
1045:
1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;
1051: p_standard_count := l_count;

Line 1048: p_standard_rem_amt := l_rem_amount * -1;

1044: 'N', 'Y');
1045:
1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;
1051: p_standard_count := l_count;
1052: ELSE

Line 1049: p_standard_func_ori_amt := l_func_ori_amt * -1;

1045:
1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;
1051: p_standard_count := l_count;
1052: ELSE
1053: p_factored_ori_amt := l_ori_amount * -1;

Line 1050: p_standard_func_rem_amt := l_func_rem_amt * -1;

1046: IF l_type = 'STANDARD' THEN
1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;
1051: p_standard_count := l_count;
1052: ELSE
1053: p_factored_ori_amt := l_ori_amount * -1;
1054: p_factored_rem_amt := l_rem_amount * -1;

Line 1051: p_standard_count := l_count;

1047: p_standard_ori_amt := l_ori_amount * -1;
1048: p_standard_rem_amt := l_rem_amount * -1;
1049: p_standard_func_ori_amt := l_func_ori_amt * -1;
1050: p_standard_func_rem_amt := l_func_rem_amt * -1;
1051: p_standard_count := l_count;
1052: ELSE
1053: p_factored_ori_amt := l_ori_amount * -1;
1054: p_factored_rem_amt := l_rem_amount * -1;
1055: p_factored_func_ori_amt := l_func_ori_amt * -1;

Line 1063: p_standard_ori_amt := NULL;

1059:
1060: l_counter := l_counter + 1;
1061: END LOOP;
1062: ELSE
1063: p_standard_ori_amt := NULL;
1064: p_standard_rem_amt := NULL;
1065: p_standard_func_ori_amt := 0;
1066: p_standard_func_rem_amt := 0;
1067: p_standard_count := 0;

Line 1064: p_standard_rem_amt := NULL;

1060: l_counter := l_counter + 1;
1061: END LOOP;
1062: ELSE
1063: p_standard_ori_amt := NULL;
1064: p_standard_rem_amt := NULL;
1065: p_standard_func_ori_amt := 0;
1066: p_standard_func_rem_amt := 0;
1067: p_standard_count := 0;
1068: p_factored_ori_amt := NULL;

Line 1065: p_standard_func_ori_amt := 0;

1061: END LOOP;
1062: ELSE
1063: p_standard_ori_amt := NULL;
1064: p_standard_rem_amt := NULL;
1065: p_standard_func_ori_amt := 0;
1066: p_standard_func_rem_amt := 0;
1067: p_standard_count := 0;
1068: p_factored_ori_amt := NULL;
1069: p_factored_rem_amt := NULL;

Line 1066: p_standard_func_rem_amt := 0;

1062: ELSE
1063: p_standard_ori_amt := NULL;
1064: p_standard_rem_amt := NULL;
1065: p_standard_func_ori_amt := 0;
1066: p_standard_func_rem_amt := 0;
1067: p_standard_count := 0;
1068: p_factored_ori_amt := NULL;
1069: p_factored_rem_amt := NULL;
1070: p_factored_func_ori_amt := 0;

Line 1067: p_standard_count := 0;

1063: p_standard_ori_amt := NULL;
1064: p_standard_rem_amt := NULL;
1065: p_standard_func_ori_amt := 0;
1066: p_standard_func_rem_amt := 0;
1067: p_standard_count := 0;
1068: p_factored_ori_amt := NULL;
1069: p_factored_rem_amt := NULL;
1070: p_factored_func_ori_amt := 0;
1071: p_factored_func_rem_amt := 0;

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

1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: arp_standard.debug( 'Exception:');
1078: end;
1079:
1080:
1081: procedure get_protested_BR(p_BR_protested_amt IN OUT NOCOPY NUMBER,

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

1092: p_min_acc_unit IN NUMBER,
1093: p_status IN ar_payment_schedules.status%TYPE) IS
1094: BEGIN
1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');
1097: END IF;
1098:
1099: select decode(p_currency_code,
1100: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

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

1123: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1124: AND ps.status = nvl(p_status, ps.status);
1125:
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()- ');
1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN

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

1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: IF PG_DEBUG in ('Y', 'C') THEN
1133: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_protested_BR ');
1134: END IF;
1135: RAISE;
1136:
1137: END get_protested_BR;

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

1151: p_status IN ar_payment_schedules.status%TYPE) IS
1152: BEGIN
1153:
1154: IF PG_DEBUG in ('Y', 'C') THEN
1155: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');
1156: END IF;
1157:
1158: select decode(p_currency_code,
1159: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

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

1182: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1183: AND ps.status = nvl(p_status, ps.status);
1184:
1185: IF PG_DEBUG in ('Y', 'C') THEN
1186: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()- ');
1187: END IF;
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN

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

1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_unpaid_BR');
1193: END IF;
1194: RAISE;
1195:
1196: END get_unpaid_BR;

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

1209: p_min_acc_unit IN NUMBER) IS
1210: BEGIN
1211:
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()+ ');
1214: END IF;
1215:
1216: select decode(p_currency_code,
1217: NULL , NULL , nvl(sum(ctl.extended_amount),0)

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

1241: and nvl(ct.drawee_site_use_id, -10) = nvl(p_site_use_id, nvl(ct.drawee_site_use_id, -10) )
1242: and ctl.customer_trx_id = ct.customer_trx_id;
1243:
1244: IF PG_DEBUG in ('Y', 'C') THEN
1245: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()- ');
1246: END IF;
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN

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

1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_pend_acceptance_BR ');
1252: END IF;
1253: RAISE;
1254:
1255: END get_pend_acceptance_BR;