DBA Data[Home] [Help]

APPS.GMI_RILSM_XMLP_PKG dependencies on DUAL

Line 19: DUAL;

15: ,'Status Range ' || FROM_STATUS || ' - All '
16: ,'Status Range ' || FROM_STATUS || ' - ' || TO_STATUS))
17: INTO RANGE_STATUS
18: FROM
19: DUAL;
20: RETURN (RANGE_STATUS);
21: END RANGECFFORMULA;
22:
23: FUNCTION ORDERCFFORMULA RETURN VARCHAR2 IS

Line 30: DUAL

26: SELECT
27: 'Asc'
28: INTO ORDER_CF
29: FROM
30: DUAL
31: WHERE ORDER1 = 'Ascending';
32: RETURN (ORDER_CF);
33: RETURN 'Asc';
34: EXCEPTION

Line 59: DUAL;

55: SELECT
56: 'All'
57: INTO FROM_STATUSCP
58: FROM
59: DUAL;
60: ELSE
61: FROM_STATUSCP := FROM_STATUS;
62: END IF;
63: RETURN (FROM_STATUSCP);

Line 73: DUAL;

69: SELECT
70: 'All'
71: INTO TO_STATUSCP
72: FROM
73: DUAL;
74: ELSE
75: TO_STATUSCP := TO_STATUS;
76: END IF;
77: RETURN (TO_STATUSCP);