eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_PKG dependencies on FND_DATE

Line 122: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),

118: details.TIME_BUILDING_BLOCK_ID,
119: details.TYPE,
120: details.MEASURE,
121: details.UNIT_OF_MEASURE,
122: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
123: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
124: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
125: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
126: details.PARENT_BUILDING_BLOCK_ID,

Line 123: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,

119: details.TYPE,
120: details.MEASURE,
121: details.UNIT_OF_MEASURE,
122: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
123: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
124: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
125: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
126: details.PARENT_BUILDING_BLOCK_ID,
127: NULL PARENT_IS_NEW,

Line 124: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),

120: details.MEASURE,
121: details.UNIT_OF_MEASURE,
122: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
123: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
124: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
125: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
126: details.PARENT_BUILDING_BLOCK_ID,
127: NULL PARENT_IS_NEW,
128: details.SCOPE,

Line 125: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,

121: details.UNIT_OF_MEASURE,
122: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
123: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
124: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
125: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
126: details.PARENT_BUILDING_BLOCK_ID,
127: NULL PARENT_IS_NEW,
128: details.SCOPE,
129: details.OBJECT_VERSION_NUMBER,

Line 134: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,

130: details.APPROVAL_STATUS,
131: details.RESOURCE_ID,
132: details.RESOURCE_TYPE,
133: details.APPROVAL_STYLE_ID,
134: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
135: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
136: details.COMMENT_TEXT,
137: details.PARENT_BUILDING_BLOCK_OVN,
138: 'N' NEW,

Line 135: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,

131: details.RESOURCE_ID,
132: details.RESOURCE_TYPE,
133: details.APPROVAL_STYLE_ID,
134: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
135: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
136: details.COMMENT_TEXT,
137: details.PARENT_BUILDING_BLOCK_OVN,
138: 'N' NEW,
139: 'N' CHANGED,

Line 171: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),

167: details.TIME_BUILDING_BLOCK_ID,
168: details.TYPE,
169: details.MEASURE,
170: details.UNIT_OF_MEASURE,
171: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
172: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
173: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
174: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
175: details.PARENT_BUILDING_BLOCK_ID,

Line 172: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,

168: details.TYPE,
169: details.MEASURE,
170: details.UNIT_OF_MEASURE,
171: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
172: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
173: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
174: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
175: details.PARENT_BUILDING_BLOCK_ID,
176: NULL PARENT_IS_NEW,

Line 173: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),

169: details.MEASURE,
170: details.UNIT_OF_MEASURE,
171: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
172: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
173: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
174: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
175: details.PARENT_BUILDING_BLOCK_ID,
176: NULL PARENT_IS_NEW,
177: details.SCOPE,

Line 174: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,

170: details.UNIT_OF_MEASURE,
171: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
172: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
173: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
174: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
175: details.PARENT_BUILDING_BLOCK_ID,
176: NULL PARENT_IS_NEW,
177: details.SCOPE,
178: details.OBJECT_VERSION_NUMBER,

Line 183: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,

179: details.APPROVAL_STATUS,
180: details.RESOURCE_ID,
181: details.RESOURCE_TYPE,
182: details.APPROVAL_STYLE_ID,
183: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
184: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
185: details.COMMENT_TEXT,
186: details.PARENT_BUILDING_BLOCK_OVN,
187: 'N' NEW,

Line 184: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,

180: details.RESOURCE_ID,
181: details.RESOURCE_TYPE,
182: details.APPROVAL_STYLE_ID,
183: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
184: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
185: details.COMMENT_TEXT,
186: details.PARENT_BUILDING_BLOCK_OVN,
187: 'N' NEW,
188: 'N' CHANGED,

Line 1688: FND_MESSAGE.SET_TOKEN('DATE',FND_DATE.DATE_TO_CANONICAL(p_day_start_time));

1684: g_error_table(g_error_count).MESSAGE_NAME := 'HXC_NO_APRL_PERIOD_PREF';
1685: g_error_table(g_error_count).APPLICATION_SHORT_NAME := 'HXC';
1686: --
1687: FND_MESSAGE.SET_NAME('HXC','HXC_NO_APRL_PERIOD_PREF');
1688: FND_MESSAGE.SET_TOKEN('DATE',FND_DATE.DATE_TO_CANONICAL(p_day_start_time));
1689: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',p_resource_id);
1690: FND_MESSAGE.RAISE_ERROR;
1691:
1692: end if;

Line 4867: := fnd_date.date_to_canonical(p_approved_time);

4863: -- l_time_recipient varchar2(150);
4864: -- l_item_key varchar2(150);
4865: l_notified_status varchar2(150) := 'FINISHED';
4866: l_approved_time varchar2(150)
4867: := fnd_date.date_to_canonical(p_approved_time);
4868: -- := to_char(p_approved_time, 'DD-MM-YYYY HH:MM:SS');
4869: l_approval_comment varchar2(150) := p_approval_comment;
4870: l_approved_status varchar2(150) := p_approval_status;
4871: l_delegated_for varchar2(150) := p_delegated_for;