The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Update_Status_Rule
(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_status_rule_tbl IN iex_status_rule_pub.status_rule_tbl_type,
x_dup_status OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Status_Rule';
SAVEPOINT Update_Status_Rule_PUB;
IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Update_Status_Rule');
IEX_STATUS_RULE_PVT.Update_Status_Rule(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_status_rule_rec => l_status_rule_rec
, x_dup_status => x_dup_status
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK TO Update_Status_Rule_PUB;
ROLLBACK TO Update_Status_Rule_PUB;
ROLLBACK TO Update_Status_Rule_PUB;
END Update_Status_Rule;
Procedure Delete_Status_Rule
(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_status_rule_id_tbl IN iex_status_rule_pub.status_rule_id_TBL_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_status_rule_id NUMBER;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Status_Rule';
SAVEPOINT Delete_Status_Rule_PUB;
IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Delete_Status_Rule');
IEX_STATUS_RULE_PVT.Delete_Status_Rule(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_status_rule_id => l_status_rule_id
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
ROLLBACK TO Delete_Status_Rule_PUB;
ROLLBACK TO Delete_Status_Rule_PUB;
ROLLBACK TO Delete_Status_Rule_PUB;
END Delete_Status_Rule;
Procedure Update_Status_Rule_Line
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_status_rule_line_TBL IN iex_status_rule_pub.status_rule_line_tbl_type,
x_dup_status OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Status_Rule_Line';
SAVEPOINT Update_Status_Rule_Line_PUB;
IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Update_Status_Rule_Line');
IEX_STATUS_RULE_PVT.Update_Status_Rule_Line(
p_api_version => p_api_version
, p_init_msg_list => FND_API.G_FALSE
, p_commit => p_commit
, p_status_rule_line_rec => l_status_rule_line_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK To Update_Status_Rule_Line_PUB;
ROLLBACK TO Update_Status_Rule_Line_PUB;
ROLLBACK TO Update_Status_Rule_Line_PUB;
END Update_Status_Rule_Line;
Procedure Delete_Status_Rule_Line
( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_status_rule_id IN NUMBER,
p_status_rule_line_ID_TBL IN iex_status_rule_pub.status_rule_line_ID_TBL_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Status_Rule_Line';
SAVEPOINT Delete_Status_Rule_Line_PUB;
IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Delete_Status_Rule_Line');
IEX_STATUS_RULE_PVT.Delete_Status_Rule_Line(
p_api_version => p_api_version
, p_init_msg_list => FND_API.G_FALSE
, p_commit => p_commit
, p_status_rule_id => p_status_rule_id
, p_status_rule_line_id => l_status_rule_line_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK To Delete_Status_Rule_Line_PUB;
ROLLBACK TO Delete_Status_Rule_Line_PUB;
ROLLBACK TO Delete_Status_Rule_Line_PUB;
END Delete_Status_Rule_Line;