DBA Data[Home] [Help]

APPS.FPA_PLANNINGCYCLE_PVT dependencies on FND_DATE

Line 973: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || '''') || ' value.'

969: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
970: FND_LOG.String
971: (FND_LOG.LEVEL_PROCEDURE,
972: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
973: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || '''') || ' value.'
974: );
975: END IF;
976:
977: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date

Line 981: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || ''''));

977: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date
978: -- was raising error 'literal does not match format string'
979:
980: dbms_aw.execute('currency_date_pc_r = '''
981: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'DDMONYYYY' || ''''));
982:
983: /*dbms_aw.execute('currency_date_pc_r = '''
984: || to_char(to_date(p_pc_info.conversion_rate_date,
985: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/

Line 1085: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'DDMONYYYY' || ''''));

1081: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.submission_due_date
1082: -- was raising error 'literal does not match format string'
1083:
1084: dbms_aw.execute('pc_submission_due_date_r = '''
1085: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'DDMONYYYY' || ''''));
1086:
1087: /*dbms_aw.execute('pc_submission_due_date_r = '''
1088: || to_char(to_date(p_pc_info.submission_due_date,
1089: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/