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_SCS_PVT dependencies on OKC_SUBCLASSES_B

Line 45: FROM OKC_SUBCLASSES_B B

41: BEGIN
42: DELETE FROM OKC_SUBCLASSES_TL T
43: WHERE NOT EXISTS (
44: SELECT NULL
45: FROM OKC_SUBCLASSES_B B
46: WHERE B.CODE = T.CODE
47: );
48:
49: UPDATE OKC_SUBCLASSES_TL T SET (

Line 109: -- FUNCTION get_rec for: OKC_SUBCLASSES_B

105:
106: END add_language;
107:
108: ---------------------------------------------------------------------------
109: -- FUNCTION get_rec for: OKC_SUBCLASSES_B
110: ---------------------------------------------------------------------------
111: FUNCTION get_rec (
112: p_scs_rec IN scs_rec_type,
113: x_no_data_found OUT NOCOPY BOOLEAN

Line 129: FROM Okc_Subclasses_B

125: LAST_UPDATE_DATE,
126: LAST_UPDATE_LOGIN,
127: CREATE_OPP_YN,
128: ACCESS_LEVEL
129: FROM Okc_Subclasses_B
130: WHERE okc_subclasses_b.code = p_code;
131: l_scs_pk scs_pk_csr%ROWTYPE;
132: l_scs_rec scs_rec_type;
133: BEGIN

Line 130: WHERE okc_subclasses_b.code = p_code;

126: LAST_UPDATE_LOGIN,
127: CREATE_OPP_YN,
128: ACCESS_LEVEL
129: FROM Okc_Subclasses_B
130: WHERE okc_subclasses_b.code = p_code;
131: l_scs_pk scs_pk_csr%ROWTYPE;
132: l_scs_rec scs_rec_type;
133: BEGIN
134: x_no_data_found := TRUE;

Line 974: -- insert_row for:OKC_SUBCLASSES_B --

970: ---------------------------------------------------------------------------
971: -- PROCEDURE insert_row
972: ---------------------------------------------------------------------------
973: -------------------------------------
974: -- insert_row for:OKC_SUBCLASSES_B --
975: -------------------------------------
976: PROCEDURE insert_row(
977: p_init_msg_list IN VARCHAR2,
978: x_return_status OUT NOCOPY VARCHAR2,

Line 990: -- Set_Attributes for:OKC_SUBCLASSES_B --

986: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
987: l_scs_rec scs_rec_type := p_scs_rec;
988: l_def_scs_rec scs_rec_type;
989: -----------------------------------------
990: -- Set_Attributes for:OKC_SUBCLASSES_B --
991: -----------------------------------------
992: FUNCTION Set_Attributes (
993: p_scs_rec IN scs_rec_type,
994: x_scs_rec OUT NOCOPY scs_rec_type

Line 1022: INSERT INTO OKC_SUBCLASSES_B(

1018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1020: RAISE OKC_API.G_EXCEPTION_ERROR;
1021: END IF;
1022: INSERT INTO OKC_SUBCLASSES_B(
1023: code,
1024: cls_code,
1025: start_date,
1026: end_date,

Line 1264: CURSOR c1 (p_cls_code IN okc_subclasses_b.cls_code%TYPE) IS

1260: l_seq Number;
1261: l_dummy Varchar2(1);
1262: l_row_notfound Boolean;
1263: --
1264: CURSOR c1 (p_cls_code IN okc_subclasses_b.cls_code%TYPE) IS
1265: SELECT nvl(max(replace(code, cls_code)), '0')
1266: FROM Okc_Subclasses_B
1267: WHERE cls_code = p_cls_code
1268: AND Instr(code, p_cls_code) > 0;

Line 1266: FROM Okc_Subclasses_B

1262: l_row_notfound Boolean;
1263: --
1264: CURSOR c1 (p_cls_code IN okc_subclasses_b.cls_code%TYPE) IS
1265: SELECT nvl(max(replace(code, cls_code)), '0')
1266: FROM Okc_Subclasses_B
1267: WHERE cls_code = p_cls_code
1268: AND Instr(code, p_cls_code) > 0;
1269: --
1270: CURSOR c2 (p_code IN okc_subclasses_v.code%TYPE) IS

Line 1272: FROM Okc_Subclasses_B

1268: AND Instr(code, p_cls_code) > 0;
1269: --
1270: CURSOR c2 (p_code IN okc_subclasses_v.code%TYPE) IS
1271: SELECT 'x'
1272: FROM Okc_Subclasses_B
1273: WHERE code = p_code;
1274: --
1275: BEGIN
1276: If l_scsv_rec.code Is Null OR

Line 1303: FROM Okc_Subclasses_B

1299: ) RETURN VARCHAR2 IS
1300: unique_key_error EXCEPTION;
1301: CURSOR c1 (p_code IN okc_subclasses_v.code%TYPE) IS
1302: SELECT 'x'
1303: FROM Okc_Subclasses_B
1304: WHERE code = p_code;
1305: CURSOR c2 (p_meaning IN okc_subclasses_v.meaning%TYPE) IS
1306: SELECT 'x'
1307: FROM Okc_Subclasses_V

Line 1529: -- lock_row for:OKC_SUBCLASSES_B --

1525: ---------------------------------------------------------------------------
1526: -- PROCEDURE lock_row
1527: ---------------------------------------------------------------------------
1528: -----------------------------------
1529: -- lock_row for:OKC_SUBCLASSES_B --
1530: -----------------------------------
1531: PROCEDURE lock_row(
1532: p_init_msg_list IN VARCHAR2,
1533: x_return_status OUT NOCOPY VARCHAR2,

Line 1542: FROM OKC_SUBCLASSES_B

1538: E_Resource_Busy EXCEPTION;
1539: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1540: CURSOR lock_csr (p_scs_rec IN scs_rec_type) IS
1541: SELECT OBJECT_VERSION_NUMBER
1542: FROM OKC_SUBCLASSES_B
1543: WHERE CODE = p_scs_rec.code
1544: AND OBJECT_VERSION_NUMBER = p_scs_rec.object_version_number
1545: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1546:

Line 1549: FROM OKC_SUBCLASSES_B

1545: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1546:
1547: CURSOR lchk_csr (p_scs_rec IN scs_rec_type) IS
1548: SELECT OBJECT_VERSION_NUMBER
1549: FROM OKC_SUBCLASSES_B
1550: WHERE CODE = p_scs_rec.code;
1551: l_api_version CONSTANT NUMBER := 1;
1552: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1553: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1554: l_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;

1550: WHERE CODE = p_scs_rec.code;
1551: l_api_version CONSTANT NUMBER := 1;
1552: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1553: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1554: l_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;
1555: lc_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;
1556: l_row_notfound BOOLEAN := FALSE;
1557: lc_row_notfound BOOLEAN := FALSE;
1558: BEGIN

Line 1555: lc_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;

1551: l_api_version CONSTANT NUMBER := 1;
1552: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1553: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1554: l_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;
1555: lc_object_version_number OKC_SUBCLASSES_B.OBJECT_VERSION_NUMBER%TYPE;
1556: l_row_notfound BOOLEAN := FALSE;
1557: lc_row_notfound BOOLEAN := FALSE;
1558: BEGIN
1559: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1882: -- update_row for:OKC_SUBCLASSES_B --

1878: ---------------------------------------------------------------------------
1879: -- PROCEDURE update_row
1880: ---------------------------------------------------------------------------
1881: -------------------------------------
1882: -- update_row for:OKC_SUBCLASSES_B --
1883: -------------------------------------
1884: PROCEDURE update_row(
1885: p_init_msg_list IN VARCHAR2,
1886: x_return_status OUT NOCOPY VARCHAR2,

Line 1967: -- Set_Attributes for:OKC_SUBCLASSES_B --

1963: END IF;
1964: RETURN(l_return_status);
1965: END populate_new_record;
1966: -----------------------------------------
1967: -- Set_Attributes for:OKC_SUBCLASSES_B --
1968: -----------------------------------------
1969: FUNCTION Set_Attributes (
1970: p_scs_rec IN scs_rec_type,
1971: x_scs_rec OUT NOCOPY scs_rec_type

Line 2004: UPDATE OKC_SUBCLASSES_B

2000: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2001: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2002: RAISE OKC_API.G_EXCEPTION_ERROR;
2003: END IF;
2004: UPDATE OKC_SUBCLASSES_B
2005: SET CLS_CODE = l_def_scs_rec.cls_code,
2006: START_DATE = l_def_scs_rec.start_date,
2007: END_DATE = l_def_scs_rec.end_date,
2008: OBJECT_VERSION_NUMBER = l_def_scs_rec.object_version_number,

Line 2543: -- delete_row for:OKC_SUBCLASSES_B --

2539: ---------------------------------------------------------------------------
2540: -- PROCEDURE delete_row
2541: ---------------------------------------------------------------------------
2542: -------------------------------------
2543: -- delete_row for:OKC_SUBCLASSES_B --
2544: -------------------------------------
2545: PROCEDURE delete_row(
2546: p_init_msg_list IN VARCHAR2,
2547: x_return_status OUT NOCOPY VARCHAR2,

Line 2567: DELETE FROM OKC_SUBCLASSES_B

2563: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2565: RAISE OKC_API.G_EXCEPTION_ERROR;
2566: END IF;
2567: DELETE FROM OKC_SUBCLASSES_B
2568: WHERE CODE = l_scs_rec.code;
2569:
2570: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2571: EXCEPTION