APPS.PA_LOOKUPS_PKG dependencies on PA_LOOKUPS

Line 1: PACKAGE BODY pa_lookups_pkg AS

1: PACKAGE BODY pa_lookups_pkg AS
2: /* $Header: PAXSLKPB.pls 115.0 99/07/16 15:32:32 porting ship $ */
3: ------------------------------------------------------------------------------
4: PROCEDURE check_unique (x_return_status IN OUT NUMBER
5: , x_lookup_type IN VARCHAR2

Line 19: from pa_lookups p

15: into x_dummy
16: from sys.dual
17: where not exists
18: (select 1
19: from pa_lookups p
20: where p.lookup_type = x_lookup_type
21: and ((UPPER(p.lookup_code) = UPPER(x_lookup_code)) or
22: (UPPER(p.meaning) = UPPER(x_meaning)))
23: );

Line 442: END pa_lookups_pkg;

438: end if;
439:
440: END check_references;
441: --===========================================================================
442: END pa_lookups_pkg;