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.

[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on AR_BATCH_SOURCES

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

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

Line 120: l_auto_batch_numbering ar_batch_sources.auto_batch_numbering%TYPE;

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

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

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

Line 183: FROM ar_batch_sources

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

Line 207: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

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

Line 210: UPDATE ar_batch_sources

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

Line 221: FROM ar_batch_sources

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

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

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

Line 607: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

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

Line 609: UPDATE ar_batch_sources

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

Line 620: FROM ar_batch_sources

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

Line 1108: -- batch name from LAST_BATCH_NUM from AR_BATCH_SOURCES

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

Line 1110: UPDATE ar_batch_sources

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

Line 1121: FROM ar_batch_sources

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

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

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

Line 1275: p_batch_date IN ar_batch_sources.start_date_active%TYPE,

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

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

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

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

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

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

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

Line 1322: FROM ar_batch_sources bs

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

Line 1392: FROM ar_batch_sources bs

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