DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on FND_DATE

Line 246: l_calculation_date := trunc(fnd_date.canonical_to_date(p_calculation_date));

242: end;
243:
244: write_log('l_session_date: '||to_char(l_session_date), DEBUG);
245:
246: l_calculation_date := trunc(fnd_date.canonical_to_date(p_calculation_date));
247:
248: write_log('l_calculation_date: '||to_char(l_calculation_date), DEBUG);
249: --
250: -- If no plan parameters are passed, process all plans.

Line 1004: -- scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */

1000: --
1001: write_log(l_proc||', 100', DEBUG);
1002:
1003: inp_value_id_tbl(1) := p_co_date_input_value_id;
1004: -- scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1005: scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1006:
1007: inp_value_id_tbl(2) := p_co_input_val_id;
1008: scr_valuetbl(2) := to_char(l_carryover); -- Bug 4752106

Line 1005: scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1001: write_log(l_proc||', 100', DEBUG);
1002:
1003: inp_value_id_tbl(1) := p_co_date_input_value_id;
1004: -- scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1005: scr_valuetbl(1) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1006:
1007: inp_value_id_tbl(2) := p_co_input_val_id;
1008: scr_valuetbl(2) := to_char(l_carryover); -- Bug 4752106
1009:

Line 1011: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */

1007: inp_value_id_tbl(2) := p_co_input_val_id;
1008: scr_valuetbl(2) := to_char(l_carryover); -- Bug 4752106
1009:
1010: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;
1011: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */
1012: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1013:
1014:
1015: write_log(l_proc||', 105', DEBUG);

Line 1012: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1008: scr_valuetbl(2) := to_char(l_carryover); -- Bug 4752106
1009:
1010: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;
1011: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */
1012: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1013:
1014:
1015: write_log(l_proc||', 105', DEBUG);
1016:

Line 1043: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */

1039: inp_value_id_tbl(1) := p_co_input_val_id;
1040: scr_valuetbl(1) := to_char(l_carryover); -- Bug 4752106
1041:
1042: inp_value_id_tbl(2) := p_co_date_input_value_id;
1043: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1044: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1045:
1046:
1047: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;

Line 1044: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1040: scr_valuetbl(1) := to_char(l_carryover); -- Bug 4752106
1041:
1042: inp_value_id_tbl(2) := p_co_date_input_value_id;
1043: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1044: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1045:
1046:
1047: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;
1048: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */

Line 1048: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */

1044: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1045:
1046:
1047: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;
1048: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */
1049: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1050:
1051: hr_entry_api.update_element_entry(
1052: p_dt_update_mode => 'CORRECTION',

Line 1049: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1045:
1046:
1047: inp_value_id_tbl(3) := p_co_exp_date_input_value_id;
1048: -- scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date); /* COMMENTED FOR BUG 11830805 */
1049: scr_valuetbl(3) := fnd_date.date_to_displaydate(l_expiry_date, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1050:
1051: hr_entry_api.update_element_entry(
1052: p_dt_update_mode => 'CORRECTION',
1053: p_session_date => l_start_date,

Line 1089: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */

1085: inp_value_id_tbl(1) := p_res_input_val_id;
1086: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1087:
1088: inp_value_id_tbl(2) := p_res_date_input_value_id;
1089: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1090: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1091:
1092:
1093: hr_entry_api.insert_element_entry(

Line 1090: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1086: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1087:
1088: inp_value_id_tbl(2) := p_res_date_input_value_id;
1089: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1090: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1091:
1092:
1093: hr_entry_api.insert_element_entry(
1094: p_effective_start_date => l_start_date,

Line 1118: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */

1114: inp_value_id_tbl(1) := p_res_input_val_id;
1115: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1116:
1117: inp_value_id_tbl(2) := P_res_date_input_value_id;
1118: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1119: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1120: hr_entry_api.update_element_entry(
1121: p_dt_update_mode => 'CORRECTION',
1122: p_session_date => l_start_date,

Line 1119: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */

1115: scr_valuetbl(1) := to_char(l_residual); -- Bug 4752106
1116:
1117: inp_value_id_tbl(2) := P_res_date_input_value_id;
1118: -- scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1); /* COMMENTED FOR BUG 11830805 */
1119: scr_valuetbl(2) := fnd_date.date_to_displaydate(l_effective_date + 1, calendar_aware=>FND_DATE.calendar_aware_alt); /* FOR BUG 11830805 */
1120: hr_entry_api.update_element_entry(
1121: p_dt_update_mode => 'CORRECTION',
1122: p_session_date => l_start_date,
1123: p_element_entry_id => l_res_ele_entry_id,