45: ,x_interface_status OUT NOCOPY VARCHAR2
46: ) IS
47:
48:
49: l_set_of_books_id PA_PLSQL_DATATYPES.IdTabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
46: ) IS
47:
48:
49: l_set_of_books_id PA_PLSQL_DATATYPES.IdTabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
47:
48:
49: l_set_of_books_id PA_PLSQL_DATATYPES.IdTabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
48:
49: l_set_of_books_id PA_PLSQL_DATATYPES.IdTabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
49: l_set_of_books_id PA_PLSQL_DATATYPES.IdTabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
50: l_source PA_PLSQL_DATATYPES.Char25TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
51: l_group_id PA_PLSQL_DATATYPES.IdTabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
52: l_record_number PA_PLSQL_DATATYPES.NumTabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
53: l_error_code PA_PLSQL_DATATYPES.Char10TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
54: l_error_reason PA_PLSQL_DATATYPES.Char1000TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
55: l_budget_level_id PA_PLSQL_DATATYPES.IdTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
56: l_budgeting_segments PA_PLSQL_DATATYPES.Char1000TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
57: l_transaction_TYPE PA_PLSQL_DATATYPES.Char25TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
58: l_sub_type PA_PLSQL_DATATYPES.Char30TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
59: l_fund_value PA_PLSQL_DATATYPES.Char25TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
60: l_period_name PA_PLSQL_DATATYPES.Char15TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
61: l_segment1_30 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
62: l_increase_decrease_flag PA_PLSQL_DATATYPES.Char1TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
63: l_amount PA_PLSQL_DATATYPES.NewAmtTabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
64: l_doc_number PA_PLSQL_DATATYPES.Char20TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
65: l_attribute1 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
66: l_attribute2 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
67: l_attribute3 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
68: l_attribute4 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
69: l_attribute5 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
70: l_attribute6 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
71: l_attribute7 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
72: l_attribute8 PA_PLSQL_DATATYPES.Char150TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
73: l_attribute9 PA_PLSQL_DATATYPES.Char150TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
74: l_attribute10 PA_PLSQL_DATATYPES.Char150TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
75: l_attribute11 PA_PLSQL_DATATYPES.Char150TabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
76: l_attribute12 PA_PLSQL_DATATYPES.Char150TabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
77: l_attribute13 PA_PLSQL_DATATYPES.Char150TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
78: l_attribute14 PA_PLSQL_DATATYPES.Char150TabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
79: l_attribute15 PA_PLSQL_DATATYPES.Char150TabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
80: l_attribute_category PA_PLSQL_DATATYPES.Char30TabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
81: l_processed_flag PA_PLSQL_DATATYPES.Char1TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
82: l_status PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
83: l_date_created PA_PLSQL_DATATYPES.DateTabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
84: l_created_by PA_PLSQL_DATATYPES.NumTabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
85: l_corrected_flag PA_PLSQL_DATATYPES.Char1TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
86: l_last_update_date PA_PLSQL_DATATYPES.DateTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
94: l_budget_user_id PA_PLSQL_DATATYPES.NewAmtTabTyp;
87: l_last_updated_by PA_PLSQL_DATATYPES.NumTabTyp;
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
94: l_budget_user_id PA_PLSQL_DATATYPES.NewAmtTabTyp;
95:
88: l_gl_date PA_PLSQL_DATATYPES.DateTabTyp;
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
94: l_budget_user_id PA_PLSQL_DATATYPES.NewAmtTabTyp;
95:
96: l_VER_GROUP_ID VARCHAR2(150);
89: l_public_law_code PA_PLSQL_DATATYPES.Char25TabTyp;
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
94: l_budget_user_id PA_PLSQL_DATATYPES.NewAmtTabTyp;
95:
96: l_VER_GROUP_ID VARCHAR2(150);
97: l_user_id NUMBER(15);
90: l_advance_type PA_PLSQL_DATATYPES.Char25TabTyp;
91: l_dept_id PA_PLSQL_DATATYPES.Num15TabTyp;
92: l_main_account PA_PLSQL_DATATYPES.Num15TabTyp;
93: l_transfer_description PA_PLSQL_DATATYPES.Char30TabTyp;
94: l_budget_user_id PA_PLSQL_DATATYPES.NewAmtTabTyp;
95:
96: l_VER_GROUP_ID VARCHAR2(150);
97: l_user_id NUMBER(15);
98: l_pkg_name VARCHAR2(30) := 'PA_CLIENT_EXT_FV_BUDGET_INT';