APPS.OKL_AM_UTIL_PVT dependencies on FND_LOOKUPS

Line 452: l_lookup_rec fnd_lookups%ROWTYPE;

448: p_lookup_code IN VARCHAR2,
449: p_validate_yn IN VARCHAR2)
450: RETURN VARCHAR2 IS
451:
452: l_lookup_rec fnd_lookups%ROWTYPE;
453: l_meaning fnd_lookups.meaning%TYPE := NULL;
454: l_sysdate DATE := SYSDATE ;
455:
456: CURSOR l_lookup_csr

Line 453: l_meaning fnd_lookups.meaning%TYPE := NULL;

449: p_validate_yn IN VARCHAR2)
450: RETURN VARCHAR2 IS
451:
452: l_lookup_rec fnd_lookups%ROWTYPE;
453: l_meaning fnd_lookups.meaning%TYPE := NULL;
454: l_sysdate DATE := SYSDATE ;
455:
456: CURSOR l_lookup_csr
457: (cp_lookup_type VARCHAR2,

Line 460: FROM fnd_lookups fndlup

456: CURSOR l_lookup_csr
457: (cp_lookup_type VARCHAR2,
458: cp_lookup_code VARCHAR2) IS
459: SELECT *
460: FROM fnd_lookups fndlup
461: WHERE fndlup.lookup_type = cp_lookup_type
462: AND fndlup.lookup_code = cp_lookup_code;
463:
464: BEGIN

Line 538: l_lookup_type fnd_lookups.lookup_type%TYPE := NULL;

534: FROM okc_rule_defs_v rd
535: WHERE rd.application_id = 540
536: AND rd.rule_code = cp_rule_code;
537:
538: l_lookup_type fnd_lookups.lookup_type%TYPE := NULL;
539: l_token_value fnd_lookups.description%TYPE := NULL;
540:
541: BEGIN
542:

Line 539: l_token_value fnd_lookups.description%TYPE := NULL;

535: WHERE rd.application_id = 540
536: AND rd.rule_code = cp_rule_code;
537:
538: l_lookup_type fnd_lookups.lookup_type%TYPE := NULL;
539: l_token_value fnd_lookups.description%TYPE := NULL;
540:
541: BEGIN
542:
543: IF p_token1_type IS NOT NULL

Line 910: l_group_meaning fnd_lookups.meaning%TYPE;

906: WHERE rd.application_id = 540
907: AND rd.rule_code = cp_rule_code;
908:
909: l_rule_meaning okc_rule_defs_v.meaning%TYPE;
910: l_group_meaning fnd_lookups.meaning%TYPE;
911: l_label_value VARCHAR2(2000) := NULL;
912:
913: BEGIN
914: