APPS.HZ_DSS_VALIDATE_PKG dependencies on AR_LOOKUPS

Line 369: -- exist_in_ar_lookups

365: END exist_in_dss_assignments ;
366:
367:
368: --------------------------------------
369: -- exist_in_ar_lookups
370: --------------------------------------
371: FUNCTION exist_in_ar_lookups
372: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
373: -- N otherwise

Line 371: FUNCTION exist_in_ar_lookups

367:
368: --------------------------------------
369: -- exist_in_ar_lookups
370: --------------------------------------
371: FUNCTION exist_in_ar_lookups
372: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
373: -- N otherwise
374: (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
375: RETURN VARCHAR2

Line 372: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS

368: --------------------------------------
369: -- exist_in_ar_lookups
370: --------------------------------------
371: FUNCTION exist_in_ar_lookups
372: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
373: -- N otherwise
374: (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
375: RETURN VARCHAR2
376: IS

Line 380: from ar_lookups

376: IS
377: CURSOR c0
378: IS
379: select 'Y'
380: from ar_lookups
381: where lookup_type = p_lookup_type
382: and lookup_code = p_lookup_code
383: and enabled_flag = 'Y' ;
384: l_yn VARCHAR2(1);

Line 396: END exist_in_ar_lookups ;

392: result := 'Y';
393: END IF;
394: CLOSE c0;
395: RETURN result;
396: END exist_in_ar_lookups ;
397:
398: --------------------------------------
399: -- exist_in_ar_lookups_gl
400: --------------------------------------

Line 399: -- exist_in_ar_lookups_gl

395: RETURN result;
396: END exist_in_ar_lookups ;
397:
398: --------------------------------------
399: -- exist_in_ar_lookups_gl
400: --------------------------------------
401: FUNCTION exist_in_ar_lookups_gl
402: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
403: -- N otherwise

Line 401: FUNCTION exist_in_ar_lookups_gl

397:
398: --------------------------------------
399: -- exist_in_ar_lookups_gl
400: --------------------------------------
401: FUNCTION exist_in_ar_lookups_gl
402: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
403: -- N otherwise
404: (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
405: RETURN VARCHAR2

Line 402: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS

398: --------------------------------------
399: -- exist_in_ar_lookups_gl
400: --------------------------------------
401: FUNCTION exist_in_ar_lookups_gl
402: -- Return Y if lookup_code and lookup_type are found in AR_LOOKUPS
403: -- N otherwise
404: (p_lookup_code VARCHAR2, p_lookup_type VARCHAR2 )
405: RETURN VARCHAR2
406: IS

Line 410: from ar_lookups

406: IS
407: CURSOR c0
408: IS
409: select 'Y'
410: from ar_lookups
411: where lookup_type = p_lookup_type
412: and lookup_code = p_lookup_code;
413: l_yn VARCHAR2(1);
414: result VARCHAR2(1);

Line 425: END exist_in_ar_lookups_gl ;

421: result := 'Y';
422: END IF;
423: CLOSE c0;
424: RETURN result;
425: END exist_in_ar_lookups_gl ;
426:
427: --------------------------------------
428: -- exist_in_fnd_lookups
429: --------------------------------------