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_inv_vendor_site_id IN NUMBER,
p_inv_payment_currency_code IN VARCHAR2,
p_global_attribute_category IN VARCHAR2,
p_global_attribute1 IN OUT NOCOPY VARCHAR2,
p_global_attribute2 IN OUT NOCOPY VARCHAR2,
p_global_attribute3 IN OUT NOCOPY VARCHAR2,
p_global_attribute4 IN OUT NOCOPY VARCHAR2,
p_global_attribute5 IN OUT NOCOPY VARCHAR2,
p_global_attribute6 IN OUT NOCOPY VARCHAR2,
p_global_attribute7 IN OUT NOCOPY VARCHAR2,
p_global_attribute8 IN OUT NOCOPY VARCHAR2,
p_global_attribute9 IN OUT NOCOPY VARCHAR2,
p_global_attribute10 IN OUT NOCOPY VARCHAR2,
p_global_attribute11 IN OUT NOCOPY VARCHAR2,
p_global_attribute12 IN OUT NOCOPY VARCHAR2,
p_global_attribute13 IN OUT NOCOPY VARCHAR2,
p_global_attribute14 IN OUT NOCOPY VARCHAR2,
p_global_attribute15 IN OUT NOCOPY VARCHAR2,
p_global_attribute16 IN OUT NOCOPY VARCHAR2,
p_global_attribute17 IN OUT NOCOPY VARCHAR2,
p_global_attribute18 IN OUT NOCOPY VARCHAR2,
p_global_attribute19 IN OUT NOCOPY VARCHAR2,
p_global_attribute20 IN OUT NOCOPY VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
l_current_invoice_status VARCHAR2(1) := 'Y';
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);
||', Last Updated By = '||to_char(p_default_last_updated_by)
||', Last Update Login = '||to_char(p_default_last_update_login)
||', 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
l_def_exp_acc_exists VARCHAR2(1);
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,
'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
BEGIN
IF (
-- bug 1579266 this country uses global attribute 5,6,7
-- (p_global_attribute5 IS NOT NULL) OR
-- (p_global_attribute6 IS NOT NULL) OR
-- (p_global_attribute7 IS NOT NULL) OR
-- (p_global_attribute2 IS NOT NULL) OR
(p_global_attribute8 IS NOT NULL) OR
(p_global_attribute9 IS NOT NULL) OR
(p_global_attribute10 IS NOT NULL) OR
(p_global_attribute11 IS NOT NULL) OR
(p_global_attribute12 IS NOT NULL) OR
(p_global_attribute13 IS NOT NULL) OR
(p_global_attribute14 IS NOT NULL) OR
(p_global_attribute15 IS NOT NULL) OR
(p_global_attribute16 IS NOT NULL) OR
(p_global_attribute17 IS NOT NULL) OR
(p_global_attribute18 IS NOT NULL) OR
(p_global_attribute19 IS NOT NULL) OR
(p_global_attribute20 IS NOT NULL))
THEN
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
BEGIN
IF (p_global_attribute2 IS NOT NULL AND
p_global_attribute2 NOT IN ('Y','N')) OR
(p_global_attribute2 IS NULL) THEN
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);
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
l_stat_code_exists VARCHAR2(1);
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);
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);
SELECT org_id into l_ou_id FROM fnd_concurrent_requests
WHERE request_id = fnd_global.conc_request_id ;
SELECT 1
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code=p_glob_attr_set1.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';
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_set3.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';
jg_globe_flex_val_shared.update_interface_status
(l_row_id,
'RA_CUSTOMERS_INTERFACE',
l_error_code,
p_record_status);