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_PLANNING_RESOURCE_UTILS dependencies on PA_NUM_TBL_TYPE

Line 229: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,

225: /********************************************************************
226: * Procedure : get_resource_defaults
227: * *****************************************************************/
228: PROCEDURE get_resource_defaults (
229: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
230: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
231: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
232: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
233: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 233: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

229: P_resource_list_members IN SYSTEM.PA_NUM_TBL_TYPE,
230: P_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
231: X_resource_class_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
232: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
233: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
234: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
235: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
236: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
237: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 236: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

232: X_resource_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
233: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
234: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
235: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
236: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
237: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
238: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
239: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 237: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

233: X_resource_class_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
234: X_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
235: X_incur_by_res_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
236: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
237: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
238: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
239: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,

Line 240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

236: X_person_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
237: X_job_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
238: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
239: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

Line 242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

238: X_person_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
239: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
245: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
246: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

239: X_named_role OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE,
240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
245: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
246: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
247: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

240: X_bom_resource_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
245: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
246: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
247: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
248: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 245: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

241: X_non_labor_resource OUT NOCOPY SYSTEM.PA_VARCHAR2_20_TBL_TYPE,
242: X_inventory_item_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
243: X_item_category_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
244: X_project_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
245: X_organization_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
246: X_fc_res_type_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
247: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
248: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
249: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 251: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

247: X_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
248: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
249: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
250: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
251: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
252: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
253: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
254: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
255: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,

Line 252: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

248: X_expenditure_category OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
249: X_event_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
250: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
251: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
252: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
253: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
254: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
255: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
256: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 254: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

250: X_revenue_category_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
251: X_supplier_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
252: X_spread_curve_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
253: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
254: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
255: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
256: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
257: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
258: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 257: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

253: X_etc_method_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
254: X_mfc_cost_type_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
255: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
256: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
257: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
258: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
259: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
260: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
261: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

Line 259: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

255: X_incurred_by_res_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
256: X_incur_by_res_class_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
257: X_incur_by_role_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
258: X_unit_of_measure OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
259: X_org_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
260: X_rate_based_flag OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE,
261: X_rate_expenditure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
262: X_rate_func_curr_code OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
263: X_msg_data OUT NOCOPY VARCHAR2,

Line 529: (P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

525: Public or Private API? Public
526:
527: ------------------------------------------------------------------------- */
528: Procedure Get_Resource_Cost_Rate
529: (P_eligible_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
530: ,P_project_id IN pa_projects_all.project_id%type
531: ,p_structure_type IN VARCHAR2
532: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
533: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 534: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

530: ,P_project_id IN pa_projects_all.project_id%type
531: ,p_structure_type IN VARCHAR2
532: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
533: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
534: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
535: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
536: ) ;
537:
538: Function Derive_Resource_List_Member

Line 535: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

531: ,p_structure_type IN VARCHAR2
532: ,p_fin_plan_type_id IN NUMBER DEFAULT NULL
533: ,P_resource_curr_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE
534: ,P_resource_raw_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
535: ,P_resource_burden_rate_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
536: ) ;
537:
538: Function Derive_Resource_List_Member
539: (p_project_id IN NUMBER,