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_CREATE_RESOURCE dependencies on PA_GET_RESOURCE

Line 122: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))

118: SELECT
119: REVENUE_CATEGORY_CODE
120: ,REVENUE_CATEGORY_M description
121: FROM PA_REVENUE_CATEGORIES_V RC
122: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
123: ) tmp
124: WHERE
125: tmp.revenue_category_code = p_resource_group;
126:

Line 311: PA_GET_RESOURCE.Get_Resource

307:
308: -- Check whether the resource_group has already been created as
309: -- a resource in PA_RESOURCE table and get the resource_id.
310:
311: PA_GET_RESOURCE.Get_Resource
312: (p_resource_name => l_resource_name,
313: p_resource_type_Code => l_resource_type_code,
314: p_person_id => NULL,
315: p_job_id => NULL,

Line 336: PA_GET_RESOURCE.Get_Resource_Information

332: RETURN;
333: END IF;
334:
335: /* For bug # 818076 fix moved this code outside the if condition */
336: PA_GET_RESOURCE.Get_Resource_Information
337: (p_resource_type_Code => l_resource_type_code,
338: p_resource_attr_value => p_resource_group,
339: p_unit_of_measure => l_uom,
340: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 365: PA_GET_RESOURCE.Get_Resource_Information

361: as track_as_labor flag should be assigned for resource_groups
362: being inserted into resource_member_list table */
363: /* Comment starts ********************
364:
365: PA_GET_RESOURCE.Get_Resource_Information
366: (p_resource_type_Code => l_resource_type_code,
367: p_resource_attr_value => p_resource_group,
368: p_unit_of_measure => l_uom,
369: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 621: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource

617: WHERE job_group_id = p_job_group_id
618: AND ROWNUM = 1;
619:
620: -- Following block of code is added for the resolution of bug 1889671
621: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource
622: -- Start of change
623:
624: CURSOR Cur_Unclassified_Resource_List IS
625: SELECT prt.resource_type_id,prt.resource_type_code

Line 843: PA_GET_RESOURCE.Get_Unclassified_Resource

839: /* commented for bug 6079140 END IF; -- Adding to TL */
840:
841: IF p_migration_code IS NULL THEN -- Added by RM
842: -- Need to create one Unclassified Resource for the resource list
843: PA_GET_RESOURCE.Get_Unclassified_Resource
844: (p_resource_id => l_resource_id,
845: p_resource_name => l_resource_name,
846: p_track_as_labor_flag => l_track_as_labor_flag,
847: p_unit_of_measure => l_uom,

Line 1724: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))

1720: SELECT
1721: REVENUE_CATEGORY_CODE
1722: ,REVENUE_CATEGORY_M description
1723: FROM PA_REVENUE_CATEGORIES_V RC
1724: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
1725: ) tmp
1726: WHERE
1727: tmp.revenue_category_code = l_revenue_category_code;
1728:

Line 1861: PA_GET_RESOURCE.Get_Resource_list_member

1857: -- since the resource list is not grouped,need only to return
1858: -- the resource_list_member_id of the input resource.Hence,first
1859: -- call Get_Resource_list_member to get the resource list member id.
1860:
1861: PA_GET_RESOURCE.Get_Resource_list_member
1862: (p_resource_list_id => p_resource_list_id,
1863: p_resource_name => p_resource_name,
1864: p_resource_type_Code => p_resource_type_code,
1865: p_group_resource_type_id => l_grouped_resource_type_id,

Line 1980: PA_GET_RESOURCE.Get_Resource_group

1976: -- track_as_labor_flag.Parent_member_id would be null in this
1977: -- case. It is possible that the resource group has already
1978: -- been created. Hence we call Get_resource_group first
1979: IF l_grouped_resource_type_code = p_resource_type_code THEN
1980: PA_GET_RESOURCE.Get_Resource_group
1981: (p_resource_list_id => p_resource_list_id,
1982: p_resource_group => l_resource_group,
1983: p_resource_list_member_id => l_group_res_list_member_id,
1984: p_resource_id => l_resource_id,

Line 2040: PA_GET_RESOURCE.Get_Resource_group

2036: --Hence,
2037: -- to determine whether the child resource has been created
2038: -- we need the parent_member_id (the resource_list_member_id of
2039: -- the resource_group);So,call Get_resource_group first
2040: PA_GET_RESOURCE.Get_Resource_group
2041: (p_resource_list_id => p_resource_list_id,
2042: p_resource_group => l_resource_group,
2043: p_resource_list_member_id => l_group_res_list_member_id,
2044: p_resource_id => l_resource_id,

Line 2157: PA_GET_RESOURCE.Get_Resource_list_member

2153: ELSE -- If resource_list_member_id returned by
2154: -- Get_Resource_Group is not null then
2155: -- call Get_Resource_list_member to get
2156: -- the resource list member
2157: PA_GET_RESOURCE.Get_Resource_list_member
2158: (p_resource_list_id => p_resource_list_id,
2159: p_resource_name => p_resource_name,
2160: p_resource_type_Code => p_resource_type_code,
2161: p_group_resource_type_id => l_grouped_resource_type_id,

Line 2674: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource

2670: --Outer Join is removed from above cursor as this code is not used to create unclassified
2671: --resource
2672:
2673: -- Following block of code is added for the resolution of bug 1889671
2674: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource
2675: -- Start of change
2676:
2677: CURSOR Cur_Unclassified_Resource_List IS
2678: SELECT prt.resource_type_id,prt.resource_type_code

Line 2925: PA_GET_RESOURCE.Get_Resource

2921:
2922: --- Check whether the child resource has already been created as
2923: --- a resource in PA_RESOURCES table and get the resource_id.
2924:
2925: PA_GET_RESOURCE.Get_Resource
2926: (p_resource_name => p_resource_name,
2927: p_resource_type_Code => p_resource_type_code,
2928: p_person_id => p_person_id,
2929: p_job_id => p_job_id,

Line 2971: PA_GET_RESOURCE.Get_Resource_Information

2967: ELSIF p_resource_type_code = 'PROJECT_ROLE' THEN
2968: l_attr_value := TO_CHAR(p_project_role_id) ;
2969: END IF;
2970:
2971: PA_GET_RESOURCE.Get_Resource_Information
2972: (p_resource_type_Code => p_resource_type_code,
2973: p_resource_attr_value => l_attr_value,
2974: p_unit_of_measure => l_uom,
2975: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 3017: PA_GET_RESOURCE.Get_Resource_Information

3013: ELSIF p_resource_type_code = 'REVENUE_CATEGORY' THEN
3014: l_attr_value := p_revenue_category_code ;
3015: END IF;
3016:
3017: PA_GET_RESOURCE.Get_Resource_Information
3018: (p_resource_type_Code => p_resource_type_code,
3019: p_resource_attr_value => l_attr_value,
3020: p_unit_of_measure => l_uom,
3021: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 3209: PA_GET_RESOURCE.Get_Unclassified_Resource

3205: -- the resource_group has at least one child resource. Hence
3206: -- need to check whether the unclassified resource has already
3207: -- been created.
3208: IF p_parent_member_id IS NOT NULL THEN
3209: PA_GET_RESOURCE.Get_Unclassified_Resource
3210: (p_resource_id => l_resource_id,
3211: p_resource_name => l_resource_name,
3212: p_track_as_labor_flag => l_track_as_labor_flag,
3213: p_unit_of_measure => l_uom,

Line 3223: PA_GET_RESOURCE.Get_Unclassified_Member

3219: IF l_err_code <> 0 THEN
3220: p_err_code := l_err_code;
3221: RETURN;
3222: END IF;
3223: PA_GET_RESOURCE.Get_Unclassified_Member
3224: (p_resource_list_id => p_resource_list_id,
3225: p_parent_member_id => p_parent_member_id,
3226: p_unclassified_resource_id => l_resource_id,
3227: p_resource_list_member_id => l_resource_list_member_id,

Line 3565: PA_GET_RESOURCE.delete_resource_list_ok(

3561: -- Check for Planning Resource List used anywhere
3562:
3563: l_err_code := 0;
3564:
3565: PA_GET_RESOURCE.delete_resource_list_ok(
3566: p_resource_list_id,
3567: 'Y',
3568: l_err_code,
3569: x_msg_data);

Line 3588: PA_GET_RESOURCE.delete_resource_list_member_ok(

3584: EXIT WHEN get_members%NOTFOUND;
3585:
3586: l_err_code := 0;
3587:
3588: PA_GET_RESOURCE.delete_resource_list_member_ok(
3589: p_resource_list_id,
3590: l_res_list_member_id,
3591: l_err_code,
3592: x_msg_data);