The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fc.descriptive_flex_context_code
FROM fnd_descr_flex_contexts fc
WHERE fc.application_id = 7003
AND fc.descriptive_flex_context_code = p_context_code
AND fc.descriptive_flexfield_name = p_flexfield_name
AND fc.enabled_flag = 'Y';
TO_NUMBER(p_core_prod_arg5), -- Default Last Updated By
TO_NUMBER(p_core_prod_arg6), -- Default Last Update Login
TO_NUMBER(p_core_prod_arg8), -- Vendor Site ID -For DK EDI
p_core_prod_arg9, -- payment curency code - FOR DK EDI
p_core_prod_arg10, -- Item Type Lookup Code - FOR BR
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,
p_current_status,
p_core_prod_arg7); -- Current Calling Sequence
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_line_type_lookup_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_credit_exists VARCHAR2(1);
p_default_last_updated_by,
p_default_last_update_login,
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_invoice_status1,
l_curr_calling_sequence); -- Current Calling Sequence
p_default_last_updated_by,
p_default_last_update_login,
p_inv_vendor_site_id,
p_inv_payment_currency_code,
p_line_type_lookup_code,
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_invoice_status2,
l_curr_calling_sequence); -- Current 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_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_current_invoice_status1 VARCHAR2(1);
p_default_last_updated_by,
p_default_last_update_login,
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_invoice_status1,
l_curr_calling_sequence); -- Current Calling Sequence
p_default_last_updated_by,
p_default_last_update_login,
p_global_attribute_category,
l_current_invoice_status2,
l_curr_calling_sequence); -- Current Calling Sequence
p_default_last_updated_by IN NUMBER,
p_default_last_update_login 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_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
l_debug_loc VARCHAR2(30);
jg_globe_flex_val_shared.insert_rejections(p_parent_table,
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_attribute_category IN VARCHAR2,
p_current_invoice_status OUT NOCOPY VARCHAR2,
p_calling_sequence IN VARCHAR2) IS
l_debug_loc VARCHAR2(30);
jg_globe_flex_val_shared.insert_rejections(p_parent_table,
p_parent_id,
'INVALID_GLOBAL_CONTEXT',
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_inv_vendor_site_id IN NUMBER,
p_inv_payment_currency_code IN VARCHAR2,
p_line_type_lookup_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_credit_exists VARCHAR2(1);
p_default_last_updated_by,
p_default_last_update_login,
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,
p_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_inv_vendor_site_id,
p_inv_payment_currency_code,
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,
p_current_invoice_status,
p_calling_sequence);
p_default_last_updated_by,
p_default_last_update_login,
p_line_type_lookup_code,
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,
p_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_last_update_login IN NUMBER,
p_int_table_name IN VARCHAR2
) IS
l_current_status VARCHAR2(1);
SELECT i.customer_name, i.customer_number, i.jgzz_fiscal_code,
i.orig_system_customer_ref,i.insert_update_flag,
i.cust_tax_reference,
i.global_attribute_category,i.global_attribute1,
i.global_attribute2,i.global_attribute3,i.global_attribute4,
i.global_attribute5,i.global_attribute6,i.global_attribute7,
i.global_attribute8,i.global_attribute9,i.global_attribute10,
i.global_attribute11,i.global_attribute12,i.global_attribute13,
i.global_attribute14,i.global_attribute15,i.global_attribute16,
i.global_attribute17,i.global_attribute18,i.global_attribute19,
i.global_attribute20,
i.gdf_address_attr_cat,i.gdf_address_attribute1,
i.gdf_address_attribute2,i.gdf_address_attribute3,i.gdf_address_attribute4,
i.gdf_address_attribute5,i.gdf_address_attribute6,i.gdf_address_attribute7,
i.gdf_address_attribute8,i.gdf_address_attribute9,i.gdf_address_attribute10,
i.gdf_address_attribute11,i.gdf_address_attribute12,i.gdf_address_attribute13,
i.gdf_address_attribute14,i.gdf_address_attribute15,i.gdf_address_attribute16,
i.gdf_address_attribute17,i.gdf_address_attribute18,i.gdf_address_attribute19,
i.gdf_address_attribute20,
i.gdf_site_use_attr_cat,i.gdf_site_use_attribute1,
i.gdf_site_use_attribute2,i.gdf_site_use_attribute3,i.gdf_site_use_attribute4,
i.gdf_site_use_attribute5,i.gdf_site_use_attribute6,i.gdf_site_use_attribute7,
i.gdf_site_use_attribute8,i.gdf_site_use_attribute9,i.gdf_site_use_attribute10,
i.gdf_site_use_attribute11,i.gdf_site_use_attribute12,i.gdf_site_use_attribute13,
i.gdf_site_use_attribute14,i.gdf_site_use_attribute15,i.gdf_site_use_attribute16,
i.gdf_site_use_attribute17,i.gdf_site_use_attribute18,i.gdf_site_use_attribute19,
i.gdf_site_use_attribute20,
i.rowid
FROM ra_customers_interface i
WHERE i.request_id = p_request_id
AND nvl(i.validated_flag,'N') <> 'Y';
SELECT i.global_attribute_category,i.global_attribute1,
i.global_attribute2,i.global_attribute3,i.global_attribute4,
i.global_attribute5,i.global_attribute6,i.global_attribute7,
i.global_attribute8,i.global_attribute9,i.global_attribute10,
i.global_attribute11,i.global_attribute12,i.global_attribute13,
i.global_attribute14,i.global_attribute15,i.global_attribute16,
i.global_attribute17,i.global_attribute18,i.global_attribute19,
i.global_attribute20,
i.gdf_cust_prof_attr_cat,i.gdf_cust_prof_attribute1,
i.gdf_cust_prof_attribute2,i.gdf_cust_prof_attribute3,i.gdf_cust_prof_attribute4,
i.gdf_cust_prof_attribute5,i.gdf_cust_prof_attribute6,i.gdf_cust_prof_attribute7,
i.gdf_cust_prof_attribute8,i.gdf_cust_prof_attribute9,i.gdf_cust_prof_attribute10,
i.gdf_cust_prof_attribute11,i.gdf_cust_prof_attribute12,i.gdf_cust_prof_attribute13,
i.gdf_cust_prof_attribute14,i.gdf_cust_prof_attribute15,i.gdf_cust_prof_attribute16,
i.gdf_cust_prof_attribute17,i.gdf_cust_prof_attribute18,i.gdf_cust_prof_attribute19,
i.gdf_cust_prof_attribute20,
i.rowid
FROM ra_customer_profiles_interface i
WHERE i.request_id = p_request_id
AND nvl(i.validated_flag,'N') <> 'Y';
SELECT s.generate_customer_number
FROM ar_system_parameters s
WHERE s.set_of_books_id = p_sob_id;
gdf_general_rec.core_prod_arg8 := idx_cur.insert_update_flag;
JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
l_errcode,
p_glob_attr_general.core_prod_arg2,
'E');
JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
p_glob_attr_general.core_prod_arg2,
'RA_CUSTOMER_PROFILES_INTERFACE',
l_errcode,
'E');
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);
SELECT org_id into l_org_id FROM fnd_concurrent_requests
WHERE request_id = fnd_global.conc_request_id ;
PROCEDURE insert_jg_zz_invoice_info
(p_invoice_id IN NUMBER,
p_global_attribute_category IN OUT NOCOPY 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_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_calling_sequence IN VARCHAR2) IS
l_debug_loc VARCHAR2(30);
PROCEDURE insert_global_tables
(p_table_name IN VARCHAR2,
p_key_column1 IN VARCHAR2,
p_key_column2 IN VARCHAR2,
p_key_column3 IN VARCHAR2,
p_key_column4 IN VARCHAR2,
p_key_column5 IN VARCHAR2,
p_key_column6 IN VARCHAR2) IS
l_product_code VARCHAR2(2);
arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.insert_global_tabl
es');