257: -- declare plsql tables to hold values during the funds check process
258: --------------------------------------------------------------------- **/
259: type rowidtabtyp is table of urowid index by binary_integer;
260: g_tab_rowid rowidtabtyp;
261: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
258: --------------------------------------------------------------------- **/
259: type rowidtabtyp is table of urowid index by binary_integer;
260: g_tab_rowid rowidtabtyp;
261: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
259: type rowidtabtyp is table of urowid index by binary_integer;
260: g_tab_rowid rowidtabtyp;
261: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
260: g_tab_rowid rowidtabtyp;
261: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
261: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
262: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
264: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
265: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
266: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
267: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
268: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
269: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
270: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
271: g_tab_OU pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
272: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
273: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
274: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
275: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
276: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
277: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
278: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
281: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
282: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
283: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
284: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
285: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
286: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
287: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
288: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
289: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
290: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
294: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
295: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
296: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
297: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
298: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
300: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
301: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
302: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
303: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
304: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
305: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
306: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
307: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
315: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
316: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
317: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
318: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
319: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
320: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
321: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
322: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
323: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
324: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
325: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
326: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
327: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
330: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
331: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
332: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
333: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
334: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
335: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
336: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
337: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
338: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
339: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
340: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
341: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
342: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
343: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
344: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
345: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
346: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
347: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
348: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
349: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
350: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
351: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
353: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
354: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
355: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
356: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
357: g_tab_res_level_cache pa_plsql_datatypes.char50TabTyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
358: g_tab_res_grp_level_cache pa_plsql_datatypes.char50TabTyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
359: g_tab_task_level_cache pa_plsql_datatypes.char50TabTyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
360: g_tab_top_task_level_cache pa_plsql_datatypes.char50TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
361: g_tab_proj_level_cache pa_plsql_datatypes.char50TabTyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
362: g_tab_proj_acct_level_cache pa_plsql_datatypes.char50TabTyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
363: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
364: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
365: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
366: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
367: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
369: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
371: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
379: /* Bug 5631763 */
372: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
373: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
374: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
375: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
377: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
378:
379: /* Bug 5631763 */
380: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
381: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
383: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
384: /* Bug 5631763 */
385:
386: -- Added for R12 ...
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
384: /* Bug 5631763 */
385:
386: -- Added for R12 ...
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
392: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
385:
386: -- Added for R12 ...
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
392: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
393: g_packet_credit_processed Varchar2(1);
386: -- Added for R12 ...
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
392: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
393: g_packet_credit_processed Varchar2(1);
394: g_packet_debit_processed Varchar2(1);
387: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
392: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
393: g_packet_credit_processed Varchar2(1);
394: g_packet_debit_processed Varchar2(1);
395:
388: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
389: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
390: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
391: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
392: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
393: g_packet_credit_processed Varchar2(1);
394: g_packet_debit_processed Varchar2(1);
395:
396:
1255: bc_packet_id
1256: FROM pa_bc_packets
1257: WHERE packet_id = p_packet_id;
1258:
1259: l_tab_packet_id pa_plsql_datatypes.idtabtyp;
1260: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
1261:
1262: PRAGMA AUTONOMOUS_TRANSACTION;
1263:
1256: FROM pa_bc_packets
1257: WHERE packet_id = p_packet_id;
1258:
1259: l_tab_packet_id pa_plsql_datatypes.idtabtyp;
1260: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
1261:
1262: PRAGMA AUTONOMOUS_TRANSACTION;
1263:
1264: BEGIN
5496:
5497: -- funds check will be done based on document_type and
5498: -- document_header_id. hence a batch of 100 EIS will be processed
5499: -- once.( if burden on diff item leades to 300 eis approximatly).
5500: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5501: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5502: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5503: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5504: l_num_rows NUMBER := 200;
5497: -- funds check will be done based on document_type and
5498: -- document_header_id. hence a batch of 100 EIS will be processed
5499: -- once.( if burden on diff item leades to 300 eis approximatly).
5500: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5501: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5502: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5503: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5504: l_num_rows NUMBER := 200;
5505: cursor cur_docs is
5498: -- document_header_id. hence a batch of 100 EIS will be processed
5499: -- once.( if burden on diff item leades to 300 eis approximatly).
5500: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5501: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5502: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5503: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5504: l_num_rows NUMBER := 200;
5505: cursor cur_docs is
5506: SELECT document_type,
5499: -- once.( if burden on diff item leades to 300 eis approximatly).
5500: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5501: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5502: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5503: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5504: l_num_rows NUMBER := 200;
5505: cursor cur_docs is
5506: SELECT document_type,
5507: document_header_id
7486: l_cache_non_cat_bdgt_ver_id Number;
7487: l_cache_non_cat_result_code VARCHAR2(30);
7488: l_fc_utils2_cwk_rlmi NUMBER;
7489:
7490: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7491: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7492: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7493: ----------------------------------------------------------------------------------------
7494: -- If resource list is setup without resource groups and the
7487: l_cache_non_cat_result_code VARCHAR2(30);
7488: l_fc_utils2_cwk_rlmi NUMBER;
7489:
7490: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7491: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7492: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7493: ----------------------------------------------------------------------------------------
7494: -- If resource list is setup without resource groups and the
7495: -- resources are setup as expenditure categories, Funds check
7488: l_fc_utils2_cwk_rlmi NUMBER;
7489:
7490: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7491: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7492: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7493: ----------------------------------------------------------------------------------------
7494: -- If resource list is setup without resource groups and the
7495: -- resources are setup as expenditure categories, Funds check
7496: -- fail due to a resource mapping error.
9807: ORDER BY document_header_id,document_distribution_id,bc_packet_id;
9808:
9809: l_pre_exp_item_id NUMBER := null;
9810: l_num_rows NUMBER := 200;
9811: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
9812: l_warn_code varchar2(30);
9813: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
9814: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
9815: j NUMBER;
9809: l_pre_exp_item_id NUMBER := null;
9810: l_num_rows NUMBER := 200;
9811: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
9812: l_warn_code varchar2(30);
9813: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
9814: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
9815: j NUMBER;
9816: l_doc_header_id pa_bc_packets.document_header_id%type;
9817: l_pre_project_id pa_bc_packets.project_id%type := null;
9810: l_num_rows NUMBER := 200;
9811: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
9812: l_warn_code varchar2(30);
9813: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
9814: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
9815: j NUMBER;
9816: l_doc_header_id pa_bc_packets.document_header_id%type;
9817: l_pre_project_id pa_bc_packets.project_id%type := null;
9818: l_count NUMBER;
14443: -- --------------------------------------------------------------------------------+
14444: PROCEDURE Do_budget_baseline_tieback(p_packet_id IN NUMBER,
14445: p_return_status OUT NOCOPY VARCHAR2)
14446: IS
14447: t_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14444: PROCEDURE Do_budget_baseline_tieback(p_packet_id IN NUMBER,
14445: p_return_status OUT NOCOPY VARCHAR2)
14446: IS
14447: t_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14445: p_return_status OUT NOCOPY VARCHAR2)
14446: IS
14447: t_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14446: IS
14447: t_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14447: t_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14448: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14449: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14450: t_rlmi pa_plsql_datatypes.Idtabtyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14451: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14459: t_draft_budget_rowid rowidtabtyp;
14452: t_project_id pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14459: t_draft_budget_rowid rowidtabtyp;
14460: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14453: t_task_id pa_plsql_datatypes.Idtabtyp;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14459: t_draft_budget_rowid rowidtabtyp;
14460: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14461: t_raid TypeNum;
14454: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14455: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14459: t_draft_budget_rowid rowidtabtyp;
14460: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14461: t_raid TypeNum;
14462: t_gl_rowid rowidtabtyp;
14456: t_start_date pa_plsql_datatypes.Datetabtyp;
14457: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14458: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14459: t_draft_budget_rowid rowidtabtyp;
14460: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14461: t_raid TypeNum;
14462: t_gl_rowid rowidtabtyp;
14463: t_budget_rowid rowidtabtyp;
14464: t_budget_start_date TypeDate;
16299: X_budget_amount_code IN VARCHAR2,
16300: X_prev_budget_version_id IN NUMBER,
16301: X_mode IN VARCHAR2)
16302: IS
16303: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16304: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16305: tt_result_code pa_plsql_datatypes.char50TabTyp;
16306: PRAGMA AUTONOMOUS_TRANSACTION;
16307: Begin
16300: X_prev_budget_version_id IN NUMBER,
16301: X_mode IN VARCHAR2)
16302: IS
16303: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16304: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16305: tt_result_code pa_plsql_datatypes.char50TabTyp;
16306: PRAGMA AUTONOMOUS_TRANSACTION;
16307: Begin
16308: If g_debug_mode = 'Y' then
16301: X_mode IN VARCHAR2)
16302: IS
16303: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16304: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16305: tt_result_code pa_plsql_datatypes.char50TabTyp;
16306: PRAGMA AUTONOMOUS_TRANSACTION;
16307: Begin
16308: If g_debug_mode = 'Y' then
16309: log_message(p_msg_token1=>'Build_account_summary_auto:Start:X_mode:'||X_mode);