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,
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 );
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;
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()+' );
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;
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
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()+' );