APPS.JE_JEPLPSSR_XMLP_PKG dependencies on FND_LOOKUPS

Line 47: NLS_YES FND_LOOKUPS.MEANING%TYPE;

43: FUNCTION GET_NLS_STRINGS RETURN BOOLEAN IS
44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: NLS_YES FND_LOOKUPS.MEANING%TYPE;
48: NLS_NO FND_LOOKUPS.MEANING%TYPE;
49: BEGIN
50: SELECT
51: LY.MEANING,

Line 48: NLS_NO FND_LOOKUPS.MEANING%TYPE;

44: NLS_VOID AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
45: NLS_NA AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
46: NLS_ALL AP_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
47: NLS_YES FND_LOOKUPS.MEANING%TYPE;
48: NLS_NO FND_LOOKUPS.MEANING%TYPE;
49: BEGIN
50: SELECT
51: LY.MEANING,
52: LN.MEANING,

Line 58: FND_LOOKUPS LY,

54: L2.DISPLAYED_FIELD,
55: L3.DISPLAYED_FIELD
56: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
57: FROM
58: FND_LOOKUPS LY,
59: FND_LOOKUPS LN,
60: AP_LOOKUP_CODES L1,
61: AP_LOOKUP_CODES L2,
62: AP_LOOKUP_CODES L3

Line 59: FND_LOOKUPS LN,

55: L3.DISPLAYED_FIELD
56: INTO NLS_YES,NLS_NO,NLS_ALL,NLS_VOID,NLS_NA
57: FROM
58: FND_LOOKUPS LY,
59: FND_LOOKUPS LN,
60: AP_LOOKUP_CODES L1,
61: AP_LOOKUP_CODES L2,
62: AP_LOOKUP_CODES L3
63: WHERE LY.LOOKUP_TYPE = 'YES_NO'

Line 137: FND_LOOKUPS

133: SELECT
134: MEANING
135: INTO P_REPORT_CURRENCY_DISP
136: FROM
137: FND_LOOKUPS
138: WHERE LOOKUP_TYPE = 'JGZZ_CURRENCY_TYPE'
139: AND LOOKUP_CODE = P_REPORT_CURRENCY;
140: CP_REPORT_CURR_DISP := P_REPORT_CURRENCY_DISP;
141: IF (GET_NLS_STRINGS <> TRUE) THEN

Line 261: FND_LOOKUPS L

257: SELECT
258: L.MEANING
259: INTO V_TRANS_TYPE
260: FROM
261: FND_LOOKUPS L
262: WHERE L.LOOKUP_CODE = 'PMT'
263: AND L.LOOKUP_TYPE = 'JLZZ_SUPPLIER_TRX_TYPE'
264: AND NVL(L.START_DATE_ACTIVE
265: ,SYSDATE) <= sysdate

Line 287: FND_LOOKUPS L

283: SELECT
284: L.MEANING
285: INTO V_TRANS_TYPE
286: FROM
287: FND_LOOKUPS L
288: WHERE L.LOOKUP_CODE = 'INV'
289: AND L.LOOKUP_TYPE = 'JLZZ_SUPPLIER_TRX_TYPE'
290: AND NVL(L.START_DATE_ACTIVE
291: ,SYSDATE) <= sysdate

Line 711: A_FLAG FND_LOOKUPS.MEANING%TYPE;

707: END IF;
708: END CF_VENDOR_CHECKFORMULA;
709:
710: FUNCTION CF_POSTED_ONLYFORMULA RETURN CHAR IS
711: A_FLAG FND_LOOKUPS.MEANING%TYPE;
712: BEGIN
713: SELECT
714: DECODE(P_POSTED
715: ,'Y'

Line 726: A_FLAG FND_LOOKUPS.MEANING%TYPE;

722: RETURN (A_FLAG);
723: END CF_POSTED_ONLYFORMULA;
724:
725: FUNCTION CF_APPROVED_ONLYFORMULA RETURN CHAR IS
726: A_FLAG FND_LOOKUPS.MEANING%TYPE;
727: BEGIN
728: SELECT
729: DECODE(P_APPROVED
730: ,'Y'

Line 987: FND_LOOKUPS

983: SELECT
984: MEANING
985: INTO P_PARAMETERS_DESC
986: FROM
987: FND_LOOKUPS
988: WHERE LOOKUP_CODE = P_YES_NO
989: AND LOOKUP_TYPE = 'YES_NO';
990: CP_PARAMETERS_DESC:=P_PARAMETERS_DESC;
991: RETURN CP_PARAMETERS_DESC;