DBA Data[Home] [Help]

APPS.PA_RBS_MAPPING dependencies on PA_CROSS_BUSINESS_GRP

Line 2148: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727

2144: decode(head.resource_class_id,-1,null,head.resource_class_id), --- resource class
2145: decode(head.non_labor_resource_id,-1,null,head.non_labor_resource_id), --- non labor resource
2146: decode(head.person_type,'PJI$NULL',null,get_res_type_numeric_id(head.person_type,11)), --- person type
2147: decode(head.expenditure_organization_id,-1,null,head.expenditure_organization_id), --- organization
2148: decode(head.job_id,-1,null,l_job_group_id,null,head.job_id,PA_Cross_Business_Grp.IsMappedToJob(head.job_id, l_job_group_id)), --- job, bug#4027727
2149: decode(head.inventory_item_id,-1,null,head.inventory_item_id), --- inventory item
2150: decode(head.item_category_id,-1,null,head.item_category_id), --- item category
2151: decode(head.expenditure_type_id,-1,null,head.expenditure_type_id), --- expenditure type
2152: decode(head.expenditure_category_id,-1,null,head.expenditure_category_id), --- expenditure category

Line 2549: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))

2545: /** Commented for bug 6662808
2546: UPDATE pa_rbs_plans_out_tmp dest
2547: SET job_id =
2548: ( decode(job_id, null, null, l_job_group_id, null, job_id,
2549: PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)))
2550: WHERE
2551: dest.job_id is not null;
2552: **/
2553:

Line 2559: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)

2555:
2556: if l_job_group_id is not null then
2557:
2558: UPDATE pa_rbs_plans_out_tmp dest
2559: SET job_id= PA_Cross_Business_Grp.IsMappedToJob(job_id,l_job_group_id)
2560: WHERE dest.job_id is not null;
2561:
2562: end if;
2563: /** AEnd of addition for bug 6662808 **/

Line 2596: -- decode(job_id, null, null, l_job_group_id, null, job_id, PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)), --bug#4027727

2592: revenue_category_id, --bug#4098679
2593: resource_class_id,
2594: non_labor_resource_id,
2595: organization_id,
2596: -- decode(job_id, null, null, l_job_group_id, null, job_id, PA_Cross_Business_Grp.IsMappedToJob(job_id, l_job_group_id)), --bug#4027727
2597: job_id, --bug#4098679
2598: inventory_item_id,
2599: item_category_id,
2600: expenditure_type_id,