APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_TBL_NUMBER

Line 25: ,p_change_id_tbl IN PO_TBL_NUMBER)

21: FUNCTION has_clause_changed(p_request_id IN NUMBER)
22: RETURN VARCHAR2;
23:
24: FUNCTION has_vendor_changed(p_request_id IN NUMBER
25: ,p_change_id_tbl IN PO_TBL_NUMBER)
26: RETURN VARCHAR2;
27:
28: FUNCTION unpaid_invoices_exists( p_invoice_id IN NUMBER)
29: RETURN BOOLEAN;

Line 45: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

41: RETURN NUMBER;
42:
43: PROCEDURE unmtch_inv_for_vndr_exists( p_vendor_id IN NUMBER
44: --bug13084712
45: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
46: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
47: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE);
48:
49:

Line 52: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

48:
49:
50: PROCEDURE prepd_inv_for_vndr_exists( p_vendor_id IN NUMBER
51: --bug13084712
52: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
53: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
54: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE);
55:
56:

Line 59: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

55:
56:
57: PROCEDURE partpd_inv_for_vndr_exists(p_vendor_id IN NUMBER
58: --bug13084712
59: ,x_invoice_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
60: ,x_invoice_num_tbl IN OUT NOCOPY PO_TBL_VARCHAR50
61: ,x_invoice_date_tbl IN OUT NOCOPY PO_TBL_DATE);
62:
63:

Line 91: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

87:
88:
89: PROCEDURE atleast_one_doc_selected
90: ( p_request_id IN NUMBER
91: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
92: ,p_validation_type IN VARCHAR2
93: ,x_result_type OUT NOCOPY VARCHAR2
94: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
95: );

Line 112: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

108:
109: PROCEDURE new_vendor_contact_provided
110: ( p_request_id IN NUMBER
111: ,p_acceptance_reqd_flag IN VARCHAR2
112: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
113: ,p_document_id_tbl IN PO_TBL_NUMBER
114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER

Line 113: ,p_document_id_tbl IN PO_TBL_NUMBER

109: PROCEDURE new_vendor_contact_provided
110: ( p_request_id IN NUMBER
111: ,p_acceptance_reqd_flag IN VARCHAR2
112: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
113: ,p_document_id_tbl IN PO_TBL_NUMBER
114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER
117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 114: ,p_change_id_tbl IN PO_TBL_NUMBER

110: ( p_request_id IN NUMBER
111: ,p_acceptance_reqd_flag IN VARCHAR2
112: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
113: ,p_document_id_tbl IN PO_TBL_NUMBER
114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER
117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER

Line 116: ,p_org_id_tbl IN PO_TBL_NUMBER

112: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
113: ,p_document_id_tbl IN PO_TBL_NUMBER
114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER
117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER
119: ,p_validation_type IN VARCHAR2
120: ,x_result_type OUT NOCOPY VARCHAR2

Line 117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

113: ,p_document_id_tbl IN PO_TBL_NUMBER
114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER
117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER
119: ,p_validation_type IN VARCHAR2
120: ,x_result_type OUT NOCOPY VARCHAR2
121: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER

114: ,p_change_id_tbl IN PO_TBL_NUMBER
115: ,p_change_type_tbl IN PO_TBL_VARCHAR30
116: ,p_org_id_tbl IN PO_TBL_NUMBER
117: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
118: ,p_new_vendor_contact_id_tbl IN PO_TBL_NUMBER
119: ,p_validation_type IN VARCHAR2
120: ,x_result_type OUT NOCOPY VARCHAR2
121: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
122: );

Line 127: ,p_change_id_tbl PO_TBL_NUMBER

123:
124:
125: PROCEDURE vendor_name_chg_valid
126: ( p_request_id IN NUMBER
127: ,p_change_id_tbl PO_TBL_NUMBER
128: ,p_change_type_tbl PO_TBL_VARCHAR30
129: ,p_old_vendor_name_tbl PO_TBL_VARCHAR240
130: ,p_new_vendor_name_tbl PO_TBL_VARCHAR240
131: ,p_validation_type IN VARCHAR2

Line 138: ,p_change_id_tbl PO_TBL_NUMBER

134: );
135:
136: PROCEDURE new_vendor_on_hold
137: ( p_request_id IN NUMBER
138: ,p_change_id_tbl PO_TBL_NUMBER
139: ,p_change_type_tbl PO_TBL_VARCHAR30
140: ,p_new_vendor_id_tbl PO_TBL_NUMBER
141: ,p_validation_type IN VARCHAR2
142: ,x_result_type OUT NOCOPY VARCHAR2

Line 140: ,p_new_vendor_id_tbl PO_TBL_NUMBER

136: PROCEDURE new_vendor_on_hold
137: ( p_request_id IN NUMBER
138: ,p_change_id_tbl PO_TBL_NUMBER
139: ,p_change_type_tbl PO_TBL_VARCHAR30
140: ,p_new_vendor_id_tbl PO_TBL_NUMBER
141: ,p_validation_type IN VARCHAR2
142: ,x_result_type OUT NOCOPY VARCHAR2
143: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
144: );

Line 148: ,p_change_id_tbl PO_TBL_NUMBER

144: );
145:
146: PROCEDURE vendor_chg_valid
147: ( p_request_id IN NUMBER
148: ,p_change_id_tbl PO_TBL_NUMBER
149: ,p_change_type_tbl PO_TBL_VARCHAR30
150: ,p_old_vendor_id_tbl PO_TBL_NUMBER
151: ,p_new_vendor_id_tbl PO_TBL_NUMBER
152: ,p_validation_type IN VARCHAR2

Line 150: ,p_old_vendor_id_tbl PO_TBL_NUMBER

146: PROCEDURE vendor_chg_valid
147: ( p_request_id IN NUMBER
148: ,p_change_id_tbl PO_TBL_NUMBER
149: ,p_change_type_tbl PO_TBL_VARCHAR30
150: ,p_old_vendor_id_tbl PO_TBL_NUMBER
151: ,p_new_vendor_id_tbl PO_TBL_NUMBER
152: ,p_validation_type IN VARCHAR2
153: ,x_result_type OUT NOCOPY VARCHAR2
154: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 151: ,p_new_vendor_id_tbl PO_TBL_NUMBER

147: ( p_request_id IN NUMBER
148: ,p_change_id_tbl PO_TBL_NUMBER
149: ,p_change_type_tbl PO_TBL_VARCHAR30
150: ,p_old_vendor_id_tbl PO_TBL_NUMBER
151: ,p_new_vendor_id_tbl PO_TBL_NUMBER
152: ,p_validation_type IN VARCHAR2
153: ,x_result_type OUT NOCOPY VARCHAR2
154: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
155: );

Line 184: ,p_change_id_tbl IN PO_TBL_NUMBER

180: );
181:
182: PROCEDURE atleast_one_change_done
183: ( p_request_id IN NUMBER
184: ,p_change_id_tbl IN PO_TBL_NUMBER
185: ,p_validation_type IN VARCHAR2
186: ,x_result_type OUT NOCOPY VARCHAR2
187: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
188: );

Line 192: ,p_change_id_tbl IN PO_TBL_NUMBER

188: );
189:
190: PROCEDURE new_vendor_site_provided
191: ( p_request_id IN NUMBER
192: ,p_change_id_tbl IN PO_TBL_NUMBER
193: ,p_change_type_tbl IN PO_TBL_VARCHAR30
194: ,p_org_id_tbl IN PO_TBL_NUMBER
195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

Line 194: ,p_org_id_tbl IN PO_TBL_NUMBER

190: PROCEDURE new_vendor_site_provided
191: ( p_request_id IN NUMBER
192: ,p_change_id_tbl IN PO_TBL_NUMBER
193: ,p_change_type_tbl IN PO_TBL_VARCHAR30
194: ,p_org_id_tbl IN PO_TBL_NUMBER
195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
197: ,p_validation_type IN VARCHAR2
198: ,x_result_type OUT NOCOPY VARCHAR2

Line 195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER

191: ( p_request_id IN NUMBER
192: ,p_change_id_tbl IN PO_TBL_NUMBER
193: ,p_change_type_tbl IN PO_TBL_VARCHAR30
194: ,p_org_id_tbl IN PO_TBL_NUMBER
195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
197: ,p_validation_type IN VARCHAR2
198: ,x_result_type OUT NOCOPY VARCHAR2
199: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

192: ,p_change_id_tbl IN PO_TBL_NUMBER
193: ,p_change_type_tbl IN PO_TBL_VARCHAR30
194: ,p_org_id_tbl IN PO_TBL_NUMBER
195: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
196: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
197: ,p_validation_type IN VARCHAR2
198: ,x_result_type OUT NOCOPY VARCHAR2
199: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
200: );

Line 204: ,p_change_id_tbl IN PO_TBL_NUMBER

200: );
201:
202: PROCEDURE new_vendor_site_CCR_valid
203: ( p_request_id IN NUMBER
204: ,p_change_id_tbl IN PO_TBL_NUMBER
205: ,p_change_type_tbl IN PO_TBL_VARCHAR30
206: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
207: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
208: ,p_validation_type IN VARCHAR2

Line 206: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER

202: PROCEDURE new_vendor_site_CCR_valid
203: ( p_request_id IN NUMBER
204: ,p_change_id_tbl IN PO_TBL_NUMBER
205: ,p_change_type_tbl IN PO_TBL_VARCHAR30
206: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
207: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
208: ,p_validation_type IN VARCHAR2
209: ,x_result_type OUT NOCOPY VARCHAR2
210: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 207: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER

203: ( p_request_id IN NUMBER
204: ,p_change_id_tbl IN PO_TBL_NUMBER
205: ,p_change_type_tbl IN PO_TBL_VARCHAR30
206: ,p_old_vendor_site_id_tbl IN PO_TBL_NUMBER
207: ,p_new_vendor_site_id_tbl IN PO_TBL_NUMBER
208: ,p_validation_type IN VARCHAR2
209: ,x_result_type OUT NOCOPY VARCHAR2
210: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
211: );

Line 215: --,p_document_id_tbl IN PO_TBL_NUMBER

211: );
212:
213: PROCEDURE generate_idv_exceptions
214: ( p_request_id IN NUMBER
215: --,p_document_id_tbl IN PO_TBL_NUMBER
216: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
217: ,x_result_type OUT NOCOPY VARCHAR2
218: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
219: );

Line 216: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

212:
213: PROCEDURE generate_idv_exceptions
214: ( p_request_id IN NUMBER
215: --,p_document_id_tbl IN PO_TBL_NUMBER
216: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
217: ,x_result_type OUT NOCOPY VARCHAR2
218: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
219: );
220:

Line 223: -- ,p_document_id_tbl IN PO_TBL_NUMBER

219: );
220:
221: PROCEDURE generate_award_exceptions
222: ( p_request_id IN NUMBER
223: -- ,p_document_id_tbl IN PO_TBL_NUMBER
224: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
225: ,x_result_type OUT NOCOPY VARCHAR2
226: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
227: );

Line 224: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

220:
221: PROCEDURE generate_award_exceptions
222: ( p_request_id IN NUMBER
223: -- ,p_document_id_tbl IN PO_TBL_NUMBER
224: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
225: ,x_result_type OUT NOCOPY VARCHAR2
226: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
227: );
228:

Line 231: ,p_document_id_tbl IN PO_TBL_NUMBER

227: );
228:
229: PROCEDURE generate_receipts_exceptions
230: ( p_request_id IN NUMBER
231: ,p_document_id_tbl IN PO_TBL_NUMBER
232: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
233: ,p_novation_effective_date IN DATE
234: ,x_result_type OUT NOCOPY VARCHAR2
235: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 232: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

228:
229: PROCEDURE generate_receipts_exceptions
230: ( p_request_id IN NUMBER
231: ,p_document_id_tbl IN PO_TBL_NUMBER
232: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
233: ,p_novation_effective_date IN DATE
234: ,x_result_type OUT NOCOPY VARCHAR2
235: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
236: );

Line 240: ,p_document_id_tbl IN PO_TBL_NUMBER

236: );
237:
238: PROCEDURE generate_project_exceptions
239: ( p_request_id IN NUMBER
240: ,p_document_id_tbl IN PO_TBL_NUMBER
241: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
242: ,p_novation_effective_date IN DATE
243: ,x_result_type OUT NOCOPY VARCHAR2
244: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 241: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

237:
238: PROCEDURE generate_project_exceptions
239: ( p_request_id IN NUMBER
240: ,p_document_id_tbl IN PO_TBL_NUMBER
241: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
242: ,p_novation_effective_date IN DATE
243: ,x_result_type OUT NOCOPY VARCHAR2
244: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
245: );

Line 249: ,p_document_id_tbl IN PO_TBL_NUMBER

245: );
246:
247: PROCEDURE generate_invoice_exceptions
248: ( p_request_id IN NUMBER
249: ,p_document_id_tbl IN PO_TBL_NUMBER
250: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
251: ,p_novation_effective_date IN DATE
252: ,x_result_type OUT NOCOPY VARCHAR2
253: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

Line 250: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER

246:
247: PROCEDURE generate_invoice_exceptions
248: ( p_request_id IN NUMBER
249: ,p_document_id_tbl IN PO_TBL_NUMBER
250: ,p_multi_mod_doc_id_tbl IN PO_TBL_NUMBER
251: ,p_novation_effective_date IN DATE
252: ,x_result_type OUT NOCOPY VARCHAR2
253: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
254: );

Line 279: ,p_org_id_tbl IN PO_TBL_NUMBER -- Added this parameter as part of CLM Controls Project

275: PROCEDURE contract_officer_provided
276: ( p_request_id IN NUMBER
277: ,p_clm_contract_officer IN NUMBER
278: ,p_validation_type IN VARCHAR2
279: ,p_org_id_tbl IN PO_TBL_NUMBER -- Added this parameter as part of CLM Controls Project
280: ,x_result_type OUT NOCOPY VARCHAR2
281: ,x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
282: );
283: