APPS.IBC_DATA_SECURITY_PVT dependencies on FND_DATE

Line 48: RETURN 'FND_DATE.CANONICAL_TO_DATE(' || p_name || ')';

44: BEGIN
45: IF p_type = 'NUMBER' THEN
46: RETURN 'FND_NUMBER.CANONICAL_TO_NUMBER(' || p_name || ')';
47: ELSIF p_type = 'DATE' THEN
48: RETURN 'FND_DATE.CANONICAL_TO_DATE(' || p_name || ')';
49: ELSE
50: RETURN p_name;
51: END IF;
52: END convert_to_name;

Line 66: RETURN 'FND_DATE.CANONICAL_TO_DATE(''' || p_value || ''')';

62: BEGIN
63: IF p_type = 'NUMBER' THEN
64: RETURN 'FND_NUMBER.CANONICAL_TO_NUMBER(''' || p_value || ''')';
65: ELSIF p_type = 'DATE' THEN
66: RETURN 'FND_DATE.CANONICAL_TO_DATE(''' || p_value || ''')';
67: ELSE
68: RETURN '''' || p_value || '''';
69: END IF;
70: END convert_to_value;

Line 84: RETURN 'FND_DATE.DATE_TO_CANONICAL(' || p_name || ')';

80: BEGIN
81: IF p_type = 'NUMBER' THEN
82: RETURN 'FND_NUMBER.NUMBER_TO_CANONICAL(' || p_name || ')';
83: ELSIF p_type = 'DATE' THEN
84: RETURN 'FND_DATE.DATE_TO_CANONICAL(' || p_name || ')';
85: ELSE
86: RETURN p_name;
87: END IF;
88: END convert_from_name;

Line 102: RETURN 'FND_DATE.DATE_TO_CANONICAL(''' || p_value || ''')';

98: BEGIN
99: IF p_type = 'NUMBER' THEN
100: RETURN 'FND_NUMBER.NUMBER_TO_CANONICAL(''' || p_value || ''')';
101: ELSIF p_type = 'DATE' THEN
102: RETURN 'FND_DATE.DATE_TO_CANONICAL(''' || p_value || ''')';
103: ELSE
104: RETURN '''' || p_value || '''';
105: END IF;
106: END convert_from_value;

Line 119: RETURN FND_DATE.DATE_TO_CANONICAL(TO_DATE(p_value, 'YYYYMMDD HH:MI:SS'));

115: BEGIN
116: IF p_type = 'NUMBER' THEN
117: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(TO_NUMBER(p_value));
118: ELSIF p_type = 'DATE' THEN
119: RETURN FND_DATE.DATE_TO_CANONICAL(TO_DATE(p_value, 'YYYYMMDD HH:MI:SS'));
120: ELSE
121: RETURN p_value;
122: END IF;
123: END canonical_from_value;