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_SETUPFUNCTIONS_PVT dependencies on OKL_DATA_SRC_FNCTNS_V

Line 19: CURSOR okl_dsf_laterversionsexist_csr (p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,

15: ---------------------------------------------------------------------------
16: PROCEDURE get_version(p_dsfv_rec IN dsfv_rec_type,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_new_version OUT NOCOPY VARCHAR2) IS
19: CURSOR okl_dsf_laterversionsexist_csr (p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
20: p_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
21: ) IS
22: SELECT '1'
23: FROM Okl_Data_Src_Fnctns_V

Line 20: p_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE

16: PROCEDURE get_version(p_dsfv_rec IN dsfv_rec_type,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_new_version OUT NOCOPY VARCHAR2) IS
19: CURSOR okl_dsf_laterversionsexist_csr (p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
20: p_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
21: ) IS
22: SELECT '1'
23: FROM Okl_Data_Src_Fnctns_V
24: WHERE name = p_name

Line 23: FROM Okl_Data_Src_Fnctns_V

19: CURSOR okl_dsf_laterversionsexist_csr (p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
20: p_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
21: ) IS
22: SELECT '1'
23: FROM Okl_Data_Src_Fnctns_V
24: WHERE name = p_name
25: AND NVL(end_date,OKL_API.G_MISS_DATE) > p_date;
26:
27: l_check VARCHAR2(1) := '?';

Line 70: -- PROCEDURE get_rec for: OKL_DATA_SRC_FNCTNS_V

66:
67: */
68:
69: ---------------------------------------------------------------------------
70: -- PROCEDURE get_rec for: OKL_DATA_SRC_FNCTNS_V
71: -- Fix this once the view data structure is fixed
72: ---------------------------------------------------------------------------
73: PROCEDURE get_rec (
74: p_dsfv_rec IN dsfv_rec_type,

Line 113: FROM Okl_Data_Src_Fnctns_V

109: CREATION_DATE,
110: LAST_UPDATED_BY,
111: LAST_UPDATE_DATE,
112: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
113: FROM Okl_Data_Src_Fnctns_V
114: WHERE okl_Data_Src_Fnctns_v.id = p_id;
115: l_okl_dsfv_pk okl_dsfv_pk_csr%ROWTYPE;
116: l_dsfv_rec dsfv_rec_type;
117: BEGIN

Line 114: WHERE okl_Data_Src_Fnctns_v.id = p_id;

110: LAST_UPDATED_BY,
111: LAST_UPDATE_DATE,
112: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
113: FROM Okl_Data_Src_Fnctns_V
114: WHERE okl_Data_Src_Fnctns_v.id = p_id;
115: l_okl_dsfv_pk okl_dsfv_pk_csr%ROWTYPE;
116: l_dsfv_rec dsfv_rec_type;
117: BEGIN
118: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 180: -- PROCEDURE check_overlaps for: OKL_DATA_SRC_FNCTNS_V

176:
177: -- Not required as new version will not be creatd while updating the function
178: /*
179: ---------------------------------------------------------------------------
180: -- PROCEDURE check_overlaps for: OKL_DATA_SRC_FNCTNS_V
181: -- To avoid overlapping of dates with other versions of the same function
182: ---------------------------------------------------------------------------
183: PROCEDURE check_overlaps (
184: p_dsfv_rec IN dsfv_rec_type,

Line 188: CURSOR okl_dsf_overlaps_csr (p_id IN Okl_Data_Src_Fnctns_V.ID%TYPE,

184: p_dsfv_rec IN dsfv_rec_type,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_valid OUT NOCOPY BOOLEAN
187: ) IS
188: CURSOR okl_dsf_overlaps_csr (p_id IN Okl_Data_Src_Fnctns_V.ID%TYPE,
189: p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,
191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
192: ) IS

Line 189: p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,

185: x_return_status OUT NOCOPY VARCHAR2,
186: x_valid OUT NOCOPY BOOLEAN
187: ) IS
188: CURSOR okl_dsf_overlaps_csr (p_id IN Okl_Data_Src_Fnctns_V.ID%TYPE,
189: p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,
191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
192: ) IS
193: SELECT '1'

Line 190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,

186: x_valid OUT NOCOPY BOOLEAN
187: ) IS
188: CURSOR okl_dsf_overlaps_csr (p_id IN Okl_Data_Src_Fnctns_V.ID%TYPE,
189: p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,
191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
192: ) IS
193: SELECT '1'
194: FROM Okl_Data_Src_Fnctns_V

Line 191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE

187: ) IS
188: CURSOR okl_dsf_overlaps_csr (p_id IN Okl_Data_Src_Fnctns_V.ID%TYPE,
189: p_name IN Okl_Data_Src_Fnctns_V.NAME%TYPE,
190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,
191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
192: ) IS
193: SELECT '1'
194: FROM Okl_Data_Src_Fnctns_V
195: WHERE NAME = p_name

Line 194: FROM Okl_Data_Src_Fnctns_V

190: p_start_date IN Okl_Data_Src_Fnctns_V.START_DATE%TYPE,
191: p_end_date IN Okl_Data_Src_Fnctns_V.END_DATE%TYPE
192: ) IS
193: SELECT '1'
194: FROM Okl_Data_Src_Fnctns_V
195: WHERE NAME = p_name
196: AND ID <> p_id
197: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
198: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))

Line 201: FROM Okl_Data_Src_Fnctns_V

197: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
198: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
199: UNION ALL
200: SELECT '2'
201: FROM Okl_Data_Src_Fnctns_V
202: WHERE NAME = p_name
203: AND ID <> p_id
204: AND p_start_date <= START_DATE
205: AND p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);

Line 464: -- PROCEDURE check_dsf_opd_dates for: OKL_DATA_SRC_FNCTNS_V

460: RETURN l_dsfv_rec;
461: END defaults_to_actuals;
462:
463: ---------------------------------------------------------------------------
464: -- PROCEDURE check_dsf_opd_dates for: OKL_DATA_SRC_FNCTNS_V
465: -- To fetch the operands that are attached to the existing version of the
466: -- function and verify the dates for the both
467: ---------------------------------------------------------------------------
468: PROCEDURE check_dsf_opd_dates (p_upd_dsfv_rec IN dsfv_rec_type,

Line 500: p_token1_value => 'Okl_Data_Src_Fnctns_V',

496: IF NOT l_not_found THEN
497: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
498: p_msg_name => G_DATES_MISMATCH,
499: p_token1 => G_PARENT_TABLE_TOKEN,
500: p_token1_value => 'Okl_Data_Src_Fnctns_V',
501: p_token2 => G_CHILD_TABLE_TOKEN,
502: p_token2_value => 'Okl_Operands_V');
503: RAISE G_EXCEPTION_HALT_PROCESSING;
504: END IF;

Line 570: p_view => 'Okl_Data_Src_Fnctns_V',

566: p_start_date_attribute_name => 'START_DATE',
567: p_start_date => l_dsfv_rec.start_date,
568: p_end_date_attribute_name => 'END_DATE',
569: p_end_date => l_dsfv_rec.end_date,
570: p_view => 'Okl_Data_Src_Fnctns_V',
571: x_return_status => l_return_status,
572: x_valid => l_valid);
573:
574:

Line 623: -- PROCEDURE determine_action for: OKL_DATA_SRC_FNCTNS_V

619: -- Not required as new version will not be creatd while updating the function
620: /*
621:
622: ---------------------------------------------------------------------------
623: -- PROCEDURE determine_action for: OKL_DATA_SRC_FNCTNS_V
624: -- This function helps in determining the various checks to be performed
625: -- for the new/updated record and also helps in determining whether a new
626: -- version is required or not
627: ---------------------------------------------------------------------------

Line 668: -- PROCEDURE insert_operands for: OKL_DATA_SRC_FNCTNS_V

664: END determine_action;
665: */
666:
667: ---------------------------------------------------------------------------
668: -- PROCEDURE insert_operands for: OKL_DATA_SRC_FNCTNS_V
669: ---------------------------------------------------------------------------
670: PROCEDURE insert_functions(p_api_version IN NUMBER,
671: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
672: x_return_status OUT NOCOPY VARCHAR2,

Line 775: -- PROCEDURE update_functions for: OKL_DATA_SRC_FNCTNS_V

771:
772: END insert_functions;
773:
774: ---------------------------------------------------------------------------
775: -- PROCEDURE update_functions for: OKL_DATA_SRC_FNCTNS_V
776: ---------------------------------------------------------------------------
777: PROCEDURE update_functions(p_api_version IN NUMBER,
778: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
779: x_return_status OUT NOCOPY VARCHAR2,

Line 1028: p_view => 'Okl_Data_Src_Fnctns_V',

1024: okl_accounting_util.get_version(p_attrib_tbl => l_attrib_tbl,
1025: p_cur_version => l_dsfv_rec.version,
1026: p_end_date_attribute_name => 'END_DATE',
1027: p_end_date => l_dsfv_rec.end_date,
1028: p_view => 'Okl_Data_Src_Fnctns_V',
1029: x_return_status => l_return_status,
1030: x_new_version => l_new_version);
1031:
1032: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN