DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_DATE

Line 180: g_psb_revision_start_date := fnd_date.chardate_to_date(g_var_value) ;

176: g_psb_application_id := to_number(g_var_value);
177: elsif (g_var_name = 'G_PSB_ORG_ID') then
178: g_psb_org_id := to_number(g_var_value);
179: elsif (g_var_name = 'G_PSB_REVISION_START_DATE') then
180: g_psb_revision_start_date := fnd_date.chardate_to_date(g_var_value) ;
181: elsif (g_var_name = 'G_PSB_REVISION_END_DATE') then
182: g_psb_revision_end_date := fnd_date.chardate_to_date(g_var_value) ;
183: end if;
184: END set_global;

Line 182: g_psb_revision_end_date := fnd_date.chardate_to_date(g_var_value) ;

178: g_psb_org_id := to_number(g_var_value);
179: elsif (g_var_name = 'G_PSB_REVISION_START_DATE') then
180: g_psb_revision_start_date := fnd_date.chardate_to_date(g_var_value) ;
181: elsif (g_var_name = 'G_PSB_REVISION_END_DATE') then
182: g_psb_revision_end_date := fnd_date.chardate_to_date(g_var_value) ;
183: end if;
184: END set_global;
185:
186: Function get_global(g_var_name IN VARCHAR2) return varchar2

Line 961: lp_attribute_value :=fnd_date.date_to_canonical(p_earliest_hire_date);

957: l_valid_attribute := 'Y' ;
958: -- Bug#2109120: Commenting
959: /*
960: elsif (C_Attribute_Rec.system_attribute_type = 'HIREDATE') then
961: lp_attribute_value :=fnd_date.date_to_canonical(p_earliest_hire_date);
962: l_valid_attribute := 'Y' ;
963: */
964: end if; -- I2
965: else

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

1258:
1259: if (C_Attribute_Rec.data_type = 'D') then
1260: begin
1261: dbms_sql.column_value(v_ocursorid,1,v_odate);
1262: v_osegment := fnd_date.date_to_canonical(v_odate);
1263: exception
1264: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
1265:
1266: -- Changed the exception part for Bug#4658351

Line 4407: l_default_start_date DATE := fnd_date.canonical_to_date('1941/01/01');

4403: -- UTF8 changes for Bug No : 2615261
4404: l_description psb_cost_distributions_i.description%TYPE;
4405: l_position_name VARCHAR2(240);
4406: l_process_start_date DATE;
4407: l_default_start_date DATE := fnd_date.canonical_to_date('1941/01/01');
4408: l_rep_req_id NUMBER;
4409: l_reqid NUMBER;
4410: l_userid NUMBER;
4411: lh_distribution gl_distribution_tbl_type;