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_VARCHAR2_15_TBL_TYPE

Line 26: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()

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
30: ,x_structure_version_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 64: ,x_txn_currency_code_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_15_TBL_TYPE --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
68: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 689: ,X_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895

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
693: ) IS

Line 691: ,X_rev_txn_currency_code_tbl OUT NOCOPY SYSTEM.pa_varchar2_15_tbl_type --File.Sql.39 bug 4440895

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
695: CURSOR C_WBS_RES_ID_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,

Line 888: x_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();

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:
892: -- Check if Project Level WBS Node

Line 890: x_rev_txn_currency_code_tbl := SYSTEM.pa_varchar2_15_tbl_type();

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
894: OPEN C_Get_Object_Type(p_wbs_element_id, p_wbs_structure_version_id);

Line 1391: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type

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
1395: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1422: L_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

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:
1426: l_t_id NUMBER;

Line 1424: L_rev_txn_curr_code_tbl SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

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);
1428: l_cnt NUMBER;