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_PROJECTS_ALL

Line 209: from pa_projects_all

205:
206: Cursor l_temp_eff_flag_csr(p_proj_id NUMBER)
207: Is
208: select 'N'
209: from pa_projects_all
210: where project_id = p_proj_id
211: and template_flag = 'Y'
212: and ((nvl(trunc(template_start_date_active), trunc(sysdate)) > trunc(sysdate)) or
213: (nvl(trunc(template_end_date_active), trunc(sysdate)) < trunc(sysdate)));

Line 435: FROM pa_projects_all

431:
432: --Bug 3279981
433: CURSOR cur_get_orig_tt_cust_flag( c_project_id IN NUMBER ) IS
434: SELECT enable_top_task_customer_flag
435: FROM pa_projects_all
436: WHERE project_id = c_project_id ;
437:
438: l_orig_def_tt_flag VARCHAR2(1);
439: l_cust_bill_split NUMBER;

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 487: l_proj_status pa_projects_all.project_status_code%TYPE;

483: from pa_project_players
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:

Line 575: pa_projects_all

571: IS
572: SELECT
573: nvl(DATE_EFF_FUNDS_CONSUMPTION,'N')
574: FROM
575: pa_projects_all
576: WHERE project_id = c_project_id ;
577:
578: /* 7508661 : EnC : Start */
579:

Line 588: pa_projects_all

584: IS
585: SELECT
586: nvl(AR_REC_NOTIFY_FLAG,'N')
587: FROM
588: pa_projects_all
589: WHERE project_id = c_project_id ;
590: /* Added for 12.2Payroll billing ER 11899223 */
591: l_auto_release_pwp_inv VARCHAR2(1);
592: l_orig_auto_release_pwp_inv VARCHAR2(1);

Line 603: pa_projects_all

599: IS
600: SELECT
601: nvl(adj_on_std_inv,'N')
602: FROM
603: pa_projects_all
604: WHERE project_id = c_project_id ;
605:
606: CURSOR get_bill_labor_accrual( c_project_id IN NUMBER )
607: IS

Line 611: pa_projects_all

607: IS
608: SELECT
609: nvl(bill_labor_accrual,'N')
610: FROM
611: pa_projects_all
612: WHERE project_id = c_project_id ;
613:
614: /* Added for 12.2Payroll billing ER 11899223 */
615: CURSOR get_auto_release_pwp_inv( c_project_id IN NUMBER )

Line 620: pa_projects_all

616: IS
617: SELECT
618: nvl(AUTO_RELEASE_PWP_INV,'Y')
619: FROM
620: pa_projects_all
621: WHERE project_id = c_project_id ;
622:
623: /* 7508661 : EnC : End */
624:

Line 629: pa_projects_all p,

625: CURSOR cur_enable_funds_flag(p_project_id IN VARCHAR2)
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

Line 695: from pa_projects_all

691:
692: /*Added for bug 7830143*/
693: CURSOR c_get_org_id(c_project_id NUMBER) IS
694: select org_id
695: from pa_projects_all
696: where project_id = c_project_id;
697:
698: l_org_id NUMBER ;
699: /*Added for bug 7830143*/

Line 1203: from pa_projects_all

1199:
1200: l_created_from_proj_id := l_project_in_rec.created_from_project_id;
1201: else
1202: select created_from_project_id into l_created_from_proj_id
1203: from pa_projects_all
1204: where project_id = l_project_in_rec.created_from_project_id;
1205: end if;
1206: --code addition for bug 2254661 ends
1207:

Line 5798: FROM pa_projects_all

5794: --Bug 3279981. Fetch project information
5795: CURSOR cur_get_proj_billing_info IS
5796: SELECT enable_top_task_customer_flag, enable_top_task_inv_mth_flag,
5797: revenue_accrual_method, invoice_method, project_type
5798: FROM pa_projects_all
5799: WHERE project_id = p_pa_project_id;
5800:
5801: CURSOR cur_check_proj_cust_exist (c_customer_id IN NUMBER ) IS
5802: SELECT 'Y'

Line 9881: FROM pa_projects_all

9877: --needed to check whether given project number is unique
9878: CURSOR l_project_number_unique_csr( p_project_number VARCHAR2)
9879: IS
9880: SELECT 'x'
9881: FROM pa_projects_all
9882: WHERE segment1 = p_project_number;
9883:
9884: --needed to check whether given project name is unique
9885: CURSOR l_project_name_unique_csr( p_project_name VARCHAR2)

Line 9888: FROM pa_projects_all

9884: --needed to check whether given project name is unique
9885: CURSOR l_project_name_unique_csr( p_project_name VARCHAR2)
9886: IS
9887: SELECT 'x'
9888: FROM pa_projects_all
9889: WHERE name = p_project_name;
9890:
9891: --needed to check whether given long name is unique
9892: CURSOR l_long_name_unique_csr( p_long_name VARCHAR2)

Line 9895: FROM pa_projects_all

9891: --needed to check whether given long name is unique
9892: CURSOR l_long_name_unique_csr( p_long_name VARCHAR2)
9893: IS
9894: SELECT 'x'
9895: FROM pa_projects_all
9896: WHERE long_name = p_long_name;
9897:
9898: /* Modidified the cursor l_key_member_csr to add start_date_active as logical
9899: primary key */

Line 10017: pa_projects_all ppa,

10013: NULL USER_NAME,
10014: -999 USER_ID,
10015: ppp.resource_source_id RESOURCE_PARTY_ID
10016: FROM pa_project_parties ppp,
10017: pa_projects_all ppa,
10018: pa_project_role_types_vl pprt,
10019: hz_parties hzo,
10020: hz_contact_points hzcp
10021: WHERE ppp.resource_type_id = 112

Line 10079: pa_projects_all ppa,

10075: NULL USER_NAME,
10076: -999 USER_ID,
10077: ppp.resource_source_id RESOURCE_PARTY_ID
10078: FROM pa_project_parties ppp,
10079: pa_projects_all ppa,
10080: pa_project_role_types_vl pprt,
10081: hz_parties hzo
10082: WHERE ppp.resource_type_id = 112
10083: AND ppp.project_id = ppa.project_id

Line 10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

10092:
10093: -- 3693229 end
10094:
10095: --Cursor to get the current published version when structure type and project id is known
10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10097: IS
10098: SELECT c.element_version_id
10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10100: ,pa_proj_elem_ver_structure d

Line 10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)

10107: AND d.status_code = 'STRUCTURE_PUBLISHED'
10108: AND d.latest_eff_published_flag = 'Y';
10109:
10110: --Cursor to get the working version when structure type and project id is known
10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10112: IS
10113: SELECT c.element_version_id
10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10115: ,pa_proj_elem_ver_structure d

Line 10127: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa

10123:
10124: -- Cursor to get the Project's System Status Code Bug 3611598
10125: CURSOR c_project_sys_status_code IS
10126: SELECT project_system_status_code
10127: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa
10128: WHERE pa.project_id = p_project_in.pa_project_id
10129: AND sta.project_status_code = pa.project_status_code;
10130:
10131: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)

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 10523: l_proj_status pa_projects_all.project_status_code%TYPE;

10519: from pa_project_players
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:

Line 10599: from pa_projects_all ppa

10595: -- Bug # 4329284.
10596:
10597: cursor cur_proj_name (c_project_id NUMBER) is
10598: select ppa.name
10599: from pa_projects_all ppa
10600: where ppa.project_id = c_project_id;
10601:
10602: cursor cur_prog_name (c_project_id NUMBER) is
10603: select ppa.name

Line 10604: from pa_projects_all ppa, pa_object_relationships por

10600: where ppa.project_id = c_project_id;
10601:
10602: cursor cur_prog_name (c_project_id NUMBER) is
10603: select ppa.name
10604: from pa_projects_all ppa, pa_object_relationships por
10605: where ppa.project_id = por.object_id_to2
10606: and por.object_id_to2 = c_project_id
10607: and por.relationship_type in ('LW','LF')
10608: union all

Line 10610: from pa_projects_all ppa, pa_object_relationships por

10606: and por.object_id_to2 = c_project_id
10607: and por.relationship_type in ('LW','LF')
10608: union all
10609: select ppa.name
10610: from pa_projects_all ppa, pa_object_relationships por
10611: where ppa.project_id = por.object_id_from2
10612: and por.object_id_from2 = c_project_id
10613: and por.relationship_type in ('LW','LF');
10614:

Line 10752: pa_projects_all proj

10748: IS
10749: select 'x'
10750: from pa_project_role_types_v roles,
10751: pa_role_controls controls,
10752: pa_projects_all proj
10753: where proj.project_id=p_project_id
10754: and proj.ROLE_LIST_ID is null
10755: and roles.project_role_id=controls.project_role_id
10756: and roles.PROJECT_ROLE_TYPE=p_role_type

Line 10763: pa_projects_all proj,

10759: union all
10760: select 'x'
10761: from pa_project_role_types_v roles,
10762: pa_role_controls controls,
10763: pa_projects_all proj,
10764: pa_role_list_members prlm
10765: where proj.project_id=p_project_id
10766: and proj.ROLE_LIST_ID =prlm.role_list_id
10767: and prlm.project_role_id = roles.project_role_id

Line 10784: pa_projects_all p,

10780: CURSOR cur_enable_funds_flag(p_project_id IN VARCHAR2)
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

Line 16556: UPDATE pa_projects_all

16552: --Update the distribution rule with the correct invoice method, if no distribution rule has been passed
16553: --Call the api to default the invoice method to the tasks
16554: IF 'Y' = l_enable_top_task_inv_mth_flag AND 'N' = p_project_in.enable_top_task_inv_mth_flag THEN
16555: IF nvl(p_project_in.distribution_rule,PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
16556: UPDATE pa_projects_all
16557: SET distribution_rule =
16558: substr(distribution_rule,1,instr(distribution_rule,'/')-1)||'/'||l_proj_invoice_method
16559: WHERE project_id = l_project_id;
16560: END IF;

Line 16593: UPDATE pa_projects_all

16589:
16590: --IF the invoice method at top task flag is checked,
16591: --invoice method of the distribution rule must internally be populated as WORK
16592: IF 'Y' = l_proj_top_task_inv_mth_flag THEN
16593: UPDATE pa_projects_all
16594: SET distribution_rule =
16595: substr(distribution_rule,1,instr(distribution_rule,'/')-1)||'/'||'WORK'
16596: WHERE project_id = l_project_id;
16597: END IF;

Line 21677: pa_debug.debug(' Updated PA_PROJECTS_ALL for status history');

21673: X_LAST_UPDATE_DATE => sysdate,
21674: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
21675:
21676: IF (l_debug_mode = 'Y') THEN
21677: pa_debug.debug(' Updated PA_PROJECTS_ALL for status history');
21678: END IF;
21679:
21680: --Fix for bug#9110781 Ends
21681:

Line 22806: FROM pa_projects_all

22802: --Bug 3279981. Fetch project information
22803: CURSOR cur_get_proj_billing_info(c_project_id IN NUMBER) IS
22804: SELECT enable_top_task_customer_flag, enable_top_task_inv_mth_flag,
22805: revenue_accrual_method, invoice_method, project_type
22806: FROM pa_projects_all
22807: WHERE project_id = c_project_id;
22808:
22809: CURSOR cur_check_proj_cust_exist (c_project_id IN NUMBER , c_customer_id IN NUMBER ) IS
22810: SELECT 'Y'

Line 30091: l_project_number Pa_Projects_All.Segment1%TYPE;

30087: IS
30088:
30089: l_project_id NUMBER;
30090: l_task_id NUMBER;
30091: l_project_number Pa_Projects_All.Segment1%TYPE;
30092: l_task_number Pa_Proj_Elements.Name%TYPE;
30093: l_task_source_reference VARCHAR2(240);
30094: l_deliverable_element_id NUMBER;
30095: l_deliverable_version_id NUMBER;

Line 30316: FROM Pa_Projects_All

30312: l_task_number := null;
30313: END IF;
30314:
30315: SELECT segment1 INTO l_project_number
30316: FROM Pa_Projects_All
30317: WHERE project_id = l_project_id;
30318:
30319: IF p_debug_mode = 'Y' THEN
30320: pa_debug.g_err_stage := 'Creating deliverable ['|| p_deliverable_short_name||']['||p_pm_deliverable_reference||']['

Line 30768: l_project_number Pa_Projects_All.Segment1%TYPE;

30764: l_action_out_tbl action_out_tbl_type ;
30765:
30766: l_project_id NUMBER;
30767: l_task_id NUMBER;
30768: l_project_number Pa_Projects_All.Segment1%TYPE;
30769: l_task_number Pa_Proj_Elements.Name%TYPE;
30770: l_dlvr_type_id Pa_Proj_Elements.type_id%TYPE;
30771:
30772: l_dlvr_prg_enabled VARCHAR2(1) := NULL;

Line 35165: from pa_projects_all

35161:
35162: CURSOR get_template_flag(c_project_id NUMBER)
35163: IS
35164: select template_flag
35165: from pa_projects_all
35166: where project_id = c_project_id;
35167:
35168: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35169: IS

Line 35417: from pa_projects_all

35413:
35414: CURSOR get_template_flag(c_project_id NUMBER)
35415: IS
35416: select template_flag
35417: from pa_projects_all
35418: where project_id = c_project_id;
35419:
35420: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35421: IS

Line 35678: from pa_projects_all

35674:
35675: CURSOR get_template_flag(c_project_id NUMBER)
35676: IS
35677: select template_flag
35678: from pa_projects_all
35679: where project_id = c_project_id;
35680:
35681: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35682: IS

Line 36658: pa_projects_all ppa

36654: ,ppes.element_version_id structure_version_id
36655: ,ppa.segment1 project_number
36656: ,ppes.name structure_name
36657: from pa_proj_elem_ver_structure ppes,
36658: pa_projects_all ppa
36659: where ppa.project_id = ppes.project_id
36660: and ppes.process_update_wbs_flag = 'Y'
36661: and NVL(ppes.process_code,'WUE') = 'WUE'
36662: and ppa.segment1 between nvl(p_project_num_from,ppa.segment1)

Line 36835: from pa_projects_all ppa

36831: l_allow_multi_program_rollup VARCHAR2(1) := NULL;
36832:
36833: cursor l_cur_sys_program_flag(c_project_id NUMBER) is
36834: select ppa.sys_program_flag
36835: from pa_projects_all ppa
36836: where ppa.project_id = c_project_id;
36837:
36838: cursor l_cur_allow_multi_prog_rollup(c_project_id NUMBER) is
36839: select ppa.allow_multi_program_rollup

Line 36840: from pa_projects_all ppa

36836: where ppa.project_id = c_project_id;
36837:
36838: cursor l_cur_allow_multi_prog_rollup(c_project_id NUMBER) is
36839: select ppa.allow_multi_program_rollup
36840: from pa_projects_all ppa
36841: where ppa.project_id = c_project_id;
36842:
36843: l_msg_index_out NUMBER := NULL;
36844: l_return_status VARCHAR2(1) := NULL;

Line 37066: from pa_projects_all ppa, pa_proj_element_versions ppev

37062: l_msg_data VARCHAR2(2000) := NULL;
37063:
37064: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37065: select ppa.name
37066: from pa_projects_all ppa, pa_proj_element_versions ppev
37067: where ppa.project_id = ppev.project_id
37068: and ppev.element_version_id = c_task_version_id;
37069:
37070: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 37072: from pa_projects_all ppa

37068: and ppev.element_version_id = c_task_version_id;
37069:
37070: cursor l_cur_prog_name2 (c_project_id NUMBER) is
37071: select ppa.name
37072: from pa_projects_all ppa
37073: where ppa.project_id = c_project_id;
37074:
37075: cursor l_cur_proj_name (c_project_id NUMBER) is
37076: select ppa.name

Line 37077: from pa_projects_all ppa

37073: where ppa.project_id = c_project_id;
37074:
37075: cursor l_cur_proj_name (c_project_id NUMBER) is
37076: select ppa.name
37077: from pa_projects_all ppa
37078: where ppa.project_id = c_project_id;
37079:
37080: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37081: select ppe.name

Line 37089: from pa_projects_all ppa

37085: and ppev.element_version_id = c_task_ver_id;
37086:
37087: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37088: select ppa.project_id
37089: from pa_projects_all ppa
37090: where pm_project_reference = c_sub_project_reference
37091: and ppa.project_id = c_sub_project_id;
37092:
37093: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 37095: from pa_projects_all ppa

37091: and ppa.project_id = c_sub_project_id;
37092:
37093: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
37094: select ppa.project_id
37095: from pa_projects_all ppa
37096: where pm_project_reference = c_sub_project_reference;
37097:
37098: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37099: select ppa.project_id

Line 37100: from pa_projects_all ppa

37096: where pm_project_reference = c_sub_project_reference;
37097:
37098: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37099: select ppa.project_id
37100: from pa_projects_all ppa
37101: where ppa.project_id = c_sub_project_id;
37102:
37103: l_parent_sub_flag VARCHAR2(1) := NULL;
37104:

Line 37646: from pa_projects_all ppa, pa_proj_element_versions ppev

37642: and por.object_relationship_id = c_object_relationship_id;
37643:
37644: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37645: select ppa.name
37646: from pa_projects_all ppa, pa_proj_element_versions ppev
37647: where ppa.project_id = ppev.project_id
37648: and ppev.element_version_id = c_task_version_id;
37649:
37650: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 37652: from pa_projects_all ppa

37648: and ppev.element_version_id = c_task_version_id;
37649:
37650: cursor l_cur_prog_name2 (c_project_id NUMBER) is
37651: select ppa.name
37652: from pa_projects_all ppa
37653: where ppa.project_id = c_project_id;
37654:
37655: cursor l_cur_proj_name (c_project_id NUMBER) is
37656: select ppa.name

Line 37657: from pa_projects_all ppa

37653: where ppa.project_id = c_project_id;
37654:
37655: cursor l_cur_proj_name (c_project_id NUMBER) is
37656: select ppa.name
37657: from pa_projects_all ppa
37658: where ppa.project_id = c_project_id;
37659:
37660: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37661: select ppe.name

Line 37674: from pa_projects_all ppa

37670: where ppev.element_version_id = c_task_version_id;
37671:
37672: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37673: select ppa.project_id
37674: from pa_projects_all ppa
37675: where pm_project_reference = c_sub_project_reference
37676: and ppa.project_id = c_sub_project_id;
37677:
37678: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 37680: from pa_projects_all ppa

37676: and ppa.project_id = c_sub_project_id;
37677:
37678: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
37679: select ppa.project_id
37680: from pa_projects_all ppa
37681: where pm_project_reference = c_sub_project_reference;
37682:
37683: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37684: select ppa.project_id

Line 37685: from pa_projects_all ppa

37681: where pm_project_reference = c_sub_project_reference;
37682:
37683: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
37684: select ppa.project_id
37685: from pa_projects_all ppa
37686: where ppa.project_id = c_sub_project_id;
37687:
37688: l_parent_sub_flag VARCHAR2(1) := NULL;
37689:

Line 38236: from pa_projects_all ppa, pa_proj_element_versions ppev

38232: and por.object_relationship_id = c_object_relationship_id;
38233:
38234: cursor l_cur_prog_name (c_task_version_id NUMBER) is
38235: select ppa.name
38236: from pa_projects_all ppa, pa_proj_element_versions ppev
38237: where ppa.project_id = ppev.project_id
38238: and ppev.element_version_id = c_task_version_id;
38239:
38240: cursor l_cur_proj_name (c_project_id NUMBER) is

Line 38242: from pa_projects_all ppa

38238: and ppev.element_version_id = c_task_version_id;
38239:
38240: cursor l_cur_proj_name (c_project_id NUMBER) is
38241: select ppa.name
38242: from pa_projects_all ppa
38243: where ppa.project_id = c_project_id;
38244:
38245: cursor l_cur_task_name (c_task_ver_id NUMBER) is
38246: select ppe.name

Line 38259: from pa_projects_all ppa

38255: where ppev.element_version_id = c_task_version_id;
38256:
38257: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
38258: select ppa.project_id
38259: from pa_projects_all ppa
38260: where pm_project_reference = c_sub_project_reference
38261: and ppa.project_id = c_sub_project_id;
38262:
38263: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is

Line 38265: from pa_projects_all ppa

38261: and ppa.project_id = c_sub_project_id;
38262:
38263: cursor l_cur_sub_proj2(c_sub_project_reference VARCHAR2) is
38264: select ppa.project_id
38265: from pa_projects_all ppa
38266: where pm_project_reference = c_sub_project_reference;
38267:
38268: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
38269: select ppa.project_id

Line 38270: from pa_projects_all ppa

38266: where pm_project_reference = c_sub_project_reference;
38267:
38268: cursor l_cur_sub_proj3(c_sub_project_id NUMBER) is
38269: select ppa.project_id
38270: from pa_projects_all ppa
38271: where ppa.project_id = c_sub_project_id;
38272:
38273: l_program_name VARCHAR2(30) := NULL;
38274: l_project_name VARCHAR2(30) := NULL;

Line 38728: FROM PA_PROJECTS_ALL

38724:
38725: CURSOR get_project_details_csr (c_project_id NUMBER) IS
38726: SELECT project_id, name, segment1, pm_project_reference,
38727: start_date, completion_date, project_type, structure_sharing_code
38728: FROM PA_PROJECTS_ALL
38729: WHERE project_id = c_project_id;
38730:
38731: CURSOR get_task_details_csr (c_project_id NUMBER) IS
38732: SELECT element_version_id,proj_element_id,display_sequence,wbs_level,wbs_number

Line 39041: FROM PA_PROJECTS_ALL

39037:
39038: CURSOR get_project_details_csr (c_project_id NUMBER) IS
39039: SELECT project_id, name, segment1, pm_project_reference,
39040: start_date, completion_date, project_type, structure_sharing_code
39041: FROM PA_PROJECTS_ALL
39042: WHERE project_id = c_project_id;
39043:
39044: CURSOR check_tasks_exists_csr(c_project_id NUMBER) IS
39045: SELECT 'Y'

Line 39635: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

39631: l_err_code NUMBER := 0;
39632: l_err_stack VARCHAR2(200) := NULL;
39633: l_err_stage VARCHAR2(200) := NULL;
39634:
39635: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
39636:
39637: l_cur_project_id NUMBER;
39638: CURSOR cur_proj_id
39639: IS

Line 39646: FROM PA_PROJECTS_ALL

39642: WHERE element_version_id = p_structure_version_id;
39643:
39644: CURSOR get_product_code ( c_project_id NUMBER ) IS
39645: SELECT pm_product_code
39646: FROM PA_PROJECTS_ALL
39647: WHERE project_id = c_project_id;
39648:
39649: CURSOR cur_struc_type( c_structure_id NUMBER )
39650: IS

Line 40123: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

40119: l_err_code NUMBER := 0;
40120: l_err_stack VARCHAR2(200) := NULL;
40121: l_err_stage VARCHAR2(200) := NULL;
40122:
40123: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
40124:
40125: CURSOR get_product_code ( c_project_id NUMBER ) IS
40126: SELECT pm_product_code
40127: FROM PA_PROJECTS_ALL

Line 40127: FROM PA_PROJECTS_ALL

40123: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
40124:
40125: CURSOR get_product_code ( c_project_id NUMBER ) IS
40126: SELECT pm_product_code
40127: FROM PA_PROJECTS_ALL
40128: WHERE project_id = c_project_id;
40129:
40130: l_cur_project_id NUMBER;
40131: CURSOR cur_proj_id

Line 41573: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

41569: l_err_code NUMBER := 0;
41570: l_err_stack VARCHAR2(200) := NULL;
41571: l_err_stage VARCHAR2(200) := NULL;
41572:
41573: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
41574:
41575: CURSOR get_product_code ( c_project_id NUMBER ) IS
41576: SELECT pm_product_code
41577: FROM PA_PROJECTS_ALL

Line 41577: FROM PA_PROJECTS_ALL

41573: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
41574:
41575: CURSOR get_product_code ( c_project_id NUMBER ) IS
41576: SELECT pm_product_code
41577: FROM PA_PROJECTS_ALL
41578: WHERE project_id = c_project_id;
41579:
41580: l_cur_project_id NUMBER;
41581: CURSOR cur_proj_id

Line 43305: FROM PA_PROJECTS_ALL

43301: l_count Number :=0;
43302:
43303: Cursor C1(c_proj_id Number) IS
43304: Select NVL(CBS_ENABLE_FLAG,'N')
43305: FROM PA_PROJECTS_ALL
43306: WHERE PROJECT_ID=c_proj_id;
43307:
43308: Cursor C2(c_proj_id Number , c_number varchar2) IS
43309: Select proj_element_id

Line 43334: FROM PA_PROJECTS_ALL PA,PA_RBS_ELEMENTS PRE

43330: and task_id=c_task_id;
43331:
43332: Cursor Check_cost_code_valid(c_proj_id Number ,c_cbs_lem_id Number) IS
43333: SELECT COUNT(1)
43334: FROM PA_PROJECTS_ALL PA,PA_RBS_ELEMENTS PRE
43335: WHERE PA.CBS_VERSION_ID=PRE.RBS_VERSION_ID
43336: AND PA.PROJECT_ID=c_proj_id
43337: AND PRE.RBS_ELEMENT_ID=c_cbs_lem_id;
43338:

Line 43603: FROM PA_PROJECTS_ALL

43599: l_count Number :=0;
43600:
43601: Cursor C1(c_proj_id Number) IS
43602: Select NVL(CBS_ENABLE_FLAG,'N')
43603: FROM PA_PROJECTS_ALL
43604: WHERE PROJECT_ID=c_proj_id;
43605:
43606: Cursor C2(c_proj_id Number , c_number varchar2) IS
43607: Select proj_element_id

Line 43632: FROM PA_PROJECTS_ALL PA,PA_RBS_ELEMENTS PRE

43628: and task_id=c_task_id;
43629:
43630: Cursor Check_cost_code_valid(c_proj_id Number ,c_cbs_lem_id Number) IS
43631: SELECT COUNT(1)
43632: FROM PA_PROJECTS_ALL PA,PA_RBS_ELEMENTS PRE
43633: WHERE PA.CBS_VERSION_ID=PRE.RBS_VERSION_ID
43634: AND PA.PROJECT_ID=c_proj_id
43635: AND PRE.RBS_ELEMENT_ID=c_cbs_lem_id;
43636: