The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
x_last_updated_by OUT NOCOPY NUMBER,
x_last_update_login OUT NOCOPY NUMBER,
x_last_update_date OUT NOCOPY DATE
) RETURN VARCHAR2 IS
CURSOR OKC_NUMBER_SCHEME_DTLS_pk_csr (cp_num_scheme_id IN NUMBER,cp_num_sequence_code IN VARCHAR2,cp_sequence_level IN NUMBER) IS
SELECT
CONCATENATION_YN,
END_CHARACTER,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE
FROM OKC_NUMBER_SCHEME_DTLS t
WHERE t.NUM_SCHEME_ID = cp_num_scheme_id and
t.NUM_SEQUENCE_CODE = cp_num_sequence_code and
t.SEQUENCE_LEVEL = cp_sequence_level;
x_last_updated_by,
x_last_update_login,
x_last_update_date;
l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
x_last_updated_by => l_last_updated_by,
x_last_update_login => l_last_update_login,
x_last_update_date => l_last_update_date
);
SELECT '!'
FROM OKC_NUMBER_SCHEMES_B
WHERE NUM_SCHEME_ID = p_num_scheme_id;
l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
FUNCTION Insert_Row(
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER,
p_concatenation_yn IN VARCHAR2,
p_end_character IN VARCHAR2,
p_object_version_number IN NUMBER,
p_created_by IN NUMBER,
p_creation_date IN DATE,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_last_update_date IN DATE
) RETURN VARCHAR2 IS
BEGIN
/*IF (l_debug = 'Y') THEN
Okc_Debug.Log('3600: Entered Insert_Row function', 2);
G_PKG_NAME, '3600: Entered Insert_Row function' );
INSERT INTO OKC_NUMBER_SCHEME_DTLS(
NUM_SCHEME_ID,
NUM_SEQUENCE_CODE,
SEQUENCE_LEVEL,
CONCATENATION_YN,
END_CHARACTER,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE)
VALUES (
p_num_scheme_id,
p_num_sequence_code,
p_sequence_level,
p_concatenation_yn,
p_end_character,
p_object_version_number,
p_created_by,
p_creation_date,
p_last_updated_by,
p_last_update_login,
p_last_update_date);
Okc_Debug.Log('3700: Leaving Insert_Row', 2);
G_PKG_NAME, '3700: Leaving Insert_Row' );
Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
G_PKG_NAME, '3800: Leaving Insert_Row:OTHERS Exception' );
END Insert_Row;
PROCEDURE Insert_Row(
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER,
p_concatenation_yn IN VARCHAR2,
p_end_character IN VARCHAR2,
x_num_scheme_id OUT NOCOPY NUMBER,
x_num_sequence_code OUT NOCOPY VARCHAR2,
x_sequence_level OUT NOCOPY NUMBER
) IS
l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('4200: Entered Insert_Row', 2);
G_PKG_NAME, '4200: Entered Insert_Row' );
l_last_update_date := l_creation_date;
l_last_updated_by := l_created_by;
l_last_update_login := Fnd_Global.Login_Id;
Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
G_PKG_NAME, '4300: Call the internal Insert_Row for Base Table' );
x_return_status := Insert_Row(
p_num_scheme_id => x_num_scheme_id,
p_num_sequence_code => x_num_sequence_code,
p_sequence_level => x_sequence_level,
p_concatenation_yn => p_concatenation_yn,
p_end_character => p_end_character,
p_object_version_number => l_object_version_number,
p_created_by => l_created_by,
p_creation_date => l_creation_date,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_last_update_date => l_last_update_date
);
Okc_Debug.Log('4500: Leaving Insert_Row', 2);
G_PKG_NAME, '4500: Leaving Insert_Row' );
Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
Okc_Debug.Log('4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '4800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm );
END Insert_Row;
SELECT object_version_number
FROM OKC_NUMBER_SCHEME_DTLS
WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level
AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
FOR UPDATE OF object_version_number NOWAIT;
SELECT object_version_number
FROM OKC_NUMBER_SCHEME_DTLS
WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level;
Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
FUNCTION Update_Row(
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER,
p_concatenation_yn IN VARCHAR2,
p_end_character IN VARCHAR2,
p_object_version_number IN NUMBER,
p_last_updated_by IN NUMBER,
p_last_update_login IN NUMBER,
p_last_update_date IN DATE
) RETURN VARCHAR2 IS
BEGIN
/*IF (l_debug = 'Y') THEN
Okc_Debug.Log('6400: Entered Update_Row', 2);
G_PKG_NAME, '6400: Entered Update_Row' );
UPDATE OKC_NUMBER_SCHEME_DTLS
SET CONCATENATION_YN = p_concatenation_yn,
END_CHARACTER = p_end_character,
OBJECT_VERSION_NUMBER = p_object_version_number,
LAST_UPDATED_BY = p_last_updated_by,
LAST_UPDATE_LOGIN = p_last_update_login,
LAST_UPDATE_DATE = p_last_update_date
WHERE NUM_SCHEME_ID = p_num_scheme_id AND NUM_SEQUENCE_CODE = p_num_sequence_code AND SEQUENCE_LEVEL = p_sequence_level;
Okc_Debug.Log('6500: Leaving Update_Row', 2);
G_PKG_NAME, '6500: Leaving Update_Row' );
Okc_Debug.Log('6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '6600: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
END Update_Row;
PROCEDURE Update_Row(
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER,
p_concatenation_yn IN VARCHAR2 := NULL,
p_end_character IN VARCHAR2 := NULL,
p_object_version_number IN NUMBER
) IS
l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
Okc_Debug.Log('7000: Entered Update_Row', 2);
G_PKG_NAME, '7000: Entered Update_Row');
l_last_update_date := SYSDATE;
l_last_updated_by := FND_GLOBAL.USER_ID;
l_last_update_login := FND_GLOBAL.LOGIN_ID;
x_return_status := Update_Row(
p_num_scheme_id => p_num_scheme_id,
p_num_sequence_code => p_num_sequence_code,
p_sequence_level => p_sequence_level,
p_concatenation_yn => l_concatenation_yn,
p_end_character => l_end_character,
p_object_version_number => l_object_version_number,
p_last_updated_by => l_last_updated_by,
p_last_update_login => l_last_update_login,
p_last_update_date => l_last_update_date
);
Okc_Debug.Log('7800: Leaving Update_Row', 2);
G_PKG_NAME, '7800: Leaving Update_Row');
Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
Okc_Debug.Log('8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '8100: Leaving Update_Row because of EXCEPTION: '||sqlerrm );
END Update_Row;
FUNCTION Delete_Row(
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER
) RETURN VARCHAR2 IS
BEGIN
/*IF (l_debug = 'Y') THEN
Okc_Debug.Log('8200: Entered Delete_Row', 2);
G_PKG_NAME, '8200: Entered Delete_Row' );
DELETE FROM OKC_NUMBER_SCHEME_DTLS
WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID AND NUM_SEQUENCE_CODE = p_NUM_SEQUENCE_CODE AND SEQUENCE_LEVEL = p_SEQUENCE_LEVEL;
Okc_Debug.Log('8300: Leaving Delete_Row', 2);
G_PKG_NAME, '8300: Leaving Delete_Row' );
Okc_Debug.Log('8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '8400: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
END Delete_Row;
PROCEDURE Delete_Row(
x_return_status OUT NOCOPY VARCHAR2,
p_num_scheme_id IN NUMBER,
p_num_sequence_code IN VARCHAR2,
p_sequence_level IN NUMBER,
p_object_version_number IN NUMBER
) IS
BEGIN
/*IF (l_debug = 'Y') THEN
Okc_Debug.Log('8800: Entered Delete_Row', 2);
G_PKG_NAME, '8800: Entered Delete_Row');
x_return_status := Delete_Row( p_num_scheme_id => p_num_scheme_id,p_num_sequence_code => p_num_sequence_code,p_sequence_level => p_sequence_level );
Okc_Debug.Log('9300: Leaving Delete_Row', 2);
G_PKG_NAME, '9300: Leaving Delete_Row' );
Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
Okc_Debug.Log('9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '9600: Leaving Delete_Row because of EXCEPTION: '||sqlerrm );
END Delete_Row;
PROCEDURE delete_set(
x_return_status OUT NOCOPY VARCHAR2,
p_num_scheme_id IN NUMBER
) IS
CURSOR lock_csr IS
SELECT rowid
FROM OKC_NUMBER_SCHEME_DTLS
WHERE NUM_SCHEME_ID = p_num_scheme_id
FOR UPDATE NOWAIT;
Okc_Debug.Log('9700: Entered Delete_Set', 2);
G_PKG_NAME, '9700: Entered Delete_Set');
DELETE FROM OKC_NUMBER_SCHEME_DTLS
WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID ;
Okc_Debug.Log('10000: Leaving Delete_set', 2);
G_PKG_NAME, '10000: Leaving Delete_set' );
Okc_Debug.Log('11000: Leaving Delete_set:E_Resource_Busy Exception', 2);
G_PKG_NAME, '11000: Leaving Delete_set:E_Resource_Busy Exception' );
Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
G_PKG_NAME, '11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm );
END Delete_Set;