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.OKS_PM_PROGRAMS_PVT dependencies on OKS_PM_STREAM_LEVELS

Line 256: oks_pm_stream_levels_v

252: ACTIVITY_LINE_ID,
253: CLE_ID
254: DNZ_CHR_ID
255: FROM
256: oks_pm_stream_levels_v
257: WHERE cle_id = p_template_cle_id
258: AND ACTIVITY_LINE_ID is null
259: ORDER by SEQUENCE_NUMBER;
260: cr_prog_stream_levels cu_prog_stream_levels%ROWTYPE;

Line 278: oks_pm_stream_levels_v

274: ACTIVITY_LINE_ID,
275: CLE_ID
276: DNZ_CHR_ID
277: FROM
278: oks_pm_stream_levels_v
279: WHERE cle_id = p_template_cle_id
280: AND ACTIVITY_LINE_ID = cp_ACTIVITY_LINE_ID
281: ORDER by SEQUENCE_NUMBER;
282: cr_act_stream_levels cu_act_stream_levels%ROWTYPE;

Line 293: from oks_pm_stream_levels_V

289:
290: -- Added by jvorugan for Bug:5080930
291: cursor get_max_seq_no is
292: select max(to_number(SEQUENCE_NUMBER))
293: from oks_pm_stream_levels_V
294: where cle_id =p_template_cle_id
295: and ACTIVITY_LINE_ID is null;
296:
297: cursor get_max_act_seq_no(cp_activity_line_id IN NUMBER) is

Line 299: from oks_pm_stream_levels_V

295: and ACTIVITY_LINE_ID is null;
296:
297: cursor get_max_act_seq_no(cp_activity_line_id IN NUMBER) is
298: select max(to_number(SEQUENCE_NUMBER))
299: from oks_pm_stream_levels_V
300: where cle_id = p_template_cle_id
301: and ACTIVITY_LINE_ID = cp_ACTIVITY_LINE_ID;
302:
303: cursor check_renew(p_target_chr_id NUMBER)is

Line 1663: FROM OKS_PM_STREAM_LEVELS_V PML

1659: PROGRAM_ID ,
1660: ACTIVITY_LINE_ID,
1661: CLE_ID
1662: DNZ_CHR_ID
1663: FROM OKS_PM_STREAM_LEVELS_V PML
1664: WHERE CLE_ID=(select id from okc_k_lines_b where cle_id=p_contract_line_id
1665: and lse_id in (2,15,20));
1666:
1667: CR_STREAM_LEVELS CU_STREAM_LEVELS%ROWTYPE;*/

Line 1829: FROM OKS_PM_STREAM_LEVELS_V PML

1825: ACTIVITY_LINE_ID,
1826: CLE_ID,
1827: DNZ_CHR_ID,
1828: OBJECT_VERSION_NUMBER
1829: FROM OKS_PM_STREAM_LEVELS_V PML
1830: WHERE CLE_ID=p_contract_line_id
1831: -- and lse_id in (2,15,20)) commented by jvorugan as pm is associated with contract line
1832: AND ACTIVITY_LINE_ID IS NULL
1833: ORDER BY ACTIVITY_LINE_ID,SEQUENCE_NUMBER;

Line 1852: FROM OKS_PM_STREAM_LEVELS_V PML

1848: ACTIVITY_LINE_ID,
1849: CLE_ID,
1850: DNZ_CHR_ID,
1851: OBJECT_VERSION_NUMBER
1852: FROM OKS_PM_STREAM_LEVELS_V PML
1853: WHERE CLE_ID=p_contract_line_id
1854: -- and lse_id in (2,15,20)) commented by jvorugan as pm is associated with contract line
1855: AND ACTIVITY_LINE_ID = cp_activity_line_id
1856: ORDER BY ACTIVITY_LINE_ID,SEQUENCE_NUMBER;

Line 4050: FROM OKS_PM_STREAM_LEVELS_V PML

4046: AUTOSCHEDULE_YN,
4047: ACTIVITY_LINE_ID,
4048: CLE_ID
4049: DNZ_CHR_ID
4050: FROM OKS_PM_STREAM_LEVELS_V PML
4051: WHERE CLE_ID=cp_cov_line_id
4052: and activity_line_id is null
4053: ORDER BY SEQUENCE_NUMBER;
4054:

Line 4066: FROM OKS_PM_STREAM_LEVELS_V PML

4062: AUTOSCHEDULE_YN,
4063: ACTIVITY_LINE_ID,
4064: CLE_ID
4065: DNZ_CHR_ID
4066: FROM OKS_PM_STREAM_LEVELS_V PML
4067: WHERE activity_line_id =cp_activity_line_id
4068: ORDER BY SEQUENCE_NUMBER;
4069:
4070:

Line 4953: SELECT ID FROM OKS_PM_STREAM_LEVELS

4949: SELECT ID FROM OKS_PM_ACTIVITIES
4950: WHERE CLE_ID = p_cle_id;
4951:
4952: CURSOR CU_GET_PML IS
4953: SELECT ID FROM OKS_PM_STREAM_LEVELS
4954: WHERE CLE_ID = p_cle_id;
4955:
4956: CURSOR CU_GET_SCH IS
4957: SELECT ID FROM OKS_PM_SCHEDULES

Line 5285: DELETE OKS_PM_STREAM_LEVELS

5281:
5282: DELETE OKS_PM_SCHEDULES
5283: WHERE dnz_chr_id = l_chr_id;
5284:
5285: DELETE OKS_PM_STREAM_LEVELS
5286: WHERE dnz_chr_id = l_chr_id;
5287:
5288: DELETE OKS_PM_ACTIVITIES
5289: WHERE dnz_chr_id = l_chr_id;

Line 5349: DELETE OKS_PM_STREAM_LEVELS_H

5345: DELETE OKS_PM_SCHEDULES_H
5346: WHERE dnz_chr_id = l_chr_id
5347: And major_version = -1;
5348:
5349: DELETE OKS_PM_STREAM_LEVELS_H
5350: WHERE dnz_chr_id = l_chr_id
5351: And major_version = -1;
5352:
5353: DELETE OKS_PM_ACTIVITIES_H

Line 5477: -- This function is to insert values into oks_pm_stream_levels

5473: return x_return_status;
5474:
5475: END CREATE_OKS_PM_ACTIVITIES;
5476:
5477: -- This function is to insert values into oks_pm_stream_levels
5478: FUNCTION CREATE_OKS_PM_STREAM_LEVELS(p_new_cle_id NUMBER,
5479: p_old_cle_id NUMBER) return VARCHAR2 IS
5480:
5481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 5478: FUNCTION CREATE_OKS_PM_STREAM_LEVELS(p_new_cle_id NUMBER,

5474:
5475: END CREATE_OKS_PM_ACTIVITIES;
5476:
5477: -- This function is to insert values into oks_pm_stream_levels
5478: FUNCTION CREATE_OKS_PM_STREAM_LEVELS(p_new_cle_id NUMBER,
5479: p_old_cle_id NUMBER) return VARCHAR2 IS
5480:
5481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5482:

Line 5485: INSERT INTO oks_pm_stream_levels

5481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5482:
5483: BEGIN
5484:
5485: INSERT INTO oks_pm_stream_levels
5486: ( ID,
5487: CLE_ID,
5488: DNZ_CHR_ID,
5489: ACTIVITY_LINE_ID,

Line 5547: FROM oks_pm_stream_levels

5543: -- SERVICE_LINE_ID,
5544: ID ORIG_SYSTEM_ID1,
5545: ORIG_SYSTEM_SOURCE_CODE,
5546: ORIG_SYSTEM_REFERENCE1
5547: FROM oks_pm_stream_levels
5548: WHERE cle_id=p_old_cle_id;
5549: RETURN l_return_status;
5550:
5551: EXCEPTION

Line 5562: END CREATE_OKS_PM_STREAM_LEVELS;

5558: SQLERRM);
5559: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
5560: return x_return_status;
5561:
5562: END CREATE_OKS_PM_STREAM_LEVELS;
5563:
5564:
5565: BEGIN
5566:

Line 5579: l_return_status := CREATE_OKS_PM_STREAM_LEVELS(p_new_coverage_id,p_old_coverage_id);

5575: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5576: THEN
5577: RAISE G_EXCEPTION_HALT_VALIDATION;
5578: END IF;
5579: l_return_status := CREATE_OKS_PM_STREAM_LEVELS(p_new_coverage_id,p_old_coverage_id);
5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);
5582: END IF;
5583:

Line 5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);

5577: RAISE G_EXCEPTION_HALT_VALIDATION;
5578: END IF;
5579: l_return_status := CREATE_OKS_PM_STREAM_LEVELS(p_new_coverage_id,p_old_coverage_id);
5580: IF (G_DEBUG_ENABLED = 'Y') THEN
5581: okc_debug.log('After CREATE_OKS_PM_STREAM_LEVELS'||l_return_status, 3);
5582: END IF;
5583:
5584: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS
5585: THEN