DBA Data[Home] [Help]

APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on FND_DATE

Line 297: l_ee_payment_date := fnd_date.canonical_to_date

293: THEN
294: pay_in_utils.trace('l_effective_date',l_effective_date);
295: pay_in_utils.trace('l_assignment_id',l_assignment_id);
296: END IF;
297: l_ee_payment_date := fnd_date.canonical_to_date
298: (
299: get_ee_value(p_element_entry_id
300: ,'Payment Date'
301: ,l_effective_date

Line 494: l_ee_payment_date := fnd_date.canonical_to_date

490: pay_in_utils.trace('l_effective_date',l_effective_date);
491: pay_in_utils.trace('l_assignment_id',l_assignment_id);
492: END IF;
493:
494: l_ee_payment_date := fnd_date.canonical_to_date
495: (
496: get_ee_value(p_element_entry_id
497: ,'Payment Date'
498: ,l_effective_date

Line 1021: l_pre_payment_date := fnd_date.canonical_to_date(get_ee_value(p_element_entry_id,'Payment Date',l_effective_date));

1017: --Record Deletion ends
1018:
1019: IF (p_element_entry_id IS NOT NULL)
1020: THEN
1021: l_pre_payment_date := fnd_date.canonical_to_date(get_ee_value(p_element_entry_id,'Payment Date',l_effective_date));
1022:
1023: IF (g_debug)
1024: THEN
1025: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);

Line 1151: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)

1147: ,p_create_warning => l_warnings
1148: );
1149:
1150: UPDATE pay_element_entry_values_f
1151: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)
1152: WHERE input_value_id = l_input_values_rec(9).input_value_id
1153: AND element_entry_id = l_element_entry_id;
1154:
1155: ELSIF ((p_element_entry_id IS NOT NULL) AND (flag = FALSE))

Line 1187: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)

1183: ,p_update_warning => l_warnings
1184: );
1185:
1186: UPDATE pay_element_entry_values_f
1187: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)
1188: WHERE input_value_id = l_input_values_rec(9).input_value_id
1189: AND element_entry_id = p_element_entry_id;
1190:
1191: END IF;