eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_PLSQL_DATATYPES

Line 28: l_period_name_tab PA_PLSQL_DATATYPES.Char50TabTyp;

24: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
26: IS
27: l_cnt number;
28: l_period_name_tab PA_PLSQL_DATATYPES.Char50TabTyp;
29: l_st_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
30: l_end_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
31: l_period_type Gl_Periods.Period_Type%TYPE;
32: l_tab_count number(10);

Line 29: l_st_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;

25: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
26: IS
27: l_cnt number;
28: l_period_name_tab PA_PLSQL_DATATYPES.Char50TabTyp;
29: l_st_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
30: l_end_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
31: l_period_type Gl_Periods.Period_Type%TYPE;
32: l_tab_count number(10);
33: l_temp number(10);

Line 30: l_end_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;

26: IS
27: l_cnt number;
28: l_period_name_tab PA_PLSQL_DATATYPES.Char50TabTyp;
29: l_st_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
30: l_end_dt_tab PA_PLSQL_DATATYPES.DateTabTyp;
31: l_period_type Gl_Periods.Period_Type%TYPE;
32: l_tab_count number(10);
33: l_temp number(10);
34: CURSOR c1(c_period_set_name varchar2,

Line 894: l_bv_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

890: l_rpt_request_id NUMBER;
891: l_debug_mode VARCHAR2(30);
892: l_conc_pa_profile_id NUMBER;
893: l_conc_gl_profile_id NUMBER;
894: l_bv_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
895: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
896: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
897:
898:

Line 895: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

891: l_debug_mode VARCHAR2(30);
892: l_conc_pa_profile_id NUMBER;
893: l_conc_gl_profile_id NUMBER;
894: l_bv_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
895: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
896: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
897:
898:
899: -- Bug 2589885, 17-MAR-2003, jwhite, Begin: --------------------

Line 896: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

892: l_conc_pa_profile_id NUMBER;
893: l_conc_gl_profile_id NUMBER;
894: l_bv_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
895: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
896: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
897:
898:
899: -- Bug 2589885, 17-MAR-2003, jwhite, Begin: --------------------
900:

Line 2530: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2526: TYPE budget_version_id_tab IS TABLE OF PA_BUDGET_VERSIONS.budget_version_id%type
2527: INDEX BY BINARY_INTEGER;
2528: t_budget_version_id budget_version_id_tab;
2529: l_request_id NUMBER;
2530: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2531: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2532: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2533: --Bug 7563735 Locking the records in cursor
2534: cursor c is

Line 2531: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2527: INDEX BY BINARY_INTEGER;
2528: t_budget_version_id budget_version_id_tab;
2529: l_request_id NUMBER;
2530: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2531: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2532: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2533: --Bug 7563735 Locking the records in cursor
2534: cursor c is
2535: select budget_version_id

Line 2532: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2528: t_budget_version_id budget_version_id_tab;
2529: l_request_id NUMBER;
2530: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2531: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2532: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2533: --Bug 7563735 Locking the records in cursor
2534: cursor c is
2535: select budget_version_id
2536: FROM Pa_budget_versions