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_FP_ELEMENTS_PUB dependencies on PA_TASKS

Line 724: pa_tasks source_pt,

720: ,sysdate
721: ,fnd_global.user_id
722: ,fnd_global.login_id
723: FROM pa_fp_elements fp,
724: pa_tasks source_pt,
725: pa_tasks target_pt
726: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id
727: AND fp.task_id = source_pt.task_id
728: AND source_pt.task_number = target_pt.task_number

Line 725: pa_tasks target_pt

721: ,fnd_global.user_id
722: ,fnd_global.login_id
723: FROM pa_fp_elements fp,
724: pa_tasks source_pt,
725: pa_tasks target_pt
726: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id
727: AND fp.task_id = source_pt.task_id
728: AND source_pt.task_number = target_pt.task_number
729: AND target_pt.project_id = l_to_project_id

Line 959: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;

955: l_prev_txn_id NUMBER := NULL;
956: l_counter NUMBER; /* Used by plsql tables during their population */
957:
958: TYPE l_task_id_tbl_typ IS TABLE OF
959: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
960: TYPE l_top_task_id_tbl_typ IS TABLE OF
961: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
962: TYPE l_top_plan_level_tbl_typ IS TABLE OF
963: PA_FP_ELEMENTS.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;

Line 961: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;

957:
958: TYPE l_task_id_tbl_typ IS TABLE OF
959: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
960: TYPE l_top_task_id_tbl_typ IS TABLE OF
961: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
962: TYPE l_top_plan_level_tbl_typ IS TABLE OF
963: PA_FP_ELEMENTS.TOP_TASK_PLANNING_LEVEL%TYPE INDEX BY BINARY_INTEGER;
964: TYPE l_plannable_flag_tbl_typ IS TABLE OF
965: PA_FP_ELEMENTS.PLANNABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 987: FROM pa_tasks t1

983: SELECT task_id task_id
984: ,top_task_id top_task_id
985: ,l_task_planning_level_low top_task_planning_level
986: ,'N' plannable_flag
987: FROM pa_tasks t1
988: WHERE project_id = p_project_id
989: AND task_id = top_task_id
990: AND exists (SELECT 'x'
991: FROM pa_tasks t2

Line 991: FROM pa_tasks t2

987: FROM pa_tasks t1
988: WHERE project_id = p_project_id
989: AND task_id = top_task_id
990: AND exists (SELECT 'x'
991: FROM pa_tasks t2
992: WHERE t2.parent_task_id = t1.task_id)
993: UNION ALL -- bug 3106741 UNION
994: SELECT task_id task_id
995: ,top_task_id top_task_id

Line 998: FROM pa_tasks t1

994: SELECT task_id task_id
995: ,top_task_id top_task_id
996: ,decode(task_id,top_task_id,l_task_planning_level_low,null) top_task_planning_level
997: ,'Y' plannable_flag
998: FROM pa_tasks t1
999: WHERE project_id = p_project_id
1000: AND not exists (SELECT 'x'
1001: FROM pa_tasks t2
1002: WHERE t2.parent_task_id = t1.task_id);

Line 1001: FROM pa_tasks t2

997: ,'Y' plannable_flag
998: FROM pa_tasks t1
999: WHERE project_id = p_project_id
1000: AND not exists (SELECT 'x'
1001: FROM pa_tasks t2
1002: WHERE t2.parent_task_id = t1.task_id);
1003: -- AND task_id <> top_task_id
1004: /* ORDER BY task_id; Bug 3106741 */
1005:

Line 1012: FROM pa_tasks

1008: SELECT task_id task_id
1009: ,top_task_id top_task_id
1010: ,l_task_planning_level_top top_task_planning_level
1011: ,'Y' plannable_flag
1012: FROM pa_tasks
1013: WHERE project_id = p_project_id
1014: AND task_id = top_task_id;
1015:
1016: BEGIN

Line 1597: l_top_task_id pa_tasks.task_id%TYPE;

1593: l_resource_exists_flag VARCHAR2(1);
1594: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
1595:
1596: --Bug 2774779
1597: l_top_task_id pa_tasks.task_id%TYPE;
1598: l_row_update_count NUMBER;
1599:
1600: BEGIN
1601:

Line 2077: ,p_task_id IN pa_tasks.task_id%TYPE /* Bug 2920954 */

2073: ============================================================================*/
2074:
2075: PROCEDURE create_enterable_resources
2076: ( p_plan_version_id IN NUMBER
2077: ,p_task_id IN pa_tasks.task_id%TYPE /* Bug 2920954 */
2078: ,p_res_del_req_flag IN VARCHAR2 /* Bug 2920954 */
2079: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2080: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2081: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2600: ,p_task_id IN pa_tasks.task_id%TYPE

2596: ==================================================================================================*/
2597: FUNCTION get_element_id (
2598: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2599: ,p_element_type IN pa_fp_elements.element_type%TYPE
2600: ,p_task_id IN pa_tasks.task_id%TYPE
2601: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2602: RETURN pa_fp_elements.proj_fp_elements_id%TYPE
2603: IS
2604:

Line 2633: ,p_task_id IN pa_tasks.task_id%TYPE

2629: ==================================================================================================*/
2630: FUNCTION get_element_plannable_flag (
2631: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2632: ,p_element_type IN pa_fp_elements.element_type%TYPE
2633: ,p_task_id IN pa_tasks.task_id%TYPE
2634: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2635: RETURN pa_fp_elements.plannable_flag%TYPE
2636: IS
2637:

Line 2666: ,p_task_id IN pa_tasks.task_id%TYPE

2662: ==================================================================================================*/
2663: FUNCTION get_plan_amount_exists_flag (
2664: p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
2665: ,p_element_type IN pa_fp_elements.element_type%TYPE
2666: ,p_task_id IN pa_tasks.task_id%TYPE
2667: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)
2668: RETURN pa_fp_elements.plan_amount_exists_flag%TYPE
2669: IS
2670:

Line 2788: l_prev_task_id pa_tasks.task_id%TYPE;

2784: VARCHAR2(30) INDEX BY BINARY_INTEGER;
2785:
2786: l_resource_level_tbl l_resource_level_tbl_typ;
2787: l_prev_res_level VARCHAR2(30);
2788: l_prev_task_id pa_tasks.task_id%TYPE;
2789:
2790: -- The following exception would be raised if the budget version
2791: -- has mixed resource planning level
2792:

Line 2850: ,pa_tasks pt

2846: ,NULL resources_planned_for_task
2847: ,'Y' plan_amount_exists_flag
2848: ,DECODE(prlm.parent_member_id, NULL, 'G','R') resource_level -- Bug :- 2625872
2849: FROM pa_resource_assignments pra
2850: ,pa_tasks pt
2851: ,pa_resource_list_members prlm
2852: WHERE budget_version_id = c_from_version_id
2853: AND pt.task_id = pra.task_id
2854: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =

Line 2918: ,pa_tasks pt

2914: ,'Y' plannable_flag
2915: ,DECODE(l_uncategorized_flag,'Y',NULL,'Y') resources_planned_for_task
2916: ,'Y' plan_amount_exists_flag
2917: FROM pa_resource_assignments pra
2918: ,pa_tasks pt
2919: ,pa_resource_list_members prlm
2920: WHERE budget_version_id = c_from_version_id
2921: AND pt.task_id = pra.task_id
2922: AND prlm.resource_list_member_id = pra.resource_list_member_id

Line 2946: ,pa_tasks pt

2942: ,'N' plannable_flag
2943: ,NULL resources_planned_for_task
2944: ,'Y' plan_amount_exists_flag
2945: FROM pa_fp_elements pfe
2946: ,pa_tasks pt
2947: WHERE pfe.proj_fp_options_id = c_proj_fp_options_id
2948: AND pfe.element_type = p_element_type
2949: AND pt.task_id = pfe.task_id
2950: AND pt.top_task_id <> pfe.task_id

Line 4176: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS

4172: /* The existing cursors were replaced by the following cursors to get the resource assignments
4173: * for the impacted task, or its childrens or its parent's childrens as the case may be
4174: */
4175:
4176: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
4177: SELECT parent_task_id,
4178: top_task_id
4179: FROM pa_tasks
4180: WHERE task_id = c_impacted_task_id;

Line 4179: FROM pa_tasks

4175:
4176: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
4177: SELECT parent_task_id,
4178: top_task_id
4179: FROM pa_tasks
4180: WHERE task_id = c_impacted_task_id;
4181:
4182: impacted_task_rec impacted_task_cur%ROWTYPE;
4183:

Line 4197: CURSOR cur_elements_for_task (c_task_id pa_tasks.task_id%TYPE) IS

4193: pra.resource_list_member_id -- Bug 3615617
4194: FROM pa_resource_assignments pra
4195: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id;
4196:
4197: CURSOR cur_elements_for_task (c_task_id pa_tasks.task_id%TYPE) IS
4198: SELECT pra.resource_assignment_id,
4199: pra.wbs_element_version_id, -- This column is selected so that it can be passed, to create_res_task_maps. One for source and one for target.
4200: pra.wbs_element_version_id, -- This would be null for budgets and forecasts!
4201: pra.project_assignment_id, -- This would be -1 for Budgets and Forecasts

Line 4210: FROM pa_tasks t

4206: pra.resource_list_member_id -- Bug 3615617
4207: FROM pa_resource_assignments pra
4208: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
4209: AND pra.task_id IN (SELECT t.task_id
4210: FROM pa_tasks t
4211: WHERE t.project_id = p_project_id
4212: CONNECT BY PRIOR t.task_id = t.parent_task_id
4213: START WITH t.task_id = c_task_id);
4214:

Line 5043: ( p_task_id IN pa_tasks.task_id%TYPE

5039:
5040: Bug 2976168. Delete from pa_fp_excluded_elements */
5041:
5042: PROCEDURE Delete_task_elements
5043: ( p_task_id IN pa_tasks.task_id%TYPE
5044: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5045: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5046: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
5047:

Line 5098: FROM pa_tasks t

5094: END IF;
5095:
5096: DELETE FROM pa_resource_assignments r
5097: WHERE r.task_id IN (SELECT t.task_id
5098: FROM pa_tasks t
5099: CONNECT BY PRIOR t.task_id = t.parent_task_id
5100: START WITH t.task_id = p_task_id);
5101:
5102: l_records_deleted := sql%rowcount;

Line 5218: ( c_task_id pa_tasks.task_id%TYPE

5214: task_element_info_rec task_element_info_cur%ROWTYPE;
5215:
5216: --This cursor is used to know whether a task is explicitly made unplannable
5217: CURSOR excluded_task_cur
5218: ( c_task_id pa_tasks.task_id%TYPE
5219: ,c_top_task_id pa_tasks.task_id%TYPE)
5220: IS
5221: SELECT 'Y'
5222: FROM pa_fp_excluded_elements pfe

Line 5219: ,c_top_task_id pa_tasks.task_id%TYPE)

5215:
5216: --This cursor is used to know whether a task is explicitly made unplannable
5217: CURSOR excluded_task_cur
5218: ( c_task_id pa_tasks.task_id%TYPE
5219: ,c_top_task_id pa_tasks.task_id%TYPE)
5220: IS
5221: SELECT 'Y'
5222: FROM pa_fp_excluded_elements pfe
5223: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id

Line 5627: FROM pa_tasks t

5623:
5624: CURSOR ci_impacted_tasks_cur
5625: (c_project_id NUMBER, c_impacted_task_id NUMBER) IS
5626: SELECT task_id
5627: FROM pa_tasks t
5628: WHERE t.project_id = c_project_id
5629: START WITH t.task_id = c_impacted_task_id
5630: CONNECT BY prior t.task_id = t.parent_task_id;
5631:

Line 6482: CURSOR task_info_cur(c_task_id pa_tasks.task_id%TYPE) IS

6478:
6479: --If the task is not a top task , this cursor always returns L as the task level as all the middle
6480: --level would have been eliminated by the time this cursor is opened.
6481:
6482: CURSOR task_info_cur(c_task_id pa_tasks.task_id%TYPE) IS
6483: SELECT pt.top_task_id top_task_id
6484: ,pt.parent_task_id parent_task_id
6485: ,DECODE(c_task_id,
6486: pt.top_task_id,L_TASK_LEVEL_TOP,

Line 6488: FROM pa_tasks pt

6484: ,pt.parent_task_id parent_task_id
6485: ,DECODE(c_task_id,
6486: pt.top_task_id,L_TASK_LEVEL_TOP,
6487: L_TASK_LEVEL_LOWEST) task_level
6488: FROM pa_tasks pt
6489: WHERE pt.task_id = c_task_id;
6490:
6491: task_info_rec task_info_cur%ROWTYPE;
6492:

Line 6498: FUNCTION is_middle_level_task(p_task_id pa_tasks.task_id%TYPE,

6494:
6495: /****** This is a LOCAL function to the bulk api which checks if a task is middle level task
6496: ****** by checking l_middle_task_tbl and then the db. */
6497:
6498: FUNCTION is_middle_level_task(p_task_id pa_tasks.task_id%TYPE,
6499: p_top_task_id pa_tasks.task_id%TYPE)
6500: RETURN VARCHAR2 IS
6501:
6502: /* Indicates if child tasks exists for a particular task.

Line 6499: p_top_task_id pa_tasks.task_id%TYPE)

6495: /****** This is a LOCAL function to the bulk api which checks if a task is middle level task
6496: ****** by checking l_middle_task_tbl and then the db. */
6497:
6498: FUNCTION is_middle_level_task(p_task_id pa_tasks.task_id%TYPE,
6499: p_top_task_id pa_tasks.task_id%TYPE)
6500: RETURN VARCHAR2 IS
6501:
6502: /* Indicates if child tasks exists for a particular task.
6503: 0 - Child task does NOT exists

Line 7060: FROM pa_tasks

7056: cursor c1 is
7057: select 'N'
7058: from sys.dual
7059: where exists (SELECT null
7060: FROM pa_tasks
7061: where parent_task_id = p_impacted_tasks_tbl(i).old_parent_task_id
7062: and task_id <> p_impacted_tasks_tbl(i).impacted_task_id);
7063: BEGIN
7064: OPEN c1;