DBA Data[Home] [Help]

APPS.FPA_SCENARIO_PVT dependencies on NLS_SESSION_PARAMETERS

Line 511: FROM NLS_SESSION_PARAMETERS

507: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
508:
509: SELECT SUBSTR(VALUE,1,1)
510: INTO l_decimal_marker
511: FROM NLS_SESSION_PARAMETERS
512: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
513:
514: l_discount_rate := REPLACE( To_Char(p_discount_rate/100), l_decimal_marker,'.');
515:

Line 604: FROM NLS_SESSION_PARAMETERS

600: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
601:
602: SELECT SUBSTR(VALUE,1,1)
603: INTO l_decimal_marker
604: FROM NLS_SESSION_PARAMETERS
605: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
606: l_scen_funds := REPLACE( To_Char(p_scenario_funds*l_pc_disply_factor), l_decimal_marker,'.');
607:
608: -- Associate the scenario with the planning cycle