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.PO_INVOICES_SV2 dependencies on AP_INVOICES

Line 458: X_curr_invoice_num ap_invoices.invoice_num%TYPE;

454: /*** The following set of curr_ variables are used to keep track of the
455: current values used to determine if a new invoice has to be created ***/
456: X_curr_invoice_amount NUMBER := 0;
457: X_curr_invoice_id NUMBER := NULL;
458: X_curr_invoice_num ap_invoices.invoice_num%TYPE;
459:
460: X_curr_vendor_id NUMBER := NULL;
461: X_curr_pay_site_id NUMBER := NULL;
462: X_curr_currency_code rcv_transactions.currency_code%TYPE := NULL;

Line 509: X_invoice_description ap_invoices.description%TYPE;

505:
506: X_batch_id NUMBER;
507: X_discountable_amount NUMBER;
508: X_inv_event VARCHAR2(26);
509: X_invoice_description ap_invoices.description%TYPE;
510: l_user_id NUMBER;
511: v_req_id NUMBER;
512:
513: /** this is the group id we insert into the

Line 785: select ap_invoices_interface_s.nextval

781: END;
782: END IF;*/
783: /* End bug 7512542 */
784:
785: select ap_invoices_interface_s.nextval
786: into x_curr_invoice_id
787: from sys.dual;
788:
789: x_group_id := substr('ERS-'||TO_CHAR(X_rcv_txns.transaction_id),1,80);

Line 802: -- parameters to this API are NOT all the columns in AP_INVOICES, the

798: END IF;
799:
800: End IF; -- X_first_rcv_txn_flag
801:
802: -- parameters to this API are NOT all the columns in AP_INVOICES, the
803: -- other columns are not used by create_receipt_invoices or create_notice_invoices.
804:
805: /**** Check to see if there is a change in vendor,
806: pay_site,

Line 837: and then insert the records in ap_invoices_interface(Headers)

833: */
834:
835: /* Bug 2531542 - The logic followed for creating invoices is to
836: insert records into ap_lines_interface first (distributions)
837: and then insert the records in ap_invoices_interface(Headers)
838: so the amount will be the total distribution amount.
839: For bug fix 1762305 , if the net received quantity is 0 then
840: distribuitions lines were not inserted. But the records were
841: inserted for the headers even for the received qty of 0.

Line 959: insert into AP_INVOICES_INTERFACE

955: X_first_rcv_txn_flag := 'Y';
956: END;
957: /* End bug 7512542 */
958:
959: insert into AP_INVOICES_INTERFACE
960: (INVOICE_ID,
961: INVOICE_NUM,
962: VENDOR_ID,
963: VENDOR_SITE_ID,

Line 1131: -- AP_INVOICES, the other columns are not used by

1127: X_ap_pay_curr := X_curr_currency_code;
1128: END IF;
1129:
1130: -- parameters to this API are NOT all the columns in
1131: -- AP_INVOICES, the other columns are not used by
1132: -- create_receipt_invoices or create_notice_invoices.
1133:
1134: END IF; /** change in one of the curr_ variables **/
1135:

Line 1336: insert into AP_INVOICES_INTERFACE

1332:
1333: /* End Bug 7512542 */
1334:
1335:
1336: insert into AP_INVOICES_INTERFACE
1337: (INVOICE_ID,
1338: INVOICE_NUM,
1339: VENDOR_ID,
1340: VENDOR_SITE_ID,

Line 1412: delete from ap_invoices_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;
1412: delete from ap_invoices_interface
1413: where invoice_id=x_curr_invoice_id;
1414: end if;
1415:
1416:

Line 1602: select ap_invoices_interface_s.nextval

1598:
1599: /*** make sure the "current" variables are correct ***/
1600: X_progress := '080';
1601:
1602: select ap_invoices_interface_s.nextval
1603: into x_curr_invoice_id
1604: from sys.dual;
1605:
1606: X_curr_invoice_amount := 0;

Line 1656: x_tmp_invoice_num ap_invoices.invoice_num%TYPE;

1652: RETURN VARCHAR2
1653: IS
1654: x_progress VARCHAR2 (3) := NULL;
1655: x_tmp_sequence_id NUMBER;
1656: x_tmp_invoice_num ap_invoices.invoice_num%TYPE;
1657: x_prefix VARCHAR2 (20);
1658:
1659: -- SBI ENH
1660: x_return_status VARCHAR2 (1);

Line 2622: l_invoice_desc ap_invoices_interface.description%TYPE;

2618: l_aging_period NUMBER;
2619: l_cutoff_date DATE;
2620: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2621: l_org_id po_headers.org_id%TYPE;
2622: l_invoice_desc ap_invoices_interface.description%TYPE;
2623:
2624: l_group_id ap_invoices_interface.group_id%TYPE;
2625: l_user_id NUMBER;
2626: l_login_id NUMBER;

Line 2624: l_group_id ap_invoices_interface.group_id%TYPE;

2620: l_def_base_currency_code ap_system_parameters.base_currency_code%TYPE;
2621: l_org_id po_headers.org_id%TYPE;
2622: l_invoice_desc ap_invoices_interface.description%TYPE;
2623:
2624: l_group_id ap_invoices_interface.group_id%TYPE;
2625: l_user_id NUMBER;
2626: l_login_id NUMBER;
2627: l_tmp_batch_id NUMBER;
2628: l_batch_name ap_batches.batch_name%TYPE;

Line 2629: l_request_id ap_invoices_interface.request_id%TYPE;

2625: l_user_id NUMBER;
2626: l_login_id NUMBER;
2627: l_tmp_batch_id NUMBER;
2628: l_batch_name ap_batches.batch_name%TYPE;
2629: l_request_id ap_invoices_interface.request_id%TYPE;
2630:
2631: l_error_msg VARCHAR2(2000);
2632: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2633: l_progress VARCHAR2(3);

Line 3280: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL

3276: END IF; -- GL_CURRENCY_API.is_fixed_rate(...)
3277:
3278: x_curr.invoice_amount := 0;
3279:
3280: SELECT AP_INVOICES_INTERFACE_S.NEXTVAL
3281: INTO x_curr.invoice_id
3282: FROM SYS.DUAL;
3283:
3284: x_curr.vendor_id := p_next_consump.vendor_id(p_index);

Line 3368: INSERT INTO ap_invoices_interface(

3364:
3365: x_return_status := FND_API.G_RET_STS_SUCCESS;
3366:
3367: FORALL i IN p_from..p_to
3368: INSERT INTO ap_invoices_interface(
3369: invoice_id,
3370: invoice_num,
3371: vendor_id,
3372: vendor_site_id,