35:
36: ---------------------------------------------------------------------------------
37: -- declare plsql tables to hold values during the funds check process
38: ---------------------------------------------------------------------
39: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
36: ---------------------------------------------------------------------------------
37: -- declare plsql tables to hold values during the funds check process
38: ---------------------------------------------------------------------
39: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
37: -- declare plsql tables to hold values during the funds check process
38: ---------------------------------------------------------------------
39: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
38: ---------------------------------------------------------------------
39: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
39: g_tab_budget_version_id pa_plsql_datatypes.IdTabTyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
40: g_tab_budget_line_id pa_plsql_datatypes.IdTabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
41: g_tab_budget_ccid pa_plsql_datatypes.NumTabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
42: g_tab_project_id pa_plsql_datatypes.IdTabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
43: g_tab_task_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
44: g_tab_exp_type pa_plsql_datatypes.char50TabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
45: g_tab_exp_org_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
46: g_tab_exp_item_date pa_plsql_datatypes.DateTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
47: g_tab_set_of_books_id pa_plsql_datatypes.Idtabtyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
48: g_tab_je_source_name pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
49: g_tab_je_category_name pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
50: g_tab_doc_type pa_plsql_datatypes.Char50TabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
51: g_tab_doc_header_id pa_plsql_datatypes.IdTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
52: g_tab_doc_line_id pa_plsql_datatypes.IdTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
53: g_tab_doc_distribution_id pa_plsql_datatypes.IdTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
54: g_tab_inv_distribution_id pa_plsql_datatypes.IdTabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
55: g_tab_actual_flag pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
56: g_tab_result_code pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
57: g_tab_status_code pa_plsql_datatypes.char50TabTyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
65: g_tab_org_id pa_plsql_datatypes.Idtabtyp;
58: g_tab_entered_dr pa_plsql_datatypes.NumTabTyp;
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
65: g_tab_org_id pa_plsql_datatypes.Idtabtyp;
66:
59: g_tab_entered_cr pa_plsql_datatypes.NumTabTyp;
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
65: g_tab_org_id pa_plsql_datatypes.Idtabtyp;
66:
67: -------->6599207 ------As part of CC Enhancements
60: g_tab_accounted_dr pa_plsql_datatypes.NumTabTyp;
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
65: g_tab_org_id pa_plsql_datatypes.Idtabtyp;
66:
67: -------->6599207 ------As part of CC Enhancements
68: ------------------------------------------------------------------------
61: g_tab_accounted_cr pa_plsql_datatypes.NumTabTyp;
62: g_tab_balance_posted_flag pa_plsql_datatypes.char50TabTyp;
63: g_tab_funds_process_mode pa_plsql_datatypes.char50TabTyp;
64: g_tab_burden_cost_flag pa_plsql_datatypes.char50TabTyp;
65: g_tab_org_id pa_plsql_datatypes.Idtabtyp;
66:
67: -------->6599207 ------As part of CC Enhancements
68: ------------------------------------------------------------------------
69: /* Added the following Global Variables which are used in
68: ------------------------------------------------------------------------
69: /* Added the following Global Variables which are used in
70: populate_plsql_tabs_CBC, create_CBC_pkt_lines */
71: ------------------------------------------------------------------------
72: g_tab_reference1 pa_plsql_datatypes.char80TabTyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
69: /* Added the following Global Variables which are used in
70: populate_plsql_tabs_CBC, create_CBC_pkt_lines */
71: ------------------------------------------------------------------------
72: g_tab_reference1 pa_plsql_datatypes.char80TabTyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
70: populate_plsql_tabs_CBC, create_CBC_pkt_lines */
71: ------------------------------------------------------------------------
72: g_tab_reference1 pa_plsql_datatypes.char80TabTyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
71: ------------------------------------------------------------------------
72: g_tab_reference1 pa_plsql_datatypes.char80TabTyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
72: g_tab_reference1 pa_plsql_datatypes.char80TabTyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
73: g_tab_reference2 pa_plsql_datatypes.char80TabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
74: g_tab_reference3 pa_plsql_datatypes.char80TabTyp;
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
82: ------------------------------------------------------------------------
75: g_tab_period_year pa_plsql_datatypes.NumTabTyp;
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
82: ------------------------------------------------------------------------
83: -------->6599207 ------END
76: g_tab_period_num pa_plsql_datatypes.NumTabTyp;
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
82: ------------------------------------------------------------------------
83: -------->6599207 ------END
84:
77: g_tab_reference5 pa_plsql_datatypes.char80TabTyp;
78: g_tab_reference4 pa_plsql_datatypes.char80TabTyp;
79: g_tab_rowid pa_plsql_datatypes.RowidTabTyp;
80: g_tab_last_update_date pa_plsql_datatypes.datetabtyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
82: ------------------------------------------------------------------------
83: -------->6599207 ------END
84:
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
81: g_tab_last_updated_by pa_plsql_datatypes.NumTabTyp;
82: ------------------------------------------------------------------------
83: -------->6599207 ------END
84:
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
82: ------------------------------------------------------------------------
83: -------->6599207 ------END
84:
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
83: -------->6599207 ------END
84:
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
84:
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
85: g_tab_pkt_reference1 pa_plsql_datatypes.char80TabTyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
86: g_tab_pkt_reference2 pa_plsql_datatypes.char80TabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
87: g_tab_pkt_reference3 pa_plsql_datatypes.char80TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
88: g_tab_event_id pa_plsql_datatypes.Idtabtyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
89: g_tab_vendor_id pa_plsql_datatypes.Idtabtyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
90: g_tab_burden_method_code pa_plsql_datatypes.char30TabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
91: g_tab_main_or_backing_code pa_plsql_datatypes.char30TabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
92: g_tab_source_event_id pa_plsql_datatypes.Idtabtyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
93: g_tab_trxn_ccid pa_plsql_datatypes.Idtabtyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
94: g_tab_p_bc_packet_id pa_plsql_datatypes.IdTabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
95: g_tab_fck_reqd_flag pa_plsql_datatypes.char50TabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
96: g_tab_ap_quantity_variance pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
97: g_tab_ap_amount_variance pa_plsql_datatypes.NumTabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
98: g_tab_ap_base_qty_variance pa_plsql_datatypes.NumTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
99: g_tab_ap_base_amount_variance pa_plsql_datatypes.NumTabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
100: g_tab_ap_po_distribution_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
101: g_tab_gl_date pa_plsql_datatypes.DateTabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
102: g_tab_period_name pa_plsql_datatypes.char15TabTyp;
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
103: g_tab_entered_amount pa_plsql_datatypes.NumTabTyp;
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
104: g_tab_accted_amount pa_plsql_datatypes.NumTabTyp;
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
105: g_tab_event_type_code pa_plsql_datatypes.char30TabTyp;
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
106: g_tab_po_release_id pa_plsql_datatypes.IdTabTyp;
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
114: -- Bug 5403775 : Added below columns to derive pa bc pkts reference columns for PO backing docs
107: g_tab_distribution_type pa_plsql_datatypes.char30TabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
114: -- Bug 5403775 : Added below columns to derive pa bc pkts reference columns for PO backing docs
115: g_tab_orig_sequence_num pa_plsql_datatypes.NumTabTyp;
108: g_tab_enc_type_id pa_plsql_datatypes.IdTabTyp;
109: g_line_type_lookup_code pa_plsql_datatypes.char30TabTyp;
110: g_tab_rate pa_plsql_datatypes.NumTabTyp; -- Bug 5665232
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
114: -- Bug 5403775 : Added below columns to derive pa bc pkts reference columns for PO backing docs
115: g_tab_orig_sequence_num pa_plsql_datatypes.NumTabTyp;
116: g_tab_applied_to_dist_id_2 pa_plsql_datatypes.NumTabTyp;
111: g_tab_bc_packet_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
114: -- Bug 5403775 : Added below columns to derive pa bc pkts reference columns for PO backing docs
115: g_tab_orig_sequence_num pa_plsql_datatypes.NumTabTyp;
116: g_tab_applied_to_dist_id_2 pa_plsql_datatypes.NumTabTyp;
117:
118: -- Bug 5169409 : R12 Funds management Uptake : This nested table introduced
119: -- in patype01.sql
112: g_tab_parent_reversal_id pa_plsql_datatypes.IdTabTyp; -- Bug 5406690
113:
114: -- Bug 5403775 : Added below columns to derive pa bc pkts reference columns for PO backing docs
115: g_tab_orig_sequence_num pa_plsql_datatypes.NumTabTyp;
116: g_tab_applied_to_dist_id_2 pa_plsql_datatypes.NumTabTyp;
117:
118: -- Bug 5169409 : R12 Funds management Uptake : This nested table introduced
119: -- in patype01.sql
120: g_ap_inv_dist_id T_PROJ_BC_AP_DIST := T_PROJ_BC_AP_DIST();
117:
118: -- Bug 5169409 : R12 Funds management Uptake : This nested table introduced
119: -- in patype01.sql
120: g_ap_inv_dist_id T_PROJ_BC_AP_DIST := T_PROJ_BC_AP_DIST();
121: g_ap_line_type_lkup pa_plsql_datatypes.char30TabTyp;
122:
123: -- Bug : 3703180 changes.
124: g_cwk_po_unreserve varchar2(1) ;
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
121: g_ap_line_type_lkup pa_plsql_datatypes.char30TabTyp;
122:
123: -- Bug : 3703180 changes.
124: g_cwk_po_unreserve varchar2(1) ;
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
126: g_bdamt_balance_tab pa_plsql_datatypes.NumTabTyp;
127: g_project_id_tab pa_plsql_datatypes.IdTabTyp ;
128: g_task_id_tab pa_plsql_datatypes.IdTabTyp ;
129: g_burden_type_tab pa_plsql_datatypes.char15TabTyp;
122:
123: -- Bug : 3703180 changes.
124: g_cwk_po_unreserve varchar2(1) ;
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
126: g_bdamt_balance_tab pa_plsql_datatypes.NumTabTyp;
127: g_project_id_tab pa_plsql_datatypes.IdTabTyp ;
128: g_task_id_tab pa_plsql_datatypes.IdTabTyp ;
129: g_burden_type_tab pa_plsql_datatypes.char15TabTyp;
130:
123: -- Bug : 3703180 changes.
124: g_cwk_po_unreserve varchar2(1) ;
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
126: g_bdamt_balance_tab pa_plsql_datatypes.NumTabTyp;
127: g_project_id_tab pa_plsql_datatypes.IdTabTyp ;
128: g_task_id_tab pa_plsql_datatypes.IdTabTyp ;
129: g_burden_type_tab pa_plsql_datatypes.char15TabTyp;
130:
131: --------------------------------------------------------------------------
124: g_cwk_po_unreserve varchar2(1) ;
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
126: g_bdamt_balance_tab pa_plsql_datatypes.NumTabTyp;
127: g_project_id_tab pa_plsql_datatypes.IdTabTyp ;
128: g_task_id_tab pa_plsql_datatypes.IdTabTyp ;
129: g_burden_type_tab pa_plsql_datatypes.char15TabTyp;
130:
131: --------------------------------------------------------------------------
132: -- This api initializes the pl/sql tables
125: g_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
126: g_bdamt_balance_tab pa_plsql_datatypes.NumTabTyp;
127: g_project_id_tab pa_plsql_datatypes.IdTabTyp ;
128: g_task_id_tab pa_plsql_datatypes.IdTabTyp ;
129: g_burden_type_tab pa_plsql_datatypes.char15TabTyp;
130:
131: --------------------------------------------------------------------------
132: -- This api initializes the pl/sql tables
133: --------------------------------------------------------------------------
4441: l_pkt_reference1 varchar2(100);
4442: l_pkt_reference2 varchar2(100);
4443: l_pkt_reference3 varchar2(100);
4444: /* Bug 3703180 **/
4445: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4442: l_pkt_reference2 varchar2(100);
4443: l_pkt_reference3 varchar2(100);
4444: /* Bug 3703180 **/
4445: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4443: l_pkt_reference3 varchar2(100);
4444: /* Bug 3703180 **/
4445: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4444: /* Bug 3703180 **/
4445: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4445: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4446: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4454: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4447: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4454: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4455: l_cr_amount number ;
4448: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4454: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4455: l_cr_amount number ;
4456: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4449: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4454: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4455: l_cr_amount number ;
4456: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4457:
4450: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4451: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4452: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4453: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4454: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4455: l_cr_amount number ;
4456: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4457:
4458: -- R12 Funds management uptake: commented CBC related code
4471: where packet_id = p_packet_id
4472: and document_type <> 'PO') ;
4473:
4474: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4475: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4476: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4477: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4478: PRAGMA AUTONOMOUS_TRANSACTION;
4479: begin
4472: and document_type <> 'PO') ;
4473:
4474: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4475: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4476: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4477: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4478: PRAGMA AUTONOMOUS_TRANSACTION;
4479: begin
4480: FORALL i IN p_bc_packet_id_tab.first .. p_bc_packet_id_tab.last
4473:
4474: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4475: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4476: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4477: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4478: PRAGMA AUTONOMOUS_TRANSACTION;
4479: begin
4480: FORALL i IN p_bc_packet_id_tab.first .. p_bc_packet_id_tab.last
4481: update pa_bc_packets
5135: l_doc_line_id NUMBER ;
5136: l_bdamt_balance NUMBER ;
5137: l_index NUMBER ;
5138: l_cr_amount NUMBER ;
5139: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5136: l_bdamt_balance NUMBER ;
5137: l_index NUMBER ;
5138: l_cr_amount NUMBER ;
5139: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5144: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
5137: l_index NUMBER ;
5138: l_cr_amount NUMBER ;
5139: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5144: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
5145:
5138: l_cr_amount NUMBER ;
5139: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5144: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
5145:
5146: BEGIN
5139: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5144: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
5145:
5146: BEGIN
5147:
5140: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
5141: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
5142: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
5143: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
5144: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
5145:
5146: BEGIN
5147:
5148:
5435: l_max_packet_id NUMBER ;
5436: l_max_packet_id_b NUMBER ;
5437: l_amount NUMBER ;
5438: l_prev_multiplier varchar2(1) ;
5439: l_tab_multiplier pa_plsql_datatypes.NumTabTyp ;
5440: l_tab_icc_exp_type pa_plsql_datatypes.char50TabTyp;
5441: l_doc_header_id pa_bc_packets.document_header_id%TYPE ;
5442: l_doc_distribution_id pa_bc_packets.document_distribution_id%TYPE ;
5443:
5436: l_max_packet_id_b NUMBER ;
5437: l_amount NUMBER ;
5438: l_prev_multiplier varchar2(1) ;
5439: l_tab_multiplier pa_plsql_datatypes.NumTabTyp ;
5440: l_tab_icc_exp_type pa_plsql_datatypes.char50TabTyp;
5441: l_doc_header_id pa_bc_packets.document_header_id%TYPE ;
5442: l_doc_distribution_id pa_bc_packets.document_distribution_id%TYPE ;
5443:
5444: /* Commented as part of Bug 5406690
8248: P_request_id IN NUMBER ,
8249: x_result_code OUT NOCOPY VARCHAR2) IS
8250:
8251: -- Variables to store eligible CDL data
8252: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8249: x_result_code OUT NOCOPY VARCHAR2) IS
8250:
8251: -- Variables to store eligible CDL data
8252: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8250:
8251: -- Variables to store eligible CDL data
8252: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8251: -- Variables to store eligible CDL data
8252: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8252: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8253: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8261: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8254: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8261: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8262: l_count_of_records NUMBER;
8255: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8261: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8262: l_count_of_records NUMBER;
8263: l_Return_Status VARCHAR2(100);
8256: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8261: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8262: l_count_of_records NUMBER;
8263: l_Return_Status VARCHAR2(100);
8264: l_Msg_Data VARCHAR2(2000);
8257: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8258: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
8259: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8260: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8261: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8262: l_count_of_records NUMBER;
8263: l_Return_Status VARCHAR2(100);
8264: l_Msg_Data VARCHAR2(2000);
8265:
8263: l_Return_Status VARCHAR2(100);
8264: l_Msg_Data VARCHAR2(2000);
8265:
8266: -- Below variables added for bug 5263721
8267: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8264: l_Msg_Data VARCHAR2(2000);
8265:
8266: -- Below variables added for bug 5263721
8267: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8265:
8266: -- Below variables added for bug 5263721
8267: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8266: -- Below variables added for bug 5263721
8267: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8267: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8268: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8269: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8270: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8271: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8272: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8273: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8274: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8275: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8276: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8277: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8278: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8279: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8280: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8281: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8282: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8283: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8284: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8285: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8286: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8287: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8288: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8289: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8290: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8291: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8292: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8293: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8294: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8295: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8296: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8297: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8298: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8306: -- Bug 5680236 : Added below new variables
8299: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8300: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8301: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8302: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8303: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8304: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8305:
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8305:
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8306: -- Bug 5680236 : Added below new variables
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8307: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8308: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8309: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8310: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8311: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8312:
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8313: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8314: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8315: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8316: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8324:
8317: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8324:
8325: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
8318: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8324:
8325: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
8326: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8319: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8320: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8321: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
8322: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
8323: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
8324:
8325: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
8326: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8327: l_cdl_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;