eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_NUMBER_SCHEME_DTL_PVT dependencies on OKC_NUMBER_SCHEME_DTLS

Line 61: -- FUNCTION get_rec for: OKC_NUMBER_SCHEME_DTLS

57: E_Resource_Busy EXCEPTION;
58: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
59:
60: ---------------------------------------------------------------------------
61: -- FUNCTION get_rec for: OKC_NUMBER_SCHEME_DTLS
62: ---------------------------------------------------------------------------
63: FUNCTION Get_Rec (
64: p_num_scheme_id IN NUMBER,
65: p_num_sequence_code IN VARCHAR2,

Line 78: 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

74: x_last_update_login OUT NOCOPY NUMBER,
75: x_last_update_date OUT NOCOPY DATE
76:
77: ) RETURN VARCHAR2 IS
78: 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
79: SELECT
80: CONCATENATION_YN,
81: END_CHARACTER,
82: OBJECT_VERSION_NUMBER,

Line 88: FROM OKC_NUMBER_SCHEME_DTLS t

84: CREATION_DATE,
85: LAST_UPDATED_BY,
86: LAST_UPDATE_LOGIN,
87: LAST_UPDATE_DATE
88: FROM OKC_NUMBER_SCHEME_DTLS t
89: WHERE t.NUM_SCHEME_ID = cp_num_scheme_id and
90: t.NUM_SEQUENCE_CODE = cp_num_sequence_code and
91: t.SEQUENCE_LEVEL = cp_sequence_level;
92: BEGIN

Line 104: OPEN OKC_NUMBER_SCHEME_DTLS_pk_csr (p_num_scheme_id, p_num_sequence_code, p_sequence_level);

100: G_PKG_NAME, '400: Entered get_rec' );
101: END IF;
102:
103: -- Get current database values
104: OPEN OKC_NUMBER_SCHEME_DTLS_pk_csr (p_num_scheme_id, p_num_sequence_code, p_sequence_level);
105: FETCH OKC_NUMBER_SCHEME_DTLS_pk_csr INTO
106: x_concatenation_yn,
107: x_end_character,
108: x_object_version_number,

Line 105: FETCH OKC_NUMBER_SCHEME_DTLS_pk_csr INTO

101: END IF;
102:
103: -- Get current database values
104: OPEN OKC_NUMBER_SCHEME_DTLS_pk_csr (p_num_scheme_id, p_num_sequence_code, p_sequence_level);
105: FETCH OKC_NUMBER_SCHEME_DTLS_pk_csr INTO
106: x_concatenation_yn,
107: x_end_character,
108: x_object_version_number,
109: x_created_by,

Line 114: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%NOTFOUND THEN

110: x_creation_date,
111: x_last_updated_by,
112: x_last_update_login,
113: x_last_update_date;
114: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%NOTFOUND THEN
115: RAISE NO_DATA_FOUND;
116: END IF;
117: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;
118:

Line 117: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;

113: x_last_update_date;
114: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%NOTFOUND THEN
115: RAISE NO_DATA_FOUND;
116: END IF;
117: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;
118:
119: /*IF (l_debug = 'Y') THEN
120: Okc_Debug.Log('500: Leaving get_rec ', 2);
121: END IF;*/

Line 149: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%ISOPEN THEN

145: p_token1_value => sqlcode,
146: p_token2 => G_SQLERRM_TOKEN,
147: p_token2_value => sqlerrm);
148:
149: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%ISOPEN THEN
150: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;
151: END IF;
152:
153: RETURN G_RET_STS_UNEXP_ERROR ;

Line 150: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;

146: p_token2 => G_SQLERRM_TOKEN,
147: p_token2_value => sqlerrm);
148:
149: IF OKC_NUMBER_SCHEME_DTLS_pk_csr%ISOPEN THEN
150: CLOSE OKC_NUMBER_SCHEME_DTLS_pk_csr;
151: END IF;
152:
153: RETURN G_RET_STS_UNEXP_ERROR ;
154:

Line 158: -- Set_Attributes for:OKC_NUMBER_SCHEME_DTLS --

154:
155: END Get_Rec;
156:
157: -----------------------------------------
158: -- Set_Attributes for:OKC_NUMBER_SCHEME_DTLS --
159: -----------------------------------------
160: FUNCTION Set_Attributes(
161: p_num_scheme_id IN NUMBER,
162: p_num_sequence_code IN VARCHAR2,

Line 173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

169: x_object_version_number OUT NOCOPY VARCHAR2,
170: x_end_character OUT NOCOPY VARCHAR2
171: ) RETURN VARCHAR2 IS
172: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line 174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;

170: x_end_character OUT NOCOPY VARCHAR2
171: ) RETURN VARCHAR2 IS
172: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line 175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;

171: ) RETURN VARCHAR2 IS
172: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
179: BEGIN

Line 176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

172: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
179: BEGIN
180: /*IF (l_debug = 'Y') THEN

Line 177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

173: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
179: BEGIN
180: /*IF (l_debug = 'Y') THEN
181: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

174: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
175: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
176: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
177: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
178: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
179: BEGIN
180: /*IF (l_debug = 'Y') THEN
181: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
182: END IF;*/

Line 280: -- Validate_Attributes for: OKC_NUMBER_SCHEME_DTLS --

276:
277: END Set_Attributes ;
278:
279: ----------------------------------------------
280: -- Validate_Attributes for: OKC_NUMBER_SCHEME_DTLS --
281: ----------------------------------------------
282: FUNCTION Validate_Attributes (
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284:

Line 559: -- Validate_Record for:OKC_NUMBER_SCHEME_DTLS --

555: -- PROCEDURE Validate_Record
556: -- It calls Item Level Validations and then makes Record Level Validations
557: ---------------------------------------------------------------------------
558: ------------------------------------------
559: -- Validate_Record for:OKC_NUMBER_SCHEME_DTLS --
560: ------------------------------------------
561: FUNCTION Validate_Record (
562: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
563:

Line 655: -- validate_row for:OKC_NUMBER_SCHEME_DTLS --

651: ---------------------------------------------------------------------------
652: -- PROCEDURE validate_row
653: ---------------------------------------------------------------------------
654: ---------------------------------------
655: -- validate_row for:OKC_NUMBER_SCHEME_DTLS --
656: ---------------------------------------
657: PROCEDURE validate_row(
658: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
659:

Line 672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;

668:
669:
670: p_object_version_number IN NUMBER
671: ) IS
672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;

Line 673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;

669:
670: p_object_version_number IN NUMBER
671: ) IS
672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

Line 674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

670: p_object_version_number IN NUMBER
671: ) IS
672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line 675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;

671: ) IS
672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line 676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;

672: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
680: BEGIN

Line 677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

673: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
680: BEGIN
681:

Line 678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

674: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
680: BEGIN
681:
682: /*IF (l_debug = 'Y') THEN

Line 679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

675: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
676: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
677: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
678: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
679: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
680: BEGIN
681:
682: /*IF (l_debug = 'Y') THEN
683: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 774: -- Insert_Row for:OKC_NUMBER_SCHEME_DTLS --

770: ---------------------------------------------------------------------------
771: -- PROCEDURE Insert_Row
772: ---------------------------------------------------------------------------
773: -------------------------------------
774: -- Insert_Row for:OKC_NUMBER_SCHEME_DTLS --
775: -------------------------------------
776: FUNCTION Insert_Row(
777: p_num_scheme_id IN NUMBER,
778: p_num_sequence_code IN VARCHAR2,

Line 802: INSERT INTO OKC_NUMBER_SCHEME_DTLS(

798: FND_LOG.STRING(G_PROC_LEVEL,
799: G_PKG_NAME, '3600: Entered Insert_Row function' );
800: END IF;
801:
802: INSERT INTO OKC_NUMBER_SCHEME_DTLS(
803: NUM_SCHEME_ID,
804: NUM_SEQUENCE_CODE,
805: SEQUENCE_LEVEL,
806: CONCATENATION_YN,

Line 863: -- Insert_Row for:OKC_NUMBER_SCHEME_DTLS --

859: END Insert_Row;
860:
861:
862: -------------------------------------
863: -- Insert_Row for:OKC_NUMBER_SCHEME_DTLS --
864: -------------------------------------
865: PROCEDURE Insert_Row(
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: x_return_status OUT NOCOPY VARCHAR2,

Line 883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

879: x_sequence_level OUT NOCOPY NUMBER
880:
881: ) IS
882:
883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line 884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;

880:
881: ) IS
882:
883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line 885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;

881: ) IS
882:
883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
889: BEGIN

Line 886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

882:
883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
889: BEGIN
890:

Line 887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

883: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
889: BEGIN
890:
891: x_return_status := G_RET_STS_SUCCESS;

Line 888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

884: l_created_by OKC_NUMBER_SCHEME_DTLS.CREATED_BY%TYPE;
885: l_creation_date OKC_NUMBER_SCHEME_DTLS.CREATION_DATE%TYPE;
886: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
887: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
888: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
889: BEGIN
890:
891: x_return_status := G_RET_STS_SUCCESS;
892:

Line 1019: -- Lock_Row for:OKC_NUMBER_SCHEME_DTLS --

1015: ---------------------------------------------------------------------------
1016: -- PROCEDURE Lock_Row
1017: ---------------------------------------------------------------------------
1018: -----------------------------------
1019: -- Lock_Row for:OKC_NUMBER_SCHEME_DTLS --
1020: -----------------------------------
1021: FUNCTION Lock_Row(
1022: p_num_scheme_id IN NUMBER,
1023: p_num_sequence_code IN VARCHAR2,

Line 1030: FROM OKC_NUMBER_SCHEME_DTLS

1026: ) RETURN VARCHAR2 IS
1027:
1028: CURSOR lock_csr (cp_num_scheme_id NUMBER, cp_num_sequence_code VARCHAR2, cp_sequence_level NUMBER, cp_object_version_number NUMBER) IS
1029: SELECT object_version_number
1030: FROM OKC_NUMBER_SCHEME_DTLS
1031: WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level
1032: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1033: FOR UPDATE OF object_version_number NOWAIT;
1034:

Line 1037: FROM OKC_NUMBER_SCHEME_DTLS

1033: FOR UPDATE OF object_version_number NOWAIT;
1034:
1035: CURSOR lchk_csr (cp_num_scheme_id NUMBER, cp_num_sequence_code VARCHAR2, cp_sequence_level NUMBER) IS
1036: SELECT object_version_number
1037: FROM OKC_NUMBER_SCHEME_DTLS
1038: WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level;
1039:
1040: l_return_status VARCHAR2(1);
1041:

Line 1042: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1038: WHERE NUM_SCHEME_ID = cp_num_scheme_id AND NUM_SEQUENCE_CODE = cp_num_sequence_code AND SEQUENCE_LEVEL = cp_sequence_level;
1039:
1040: l_return_status VARCHAR2(1);
1041:
1042: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1043:
1044: l_row_notfound BOOLEAN := FALSE;
1045: BEGIN
1046:

Line 1144: -- Lock_Row for:OKC_NUMBER_SCHEME_DTLS --

1140: RETURN( G_RET_STS_UNEXP_ERROR );
1141: END Lock_Row;
1142:
1143: -----------------------------------
1144: -- Lock_Row for:OKC_NUMBER_SCHEME_DTLS --
1145: -----------------------------------
1146: PROCEDURE Lock_Row(
1147: x_return_status OUT NOCOPY VARCHAR2,
1148:

Line 1239: -- Update_Row for:OKC_NUMBER_SCHEME_DTLS --

1235: ---------------------------------------------------------------------------
1236: -- PROCEDURE Update_Row
1237: ---------------------------------------------------------------------------
1238: -------------------------------------
1239: -- Update_Row for:OKC_NUMBER_SCHEME_DTLS --
1240: -------------------------------------
1241: FUNCTION Update_Row(
1242: p_num_scheme_id IN NUMBER,
1243: p_num_sequence_code IN VARCHAR2,

Line 1264: UPDATE OKC_NUMBER_SCHEME_DTLS

1260: FND_LOG.STRING(G_PROC_LEVEL,
1261: G_PKG_NAME, '6400: Entered Update_Row' );
1262: END IF;
1263:
1264: UPDATE OKC_NUMBER_SCHEME_DTLS
1265: SET CONCATENATION_YN = p_concatenation_yn,
1266: END_CHARACTER = p_end_character,
1267: OBJECT_VERSION_NUMBER = p_object_version_number,
1268: LAST_UPDATED_BY = p_last_updated_by,

Line 1308: -- Update_Row for:OKC_NUMBER_SCHEME_DTLS --

1304:
1305: END Update_Row;
1306:
1307: -------------------------------------
1308: -- Update_Row for:OKC_NUMBER_SCHEME_DTLS --
1309: -------------------------------------
1310: PROCEDURE Update_Row(
1311: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1312:

Line 1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;

1321: p_object_version_number IN NUMBER
1322:
1323: ) IS
1324:
1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

Line 1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;

1322:
1323: ) IS
1324:
1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

Line 1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1323: ) IS
1324:
1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
1331:

Line 1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;

1324:
1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
1331:
1332: BEGIN

Line 1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;

1325: l_concatenation_yn OKC_NUMBER_SCHEME_DTLS.CONCATENATION_YN%TYPE;
1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
1331:
1332: BEGIN
1333:

Line 1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;

1326: l_end_character OKC_NUMBER_SCHEME_DTLS.END_CHARACTER%TYPE;
1327: l_object_version_number OKC_NUMBER_SCHEME_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1328: l_last_updated_by OKC_NUMBER_SCHEME_DTLS.LAST_UPDATED_BY%TYPE;
1329: l_last_update_login OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_LOGIN%TYPE;
1330: l_last_update_date OKC_NUMBER_SCHEME_DTLS.LAST_UPDATE_DATE%TYPE;
1331:
1332: BEGIN
1333:
1334: /*IF (l_debug = 'Y') THEN

Line 1514: -- Delete_Row for:OKC_NUMBER_SCHEME_DTLS --

1510: ---------------------------------------------------------------------------
1511: -- PROCEDURE Delete_Row
1512: ---------------------------------------------------------------------------
1513: -------------------------------------
1514: -- Delete_Row for:OKC_NUMBER_SCHEME_DTLS --
1515: -------------------------------------
1516: FUNCTION Delete_Row(
1517: p_num_scheme_id IN NUMBER,
1518: p_num_sequence_code IN VARCHAR2,

Line 1533: DELETE FROM OKC_NUMBER_SCHEME_DTLS

1529: FND_LOG.STRING(G_PROC_LEVEL,
1530: G_PKG_NAME, '8200: Entered Delete_Row' );
1531: END IF;
1532:
1533: DELETE FROM OKC_NUMBER_SCHEME_DTLS
1534: WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID AND NUM_SEQUENCE_CODE = p_NUM_SEQUENCE_CODE AND SEQUENCE_LEVEL = p_SEQUENCE_LEVEL;
1535:
1536: /*IF (l_debug = 'Y') THEN
1537: Okc_Debug.Log('8300: Leaving Delete_Row', 2);

Line 1571: -- Delete_Row for:OKC_NUMBER_SCHEME_DTLS --

1567:
1568: END Delete_Row;
1569:
1570: -------------------------------------
1571: -- Delete_Row for:OKC_NUMBER_SCHEME_DTLS --
1572: -------------------------------------
1573: PROCEDURE Delete_Row(
1574: x_return_status OUT NOCOPY VARCHAR2,
1575: p_num_scheme_id IN NUMBER,

Line 1681: FROM OKC_NUMBER_SCHEME_DTLS

1677: p_num_scheme_id IN NUMBER
1678: ) IS
1679: CURSOR lock_csr IS
1680: SELECT rowid
1681: FROM OKC_NUMBER_SCHEME_DTLS
1682: WHERE NUM_SCHEME_ID = p_num_scheme_id
1683: FOR UPDATE NOWAIT;
1684:
1685: BEGIN

Line 1711: DELETE FROM OKC_NUMBER_SCHEME_DTLS

1707: FND_LOG.STRING(G_PROC_LEVEL,
1708: G_PKG_NAME, '9900: Deleting the Set' );
1709: END IF;
1710:
1711: DELETE FROM OKC_NUMBER_SCHEME_DTLS
1712: WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID ;
1713:
1714: /*IF (l_debug = 'Y') THEN
1715: Okc_Debug.Log('10000: Leaving Delete_set', 2);