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_FCST_AMT_PUB dependencies on PA_PLSQL_DATATYPES

Line 61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

57: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
58:
59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';
60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
64:
65: l_rev_gen_method VARCHAR2(3);

Line 62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

58:
59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';
60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
64:
65: l_rev_gen_method VARCHAR2(3);
66: l_error_msg VARCHAR2(30);

Line 63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

59: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.generate_fcst_amt_wrp';
60: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
61: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
62: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
63: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
64:
65: l_rev_gen_method VARCHAR2(3);
66: l_error_msg VARCHAR2(30);
67: l_msg_count NUMBER;

Line 78: lx_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

74: l_task_count NUMBER;
75:
76: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%type;
77: l_src_version_type pa_budget_versions.version_type%type;
78: lx_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: lx_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
80:
81: -- Bug 4592564: Removed variables for Unspent Amounts option.
82:

Line 79: lx_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

75:
76: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%type;
77: l_src_version_type pa_budget_versions.version_type%type;
78: lx_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
79: lx_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
80:
81: -- Bug 4592564: Removed variables for Unspent Amounts option.
82:
83: -- Added as part of fix for Bug 4232094

Line 961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004

957: WHERE project_id = P_PROJECT_ID and
958: top_task_id = l_temp_top_task_id and
959: task_id <> top_task_id; -- don't want to retrieve the current node
960:
961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004

958: top_task_id = l_temp_top_task_id and
959: task_id <> top_task_id; -- don't want to retrieve the current node
960:
961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;

Line 963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004

959: task_id <> top_task_id; -- don't want to retrieve the current node
960:
961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;

Line 964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

960:
961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
968: l_curr_etc_ver_id NUMBER;

Line 965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;

961: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
962: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
963: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
964: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
965: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
966: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
967: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
968: l_curr_etc_ver_id NUMBER;
969: l_curr_etc_method_code VARCHAR2(30);

Line 982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

978: l_bc_index BINARY_INTEGER;
979: l_ev_index BINARY_INTEGER;
980:
981: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

979: l_ev_index BINARY_INTEGER;
980:
981: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:

Line 984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

980:
981: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */

Line 985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

981: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

982: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
983: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
984: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

985: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

986: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:

Line 991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

987:
988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */

Line 992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

988: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

989: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
990: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
991: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

992: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

993: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1001:

Line 998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

994:
995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1001:
1002: -- Bug 4114589: When populating temporary table data, we need to process

Line 999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

995: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1001:
1002: -- Bug 4114589: When populating temporary table data, we need to process
1003: -- tasks with source of Average of Actuals separately after copying actuals.

Line 1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

996: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
997: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
998: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
999: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1001:
1002: -- Bug 4114589: When populating temporary table data, we need to process
1003: -- tasks with source of Average of Actuals separately after copying actuals.
1004: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1004: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1000: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1001:
1002: -- Bug 4114589: When populating temporary table data, we need to process
1003: -- tasks with source of Average of Actuals separately after copying actuals.
1004: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1005:
1006: -- Bug 4089850: Modified traverse_tasks_rlm_cur so that we no longer
1007: -- join with pa_tasks to get the ETC source code. Instead, we return
1008: -- the transaction_source_code from tmp1.

Line 1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1015: tmp1.resource_list_member_id,
1016: tmp1.etc_method_code
1017: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1018:
1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

Line 1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;

1016: tmp1.etc_method_code
1017: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1018:
1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;

Line 1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1017: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1018:
1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1025:

Line 1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1018:
1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1025:
1026: l_gen_etc_source_code_override VARCHAR2(30);

Line 1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1019: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1025:
1026: l_gen_etc_source_code_override VARCHAR2(30);
1027:

Line 1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;

1020: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1021: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1022: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1023: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1024: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1025:
1026: l_gen_etc_source_code_override VARCHAR2(30);
1027:
1028: --in param for PPA_FP_MAP_BV_PUB.GEN_MAP_BV_TO_TARGET_RL to

Line 1082: L_RES_ASG_UOM_UPDATE_TAB PA_PLSQL_DATATYPES.IdTabTyp;

1078: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
1079: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
1080: l_cal_unit_of_measure_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1081:
1082: L_RES_ASG_UOM_UPDATE_TAB PA_PLSQL_DATATYPES.IdTabTyp;
1083:
1084: l_target_class_rlm_id NUMBER;
1085: l_rev_gen_method VARCHAR2(10);
1086:

Line 1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1130:
1131: l_etc_start_date DATE;
1132:
1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1138:

Line 1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1131: l_etc_start_date DATE;
1132:
1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1138:
1139: l_entered_flag VARCHAR2(1) := 'N';

Line 1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1132:
1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1138:
1139: l_entered_flag VARCHAR2(1) := 'N';
1140: l_proceed_flag VARCHAR2(1) := 'Y';

Line 1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1133: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1134: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1136: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1137: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1138:
1139: l_entered_flag VARCHAR2(1) := 'N';
1140: l_proceed_flag VARCHAR2(1) := 'Y';
1141:

Line 1521: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1517: TYPE SystemPaNumTblTypeTabType
1518: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;
1519:
1520: l_ra_id_tab_table SystemPaNumTblTypeTabType;
1521: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1522: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1523:
1524: /***
1525: * Added in IPM

Line 1522: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

1518: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;
1519:
1520: l_ra_id_tab_table SystemPaNumTblTypeTabType;
1521: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1522: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1523:
1524: /***
1525: * Added in IPM
1526: * Variable : L_REMOVE_RECORD_FLAG_TAB

Line 1577: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1573: */
1574:
1575: -- Added in IPM to track if a record in the existing set of
1576: -- pl/sql tables needs to be removed.
1577: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1578: l_remove_records_flag VARCHAR2(1);
1579:
1580: -- Added in IPM to track if only ETC revenue is available.
1581: -- Note that this table should be initialized after ETC is

Line 1583: l_rev_only_src_txn_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1579:
1580: -- Added in IPM to track if only ETC revenue is available.
1581: -- Note that this table should be initialized after ETC is
1582: -- fetched but before assignments to ETC raw cost begin.
1583: l_rev_only_src_txn_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1584:
1585: /* This user-defined exception is used to skip processing of
1586: * a planning transaction within a loop */
1587: continue_loop EXCEPTION;

Line 1589: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1585: /* This user-defined exception is used to skip processing of
1586: * a planning transaction within a loop */
1587: continue_loop EXCEPTION;
1588:
1589: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1590: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
1591:
1592: BEGIN
1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;