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_RW_BATCHES_PKG dependencies on AR_RECEIPT_CLASSES

Line 431: FROM ar_receipt_classes

427: l_request_id ar_batches.request_id%TYPE;
428: l_confirm_required VARCHAR2(1);
429: CURSOR c_receipt_class IS
430: SELECT confirm_flag
431: FROM ar_receipt_classes
432: WHERE receipt_class_id = p_receipt_class_id;
433:
434: CURSOR c_valid_receipt_class IS
435: SELECT rc.receipt_class_id

Line 436: FROM ar_receipt_classes rc

432: WHERE receipt_class_id = p_receipt_class_id;
433:
434: CURSOR c_valid_receipt_class IS
435: SELECT rc.receipt_class_id
436: FROM ar_receipt_classes rc
437: WHERE rc.receipt_class_id = l_batch_rec.receipt_class_id
438: AND rc.creation_method_code = 'AUTOMATIC';
439:
440:

Line 866: FROM ar_receipt_classes rc

862: WHERE branch_party_id = p_remittance_bank_branch_id;
863:
864: CURSOR c_valid_receipt_class IS
865: SELECT rc.receipt_class_id
866: FROM ar_receipt_classes rc
867: WHERE rc.receipt_class_id = l_batch_rec.receipt_class_id
868: AND rc.remit_flag = 'Y'
869: AND rc.creation_method_code not in ('BR','BR_REMIT')
870: AND (rc.remit_method_code = l_batch_rec.remit_method_code

Line 1278: p_rec_class_id OUT NOCOPY ar_receipt_classes.receipt_class_id%TYPE,

1274: PROCEDURE default_batch_source_pay_mthds(p_batch_source_name IN OUT NOCOPY ar_batch_sources.name%TYPE,
1275: p_batch_date IN ar_batch_sources.start_date_active%TYPE,
1276: p_batch_source_id IN OUT NOCOPY ar_batch_sources.batch_source_id%TYPE,
1277: p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%TYPE,
1278: p_rec_class_id OUT NOCOPY ar_receipt_classes.receipt_class_id%TYPE,
1279: p_rec_class_name OUT NOCOPY ar_receipt_classes.name%TYPE,
1280: p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,
1281: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
1282: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,

Line 1279: p_rec_class_name OUT NOCOPY ar_receipt_classes.name%TYPE,

1275: p_batch_date IN ar_batch_sources.start_date_active%TYPE,
1276: p_batch_source_id IN OUT NOCOPY ar_batch_sources.batch_source_id%TYPE,
1277: p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%TYPE,
1278: p_rec_class_id OUT NOCOPY ar_receipt_classes.receipt_class_id%TYPE,
1279: p_rec_class_name OUT NOCOPY ar_receipt_classes.name%TYPE,
1280: p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,
1281: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
1282: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,
1283: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,

Line 1289: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,

1285: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1286: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1287: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1288: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
1289: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,
1290: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1291: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS
1292:
1293: l_batch_source_id ar_batch_sources.batch_source_id%TYPE;

Line 1290: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

1286: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1287: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1288: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
1289: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,
1290: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1291: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS
1292:
1293: l_batch_source_id ar_batch_sources.batch_source_id%TYPE;
1294: l_batch_number ar_batch_sources.auto_batch_numbering%TYPE;

Line 1295: l_rec_class_id ar_receipt_classes.receipt_class_id%TYPE;

1291: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS
1292:
1293: l_batch_source_id ar_batch_sources.batch_source_id%TYPE;
1294: l_batch_number ar_batch_sources.auto_batch_numbering%TYPE;
1295: l_rec_class_id ar_receipt_classes.receipt_class_id%TYPE;
1296: l_rec_class_name ar_receipt_classes.name%TYPE;
1297: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;
1298: l_pay_method_name ar_receipt_methods.name%TYPE;
1299: l_bank_name ce_bank_branches_v.bank_name%TYPE;

Line 1296: l_rec_class_name ar_receipt_classes.name%TYPE;

1292:
1293: l_batch_source_id ar_batch_sources.batch_source_id%TYPE;
1294: l_batch_number ar_batch_sources.auto_batch_numbering%TYPE;
1295: l_rec_class_id ar_receipt_classes.receipt_class_id%TYPE;
1296: l_rec_class_name ar_receipt_classes.name%TYPE;
1297: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;
1298: l_pay_method_name ar_receipt_methods.name%TYPE;
1299: l_bank_name ce_bank_branches_v.bank_name%TYPE;
1300: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

Line 1306: l_remit_flag ar_receipt_classes.remit_flag%TYPE;

1302: l_currency_code ce_bank_accounts.currency_code%TYPE;
1303: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1304: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1305: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;
1306: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
1307: l_creation_status ar_receipt_classes.creation_status%TYPE;
1308: l_meaning ar_lookups.meaning%TYPE;
1309: l_num NUMBER;
1310: --Bug fix 5647335 starts

Line 1307: l_creation_status ar_receipt_classes.creation_status%TYPE;

1303: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1304: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1305: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;
1306: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
1307: l_creation_status ar_receipt_classes.creation_status%TYPE;
1308: l_meaning ar_lookups.meaning%TYPE;
1309: l_num NUMBER;
1310: --Bug fix 5647335 starts
1311: l_default_org_id NUMBER;

Line 1474: FROM ar_receipt_classes rc,

1470: l_pay_method_name,
1471: l_creation_status,
1472: l_meaning,
1473: l_remit_flag
1474: FROM ar_receipt_classes rc,
1475: ar_receipt_methods rm,
1476: ar_lookups l
1477: WHERE rc.receipt_class_id=l_rec_class_id
1478: AND rc.receipt_class_id = rm.receipt_class_id

Line 1531: FROM ar_receipt_classes rc,

1527: l_rec_class_name,
1528: l_creation_status,
1529: l_meaning,
1530: l_remit_flag
1531: FROM ar_receipt_classes rc,
1532: ar_lookups l
1533: WHERE rc.receipt_class_id=l_rec_class_id
1534: AND rc.creation_status = l.lookup_code(+)
1535: AND l.lookup_type(+) = 'RECEIPT_CREATION_STATUS'