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_CLS_PVT dependencies on OKL_CRTRN_LNSTYLS

Line 95: p_token3_value => 'OKL_CRTRN_LNSTYLS_V');

91: p_token1_value => 'CRN_ID_FOR',
92: p_token2 => G_CHILD_TABLE_TOKEN,
93: p_token2_value => G_VIEW,
94: p_token3 => G_PARENT_TABLE_TOKEN,
95: p_token3_value => 'OKL_CRTRN_LNSTYLS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_crn_id;

Line 144: p_token3_value => 'OKL_CRTRN_LNSTYLS_V');

140: p_token1_value => 'LSE_ID_FOR',
141: p_token2 => G_CHILD_TABLE_TOKEN,
142: p_token2_value => G_VIEW,
143: p_token3 => G_PARENT_TABLE_TOKEN,
144: p_token3_value => 'OKL_CRTRN_LNSTYLS_V');
145:
146: RAISE G_EXCEPTION_HALT_VALIDATION;
147: END IF;
148: END validate_lse_id;

Line 184: -- FUNCTION get_rec for: OKL_CRTRN_LNSTYLS

180: NULL;
181: END api_copy;
182:
183: ---------------------------------------------------------------------------
184: -- FUNCTION get_rec for: OKL_CRTRN_LNSTYLS
185: ---------------------------------------------------------------------------
186: FUNCTION get_rec (
187: p_cls_rec IN cls_rec_type,
188: x_no_data_found OUT NOCOPY BOOLEAN

Line 217: FROM Okl_Crtrn_Lnstyls

213: CREATION_DATE,
214: LAST_UPDATED_BY,
215: LAST_UPDATE_DATE,
216: LAST_UPDATE_LOGIN
217: FROM Okl_Crtrn_Lnstyls
218: WHERE okl_crtrn_lnstyls.id = p_id;
219: l_cls_pk cls_pk_csr%ROWTYPE;
220: l_cls_rec cls_rec_type;
221: BEGIN

Line 218: WHERE okl_crtrn_lnstyls.id = p_id;

214: LAST_UPDATED_BY,
215: LAST_UPDATE_DATE,
216: LAST_UPDATE_LOGIN
217: FROM Okl_Crtrn_Lnstyls
218: WHERE okl_crtrn_lnstyls.id = p_id;
219: l_cls_pk cls_pk_csr%ROWTYPE;
220: l_cls_rec cls_rec_type;
221: BEGIN
222: x_no_data_found := TRUE;

Line 264: -- FUNCTION get_rec for: OKL_CRTRN_LNSTYLS_V

260: BEGIN
261: RETURN(get_rec(p_cls_rec, l_row_notfound));
262: END get_rec;
263: ---------------------------------------------------------------------------
264: -- FUNCTION get_rec for: OKL_CRTRN_LNSTYLS_V
265: ---------------------------------------------------------------------------
266: FUNCTION get_rec (
267: p_clsv_rec IN clsv_rec_type,
268: x_no_data_found OUT NOCOPY BOOLEAN

Line 297: FROM Okl_Crtrn_Lnstyls_V

293: CREATION_DATE,
294: LAST_UPDATED_BY,
295: LAST_UPDATE_DATE,
296: LAST_UPDATE_LOGIN
297: FROM Okl_Crtrn_Lnstyls_V
298: WHERE okl_crtrn_lnstyls_v.id = p_id;
299: l_okl_clsv_pk okl_clsv_pk_csr%ROWTYPE;
300: l_clsv_rec clsv_rec_type;
301: BEGIN

Line 298: WHERE okl_crtrn_lnstyls_v.id = p_id;

294: LAST_UPDATED_BY,
295: LAST_UPDATE_DATE,
296: LAST_UPDATE_LOGIN
297: FROM Okl_Crtrn_Lnstyls_V
298: WHERE okl_crtrn_lnstyls_v.id = p_id;
299: l_okl_clsv_pk okl_clsv_pk_csr%ROWTYPE;
300: l_clsv_rec clsv_rec_type;
301: BEGIN
302: x_no_data_found := TRUE;

Line 345: -- FUNCTION null_out_defaults for: OKL_CRTRN_LNSTYLS_V --

341: RETURN(get_rec(p_clsv_rec, l_row_notfound));
342: END get_rec;
343:
344: ---------------------------------------------------------
345: -- FUNCTION null_out_defaults for: OKL_CRTRN_LNSTYLS_V --
346: ---------------------------------------------------------
347: FUNCTION null_out_defaults (
348: p_clsv_rec IN clsv_rec_type
349: ) RETURN clsv_rec_type IS

Line 430: -- Validate_Attributes for:OKL_CRTRN_LNSTYLS_V --

426: ---------------------------------------------------------------------------
427: -- PROCEDURE Validate_Attributes
428: ---------------------------------------------------------------------------
429: -------------------------------------------------
430: -- Validate_Attributes for:OKL_CRTRN_LNSTYLS_V --
431: -------------------------------------------------
432: FUNCTION Validate_Attributes (
433: p_clsv_rec IN clsv_rec_type
434: ) RETURN VARCHAR2 IS

Line 489: -- Validate_Record for:OKL_CRTRN_LNSTYLS_V --

485: ---------------------------------------------------------------------------
486: -- PROCEDURE Validate_Record
487: ---------------------------------------------------------------------------
488: ---------------------------------------------
489: -- Validate_Record for:OKL_CRTRN_LNSTYLS_V --
490: ---------------------------------------------
491: FUNCTION Validate_Record (
492: p_clsv_rec IN clsv_rec_type
493: ) RETURN VARCHAR2 IS

Line 569: -- validate_row for:OKL_CRTRN_LNSTYLS_V --

565: ---------------------------------------------------------------------------
566: -- PROCEDURE validate_row
567: ---------------------------------------------------------------------------
568: ------------------------------------------
569: -- validate_row for:OKL_CRTRN_LNSTYLS_V --
570: ------------------------------------------
571: PROCEDURE validate_row(
572: p_api_version IN NUMBER,
573: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 713: -- insert_row for:OKL_CRTRN_LNSTYLS --

709: ---------------------------------------------------------------------------
710: -- PROCEDURE insert_row
711: ---------------------------------------------------------------------------
712: --------------------------------------
713: -- insert_row for:OKL_CRTRN_LNSTYLS --
714: --------------------------------------
715: PROCEDURE insert_row(
716: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
717: x_return_status OUT NOCOPY VARCHAR2,

Line 729: -- Set_Attributes for:OKL_CRTRN_LNSTYLS --

725: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
726: l_cls_rec cls_rec_type := p_cls_rec;
727: l_def_cls_rec cls_rec_type;
728: ------------------------------------------
729: -- Set_Attributes for:OKL_CRTRN_LNSTYLS --
730: ------------------------------------------
731: FUNCTION Set_Attributes (
732: p_cls_rec IN cls_rec_type,
733: x_cls_rec OUT NOCOPY cls_rec_type

Line 760: INSERT INTO OKL_CRTRN_LNSTYLS(

756: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
757: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
758: RAISE okl_api.G_EXCEPTION_ERROR;
759: END IF;
760: INSERT INTO OKL_CRTRN_LNSTYLS(
761: id,
762: crn_id,
763: lse_id,
764: object_version_number,

Line 848: -- insert_row for:OKL_CRTRN_LNSTYLS_V --

844: '_PVT'
845: );
846: END insert_row;
847: ----------------------------------------
848: -- insert_row for:OKL_CRTRN_LNSTYLS_V --
849: ----------------------------------------
850: PROCEDURE insert_row(
851: p_api_version IN NUMBER,
852: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 882: -- Set_Attributes for:OKL_CRTRN_LNSTYLS_V --

878: l_clsv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
879: RETURN(l_clsv_rec);
880: END fill_who_columns;
881: --------------------------------------------
882: -- Set_Attributes for:OKL_CRTRN_LNSTYLS_V --
883: --------------------------------------------
884: FUNCTION Set_Attributes (
885: p_clsv_rec IN clsv_rec_type,
886: x_clsv_rec OUT NOCOPY clsv_rec_type

Line 1062: -- lock_row for:OKL_CRTRN_LNSTYLS --

1058: ---------------------------------------------------------------------------
1059: -- PROCEDURE lock_row
1060: ---------------------------------------------------------------------------
1061: ------------------------------------
1062: -- lock_row for:OKL_CRTRN_LNSTYLS --
1063: ------------------------------------
1064: PROCEDURE lock_row(
1065: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1066: x_return_status OUT NOCOPY VARCHAR2,

Line 1075: FROM OKL_CRTRN_LNSTYLS

1071: E_Resource_Busy EXCEPTION;
1072: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1073: CURSOR lock_csr (p_cls_rec IN cls_rec_type) IS
1074: SELECT OBJECT_VERSION_NUMBER
1075: FROM OKL_CRTRN_LNSTYLS
1076: WHERE ID = p_cls_rec.id
1077: AND OBJECT_VERSION_NUMBER = p_cls_rec.object_version_number
1078: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1079:

Line 1082: FROM OKL_CRTRN_LNSTYLS

1078: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1079:
1080: CURSOR lchk_csr (p_cls_rec IN cls_rec_type) IS
1081: SELECT OBJECT_VERSION_NUMBER
1082: FROM OKL_CRTRN_LNSTYLS
1083: WHERE ID = p_cls_rec.id;
1084: l_api_version CONSTANT NUMBER := 1;
1085: l_api_name CONSTANT VARCHAR2(30) := 'LNSTYLS_lock_row';
1086: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1087: l_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;

1083: WHERE ID = p_cls_rec.id;
1084: l_api_version CONSTANT NUMBER := 1;
1085: l_api_name CONSTANT VARCHAR2(30) := 'LNSTYLS_lock_row';
1086: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1087: l_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;
1088: lc_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;
1089: l_row_notfound BOOLEAN := FALSE;
1090: lc_row_notfound BOOLEAN := FALSE;
1091: BEGIN

Line 1088: lc_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;

1084: l_api_version CONSTANT NUMBER := 1;
1085: l_api_name CONSTANT VARCHAR2(30) := 'LNSTYLS_lock_row';
1086: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1087: l_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;
1088: lc_object_version_number OKL_CRTRN_LNSTYLS.OBJECT_VERSION_NUMBER%TYPE;
1089: l_row_notfound BOOLEAN := FALSE;
1090: lc_row_notfound BOOLEAN := FALSE;
1091: BEGIN
1092: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1168: -- lock_row for:OKL_CRTRN_LNSTYLS_V --

1164: '_PVT'
1165: );
1166: END lock_row;
1167: --------------------------------------
1168: -- lock_row for:OKL_CRTRN_LNSTYLS_V --
1169: --------------------------------------
1170: PROCEDURE lock_row(
1171: p_api_version IN NUMBER,
1172: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1316: -- update_row for:OKL_CRTRN_LNSTYLS --

1312: ---------------------------------------------------------------------------
1313: -- PROCEDURE update_row
1314: ---------------------------------------------------------------------------
1315: --------------------------------------
1316: -- update_row for:OKL_CRTRN_LNSTYLS --
1317: --------------------------------------
1318: PROCEDURE update_row(
1319: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1320: x_return_status OUT NOCOPY VARCHAR2,

Line 1452: -- Set_Attributes for:OKL_CRTRN_LNSTYLS --

1448: END IF;
1449: RETURN(l_return_status);
1450: END populate_new_record;
1451: ------------------------------------------
1452: -- Set_Attributes for:OKL_CRTRN_LNSTYLS --
1453: ------------------------------------------
1454: FUNCTION Set_Attributes (
1455: p_cls_rec IN cls_rec_type,
1456: x_cls_rec OUT NOCOPY cls_rec_type

Line 1489: UPDATE OKL_CRTRN_LNSTYLS

1485: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1487: RAISE okl_api.G_EXCEPTION_ERROR;
1488: END IF;
1489: UPDATE OKL_CRTRN_LNSTYLS
1490: SET CRN_ID = l_def_cls_rec.crn_id,
1491: LSE_ID = l_def_cls_rec.lse_id,
1492: OBJECT_VERSION_NUMBER = l_def_cls_rec.object_version_number,
1493: ATTRIBUTE_CATEGORY = l_def_cls_rec.attribute_category,

Line 1551: -- update_row for:OKL_CRTRN_LNSTYLS_V --

1547: '_PVT'
1548: );
1549: END update_row;
1550: ----------------------------------------
1551: -- update_row for:OKL_CRTRN_LNSTYLS_V --
1552: ----------------------------------------
1553: PROCEDURE update_row(
1554: p_api_version IN NUMBER,
1555: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1702: -- Set_Attributes for:OKL_CRTRN_LNSTYLS_V --

1698: END IF;
1699: RETURN(l_return_status);
1700: END populate_new_record;
1701: --------------------------------------------
1702: -- Set_Attributes for:OKL_CRTRN_LNSTYLS_V --
1703: --------------------------------------------
1704: FUNCTION Set_Attributes (
1705: p_clsv_rec IN clsv_rec_type,
1706: x_clsv_rec OUT NOCOPY clsv_rec_type

Line 1885: -- delete_row for:OKL_CRTRN_LNSTYLS --

1881: ---------------------------------------------------------------------------
1882: -- PROCEDURE delete_row
1883: ---------------------------------------------------------------------------
1884: --------------------------------------
1885: -- delete_row for:OKL_CRTRN_LNSTYLS --
1886: --------------------------------------
1887: PROCEDURE delete_row(
1888: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1889: x_return_status OUT NOCOPY VARCHAR2,

Line 1909: DELETE FROM OKL_CRTRN_LNSTYLS

1905: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1906: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1907: RAISE okl_api.G_EXCEPTION_ERROR;
1908: END IF;
1909: DELETE FROM OKL_CRTRN_LNSTYLS
1910: WHERE ID = l_cls_rec.id;
1911:
1912: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1913: EXCEPTION

Line 1946: -- delete_row for:OKL_CRTRN_LNSTYLS_V --

1942: '_PVT'
1943: );
1944: END delete_row;
1945: ----------------------------------------
1946: -- delete_row for:OKL_CRTRN_LNSTYLS_V --
1947: ----------------------------------------
1948: PROCEDURE delete_row(
1949: p_api_version IN NUMBER,
1950: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,