[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_update_login IN NUMBER
)
IS
l_return_status VARCHAR2(30);
SELECT SYSDATE
INTO l_note_date
FROM sys.dual;
p_last_update_date => l_note_date,
p_last_updated_by => p_created_by,
p_creation_date => l_note_date,
p_created_by => p_created_by,
p_last_update_login => p_last_update_login,
p_note_type => 'CUG_SR_ATTR_DETAILS',
p_note_status => l_note_status,
p_jtf_note_contexts_tab => l_note_context_tab_dflt );
p_last_update_date => l_note_date,
p_last_updated_by => p_created_by,
p_creation_date => l_note_date,
p_created_by => p_created_by,
p_last_update_login => p_last_update_login,
p_note_type => 'CUG_SR_ATTR_DETAILS',
p_note_status => l_note_status,
p_jtf_note_contexts_tab => l_note_context_tab_dflt,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data );
SELECT *
FROM cs_incidents_all_b
WHERE incident_id = p_incident_id ;
SELECT sr_attribute_code,
sr_attribute_value
FROM cug_incidnt_attr_vals_vl
WHERE incident_id = p_incident_id ;
p_last_update_login IN NUMBER,
p_cic_attribute_code IN JTF_VARCHAR2_TABLE_100,
p_cic_attr_value IN JTF_VARCHAR2_TABLE_2000,
p_cic_attr_lookup IN JTF_VARCHAR2_TABLE_100
)
IS
l_create_attribute_note CLOB := NULL;
l_last_updated_by NUMBER(15);
SELECT Description
INTO l_new_constant
FROM Fnd_Lookup_values
WHERE Lookup_Code = 'CUG_SR_AUTONOTE_NEW'
AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
AND language = userenv('LANG');
SELECT SYSDATE
INTO l_creation_date
FROM sys.dual;
SELECT Description
INTO l_attr_name
FROM Fnd_Lookups
WHERE Lookup_Code = p_cic_attribute_code(i)
AND Lookup_Type = 'CUG_SR_TYPE_ATTRIBUTES';
SELECT Meaning ,description
INTO l_attr_value ,l_attr_description
FROM Fnd_Lookups
WHERE Lookup_Code = p_cic_attr_value(i)
AND Lookup_Type = p_cic_attr_lookup(i);
SELECT CUG_INCIDNT_ATTR_VALS_B_S.nextval
INTO l_incident_attr_val_id
FROM sys.dual;
CUG_INCIDNT_ATTR_VALS_PKG.INSERT_ROW( X_ROWID => l_row_id,
X_INCIDNT_ATTR_VAL_ID => l_incident_attr_val_id,
X_OBJECT_VERSION_NUMBER => l_object_version_number,
X_INCIDENT_ID => p_incident_id,
X_SR_ATTRIBUTE_CODE => p_cic_attribute_code(i),
X_OVERRIDE_ADDR_VALID_FLAG => p_override_addr_valid_flag,
X_ATTRIBUTE1 => l_ATTRIBUTE1,
X_ATTRIBUTE2 => l_ATTRIBUTE2,
X_ATTRIBUTE3 => l_ATTRIBUTE3,
X_ATTRIBUTE4 => l_ATTRIBUTE4,
X_ATTRIBUTE5 => l_ATTRIBUTE5,
X_ATTRIBUTE6 => l_ATTRIBUTE6,
X_ATTRIBUTE7 => l_ATTRIBUTE7,
X_ATTRIBUTE8 => l_ATTRIBUTE8,
X_ATTRIBUTE9 => l_ATTRIBUTE9,
X_ATTRIBUTE10 => l_ATTRIBUTE10,
X_ATTRIBUTE11 => l_ATTRIBUTE11,
X_ATTRIBUTE12 => l_ATTRIBUTE12,
X_ATTRIBUTE13 => l_ATTRIBUTE13,
X_ATTRIBUTE14 => l_ATTRIBUTE14,
X_ATTRIBUTE15 => l_ATTRIBUTE15,
X_ATTRIBUTE_CATEGORY => l_ATTRIBUTE_CATEGORY,
X_SR_ATTRIBUTE_VALUE => l_attr_description, -- p_cic_attr_value(i), -- Added l_attr_description for bug 12379451
X_CREATED_BY => p_created_by,
X_LAST_UPDATED_BY => p_created_by,
X_LAST_UPDATE_LOGIN => p_last_update_login,
X_CREATION_DATE => l_creation_date,
X_LAST_UPDATE_DATE => l_creation_date );
p_last_update_login );
p_last_update_login );
PROCEDURE UPDATE_CIC_ATTR_RECORD (
p_incident_attr_val_id IN JTF_NUMBER_TABLE,
p_incident_type_id IN NUMBER,
p_incident_id IN NUMBER,
p_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_cic_attribute_code IN JTF_VARCHAR2_TABLE_100,
p_cic_attr_value IN JTF_VARCHAR2_TABLE_2000,
p_cic_attr_lookup IN JTF_VARCHAR2_TABLE_100,
p_override_addr_valid_flag IN VARCHAR2,
p_address_summary IN VARCHAR2
)
IS
l_attr_name VARCHAR2(240);
l_update_attribute_note VARCHAR2(20000) := NULL;
l_update_note_flag VARCHAR2(1) := 'N';
l_last_update_date DATE;
SELECT count(1)
INTO l_value_count
FROM CUG_INCIDNT_ATTR_VALS_B
WHERE INCIDENT_ID = p_incident_id;
SELECT Description
INTO l_old_values
FROM Fnd_Lookup_values
WHERE Lookup_Code = 'CUG_SR_AUTONOTE_OLD'
AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
AND language = userenv('LANG');
SELECT Description
INTO l_new_values
FROM Fnd_Lookup_values
WHERE Lookup_Code = 'CUG_SR_AUTONOTE_NEW'
AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
AND language = userenv('LANG');
SELECT SYSDATE
INTO l_last_update_date
FROM sys.dual;
SELECT Description
INTO l_attr_name
FROM Fnd_Lookups
WHERE Lookup_Code = p_cic_attribute_code(i)
AND Lookup_Type = 'CUG_SR_TYPE_ATTRIBUTES';
SELECT Description
INTO l_attr_value
FROM Fnd_Lookups
WHERE Lookup_Code = p_cic_attr_value(i)
AND Lookup_Type = p_cic_attr_lookup(i);
SELECT Object_Version_Number ,
Override_Addr_Valid_Flag,
Sr_Attribute_Value
INTO l_object_version_number ,
l_override_addr_valid_flag,
l_old_attr_values
FROM cug_incidnt_attr_vals_vl
WHERE INCIDNT_ATTR_VAL_ID = p_incident_attr_val_id(i);
l_update_note_flag := 'Y';
CUG_INCIDNT_ATTR_VALS_PKG.UPDATE_ROW( X_INCIDNT_ATTR_VAL_ID => p_incident_attr_val_id(i),
X_OBJECT_VERSION_NUMBER => l_object_version_number,
X_INCIDENT_ID => p_incident_id,
X_SR_ATTRIBUTE_CODE => p_cic_attribute_code(i),
X_OVERRIDE_ADDR_VALID_FLAG => l_override_addr_valid_flag,
X_ATTRIBUTE1 => l_ATTRIBUTE1,
X_ATTRIBUTE2 => l_ATTRIBUTE2,
X_ATTRIBUTE3 => l_ATTRIBUTE3,
X_ATTRIBUTE4 => l_ATTRIBUTE4,
X_ATTRIBUTE5 => l_ATTRIBUTE5,
X_ATTRIBUTE6 => l_ATTRIBUTE6,
X_ATTRIBUTE7 => l_ATTRIBUTE7,
X_ATTRIBUTE8 => l_ATTRIBUTE8,
X_ATTRIBUTE9 => l_ATTRIBUTE9,
X_ATTRIBUTE10 => l_ATTRIBUTE10,
X_ATTRIBUTE11 => l_ATTRIBUTE11,
X_ATTRIBUTE12 => l_ATTRIBUTE12,
X_ATTRIBUTE13 => l_ATTRIBUTE13,
X_ATTRIBUTE14 => l_ATTRIBUTE14,
X_ATTRIBUTE15 => l_ATTRIBUTE15,
X_ATTRIBUTE_CATEGORY => l_ATTRIBUTE_CATEGORY,
X_SR_ATTRIBUTE_VALUE => l_attr_value, -- p_cic_attr_value(i), -- Added l_attr_value for bug 12379451
X_LAST_UPDATE_DATE => l_last_update_date,
X_LAST_UPDATED_BY => p_updated_by,
X_LAST_UPDATE_LOGIN => p_last_update_login);
module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
message => 'Attribute ID = '||p_incident_attr_val_id(i)||'; Attribute Code = '||p_cic_attribute_code(i)||'; Value ='||p_cic_attr_value(i));
l_update_attribute_note := l_new_values || fnd_global.newline() || l_old_values;
IF l_update_note_flag <> 'N' THEN
-- Create Update Attribute Note --
CREATE_CIC_ATTRIBUTE_NOTE ( p_incident_id,
l_update_attribute_note,
NULL,
p_updated_by,
p_last_update_login );
p_updated_by,
p_last_update_login,
p_cic_attribute_code,
p_cic_attr_value,
p_cic_attr_lookup
);
module => 'CS.CS_CIC_ATTRIBUTE_PUB.UPDATE_CIC_ATTR_RECORD',
message => 'SQL Exception: '||SQLERRM);
END UPDATE_CIC_ATTR_RECORD;
PROCEDURE DELETE_CIC_ATTR_RECORD
(
p_incident_attr_val_id IN JTF_NUMBER_TABLE
)
IS
l_return_status VARCHAR2(30);
CUG_INCIDNT_ATTR_VALS_PKG.DELETE_ROW ( p_incident_attr_val_id(i) );
module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
message => 'Deleted Attribute ID: '||p_incident_attr_val_id(i));
module => 'CS.CS_CIC_ATTRIBUTE_PUB.DELETE_CIC_ATTR_RECORD',
message => 'SQL Exception: '||SQLERRM);
END DELETE_CIC_ATTR_RECORD;