168: p_login_id IN NUMBER,
169: p_sequence IN OUT NOCOPY NUMBER,
170: x_return_status OUT NOCOPY VARCHAR2);
171:
172: --For Standard PO
173: --Includes Global Agreement Reference checks, Consigned Inventory checks
174: PROCEDURE check_standard_po(p_document_id IN NUMBER,
175: p_online_report_id IN NUMBER,
176: p_user_id IN NUMBER,
170: x_return_status OUT NOCOPY VARCHAR2);
171:
172: --For Standard PO
173: --Includes Global Agreement Reference checks, Consigned Inventory checks
174: PROCEDURE check_standard_po(p_document_id IN NUMBER,
175: p_online_report_id IN NUMBER,
176: p_user_id IN NUMBER,
177: p_login_id IN NUMBER,
178: p_sequence IN OUT NOCOPY NUMBER,
177: p_login_id IN NUMBER,
178: p_sequence IN OUT NOCOPY NUMBER,
179: x_return_status OUT NOCOPY VARCHAR2);
180:
181: --For Standard POs which reference Global Agreement called from
182: --check_standard_po
183: PROCEDURE check_std_global_ref(p_document_id IN NUMBER,
184: p_online_report_id IN NUMBER,
185: p_user_id IN NUMBER,
178: p_sequence IN OUT NOCOPY NUMBER,
179: x_return_status OUT NOCOPY VARCHAR2);
180:
181: --For Standard POs which reference Global Agreement called from
182: --check_standard_po
183: PROCEDURE check_std_global_ref(p_document_id IN NUMBER,
184: p_online_report_id IN NUMBER,
185: p_user_id IN NUMBER,
186: p_login_id IN NUMBER,
186: p_login_id IN NUMBER,
187: p_sequence IN OUT NOCOPY NUMBER,
188: x_return_status OUT NOCOPY VARCHAR2);
189:
190: --For Standard POs which have consigned reference called from
191: --check_standard_po
192: PROCEDURE check_std_consigned_ref(p_document_id IN NUMBER,
193: p_online_report_id IN NUMBER,
194: p_user_id IN NUMBER,
187: p_sequence IN OUT NOCOPY NUMBER,
188: x_return_status OUT NOCOPY VARCHAR2);
189:
190: --For Standard POs which have consigned reference called from
191: --check_standard_po
192: PROCEDURE check_std_consigned_ref(p_document_id IN NUMBER,
193: p_online_report_id IN NUMBER,
194: p_user_id IN NUMBER,
195: p_login_id IN NUMBER,
196: p_sequence IN OUT NOCOPY NUMBER,
197: x_return_status OUT NOCOPY VARCHAR2);
198:
199: --
200: -- For Standard POs which have Global contract reference. Called from
201: -- check_standard_po
202:
203: PROCEDURE check_std_gc_ref
204: ( p_document_id IN NUMBER,
197: x_return_status OUT NOCOPY VARCHAR2);
198:
199: --
200: -- For Standard POs which have Global contract reference. Called from
201: -- check_standard_po
202:
203: PROCEDURE check_std_gc_ref
204: ( p_document_id IN NUMBER,
205: p_online_report_id IN NUMBER,