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_BATCH_SOURCES

Line 18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);

14: p_currency_code IN ar_batches.currency_code%TYPE,
15: p_gl_date IN ar_batches.gl_date%TYPE,
16: p_batch_date IN ar_batches.batch_date%TYPE,
17: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
18: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE);
19: --
20: PROCEDURE validate_args_insert_remit(
21: p_row_id IN VARCHAR2,
22: p_batch_id IN ar_batches.batch_id%TYPE,

Line 121: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;

117: p_module_name IN VARCHAR2,
118: p_module_version IN VARCHAR2 ) IS
119: --
120: l_batch_rec ar_batches%ROWTYPE;
121: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;
122: l_request_id ar_batches.request_id%TYPE;
123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
125: BEGIN

Line 180: -- Get the batch numbering type from AR_BATCH_SOURCES

176: l_batch_rec.attribute13 := p_attribute13;
177: l_batch_rec.attribute14 := p_attribute14;
178: l_batch_rec.attribute15 := p_attribute15;
179: --
180: -- Get the batch numbering type from AR_BATCH_SOURCES
181: --
182: SELECT auto_batch_numbering
183: INTO l_auto_batch_numbering
184: FROM ar_batch_sources

Line 184: FROM ar_batch_sources

180: -- Get the batch numbering type from AR_BATCH_SOURCES
181: --
182: SELECT auto_batch_numbering
183: INTO l_auto_batch_numbering
184: FROM ar_batch_sources
185: WHERE batch_source_id = l_batch_rec.batch_source_id;
186: --
187: IF PG_DEBUG in ('Y', 'C') THEN
188: arp_util.debug('validate_args_insert_manual: ' || 'Auto Batch Num : '||l_auto_batch_numbering );

Line 208: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

204: l_auto_batch_numbering );
205: END IF;
206: --
207: -- If automatic batch numbering is set to ON, then get the next
208: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
209: --
210: IF ( l_auto_batch_numbering = 'AUTOMATIC' ) THEN
211: UPDATE ar_batch_sources
212: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1

Line 211: UPDATE ar_batch_sources

207: -- If automatic batch numbering is set to ON, then get the next
208: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
209: --
210: IF ( l_auto_batch_numbering = 'AUTOMATIC' ) THEN
211: UPDATE ar_batch_sources
212: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1
213: WHERE batch_source_id = l_batch_rec.batch_source_id;
214: --
215: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 222: FROM ar_batch_sources

218: END IF;
219: --
220: SELECT NVL( LAST_BATCH_NUM, 0 )
221: INTO l_batch_rec.name
222: FROM ar_batch_sources
223: WHERE batch_source_id = l_batch_rec.batch_source_id;
224: --
225: p_name := l_batch_rec.name;
226: ELSE

Line 300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS

296: p_currency_code IN ar_batches.currency_code%TYPE,
297: p_gl_date IN ar_batches.gl_date%TYPE,
298: p_batch_date IN ar_batches.batch_date%TYPE,
299: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE,
300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
302: BEGIN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()+' );

Line 608: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

604: --
605: l_batch_rec.batch_source_id := 1;
606: --
607: -- automatic batch numbering is set to ON, so get the next
608: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
609: --
610: UPDATE ar_batch_sources
611: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1
612: WHERE batch_source_id = l_batch_rec.batch_source_id;

Line 610: UPDATE ar_batch_sources

606: --
607: -- automatic batch numbering is set to ON, so get the next
608: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
609: --
610: UPDATE ar_batch_sources
611: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1
612: WHERE batch_source_id = l_batch_rec.batch_source_id;
613: --
614: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 621: FROM ar_batch_sources

617: END IF;
618: --
619: SELECT NVL( LAST_BATCH_NUM, 0 )
620: INTO l_batch_rec.name
621: FROM ar_batch_sources
622: WHERE batch_source_id = l_batch_rec.batch_source_id;
623: --
624: p_name := l_batch_rec.name;
625: --

Line 1109: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

1105: --
1106: l_batch_rec.batch_source_id := 1;
1107: --
1108: -- automatic batch numbering is set to ON, so get the next
1109: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
1110: --
1111: UPDATE ar_batch_sources
1112: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1
1113: WHERE batch_source_id = l_batch_rec.batch_source_id;

Line 1111: UPDATE ar_batch_sources

1107: --
1108: -- automatic batch numbering is set to ON, so get the next
1109: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES
1110: --
1111: UPDATE ar_batch_sources
1112: SET last_batch_num = NVL( LAST_BATCH_NUM, 0 ) + 1
1113: WHERE batch_source_id = l_batch_rec.batch_source_id;
1114: --
1115: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 1122: FROM ar_batch_sources

1118: END IF;
1119: --
1120: SELECT NVL( LAST_BATCH_NUM, 0 )
1121: INTO l_batch_rec.name
1122: FROM ar_batch_sources
1123: WHERE batch_source_id = l_batch_rec.batch_source_id;
1124: --
1125: p_name := l_batch_rec.name;
1126: p_batch_applied_status := l_batch_rec.batch_applied_status;

Line 1275: PROCEDURE default_batch_source_pay_mthds(p_batch_source_name IN OUT NOCOPY ar_batch_sources.name%TYPE,

1271: RAISE;
1272: END delete_batch;
1273:
1274:
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,

Line 1276: p_batch_date IN ar_batch_sources.start_date_active%TYPE,

1272: END delete_batch;
1273:
1274:
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,

Line 1277: p_batch_source_id IN OUT NOCOPY ar_batch_sources.batch_source_id%TYPE,

1273:
1274:
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,

Line 1278: p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%TYPE,

1274:
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,

Line 1294: l_batch_source_id ar_batch_sources.batch_source_id%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;
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;

Line 1295: l_batch_number ar_batch_sources.auto_batch_numbering%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;
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;

Line 1323: FROM ar_batch_sources bs

1319: bs.default_receipt_class_id,
1320: bs.default_receipt_method_id,
1321: bs.default_remit_bank_account_id,
1322: bs.org_id
1323: FROM ar_batch_sources bs
1324: WHERE bs.name = p_batch_source_name
1325: AND bs.type <> 'AUTOMATIC'
1326: AND p_batch_date BETWEEN bs.start_date_active AND NVL(bs.end_date_active,p_batch_date);
1327: BEGIN

Line 1393: FROM ar_batch_sources bs

1389: l_batch_number,
1390: l_rec_class_id,
1391: l_pay_method_id,
1392: l_bank_account_id
1393: FROM ar_batch_sources bs
1394: WHERE bs.name = p_batch_source_name
1395: AND bs.type <> 'AUTOMATIC'
1396: AND p_batch_date BETWEEN bs.start_date_active AND NVL(bs.end_date_active,p_batch_date);*/
1397: EXCEPTION