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_RESOURCE_LIST_MEMBERS

Line 1586: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;

1582: l_return_status VARCHAR2(2000);
1583: l_debug_mode VARCHAR2(30);
1584:
1585: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
1586: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
1587: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
1588: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
1589: l_err_code NUMBER;
1590: l_err_stage VARCHAR2(100);

Line 1587: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;

1583: l_debug_mode VARCHAR2(30);
1584:
1585: l_uncat_res_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
1586: l_uncat_res_list_mem_id pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE;
1587: l_uncat_res_id pa_resource_list_members.RESOURCE_ID%TYPE;
1588: l_uncat_track_as_labor_flg pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE;
1589: l_err_code NUMBER;
1590: l_err_stage VARCHAR2(100);
1591: l_err_stack VARCHAR2(1000);

Line 2066: table join with pa_resource_list_members.It also deals the case when

2062: /*============================================================================
2063: This api makes use of PA_FP_ELEMENTS and enters only user_entered records
2064: if they aren't already present in PA_RESOURCE_ASSIGNMENTS. Uncategorised
2065: resource_list has been dealt separately, as in this case, we can avoid a
2066: table join with pa_resource_list_members.It also deals the case when
2067: planning level is project and resource_list is uncategorised, in which
2068: case the given version doesn't have a record in PA_FP_ELEMENTS.
2069:
2070: Bug 2920954 - To create ras for a particular task and control deletion

Line 2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;

2097: l_fp_pref_code PA_PROJ_FP_OPTIONS.FIN_PLAN_PREFERENCE_CODE%TYPE;
2098: l_fp_level_code PA_PROJ_FP_OPTIONS.COST_FIN_PLAN_LEVEL_CODE%TYPE;
2099: l_proj_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
2100: l_uncat_rlmid PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE;
2101: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
2102: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
2103:
2104: TYPE l_ra_id_tbl_typ IS TABLE OF
2105: PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2150: FROM pa_fp_elements fp, pa_resource_list_members prlm, pa_resources pr

2146: ,prlm.track_as_labor_flag
2147: ,decode(prlm.track_as_labor_flag,'Y',PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,
2148: 'N',decode(pr.unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,NULL,pr.unit_of_measure)
2149: ) unit_of_measure /* Modified for bug #2586307 */
2150: FROM pa_fp_elements fp, pa_resource_list_members prlm, pa_resources pr
2151: WHERE proj_fp_options_id = l_proj_fp_options_id /* included for bug 3062798*/
2152: AND fin_plan_version_id = p_plan_version_id
2153: AND fp.resource_list_member_id <> 0 -- select only resource level records
2154: AND fp.plannable_flag = 'Y' --resource is plannable

Line 2247: * pa_resource_list_members table if it is 'Y'

2243: WHERE resource_list_id = l_resource_list_id;
2244:
2245:
2246: /* Checking uncategorised flag to avoid a join with
2247: * pa_resource_list_members table if it is 'Y'
2248: */
2249:
2250: IF l_uncat_flag = 'Y' THEN
2251:

Line 2601: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)

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:
2605: l_proj_fp_elements_id pa_fp_elements.proj_fp_elements_id%TYPE := -99;

Line 2634: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)

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:
2638: l_plannable_flag pa_fp_elements.plannable_flag%TYPE := 'N';

Line 2667: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE)

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:
2671: l_plan_amount_exists_flag pa_fp_elements.plan_amount_exists_flag%TYPE := 'N';

Line 2696: p_parent_member_id IN pa_resource_list_members.parent_member_id%TYPE

2692: /*=======================================================================
2693: The following function returns resource_planning_level based upon the i/ps.
2694: ========================================================================*/
2695: FUNCTION get_resource_planning_level(
2696: p_parent_member_id IN pa_resource_list_members.parent_member_id%TYPE
2697: ,p_uncategorized_flag IN pa_resource_lists.uncategorized_flag%TYPE
2698: ,p_grouped_flag IN VARCHAR2)
2699: RETURN pa_fp_elements.resource_planning_level%TYPE IS
2700:

Line 2824: ,pa_resource_list_members prlm

2820: ,NULL resources_planned_for_task
2821: ,'Y' plan_amount_exists_flag
2822: ,DECODE(prlm.parent_member_id, NULL, 'G','R') resource_level -- Bug :- 2625872
2823: FROM pa_resource_assignments pra
2824: ,pa_resource_list_members prlm
2825: WHERE budget_version_id = c_from_version_id
2826: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2827: PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2828: AND prlm.resource_list_member_id = pra.resource_list_member_id

Line 2851: ,pa_resource_list_members prlm

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) =
2855: PA_FP_CONSTANTS_PKG.G_USER_ENTERED

Line 2919: ,pa_resource_list_members prlm

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
2923: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) = PA_FP_CONSTANTS_PKG.G_USER_ENTERED

Line 4611: FROM pa_resource_list_members

4607: CURSOR ungrouped_res_cur
4608: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4609: IS
4610: SELECT resource_list_member_id
4611: FROM pa_resource_list_members
4612: WHERE resource_list_id = c_resource_list_id
4613: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4614: AND enabled_flag='Y' -- bug 3289243
4615: AND display_flag='Y'; -- bug 3289243

Line 4627: FROM pa_resource_list_members

4623: CURSOR grouped_res_level_res_cur
4624: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4625: IS
4626: SELECT resource_list_member_id
4627: FROM pa_resource_list_members
4628: WHERE resource_list_id = c_resource_list_id
4629: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4630: AND enabled_flag='Y' -- bug 3289243
4631: AND display_flag='Y' -- bug 3289243

Line 4644: FROM pa_resource_list_members

4640: CURSOR grouped_resgrp_level_res_cur
4641: ( c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
4642: IS
4643: SELECT resource_list_member_id
4644: FROM pa_resource_list_members
4645: WHERE resource_list_id = c_resource_list_id
4646: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4647: AND enabled_flag='Y' -- bug 3289243
4648: AND display_flag='Y' -- bug 3289243