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.OKL_CGR_PVT dependencies on OKL_CONTEXT_GROUPS_B

Line 43: FROM OKL_CONTEXT_GROUPS_B B

39: BEGIN
40: DELETE FROM OKL_CONTEXT_GROUPS_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_CONTEXT_GROUPS_B B
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_CONTEXT_GROUPS_TL T SET (

Line 102: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_B

98:
99: END add_language;
100:
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKL_CONTEXT_GROUPS_B
103: ---------------------------------------------------------------------------
104: FUNCTION get_rec (
105: p_cgr_rec IN cgr_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN

Line 108: CURSOR okl_context_groups_b_pk_csr (p_id IN NUMBER) IS

104: FUNCTION get_rec (
105: p_cgr_rec IN cgr_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN
107: ) RETURN cgr_rec_type IS
108: CURSOR okl_context_groups_b_pk_csr (p_id IN NUMBER) IS
109: SELECT
110: ID,
111: NAME,
112: OBJECT_VERSION_NUMBER,

Line 118: FROM Okl_Context_Groups_B

114: CREATION_DATE,
115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okl_Context_Groups_B
119: WHERE okl_context_groups_b.id = p_id;
120: l_okl_context_groups_b_pk okl_context_groups_b_pk_csr%ROWTYPE;
121: l_cgr_rec cgr_rec_type;
122: BEGIN

Line 119: WHERE okl_context_groups_b.id = p_id;

115: LAST_UPDATED_BY,
116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okl_Context_Groups_B
119: WHERE okl_context_groups_b.id = p_id;
120: l_okl_context_groups_b_pk okl_context_groups_b_pk_csr%ROWTYPE;
121: l_cgr_rec cgr_rec_type;
122: BEGIN
123: x_no_data_found := TRUE;

Line 120: l_okl_context_groups_b_pk okl_context_groups_b_pk_csr%ROWTYPE;

116: LAST_UPDATE_DATE,
117: LAST_UPDATE_LOGIN
118: FROM Okl_Context_Groups_B
119: WHERE okl_context_groups_b.id = p_id;
120: l_okl_context_groups_b_pk okl_context_groups_b_pk_csr%ROWTYPE;
121: l_cgr_rec cgr_rec_type;
122: BEGIN
123: x_no_data_found := TRUE;
124: -- Get current database values

Line 125: OPEN okl_context_groups_b_pk_csr (p_cgr_rec.id);

121: l_cgr_rec cgr_rec_type;
122: BEGIN
123: x_no_data_found := TRUE;
124: -- Get current database values
125: OPEN okl_context_groups_b_pk_csr (p_cgr_rec.id);
126: FETCH okl_context_groups_b_pk_csr INTO
127: l_cgr_rec.ID,
128: l_cgr_rec.NAME,
129: l_cgr_rec.OBJECT_VERSION_NUMBER,

Line 126: FETCH okl_context_groups_b_pk_csr INTO

122: BEGIN
123: x_no_data_found := TRUE;
124: -- Get current database values
125: OPEN okl_context_groups_b_pk_csr (p_cgr_rec.id);
126: FETCH okl_context_groups_b_pk_csr INTO
127: l_cgr_rec.ID,
128: l_cgr_rec.NAME,
129: l_cgr_rec.OBJECT_VERSION_NUMBER,
130: l_cgr_rec.CREATED_BY,

Line 135: x_no_data_found := okl_context_groups_b_pk_csr%NOTFOUND;

131: l_cgr_rec.CREATION_DATE,
132: l_cgr_rec.LAST_UPDATED_BY,
133: l_cgr_rec.LAST_UPDATE_DATE,
134: l_cgr_rec.LAST_UPDATE_LOGIN;
135: x_no_data_found := okl_context_groups_b_pk_csr%NOTFOUND;
136: CLOSE okl_context_groups_b_pk_csr;
137: RETURN(l_cgr_rec);
138: END get_rec;
139:

Line 136: CLOSE okl_context_groups_b_pk_csr;

132: l_cgr_rec.LAST_UPDATED_BY,
133: l_cgr_rec.LAST_UPDATE_DATE,
134: l_cgr_rec.LAST_UPDATE_LOGIN;
135: x_no_data_found := okl_context_groups_b_pk_csr%NOTFOUND;
136: CLOSE okl_context_groups_b_pk_csr;
137: RETURN(l_cgr_rec);
138: END get_rec;
139:
140: FUNCTION get_rec (

Line 896: -- insert_row for:OKL_CONTEXT_GROUPS_B --

892: ---------------------------------------------------------------------------
893: -- PROCEDURE insert_row
894: ---------------------------------------------------------------------------
895: -----------------------------------------
896: -- insert_row for:OKL_CONTEXT_GROUPS_B --
897: -----------------------------------------
898: PROCEDURE insert_row(
899: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
900: x_return_status OUT NOCOPY VARCHAR2,

Line 912: -- Set_Attributes for:OKL_CONTEXT_GROUPS_B --

908: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
909: l_cgr_rec cgr_rec_type := p_cgr_rec;
910: l_def_cgr_rec cgr_rec_type;
911: ---------------------------------------------
912: -- Set_Attributes for:OKL_CONTEXT_GROUPS_B --
913: ---------------------------------------------
914: FUNCTION Set_Attributes (
915: p_cgr_rec IN cgr_rec_type,
916: x_cgr_rec OUT NOCOPY cgr_rec_type

Line 943: INSERT INTO OKL_CONTEXT_GROUPS_B(

939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
941: RAISE OKC_API.G_EXCEPTION_ERROR;
942: END IF;
943: INSERT INTO OKL_CONTEXT_GROUPS_B(
944: id,
945: name,
946: object_version_number,
947: created_by,

Line 1353: -- lock_row for:OKL_CONTEXT_GROUPS_B --

1349: ---------------------------------------------------------------------------
1350: -- PROCEDURE lock_row
1351: ---------------------------------------------------------------------------
1352: ---------------------------------------
1353: -- lock_row for:OKL_CONTEXT_GROUPS_B --
1354: ---------------------------------------
1355: PROCEDURE lock_row(
1356: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1357: x_return_status OUT NOCOPY VARCHAR2,

Line 1366: FROM OKL_CONTEXT_GROUPS_B

1362: E_Resource_Busy EXCEPTION;
1363: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1364: CURSOR lock_csr (p_cgr_rec IN cgr_rec_type) IS
1365: SELECT OBJECT_VERSION_NUMBER
1366: FROM OKL_CONTEXT_GROUPS_B
1367: WHERE ID = p_cgr_rec.id
1368: AND OBJECT_VERSION_NUMBER = p_cgr_rec.object_version_number
1369: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1370:

Line 1373: FROM OKL_CONTEXT_GROUPS_B

1369: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1370:
1371: CURSOR lchk_csr (p_cgr_rec IN cgr_rec_type) IS
1372: SELECT OBJECT_VERSION_NUMBER
1373: FROM OKL_CONTEXT_GROUPS_B
1374: WHERE ID = p_cgr_rec.id;
1375: l_api_version CONSTANT NUMBER := 1;
1376: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1378: l_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

1374: WHERE ID = p_cgr_rec.id;
1375: l_api_version CONSTANT NUMBER := 1;
1376: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: l_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1379: lc_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1380: l_row_notfound BOOLEAN := FALSE;
1381: lc_row_notfound BOOLEAN := FALSE;
1382: BEGIN

Line 1379: lc_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

1375: l_api_version CONSTANT NUMBER := 1;
1376: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: l_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1379: lc_object_version_number OKL_CONTEXT_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
1380: l_row_notfound BOOLEAN := FALSE;
1381: lc_row_notfound BOOLEAN := FALSE;
1382: BEGIN
1383: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1716: -- update_row for:OKL_CONTEXT_GROUPS_B --

1712: ---------------------------------------------------------------------------
1713: -- PROCEDURE update_row
1714: ---------------------------------------------------------------------------
1715: -----------------------------------------
1716: -- update_row for:OKL_CONTEXT_GROUPS_B --
1717: -----------------------------------------
1718: PROCEDURE update_row(
1719: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1720: x_return_status OUT NOCOPY VARCHAR2,

Line 1784: -- Set_Attributes for:OKL_CONTEXT_GROUPS_B --

1780: END IF;
1781: RETURN(l_return_status);
1782: END populate_new_record;
1783: ---------------------------------------------
1784: -- Set_Attributes for:OKL_CONTEXT_GROUPS_B --
1785: ---------------------------------------------
1786: FUNCTION Set_Attributes (
1787: p_cgr_rec IN cgr_rec_type,
1788: x_cgr_rec OUT NOCOPY cgr_rec_type

Line 1821: UPDATE OKL_CONTEXT_GROUPS_B

1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1819: RAISE OKC_API.G_EXCEPTION_ERROR;
1820: END IF;
1821: UPDATE OKL_CONTEXT_GROUPS_B
1822: SET NAME = l_def_cgr_rec.name,
1823: OBJECT_VERSION_NUMBER = l_def_cgr_rec.object_version_number,
1824: CREATED_BY = l_def_cgr_rec.created_by,
1825: CREATION_DATE = l_def_cgr_rec.creation_date,

Line 2334: -- delete_row for:OKL_CONTEXT_GROUPS_B --

2330: ---------------------------------------------------------------------------
2331: -- PROCEDURE delete_row
2332: ---------------------------------------------------------------------------
2333: -----------------------------------------
2334: -- delete_row for:OKL_CONTEXT_GROUPS_B --
2335: -----------------------------------------
2336: PROCEDURE delete_row(
2337: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2338: x_return_status OUT NOCOPY VARCHAR2,

Line 2358: DELETE FROM OKL_CONTEXT_GROUPS_B

2354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2355: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2356: RAISE OKC_API.G_EXCEPTION_ERROR;
2357: END IF;
2358: DELETE FROM OKL_CONTEXT_GROUPS_B
2359: WHERE ID = l_cgr_rec.id;
2360:
2361: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2362: EXCEPTION

Line 2713: FROM OKL_CONTEXT_GROUPS_B

2709:
2710: BEGIN
2711: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
2712: INTO id, db_luby, db_ludate
2713: FROM OKL_CONTEXT_GROUPS_B
2714: where ID = p_cgrv_rec.id;
2715:
2716: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2717: db_ludate, '')) then

Line 2719: UPDATE OKL_CONTEXT_GROUPS_B

2715:
2716: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2717: db_ludate, '')) then
2718: --Update _b
2719: UPDATE OKL_CONTEXT_GROUPS_B
2720: SET OBJECT_VERSION_NUMBER = TO_NUMBER(p_cgrv_rec.object_version_number),
2721: NAME = p_cgrv_rec.name,
2722: LAST_UPDATE_DATE = f_ludate,
2723: LAST_UPDATED_BY = f_luby,

Line 2776: INSERT INTO OKL_CONTEXT_GROUPS_B

2772: END;
2773: EXCEPTION
2774: when no_data_found then
2775:
2776: INSERT INTO OKL_CONTEXT_GROUPS_B
2777: (
2778: ID,
2779: NAME,
2780: OBJECT_VERSION_NUMBER,

Line 2798: from OKL_CONTEXT_GROUPS_B

2794: f_ludate,
2795: 0
2796: FROM DUAL
2797: WHERE NOT EXISTS (SELECT 1
2798: from OKL_CONTEXT_GROUPS_B
2799: where NAME = p_cgrv_rec.NAME);
2800:
2801: INSERT INTO OKL_CONTEXT_GROUPS_TL
2802: (