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

Line 25: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

21: ,p_RBS_Version_Id IN NUMBER DEFAULT NULL
22: ,p_WBS_Rollup_Flag IN VARCHAR2
23: ,p_RBS_Rollup_Flag IN VARCHAR2
24: ,p_resource_tbl_flag IN VARCHAR2 DEFAULT 'N'
25: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
26: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
27: ,x_version OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: ,x_version_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29: ,x_project_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 63: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

59: ,x_total_labor_hours OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: ,x_total_equip_hours OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61: ,x_rev_total_labor_hours OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62: ,x_rev_total_equip_hours OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
64: ,x_txn_currency_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE --File.Sql.39 bug 4440895
65: ,x_workplan_costs_enabled_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 688: ,X_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

684: ,p_WBS_Structure_Version_Id IN NUMBER DEFAULT NULL
685: ,p_RBS_Version_Id IN NUMBER DEFAULT NULL
686: ,p_WBS_Rollup_Flag IN VARCHAR2
687: ,p_RBS_Rollup_Flag IN VARCHAR2
688: ,X_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
689: ,X_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895
690: ,X_rev_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
691: ,X_rev_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895
692: ,X_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 690: ,X_rev_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

686: ,p_WBS_Rollup_Flag IN VARCHAR2
687: ,p_RBS_Rollup_Flag IN VARCHAR2
688: ,X_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
689: ,X_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895
690: ,X_rev_res_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
691: ,X_rev_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895
692: ,X_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
693: ) IS
694: -- WBS only - Rollup

Line 887: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

883:
884: pa_debug.g_err_stage:='Beginning of ' || L_FuncProc;
885: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
886:
887: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
888: x_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
889: x_rev_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
890: x_rev_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
891:

Line 889: x_rev_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

885: pa_debug.write(L_Module,pa_debug.g_err_stage,3);
886:
887: x_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
888: x_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
889: x_rev_res_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
890: x_rev_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();
891:
892: -- Check if Project Level WBS Node
893: IF (p_wbs_element_id IS NOT NULL) AND (p_wbs_structure_version_id IS NOT NULL) THEN

Line 1390: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1386: ,p_WBS_Structure_Version_Id IN NUMBER DEFAULT NULL
1387: ,p_RBS_Version_Id IN NUMBER DEFAULT NULL
1388: ,p_WBS_Rollup_Flag IN VARCHAR2
1389: ,p_RBS_Rollup_Flag IN VARCHAR2
1390: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1391: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
1392: ,x_cost_budget_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1393: ,x_rev_budget_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1394: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1421: L_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

1417: l_raw_cost_adj_pct NUMBER;
1418: l_burden_cost_adj_pct NUMBER;
1419: l_revenue_adj_pct NUMBER;
1420:
1421: L_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1422: L_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1423: L_rev_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1424: L_rev_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1425:

Line 1423: L_rev_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

1419: l_revenue_adj_pct NUMBER;
1420:
1421: L_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1422: L_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1423: L_rev_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1424: L_rev_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1425:
1426: l_t_id NUMBER;
1427: l_t_code VARCHAR2(15);

Line 1435: l_target_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

1431: l_rev_budget_version_id NUMBER;
1432: l_target_budget_version_id NUMBER;
1433: l_target_rev_version_id NUMBER;
1434:
1435: l_target_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1436: l_target_rev_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1437:
1438: api_exception EXCEPTION ;
1439:

Line 1436: l_target_rev_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();

1432: l_target_budget_version_id NUMBER;
1433: l_target_rev_version_id NUMBER;
1434:
1435: l_target_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1436: l_target_rev_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE();
1437:
1438: api_exception EXCEPTION ;
1439:
1440: l_struct_ver_id NUMBER;