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 312: PA_GET_RESOURCE.Get_Resource

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

Line 337: PA_GET_RESOURCE.Get_Resource_Information

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

Line 366: PA_GET_RESOURCE.Get_Resource_Information

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

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

629: WHERE job_group_id = p_job_group_id
630: AND ROWNUM = 1;
631:
632: -- Following block of code is added for the resolution of bug 1889671
633: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource
634: -- Start of change
635:
636: CURSOR Cur_Unclassified_Resource_List IS
637: SELECT prt.resource_type_id,prt.resource_type_code

Line 859: PA_GET_RESOURCE.Get_Unclassified_Resource

855: /* commented for bug 6079140 END IF; -- Adding to TL */
856:
857: IF p_migration_code IS NULL THEN -- Added by RM
858: -- Need to create one Unclassified Resource for the resource list
859: PA_GET_RESOURCE.Get_Unclassified_Resource
860: (p_resource_id => l_resource_id,
861: p_resource_name => l_resource_name,
862: p_track_as_labor_flag => l_track_as_labor_flag,
863: p_unit_of_measure => l_uom,

Line 2072: 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))

2068: SELECT
2069: REVENUE_CATEGORY_CODE
2070: ,REVENUE_CATEGORY_M description
2071: FROM PA_REVENUE_CATEGORIES_V RC
2072: 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))
2073: ) tmp
2074: WHERE
2075: tmp.revenue_category_code = l_revenue_category_code;
2076:

Line 2209: PA_GET_RESOURCE.Get_Resource_list_member

2205: -- since the resource list is not grouped,need only to return
2206: -- the resource_list_member_id of the input resource.Hence,first
2207: -- call Get_Resource_list_member to get the resource list member id.
2208:
2209: PA_GET_RESOURCE.Get_Resource_list_member
2210: (p_resource_list_id => p_resource_list_id,
2211: p_resource_name => p_resource_name,
2212: p_resource_type_Code => p_resource_type_code,
2213: p_group_resource_type_id => l_grouped_resource_type_id,

Line 2328: PA_GET_RESOURCE.Get_Resource_group

2324: -- track_as_labor_flag.Parent_member_id would be null in this
2325: -- case. It is possible that the resource group has already
2326: -- been created. Hence we call Get_resource_group first
2327: IF l_grouped_resource_type_code = p_resource_type_code THEN
2328: PA_GET_RESOURCE.Get_Resource_group
2329: (p_resource_list_id => p_resource_list_id,
2330: p_resource_group => l_resource_group,
2331: p_resource_list_member_id => l_group_res_list_member_id,
2332: p_resource_id => l_resource_id,

Line 2388: PA_GET_RESOURCE.Get_Resource_group

2384: --Hence,
2385: -- to determine whether the child resource has been created
2386: -- we need the parent_member_id (the resource_list_member_id of
2387: -- the resource_group);So,call Get_resource_group first
2388: PA_GET_RESOURCE.Get_Resource_group
2389: (p_resource_list_id => p_resource_list_id,
2390: p_resource_group => l_resource_group,
2391: p_resource_list_member_id => l_group_res_list_member_id,
2392: p_resource_id => l_resource_id,

Line 2505: PA_GET_RESOURCE.Get_Resource_list_member

2501: ELSE -- If resource_list_member_id returned by
2502: -- Get_Resource_Group is not null then
2503: -- call Get_Resource_list_member to get
2504: -- the resource list member
2505: PA_GET_RESOURCE.Get_Resource_list_member
2506: (p_resource_list_id => p_resource_list_id,
2507: p_resource_name => p_resource_name,
2508: p_resource_type_Code => p_resource_type_code,
2509: p_group_resource_type_id => l_grouped_resource_type_id,

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

3018: --Outer Join is removed from above cursor as this code is not used to create unclassified
3019: --resource
3020:
3021: -- Following block of code is added for the resolution of bug 1889671
3022: -- Same logic is used as it is done in PA_GET_RESOURCE.Get_Unclassified_Resource
3023: -- Start of change
3024:
3025: CURSOR Cur_Unclassified_Resource_List IS
3026: SELECT prt.resource_type_id,prt.resource_type_code

Line 3274: PA_GET_RESOURCE.Get_Resource

3270:
3271: --- Check whether the child resource has already been created as
3272: --- a resource in PA_RESOURCES table and get the resource_id.
3273:
3274: PA_GET_RESOURCE.Get_Resource
3275: (p_resource_name => p_resource_name,
3276: p_resource_type_Code => p_resource_type_code,
3277: p_person_id => p_person_id,
3278: p_job_id => p_job_id,

Line 3320: PA_GET_RESOURCE.Get_Resource_Information

3316: ELSIF p_resource_type_code = 'PROJECT_ROLE' THEN
3317: l_attr_value := TO_CHAR(p_project_role_id) ;
3318: END IF;
3319:
3320: PA_GET_RESOURCE.Get_Resource_Information
3321: (p_resource_type_Code => p_resource_type_code,
3322: p_resource_attr_value => l_attr_value,
3323: p_unit_of_measure => l_uom,
3324: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 3366: PA_GET_RESOURCE.Get_Resource_Information

3362: ELSIF p_resource_type_code = 'REVENUE_CATEGORY' THEN
3363: l_attr_value := p_revenue_category_code ;
3364: END IF;
3365:
3366: PA_GET_RESOURCE.Get_Resource_Information
3367: (p_resource_type_Code => p_resource_type_code,
3368: p_resource_attr_value => l_attr_value,
3369: p_unit_of_measure => l_uom,
3370: p_Rollup_quantity_flag => l_rollup_qty_flag,

Line 3558: PA_GET_RESOURCE.Get_Unclassified_Resource

3554: -- the resource_group has at least one child resource. Hence
3555: -- need to check whether the unclassified resource has already
3556: -- been created.
3557: IF p_parent_member_id IS NOT NULL THEN
3558: PA_GET_RESOURCE.Get_Unclassified_Resource
3559: (p_resource_id => l_resource_id,
3560: p_resource_name => l_resource_name,
3561: p_track_as_labor_flag => l_track_as_labor_flag,
3562: p_unit_of_measure => l_uom,

Line 3572: PA_GET_RESOURCE.Get_Unclassified_Member

3568: IF l_err_code <> 0 THEN
3569: p_err_code := l_err_code;
3570: RETURN;
3571: END IF;
3572: PA_GET_RESOURCE.Get_Unclassified_Member
3573: (p_resource_list_id => p_resource_list_id,
3574: p_parent_member_id => p_parent_member_id,
3575: p_unclassified_resource_id => l_resource_id,
3576: p_resource_list_member_id => l_resource_list_member_id,

Line 3914: PA_GET_RESOURCE.delete_resource_list_ok(

3910: -- Check for Planning Resource List used anywhere
3911:
3912: l_err_code := 0;
3913:
3914: PA_GET_RESOURCE.delete_resource_list_ok(
3915: p_resource_list_id,
3916: 'Y',
3917: l_err_code,
3918: x_msg_data);

Line 3937: PA_GET_RESOURCE.delete_resource_list_member_ok(

3933: EXIT WHEN get_members%NOTFOUND;
3934:
3935: l_err_code := 0;
3936:
3937: PA_GET_RESOURCE.delete_resource_list_member_ok(
3938: p_resource_list_id,
3939: l_res_list_member_id,
3940: l_err_code,
3941: x_msg_data);