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_SETUPFORMULAE_PVT dependencies on OKL_FORMULAE_V

Line 20: CURSOR okl_fma_laterversionsexist_csr (p_name IN Okl_Formulae_V.NAME%TYPE,

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

Line 21: p_date IN Okl_Formulae_V.END_DATE%TYPE) IS

17: PROCEDURE get_version(p_fmav_rec IN fmav_rec_type,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_new_version OUT NOCOPY VARCHAR2) IS
20: CURSOR okl_fma_laterversionsexist_csr (p_name IN Okl_Formulae_V.NAME%TYPE,
21: p_date IN Okl_Formulae_V.END_DATE%TYPE) IS
22: SELECT '1'
23: FROM Okl_Formulae_V
24: WHERE name = p_name
25: AND NVL(end_date,p_date) > p_date;

Line 23: FROM Okl_Formulae_V

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

Line 70: -- PROCEDURE get_rec for: OKL_FORMULAE_V

66:
67: */
68:
69: ---------------------------------------------------------------------------
70: -- PROCEDURE get_rec for: OKL_FORMULAE_V
71: ---------------------------------------------------------------------------
72: PROCEDURE get_rec (
73: p_fmav_rec IN fmav_rec_type,
74: x_return_status OUT NOCOPY VARCHAR2,

Line 114: FROM Okl_Formulae_V

110: CREATION_DATE,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
114: FROM Okl_Formulae_V
115: WHERE okl_formulae_v.id = p_id;
116: l_okl_fmav_pk okl_fmav_pk_csr%ROWTYPE;
117: l_fmav_rec fmav_rec_type;
118: BEGIN

Line 115: WHERE okl_formulae_v.id = p_id;

111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
114: FROM Okl_Formulae_V
115: WHERE okl_formulae_v.id = p_id;
116: l_okl_fmav_pk okl_fmav_pk_csr%ROWTYPE;
117: l_fmav_rec fmav_rec_type;
118: BEGIN
119: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 185: -- PROCEDURE check_overlaps for: OKL_FORMULAE_V

181: -- while updating
182:
183: /*
184: ---------------------------------------------------------------------------
185: -- PROCEDURE check_overlaps for: OKL_FORMULAE_V
186: -- To avoid overlapping of dates with other versions of the same formula
187: ---------------------------------------------------------------------------
188: PROCEDURE check_overlaps (
189: p_fmav_rec IN fmav_rec_type,

Line 193: CURSOR okl_fma_overlaps_csr (p_id IN Okl_Formulae_V.ID%TYPE,

189: p_fmav_rec IN fmav_rec_type,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_valid OUT NOCOPY BOOLEAN
192: ) IS
193: CURSOR okl_fma_overlaps_csr (p_id IN Okl_Formulae_V.ID%TYPE,
194: p_name IN Okl_Formulae_V.NAME%TYPE,
195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,
196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE
197: ) IS

Line 194: p_name IN Okl_Formulae_V.NAME%TYPE,

190: x_return_status OUT NOCOPY VARCHAR2,
191: x_valid OUT NOCOPY BOOLEAN
192: ) IS
193: CURSOR okl_fma_overlaps_csr (p_id IN Okl_Formulae_V.ID%TYPE,
194: p_name IN Okl_Formulae_V.NAME%TYPE,
195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,
196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE
197: ) IS
198: SELECT '1'

Line 195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,

191: x_valid OUT NOCOPY BOOLEAN
192: ) IS
193: CURSOR okl_fma_overlaps_csr (p_id IN Okl_Formulae_V.ID%TYPE,
194: p_name IN Okl_Formulae_V.NAME%TYPE,
195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,
196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE
197: ) IS
198: SELECT '1'
199: FROM Okl_Formulae_V

Line 196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE

192: ) IS
193: CURSOR okl_fma_overlaps_csr (p_id IN Okl_Formulae_V.ID%TYPE,
194: p_name IN Okl_Formulae_V.NAME%TYPE,
195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,
196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE
197: ) IS
198: SELECT '1'
199: FROM Okl_Formulae_V
200: WHERE NAME = p_name

Line 199: FROM Okl_Formulae_V

195: p_start_date IN Okl_Formulae_V.START_DATE%TYPE,
196: p_end_date IN Okl_Formulae_V.END_DATE%TYPE
197: ) IS
198: SELECT '1'
199: FROM Okl_Formulae_V
200: WHERE NAME = p_name
201: AND ID <> p_id
202: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
203: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))

Line 206: FROM Okl_Formulae_V

202: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
203: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
204: UNION ALL
205: SELECT '2'
206: FROM Okl_Formulae_V
207: WHERE NAME = p_name
208: AND ID <> p_id
209: AND p_start_date <= START_DATE
210: AND p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);

Line 256: -- PROCEDURE check_constraints for: OKL_FORMULAE_V

252: */
253:
254: /*
255: ---------------------------------------------------------------------------
256: -- PROCEDURE check_constraints for: OKL_FORMULAE_V
257: -- To verify whether the dates are valid for both formula and operands
258: -- attached to it
259: ---------------------------------------------------------------------------
260: PROCEDURE check_constraints (

Line 306: p_token1_value => 'Okl_Formulae_V',

302: IF NOT l_row_not_found then
303: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
304: p_msg_name => G_DATES_MISMATCH,
305: p_token1 => G_PARENT_TABLE_TOKEN,
306: p_token1_value => 'Okl_Formulae_V',
307: p_token2 => G_CHILD_TABLE_TOKEN,
308: p_token2_value => 'Okl_Operands_V');
309: x_valid := FALSE;
310: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 344: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Formulae_V.id%TYPE) IS

340: PROCEDURE check_constraints (p_upd_fmav_rec IN fmav_rec_type,
341: p_fmav_rec IN fmav_rec_type,
342: x_return_status OUT NOCOPY VARCHAR2
343: ) IS
344: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Formulae_V.id%TYPE) IS
345: SELECT opd.ID ID,
346: opd.START_DATE START_DATE,
347: opd.END_DATE
348: FROM Okl_Operands_B opd

Line 382: p_token1_value => 'Okl_Formulae_V',

378: p_upd_fmav_rec.end_date < NVL(l_max_end_date, to_date(to_char('31/12/9999','DD/MM/YYYY'), 'DD/MM/YYYY'))) THEN
379: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
380: p_msg_name => G_DATES_MISMATCH,
381: p_token1 => G_PARENT_TABLE_TOKEN,
382: p_token1_value => 'Okl_Formulae_V',
383: p_token2 => G_CHILD_TABLE_TOKEN,
384: p_token2_value => 'Okl_Operands_V');
385: RAISE G_EXCEPTION_HALT_PROCESSING;
386: END IF;

Line 418: -- PROCEDURE check_fma_opd_dates for: OKL_FORMULAE_V

414:
415: */
416:
417: ---------------------------------------------------------------------------
418: -- PROCEDURE check_fma_opd_dates for: OKL_FORMULAE_V
419: -- To fetch the operands that are attached to the existing version of the
420: -- function and verify the dates for the both
421: ---------------------------------------------------------------------------
422: PROCEDURE check_fma_opd_dates (p_upd_fmav_rec IN fmav_rec_type,

Line 750: p_view => 'Okl_Formulae_V',

746: p_start_date_attribute_name => 'START_DATE',
747: p_start_date => l_fmav_rec.start_date,
748: p_end_date_attribute_name => 'END_DATE',
749: p_end_date => l_fmav_rec.end_date,
750: p_view => 'Okl_Formulae_V',
751: x_return_status => l_return_status,
752: x_valid => l_valid);
753:
754: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 806: -- PROCEDURE determine_action for: OKL_FORMULAE_V

802: -- determine_action is not required as new version will not be created while updating
803: /*
804:
805: ---------------------------------------------------------------------------
806: -- PROCEDURE determine_action for: OKL_FORMULAE_V
807: -- This function helps in determining the various checks to be performed
808: -- for the new/updated record and also helps in determining whether a new
809: -- version is required or not
810: ---------------------------------------------------------------------------

Line 855: -- PROCEDURE get_fma_operands for: OKL_FORMULAE_V

851: */
852: -- get_fma_operands is not required as new version will not be created while updating
853: /*
854: ---------------------------------------------------------------------------
855: -- PROCEDURE get_fma_operands for: OKL_FORMULAE_V
856: -- To fetch the operands that are attached to the existing version of the
857: -- formula
858: ---------------------------------------------------------------------------
859: PROCEDURE get_fma_operands (p_upd_fmav_rec IN fmav_rec_type,

Line 911: -- PROCEDURE insert_formulae for: OKL_FORMULAE_V

907:
908: */
909:
910: ---------------------------------------------------------------------------
911: -- PROCEDURE insert_formulae for: OKL_FORMULAE_V
912: ---------------------------------------------------------------------------
913: PROCEDURE insert_formulae(p_api_version IN NUMBER,
914: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
915: x_return_status OUT NOCOPY VARCHAR2,

Line 1019: -- PROCEDURE update_formulae for: OKL_FORMULAE_V

1015:
1016: END insert_formulae;
1017:
1018: ---------------------------------------------------------------------------
1019: -- PROCEDURE update_formulae for: OKL_FORMULAE_V
1020: ---------------------------------------------------------------------------
1021: PROCEDURE update_formulae(p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1023: x_return_status OUT NOCOPY VARCHAR2,

Line 1294: p_view => 'Okl_Formulae_V',

1290: okl_accounting_util.get_version(p_attrib_tbl => l_attrib_tbl,
1291: p_cur_version => l_fmav_rec.version,
1292: p_end_date_attribute_name => 'END_DATE',
1293: p_end_date => l_fmav_rec.end_date,
1294: p_view => 'Okl_Formulae_V',
1295: x_return_status => l_return_status,
1296: x_new_version => l_new_version);
1297:
1298: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN