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_ALL

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

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

Line 793: FROM pa_projects_all WHERE project_id = p_project_id;

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

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

4895: and pe.proj_element_id = pst.proj_element_id
4896: and pst.structure_type_id = 1;
4897:
4898: CURSOR cur_get_proj_temp_flag IS
4899: select template_flag from pa_projects_all where project_id = p_project_id;
4900: l_template_flag VARCHAR2(1);
4901:
4902: --cursor to get only structure version id (when version disabled)
4903: CURSOR cur_get_only_ver_struct_id IS

Line 9302: FROM PA_PROJECTS_ALL

9298: --to be used only in AMG flow
9299: CURSOR c_get_template_flag
9300: IS
9301: SELECT TEMPLATE_FLAG
9302: FROM PA_PROJECTS_ALL
9303: WHERE PROJECT_ID = p_project_id;
9304:
9305: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
9306: l_task_id NUMBER; --3603636

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

9301: SELECT TEMPLATE_FLAG
9302: FROM PA_PROJECTS_ALL
9303: WHERE PROJECT_ID = p_project_id;
9304:
9305: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE; -- Bug 3586648
9306: l_task_id NUMBER; --3603636
9307: -- Bug 3722011 Begin
9308: L_SHARING_ENABLED VARCHAR2(1) ;
9309: L_SPLIT_WORKPLAN VARCHAR2(1) ;

Line 10519: from pa_projects_all

10515: l_pfn_currency_code VARCHAR2(15) := null;
10516:
10517: cursor proj_all(p_project_id NUMBER) is
10518: select project_currency_code, projfunc_currency_code
10519: from pa_projects_all
10520: where project_id = p_project_id;
10521:
10522: -- BUG # 3659659.
10523:

Line 11258: FROM pa_projects_all

11254: END IF;
11255:
11256: SELECT structure_sharing_code
11257: INTO l_structure_sharing_code
11258: FROM pa_projects_all
11259: WHERE project_id = p_project_id;
11260:
11261:
11262: l_fin_structure_version_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id, 'FINANCIAL');

Line 13373: from pa_projects_all ppa

13369: l_no_rate_exception Exception;
13370: cursor projects_in_range is
13371: select ppa.org_id, ppa.project_currency_code, ppa.projfunc_currency_code,
13372: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(ppa.project_id) shared_structure
13373: from pa_projects_all ppa
13374: where ppa.project_id = l_project_id;
13375:
13376: -- tables to hold project_ids, latest WP ids and res list ids.
13377: proj_ids_tbl SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();

Line 14259: pa_projects_all ppa

14255: SELECT gp.START_DATE
14256: FROM gl_periods gp,
14257: gl_sets_of_books gsb,
14258: pa_implementations_all pia,
14259: pa_projects_all ppa
14260: WHERE ppa.project_id = l_project_id
14261: and nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)
14262: and gsb.set_of_books_id = pia.set_of_books_id
14263: and gp.period_set_name = gsb.period_set_name

Line 21570: from pa_projects_all

21566: l_proj_curr_code varchar2(15);
21567: l_proj_func_curr_code varchar2(15);
21568: cursor proj_info is
21569: select org_id, project_currency_code, projfunc_currency_code
21570: from pa_projects_all
21571: where project_id = p_project_id;
21572:
21573: ETC_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
21574: ETC_PROJECT_ORG_ID PA_PLSQL_DATATYPES.Num15TabTyp;

Line 22660: FROM PA_PROJECTS_ALL

22656:
22657: CURSOR c_get_template_flag(c_project_id NUMBER)
22658: IS
22659: SELECT TEMPLATE_FLAG
22660: FROM PA_PROJECTS_ALL
22661: WHERE PROJECT_ID = c_project_id;
22662:
22663: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
22664: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;

Line 22663: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;

22659: SELECT TEMPLATE_FLAG
22660: FROM PA_PROJECTS_ALL
22661: WHERE PROJECT_ID = c_project_id;
22662:
22663: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
22664: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;
22665: l_last_project_id NUMBER;
22666: l_last_sharing_Enabled VARCHAR2(1);
22667: l_last_split_workplan VARCHAR2(1);

Line 22664: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;

22660: FROM PA_PROJECTS_ALL
22661: WHERE PROJECT_ID = c_project_id;
22662:
22663: l_structure_sharing_code pa_projects_all.structure_sharing_code%TYPE;
22664: l_last_str_sharing_code pa_projects_all.structure_sharing_code%TYPE;
22665: l_last_project_id NUMBER;
22666: l_last_sharing_Enabled VARCHAR2(1);
22667: l_last_split_workplan VARCHAR2(1);
22668: l_task_id NUMBER;

Line 22725: from pa_projects_all

22721:
22722: -- MOAC Changes Bug 4698162 Begin
22723: CURSOR c_get_org_id(c_project_id NUMBER) IS
22724: select org_id
22725: from pa_projects_all
22726: where project_id = c_project_id;
22727:
22728: l_org_id NUMBER;
22729: -- MOAC Changes Bug 4698162 End