APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_DATE

Line 3943: l_description := Fnd_Date.Date_to_Canonical(l_description);

3939: -- Moved the date format conversion out of the insert statement.
3940:
3941: if (l_data_type = 'D') then
3942: begin
3943: l_description := Fnd_Date.Date_to_Canonical(l_description);
3944: exception
3945: when OTHERS then
3946: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
3947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

Line 4043: vdef_col := fnd_date.date_to_canonical(vdef_col3);

4039: end;
4040: elsif (attribute_rec.data_type = 'D') then
4041: begin
4042: DBMS_SQL.COLUMN_VALUE(v_cursorid,1,vdef_col3);
4043: vdef_col := fnd_date.date_to_canonical(vdef_col3);
4044: exception
4045: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
4046:
4047: -- Changed the exception part for Bug #4658351

Line 5397: v_qsegment := Fnd_Date.Date_to_Canonical(v_qsegment);

5393: -- Moved the date format conversion out of the insert statement.
5394:
5395: if (l_data_type = 'D') then
5396: begin
5397: v_qsegment := Fnd_Date.Date_to_Canonical(v_qsegment);
5398: exception
5399: when OTHERS then
5400: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
5401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

Line 5548: v_osegment := fnd_date.date_to_canonical(v_odate);

5544: end if;
5545: if (Emp_attribute_rec.data_type = 'D') then
5546: begin
5547: dbms_sql.column_value(v_ocursorid,1,v_odate);
5548: v_osegment := fnd_date.date_to_canonical(v_odate);
5549: exception
5550: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
5551:
5552: -- Changed the exception part for Bug#4658351

Line 5992: lp_hiredate := fnd_date.date_to_canonical(l_hiredate);

5988: /*For Bug No : 2109120 End*/
5989:
5990:
5991: if (l_hiredate is not null) then
5992: lp_hiredate := fnd_date.date_to_canonical(l_hiredate);
5993: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5994: ( HR_POSITION_ID ,
5995: HR_EMPLOYEE_ID ,
5996: DATA_EXTRACT_ID ,