258: -- declare plsql tables to hold values during the funds check process
259: --------------------------------------------------------------------- **/
260: type rowidtabtyp is table of urowid index by binary_integer;
261: g_tab_rowid rowidtabtyp;
262: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
259: --------------------------------------------------------------------- **/
260: type rowidtabtyp is table of urowid index by binary_integer;
261: g_tab_rowid rowidtabtyp;
262: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
260: type rowidtabtyp is table of urowid index by binary_integer;
261: g_tab_rowid rowidtabtyp;
262: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
261: g_tab_rowid rowidtabtyp;
262: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
262: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
263: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
264: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
265: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
266: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
267: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
268: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
269: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
270: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
271: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
272: g_tab_OU pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
273: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
274: g_tab_period_name pa_plsql_datatypes.char50TabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
275: g_tab_time_phase_type_code pa_plsql_datatypes.char50TabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
276: g_tab_amount_type pa_plsql_datatypes.char50TabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
277: g_tab_boundary_code pa_plsql_datatypes.char50TabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
278: g_tab_entry_level_code pa_plsql_datatypes.char50TabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
279: g_tab_category_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
280: g_tab_rlmi pa_plsql_datatypes.IdTabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
281: g_tab_p_resource_id pa_plsql_datatypes.IdTabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
282: g_tab_r_list_id pa_plsql_datatypes.IdTabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
283: g_tab_p_member_id pa_plsql_datatypes.IdTabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
284: g_tab_bud_task_id pa_plsql_datatypes.IdTabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
285: g_tab_bud_rlmi pa_plsql_datatypes.IdTabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
286: g_tab_tt_task_id pa_plsql_datatypes.IdTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
287: g_tab_r_fclevel_code pa_plsql_datatypes.char50TabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
288: g_tab_rg_fclevel_code pa_plsql_datatypes.char50TabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
289: g_tab_t_fclevel_code pa_plsql_datatypes.char50TabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
290: g_tab_tt_fclevel_code pa_plsql_datatypes.char50TabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
291: g_tab_p_fclevel_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
292: g_tab_p_acct_fclevel_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
293: g_tab_burd_cost_flag pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
294: g_tab_pkt_trx_amt pa_plsql_datatypes.NumTabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
295: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
296: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
297: g_tab_PA_amt pa_plsql_datatypes.NumTabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
298: g_tab_PE_amt pa_plsql_datatypes.NumTabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
299: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
300: g_tab_effect_on_funds_code pa_plsql_datatypes.char50TabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
301: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
302: g_tab_r_result_code pa_plsql_datatypes.char50TabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
303: g_tab_rg_result_code pa_plsql_datatypes.char50TabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
304: g_tab_t_result_code pa_plsql_datatypes.char50TabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
305: g_tab_tt_result_code pa_plsql_datatypes.char50TabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
306: g_tab_p_result_code pa_plsql_datatypes.char50TabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
307: g_tab_p_acct_result_code pa_plsql_datatypes.char50TabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
308: g_tab_r_budget_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
309: g_tab_rg_budget_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
310: g_tab_t_budget_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
311: g_tab_tt_budget_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
312: g_tab_p_budget_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
313: g_tab_r_actual_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
314: g_tab_rg_actual_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
315: g_tab_t_actual_posted pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
316: g_tab_tt_actual_posted pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
317: g_tab_p_actual_posted pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
318: g_tab_r_enc_posted pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
319: g_tab_rg_enc_posted pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
320: g_tab_t_enc_posted pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
321: g_tab_tt_enc_posted pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
322: g_tab_p_enc_posted pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
323: g_tab_r_budget_bal pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
324: g_tab_rg_budget_bal pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
325: g_tab_t_budget_bal pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
326: g_tab_tt_budget_bal pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
327: g_tab_p_budget_bal pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
328: g_tab_r_actual_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
329: g_tab_rg_actual_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
330: g_tab_t_actual_approved pa_plsql_datatypes.NumTabTyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
331: g_tab_tt_actual_approved pa_plsql_datatypes.NumTabTyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
332: g_tab_p_actual_approved pa_plsql_datatypes.NumTabTyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
333: g_tab_r_enc_approved pa_plsql_datatypes.NumTabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
334: g_tab_rg_enc_approved pa_plsql_datatypes.NumTabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
335: g_tab_t_enc_approved pa_plsql_datatypes.NumTabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
336: g_tab_tt_enc_approved pa_plsql_datatypes.NumTabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
337: g_tab_p_enc_approved pa_plsql_datatypes.NumTabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
338: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
339: g_tab_budget_ccid pa_plsql_datatypes.Idtabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
340: g_tab_old_budget_ccid pa_plsql_datatypes.Idtabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
341: g_tab_effect_fclevel pa_plsql_datatypes.char50TabTyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
342: g_tab_exp_category pa_plsql_datatypes.char50TabTyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
343: g_tab_rev_category pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
344: g_tab_sys_link_func pa_plsql_datatypes.char50TabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
345: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
346: g_tab_gl_date pa_plsql_datatypes.Datetabtyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
347: g_tab_pa_date pa_plsql_datatypes.Datetabtyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
348: g_tab_start_date pa_plsql_datatypes.Datetabtyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
349: g_tab_end_date pa_plsql_datatypes.Datetabtyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
350: g_tab_encum_type_id pa_plsql_datatypes.Idtabtyp;
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
351: g_tab_process_funds_level pa_plsql_datatypes.char50TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
352: g_tab_res_level_cache_amt pa_plsql_datatypes.NumTabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
353: g_tab_res_grp_level_cache_amt pa_plsql_datatypes.NumTabTyp;
354: g_tab_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
355: g_tab_top_task_level_cache_amt pa_plsql_datatypes.NumTabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
356: g_tab_proj_level_cache_amt pa_plsql_datatypes.NumTabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
357: g_tab_prj_acct_level_cache_amt pa_plsql_datatypes.NumTabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
358: /* Bug 9750534: Modified the below cache global variables from Char50TabTyp to Char100TabTyp */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
359: g_tab_res_level_cache pa_plsql_datatypes.char100TabTyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
360: g_tab_res_grp_level_cache pa_plsql_datatypes.char100TabTyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
361: g_tab_task_level_cache pa_plsql_datatypes.char100TabTyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
362: g_tab_top_task_level_cache pa_plsql_datatypes.char100TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
363: g_tab_proj_level_cache pa_plsql_datatypes.char100TabTyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
364: g_tab_proj_acct_level_cache pa_plsql_datatypes.char100TabTyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
365: g_tab_tieback_id pa_plsql_datatypes.char250TabTyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
366: g_tab_group_resource_type_id pa_plsql_datatypes.NumTabTyp; /* bug fix 2658952 */
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
367: g_tab_person_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
368: g_tab_job_id pa_plsql_datatypes.Idtabtyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
369: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
370: g_tab_non_lab_res pa_plsql_datatypes.char250TabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
371: g_tab_non_lab_res_org pa_plsql_datatypes.Idtabtyp;
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
372: g_tab_non_cat_rlmi pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
373: g_tab_proj_OU pa_plsql_datatypes.Idtabtyp;
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
374: g_tab_exp_OU pa_plsql_datatypes.Idtabtyp;
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
382: /* Bug 5631763 */
375: g_tab_doc_line_id pa_plsql_datatypes.Idtabtyp;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
376: g_tab_ext_bdgt_link pa_plsql_datatypes.char50TabTyp;
377: g_tab_sob_id pa_plsql_datatypes.Idtabtyp;
378: g_tab_exp_gl_date pa_plsql_datatypes.DateTabTyp;
379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
387: /* Bug 5631763 */
388:
389: -- Added for R12 ...
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
387: /* Bug 5631763 */
388:
389: -- Added for R12 ...
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
395: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
388:
389: -- Added for R12 ...
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
395: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
396: g_packet_credit_processed Varchar2(1);
389: -- Added for R12 ...
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
395: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
396: g_packet_credit_processed Varchar2(1);
397: g_packet_debit_processed Varchar2(1);
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
395: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
396: g_packet_credit_processed Varchar2(1);
397: g_packet_debit_processed Varchar2(1);
398:
391: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
392: g_tab_src_dist_id_num_1 pa_plsql_datatypes.Idtabtyp;
393: g_tab_gl_bc_event_id pa_plsql_datatypes.Idtabtyp;
394: g_tab_src_dist_type pa_plsql_datatypes.char50TabTyp;
395: g_tab_allow_flag pa_plsql_datatypes.Char1TabTyp;
396: g_packet_credit_processed Varchar2(1);
397: g_packet_debit_processed Varchar2(1);
398:
399:
1259: bc_packet_id
1260: FROM pa_bc_packets
1261: WHERE packet_id = p_packet_id;
1262:
1263: l_tab_packet_id pa_plsql_datatypes.idtabtyp;
1264: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp; */
1265:
1266: PRAGMA AUTONOMOUS_TRANSACTION;
1267:
1260: FROM pa_bc_packets
1261: WHERE packet_id = p_packet_id;
1262:
1263: l_tab_packet_id pa_plsql_datatypes.idtabtyp;
1264: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp; */
1265:
1266: PRAGMA AUTONOMOUS_TRANSACTION;
1267:
1268: BEGIN
5633:
5634: -- funds check will be done based on document_type and
5635: -- document_header_id. hence a batch of 100 EIS will be processed
5636: -- once.( if burden on diff item leades to 300 eis approximatly).
5637: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5638: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5639: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5640: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5641: l_num_rows NUMBER := 200;
5634: -- funds check will be done based on document_type and
5635: -- document_header_id. hence a batch of 100 EIS will be processed
5636: -- once.( if burden on diff item leades to 300 eis approximatly).
5637: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5638: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5639: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5640: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5641: l_num_rows NUMBER := 200;
5642: cursor cur_docs is
5635: -- document_header_id. hence a batch of 100 EIS will be processed
5636: -- once.( if burden on diff item leades to 300 eis approximatly).
5637: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5638: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5639: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5640: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5641: l_num_rows NUMBER := 200;
5642: cursor cur_docs is
5643: SELECT document_type,
5636: -- once.( if burden on diff item leades to 300 eis approximatly).
5637: l_tab_doc_type pa_plsql_datatypes.char50tabtyp;
5638: l_tab_effect_fc_level pa_plsql_datatypes.char50tabtyp;
5639: l_tab_doc_header_id pa_plsql_datatypes.idtabtyp;
5640: l_tab_bc_packet_id pa_plsql_datatypes.idtabtyp;
5641: l_num_rows NUMBER := 200;
5642: cursor cur_docs is
5643: SELECT document_type,
5644: document_header_id
7684: l_cache_non_cat_bdgt_ver_id Number;
7685: l_cache_non_cat_result_code VARCHAR2(30);
7686: l_fc_utils2_cwk_rlmi NUMBER;
7687:
7688: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7689: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7690: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7691: ----------------------------------------------------------------------------------------
7692: -- If resource list is setup without resource groups and the
7685: l_cache_non_cat_result_code VARCHAR2(30);
7686: l_fc_utils2_cwk_rlmi NUMBER;
7687:
7688: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7689: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7690: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7691: ----------------------------------------------------------------------------------------
7692: -- If resource list is setup without resource groups and the
7693: -- resources are setup as expenditure categories, Funds check
7686: l_fc_utils2_cwk_rlmi NUMBER;
7687:
7688: l_tab_resmap_list_id PA_PLSQL_DATATYPES.IDTABTYP;
7689: l_tab_resmap_project_id PA_PLSQL_DATATYPES.IDTABTYP;
7690: l_tab_resmap_pkt_line_type PA_PLSQL_DATATYPES.CHAR50TABTYP;
7691: ----------------------------------------------------------------------------------------
7692: -- If resource list is setup without resource groups and the
7693: -- resources are setup as expenditure categories, Funds check
7694: -- fail due to a resource mapping error.
10060: ORDER BY document_header_id,document_distribution_id,bc_packet_id;
10061:
10062: l_pre_exp_item_id NUMBER := null;
10063: l_num_rows NUMBER := 200;
10064: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
10065: l_warn_code varchar2(30);
10066: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
10067: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
10068: j NUMBER;
10062: l_pre_exp_item_id NUMBER := null;
10063: l_num_rows NUMBER := 200;
10064: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
10065: l_warn_code varchar2(30);
10066: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
10067: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
10068: j NUMBER;
10069: l_doc_header_id pa_bc_packets.document_header_id%type;
10070: l_pre_project_id pa_bc_packets.project_id%type := null;
10063: l_num_rows NUMBER := 200;
10064: l_tab_dist_warn_code pa_plsql_datatypes.char25tabtyp;
10065: l_warn_code varchar2(30);
10066: l_tab_warning_code pa_plsql_datatypes.char25tabtyp;
10067: l_tab_ext_bdgt_flag pa_plsql_datatypes.char25tabtyp;
10068: j NUMBER;
10069: l_doc_header_id pa_bc_packets.document_header_id%type;
10070: l_pre_project_id pa_bc_packets.project_id%type := null;
10071: l_count NUMBER;
14865: -- --------------------------------------------------------------------------------+
14866: PROCEDURE Do_budget_baseline_tieback(p_packet_id IN NUMBER,
14867: p_return_status OUT NOCOPY VARCHAR2)
14868: IS
14869: t_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14866: PROCEDURE Do_budget_baseline_tieback(p_packet_id IN NUMBER,
14867: p_return_status OUT NOCOPY VARCHAR2)
14868: IS
14869: t_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14867: p_return_status OUT NOCOPY VARCHAR2)
14868: IS
14869: t_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14868: IS
14869: t_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14869: t_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14870: t_bud_ccid pa_plsql_datatypes.Idtabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14871: t_budget_line_id pa_plsql_datatypes.Idtabtyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14872: t_rlmi pa_plsql_datatypes.Idtabtyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14873: t_parent_rlmi pa_plsql_datatypes.Idtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14881: t_draft_budget_rowid rowidtabtyp;
14874: t_project_id pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14881: t_draft_budget_rowid rowidtabtyp;
14882: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14875: t_task_id pa_plsql_datatypes.Idtabtyp;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14881: t_draft_budget_rowid rowidtabtyp;
14882: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14883: t_raid TypeNum;
14876: t_top_task_id pa_plsql_datatypes.Idtabtyp;
14877: t_prev_ver_ccid pa_plsql_datatypes.Idtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14881: t_draft_budget_rowid rowidtabtyp;
14882: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14883: t_raid TypeNum;
14884: t_gl_rowid rowidtabtyp;
14878: t_start_date pa_plsql_datatypes.Datetabtyp;
14879: t_txn_currency_code pa_plsql_datatypes.char50TabTyp;
14880: t_draft_needs_update pa_plsql_datatypes.char50TabTyp;
14881: t_draft_budget_rowid rowidtabtyp;
14882: t_draft_ccid pa_plsql_datatypes.Idtabtyp;
14883: t_raid TypeNum;
14884: t_gl_rowid rowidtabtyp;
14885: t_budget_rowid rowidtabtyp;
14886: t_budget_start_date TypeDate;
16730: X_budget_amount_code IN VARCHAR2,
16731: X_prev_budget_version_id IN NUMBER,
16732: X_mode IN VARCHAR2)
16733: IS
16734: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16735: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16736: tt_result_code pa_plsql_datatypes.char50TabTyp;
16737: PRAGMA AUTONOMOUS_TRANSACTION;
16738: Begin
16731: X_prev_budget_version_id IN NUMBER,
16732: X_mode IN VARCHAR2)
16733: IS
16734: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16735: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16736: tt_result_code pa_plsql_datatypes.char50TabTyp;
16737: PRAGMA AUTONOMOUS_TRANSACTION;
16738: Begin
16739: If g_debug_mode = 'Y' then
16732: X_mode IN VARCHAR2)
16733: IS
16734: tt_gl_period_name pa_plsql_datatypes.char50TabTyp;
16735: tt_code_combination_id pa_plsql_datatypes.IdTabTyp;
16736: tt_result_code pa_plsql_datatypes.char50TabTyp;
16737: PRAGMA AUTONOMOUS_TRANSACTION;
16738: Begin
16739: If g_debug_mode = 'Y' then
16740: log_message(p_msg_token1=>'Build_account_summary_auto:Start:X_mode:'||X_mode);