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 2483: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);

2479:
2480:
2481: -- convert params
2482: l_resource_id := p_resource_id;
2483: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2484: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2485:
2486: -- get list of valid aliases for this period
2487:

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

2480:
2481: -- convert params
2482: l_resource_id := p_resource_id;
2483: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2484: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2485:
2486: -- get list of valid aliases for this period
2487:
2488: IF (p_alias_or_element_id = 'ALIAS'

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

2511:
2512: -- pull out TC_W_TCRD_ALIASES values
2513:
2514: l_index:=l_aliases.FIRST;
2515: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2516: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2517:
2518: -- first check to see that aliases have been setup for this person!!!
2519: -- v115.23

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

2512: -- pull out TC_W_TCRD_ALIASES values
2513:
2514: l_index:=l_aliases.FIRST;
2515: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2516: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2517:
2518: -- first check to see that aliases have been setup for this person!!!
2519: -- v115.23
2520:

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

2803: p_block_array(l_array_index).MEASURE;
2804: l_blocks(l_array_index).UNIT_OF_MEASURE :=
2805: p_block_array(l_array_index).UNIT_OF_MEASURE;
2806: l_blocks(l_array_index).START_TIME :=
2807: fnd_date.canonical_to_date(p_block_array(l_array_index).START_TIME);
2808: l_blocks(l_array_index).STOP_TIME :=
2809: fnd_date.canonical_to_date(p_block_array(l_array_index).STOP_TIME);
2810: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_ID :=
2811: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_ID;

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

2805: p_block_array(l_array_index).UNIT_OF_MEASURE;
2806: l_blocks(l_array_index).START_TIME :=
2807: fnd_date.canonical_to_date(p_block_array(l_array_index).START_TIME);
2808: l_blocks(l_array_index).STOP_TIME :=
2809: fnd_date.canonical_to_date(p_block_array(l_array_index).STOP_TIME);
2810: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_ID :=
2811: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_ID;
2812: l_blocks(l_array_index).PARENT_IS_NEW :=
2813: p_block_array(l_array_index).PARENT_IS_NEW;

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

2823: p_block_array(l_array_index).RESOURCE_TYPE;
2824: l_blocks(l_array_index).APPROVAL_STYLE_ID :=
2825: p_block_array(l_array_index).APPROVAL_STYLE_ID;
2826: l_blocks(l_array_index).DATE_FROM :=
2827: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_FROM);
2828: l_blocks(l_array_index).DATE_TO :=
2829: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_TO);
2830: l_blocks(l_array_index).COMMENT_TEXT :=
2831: p_block_array(l_array_index).COMMENT_TEXT;

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

2825: p_block_array(l_array_index).APPROVAL_STYLE_ID;
2826: l_blocks(l_array_index).DATE_FROM :=
2827: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_FROM);
2828: l_blocks(l_array_index).DATE_TO :=
2829: fnd_date.canonical_to_date(p_block_array(l_array_index).DATE_TO);
2830: l_blocks(l_array_index).COMMENT_TEXT :=
2831: p_block_array(l_array_index).COMMENT_TEXT;
2832: l_blocks(l_array_index).PARENT_BUILDING_BLOCK_OVN:=
2833: p_block_array(l_array_index).PARENT_BUILDING_BLOCK_OVN;

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

2875: p_blocks(l_block_index).TIME_BUILDING_BLOCK_ID
2876: ,p_blocks(l_block_index).TYPE
2877: ,p_blocks(l_block_index).MEASURE
2878: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2879: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2880: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2881: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2882: ,p_blocks(l_block_index).PARENT_IS_NEW
2883: ,p_blocks(l_block_index).SCOPE

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

2876: ,p_blocks(l_block_index).TYPE
2877: ,p_blocks(l_block_index).MEASURE
2878: ,p_blocks(l_block_index).UNIT_OF_MEASURE
2879: ,fnd_date.date_to_canonical(p_blocks(l_block_index).START_TIME)
2880: ,fnd_date.date_to_canonical(p_blocks(l_block_index).STOP_TIME)
2881: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_ID
2882: ,p_blocks(l_block_index).PARENT_IS_NEW
2883: ,p_blocks(l_block_index).SCOPE
2884: ,p_blocks(l_block_index).OBJECT_VERSION_NUMBER

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

2885: ,p_blocks(l_block_index).APPROVAL_STATUS
2886: ,p_blocks(l_block_index).RESOURCE_ID
2887: ,p_blocks(l_block_index).RESOURCE_TYPE
2888: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2889: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2890: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2891: ,p_blocks(l_block_index).COMMENT_TEXT
2892: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2893: ,p_blocks(l_block_index).NEW

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

2886: ,p_blocks(l_block_index).RESOURCE_ID
2887: ,p_blocks(l_block_index).RESOURCE_TYPE
2888: ,p_blocks(l_block_index).APPROVAL_STYLE_ID
2889: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_FROM)
2890: ,fnd_date.date_to_canonical(p_blocks(l_block_index).DATE_TO)
2891: ,p_blocks(l_block_index).COMMENT_TEXT
2892: ,p_blocks(l_block_index).PARENT_BUILDING_BLOCK_OVN
2893: ,p_blocks(l_block_index).NEW
2894: ,p_blocks(l_block_index).CHANGED