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_LAD_PVT dependencies on OKL_LEASEAPP_DATAPOINTS

Line 94: -- FUNCTION get_rec for: OKL_LEASEAPP_DATAPOINTS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_LEASEAPP_DATAPOINTS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_ladv_rec IN ladv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 113: FROM Okl_Leaseapp_Datapoints_V

109: LEASEAPP_ID,
110: DATA_POINT_ID,
111: DATA_POINT_CATEGORY,
112: DATA_POINT_VALUE
113: FROM Okl_Leaseapp_Datapoints_V
114: WHERE okl_leaseapp_datapoints_v.id = p_id;
115: l_okl_ladv_pk okl_ladv_pk_csr%ROWTYPE;
116: l_ladv_rec ladv_rec_type;
117: BEGIN

Line 114: WHERE okl_leaseapp_datapoints_v.id = p_id;

110: DATA_POINT_ID,
111: DATA_POINT_CATEGORY,
112: DATA_POINT_VALUE
113: FROM Okl_Leaseapp_Datapoints_V
114: WHERE okl_leaseapp_datapoints_v.id = p_id;
115: l_okl_ladv_pk okl_ladv_pk_csr%ROWTYPE;
116: l_ladv_rec ladv_rec_type;
117: BEGIN
118: x_no_data_found := TRUE;

Line 167: -- FUNCTION get_rec for: OKL_LEASEAPP_DATAPOINTS

163: BEGIN
164: RETURN(get_rec(p_ladv_rec, l_row_not_found));
165: END get_rec;
166: ---------------------------------------------------------------------------
167: -- FUNCTION get_rec for: OKL_LEASEAPP_DATAPOINTS
168: ---------------------------------------------------------------------------
169: FUNCTION get_rec (
170: p_lad_rec IN lad_rec_type,
171: x_no_data_found OUT NOCOPY BOOLEAN

Line 173: CURSOR okl_leaseapp_datapoints_pk_csr (p_id IN NUMBER) IS

169: FUNCTION get_rec (
170: p_lad_rec IN lad_rec_type,
171: x_no_data_found OUT NOCOPY BOOLEAN
172: ) RETURN lad_rec_type IS
173: CURSOR okl_leaseapp_datapoints_pk_csr (p_id IN NUMBER) IS
174: SELECT
175: ID,
176: OBJECT_VERSION_NUMBER,
177: CREATED_BY,

Line 186: FROM Okl_Leaseapp_Datapoints

182: LEASEAPP_ID,
183: DATA_POINT_ID,
184: DATA_POINT_CATEGORY,
185: DATA_POINT_VALUE
186: FROM Okl_Leaseapp_Datapoints
187: WHERE okl_leaseapp_datapoints.id = p_id;
188: l_okl_leaseapp_datapoints_pk okl_leaseapp_datapoints_pk_csr%ROWTYPE;
189: l_lad_rec lad_rec_type;
190: BEGIN

Line 187: WHERE okl_leaseapp_datapoints.id = p_id;

183: DATA_POINT_ID,
184: DATA_POINT_CATEGORY,
185: DATA_POINT_VALUE
186: FROM Okl_Leaseapp_Datapoints
187: WHERE okl_leaseapp_datapoints.id = p_id;
188: l_okl_leaseapp_datapoints_pk okl_leaseapp_datapoints_pk_csr%ROWTYPE;
189: l_lad_rec lad_rec_type;
190: BEGIN
191: x_no_data_found := TRUE;

Line 188: l_okl_leaseapp_datapoints_pk okl_leaseapp_datapoints_pk_csr%ROWTYPE;

184: DATA_POINT_CATEGORY,
185: DATA_POINT_VALUE
186: FROM Okl_Leaseapp_Datapoints
187: WHERE okl_leaseapp_datapoints.id = p_id;
188: l_okl_leaseapp_datapoints_pk okl_leaseapp_datapoints_pk_csr%ROWTYPE;
189: l_lad_rec lad_rec_type;
190: BEGIN
191: x_no_data_found := TRUE;
192: -- Get current database values

Line 193: OPEN okl_leaseapp_datapoints_pk_csr (p_lad_rec.id);

189: l_lad_rec lad_rec_type;
190: BEGIN
191: x_no_data_found := TRUE;
192: -- Get current database values
193: OPEN okl_leaseapp_datapoints_pk_csr (p_lad_rec.id);
194: FETCH okl_leaseapp_datapoints_pk_csr INTO
195: l_lad_rec.id,
196: l_lad_rec.object_version_number,
197: l_lad_rec.created_by,

Line 194: FETCH okl_leaseapp_datapoints_pk_csr INTO

190: BEGIN
191: x_no_data_found := TRUE;
192: -- Get current database values
193: OPEN okl_leaseapp_datapoints_pk_csr (p_lad_rec.id);
194: FETCH okl_leaseapp_datapoints_pk_csr INTO
195: l_lad_rec.id,
196: l_lad_rec.object_version_number,
197: l_lad_rec.created_by,
198: l_lad_rec.creation_date,

Line 206: x_no_data_found := okl_leaseapp_datapoints_pk_csr%NOTFOUND;

202: l_lad_rec.leaseapp_id,
203: l_lad_rec.data_point_id,
204: l_lad_rec.data_point_category,
205: l_lad_rec.data_point_value;
206: x_no_data_found := okl_leaseapp_datapoints_pk_csr%NOTFOUND;
207: CLOSE okl_leaseapp_datapoints_pk_csr;
208: RETURN(l_lad_rec);
209: END get_rec;
210:

Line 207: CLOSE okl_leaseapp_datapoints_pk_csr;

203: l_lad_rec.data_point_id,
204: l_lad_rec.data_point_category,
205: l_lad_rec.data_point_value;
206: x_no_data_found := okl_leaseapp_datapoints_pk_csr%NOTFOUND;
207: CLOSE okl_leaseapp_datapoints_pk_csr;
208: RETURN(l_lad_rec);
209: END get_rec;
210:
211: ------------------------------------------------------------------

Line 240: -- FUNCTION null_out_defaults for: OKL_LEASEAPP_DATAPOINTS_V

236: BEGIN
237: RETURN(get_rec(p_lad_rec, l_row_not_found));
238: END get_rec;
239: ---------------------------------------------------------------------------
240: -- FUNCTION null_out_defaults for: OKL_LEASEAPP_DATAPOINTS_V
241: ---------------------------------------------------------------------------
242: FUNCTION null_out_defaults (
243: p_ladv_rec IN ladv_rec_type
244: ) RETURN ladv_rec_type IS

Line 448: -- Validate_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --

444: ---------------------------------------------------------------------------
445: -- FUNCTION Validate_Attributes
446: ---------------------------------------------------------------------------
447: -------------------------------------------------------
448: -- Validate_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --
449: -------------------------------------------------------
450: FUNCTION Validate_Attributes (
451: p_ladv_rec IN ladv_rec_type
452: ) RETURN VARCHAR2 IS

Line 531: -- Validate Record for:OKL_LEASEAPP_DATAPOINTS_V --

527: ---------------------------------------------------------------------------
528: -- PROCEDURE Validate_Record
529: ---------------------------------------------------------------------------
530: ---------------------------------------------------
531: -- Validate Record for:OKL_LEASEAPP_DATAPOINTS_V --
532: ---------------------------------------------------
533: FUNCTION Validate_Record (
534: p_ladv_rec IN ladv_rec_type,
535: p_db_ladv_rec IN ladv_rec_type

Line 593: -- validate_row for:OKL_LEASEAPP_DATAPOINTS_V --

589: ---------------------------------------------------------------------------
590: -- PROCEDURE validate_row
591: ---------------------------------------------------------------------------
592: ------------------------------------------------
593: -- validate_row for:OKL_LEASEAPP_DATAPOINTS_V --
594: ------------------------------------------------
595: PROCEDURE validate_row(
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2,

Line 670: -- PL/SQL TBL validate_row for:OKL_LEASEAPP_DATAPOINTS_V --

666: '_PVT'
667: );
668: END validate_row;
669: -----------------------------------------------------------
670: -- PL/SQL TBL validate_row for:OKL_LEASEAPP_DATAPOINTS_V --
671: -----------------------------------------------------------
672: PROCEDURE validate_row(
673: p_api_version IN NUMBER,
674: p_init_msg_list IN VARCHAR2,

Line 766: -- PL/SQL TBL validate_row for:OKL_LEASEAPP_DATAPOINTS_V --

762: );
763: END validate_row;
764:
765: -----------------------------------------------------------
766: -- PL/SQL TBL validate_row for:OKL_LEASEAPP_DATAPOINTS_V --
767: -----------------------------------------------------------
768: PROCEDURE validate_row(
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2,

Line 831: -- insert_row for:OKL_LEASEAPP_DATAPOINTS --

827: ---------------------------------------------------------------------------
828: -- PROCEDURE insert_row
829: ---------------------------------------------------------------------------
830: --------------------------------------------
831: -- insert_row for:OKL_LEASEAPP_DATAPOINTS --
832: --------------------------------------------
833: PROCEDURE insert_row(
834: p_init_msg_list IN VARCHAR2,
835: x_return_status OUT NOCOPY VARCHAR2,

Line 847: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS --

843: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
844: l_lad_rec lad_rec_type := p_lad_rec;
845: l_def_lad_rec lad_rec_type;
846: ------------------------------------------------
847: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS --
848: ------------------------------------------------
849: FUNCTION Set_Attributes (
850: p_lad_rec IN lad_rec_type,
851: x_lad_rec OUT NOCOPY lad_rec_type

Line 878: INSERT INTO OKL_LEASEAPP_DATAPOINTS(

874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: INSERT INTO OKL_LEASEAPP_DATAPOINTS(
879: id,
880: object_version_number,
881: created_by,
882: creation_date,

Line 939: -- insert_row for :OKL_LEASEAPP_DATAPOINTS_V --

935: '_PVT'
936: );
937: END insert_row;
938: -----------------------------------------------
939: -- insert_row for :OKL_LEASEAPP_DATAPOINTS_V --
940: -----------------------------------------------
941: PROCEDURE insert_row(
942: p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2,

Line 973: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --

969: l_ladv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
970: RETURN(l_ladv_rec);
971: END fill_who_columns;
972: --------------------------------------------------
973: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --
974: --------------------------------------------------
975: FUNCTION Set_Attributes (
976: p_ladv_rec IN ladv_rec_type,
977: x_ladv_rec OUT NOCOPY ladv_rec_type

Line 1251: -- lock_row for:OKL_LEASEAPP_DATAPOINTS --

1247: ---------------------------------------------------------------------------
1248: -- PROCEDURE lock_row
1249: ---------------------------------------------------------------------------
1250: ------------------------------------------
1251: -- lock_row for:OKL_LEASEAPP_DATAPOINTS --
1252: ------------------------------------------
1253: PROCEDURE lock_row(
1254: p_init_msg_list IN VARCHAR2,
1255: x_return_status OUT NOCOPY VARCHAR2,

Line 1264: FROM OKL_LEASEAPP_DATAPOINTS

1260: E_Resource_Busy EXCEPTION;
1261: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1262: CURSOR lock_csr (p_lad_rec IN lad_rec_type) IS
1263: SELECT OBJECT_VERSION_NUMBER
1264: FROM OKL_LEASEAPP_DATAPOINTS
1265: WHERE ID = p_lad_rec.id
1266: AND OBJECT_VERSION_NUMBER = p_lad_rec.object_version_number
1267: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1268:

Line 1271: FROM OKL_LEASEAPP_DATAPOINTS

1267: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1268:
1269: CURSOR lchk_csr (p_lad_rec IN lad_rec_type) IS
1270: SELECT OBJECT_VERSION_NUMBER
1271: FROM OKL_LEASEAPP_DATAPOINTS
1272: WHERE ID = p_lad_rec.id;
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1276: l_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;

1272: WHERE ID = p_lad_rec.id;
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1276: l_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;
1277: lc_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;
1278: l_row_notfound BOOLEAN := FALSE;
1279: lc_row_notfound BOOLEAN := FALSE;
1280: BEGIN

Line 1277: lc_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;

1273: l_api_version CONSTANT NUMBER := 1;
1274: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1276: l_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;
1277: lc_object_version_number OKL_LEASEAPP_DATAPOINTS.OBJECT_VERSION_NUMBER%TYPE;
1278: l_row_notfound BOOLEAN := FALSE;
1279: lc_row_notfound BOOLEAN := FALSE;
1280: BEGIN
1281: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1358: -- lock_row for: OKL_LEASEAPP_DATAPOINTS_V --

1354: '_PVT'
1355: );
1356: END lock_row;
1357: ---------------------------------------------
1358: -- lock_row for: OKL_LEASEAPP_DATAPOINTS_V --
1359: ---------------------------------------------
1360: PROCEDURE lock_row(
1361: p_api_version IN NUMBER,
1362: p_init_msg_list IN VARCHAR2,

Line 1598: -- update_row for:OKL_LEASEAPP_DATAPOINTS --

1594: ---------------------------------------------------------------------------
1595: -- PROCEDURE update_row
1596: ---------------------------------------------------------------------------
1597: --------------------------------------------
1598: -- update_row for:OKL_LEASEAPP_DATAPOINTS --
1599: --------------------------------------------
1600: PROCEDURE update_row(
1601: p_init_msg_list IN VARCHAR2,
1602: x_return_status OUT NOCOPY VARCHAR2,

Line 1677: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS --

1673: END IF;
1674: RETURN(l_return_status);
1675: END populate_new_record;
1676: ------------------------------------------------
1677: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS --
1678: ------------------------------------------------
1679: FUNCTION Set_Attributes (
1680: p_lad_rec IN lad_rec_type,
1681: x_lad_rec OUT NOCOPY lad_rec_type

Line 1715: UPDATE OKL_LEASEAPP_DATAPOINTS

1711: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1713: RAISE OKC_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: UPDATE OKL_LEASEAPP_DATAPOINTS
1716: SET OBJECT_VERSION_NUMBER = l_def_lad_rec.object_version_number,
1717: CREATED_BY = l_def_lad_rec.created_by,
1718: CREATION_DATE = l_def_lad_rec.creation_date,
1719: LAST_UPDATED_BY = l_def_lad_rec.last_updated_by,

Line 1764: -- update_row for:OKL_LEASEAPP_DATAPOINTS_V --

1760: '_PVT'
1761: );
1762: END update_row;
1763: ----------------------------------------------
1764: -- update_row for:OKL_LEASEAPP_DATAPOINTS_V --
1765: ----------------------------------------------
1766: PROCEDURE update_row(
1767: p_api_version IN NUMBER,
1768: p_init_msg_list IN VARCHAR2,

Line 1856: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --

1852: END IF;
1853: RETURN(l_return_status);
1854: END populate_new_record;
1855: --------------------------------------------------
1856: -- Set_Attributes for:OKL_LEASEAPP_DATAPOINTS_V --
1857: --------------------------------------------------
1858: FUNCTION Set_Attributes (
1859: p_ladv_rec IN ladv_rec_type,
1860: x_ladv_rec OUT NOCOPY ladv_rec_type

Line 2150: -- delete_row for:OKL_LEASEAPP_DATAPOINTS --

2146: ---------------------------------------------------------------------------
2147: -- PROCEDURE delete_row
2148: ---------------------------------------------------------------------------
2149: --------------------------------------------
2150: -- delete_row for:OKL_LEASEAPP_DATAPOINTS --
2151: --------------------------------------------
2152: PROCEDURE delete_row(
2153: p_init_msg_list IN VARCHAR2,
2154: x_return_status OUT NOCOPY VARCHAR2,

Line 2175: DELETE FROM OKL_LEASEAPP_DATAPOINTS

2171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2172: RAISE OKC_API.G_EXCEPTION_ERROR;
2173: END IF;
2174:
2175: DELETE FROM OKL_LEASEAPP_DATAPOINTS
2176: WHERE ID = p_lad_rec.id;
2177:
2178: x_return_status := l_return_status;
2179: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2213: -- delete_row for:OKL_LEASEAPP_DATAPOINTS_V --

2209: '_PVT'
2210: );
2211: END delete_row;
2212: ----------------------------------------------
2213: -- delete_row for:OKL_LEASEAPP_DATAPOINTS_V --
2214: ----------------------------------------------
2215: PROCEDURE delete_row(
2216: p_api_version IN NUMBER,
2217: p_init_msg_list IN VARCHAR2,

Line 2295: -- PL/SQL TBL delete_row for:OKL_LEASEAPP_DATAPOINTS_V --

2291: '_PVT'
2292: );
2293: END delete_row;
2294: ---------------------------------------------------------
2295: -- PL/SQL TBL delete_row for:OKL_LEASEAPP_DATAPOINTS_V --
2296: ---------------------------------------------------------
2297: PROCEDURE delete_row(
2298: p_api_version IN NUMBER,
2299: p_init_msg_list IN VARCHAR2,

Line 2391: -- PL/SQL TBL delete_row for:OKL_LEASEAPP_DATAPOINTS_V --

2387: );
2388: END delete_row;
2389:
2390: ---------------------------------------------------------
2391: -- PL/SQL TBL delete_row for:OKL_LEASEAPP_DATAPOINTS_V --
2392: ---------------------------------------------------------
2393: PROCEDURE delete_row(
2394: p_api_version IN NUMBER,
2395: p_init_msg_list IN VARCHAR2,