DBA Data[Home] [Help]

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 874: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,

870: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
871: +===========================================================================*/
872: PROCEDURE check_unique_batch_name(
873: p_row_id IN VARCHAR2,
874: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
875: p_batch_name IN ar_batches.name%TYPE,
876: p_module_name IN VARCHAR2,
877: p_module_version IN VARCHAR2 ) IS
878: l_count NUMBER := 0;

Line 941: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,

937: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
938: | |
939: +===========================================================================*/
940: PROCEDURE validate_args_cu_batch_name(
941: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
942: p_batch_name IN ar_batches.name%TYPE ) IS
943: BEGIN
944: IF PG_DEBUG in ('Y', 'C') THEN
945: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );

Line 996: p_batch_source_name IN ar_batch_sources.name%TYPE,

992: | MODIFICATION HISTORY - 07/12/95 - Created by Ganesh Vaidee |
993: +===========================================================================*/
994: PROCEDURE check_unique_batch_name(
995: p_row_id IN VARCHAR2,
996: p_batch_source_name IN ar_batch_sources.name%TYPE,
997: p_batch_name IN ar_batches.name%TYPE,
998: p_module_name IN VARCHAR2,
999: p_module_version IN VARCHAR2 ) IS
1000: l_count NUMBER := 0;

Line 1015: FROM AR_BATCH_SOURCES bs,

1011: END IF;
1012: --
1013: SELECT COUNT(*)
1014: INTO l_count
1015: FROM AR_BATCH_SOURCES bs,
1016: AR_BATCHES bat
1017: WHERE bat.batch_source_id = bs.batch_source_id
1018: AND bs.name = p_batch_source_name
1019: AND bat.name = p_batch_name

Line 1065: p_batch_source_name IN ar_batch_sources.name%TYPE,

1061: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 07/12/95 |
1062: | |
1063: +===========================================================================*/
1064: PROCEDURE validate_args_cu_batch_name(
1065: p_batch_source_name IN ar_batch_sources.name%TYPE,
1066: p_batch_name IN ar_batches.name%TYPE ) IS
1067: BEGIN
1068: IF PG_DEBUG in ('Y', 'C') THEN
1069: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );