The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Update_Score
(p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
P_SCORE_TBL IN IEX_SCORE_PUB.SCORE_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_Score';
SAVEPOINT UPDATE_SCORE_PUB;
iex_score_pvt.WriteLog('iexpscrb:UpdateScore:Start');
IEX_SCORE_PVT.Update_Score(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_rec => l_score_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
);
iex_score_pvt.WriteLog('iexpscrb:UpdateScore:End');
ROLLBACK TO UPDATE_SCORE_PUB;
ROLLBACK TO UPDATE_SCORE_PUB;
ROLLBACK TO UPDATE_SCORE_PUB;
END Update_Score;
Procedure Delete_Score
(p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
P_SCORE_ID_TBL IN IEX_SCORE_PUB.SCORE_ID_TBL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_score_id NUMBER;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Score';
SAVEPOINT DELETE_SCORE_PUB;
iex_score_pvt.WriteLog('iexpscrb:DeleteScore:Start');
iex_score_pvt.WriteLog('iexpscrb:DeleteScore:scrcnt='||p_score_id_tbl.count);
iex_score_pvt.WriteLog('iexpscrb:DeleteScore:scoreId='||l_score_id);
IEX_SCORE_PVT.Delete_Score(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_id => l_score_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
iex_score_pvt.WriteLog('iexpscrb:DeleteScore:End');
ROLLBACK TO DELETE_SCORE_PUB;
ROLLBACK TO DELETE_SCORE_PUB;
ROLLBACK TO DELETE_SCORE_PUB;
END Delete_Score;
Procedure Update_SCORE_COMP
( p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_SCORE_COMP_TBL IN IEX_SCORE_PUB.SCORE_COMP_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) := 'Update_Score_Comp';
SAVEPOINT UPDATE_Score_Comp_PUB;
iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: Start');
iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: scrcompcnt='||p_score_comp_tbl.count);
IEX_SCORE_PVT.Update_Score_Comp(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_comp_rec => l_score_comp_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: End');
ROLLBACK TO UPDATE_SCORE_COMP_PUB;
ROLLBACK TO UPDATE_SCORE_COMP_PUB;
ROLLBACK TO UPDATE_SCORE_COMP_PUB;
END Update_Score_Comp;
Procedure Delete_SCORE_COMP
( p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_SCORE_ID IN NUMBER,
p_SCORE_COMP_ID_TBL IN IEX_SCORE_PUB.SCORE_COMP_ID_TBL,
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_Score_COMP';
SAVEPOINT DELETE_SCORE_COMP_PUB;
iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: Start');
iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: scorecompid='||l_score_comp_id);
IEX_SCORE_PVT.Delete_Score_Comp(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_id => p_score_id
, p_score_comp_id => l_score_comp_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: End');
ROLLBACK TO DELETE_SCORE_COMP_PUB;
ROLLBACK TO DELETE_SCORE_COMP_PUB;
ROLLBACK TO DELETE_SCORE_COMP_PUB;
END Delete_Score_Comp;
Procedure Update_SCORE_COMP_TYPE
( p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_SCORE_COMP_TYPE_TBL IN IEX_SCORE_PUB.SCORE_COMP_TYPE_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_Score_Comp_TYPE';
SAVEPOINT UPDATE_Score_Comp_TYPE_PUB;
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: scrcomptypecnt='||p_score_comp_type_tbl.count);
IEX_SCORE_PVT.Update_Score_Comp_Type(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_comp_type_rec => l_score_comp_type_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
);
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');
ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
END Update_Score_Comp_Type;
Procedure Delete_Score_Comp_Type
(p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_SCORE_COMP_TYPE_TBL IN IEX_SCORE_PUB.SCORE_COMP_TYPE_TBL_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
l_score_comp_type_id NUMBER ;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Score_Comp_Type';
SAVEPOINT DELETE_SCORE_COMP_TYPE_PUB;
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: scrcomptypeid='||l_score_comp_type_id);
IEX_SCORE_PVT.Delete_Score_comp_type(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_comp_type_id => l_score_comp_type_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');
ROLLBACK To DELETE_Score_Comp_TYPE_PUB;
ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
END Delete_Score_comp_type;
ROLLBACK To DELETE_Score_Comp_DET_PUB;
ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
Procedure Update_SCORE_COMP_DET
( p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_SCORE_COMP_Det_TBL IN IEX_SCORE_PUB.SCORE_COMP_DET_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) := 'Update_Score_Comp_DET';
SAVEPOINT UPDATE_Score_Comp_PUB_DET;
IEX_SCORE_PVT.Update_Score_Comp_DET(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_comp_det_rec => l_score_comp_det_rec
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK To UPDATE_Score_Comp_DET_PUB;
ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
END Update_Score_Comp_DET;
Procedure Delete_SCORE_COMP_DET
( p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 ,
p_commit IN VARCHAR2 ,
p_SCORE_COMP_ID IN NUMBER,
p_SCORE_COMP_DET_ID_TBL IN IEX_SCORE_PUB.SCORE_COMP_DET_ID_TBL,
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_Score_COMP_DET';
SAVEPOINT DELETE_SCORE_COMP_DET_PUB;
IEX_SCORE_PVT.Delete_Score_Comp_Det(
p_api_version => p_api_version
, p_init_msg_list => p_init_msg_list
, p_commit => p_commit
, p_score_comp_id => p_score_comp_id
, p_score_comp_Det_id => l_score_comp_det_id
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
ROLLBACK To DELETE_Score_Comp_DET_PUB;
ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
END Delete_Score_Comp_Det;