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_DEPOSIT_WRAPPER_UTILITIES dependencies on FND_DATE

Line 773: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date

769: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
770: select rp.period_type
771: ,rp.duration_in_days
772: ,p.number_per_fiscal_year
773: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
774: from hxc_recurring_periods rp
775: ,per_time_period_types p
776: where p.period_type (+) = rp.period_type
777: and rp.recurring_period_id = p_recurring_period_id;

Line 1041: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).START_TIME)

1037: ,p_blocks(l_block_count).UNIT_OF_MEASURE
1038: );
1039: l_block_string := add_value_to_string
1040: (l_block_string
1041: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).START_TIME)
1042: );
1043: l_block_string := add_value_to_string
1044: (l_block_string
1045: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).STOP_TIME)

Line 1045: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).STOP_TIME)

1041: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).START_TIME)
1042: );
1043: l_block_string := add_value_to_string
1044: (l_block_string
1045: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).STOP_TIME)
1046: );
1047: l_block_string := add_value_to_string
1048: (l_block_string
1049: ,p_blocks(l_block_count).PARENT_BUILDING_BLOCK_ID

Line 1081: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_FROM)

1077: ,p_blocks(l_block_count).APPROVAL_STYLE_ID
1078: );
1079: l_block_string := add_value_to_string
1080: (l_block_string
1081: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_FROM)
1082: );
1083: l_block_string := add_value_to_string
1084: (l_block_string
1085: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_TO)

Line 1085: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_TO)

1081: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_FROM)
1082: );
1083: l_block_string := add_value_to_string
1084: (l_block_string
1085: ,FND_DATE.DATE_TO_CANONICAL(p_blocks(l_block_count).DATE_TO)
1086: );
1087: l_block_string := add_value_to_string
1088: (l_block_string
1089: ,p_blocks(l_block_count).COMMENT_TEXT

Line 1150: l_blocks2(l_block_count).start_time := FND_DATE.CANONICAL_TO_DATE(l_result);

1146: l_blocks2(l_block_count).measure := l_result;
1147: elsif(l_position=3) then
1148: l_blocks2(l_block_count).unit_of_measure := l_result;
1149: elsif(l_position=4) then
1150: l_blocks2(l_block_count).start_time := FND_DATE.CANONICAL_TO_DATE(l_result);
1151: elsif(l_position=5) then
1152: l_blocks2(l_block_count).stop_time := FND_DATE.CANONICAL_TO_DATE(l_result);
1153: elsif(l_position=6) then
1154: l_blocks2(l_block_count).parent_building_block_id := l_result;

Line 1152: l_blocks2(l_block_count).stop_time := FND_DATE.CANONICAL_TO_DATE(l_result);

1148: l_blocks2(l_block_count).unit_of_measure := l_result;
1149: elsif(l_position=4) then
1150: l_blocks2(l_block_count).start_time := FND_DATE.CANONICAL_TO_DATE(l_result);
1151: elsif(l_position=5) then
1152: l_blocks2(l_block_count).stop_time := FND_DATE.CANONICAL_TO_DATE(l_result);
1153: elsif(l_position=6) then
1154: l_blocks2(l_block_count).parent_building_block_id := l_result;
1155: elsif(l_position=7) then
1156: l_blocks2(l_block_count).parent_is_new := l_result;

Line 1170: l_blocks2(l_block_count).date_from := FND_DATE.CANONICAL_TO_DATE(l_result);

1166: l_blocks2(l_block_count).resource_type := l_result;
1167: elsif(l_position=13) then
1168: l_blocks2(l_block_count).approval_style_id := l_result;
1169: elsif(l_position=14) then
1170: l_blocks2(l_block_count).date_from := FND_DATE.CANONICAL_TO_DATE(l_result);
1171: elsif(l_position=15) then
1172: l_blocks2(l_block_count).date_to := FND_DATE.CANONICAL_TO_DATE(l_result);
1173: elsif(l_position=16) then
1174: l_blocks2(l_block_count).comment_text := l_result;

Line 1172: l_blocks2(l_block_count).date_to := FND_DATE.CANONICAL_TO_DATE(l_result);

1168: l_blocks2(l_block_count).approval_style_id := l_result;
1169: elsif(l_position=14) then
1170: l_blocks2(l_block_count).date_from := FND_DATE.CANONICAL_TO_DATE(l_result);
1171: elsif(l_position=15) then
1172: l_blocks2(l_block_count).date_to := FND_DATE.CANONICAL_TO_DATE(l_result);
1173: elsif(l_position=16) then
1174: l_blocks2(l_block_count).comment_text := l_result;
1175: elsif(l_position=17) then
1176: l_blocks2(l_block_count).parent_building_block_ovn := l_result;

Line 1226: := FND_DATE.CANONICAL_TO_DATE(

1222: (p_string => p_block_string
1223: ,p_value_index => l_value_index);
1224: l_value_index := l_value_index +1;
1225: l_blocks(l_block_count).START_TIME
1226: := FND_DATE.CANONICAL_TO_DATE(
1227: get_value_from_string
1228: (p_string => p_block_string
1229: ,p_value_index => l_value_index));
1230: l_value_index := l_value_index +1;

Line 1232: := FND_DATE.CANONICAL_TO_DATE(

1228: (p_string => p_block_string
1229: ,p_value_index => l_value_index));
1230: l_value_index := l_value_index +1;
1231: l_blocks(l_block_count).STOP_TIME
1232: := FND_DATE.CANONICAL_TO_DATE(
1233: get_value_from_string
1234: (p_string => p_block_string
1235: ,p_value_index => l_value_index));
1236: l_value_index := l_value_index +1;

Line 1278: := FND_DATE.CANONICAL_TO_DATE(

1274: (p_string => p_block_string
1275: ,p_value_index => l_value_index);
1276: l_value_index := l_value_index +1;
1277: l_blocks(l_block_count).DATE_FROM
1278: := FND_DATE.CANONICAL_TO_DATE(
1279: get_value_from_string
1280: (p_string => p_block_string
1281: ,p_value_index => l_value_index));
1282: l_value_index := l_value_index +1;

Line 1284: := FND_DATE.CANONICAL_TO_DATE(

1280: (p_string => p_block_string
1281: ,p_value_index => l_value_index));
1282: l_value_index := l_value_index +1;
1283: l_blocks(l_block_count).DATE_TO
1284: := FND_DATE.CANONICAL_TO_DATE(
1285: get_value_from_string
1286: (p_string => p_block_string
1287: ,p_value_index => l_value_index));
1288: l_value_index := l_value_index +1;

Line 2589: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);

2585:
2586:
2587: -- convert params
2588: l_resource_id := p_resource_id;
2589: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2590: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2591:
2592: IF g_debug THEN
2593: hr_utility.trace(' Get list of valid aliases for this period.');

Line 2590: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);

2586:
2587: -- convert params
2588: l_resource_id := p_resource_id;
2589: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2590: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2591:
2592: IF g_debug THEN
2593: hr_utility.trace(' Get list of valid aliases for this period.');
2594: END IF;

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

2637:
2638: -- pull out TC_W_TCRD_ALIASES values
2639:
2640: l_index:=l_aliases.FIRST;
2641: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2642: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2643:
2644: -- first check to see that aliases have been setup for this person!!!
2645: -- v115.23

Line 2642: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);

2638: -- pull out TC_W_TCRD_ALIASES values
2639:
2640: l_index:=l_aliases.FIRST;
2641: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2642: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2643:
2644: -- first check to see that aliases have been setup for this person!!!
2645: -- v115.23
2646:

Line 3063: fnd_date.canonical_to_date(p_block_array(l_array_index).START_TIME);

3059: p_block_array(l_array_index).MEASURE;
3060: l_blocks(l_array_index).UNIT_OF_MEASURE :=
3061: p_block_array(l_array_index).UNIT_OF_MEASURE;
3062: l_blocks(l_array_index).START_TIME :=
3063: fnd_date.canonical_to_date(p_block_array(l_array_index).START_TIME);
3064: l_blocks(l_array_index).STOP_TIME :=
3065: fnd_date.canonical_to_date(p_block_array(l_array_index).STOP_TIME);
3066: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_ID :=
3067: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_ID;

Line 3065: fnd_date.canonical_to_date(p_block_array(l_array_index).STOP_TIME);

3061: p_block_array(l_array_index).UNIT_OF_MEASURE;
3062: l_blocks(l_array_index).START_TIME :=
3063: fnd_date.canonical_to_date(p_block_array(l_array_index).START_TIME);
3064: l_blocks(l_array_index).STOP_TIME :=
3065: fnd_date.canonical_to_date(p_block_array(l_array_index).STOP_TIME);
3066: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_ID :=
3067: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_ID;
3068: l_blocks(l_array_index).PARENT_IS_NEW :=
3069: p_block_array(l_array_index).PARENT_IS_NEW;

Line 3083: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_FROM);

3079: p_block_array(l_array_index).RESOURCE_TYPE;
3080: l_blocks(l_array_index).APPROVAL_STYLE_ID :=
3081: p_block_array(l_array_index).APPROVAL_STYLE_ID;
3082: l_blocks(l_array_index).DATE_FROM :=
3083: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_FROM);
3084: l_blocks(l_array_index).DATE_TO :=
3085: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_TO);
3086: l_blocks(l_array_index).COMMENT_TEXT :=
3087: p_block_array(l_array_index).COMMENT_TEXT;

Line 3085: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_TO);

3081: p_block_array(l_array_index).APPROVAL_STYLE_ID;
3082: l_blocks(l_array_index).DATE_FROM :=
3083: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_FROM);
3084: l_blocks(l_array_index).DATE_TO :=
3085: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_TO);
3086: l_blocks(l_array_index).COMMENT_TEXT :=
3087: p_block_array(l_array_index).COMMENT_TEXT;
3088: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_OVN:=
3089: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_OVN;

Line 3135: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)

3131: p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID
3132: ,p_blocks(l_block_index).TYPE
3133: ,p_blocks(l_block_index).MEASURE
3134: ,p_blocks(l_block_index).UNIT_OF_MEASURE
3135: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
3136: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
3137: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
3138: ,p_blocks(l_block_index).PARENT_IS_NEW
3139: ,p_blocks(l_block_index).SCOPE

Line 3136: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)

3132: ,p_blocks(l_block_index).TYPE
3133: ,p_blocks(l_block_index).MEASURE
3134: ,p_blocks(l_block_index).UNIT_OF_MEASURE
3135: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
3136: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
3137: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
3138: ,p_blocks(l_block_index).PARENT_IS_NEW
3139: ,p_blocks(l_block_index).SCOPE
3140: ,p_blocks(l_block_index).OBJECT_VERSION_NUMBER

Line 3145: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)

3141: ,p_blocks(l_block_index).APPROVAL_STATUS
3142: ,p_blocks(l_block_index).RESOURCE_ID
3143: ,p_blocks(l_block_index).RESOURCE_TYPE
3144: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
3145: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
3146: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
3147: ,p_blocks(l_block_index).COMMENT_TEXT
3148: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
3149: ,p_blocks(l_block_index).NEW

Line 3146: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)

3142: ,p_blocks(l_block_index).RESOURCE_ID
3143: ,p_blocks(l_block_index).RESOURCE_TYPE
3144: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
3145: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
3146: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
3147: ,p_blocks(l_block_index).COMMENT_TEXT
3148: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
3149: ,p_blocks(l_block_index).NEW
3150: ,p_blocks(l_block_index).CHANGED