APPS.RLM_RLMDMCOM_XMLP_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 10: FND_LOOKUP_VALUES_VL

6: CURSOR CUR_SCHEDULE_TYPE(V_SCHEDULE_TYPE IN VARCHAR2) IS
7: SELECT
8: MEANING
9: FROM
10: FND_LOOKUP_VALUES_VL
11: WHERE LOOKUP_TYPE = 'RLM_SCHEDULE_TYPE'
12: AND LOOKUP_CODE = V_SCHEDULE_TYPE
13: AND ENABLED_FLAG = 'Y';
14: CURSOR CUR_SCH_REF_NUM(V_SCH_REF_NUM IN NUMBER) IS

Line 44: FND_LOOKUP_VALUES_VL

40: CURSOR CUR_DISCREP_ONLY(V_DISCREP IN VARCHAR2) IS
41: SELECT
42: MEANING
43: FROM
44: FND_LOOKUP_VALUES_VL
45: WHERE LOOKUP_TYPE = 'YES_NO'
46: AND LOOKUP_CODE = V_DISCREP
47: AND ENABLED_FLAG = 'Y';
48: CURSOR CUR_SEQ_MATCH(P_SEQ_MATCH IN VARCHAR2) IS

Line 52: FND_LOOKUP_VALUES_VL

48: CURSOR CUR_SEQ_MATCH(P_SEQ_MATCH IN VARCHAR2) IS
49: SELECT
50: MEANING
51: FROM
52: FND_LOOKUP_VALUES_VL
53: WHERE LOOKUP_TYPE = 'RLM_OPTIONAL_MATCH_ATTRIBUTES'
54: AND ENABLED_FLAG = 'Y'
55: AND LOOKUP_CODE = P_SEQ_MATCH;
56: BEGIN

Line 187: FND_LOOKUP_VALUES_VL

183: CURSOR CUR_FIRM_DISP_CODE(V_PRE_HORIZ_DISP_CODE IN VARCHAR2) IS
184: SELECT
185: MEANING
186: FROM
187: FND_LOOKUP_VALUES_VL
188: WHERE LOOKUP_TYPE = 'RLM_FIRM_DISP_CODE'
189: AND LOOKUP_CODE = V_PRE_HORIZ_DISP_CODE;
190: BEGIN
191: OPEN CUR_FIRM_DISP_CODE(PREHORIZON_DESPOSITION_CODE);

Line 207: FND_LOOKUP_VALUES_VL

203: CURSOR CUR_INTRANSIT_CALC(V_INTRANSIT_CAL IN VARCHAR2) IS
204: SELECT
205: MEANING
206: FROM
207: FND_LOOKUP_VALUES_VL
208: WHERE LOOKUP_TYPE = 'RLM_INTRANSIT_CALC_BASIS'
209: AND LOOKUP_CODE = V_INTRANSIT_CAL
210: AND ENABLED_FLAG = 'Y';
211: BEGIN

Line 243: FND_LOOKUP_VALUES_VL

239: SUBSTR(LOOKUP_CODE
240: ,INSTR(LOOKUP_CODE
241: ,',') + 1)
242: FROM
243: FND_LOOKUP_VALUES_VL
244: WHERE LOOKUP_TYPE = 'RLM_OPTIONAL_MATCH_ATTRIBUTES'
245: AND ENABLED_FLAG = 'Y'
246: AND LOOKUP_CODE = P_SEQ_MATCH;
247: BEGIN

Line 351: V_FROZEN_FLAG FND_LOOKUP_VALUES_VL.MEANING%TYPE;

347: RETURN (NULL);
348: END CF_CUSTOMER_NUMBER_MEANFORMULA;
349:
350: FUNCTION CF_FROZEN_FLAGFORMULA(FROZEN_FLAG IN VARCHAR2) RETURN CHAR IS
351: V_FROZEN_FLAG FND_LOOKUP_VALUES_VL.MEANING%TYPE;
352: CURSOR CUR_FROZEN_FLAG(V_FLAG_CODE IN VARCHAR2) IS
353: SELECT
354: MEANING
355: FROM

Line 356: FND_LOOKUP_VALUES_VL

352: CURSOR CUR_FROZEN_FLAG(V_FLAG_CODE IN VARCHAR2) IS
353: SELECT
354: MEANING
355: FROM
356: FND_LOOKUP_VALUES_VL
357: WHERE LOOKUP_TYPE = 'YES_NO'
358: AND LOOKUP_CODE = V_FLAG_CODE
359: AND ENABLED_FLAG = 'Y';
360: BEGIN

Line 372: V_TIME_UOM_CODE FND_LOOKUP_VALUES_VL.MEANING%TYPE;

368: RETURN (NULL);
369: END CF_FROZEN_FLAGFORMULA;
370:
371: FUNCTION CF_TIME_UOM_CODEFORMULA(TIME_UOM_CODE IN VARCHAR2) RETURN CHAR IS
372: V_TIME_UOM_CODE FND_LOOKUP_VALUES_VL.MEANING%TYPE;
373: CURSOR CUR_TIME_UOM_CODE(V_TIME_UOM IN VARCHAR2) IS
374: SELECT
375: MEANING
376: FROM

Line 377: FND_LOOKUP_VALUES_VL

373: CURSOR CUR_TIME_UOM_CODE(V_TIME_UOM IN VARCHAR2) IS
374: SELECT
375: MEANING
376: FROM
377: FND_LOOKUP_VALUES_VL
378: WHERE LOOKUP_TYPE = 'RLM_TIME_UOM'
379: AND LOOKUP_CODE = V_TIME_UOM
380: AND ENABLED_FLAG = 'Y';
381: BEGIN

Line 393: V_EXC_NONWORKDAYS_FLAG FND_LOOKUP_VALUES_VL.MEANING%TYPE;

389: RETURN (NULL);
390: END CF_TIME_UOM_CODEFORMULA;
391:
392: FUNCTION CF_EXCLUDE_NONWORKDAYSFORMULA(EXCLUDE_NON_WORKDAYS_FLAG IN VARCHAR2) RETURN CHAR IS
393: V_EXC_NONWORKDAYS_FLAG FND_LOOKUP_VALUES_VL.MEANING%TYPE;
394: CURSOR CUR_EXC_NONWORK_FLAG(V_EXC_NONWORKDAYS_FLAG IN VARCHAR2) IS
395: SELECT
396: MEANING
397: FROM

Line 398: FND_LOOKUP_VALUES_VL

394: CURSOR CUR_EXC_NONWORK_FLAG(V_EXC_NONWORKDAYS_FLAG IN VARCHAR2) IS
395: SELECT
396: MEANING
397: FROM
398: FND_LOOKUP_VALUES_VL
399: WHERE LOOKUP_TYPE = 'YES_NO'
400: AND LOOKUP_CODE = V_EXC_NONWORKDAYS_FLAG
401: AND ENABLED_FLAG = 'Y';
402: BEGIN