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.

[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on OKC_OPERATION_LINES

Line 22: FROM okc_operation_lines

18: source_line_id IN NUMBER) RETURN BOOLEAN
19: IS
20: CURSOR op_lines IS
21: SELECT subject_chr_id
22: FROM okc_operation_lines
23: WHERE object_cle_id = source_line_id
24: AND process_flag = 'P'
25: AND active_yn = 'Y';
26: x_return BOOLEAN := FALSE;

Line 46: FROM okc_operation_lines

42: p_subject_chr_id IN NUMBER) RETURN BOOLEAN
43: IS
44: CURSOR oper_exist IS
45: SELECT 'X' x
46: FROM okc_operation_lines
47: WHERE subject_chr_id = p_subject_chr_id
48: AND object_cle_id = p_object_cle_id;
49: x_return BOOLEAN := FALSE;
50: BEGIN

Line 63: FROM okc_operation_lines

59: PROCEDURE SET_OL_SELECTED(p_id IN NUMBER,
60: x_return_status OUT NOCOPY VARCHAR2) IS
61: CURSOR parent_cur IS
62: SELECT id, select_yn
63: FROM okc_operation_lines
64: WHERE id = (SELECT parent_ole_id
65: FROM okc_operation_lines
66: WHERE id = p_id);
67: l_api_version CONSTANT NUMBER := 1.0;

Line 65: FROM okc_operation_lines

61: CURSOR parent_cur IS
62: SELECT id, select_yn
63: FROM okc_operation_lines
64: WHERE id = (SELECT parent_ole_id
65: FROM okc_operation_lines
66: WHERE id = p_id);
67: l_api_version CONSTANT NUMBER := 1.0;
68: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
69: l_return_status VARCHAR2(1);

Line 198: FROM okc_operation_lines OPL,

194: -- and terminated lines. Also simplified the fetch for sublines.
195: ------------------------------------------------------------------
196: CURSOR operation_lines(p_target_id IN NUMBER) IS
197: SELECT opl.id, oie_id, object_chr_id, object_cle_id, parent_ole_id, select_yn, cle.cle_id
198: FROM okc_operation_lines OPL,
199: okc_k_lines_b cle
200: WHERE OPL.subject_chr_id = p_target_id
201: AND EXISTS (SELECT 'X'
202: FROM okc_operation_instances OPI

Line 223: FROM okc_operation_lines

219: AND NVL(cle1.line_renewal_type_code,'FUL') not in ('DNR', 'KEP'))
220: /*
221: MINUS
222: (SELECT id, oie_id, object_chr_id, object_cle_id, parent_ole_id, select_yn
223: FROM okc_operation_lines
224: WHERE subject_chr_id = p_target_id
225: AND parent_ole_id IS NULL
226: UNION
227: SELECT a.id, a.oie_id, a.object_chr_id, a.object_cle_id, a.parent_ole_id, a.select_yn

Line 228: FROM okc_operation_lines a, okc_operation_lines b

224: WHERE subject_chr_id = p_target_id
225: AND parent_ole_id IS NULL
226: UNION
227: SELECT a.id, a.oie_id, a.object_chr_id, a.object_cle_id, a.parent_ole_id, a.select_yn
228: FROM okc_operation_lines a, okc_operation_lines b
229: WHERE a.subject_chr_id = p_target_id
230: AND b.subject_chr_id = p_target_id
231: AND a.id = b.parent_ole_id)
232: */

Line 236: ( SELECT '1' FROM okc_operation_lines

232: */
233: -- Added following code for bug#5981381 i.e. removed looping of function call of not_processed_by_other
234: -- and moved the entire code from the cursor to here
235: AND NOT EXISTS
236: ( SELECT '1' FROM okc_operation_lines
237: WHERE object_cle_id = opl.object_cle_id
238: AND subject_chr_id <> p_target_id
239: AND process_flag = 'P'
240: AND active_yn = 'Y')

Line 298: FROM okc_operation_lines OPL,

294: FUNCTION opl_terminated(p_opl_id IN NUMBER) RETURN BOOLEAN IS
295:
296: CURSOR get_terminated_opl(cp_opl_id IN NUMBER) IS
297: SELECT 1
298: FROM okc_operation_lines OPL,
299: okc_k_lines_b KLN
300: WHERE OPL.id = cp_opl_id
301: AND OPL.object_cle_id = KLN.id
302: AND KLN.date_terminated IS NOT NULL;

Line 564: ( SELECT '1' FROM okc_operation_lines

560: AND NVL(cle.line_renewal_type_code,'FUL') not in ('DNR', 'KEP')) -- Added by MKS
561: -- Added following code for bug#5981381 i.e. removed looping of function call of is_laready_in_ol
562: -- and moved the entire code from that function to here
563: AND NOT EXISTS
564: ( SELECT '1' FROM okc_operation_lines
565: WHERE subject_chr_id = p_target_chr_id
566: AND object_cle_id = s.id) ;
567:
568: ------------------------------------------------------------------

Line 1002: SELECT id FROM OKC_OPERATION_LINES

998: END IS_PRESENT;
999:
1000: FUNCTION GET_HDR_OLE_ID(p_header_id IN NUMBER) RETURN NUMBER IS
1001: CURSOR header_op_line IS
1002: SELECT id FROM OKC_OPERATION_LINES
1003: WHERE oie_id = p_oie_id
1004: AND object_chr_id = p_header_id
1005: AND object_cle_id IS NULL;
1006: x_ret_id NUMBER ;

Line 1019: SELECT id FROM OKC_OPERATION_LINES

1015: END GET_HDR_OLE_ID;
1016:
1017: FUNCTION GET_TOPLINE_OLE_ID(p_topline_id IN NUMBER) RETURN NUMBER IS
1018: CURSOR topline_op_line IS
1019: SELECT id FROM OKC_OPERATION_LINES
1020: WHERE oie_id = p_oie_id
1021: AND object_cle_id = p_topline_id;
1022: x_ret_id NUMBER ;
1023: BEGIN

Line 1300: FROM okc_operation_lines

1296: FUNCTION FIND_OL_STATUS(p_object_cle_id IN NUMBER) RETURN VARCHAR2
1297: IS
1298: CURSOR process_flag IS
1299: SELECT process_flag
1300: FROM okc_operation_lines
1301: WHERE object_cle_id = p_object_cle_id
1302: AND active_yn = 'Y';
1303:
1304: x_return VARCHAR2(200) := 'A';

Line 1379: FROM okc_operation_lines

1375: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1376:
1377: CURSOR get_top_line IS
1378: SELECT object_cle_id
1379: FROM okc_operation_lines
1380: WHERE p_parent_ole_id = id;
1381: x_return NUMBER;
1382: BEGIN
1383: BEGIN

Line 1707: SELECT object_cle_id FROM okc_operation_lines ol, okc_k_lines_b cle

1703: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1704:
1705:
1706: CURSOR get_oper_sub_lines(p_id IN NUMBER) IS
1707: SELECT object_cle_id FROM okc_operation_lines ol, okc_k_lines_b cle
1708: WHERE ol.parent_ole_id = p_id
1709: and ol.process_flag IN ('A','E')
1710: and ol.select_yn = 'Y'
1711: and cle.id = ol.object_cle_id

Line 1715: SELECT * FROM okc_operation_lines

1711: and cle.id = ol.object_cle_id
1712: and cle.date_terminated is null
1713: and NVL(cle.line_renewal_type_code,'FUL') not in ('DNR', 'KEP'); -- bug 5078797
1714: /*
1715: SELECT * FROM okc_operation_lines
1716: WHERE parent_ole_id = p_id
1717: AND process_flag IN ('A', 'E')
1718: AND select_yn = 'Y';
1719: */

Line 1829: SELECT b. * FROM okc_operation_lines a, okc_operation_lines b

1825:
1826:
1827: /*
1828: CURSOR get_oper_top_lines IS
1829: SELECT b. * FROM okc_operation_lines a, okc_operation_lines b
1830: WHERE a.oie_id = p_oie_id
1831: AND b.oie_id = p_oie_id
1832: AND a.id = b.parent_ole_id
1833: AND a.parent_ole_id IS NULL

Line 1842: FROM okc_operation_lines b,

1838: SELECT b.*,
1839: chr.inv_organization_id,
1840: chr.authoring_org_id,
1841: chr.currency_code
1842: FROM okc_operation_lines b,
1843: okc_k_lines_b cle,
1844: okc_k_headers_all_b chr,
1845: okc_statuses_b st
1846: WHERE b.oie_id = p_oie_id

Line 1860: SELECT * FROM okc_operation_lines

1856: and nvl(renewal_type_code, G_GCD_RENEWAL_TYPE) <> 'DNR';
1857:
1858: /*
1859: CURSOR get_oper_sub_lines(p_id IN NUMBER) IS
1860: SELECT * FROM okc_operation_lines
1861: WHERE parent_ole_id = p_id
1862: AND process_flag IN ('A', 'E')
1863: AND select_yn = 'Y';
1864: */

Line 1866: SELECT ol.*, lse_id, start_date, end_date FROM okc_operation_lines ol,

1862: AND process_flag IN ('A', 'E')
1863: AND select_yn = 'Y';
1864: */
1865: CURSOR get_oper_sub_lines(p_id IN NUMBER) IS
1866: SELECT ol.*, lse_id, start_date, end_date FROM okc_operation_lines ol,
1867: okc_k_lines_b cle
1868: WHERE parent_ole_id = p_id
1869: and process_flag IN ('A','E')
1870: and select_yn = 'Y'

Line 1876: FROM okc_operation_lines

1872: and cle.date_terminated is NULL
1873: and NVL(cle.line_renewal_type_code,'FUL') not in ('DNR', 'KEP') -- bug 5078797
1874: and NOT EXISTS
1875: ( SELECT 'x'
1876: FROM okc_operation_lines
1877: WHERE object_cle_id = ol.object_cle_id
1878: AND subject_chr_id <> ol.subject_chr_id
1879: AND process_flag = 'P'
1880: AND active_yn = 'Y'

Line 2565: --update process status and subject cle id in okc_operation_lines for all

2561:
2562: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2563: LOG_MESSAGES(' ');
2564:
2565: --update process status and subject cle id in okc_operation_lines for all
2566: --source toplines and sublines that where successfully copied to the target
2567: IF (l_opl_id_tbl.COUNT > 0 ) THEN
2568:
2569: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 2570: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_opn_lines','updating okc_operation_lines l_opl_id_tbl.COUNT='||l_opl_id_tbl.COUNT);

2566: --source toplines and sublines that where successfully copied to the target
2567: IF (l_opl_id_tbl.COUNT > 0 ) THEN
2568:
2569: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2570: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_opn_lines','updating okc_operation_lines l_opl_id_tbl.COUNT='||l_opl_id_tbl.COUNT);
2571: END IF;
2572:
2573: FORALL i IN l_opl_id_tbl.FIRST..l_opl_id_tbl.LAST
2574: UPDATE okc_operation_lines SET

Line 2574: UPDATE okc_operation_lines SET

2570: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_opn_lines','updating okc_operation_lines l_opl_id_tbl.COUNT='||l_opl_id_tbl.COUNT);
2571: END IF;
2572:
2573: FORALL i IN l_opl_id_tbl.FIRST..l_opl_id_tbl.LAST
2574: UPDATE okc_operation_lines SET
2575: subject_cle_id = l_opl_sub_cle_id_tbl(i),
2576: process_flag = l_opl_status_tbl(i),
2577: object_version_number = object_version_number + 1,
2578: last_updated_by = l_user_id,

Line 2592: -- Call Pricing API after the update to okc_operation_lines

2588: log_messages('***** Number of Source Sublines processed : ***** '||l_src_sub_line_id_tbl.COUNT);
2589: LOG_MESSAGES(' ');
2590:
2591: -- bug 6114024
2592: -- Call Pricing API after the update to okc_operation_lines
2593: IF (l_opl_id_tbl.COUNT > 0 ) THEN
2594: IF l_can_copy = 'Y' THEN
2595: LOG_MESSAGES('l_can_copy = Y ');
2596: LOG_MESSAGES('Calling OKS_REPRICE_PVT.call_pricing_api');

Line 2675: (SELECT b.object_cle_id FROM okc_operation_lines a, okc_operation_lines b

2671: tl.program_application_id = l_prog_appl_id,
2672: tl.program_id = l_prog_id,
2673: tl.program_update_date = l_update_date
2674: WHERE tl.id IN
2675: (SELECT b.object_cle_id FROM okc_operation_lines a, okc_operation_lines b
2676: WHERE a.oie_id = p_oie_id
2677: AND b.oie_id = p_oie_id
2678: AND a.id = b.parent_ole_id
2679: AND a.parent_ole_id IS NULL

Line 2705: (SELECT a.object_chr_id FROM okc_operation_lines a

2701: h.program_application_id = l_prog_appl_id,
2702: h.program_id = l_prog_id,
2703: h.program_update_date = l_update_date
2704: WHERE h.id IN
2705: (SELECT a.object_chr_id FROM okc_operation_lines a
2706: WHERE a.oie_id = p_oie_id
2707: AND a.object_cle_id IS NULL
2708: AND a.subject_cle_id IS NULL
2709: AND a.select_yn = 'Y')