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_PROJECT_PUB dependencies on PA_PROJECT_TYPES

Line 26: (p_project_type pa_project_types.project_type%type)

22: -- PACKAGE CURSORS -------------------------------------------------------------------------
23: --needed to get the field values associated to a particular project_type
24:
25: CURSOR l_project_type_csr
26: (p_project_type pa_project_types.project_type%type)
27: IS
28: SELECT *
29: FROM pa_project_types
30: WHERE project_type = p_project_type;

Line 29: FROM pa_project_types

25: CURSOR l_project_type_csr
26: (p_project_type pa_project_types.project_type%type)
27: IS
28: SELECT *
29: FROM pa_project_types
30: WHERE project_type = p_project_type;
31:
32: --needed to get the field values associated to a particular project
33:

Line 242: l_project_type_rec pa_project_types%rowtype;

238: l_err_stack VARCHAR2(2000);
239: i NUMBER := 0; --counter
240: j NUMBER := 0; --counter
241: l_is_overridable BOOLEAN := FALSE;
242: l_project_type_rec pa_project_types%rowtype;
243: l_project_rec pa_projects%rowtype;
244: l_project_in_rec project_in_rec_type;
245: l_override_fields_rec l_override_fields_csr%rowtype;
246: l_override_fields_tab override_fields_tbl_type;

Line 472: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

468:
469: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
470: CURSOR c_prj(c_project_id IN NUMBER ) IS
471: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
472: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
473: where ppa.project_id = c_project_id
474: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
475: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
476: and pps.STATUS_TYPE = 'PROJECT'

Line 488: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

484: where project_id = c_project_id
485: and project_role_type='PROJECT MANAGER';
486:
487: l_proj_status pa_projects_all.project_status_code%TYPE;
488: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
489: l_prj_mgr_count NUMBER;
490: /* End of code for bug #2111806. */
491:
492: -- 4193743 Added below local variables

Line 555: pa_project_types ppt

551: NULL
552: FROM
553: pa_probability_members ppm,
554: pa_projects pp,
555: pa_project_types ppt
556: WHERE
557: pp.project_type = ppt.project_type AND
558: pp.org_id = ppt.org_id AND
559: ppt.probability_list_id = ppm.probability_list_id AND

Line 630: pa_project_types_all pt

626: IS
627: SELECT 'Y'
628: FROM
629: pa_projects_all p,
630: pa_project_types_all pt
631: WHERE
632: p.project_id = p_project_id AND
633: pt.project_type_class_code = 'CONTRACT' AND
634: p.project_type = pt.project_type AND

Line 5759: l_project_type_rec pa_project_types%rowtype;

5755: l_d_task_ver_id NUMBER;
5756: l_d_struct_ver_id NUMBER;
5757:
5758: --custom parameters
5759: l_project_type_rec pa_project_types%rowtype;
5760: l_project_rec pa_projects%rowtype;
5761: l_task_in_rec task_in_rec_type;
5762: l_project_id pa_projects.project_id%type;
5763: l_task_id pa_tasks.task_id%type;

Line 9872: FROM pa_project_types pt

9868: SELECT pt.project_type_class_code
9869: , pt.service_type_code
9870: , pt.revaluate_funding_flag /*Bug 2891513 : selecting the columns revaluate_funding_flag and include_gains_losses_flag*/
9871: , pt.include_gains_losses_flag
9872: FROM pa_project_types pt
9873: , pa_projects p
9874: WHERE p.project_type = pt.project_type
9875: AND p.project_id = p_pa_project_id;
9876:

Line 10187: l_project_type_class_code pa_project_types.project_type_class_code%type;

10183: l_added_task_tbl pa_project_pub.task_in_tbl_type;
10184: l_task_id_tbl pa_project_pub.task_out_tbl_type;
10185: l_count NUMBER;
10186: l_task_rec pa_project_pub.task_in_rec_type;
10187: l_project_type_class_code pa_project_types.project_type_class_code%type;
10188: l_service_type_code pa_project_types.service_type_code%type;
10189:
10190: l_key_members_tbl pa_project_pub.project_role_tbl_type;
10191: l_key_members_in_rec pa_project_pub.project_role_rec_type;

Line 10188: l_service_type_code pa_project_types.service_type_code%type;

10184: l_task_id_tbl pa_project_pub.task_out_tbl_type;
10185: l_count NUMBER;
10186: l_task_rec pa_project_pub.task_in_rec_type;
10187: l_project_type_class_code pa_project_types.project_type_class_code%type;
10188: l_service_type_code pa_project_types.service_type_code%type;
10189:
10190: l_key_members_tbl pa_project_pub.project_role_tbl_type;
10191: l_key_members_in_rec pa_project_pub.project_role_rec_type;
10192: l_key_members_current_rec l_key_member_csr%ROWTYPE;

Line 10508: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

10504:
10505: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
10506: CURSOR c_prj(c_project_id IN NUMBER ) IS
10507: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
10508: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
10509: where ppa.project_id = c_project_id
10510: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
10511: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
10512: and pps.STATUS_TYPE = 'PROJECT'

Line 10524: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

10520: where project_id = c_project_id
10521: and project_role_type='PROJECT MANAGER';
10522:
10523: l_proj_status pa_projects_all.project_status_code%TYPE;
10524: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
10525: l_prj_mgr_count NUMBER;
10526: /* End of code for bug #2111806. */
10527:
10528: l_old_cust_top_task_flag varchar2(1); -- 4188765 Added local variable

Line 10681: pa_project_types ppt

10677: NULL
10678: FROM
10679: pa_probability_members ppm,
10680: pa_projects pp,
10681: pa_project_types ppt
10682: WHERE
10683: pp.project_type = ppt.project_type AND
10684: pp.org_id = ppt.org_id AND
10685: ppt.probability_list_id = ppm.probability_list_id AND

Line 10700: pa_project_types ppt

10696: 'Y'
10697: FROM
10698: pa_work_types_vl pwt,
10699: pa_projects pp,
10700: pa_project_types ppt
10701: WHERE
10702: trunc(sysdate) BETWEEN pwt.start_date_active AND nvl(pwt.end_date_active,trunc(SYSDATE)) AND
10703: pp.project_type = ppt.project_type AND
10704: pp.org_id = ppt.org_id AND

Line 10733: pa_project_types ppt

10729: SELECT
10730: ppt.cc_prvdr_flag
10731: FROM
10732: pa_projects pp,
10733: pa_project_types ppt
10734: WHERE
10735: pp.project_type = ppt.project_type AND
10736: pp.org_id = ppt.org_id AND --this condition is not mandatory
10737: pp.project_id = p_project_id;

Line 10785: pa_project_types_all pt

10781: IS
10782: SELECT 'Y'
10783: FROM
10784: pa_projects_all p,
10785: pa_project_types_all pt
10786: WHERE
10787: p.project_id = p_project_id AND
10788: pt.project_type_class_code = 'CONTRACT' AND
10789: p.project_type = pt.project_type AND

Line 11515: -- Need to fetch information from pa_project_types

11511: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11512: END IF;
11513:
11514:
11515: -- Need to fetch information from pa_project_types
11516:
11517: /* Bug# 2891513- Added the variables for l_revaluate_funding and l_include_gains_and_losses */
11518:
11519: OPEN l_project_type_csr(l_project_id);

Line 20453: From pa_project_types pt, pa_projects pa

20449: end if;
20450:
20451: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20452: into l_cc_prvdr_flag,l_mcb_flag
20453: From pa_project_types pt, pa_projects pa
20454: where pa.project_type=pt.project_type AND
20455: pt.org_id = pa.org_id and
20456: pa.project_id=l_project_id;
20457:

Line 21047: From pa_project_types pt, pa_projects pa

21043: END if;
21044:
21045: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
21046: into l_cc_prvdr_flag,l_mcb_flag
21047: From pa_project_types pt, pa_projects pa
21048: where pa.project_type=pt.project_type
21049: AND pa.org_id = pt.org_id
21050: and pa.project_id=l_project_id;
21051: