APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INVOICES_INTERFACE

Line 701: where entity_name = 'AP_INVOICES_INTERFACE'

697: BEGIN
698: select count(1)
699: into l_attachments_count
700: from fnd_attached_documents
701: where entity_name = 'AP_INVOICES_INTERFACE'
702: and pk1_value = p_from_invoice_id;
703:
704: -- we only need to copy attachments if there is one
705: if ( l_attachments_count > 0 )

Line 708: x_from_entity_name => 'AP_INVOICES_INTERFACE',

704: -- we only need to copy attachments if there is one
705: if ( l_attachments_count > 0 )
706: then
707: fnd_attached_documents2_pkg.copy_attachments(
708: x_from_entity_name => 'AP_INVOICES_INTERFACE',
709: x_from_pk1_value => p_from_invoice_id,
710: x_to_entity_name => 'AP_INVOICES',
711: x_to_pk1_value => p_to_invoice_id);
712: end if;

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

2737: Sequential Numbering in Invoice Open Interface (R11 only)
2738:
2739: The two modes for numbering can be:
2740: - Simple Manual Entry without Audit: Any value entered in the column
2741: AP_INVOICES_INTERFACE.VOUCHER_NUM will be inserted in AP_INVOICES.
2742: VOUCHER_NUM without validation.
2743:
2744: - Auto Voucher Numbering with Audit: A value will be obtained
2745: automatically for the record being imported and will be populated in

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

2765: If the profile value is "Partial" or "Always" and
2766: the payables option of Invoice Document Category override is
2767: "Yes" then the user can specify the document category, else the
2768: invoice will be rejected for 'Override Disabled', if the user populates
2769: AP_INVOICES_INTERFACE.DOC_CATEGORY_CODE (and override is "No").
2770:
2771: If the profile value is "Always" and no document category is specified
2772: by the user, then "Standard Invoices" category will be used for
2773: standard invoices and "Credit Memo Invoices" category will be used

Line 4031: UPDATE AP_INVOICES_INTERFACE

4027: IF AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y' THEN
4028: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
4029: END IF;
4030:
4031: UPDATE AP_INVOICES_INTERFACE
4032: SET status = p_status
4033: WHERE invoice_id = p_import_invoice_id;
4034:
4035: RETURN(TRUE);

Line 4115: UPDATE AP_INVOICES_INTERFACE

4111: -- as (request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id or request_id is null)
4112:
4113: IF p_group_id IS NULL THEN
4114:
4115: UPDATE AP_INVOICES_INTERFACE
4116: SET status = l_processed
4117: WHERE source = p_source
4118: AND p_group_id is NULL
4119: AND status = l_processing

Line 4123: UPDATE AP_INVOICES_INTERFACE

4119: AND status = l_processing
4120: AND (request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id or request_id is null);
4121: -- bug 7608232
4122:
4123: UPDATE AP_INVOICES_INTERFACE
4124: SET status = l_rejected
4125: WHERE source = p_source
4126: AND p_group_id is NULL
4127: AND status = l_rejecting

Line 4132: UPDATE AP_INVOICES_INTERFACE

4128: AND (request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id or request_id is null);
4129: -- bug 7608232
4130: ELSE
4131:
4132: UPDATE AP_INVOICES_INTERFACE
4133: SET status = l_processed
4134: WHERE source = p_source
4135: AND group_id = p_group_id
4136: AND status = l_processing

Line 4139: UPDATE AP_INVOICES_INTERFACE

4135: AND group_id = p_group_id
4136: AND status = l_processing
4137: AND (request_id = AP_IMPORT_INVOICES_PKG.g_conc_request_id or request_id is null);
4138: -- bug 7608232
4139: UPDATE AP_INVOICES_INTERFACE
4140: SET status = l_rejected
4141: WHERE source = p_source
4142: AND group_id = p_group_id
4143: AND status = l_rejecting