DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_IMPORT_INVOICES_PKG

Line 70: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

66: /* Fatal error flag is set if there is no valid supplier or supplier site.*/
67: /* */
68: /*========================================================================*/
69: FUNCTION v_check_invoice_validation(
70: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
71: p_match_mode OUT NOCOPY VARCHAR2,
72: p_min_acct_unit_inv_curr OUT NOCOPY NUMBER,
73: p_precision_inv_curr OUT NOCOPY NUMBER,
74: p_positive_price_tolerance OUT NOCOPY NUMBER,

Line 117: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

113: /* 3. PO vendor information is inconsistent */
114: /* */
115: /*========================================================================*/
116: FUNCTION v_check_invalid_po (
117: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
118: p_default_last_updated_by IN NUMBER,
119: p_default_last_update_login IN NUMBER,
120: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
121: p_po_vendor_id OUT NOCOPY NUMBER,

Line 137: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

133: /* 3. Invalid Supplier provided */
134: /* */
135: /*=========================================================================*/
136: FUNCTION v_check_invalid_supplier (
137: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
138: p_default_last_updated_by IN NUMBER,
139: p_default_last_update_login IN NUMBER,
140: p_return_vendor_id OUT NOCOPY NUMBER,
141: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 158: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

154: /* */
155: /*=========================================================================*/
156: FUNCTION v_check_invalid_supplier_site (
157: p_invoice_rec IN
158: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
159: p_vendor_site_id_per_po IN NUMBER,
160: p_default_last_updated_by IN NUMBER,
161: p_default_last_update_login IN NUMBER,
162: p_return_vendor_site_id OUT NOCOPY NUMBER,

Line 178: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

174: /* 2. Invalid Party provided */
175: /* */
176: /*=========================================================================*/
177: FUNCTION v_check_invalid_party(
178: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
179: p_default_last_updated_by IN NUMBER,
180: p_default_last_update_login IN NUMBER,
181: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
182: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 195: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

191: /* 4. Party Site is invalid */
192: /* */
193: /*=========================================================================*/
194: FUNCTION v_check_invalid_party_site (
195: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
196: p_default_last_updated_by IN NUMBER,
197: p_default_last_update_login IN NUMBER,
198: p_return_party_site_id OUT NOCOPY NUMBER,
199: p_terms_date_basis OUT NOCOPY VARCHAR2,

Line 214: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

210: /* the interface. */
211: /* */
212: /*=========================================================================*/
213: FUNCTION v_check_invalid_invoice_num (
214: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
215: p_allow_interest_invoices IN VARCHAR2, --Bug4113223
216: p_invoice_num OUT NOCOPY VARCHAR2,
217: p_default_last_updated_by IN NUMBER,
218: p_default_last_update_login IN NUMBER,

Line 234: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

230: /* minimum accountable unit and precision for the currency. */
231: /* */
232: /*=========================================================================*/
233: FUNCTION v_check_invalid_inv_curr_code (
234: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
235: p_inv_currency_code OUT NOCOPY VARCHAR2,
236: p_min_acc_unit_inv_curr OUT NOCOPY NUMBER,
237: p_precision_inv_curr OUT NOCOPY NUMBER,
238: p_default_last_updated_by IN NUMBER,

Line 261: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

257: /* If invoice type is CREDIT set match mode to MC */
258: /* */
259: /*=========================================================================*/
260: FUNCTION v_check_invoice_type_amount (
261: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
262: p_invoice_type_lookup_code OUT NOCOPY VARCHAR2,
263: p_match_mode OUT NOCOPY VARCHAR2,
264: p_precision_inv_curr IN NUMBER,
265: p_default_last_updated_by IN NUMBER,

Line 283: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

279: /* in the record was null. */
280: /* */
281: /*=========================================================================*/
282: FUNCTION v_check_invalid_awt_group (
283: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
284: p_awt_group_id OUT NOCOPY NUMBER,
285: p_default_last_updated_by IN NUMBER,
286: p_default_last_update_login IN NUMBER,
287: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 303: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

299: /* in the record was null. */
300: /* */
301: /*=================================================================================*/
302: FUNCTION v_check_invalid_pay_awt_group (
303: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
304: p_pay_awt_group_id OUT NOCOPY NUMBER,
305: p_default_last_updated_by IN NUMBER,
306: p_default_last_update_login IN NUMBER,
307: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 322: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

318: /* Returns the exchange rate and exchange date. */
319: /* */
320: /*=========================================================================*/
321: FUNCTION v_check_exchange_rate_type (
322: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
323: p_exchange_rate OUT NOCOPY NUMBER,
324: p_exchange_date OUT NOCOPY DATE,
325: p_base_currency_code IN VARCHAR2,
326: p_multi_currency_flag IN VARCHAR2,

Line 353: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

349: /* */
350: /*=========================================================================*/
351: FUNCTION v_check_invalid_terms (
352: p_invoice_rec IN
353: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
354: p_terms_id OUT NOCOPY NUMBER,
355: p_terms_date OUT NOCOPY DATE,
356: p_terms_date_basis IN VARCHAR2,
357: p_default_last_updated_by IN NUMBER,

Line 374: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

370: /* 5. Is Requester a valid employee? */
371: /* */
372: /*=========================================================================*/
373: FUNCTION v_check_misc_invoice_info (
374: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
375: -- Bug 6509776
376: p_set_of_books_id IN NUMBER,
377: p_default_last_updated_by IN NUMBER,
378: p_default_last_update_login IN NUMBER,

Line 391: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

387: /* 2. REG Code and Number Derive Valid LE */
388: /* */
389: /*=========================================================================*/
390: FUNCTION v_check_legal_entity_info (
391: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
392: p_set_of_books_id IN NUMBER,
393: p_default_last_updated_by IN NUMBER,
394: p_default_last_update_login IN NUMBER,
395: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 411: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

407: /* is null. */
408: /* */
409: /*=========================================================================*/
410: FUNCTION v_check_invalid_pay_curr (
411: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
412: p_pay_currency_code OUT NOCOPY VARCHAR2,
413: p_payment_cross_rate_date OUT NOCOPY DATE,
414: p_payment_cross_rate OUT NOCOPY NUMBER,
415: p_payment_cross_rate_type OUT NOCOPY VARCHAR2,

Line 430: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

426: /*=========================================================================*/
427:
428: FUNCTION v_check_prepay_info(
429: p_invoice_rec IN OUT NOCOPY
430: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
431: p_base_currency_code IN VARCHAR2,
432: p_prepay_period_name IN OUT NOCOPY VARCHAR2,
433: p_prepay_invoice_id OUT NOCOPY NUMBER, --Contract Payments
434: p_prepay_case_name OUT NOCOPY VARCHAR2, --Contract Payments

Line 454: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

450: /* 3. Derives base amount if possible.
451: /* */
452: /*=========================================================================*/
453: FUNCTION v_check_no_xrate_base_amount (
454: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
455: p_base_currency_code IN VARCHAR2,
456: p_multi_currency_flag IN VARCHAR2,
457: p_calc_user_xrate IN VARCHAR2,
458: p_default_last_updated_by IN NUMBER,

Line 477: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

473: /* */
474: /*=========================================================================*/
475: FUNCTION v_check_lines_validation (
476: -- bug 8495005 fix : changed as IN OUT NOCOPY
477: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
478: p_invoice_lines_tab IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.t_lines_table, --Retropricing
479: p_gl_date_from_get_info IN DATE,
480: p_gl_date_from_receipt_flag IN VARCHAR2,
481: p_positive_price_tolerance IN NUMBER,

Line 478: p_invoice_lines_tab IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.t_lines_table, --Retropricing

474: /*=========================================================================*/
475: FUNCTION v_check_lines_validation (
476: -- bug 8495005 fix : changed as IN OUT NOCOPY
477: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
478: p_invoice_lines_tab IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.t_lines_table, --Retropricing
479: p_gl_date_from_get_info IN DATE,
480: p_gl_date_from_receipt_flag IN VARCHAR2,
481: p_positive_price_tolerance IN NUMBER,
482: p_pa_installed IN VARCHAR2,

Line 513: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,

509: /* 1. Does the line amount exceed the invoice currency precision? */
510: /* */
511: /*=======================================================================*/
512: FUNCTION v_check_invoice_line_amount (
513: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,
514: p_precision_inv_curr IN NUMBER,
515: p_default_last_updated_by IN NUMBER,
516: p_default_last_update_login IN NUMBER,
517: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 528: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

524: /* validity and consistency. It rejects if necessary. */
525: /* */
526: /*=======================================================================*/
527: FUNCTION v_check_line_po_info (
528: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
529: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
530: p_set_of_books_id IN NUMBER,
531: p_positive_price_tolerance IN NUMBER,
532: p_qty_ord_tolerance IN NUMBER,

Line 529: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

525: /* */
526: /*=======================================================================*/
527: FUNCTION v_check_line_po_info (
528: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
529: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
530: p_set_of_books_id IN NUMBER,
531: p_positive_price_tolerance IN NUMBER,
532: p_qty_ord_tolerance IN NUMBER,
533: p_amt_ord_tolerance IN NUMBER,

Line 558: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

554: /* */
555: /*=======================================================================*/
556:
557: FUNCTION v_check_line_po_info2 (
558: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
559: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,
560: p_positive_price_tolerance IN NUMBER,
561: p_qty_ord_tolerance IN NUMBER,
562: p_amt_ord_tolerance IN NUMBER,

Line 559: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,

555: /*=======================================================================*/
556:
557: FUNCTION v_check_line_po_info2 (
558: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
559: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,
560: p_positive_price_tolerance IN NUMBER,
561: p_qty_ord_tolerance IN NUMBER,
562: p_amt_ord_tolerance IN NUMBER,
563: p_max_qty_ord_tolerance IN NUMBER,

Line 587: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

583: /* */
584: /*=========================================================================*/
585: --Contract Payments: Added the p_invoice_rec to the signature.
586: FUNCTION v_check_po_overlay (
587: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
588: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,
589: p_po_line_id IN NUMBER,
590: p_po_line_location_id IN NUMBER,
591: p_po_distribution_id IN NUMBER,

Line 588: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,

584: /*=========================================================================*/
585: --Contract Payments: Added the p_invoice_rec to the signature.
586: FUNCTION v_check_po_overlay (
587: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
588: p_invoice_lines_rec IN AP_IMPORT_INVOICES_PKG.r_line_info_rec,
589: p_po_line_id IN NUMBER,
590: p_po_line_location_id IN NUMBER,
591: p_po_distribution_id IN NUMBER,
592: p_set_of_books_id IN NUMBER,

Line 605: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

601: /* information for RCV matched lines. */
602: /* */
603: /*=========================================================================*/
604: FUNCTION v_check_receipt_info (
605: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
606: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
607: p_default_last_updated_by IN NUMBER,
608: p_default_last_update_login IN NUMBER,
609: p_temp_line_status OUT NOCOPY VARCHAR2,

Line 606: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

602: /* */
603: /*=========================================================================*/
604: FUNCTION v_check_receipt_info (
605: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
606: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
607: p_default_last_updated_by IN NUMBER,
608: p_default_last_update_login IN NUMBER,
609: p_temp_line_status OUT NOCOPY VARCHAR2,
610: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 622: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

618: /* and validated. */
619: /* */
620: /*=========================================================================*/
621: FUNCTION v_check_line_accounting_date (
622: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
623: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
624: p_gl_date_from_get_info IN DATE,
625: p_gl_date_from_receipt_flag IN VARCHAR2,
626: p_set_of_books_id IN NUMBER,

Line 623: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

619: /* */
620: /*=========================================================================*/
621: FUNCTION v_check_line_accounting_date (
622: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
623: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
624: p_gl_date_from_get_info IN DATE,
625: p_gl_date_from_receipt_flag IN VARCHAR2,
626: p_set_of_books_id IN NUMBER,
627: p_purch_encumbrance_flag IN VARCHAR2,

Line 640: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

636: /* level project information. */
637: /* */
638: /*=========================================================================*/
639: FUNCTION v_check_line_project_info (
640: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
641: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
642: p_accounting_date IN DATE,
643: p_pa_installed IN VARCHAR2,
644: p_employee_id IN NUMBER,

Line 641: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

637: /* */
638: /*=========================================================================*/
639: FUNCTION v_check_line_project_info (
640: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
641: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
642: p_accounting_date IN DATE,
643: p_pa_installed IN VARCHAR2,
644: p_employee_id IN NUMBER,
645: p_base_currency_code IN VARCHAR2,

Line 663: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

659: /* If possible it builds account by overlaying and stores in line record. */
660: /* */
661: /*=========================================================================*/
662: FUNCTION v_check_line_account_info (
663: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
664: p_freight_code_combination_id IN NUMBER,
665: p_pa_built_account IN NUMBER,
666: p_accounting_date IN DATE,
667: p_set_of_books_id IN NUMBER,

Line 709: IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

705: /* */
706: /*=========================================================================*/
707: FUNCTION v_check_deferred_accounting (
708: p_invoice_lines_rec
709: IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
710: p_set_of_books_id IN NUMBER,
711: p_default_last_updated_by IN NUMBER,
712: p_default_last_update_login IN NUMBER,
713: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 726: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

722: /* */
723: /*========================================================================*/
724: FUNCTION v_check_line_dist_set (
725: p_invoice_rec IN
726: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
727: p_invoice_lines_rec IN OUT NOCOPY
728: AP_IMPORT_INVOICES_PKG.r_line_info_rec,
729: p_base_currency_code IN VARCHAR2,
730: p_employee_id IN NUMBER,

Line 728: AP_IMPORT_INVOICES_PKG.r_line_info_rec,

724: FUNCTION v_check_line_dist_set (
725: p_invoice_rec IN
726: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
727: p_invoice_lines_rec IN OUT NOCOPY
728: AP_IMPORT_INVOICES_PKG.r_line_info_rec,
729: p_base_currency_code IN VARCHAR2,
730: p_employee_id IN NUMBER,
731: p_gl_date_from_get_info IN DATE,
732: p_set_of_books_id IN NUMBER,

Line 762: IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

758: /* */
759: /*=========================================================================*/
760: FUNCTION v_check_qty_uom_non_po (
761: p_invoice_rec
762: IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
763: p_invoice_lines_rec
764: IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
765: p_default_last_updated_by IN NUMBER,
766: p_default_last_update_login IN NUMBER,

Line 764: IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

760: FUNCTION v_check_qty_uom_non_po (
761: p_invoice_rec
762: IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
763: p_invoice_lines_rec
764: IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
765: p_default_last_updated_by IN NUMBER,
766: p_default_last_update_login IN NUMBER,
767: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
768: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 780: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

776: /* function unless an error or rejection occurs. */
777: /* */
778: /*=========================================================================*/
779: FUNCTION v_check_invalid_line_awt_group (
780: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
781: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
782: p_default_last_updated_by IN NUMBER,
783: p_default_last_update_login IN NUMBER,
784: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 781: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

777: /* */
778: /*=========================================================================*/
779: FUNCTION v_check_invalid_line_awt_group (
780: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
781: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
782: p_default_last_updated_by IN NUMBER,
783: p_default_last_update_login IN NUMBER,
784: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
785: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 797: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

793: /* function unless an error or rejection occurs. */
794: /* */
795: /*=============================================================================*/
796: FUNCTION v_check_invalid_line_pay_awt_g (
797: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
798: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
799: p_default_last_updated_by IN NUMBER,
800: p_default_last_update_login IN NUMBER,
801: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 798: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

794: /* */
795: /*=============================================================================*/
796: FUNCTION v_check_invalid_line_pay_awt_g (
797: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
798: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
799: p_default_last_updated_by IN NUMBER,
800: p_default_last_update_login IN NUMBER,
801: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
802: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 814: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

810: /* validation function. */
811: /* */
812: /*=========================================================================*/
813: FUNCTION v_check_duplicate_line_num (
814: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
815: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
816: p_default_last_updated_by IN NUMBER,
817: p_default_last_update_login IN NUMBER,
818: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 815: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

811: /* */
812: /*=========================================================================*/
813: FUNCTION v_check_duplicate_line_num (
814: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
815: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
816: p_default_last_updated_by IN NUMBER,
817: p_default_last_update_login IN NUMBER,
818: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
819: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 831: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec, -- bug 7599916

827: /*=========================================================================*/
828:
829: FUNCTION v_check_misc_line_info (
830: p_invoice_rec IN
831: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec, -- bug 7599916
832: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
833: p_default_last_updated_by IN NUMBER,
834: p_default_last_update_login IN NUMBER,
835: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 832: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

828:
829: FUNCTION v_check_misc_line_info (
830: p_invoice_rec IN
831: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec, -- bug 7599916
832: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
833: p_default_last_updated_by IN NUMBER,
834: p_default_last_update_login IN NUMBER,
835: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
836: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 847: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

843: /* */
844: /*=========================================================================*/
845: FUNCTION v_check_prorate_info (
846: p_invoice_rec IN
847: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
848: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
849: p_default_last_updated_by IN NUMBER,
850: p_default_last_update_login IN NUMBER,
851: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 848: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

844: /*=========================================================================*/
845: FUNCTION v_check_prorate_info (
846: p_invoice_rec IN
847: AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
848: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
849: p_default_last_updated_by IN NUMBER,
850: p_default_last_update_login IN NUMBER,
851: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
852: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN ;

Line 870: AP_IMPORT_INVOICES_PKG.r_line_info_rec,

866: /* */
867: /*=========================================================================*/
868: FUNCTION v_check_asset_info (
869: p_invoice_lines_rec IN OUT NOCOPY
870: AP_IMPORT_INVOICES_PKG.r_line_info_rec,
871: p_set_of_books_id IN NUMBER,
872: p_asset_book_type IN VARCHAR2, -- Bug 5448579
873: p_default_last_updated_by IN NUMBER,
874: p_default_last_update_login IN NUMBER,

Line 907: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

903: |
904: *============================================================================*/
905:
906: FUNCTION v_check_tax_info(
907: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
908: p_default_last_updated_by IN NUMBER,
909: p_default_last_update_login IN NUMBER,
910: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
911: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 941: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

937: | 20-JAN-2004 SYIDNER Created
938: |
939: *============================================================================*/
940: FUNCTION v_check_tax_line_info (
941: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
942: p_default_last_updated_by IN NUMBER,
943: p_default_last_update_login IN NUMBER,
944: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
945: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 974: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

970: |
971: *============================================================================*/
972:
973: FUNCTION v_check_line_purch_category(
974: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
975: p_default_last_updated_by IN NUMBER,
976: p_default_last_update_login IN NUMBER,
977: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
978: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 1007: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

1003: |
1004: *============================================================================*/
1005:
1006: FUNCTION v_check_line_cost_factor(
1007: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1008: p_default_last_updated_by IN NUMBER,
1009: p_default_last_update_login IN NUMBER,
1010: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
1011: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 1025: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

1021: |
1022: *============================================================================*/
1023:
1024: FUNCTION v_check_line_retainage(
1025: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1026: p_retainage_ccid IN NUMBER,
1027: p_default_last_updated_by IN NUMBER,
1028: p_default_last_update_login IN NUMBER,
1029: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 1034: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1030: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
1031:
1032:
1033: FUNCTION v_check_payment_defaults(
1034: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1035: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
1036: p_calling_sequence IN VARCHAR2,
1037: p_default_last_updated_by IN NUMBER,
1038: p_default_last_update_login IN NUMBER

Line 1043: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1039: ) return boolean;
1040:
1041:
1042: FUNCTION v_check_party_vendor(
1043: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1044: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
1045: p_calling_sequence IN VARCHAR2,
1046: p_default_last_updated_by IN NUMBER,
1047: p_default_last_update_login IN NUMBER

Line 1053: FUNCTION v_check_line_get_po_tax_attr(p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1049:
1050:
1051: --bugfix:5565310
1052: -- bug 8495005 fix: changed p_invoice_rec as IN OUT NOCOPY
1053: FUNCTION v_check_line_get_po_tax_attr(p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1054: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1055: p_calling_sequence IN VARCHAR2) return boolean;
1056:
1057: --bugfix:6989166

Line 1054: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

1050:
1051: --bugfix:5565310
1052: -- bug 8495005 fix: changed p_invoice_rec as IN OUT NOCOPY
1053: FUNCTION v_check_line_get_po_tax_attr(p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1054: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1055: p_calling_sequence IN VARCHAR2) return boolean;
1056:
1057: --bugfix:6989166
1058: FUNCTION v_check_ship_to_location_code(

Line 1059: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1055: p_calling_sequence IN VARCHAR2) return boolean;
1056:
1057: --bugfix:6989166
1058: FUNCTION v_check_ship_to_location_code(
1059: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1060: p_invoice_line_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec, --bug 15862708
1061: p_default_last_updated_by IN NUMBER,
1062: p_default_last_update_login IN NUMBER,
1063: p_current_invoice_status IN OUT NOCOPY VARCHAR2,

Line 1060: p_invoice_line_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec, --bug 15862708

1056:
1057: --bugfix:6989166
1058: FUNCTION v_check_ship_to_location_code(
1059: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1060: p_invoice_line_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec, --bug 15862708
1061: p_default_last_updated_by IN NUMBER,
1062: p_default_last_update_login IN NUMBER,
1063: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
1064: p_calling_sequence IN VARCHAR2) return boolean;

Line 1076: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1072: /* */
1073: /*=========================================================================*/
1074:
1075: FUNCTION v_check_invalid_remit_supplier(
1076: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1077: p_default_last_updated_by IN NUMBER,
1078: p_default_last_update_login IN NUMBER,
1079: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
1080: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;

Line 1100: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,

1096: /* wfapproval_status and generate_dists onto lines records */
1097: /* */
1098: /*=========================================================================*/
1099: FUNCTION v_populate_lines_misc(
1100: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1101: p_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1102: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
1103:
1104: --bug 15862708

Line 1101: p_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,

1097: /* */
1098: /*=========================================================================*/
1099: FUNCTION v_populate_lines_misc(
1100: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
1101: p_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
1102: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN;
1103:
1104: --bug 15862708
1105: TYPE g_ship_to_loc_id_code IS TABLE OF hr_locations.ship_to_location_id%TYPE INDEX BY VARCHAR2(60);