DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_REPORTS_B

Line 3384: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE) RETURN BOOLEAN IS

3380: END lock_report_trx_parameters;
3381:
3382: FUNCTION validate_accounts(
3383: p_rap_tbl rap_tbl_type
3384: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE) RETURN BOOLEAN IS
3385:
3386: l_return_status boolean := true;
3387: l_test_value fnd_flex_values_vl.flex_value%TYPE;
3388: i NUMBER := 0;

Line 3391: p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE

3387: l_test_value fnd_flex_values_vl.flex_value%TYPE;
3388: i NUMBER := 0;
3389:
3390: CURSOR c_is_valid_nat_acc(
3391: p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
3392: ,p_segment_id OKL_REPORT_ACC_PARAMS.SEGMENT_RANGE_FROM%TYPE) IS
3393: SELECT flex.flex_value Account_Number
3394: FROM fnd_id_flex_segments s,
3395: fnd_segment_attribute_values sav,

Line 3801: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;

3797:
3798: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3799: l_api_name VARCHAR2(30) := 'CREATE_REPORT';
3800: i NUMBER := 0;
3801: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;
3802: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;
3803: l_report_id OKL_REPORTS_B.REPORT_ID%TYPE;
3804: l_func_ret_value boolean := true;
3805: la_func_ret_value boolean := true;

Line 3802: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;

3798: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3799: l_api_name VARCHAR2(30) := 'CREATE_REPORT';
3800: i NUMBER := 0;
3801: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;
3802: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;
3803: l_report_id OKL_REPORTS_B.REPORT_ID%TYPE;
3804: l_func_ret_value boolean := true;
3805: la_func_ret_value boolean := true;
3806: lt_func_ret_value boolean := true;

Line 3803: l_report_id OKL_REPORTS_B.REPORT_ID%TYPE;

3799: l_api_name VARCHAR2(30) := 'CREATE_REPORT';
3800: i NUMBER := 0;
3801: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;
3802: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;
3803: l_report_id OKL_REPORTS_B.REPORT_ID%TYPE;
3804: l_func_ret_value boolean := true;
3805: la_func_ret_value boolean := true;
3806: lt_func_ret_value boolean := true;
3807: ls_func_ret_value boolean := true;

Line 4045: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;

4041:
4042: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4043: l_api_name VARCHAR2(30) := 'UPDATE_REPORT';
4044: i NUMBER := 0;
4045: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;
4046: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;
4047: l_func_ret_value boolean := true;
4048: la_func_ret_value boolean := true;
4049: lt_func_ret_value boolean := true;

Line 4046: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;

4042: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
4043: l_api_name VARCHAR2(30) := 'UPDATE_REPORT';
4044: i NUMBER := 0;
4045: l_book_class_code OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE;
4046: l_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE;
4047: l_func_ret_value boolean := true;
4048: la_func_ret_value boolean := true;
4049: lt_func_ret_value boolean := true;
4050: ls_func_ret_value boolean := true;