DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PJM_COMMITMENT_UTILS

Line 1844: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(

1840: --Bug 3615477
1841: --Also updating the value of fc_res_type_code.
1842: UPDATE pa_res_members_temp res_temp
1843: SET res_temp.expenditure_type =
1844: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(
1845: res_temp.organization_id, res_temp.inventory_item_id)
1846: WHERE res_temp.organization_id IS NOT NULL
1847: AND res_temp.inventory_item_id IS NOT NULL
1848: AND res_temp.expenditure_type IS NULL;

Line 1911: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(

1907: -- Get the item's exp type if it exists
1908:
1909: UPDATE pa_res_members_temp res_temp
1910: SET res_temp.rate_expenditure_type =
1911: PJM_COMMITMENT_UTILS.MTL_EXPENDITURE_TYPE(
1912: res_temp.organization_id, res_temp.inventory_item_id)
1913: WHERE res_temp.organization_id IS NOT NULL
1914: AND res_temp.inventory_item_id IS NOT NULL
1915: AND res_temp.rate_expenditure_type IS NULL;