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_STY_PVT dependencies on OKL_STRM_TYPE_V

Line 301: -- FUNCTION get_rec for: OKL_STRM_TYPE_V

297: BEGIN
298: RETURN(get_rec(p_okl_strm_type_tl_rec, l_row_notfound));
299: END get_rec;
300: ---------------------------------------------------------------------------
301: -- FUNCTION get_rec for: OKL_STRM_TYPE_V
302: ---------------------------------------------------------------------------
303: FUNCTION get_rec (
304: p_styv_rec IN styv_rec_type,
305: x_no_data_found OUT NOCOPY BOOLEAN

Line 363: FROM OKL_STRM_TYPE_V

359:
360: -- Added by SNANDIKO for Bug 6744584 Start
361: CONTINGENCY_ID
362: -- Added by SNANDIKO for Bug 6744584 End
363: FROM OKL_STRM_TYPE_V
364: WHERE OKL_STRM_TYPE_V.id = p_id;
365: l_okl_styv_pk okl_styv_pk_csr%ROWTYPE;
366: l_styv_rec styv_rec_type;
367: BEGIN

Line 364: WHERE OKL_STRM_TYPE_V.id = p_id;

360: -- Added by SNANDIKO for Bug 6744584 Start
361: CONTINGENCY_ID
362: -- Added by SNANDIKO for Bug 6744584 End
363: FROM OKL_STRM_TYPE_V
364: WHERE OKL_STRM_TYPE_V.id = p_id;
365: l_okl_styv_pk okl_styv_pk_csr%ROWTYPE;
366: l_styv_rec styv_rec_type;
367: BEGIN
368: x_no_data_found := TRUE;

Line 441: -- FUNCTION null_out_defaults for: OKL_STRM_TYPE_V --

437: RETURN(get_rec(p_styv_rec, l_row_notfound));
438: END get_rec;
439:
440: -----------------------------------------------------
441: -- FUNCTION null_out_defaults for: OKL_STRM_TYPE_V --
442: -----------------------------------------------------
443: FUNCTION null_out_defaults (
444: p_styv_rec IN styv_rec_type
445: ) RETURN styv_rec_type IS

Line 1499: CURSOR prev_strm_type_csr( p_sty_id OKL_STRM_TYPE_V.ID%TYPE) IS

1495: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1496:
1497: -- prasjain - Bug#5762913 - Commented - Start
1498: /*
1499: CURSOR prev_strm_type_csr( p_sty_id OKL_STRM_TYPE_V.ID%TYPE) IS
1500: SELECT ACCRUAL_YN
1501: FROM OKL_STRM_TYPE_V
1502: WHERE ID = p_sty_id;
1503: */

Line 1501: FROM OKL_STRM_TYPE_V

1497: -- prasjain - Bug#5762913 - Commented - Start
1498: /*
1499: CURSOR prev_strm_type_csr( p_sty_id OKL_STRM_TYPE_V.ID%TYPE) IS
1500: SELECT ACCRUAL_YN
1501: FROM OKL_STRM_TYPE_V
1502: WHERE ID = p_sty_id;
1503: */
1504: -- prasjain - Bug#5762913 - Commented - End
1505:

Line 2046: FROM OKL_STRM_TYPE_V

2042:
2043: -- Cursor for sty Unique Key
2044: CURSOR okl_sty_uk_csr(p_rec styv_rec_type) IS
2045: SELECT '1'
2046: FROM OKL_STRM_TYPE_V
2047: WHERE code = p_rec.code
2048: AND version = p_rec.version
2049: AND stream_type_purpose = p_rec.stream_type_purpose
2050: AND id <> NVL(p_rec.id,-9999);

Line 2294: -- validate_row for:OKL_STRM_TYPE_V --

2290: ---------------------------------------------------------------------------
2291: -- PROCEDURE validate_row
2292: ---------------------------------------------------------------------------
2293: --------------------------------------
2294: -- validate_row for:OKL_STRM_TYPE_V --
2295: --------------------------------------
2296: PROCEDURE validate_row(
2297: p_api_version IN NUMBER,
2298: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2764: -- insert_row for:OKL_STRM_TYPE_V --

2760: '_PVT'
2761: );
2762: END insert_row;
2763: ------------------------------------
2764: -- insert_row for:OKL_STRM_TYPE_V --
2765: ------------------------------------
2766: PROCEDURE insert_row(
2767: p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2800: -- Set_Attributes for:OKL_STRM_TYPE_V --

2796: l_styv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2797: RETURN(l_styv_rec);
2798: END fill_who_columns;
2799: ----------------------------------------
2800: -- Set_Attributes for:OKL_STRM_TYPE_V --
2801: ----------------------------------------
2802: FUNCTION Set_Attributes (
2803: p_styv_rec IN styv_rec_type,
2804: x_styv_rec OUT NOCOPY styv_rec_type

Line 3201: -- lock_row for:OKL_STRM_TYPE_V --

3197: '_PVT'
3198: );
3199: END lock_row;
3200: ----------------------------------
3201: -- lock_row for:OKL_STRM_TYPE_V --
3202: ----------------------------------
3203: PROCEDURE lock_row(
3204: p_api_version IN NUMBER,
3205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3889: -- update_row for:OKL_STRM_TYPE_V --

3885: '_PVT'
3886: );
3887: END update_row;
3888: ------------------------------------
3889: -- update_row for:OKL_STRM_TYPE_V --
3890: ------------------------------------
3891: PROCEDURE update_row(
3892: p_api_version IN NUMBER,
3893: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4130: -- Set_Attributes for:OKL_STRM_TYPE_V --

4126: -- Added by SNANDIKO for Bug 6744584 End
4127: RETURN(l_return_status);
4128: END populate_new_record;
4129: ----------------------------------------
4130: -- Set_Attributes for:OKL_STRM_TYPE_V --
4131: ----------------------------------------
4132: FUNCTION Set_Attributes (
4133: p_styv_rec IN styv_rec_type,
4134: x_styv_rec OUT NOCOPY styv_rec_type

Line 4486: -- delete_row for:OKL_STRM_TYPE_V --

4482: '_PVT'
4483: );
4484: END delete_row;
4485: ------------------------------------
4486: -- delete_row for:OKL_STRM_TYPE_V --
4487: ------------------------------------
4488: PROCEDURE delete_row(
4489: p_api_version IN NUMBER,
4490: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,