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 432: FROM ar_receipt_classes

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

Line 437: FROM ar_receipt_classes rc

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

Line 867: FROM ar_receipt_classes rc

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

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

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

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

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

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

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

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

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

Line 1296: l_rec_class_id ar_receipt_classes.receipt_class_id%TYPE;

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

Line 1297: l_rec_class_name ar_receipt_classes.name%TYPE;

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

Line 1307: l_remit_flag ar_receipt_classes.remit_flag%TYPE;

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

Line 1308: l_creation_status ar_receipt_classes.creation_status%TYPE;

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

Line 1475: FROM ar_receipt_classes rc,

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

Line 1532: FROM ar_receipt_classes rc,

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