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_PVT dependencies on OKC_NUMBER_SCHEMES_V

Line 119: -- FUNCTION get_rec for: OKC_NUMBER_SCHEMES_V

115:
116: END Get_Seq_Id;
117:
118: ---------------------------------------------------------------------------
119: -- FUNCTION get_rec for: OKC_NUMBER_SCHEMES_V
120: ---------------------------------------------------------------------------
121: FUNCTION Get_Rec (
122: p_num_scheme_id IN NUMBER,
123:

Line 137: CURSOR OKC_NUMBER_SCHEMES_V_pk_csr (cp_num_scheme_id IN NUMBER) IS

133: x_last_update_login OUT NOCOPY NUMBER,
134: x_last_update_date OUT NOCOPY DATE
135:
136: ) RETURN VARCHAR2 IS
137: CURSOR OKC_NUMBER_SCHEMES_V_pk_csr (cp_num_scheme_id IN NUMBER) IS
138: SELECT
139: NUMBER_ARTICLE_YN,
140: LANGUAGE,
141: SOURCE_LANG,

Line 150: FROM OKC_NUMBER_SCHEMES_V t

146: CREATION_DATE,
147: LAST_UPDATED_BY,
148: LAST_UPDATE_LOGIN,
149: LAST_UPDATE_DATE
150: FROM OKC_NUMBER_SCHEMES_V t
151: WHERE t.NUM_SCHEME_ID = cp_num_scheme_id;
152: BEGIN
153:
154: /*IF (l_debug = 'Y') THEN

Line 164: OPEN OKC_NUMBER_SCHEMES_V_pk_csr (p_num_scheme_id);

160: G_PKG_NAME, '400: Entered get_rec' );
161: END IF;
162:
163: -- Get current database values
164: OPEN OKC_NUMBER_SCHEMES_V_pk_csr (p_num_scheme_id);
165: FETCH OKC_NUMBER_SCHEMES_V_pk_csr INTO
166: x_number_article_yn,
167: x_language,
168: x_source_lang,

Line 165: FETCH OKC_NUMBER_SCHEMES_V_pk_csr INTO

161: END IF;
162:
163: -- Get current database values
164: OPEN OKC_NUMBER_SCHEMES_V_pk_csr (p_num_scheme_id);
165: FETCH OKC_NUMBER_SCHEMES_V_pk_csr INTO
166: x_number_article_yn,
167: x_language,
168: x_source_lang,
169: x_scheme_name,

Line 177: IF OKC_NUMBER_SCHEMES_V_pk_csr%NOTFOUND THEN

173: x_creation_date,
174: x_last_updated_by,
175: x_last_update_login,
176: x_last_update_date;
177: IF OKC_NUMBER_SCHEMES_V_pk_csr%NOTFOUND THEN
178: RAISE NO_DATA_FOUND;
179: END IF;
180: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;
181:

Line 180: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;

176: x_last_update_date;
177: IF OKC_NUMBER_SCHEMES_V_pk_csr%NOTFOUND THEN
178: RAISE NO_DATA_FOUND;
179: END IF;
180: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;
181:
182: /*IF (l_debug = 'Y') THEN
183: Okc_Debug.Log('500: Leaving get_rec ', 2);
184: END IF;*/

Line 211: IF OKC_NUMBER_SCHEMES_V_pk_csr%ISOPEN THEN

207: p_token1_value => sqlcode,
208: p_token2 => G_SQLERRM_TOKEN,
209: p_token2_value => sqlerrm);
210:
211: IF OKC_NUMBER_SCHEMES_V_pk_csr%ISOPEN THEN
212: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;
213: END IF;
214:
215: RETURN G_RET_STS_UNEXP_ERROR ;

Line 212: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;

208: p_token2 => G_SQLERRM_TOKEN,
209: p_token2_value => sqlerrm);
210:
211: IF OKC_NUMBER_SCHEMES_V_pk_csr%ISOPEN THEN
212: CLOSE OKC_NUMBER_SCHEMES_V_pk_csr;
213: END IF;
214:
215: RETURN G_RET_STS_UNEXP_ERROR ;
216:

Line 220: -- Set_Attributes for:OKC_NUMBER_SCHEMES_V --

216:
217: END Get_Rec;
218:
219: -----------------------------------------
220: -- Set_Attributes for:OKC_NUMBER_SCHEMES_V --
221: -----------------------------------------
222: FUNCTION Set_Attributes(
223: p_num_scheme_id IN NUMBER,
224: p_number_article_yn IN VARCHAR2,

Line 235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;

231: x_scheme_name OUT NOCOPY VARCHAR2,
232: x_num_scheme_preview OUT NOCOPY VARCHAR2
233: ) RETURN VARCHAR2 IS
234: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line 236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;

232: x_num_scheme_preview OUT NOCOPY VARCHAR2
233: ) RETURN VARCHAR2 IS
234: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line 237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;

233: ) RETURN VARCHAR2 IS
234: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;

Line 238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

234: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;
242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;

Line 239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

235: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;
242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;
243: BEGIN

Line 240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

236: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;
242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;
243: BEGIN
244: /*IF (l_debug = 'Y') THEN

Line 241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;

237: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;
242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;
243: BEGIN
244: /*IF (l_debug = 'Y') THEN
245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);

Line 242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;

238: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
239: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
240: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
241: l_language OKC_NUMBER_SCHEMES_V.LANGUAGE%TYPE;
242: l_source_lang OKC_NUMBER_SCHEMES_V.SOURCE_LANG%TYPE;
243: BEGIN
244: /*IF (l_debug = 'Y') THEN
245: Okc_Debug.Log('700: Entered Set_Attributes ', 2);
246: END IF;*/

Line 350: -- Validate_Attributes for: OKC_NUMBER_SCHEMES_V --

346:
347: END Set_Attributes ;
348:
349: ----------------------------------------------
350: -- Validate_Attributes for: OKC_NUMBER_SCHEMES_V --
351: ----------------------------------------------
352: FUNCTION Validate_Attributes (
353: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
354:

Line 542: -- Validate_Record for:OKC_NUMBER_SCHEMES_V --

538: -- PROCEDURE Validate_Record
539: -- It calls Item Level Validations and then makes Record Level Validations
540: ---------------------------------------------------------------------------
541: ------------------------------------------
542: -- Validate_Record for:OKC_NUMBER_SCHEMES_V --
543: ------------------------------------------
544: FUNCTION Validate_Record (
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546:

Line 637: -- validate_row for:OKC_NUMBER_SCHEMES_V --

633: ---------------------------------------------------------------------------
634: -- PROCEDURE validate_row
635: ---------------------------------------------------------------------------
636: ---------------------------------------
637: -- validate_row for:OKC_NUMBER_SCHEMES_V --
638: ---------------------------------------
639: PROCEDURE validate_row(
640: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
641:

Line 650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;

646: p_scheme_name IN VARCHAR2,
647: p_num_scheme_preview IN VARCHAR2,
648: p_object_version_number IN NUMBER
649: ) IS
650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;

Line 651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;

647: p_num_scheme_preview IN VARCHAR2,
648: p_object_version_number IN NUMBER
649: ) IS
650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;

Line 652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;

648: p_object_version_number IN NUMBER
649: ) IS
650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line 653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;

649: ) IS
650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line 654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;

650: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line 655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;

651: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
659: BEGIN

Line 656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

652: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
659: BEGIN
660:

Line 657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

653: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
659: BEGIN
660:
661: /*IF (l_debug = 'Y') THEN

Line 658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

654: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
655: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
656: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
657: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
658: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
659: BEGIN
660:
661: /*IF (l_debug = 'Y') THEN
662: Okc_Debug.Log('3100: Entered validate_row', 2);

Line 923: -- Insert_Row for:OKC_NUMBER_SCHEMES_V --

919: END Insert_Row;
920:
921:
922: -------------------------------------
923: -- Insert_Row for:OKC_NUMBER_SCHEMES_V --
924: -------------------------------------
925: PROCEDURE Insert_Row(
926: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
927: x_return_status OUT NOCOPY VARCHAR2,

Line 938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;

934: x_num_scheme_id OUT NOCOPY NUMBER
935:
936: ) IS
937:
938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line 939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;

935:
936: ) IS
937:
938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line 940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;

936: ) IS
937:
938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
944: BEGIN

Line 941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

937:
938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
944: BEGIN
945:

Line 942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

938: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
944: BEGIN
945:
946: x_return_status := G_RET_STS_SUCCESS;

Line 943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

939: l_created_by OKC_NUMBER_SCHEMES_V.CREATED_BY%TYPE;
940: l_creation_date OKC_NUMBER_SCHEMES_V.CREATION_DATE%TYPE;
941: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
942: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
943: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
944: BEGIN
945:
946: x_return_status := G_RET_STS_SUCCESS;
947:

Line 1336: -- Lock_Row for:OKC_NUMBER_SCHEMES_V --

1332: RETURN( G_RET_STS_UNEXP_ERROR );
1333: END Lock_Row;
1334:
1335: -----------------------------------
1336: -- Lock_Row for:OKC_NUMBER_SCHEMES_V --
1337: -----------------------------------
1338: PROCEDURE Lock_Row(
1339: x_return_status OUT NOCOPY VARCHAR2,
1340:

Line 1581: -- Update_Row for:OKC_NUMBER_SCHEMES_V --

1577:
1578: END Update_Row;
1579:
1580: -------------------------------------
1581: -- Update_Row for:OKC_NUMBER_SCHEMES_V --
1582: -------------------------------------
1583: PROCEDURE Update_Row(
1584: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1585:

Line 1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;

1593: p_object_version_number IN NUMBER
1594:
1595: ) IS
1596:
1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

Line 1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;

1594:
1595: ) IS
1596:
1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

Line 1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;

1595: ) IS
1596:
1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

Line 1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;

1596:
1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
1604:

Line 1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;

1597: l_number_article_yn OKC_NUMBER_SCHEMES_V.NUMBER_ARTICLE_YN%TYPE;
1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
1604:
1605: BEGIN

Line 1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;

1598: l_scheme_name OKC_NUMBER_SCHEMES_V.SCHEME_NAME%TYPE;
1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
1604:
1605: BEGIN
1606:

Line 1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;

1599: l_num_scheme_preview OKC_NUMBER_SCHEMES_V.num_scheme_preview%TYPE;
1600: l_object_version_number OKC_NUMBER_SCHEMES_V.OBJECT_VERSION_NUMBER%TYPE;
1601: l_last_updated_by OKC_NUMBER_SCHEMES_V.LAST_UPDATED_BY%TYPE;
1602: l_last_update_login OKC_NUMBER_SCHEMES_V.LAST_UPDATE_LOGIN%TYPE;
1603: l_last_update_date OKC_NUMBER_SCHEMES_V.LAST_UPDATE_DATE%TYPE;
1604:
1605: BEGIN
1606:
1607: /*IF (l_debug = 'Y') THEN

Line 1934: -- Delete_Row for:OKC_NUMBER_SCHEMES_V --

1930:
1931: END Delete_Row_T;
1932:
1933: -------------------------------------
1934: -- Delete_Row for:OKC_NUMBER_SCHEMES_V --
1935: -------------------------------------
1936: PROCEDURE Delete_Row(
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: p_num_scheme_id IN NUMBER,