DBA Data[Home] [Help]

APPS.OKL_FMA_PVT dependencies on OKL_API

Line 832: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;

828: ) IS
829:
830: l_dummy VARCHAR2(1) := '?';
831: -- l_row_not_found Boolean := False;
832: l_row_found VARCHAR2(1) := OKL_API.G_TRUE;
833:
834: -- Cursor For OKL_FMA_FYP_FK - Foreign Key Constraint
835: /*
836: CURSOR okl_fndv_pk_csr (p_code IN OKL_FORMULAE_V.fyp_code%TYPE) IS

Line 865: IF (l_row_found = OKL_API.G_FALSE) then

861: */
862:
863: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FORMULA_TYPE', p_fmav_rec.fyp_code);
864:
865: IF (l_row_found = OKL_API.G_FALSE) then
866: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fyp_code');
867: x_return_status := OKC_API.G_RET_STS_ERROR;
868: END IF;
869:

Line 1138: p_fmav_rec.end_date <> OKL_API.G_MISS_DATE AND

1134: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1135:
1136: -- check for data before processing
1137: IF p_fmav_rec.end_date IS NOT NULL AND
1138: p_fmav_rec.end_date <> OKL_API.G_MISS_DATE AND
1139: p_fmav_rec.end_date < p_fmav_rec.start_date THEN
1140: OKC_API.SET_MESSAGE(p_app_name => 'OKL'
1141: ,p_msg_name => g_to_date_error );
1142: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 4221: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

4217: p_last_update_date IN VARCHAR2)IS
4218:
4219: l_api_version CONSTANT number := 1;
4220: l_api_name CONSTANT varchar2(30) := 'LOAD_SEED_ROW';
4221: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
4222: l_msg_count number;
4223: l_msg_data varchar2(4000);
4224: l_init_msg_list VARCHAR2(1):= 'T';
4225: l_fmav_rec fmav_rec_type;