DBA Data[Home] [Help]

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: -- BEGIN Bug 10298995 : Added for Viasat enhancement
82: cursor res_asgn_csr IS

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: -- BEGIN Bug 10298995 : Added for Viasat enhancement
82: cursor res_asgn_csr IS
83: select resource_assignment_id, txn_currency_code

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

1095: WHERE project_id = P_PROJECT_ID and
1096: top_task_id = l_temp_top_task_id and
1097: task_id <> top_task_id; -- don't want to retrieve the current node
1098:
1099: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;

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

1096: top_task_id = l_temp_top_task_id and
1097: task_id <> top_task_id; -- don't want to retrieve the current node
1098:
1099: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;

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

1097: task_id <> top_task_id; -- don't want to retrieve the current node
1098:
1099: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;

Line 1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

1098:
1099: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
1106: l_curr_etc_ver_id NUMBER;

Line 1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;

1099: l_top_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1100: l_child_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp; -- ETC Enhancements 10/2004
1101: l_top_gen_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp; -- ETC Enhancements 10/2004
1102: l_task_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1103: l_gen_etc_source_code_tab pa_plsql_datatypes.Char30TabTyp;
1104: l_curr_task_id PA_TASKS.TASK_ID%TYPE;
1105: l_curr_etc_source PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE;
1106: l_curr_etc_ver_id NUMBER;
1107: l_curr_etc_method_code VARCHAR2(30);

Line 1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1117: l_bc_index BINARY_INTEGER;
1118: l_ev_index BINARY_INTEGER;
1119:
1120: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

Line 1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1118: l_ev_index BINARY_INTEGER;
1119:
1120: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1119:
1120: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:

Line 1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1120: /* PL/SQL tables for Remaining Budget - Performance Bug 4194849 */
1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */

Line 1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

1121: l_rb_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1122: l_rb_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1123: l_rb_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1124: l_rb_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1125: l_rb_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

Line 1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1126: l_rb_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1127:
1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:

Line 1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1128: /* PL/SQL tables for Budget To Complete - Performance Bug 4194849 */
1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */

Line 1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

1129: l_bc_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1130: l_bc_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1131: l_bc_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1132: l_bc_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1133: l_bc_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

Line 1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1134: l_bc_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1135:
1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1143:

Line 1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1136: /* PL/SQL tables for Earned Value - Performance Bug 4194849 */
1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1143:
1144: -- Bug 4114589: When populating temporary table data, we need to process

Line 1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

1137: l_ev_src_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1143:
1144: -- Bug 4114589: When populating temporary table data, we need to process
1145: -- tasks with source of Average of Actuals separately after copying actuals.

Line 1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1138: l_ev_tgt_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1139: l_ev_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1140: l_ev_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1141: l_ev_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1143:
1144: -- Bug 4114589: When populating temporary table data, we need to process
1145: -- tasks with source of Average of Actuals separately after copying actuals.
1146: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1146: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1142: l_ev_etc_source_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1143:
1144: -- Bug 4114589: When populating temporary table data, we need to process
1145: -- tasks with source of Average of Actuals separately after copying actuals.
1146: l_avg_actuals_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1147:
1148: -- Bug 4089850: Modified traverse_tasks_rlm_cur so that we no longer
1149: -- join with pa_tasks to get the ETC source code. Instead, we return
1150: -- the transaction_source_code from tmp1.

Line 1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1158: tmp1.cbs_element_id, --bug#16791711
1159: tmp1.etc_method_code
1160: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1161:
1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

Line 1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;

1159: tmp1.etc_method_code
1160: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1161:
1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711

Line 1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1160: FROM PA_FP_CALC_AMT_TMP1 tmp1;
1161:
1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711
1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;

Line 1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1161:
1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711
1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1169:

Line 1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;

1162: l_task_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711
1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1169:
1170: -- gboomina Bug 8318932 AAI Enhancement - Start

Line 1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711

1163: l_gen_etc_source_code_tab2 pa_plsql_datatypes.Char30TabTyp;
1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711
1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1169:
1170: -- gboomina Bug 8318932 AAI Enhancement - Start
1171: CURSOR get_copy_etc_from_plan_csr

Line 1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;

1164: l_src_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1165: l_tgt_ra_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1166: l_rlm_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;
1167: l_cbs_id_tab2 PA_PLSQL_DATATYPES.NumTabTyp;--bug#16791711
1168: l_etc_method_tab2 pa_plsql_datatypes.Char30TabTyp;
1169:
1170: -- gboomina Bug 8318932 AAI Enhancement - Start
1171: CURSOR get_copy_etc_from_plan_csr
1172: IS

Line 1237: L_RES_ASG_UOM_UPDATE_TAB PA_PLSQL_DATATYPES.IdTabTyp;

1233: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
1234: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
1235: l_cal_unit_of_measure_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1236:
1237: L_RES_ASG_UOM_UPDATE_TAB PA_PLSQL_DATATYPES.IdTabTyp;
1238:
1239: l_target_class_rlm_id NUMBER;
1240: l_target_class_cbs_id NUMBER;--bug#16791711
1241: l_rev_gen_method VARCHAR2(10);

Line 1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1287:
1288: l_etc_start_date DATE;
1289:
1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1295:

Line 1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1288: l_etc_start_date DATE;
1289:
1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1295:
1296: l_entered_flag VARCHAR2(1) := 'N';

Line 1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1289:
1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1295:
1296: l_entered_flag VARCHAR2(1) := 'N';
1297: l_proceed_flag VARCHAR2(1) := 'Y';

Line 1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1290: /* Bug 3968748: Variables for populating PA_FP_GEN_RATE_TMP */
1291: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1292: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1293: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1294: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1295:
1296: l_entered_flag VARCHAR2(1) := 'N';
1297: l_proceed_flag VARCHAR2(1) := 'Y';
1298:

Line 1690: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1686: TYPE SystemPaNumTblTypeTabType
1687: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;
1688:
1689: l_ra_id_tab_table SystemPaNumTblTypeTabType;
1690: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1691: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1692:
1693: /***
1694: * Added in IPM

Line 1691: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

1687: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;
1688:
1689: l_ra_id_tab_table SystemPaNumTblTypeTabType;
1690: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1691: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
1692:
1693: /***
1694: * Added in IPM
1695: * Variable : L_REMOVE_RECORD_FLAG_TAB

Line 1746: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1742: */
1743:
1744: -- Added in IPM to track if a record in the existing set of
1745: -- pl/sql tables needs to be removed.
1746: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1747: l_remove_records_flag VARCHAR2(1);
1748:
1749: -- Added in IPM to track if only ETC revenue is available.
1750: -- Note that this table should be initialized after ETC is

Line 1752: l_rev_only_src_txn_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

1748:
1749: -- Added in IPM to track if only ETC revenue is available.
1750: -- Note that this table should be initialized after ETC is
1751: -- fetched but before assignments to ETC raw cost begin.
1752: l_rev_only_src_txn_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1753:
1754: /* This user-defined exception is used to skip processing of
1755: * a planning transaction within a loop */
1756: continue_loop EXCEPTION;

Line 1758: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1754: /* This user-defined exception is used to skip processing of
1755: * a planning transaction within a loop */
1756: continue_loop EXCEPTION;
1757:
1758: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1759: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
1760:
1761: BEGIN
1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;