DBA Data[Home] [Help]

APPS.FPA_PLANNINGCYCLE_PVT dependencies on FND_DATE

Line 984: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.' -- Bug 9264707

980: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
981: FND_LOG.String
982: (FND_LOG.LEVEL_PROCEDURE,
983: 'fpa.sql.FPA_PlanningCycle_Pvt.Update_Pc_Currency',
984: 'Setting currency_date_pc_r to : ' || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''') || ' value.' -- Bug 9264707
985: );
986: END IF;
987:
988: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date

Line 992: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''')); -- Bug 9264707

988: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.conversion_rate_date
989: -- was raising error 'literal does not match format string'
990:
991: dbms_aw.execute('currency_date_pc_r = '''
992: || to_char(fnd_date.chardate_to_date(p_pc_info.conversion_rate_date), 'MMDDYYYY' || '''')); -- Bug 9264707
993:
994: /*dbms_aw.execute('currency_date_pc_r = '''
995: || to_char(to_date(p_pc_info.conversion_rate_date,
996: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/

Line 1096: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'MMDDYYYY' || '''')); -- Bug 9264707

1092: --Bug 4254274 : Applying to_date function on variable of type character i.e p_pc_info.submission_due_date
1093: -- was raising error 'literal does not match format string'
1094:
1095: dbms_aw.execute('pc_submission_due_date_r = '''
1096: || to_char(fnd_date.chardate_to_date(p_pc_info.submission_due_date), 'MMDDYYYY' || '''')); -- Bug 9264707
1097:
1098: /*dbms_aw.execute('pc_submission_due_date_r = '''
1099: || to_char(to_date(p_pc_info.submission_due_date,
1100: 'DD-MON-YYYY'), 'DDMONYYYY' || ''''));*/