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_STRUCTURE_PVT1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 113: l_proj_structure_type_id PA_PROJ_STRUCTURE_TYPES.PROJ_STRUCTURE_TYPE_ID%TYPE;

109:
110: l_rowid VARCHAR2(255);
111: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
112: l_structure_type_id PA_STRUCTURE_TYPES.STRUCTURE_TYPE_ID%TYPE;
113: l_proj_structure_type_id PA_PROJ_STRUCTURE_TYPES.PROJ_STRUCTURE_TYPE_ID%TYPE;
114: l_structure_type PA_STRUCTURE_TYPES.STRUCTURE_TYPE_CLASS_CODE%TYPE;
115:
116: l_workplan_license VARCHAR2(1);
117: l_financial_license VARCHAR2(1);

Line 498: --Insert into pa_proj_structure_types

494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: END IF;
497:
498: --Insert into pa_proj_structure_types
499: BEGIN
500: l_proj_structure_type_id := NULL;
501: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
502: X_ROWID => l_rowid

Line 501: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

497:
498: --Insert into pa_proj_structure_types
499: BEGIN
500: l_proj_structure_type_id := NULL;
501: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
502: X_ROWID => l_rowid
503: , X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
504: , X_PROJ_ELEMENT_ID => l_proj_element_id
505: , X_STRUCTURE_TYPE_ID => l_structure_type_id

Line 983: from pa_proj_structure_types p, pa_structure_types s

979: and status_code <> 'STRUCTURE_PUBLISHED';
980:
981: CURSOR check_financial_type(c_structure_id NUMBER) IS
982: select '1'
983: from pa_proj_structure_types p, pa_structure_types s
984: where s.structure_type_class_code IN ('FINANCIAL')
985: and s.structure_type_id = p.structure_type_id
986: and p.proj_element_id = c_structure_id;
987:

Line 2298: from pa_proj_structure_types

2294: l_msg_data VARCHAR2(250);
2295:
2296: cursor sel_struct_type IS
2297: select rowid
2298: from pa_proj_structure_types
2299: where proj_element_id = p_structure_id;
2300:
2301: -- Begin fix for Bug # 4506308.
2302:

Line 2358: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

2354: OPEN sel_struct_type;
2355: LOOP
2356: FETCH sel_struct_type into l_rowid;
2357: EXIT WHEN sel_struct_type%NOTFOUND;
2358: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
2359: END LOOP;
2360: CLOSE sel_struct_type;
2361:
2362: --Lock record

Line 6269: PA_PROJ_STRUCTURE_TYPES ppst

6265: IS
6266: SELECT pst.structure_type_class_code
6267: FROM PA_STRUCTURE_TYPES pst,
6268: PA_PROJ_ELEMENT_VERSIONS ppev,
6269: PA_PROJ_STRUCTURE_TYPES ppst
6270: WHERE ppev.element_version_id = c_structure_version_id
6271: AND ppev.proj_element_id = ppst.proj_element_id
6272: AND ppst.structure_type_id = pst.structure_type_id;
6273:

Line 6439: PA_PROJ_STRUCTURE_TYPES ppst

6435:
6436: SELECT pst.structure_type_class_code
6437: INTO l_structure_type1
6438: FROM PA_STRUCTURE_TYPES pst,
6439: PA_PROJ_STRUCTURE_TYPES ppst
6440: WHERE ppst.proj_element_id = l_structure_ver_to_rec.proj_element_id
6441: AND pst.structure_type_id = ppst.structure_type_id;
6442:
6443: PA_RELATIONSHIP_PVT.Create_Relationship(

Line 6478: PA_PROJ_STRUCTURE_TYPES ppst

6474:
6475: SELECT pst.structure_type_class_code
6476: INTO l_structure_type1
6477: FROM PA_STRUCTURE_TYPES pst,
6478: PA_PROJ_STRUCTURE_TYPES ppst
6479: WHERE ppst.proj_element_id = l_info_task_ver_rec.structure_id
6480: AND pst.structure_type_id = ppst.structure_type_id;
6481:
6482: PA_RELATIONSHIP_PVT.Create_Relationship(

Line 7058: PA_PROJ_STRUCTURE_TYPES ppst

7054: CURSOR l_get_structure_type_csr(c_proj_element_id NUMBER)
7055: IS
7056: SELECT structure_type_class_code
7057: FROM PA_STRUCTURE_TYPES pst,
7058: PA_PROJ_STRUCTURE_TYPES ppst
7059: WHERE ppst.proj_element_id = c_proj_element_id
7060: AND pst.structure_type_id = ppst.structure_type_id;
7061:
7062: CURSOR l_get_structure_csr(c_project_id NUMBER)

Line 8585: pa_proj_structure_types b,

8581: IS
8582: cursor c1 IS
8583: select a.proj_element_id
8584: from pa_proj_elements a,
8585: pa_proj_structure_types b,
8586: pa_structure_types c
8587: where a.project_id = p_project_id
8588: and a.object_type = 'PA_STRUCTURES'
8589: and a.proj_element_id = b.proj_element_id

Line 8595: from pa_proj_structure_types a, pa_structure_types b

8591: and c.structure_type_class_code IN ('FINANCIAL');
8592:
8593: cursor sel_struct_type(c_structure_id NUMBER) IS
8594: select a.rowid
8595: from pa_proj_structure_types a, pa_structure_types b
8596: where a.proj_element_id = c_structure_id
8597: and a.structure_type_id = b.structure_type_id
8598: and b.structure_type_class_code = 'WORKPLAN';
8599:

Line 8646: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

8642: IF sel_struct_type%FOUND THEN
8643: IF (p_debug_mode = 'Y') THEN
8644: pa_debug.debug('Deleting type structure type');
8645: END IF;
8646: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
8647: END IF;
8648: CLOSE sel_struct_type;
8649:
8650: --create_structure

Line 9526: pa_proj_structure_types c,

9522: CURSOR get_wp_attr_rvn IS
9523: select b.proj_element_id, a.record_version_number
9524: from pa_proj_workplan_attr a,
9525: pa_proj_elements b,
9526: pa_proj_structure_types c,
9527: pa_structure_types d
9528: where a.project_id = b.project_id
9529: and a.proj_element_id = b.proj_element_id
9530: and b.project_id = p_project_id

Line 9537: from pa_proj_structure_types a,

9533: and d.structure_type_class_code = 'WORKPLAN';
9534:
9535: cursor sel_wp_struct_type(c_structure_id NUMBER) IS
9536: select a.rowid
9537: from pa_proj_structure_types a,
9538: pa_structure_types b
9539: where a.proj_element_id = c_structure_id
9540: and a.structure_type_id = b.structure_type_id
9541: and b.structure_type_class_code = 'WORKPLAN';

Line 9554: pa_proj_structure_types b,

9550:
9551: cursor sel_wp_structure_id IS
9552: select a.proj_element_id
9553: from pa_proj_elements a,
9554: pa_proj_structure_types b,
9555: pa_structure_types c
9556: where a.project_id = p_project_id
9557: and a.object_type = 'PA_STRUCTURES'
9558: and a.proj_element_id = b.proj_element_id

Line 9603: pa_proj_structure_types b,

9599:
9600: cursor sel_fin_structure_id IS
9601: select a.proj_element_id
9602: from pa_proj_elements a,
9603: pa_proj_structure_types b,
9604: pa_structure_types c
9605: where a.project_id = p_project_id
9606: and a.object_type = 'PA_STRUCTURES'
9607: and a.proj_element_id = b.proj_element_id

Line 9988: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

9984:
9985: --Delete structure type
9986: OPEN sel_wp_struct_type(l_structure_id);
9987: FETCH sel_wp_struct_type into l_rowid;
9988: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
9989: CLOSE sel_wp_struct_type;
9990:
9991: --Update structure status to published if project;
9992: -- working if template

Line 10209: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

10205: OPEN sel_struc_type_id;
10206: FETCH sel_struc_type_id INTO l_struc_type_id;
10207: CLOSE sel_struc_type_id;
10208:
10209: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
10210: X_ROWID => l_rowid
10211: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
10212: ,X_PROJ_ELEMENT_ID => l_structure_id
10213: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 10680: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

10676:
10677: --Delete structure type
10678: OPEN sel_wp_struct_type(l_structure_id);
10679: FETCH sel_wp_struct_type into l_rowid;
10680: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
10681: CLOSE sel_wp_struct_type;
10682:
10683: --Update structure status to published if project;
10684: -- working if template

Line 11297: pa_proj_structure_types ppst,

11293: cursor get_wp_versions IS
11294: select ppevs.element_version_id
11295: from pa_proj_elem_ver_structure ppevs,
11296: pa_proj_elements ppe,
11297: pa_proj_structure_types ppst,
11298: pa_structure_types pst
11299: where ppevs.status_code <> 'STRUCTURE_PUBLISHED'
11300: and ppevs.project_id = ppe.project_id
11301: and ppevs.proj_element_id = ppe.proj_element_id

Line 11312: pa_proj_structure_types ppst,

11308: union all
11309: select ppevs.element_version_id
11310: from pa_proj_elem_ver_structure ppevs,
11311: pa_proj_elements ppe,
11312: pa_proj_structure_types ppst,
11313: pa_structure_types pst
11314: where ppevs.status_code = 'STRUCTURE_PUBLISHED'
11315: and ppevs.project_id = ppe.project_id
11316: and ppevs.proj_element_id = ppe.proj_element_id

Line 12959: PA_PROJ_STRUCTURE_TYPES ppst

12955: IS
12956: SELECT pst.structure_type_class_code
12957: FROM PA_STRUCTURE_TYPES pst,
12958: PA_PROJ_ELEMENT_VERSIONS ppev,
12959: PA_PROJ_STRUCTURE_TYPES ppst
12960: WHERE ppev.element_version_id = c_structure_version_id
12961: AND ppev.proj_element_id = ppst.proj_element_id
12962: AND ppst.structure_type_id = pst.structure_type_id;
12963:

Line 13885: pa_proj_structure_types c,

13881: CURSOR get_wp_attr_rvn IS
13882: select b.proj_element_id, a.record_version_number
13883: from pa_proj_workplan_attr a,
13884: pa_proj_elements b,
13885: pa_proj_structure_types c,
13886: pa_structure_types d
13887: where a.project_id = b.project_id
13888: and a.proj_element_id = b.proj_element_id
13889: and b.project_id = p_project_id

Line 13896: from pa_proj_structure_types a,

13892: and d.structure_type_class_code = 'WORKPLAN';
13893:
13894: cursor sel_wp_struct_type(c_structure_id NUMBER) IS
13895: select a.rowid
13896: from pa_proj_structure_types a,
13897: pa_structure_types b
13898: where a.proj_element_id = c_structure_id
13899: and a.structure_type_id = b.structure_type_id
13900: and b.structure_type_class_code = 'WORKPLAN';

Line 13915: pa_proj_structure_types b,

13911: l_wp_structure_code VARCHAR2(10) := 'WORKPLAN';
13912: cursor sel_wp_structure_id IS
13913: select a.proj_element_id
13914: from pa_proj_elements a,
13915: pa_proj_structure_types b,
13916: pa_structure_types c
13917: where a.project_id = p_project_id
13918: and a.object_type = 'PA_STRUCTURES'
13919: and a.proj_element_id = b.proj_element_id

Line 13967: pa_proj_structure_types b,

13963: l_fin_structure_code VARCHAR2(10) := 'FINANCIAL';
13964: cursor sel_fin_structure_id IS
13965: select a.proj_element_id
13966: from pa_proj_elements a,
13967: pa_proj_structure_types b,
13968: pa_structure_types c
13969: where a.project_id = p_project_id
13970: and a.object_type = 'PA_STRUCTURES'
13971: and a.proj_element_id = b.proj_element_id

Line 14580: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14576: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
14577: CLOSE sel_fin_struc_type_id;
14578:
14579: l_proj_structure_type_id := NULL;
14580: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14581: X_ROWID => l_rowid
14582: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
14583: ,X_PROJ_ELEMENT_ID => l_structure_id
14584: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 14997: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14993: FETCH sel_struc_type_id INTO l_struc_type_id;
14994: CLOSE sel_struc_type_id;
14995:
14996: l_proj_structure_type_id := NULL;
14997: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14998: X_ROWID => l_rowid
14999: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15000: ,X_PROJ_ELEMENT_ID => l_structure_id
15001: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 15565: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15561: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
15562: CLOSE sel_fin_struc_type_id;
15563:
15564: l_proj_structure_type_id := NULL;
15565: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15566: X_ROWID => l_rowid
15567: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15568: ,X_PROJ_ELEMENT_ID => l_structure_id
15569: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 16112: --delete from pa_proj_structure_types

16108: where parent_structure_version_id = l_keep_structure_ver_id
16109: and object_type = 'PA_TASKS'
16110: and financial_task_flag = 'N';
16111:
16112: --delete from pa_proj_structure_types
16113: DELETe FROM pa_proj_structure_types
16114: where proj_element_id = l_structure_id
16115: and structure_type_id = (
16116: select structure_type_id from pa_structure_types

Line 16113: DELETe FROM pa_proj_structure_types

16109: and object_type = 'PA_TASKS'
16110: and financial_task_flag = 'N';
16111:
16112: --delete from pa_proj_structure_types
16113: DELETe FROM pa_proj_structure_types
16114: where proj_element_id = l_structure_id
16115: and structure_type_id = (
16116: select structure_type_id from pa_structure_types
16117: where structure_type = 'WORKPLAN');

Line 16588: --delete from pa_proj_structure_types

16584: where project_id =p_project_id --Bug No 3634334
16585: and parent_structure_version_id = l_keep_structure_ver_id
16586: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16587:
16588: --delete from pa_proj_structure_types
16589: DELETe FROM pa_proj_structure_types
16590: where proj_element_id = l_structure_id
16591: and structure_type_id = (
16592: select structure_type_id from pa_structure_types

Line 16589: DELETe FROM pa_proj_structure_types

16585: and parent_structure_version_id = l_keep_structure_ver_id
16586: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16587:
16588: --delete from pa_proj_structure_types
16589: DELETe FROM pa_proj_structure_types
16590: where proj_element_id = l_structure_id
16591: and structure_type_id = (
16592: select structure_type_id from pa_structure_types
16593: where structure_type = 'WORKPLAN');

Line 16996: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

16992: OPEN sel_struc_type_id;
16993: FETCH sel_struc_type_id INTO l_struc_type_id;
16994: CLOSE sel_struc_type_id;
16995:
16996: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
16997: X_ROWID => l_rowid
16998: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
16999: ,X_PROJ_ELEMENT_ID => l_structure_id
17000: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 17388: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17384: OPEN sel_struc_type_id;
17385: FETCH sel_struc_type_id INTO l_struc_type_id;
17386: CLOSE sel_struc_type_id;
17387:
17388: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17389: X_ROWID => l_rowid
17390: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17391: ,X_PROJ_ELEMENT_ID => l_structure_id
17392: ,X_STRUCTURE_TYPE_ID => l_struc_type_id