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_SAO_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 36: -- FUNCTION get_rec for: OKL_SYS_ACCT_OPTS

32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_SYS_ACCT_OPTS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_sao_rec IN sao_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_sys_acct_opts_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_sao_rec IN sao_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN sao_rec_type IS
42: CURSOR okl_sys_acct_opts_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: CC_REP_CURRENCY_CODE,
46: CODE_COMBINATION_ID,

Line 110: FROM Okl_Sys_Acct_Opts

106: ,PAY_DIST_SET_ID
107: ,SECONDARY_REP_METHOD --Bug#7225249
108: --Bug# 8370699
109: ,amort_inc_adj_rev_dt_yn
110: FROM Okl_Sys_Acct_Opts
111: WHERE okl_sys_acct_opts.id = p_id;
112: l_okl_sys_acct_opts_pk okl_sys_acct_opts_pk_csr%ROWTYPE;
113: l_sao_rec sao_rec_type;
114: BEGIN

Line 111: WHERE okl_sys_acct_opts.id = p_id;

107: ,SECONDARY_REP_METHOD --Bug#7225249
108: --Bug# 8370699
109: ,amort_inc_adj_rev_dt_yn
110: FROM Okl_Sys_Acct_Opts
111: WHERE okl_sys_acct_opts.id = p_id;
112: l_okl_sys_acct_opts_pk okl_sys_acct_opts_pk_csr%ROWTYPE;
113: l_sao_rec sao_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;

Line 112: l_okl_sys_acct_opts_pk okl_sys_acct_opts_pk_csr%ROWTYPE;

108: --Bug# 8370699
109: ,amort_inc_adj_rev_dt_yn
110: FROM Okl_Sys_Acct_Opts
111: WHERE okl_sys_acct_opts.id = p_id;
112: l_okl_sys_acct_opts_pk okl_sys_acct_opts_pk_csr%ROWTYPE;
113: l_sao_rec sao_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values

Line 117: OPEN okl_sys_acct_opts_pk_csr (p_sao_rec.id);

113: l_sao_rec sao_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values
117: OPEN okl_sys_acct_opts_pk_csr (p_sao_rec.id);
118: FETCH okl_sys_acct_opts_pk_csr INTO
119: l_sao_rec.ID,
120: l_sao_rec.CC_REP_currency_code,
121: l_sao_rec.CODE_COMBINATION_ID,

Line 118: FETCH okl_sys_acct_opts_pk_csr INTO

114: BEGIN
115: x_no_data_found := TRUE;
116: -- Get current database values
117: OPEN okl_sys_acct_opts_pk_csr (p_sao_rec.id);
118: FETCH okl_sys_acct_opts_pk_csr INTO
119: l_sao_rec.ID,
120: l_sao_rec.CC_REP_currency_code,
121: l_sao_rec.CODE_COMBINATION_ID,
122: l_sao_rec.AEL_REP_currency_code,

Line 186: x_no_data_found := okl_sys_acct_opts_pk_csr%NOTFOUND;

182: ,l_sao_rec.SECONDARY_REP_METHOD --Bug#7225249
183: --Bug# 8370699
184: ,l_sao_rec.AMORT_INC_ADJ_REV_DT_YN;
185:
186: x_no_data_found := okl_sys_acct_opts_pk_csr%NOTFOUND;
187: CLOSE okl_sys_acct_opts_pk_csr;
188: RETURN(l_sao_rec);
189: END get_rec;
190:

Line 187: CLOSE okl_sys_acct_opts_pk_csr;

183: --Bug# 8370699
184: ,l_sao_rec.AMORT_INC_ADJ_REV_DT_YN;
185:
186: x_no_data_found := okl_sys_acct_opts_pk_csr%NOTFOUND;
187: CLOSE okl_sys_acct_opts_pk_csr;
188: RETURN(l_sao_rec);
189: END get_rec;
190:
191: FUNCTION get_rec (

Line 199: -- FUNCTION get_rec for: OKL_SYS_ACCT_OPTS_V

195: BEGIN
196: RETURN(get_rec(p_sao_rec, l_row_notfound));
197: END get_rec;
198: ---------------------------------------------------------------------------
199: -- FUNCTION get_rec for: OKL_SYS_ACCT_OPTS_V
200: ---------------------------------------------------------------------------
201: FUNCTION get_rec (
202: p_saov_rec IN saov_rec_type,
203: x_no_data_found OUT NOCOPY BOOLEAN

Line 273: FROM OKL_SYS_ACCT_OPTS

269: ,PAY_DIST_SET_ID
270: ,SECONDARY_REP_METHOD --Bug#7225249
271: --Bug# 8370699
272: ,AMORT_INC_ADJ_REV_DT_YN
273: FROM OKL_SYS_ACCT_OPTS
274: WHERE OKL_SYS_ACCT_OPTS.id = p_id;
275: l_okl_saov_pk okl_saov_pk_csr%ROWTYPE;
276: l_saov_rec saov_rec_type;
277: BEGIN

Line 274: WHERE OKL_SYS_ACCT_OPTS.id = p_id;

270: ,SECONDARY_REP_METHOD --Bug#7225249
271: --Bug# 8370699
272: ,AMORT_INC_ADJ_REV_DT_YN
273: FROM OKL_SYS_ACCT_OPTS
274: WHERE OKL_SYS_ACCT_OPTS.id = p_id;
275: l_okl_saov_pk okl_saov_pk_csr%ROWTYPE;
276: l_saov_rec saov_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;

Line 363: -- FUNCTION null_out_defaults for: OKL_SYS_ACCT_OPTS_V --

359: RETURN(get_rec(p_saov_rec, l_row_notfound));
360: END get_rec;
361:
362: ---------------------------------------------------------
363: -- FUNCTION null_out_defaults for: OKL_SYS_ACCT_OPTS_V --
364: ---------------------------------------------------------
365: FUNCTION null_out_defaults (
366: p_saov_rec IN saov_rec_type
367: ) RETURN saov_rec_type IS

Line 568: -- Validate_Attributes for:OKL_SYS_ACCT_OPTS_V --

564: ---------------------------------------------------------------------------
565: -- PROCEDURE Validate_Attributes
566: ---------------------------------------------------------------------------
567: -------------------------------------------------
568: -- Validate_Attributes for:OKL_SYS_ACCT_OPTS_V --
569: -------------------------------------------------
570: FUNCTION Validate_Attributes (
571: p_saov_rec IN saov_rec_type
572: ) RETURN VARCHAR2 IS

Line 2243: -- Validate_Record for:OKL_SYS_ACCT_OPTS_V --

2239: ---------------------------------------------------------------------------
2240: -- PROCEDURE Validate_Record
2241: ---------------------------------------------------------------------------
2242: ---------------------------------------------
2243: -- Validate_Record for:OKL_SYS_ACCT_OPTS_V --
2244: ---------------------------------------------
2245: FUNCTION Validate_Record (
2246: p_saov_rec IN saov_rec_type
2247: ) RETURN VARCHAR2 IS

Line 2416: -- validate_row for:OKL_SYS_ACCT_OPTS_V --

2412: ---------------------------------------------------------------------------
2413: -- PROCEDURE validate_row
2414: ---------------------------------------------------------------------------
2415: ------------------------------------------
2416: -- validate_row for:OKL_SYS_ACCT_OPTS_V --
2417: ------------------------------------------
2418: PROCEDURE validate_row(
2419: p_api_version IN NUMBER,
2420: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2576: -- insert_row for:OKL_SYS_ACCT_OPTS --

2572: ---------------------------------------------------------------------------
2573: -- PROCEDURE insert_row
2574: ---------------------------------------------------------------------------
2575: --------------------------------------
2576: -- insert_row for:OKL_SYS_ACCT_OPTS --
2577: --------------------------------------
2578: PROCEDURE insert_row(
2579: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2580: x_return_status OUT NOCOPY VARCHAR2,

Line 2592: -- Set_Attributes for:OKL_SYS_ACCT_OPTS --

2588: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2589: l_sao_rec sao_rec_type := p_sao_rec;
2590: l_def_sao_rec sao_rec_type;
2591: ------------------------------------------
2592: -- Set_Attributes for:OKL_SYS_ACCT_OPTS --
2593: ------------------------------------------
2594: FUNCTION Set_Attributes (
2595: p_sao_rec IN sao_rec_type,
2596: x_sao_rec OUT NOCOPY sao_rec_type

Line 2623: INSERT INTO OKL_SYS_ACCT_OPTS(

2619: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2620: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2621: RAISE Okc_Api.G_EXCEPTION_ERROR;
2622: END IF;
2623: INSERT INTO OKL_SYS_ACCT_OPTS(
2624: id,
2625: cc_rep_currency_code,
2626: code_combination_id,
2627: ael_rep_currency_code,

Line 2794: -- insert_row for:OKL_SYS_ACCT_OPTS_V --

2790: '_PVT'
2791: );
2792: END insert_row;
2793: ----------------------------------------
2794: -- insert_row for:OKL_SYS_ACCT_OPTS_V --
2795: ----------------------------------------
2796: PROCEDURE insert_row(
2797: p_api_version IN NUMBER,
2798: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 2828: -- Set_Attributes for:OKL_SYS_ACCT_OPTS_V --

2824: l_saov_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2825: RETURN(l_saov_rec);
2826: END fill_who_columns;
2827: --------------------------------------------
2828: -- Set_Attributes for:OKL_SYS_ACCT_OPTS_V --
2829: --------------------------------------------
2830: FUNCTION Set_Attributes (
2831: p_saov_rec IN saov_rec_type,
2832: x_saov_rec OUT NOCOPY saov_rec_type

Line 3030: -- lock_row for:OKL_SYS_ACCT_OPTS --

3026: ---------------------------------------------------------------------------
3027: -- PROCEDURE lock_row
3028: ---------------------------------------------------------------------------
3029: ------------------------------------
3030: -- lock_row for:OKL_SYS_ACCT_OPTS --
3031: ------------------------------------
3032: PROCEDURE lock_row(
3033: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3034: x_return_status OUT NOCOPY VARCHAR2,

Line 3043: FROM OKL_SYS_ACCT_OPTS

3039: E_Resource_Busy EXCEPTION;
3040: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3041: CURSOR lock_csr (p_sao_rec IN sao_rec_type) IS
3042: SELECT OBJECT_VERSION_NUMBER
3043: FROM OKL_SYS_ACCT_OPTS
3044: WHERE ID = p_sao_rec.id
3045: AND OBJECT_VERSION_NUMBER = p_sao_rec.object_version_number
3046: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3047:

Line 3050: FROM OKL_SYS_ACCT_OPTS

3046: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3047:
3048: CURSOR lchk_csr (p_sao_rec IN sao_rec_type) IS
3049: SELECT OBJECT_VERSION_NUMBER
3050: FROM OKL_SYS_ACCT_OPTS
3051: WHERE ID = p_sao_rec.id;
3052: l_api_version CONSTANT NUMBER := 1;
3053: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
3054: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3055: l_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;

3051: WHERE ID = p_sao_rec.id;
3052: l_api_version CONSTANT NUMBER := 1;
3053: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
3054: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3055: l_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
3056: lc_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
3057: l_row_notfound BOOLEAN := FALSE;
3058: lc_row_notfound BOOLEAN := FALSE;
3059: BEGIN

Line 3056: lc_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;

3052: l_api_version CONSTANT NUMBER := 1;
3053: l_api_name CONSTANT VARCHAR2(30) := 'OPTS_lock_row';
3054: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3055: l_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
3056: lc_object_version_number OKL_SYS_ACCT_OPTS.OBJECT_VERSION_NUMBER%TYPE;
3057: l_row_notfound BOOLEAN := FALSE;
3058: lc_row_notfound BOOLEAN := FALSE;
3059: BEGIN
3060: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3136: -- lock_row for:OKL_SYS_ACCT_OPTS_V --

3132: '_PVT'
3133: );
3134: END lock_row;
3135: --------------------------------------
3136: -- lock_row for:OKL_SYS_ACCT_OPTS_V --
3137: --------------------------------------
3138: PROCEDURE lock_row(
3139: p_api_version IN NUMBER,
3140: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 3300: -- update_row for:OKL_SYS_ACCT_OPTS --

3296: ---------------------------------------------------------------------------
3297: -- PROCEDURE update_row
3298: ---------------------------------------------------------------------------
3299: --------------------------------------
3300: -- update_row for:OKL_SYS_ACCT_OPTS --
3301: --------------------------------------
3302: PROCEDURE update_row(
3303: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3304: x_return_status OUT NOCOPY VARCHAR2,

Line 3589: -- Set_Attributes for:OKL_SYS_ACCT_OPTS --

3585:
3586: RETURN(l_return_status);
3587: END populate_new_record;
3588: ------------------------------------------
3589: -- Set_Attributes for:OKL_SYS_ACCT_OPTS --
3590: ------------------------------------------
3591: FUNCTION Set_Attributes (
3592: p_sao_rec IN sao_rec_type,
3593: x_sao_rec OUT NOCOPY sao_rec_type

Line 3626: UPDATE OKL_SYS_ACCT_OPTS

3622: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3623: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3624: RAISE Okc_Api.G_EXCEPTION_ERROR;
3625: END IF;
3626: UPDATE OKL_SYS_ACCT_OPTS
3627: SET CC_REP_CURRENCY_CODE = l_def_sao_rec.cc_rep_currency_code,
3628: CODE_COMBINATION_ID = l_def_sao_rec.code_combination_id,
3629: AEL_REP_CURRENCY_CODE = l_def_sao_rec.ael_rep_currency_code,
3630: SET_OF_BOOKS_ID = l_def_sao_rec.set_of_books_id,

Line 3731: -- update_row for:OKL_SYS_ACCT_OPTS_V --

3727: '_PVT'
3728: );
3729: END update_row;
3730: ----------------------------------------
3731: -- update_row for:OKL_SYS_ACCT_OPTS_V --
3732: ----------------------------------------
3733: PROCEDURE update_row(
3734: p_api_version IN NUMBER,
3735: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

Line 4034: -- Set_Attributes for:OKL_SYS_ACCT_OPTS_V --

4030:
4031: RETURN(l_return_status);
4032: END populate_new_record;
4033: --------------------------------------------
4034: -- Set_Attributes for:OKL_SYS_ACCT_OPTS_V --
4035: --------------------------------------------
4036: FUNCTION Set_Attributes (
4037: p_saov_rec IN saov_rec_type,
4038: x_saov_rec OUT NOCOPY saov_rec_type

Line 4232: -- delete_row for:OKL_SYS_ACCT_OPTS --

4228: ---------------------------------------------------------------------------
4229: -- PROCEDURE delete_row
4230: ---------------------------------------------------------------------------
4231: --------------------------------------
4232: -- delete_row for:OKL_SYS_ACCT_OPTS --
4233: --------------------------------------
4234: PROCEDURE delete_row(
4235: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
4236: x_return_status OUT NOCOPY VARCHAR2,

Line 4256: DELETE FROM OKL_SYS_ACCT_OPTS

4252: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4253: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
4254: RAISE Okc_Api.G_EXCEPTION_ERROR;
4255: END IF;
4256: DELETE FROM OKL_SYS_ACCT_OPTS
4257: WHERE ID = l_sao_rec.id;
4258:
4259: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
4260: EXCEPTION

Line 4293: -- delete_row for:OKL_SYS_ACCT_OPTS_V --

4289: '_PVT'
4290: );
4291: END delete_row;
4292: ----------------------------------------
4293: -- delete_row for:OKL_SYS_ACCT_OPTS_V --
4294: ----------------------------------------
4295: PROCEDURE delete_row(
4296: p_api_version IN NUMBER,
4297: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,