The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_line_type_lookup_code IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
l_credit_exists VARCHAR2(1);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
l_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_invoice_status,
p_calling_sequence);
SELECT org_id into l_ou_id FROM fnd_concurrent_requests
WHERE request_id = fnd_global.conc_request_id ;
SELECT invoice_id
INTO invo_id
FROM ap_invoice_lines_interface
WHERE invoice_line_id = P_parent_id;
SELECT nvl(liability_post_lookup_code, 'NONE')
INTO l_liability_post_lookup_code
FROM ap_system_parameters;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
invo_id,
'MULTIPLE BAL SEG FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
||', Last Updated By = '||to_char(p_default_last_updated_by)
||', Last Update Login = '||to_char(p_default_last_update_login)
||', Line Type Lookup Code = '||p_line_type_lookup_code
||', Global Attribute Category = '||p_global_attribute_category
||', Global Attribute1 = '||p_global_attribute1
||', Global Attribute2 = '||p_global_attribute2
||', Global Attribute3 = '||p_global_attribute3
||', Global Attribute4 = '||p_global_attribute4
||', Global Attribute5 = '||p_global_attribute5
||', Global Attribute6 = '||p_global_attribute6
||', Global Attribute7 = '||p_global_attribute7
||', Global Attribute8 = '||p_global_attribute8
||', Global Attribute9 = '||p_global_attribute9
||', Global Attribute10 = '||p_global_attribute10
||', Global Attribute11 = '||p_global_attribute11
||', Global Attribute12 = '||p_global_attribute12
||', Global Attribute13 = '||p_global_attribute13
||', Global Attribute14 = '||p_global_attribute14
||', Global Attribute15 = '||p_global_attribute15
||', Global Attribute16 = '||p_global_attribute16
||', Global Attribute17 = '||p_global_attribute17
||', Global Attribute18 = '||p_global_attribute18
||', Global Attribute19 = '||p_global_attribute19
||', Global Attribute20 = '||p_global_attribute20);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'JLAR_LEGAL_TRX_CATEGORY'
AND lookup_code = p_global_attribute11
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR11',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR11',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'JLAR_DOCUMENT_LETTER'
AND lookup_code = p_global_attribute12
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y' ;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR12',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR12',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM jl_ar_ap_trx_dgi_codes
WHERE trx_category = p_global_attribute11
and trx_letter = p_global_attribute12;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR13',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR13',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR15',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR15',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR15',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR16',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = p_global_attribute17
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y' ;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR17',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR17',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT nvl(liability_post_lookup_code, 'NONE')
INTO l_liability_post_lookup_code
FROM ap_system_parameters;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'MULTIPLE BAL SEG FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM HR_Locations_all
WHERE Location_id = p_global_attribute3
AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR3',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR3',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR4',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM HR_Locations_all
WHERE Location_id = p_global_attribute18
AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR18',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM PO_Vendors
WHERE segment1 = p_global_attribute2;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR2',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM HR_Locations_all
WHERE Location_id = p_global_attribute3
AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR3',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR3',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_insert_update_flag IN VARCHAR2,
p_request_id IN NUMBER,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_record_status OUT NOCOPY VARCHAR2) IS
l_current_record_status VARCHAR2(1) := 'S';
p_insert_update_flag,
p_request_id,
p_global_attribute_category,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_record_status);
p_insert_update_flag,
p_request_id,
p_global_attribute_category,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_record_status);
p_insert_update_flag,
p_request_id,
p_global_attribute_category,
p_global_attribute1,
p_global_attribute2,
p_global_attribute3,
p_global_attribute4,
p_global_attribute5,
p_global_attribute6,
p_global_attribute7,
p_global_attribute8,
p_global_attribute9,
p_global_attribute10,
p_global_attribute11,
p_global_attribute12,
p_global_attribute13,
p_global_attribute14,
p_global_attribute15,
p_global_attribute16,
p_global_attribute17,
p_global_attribute18,
p_global_attribute19,
p_global_attribute20,
l_current_record_status);
SELECT org_id into l_ou_id FROM fnd_concurrent_requests
WHERE request_id = fnd_global.conc_request_id ;
SELECT org_id into l_ou_id FROM fnd_concurrent_requests
WHERE request_id = fnd_global.conc_request_id ;
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_mesg_code,
l_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_mesg_code,
l_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
SELECT 'x'
INTO l_lookup_code
FROM dual
WHERE exists (select lookup_code
from fnd_lookups
where lookup_type = 'JLAR_TAXID_TYPE'
and lookup_code = p_glob_attr_set1.global_attribute10);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_mesg_code,
l_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_taxid_mesg_code,
l_taxid_record_status);
p_insert_update_flag IN VARCHAR2,
p_request_id IN NUMBER,
p_global_attribute_category IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_taxid_mesg_code OUT NOCOPY VARCHAR2,
p_taxid_record_status OUT NOCOPY VARCHAR2) IS
l_return_ar VARCHAR2(10):=NULL;
IF (p_insert_update_flag = 'U') THEN
BEGIN
SELECT rc.cust_account_id INTO l_customer_id
FROM hz_cust_accounts rc
WHERE rc.orig_system_reference = p_orig_system_customer_ref;
arp_util_tax.debug('jl_zz_taxid_customers: ' || 'No data found in hz_cust_accounts table for Update');
UPDATE ra_customers_interface
SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
WHERE rowid = p_row_id;
UPDATE ra_customers_interface
SET customer_number = p_jgzz_fiscal_code
WHERE rowid = p_row_id;
UPDATE ra_customers_interface
SET customer_number = p_jgzz_fiscal_code||'-'||p_global_attribute12
WHERE rowid = p_row_id;
UPDATE ra_customers_interface
SET customer_number = p_jgzz_fiscal_code
WHERE rowid = p_row_id;
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'YES_NO'
AND lookup_code = p_global_attribute1
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR1',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR1',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM jl_br_ap_operations
WHERE cfo_code = p_global_attribute2;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR2',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'JLBR_INVOICE_SERIES'
AND lookup_code = p_global_attribute3
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR3',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'JLBR_INVOICE_CLASS'
AND lookup_code = p_global_attribute4
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR4',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR5',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
SELECT invoice_date
INTO p_val_date
FROM ap_invoices_interface
WHERE invoice_id = p_parent_id;
SELECT 'X'
INTO value_exists
FROM ap_tax_codes
WHERE tax_type = 'ICMS'
AND name = p_global_attribute6
AND nvl(start_date,p_val_date) <= p_val_date
AND nvl(inactive_date,p_val_date+1) > p_val_date
AND nvl(enabled_flag,'Y') = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR6',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR7',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR8',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR9',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR10',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM jl_br_ap_operations
WHERE p_line_type_lookup_code = 'ITEM'
AND CFO_CODE = p_global_attribute1;
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR1',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
l_invoice_id NUMBER;
SELECT invoice_id,po_number
INTO l_invoice_id,l_po_number
FROM ap_invoice_lines_interface
WHERE invoice_line_id = p_parent_id;
SELECT global_attribute2,global_attribute6,global_attribute7
INTO l_cfo_code,l_icms_tax_name,l_icms_tax_amount
FROM ap_invoices_interface
WHERE invoice_id = l_invoice_id;
SELECT DISTINCT 1
INTO l_exists
FROM ap_interface_rejections
WHERE parent_id=l_invoice_id
AND parent_table = 'AP_INVOICES_INTERFACE'
AND REJECT_LOOKUP_CODE = 'INVALID_GLOBAL_ATTR2';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
l_invoice_id,
'INVALID_GLOBAL_ATTR2',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
select to_number(l_inscription_type)
into l_num_check
from dual;
select to_number(l_inscription_number)
into l_num_check
from dual;
select to_number(l_inscription_branch)
into l_num_check
from dual;
select to_number(l_inscription_digit)
into l_num_check
from dual;
jg_globe_flex_val_shared.update_interface_status
(l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_error_code,
p_record_status);
SELECT 1
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code=p_glob_attr_set2.global_attribute1
AND lookup_type = 'YES_NO'
AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
AND ENABLED_FLAG = 'Y';
SELECT 1
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code=p_glob_attr_set2.global_attribute2
AND lookup_type = 'YES_NO'
AND NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
AND ENABLED_FLAG = 'Y';
jg_globe_flex_val_shared.update_interface_status
(l_row_id,
'RA_CUSTOMER_PROFILES_INTERFACE',
l_error_code,
p_record_status);
SELECT tax_method_code
INTO l_tax_method
FROM zx_product_options;
SELECT substr(global_attribute13,1,30)
INTO l_tax_rule_set
FROM ar_system_parameters;
SELECT count(*)
INTO l_dummy
FROM jl_zz_ar_tx_att_cls tac,
jl_zz_ar_tx_categ tc
WHERE tac.tax_attr_class_code = p_glob_attr_set2.global_attribute8
AND tac.tax_attr_class_type = 'CONTRIBUTOR_CLASS'
AND tac.enabled_flag = 'Y'
AND tac.tax_category_id = tc.tax_category_id
AND tc.tax_rule_set = l_tax_rule_set;
jg_globe_flex_val_shared.update_interface_status (l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_error_code,
p_record_status);
p_default_last_updated_by IN NUMBER,
p_default_last_update_login IN NUMBER,
p_global_attribute1 IN VARCHAR2,
p_global_attribute2 IN VARCHAR2,
p_global_attribute3 IN VARCHAR2,
p_global_attribute4 IN VARCHAR2,
p_global_attribute5 IN VARCHAR2,
p_global_attribute6 IN VARCHAR2,
p_global_attribute7 IN VARCHAR2,
p_global_attribute8 IN VARCHAR2,
p_global_attribute9 IN VARCHAR2,
p_global_attribute10 IN VARCHAR2,
p_global_attribute11 IN VARCHAR2,
p_global_attribute12 IN VARCHAR2,
p_global_attribute13 IN VARCHAR2,
p_global_attribute14 IN VARCHAR2,
p_global_attribute15 IN VARCHAR2,
p_global_attribute16 IN VARCHAR2,
p_global_attribute17 IN VARCHAR2,
p_global_attribute18 IN VARCHAR2,
p_global_attribute19 IN VARCHAR2,
p_global_attribute20 IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
value_exists VARCHAR2(1);
SELECT 'X'
INTO value_exists
FROM fnd_lookups
WHERE lookup_type = 'JLCL_AP_DOCUMENT_TYPE'
AND lookup_code = p_global_attribute19
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate) >= sysdate
AND enabled_flag = 'Y';
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'INVALID_GLOBAL_ATTR19',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);
jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
p_parent_id,
'GLOBAL_ATTR_VALUE_FOUND',
p_default_last_updated_by,
p_default_last_update_login,
p_calling_sequence);