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

Line 93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;

89: WHERE structure_version_id = p_struct_ver_id
90: AND nvl(resource_assignment_id,HIDDEN_RES_ASSGN_ID) = p_res_asg_id
91: AND txn_currency_code = p_txn_currency_code;
92:
93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;
94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;
95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;
96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;

90: AND nvl(resource_assignment_id,HIDDEN_RES_ASSGN_ID) = p_res_asg_id
91: AND txn_currency_code = p_txn_currency_code;
92:
93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;
94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;
95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;
96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
98:

Line 95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;

91: AND txn_currency_code = p_txn_currency_code;
92:
93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;
94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;
95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;
96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
98:
99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;

Line 96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;

92:
93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;
94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;
95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;
96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
98:
99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
100: l_time_phase VARCHAR2(10);

Line 97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;

93: l_project_id_tab pa_plsql_datatypes.IdTabTyp;
94: l_struct_ver_id_tab pa_plsql_datatypes.IdTabTyp;
95: l_budget_ver_id_tab pa_plsql_datatypes.IdTabTyp;
96: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
98:
99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
100: l_time_phase VARCHAR2(10);
101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;

Line 101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;

97: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
98:
99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
100: l_time_phase VARCHAR2(10);
101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

98:
99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
100: l_time_phase VARCHAR2(10);
101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

99: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
100: l_time_phase VARCHAR2(10);
101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

100: l_time_phase VARCHAR2(10);
101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

101: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

102: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

103: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;

104: --l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

Line 109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

105: --l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

106: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
114: l_start_date Date;

Line 111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;

107: --l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
114: l_start_date Date;
115: l_end_date Date;

Line 112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

108: --l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
114: l_start_date Date;
115: l_end_date Date;
116:

Line 113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

109: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
110: --l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
111: --l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
112: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
113: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
114: l_start_date Date;
115: l_end_date Date;
116:
117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;

Line 119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;

115: l_end_date Date;
116:
117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;
118:
119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;

Line 120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;

116:
117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;
118:
119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;
124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;

117: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;
118:
119: l_txn_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
120: l_proj_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;
124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
125: l_ra_id_upd_reprt_tab pa_plsql_datatypes.IdTabTyp;

Line 125: l_ra_id_upd_reprt_tab pa_plsql_datatypes.IdTabTyp;

121: l_pou_bd_cost_tab pa_plsql_datatypes.NumTabTyp;
122:
123: l_bv_id pa_budget_versions.budget_version_id%type;
124: l_bv_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
125: l_ra_id_upd_reprt_tab pa_plsql_datatypes.IdTabTyp;
126:
127: /* Additional parameters for MAINTAIN_ACTUAL_AMT_RA */
128: l_open_pd_plan_amt_flag VARCHAR2(1);
129: -- End Date of P_ACTUALS_THRU_DATE period

Line 708: ,p_budget_line_id_tab IN pa_plsql_datatypes.IdTabTyp

704: (p_calling_module IN Varchar2
705: ,p_activity_code IN Varchar2
706: ,p_budget_version_id IN Number
707: ,p_resource_assignment_id IN Number
708: ,p_budget_line_id_tab IN pa_plsql_datatypes.IdTabTyp
709: ,p_calling_mode IN varchar2
710: ,x_msg_data OUT NOCOPY Varchar2
711: ,x_msg_count OUT NOCOPY Number
712: ,x_return_status OUT NOCOPY Varchar2) IS

Line 875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

871: X_MSG_COUNT OUT NOCOPY NUMBER,
872: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
873:
874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';
875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

872: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
873:
874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';
875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

873:
874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';
875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

874: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.maintain_actual_amt_ra';
875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

875: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

876: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

877: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

878: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

879: l_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

880: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:

Line 885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

881: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

882: l_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

883: l_project_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
884: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

885: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

886: l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

887: l_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

888:
889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

889: l_ins_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

890: l_ins_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

891: l_ins_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

892: l_ins_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

893: l_ins_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

894: l_ins_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:

Line 899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

895: l_ins_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

896: l_ins_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

897: l_ins_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
898: l_ins_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

899: l_ins_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

900: l_ins_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

901: l_ins_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

902:
903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

903: l_upd_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

904: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

905: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

906: l_upd_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

907: l_upd_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

908: l_upd_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:

Line 913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

909: l_upd_project_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;

Line 914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

910: l_upd_proj_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

911: l_upd_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
912: l_upd_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
913: l_upd_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

914: l_upd_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:

Line 919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

915: l_upd_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */

Line 920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

916:
917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

917: l_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
918: l_projfunc_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
919: l_projfunc_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

920: l_project_cost_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

921: l_project_rev_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

922:
923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

923: /* PL/SQL tables for rate overrides (Added for Bug 4162449) */
924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

924: l_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

925: l_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
933:

Line 930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

926: l_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
933:
934: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

927: l_ins_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
933:
934: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
935: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

928: l_ins_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
929: l_ins_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
930: l_upd_cost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
931: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
932: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
933:
934: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
935: l_last_update_login NUMBER := FND_GLOBAL.login_id;
936: l_sysdate DATE := SYSDATE;

Line 939: l_bdgt_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

935: l_last_update_login NUMBER := FND_GLOBAL.login_id;
936: l_sysdate DATE := SYSDATE;
937:
938: l_bdgt_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
939: l_bdgt_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
940:
941: l_upd_ind NUMBER := 1;
942: l_ins_ind NUMBER := 1;
943:

Line 958: l_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

954: -- Bug 4699248: Replaced l_spread_curve_name with l_spread_curve_code
955: -- throughout this procedure. Also, updated the type accordingly.
956: l_spread_curve_code PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE;
957:
958: l_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
959:
960: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
961:
962: /* Variables for Bug 4142150 */

Line 982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

978: l_burden_cost_rate_override NUMBER;
979: l_txn_bill_rate_override NUMBER;
980:
981: -- PL/SQL tables to stored planned amounts from existing lines
982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

979: l_txn_bill_rate_override NUMBER;
980:
981: -- PL/SQL tables to stored planned amounts from existing lines
982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

980:
981: -- PL/SQL tables to stored planned amounts from existing lines
982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

981: -- PL/SQL tables to stored planned amounts from existing lines
982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

982: l_upd_plan_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

983: l_upd_plan_txn_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

984: l_upd_plan_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
992:

Line 989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

985: l_upd_plan_proj_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
992:
993: l_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;

Line 990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

986: l_upd_plan_proj_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
992:
993: l_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
994:

Line 991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;

987: l_upd_plan_proj_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
988: l_upd_plan_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
989: l_upd_plan_pfc_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
990: l_upd_plan_pfc_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
991: l_upd_plan_qty_tab PA_PLSQL_DATATYPES.NumTabTyp;
992:
993: l_ret_manual_line_flag PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE;
994:
995: BEGIN

Line 2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2764: GROUP BY ra.resource_assignment_id,
2765: ra.planning_start_date,
2766: ra.planning_end_date;
2767:
2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2765: ra.planning_start_date,
2766: ra.planning_end_date;
2767:
2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2766: ra.planning_end_date;
2767:
2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2767:
2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2775:

Line 2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2768: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2775:
2776: l_end_date_upd_val_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2769: l_plan_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2775:
2776: l_end_date_upd_val_tab PA_PLSQL_DATATYPES.DateTabTyp;
2777:

Line 2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2770: l_plan_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2771: l_plan_period_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2775:
2776: l_end_date_upd_val_tab PA_PLSQL_DATATYPES.DateTabTyp;
2777:
2778: l_upd_flag VARCHAR2(1);

Line 2776: l_end_date_upd_val_tab PA_PLSQL_DATATYPES.DateTabTyp;

2772: l_plan_period_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2773: l_min_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2774: l_max_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2775:
2776: l_end_date_upd_val_tab PA_PLSQL_DATATYPES.DateTabTyp;
2777:
2778: l_upd_flag VARCHAR2(1);
2779: l_start_date DATE;
2780: l_end_date DATE;

Line 2783: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

2779: l_start_date DATE;
2780: l_end_date DATE;
2781: l_count NUMBER := 1;
2782:
2783: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2784: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2785: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2786:
2787: lc_SyncVersion CONSTANT VARCHAR2(30) := 'SYNC_VERSION_LEVEL';

Line 2784: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2780: l_end_date DATE;
2781: l_count NUMBER := 1;
2782:
2783: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2784: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2785: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2786:
2787: lc_SyncVersion CONSTANT VARCHAR2(30) := 'SYNC_VERSION_LEVEL';
2788: lc_CopyActuals CONSTANT VARCHAR2(30) := 'COPY_ACTUALS';

Line 2785: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2781: l_count NUMBER := 1;
2782:
2783: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
2784: l_upd_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2785: l_upd_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2786:
2787: lc_SyncVersion CONSTANT VARCHAR2(30) := 'SYNC_VERSION_LEVEL';
2788: lc_CopyActuals CONSTANT VARCHAR2(30) := 'COPY_ACTUALS';
2789: lc_Commitments CONSTANT VARCHAR2(30) := 'GEN_COMMITMENTS';

Line 3134: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IDTABTYP,

3130: **/
3131: PROCEDURE BLK_UPD_REPORTING_LINES_WRP
3132: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
3133: P_ENTIRE_VERSION_FLAG IN VARCHAR2,
3134: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IDTABTYP,
3135: P_ACTIVITY_CODE IN VARCHAR2,
3136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3137: X_MSG_COUNT OUT NOCOPY NUMBER,
3138: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

3544: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
3545:
3546: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.SYNC_UP_PLANNING_DATES_NONE_TP';
3547:
3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3551: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3552: l_min_start_date DATE ;

Line 3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;

3545:
3546: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.SYNC_UP_PLANNING_DATES_NONE_TP';
3547:
3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3551: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3552: l_min_start_date DATE ;
3553: l_max_end_date DATE;

Line 3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;

3546: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_maintain_actual_pub.SYNC_UP_PLANNING_DATES_NONE_TP';
3547:
3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3551: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3552: l_min_start_date DATE ;
3553: l_max_end_date DATE;
3554:

Line 3551: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

3547:
3548: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3549: l_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3550: l_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3551: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3552: l_min_start_date DATE ;
3553: l_max_end_date DATE;
3554:
3555: l_dummy NUMBER;

Line 3568: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

3564: l_sum_plan_quantity NUMBER;
3565: l_etc_quantity NUMBER;
3566:
3567: l_upd_index NUMBER;
3568: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3569: l_upd_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3570: l_upd_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3571: BEGIN
3572: X_MSG_COUNT := 0;

Line 3569: l_upd_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;

3565: l_etc_quantity NUMBER;
3566:
3567: l_upd_index NUMBER;
3568: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3569: l_upd_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3570: l_upd_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3571: BEGIN
3572: X_MSG_COUNT := 0;
3573: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 3570: l_upd_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;

3566:
3567: l_upd_index NUMBER;
3568: l_upd_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3569: l_upd_planning_start_date_tab pa_plsql_datatypes.DateTabTyp;
3570: l_upd_planning_end_date_tab pa_plsql_datatypes.DateTabTyp;
3571: BEGIN
3572: X_MSG_COUNT := 0;
3573: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3574: