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_OVT_PVT dependencies on OKL_OVD_RUL_TMLS

Line 36: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_ovt_rec IN ovt_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_ovd_rul_tmls_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_ovt_rec IN ovt_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN ovt_rec_type IS
42: CURSOR okl_ovd_rul_tmls_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: RUL_ID,
46: SEQUENCE_NUMBER,

Line 54: FROM Okl_Ovd_Rul_Tmls

50: CREATION_DATE,
51: LAST_UPDATED_BY,
52: LAST_UPDATE_DATE,
53: LAST_UPDATE_LOGIN
54: FROM Okl_Ovd_Rul_Tmls
55: WHERE okl_ovd_rul_tmls.id = p_id;
56: l_okl_ovd_rul_tmls_pk okl_ovd_rul_tmls_pk_csr%ROWTYPE;
57: l_ovt_rec ovt_rec_type;
58: BEGIN

Line 55: WHERE okl_ovd_rul_tmls.id = p_id;

51: LAST_UPDATED_BY,
52: LAST_UPDATE_DATE,
53: LAST_UPDATE_LOGIN
54: FROM Okl_Ovd_Rul_Tmls
55: WHERE okl_ovd_rul_tmls.id = p_id;
56: l_okl_ovd_rul_tmls_pk okl_ovd_rul_tmls_pk_csr%ROWTYPE;
57: l_ovt_rec ovt_rec_type;
58: BEGIN
59: x_no_data_found := TRUE;

Line 56: l_okl_ovd_rul_tmls_pk okl_ovd_rul_tmls_pk_csr%ROWTYPE;

52: LAST_UPDATE_DATE,
53: LAST_UPDATE_LOGIN
54: FROM Okl_Ovd_Rul_Tmls
55: WHERE okl_ovd_rul_tmls.id = p_id;
56: l_okl_ovd_rul_tmls_pk okl_ovd_rul_tmls_pk_csr%ROWTYPE;
57: l_ovt_rec ovt_rec_type;
58: BEGIN
59: x_no_data_found := TRUE;
60: -- Get current database values

Line 61: OPEN okl_ovd_rul_tmls_pk_csr (p_ovt_rec.id);

57: l_ovt_rec ovt_rec_type;
58: BEGIN
59: x_no_data_found := TRUE;
60: -- Get current database values
61: OPEN okl_ovd_rul_tmls_pk_csr (p_ovt_rec.id);
62: FETCH okl_ovd_rul_tmls_pk_csr INTO
63: l_ovt_rec.ID,
64: l_ovt_rec.RUL_ID,
65: l_ovt_rec.SEQUENCE_NUMBER,

Line 62: FETCH okl_ovd_rul_tmls_pk_csr INTO

58: BEGIN
59: x_no_data_found := TRUE;
60: -- Get current database values
61: OPEN okl_ovd_rul_tmls_pk_csr (p_ovt_rec.id);
62: FETCH okl_ovd_rul_tmls_pk_csr INTO
63: l_ovt_rec.ID,
64: l_ovt_rec.RUL_ID,
65: l_ovt_rec.SEQUENCE_NUMBER,
66: l_ovt_rec.OVD_ID,

Line 73: x_no_data_found := okl_ovd_rul_tmls_pk_csr%NOTFOUND;

69: l_ovt_rec.CREATION_DATE,
70: l_ovt_rec.LAST_UPDATED_BY,
71: l_ovt_rec.LAST_UPDATE_DATE,
72: l_ovt_rec.LAST_UPDATE_LOGIN;
73: x_no_data_found := okl_ovd_rul_tmls_pk_csr%NOTFOUND;
74: CLOSE okl_ovd_rul_tmls_pk_csr;
75: RETURN(l_ovt_rec);
76: END get_rec;
77:

Line 74: CLOSE okl_ovd_rul_tmls_pk_csr;

70: l_ovt_rec.LAST_UPDATED_BY,
71: l_ovt_rec.LAST_UPDATE_DATE,
72: l_ovt_rec.LAST_UPDATE_LOGIN;
73: x_no_data_found := okl_ovd_rul_tmls_pk_csr%NOTFOUND;
74: CLOSE okl_ovd_rul_tmls_pk_csr;
75: RETURN(l_ovt_rec);
76: END get_rec;
77:
78: FUNCTION get_rec (

Line 86: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS_V

82: BEGIN
83: RETURN(get_rec(p_ovt_rec, l_row_notfound));
84: END get_rec;
85: ---------------------------------------------------------------------------
86: -- FUNCTION get_rec for: OKL_OVD_RUL_TMLS_V
87: ---------------------------------------------------------------------------
88: FUNCTION get_rec (
89: p_ovtv_rec IN ovtv_rec_type,
90: x_no_data_found OUT NOCOPY BOOLEAN

Line 104: FROM Okl_Ovd_Rul_Tmls_V

100: CREATION_DATE,
101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okl_Ovd_Rul_Tmls_V
105: WHERE okl_ovd_rul_tmls_v.id = p_id;
106: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
107: l_ovtv_rec ovtv_rec_type;
108: BEGIN

Line 105: WHERE okl_ovd_rul_tmls_v.id = p_id;

101: LAST_UPDATED_BY,
102: LAST_UPDATE_DATE,
103: LAST_UPDATE_LOGIN
104: FROM Okl_Ovd_Rul_Tmls_V
105: WHERE okl_ovd_rul_tmls_v.id = p_id;
106: l_okl_ovtv_pk okl_ovtv_pk_csr%ROWTYPE;
107: l_ovtv_rec ovtv_rec_type;
108: BEGIN
109: x_no_data_found := TRUE;

Line 137: -- FUNCTION null_out_defaults for: OKL_OVD_RUL_TMLS_V --

133: RETURN(get_rec(p_ovtv_rec, l_row_notfound));
134: END get_rec;
135:
136: --------------------------------------------------------
137: -- FUNCTION null_out_defaults for: OKL_OVD_RUL_TMLS_V --
138: --------------------------------------------------------
139: FUNCTION null_out_defaults (
140: p_ovtv_rec IN ovtv_rec_type
141: ) RETURN ovtv_rec_type IS

Line 180: -- Validate_Attributes for:OKL_OVD_RUL_TMLS_V --

176: ---------------------------------------------------------------------------
177: -- PROCEDURE Validate_Attributes
178: ---------------------------------------------------------------------------
179: ------------------------------------------------
180: -- Validate_Attributes for:OKL_OVD_RUL_TMLS_V --
181: ------------------------------------------------
182: FUNCTION Validate_Attributes (
183: p_ovtv_rec IN ovtv_rec_type
184: ) RETURN VARCHAR2 IS

Line 220: -- Validate_Record for:OKL_OVD_RUL_TMLS_V --

216: ---------------------------------------------------------------------------
217: -- PROCEDURE Validate_Record
218: ---------------------------------------------------------------------------
219: --------------------------------------------
220: -- Validate_Record for:OKL_OVD_RUL_TMLS_V --
221: --------------------------------------------
222: FUNCTION Validate_Record (
223: p_ovtv_rec IN ovtv_rec_type
224: ) RETURN VARCHAR2 IS

Line 755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,

751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
752: l_unq_tbl OKC_UTIL.unq_tbl_type;
753: l_ovt_status VARCHAR2(1);
754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id

Line 756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is

752: l_unq_tbl OKC_UTIL.unq_tbl_type;
753: l_ovt_status VARCHAR2(1);
754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id
760: AND rul_id = p_rul_id

Line 758: FROM okl_ovd_rul_tmls_v

754: l_row_found Boolean := False;
755: CURSOR c1(p_ovd_id okl_ovd_rul_tmls_v.ovd_id%TYPE,
756: p_rul_id okl_ovd_rul_tmls_v.rul_id%TYPE) is
757: SELECT '1'
758: FROM okl_ovd_rul_tmls_v
759: WHERE ovd_id = p_ovd_id
760: AND rul_id = p_rul_id
761: AND id <> nvl(p_ovtv_rec.id,-9999);
762: BEGIN

Line 772: OKC_API.set_message(G_APP_NAME,G_UNQS,G_TABLE_TOKEN, 'Okl_Ovd_Rul_Tmls_V'); ---CHG001

768: FETCH c1 into l_ovt_status;
769: l_row_found := c1%FOUND;
770: CLOSE c1;
771: IF l_row_found then
772: OKC_API.set_message(G_APP_NAME,G_UNQS,G_TABLE_TOKEN, 'Okl_Ovd_Rul_Tmls_V'); ---CHG001
773: x_return_status := OKC_API.G_RET_STS_ERROR;
774: END IF;
775: EXCEPTION
776: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 889: -- validate_row for:OKL_OVD_RUL_TMLS_V --

885: ---------------------------------------------------------------------------
886: -- PROCEDURE validate_row
887: ---------------------------------------------------------------------------
888: -----------------------------------------
889: -- validate_row for:OKL_OVD_RUL_TMLS_V --
890: -----------------------------------------
891: PROCEDURE validate_row(
892: p_api_version IN NUMBER,
893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1042: -- insert_row for:OKL_OVD_RUL_TMLS --

1038: ---------------------------------------------------------------------------
1039: -- PROCEDURE insert_row
1040: ---------------------------------------------------------------------------
1041: -------------------------------------
1042: -- insert_row for:OKL_OVD_RUL_TMLS --
1043: -------------------------------------
1044: PROCEDURE insert_row(
1045: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1046: x_return_status OUT NOCOPY VARCHAR2,

Line 1058: -- Set_Attributes for:OKL_OVD_RUL_TMLS --

1054: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1055: l_ovt_rec ovt_rec_type := p_ovt_rec;
1056: l_def_ovt_rec ovt_rec_type;
1057: -----------------------------------------
1058: -- Set_Attributes for:OKL_OVD_RUL_TMLS --
1059: -----------------------------------------
1060: FUNCTION Set_Attributes (
1061: p_ovt_rec IN ovt_rec_type,
1062: x_ovt_rec OUT NOCOPY ovt_rec_type

Line 1089: INSERT INTO OKL_OVD_RUL_TMLS(

1085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1087: RAISE OKC_API.G_EXCEPTION_ERROR;
1088: END IF;
1089: INSERT INTO OKL_OVD_RUL_TMLS(
1090: id,
1091: rul_id,
1092: sequence_number,
1093: ovd_id,

Line 1147: -- insert_row for:OKL_OVD_RUL_TMLS_V --

1143: '_PVT'
1144: );
1145: END insert_row;
1146: ---------------------------------------
1147: -- insert_row for:OKL_OVD_RUL_TMLS_V --
1148: ---------------------------------------
1149: PROCEDURE insert_row(
1150: p_api_version IN NUMBER,
1151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1181: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --

1177: l_ovtv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1178: RETURN(l_ovtv_rec);
1179: END fill_who_columns;
1180: -------------------------------------------
1181: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --
1182: -------------------------------------------
1183: FUNCTION Set_Attributes (
1184: p_ovtv_rec IN ovtv_rec_type,
1185: x_ovtv_rec OUT NOCOPY ovtv_rec_type

Line 1370: -- lock_row for:OKL_OVD_RUL_TMLS --

1366: ---------------------------------------------------------------------------
1367: -- PROCEDURE lock_row
1368: ---------------------------------------------------------------------------
1369: -----------------------------------
1370: -- lock_row for:OKL_OVD_RUL_TMLS --
1371: -----------------------------------
1372: PROCEDURE lock_row(
1373: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1374: x_return_status OUT NOCOPY VARCHAR2,

Line 1383: FROM OKL_OVD_RUL_TMLS

1379: E_Resource_Busy EXCEPTION;
1380: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1381: CURSOR lock_csr (p_ovt_rec IN ovt_rec_type) IS
1382: SELECT OBJECT_VERSION_NUMBER
1383: FROM OKL_OVD_RUL_TMLS
1384: WHERE ID = p_ovt_rec.id
1385: AND OBJECT_VERSION_NUMBER = p_ovt_rec.object_version_number
1386: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1387:

Line 1390: FROM OKL_OVD_RUL_TMLS

1386: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1387:
1388: CURSOR lchk_csr (p_ovt_rec IN ovt_rec_type) IS
1389: SELECT OBJECT_VERSION_NUMBER
1390: FROM OKL_OVD_RUL_TMLS
1391: WHERE ID = p_ovt_rec.id;
1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'TMLS_lock_row';
1394: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1395: l_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;

1391: WHERE ID = p_ovt_rec.id;
1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'TMLS_lock_row';
1394: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1395: l_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;
1396: lc_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;
1397: l_row_notfound BOOLEAN := FALSE;
1398: lc_row_notfound BOOLEAN := FALSE;
1399: BEGIN

Line 1396: lc_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;

1392: l_api_version CONSTANT NUMBER := 1;
1393: l_api_name CONSTANT VARCHAR2(30) := 'TMLS_lock_row';
1394: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1395: l_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;
1396: lc_object_version_number OKL_OVD_RUL_TMLS.OBJECT_VERSION_NUMBER%TYPE;
1397: l_row_notfound BOOLEAN := FALSE;
1398: lc_row_notfound BOOLEAN := FALSE;
1399: BEGIN
1400: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1476: -- lock_row for:OKL_OVD_RUL_TMLS_V --

1472: '_PVT'
1473: );
1474: END lock_row;
1475: -------------------------------------
1476: -- lock_row for:OKL_OVD_RUL_TMLS_V --
1477: -------------------------------------
1478: PROCEDURE lock_row(
1479: p_api_version IN NUMBER,
1480: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1633: -- update_row for:OKL_OVD_RUL_TMLS --

1629: ---------------------------------------------------------------------------
1630: -- PROCEDURE update_row
1631: ---------------------------------------------------------------------------
1632: -------------------------------------
1633: -- update_row for:OKL_OVD_RUL_TMLS --
1634: -------------------------------------
1635: PROCEDURE update_row(
1636: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1637: x_return_status OUT NOCOPY VARCHAR2,

Line 1709: -- Set_Attributes for:OKL_OVD_RUL_TMLS --

1705: END IF;
1706: RETURN(l_return_status);
1707: END populate_new_record;
1708: -----------------------------------------
1709: -- Set_Attributes for:OKL_OVD_RUL_TMLS --
1710: -----------------------------------------
1711: FUNCTION Set_Attributes (
1712: p_ovt_rec IN ovt_rec_type,
1713: x_ovt_rec OUT NOCOPY ovt_rec_type

Line 1746: UPDATE OKL_OVD_RUL_TMLS

1742: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1744: RAISE OKC_API.G_EXCEPTION_ERROR;
1745: END IF;
1746: UPDATE OKL_OVD_RUL_TMLS
1747: SET RUL_ID = l_def_ovt_rec.rul_id,
1748: SEQUENCE_NUMBER = l_def_ovt_rec.sequence_number,
1749: OVD_ID = l_def_ovt_rec.ovd_id,
1750: OBJECT_VERSION_NUMBER = l_def_ovt_rec.object_version_number,

Line 1793: -- update_row for:OKL_OVD_RUL_TMLS_V --

1789: '_PVT'
1790: );
1791: END update_row;
1792: ---------------------------------------
1793: -- update_row for:OKL_OVD_RUL_TMLS_V --
1794: ---------------------------------------
1795: PROCEDURE update_row(
1796: p_api_version IN NUMBER,
1797: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1884: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --

1880: END IF;
1881: RETURN(l_return_status);
1882: END populate_new_record;
1883: -------------------------------------------
1884: -- Set_Attributes for:OKL_OVD_RUL_TMLS_V --
1885: -------------------------------------------
1886: FUNCTION Set_Attributes (
1887: p_ovtv_rec IN ovtv_rec_type,
1888: x_ovtv_rec OUT NOCOPY ovtv_rec_type

Line 2076: -- delete_row for:OKL_OVD_RUL_TMLS --

2072: ---------------------------------------------------------------------------
2073: -- PROCEDURE delete_row
2074: ---------------------------------------------------------------------------
2075: -------------------------------------
2076: -- delete_row for:OKL_OVD_RUL_TMLS --
2077: -------------------------------------
2078: PROCEDURE delete_row(
2079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2080: x_return_status OUT NOCOPY VARCHAR2,

Line 2100: DELETE FROM OKL_OVD_RUL_TMLS

2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;
2100: DELETE FROM OKL_OVD_RUL_TMLS
2101: WHERE ID = l_ovt_rec.id;
2102:
2103: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2104: EXCEPTION

Line 2137: -- delete_row for:OKL_OVD_RUL_TMLS_V --

2133: '_PVT'
2134: );
2135: END delete_row;
2136: ---------------------------------------
2137: -- delete_row for:OKL_OVD_RUL_TMLS_V --
2138: ---------------------------------------
2139: PROCEDURE delete_row(
2140: p_api_version IN NUMBER,
2141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,