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_COVERAGES_PVT dependencies on OKC_K_LINES_V

Line 46: SELECT COUNT(*) FROM OKC_K_LINES_V

42: x_return_status OUT NOCOPY VARCHAR2) IS
43: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
44: l_Count NUMBER;
45: CURSOR Cur_Line(P_Line_Id IN NUMBER) IS
46: SELECT COUNT(*) FROM OKC_K_LINES_V
47: WHERE id=P_Line_Id;
48: BEGIN
49: IF P_Line_id = OKC_API.G_MISS_NUM OR
50: P_Line_Id IS NULL

Line 444: FROM OKC_K_LINES_v

440: ATTRIBUTE12,
441: ATTRIBUTE13,
442: ATTRIBUTE14,
443: ATTRIBUTE15
444: FROM OKC_K_LINES_v
445: WHERE ID= P_Line_Id;
446: --------------------------
447: CURSOR Cur_LineDet3 (P_Line_Id IN NUMBER) IS
448: SELECT SFWT_FLAG,

Line 475: FROM OKC_K_LINES_v

471: ATTRIBUTE12,
472: ATTRIBUTE13,
473: ATTRIBUTE14,
474: ATTRIBUTE15
475: FROM OKC_K_LINES_v
476: WHERE ID= P_Line_Id;
477: --------------------------
478: LineDet_Rec3 Cur_LineDet3%ROWTYPE;
479: LineDet_Rec Cur_LineDet%ROWTYPE;

Line 2023: SELECT ID FROM OKC_K_Lines_v

2019: x_msg_data OUT NOCOPY VARCHAR2,
2020: P_Header_id IN NUMBER) IS
2021:
2022: CURSOR Cur_Line (P_Chr_Id IN NUMBER) IS
2023: SELECT ID FROM OKC_K_Lines_v
2024: WHERE chr_ID=p_chr_Id;
2025:
2026: CURSOR Cur_gov (P_chr_Id IN NUMBER) IS
2027: SELECT ID FROM OKC_Governances_v

Line 2235: ,OKC_K_LINES_V lv

2231: WHERE Rul_Id =P_Rule_Id;
2232:
2233: CURSOR Kprl_Cur(P_cle_Id IN NUMBER) IS
2234: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr
2235: ,OKC_K_LINES_V lv
2236: WHERE pr.cle_Id=P_cle_Id
2237: And pr.cle_id = lv.id
2238: And pr.dnz_chr_id = lv.dnz_chr_id;
2239:

Line 2431: from okc_k_Lines_v kl,

2427: FUNCTION Bp_Check(P_rgp_Id IN NUMBER)
2428: RETURN BOOLEAN IS
2429: CURSOR GetLse_Cur IS
2430: SELECT kl.lse_ID
2431: from okc_k_Lines_v kl,
2432: okc_rule_groups_v rg
2433: where kl.id = rg.cle_id
2434: and rg.id = P_rgp_Id;
2435:

Line 3468: FROM OKC_K_LINES_V

3464: SELECT ID,
3465: LSE_ID,
3466: START_DATE,
3467: END_DATE
3468: FROM OKC_K_LINES_V
3469: WHERE cle_ID= P_Id and lse_id in (2,14,15,20,13,19);
3470:
3471: Linecov_Rec Linecov_Cur%ROWTYPE;
3472: ----------------------------------------------

Line 3476: FROM OKC_K_LINES_V

3472: ----------------------------------------------
3473: -- Cursor for Business Process
3474: CURSOR Linedet_Cur(P_ID IN NUMBER) IS
3475: SELECT ID, START_DATE, END_DATE
3476: FROM OKC_K_LINES_V
3477: WHERE cle_ID= P_Id ;
3478:
3479: LineDet_Rec LineDet_Cur%ROWTYPE;
3480:

Line 3491: SELECT ID FROM OKC_K_LINES_V

3487: oks_offset_rec CUR_GET_OFFSET_BP%ROWTYPE;
3488: ------------------------------------------------
3489: -- Cursor for Bill Type/Reaction Time
3490: CURSOR LineDet1_Cur(P_ID IN NUMBER) IS
3491: SELECT ID FROM OKC_K_LINES_V
3492: WHERE cle_ID= P_Id;
3493: ------------------------------------------------
3494: --Cursor for Bill Rate
3495: CURSOR LineDet2_Cur(P_ID IN NUMBER) IS

Line 3496: SELECT ID FROM OKC_K_LINES_V

3492: WHERE cle_ID= P_Id;
3493: ------------------------------------------------
3494: --Cursor for Bill Rate
3495: CURSOR LineDet2_Cur(P_ID IN NUMBER) IS
3496: SELECT ID FROM OKC_K_LINES_V
3497: WHERE cle_ID= P_Id;
3498: ------------------------------------------------
3499: CURSOR dnz_Cur IS
3500: SELECT Chr_Id FROM OKC_K_LINES_V

Line 3500: SELECT Chr_Id FROM OKC_K_LINES_V

3496: SELECT ID FROM OKC_K_LINES_V
3497: WHERE cle_ID= P_Id;
3498: ------------------------------------------------
3499: CURSOR dnz_Cur IS
3500: SELECT Chr_Id FROM OKC_K_LINES_V
3501: WHERE Id=P_Service_Line_ID;
3502:
3503: l_bp_offset_duration NUMBER := NULL;
3504: l_bp_offset_period VARCHAR2(3) := NULL;

Line 3829: ,OKC_K_LINES_V lv

3825: WHERE Rul_Id =P_Rule_Id;
3826:
3827: CURSOR Kprl_Cur(P_cle_Id IN NUMBER) IS
3828: SELECT pr.ID FROM OKC_K_PARTY_ROLES_B pr
3829: ,OKC_K_LINES_V lv
3830: WHERE pr.cle_Id=P_cle_Id
3831: And pr.cle_id = lv.id
3832: And pr.dnz_chr_id = lv.dnz_chr_id;
3833:

Line 3913: from okc_k_Lines_v kl,

3909: FUNCTION Bp_Check(P_rgp_Id IN NUMBER)
3910: RETURN BOOLEAN IS
3911: CURSOR GetLse_Cur IS
3912: SELECT kl.lse_ID
3913: from okc_k_Lines_v kl,
3914: okc_rule_groups_v rg
3915: where kl.id = rg.cle_id
3916: and rg.id = P_rgp_Id;
3917:

Line 4413: FROM OKC_K_LINES_V

4409:
4410: Cursor Cur_Get_Cov_details(p_cov_line_id NUMBER) IS
4411: SELECT NAME, ITEM_DESCRIPTION,
4412: EXCEPTION_YN
4413: FROM OKC_K_LINES_V
4414: WHERE id = p_cov_line_id
4415: AND lse_id in (2,15,20);
4416:
4417: Cursor Get_Coverage_rules(p_cov_line_id NUMBER) IS

Line 4450: FROM OKC_K_LINES_V lines, OKC_K_ITEMS_V items

4446: SELECT lines.id,
4447: -- lines.start_date start_date,
4448: -- lines.end_date end_date,
4449: items.object1_id1
4450: FROM OKC_K_LINES_V lines, OKC_K_ITEMS_V items
4451: WHERE lines.cle_id = p_cle_id
4452: AND lines.lse_id IN(3,16,21)
4453: AND items.JTOT_OBJECT1_CODE = 'OKX_BUSIPROC'
4454: AND items.cle_id = lines.id ;

Line 4556: FROM OKC_K_LINES_V lines,

4552: items.object1_id1 BP_ID,
4553: ocv.cro_code cro_code,
4554: ocv.object1_id1 res_id,
4555: ocv.resource_class resource_class
4556: FROM OKC_K_LINES_V lines,
4557: OKC_K_PARTY_ROLES_B party,
4558: OKC_CONTACTS_V ocv,
4559: OKC_K_ITEMS_V items
4560: WHERE lines.id = p_bp_line_id

Line 4579: FROM OKC_K_LINES_V lines,

4575: items.object1_id1 object1_id1,
4576: oksl.discount_amount discount_amount,
4577: oksl.discount_percent discount_percent,
4578: txn.billing_type billing_type
4579: FROM OKC_K_LINES_V lines,
4580: OKS_K_LINES_B oksl,
4581: OKC_K_ITEMS_V items,
4582: okx_txn_billing_types_v txn
4583: WHERE lines.cle_id = p_cle_id

Line 4629: l_source_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;

4625: l_source_start_date Date;
4626: l_source_end_date Date;
4627: l_target_start_date Date;
4628: l_target_end_date Date;
4629: l_source_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;
4630: l_target_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;
4631: l_src_cov_id NUMBER;
4632: l_tgt_cov_id NUMBER;
4633: G_MISMATCH EXCEPTION ;

Line 4630: l_target_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;

4626: l_source_end_date Date;
4627: l_target_start_date Date;
4628: l_target_end_date Date;
4629: l_source_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;
4630: l_target_exp OKC_K_LINES_V.EXCEPTION_YN%TYPE;
4631: l_src_cov_id NUMBER;
4632: l_tgt_cov_id NUMBER;
4633: G_MISMATCH EXCEPTION ;
4634: l_return BOOLEAN:= TRUE;

Line 4680: l_source_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;

4676: l_msg_count NUMBER;
4677: l_msg_data VARCHAR2(2000):=null;
4678: l_source_cov_name VARCHAR2(150);
4679: l_target_cov_name VARCHAR2(150);
4680: l_source_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;
4681: l_target_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;
4682: l_pml_src_index NUMBER:= 0;
4683: l_pml_tgt_index NUMBER:= 0;
4684: -- l_src_pml_index1 NUMBER:= 0;

Line 4681: l_target_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;

4677: l_msg_data VARCHAR2(2000):=null;
4678: l_source_cov_name VARCHAR2(150);
4679: l_target_cov_name VARCHAR2(150);
4680: l_source_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;
4681: l_target_cov_desc OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE;
4682: l_pml_src_index NUMBER:= 0;
4683: l_pml_tgt_index NUMBER:= 0;
4684: -- l_src_pml_index1 NUMBER:= 0;
4685: -- l_tgt_pml_index1 NUMBER:= 0;

Line 5469: SELECT ID FROM OKC_K_LINES_v

5465: P_Target_contract_Line_Id IN NUMBER,
5466: x_Actual_coverage_id OUT NOCOPY NUMBER) IS
5467:
5468: CURSOR Cur_LineDet (P_Line_Id IN NUMBER) IS
5469: SELECT ID FROM OKC_K_LINES_v
5470: WHERE CLE_ID= P_Line_Id
5471: AND LSE_ID in (2,15,20);
5472:
5473: CURSOR Cur_LineDet1 (P_Line_Id IN NUMBER) IS

Line 5474: SELECT Start_Date,End_Date FROM OKC_K_LINES_v

5470: WHERE CLE_ID= P_Line_Id
5471: AND LSE_ID in (2,15,20);
5472:
5473: CURSOR Cur_LineDet1 (P_Line_Id IN NUMBER) IS
5474: SELECT Start_Date,End_Date FROM OKC_K_LINES_v
5475: WHERE ID= P_Line_Id;
5476:
5477: l_cov_id OKC_K_LINES_V.ID%TYPE;
5478: l_start_date OKC_K_LINES_V.START_DATE%TYPE;

Line 5477: l_cov_id OKC_K_LINES_V.ID%TYPE;

5473: CURSOR Cur_LineDet1 (P_Line_Id IN NUMBER) IS
5474: SELECT Start_Date,End_Date FROM OKC_K_LINES_v
5475: WHERE ID= P_Line_Id;
5476:
5477: l_cov_id OKC_K_LINES_V.ID%TYPE;
5478: l_start_date OKC_K_LINES_V.START_DATE%TYPE;
5479: l_end_date OKC_K_LINES_V.END_DATE%TYPE;
5480:
5481: l_api_version CONSTANT NUMBER := 1.0;

Line 5478: l_start_date OKC_K_LINES_V.START_DATE%TYPE;

5474: SELECT Start_Date,End_Date FROM OKC_K_LINES_v
5475: WHERE ID= P_Line_Id;
5476:
5477: l_cov_id OKC_K_LINES_V.ID%TYPE;
5478: l_start_date OKC_K_LINES_V.START_DATE%TYPE;
5479: l_end_date OKC_K_LINES_V.END_DATE%TYPE;
5480:
5481: l_api_version CONSTANT NUMBER := 1.0;
5482: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';

Line 5479: l_end_date OKC_K_LINES_V.END_DATE%TYPE;

5475: WHERE ID= P_Line_Id;
5476:
5477: l_cov_id OKC_K_LINES_V.ID%TYPE;
5478: l_start_date OKC_K_LINES_V.START_DATE%TYPE;
5479: l_end_date OKC_K_LINES_V.END_DATE%TYPE;
5480:
5481: l_api_version CONSTANT NUMBER := 1.0;
5482: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
5483: l_return_status VARCHAR2(1);

Line 6751: FROM -- okc_k_lines_v lines1, --new_id

6747: lines1.Id New_line_ID,lines1.chr_Id New_Chr_Id,
6748: lines1.created_by,
6749: lines1.last_updated_by,
6750: lines1.last_update_login
6751: FROM -- okc_k_lines_v lines1, --new_id
6752: -- okc_k_lines_v lines2 -- old_id
6753: okc_k_lines_b lines1, --Modified by Jvorugan for Bug:4560735
6754: okc_k_lines_b lines2
6755: WHERE lines1.id =l_id

Line 6752: -- okc_k_lines_v lines2 -- old_id

6748: lines1.created_by,
6749: lines1.last_updated_by,
6750: lines1.last_update_login
6751: FROM -- okc_k_lines_v lines1, --new_id
6752: -- okc_k_lines_v lines2 -- old_id
6753: okc_k_lines_b lines1, --Modified by Jvorugan for Bug:4560735
6754: okc_k_lines_b lines2
6755: WHERE lines1.id =l_id
6756: AND lines1.ORIG_SYSTEM_ID1 = lines2.ID;