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

Line 27: l_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

23: l_data VARCHAR2(2000);
24: l_msg_index_out NUMBER:=0;
25:
26: --Bug 4895793 : Local Variables for calling get_resource_defaults API with DISTINCT rlm_ids.
27: l_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
28: l_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
29: l_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
30: l_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
31: l_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 30: l_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;

26: --Bug 4895793 : Local Variables for calling get_resource_defaults API with DISTINCT rlm_ids.
27: l_resource_list_members_tab SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
28: l_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
29: l_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
30: l_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
31: l_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
32: l_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
33: l_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
34: l_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 32: l_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;

28: l_resource_class_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
29: l_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
30: l_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
31: l_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
32: l_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
33: l_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
34: l_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
35: l_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 33: l_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;

29: l_resource_class_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
30: l_resource_class_id_tab SYSTEM.PA_NUM_TBL_TYPE;
31: l_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
32: l_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
33: l_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
34: l_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
35: l_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;

Line 36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;

32: l_person_id_tab SYSTEM.PA_NUM_TBL_TYPE;
33: l_job_id_tab SYSTEM.PA_NUM_TBL_TYPE;
34: l_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
35: l_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;

34: l_person_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
35: l_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
41: l_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
42: l_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;

35: l_named_role_tab SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
41: l_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
42: l_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
43: l_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

36: l_bom_resource_id_tab SYSTEM.PA_NUM_TBL_TYPE;
37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
41: l_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
42: l_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
43: l_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
44: l_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 41: l_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;

37: l_non_labor_resource_tab SYSTEM.PA_VARCHAR2_20_TBL_TYPE;
38: l_inventory_item_id_tab SYSTEM.PA_NUM_TBL_TYPE;
39: l_item_category_id_tab SYSTEM.PA_NUM_TBL_TYPE;
40: l_project_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
41: l_organization_id_tab SYSTEM.PA_NUM_TBL_TYPE;
42: l_fc_res_type_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
43: l_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
44: l_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
45: l_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 47: l_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;

43: l_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
44: l_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
45: l_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
46: l_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
47: l_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
48: l_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
49: l_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
50: l_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
51: l_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;

Line 48: l_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;

44: l_expenditure_category_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
45: l_event_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
46: l_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
47: l_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
48: l_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
49: l_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
50: l_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
51: l_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
52: l_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 50: l_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;

46: l_revenue_category_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
47: l_supplier_id_tab SYSTEM.PA_NUM_TBL_TYPE;
48: l_spread_curve_id_tab SYSTEM.PA_NUM_TBL_TYPE;
49: l_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
50: l_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
51: l_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
52: l_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
53: l_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
54: l_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 53: l_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;

49: l_etc_method_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
50: l_mfc_cost_type_id_tab SYSTEM.PA_NUM_TBL_TYPE;
51: l_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
52: l_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
53: l_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
54: l_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
55: l_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
56: l_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
57: l_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 55: l_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;

51: l_incurred_by_res_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
52: l_incur_by_res_cls_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
53: l_incur_by_role_id_tab SYSTEM.PA_NUM_TBL_TYPE;
54: l_unit_of_measure_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
55: l_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
56: l_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
57: l_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
58: l_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
59: --l_rat_incured_by_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;

Line 59: --l_rat_incured_by_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;

55: l_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
56: l_rate_based_flag_tab SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
57: l_rate_expenditure_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
58: l_rate_func_curr_code_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
59: --l_rat_incured_by_org_id_tab SYSTEM.PA_NUM_TBL_TYPE;
60: l_incur_by_res_type_tab SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
61:
62: -- Maps rlm_ids to indexes for l_resource_list_members_tab
63: l_rlmid_index_map PA_PLSQL_DATATYPES.IdTabTyp;

Line 475: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

471: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
472:
473: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.INCLUDE_CHANGE_DOCUMENT_WRP';
474:
475: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
476: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type;
477: l_translated_err_msg_count NUMBER;
478: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type;
479: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

Line 479: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

475: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
476: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type;
477: l_translated_err_msg_count NUMBER;
478: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type;
479: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
480: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
481: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
482: l_msg_count number(15);
483: l_msg_index_out number(15);