65:
66: --===================================================================
67: TYPE ps_posting_rec_type IS RECORD
68: (
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
66: --===================================================================
67: TYPE ps_posting_rec_type IS RECORD
68: (
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
67: TYPE ps_posting_rec_type IS RECORD
68: (
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
68: (
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: creation_date DATE := FND_API.G_MISS_DATE,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: last_updated_by NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
72: last_update_date DATE := FND_API.G_MISS_DATE,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: last_update_login NUMBER := FND_API.G_MISS_NUM,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
74: object_version_number NUMBER := FND_API.G_MISS_NUM,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
75: posting_id NUMBER := FND_API.G_MISS_NUM,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
76: max_no_contents NUMBER := FND_API.G_MISS_NUM,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
77: posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78: content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: default_content_id NUMBER := FND_API.G_MISS_NUM,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: posting_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: display_name VARCHAR2(240) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: posting_description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute_category VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
91: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99: attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
92: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99: attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
100: );
93: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99: attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
100: );
101:
94: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99: attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
100: );
101:
102: g_miss_ps_posting_rec ps_posting_rec_type;
95: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: attribute14 VARCHAR2(100) := FND_API.G_MISS_CHAR,
99: attribute15 VARCHAR2(1000) := FND_API.G_MISS_CHAR
100: );
101:
102: g_miss_ps_posting_rec ps_posting_rec_type;
103: TYPE ps_posting_tbl_type IS TABLE OF ps_posting_rec_type INDEX BY BINARY_INTEGER;
115: -- Parameters
116: --
117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_ps_posting_rec IN ps_posting_rec_type Required
123: --
116: --
117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_ps_posting_rec IN ps_posting_rec_type Required
123: --
124: -- OUT
117: -- IN
118: -- p_api_version_number IN NUMBER Required
119: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
120: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
121: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
122: -- p_ps_posting_rec IN ps_posting_rec_type Required
123: --
124: -- OUT
125: -- x_return_status OUT VARCHAR2
134: --
135:
136: PROCEDURE Create_Ps_Posting(
137: p_api_version_number IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141:
142: x_return_status OUT NOCOPY VARCHAR2,
135:
136: PROCEDURE Create_Ps_Posting(
137: p_api_version_number IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141:
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
136: PROCEDURE Create_Ps_Posting(
137: p_api_version_number IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141:
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
159: -- Parameters
160: --
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_ps_posting_rec IN ps_posting_rec_type Required
167: --
160: --
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_ps_posting_rec IN ps_posting_rec_type Required
167: --
168: -- OUT
161: -- IN
162: -- p_api_version_number IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166: -- p_ps_posting_rec IN ps_posting_rec_type Required
167: --
168: -- OUT
169: -- x_return_status OUT VARCHAR2
178: --
179:
180: PROCEDURE Update_Ps_Posting(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
179:
180: PROCEDURE Update_Ps_Posting(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
180: PROCEDURE Update_Ps_Posting(
181: p_api_version_number IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185:
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
203: -- Parameters
204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_POSTING_ID IN NUMBER
211: -- p_object_version_number IN NUMBER Optional Default = NULL
204: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_POSTING_ID IN NUMBER
211: -- p_object_version_number IN NUMBER Optional Default = NULL
212: --
205: -- IN
206: -- p_api_version_number IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210: -- p_POSTING_ID IN NUMBER
211: -- p_object_version_number IN NUMBER Optional Default = NULL
212: --
213: -- OUT
223: --
224:
225: PROCEDURE Delete_Ps_Posting(
226: p_api_version_number IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
224:
225: PROCEDURE Delete_Ps_Posting(
226: p_api_version_number IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
225: PROCEDURE Delete_Ps_Posting(
226: p_api_version_number IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228: p_commit IN VARCHAR2 := FND_API.G_FALSE,
229: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_posting_id IN NUMBER,
246: -- Parameters
247: --
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_ps_posting_rec IN ps_posting_rec_type Required
254: --
247: --
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_ps_posting_rec IN ps_posting_rec_type Required
254: --
255: -- OUT
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_ps_posting_rec IN ps_posting_rec_type Required
254: --
255: -- OUT
256: -- x_return_status OUT VARCHAR2
265: --
266:
267: PROCEDURE Lock_Ps_Posting(
268: p_api_version_number IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270:
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
289: -- End of Comments
290:
291: PROCEDURE Validate_ps_posting(
292: p_api_version_number IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: p_ps_posting_rec IN ps_posting_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
290:
291: PROCEDURE Validate_ps_posting(
292: p_api_version_number IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: p_ps_posting_rec IN ps_posting_rec_type,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2
376: -- End of Comments
377:
378: PROCEDURE Validate_ps_posting_rec(
379: p_api_version_number IN NUMBER,
380: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,
384: p_ps_posting_rec IN ps_posting_rec_type