APPS.PO_INVOICES_SV2 dependencies on AP_INVOICE_LINES_INTERFACE

Line 872: from ap_invoice_lines_interface

868: (X_curr_osa_flag <> X_rcv_txns.osa_flag) --Shikyu project
869: THEN
870: /* 2531542 */
871: select count(*) into x_dist_count
872: from ap_invoice_lines_interface
873: where invoice_id = x_curr_invoice_id;
874:
875:
876:

Line 1305: from ap_invoice_lines_interface

1301:
1302: IF (X_curr_inv_process_flag = 'Y') THEN
1303:
1304: select count(*) into x_dist_count
1305: from ap_invoice_lines_interface
1306: where invoice_id = x_curr_invoice_id;
1307:
1308: if (x_dist_count > 0 ) then
1309: BEGIN

Line 1407: from ap_invoice_lines_interface

1403: asn_debug.put_line('Completed create receipt invoices program... ');
1404: END IF;
1405:
1406: select count(*) into x_dist_count
1407: from ap_invoice_lines_interface
1408: where invoice_id = x_curr_invoice_id;
1409:
1410: if (x_dist_count = 0 ) then
1411: x_invoice_count := x_invoice_count - 1;

Line 2384: FROM ap_invoice_lines_interface

2380:
2381:
2382: SELECT NVL(MAX(line_number), 0) + 1
2383: INTO X_line_count
2384: FROM ap_invoice_lines_interface
2385: WHERE invoice_id = x_invoice_id;
2386:
2387: select ap_invoice_lines_interface_s.nextval
2388: into x_invoice_line_id

Line 2387: select ap_invoice_lines_interface_s.nextval

2383: INTO X_line_count
2384: FROM ap_invoice_lines_interface
2385: WHERE invoice_id = x_invoice_id;
2386:
2387: select ap_invoice_lines_interface_s.nextval
2388: into x_invoice_line_id
2389: from sys.dual;
2390:
2391: /* Bug 1374789: We should not pass project_id and task_id

Line 2443: insert into ap_invoice_lines_interface

2439: X_invoiced_amount := X_curr_amount;
2440: X_invoiced_unit_price := X_unit_price ;
2441: END IF;
2442:
2443: insert into ap_invoice_lines_interface
2444: (INVOICE_ID,
2445: INVOICE_LINE_ID,
2446: LINE_NUMBER,
2447: LINE_TYPE_LOOKUP_CODE,

Line 3446: INSERT INTO ap_invoice_lines_interface(

3442: l_ship_to_location_id := get_ship_to_location_id(p_consumption.line_location_id(i));
3443: l_tax_classification_code := get_tax_classification_code(p_consumption.po_header_id(i),
3444: p_consumption.line_location_id(i),
3445: 'PURCHASE_ORDER');
3446: INSERT INTO ap_invoice_lines_interface(
3447: invoice_id,
3448: invoice_line_id,
3449: line_number,
3450: line_type_lookup_code,

Line 3496: ap_invoice_lines_interface_s.nextval,

3492: TAX_CLASSIFICATION_CODE --Bug: 5125624
3493: )
3494: SELECT
3495: p_consumption.invoice_id(i),
3496: ap_invoice_lines_interface_s.nextval,
3497: p_consumption.invoice_line_number(i),
3498: 'ITEM',
3499: p_consumption.invoice_line_amount(i),
3500: -- p_consumption.creation_date(i), -- bug2786193: use sysdate