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 2529: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2525: TYPE budget_version_id_tab IS TABLE OF PA_BUDGET_VERSIONS.budget_version_id%type
2526: INDEX BY BINARY_INTEGER;
2527: t_budget_version_id budget_version_id_tab;
2528: l_request_id NUMBER;
2529: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2530: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2531: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2532: BEGIN
2533: -- Setting the Debug Statements

Line 2530: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2526: INDEX BY BINARY_INTEGER;
2527: t_budget_version_id budget_version_id_tab;
2528: l_request_id NUMBER;
2529: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2530: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2531: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2532: BEGIN
2533: -- Setting the Debug Statements
2534: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2531: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2527: t_budget_version_id budget_version_id_tab;
2528: l_request_id NUMBER;
2529: l_locked_person_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2530: l_plan_proc_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2531: l_req_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2532: BEGIN
2533: -- Setting the Debug Statements
2534: IF P_PA_DEBUG_MODE = 'Y' THEN
2535: PA_DEBUG.Set_Curr_Function( p_function => 'Wrapper_Refresh_Pd_Profile',