APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on AR_BATCH_SOURCES

Line 7: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,

3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:
6: PROCEDURE validate_args_cu_batch_name(
7: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
8: p_batch_name IN ar_batches.name%TYPE );
9: --
10: PROCEDURE validate_args_cu_batch_name(
11: p_batch_source_name IN ar_batch_sources.name%TYPE,

Line 11: p_batch_source_name IN ar_batch_sources.name%TYPE,

7: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
8: p_batch_name IN ar_batches.name%TYPE );
9: --
10: PROCEDURE validate_args_cu_batch_name(
11: p_batch_source_name IN ar_batch_sources.name%TYPE,
12: p_batch_name IN ar_batches.name%TYPE );
13: --
14: PROCEDURE validate_args_cu_media_ref(
15: p_media_ref IN ar_batches.media_reference%TYPE );

Line 826: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,

822: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
823: +===========================================================================*/
824: PROCEDURE check_unique_batch_name(
825: p_row_id IN VARCHAR2,
826: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
827: p_batch_name IN ar_batches.name%TYPE,
828: p_module_name IN VARCHAR2,
829: p_module_version IN VARCHAR2 ) IS
830: l_count NUMBER := 0;

Line 893: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,

889: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
890: | |
891: +===========================================================================*/
892: PROCEDURE validate_args_cu_batch_name(
893: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
894: p_batch_name IN ar_batches.name%TYPE ) IS
895: BEGIN
896: IF PG_DEBUG in ('Y', 'C') THEN
897: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );

Line 948: p_batch_source_name IN ar_batch_sources.name%TYPE,

944: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
945: +===========================================================================*/
946: PROCEDURE check_unique_batch_name(
947: p_row_id IN VARCHAR2,
948: p_batch_source_name IN ar_batch_sources.name%TYPE,
949: p_batch_name IN ar_batches.name%TYPE,
950: p_module_name IN VARCHAR2,
951: p_module_version IN VARCHAR2 ) IS
952: l_count NUMBER := 0;

Line 967: FROM AR_BATCH_SOURCES bs,

963: END IF;
964: --
965: SELECT COUNT(*)
966: INTO l_count
967: FROM AR_BATCH_SOURCES bs,
968: AR_BATCHES bat
969: WHERE bat.batch_source_id = bs.batch_source_id
970: AND bs.name = p_batch_source_name
971: AND bat.name = p_batch_name

Line 1017: p_batch_source_name IN ar_batch_sources.name%TYPE,

1013: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
1014: | |
1015: +===========================================================================*/
1016: PROCEDURE validate_args_cu_batch_name(
1017: p_batch_source_name IN ar_batch_sources.name%TYPE,
1018: p_batch_name IN ar_batches.name%TYPE ) IS
1019: BEGIN
1020: IF PG_DEBUG in ('Y', 'C') THEN
1021: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );