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_SETUPOPERANDS_PVT dependencies on OKL_OPERANDS_V

Line 19: CURSOR okl_opd_laterversionsexist_csr (p_name IN Okl_Operands_V.NAME%TYPE,

15: ---------------------------------------------------------------------------
16: PROCEDURE get_version(p_opdv_rec IN opdv_rec_type,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_new_version OUT NOCOPY VARCHAR2) IS
19: CURSOR okl_opd_laterversionsexist_csr (p_name IN Okl_Operands_V.NAME%TYPE,
20: p_date IN Okl_Operands_V.END_DATE%TYPE) IS
21: SELECT '1'
22: FROM Okl_Operands_V
23: WHERE name = p_name

Line 20: p_date IN Okl_Operands_V.END_DATE%TYPE) IS

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

Line 22: FROM Okl_Operands_V

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

Line 69: -- PROCEDURE get_rec for: OKL_OPERANDS_V

65:
66: */
67:
68: ---------------------------------------------------------------------------
69: -- PROCEDURE get_rec for: OKL_OPERANDS_V
70: ---------------------------------------------------------------------------
71: PROCEDURE get_rec (
72: p_opdv_rec IN opdv_rec_type,
73: x_return_status OUT NOCOPY VARCHAR2,

Line 96: FROM Okl_Operands_V

92: CREATION_DATE,
93: LAST_UPDATED_BY,
94: LAST_UPDATE_DATE,
95: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
96: FROM Okl_Operands_V
97: WHERE okl_operands_v.id = p_id;
98: l_okl_opdv_pk okl_opdv_pk_csr%ROWTYPE;
99: l_opdv_rec opdv_rec_type;
100: BEGIN

Line 97: WHERE okl_operands_v.id = p_id;

93: LAST_UPDATED_BY,
94: LAST_UPDATE_DATE,
95: NVL(LAST_UPDATE_LOGIN, OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
96: FROM Okl_Operands_V
97: WHERE okl_operands_v.id = p_id;
98: l_okl_opdv_pk okl_opdv_pk_csr%ROWTYPE;
99: l_opdv_rec opdv_rec_type;
100: BEGIN
101: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 155: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,

151: p_opdv_rec IN opdv_rec_type,
152: x_return_status OUT NOCOPY VARCHAR2
153: ) IS
154:
155: CURSOR okl_fma_linkedopds_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
156: p_start_date DATE, p_end_date DATE) IS
157: SELECT '1'
158: FROM Okl_Formulae_B fma
159: WHERE fma.ID = p_fma_id

Line 222: CURSOR okl_dsf_linkedopds_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,

218: p_opdv_rec IN opdv_rec_type,
219: x_return_status OUT NOCOPY VARCHAR2
220: ) IS
221:
222: CURSOR okl_dsf_linkedopds_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,
223: p_start_date DATE, p_end_date DATE) IS
224: SELECT '1'
225: FROM OKL_DATA_SRC_FNCTNS_B dsf
226: WHERE dsf.ID = p_dsf_id

Line 284: -- PROCEDURE check_overlaps for: OKL_OPERANDS_V

280: -- Not required as new version will not be created while updating the operand
281: /*
282:
283: ---------------------------------------------------------------------------
284: -- PROCEDURE check_overlaps for: OKL_OPERANDS_V
285: -- To avoid overlapping of dates with other versions of the same operand
286: ---------------------------------------------------------------------------
287: PROCEDURE check_overlaps (
288: p_opdv_rec IN opdv_rec_type,

Line 292: CURSOR okl_opd_overlaps_csr (p_id IN Okl_Operands_V.ID%TYPE,

288: p_opdv_rec IN opdv_rec_type,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_valid OUT NOCOPY BOOLEAN
291: ) IS
292: CURSOR okl_opd_overlaps_csr (p_id IN Okl_Operands_V.ID%TYPE,
293: p_name IN Okl_Operands_V.NAME%TYPE,
294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
295: p_end_date IN Okl_Operands_V.END_DATE%TYPE
296: ) IS

Line 293: p_name IN Okl_Operands_V.NAME%TYPE,

289: x_return_status OUT NOCOPY VARCHAR2,
290: x_valid OUT NOCOPY BOOLEAN
291: ) IS
292: CURSOR okl_opd_overlaps_csr (p_id IN Okl_Operands_V.ID%TYPE,
293: p_name IN Okl_Operands_V.NAME%TYPE,
294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
295: p_end_date IN Okl_Operands_V.END_DATE%TYPE
296: ) IS
297: SELECT '1'

Line 294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,

290: x_valid OUT NOCOPY BOOLEAN
291: ) IS
292: CURSOR okl_opd_overlaps_csr (p_id IN Okl_Operands_V.ID%TYPE,
293: p_name IN Okl_Operands_V.NAME%TYPE,
294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
295: p_end_date IN Okl_Operands_V.END_DATE%TYPE
296: ) IS
297: SELECT '1'
298: FROM Okl_Operands_V

Line 295: p_end_date IN Okl_Operands_V.END_DATE%TYPE

291: ) IS
292: CURSOR okl_opd_overlaps_csr (p_id IN Okl_Operands_V.ID%TYPE,
293: p_name IN Okl_Operands_V.NAME%TYPE,
294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
295: p_end_date IN Okl_Operands_V.END_DATE%TYPE
296: ) IS
297: SELECT '1'
298: FROM Okl_Operands_V
299: WHERE NAME = p_name

Line 298: FROM Okl_Operands_V

294: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
295: p_end_date IN Okl_Operands_V.END_DATE%TYPE
296: ) IS
297: SELECT '1'
298: FROM Okl_Operands_V
299: WHERE NAME = p_name
300: AND ID <> p_id
301: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
302: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))

Line 305: FROM Okl_Operands_V

301: AND (p_start_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE) OR
302: p_end_date BETWEEN START_DATE AND NVL(END_DATE, OKL_API.G_MISS_DATE))
303: UNION ALL
304: SELECT '2'
305: FROM Okl_Operands_V
306: WHERE NAME = p_name
307: AND ID <> p_id
308: AND p_start_date <= START_DATE
309: AND p_end_date >= NVL(END_DATE, OKL_API.G_MISS_DATE);

Line 355: -- PROCEDURE check_constraints for: OKL_OPERANDS_V

351: */
352: -- Not required as new version will not be created while updating the operand
353: /*
354: ---------------------------------------------------------------------------
355: -- PROCEDURE check_constraints for: OKL_OPERANDS_V
356: -- To verify whether the dates are valid for both formula and operands
357: -- attached to it
358: ---------------------------------------------------------------------------
359: PROCEDURE check_constraints (

Line 364: CURSOR okl_opd_dsf_fk_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,

360: p_opdv_rec IN opdv_rec_type,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_valid OUT NOCOPY BOOLEAN
363: ) IS
364: CURSOR okl_opd_dsf_fk_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,
365: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
366: p_end_date IN Okl_Operands_V.END_DATE%TYPE
367:
368: ) IS

Line 365: p_start_date IN Okl_Operands_V.START_DATE%TYPE,

361: x_return_status OUT NOCOPY VARCHAR2,
362: x_valid OUT NOCOPY BOOLEAN
363: ) IS
364: CURSOR okl_opd_dsf_fk_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,
365: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
366: p_end_date IN Okl_Operands_V.END_DATE%TYPE
367:
368: ) IS
369: SELECT '1'

Line 366: p_end_date IN Okl_Operands_V.END_DATE%TYPE

362: x_valid OUT NOCOPY BOOLEAN
363: ) IS
364: CURSOR okl_opd_dsf_fk_csr (p_dsf_id IN Okl_Operands_V.dsf_id%TYPE,
365: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
366: p_end_date IN Okl_Operands_V.END_DATE%TYPE
367:
368: ) IS
369: SELECT '1'
370: FROM Okl_Data_Src_Fnctns_V dsf

Line 375: CURSOR okl_opd_fma_fk_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,

371: WHERE dsf.ID = p_dsf_id
372: AND (dsf.START_DATE > p_start_date OR
373: NVL(dsf.END_DATE, p_end_date) < p_end_date);
374:
375: CURSOR okl_opd_fma_fk_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
376: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
377: p_end_date IN Okl_Operands_V.END_DATE%TYPE
378:
379: ) IS

Line 376: p_start_date IN Okl_Operands_V.START_DATE%TYPE,

372: AND (dsf.START_DATE > p_start_date OR
373: NVL(dsf.END_DATE, p_end_date) < p_end_date);
374:
375: CURSOR okl_opd_fma_fk_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
376: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
377: p_end_date IN Okl_Operands_V.END_DATE%TYPE
378:
379: ) IS
380: SELECT '1'

Line 377: p_end_date IN Okl_Operands_V.END_DATE%TYPE

373: NVL(dsf.END_DATE, p_end_date) < p_end_date);
374:
375: CURSOR okl_opd_fma_fk_csr (p_fma_id IN Okl_Operands_V.fma_id%TYPE,
376: p_start_date IN Okl_Operands_V.START_DATE%TYPE,
377: p_end_date IN Okl_Operands_V.END_DATE%TYPE
378:
379: ) IS
380: SELECT '1'
381: FROM Okl_Formulae_V fma

Line 408: p_token2_value => 'Okl_Operands_V');

404: p_msg_name => G_DATES_MISMATCH,
405: p_token1 => G_PARENT_TABLE_TOKEN,
406: p_token1_value => 'Okl_Data_Src_Fnctns_V',
407: p_token2 => G_CHILD_TABLE_TOKEN,
408: p_token2_value => 'Okl_Operands_V');
409: x_valid := FALSE;
410: x_return_status := OKL_API.G_RET_STS_ERROR;
411: RAISE G_EXCEPTION_HALT_PROCESSING;
412: END IF;

Line 430: p_token2_value => 'Okl_Operands_V');

426: p_msg_name => G_DATES_MISMATCH,
427: p_token1 => G_PARENT_TABLE_TOKEN,
428: p_token1_value => 'Okl_Formulae_V',
429: p_token2 => G_CHILD_TABLE_TOKEN,
430: p_token2_value => 'Okl_Operands_V');
431: x_valid := FALSE;
432: x_return_status := OKL_API.G_RET_STS_ERROR;
433: RAISE G_EXCEPTION_HALT_PROCESSING;
434: END IF;

Line 589: -- PROCEDURE check_opd_fma_dates for: OKL_OPERANDS_V

585: END reorganize_inputs;
586:
587: /*
588: ---------------------------------------------------------------------------
589: -- PROCEDURE check_opd_fma_dates for: OKL_OPERANDS_V
590: -- To fetch the formulae that are attached to the existing version of the
591: -- operand
592: ---------------------------------------------------------------------------
593: PROCEDURE check_opd_fma_dates (p_upd_opdv_rec IN opdv_rec_type,

Line 704: p_view => 'Okl_Operands_V',

700: p_start_date_attribute_name => 'START_DATE',
701: p_start_date => l_opdv_rec.start_date,
702: p_end_date_attribute_name => 'END_DATE',
703: p_end_date => l_opdv_rec.end_date,
704: p_view => 'Okl_Operands_V',
705: x_return_status => l_return_status,
706: x_valid => l_valid);
707:
708:

Line 775: -- FUNCTION determine_action for: OKL_OPERANDS_V

771: */
772: -- Not required as new version will not be created while updating the operand
773: /*
774: ---------------------------------------------------------------------------
775: -- FUNCTION determine_action for: OKL_OPERANDS_V
776: -- This function helps in determining the various checks to be performed
777: -- for the new/updated record and also helps in determining whether a new
778: -- version is required or not
779: ---------------------------------------------------------------------------

Line 824: -- PROCEDURE insert_operands for: OKL_OPERANDS_V

820: END determine_action;
821: */
822:
823: ---------------------------------------------------------------------------
824: -- PROCEDURE insert_operands for: OKL_OPERANDS_V
825: ---------------------------------------------------------------------------
826: PROCEDURE insert_operands(p_api_version IN NUMBER,
827: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
828: x_return_status OUT NOCOPY VARCHAR2,

Line 957: -- PROCEDURE update_operands for: OKL_OPERANDS_V

953:
954: END insert_operands;
955:
956: ---------------------------------------------------------------------------
957: -- PROCEDURE update_operands for: OKL_OPERANDS_V
958: ---------------------------------------------------------------------------
959: PROCEDURE update_operands(p_api_version IN NUMBER,
960: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
961: x_return_status OUT NOCOPY VARCHAR2,

Line 1226: p_view => 'Okl_Operands_V',

1222: okl_accounting_util.get_version(p_attrib_tbl => l_attrib_tbl,
1223: p_cur_version => l_opdv_rec.version,
1224: p_end_date_attribute_name => 'END_DATE',
1225: p_end_date => l_opdv_rec.end_date,
1226: p_view => 'Okl_Operands_V',
1227: x_return_status => l_return_status,
1228: x_new_version => l_new_version);
1229:
1230: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN