[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT MR_HEADER_ID
FROM AHL_MR_HEADERS_APP_V A
WHERE UPPER(TITLE)=(C_TITLE)
AND MR_STATUS_CODE<>'TERMINATED'
AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
AND NVL(TYPE_CODE,'X')=DECODE(C_TYPE_CODE,'ACTIVITY','PROGRAM', 'PROGRAM','ACTIVITY','X');
SELECT TITLE
FROM AHL_MR_HEADERS_APP_V
WHERE MR_HEADER_ID=C_MR_HEADER_ID
AND MR_STATUS_CODE<>'TERMINATED'
AND trunc(NVL(EFFECTIVE_TO,SYSDATE+1))>SYSDATE
AND NVL(TYPE_CODE,'X')=DECODE(NVL(C_TYPE_CODE,'X'),'ACTIVITY','PROGRAM','PROGRAM','ACTIVITY','X');
SELECT TYPE_CODE INTO L_TYPE_CODE
FROM AHL_MR_HEADERS_B
WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
SELECT TITLE INTO l_title
FROM AHL_MR_HEADERS_B
WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
SELECT COUNT(*) INTO l_counter
FROM AHL_MR_RELATIONSHIPS
START WITH RELATED_MR_HEADER_ID=P_RELATED_MR_HEADER_ID
CONNECT BY PRIOR RELATED_MR_HEADER_ID=MR_HEADER_ID;
SELECT MR_STATUS_CODE,TITLE,TYPE_CODE
FROM AHL_MR_HEADERS_B
WHERE MR_HEADER_ID=C_MR_HEADER_ID;
select *
from AHL_MR_RELATIONSHIPS
where MR_HEADER_ID=C_MR_HEADER_ID
and RELATED_MR_HEADER_ID=C_RELATED_MR_HEADER_ID
and relationship_code=c_relationship_code;
SELECT 'x'
FROM ahl_mr_headers_b
WHERE mr_header_id = c_mr_header_id AND
program_type_code = 'MO_PROC';
delete AHL_MR_RELATIONSHIPS
where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
and OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;
update AHL_mr_RELATIONSHIPS
set MR_HEADER_ID = p_x_mr_relation_tbl(i).MR_HEADER_ID,
RELATED_MR_HEADER_ID = p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
RELATIONSHIP_CODE = p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,
OBJECT_VERSION_NUMBER = p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER + 1,
ATTRIBUTE_CATEGORY = p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = p_x_mr_relation_tbl(i).ATTRIBUTE1,
ATTRIBUTE2 = p_x_mr_relation_tbl(i).ATTRIBUTE2,
ATTRIBUTE3 = p_x_mr_relation_tbl(i).ATTRIBUTE3,
ATTRIBUTE4 = p_x_mr_relation_tbl(i).ATTRIBUTE4,
ATTRIBUTE5 = p_x_mr_relation_tbl(i).ATTRIBUTE5,
ATTRIBUTE6 = p_x_mr_relation_tbl(i).ATTRIBUTE6,
ATTRIBUTE7 = p_x_mr_relation_tbl(i).ATTRIBUTE7,
ATTRIBUTE8 = p_x_mr_relation_tbl(i).ATTRIBUTE8,
ATTRIBUTE9 = p_x_mr_relation_tbl(i).ATTRIBUTE9,
ATTRIBUTE10 = p_x_mr_relation_tbl(i).ATTRIBUTE10,
ATTRIBUTE11 = p_x_mr_relation_tbl(i).ATTRIBUTE11,
ATTRIBUTE12 = p_x_mr_relation_tbl(i).ATTRIBUTE12,
ATTRIBUTE13 = p_x_mr_relation_tbl(i).ATTRIBUTE13,
ATTRIBUTE14 = p_x_mr_relation_tbl(i).ATTRIBUTE14,
ATTRIBUTE15 = p_x_mr_relation_tbl(i).ATTRIBUTE15,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_LOGIN = fnd_global.user_id
where MR_RELATIONSHIP_ID = p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
and OBJECT_VERSION_NUMBER=p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER;
SELECT AHL_MR_RELATIONSHIPS_S.NEXTVAL
INTO p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID
FROM DUAL;
insert into AHl_mr_RELATIONSHIPS(
MR_RELATIONSHIP_ID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
MR_HEADER_ID,
RELATED_MR_HEADER_ID,
RELATIONSHIP_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15)
values(
p_x_mr_relation_tbl(i).MR_RELATIONSHIP_ID,
1,
sysdate,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
fnd_global.user_id,
p_x_mr_relation_tbl(i).MR_HEADER_ID,
p_x_mr_relation_tbl(i).RELATED_MR_HEADER_ID,
p_x_mr_relation_tbl(i).RELATIONSHIP_CODE,
p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY,
p_x_mr_relation_tbl(i).ATTRIBUTE1,
p_x_mr_relation_tbl(i).ATTRIBUTE2,
p_x_mr_relation_tbl(i).ATTRIBUTE3,
p_x_mr_relation_tbl(i).ATTRIBUTE4,
p_x_mr_relation_tbl(i).ATTRIBUTE5,
p_x_mr_relation_tbl(i).ATTRIBUTE6,
p_x_mr_relation_tbl(i).ATTRIBUTE7,
p_x_mr_relation_tbl(i).ATTRIBUTE8,
p_x_mr_relation_tbl(i).ATTRIBUTE9,
p_x_mr_relation_tbl(i).ATTRIBUTE10,
p_x_mr_relation_tbl(i).ATTRIBUTE11,
p_x_mr_relation_tbl(i).ATTRIBUTE12,
p_x_mr_relation_tbl(i).ATTRIBUTE13,
p_x_mr_relation_tbl(i).ATTRIBUTE14,
p_x_mr_relation_tbl(i).ATTRIBUTE15);