APPS.OKC_NUMBER_SCHEME_PVT dependencies on OKC_NUMBER_SCHEMES_B

Line 62: SELECT OKC_NUMBER_SCHEMES_B_S.NEXTVAL FROM DUAL;

58: p_num_scheme_id IN NUMBER,
59: x_num_scheme_id OUT NOCOPY NUMBER
60: ) RETURN VARCHAR2 IS
61: CURSOR l_seq_csr IS
62: SELECT OKC_NUMBER_SCHEMES_B_S.NEXTVAL FROM DUAL;
63: BEGIN
64: /*IF (l_debug = 'Y') THEN
65: Okc_Debug.Log('100: Entered get_seq_id', 2);
66: END IF;*/

Line 752: -- Insert_Row for:OKC_NUMBER_SCHEMES_B --

748: ---------------------------------------------------------------------------
749: -- PROCEDURE Insert_Row
750: ---------------------------------------------------------------------------
751: -------------------------------------
752: -- Insert_Row for:OKC_NUMBER_SCHEMES_B --
753: -------------------------------------
754: FUNCTION Insert_Row(
755: p_num_scheme_id IN NUMBER,
756: p_number_article_yn IN VARCHAR2,

Line 778: INSERT INTO OKC_NUMBER_SCHEMES_B(

774: FND_LOG.STRING(G_PROC_LEVEL,
775: G_PKG_NAME, '3600: Entered Insert_Row function' );
776: END IF;
777:
778: INSERT INTO OKC_NUMBER_SCHEMES_B(
779: NUM_SCHEME_ID,
780: NUMBER_ARTICLE_YN,
781: NUM_SCHEME_PREVIEW,
782: OBJECT_VERSION_NUMBER,

Line 1110: -- Lock_Row for:OKC_NUMBER_SCHEMES_B --

1106: ---------------------------------------------------------------------------
1107: -- PROCEDURE Lock_Row
1108: ---------------------------------------------------------------------------
1109: -----------------------------------
1110: -- Lock_Row for:OKC_NUMBER_SCHEMES_B --
1111: -----------------------------------
1112: FUNCTION Lock_Row(
1113: p_num_scheme_id IN NUMBER,
1114: p_object_version_number IN NUMBER

Line 1122: FROM OKC_NUMBER_SCHEMES_B

1118: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1119:
1120: CURSOR lock_csr (cp_num_scheme_id NUMBER, cp_object_version_number NUMBER) IS
1121: SELECT object_version_number
1122: FROM OKC_NUMBER_SCHEMES_B
1123: WHERE NUM_SCHEME_ID = cp_num_scheme_id
1124: AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
1125: FOR UPDATE OF object_version_number NOWAIT;
1126:

Line 1129: FROM OKC_NUMBER_SCHEMES_B

1125: FOR UPDATE OF object_version_number NOWAIT;
1126:
1127: CURSOR lchk_csr (cp_num_scheme_id NUMBER) IS
1128: SELECT object_version_number
1129: FROM OKC_NUMBER_SCHEMES_B
1130: WHERE NUM_SCHEME_ID = cp_num_scheme_id;
1131:
1132: l_return_status VARCHAR2(1);
1133:

Line 1134: l_object_version_number OKC_NUMBER_SCHEMES_B.OBJECT_VERSION_NUMBER%TYPE;

1130: WHERE NUM_SCHEME_ID = cp_num_scheme_id;
1131:
1132: l_return_status VARCHAR2(1);
1133:
1134: l_object_version_number OKC_NUMBER_SCHEMES_B.OBJECT_VERSION_NUMBER%TYPE;
1135:
1136: l_row_notfound BOOLEAN := FALSE;
1137: BEGIN
1138:

Line 1448: -- Update_Row for:OKC_NUMBER_SCHEMES_B --

1444: ---------------------------------------------------------------------------
1445: -- PROCEDURE Update_Row
1446: ---------------------------------------------------------------------------
1447: -------------------------------------
1448: -- Update_Row for:OKC_NUMBER_SCHEMES_B --
1449: -------------------------------------
1450: FUNCTION Update_Row(
1451: p_num_scheme_id IN NUMBER,
1452: p_number_article_yn IN VARCHAR2,

Line 1471: UPDATE OKC_NUMBER_SCHEMES_B

1467: FND_LOG.STRING(G_PROC_LEVEL,
1468: G_PKG_NAME, '6400: Entered Update_Row' );
1469: END IF;
1470:
1471: UPDATE OKC_NUMBER_SCHEMES_B
1472: SET NUMBER_ARTICLE_YN = p_number_article_yn,
1473: NUM_SCHEME_PREVIEW = p_num_scheme_preview,
1474: OBJECT_VERSION_NUMBER = p_object_version_number,
1475: LAST_UPDATED_BY = p_last_updated_by,

Line 1823: -- Delete_Row for:OKC_NUMBER_SCHEMES_B --

1819: ---------------------------------------------------------------------------
1820: -- PROCEDURE Delete_Row
1821: ---------------------------------------------------------------------------
1822: -------------------------------------
1823: -- Delete_Row for:OKC_NUMBER_SCHEMES_B --
1824: -------------------------------------
1825: FUNCTION Delete_Row(
1826: p_num_scheme_id IN NUMBER
1827: ) RETURN VARCHAR2 IS

Line 1840: DELETE FROM OKC_NUMBER_SCHEMES_B

1836: FND_LOG.STRING(G_PROC_LEVEL,
1837: G_PKG_NAME, '8200: Entered Delete_Row' );
1838: END IF;
1839:
1840: DELETE FROM OKC_NUMBER_SCHEMES_B
1841: WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID;
1842:
1843: /*IF (l_debug = 'Y') THEN
1844: Okc_Debug.Log('8300: Leaving Delete_Row', 2);