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_PROGRESS_PUB dependencies on PA_PROJECTS

Line 342: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648

338: l_planned_effort2 SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ;
339: l_start_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
340: l_end_dates SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
341:
342: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
343: l_etc_effort_this_period NUMBER;--Bug 3595585
344: l_last_submitted_etc_effort NUMBER;--Bug 3595585
345:
346: -- Bug 3608422 : Added the cusrosr below

Line 792: FROM pa_projects_all WHERE project_id = p_project_id;

788:
789: --bug 3824042
790: SELECT project_currency_code, projfunc_currency_code
791: INTO l_prj_currency_code, l_prjfunc_currency_code
792: FROM pa_projects_all WHERE project_id = p_project_id;
793:
794: IF g1_debug_mode = 'Y' THEN
795: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'l_structure_sharing_code='||l_structure_sharing_code, x_Log_Level=> 3);
796: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);

Line 4495: select template_flag from pa_projects_all where project_id = p_project_id;

4491: and pe.proj_element_id = pst.proj_element_id
4492: and pst.structure_type_id = 1;
4493:
4494: CURSOR cur_get_proj_temp_flag IS
4495: select template_flag from pa_projects_all where project_id = p_project_id;
4496: l_template_flag VARCHAR2(1);
4497:
4498: --cursor to get only structure version id (when version disabled)
4499: CURSOR cur_get_only_ver_struct_id IS

Line 8884: FROM PA_PROJECTS_ALL

8880: --to be used only in AMG flow
8881: CURSOR c_get_template_flag
8882: IS
8883: SELECT TEMPLATE_FLAG
8884: FROM PA_PROJECTS_ALL
8885: WHERE PROJECT_ID = p_project_id;
8886:
8887: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
8888: l_task_id NUMBER; --3603636

Line 8887: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648

8883: SELECT TEMPLATE_FLAG
8884: FROM PA_PROJECTS_ALL
8885: WHERE PROJECT_ID = p_project_id;
8886:
8887: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
8888: l_task_id NUMBER; --3603636
8889: -- Bug 3722011 Begin
8890: L_SHARING_ENABLED VARCHAR2(1) ;
8891: L_SPLIT_WORKPLAN VARCHAR2(1) ;

Line 10084: from pa_projects_all

10080: l_pfn_currency_code VARCHAR2(15) := null;
10081:
10082: cursor proj_all(p_project_id NUMBER) is
10083: select project_currency_code, projfunc_currency_code
10084: from pa_projects_all
10085: where project_id = p_project_id;
10086:
10087: -- BUG # 3659659.
10088:

Line 10091: from pa_projects

10087: -- BUG # 3659659.
10088:
10089: cursor cur_org_id(p_project_id NUMBER) is
10090: select org_id
10091: from pa_projects
10092: where project_id = p_project_Id;
10093:
10094: --bug3675107
10095: l_pa_period_name VARCHAR2(30) :=null;

Line 10816: FROM pa_projects_all

10812: END IF;
10813:
10814: SELECT structure_sharing_code
10815: INTO l_structure_sharing_code
10816: FROM pa_projects_all
10817: WHERE project_id = p_project_id;
10818:
10819:
10820: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');

Line 12903: from pa_projects_all ppa

12899: l_no_rate_exception Exception;
12900: cursor projects_in_range is
12901: select ppa.org_id, ppa.project_currency_code, ppa.projfunc_currency_code,
12902: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(ppa.project_id) shared_structure
12903: from pa_projects_all ppa
12904: where ppa.project_id = l_project_id;
12905:
12906: -- tables to hold project_ids, latest WP ids and res list ids.
12907: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 13766: pa_projects_all ppa

13762: SELECT gp.START_DATE
13763: FROM gl_periods gp,
13764: gl_sets_of_books gsb,
13765: pa_implementations_all pia,
13766: pa_projects_all ppa
13767: WHERE ppa.project_id = l_project_id
13768: and nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)
13769: and gsb.set_of_books_id = pia.set_of_books_id
13770: and gp.period_set_name = gsb.period_set_name

Line 20107: from pa_projects_all

20103: l_proj_curr_code varchar2(15);
20104: l_proj_func_curr_code varchar2(15);
20105: cursor proj_info is
20106: select org_id, project_currency_code, projfunc_currency_code
20107: from pa_projects_all
20108: where project_id = p_project_id;
20109:
20110: ETC_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
20111: ETC_PROJECT_ORG_ID PA_PLSQL_DATATYPES.Num15TabTyp;

Line 21197: FROM PA_PROJECTS_ALL

21193:
21194: CURSOR c_get_template_flag(c_project_id NUMBER)
21195: IS
21196: SELECT TEMPLATE_FLAG
21197: FROM PA_PROJECTS_ALL
21198: WHERE PROJECT_ID = c_project_id;
21199:
21200: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
21201: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;

Line 21200: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;

21196: SELECT TEMPLATE_FLAG
21197: FROM PA_PROJECTS_ALL
21198: WHERE PROJECT_ID = c_project_id;
21199:
21200: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
21201: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;
21202: l_last_project_id NUMBER;
21203: l_last_sharing_Enabled VARCHAR2(1);
21204: l_last_split_workplan VARCHAR2(1);

Line 21201: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;

21197: FROM PA_PROJECTS_ALL
21198: WHERE PROJECT_ID = c_project_id;
21199:
21200: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
21201: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;
21202: l_last_project_id NUMBER;
21203: l_last_sharing_Enabled VARCHAR2(1);
21204: l_last_split_workplan VARCHAR2(1);
21205: l_task_id NUMBER;

Line 21260: from pa_projects_all

21256:
21257: -- MOAC Changes Bug 4698162 Begin
21258: CURSOR c_get_org_id(c_project_id NUMBER) IS
21259: select org_id
21260: from pa_projects_all
21261: where project_id = c_project_id;
21262:
21263: l_org_id NUMBER;
21264: -- MOAC Changes Bug 4698162 End