APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_INVOICE_KEY_IND

Line 1301: INSERT INTO AP_INVOICE_KEY_IND

1297: END CURRENT_PERIOD;
1298:
1299: FUNCTION INSERT_KEY_IND RETURN BOOLEAN IS
1300: BEGIN
1301: INSERT INTO AP_INVOICE_KEY_IND
1302: (PERIOD_NAME
1303: ,LAST_UPDATE_DATE
1304: ,LAST_UPDATED_BY
1305: ,NUM_INVOICES

Line 1427: AP_INVOICE_KEY_IND

1423:
1424: FUNCTION UPDATE_KEY_IND RETURN BOOLEAN IS
1425: BEGIN
1426: UPDATE
1427: AP_INVOICE_KEY_IND
1428: SET
1429: LAST_UPDATE_DATE = SYSDATE
1430: ,LAST_UPDATED_BY = 0
1431: ,NUM_INVOICES = C_NEW_INVOICES

Line 1590: AP_INVOICE_KEY_IND INV,

1586: L_PRIOR_VENDORS_UPDATED,L_PRIOR_SITES_UPDATED,L_OLD_INVOICES_PAID,L_OLD_AUTO_CHECKS,L_OLD_MANUAL_CHECKS,
1587: L_OLD_AUTO_CHECKS_DLR,L_OLD_MANUAL_CHECKS_DLR,L_OLD_DISCOUNTS,L_OLD_DISCOUNT_DLR,L_OLD_VOID,L_OLD_STOPPED,
1588: L_OLD_SPOILED,L_OLD_OUTSTANDING,L_OLD_CLEARED,L_OLD_CLEARED_DLR,L_OLD_OUTSTANDING_DLR,L_OLD_REFUND_PAYMENTS,L_OLD_REFUND_PAYMENTS_DLR
1589: FROM
1590: AP_INVOICE_KEY_IND INV,
1591: AP_VENDOR_KEY_IND VEN,
1592: AP_PAYMENT_KEY_IND PAY
1593: WHERE INV.PERIOD_NAME = VEN.PERIOD_NAME
1594: AND INV.PERIOD_NAME = PAY.PERIOD_NAME