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_RRD_PVT dependencies on OKC_RG_ROLE_DEFS

Line 13: OKC_RG_ROLE_DEFS_S1.nextval

9: l_id Number;
10: -- for customer's data (for non-seeded date id should be 50000 or above)
11: cursor nonseed_c is
12: select
13: OKC_RG_ROLE_DEFS_S1.nextval
14: from
15: dual;
16: -- for datamerge's data (for seeded date id should be greater than or equal to 11000 and less than 50000)
17: cursor seed_c is

Line 21: OKC_RG_ROLE_DEFS_V

17: cursor seed_c is
18: select
19: nvl(max(id), 11000) + 1
20: from
21: OKC_RG_ROLE_DEFS_V
22: where
23: id >= 11000 AND id < 50000;
24: BEGIN
25: if fnd_global.user_id = 1 then

Line 35: SELECT OKC_RG_ROLE_DEFS_S1.nextval

31: fetch nonseed_c into l_id;
32: close nonseed_c;
33: end if;
34: /*
35: SELECT OKC_RG_ROLE_DEFS_S1.nextval
36: INTO l_id
37: FROM DUAL;
38: */
39: RETURN(l_id);

Line 68: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS

64: null;
65: END api_copy;
66:
67: ---------------------------------------------------------------------------
68: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS
69: ---------------------------------------------------------------------------
70: FUNCTION get_rec (
71: p_rrd_rec IN rrd_rec_type,
72: x_no_data_found OUT NOCOPY BOOLEAN

Line 104: FROM Okc_Rg_Role_Defs

100: ATTRIBUTE13,
101: ATTRIBUTE14,
102: ATTRIBUTE15,
103: ACCESS_LEVEL
104: FROM Okc_Rg_Role_Defs
105: WHERE okc_rg_role_defs.id = p_id;
106: l_rrd_pk rrd_pk_csr%ROWTYPE;
107: l_rrd_rec rrd_rec_type;
108: BEGIN

Line 105: WHERE okc_rg_role_defs.id = p_id;

101: ATTRIBUTE14,
102: ATTRIBUTE15,
103: ACCESS_LEVEL
104: FROM Okc_Rg_Role_Defs
105: WHERE okc_rg_role_defs.id = p_id;
106: l_rrd_pk rrd_pk_csr%ROWTYPE;
107: l_rrd_rec rrd_rec_type;
108: BEGIN
109: x_no_data_found := TRUE;

Line 154: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS_V

150: BEGIN
151: RETURN(get_rec(p_rrd_rec, l_row_notfound));
152: END get_rec;
153: ---------------------------------------------------------------------------
154: -- FUNCTION get_rec for: OKC_RG_ROLE_DEFS_V
155: ---------------------------------------------------------------------------
156: FUNCTION get_rec (
157: p_rrdv_rec IN rrdv_rec_type,
158: x_no_data_found OUT NOCOPY BOOLEAN

Line 190: FROM Okc_Rg_Role_Defs_V

186: LAST_UPDATED_BY,
187: LAST_UPDATE_DATE,
188: LAST_UPDATE_LOGIN,
189: ACCESS_LEVEL
190: FROM Okc_Rg_Role_Defs_V
191: WHERE okc_rg_role_defs_v.id = p_id;
192: l_okc_rrdv_pk okc_rrdv_pk_csr%ROWTYPE;
193: l_rrdv_rec rrdv_rec_type;
194: BEGIN

Line 191: WHERE okc_rg_role_defs_v.id = p_id;

187: LAST_UPDATE_DATE,
188: LAST_UPDATE_LOGIN,
189: ACCESS_LEVEL
190: FROM Okc_Rg_Role_Defs_V
191: WHERE okc_rg_role_defs_v.id = p_id;
192: l_okc_rrdv_pk okc_rrdv_pk_csr%ROWTYPE;
193: l_rrdv_rec rrdv_rec_type;
194: BEGIN
195: x_no_data_found := TRUE;

Line 241: -- FUNCTION null_out_defaults for: OKC_RG_ROLE_DEFS_V --

237: RETURN(get_rec(p_rrdv_rec, l_row_notfound));
238: END get_rec;
239:
240: --------------------------------------------------------
241: -- FUNCTION null_out_defaults for: OKC_RG_ROLE_DEFS_V --
242: --------------------------------------------------------
243: FUNCTION null_out_defaults (
244: p_rrdv_rec IN rrdv_rec_type
245: ) RETURN rrdv_rec_type IS

Line 552: -- Validate_Attributes for:OKC_RG_ROLE_DEFS_V --

548: ---------------------------------------------------------------------------
549: -- PROCEDURE Validate_Attributes
550: ---------------------------------------------------------------------------
551: ------------------------------------------------
552: -- Validate_Attributes for:OKC_RG_ROLE_DEFS_V --
553: ------------------------------------------------
554: FUNCTION Validate_Attributes (
555: p_rrdv_rec IN rrdv_rec_type
556: ) RETURN VARCHAR2 IS

Line 645: -- Validate_Record for:OKC_RG_ROLE_DEFS_V --

641: ---------------------------------------------------------------------------
642: -- PROCEDURE Validate_Record
643: ---------------------------------------------------------------------------
644: --------------------------------------------
645: -- Validate_Record for:OKC_RG_ROLE_DEFS_V --
646: --------------------------------------------
647: FUNCTION Validate_Record (
648: p_rrdv_rec IN rrdv_rec_type
649: ) RETURN VARCHAR2 IS

Line 703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,

699: FUNCTION validate_unique_keys (
700: p_rrdv_rec IN rrdv_rec_type
701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V

Line 704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,

700: p_rrdv_rec IN rrdv_rec_type
701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id

Line 705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS

701: ) RETURN VARCHAR2 IS
702: unique_key_error EXCEPTION;
703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id
709: AND sre_id = p_sre_id

Line 707: FROM Okc_Rg_Role_Defs_V

703: CURSOR c1 (p_id IN okc_rg_role_defs_v.id%TYPE,
704: p_srd_id IN okc_rg_role_defs_v.srd_id%TYPE,
705: p_sre_id IN okc_rg_role_defs_v.sre_id%TYPE) IS
706: SELECT 'x'
707: FROM Okc_Rg_Role_Defs_V
708: WHERE srd_id = p_srd_id
709: AND sre_id = p_sre_id
710: AND ((p_id IS NULL)
711: OR (p_id IS NOT NULL

Line 837: -- validate_row for:OKC_RG_ROLE_DEFS_V --

833: ---------------------------------------------------------------------------
834: -- PROCEDURE validate_row
835: ---------------------------------------------------------------------------
836: -----------------------------------------
837: -- validate_row for:OKC_RG_ROLE_DEFS_V --
838: -----------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2,

Line 981: -- insert_row for:OKC_RG_ROLE_DEFS --

977: ---------------------------------------------------------------------------
978: -- PROCEDURE insert_row
979: ---------------------------------------------------------------------------
980: -------------------------------------
981: -- insert_row for:OKC_RG_ROLE_DEFS --
982: -------------------------------------
983: PROCEDURE insert_row(
984: p_init_msg_list IN VARCHAR2,
985: x_return_status OUT NOCOPY VARCHAR2,

Line 997: -- Set_Attributes for:OKC_RG_ROLE_DEFS --

993: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
994: l_rrd_rec rrd_rec_type := p_rrd_rec;
995: l_def_rrd_rec rrd_rec_type;
996: -----------------------------------------
997: -- Set_Attributes for:OKC_RG_ROLE_DEFS --
998: -----------------------------------------
999: FUNCTION Set_Attributes (
1000: p_rrd_rec IN rrd_rec_type,
1001: x_rrd_rec OUT NOCOPY rrd_rec_type

Line 1028: INSERT INTO OKC_RG_ROLE_DEFS(

1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: INSERT INTO OKC_RG_ROLE_DEFS(
1029: id,
1030: srd_id,
1031: sre_id,
1032: object_version_number,

Line 1122: -- insert_row for:OKC_RG_ROLE_DEFS_V --

1118: '_PVT'
1119: );
1120: END insert_row;
1121: ---------------------------------------
1122: -- insert_row for:OKC_RG_ROLE_DEFS_V --
1123: ---------------------------------------
1124: PROCEDURE insert_row(
1125: p_api_version IN NUMBER,
1126: p_init_msg_list IN VARCHAR2,

Line 1156: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --

1152: l_rrdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1153: RETURN(l_rrdv_rec);
1154: END fill_who_columns;
1155: -------------------------------------------
1156: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --
1157: -------------------------------------------
1158: FUNCTION Set_Attributes (
1159: p_rrdv_rec IN rrdv_rec_type,
1160: x_rrdv_rec OUT NOCOPY rrdv_rec_type

Line 1336: -- lock_row for:OKC_RG_ROLE_DEFS --

1332: ---------------------------------------------------------------------------
1333: -- PROCEDURE lock_row
1334: ---------------------------------------------------------------------------
1335: -----------------------------------
1336: -- lock_row for:OKC_RG_ROLE_DEFS --
1337: -----------------------------------
1338: PROCEDURE lock_row(
1339: p_init_msg_list IN VARCHAR2,
1340: x_return_status OUT NOCOPY VARCHAR2,

Line 1349: FROM OKC_RG_ROLE_DEFS

1345: E_Resource_Busy EXCEPTION;
1346: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1347: CURSOR lock_csr (p_rrd_rec IN rrd_rec_type) IS
1348: SELECT OBJECT_VERSION_NUMBER
1349: FROM OKC_RG_ROLE_DEFS
1350: WHERE ID = p_rrd_rec.id
1351: AND OBJECT_VERSION_NUMBER = p_rrd_rec.object_version_number
1352: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1353:

Line 1356: FROM OKC_RG_ROLE_DEFS

1352: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1353:
1354: CURSOR lchk_csr (p_rrd_rec IN rrd_rec_type) IS
1355: SELECT OBJECT_VERSION_NUMBER
1356: FROM OKC_RG_ROLE_DEFS
1357: WHERE ID = p_rrd_rec.id;
1358: l_api_version CONSTANT NUMBER := 1;
1359: l_api_name CONSTANT VARCHAR2(30) := 'DEFS_lock_row';
1360: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1361: l_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;

1357: WHERE ID = p_rrd_rec.id;
1358: l_api_version CONSTANT NUMBER := 1;
1359: l_api_name CONSTANT VARCHAR2(30) := 'DEFS_lock_row';
1360: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1361: l_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;
1362: lc_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;
1363: l_row_notfound BOOLEAN := FALSE;
1364: lc_row_notfound BOOLEAN := FALSE;
1365: BEGIN

Line 1362: lc_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;

1358: l_api_version CONSTANT NUMBER := 1;
1359: l_api_name CONSTANT VARCHAR2(30) := 'DEFS_lock_row';
1360: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1361: l_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;
1362: lc_object_version_number OKC_RG_ROLE_DEFS.OBJECT_VERSION_NUMBER%TYPE;
1363: l_row_notfound BOOLEAN := FALSE;
1364: lc_row_notfound BOOLEAN := FALSE;
1365: BEGIN
1366: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1442: -- lock_row for:OKC_RG_ROLE_DEFS_V --

1438: '_PVT'
1439: );
1440: END lock_row;
1441: -------------------------------------
1442: -- lock_row for:OKC_RG_ROLE_DEFS_V --
1443: -------------------------------------
1444: PROCEDURE lock_row(
1445: p_api_version IN NUMBER,
1446: p_init_msg_list IN VARCHAR2,

Line 1590: -- update_row for:OKC_RG_ROLE_DEFS --

1586: ---------------------------------------------------------------------------
1587: -- PROCEDURE update_row
1588: ---------------------------------------------------------------------------
1589: -------------------------------------
1590: -- update_row for:OKC_RG_ROLE_DEFS --
1591: -------------------------------------
1592: PROCEDURE update_row(
1593: p_init_msg_list IN VARCHAR2,
1594: x_return_status OUT NOCOPY VARCHAR2,

Line 1738: -- Set_Attributes for:OKC_RG_ROLE_DEFS --

1734: END IF;
1735: RETURN(l_return_status);
1736: END populate_new_record;
1737: -----------------------------------------
1738: -- Set_Attributes for:OKC_RG_ROLE_DEFS --
1739: -----------------------------------------
1740: FUNCTION Set_Attributes (
1741: p_rrd_rec IN rrd_rec_type,
1742: x_rrd_rec OUT NOCOPY rrd_rec_type

Line 1775: UPDATE OKC_RG_ROLE_DEFS

1771: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1772: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1773: RAISE OKC_API.G_EXCEPTION_ERROR;
1774: END IF;
1775: UPDATE OKC_RG_ROLE_DEFS
1776: SET SRD_ID = l_def_rrd_rec.srd_id,
1777: SRE_ID = l_def_rrd_rec.sre_id,
1778: OBJECT_VERSION_NUMBER = l_def_rrd_rec.object_version_number,
1779: CREATED_BY = l_def_rrd_rec.created_by,

Line 1840: -- update_row for:OKC_RG_ROLE_DEFS_V --

1836: '_PVT'
1837: );
1838: END update_row;
1839: ---------------------------------------
1840: -- update_row for:OKC_RG_ROLE_DEFS_V --
1841: ---------------------------------------
1842: PROCEDURE update_row(
1843: p_api_version IN NUMBER,
1844: p_init_msg_list IN VARCHAR2,

Line 2003: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --

1999: END IF;
2000: RETURN(l_return_status);
2001: END populate_new_record;
2002: -------------------------------------------
2003: -- Set_Attributes for:OKC_RG_ROLE_DEFS_V --
2004: -------------------------------------------
2005: FUNCTION Set_Attributes (
2006: p_rrdv_rec IN rrdv_rec_type,
2007: x_rrdv_rec OUT NOCOPY rrdv_rec_type

Line 2186: -- delete_row for:OKC_RG_ROLE_DEFS --

2182: ---------------------------------------------------------------------------
2183: -- PROCEDURE delete_row
2184: ---------------------------------------------------------------------------
2185: -------------------------------------
2186: -- delete_row for:OKC_RG_ROLE_DEFS --
2187: -------------------------------------
2188: PROCEDURE delete_row(
2189: p_init_msg_list IN VARCHAR2,
2190: x_return_status OUT NOCOPY VARCHAR2,

Line 2210: DELETE FROM OKC_RG_ROLE_DEFS

2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: DELETE FROM OKC_RG_ROLE_DEFS
2211: WHERE ID = l_rrd_rec.id;
2212:
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION

Line 2247: -- delete_row for:OKC_RG_ROLE_DEFS_V --

2243: '_PVT'
2244: );
2245: END delete_row;
2246: ---------------------------------------
2247: -- delete_row for:OKC_RG_ROLE_DEFS_V --
2248: ---------------------------------------
2249: PROCEDURE delete_row(
2250: p_api_version IN NUMBER,
2251: p_init_msg_list IN VARCHAR2,