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_PFC_PVT dependencies on OKL_PRTFL_CNTRCTS_B

Line 101: FROM OKL_PRTFL_CNTRCTS_B B

97: BEGIN
98: DELETE FROM OKL_PRTFL_CNTRCTS_TL T
99: WHERE NOT EXISTS (
100: SELECT NULL
101: FROM OKL_PRTFL_CNTRCTS_B B
102: WHERE B.ID =T.ID
103: );
104:
105: UPDATE OKL_PRTFL_CNTRCTS_TL T SET(

Line 278: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_B

274: BEGIN
275: RETURN(get_rec(p_pfcv_rec, l_row_not_found));
276: END get_rec;
277: ---------------------------------------------------------------------------
278: -- FUNCTION get_rec for: OKL_PRTFL_CNTRCTS_B
279: ---------------------------------------------------------------------------
280: FUNCTION get_rec (
281: p_pfc_rec IN pfc_rec_type,
282: x_no_data_found OUT NOCOPY BOOLEAN

Line 284: CURSOR okl_prtfl_cntrcts_b_pk_csr (p_id IN NUMBER) IS

280: FUNCTION get_rec (
281: p_pfc_rec IN pfc_rec_type,
282: x_no_data_found OUT NOCOPY BOOLEAN
283: ) RETURN pfc_rec_type IS
284: CURSOR okl_prtfl_cntrcts_b_pk_csr (p_id IN NUMBER) IS
285: SELECT
286: ID,
287: LINE_LEVEL_YN,
288: KHR_ID,

Line 315: FROM Okl_Prtfl_Cntrcts_B

311: CREATION_DATE,
312: LAST_UPDATED_BY,
313: LAST_UPDATE_DATE,
314: LAST_UPDATE_LOGIN
315: FROM Okl_Prtfl_Cntrcts_B
316: WHERE okl_prtfl_cntrcts_b.id = p_id;
317: l_okl_prtfl_cntrcts_b_pk okl_prtfl_cntrcts_b_pk_csr%ROWTYPE;
318: l_pfc_rec pfc_rec_type;
319: BEGIN

Line 316: WHERE okl_prtfl_cntrcts_b.id = p_id;

312: LAST_UPDATED_BY,
313: LAST_UPDATE_DATE,
314: LAST_UPDATE_LOGIN
315: FROM Okl_Prtfl_Cntrcts_B
316: WHERE okl_prtfl_cntrcts_b.id = p_id;
317: l_okl_prtfl_cntrcts_b_pk okl_prtfl_cntrcts_b_pk_csr%ROWTYPE;
318: l_pfc_rec pfc_rec_type;
319: BEGIN
320: x_no_data_found := TRUE;

Line 317: l_okl_prtfl_cntrcts_b_pk okl_prtfl_cntrcts_b_pk_csr%ROWTYPE;

313: LAST_UPDATE_DATE,
314: LAST_UPDATE_LOGIN
315: FROM Okl_Prtfl_Cntrcts_B
316: WHERE okl_prtfl_cntrcts_b.id = p_id;
317: l_okl_prtfl_cntrcts_b_pk okl_prtfl_cntrcts_b_pk_csr%ROWTYPE;
318: l_pfc_rec pfc_rec_type;
319: BEGIN
320: x_no_data_found := TRUE;
321: -- Get current database values

Line 322: OPEN okl_prtfl_cntrcts_b_pk_csr (p_pfc_rec.id);

318: l_pfc_rec pfc_rec_type;
319: BEGIN
320: x_no_data_found := TRUE;
321: -- Get current database values
322: OPEN okl_prtfl_cntrcts_b_pk_csr (p_pfc_rec.id);
323: FETCH okl_prtfl_cntrcts_b_pk_csr INTO
324: l_pfc_rec.id,
325: l_pfc_rec.line_level_yn,
326: l_pfc_rec.khr_id,

Line 323: FETCH okl_prtfl_cntrcts_b_pk_csr INTO

319: BEGIN
320: x_no_data_found := TRUE;
321: -- Get current database values
322: OPEN okl_prtfl_cntrcts_b_pk_csr (p_pfc_rec.id);
323: FETCH okl_prtfl_cntrcts_b_pk_csr INTO
324: l_pfc_rec.id,
325: l_pfc_rec.line_level_yn,
326: l_pfc_rec.khr_id,
327: l_pfc_rec.object_version_number,

Line 353: x_no_data_found := okl_prtfl_cntrcts_b_pk_csr%NOTFOUND;

349: l_pfc_rec.creation_date,
350: l_pfc_rec.last_updated_by,
351: l_pfc_rec.last_update_date,
352: l_pfc_rec.last_update_login;
353: x_no_data_found := okl_prtfl_cntrcts_b_pk_csr%NOTFOUND;
354: CLOSE okl_prtfl_cntrcts_b_pk_csr;
355: RETURN(l_pfc_rec);
356: END get_rec;
357:

Line 354: CLOSE okl_prtfl_cntrcts_b_pk_csr;

350: l_pfc_rec.last_updated_by,
351: l_pfc_rec.last_update_date,
352: l_pfc_rec.last_update_login;
353: x_no_data_found := okl_prtfl_cntrcts_b_pk_csr%NOTFOUND;
354: CLOSE okl_prtfl_cntrcts_b_pk_csr;
355: RETURN(l_pfc_rec);
356: END get_rec;
357:
358: ------------------------------------------------------------------

Line 1322: -- insert_row for:OKL_PRTFL_CNTRCTS_B --

1318: ---------------------------------------------------------------------------
1319: -- PROCEDURE insert_row
1320: ---------------------------------------------------------------------------
1321: ----------------------------------------
1322: -- insert_row for:OKL_PRTFL_CNTRCTS_B --
1323: ----------------------------------------
1324: PROCEDURE insert_row(
1325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1326: x_return_status OUT NOCOPY VARCHAR2,

Line 1338: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_B --

1334: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1335: l_pfc_rec pfc_rec_type := p_pfc_rec;
1336: l_def_pfc_rec pfc_rec_type;
1337: --------------------------------------------
1338: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_B --
1339: --------------------------------------------
1340: FUNCTION Set_Attributes (
1341: p_pfc_rec IN pfc_rec_type,
1342: x_pfc_rec OUT NOCOPY pfc_rec_type

Line 1369: INSERT INTO OKL_PRTFL_CNTRCTS_B(

1365: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1366: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1367: RAISE OKL_API.G_EXCEPTION_ERROR;
1368: END IF;
1369: INSERT INTO OKL_PRTFL_CNTRCTS_B(
1370: id,
1371: line_level_yn,
1372: khr_id,
1373: object_version_number,

Line 1911: -- lock_row for:OKL_PRTFL_CNTRCTS_B --

1907: ---------------------------------------------------------------------------
1908: -- PROCEDURE lock_row
1909: ---------------------------------------------------------------------------
1910: --------------------------------------
1911: -- lock_row for:OKL_PRTFL_CNTRCTS_B --
1912: --------------------------------------
1913: PROCEDURE lock_row(
1914: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1915: x_return_status OUT NOCOPY VARCHAR2,

Line 1924: FROM OKL_PRTFL_CNTRCTS_B

1920: E_Resource_Busy EXCEPTION;
1921: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1922: CURSOR lock_csr (p_pfc_rec IN pfc_rec_type) IS
1923: SELECT OBJECT_VERSION_NUMBER
1924: FROM OKL_PRTFL_CNTRCTS_B
1925: WHERE ID = p_pfc_rec.id
1926: AND OBJECT_VERSION_NUMBER = p_pfc_rec.object_version_number
1927: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1928:

Line 1931: FROM OKL_PRTFL_CNTRCTS_B

1927: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1928:
1929: CURSOR lchk_csr (p_pfc_rec IN pfc_rec_type) IS
1930: SELECT OBJECT_VERSION_NUMBER
1931: FROM OKL_PRTFL_CNTRCTS_B
1932: WHERE ID = p_pfc_rec.id;
1933: l_api_version CONSTANT NUMBER := 1;
1934: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1935: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1936: l_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;

1932: WHERE ID = p_pfc_rec.id;
1933: l_api_version CONSTANT NUMBER := 1;
1934: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1935: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1936: l_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;
1937: lc_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;
1938: l_row_notfound BOOLEAN := FALSE;
1939: lc_row_notfound BOOLEAN := FALSE;
1940: BEGIN

Line 1937: lc_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;

1933: l_api_version CONSTANT NUMBER := 1;
1934: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1935: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1936: l_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;
1937: lc_object_version_number OKL_PRTFL_CNTRCTS_B.OBJECT_VERSION_NUMBER%TYPE;
1938: l_row_notfound BOOLEAN := FALSE;
1939: lc_row_notfound BOOLEAN := FALSE;
1940: BEGIN
1941: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2358: -- update_row for:OKL_PRTFL_CNTRCTS_B --

2354: ---------------------------------------------------------------------------
2355: -- PROCEDURE update_row
2356: ---------------------------------------------------------------------------
2357: ----------------------------------------
2358: -- update_row for:OKL_PRTFL_CNTRCTS_B --
2359: ----------------------------------------
2360: PROCEDURE update_row(
2361: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2362: x_return_status OUT NOCOPY VARCHAR2,

Line 2509: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_B --

2505: END IF;
2506: RETURN(l_return_status);
2507: END populate_new_record;
2508: --------------------------------------------
2509: -- Set_Attributes for:OKL_PRTFL_CNTRCTS_B --
2510: --------------------------------------------
2511: FUNCTION Set_Attributes (
2512: p_pfc_rec IN pfc_rec_type,
2513: x_pfc_rec OUT NOCOPY pfc_rec_type

Line 2547: UPDATE OKL_PRTFL_CNTRCTS_B

2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: UPDATE OKL_PRTFL_CNTRCTS_B
2548: SET LINE_LEVEL_YN = l_def_pfc_rec.line_level_yn,
2549: KHR_ID = l_def_pfc_rec.khr_id,
2550: OBJECT_VERSION_NUMBER = l_def_pfc_rec.object_version_number,
2551: REQUEST_ID = l_def_pfc_rec.request_id,

Line 3278: -- delete_row for:OKL_PRTFL_CNTRCTS_B --

3274: ---------------------------------------------------------------------------
3275: -- PROCEDURE delete_row
3276: ---------------------------------------------------------------------------
3277: ----------------------------------------
3278: -- delete_row for:OKL_PRTFL_CNTRCTS_B --
3279: ----------------------------------------
3280: PROCEDURE delete_row(
3281: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
3282: x_return_status OUT NOCOPY VARCHAR2,

Line 3303: DELETE FROM OKL_PRTFL_CNTRCTS_B

3299: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3300: RAISE OKL_API.G_EXCEPTION_ERROR;
3301: END IF;
3302:
3303: DELETE FROM OKL_PRTFL_CNTRCTS_B
3304: WHERE ID = p_pfc_rec.id;
3305:
3306: x_return_status := l_return_status;
3307: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);