[Home] [Help]
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: --------------------------------------------------------------------------
4156: l_pkt_reference1 varchar2(100);
4157: l_pkt_reference2 varchar2(100);
4158: l_pkt_reference3 varchar2(100);
4159: /* Bug 3703180 **/
4160: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4157: l_pkt_reference2 varchar2(100);
4158: l_pkt_reference3 varchar2(100);
4159: /* Bug 3703180 **/
4160: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4158: l_pkt_reference3 varchar2(100);
4159: /* Bug 3703180 **/
4160: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4159: /* Bug 3703180 **/
4160: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4160: l_doc_line_id_tab pa_plsql_datatypes.IdTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4161: l_po_header_id_tab pa_plsql_datatypes.IdTabTyp ;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4169: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4162: l_po_distribution_id_tab pa_plsql_datatypes.IdTabTyp ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4169: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4170: l_cr_amount number ;
4163: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4169: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4170: l_cr_amount number ;
4171: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4164: l_raw_amount_tab pa_plsql_datatypes.NumTabTyp ;
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4169: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4170: l_cr_amount number ;
4171: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4172:
4165: l_amt_balance_tab pa_plsql_datatypes.NumTabTyp;
4166: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4167: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4168: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4169: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4170: l_cr_amount number ;
4171: l_burd_exists_flag VARCHAR2(1); --Bug 3749551
4172:
4173: -- R12 Funds management uptake: commented CBC related code
4186: where packet_id = p_packet_id
4187: and document_type <> 'PO') ;
4188:
4189: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4190: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4191: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4192: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4193: PRAGMA AUTONOMOUS_TRANSACTION;
4194: begin
4187: and document_type <> 'PO') ;
4188:
4189: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4190: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4191: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4192: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4193: PRAGMA AUTONOMOUS_TRANSACTION;
4194: begin
4195: FORALL i IN p_bc_packet_id_tab.first .. p_bc_packet_id_tab.last
4188:
4189: PROCEDURE Rate_PO_Unreserve( p_packet_id number,
4190: p_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp,
4191: p_entered_cr_tab pa_plsql_datatypes.NumTabTyp,
4192: p_accounted_cr_tab pa_plsql_datatypes.NumTabTyp) is
4193: PRAGMA AUTONOMOUS_TRANSACTION;
4194: begin
4195: FORALL i IN p_bc_packet_id_tab.first .. p_bc_packet_id_tab.last
4196: update pa_bc_packets
4832: l_doc_line_id NUMBER ;
4833: l_bdamt_balance NUMBER ;
4834: l_index NUMBER ;
4835: l_cr_amount NUMBER ;
4836: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4833: l_bdamt_balance NUMBER ;
4834: l_index NUMBER ;
4835: l_cr_amount NUMBER ;
4836: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4841: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
4834: l_index NUMBER ;
4835: l_cr_amount NUMBER ;
4836: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4841: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
4842:
4835: l_cr_amount NUMBER ;
4836: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4841: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
4842:
4843: BEGIN
4836: l_bc_packet_id_tab pa_plsql_datatypes.IdTabTyp ;
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4841: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
4842:
4843: BEGIN
4844:
4837: l_entered_dr_tab pa_plsql_datatypes.NumTabTyp;
4838: l_entered_cr_tab pa_plsql_datatypes.NumTabTyp;
4839: l_accounted_dr_tab pa_plsql_datatypes.NumTabTyp;
4840: l_accounted_cr_tab pa_plsql_datatypes.NumTabTyp;
4841: l_exp_type_tab pa_plsql_datatypes.char50TabTyp;
4842:
4843: BEGIN
4844:
4845: IF g_project_id_tab.count > 0 THEN
5123: l_max_packet_id NUMBER ;
5124: l_max_packet_id_b NUMBER ;
5125: l_amount NUMBER ;
5126: l_prev_multiplier varchar2(1) ;
5127: l_tab_multiplier pa_plsql_datatypes.NumTabTyp ;
5128: l_tab_icc_exp_type pa_plsql_datatypes.char50TabTyp;
5129: l_doc_header_id pa_bc_packets.document_header_id%TYPE ;
5130: l_doc_distribution_id pa_bc_packets.document_distribution_id%TYPE ;
5131:
5124: l_max_packet_id_b NUMBER ;
5125: l_amount NUMBER ;
5126: l_prev_multiplier varchar2(1) ;
5127: l_tab_multiplier pa_plsql_datatypes.NumTabTyp ;
5128: l_tab_icc_exp_type pa_plsql_datatypes.char50TabTyp;
5129: l_doc_header_id pa_bc_packets.document_header_id%TYPE ;
5130: l_doc_distribution_id pa_bc_packets.document_distribution_id%TYPE ;
5131:
5132: /* Commented as part of Bug 5406690
7874: P_request_id IN NUMBER ,
7875: x_result_code OUT NOCOPY VARCHAR2) IS
7876:
7877: -- Variables to store eligible CDL data
7878: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7875: x_result_code OUT NOCOPY VARCHAR2) IS
7876:
7877: -- Variables to store eligible CDL data
7878: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7876:
7877: -- Variables to store eligible CDL data
7878: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7877: -- Variables to store eligible CDL data
7878: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7878: l_Exp_Item_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7879: l_cdl_gl_Date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7887: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7880: l_Burd_Sum_Dest_Run_Id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7887: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7888: l_count_of_records NUMBER;
7881: l_doc_header_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7887: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7888: l_count_of_records NUMBER;
7889: l_Return_Status VARCHAR2(100);
7882: l_doc_distribution_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7887: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7888: l_count_of_records NUMBER;
7889: l_Return_Status VARCHAR2(100);
7890: l_Msg_Data VARCHAR2(2000);
7883: l_cdl_line_type_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7884: l_system_linkage_function_tbl PA_PLSQL_DATATYPES.Char3TabTyp;
7885: l_expenditure_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7886: l_cdl_acct_event_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7887: l_acct_source_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7888: l_count_of_records NUMBER;
7889: l_Return_Status VARCHAR2(100);
7890: l_Msg_Data VARCHAR2(2000);
7891:
7889: l_Return_Status VARCHAR2(100);
7890: l_Msg_Data VARCHAR2(2000);
7891:
7892: -- Below variables added for bug 5263721
7893: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7890: l_Msg_Data VARCHAR2(2000);
7891:
7892: -- Below variables added for bug 5263721
7893: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7891:
7892: -- Below variables added for bug 5263721
7893: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7892: -- Below variables added for bug 5263721
7893: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7893: l_billable_flag_tbl PA_PLSQL_DATATYPES.Char1TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7894: l_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7895: l_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7896: l_pa_period_name_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7897: l_denom_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7898: l_acct_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7899: l_project_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7900: l_projfunc_currency_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7901: l_system_reference1_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7902: l_person_type_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7903: l_po_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7904: l_attribute1_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7905: l_attribute2_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7906: l_attribute3_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7907: l_attribute4_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7908: l_attribute5_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7909: l_attribute6_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7910: l_attribute7_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7911: l_attribute8_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7912: l_attribute9_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7913: l_attribute10_tbl PA_PLSQL_DATATYPES.Char150TabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7914: l_attribute_category_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7915: l_expenditure_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7916: l_ACCT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7917: l_ACCT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7918: l_ACCT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7919: l_PROJECT_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7920: l_PROJECT_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7921: l_PROJECT_EXCHANGE_RATE_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7922: l_PROJFUNC_COST_RATE_DATE_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7923: l_PROJFUNC_COST_RATE_TYPE_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7924: l_pfc_ex_rate_tbl PA_PLSQL_DATATYPES.NumTabTyp;
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7932: -- Bug 5680236 : Added below new variables
7925: l_job_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7926: l_non_labor_resource_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7927: l_nl_res_orgn_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7928: l_wip_resource_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7929: l_incurred_by_person_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7930: l_inventory_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7931:
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7931:
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7932: -- Bug 5680236 : Added below new variables
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7933: l_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7934: l_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7935: l_doc_line_number_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7936: l_transaction_source_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7937: l_cdl_rowid_tbl PA_PLSQL_DATATYPES.RowidTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7938:
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7939: l_bc_commitment_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7940: l_bc_project_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7941: l_bc_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7942: l_bc_res_list_mem_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7943: l_bc_top_task_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
7944: l_bc_budget_version_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
7952: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7945: l_bc_budget_line_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7946: l_bc_entry_level_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7947: l_bc_gl_start_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
7948: l_bc_exp_item_id_tbl PA_PLSQL_DATATYPES.IDTabTyp;
7949: l_bc_transfer_sts_code_tbl PA_PLSQL_DATATYPES.Char30TabTyp;
7950:
7951: l_cdl_top_task_id pa_tasks.top_task_id%TYPE;
7952: l_cdl_budget_version_id pa_budget_versions.budget_version_id%TYPE;
7953: l_cdl_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;