76:
77: --===================================================================
78: TYPE ae_header_rec_type IS RECORD
79: (
80: ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
77: --===================================================================
78: TYPE ae_header_rec_type IS RECORD
79: (
80: ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
78: TYPE ae_header_rec_type IS RECORD
79: (
80: ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
79: (
80: ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
80: ae_header_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
81: object_version_number NUMBER,-- := FND_API.G_MISS_NUM,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
82: last_update_date DATE,-- := FND_API.G_MISS_DATE,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
83: last_updated_by NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
84: creation_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
85: created_by NUMBER,-- := FND_API.G_MISS_NUM,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
86: last_update_login NUMBER,-- := FND_API.G_MISS_NUM,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
87: request_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
88: program_application_id NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
89: program_update_date DATE,-- := FND_API.G_MISS_DATE,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
90: program_id NUMBER,-- := FND_API.G_MISS_NUM,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
91: accounting_event_id NUMBER,-- := FND_API.G_MISS_NUM,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
92: accounting_date DATE,-- := FND_API.G_MISS_DATE,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
93: accounting_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
94: ae_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
95: ae_sequence_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
96: ae_sequence_value NUMBER,-- := FND_API.G_MISS_NUM,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
97: cross_currency_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
98: description VARCHAR2(240),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
99: gl_reversal_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
100: gl_transfer_error_code VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
101: gl_transfer_flag VARCHAR2(1),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
102: gl_transfer_run_id NUMBER,-- := FND_API.G_MISS_NUM,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
103: org_id NUMBER,-- := FND_API.G_MISS_NUM,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
104: period_name VARCHAR2(15),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
105: set_of_books_id NUMBER,-- := FND_API.G_MISS_NUM,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
106: attribute_category VARCHAR2(30),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
107: attribute1 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
108: attribute2 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
109: attribute3 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
110: attribute4 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
111: attribute5 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
112: attribute6 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
113: attribute7 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
121: attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
114: attribute8 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
121: attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
122: );
115: attribute9 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
121: attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
122: );
123:
116: attribute10 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
121: attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
122: );
123:
124: g_miss_ae_header_rec ae_header_rec_type;
117: attribute11 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
118: attribute12 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
119: attribute13 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
120: attribute14 VARCHAR2(150),-- := FND_API.G_MISS_CHAR,
121: attribute15 VARCHAR2(150) -- := FND_API.G_MISS_CHAR
122: );
123:
124: g_miss_ae_header_rec ae_header_rec_type;
125: TYPE ae_header_tbl_type IS TABLE OF ae_header_rec_type INDEX BY BINARY_INTEGER;
137: -- Parameters
138: --
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_ae_header_rec IN ae_header_rec_type Required
145: --
138: --
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_ae_header_rec IN ae_header_rec_type Required
145: --
146: -- OUT
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_ae_header_rec IN ae_header_rec_type Required
145: --
146: -- OUT
147: -- x_return_status OUT VARCHAR2
156: --
157:
158: PROCEDURE Create_Ae_Header(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
157:
158: PROCEDURE Create_Ae_Header(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
158: PROCEDURE Create_Ae_Header(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163:
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
181: -- Parameters
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ae_header_rec IN ae_header_rec_type Required
189: --
182: --
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ae_header_rec IN ae_header_rec_type Required
189: --
190: -- OUT
183: -- IN
184: -- p_api_version_number IN NUMBER Required
185: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
186: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
187: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
188: -- p_ae_header_rec IN ae_header_rec_type Required
189: --
190: -- OUT
191: -- x_return_status OUT VARCHAR2
200: --
201:
202: PROCEDURE Update_Ae_Header(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
201:
202: PROCEDURE Update_Ae_Header(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
202: PROCEDURE Update_Ae_Header(
203: p_api_version_number IN NUMBER,
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
225: -- Parameters
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_AE_HEADER_ID IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_AE_HEADER_ID IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
234: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_AE_HEADER_ID IN NUMBER
233: -- p_object_version_number IN NUMBER Optional Default = NULL
234: --
235: -- OUT
245: --
246:
247: PROCEDURE Delete_Ae_Header(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
246:
247: PROCEDURE Delete_Ae_Header(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
247: PROCEDURE Delete_Ae_Header(
248: p_api_version_number IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_commit IN VARCHAR2 := FND_API.G_FALSE,
251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_ae_header_id IN NUMBER,
268: -- Parameters
269: --
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ae_header_rec IN ae_header_rec_type Required
276: --
269: --
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ae_header_rec IN ae_header_rec_type Required
276: --
277: -- OUT
270: -- IN
271: -- p_api_version_number IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
273: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
275: -- p_ae_header_rec IN ae_header_rec_type Required
276: --
277: -- OUT
278: -- x_return_status OUT VARCHAR2
287: --
288:
289: PROCEDURE Lock_Ae_Header(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292:
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
311: -- End of Comments
312:
313: PROCEDURE Validate_ae_header(
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_ae_header_rec IN ae_header_rec_type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
312:
313: PROCEDURE Validate_ae_header(
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: p_ae_header_rec IN ae_header_rec_type,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2
349: -- End of Comments
350:
351: PROCEDURE Validate_ae_header_rec(
352: p_api_version_number IN NUMBER,
353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_ae_header_rec IN ae_header_rec_type