APPS.OKC_NUMBER_SCHEME_PVT dependencies on OKC_NUMBER_SCHEMES_TL

Line 835: -- Insert_Row for:OKC_NUMBER_SCHEMES_TL --

831: END Insert_Row;
832:
833:
834: -------------------------------------
835: -- Insert_Row for:OKC_NUMBER_SCHEMES_TL --
836: -------------------------------------
837: FUNCTION Insert_Row(
838: p_num_scheme_id IN NUMBER,
839: p_scheme_name IN VARCHAR2,

Line 865: INSERT INTO OKC_NUMBER_SCHEMES_TL(

861: G_PKG_NAME, '3900: Entered Insert_Row function' );
862: END IF;
863:
864: FOR l_lang_rec IN get_languages LOOP
865: INSERT INTO OKC_NUMBER_SCHEMES_TL(
866: NUM_SCHEME_ID,
867: SCHEME_NAME,
868: CREATED_BY,
869: CREATION_DATE,

Line 1236: -- Lock_Row for:OKC_NUMBER_SCHEMES_TL --

1232: RETURN( G_RET_STS_UNEXP_ERROR );
1233: END Lock_Row;
1234:
1235: -----------------------------------
1236: -- Lock_Row for:OKC_NUMBER_SCHEMES_TL --
1237: -----------------------------------
1238: FUNCTION Lock_Row(
1239: p_num_scheme_id IN NUMBER
1240: ) RETURN VARCHAR2 IS

Line 1247: FROM OKC_NUMBER_SCHEMES_TL

1243: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1244:
1245: CURSOR lock_csr (cp_num_scheme_id NUMBER) IS
1246: SELECT *
1247: FROM OKC_NUMBER_SCHEMES_TL
1248: WHERE NUM_SCHEME_ID = cp_num_scheme_id
1249: FOR UPDATE NOWAIT;
1250:
1251: l_return_status VARCHAR2(1);

Line 1515: -- Update_Row for:OKC_NUMBER_SCHEMES_TL --

1511:
1512: END Update_Row;
1513:
1514: -------------------------------------
1515: -- Update_Row for:OKC_NUMBER_SCHEMES_TL --
1516: -------------------------------------
1517: FUNCTION Update_Row(
1518: p_num_scheme_id IN NUMBER,
1519: p_scheme_name IN VARCHAR2,

Line 1537: UPDATE OKC_NUMBER_SCHEMES_TL

1533: FND_LOG.STRING(G_PROC_LEVEL,
1534: G_PKG_NAME, '6700: Entered Update_Row' );
1535: END IF;
1536:
1537: UPDATE OKC_NUMBER_SCHEMES_TL
1538: SET SCHEME_NAME = p_scheme_name,
1539: LAST_UPDATED_BY = p_last_updated_by,
1540: LAST_UPDATE_LOGIN = p_last_update_login,
1541: LAST_UPDATE_DATE = p_last_update_date,

Line 1879: -- Delete_Row for:OKC_NUMBER_SCHEMES_TL --

1875: END Delete_Row;
1876:
1877:
1878: -------------------------------------
1879: -- Delete_Row for:OKC_NUMBER_SCHEMES_TL --
1880: -------------------------------------
1881: FUNCTION Delete_Row_T(
1882: p_num_scheme_id IN NUMBER
1883: ) RETURN VARCHAR2 IS

Line 1896: DELETE FROM OKC_NUMBER_SCHEMES_TL

1892: FND_LOG.STRING(G_PROC_LEVEL,
1893: G_PKG_NAME, '8500: Entered Delete_Row' );
1894: END IF;
1895:
1896: DELETE FROM OKC_NUMBER_SCHEMES_TL
1897: WHERE NUM_SCHEME_ID = p_NUM_SCHEME_ID;
1898:
1899: /*IF (l_debug = 'Y') THEN
1900: Okc_Debug.Log('8600: Leaving Delete_Row', 2);