The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
QUALIFIER_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,LAST_UPDATE_LOGIN
,QUALIFIER_GROUPING_NO
,QUALIFIER_CONTEXT
,QUALIFIER_ATTRIBUTE
,QUALIFIER_ATTR_VALUE
,COMPARISON_OPERATOR_CODE
,EXCLUDER_FLAG
,QUALIFIER_RULE_ID
,START_DATE_ACTIVE
,END_DATE_ACTIVE
,CREATED_FROM_RULE_ID
,QUALIFIER_PRECEDENCE
,LIST_HEADER_ID
,LIST_LINE_ID
,QUALIFIER_DATATYPE
,QUALIFIER_ATTR_VALUE_TO
,CONTEXT
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ACTIVE_FLAG
,LIST_TYPE_CODE
,QUAL_ATTR_VALUE_FROM_NUMBER
,QUAL_ATTR_VALUE_TO_NUMBER
FROM oks_qualifiers
WHERE qualifier_id = p_id;
,l_qua_rec.LAST_UPDATE_DATE
,l_qua_rec.LAST_UPDATED_BY
,l_qua_rec.REQUEST_ID
,l_qua_rec.PROGRAM_APPLICATION_ID
,l_qua_rec.PROGRAM_ID
,l_qua_rec.PROGRAM_UPDATE_DATE
,l_qua_rec.LAST_UPDATE_LOGIN
,l_qua_rec.QUALIFIER_GROUPING_NO
,l_qua_rec.QUALIFIER_CONTEXT
,l_qua_rec.QUALIFIER_ATTRIBUTE
,l_qua_rec.QUALIFIER_ATTR_VALUE
,l_qua_rec.COMPARISON_OPERATOR_CODE
,l_qua_rec.EXCLUDER_FLAG
,l_qua_rec.QUALIFIER_RULE_ID
,l_qua_rec.START_DATE_ACTIVE
,l_qua_rec.END_DATE_ACTIVE
,l_qua_rec.CREATED_FROM_RULE_ID
,l_qua_rec.QUALIFIER_PRECEDENCE
,l_qua_rec.LIST_HEADER_ID
,l_qua_rec.LIST_LINE_ID
,l_qua_rec.QUALIFIER_DATATYPE
,l_qua_rec.QUALIFIER_ATTR_VALUE_TO
,l_qua_rec.CONTEXT
,l_qua_rec.ATTRIBUTE1
,l_qua_rec.ATTRIBUTE2
,l_qua_rec.ATTRIBUTE3
,l_qua_rec.ATTRIBUTE4
,l_qua_rec.ATTRIBUTE5
,l_qua_rec.ATTRIBUTE6
,l_qua_rec.ATTRIBUTE7
,l_qua_rec.ATTRIBUTE8
,l_qua_rec.ATTRIBUTE9
,l_qua_rec.ATTRIBUTE10
,l_qua_rec.ATTRIBUTE11
,l_qua_rec.ATTRIBUTE12
,l_qua_rec.ATTRIBUTE13
,l_qua_rec.ATTRIBUTE14
,l_qua_rec.ATTRIBUTE15
,l_qua_rec.ACTIVE_FLAG
,l_qua_rec.LIST_TYPE_CODE
,l_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER
,l_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER ;
SELECT
QUALIFIER_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,LAST_UPDATE_LOGIN
,QUALIFIER_GROUPING_NO
,QUALIFIER_CONTEXT
,QUALIFIER_ATTRIBUTE
,QUALIFIER_ATTR_VALUE
,COMPARISON_OPERATOR_CODE
,EXCLUDER_FLAG
,QUALIFIER_RULE_ID
,START_DATE_ACTIVE
,END_DATE_ACTIVE
,CREATED_FROM_RULE_ID
,QUALIFIER_PRECEDENCE
,LIST_HEADER_ID
,LIST_LINE_ID
,QUALIFIER_DATATYPE
,QUALIFIER_ATTR_VALUE_TO
,CONTEXT
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ACTIVE_FLAG
,LIST_TYPE_CODE
,QUAL_ATTR_VALUE_FROM_NUMBER
,QUAL_ATTR_VALUE_TO_NUMBER
FROM Oks_QUALIFIERS_V
WHERE oks_qualifiers_v.qualifier_id = p_id;
,l_quav_rec.LAST_UPDATE_DATE
,l_quav_rec.LAST_UPDATED_BY
,l_quav_rec.REQUEST_ID
,l_quav_rec.PROGRAM_APPLICATION_ID
,l_quav_rec.PROGRAM_ID
,l_quav_rec.PROGRAM_UPDATE_DATE
,l_quav_rec.LAST_UPDATE_LOGIN
,l_quav_rec.QUALIFIER_GROUPING_NO
,l_quav_rec.QUALIFIER_CONTEXT
,l_quav_rec.QUALIFIER_ATTRIBUTE
,l_quav_rec.QUALIFIER_ATTR_VALUE
,l_quav_rec.COMPARISON_OPERATOR_CODE
,l_quav_rec.EXCLUDER_FLAG
,l_quav_rec.QUALIFIER_RULE_ID
,l_quav_rec.START_DATE_ACTIVE
,l_quav_rec.END_DATE_ACTIVE
,l_quav_rec.CREATED_FROM_RULE_ID
,l_quav_rec.QUALIFIER_PRECEDENCE
,l_quav_rec.LIST_HEADER_ID
,l_quav_rec.LIST_LINE_ID
,l_quav_rec.QUALIFIER_DATATYPE
,l_quav_rec.QUALIFIER_ATTR_VALUE_TO
,l_quav_rec.CONTEXT
,l_quav_rec.ATTRIBUTE1
,l_quav_rec.ATTRIBUTE2
,l_quav_rec.ATTRIBUTE3
,l_quav_rec.ATTRIBUTE4
,l_quav_rec.ATTRIBUTE5
,l_quav_rec.ATTRIBUTE6
,l_quav_rec.ATTRIBUTE7
,l_quav_rec.ATTRIBUTE8
,l_quav_rec.ATTRIBUTE9
,l_quav_rec.ATTRIBUTE10
,l_quav_rec.ATTRIBUTE11
,l_quav_rec.ATTRIBUTE12
,l_quav_rec.ATTRIBUTE13
,l_quav_rec.ATTRIBUTE14
,l_quav_rec.ATTRIBUTE15
,l_quav_rec.ACTIVE_FLAG
,l_quav_rec.LIST_TYPE_CODE
,l_quav_rec.QUAL_ATTR_VALUE_FROM_NUMBER
,l_quav_rec.QUAL_ATTR_VALUE_TO_NUMBER ;
IF (l_quav_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
l_quav_rec.last_update_date := NULL;
IF (l_quav_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
l_quav_rec.last_updated_by := NULL;
PROCEDURE validate_last_update_by(x_return_status OUT NOCOPY varchar2,
p_id IN Number)
Is
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_by');
End validate_last_update_by;
PROCEDURE validate_last_update_date(x_return_status OUT NOCOPY varchar2,
p_date IN DATE)
Is
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
End validate_last_update_date;
validate_last_update_date(x_return_status, p_quav_rec.last_update_date);
validate_last_update_by(x_return_status, p_quav_rec.last_updated_by);
SELECT
QUALIFIER_RULE_ID ,
CREATION_DATE ,
CREATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
PROGRAM_APPLICATION_ID ,
PROGRAM_ID ,
PROGRAM_UPDATE_DATE ,
REQUEST_ID ,
LAST_UPDATE_LOGIN ,
NAME ,
DESCRIPTION ,
CONTEXT ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15
FROM Oks_QUALIFIER_RULES_V
WHERE OKS_QUALIFIER_RULES_V.qualifier_rule_id = p_id;
p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY ;
p_to.PROGRAM_UPDATE_DATE := p_from.PROGRAM_UPDATE_DATE ;
p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN ;
p_to.LAST_UPDATE_DATE := p_from.LAST_UPDATE_DATE;
p_to.LAST_UPDATED_BY := p_from.LAST_UPDATED_BY ;
p_to.PROGRAM_UPDATE_DATE := p_from.PROGRAM_UPDATE_DATE ;
p_to.LAST_UPDATE_LOGIN := p_from.LAST_UPDATE_LOGIN ;
PROCEDURE insert_row(
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qua_rec IN qua_rec_type,
x_qua_rec OUT NOCOPY qua_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_insert_row';
INSERT INTO OKS_QUALIFIERS(
QUALIFIER_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,LAST_UPDATE_LOGIN
,QUALIFIER_GROUPING_NO
,QUALIFIER_CONTEXT
,QUALIFIER_ATTRIBUTE
,QUALIFIER_ATTR_VALUE
,COMPARISON_OPERATOR_CODE
,EXCLUDER_FLAG
,QUALIFIER_RULE_ID
,START_DATE_ACTIVE
,END_DATE_ACTIVE
,CREATED_FROM_RULE_ID
,QUALIFIER_PRECEDENCE
,LIST_HEADER_ID
,LIST_LINE_ID
,QUALIFIER_DATATYPE
,QUALIFIER_ATTR_VALUE_TO
,CONTEXT
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ACTIVE_FLAG
,LIST_TYPE_CODE
,QUAL_ATTR_VALUE_FROM_NUMBER
,QUAL_ATTR_VALUE_TO_NUMBER )
VALUES (
l_qua_rec.QUALIFIER_ID
,l_qua_rec.CREATION_DATE
,l_qua_rec.CREATED_BY
,l_qua_rec.LAST_UPDATE_DATE
,l_qua_rec.LAST_UPDATED_BY
,l_qua_rec.REQUEST_ID
,l_qua_rec.PROGRAM_APPLICATION_ID
,l_qua_rec.PROGRAM_ID
,l_qua_rec.PROGRAM_UPDATE_DATE
,l_qua_rec.LAST_UPDATE_LOGIN
,l_qua_rec.QUALIFIER_GROUPING_NO
,l_qua_rec.QUALIFIER_CONTEXT
,l_qua_rec.QUALIFIER_ATTRIBUTE
,l_qua_rec.QUALIFIER_ATTR_VALUE
,l_qua_rec.COMPARISON_OPERATOR_CODE
,l_qua_rec.EXCLUDER_FLAG
,l_qua_rec.QUALIFIER_RULE_ID
,l_qua_rec.START_DATE_ACTIVE
,l_qua_rec.END_DATE_ACTIVE
,l_qua_rec.CREATED_FROM_RULE_ID
,l_qua_rec.QUALIFIER_PRECEDENCE
,l_qua_rec.LIST_HEADER_ID
,l_qua_rec.LIST_LINE_ID
,l_qua_rec.QUALIFIER_DATATYPE
,l_qua_rec.QUALIFIER_ATTR_VALUE_TO
,l_qua_rec.CONTEXT
,l_qua_rec.ATTRIBUTE1
,l_qua_rec.ATTRIBUTE2
,l_qua_rec.ATTRIBUTE3
,l_qua_rec.ATTRIBUTE4
,l_qua_rec.ATTRIBUTE5
,l_qua_rec.ATTRIBUTE6
,l_qua_rec.ATTRIBUTE7
,l_qua_rec.ATTRIBUTE8
,l_qua_rec.ATTRIBUTE9
,l_qua_rec.ATTRIBUTE10
,l_qua_rec.ATTRIBUTE11
,l_qua_rec.ATTRIBUTE12
,l_qua_rec.ATTRIBUTE13
,l_qua_rec.ATTRIBUTE14
,l_qua_rec.ATTRIBUTE15
,l_qua_rec.ACTIVE_FLAG
,l_qua_rec.LIST_TYPE_CODE
,l_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER
,l_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER );
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_rec IN quav_rec_type,
x_quav_rec OUT NOCOPY quav_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
l_quav_rec.LAST_UPDATE_DATE := SYSDATE;
l_quav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_quav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
insert_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_qua_rec,
lx_qua_rec
);
END insert_row;
PROCEDURE insert_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_tbl IN quav_tbl_type,
x_quav_tbl OUT NOCOPY quav_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
insert_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_quav_rec => p_quav_tbl(i),
x_quav_rec => x_quav_tbl(i));
END insert_row;
SELECT qualifier_id
FROM OKS_QUALIFIERS
WHERE QUALIFIER_ID = p_qua_rec.qualifier_id;
OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
PROCEDURE update_row(
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qua_rec IN qua_rec_type,
x_qua_rec OUT NOCOPY qua_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_update_row';
IF (x_qua_rec.last_update_date = OKC_API.G_MISS_DATE)
OR (x_qua_rec.last_update_date IS NULL)
THEN
x_qua_rec.last_update_date := l_qua_rec.last_update_date;
IF (x_qua_rec.last_updated_BY = OKC_API.G_MISS_NUM)
OR (x_qua_rec.last_updated_by IS NULL)
THEN
x_qua_rec.last_updated_BY := l_qua_rec.last_updated_BY;
UPDATE OKS_QUALIFIERS
SET
QUALIFIER_ID = l_def_qua_rec.QUALIFIER_ID ,
CREATION_DATE = l_def_qua_rec.CREATION_DATE ,
CREATED_BY = l_def_qua_rec.CREATED_BY ,
LAST_UPDATE_DATE = l_def_qua_rec.LAST_UPDATE_DATE ,
LAST_UPDATED_BY = l_def_qua_rec.LAST_UPDATED_BY ,
REQUEST_ID = l_def_qua_rec.REQUEST_ID ,
PROGRAM_APPLICATION_ID = l_def_qua_rec.PROGRAM_APPLICATION_ID ,
PROGRAM_ID = l_def_qua_rec.PROGRAM_ID ,
PROGRAM_UPDATE_DATE = l_def_qua_rec.PROGRAM_UPDATE_DATE ,
LAST_UPDATE_LOGIN = l_def_qua_rec.LAST_UPDATE_LOGIN ,
QUALIFIER_GROUPING_NO = l_def_qua_rec.QUALIFIER_GROUPING_NO ,
QUALIFIER_CONTEXT = l_def_qua_rec.QUALIFIER_CONTEXT ,
QUALIFIER_ATTRIBUTE = l_def_qua_rec.QUALIFIER_ATTRIBUTE,
QUALIFIER_ATTR_VALUE = l_def_qua_rec.QUALIFIER_ATTR_VALUE,
COMPARISON_OPERATOR_CODE = l_def_qua_rec.COMPARISON_OPERATOR_CODE ,
EXCLUDER_FLAG = l_def_qua_rec.EXCLUDER_FLAG ,
QUALIFIER_RULE_ID = l_def_qua_rec.QUALIFIER_RULE_ID ,
START_DATE_ACTIVE = l_def_qua_rec.START_DATE_ACTIVE ,
END_DATE_ACTIVE = l_def_qua_rec.END_DATE_ACTIVE ,
CREATED_FROM_RULE_ID = l_def_qua_rec.CREATED_FROM_RULE_ID ,
QUALIFIER_PRECEDENCE = l_def_qua_rec.QUALIFIER_PRECEDENCE ,
LIST_HEADER_ID = l_def_qua_rec.LIST_HEADER_ID ,
LIST_LINE_ID = l_def_qua_rec.LIST_LINE_ID ,
QUALIFIER_DATATYPE = l_def_qua_rec.QUALIFIER_DATATYPE ,
QUALIFIER_ATTR_VALUE_TO = l_def_qua_rec.QUALIFIER_ATTR_VALUE_TO ,
CONTEXT = l_def_qua_rec.CONTEXT ,
ATTRIBUTE1 = l_def_qua_rec.ATTRIBUTE1 ,
ATTRIBUTE2 = l_def_qua_rec.ATTRIBUTE2 ,
ATTRIBUTE3 = l_def_qua_rec.ATTRIBUTE3 ,
ATTRIBUTE4 = l_def_qua_rec.ATTRIBUTE4 ,
ATTRIBUTE5 = l_def_qua_rec.ATTRIBUTE5 ,
ATTRIBUTE6 = l_def_qua_rec.ATTRIBUTE6 ,
ATTRIBUTE7 = l_def_qua_rec.ATTRIBUTE7 ,
ATTRIBUTE8 = l_def_qua_rec.ATTRIBUTE8 ,
ATTRIBUTE9 = l_def_qua_rec.ATTRIBUTE9 ,
ATTRIBUTE10 = l_def_qua_rec.ATTRIBUTE10 ,
ATTRIBUTE11 = l_def_qua_rec.ATTRIBUTE11 ,
ATTRIBUTE12 = l_def_qua_rec.ATTRIBUTE12 ,
ATTRIBUTE13 = l_def_qua_rec.ATTRIBUTE13 ,
ATTRIBUTE14 = l_def_qua_rec.ATTRIBUTE14 ,
ATTRIBUTE15 = l_def_qua_rec.ATTRIBUTE15 ,
ACTIVE_FLAG = l_def_qua_rec.ACTIVE_FLAG ,
LIST_TYPE_CODE = l_def_qua_rec.LIST_TYPE_CODE ,
QUAL_ATTR_VALUE_FROM_NUMBER = l_def_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER ,
QUAL_ATTR_VALUE_TO_NUMBER = l_def_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER
WHere qualifier_id = l_def_qua_rec.qualifier_id;
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_rec IN quav_rec_type,
x_quav_rec OUT NOCOPY quav_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
l_quav_rec.LAST_UPDATE_DATE := SYSDATE;
l_quav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
l_quav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
IF (x_quav_rec.last_updated_by = OKC_API.G_MISS_NUM)
OR (x_quav_rec.last_updated_by IS NULL)
THEN
x_quav_rec.last_updated_by := l_quav_rec.last_updated_by;
IF (x_quav_rec.last_update_date = OKC_API.G_MISS_DATE)
OR (x_quav_rec.last_update_date IS NULL)
THEN
x_quav_rec.last_update_date := l_quav_rec.last_update_date;
update_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_qua_rec,
lx_qua_rec
);
END update_row;
PROCEDURE update_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_tbl IN quav_tbl_type,
x_quav_tbl OUT NOCOPY quav_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
update_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_quav_rec => p_quav_tbl(i),
x_quav_rec => x_quav_tbl(i));
END update_row;
PROCEDURE delete_row(
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qua_rec IN qua_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'LINES_delete_row';
DELETE FROM OKS_QUALIFIERS
WHERE QUALIFIER_ID = l_qua_rec.qualifier_id;
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_rec IN quav_rec_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
delete_row(
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_qua_rec
);
END delete_row;
PROCEDURE delete_row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_quav_tbl IN quav_tbl_type) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
delete_row (
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_quav_rec => p_quav_tbl(i));
END delete_row;