APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on DBMS_SQL

Line 720: l_cursor_id := dbms_sql.open_cursor;

716: x_plan_start_date FROM Pa_Proj_Period_Profiles
717: WHERE Period_Profile_Id = NVL(p_period_profile_id,0);
718:
719: l_column_name := 'PERIOD'||LTRIM(TO_CHAR(x_number_of_periods))||'_END_DATE';
720: l_cursor_id := dbms_sql.open_cursor;
721: l_stmt := 'select ' ||l_column_name
722: || ' from pa_proj_period_profiles where ' ||
723: ' period_profile_id = '||to_char(p_period_profile_id);
724:

Line 725: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);

721: l_stmt := 'select ' ||l_column_name
722: || ' from pa_proj_period_profiles where ' ||
723: ' period_profile_id = '||to_char(p_period_profile_id);
724:
725: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
726: dbms_sql.define_column(l_cursor_id,1,l_plan_end_date);
727:
728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);
729:

Line 726: dbms_sql.define_column(l_cursor_id,1,l_plan_end_date);

722: || ' from pa_proj_period_profiles where ' ||
723: ' period_profile_id = '||to_char(p_period_profile_id);
724:
725: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
726: dbms_sql.define_column(l_cursor_id,1,l_plan_end_date);
727:
728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);
729:
730:

Line 728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);

724:
725: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
726: dbms_sql.define_column(l_cursor_id,1,l_plan_end_date);
727:
728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);
729:
730:
731: dbms_sql.column_value(l_cursor_id,1,l_plan_end_date);
732: dbms_sql.close_cursor(l_cursor_id);

Line 731: dbms_sql.column_value(l_cursor_id,1,l_plan_end_date);

727:
728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);
729:
730:
731: dbms_sql.column_value(l_cursor_id,1,l_plan_end_date);
732: dbms_sql.close_cursor(l_cursor_id);
733: x_plan_end_date := l_plan_end_date;
734:
735: EXCEPTION

Line 732: dbms_sql.close_cursor(l_cursor_id);

728: l_dummy := dbms_sql.execute_and_fetch(l_cursor_id);
729:
730:
731: dbms_sql.column_value(l_cursor_id,1,l_plan_end_date);
732: dbms_sql.close_cursor(l_cursor_id);
733: x_plan_end_date := l_plan_end_date;
734:
735: EXCEPTION
736: WHEN NO_DATA_FOUND THEN