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_STRUCTURE_TYPES

Line 112: l_structure_type_id PA_STRUCTURE_TYPES.STRUCTURE_TYPE_ID%TYPE;

108: l_error_message_code VARCHAR2(250);
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);

Line 114: l_structure_type PA_STRUCTURE_TYPES.STRUCTURE_TYPE_CLASS_CODE%TYPE;

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);
118: l_multi_struc_license VARCHAR2(1);

Line 152: from pa_structure_types

148: cursor get_licensed(p_workplan VARCHAR2,
149: p_financial VARCHAR2,
150: p_deliverable VARCHAR2) IS
151: select structure_type_id, structure_type_class_code
152: from pa_structure_types
153: where (structure_type_class_code = 'WORKPLAN' and 'Y' = p_workplan)
154: or (structure_type_class_code = 'FINANCIAL' and 'Y' = p_financial)
155: or (structure_type_class_code = 'DELIVERABLE' and 'Y' = p_deliverable);
156: l_deliverable_license VARCHAR2(1) := 'N';

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 6267: FROM PA_STRUCTURE_TYPES pst,

6263:
6264: CURSOR l_get_structure_type_csr(c_structure_version_id NUMBER)
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

Line 6274: l_structure_type PA_STRUCTURE_TYPES.structure_type%TYPE;

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:
6274: l_structure_type PA_STRUCTURE_TYPES.structure_type%TYPE;
6275:
6276: CURSOR l_check_working_versions_csr(c_structure_version_id NUMBER)
6277: IS
6278: SELECT 'Y'

Line 6313: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;

6309: and v1.parent_structure_version_id = v2.element_version_id;
6310: l_info_task_ver_rec get_task_version_info%ROWTYPE;
6311:
6312: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
6313: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
6314:
6315: --hsiu
6316: --added for task weighting
6317: CURSOR get_cur_task_ver_weighting(c_ver_id NUMBER) IS

Line 6438: FROM PA_STRUCTURE_TYPES pst,

6434: FETCH l_get_structure_ver_csr INTO l_structure_ver_to_rec;
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:

Line 6477: FROM PA_STRUCTURE_TYPES pst,

6473: FETCH get_task_version_info INTO l_info_task_ver_rec;
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:

Line 7045: l_structure_type PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;

7041: l_msg_count NUMBER;
7042: l_msg_data VARCHAR2(250);
7043: l_split_cost_workplan_flag VARCHAR2(1);
7044: l_structure_id NUMBER;
7045: l_structure_type PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
7046:
7047: --Bug 2189657
7048: --Added for linking tasks with no display sequence.
7049: Type T_EquivElemVerTable IS TABLE OF NUMBER

Line 7057: FROM PA_STRUCTURE_TYPES pst,

7053:
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:

Line 8586: pa_structure_types c

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
8590: and b.structure_type_id = c.structure_type_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 9527: pa_structure_types d

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
9531: and b.proj_element_id = c.proj_element_id

Line 9538: pa_structure_types b

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';
9542:

Line 9555: pa_structure_types c

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
9559: and b.structure_type_id = c.structure_type_id

Line 9604: pa_structure_types c

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
9608: and b.structure_type_id = c.structure_type_id

Line 9613: from pa_structure_types

9609: and c.structure_type_class_code = 'FINANCIAL';
9610:
9611: CURSOR sel_struc_type_id IS
9612: select structure_type_id
9613: from pa_structure_types
9614: where structure_type_class_code = 'WORKPLAN';
9615:
9616: cursor sel_struc_ver(c_structure_id NUMBER) IS
9617: select element_version_id

Line 11298: pa_structure_types pst

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
11302: and ppe.object_type = 'PA_STRUCTURES'

Line 11313: pa_structure_types pst

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
11317: and ppe.object_type = 'PA_STRUCTURES'

Line 12957: FROM PA_STRUCTURE_TYPES pst,

12953:
12954: CURSOR l_get_structure_type_csr(c_structure_version_id NUMBER)
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

Line 12964: l_structure_type PA_STRUCTURE_TYPES.structure_type%TYPE;

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:
12964: l_structure_type PA_STRUCTURE_TYPES.structure_type%TYPE;
12965:
12966: CURSOR l_check_working_versions_csr(c_structure_version_id NUMBER)
12967: IS
12968: SELECT 'Y'

Line 12985: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;

12981: l_dummy VARCHAR2(1);
12982:
12983:
12984: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
12985: l_structure_type1 PA_STRUCTURE_TYPES.structure_type_class_code%TYPE;
12986:
12987: --Added by rtarway
12988: l_rowid VARCHAR2(255);
12989:

Line 13886: pa_structure_types d

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
13890: and b.proj_element_id = c.proj_element_id

Line 13897: pa_structure_types b

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';
13901:

Line 13916: pa_structure_types c

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
13920: and b.structure_type_id = c.structure_type_id

Line 13968: pa_structure_types c

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
13972: and b.structure_type_id = c.structure_type_id

Line 13978: from pa_structure_types

13974: and c.structure_type_class_code = l_fin_structure_code;
13975:
13976: CURSOR sel_struc_type_id IS
13977: select structure_type_id
13978: from pa_structure_types
13979: where structure_type_class_code = 'WORKPLAN';
13980:
13981: cursor sel_struc_ver(c_structure_id NUMBER) IS
13982: select element_version_id

Line 14051: from pa_structure_types

14047: l_wp_name VARCHAR2(240);
14048:
14049: CURSOR sel_fin_struc_type_id IS
14050: select structure_type_id
14051: from pa_structure_types
14052: where structure_type_class_code = 'FINANCIAL';
14053: l_fin_struc_type_id NUMBER;
14054: l_del_name VARCHAR2(240);
14055: l_wp_enabled VARCHAR2(1);

Line 16116: select structure_type_id from pa_structure_types

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');
16118:
16119: /* Bug 3906015
16120: Moved this code to above (i.e) before deleting the elements (Before deleting task)

Line 16592: select structure_type_id from pa_structure_types

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');
16594:
16595: -- NYU
16596: -- delete deliverable associations