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 471: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

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

Line 487: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

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

Line 543: pa_project_types ppt

539: NULL
540: FROM
541: pa_probability_members ppm,
542: pa_projects pp,
543: pa_project_types ppt
544: WHERE
545: pp.project_type = ppt.project_type AND
546: pp.org_id = ppt.org_id AND
547: ppt.probability_list_id = ppm.probability_list_id AND

Line 597: pa_project_types_all pt

593: IS
594: SELECT 'Y'
595: FROM
596: pa_projects_all p,
597: pa_project_types_all pt
598: WHERE
599: p.project_id = p_project_id AND
600: pt.project_type_class_code = 'CONTRACT' AND
601: p.project_type = pt.project_type AND

Line 5609: l_project_type_rec pa_project_types%rowtype;

5605: l_d_task_ver_id NUMBER;
5606: l_d_struct_ver_id NUMBER;
5607:
5608: --custom parameters
5609: l_project_type_rec pa_project_types%rowtype;
5610: l_project_rec pa_projects%rowtype;
5611: l_task_in_rec task_in_rec_type;
5612: l_project_id pa_projects.project_id%type;
5613: l_task_id pa_tasks.task_id%type;

Line 9620: FROM pa_project_types pt

9616: SELECT pt.project_type_class_code
9617: , pt.service_type_code
9618: , pt.revaluate_funding_flag /*Bug 2891513 : selecting the columns revaluate_funding_flag and include_gains_losses_flag*/
9619: , pt.include_gains_losses_flag
9620: FROM pa_project_types pt
9621: , pa_projects p
9622: WHERE p.project_type = pt.project_type
9623: AND p.project_id = p_pa_project_id;
9624:

Line 9926: l_project_type_class_code pa_project_types.project_type_class_code%type;

9922: l_added_task_tbl pa_project_pub.task_in_tbl_type;
9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;
9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;
9928:
9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;
9930: l_key_members_in_rec pa_project_pub.project_role_rec_type;

Line 9927: l_service_type_code pa_project_types.service_type_code%type;

9923: l_task_id_tbl pa_project_pub.task_out_tbl_type;
9924: l_count NUMBER;
9925: l_task_rec pa_project_pub.task_in_rec_type;
9926: l_project_type_class_code pa_project_types.project_type_class_code%type;
9927: l_service_type_code pa_project_types.service_type_code%type;
9928:
9929: l_key_members_tbl pa_project_pub.project_role_tbl_type;
9930: l_key_members_in_rec pa_project_pub.project_role_rec_type;
9931: l_key_members_current_rec l_key_member_csr%ROWTYPE;

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

10242:
10243: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
10244: CURSOR c_prj(c_project_id IN NUMBER ) IS
10245: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
10246: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
10247: where ppa.project_id = c_project_id
10248: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
10249: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
10250: and pps.STATUS_TYPE = 'PROJECT'

Line 10262: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

10258: where project_id = c_project_id
10259: and project_role_type='PROJECT MANAGER';
10260:
10261: l_proj_status pa_projects_all.project_status_code%TYPE;
10262: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
10263: l_prj_mgr_count NUMBER;
10264: /* End of code for bug #2111806. */
10265:
10266: l_old_cust_top_task_flag varchar2(1); -- 4188765 Added local variable

Line 10419: pa_project_types ppt

10415: NULL
10416: FROM
10417: pa_probability_members ppm,
10418: pa_projects pp,
10419: pa_project_types ppt
10420: WHERE
10421: pp.project_type = ppt.project_type AND
10422: pp.org_id = ppt.org_id AND
10423: ppt.probability_list_id = ppm.probability_list_id AND

Line 10438: pa_project_types ppt

10434: 'Y'
10435: FROM
10436: pa_work_types_vl pwt,
10437: pa_projects pp,
10438: pa_project_types ppt
10439: WHERE
10440: trunc(sysdate) BETWEEN pwt.start_date_active AND nvl(pwt.end_date_active,trunc(SYSDATE)) AND
10441: pp.project_type = ppt.project_type AND
10442: pp.org_id = ppt.org_id AND

Line 10471: pa_project_types ppt

10467: SELECT
10468: ppt.cc_prvdr_flag
10469: FROM
10470: pa_projects pp,
10471: pa_project_types ppt
10472: WHERE
10473: pp.project_type = ppt.project_type AND
10474: pp.org_id = ppt.org_id AND --this condition is not mandatory
10475: pp.project_id = p_project_id;

Line 10523: pa_project_types_all pt

10519: IS
10520: SELECT 'Y'
10521: FROM
10522: pa_projects_all p,
10523: pa_project_types_all pt
10524: WHERE
10525: p.project_id = p_project_id AND
10526: pt.project_type_class_code = 'CONTRACT' AND
10527: p.project_type = pt.project_type AND

Line 11197: -- Need to fetch information from pa_project_types

11193: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11194: END IF;
11195:
11196:
11197: -- Need to fetch information from pa_project_types
11198:
11199: /* Bug# 2891513- Added the variables for l_revaluate_funding and l_include_gains_and_losses */
11200:
11201: OPEN l_project_type_csr(l_project_id);

Line 20052: From pa_project_types pt, pa_projects pa

20048: end if;
20049:
20050: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20051: into l_cc_prvdr_flag,l_mcb_flag
20052: From pa_project_types pt, pa_projects pa
20053: where pa.project_type=pt.project_type AND
20054: pt.org_id = pa.org_id and
20055: pa.project_id=l_project_id;
20056:

Line 20646: From pa_project_types pt, pa_projects pa

20642: END if;
20643:
20644: Select pt.CC_PRVDR_FLAG,pa.multi_currency_billing_flag
20645: into l_cc_prvdr_flag,l_mcb_flag
20646: From pa_project_types pt, pa_projects pa
20647: where pa.project_type=pt.project_type
20648: AND pa.org_id = pt.org_id
20649: and pa.project_id=l_project_id;
20650: