107:
108: PROCEDURE CREATE_DOCUMENT
109: (
110: p_api_version IN NUMBER := 1.0 ,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
113: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_x_document_tbl IN OUT NOCOPY Document_Tbl ,
108: PROCEDURE CREATE_DOCUMENT
109: (
110: p_api_version IN NUMBER := 1.0 ,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
113: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_x_document_tbl IN OUT NOCOPY Document_Tbl ,
116: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
109: (
110: p_api_version IN NUMBER := 1.0 ,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
113: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_x_document_tbl IN OUT NOCOPY Document_Tbl ,
116: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
117: p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
110: p_api_version IN NUMBER := 1.0 ,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
113: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: p_x_document_tbl IN OUT NOCOPY Document_Tbl ,
116: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
117: p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
118: x_return_status OUT NOCOPY VARCHAR2 ,
124:
125: PROCEDURE MODIFY_DOCUMENT
126: (
127: p_api_version IN NUMBER := 1.0 ,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_x_document_tbl IN OUT NOCOPY document_tbl ,
125: PROCEDURE MODIFY_DOCUMENT
126: (
127: p_api_version IN NUMBER := 1.0 ,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_x_document_tbl IN OUT NOCOPY document_tbl ,
133: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
126: (
127: p_api_version IN NUMBER := 1.0 ,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_x_document_tbl IN OUT NOCOPY document_tbl ,
133: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
134: p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
127: p_api_version IN NUMBER := 1.0 ,
128: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
129: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
130: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_x_document_tbl IN OUT NOCOPY document_tbl ,
133: p_x_supplier_tbl IN OUT NOCOPY Supplier_Tbl ,
134: p_x_recipient_tbl IN OUT NOCOPY Recipient_Tbl ,
135: x_return_status OUT NOCOPY VARCHAR2 ,
140: --Procedure to Create Supplier Record for an associated document
141: PROCEDURE CREATE_SUPPLIER
142: (
143: p_api_version IN NUMBER := 1.0 ,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_supplier_tbl IN OUT NOCOPY supplier_tbl ,
141: PROCEDURE CREATE_SUPPLIER
142: (
143: p_api_version IN NUMBER := 1.0 ,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_supplier_tbl IN OUT NOCOPY supplier_tbl ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
142: (
143: p_api_version IN NUMBER := 1.0 ,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_supplier_tbl IN OUT NOCOPY supplier_tbl ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
150: x_msg_count OUT NOCOPY NUMBER ,
143: p_api_version IN NUMBER := 1.0 ,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
146: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148: p_x_supplier_tbl IN OUT NOCOPY supplier_tbl ,
149: x_return_status OUT NOCOPY VARCHAR2 ,
150: x_msg_count OUT NOCOPY NUMBER ,
151: x_msg_data OUT NOCOPY VARCHAR2);
153: --Procedure to Update Supplier Record for an associated document
154: PROCEDURE MODIFY_SUPPLIER
155: (
156: p_api_version IN NUMBER := 1.0 ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_supplier_tbl IN supplier_tbl ,
154: PROCEDURE MODIFY_SUPPLIER
155: (
156: p_api_version IN NUMBER := 1.0 ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_supplier_tbl IN supplier_tbl ,
162: x_return_status OUT NOCOPY VARCHAR2 ,
155: (
156: p_api_version IN NUMBER := 1.0 ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_supplier_tbl IN supplier_tbl ,
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,
156: p_api_version IN NUMBER := 1.0 ,
157: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
158: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
159: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_supplier_tbl IN supplier_tbl ,
162: x_return_status OUT NOCOPY VARCHAR2 ,
163: x_msg_count OUT NOCOPY NUMBER ,
164: x_msg_data OUT NOCOPY VARCHAR2);
166: --Procedure to Remove Supplier Record for an associated document
167: PROCEDURE DELETE_SUPPLIER
168: (
169: p_api_version IN NUMBER := 1.0 ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: p_supplier_rec IN supplier_rec ,
167: PROCEDURE DELETE_SUPPLIER
168: (
169: p_api_version IN NUMBER := 1.0 ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: p_supplier_rec IN supplier_rec ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
168: (
169: p_api_version IN NUMBER := 1.0 ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: p_supplier_rec IN supplier_rec ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
176: x_msg_count OUT NOCOPY NUMBER ,
169: p_api_version IN NUMBER := 1.0 ,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: p_supplier_rec IN supplier_rec ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
176: x_msg_count OUT NOCOPY NUMBER ,
177: x_msg_data OUT NOCOPY VARCHAR2);
179: --Procedure to Create Recipient Record for an associated document
180: PROCEDURE CREATE_RECIPIENT
181: (
182: p_api_version IN NUMBER := 1.0 ,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
185: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_x_recipient_tbl IN OUT NOCOPY recipient_tbl ,
180: PROCEDURE CREATE_RECIPIENT
181: (
182: p_api_version IN NUMBER := 1.0 ,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
185: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_x_recipient_tbl IN OUT NOCOPY recipient_tbl ,
188: x_return_status OUT NOCOPY VARCHAR2 ,
181: (
182: p_api_version IN NUMBER := 1.0 ,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
185: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_x_recipient_tbl IN OUT NOCOPY recipient_tbl ,
188: x_return_status OUT NOCOPY VARCHAR2 ,
189: x_msg_count OUT NOCOPY NUMBER ,
182: p_api_version IN NUMBER := 1.0 ,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
185: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_x_recipient_tbl IN OUT NOCOPY recipient_tbl ,
188: x_return_status OUT NOCOPY VARCHAR2 ,
189: x_msg_count OUT NOCOPY NUMBER ,
190: x_msg_data OUT NOCOPY VARCHAR2);
192: --Procedure to Update Recipient Record for an associated document
193: PROCEDURE MODIFY_RECIPIENT
194: (
195: p_api_version IN NUMBER := 1.0 ,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_recipient_tbl IN OUT NOCOPY recipient_tbl ,
193: PROCEDURE MODIFY_RECIPIENT
194: (
195: p_api_version IN NUMBER := 1.0 ,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_recipient_tbl IN OUT NOCOPY recipient_tbl ,
201: x_return_status OUT NOCOPY VARCHAR2 ,
194: (
195: p_api_version IN NUMBER := 1.0 ,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_recipient_tbl IN OUT NOCOPY recipient_tbl ,
201: x_return_status OUT NOCOPY VARCHAR2 ,
202: x_msg_count OUT NOCOPY NUMBER ,
195: p_api_version IN NUMBER := 1.0 ,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
198: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_recipient_tbl IN OUT NOCOPY recipient_tbl ,
201: x_return_status OUT NOCOPY VARCHAR2 ,
202: x_msg_count OUT NOCOPY NUMBER ,
203: x_msg_data OUT NOCOPY VARCHAR2);
205: --Procedure to Remove Recipient Record for an associated document
206: PROCEDURE DELETE_RECIPIENT
207: (
208: p_api_version IN NUMBER := 1.0 ,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
211: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: p_recipient_rec IN recipient_rec ,
206: PROCEDURE DELETE_RECIPIENT
207: (
208: p_api_version IN NUMBER := 1.0 ,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
211: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: p_recipient_rec IN recipient_rec ,
214: x_return_status OUT NOCOPY VARCHAR2 ,
207: (
208: p_api_version IN NUMBER := 1.0 ,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
211: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: p_recipient_rec IN recipient_rec ,
214: x_return_status OUT NOCOPY VARCHAR2 ,
215: x_msg_count OUT NOCOPY NUMBER ,
208: p_api_version IN NUMBER := 1.0 ,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
211: p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
213: p_recipient_rec IN recipient_rec ,
214: x_return_status OUT NOCOPY VARCHAR2 ,
215: x_msg_count OUT NOCOPY NUMBER ,
216: x_msg_data OUT NOCOPY VARCHAR2);