The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* procedure to insert INSERT_ROW */
PROCEDURE INSERT_ROW
(
PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
PX_RESPONSE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
P_created_by IN NUMBER ,
P_creation_date IN DATE ,
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_RESPONSE_NAME IN VARCHAR2,
P_DESCRIPTION IN VARCHAR2 := NULL,
P_CONTEXT IN VARCHAR2 := NULL,
P_ATTRIBUTE1 IN VARCHAR2 := NULL,
P_ATTRIBUTE2 IN VARCHAR2 := NULL,
P_ATTRIBUTE3 IN VARCHAR2 := NULL,
P_ATTRIBUTE4 IN VARCHAR2 := NULL,
P_ATTRIBUTE5 IN VARCHAR2 := NULL,
P_ATTRIBUTE6 IN VARCHAR2 := NULL,
P_ATTRIBUTE7 IN VARCHAR2 := NULL,
P_ATTRIBUTE8 IN VARCHAR2 := NULL,
P_ATTRIBUTE9 IN VARCHAR2 := NULL,
P_ATTRIBUTE10 IN VARCHAR2 := NULL,
P_ATTRIBUTE11 IN VARCHAR2 := NULL,
P_ATTRIBUTE12 IN VARCHAR2 := NULL,
P_ATTRIBUTE13 IN VARCHAR2 := NULL,
P_ATTRIBUTE14 IN VARCHAR2 := NULL,
P_ATTRIBUTE15 IN VARCHAR2 := NULL,
P_ATTRIBUTE16 IN VARCHAR2 := NULL,
P_ATTRIBUTE17 IN VARCHAR2 := NULL,
P_ATTRIBUTE18 IN VARCHAR2 := NULL,
P_ATTRIBUTE19 IN VARCHAR2 := NULL,
P_ATTRIBUTE20 IN VARCHAR2 := NULL
)
IS
cursor c is
select ROWID
from aso_sup_response_B
where RESPONSE_ID = PX_RESPONSE_ID ;
select aso_sup_response_B_S.NEXTVAL from sys.dual;
insert into ASO_SUP_RESPONSE_B (
RESPONSE_ID,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login ,
CONTEXT,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15 ,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20)
values
(
PX_RESPONSE_ID,
P_created_by ,
P_creation_date ,
P_last_updated_by ,
P_last_update_date ,
P_last_update_login,
P_CONTEXT,
P_ATTRIBUTE1 ,
P_ATTRIBUTE2 ,
P_ATTRIBUTE3 ,
P_ATTRIBUTE4 ,
P_ATTRIBUTE5 ,
P_ATTRIBUTE6 ,
P_ATTRIBUTE7 ,
P_ATTRIBUTE8 ,
P_ATTRIBUTE9 ,
P_ATTRIBUTE10 ,
P_ATTRIBUTE11 ,
P_ATTRIBUTE12 ,
P_ATTRIBUTE13 ,
P_ATTRIBUTE14 ,
P_ATTRIBUTE15,
P_ATTRIBUTE16,
P_ATTRIBUTE17,
P_ATTRIBUTE18,
P_ATTRIBUTE19,
P_ATTRIBUTE20
);
insert into ASO_SUP_RESPONSE_TL (
RESPONSE_ID,
LANGUAGE,
SOURCE_LANG,
RESPONSE_NAME,
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
) select
PX_RESPONSE_ID,
L.LANGUAGE_CODE,
userenv('LANG'),
P_RESPONSE_NAME,
P_DESCRIPTION,
P_LAST_UPDATE_DATE,
P_LAST_UPDATED_BY,
P_CREATION_DATE,
P_CREATED_BY,
P_LAST_UPDATE_LOGIN
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
( select 'x'
from ASO_SUP_RESPONSE_TL T
where T.RESPONSE_ID = PX_RESPONSE_ID
and T.LANGUAGE = L.LANGUAGE_CODE );
end INSERT_ROW;
PROCEDURE UPDATE_ROW
(
P_RESPONSE_ID IN NUMBER,
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_RESPONSE_NAME IN VARCHAR2,
P_DESCRIPTION IN VARCHAR2,
P_CONTEXT IN VARCHAR2,
P_ATTRIBUTE1 IN VARCHAR2,
P_ATTRIBUTE2 IN VARCHAR2,
P_ATTRIBUTE3 IN VARCHAR2,
P_ATTRIBUTE4 IN VARCHAR2,
P_ATTRIBUTE5 IN VARCHAR2,
P_ATTRIBUTE6 IN VARCHAR2,
P_ATTRIBUTE7 IN VARCHAR2,
P_ATTRIBUTE8 IN VARCHAR2,
P_ATTRIBUTE9 IN VARCHAR2,
P_ATTRIBUTE10 IN VARCHAR2,
P_ATTRIBUTE11 IN VARCHAR2,
P_ATTRIBUTE12 IN VARCHAR2,
P_ATTRIBUTE13 IN VARCHAR2,
P_ATTRIBUTE14 IN VARCHAR2,
P_ATTRIBUTE15 IN VARCHAR2,
P_ATTRIBUTE16 IN VARCHAR2,
P_ATTRIBUTE17 IN VARCHAR2,
P_ATTRIBUTE18 IN VARCHAR2,
P_ATTRIBUTE19 IN VARCHAR2,
P_ATTRIBUTE20 IN VARCHAR2
)
IS
Begin
update ASO_SUP_RESPONSE_B
set
last_updated_by = P_last_updated_by,
last_update_date = P_last_update_date,
last_update_login = P_last_update_login,
context = P_context,
ATTRIBUTE1 = P_ATTRIBUTE1,
ATTRIBUTE2 = P_ATTRIBUTE2,
ATTRIBUTE3 = P_ATTRIBUTE3,
ATTRIBUTE4 = P_ATTRIBUTE4,
ATTRIBUTE5 = P_ATTRIBUTE5,
ATTRIBUTE6 = P_ATTRIBUTE6,
ATTRIBUTE7 = P_ATTRIBUTE7,
ATTRIBUTE8 = P_ATTRIBUTE8,
ATTRIBUTE9 = P_ATTRIBUTE9,
ATTRIBUTE10 = P_ATTRIBUTE10,
ATTRIBUTE11 = P_ATTRIBUTE11,
ATTRIBUTE12 = P_ATTRIBUTE12,
ATTRIBUTE13 = P_ATTRIBUTE13,
ATTRIBUTE14 = P_ATTRIBUTE14,
ATTRIBUTE15 = P_ATTRIBUTE15,
ATTRIBUTE16 = P_ATTRIBUTE16,
ATTRIBUTE17 = P_ATTRIBUTE17,
ATTRIBUTE18 = P_ATTRIBUTE18,
ATTRIBUTE19 = P_ATTRIBUTE19,
ATTRIBUTE20 = P_ATTRIBUTE20
where RESPONSE_ID = P_RESPONSE_ID;
update ASO_SUP_RESPONSE_TL
set
RESPONSE_NAME = P_RESPONSE_NAME,
DESCRIPTION = P_DESCRIPTION,
LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
LAST_UPDATED_BY = P_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where RESPONSE_ID = P_RESPONSE_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG) ;
End UPDATE_ROW;
procedure DELETE_ROW (
P_RESPONSE_ID IN NUMBER
)
IS
Begin
delete from ASO_SUP_RESPONSE_TL
where RESPONSE_ID = P_RESPONSE_ID;
delete from ASO_SUP_RESPONSE_B
where RESPONSE_ID = P_RESPONSE_ID;
End Delete_row;
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_RESPONSE_NAME IN VARCHAR2,
P_DESCRIPTION IN VARCHAR2,
P_CONTEXT IN VARCHAR2,
P_ATTRIBUTE1 IN VARCHAR2,
P_ATTRIBUTE2 IN VARCHAR2,
P_ATTRIBUTE3 IN VARCHAR2,
P_ATTRIBUTE4 IN VARCHAR2,
P_ATTRIBUTE5 IN VARCHAR2,
P_ATTRIBUTE6 IN VARCHAR2,
P_ATTRIBUTE7 IN VARCHAR2,
P_ATTRIBUTE8 IN VARCHAR2,
P_ATTRIBUTE9 IN VARCHAR2,
P_ATTRIBUTE10 IN VARCHAR2,
P_ATTRIBUTE11 IN VARCHAR2,
P_ATTRIBUTE12 IN VARCHAR2,
P_ATTRIBUTE13 IN VARCHAR2,
P_ATTRIBUTE14 IN VARCHAR2,
P_ATTRIBUTE15 IN VARCHAR2
)
IS
CURSOR i_csr is
SELECT
a.RESPONSE_ID ,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login ,
context,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15
from ASO_SUP_RESPONSE_B a
where a.RESPONSE_ID = P_RESPONSE_ID
for update of a.RESPONSE_ID nowait;
select
RESPONSE_NAME,
DESCRIPTION,
decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
from ASO_SUP_RESPONSE_TL
where RESPONSE_ID = P_RESPONSE_ID
for update of RESPONSE_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((recinfo.LAST_UPDATED_BY = P_LAST_UPDATED_BY)
OR ((recinfo.LAST_UPDATED_BY is null) AND (P_LAST_UPDATED_BY is null)))
AND ((recinfo.LAST_UPDATE_DATE = P_LAST_UPDATE_DATE)
OR ((recinfo.LAST_UPDATE_DATE is null) AND (P_LAST_UPDATE_DATE is null)))
AND ((recinfo.LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN)
OR ((recinfo.LAST_UPDATE_LOGIN is null) AND (P_LAST_UPDATE_LOGIN is null)))
AND ((recinfo.CONTEXT = P_CONTEXT)
OR ((recinfo.CONTEXT is null) AND (P_CONTEXT is null)))
AND ((recinfo.ATTRIBUTE1 = P_ATTRIBUTE1)
OR ((recinfo.ATTRIBUTE1 is null) AND (P_ATTRIBUTE1 is null)))
AND ((recinfo.ATTRIBUTE2 = P_ATTRIBUTE2)
OR ((recinfo.ATTRIBUTE2 is null) AND (P_ATTRIBUTE2 is null)))
AND ((recinfo.ATTRIBUTE3 = P_ATTRIBUTE3)
OR ((recinfo.ATTRIBUTE3 is null) AND (P_ATTRIBUTE3 is null)))
AND ((recinfo.ATTRIBUTE4 = P_ATTRIBUTE4)
OR ((recinfo.ATTRIBUTE4 is null) AND (P_ATTRIBUTE4 is null)))
AND ((recinfo.ATTRIBUTE5 = P_ATTRIBUTE5)
OR ((recinfo.ATTRIBUTE5 is null) AND (P_ATTRIBUTE5 is null)))
AND ((recinfo.ATTRIBUTE6 = P_ATTRIBUTE6)
OR ((recinfo.ATTRIBUTE6 is null) AND (P_ATTRIBUTE6 is null)))
AND ((recinfo.ATTRIBUTE7 = P_ATTRIBUTE7)
OR ((recinfo.ATTRIBUTE7 is null) AND (P_ATTRIBUTE7 is null)))
AND ((recinfo.ATTRIBUTE8 = P_ATTRIBUTE8)
OR ((recinfo.ATTRIBUTE8 is null) AND (P_ATTRIBUTE8 is null)))
AND ((recinfo.ATTRIBUTE9 = P_ATTRIBUTE9)
OR ((recinfo.ATTRIBUTE9 is null) AND (P_ATTRIBUTE9 is null)))
AND ((recinfo.ATTRIBUTE10 = P_ATTRIBUTE10)
OR ((recinfo.ATTRIBUTE10 is null) AND (P_ATTRIBUTE10 is null)))
AND ((recinfo.ATTRIBUTE11 = P_ATTRIBUTE11)
OR ((recinfo.ATTRIBUTE11 is null) AND (P_ATTRIBUTE11 is null)))
AND ((recinfo.ATTRIBUTE12 = P_ATTRIBUTE12)
OR ((recinfo.ATTRIBUTE12 is null) AND (P_ATTRIBUTE12 is null)))
AND ((recinfo.ATTRIBUTE13 = P_ATTRIBUTE13)
OR ((recinfo.ATTRIBUTE13 is null) AND (P_ATTRIBUTE13 is null)))
AND ((recinfo.ATTRIBUTE14 = P_ATTRIBUTE14)
OR ((recinfo.ATTRIBUTE14 is null) AND (P_ATTRIBUTE14 is null)))
AND ((recinfo.ATTRIBUTE15 = P_ATTRIBUTE15)
OR ((recinfo.ATTRIBUTE15 is null) AND (P_ATTRIBUTE15 is null)))
) then
null;
delete from ASO_SUP_RESPONSE_TL T
where not exists
( select NULL
from ASO_SUP_RESPONSE_B B
where B.RESPONSE_ID = T.RESPONSE_ID
);
update ASO_SUP_RESPONSE_TL T set (
RESPONSE_NAME,
DESCRIPTION
) = ( select
B.RESPONSE_NAME,
B.DESCRIPTION
from ASO_SUP_RESPONSE_TL B
where B.RESPONSE_ID = T.RESPONSE_ID
and B.LANGUAGE = T.SOURCE_LANG )
where (
T.RESPONSE_ID,
T.LANGUAGE
) in ( select
SUBT.RESPONSE_ID,
SUBT.LANGUAGE
from ASO_SUP_RESPONSE_TL SUBB,
ASO_SUP_RESPONSE_TL SUBT
where SUBB.RESPONSE_ID = SUBT.RESPONSE_ID
and SUBB.LANGUAGE = SUBT.SOURCE_LANG
and ( SUBB.RESPONSE_NAME <> SUBT.RESPONSE_NAME
or ( SUBB.RESPONSE_NAME is null and SUBT.RESPONSE_NAME is not null )
or ( SUBB.RESPONSE_NAME is not null and SUBT.RESPONSE_NAME is null ) )
and ( SUBB.DESCRIPTION <> SUBT.DESCRIPTION
or ( SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null )
or ( SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null ) )
);
insert into ASO_SUP_RESPONSE_TL (
RESPONSE_ID,
LANGUAGE,
SOURCE_LANG,
RESPONSE_NAME,
DESCRIPTION,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
) select
B.RESPONSE_ID,
L.LANGUAGE_CODE,
B.SOURCE_LANG,
B.RESPONSE_NAME,
B.DESCRIPTION,
B.LAST_UPDATE_DATE,
B.LAST_UPDATED_BY,
B.CREATION_DATE,
B.CREATED_BY,
B.LAST_UPDATE_LOGIN
from ASO_SUP_RESPONSE_TL B,
FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
( select NULL
from ASO_SUP_RESPONSE_TL T
where T.RESPONSE_ID = B.RESPONSE_ID
and T.LANGUAGE = L.LANGUAGE_CODE );
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_RESPONSE_NAME IN VARCHAR2,
P_DESCRIPTION IN VARCHAR2 := NULL,
P_CONTEXT IN VARCHAR2 := NULL,
P_ATTRIBUTE1 IN VARCHAR2 := NULL,
P_ATTRIBUTE2 IN VARCHAR2 := NULL,
P_ATTRIBUTE3 IN VARCHAR2 := NULL,
P_ATTRIBUTE4 IN VARCHAR2 := NULL,
P_ATTRIBUTE5 IN VARCHAR2 := NULL,
P_ATTRIBUTE6 IN VARCHAR2 := NULL,
P_ATTRIBUTE7 IN VARCHAR2 := NULL,
P_ATTRIBUTE8 IN VARCHAR2 := NULL,
P_ATTRIBUTE9 IN VARCHAR2 := NULL,
P_ATTRIBUTE10 IN VARCHAR2 := NULL,
P_ATTRIBUTE11 IN VARCHAR2 := NULL,
P_ATTRIBUTE12 IN VARCHAR2 := NULL,
P_ATTRIBUTE13 IN VARCHAR2 := NULL,
P_ATTRIBUTE14 IN VARCHAR2 := NULL,
P_ATTRIBUTE15 IN VARCHAR2 := NULL,
P_ATTRIBUTE16 IN VARCHAR2 := NULL,
P_ATTRIBUTE17 IN VARCHAR2 := NULL,
P_ATTRIBUTE18 IN VARCHAR2 := NULL,
P_ATTRIBUTE19 IN VARCHAR2 := NULL,
P_ATTRIBUTE20 IN VARCHAR2 := NULL,
X_OWNER IN VARCHAR2)
IS
begin
declare
user_id number := 0;
ASO_SUP_RESPONSE_PKG.UPDATE_ROW (
P_RESPONSE_ID => P_RESPONSE_ID,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => user_id,
P_LAST_UPDATE_LOGIN => 0,
P_RESPONSE_NAME => P_RESPONSE_NAME,
P_DESCRIPTION => P_DESCRIPTION,
p_context => P_context,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);
ASO_SUP_RESPONSE_PKG.INSERT_ROW (
PX_ROWID => row_id,
PX_RESPONSE_ID => L_RESPONSE_ID,
P_CREATION_DATE => sysdate,
P_CREATED_BY => user_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATED_BY => user_id,
P_LAST_UPDATE_LOGIN => 0,
P_RESPONSE_NAME => P_RESPONSE_NAME,
P_DESCRIPTION => P_DESCRIPTION,
p_context => P_context,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);
update ASO_SUP_RESPONSE_TL
set RESPONSE_NAME = P_RESPONSE_NAME,
DESCRIPTION = P_DESCRIPTION,
source_lang = userenv('LANG'),
last_update_date = sysdate,
last_updated_by = l_user_id,
last_update_login = 0
where RESPONSE_ID = P_RESPONSE_ID
and userenv('LANG') in (language, source_lang);
SELECT RESPONSE_ID
FROM ASO_SUP_RESPONSE_TL
WHERE RESPONSE_ID = p_RESPONSE_ID;
select component_response_ID
from aso_sup_comp_resp_map
where component_id = P_RESP_COMPONENT_ID
and response_id = P_RESPONSE_ID;
ASO_SUP_RESPONSE_PKG.UPDATE_ROW (
P_RESPONSE_ID => P_RESPONSE_ID,
P_LAST_UPDATE_DATE => sysdate ,
P_LAST_UPDATED_BY => l_user_id ,
P_LAST_UPDATE_LOGIN => l_user_id ,
P_RESPONSE_NAME => P_RESPONSE_NAME,
P_DESCRIPTION => P_DESCRIPTION,
p_context => P_CONTEXT,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);
ASO_SUP_RESPONSE_PKG.INSERT_ROW (
PX_ROWID => row_id,
PX_RESPONSE_ID => L_RESPONSE_ID,
P_CREATION_DATE => sysdate ,
P_CREATED_BY => l_user_id ,
P_LAST_UPDATE_DATE => sysdate ,
P_LAST_UPDATED_BY => l_user_id ,
P_LAST_UPDATE_LOGIN => l_user_id ,
P_RESPONSE_NAME => P_RESPONSE_NAME,
P_DESCRIPTION => P_DESCRIPTION,
p_context => P_CONTEXT,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);
ASO_SUP_COMP_RESP_MAP_PKG.UPDATE_ROW (
P_COMPONENT_RESPONSE_ID => l_COMPONENT_RESPONSE_ID,
P_LAST_UPDATE_DATE => sysdate ,
P_LAST_UPDATED_BY => l_user_id ,
P_LAST_UPDATE_LOGIN => l_user_id ,
P_COMPONENT_ID => P_RESP_COMPONENT_ID,
P_RESPONSE_ID => P_RESPONSE_ID ,
P_DISPLAY_SEQUENCE => P_RESP_DISPLAY_SEQUENCE,
p_context => P_CONTEXT,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);
ASO_SUP_COMP_RESP_MAP_PKG.INSERT_ROW (
PX_ROWID => row_id1,
PX_COMPONENT_RESPONSE_ID => l_COMPONENT_RESPONSE_ID,
P_CREATION_DATE => sysdate ,
P_CREATED_BY => l_user_id ,
P_LAST_UPDATE_DATE => sysdate ,
P_LAST_UPDATED_BY => l_user_id ,
P_LAST_UPDATE_LOGIN => l_user_id ,
P_COMPONENT_ID => P_RESP_COMPONENT_ID,
P_RESPONSE_ID => P_RESPONSE_ID ,
P_DISPLAY_SEQUENCE => P_RESP_DISPLAY_SEQUENCE,
p_context => P_CONTEXT,
P_ATTRIBUTE1 => P_ATTRIBUTE1,
P_ATTRIBUTE2 => P_ATTRIBUTE2,
P_ATTRIBUTE3 => P_ATTRIBUTE3,
P_ATTRIBUTE4 => P_ATTRIBUTE4,
P_ATTRIBUTE5 => P_ATTRIBUTE5,
P_ATTRIBUTE6 => P_ATTRIBUTE6,
P_ATTRIBUTE7 => P_ATTRIBUTE7,
P_ATTRIBUTE8 => P_ATTRIBUTE8,
P_ATTRIBUTE9 => P_ATTRIBUTE9,
P_ATTRIBUTE10 => P_ATTRIBUTE10,
P_ATTRIBUTE11 => P_ATTRIBUTE11,
P_ATTRIBUTE12 => P_ATTRIBUTE12,
P_ATTRIBUTE13 => P_ATTRIBUTE13,
P_ATTRIBUTE14 => P_ATTRIBUTE14,
P_ATTRIBUTE15 => P_ATTRIBUTE15,
P_ATTRIBUTE16 => P_ATTRIBUTE16,
P_ATTRIBUTE17 => P_ATTRIBUTE17,
P_ATTRIBUTE18 => P_ATTRIBUTE18,
P_ATTRIBUTE19 => P_ATTRIBUTE19,
P_ATTRIBUTE20 => P_ATTRIBUTE20
);