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_SYP_PVT dependencies on OKL_SYSTEM_PARAMS

Line 94: -- FUNCTION get_rec for: OKL_SYSTEM_PARAMS_ALL_V

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

Line 186: FROM OKL_SYSTEM_PARAMS

182: LSEOPP_SEQ_PREFIX_TXT,
183: QCKQTE_SEQ_PREFIX_TXT,
184: LSEQTE_SEQ_PREFIX_TXT
185: --Bug 7022258--Addition end
186: FROM OKL_SYSTEM_PARAMS
187: WHERE OKL_SYSTEM_PARAMS.id = p_id;
188: l_okl_sys_params_v_pk okl_sys_params_v_pk_csr%ROWTYPE;
189: l_sypv_rec sypv_rec_type;
190: BEGIN

Line 187: WHERE OKL_SYSTEM_PARAMS.id = p_id;

183: QCKQTE_SEQ_PREFIX_TXT,
184: LSEQTE_SEQ_PREFIX_TXT
185: --Bug 7022258--Addition end
186: FROM OKL_SYSTEM_PARAMS
187: WHERE OKL_SYSTEM_PARAMS.id = p_id;
188: l_okl_sys_params_v_pk okl_sys_params_v_pk_csr%ROWTYPE;
189: l_sypv_rec sypv_rec_type;
190: BEGIN
191: x_no_data_found := TRUE;

Line 315: -- FUNCTION get_rec for: OKL_SYSTEM_PARAMS_ALL

311: BEGIN
312: RETURN(get_rec(p_sypv_rec, l_row_not_found));
313: END get_rec;
314: ---------------------------------------------------------------------------
315: -- FUNCTION get_rec for: OKL_SYSTEM_PARAMS_ALL
316: ---------------------------------------------------------------------------
317: FUNCTION get_rec (
318: p_syp_rec IN syp_rec_type,
319: x_no_data_found OUT NOCOPY BOOLEAN

Line 410: FROM OKL_SYSTEM_PARAMS_ALL

406: LSEOPP_SEQ_PREFIX_TXT,
407: QCKQTE_SEQ_PREFIX_TXT,
408: LSEQTE_SEQ_PREFIX_TXT
409: --Bug 7022258--Addition end
410: FROM OKL_SYSTEM_PARAMS_ALL
411: WHERE OKL_SYSTEM_PARAMS_ALL.id = p_id;
412: l_okl_sys_params_pk okl_sys_params_pk_csr%ROWTYPE;
413: l_syp_rec syp_rec_type;
414: BEGIN

Line 411: WHERE OKL_SYSTEM_PARAMS_ALL.id = p_id;

407: QCKQTE_SEQ_PREFIX_TXT,
408: LSEQTE_SEQ_PREFIX_TXT
409: --Bug 7022258--Addition end
410: FROM OKL_SYSTEM_PARAMS_ALL
411: WHERE OKL_SYSTEM_PARAMS_ALL.id = p_id;
412: l_okl_sys_params_pk okl_sys_params_pk_csr%ROWTYPE;
413: l_syp_rec syp_rec_type;
414: BEGIN
415: x_no_data_found := TRUE;

Line 540: -- FUNCTION null_out_defaults for: OKL_SYSTEM_PARAMS_ALL_V

536: BEGIN
537: RETURN(get_rec(p_syp_rec, l_row_not_found));
538: END get_rec;
539: ---------------------------------------------------------------------------
540: -- FUNCTION null_out_defaults for: OKL_SYSTEM_PARAMS_ALL_V
541: ---------------------------------------------------------------------------
542: FUNCTION null_out_defaults (
543: p_sypv_rec IN sypv_rec_type
544: ) RETURN sypv_rec_type IS

Line 936: 'OKL_SYSTEM_PARAMS_V',

932: g_no_parent_record,
933: g_col_name_token,
934: 'tax_upfront_sty_id',
935: g_child_table_token ,
936: 'OKL_SYSTEM_PARAMS_V',
937: g_parent_table_token ,
938: 'okl_strm_type_b');
939: x_return_status := OKC_API.G_RET_STS_ERROR;
940: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1374: AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)

1370: SELECT 'X'
1371: FROM MTL_ITEM_CATEGORIES MTLITMCATS,
1372: MTL_CATEGORY_SETS MTLCATSETS
1373: WHERE MTLITMCATS.CATEGORY_SET_ID = MTLCATSETS.CATEGORY_SET_ID
1374: AND MTLITMCATS.ORGANIZATION_ID = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
1375: AND MTLCATSETS.MULT_ITEM_CAT_ASSIGN_FLAG = 'N'
1376: AND MTLITMCATS.CATEGORY_SET_ID = cp_cat_set_id;
1377:
1378: l_dummy VARCHAR2(1);

Line 1924: FROM OKL_SYSTEM_PARAMS SYP;

1920: p_syp_rec IN syp_rec_type) IS
1921: -- Get DB values for org_id (query on _V means query for org_id)
1922: CURSOR get_db_values_csr IS
1923: SELECT SYP.id
1924: FROM OKL_SYSTEM_PARAMS SYP;
1925: l_id NUMBER;
1926: BEGIN
1927: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1928: OPEN get_db_values_csr;

Line 1952: -- Validate_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --

1948: ---------------------------------------------------------------------------
1949: -- FUNCTION Validate_Attributes
1950: ---------------------------------------------------------------------------
1951: ---------------------------------------------------------
1952: -- Validate_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --
1953: -- RMUNJULU Added call to Validate_Delink_yn
1954: -- SECHAWLA 28-MAR-05 4274575 Added call to Validate_TAX_UPFRONT_YN, Validate_TAX_INVOICE_YN, Validate_TAX_SCHEDULE_YN
1955: ---------------------------------------------------------
1956: FUNCTION Validate_Attributes (

Line 2243: -- Validate Record for:OKL_SYSTEM_PARAMS_ALL_V --

2239: ---------------------------------------------------------------------------
2240: -- PROCEDURE Validate_Record
2241: ---------------------------------------------------------------------------
2242: -----------------------------------------------------
2243: -- Validate Record for:OKL_SYSTEM_PARAMS_ALL_V --
2244: -----------------------------------------------------
2245: FUNCTION Validate_Record (
2246: p_sypv_rec IN sypv_rec_type,
2247: p_db_OklSystemParam1 IN sypv_rec_type

Line 2548: -- validate_row for:OKL_SYSTEM_PARAMS_ALL_V --

2544: ---------------------------------------------------------------------------
2545: -- PROCEDURE validate_row
2546: ---------------------------------------------------------------------------
2547: --------------------------------------------------
2548: -- validate_row for:OKL_SYSTEM_PARAMS_ALL_V --
2549: --------------------------------------------------
2550: PROCEDURE validate_row(
2551: p_api_version IN NUMBER,
2552: p_init_msg_list IN VARCHAR2,

Line 2625: -- PL/SQL TBL validate_row for:OKL_SYSTEM_PARAMS_ALL_V --

2621: '_PVT'
2622: );
2623: END validate_row;
2624: -------------------------------------------------------------
2625: -- PL/SQL TBL validate_row for:OKL_SYSTEM_PARAMS_ALL_V --
2626: -------------------------------------------------------------
2627: PROCEDURE validate_row(
2628: p_api_version IN NUMBER,
2629: p_init_msg_list IN VARCHAR2,

Line 2721: -- PL/SQL TBL validate_row for:OKL_SYSTEM_PARAMS_ALL_V --

2717: );
2718: END validate_row;
2719:
2720: -------------------------------------------------------------
2721: -- PL/SQL TBL validate_row for:OKL_SYSTEM_PARAMS_ALL_V --
2722: -------------------------------------------------------------
2723: PROCEDURE validate_row(
2724: p_api_version IN NUMBER,
2725: p_init_msg_list IN VARCHAR2,

Line 2786: -- insert_row for:OKL_SYSTEM_PARAMS_ALL --

2782: ---------------------------------------------------------------------------
2783: -- PROCEDURE insert_row
2784: ---------------------------------------------------------------------------
2785: ----------------------------------------------
2786: -- insert_row for:OKL_SYSTEM_PARAMS_ALL --
2787: ----------------------------------------------
2788: PROCEDURE insert_row(
2789: p_init_msg_list IN VARCHAR2,
2790: x_return_status OUT NOCOPY VARCHAR2,

Line 2802: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL --

2798: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2799: l_syp_rec syp_rec_type := p_syp_rec;
2800: l_def_syp_rec syp_rec_type;
2801: --------------------------------------------------
2802: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL --
2803: --------------------------------------------------
2804: FUNCTION Set_Attributes (
2805: p_syp_rec IN syp_rec_type,
2806: x_syp_rec OUT NOCOPY syp_rec_type

Line 2840: INSERT INTO OKL_SYSTEM_PARAMS_ALL(

2836: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2837: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2838: RAISE OKL_API.G_EXCEPTION_ERROR;
2839: END IF;
2840: INSERT INTO OKL_SYSTEM_PARAMS_ALL(
2841: id,
2842: delink_yn,
2843: -- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
2844: REMK_SUBINVENTORY ,

Line 3055: -- insert_row for :OKL_SYSTEM_PARAMS_ALL_V --

3051: '_PVT'
3052: );
3053: END insert_row;
3054: -------------------------------------------------
3055: -- insert_row for :OKL_SYSTEM_PARAMS_ALL_V --
3056: -- RMUNJULU Added code to default delink_yn
3057: -- RMUNJULU Added code to default org_id
3058: -- SECHAWLA 28-MAR-05 4274575 : added code to default tax_upfront_yn, tax_INVOICE_yn, tax_schedule_yn
3059: -------------------------------------------------

Line 3092: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --

3088: l_sypv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3089: RETURN(l_sypv_rec);
3090: END fill_who_columns;
3091: ----------------------------------------------------
3092: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --
3093: ----------------------------------------------------
3094: FUNCTION Set_Attributes (
3095: p_sypv_rec IN sypv_rec_type,
3096: x_sypv_rec OUT NOCOPY sypv_rec_type

Line 3492: -- lock_row for:OKL_SYSTEM_PARAMS_ALL --

3488: ---------------------------------------------------------------------------
3489: -- PROCEDURE lock_row
3490: ---------------------------------------------------------------------------
3491: --------------------------------------------
3492: -- lock_row for:OKL_SYSTEM_PARAMS_ALL --
3493: --------------------------------------------
3494: PROCEDURE lock_row(
3495: p_init_msg_list IN VARCHAR2,
3496: x_return_status OUT NOCOPY VARCHAR2,

Line 3505: FROM OKL_SYSTEM_PARAMS_ALL

3501: E_Resource_Busy EXCEPTION;
3502: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
3503: CURSOR lock_csr (p_syp_rec IN syp_rec_type) IS
3504: SELECT OBJECT_VERSION_NUMBER
3505: FROM OKL_SYSTEM_PARAMS_ALL
3506: WHERE ID = p_syp_rec.id
3507: AND OBJECT_VERSION_NUMBER = p_syp_rec.object_version_number
3508: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3509:

Line 3512: FROM OKL_SYSTEM_PARAMS_ALL

3508: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3509:
3510: CURSOR lchk_csr (p_syp_rec IN syp_rec_type) IS
3511: SELECT OBJECT_VERSION_NUMBER
3512: FROM OKL_SYSTEM_PARAMS_ALL
3513: WHERE ID = p_syp_rec.id;
3514: l_api_version CONSTANT NUMBER := 1;
3515: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3516: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3517: l_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;

3513: WHERE ID = p_syp_rec.id;
3514: l_api_version CONSTANT NUMBER := 1;
3515: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3516: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3517: l_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;
3518: lc_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;
3519: l_row_notfound BOOLEAN := FALSE;
3520: lc_row_notfound BOOLEAN := FALSE;
3521: BEGIN

Line 3518: lc_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;

3514: l_api_version CONSTANT NUMBER := 1;
3515: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
3516: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3517: l_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;
3518: lc_object_version_number OKL_SYSTEM_PARAMS_ALL.OBJECT_VERSION_NUMBER%TYPE;
3519: l_row_notfound BOOLEAN := FALSE;
3520: lc_row_notfound BOOLEAN := FALSE;
3521: BEGIN
3522: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 3599: -- lock_row for: OKL_SYSTEM_PARAMS_ALL_V --

3595: '_PVT'
3596: );
3597: END lock_row;
3598: -----------------------------------------------
3599: -- lock_row for: OKL_SYSTEM_PARAMS_ALL_V --
3600: -----------------------------------------------
3601: PROCEDURE lock_row(
3602: p_api_version IN NUMBER,
3603: p_init_msg_list IN VARCHAR2,

Line 3839: -- update_row for:OKL_SYSTEM_PARAMS_ALL --

3835: ---------------------------------------------------------------------------
3836: -- PROCEDURE update_row
3837: ---------------------------------------------------------------------------
3838: ----------------------------------------------
3839: -- update_row for:OKL_SYSTEM_PARAMS_ALL --
3840: ----------------------------------------------
3841: PROCEDURE update_row(
3842: p_init_msg_list IN VARCHAR2,
3843: x_return_status OUT NOCOPY VARCHAR2,

Line 4166: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL --

4162: END IF;
4163: RETURN(l_return_status);
4164: END populate_new_record;
4165: --------------------------------------------------
4166: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL --
4167: --------------------------------------------------
4168: FUNCTION Set_Attributes (
4169: p_syp_rec IN syp_rec_type,
4170: x_syp_rec OUT NOCOPY syp_rec_type

Line 4204: UPDATE OKL_SYSTEM_PARAMS_ALL

4200: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4201: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4202: RAISE OKL_API.G_EXCEPTION_ERROR;
4203: END IF;
4204: UPDATE OKL_SYSTEM_PARAMS_ALL
4205: SET DELINK_YN = l_def_syp_rec.delink_yn,
4206: -- SECHAWLA 28-SEP-04 3924244: Added new columns - begin
4207: REMK_SUBINVENTORY = l_def_syp_rec.REMK_SUBINVENTORY ,
4208: REMK_ORGANIZATION_ID = l_def_syp_rec.REMK_ORGANIZATION_ID,

Line 4333: -- update_row for:OKL_SYSTEM_PARAMS_ALL_V --

4329: '_PVT'
4330: );
4331: END update_row;
4332: ------------------------------------------------
4333: -- update_row for:OKL_SYSTEM_PARAMS_ALL_V --
4334: -- RMUNJULU Changed to add code to set object _version_number and pass lx_sypv_rec to lock row
4335: ------------------------------------------------
4336: PROCEDURE update_row(
4337: p_api_version IN NUMBER,

Line 4680: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --

4676: END IF;
4677: RETURN(l_return_status);
4678: END populate_new_record;
4679: ----------------------------------------------------
4680: -- Set_Attributes for:OKL_SYSTEM_PARAMS_ALL_V --
4681: ----------------------------------------------------
4682: FUNCTION Set_Attributes (
4683: p_sypv_rec IN sypv_rec_type,
4684: x_sypv_rec OUT NOCOPY sypv_rec_type

Line 4701: -- Developers adding new columns to okl_system_params_all, should also

4697: -- exception, in case if this update_row gets called from a place
4698: -- ( say Setup > System Options > Item Category Set), before the setup of
4699: -- above mentioned attributes is done.
4700:
4701: -- Developers adding new columns to okl_system_params_all, should also
4702: -- default their new columns here with appropriate values, if the validate
4703: -- procedures for these new columns require the column values be not null.
4704:
4705: -- Default delink_yn

Line 5050: -- delete_row for:OKL_SYSTEM_PARAMS_ALL --

5046: ---------------------------------------------------------------------------
5047: -- PROCEDURE delete_row
5048: ---------------------------------------------------------------------------
5049: ----------------------------------------------
5050: -- delete_row for:OKL_SYSTEM_PARAMS_ALL --
5051: ----------------------------------------------
5052: PROCEDURE delete_row(
5053: p_init_msg_list IN VARCHAR2,
5054: x_return_status OUT NOCOPY VARCHAR2,

Line 5075: DELETE FROM OKL_SYSTEM_PARAMS_ALL

5071: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
5072: RAISE OKL_API.G_EXCEPTION_ERROR;
5073: END IF;
5074:
5075: DELETE FROM OKL_SYSTEM_PARAMS_ALL
5076: WHERE ID = p_syp_rec.id;
5077:
5078: x_return_status := l_return_status;
5079: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 5113: -- delete_row for:OKL_SYSTEM_PARAMS_ALL_V --

5109: '_PVT'
5110: );
5111: END delete_row;
5112: ------------------------------------------------
5113: -- delete_row for:OKL_SYSTEM_PARAMS_ALL_V --
5114: ------------------------------------------------
5115: PROCEDURE delete_row(
5116: p_api_version IN NUMBER,
5117: p_init_msg_list IN VARCHAR2,

Line 5195: -- PL/SQL TBL delete_row for:OKL_SYSTEM_PARAMS_ALL_V --

5191: '_PVT'
5192: );
5193: END delete_row;
5194: -----------------------------------------------------------
5195: -- PL/SQL TBL delete_row for:OKL_SYSTEM_PARAMS_ALL_V --
5196: -----------------------------------------------------------
5197: PROCEDURE delete_row(
5198: p_api_version IN NUMBER,
5199: p_init_msg_list IN VARCHAR2,

Line 5291: -- PL/SQL TBL delete_row for:OKL_SYSTEM_PARAMS_ALL_V --

5287: );
5288: END delete_row;
5289:
5290: -----------------------------------------------------------
5291: -- PL/SQL TBL delete_row for:OKL_SYSTEM_PARAMS_ALL_V --
5292: -----------------------------------------------------------
5293: PROCEDURE delete_row(
5294: p_api_version IN NUMBER,
5295: p_init_msg_list IN VARCHAR2,