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_PROJ_TASK_STRUC_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 292: FROM pa_object_relationships

288:
289: CURSOR parent_of_previous_task( c_task_version_id NUMBER )
290: IS
291: SELECT object_id_from1
292: FROM pa_object_relationships
293: WHERE object_id_to1 = c_task_version_id
294: and object_type_from in ('PA_STRUCTURES','PA_TASKS') -- bug 6429275
295: and object_type_to = 'PA_TASKS'
296: and relationship_type = 'S';

Line 807: FROM pa_object_relationships

803: WHERE project_id = p_project_id
804: AND object_type = 'PA_TASKS'
805: AND parent_structure_version_id = c_structure_version_id
806: and element_version_id in ( SELECT object_id_to1
807: FROM pa_object_relationships
808: WHERE object_id_from1 = c_parent_task_version_id
809: and relationship_type = 'S'
810: )
811: AND display_sequence = ( SELECT max( display_sequence )

Line 817: FROM pa_object_relationships

813: WHERE project_id = p_project_id
814: AND object_type = 'PA_TASKS'
815: AND parent_structure_version_id = c_structure_version_id
816: and element_version_id in ( SELECT object_id_to1
817: FROM pa_object_relationships
818: WHERE object_id_from1 = c_parent_task_version_id
819: and relationship_type = 'S'
820: )
821: );

Line 854: FROM pa_object_relationships

850:
851: CURSOR cur_child_exists(c_task_ver_id NUMBER)
852: IS
853: select 'Y'
854: FROM pa_object_relationships
855: where object_id_from1 = c_task_ver_id
856: AND object_type_from IN ('PA_TASKS', 'PA_STRUCTURES') --Corrected 'PA_TASK' TO 'PA_TASKS' for Bug 4035526
857: and relationship_type = 'S';
858: l_child_exists VARCHAR2(1);

Line 929: from pa_object_relationships

925:
926: --hsiu added for task status
927: CURSOR get_parent_version_id(c_elem_ver_id NUMBER) IS
928: select object_id_from1
929: from pa_object_relationships
930: where object_id_to1 = c_elem_ver_id
931: and object_type_to = 'PA_TASKS'
932: and relationship_type = 'S';
933: l_parent_ver_id NUMBER;

Line 2348: FROM pa_object_relationships

2344:
2345: CURSOR cur_pa_obj_rel( c_task_version_id NUMBER )
2346: IS
2347: SELECT object_id_from1
2348: FROM pa_object_relationships
2349: WHERE object_id_to1 = c_task_version_id
2350: and relationship_type = 'S';
2351:
2352: CURSOR cur_pa_proj_elem_ver( c_task_version_id NUMBER )

Line 3709: DELETE FROM pa_object_relationships

3705: ,p_msg_name => l_error_message_code);
3706: raise api_error;
3707: END IF;
3708:
3709: DELETE FROM pa_object_relationships
3710: WHERE relationship_type = 'S' AND
3711: (object_id_from1 = cur_task_ver_rec.element_version_id OR
3712: object_id_to1 = cur_task_ver_rec.element_version_id);
3713:

Line 3733: DELETE FROM pa_object_relationships

3729: ,p_msg_name => l_error_message_code);
3730: raise api_error;
3731: END IF;
3732:
3733: DELETE FROM pa_object_relationships
3734: WHERE relationship_type = 'S' AND
3735: (object_id_from1 = cur_str_ver_rec.element_version_id OR
3736: object_id_to1 = cur_str_ver_rec.element_version_id);
3737:

Line 4439: DELETE FROM pa_object_relationships WHERE relationship_type = 'S' AND

4435: FETCH cur_pa_proj_elem_vers INTO l_cur_pa_proj_elem_vers_rec;
4436: IF cur_pa_proj_elem_vers%FOUND
4437: THEN
4438: FOR cur_task_vers_rec IN cur_task_vers( l_cur_pa_proj_elem_vers_rec.element_version_id ) LOOP
4439: DELETE FROM pa_object_relationships WHERE relationship_type = 'S' AND
4440: (object_id_to1 = cur_task_vers_rec.element_version_id OR
4441: object_id_from1 = cur_task_vers_rec.element_version_id);
4442:
4443: --it is possible that COSTING and WORKPLAN str are same. so delete from schedule versions as well.

Line 6823: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE

6819: -- End of code added for bug 3387963
6820:
6821: /* Code added for 6211012*/
6822:
6823: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
6824: INDEX BY BINARY_INTEGER;
6825: l_obj_rel_id typ_obj_rela_id;
6826:
6827: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

Line 6827: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

6823: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
6824: INDEX BY BINARY_INTEGER;
6825: l_obj_rel_id typ_obj_rela_id;
6826:
6827: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
6828: INDEX BY BINARY_INTEGER;
6829: l_obj_typ_from typ_obj_typ_from;
6830:
6831: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

Line 6831: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

6827: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
6828: INDEX BY BINARY_INTEGER;
6829: l_obj_typ_from typ_obj_typ_from;
6830:
6831: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
6832: INDEX BY BINARY_INTEGER;
6833: l_obj_from_id typ_obj_from_id;
6834:
6835: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

Line 6835: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

6831: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
6832: INDEX BY BINARY_INTEGER;
6833: l_obj_from_id typ_obj_from_id;
6834:
6835: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
6836: INDEX BY BINARY_INTEGER;
6837: l_obj_typ_to typ_obj_typ_to;
6838:
6839: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

Line 6839: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

6835: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
6836: INDEX BY BINARY_INTEGER;
6837: l_obj_typ_to typ_obj_typ_to;
6838:
6839: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
6840: INDEX BY BINARY_INTEGER;
6841: l_obj_to_id typ_obj_to_id;
6842:
6843: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

Line 6843: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

6839: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
6840: INDEX BY BINARY_INTEGER;
6841: l_obj_to_id typ_obj_to_id;
6842:
6843: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
6844: INDEX BY BINARY_INTEGER;
6845: l_rel_typ typ_rel_typ;
6846:
6847: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

Line 6847: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

6843: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
6844: INDEX BY BINARY_INTEGER;
6845: l_rel_typ typ_rel_typ;
6846:
6847: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
6848: INDEX BY BINARY_INTEGER;
6849: l_rel_subtyp typ_rel_subtyp;
6850:
6851: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

Line 6851: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

6847: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
6848: INDEX BY BINARY_INTEGER;
6849: l_rel_subtyp typ_rel_subtyp;
6850:
6851: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
6852: INDEX BY BINARY_INTEGER;
6853: l_rec_ver_num typ_rec_ver_num;
6854:
6855: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

Line 6855: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

6851: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
6852: INDEX BY BINARY_INTEGER;
6853: l_rec_ver_num typ_rec_ver_num;
6854:
6855: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE
6856: INDEX BY BINARY_INTEGER;
6857: l_wt_percent typ_wt_percent;
6858:
6859:

Line 6864: pa_object_relationships_s.nextval,

6860: CURSOR cur_pa_obj_rela_1(c_src_fin_version_id NUMBER,
6861: c_dest_project_id NUMBER
6862: ) IS
6863: SELECT
6864: pa_object_relationships_s.nextval,
6865: pobj.object_type_from,
6866: ppev1.element_version_id,
6867: pobj.object_type_to,
6868: ppev2.element_version_id,

Line 6881: FROM pa_object_relationships

6877: relationship_type,
6878: relationship_subtype,
6879: Record_Version_Number,
6880: weighting_percentage
6881: FROM pa_object_relationships
6882: START WITH object_id_from1 = c_src_fin_version_id
6883: AND RELATIONSHIP_TYPE = 'S'
6884: CONNECT BY object_id_from1 = PRIOR object_id_to1
6885: AND RELATIONSHIP_TYPE = 'S' ) pobj,

Line 7267: insert into PA_OBJECT_RELATIONSHIPS (

7263:
7264: IF l_obj_rel_id.COUNT >0 THEN
7265:
7266: FORALL i IN l_obj_rel_id.FIRST..l_obj_rel_id.LAST
7267: insert into PA_OBJECT_RELATIONSHIPS (
7268: object_relationship_id,
7269: object_type_from,
7270: object_id_from1,
7271: object_type_to,

Line 7319: INSERT INTO PA_OBJECT_RELATIONSHIPS (

7315: CLOSE cur_pa_obj_rela_1;
7316:
7317: /*
7318:
7319: INSERT INTO PA_OBJECT_RELATIONSHIPS (
7320: object_relationship_id
7321: ,object_type_from
7322: ,object_id_from1
7323: ,object_type_to

Line 7336: pa_object_relationships_s.nextval

7332: ,LAST_UPDATE_LOGIN
7333: ,weighting_percentage
7334: )
7335: SELECT
7336: pa_object_relationships_s.nextval
7337: ,pobj.object_type_from
7338: ,ppev1.element_version_id
7339: ,pobj.object_type_to
7340: ,ppev2.element_version_id

Line 7359: FROM pa_object_relationships

7355: relationship_type,
7356: relationship_subtype,
7357: Record_Version_Number,
7358: weighting_percentage
7359: FROM pa_object_relationships
7360: START WITH object_id_from1 = l_src_fin_version_id
7361: AND RELATIONSHIP_TYPE = 'S'
7362: CONNECT BY object_id_from1 = PRIOR object_id_to1
7363: AND RELATIONSHIP_TYPE = 'S' ) pobj,

Line 7838: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE

7834: --3916763 End
7835:
7836: /* Code added for 6211012*/
7837:
7838: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
7839: INDEX BY BINARY_INTEGER;
7840: l_obj_rel_id typ_obj_rela_id;
7841:
7842: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

Line 7842: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

7838: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
7839: INDEX BY BINARY_INTEGER;
7840: l_obj_rel_id typ_obj_rela_id;
7841:
7842: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
7843: INDEX BY BINARY_INTEGER;
7844: l_obj_typ_from typ_obj_typ_from;
7845:
7846: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

Line 7846: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

7842: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
7843: INDEX BY BINARY_INTEGER;
7844: l_obj_typ_from typ_obj_typ_from;
7845:
7846: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
7847: INDEX BY BINARY_INTEGER;
7848: l_obj_from_id typ_obj_from_id;
7849:
7850: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

Line 7850: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

7846: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
7847: INDEX BY BINARY_INTEGER;
7848: l_obj_from_id typ_obj_from_id;
7849:
7850: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
7851: INDEX BY BINARY_INTEGER;
7852: l_obj_typ_to typ_obj_typ_to;
7853:
7854: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

Line 7854: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

7850: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
7851: INDEX BY BINARY_INTEGER;
7852: l_obj_typ_to typ_obj_typ_to;
7853:
7854: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
7855: INDEX BY BINARY_INTEGER;
7856: l_obj_to_id typ_obj_to_id;
7857:
7858: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

Line 7858: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

7854: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
7855: INDEX BY BINARY_INTEGER;
7856: l_obj_to_id typ_obj_to_id;
7857:
7858: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
7859: INDEX BY BINARY_INTEGER;
7860: l_rel_typ typ_rel_typ;
7861:
7862: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

Line 7862: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

7858: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
7859: INDEX BY BINARY_INTEGER;
7860: l_rel_typ typ_rel_typ;
7861:
7862: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
7863: INDEX BY BINARY_INTEGER;
7864: l_rel_subtyp typ_rel_subtyp;
7865:
7866: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

Line 7866: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

7862: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
7863: INDEX BY BINARY_INTEGER;
7864: l_rel_subtyp typ_rel_subtyp;
7865:
7866: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
7867: INDEX BY BINARY_INTEGER;
7868: l_rec_ver_num typ_rec_ver_num;
7869:
7870: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

Line 7870: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

7866: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
7867: INDEX BY BINARY_INTEGER;
7868: l_rec_ver_num typ_rec_ver_num;
7869:
7870: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE
7871: INDEX BY BINARY_INTEGER;
7872: l_wt_percent typ_wt_percent;
7873:
7874:

Line 7879: pa_object_relationships_s.nextval,

7875: CURSOR cur_pa_obj_rela_2(c_src_str_version_id NUMBER,
7876: c_struc_version_id NUMBER
7877: ) IS
7878: SELECT /*+ USE_HASH(ppev2 ppev1)*/
7879: pa_object_relationships_s.nextval,
7880: pobj.object_type_from,
7881: ppev1.element_version_id,
7882: pobj.object_type_to,
7883: ppev2.element_version_id,

Line 7892: FROM pa_object_relationships

7888: FROM ( SELECT object_type_from, object_id_from1,
7889: object_type_to, object_id_to1,
7890: relationship_type, relationship_subtype,
7891: Record_Version_Number, weighting_percentage
7892: FROM pa_object_relationships
7893: START WITH object_id_from1 = c_src_str_version_id
7894: AND RELATIONSHIP_TYPE = 'S'
7895: CONNECT BY object_id_from1 = PRIOR object_id_to1
7896: AND RELATIONSHIP_TYPE = 'S' ) pobj,

Line 9441: insert into PA_OBJECT_RELATIONSHIPS (

9437:
9438: IF l_obj_rel_id.COUNT >0 THEN
9439:
9440: FORALL i IN l_obj_rel_id.FIRST..l_obj_rel_id.LAST
9441: insert into PA_OBJECT_RELATIONSHIPS (
9442: object_relationship_id,
9443: object_type_from,
9444: object_id_from1,
9445: object_type_to,

Line 9492: INSERT INTO PA_OBJECT_RELATIONSHIPS (

9488:
9489: CLOSE cur_pa_obj_rela_2;
9490:
9491: /*
9492: INSERT INTO PA_OBJECT_RELATIONSHIPS (
9493: object_relationship_id
9494: ,object_type_from
9495: ,object_id_from1
9496: ,object_type_to

Line 9510: /* pa_object_relationships_s.nextval

9506: ,weighting_percentage
9507: )
9508: /*Added the hint for the bug 3513853*/
9509: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
9510: /* pa_object_relationships_s.nextval
9511: ,pobj.object_type_from
9512: ,ppev1.element_version_id
9513: ,pobj.object_type_to
9514: ,ppev2.element_version_id

Line 9533: FROM pa_object_relationships

9529: relationship_type,
9530: relationship_subtype,
9531: Record_Version_Number,
9532: weighting_percentage
9533: FROM pa_object_relationships
9534: START WITH object_id_from1 = rec_dest_wp_struc_versions.attribute15
9535: AND RELATIONSHIP_TYPE = 'S'
9536: CONNECT BY object_id_from1 = PRIOR object_id_to1
9537: AND RELATIONSHIP_TYPE = 'S' ) pobj,

Line 10668: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE

10664: l_latest_pub_str_ver_id NUMBER;
10665:
10666: /* Code added for 6211012*/
10667:
10668: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
10669: INDEX BY BINARY_INTEGER;
10670: l_obj_rel_id typ_obj_rela_id;
10671:
10672: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

Line 10672: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE

10668: TYPE typ_obj_rela_id is TABLE OF pa_object_relationships.object_relationship_id%TYPE
10669: INDEX BY BINARY_INTEGER;
10670: l_obj_rel_id typ_obj_rela_id;
10671:
10672: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
10673: INDEX BY BINARY_INTEGER;
10674: l_obj_typ_from typ_obj_typ_from;
10675:
10676: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

Line 10676: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE

10672: TYPE typ_obj_typ_from is TABLE OF pa_object_relationships.object_type_from%TYPE
10673: INDEX BY BINARY_INTEGER;
10674: l_obj_typ_from typ_obj_typ_from;
10675:
10676: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
10677: INDEX BY BINARY_INTEGER;
10678: l_obj_from_id typ_obj_from_id;
10679:
10680: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

Line 10680: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE

10676: TYPE typ_obj_from_id is TABLE OF pa_object_relationships.object_id_from1%TYPE
10677: INDEX BY BINARY_INTEGER;
10678: l_obj_from_id typ_obj_from_id;
10679:
10680: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
10681: INDEX BY BINARY_INTEGER;
10682: l_obj_typ_to typ_obj_typ_to;
10683:
10684: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

Line 10684: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE

10680: TYPE typ_obj_typ_to is TABLE OF pa_object_relationships.object_type_to%TYPE
10681: INDEX BY BINARY_INTEGER;
10682: l_obj_typ_to typ_obj_typ_to;
10683:
10684: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
10685: INDEX BY BINARY_INTEGER;
10686: l_obj_to_id typ_obj_to_id;
10687:
10688: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

Line 10688: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE

10684: TYPE typ_obj_to_id is TABLE OF pa_object_relationships.object_id_to1%TYPE
10685: INDEX BY BINARY_INTEGER;
10686: l_obj_to_id typ_obj_to_id;
10687:
10688: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
10689: INDEX BY BINARY_INTEGER;
10690: l_rel_typ typ_rel_typ;
10691:
10692: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

Line 10692: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE

10688: TYPE typ_rel_typ is TABLE OF pa_object_relationships.relationship_type%TYPE
10689: INDEX BY BINARY_INTEGER;
10690: l_rel_typ typ_rel_typ;
10691:
10692: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
10693: INDEX BY BINARY_INTEGER;
10694: l_rel_subtyp typ_rel_subtyp;
10695:
10696: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

Line 10696: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE

10692: TYPE typ_rel_subtyp is TABLE OF pa_object_relationships.relationship_subtype%TYPE
10693: INDEX BY BINARY_INTEGER;
10694: l_rel_subtyp typ_rel_subtyp;
10695:
10696: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
10697: INDEX BY BINARY_INTEGER;
10698: l_rec_ver_num typ_rec_ver_num;
10699:
10700: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

Line 10700: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE

10696: TYPE typ_rec_ver_num is TABLE OF pa_object_relationships.Record_Version_Number%TYPE
10697: INDEX BY BINARY_INTEGER;
10698: l_rec_ver_num typ_rec_ver_num;
10699:
10700: TYPE typ_wt_percent is TABLE OF pa_object_relationships.weighting_percentage%TYPE
10701: INDEX BY BINARY_INTEGER;
10702: l_wt_percent typ_wt_percent;
10703:
10704:

Line 10709: pa_object_relationships_s.nextval,

10705: CURSOR cur_pa_obj_rela_3(c_src_str_version_id NUMBER,
10706: c_struc_version_id NUMBER
10707: ) IS
10708: SELECT /*+ USE_HASH(ppev2 ppev1)*/
10709: pa_object_relationships_s.nextval,
10710: pobj.object_type_from,
10711: ppev1.element_version_id,
10712: pobj.object_type_to,
10713: ppev2.element_version_id,

Line 10722: FROM pa_object_relationships

10718: FROM ( SELECT object_type_from, object_id_from1,
10719: object_type_to, object_id_to1,
10720: relationship_type, relationship_subtype,
10721: Record_Version_Number, weighting_percentage
10722: FROM pa_object_relationships
10723: --bug#3094283WHERE RELATIONSHIP_TYPE = 'S'
10724: start with object_id_from1 = c_src_str_version_id
10725: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 - Added this condition */
10726: connect by object_id_from1 = prior object_id_to1

Line 12400: insert into PA_OBJECT_RELATIONSHIPS (

12396:
12397: IF l_obj_rel_id.COUNT >0 THEN
12398:
12399: FORALL i IN l_obj_rel_id.FIRST..l_obj_rel_id.LAST
12400: insert into PA_OBJECT_RELATIONSHIPS (
12401: object_relationship_id,
12402: object_type_from,
12403: object_id_from1,
12404: object_type_to,

Line 12450: INSERT INTO PA_OBJECT_RELATIONSHIPS (

12446:
12447: CLOSE cur_pa_obj_rela_3;
12448:
12449: /*
12450: INSERT INTO PA_OBJECT_RELATIONSHIPS (
12451: object_relationship_id,
12452: object_type_from,
12453: object_id_from1,
12454: object_type_to,

Line 12468: /* pa_object_relationships_s.nextval,

12464: weighting_percentage
12465: )
12466: /*Added the hint for the bug 3513853*/
12467: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
12468: /* pa_object_relationships_s.nextval,
12469: pobj.object_type_from,
12470: ppev1.element_version_id,
12471: pobj.object_type_to,
12472: ppev2.element_version_id,

Line 12486: FROM pa_object_relationships

12482: FROM ( SELECT object_type_from, object_id_from1,
12483: object_type_to, object_id_to1,
12484: relationship_type, relationship_subtype,
12485: Record_Version_Number, weighting_percentage
12486: FROM pa_object_relationships
12487: --bug#3094283WHERE RELATIONSHIP_TYPE = 'S'
12488: start with object_id_from1 = l_dest_str_versions_tbl(k).src_str_version_id
12489: and RELATIONSHIP_TYPE = 'S' /* Bug 2881667 Added this condition */
12490: /* connect by object_id_from1 = prior object_id_to1

Line 13364: FROM pa_object_relationships

13360: SELECT object_id_from1 -- parent task id
13361: ,object_relationship_id, -- relationship id reqd for update relationship API
13362: record_version_number,
13363: weighting_percentage -- Bug 3075609. We need to get hold of the weightage of the task in db.
13364: FROM pa_object_relationships
13365: WHERE object_id_to1 = c_task_version_id
13366: AND relationship_type = 'S';
13367:
13368: -- Added for DFF attributes for calling update_schedule_version

Line 13424: TYPE weighting_percentage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE

13420: TYPE wbs_number_tbl IS TABLE OF pa_proj_element_versions.wbs_number%TYPE
13421: INDEX BY BINARY_INTEGER;
13422: TYPE child_count_tbl IS TABLE OF NUMBER
13423: INDEX BY BINARY_INTEGER;
13424: TYPE weighting_percentage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE
13425: INDEX BY BINARY_INTEGER;
13426: TYPE task_version_id_tbl IS TABLE OF pa_proj_element_versions.element_version_id%TYPE
13427: INDEX BY BINARY_INTEGER;
13428:

Line 13469: l_relationship_id pa_object_relationships.object_relationship_id%TYPE;

13465:
13466: -- version level variables required only for update task case.
13467: l_proj_elem_ver_rvn pa_proj_element_versions.record_version_number%TYPE; -- record version number of proj element table
13468: l_proj_elem_ver_rowid VARCHAR2(255); -- rowid of the task being updated.
13469: l_relationship_id pa_object_relationships.object_relationship_id%TYPE;
13470: l_obj_rel_rvn NUMBER;
13471:
13472: -- flexfield attributes used for updating/creating element version and schedule versions table.
13473: l_attribute_category PA_PROJ_ELEMENT_VERSIONS.attribute_category%TYPE;

Line 14615: l_relationship_id_tmp pa_object_relationships.object_relationship_id%TYPE;

14611:
14612: l_task_ver_id_tmp pa_proj_element_versions.element_version_id%TYPE;
14613: l_dummy_number NUMBER;
14614: l_db_parent_task_ver_id_tmp pa_proj_element_versions.element_version_id%TYPE;
14615: l_relationship_id_tmp pa_object_relationships.object_relationship_id%TYPE;
14616:
14617: BEGIN
14618:
14619: OPEN cur_pa_task_ver( l_structure_version_id, l_task_in_rec.pa_task_id );

Line 15159: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt

15155: -- This cursor identified the number of progressible tasks under a parent.
15156: CURSOR get_child_count(c_parent_element_version_id NUMBER)
15157: IS
15158: SELECT count(rel.object_id_to1)
15159: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
15160: WHERE rel.object_id_from1 = c_parent_element_version_id
15161: AND rel.object_type_to = 'PA_TASKS'
15162: AND rel.relationship_type = 'S'
15163: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 15605: l_db_task_weightage pa_object_relationships.weighting_percentage%TYPE;

15601: l_db_parent_task_version_id pa_proj_element_versions.element_version_id%TYPE;
15602: l_parent_task_version_id pa_proj_element_versions.element_version_id%TYPE;
15603:
15604: -- Bug 3075609. This will hold the weightage of the task version currently in database.
15605: l_db_task_weightage pa_object_relationships.weighting_percentage%TYPE;
15606: BEGIN
15607: IF (l_parent_task_id IS NOT null)
15608: THEN
15609: l_parent_task_version_id := l_task_version_id_tbl(l_parent_task_id);

Line 15900: l_relationship_subtype pa_object_relationships.relationship_subtype%TYPE;

15896:
15897: DECLARE
15898: l_structure_version_id_from pa_proj_element_versions.element_version_id%TYPE;
15899: l_task_version_id_from pa_proj_element_versions.element_version_id%TYPE;
15900: l_relationship_subtype pa_object_relationships.relationship_subtype%TYPE;
15901:
15902: BEGIN
15903:
15904: -- Set the following local variables before calling PA_RELATIONSHIP_PUB.Create_Relationship

Line 16534: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt

16530: -- reassign the task weightages for the affected peer tasks.
16531: CURSOR cur_get_child_info(c_parent_element_version_id NUMBER)
16532: IS
16533: SELECT rel.OBJECT_RELATIONSHIP_ID,tt.prog_entry_enable_flag
16534: FROM PA_OBJECT_RELATIONSHIPS rel, pa_proj_element_versions pev, pa_proj_elements pe, pa_task_types tt
16535: WHERE rel.object_id_from1 = c_parent_element_version_id
16536: AND rel.object_type_to = 'PA_TASKS'
16537: AND rel.relationship_type = 'S'
16538: AND rel.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

Line 16544: TYPE obj_rel_id_tbl is table of pa_object_relationships.object_relationship_id%TYPE

16540: AND pev.proj_element_id = pe.proj_element_id
16541: AND tt.object_type = 'PA_TASKS' /* bug 3279978 FP M Enhancement */
16542: AND pe.type_id = tt.task_type_id;
16543:
16544: TYPE obj_rel_id_tbl is table of pa_object_relationships.object_relationship_id%TYPE
16545: INDEX BY BINARY_INTEGER;
16546:
16547: l_parent_version_id pa_proj_element_versions.element_version_id%TYPE;
16548: l_prog_entry_enable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;

Line 16581: UPDATE pa_object_relationships

16577: END IF;
16578: END LOOP;
16579: -- update back the records.
16580: FORALL i in l_obj_rel_id_tbl.first..l_obj_rel_id_tbl.last
16581: UPDATE pa_object_relationships
16582: set weighting_percentage = l_task_weightage_tbl(i)
16583: where object_relationship_id = l_obj_rel_id_tbl(i);
16584: END IF;
16585: EXIT WHEN nvl(l_obj_rel_id_tbl.last,0) < l_plsql_max_array_size;

Line 20359: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE

20355: (
20356: summed_effort pa_proj_elem_ver_schedule.planned_effort%TYPE
20357: ,summed_duration pa_proj_elem_ver_schedule.duration%TYPE
20358: ,child_count Number
20359: ,cum_alloted_weightage pa_object_relationships.weighting_percentage%TYPE
20360: ,processed_child_count Number
20361: -- Following added for bug 3053472
20362: ,loop_count Number
20363: ,residual_task_count Number

Line 20373: TYPE object_rel_id_tbl IS TABLE OF pa_object_relationships.object_relationship_id%TYPE

20369:
20370: TYPE prog_enable_flag_tbl IS TABLE OF pa_task_types.prog_entry_enable_flag%TYPE
20371: INDEX BY BINARY_INTEGER;
20372:
20373: TYPE object_rel_id_tbl IS TABLE OF pa_object_relationships.object_relationship_id%TYPE
20374: INDEX BY BINARY_INTEGER;
20375:
20376: TYPE parent_task_ver_id_tbl IS TABLE OF pa_object_relationships.object_id_from1%TYPE --pa_proj_element_versions.element_version_id%TYPE 3746912
20377: INDEX BY BINARY_INTEGER;

Line 20376: TYPE parent_task_ver_id_tbl IS TABLE OF pa_object_relationships.object_id_from1%TYPE --pa_proj_element_versions.element_version_id%TYPE 3746912

20372:
20373: TYPE object_rel_id_tbl IS TABLE OF pa_object_relationships.object_relationship_id%TYPE
20374: INDEX BY BINARY_INTEGER;
20375:
20376: TYPE parent_task_ver_id_tbl IS TABLE OF pa_object_relationships.object_id_from1%TYPE --pa_proj_element_versions.element_version_id%TYPE 3746912
20377: INDEX BY BINARY_INTEGER;
20378:
20379: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
20380: INDEX BY BINARY_INTEGER;

Line 20385: TYPE task_weightage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE

20381:
20382: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
20383: INDEX BY BINARY_INTEGER;
20384:
20385: TYPE task_weightage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE
20386: INDEX BY BINARY_INTEGER;
20387: -- End of Type Declarations.
20388:
20389:

Line 20406: pa_object_relationships rel,

20402: NVL(pxpv.labor_effort,0) + NVL(pxpv.equipment_effort,0),
20403: sch.duration,
20404: ptt.prog_entry_enable_flag
20405: from pa_proj_element_versions ver,
20406: pa_object_relationships rel,
20407: pa_proj_elem_ver_schedule sch,
20408: pa_proj_elements ele,
20409: pa_task_types ptt,
20410: pji_xbs_plans_v pxpv

Line 20693: l_task_weightage pa_object_relationships.weighting_percentage%TYPE;

20689: DECLARE
20690: l_task_weightage_tbl task_weightage_tbl;
20691:
20692: l_parent_id pa_proj_element_versions.element_version_id%TYPE;
20693: l_task_weightage pa_object_relationships.weighting_percentage%TYPE;
20694:
20695: --Bug 3053472 - remaining weightage is no more required.
20696: --l_remaining_weightage pa_object_relationships.weighting_percentage%TYPE;
20697:

Line 20696: --l_remaining_weightage pa_object_relationships.weighting_percentage%TYPE;

20692: l_parent_id pa_proj_element_versions.element_version_id%TYPE;
20693: l_task_weightage pa_object_relationships.weighting_percentage%TYPE;
20694:
20695: --Bug 3053472 - remaining weightage is no more required.
20696: --l_remaining_weightage pa_object_relationships.weighting_percentage%TYPE;
20697:
20698: l_residual_weightage pa_object_relationships.weighting_percentage%TYPE;
20699: BEGIN
20700: IF nvl(l_object_rel_id_tbl.last,0) > 0 THEN

Line 20698: l_residual_weightage pa_object_relationships.weighting_percentage%TYPE;

20694:
20695: --Bug 3053472 - remaining weightage is no more required.
20696: --l_remaining_weightage pa_object_relationships.weighting_percentage%TYPE;
20697:
20698: l_residual_weightage pa_object_relationships.weighting_percentage%TYPE;
20699: BEGIN
20700: IF nvl(l_object_rel_id_tbl.last,0) > 0 THEN
20701: FOR i in l_object_rel_id_tbl.first..l_object_rel_id_tbl.last LOOP
20702: l_parent_id := l_parent_task_ver_id_tbl(i);

Line 20790: -- Do a bulk update into pa_object_relationships table as the weightage has

20786: END IF;
20787: END IF;
20788: END LOOP;
20789:
20790: -- Do a bulk update into pa_object_relationships table as the weightage has
20791: -- been calculated for all the tasks.
20792: FORALL i in l_object_rel_id_tbl.first..l_object_rel_id_tbl.last
20793: UPDATE pa_object_relationships
20794: SET weighting_percentage = l_task_weightage_tbl(i)

Line 20793: UPDATE pa_object_relationships

20789:
20790: -- Do a bulk update into pa_object_relationships table as the weightage has
20791: -- been calculated for all the tasks.
20792: FORALL i in l_object_rel_id_tbl.first..l_object_rel_id_tbl.last
20793: UPDATE pa_object_relationships
20794: SET weighting_percentage = l_task_weightage_tbl(i)
20795: WHERE object_relationship_id = l_object_rel_id_tbl(i);
20796: IF l_debug_mode = 'Y' THEN
20797: pa_debug.g_err_stage:= 'Updated ' || sql%rowcount || ' Records in PA_OBJECT_RELATIONSHIPS';

Line 20797: pa_debug.g_err_stage:= 'Updated ' || sql%rowcount || ' Records in PA_OBJECT_RELATIONSHIPS';

20793: UPDATE pa_object_relationships
20794: SET weighting_percentage = l_task_weightage_tbl(i)
20795: WHERE object_relationship_id = l_object_rel_id_tbl(i);
20796: IF l_debug_mode = 'Y' THEN
20797: pa_debug.g_err_stage:= 'Updated ' || sql%rowcount || ' Records in PA_OBJECT_RELATIONSHIPS';
20798: pa_debug.write(G_PKG_NAME,pa_debug.g_err_stage,l_debug_level3);
20799: END IF;
20800: END IF;
20801: END;

Line 21720: PA_Object_Relationships POR,

21716: decode(sign(NVL(POR.Lag_Day,0)),
21717: '0', '', '-1', '', '+') || decode(POR.Lag_Day,0, NULL, POR.Lag_day)/(10*8*60) LagDays --bug 4348156
21718: From PA_Proj_Elements PPE,
21719: PA_Proj_Element_Versions PEV,
21720: PA_Object_Relationships POR,
21721: PA_PROJ_ELEMENT_VERSIONS PEV2
21722: Where PPE.project_id = PEV.project_id
21723: and PPE.proj_element_id = PEV.proj_element_id
21724: and PEV.element_version_id = POR.object_id_to1

Line 21750: PA_Object_Relationships POR,

21746: decode(sign(NVL(POR.Lag_Day,0)),
21747: '0', '', '-1', '', '+') || decode(POR.Lag_Day,0, NULL, POR.Lag_day)/(10*8*60) LagDays --bug 4348156
21748: From PA_Proj_Elements PPE,
21749: PA_Proj_Element_Versions PEV,
21750: PA_Object_Relationships POR,
21751: PA_PROJ_ELEMENT_VERSIONS PEV2
21752: Where PPE.project_id = PEV.project_id
21753: and PPE.proj_element_id = PEV.proj_element_id
21754: and PEV.element_version_id = POR.object_id_to1

Line 21819: DELETE FROM pa_object_relationships por1

21815: raise;
21816: END;
21817: IF l_object_type='PA_TASKS' THEN
21818: BEGIN
21819: DELETE FROM pa_object_relationships por1
21820: WHERE por1.object_relationship_id IN
21821: (SELECT por.object_relationship_id
21822: FROM pa_object_relationships por
21823: WHERE por.relationship_type = 'D'

Line 21822: FROM pa_object_relationships por

21818: BEGIN
21819: DELETE FROM pa_object_relationships por1
21820: WHERE por1.object_relationship_id IN
21821: (SELECT por.object_relationship_id
21822: FROM pa_object_relationships por
21823: WHERE por.relationship_type = 'D'
21824: AND por.object_id_from1 = p_element_version_id
21825: AND por.object_id_from2 = por.object_id_to2
21826: AND por.object_type_from = 'PA_TASKS'

Line 21839: DELETE FROM pa_object_relationships por1

21835: raise;
21836: END;
21837: ELSIF l_object_type='PA_STRUCTURES' THEN
21838: BEGIN
21839: DELETE FROM pa_object_relationships por1
21840: WHERE por1.object_relationship_id IN
21841: (SELECT por.object_relationship_id
21842: FROM pa_proj_element_versions ppev,
21843: pa_object_relationships por

Line 21843: pa_object_relationships por

21839: DELETE FROM pa_object_relationships por1
21840: WHERE por1.object_relationship_id IN
21841: (SELECT por.object_relationship_id
21842: FROM pa_proj_element_versions ppev,
21843: pa_object_relationships por
21844: WHERE relationship_type ='D'
21845: AND ppev.parent_structure_version_id = p_element_version_id
21846: AND ppev.object_type = 'PA_TASKS'
21847: AND por.object_id_from2 = por.object_id_to2