eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_VALIDATION_PKG dependencies on STANDARD

Line 254: AND nvl(p_invoice_rec.invoice_type_lookup_code,'STANDARD') <> 'PAYMENT REQUEST'

250: --the query Q_AUDIT
251:
252: --added nvl for bug 7314487
253: IF l_temp_vendor_id is NULL
254: AND nvl(p_invoice_rec.invoice_type_lookup_code,'STANDARD') <> 'PAYMENT REQUEST'
255: THEN UPDATE ap_invoices_interface
256: SET vendor_id = l_vendor_id
257: WHERE invoice_id = p_invoice_rec.invoice_id;
258: END IF;

Line 1359: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

1355: SELECT closed_date, vendor_id, vendor_site_id
1356: INTO l_closed_date ,l_vendor_id, l_vendor_site_id
1357: FROM po_headers
1358: WHERE segment1 = p_invoice_rec.po_number
1359: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
1360: /* BUG 2902452 added*/
1361: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS');--Bug5687122 --Added In Process condition
1362:
1363: IF (l_vendor_id IS NOT NULL) Then

Line 3014: -- We only support importing invoice types 'STANDARD', 'CREDIT',

3010: END IF;
3011:
3012: p_invoice_type_lookup_code := p_invoice_rec.invoice_type_lookup_code;
3013:
3014: -- We only support importing invoice types 'STANDARD', 'CREDIT',
3015: -- 'PREPAYMENT' -- Contract Payments
3016: -- and 'PO PRICE ADJUST' --Retropricing
3017: -- and 'DEBIT' -- Debit Memo
3018: -- Also we check for invalid lookup code only if it is not null

Line 3019: -- Else we populate STANDARD for invoice amount >=0 and CREDIT for

3015: -- 'PREPAYMENT' -- Contract Payments
3016: -- and 'PO PRICE ADJUST' --Retropricing
3017: -- and 'DEBIT' -- Debit Memo
3018: -- Also we check for invalid lookup code only if it is not null
3019: -- Else we populate STANDARD for invoice amount >=0 and CREDIT for
3020: -- invoice amount <0
3021:
3022: --Bug 4410499 Added EXPENSE REPORT to the list of
3023: --invoice types we support thru open interface import

Line 3030: 'STANDARD','CREDIT', 'DEBIT', 'PO PRICE ADJUST','PREPAYMENT','EXPENSE REPORT',

3026: --Payment Requests : Added 'PAYMENT REQUEST' to the IF condition
3027: --Bug 7299826 EC Subcon Project : Added 'DEBIT' to the IF condition
3028: IF ((p_invoice_rec.invoice_type_lookup_code IS NOT NULL) AND
3029: (p_invoice_rec.invoice_type_lookup_code NOT IN (
3030: 'STANDARD','CREDIT', 'DEBIT', 'PO PRICE ADJUST','PREPAYMENT','EXPENSE REPORT',
3031: 'PAYMENT REQUEST')))
3032: THEN
3033:
3034: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections

Line 3054: ||'code is null, setting to STANDARD.';

3050: ELSIF ((p_invoice_rec.invoice_type_lookup_code IS NULL) AND
3051: (p_invoice_rec.invoice_amount >=0)) THEN
3052:
3053: debug_info := '(Check Invoice Type and Amount 2) Invoice type lookup '
3054: ||'code is null, setting to STANDARD.';
3055: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
3056: AP_IMPORT_UTILITIES_PKG.Print(
3057: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3058: END IF;

Line 3060: p_invoice_type_lookup_code := 'STANDARD';

3056: AP_IMPORT_UTILITIES_PKG.Print(
3057: AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3058: END IF;
3059:
3060: p_invoice_type_lookup_code := 'STANDARD';
3061:
3062: ELSIF ((p_invoice_rec.invoice_type_lookup_code IS NULL) AND
3063: (p_invoice_rec.invoice_amount < 0)) THEN
3064:

Line 3123: IN ('Standard','STANDARD','Prepayment','PREPAYMENT'/*, -- Bug 7002267

3119:
3120: --Contract Payments: Modified the IF condition to add 'Prepayment' type
3121: --Payment Requests: Added 'PAYMENT REQUEST' type to the IF condition
3122: IF (((nvl(p_invoice_type_lookup_code,'DUMMY')
3123: IN ('Standard','STANDARD','Prepayment','PREPAYMENT'/*, -- Bug 7002267
3124: 'PAYMENT REQUEST'*/)) AND
3125: (p_invoice_rec.invoice_amount < 0)) OR
3126: ((nvl(p_invoice_type_lookup_code,'DUMMY') IN ('CREDIT', 'DEBIT')) AND --Bug 7299826 - Added DEBIT
3127: (p_invoice_rec.invoice_amount > 0))) THEN -- Bug 2822878

Line 4202: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');

4198: SELECT terms_id
4199: INTO l_term_id
4200: FROM po_headers
4201: WHERE segment1 = p_invoice_rec.po_number
4202: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
4203: END IF;
4204:
4205: -- no term from header level po_number, try lines level po_number
4206: IF (l_term_id is null ) THEN

Line 4217: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

4213: BEGIN
4214: SELECT p.terms_id
4215: INTO l_term_id
4216: FROM po_headers p, ap_invoice_lines_interface l
4217: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
4218: AND ((l.po_header_id = p.po_header_id) OR
4219: (l.po_number = p.segment1))
4220: AND l.invoice_id = p_invoice_rec.invoice_id
4221: AND p.terms_id IS NOT NULL

Line 8119: nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'PREPAYMENT') THEN

8115: -- Check if retainage account is available if the po shipment
8116: -- has retainage.
8117: ---------------------------------------------------------
8118: IF (p_invoice_lines_tab(i).po_line_location_id IS NOT NULL AND
8119: nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'PREPAYMENT') THEN
8120:
8121: debug_info := '(Check Lines 26) Checking for retainage account ';
8122: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8123: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);

Line 8396: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

8392: SELECT 'Y', po_header_id
8393: INTO l_po_is_valid_flag, l_po_header_id
8394: FROM po_headers
8395: WHERE segment1 = p_invoice_rec.po_number
8396: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
8397: /* BUG 2902452 added*/
8398: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS');--Bug5687122 --Added In Process condition
8399:
8400: EXCEPTION

Line 8443: AND ph.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

8439: SELECT 'Y'
8440: INTO l_po_is_valid_flag
8441: FROM po_headers ph
8442: WHERE ph.po_header_id = l_po_header_id
8443: AND ph.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
8444: /* BUG 2902452 added */
8445: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS');--Bug5687122 --Added In Process condition
8446:
8447: EXCEPTION

Line 8491: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

8487: SELECT 'Y', ph.po_header_id
8488: INTO l_po_is_valid_flag, l_po_header_id
8489: FROM po_headers ph
8490: WHERE segment1 = p_invoice_lines_rec.po_number
8491: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
8492: /*BUG 2902452 added*/
8493: AND nvl(authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','IN PROCESS');--Bug5687122 --Added In Process condition
8494:
8495: EXCEPTION

Line 8970: Removed the 'STANDARD' from the condition from both

8966: BEGIN
8967: debug_info :=
8968: '(v_check_line_po_info 10.2) Check lines for po_release_id ';
8969: /* For bug 4038403
8970: Removed the 'STANDARD' from the condition from both
8971: the queries as there is no need to validate the release
8972: details for standard PO */
8973:
8974: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 8972: details for standard PO */

8968: '(v_check_line_po_info 10.2) Check lines for po_release_id ';
8969: /* For bug 4038403
8970: Removed the 'STANDARD' from the condition from both
8971: the queries as there is no need to validate the release
8972: details for standard PO */
8973:
8974: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
8975: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
8976: debug_info);

Line 8992: and poh.type_lookup_code in ('BLANKET', 'PLANNED') --, 'STANDARD')

8988: -- fix for bug 2809177 commented above line and wrote the below one
8989: and poh.po_header_id = l_po_header_id
8990: -- Commented below line as a fix for bug 2809177
8991: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
8992: and poh.type_lookup_code in ('BLANKET', 'PLANNED') --, 'STANDARD')
8993: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
8994: and pol.line_num = p_invoice_lines_rec.po_line_number )
8995: AND po_release_id = (
8996: select po_release_id

Line 9004: and poh.type_lookup_code in ('BLANKET', 'PLANNED')--, 'STANDARD')

9000: -- fix for bug 2809177 commented above line and wrote the below one
9001: and poh.po_header_id = l_po_header_id
9002: -- Commented below line as a fix for bug 2809177
9003: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9004: and poh.type_lookup_code in ('BLANKET', 'PLANNED')--, 'STANDARD')
9005: and por.po_header_id = l_po_header_id -- Added as a fix for bug 2809177
9006: and por.release_num = p_invoice_lines_rec.release_num )
9007: AND rownum <=1;
9008: ELSIF p_invoice_lines_rec.po_number IS NOT NULL THEN

Line 9020: and poh.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

9016: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9017: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9018: -- fix for bug 2809177 commented above two lines and wrote the below one
9019: and poh.segment1 = p_invoice_lines_rec.po_number
9020: and poh.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
9021: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
9022: and pol.line_num = p_invoice_lines_rec.po_line_number )
9023: AND po_release_id = (
9024: select po_release_id

Line 9031: and poh.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')

9027: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9028: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9029: -- fix for bug 2809177 commented above two line and wrote the below one
9030: and poh.segment1 = p_invoice_lines_rec.po_number
9031: and poh.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
9032: and por.release_num = p_invoice_lines_rec.release_num )
9033: AND rownum <=1;
9034: END IF ;
9035:

Line 10420: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');

10416: SELECT segment1
10417: INTO l_po_number
10418: FROM po_headers
10419: WHERE po_header_id = l_po_header_id
10420: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
10421: EXCEPTION
10422: WHEN NO_DATA_FOUND THEN
10423: NULL;
10424: END;

Line 10582: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');

10578: SELECT po_header_id
10579: INTO l_po_header_id
10580: FROM po_headers
10581: WHERE segment1 = l_po_number
10582: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
10583:
10584: END IF; -- Step 30: po_number is not null but po_header_id is null
10585:
10586: -- Get other po infomation

Line 10788: | not reject if we are able to derive a single actual('Standard') |

10784: | A)Prepayment Invoice,we should not reject if we can derive |
10785: | a single shipment of type 'Prepayment' from the PO line |
10786: | we should not reject it. |
10787: | B)Any other invoice (Std, credit,debit, mixed), we should |
10788: | not reject if we are able to derive a single actual('Standard') |
10789: | shipment. |
10790: +---------------------------------------------------------------------*/
10791:
10792: SELECT line_location_id

Line 11607: --Unit Price must be always be positive for STANDARD invoices, and negative

11603:
11604: END IF;
11605:
11606:
11607: --Unit Price must be always be positive for STANDARD invoices, and negative
11608: --for CREDIT/DEBIT memos, and postive or negative for MIXED type of invoices.
11609: debug_info := '(v_check_line_po_info 34.10) Check the sign of the unit_price against'
11610: ||'the invoice type';
11611: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 11618: IF ((p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT') and

11614: END IF;
11615:
11616: --Contract Payments: Modified the IF condition to add 'PREPAYMENT'.
11617:
11618: IF ((p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT') and
11619: p_invoice_lines_rec.unit_price < 0) OR
11620: (p_invoice_rec.invoice_type_lookup_code IN ('CREDIT','DEBIT') and
11621: p_invoice_lines_rec.unit_price > 0)) THEN
11622:

Line 12137: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');

12133: SELECT po_header_id
12134: INTO l_po_header_id
12135: FROM po_headers
12136: WHERE segment1 = l_po_number
12137: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
12138: EXCEPTION
12139: when NO_DATA_FOUND then
12140: null;
12141: END;

Line 12550: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.

12546: BEGIN
12547:
12548: --Contract Payments: Modified the WHERE condition so that we check for
12549: --'Prepayment' type shipments for complex work pos for Prepayment invoices and otherwise
12550: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.
12551: SELECT 'X'
12552: INTO l_invalid_shipment_type
12553: FROM po_distributions pd,
12554: po_line_locations pll

Line 12560: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

12556: AND pd.po_distribution_id = l_po_distribution_id
12557: AND
12558: (
12559: (p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and
12560: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
12561: ) OR
12562: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12563: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
12564: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

Line 12564: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

12560: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
12561: ) OR
12562: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12563: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
12564: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))
12565: )
12566: )
12567: )
12568: AND pll.APPROVED_FLAG = 'Y'

Line 12604: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.

12600: END IF;
12601:
12602: --Contract Payments: Modified the WHERE condition so that we check for
12603: --'Prepayment' type shipments for complex work pos for Prepayment invoices and otherwise
12604: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.
12605: BEGIN
12606: SELECT 'X'
12607: INTO l_invalid_shipment_type
12608: FROM po_line_locations pll

Line 12612: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

12608: FROM po_line_locations pll
12609: WHERE line_location_id = l_po_line_location_id
12610: AND(
12611: (p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and
12612: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
12613: ) OR
12614: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12615: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
12616: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

Line 12616: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

12612: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
12613: ) OR
12614: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12615: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
12616: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))
12617: )
12618: )
12619: )
12620: AND APPROVED_FLAG = 'Y'

Line 12705: pll.SHIPMENT_TYPE NOT IN ('STANDARD','BLANKET','SCHEDULED')

12701: WHERE pll.po_line_id = l_po_line_id
12702: AND(
12703: (
12704: (p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and
12705: pll.SHIPMENT_TYPE NOT IN ('STANDARD','BLANKET','SCHEDULED')
12706: ) OR
12707: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12708: ((pll.payment_type IS NOT NULL and pll.shipment_type <> 'PREPAYMENT') or
12709: (pll.payment_type IS NULL and pll.shipment_type NOT IN ('STANDARD','BLANKET','SCHEDULED'))

Line 12709: (pll.payment_type IS NULL and pll.shipment_type NOT IN ('STANDARD','BLANKET','SCHEDULED'))

12705: pll.SHIPMENT_TYPE NOT IN ('STANDARD','BLANKET','SCHEDULED')
12706: ) OR
12707: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
12708: ((pll.payment_type IS NOT NULL and pll.shipment_type <> 'PREPAYMENT') or
12709: (pll.payment_type IS NULL and pll.shipment_type NOT IN ('STANDARD','BLANKET','SCHEDULED'))
12710: )
12711: )
12712: )
12713: /* Bug 4038403 removed these two conditions and added the below condition

Line 13015: (p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT'))) Then

13011: ------------------------------------------------------
13012: --Contract Payments: Modified the IF condition to add 'PREPAYMENT'.
13013:
13014: IF ((p_invoice_lines_rec.quantity_invoiced) <= 0 AND
13015: (p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT'))) Then
13016: debug_info :=
13017: '(v_check_line_po_info2 4) Check for Invalid Line Quantity';
13018: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
13019: AP_IMPORT_UTILITIES_PKG.Print(

Line 13047: (p_invoice_rec.invoice_type_lookup_code = 'STANDARD')) Then

13043: END IF;
13044:
13045: ELSIF (p_match_basis = 'AMOUNT') THEN
13046: IF ((p_invoice_lines_rec.amount) <= 0 AND
13047: (p_invoice_rec.invoice_type_lookup_code = 'STANDARD')) Then
13048: debug_info :=
13049: '(v_check_line_po_info2 4) Check for Invalid Line Amount';
13050: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
13051: AP_IMPORT_UTILITIES_PKG.Print(

Line 14035: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

14031: WHERE pd.line_location_id = pll.line_location_id
14032: AND pll.po_line_id = l_po_line_id
14033: AND(
14034: (p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and
14035: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
14036: ) OR
14037: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
14038: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
14039: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

Line 14039: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))

14035: pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
14036: ) OR
14037: (p_invoice_rec.invoice_type_lookup_code = 'PREPAYMENT' and
14038: ((pll.payment_type IS NOT NULL and pll.shipment_type = 'PREPAYMENT') or
14039: (pll.payment_type IS NULL and pll.shipment_type IN ('STANDARD','BLANKET','SCHEDULED'))
14040: )
14041: )
14042: )
14043: AND pll.APPROVED_FLAG = 'Y'

Line 19670: IF ( (p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT') and

19666: END IF;
19667:
19668: --Contract Payments: Modified the IF condition to add 'PREPAYMENT'.
19669:
19670: IF ( (p_invoice_rec.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT') and
19671: NVL(p_invoice_rec.control_amount, 0) > NVL(p_invoice_rec.invoice_amount, 0)) OR
19672: (p_invoice_rec.invoice_type_lookup_code IN ('CREDIT', 'DEBIT') and -- bug 7299826
19673: NVL(abs(p_invoice_rec.control_amount), NVL(abs(p_invoice_rec.invoice_amount),0)) > NVL(abs(p_invoice_rec.invoice_amount),0)) --Bug 6925674 (Base bug6905106)
19674: ) THEN

Line 21501: and nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'EXPENSE REPORT' then

21497:
21498:
21499: --if we just have vendor info then also populate the party info
21500: if p_invoice_rec.vendor_site_id is not null and p_invoice_rec.party_site_id is null
21501: and nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'EXPENSE REPORT' then
21502: Begin
21503: select party_site_id
21504: into p_invoice_rec.party_site_id
21505: from po_vendor_sites