APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INVOICES_INTERFACE

Line 24: where entity_name = 'AP_INVOICES_INTERFACE'

20: BEGIN
21: select count(1)
22: into l_attachments_count
23: from fnd_attached_documents
24: where entity_name = 'AP_INVOICES_INTERFACE'
25: and pk1_value = p_from_invoice_id;
26:
27: -- we only need to copy attachments if there is one
28: if ( l_attachments_count > 0 )

Line 31: x_from_entity_name => 'AP_INVOICES_INTERFACE',

27: -- we only need to copy attachments if there is one
28: if ( l_attachments_count > 0 )
29: then
30: fnd_attached_documents2_pkg.copy_attachments(
31: x_from_entity_name => 'AP_INVOICES_INTERFACE',
32: x_from_pk1_value => p_from_invoice_id,
33: x_to_entity_name => 'AP_INVOICES',
34: x_to_pk1_value => p_to_invoice_id);
35: end if;

Line 2057: AP_INVOICES_INTERFACE.VOUCHER_NUM will be inserted in AP_INVOICES.

2053: Sequential Numbering in Invoice Open Interface (R11 only)
2054:
2055: The two modes for numbering can be:
2056: - Simple Manual Entry without Audit: Any value entered in the column
2057: AP_INVOICES_INTERFACE.VOUCHER_NUM will be inserted in AP_INVOICES.
2058: VOUCHER_NUM without validation.
2059:
2060: - Auto Voucher Numbering with Audit: A value will be obtained
2061: automatically for the record being imported and will be populated in

Line 2085: AP_INVOICES_INTERFACE.DOC_CATEGORY_CODE (and override is "No").

2081: If the profile value is "Partial" or "Always" and
2082: the payables option of Invoice Document Category override is
2083: "Yes" then the user can specify the document category, else the
2084: invoice will be rejected for 'Override Disabled', if the user populates
2085: AP_INVOICES_INTERFACE.DOC_CATEGORY_CODE (and override is "No").
2086:
2087: If the profile value is "Always" and no document category is specified
2088: by the user, then "Standard Invoices" category will be used for
2089: standard invoices and "Credit Memo Invoices" category will be used

Line 3336: UPDATE AP_INVOICES_INTERFACE

3332: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN
3333: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
3334: END IF;
3335:
3336: UPDATE AP_INVOICES_INTERFACE
3337: SET status = p_status
3338: WHERE invoice_id = p_import_invoice_id;
3339:
3340: RETURN(TRUE);

Line 3418: UPDATE AP_INVOICES_INTERFACE

3414: --pertaining to the current request. Modified the below 4 update stmts.
3415:
3416: IF p_group_id IS NULL THEN
3417:
3418: UPDATE AP_INVOICES_INTERFACE
3419: SET status = l_processed
3420: WHERE source = p_source
3421: AND p_group_id is NULL
3422: AND status = l_processing

Line 3425: UPDATE AP_INVOICES_INTERFACE

3421: AND p_group_id is NULL
3422: AND status = l_processing
3423: AND request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id;
3424:
3425: UPDATE AP_INVOICES_INTERFACE
3426: SET status = l_rejected
3427: WHERE source = p_source
3428: AND p_group_id is NULL
3429: AND status = l_rejecting

Line 3434: UPDATE AP_INVOICES_INTERFACE

3430: AND request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id;
3431:
3432: ELSE
3433:
3434: UPDATE AP_INVOICES_INTERFACE
3435: SET status = l_processed
3436: WHERE source = p_source
3437: AND group_id = p_group_id
3438: AND status = l_processing

Line 3441: UPDATE AP_INVOICES_INTERFACE

3437: AND group_id = p_group_id
3438: AND status = l_processing
3439: ANd request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id;
3440:
3441: UPDATE AP_INVOICES_INTERFACE
3442: SET status = l_rejected
3443: WHERE source = p_source
3444: AND group_id = p_group_id
3445: AND status = l_rejecting