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_CI_MERGE dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 928: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();

924: l_ci_all_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
925: l_target_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
926: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
927: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
928: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
929: l_translated_err_msg_count NUMBER;
930: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
931:
932: l_impact_record_exists VARCHAR2(1); -- Bug 3677924 Raja 02-Jul-04

Line 3110: l_bl_DESCRIPTION_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3106: l_bl_RAW_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3107: l_bl_BURDENED_COST_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3108: l_bl_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3109: l_bl_CHANGE_REASON_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3110: l_bl_DESCRIPTION_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3111: l_bl_ATTRIBUTE_CATEGORY_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3112: l_bl_ATTRIBUTE1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3113: l_bl_ATTRIBUTE2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
3114: l_bl_ATTRIBUTE3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE:= SYSTEM.PA_VARCHAR2_150_TBL_TYPE();

Line 3135: l_bl_CCID_GEN_REJ_MESSAGE_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3131: l_bl_BURDEN_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3132: l_bl_OTHER_REJECTION_CODE_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3133: l_bl_CODE_COMBINATION_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3134: l_bl_CCID_GEN_STATUS_CODE_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3135: l_bl_CCID_GEN_REJ_MESSAGE_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE:= SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3136: l_bl_REQUEST_ID_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3137: l_bl_BORROWED_REVENUE_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3138: l_bl_TP_REVENUE_IN_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
3139: l_bl_TP_REVENUE_OUT_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 12551: ,x_translated_msgs_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type --File.Sql.39 bug 4440895

12547: ,p_update_agreement_amt_flag IN VARCHAR2
12548: ,p_funding_category IN VARCHAR2
12549: ,p_raTxn_rollup_api_call_flag IN VARCHAR2 --IPM Arch Enhancement Bug 4865563
12550: ,p_add_msg_to_stack IN VARCHAR2
12551: ,x_translated_msgs_tbl OUT NOCOPY SYSTEM.pa_varchar2_2000_tbl_type --File.Sql.39 bug 4440895
12552: ,x_translated_err_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
12553: ,x_translated_err_msg_level_tbl OUT NOCOPY SYSTEM.pa_varchar2_30_tbl_type --File.Sql.39 bug 4440895
12554: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12555: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 12733: x_translated_msgs_tbl := SYSTEM.pa_varchar2_2000_tbl_type();

12729: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12730: END IF;
12731:
12732:
12733: x_translated_msgs_tbl := SYSTEM.pa_varchar2_2000_tbl_type();
12734: x_translated_err_msg_level_tbl := SYSTEM.pa_varchar2_30_tbl_type();
12735:
12736: IF p_add_msg_to_stack='N' THEN
12737:

Line 13648: l_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

13644: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13645: l_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE;
13646: l_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE;
13647: l_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;
13648: l_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
13649: -- target ci variables
13650: l_dc_line_id_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13651: l_task_id_to_tbl SYSTEM.PA_NUM_TBL_TYPE ;
13652: l_expenditure_type_to_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE ;

Line 13695: u_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

13691: u_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
13692: u_effective_from_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
13693: u_effective_to_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
13694: u_change_reason_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
13695: u_change_description SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
13696: --
13697: l_api_version number := 1;
13698: l_api_name CONSTANT VARCHAR2(60) := 'PA_FP_CI_MERGE.copy_direct_cost_data';
13699: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;