APPS.OKL_PROCESS_TMPT_SET_PVT dependencies on OKL_AE_TMPT_SETS

Line 58: FROM OKL_AE_TMPT_SETS_V

54:
55: CURSOR aes_csr(v_aes_id NUMBER) IS
56: SELECT start_date,
57: end_date
58: FROM OKL_AE_TMPT_SETS_V
59: WHERE id = v_aes_id;
60:
61: l_aes_start_date DATE;
62: l_aes_end_date DATE;

Line 1346: p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL)

1342: x_msg_count OUT NOCOPY NUMBER,
1343: x_msg_data OUT NOCOPY VARCHAR2,
1344: p_aesv_rec IN aesv_rec_type,
1345: x_aesv_rec OUT NOCOPY aesv_rec_type,
1346: p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL)
1347:
1348: IS
1349:
1350: l_api_version NUMBER := 1.0;

Line 1355: l_copy_to_id OKL_AE_TMPT_SETS.id%TYPE;

1351: l_api_name VARCHAR2(30) := 'CREATE_TMPT_SET';
1352: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1353: l_valid_flag VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1354: l_id NUMBER ;
1355: l_copy_to_id OKL_AE_TMPT_SETS.id%TYPE;
1356:
1357: CURSOR aes_csr (v_name VARCHAR2) IS
1358: SELECT ID
1359: FROM OKL_AE_TMPT_SETS_V

Line 1359: FROM OKL_AE_TMPT_SETS_V

1355: l_copy_to_id OKL_AE_TMPT_SETS.id%TYPE;
1356:
1357: CURSOR aes_csr (v_name VARCHAR2) IS
1358: SELECT ID
1359: FROM OKL_AE_TMPT_SETS_V
1360: WHERE name = v_name;
1361:
1362: BEGIN
1363: