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 2317: from pa_proj_structure_types

2313: l_msg_data VARCHAR2(250);
2314:
2315: cursor sel_struct_type IS
2316: select rowid
2317: from pa_proj_structure_types
2318: where proj_element_id = p_structure_id;
2319:
2320: -- Begin fix for Bug # 4506308.
2321:

Line 2377: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

2373: OPEN sel_struct_type;
2374: LOOP
2375: FETCH sel_struct_type into l_rowid;
2376: EXIT WHEN sel_struct_type%NOTFOUND;
2377: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
2378: END LOOP;
2379: CLOSE sel_struct_type;
2380:
2381: --Lock record

Line 6329: PA_PROJ_STRUCTURE_TYPES ppst

6325: IS
6326: SELECT pst.structure_type_class_code
6327: FROM PA_STRUCTURE_TYPES pst,
6328: PA_PROJ_ELEMENT_VERSIONS ppev,
6329: PA_PROJ_STRUCTURE_TYPES ppst
6330: WHERE ppev.element_version_id = c_structure_version_id
6331: AND ppev.proj_element_id = ppst.proj_element_id
6332: AND ppst.structure_type_id = pst.structure_type_id;
6333:

Line 6499: PA_PROJ_STRUCTURE_TYPES ppst

6495:
6496: SELECT pst.structure_type_class_code
6497: INTO l_structure_type1
6498: FROM PA_STRUCTURE_TYPES pst,
6499: PA_PROJ_STRUCTURE_TYPES ppst
6500: WHERE ppst.proj_element_id = l_structure_ver_to_rec.proj_element_id
6501: AND pst.structure_type_id = ppst.structure_type_id;
6502:
6503: PA_RELATIONSHIP_PVT.Create_Relationship(

Line 6538: PA_PROJ_STRUCTURE_TYPES ppst

6534:
6535: SELECT pst.structure_type_class_code
6536: INTO l_structure_type1
6537: FROM PA_STRUCTURE_TYPES pst,
6538: PA_PROJ_STRUCTURE_TYPES ppst
6539: WHERE ppst.proj_element_id = l_info_task_ver_rec.structure_id
6540: AND pst.structure_type_id = ppst.structure_type_id;
6541:
6542: PA_RELATIONSHIP_PVT.Create_Relationship(

Line 7118: PA_PROJ_STRUCTURE_TYPES ppst

7114: CURSOR l_get_structure_type_csr(c_proj_element_id NUMBER)
7115: IS
7116: SELECT structure_type_class_code
7117: FROM PA_STRUCTURE_TYPES pst,
7118: PA_PROJ_STRUCTURE_TYPES ppst
7119: WHERE ppst.proj_element_id = c_proj_element_id
7120: AND pst.structure_type_id = ppst.structure_type_id;
7121:
7122: CURSOR l_get_structure_csr(c_project_id NUMBER)

Line 8957: pa_proj_structure_types b,

8953: IS
8954: cursor c1 IS
8955: select a.proj_element_id
8956: from pa_proj_elements a,
8957: pa_proj_structure_types b,
8958: pa_structure_types c
8959: where a.project_id = p_project_id
8960: and a.object_type = 'PA_STRUCTURES'
8961: and a.proj_element_id = b.proj_element_id

Line 8967: from pa_proj_structure_types a, pa_structure_types b

8963: and c.structure_type_class_code IN ('FINANCIAL');
8964:
8965: cursor sel_struct_type(c_structure_id NUMBER) IS
8966: select a.rowid
8967: from pa_proj_structure_types a, pa_structure_types b
8968: where a.proj_element_id = c_structure_id
8969: and a.structure_type_id = b.structure_type_id
8970: and b.structure_type_class_code = 'WORKPLAN';
8971:

Line 9018: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

9014: IF sel_struct_type%FOUND THEN
9015: IF (p_debug_mode = 'Y') THEN
9016: pa_debug.debug('Deleting type structure type');
9017: END IF;
9018: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
9019: END IF;
9020: CLOSE sel_struct_type;
9021:
9022: --create_structure

Line 9898: pa_proj_structure_types c,

9894: CURSOR get_wp_attr_rvn IS
9895: select b.proj_element_id, a.record_version_number
9896: from pa_proj_workplan_attr a,
9897: pa_proj_elements b,
9898: pa_proj_structure_types c,
9899: pa_structure_types d
9900: where a.project_id = b.project_id
9901: and a.proj_element_id = b.proj_element_id
9902: and b.project_id = p_project_id

Line 9909: from pa_proj_structure_types a,

9905: and d.structure_type_class_code = 'WORKPLAN';
9906:
9907: cursor sel_wp_struct_type(c_structure_id NUMBER) IS
9908: select a.rowid
9909: from pa_proj_structure_types a,
9910: pa_structure_types b
9911: where a.proj_element_id = c_structure_id
9912: and a.structure_type_id = b.structure_type_id
9913: and b.structure_type_class_code = 'WORKPLAN';

Line 9926: pa_proj_structure_types b,

9922:
9923: cursor sel_wp_structure_id IS
9924: select a.proj_element_id
9925: from pa_proj_elements a,
9926: pa_proj_structure_types b,
9927: pa_structure_types c
9928: where a.project_id = p_project_id
9929: and a.object_type = 'PA_STRUCTURES'
9930: and a.proj_element_id = b.proj_element_id

Line 9975: pa_proj_structure_types b,

9971:
9972: cursor sel_fin_structure_id IS
9973: select a.proj_element_id
9974: from pa_proj_elements a,
9975: pa_proj_structure_types b,
9976: pa_structure_types c
9977: where a.project_id = p_project_id
9978: and a.object_type = 'PA_STRUCTURES'
9979: and a.proj_element_id = b.proj_element_id

Line 10360: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

10356:
10357: --Delete structure type
10358: OPEN sel_wp_struct_type(l_structure_id);
10359: FETCH sel_wp_struct_type into l_rowid;
10360: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
10361: CLOSE sel_wp_struct_type;
10362:
10363: --Update structure status to published if project;
10364: -- working if template

Line 10581: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

10577: OPEN sel_struc_type_id;
10578: FETCH sel_struc_type_id INTO l_struc_type_id;
10579: CLOSE sel_struc_type_id;
10580:
10581: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
10582: X_ROWID => l_rowid
10583: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
10584: ,X_PROJ_ELEMENT_ID => l_structure_id
10585: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 11052: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);

11048:
11049: --Delete structure type
11050: OPEN sel_wp_struct_type(l_structure_id);
11051: FETCH sel_wp_struct_type into l_rowid;
11052: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
11053: CLOSE sel_wp_struct_type;
11054:
11055: --Update structure status to published if project;
11056: -- working if template

Line 11669: pa_proj_structure_types ppst,

11665: cursor get_wp_versions IS
11666: select ppevs.element_version_id
11667: from pa_proj_elem_ver_structure ppevs,
11668: pa_proj_elements ppe,
11669: pa_proj_structure_types ppst,
11670: pa_structure_types pst
11671: where ppevs.status_code <> 'STRUCTURE_PUBLISHED'
11672: and ppevs.project_id = ppe.project_id
11673: and ppevs.proj_element_id = ppe.proj_element_id

Line 11684: pa_proj_structure_types ppst,

11680: union all
11681: select ppevs.element_version_id
11682: from pa_proj_elem_ver_structure ppevs,
11683: pa_proj_elements ppe,
11684: pa_proj_structure_types ppst,
11685: pa_structure_types pst
11686: where ppevs.status_code = 'STRUCTURE_PUBLISHED'
11687: and ppevs.project_id = ppe.project_id
11688: and ppevs.proj_element_id = ppe.proj_element_id

Line 13331: PA_PROJ_STRUCTURE_TYPES ppst

13327: IS
13328: SELECT pst.structure_type_class_code
13329: FROM PA_STRUCTURE_TYPES pst,
13330: PA_PROJ_ELEMENT_VERSIONS ppev,
13331: PA_PROJ_STRUCTURE_TYPES ppst
13332: WHERE ppev.element_version_id = c_structure_version_id
13333: AND ppev.proj_element_id = ppst.proj_element_id
13334: AND ppst.structure_type_id = pst.structure_type_id;
13335:

Line 14259: pa_proj_structure_types c,

14255: CURSOR get_wp_attr_rvn IS
14256: select b.proj_element_id, a.record_version_number
14257: from pa_proj_workplan_attr a,
14258: pa_proj_elements b,
14259: pa_proj_structure_types c,
14260: pa_structure_types d
14261: where a.project_id = b.project_id
14262: and a.proj_element_id = b.proj_element_id
14263: and b.project_id = p_project_id

Line 14270: from pa_proj_structure_types a,

14266: and d.structure_type_class_code = 'WORKPLAN';
14267:
14268: cursor sel_wp_struct_type(c_structure_id NUMBER) IS
14269: select a.rowid
14270: from pa_proj_structure_types a,
14271: pa_structure_types b
14272: where a.proj_element_id = c_structure_id
14273: and a.structure_type_id = b.structure_type_id
14274: and b.structure_type_class_code = 'WORKPLAN';

Line 14289: pa_proj_structure_types b,

14285: l_wp_structure_code VARCHAR2(10) := 'WORKPLAN';
14286: cursor sel_wp_structure_id IS
14287: select a.proj_element_id
14288: from pa_proj_elements a,
14289: pa_proj_structure_types b,
14290: pa_structure_types c
14291: where a.project_id = p_project_id
14292: and a.object_type = 'PA_STRUCTURES'
14293: and a.proj_element_id = b.proj_element_id

Line 14341: pa_proj_structure_types b,

14337: l_fin_structure_code VARCHAR2(10) := 'FINANCIAL';
14338: cursor sel_fin_structure_id IS
14339: select a.proj_element_id
14340: from pa_proj_elements a,
14341: pa_proj_structure_types b,
14342: pa_structure_types c
14343: where a.project_id = p_project_id
14344: and a.object_type = 'PA_STRUCTURES'
14345: and a.proj_element_id = b.proj_element_id

Line 14956: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

14952: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
14953: CLOSE sel_fin_struc_type_id;
14954:
14955: l_proj_structure_type_id := NULL;
14956: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
14957: X_ROWID => l_rowid
14958: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
14959: ,X_PROJ_ELEMENT_ID => l_structure_id
14960: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 15373: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15369: FETCH sel_struc_type_id INTO l_struc_type_id;
15370: CLOSE sel_struc_type_id;
15371:
15372: l_proj_structure_type_id := NULL;
15373: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15374: X_ROWID => l_rowid
15375: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15376: ,X_PROJ_ELEMENT_ID => l_structure_id
15377: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 15941: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

15937: FETCH sel_fin_struc_type_id INTO l_fin_struc_type_id;
15938: CLOSE sel_fin_struc_type_id;
15939:
15940: l_proj_structure_type_id := NULL;
15941: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
15942: X_ROWID => l_rowid
15943: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
15944: ,X_PROJ_ELEMENT_ID => l_structure_id
15945: ,X_STRUCTURE_TYPE_ID => l_fin_struc_type_id

Line 16488: --delete from pa_proj_structure_types

16484: where parent_structure_version_id = l_keep_structure_ver_id
16485: and object_type = 'PA_TASKS'
16486: and financial_task_flag = 'N';
16487:
16488: --delete from pa_proj_structure_types
16489: DELETe FROM pa_proj_structure_types
16490: where proj_element_id = l_structure_id
16491: and structure_type_id = (
16492: select structure_type_id from pa_structure_types

Line 16489: DELETe FROM pa_proj_structure_types

16485: and object_type = 'PA_TASKS'
16486: and financial_task_flag = 'N';
16487:
16488: --delete from pa_proj_structure_types
16489: DELETe FROM pa_proj_structure_types
16490: where proj_element_id = l_structure_id
16491: and structure_type_id = (
16492: select structure_type_id from pa_structure_types
16493: where structure_type = 'WORKPLAN');

Line 16964: --delete from pa_proj_structure_types

16960: where project_id =p_project_id --Bug No 3634334
16961: and parent_structure_version_id = l_keep_structure_ver_id
16962: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16963:
16964: --delete from pa_proj_structure_types
16965: DELETe FROM pa_proj_structure_types
16966: where proj_element_id = l_structure_id
16967: and structure_type_id = (
16968: select structure_type_id from pa_structure_types

Line 16965: DELETe FROM pa_proj_structure_types

16961: and parent_structure_version_id = l_keep_structure_ver_id
16962: and object_type IN ('PA_TASKS', 'PA_STRUCTURES'));
16963:
16964: --delete from pa_proj_structure_types
16965: DELETe FROM pa_proj_structure_types
16966: where proj_element_id = l_structure_id
16967: and structure_type_id = (
16968: select structure_type_id from pa_structure_types
16969: where structure_type = 'WORKPLAN');

Line 17372: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17368: OPEN sel_struc_type_id;
17369: FETCH sel_struc_type_id INTO l_struc_type_id;
17370: CLOSE sel_struc_type_id;
17371:
17372: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17373: X_ROWID => l_rowid
17374: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17375: ,X_PROJ_ELEMENT_ID => l_structure_id
17376: ,X_STRUCTURE_TYPE_ID => l_struc_type_id

Line 17764: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(

17760: OPEN sel_struc_type_id;
17761: FETCH sel_struc_type_id INTO l_struc_type_id;
17762: CLOSE sel_struc_type_id;
17763:
17764: PA_PROJ_STRUCTURE_TYPES_PKG.insert_row(
17765: X_ROWID => l_rowid
17766: ,X_PROJ_STRUCTURE_TYPE_ID => l_proj_structure_type_id
17767: ,X_PROJ_ELEMENT_ID => l_structure_id
17768: ,X_STRUCTURE_TYPE_ID => l_struc_type_id