The following lines contain the word 'select', 'insert', 'update' or 'delete':
'Calling Insert_Row table handler');
CSD_FLWSTS_TRAN_RESPS_PKG.Insert_Row
(
px_flwsts_tran_resp_id => x_flwsts_tran_resp_id,
p_flwsts_tran_id => p_flwsts_tran_resp_rec.flwsts_tran_id,
p_responsibility_id => p_flwsts_tran_resp_rec.responsibility_id,
p_object_version_number => l_obj_ver_num,
p_created_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_last_update_date => SYSDATE,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
'Returned from Insert_Row table handler');
/* procedure name: Update_Flwsts_Tran_Resp */
/* description : procedure used to update */
/* FS transition responsibility rec */
/* */
/*--------------------------------------------------*/
PROCEDURE Update_Flwsts_Tran_Resp
(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,
p_init_msg_list IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_flwsts_tran_resp_rec IN FLWSTS_TRAN_RESP_REC_TYPE,
x_obj_ver_number OUT NOCOPY NUMBER
) IS
-- CONSTANTS --
lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLWSTS_TRAN_RESPS_PVT.update_flwsts_tran_resp';
lc_api_name CONSTANT VARCHAR2(30) := 'Update_Flwsts_Tran_Resp';
SAVEPOINT Update_Flwsts_Tran_Resp;
'Entered Update_Flwsts_Tran_Resp');
'Calling Update_Row table handler');
CSD_FLWSTS_TRAN_RESPS_PKG.Update_Row
(
p_flwsts_tran_resp_id => p_flwsts_tran_resp_rec.flwsts_tran_resp_id,
p_flwsts_tran_id => p_flwsts_tran_resp_rec.flwsts_tran_id,
p_responsibility_id => p_flwsts_tran_resp_rec.responsibility_id,
p_object_version_number => p_flwsts_tran_resp_rec.object_version_number,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_last_update_date => SYSDATE,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
'Returned from Update_Row table handler');
'Leaving Update_Flwsts_Tran_Resp');
ROLLBACK TO Update_Flwsts_Tran_Resp;
ROLLBACK TO Update_Flwsts_Tran_Resp;
ROLLBACK TO Update_Flwsts_Tran_Resp;
ROLLBACK TO Update_Flwsts_Tran_Resp;
END Update_Flwsts_Tran_Resp;
/* procedure name: Delete_Flwsts_Tran_Resp */
/* description : procedure used to delete */
/* FS transition responsibility rec */
/* */
/*--------------------------------------------------*/
PROCEDURE Delete_Flwsts_Tran_Resp
(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,
p_init_msg_list IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_flwsts_tran_resp_id IN NUMBER
) IS
-- CONSTANTS --
lc_mod_name CONSTANT VARCHAR2(100) := 'csd.plsql.CSD_FLWSTS_TRAN_RESPS_PVT.Delete_Flwsts_Tran_Resp';
lc_api_name CONSTANT VARCHAR2(30) := 'Delete_Flwsts_Tran_Resp';
SAVEPOINT Delete_Flwsts_Tran_Resp;
'Entered Delete_Flwsts_Tran_Resp');
'Calling Delete_Row table handler');
CSD_FLWSTS_TRAN_RESPS_PKG.Delete_Row
( p_flwsts_tran_resp_id => p_flwsts_tran_resp_id);
'Returned from Delete_Row table handler');
'Leaving Delete_Flwsts_Tran_Resp');
ROLLBACK TO Delete_Flwsts_Tran_Resp;
ROLLBACK TO Delete_Flwsts_Tran_Resp;
ROLLBACK TO Delete_Flwsts_Tran_Resp;
END Delete_Flwsts_Tran_Resp;