APPS.HXC_APPROVAL_WF_PKG dependencies on FND_DATE

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

104: details.TIME_BUILDING_BLOCK_ID,
105: details.TYPE,
106: details.MEASURE,
107: details.UNIT_OF_MEASURE,
108: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
109: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
110: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
111: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
112: details.PARENT_BUILDING_BLOCK_ID,

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

105: details.TYPE,
106: details.MEASURE,
107: details.UNIT_OF_MEASURE,
108: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
109: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
110: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
111: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
112: details.PARENT_BUILDING_BLOCK_ID,
113: NULL PARENT_IS_NEW,

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

106: details.MEASURE,
107: details.UNIT_OF_MEASURE,
108: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
109: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
110: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
111: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
112: details.PARENT_BUILDING_BLOCK_ID,
113: NULL PARENT_IS_NEW,
114: details.SCOPE,

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

107: details.UNIT_OF_MEASURE,
108: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.start_time),
109: FND_DATE.DATE_TO_CANONICAL(days.start_time) ) CANONICAL_START_TIME,
110: DECODE(details.type, 'RANGE', FND_DATE.DATE_TO_CANONICAL(details.stop_time),
111: FND_DATE.DATE_TO_CANONICAL(days.stop_time) ) CANONICAL_STOP_TIME,
112: details.PARENT_BUILDING_BLOCK_ID,
113: NULL PARENT_IS_NEW,
114: details.SCOPE,
115: details.OBJECT_VERSION_NUMBER,

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

116: details.APPROVAL_STATUS,
117: details.RESOURCE_ID,
118: details.RESOURCE_TYPE,
119: details.APPROVAL_STYLE_ID,
120: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
121: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
122: details.COMMENT_TEXT,
123: details.PARENT_BUILDING_BLOCK_OVN,
124: 'N' NEW,

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

117: details.RESOURCE_ID,
118: details.RESOURCE_TYPE,
119: details.APPROVAL_STYLE_ID,
120: FND_DATE.DATE_TO_CANONICAL(details.date_from) CANONICAL_DATE_FROM,
121: FND_DATE.DATE_TO_CANONICAL(details.date_to) CANONICAL_DATE_TO,
122: details.COMMENT_TEXT,
123: details.PARENT_BUILDING_BLOCK_OVN,
124: 'N' NEW,
125: 'N' CHANGED,

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

1505: g_error_table(g_error_count).MESSAGE_NAME := 'HXC_NO_APRL_PERIOD_PREF';
1506: g_error_table(g_error_count).APPLICATION_SHORT_NAME := 'HXC';
1507: --
1508: FND_MESSAGE.SET_NAME('HXC','HXC_NO_APRL_PERIOD_PREF');
1509: FND_MESSAGE.SET_TOKEN('DATE',FND_DATE.DATE_TO_CANONICAL(p_day_start_time));
1510: FND_MESSAGE.SET_TOKEN('RESOURCE_ID',p_resource_id);
1511: FND_MESSAGE.RAISE_ERROR;
1512:
1513: end if;

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

4211: -- l_time_recipient varchar2(150);
4212: -- l_item_key varchar2(150);
4213: l_notified_status varchar2(150) := 'FINISHED';
4214: l_approved_time varchar2(150)
4215: := fnd_date.date_to_canonical(p_approved_time);
4216: -- := to_char(p_approved_time, 'DD-MM-YYYY HH:MM:SS');
4217: l_approval_comment varchar2(150) := p_approval_comment;
4218: l_approved_status varchar2(150) := p_approval_status;
4219: l_delegated_for varchar2(150) := p_delegated_for;