DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on FND_DATE

Line 1665: p_rec_period_start_date => fnd_date.canonical_to_date

1661: hr_utility.set_location(g_package||l_proc, 10);
1662: END IF;
1663:
1664: find_current_period(
1665: p_rec_period_start_date => fnd_date.canonical_to_date
1666: (p_rec_period_start_date)
1667: ,p_period_type => p_period_type
1668: ,p_duration_in_days => p_duration_in_days
1669: ,p_current_date => TO_DATE(p_current_date, g_date_format)

Line 1731: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);

1727: l_plan_name VARCHAR2(80);
1728: --
1729: BEGIN
1730: --
1731: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
1732: --
1733: IF (p_plan_code = 'MONTHLY') THEN
1734: l_plan_name := 'LGE_TL_MonthlyLeave_AP';
1735: ELSE

Line 2166: fnd_date.date_to_canonical(c_timecard.START_TIME),

2162: c_timecard.TIME_BUILDING_BLOCK_ID,
2163: c_timecard.TYPE,
2164: c_timecard.MEASURE,
2165: c_timecard.UNIT_OF_MEASURE,
2166: fnd_date.date_to_canonical(c_timecard.START_TIME),
2167: fnd_date.date_to_canonical(c_timecard.STOP_TIME),
2168: c_timecard.PARENT_BUILDING_BLOCK_ID,
2169: c_timecard.PARENT_IS_NEW,
2170: c_timecard.SCOPE,

Line 2167: fnd_date.date_to_canonical(c_timecard.STOP_TIME),

2163: c_timecard.TYPE,
2164: c_timecard.MEASURE,
2165: c_timecard.UNIT_OF_MEASURE,
2166: fnd_date.date_to_canonical(c_timecard.START_TIME),
2167: fnd_date.date_to_canonical(c_timecard.STOP_TIME),
2168: c_timecard.PARENT_BUILDING_BLOCK_ID,
2169: c_timecard.PARENT_IS_NEW,
2170: c_timecard.SCOPE,
2171: c_timecard.OBJECT_VERSION_NUMBER,

Line 2176: fnd_date.date_to_canonical(c_timecard.DATE_FROM),

2172: c_timecard.APPROVAL_STATUS,
2173: c_timecard.RESOURCE_ID,
2174: c_timecard.RESOURCE_TYPE,
2175: c_timecard.APPROVAL_STYLE_ID,
2176: fnd_date.date_to_canonical(c_timecard.DATE_FROM),
2177: fnd_date.date_to_canonical(c_timecard.DATE_TO),
2178: c_timecard.COMMENT_TEXT,
2179: c_timecard.PARENT_BUILDING_BLOCK_OVN,
2180: c_timecard.NEW,

Line 2177: fnd_date.date_to_canonical(c_timecard.DATE_TO),

2173: c_timecard.RESOURCE_ID,
2174: c_timecard.RESOURCE_TYPE,
2175: c_timecard.APPROVAL_STYLE_ID,
2176: fnd_date.date_to_canonical(c_timecard.DATE_FROM),
2177: fnd_date.date_to_canonical(c_timecard.DATE_TO),
2178: c_timecard.COMMENT_TEXT,
2179: c_timecard.PARENT_BUILDING_BLOCK_OVN,
2180: c_timecard.NEW,
2181: c_timecard.CHANGED,

Line 2206: fnd_date.date_to_canonical(c_day_info.START_TIME),

2202: c_day_info.TIME_BUILDING_BLOCK_ID,
2203: c_day_info.TYPE,
2204: c_day_info.MEASURE,
2205: c_day_info.UNIT_OF_MEASURE,
2206: fnd_date.date_to_canonical(c_day_info.START_TIME),
2207: fnd_date.date_to_canonical(c_day_info.STOP_TIME),
2208: c_day_info.PARENT_BUILDING_BLOCK_ID,
2209: c_day_info.PARENT_IS_NEW,
2210: c_day_info.SCOPE,

Line 2207: fnd_date.date_to_canonical(c_day_info.STOP_TIME),

2203: c_day_info.TYPE,
2204: c_day_info.MEASURE,
2205: c_day_info.UNIT_OF_MEASURE,
2206: fnd_date.date_to_canonical(c_day_info.START_TIME),
2207: fnd_date.date_to_canonical(c_day_info.STOP_TIME),
2208: c_day_info.PARENT_BUILDING_BLOCK_ID,
2209: c_day_info.PARENT_IS_NEW,
2210: c_day_info.SCOPE,
2211: c_day_info.OBJECT_VERSION_NUMBER,

Line 2216: fnd_date.date_to_canonical(c_day_info.DATE_FROM),

2212: c_day_info.APPROVAL_STATUS,
2213: c_day_info.RESOURCE_ID,
2214: c_day_info.RESOURCE_TYPE,
2215: c_day_info.APPROVAL_STYLE_ID,
2216: fnd_date.date_to_canonical(c_day_info.DATE_FROM),
2217: fnd_date.date_to_canonical(c_day_info.DATE_TO),
2218: c_day_info.COMMENT_TEXT,
2219: c_day_info.PARENT_BUILDING_BLOCK_OVN,
2220: c_day_info.NEW,

Line 2217: fnd_date.date_to_canonical(c_day_info.DATE_TO),

2213: c_day_info.RESOURCE_ID,
2214: c_day_info.RESOURCE_TYPE,
2215: c_day_info.APPROVAL_STYLE_ID,
2216: fnd_date.date_to_canonical(c_day_info.DATE_FROM),
2217: fnd_date.date_to_canonical(c_day_info.DATE_TO),
2218: c_day_info.COMMENT_TEXT,
2219: c_day_info.PARENT_BUILDING_BLOCK_OVN,
2220: c_day_info.NEW,
2221: c_day_info.CHANGED,

Line 2245: fnd_date.date_to_canonical(c_detail_info.START_TIME),

2241: c_detail_info.TIME_BUILDING_BLOCK_ID,
2242: c_detail_info.TYPE,
2243: c_detail_info.MEASURE,
2244: c_detail_info.UNIT_OF_MEASURE,
2245: fnd_date.date_to_canonical(c_detail_info.START_TIME),
2246: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),
2247: c_detail_info.PARENT_BUILDING_BLOCK_ID,
2248: c_detail_info.PARENT_IS_NEW,
2249: c_detail_info.SCOPE,

Line 2246: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),

2242: c_detail_info.TYPE,
2243: c_detail_info.MEASURE,
2244: c_detail_info.UNIT_OF_MEASURE,
2245: fnd_date.date_to_canonical(c_detail_info.START_TIME),
2246: fnd_date.date_to_canonical(c_detail_info.STOP_TIME),
2247: c_detail_info.PARENT_BUILDING_BLOCK_ID,
2248: c_detail_info.PARENT_IS_NEW,
2249: c_detail_info.SCOPE,
2250: c_detail_info.OBJECT_VERSION_NUMBER,

Line 2255: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),

2251: c_detail_info.APPROVAL_STATUS,
2252: c_detail_info.RESOURCE_ID,
2253: c_detail_info.RESOURCE_TYPE,
2254: c_detail_info.APPROVAL_STYLE_ID,
2255: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),
2256: fnd_date.date_to_canonical(c_detail_info.DATE_TO),
2257: c_detail_info.COMMENT_TEXT,
2258: c_detail_info.PARENT_BUILDING_BLOCK_OVN,
2259: c_detail_info.NEW,

Line 2256: fnd_date.date_to_canonical(c_detail_info.DATE_TO),

2252: c_detail_info.RESOURCE_ID,
2253: c_detail_info.RESOURCE_TYPE,
2254: c_detail_info.APPROVAL_STYLE_ID,
2255: fnd_date.date_to_canonical(c_detail_info.DATE_FROM),
2256: fnd_date.date_to_canonical(c_detail_info.DATE_TO),
2257: c_detail_info.COMMENT_TEXT,
2258: c_detail_info.PARENT_BUILDING_BLOCK_OVN,
2259: c_detail_info.NEW,
2260: c_detail_info.CHANGED,