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_LPO_PVT dependencies on OKL_LATE_POLICIES_V

Line 46: FROM OKL_LATE_POLICIES_V

42:
43: -- Cursor to get khr_id if a contract exists (create mode)
44: CURSOR okl_name_csr ( p_lpov_rec IN lpov_rec_type) IS
45: SELECT name
46: FROM OKL_LATE_POLICIES_V
47: WHERE name = p_lpov_rec.name
48: AND id <> p_lpov_rec.id;
49:
50:

Line 51: l_name OKL_LATE_POLICIES_V.NAME%TYPE;

47: WHERE name = p_lpov_rec.name
48: AND id <> p_lpov_rec.id;
49:
50:
51: l_name OKL_LATE_POLICIES_V.NAME%TYPE;
52: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
53: BEGIN
54:
55: -- Check if value passed for id

Line 166: -- FUNCTION get_rec for: OKL_LATE_POLICIES_V

162: );
163: END add_language;
164:
165: ---------------------------------------------------------------------------
166: -- FUNCTION get_rec for: OKL_LATE_POLICIES_V
167: ---------------------------------------------------------------------------
168: FUNCTION get_rec (
169: p_lpov_rec IN lpov_rec_type,
170: x_no_data_found OUT NOCOPY BOOLEAN

Line 172: CURSOR okl_late_policies_v_pk_csr (p_id IN NUMBER) IS

168: FUNCTION get_rec (
169: p_lpov_rec IN lpov_rec_type,
170: x_no_data_found OUT NOCOPY BOOLEAN
171: ) RETURN lpov_rec_type IS
172: CURSOR okl_late_policies_v_pk_csr (p_id IN NUMBER) IS
173: SELECT
174: ID,
175: ORG_ID,
176: NAME,

Line 221: FROM Okl_Late_Policies_V

217: LAST_UPDATED_BY,
218: LAST_UPDATE_DATE,
219: LAST_UPDATE_LOGIN,
220: DAYS_IN_YEAR
221: FROM Okl_Late_Policies_V
222: WHERE okl_late_policies_v.id = p_id;
223: l_okl_late_policies_v_pk okl_late_policies_v_pk_csr%ROWTYPE;
224: l_lpov_rec lpov_rec_type;
225: BEGIN

Line 222: WHERE okl_late_policies_v.id = p_id;

218: LAST_UPDATE_DATE,
219: LAST_UPDATE_LOGIN,
220: DAYS_IN_YEAR
221: FROM Okl_Late_Policies_V
222: WHERE okl_late_policies_v.id = p_id;
223: l_okl_late_policies_v_pk okl_late_policies_v_pk_csr%ROWTYPE;
224: l_lpov_rec lpov_rec_type;
225: BEGIN
226: x_no_data_found := TRUE;

Line 223: l_okl_late_policies_v_pk okl_late_policies_v_pk_csr%ROWTYPE;

219: LAST_UPDATE_LOGIN,
220: DAYS_IN_YEAR
221: FROM Okl_Late_Policies_V
222: WHERE okl_late_policies_v.id = p_id;
223: l_okl_late_policies_v_pk okl_late_policies_v_pk_csr%ROWTYPE;
224: l_lpov_rec lpov_rec_type;
225: BEGIN
226: x_no_data_found := TRUE;
227: -- Get current database values

Line 228: OPEN okl_late_policies_v_pk_csr (p_lpov_rec.id);

224: l_lpov_rec lpov_rec_type;
225: BEGIN
226: x_no_data_found := TRUE;
227: -- Get current database values
228: OPEN okl_late_policies_v_pk_csr (p_lpov_rec.id);
229: FETCH okl_late_policies_v_pk_csr INTO
230: l_lpov_rec.id,
231: l_lpov_rec.org_id,
232: l_lpov_rec.name,

Line 229: FETCH okl_late_policies_v_pk_csr INTO

225: BEGIN
226: x_no_data_found := TRUE;
227: -- Get current database values
228: OPEN okl_late_policies_v_pk_csr (p_lpov_rec.id);
229: FETCH okl_late_policies_v_pk_csr INTO
230: l_lpov_rec.id,
231: l_lpov_rec.org_id,
232: l_lpov_rec.name,
233: l_lpov_rec.description,

Line 277: x_no_data_found := okl_late_policies_v_pk_csr%NOTFOUND;

273: l_lpov_rec.last_updated_by,
274: l_lpov_rec.last_update_date,
275: l_lpov_rec.last_update_login,
276: l_lpov_rec.DAYS_IN_YEAR;
277: x_no_data_found := okl_late_policies_v_pk_csr%NOTFOUND;
278: CLOSE okl_late_policies_v_pk_csr;
279: RETURN(l_lpov_rec);
280: END get_rec;
281:

Line 278: CLOSE okl_late_policies_v_pk_csr;

274: l_lpov_rec.last_update_date,
275: l_lpov_rec.last_update_login,
276: l_lpov_rec.DAYS_IN_YEAR;
277: x_no_data_found := okl_late_policies_v_pk_csr%NOTFOUND;
278: CLOSE okl_late_policies_v_pk_csr;
279: RETURN(l_lpov_rec);
280: END get_rec;
281:
282: ------------------------------------------------------------------

Line 523: -- FUNCTION null_out_defaults for: OKL_LATE_POLICIES_V

519: BEGIN
520: RETURN(get_rec(p_okl_late_policies_tl_rec, l_row_not_found));
521: END get_rec;
522: ---------------------------------------------------------------------------
523: -- FUNCTION null_out_defaults for: OKL_LATE_POLICIES_V
524: ---------------------------------------------------------------------------
525: FUNCTION null_out_defaults (
526: p_lpov_rec IN lpov_rec_type
527: ) RETURN lpov_rec_type IS

Line 677: -- Validate_Attributes for:OKL_LATE_POLICIES_V --

673: ---------------------------------------------------------------------------
674: -- FUNCTION Validate_Attributes
675: ---------------------------------------------------------------------------
676: -------------------------------------------------
677: -- Validate_Attributes for:OKL_LATE_POLICIES_V --
678: -------------------------------------------------
679: FUNCTION Validate_Attributes (
680: p_lpov_rec IN lpov_rec_type
681: ) RETURN VARCHAR2 IS

Line 686: Okc_Util.ADD_VIEW('OKL_LATE_POLICIES_V', x_return_status);

682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
683: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
684: BEGIN
685: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
686: Okc_Util.ADD_VIEW('OKL_LATE_POLICIES_V', x_return_status);
687: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
688: l_return_status := x_return_status;
689: RAISE G_EXCEPTION_HALT_VALIDATION;
690: END IF;

Line 764: -- Validate Record for:OKL_LATE_POLICIES_V --

760: ---------------------------------------------------------------------------
761: -- PROCEDURE Validate_Record
762: ---------------------------------------------------------------------------
763: ---------------------------------------------
764: -- Validate Record for:OKL_LATE_POLICIES_V --
765: ---------------------------------------------
766: FUNCTION Validate_Record (p_lpov_rec IN lpov_rec_type)
767: RETURN VARCHAR2 IS
768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 933: -- validate_row for:OKL_LATE_POLICIES_V --

929: ---------------------------------------------------------------------------
930: -- PROCEDURE validate_row
931: ---------------------------------------------------------------------------
932: ------------------------------------------
933: -- validate_row for:OKL_LATE_POLICIES_V --
934: ------------------------------------------
935: PROCEDURE validate_row(
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1010: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --

1006: '_PVT'
1007: );
1008: END validate_row;
1009: -----------------------------------------------------
1010: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --
1011: -----------------------------------------------------
1012:
1013: -----------------------------------------------------
1014: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --

Line 1014: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --

1010: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --
1011: -----------------------------------------------------
1012:
1013: -----------------------------------------------------
1014: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --
1015: -----------------------------------------------------
1016: PROCEDURE validate_row(
1017: p_api_version IN NUMBER,
1018: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1373: -- insert_row for :OKL_LATE_POLICIES_V --

1369: '_PVT'
1370: );
1371: END insert_row;
1372: -----------------------------------------
1373: -- insert_row for :OKL_LATE_POLICIES_V --
1374: -----------------------------------------
1375: PROCEDURE insert_row(
1376: p_api_version IN NUMBER,
1377: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 1409: -- Set_Attributes for:OKL_LATE_POLICIES_V --

1405: l_lpov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1406: RETURN(l_lpov_rec);
1407: END fill_who_columns;
1408: --------------------------------------------
1409: -- Set_Attributes for:OKL_LATE_POLICIES_V --
1410: --------------------------------------------
1411: FUNCTION Set_Attributes (
1412: p_lpov_rec IN lpov_rec_type,
1413: x_lpov_rec OUT NOCOPY lpov_rec_type

Line 1799: -- lock_row for: OKL_LATE_POLICIES_V --

1795: '_PVT'
1796: );
1797: END lock_row;
1798: ---------------------------------------
1799: -- lock_row for: OKL_LATE_POLICIES_V --
1800: ---------------------------------------
1801: PROCEDURE lock_row(
1802: p_api_version IN NUMBER,
1803: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2465: -- update_row for:OKL_LATE_POLICIES_V --

2461: '_PVT'
2462: );
2463: END update_row;
2464: ----------------------------------------
2465: -- update_row for:OKL_LATE_POLICIES_V --
2466: ----------------------------------------
2467: PROCEDURE update_row(
2468: p_api_version IN NUMBER,
2469: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2707: -- Set_Attributes for:OKL_LATE_POLICIES_V --

2703: END IF;
2704: RETURN(l_return_status);
2705: END populate_new_record;
2706: --------------------------------------------
2707: -- Set_Attributes for:OKL_LATE_POLICIES_V --
2708: --------------------------------------------
2709: FUNCTION Set_Attributes (
2710: p_lpov_rec IN lpov_rec_type,
2711: x_lpov_rec OUT NOCOPY lpov_rec_type

Line 3033: -- delete_row for:OKL_LATE_POLICIES_V --

3029: '_PVT'
3030: );
3031: END delete_row;
3032: ----------------------------------------
3033: -- delete_row for:OKL_LATE_POLICIES_V --
3034: ----------------------------------------
3035: PROCEDURE delete_row(
3036: p_api_version IN NUMBER,
3037: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 3129: -- PL/SQL TBL delete_row for:OKL_LATE_POLICIES_V --

3125: '_PVT'
3126: );
3127: END delete_row;
3128: ---------------------------------------------------
3129: -- PL/SQL TBL delete_row for:OKL_LATE_POLICIES_V --
3130: ---------------------------------------------------
3131: PROCEDURE delete_row(
3132: p_api_version IN NUMBER,
3133: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,