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_B

Line 85: SELECT count(*) FROM OKC_K_LINES_B

81: x_template_yn OUT NOCOPY VARCHAR2,
82: x_return_status OUT NOCOPY VARCHAR2) IS
83:
84: CURSOR check_cov_tmpl(p_cov_id IN Number) IS
85: SELECT count(*) FROM OKC_K_LINES_B
86: WHERE id = p_cov_id
87: AND lse_id in (2,15,20)
88: and dnz_chr_id < 0;
89:

Line 487: FROM OKC_K_LINES_B

483:
484: CURSOR Cur_childline(P_cle_Id IN NUMBER,
485: P_lse_Id IN NUMBER) IS
486: SELECT ID
487: FROM OKC_K_LINES_B
488: WHERE cle_Id=P_cle_Id
489: AND lse_Id=P_lse_Id;
490: -------------------------------------
491:

Line 512: FROM OKC_K_LINES_B

508: ATTRIBUTE12,
509: ATTRIBUTE13,
510: ATTRIBUTE14,
511: ATTRIBUTE15
512: FROM OKC_K_LINES_B
513: WHERE cle_Id=P_cle_Id
514: AND lse_Id=P_lse_Id;
515: ---------------------------------------
516:

Line 520: FROM OKC_K_LINES_B

516:
517: CURSOR Cur_childline_bt(P_cle_Id IN NUMBER,
518: P_lse_Id IN NUMBER) IS
519: SELECT ID
520: FROM OKC_K_LINES_B
521: WHERE cle_Id=P_cle_Id
522: AND lse_Id=P_lse_Id;
523: ----------------------------------------
524:

Line 528: FROM OKC_K_LINES_B

524:
525: CURSOR Cur_childline1(P_cle_Id IN NUMBER,
526: P_lse_Id IN NUMBER) IS
527: SELECT ID
528: FROM OKC_K_LINES_B
529: WHERE cle_Id=P_cle_Id
530: AND lse_Id=P_lse_Id;
531: -----------------------------------------
532:

Line 548: OKC_K_LINES_B lv

544: pr.MINORITY_GROUP_LOOKUP_CODE,
545: pr.SMALL_BUSINESS_FLAG,
546: pr.WOMEN_OWNED_FLAG
547: FROM OKC_K_Party_Roles_V pr,
548: OKC_K_LINES_B lv
549: WHERE pr.cle_ID=p_cle_Id
550: AND pr.Rle_Code=P_Role_Code
551: AND pr.cle_id = lv.id
552: AND pr.dnz_chr_id = lv.dnz_chr_id ;

Line 858: SELECT COUNT(1) FROM OKC_K_LINES_B

854: l_Currency VARCHAR2(15) := NULL;
855: l_type_msmtch CONSTANT varchar2(200) := 'OKS_COV_TYPE_MSMTCH';
856: -----------------------------------
857: CURSOR Check_Cur(P_Line_Id IN NUMBER) IS
858: SELECT COUNT(1) FROM OKC_K_LINES_B
859: WHERE cle_Id=P_Line_Id
860: AND lse_Id IN (2,15,20);
861:
862: ------------------------------------

Line 867: SELECT Currency_Code FROM OKC_K_LINES_B

863: FUNCTION GetCurrency (P_ID IN NUMBER)
864: RETURN Varchar2
865: IS
866: CURSOR Currency_Cur IS
867: SELECT Currency_Code FROM OKC_K_LINES_B
868: WHERE ID=P_Id;
869:
870: BEGIN
871: OPEN Currency_Cur;

Line 878: l_sts OKC_K_LINES_B.sts_Code%Type:= NULL;

874: RETURN l_Currency;
875: END GetCurrency;
876: FUNCTION GetStatus (P_ID IN NUMBER)
877: RETURN Varchar2 IS
878: l_sts OKC_K_LINES_B.sts_Code%Type:= NULL;
879: CURSOR sts_Cur IS
880: SELECT sts_Code FROM OKC_K_LINES_B
881: WHERE ID=P_Id;
882: BEGIN

Line 880: SELECT sts_Code FROM OKC_K_LINES_B

876: FUNCTION GetStatus (P_ID IN NUMBER)
877: RETURN Varchar2 IS
878: l_sts OKC_K_LINES_B.sts_Code%Type:= NULL;
879: CURSOR sts_Cur IS
880: SELECT sts_Code FROM OKC_K_LINES_B
881: WHERE ID=P_Id;
882: BEGIN
883: OPEN sts_Cur;
884: FETCH sts_Cur INTO l_sts;

Line 2193: FROM Okc_K_Lines_b

2189:
2190:
2191: CURSOR line_det_Cur(P_cle_Id IN NUMBER)
2192: IS SELECT id, start_date, lse_id
2193: FROM Okc_K_Lines_b
2194: WHERE Id=P_cle_Id;
2195:
2196: CURSOR Child_Cur(P_cle_Id IN NUMBER)
2197: IS SELECT DNZ_CHR_ID, ID

Line 2198: FROM Okc_K_Lines_b

2194: WHERE Id=P_cle_Id;
2195:
2196: CURSOR Child_Cur(P_cle_Id IN NUMBER)
2197: IS SELECT DNZ_CHR_ID, ID
2198: FROM Okc_K_Lines_b
2199: WHERE cle_Id=P_cle_Id;
2200:
2201: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
2202: IS SELECT ID,DNZ_CHR_ID

Line 2203: FROM Okc_K_Lines_b

2199: WHERE cle_Id=P_cle_Id;
2200:
2201: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
2202: IS SELECT ID,DNZ_CHR_ID
2203: FROM Okc_K_Lines_b
2204: WHERE cle_Id=P_Parent_Id;
2205:
2206: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
2207: IS SELECT ID,DNZ_CHR_ID

Line 2208: FROM Okc_K_Lines_b

2204: WHERE cle_Id=P_Parent_Id;
2205:
2206: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
2207: IS SELECT ID,DNZ_CHR_ID
2208: FROM Okc_K_Lines_b
2209: WHERE cle_Id=P_Parent_Id;
2210: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
2211: IS SELECT ID,DNZ_CHR_ID
2212: FROM Okc_K_Lines_b

Line 2212: FROM Okc_K_Lines_b

2208: FROM Okc_K_Lines_b
2209: WHERE cle_Id=P_Parent_Id;
2210: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
2211: IS SELECT ID,DNZ_CHR_ID
2212: FROM Okc_K_Lines_b
2213: WHERE cle_Id=P_Parent_Id;
2214: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
2215: IS SELECT ID,DNZ_CHR_ID
2216: FROM Okc_K_Lines_b

Line 2216: FROM Okc_K_Lines_b

2212: FROM Okc_K_Lines_b
2213: WHERE cle_Id=P_Parent_Id;
2214: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
2215: IS SELECT ID,DNZ_CHR_ID
2216: FROM Okc_K_Lines_b
2217: WHERE cle_Id=P_Parent_Id;
2218: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
2219: IS SELECT ID,DNZ_CHR_ID
2220: FROM Okc_K_Lines_b

Line 2220: FROM Okc_K_Lines_b

2216: FROM Okc_K_Lines_b
2217: WHERE cle_Id=P_Parent_Id;
2218: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
2219: IS SELECT ID,DNZ_CHR_ID
2220: FROM Okc_K_Lines_b
2221: WHERE cle_Id=P_Parent_Id;
2222:
2223: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2224: IS SELECT ID

Line 2287: FROM OKC_K_LINES_B LINES1,

2283: l_sch_index NUMBER := 0;*/
2284:
2285: CURSOR CUR_GET_BRS_ID(p_service_line_id IN NUMBER) IS
2286: SELECT BRS.ID BRS_LINE_ID
2287: FROM OKC_K_LINES_B LINES1,
2288: OKC_K_LINES_B LINES2,
2289: OKC_K_LINES_B LINES3,
2290: OKC_K_LINES_B LINES4,
2291: OKS_BILLRATE_SCHEDULES BRS

Line 2288: OKC_K_LINES_B LINES2,

2284:
2285: CURSOR CUR_GET_BRS_ID(p_service_line_id IN NUMBER) IS
2286: SELECT BRS.ID BRS_LINE_ID
2287: FROM OKC_K_LINES_B LINES1,
2288: OKC_K_LINES_B LINES2,
2289: OKC_K_LINES_B LINES3,
2290: OKC_K_LINES_B LINES4,
2291: OKS_BILLRATE_SCHEDULES BRS
2292: WHERE LINES1.CLE_ID = p_service_line_id

Line 2289: OKC_K_LINES_B LINES3,

2285: CURSOR CUR_GET_BRS_ID(p_service_line_id IN NUMBER) IS
2286: SELECT BRS.ID BRS_LINE_ID
2287: FROM OKC_K_LINES_B LINES1,
2288: OKC_K_LINES_B LINES2,
2289: OKC_K_LINES_B LINES3,
2290: OKC_K_LINES_B LINES4,
2291: OKS_BILLRATE_SCHEDULES BRS
2292: WHERE LINES1.CLE_ID = p_service_line_id
2293: AND lines2.cle_id = lines1.id

Line 2290: OKC_K_LINES_B LINES4,

2286: SELECT BRS.ID BRS_LINE_ID
2287: FROM OKC_K_LINES_B LINES1,
2288: OKC_K_LINES_B LINES2,
2289: OKC_K_LINES_B LINES3,
2290: OKC_K_LINES_B LINES4,
2291: OKS_BILLRATE_SCHEDULES BRS
2292: WHERE LINES1.CLE_ID = p_service_line_id
2293: AND lines2.cle_id = lines1.id
2294: AND lines3.cle_id = lines2.id

Line 2310: from okc_k_lines_b

2306: -- From R12, notes and PM will be deleted when the serviceline id is deleted and not with the coverage.
2307: /*
2308: CURSOR Cur_Service_line(p_cle_id IN NUMBER) IS
2309: SELECT cle_id
2310: from okc_k_lines_b
2311: where id=p_cle_id
2312: and lse_id in (2,15,20);
2313:
2314: l_service_line_id NUMBER;

Line 3787: FROM Okc_K_Lines_b

3783:
3784:
3785: CURSOR line_det_Cur(P_cle_Id IN NUMBER)
3786: IS SELECT id, start_date, lse_id
3787: FROM Okc_K_Lines_b
3788: WHERE Id=P_cle_Id;
3789:
3790: CURSOR Child_Cur(P_cle_Id IN NUMBER)
3791: IS SELECT DNZ_CHR_ID

Line 3792: FROM Okc_K_Lines_b

3788: WHERE Id=P_cle_Id;
3789:
3790: CURSOR Child_Cur(P_cle_Id IN NUMBER)
3791: IS SELECT DNZ_CHR_ID
3792: FROM Okc_K_Lines_b
3793: WHERE cle_Id=P_cle_Id;
3794:
3795: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
3796: IS SELECT ID,DNZ_CHR_ID

Line 3797: FROM Okc_K_Lines_b

3793: WHERE cle_Id=P_cle_Id;
3794:
3795: CURSOR Child_Cur1(P_Parent_Id IN NUMBER)
3796: IS SELECT ID,DNZ_CHR_ID
3797: FROM Okc_K_Lines_b
3798: WHERE cle_Id=P_Parent_Id;
3799:
3800: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
3801: IS SELECT ID,DNZ_CHR_ID

Line 3802: FROM Okc_K_Lines_b

3798: WHERE cle_Id=P_Parent_Id;
3799:
3800: CURSOR Child_Cur2(P_Parent_Id IN NUMBER)
3801: IS SELECT ID,DNZ_CHR_ID
3802: FROM Okc_K_Lines_b
3803: WHERE cle_Id=P_Parent_Id;
3804: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
3805: IS SELECT ID,DNZ_CHR_ID
3806: FROM Okc_K_Lines_b

Line 3806: FROM Okc_K_Lines_b

3802: FROM Okc_K_Lines_b
3803: WHERE cle_Id=P_Parent_Id;
3804: CURSOR Child_Cur3(P_Parent_Id IN NUMBER)
3805: IS SELECT ID,DNZ_CHR_ID
3806: FROM Okc_K_Lines_b
3807: WHERE cle_Id=P_Parent_Id;
3808: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
3809: IS SELECT ID,DNZ_CHR_ID
3810: FROM Okc_K_Lines_b

Line 3810: FROM Okc_K_Lines_b

3806: FROM Okc_K_Lines_b
3807: WHERE cle_Id=P_Parent_Id;
3808: CURSOR Child_Cur4(P_Parent_Id IN NUMBER)
3809: IS SELECT ID,DNZ_CHR_ID
3810: FROM Okc_K_Lines_b
3811: WHERE cle_Id=P_Parent_Id;
3812: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
3813: IS SELECT ID,DNZ_CHR_ID
3814: FROM Okc_K_Lines_b

Line 3814: FROM Okc_K_Lines_b

3810: FROM Okc_K_Lines_b
3811: WHERE cle_Id=P_Parent_Id;
3812: CURSOR Child_Cur5(P_Parent_Id IN NUMBER)
3813: IS SELECT ID,DNZ_CHR_ID
3814: FROM Okc_K_Lines_b
3815: WHERE cle_Id=P_Parent_Id;
3816:
3817: CURSOR Item_Cur(P_Line_Id IN NUMBER)
3818: IS SELECT ID

Line 4284: delete okc_k_lines_b where

4280: loop
4281: BEGIN
4282: delete okc_k_lines_tl where
4283: id =l_clev_tbl_in(i).id;
4284: delete okc_k_lines_b where
4285: id =l_clev_tbl_in(i).id;
4286:
4287: EXCEPTION
4288: WHEN OTHERS THEN

Line 4467: FROM OKC_K_LINES_B lines,

4463: NVL(kines.offset_duration,0) offset_duration,
4464: NVL(kines.offset_period,0) offset_period,
4465: NVL(kines.allow_bt_discount,0) allow_bt_discount,
4466: NVL(kines.apply_default_timezone,0) apply_default_timezone
4467: FROM OKC_K_LINES_B lines,
4468: OKC_K_ITEMS items,
4469: OKS_K_LINES_B kines
4470: WHERE lines.cle_id = p_cle_id
4471: AND lines.id = items.cle_id

Line 4497: FROM OKC_K_LINES_B lines,

4493: covtm.thursday_yn thursday_yn,
4494: covtm.friday_yn friday_yn,
4495: covtm.saturday_yn saturday_yn,
4496: covtm.sunday_yn sunday_yn
4497: FROM OKC_K_LINES_B lines,
4498: OKC_K_ITEMS items,
4499: OKS_COVERAGE_TIMEZONES covtz,
4500: OKS_COVERAGE_TIMES covtm
4501: WHERE lines.id = p_id

Line 4533: FROM OKC_K_LINES_B lines,

4529: NVL(acm.wed_duration,0) wed_duration,
4530: NVL(acm.thu_duration,0) thu_duration,
4531: NVL(acm.fri_duration,0) fri_duration,
4532: NVL(acm.sat_duration,0) sat_duration
4533: FROM OKC_K_LINES_B lines,
4534: OKS_K_LINES_V oksl,
4535: OKS_ACTION_TIME_TYPES act,
4536: OKS_ACTION_TIMES acm
4537: WHERE lines.cle_id = p_cle_id

Line 6087: OKC_K_LINES_B lines1,

6083: rules.rule_information3 percent_over_list_price, -- %over_list_price
6084: rules.rule_information4 bill_rate_code, -- bill_rate_code
6085: NVL(rules.TEMPLATE_YN,'N') TEMPLATE_YN
6086: FROM
6087: OKC_K_LINES_B lines1,
6088: OKC_K_LINES_B lines2,
6089: OKC_RULE_GROUPS_B orgb,
6090: OKC_RULES_B rules
6091: WHERE

Line 6088: OKC_K_LINES_B lines2,

6084: rules.rule_information4 bill_rate_code, -- bill_rate_code
6085: NVL(rules.TEMPLATE_YN,'N') TEMPLATE_YN
6086: FROM
6087: OKC_K_LINES_B lines1,
6088: OKC_K_LINES_B lines2,
6089: OKC_RULE_GROUPS_B orgb,
6090: OKC_RULES_B rules
6091: WHERE
6092: lines1.lse_id IN (5,23,59)

Line 6302: OKC_K_LINES_B lines1,

6298: bills.last_update_login last_update_login,
6299: bills.security_group_id security_group_id,
6300: bills.object_version_number object_version_number--Added
6301: FROM
6302: OKC_K_LINES_B lines1,
6303: OKC_K_LINES_B lines2,
6304: OKC_K_LINES_B lines3,
6305: OKC_K_ITEMS items,
6306: OKC_RULE_GROUPS_B orgb,

Line 6303: OKC_K_LINES_B lines2,

6299: bills.security_group_id security_group_id,
6300: bills.object_version_number object_version_number--Added
6301: FROM
6302: OKC_K_LINES_B lines1,
6303: OKC_K_LINES_B lines2,
6304: OKC_K_LINES_B lines3,
6305: OKC_K_ITEMS items,
6306: OKC_RULE_GROUPS_B orgb,
6307: OKC_RULES_B rules,

Line 6304: OKC_K_LINES_B lines3,

6300: bills.object_version_number object_version_number--Added
6301: FROM
6302: OKC_K_LINES_B lines1,
6303: OKC_K_LINES_B lines2,
6304: OKC_K_LINES_B lines3,
6305: OKC_K_ITEMS items,
6306: OKC_RULE_GROUPS_B orgb,
6307: OKC_RULES_B rules,
6308: OKS_BILLRATE_SCHEDULES bills

Line 6443: ELSE -- create lines in okc_k_lines_b, oks_billrate_schedules

6439: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6440: RAISE G_EXCEPTION_BRS_UPDATE ;
6441: END IF;
6442:
6443: ELSE -- create lines in okc_k_lines_b, oks_billrate_schedules
6444:
6445: INIT_CONTRACT_LINE(l_clev_tbl_in);
6446: INIT_BILL_RATE_LINE(l_bill_rate_tbl_in) ;
6447:

Line 6753: okc_k_lines_b lines1, --Modified by Jvorugan for Bug:4560735

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;
6757: --AND lines1.lse_id =1

Line 6754: okc_k_lines_b lines2

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;
6757: --AND lines1.lse_id =1
6758: --AND lines2.lse_id = 1;

Line 6943: -- get the original system_id1 from okc_k_lines_b

6939:
6940: l_old_object1_id1 NUMBER := 0;
6941: l_old_line_number NUMBER := 0;
6942: l_new_Bp_Object1_ID1 NUMBER := 0;
6943: -- get the original system_id1 from okc_k_lines_b
6944:
6945: CURSOR CUR_GET_ORIG_SYS_ID1(p_id IN NUMBER) IS
6946: SELECT ORIG_SYSTEM_ID1
6947: FROM OKC_K_LINES_B

Line 6947: FROM OKC_K_LINES_B

6943: -- get the original system_id1 from okc_k_lines_b
6944:
6945: CURSOR CUR_GET_ORIG_SYS_ID1(p_id IN NUMBER) IS
6946: SELECT ORIG_SYSTEM_ID1
6947: FROM OKC_K_LINES_B
6948: WHERE ID = p_id ;
6949: -- get the coverage details for the coverage line added by jvorugan
6950: CURSOR CUR_GET_COV_DET(p_id IN NUMBER) IS
6951: SELECT ID,DNZ_CHR_ID, START_DATE, END_DATE

Line 6952: FROM OKC_K_LINES_B

6948: WHERE ID = p_id ;
6949: -- get the coverage details for the coverage line added by jvorugan
6950: CURSOR CUR_GET_COV_DET(p_id IN NUMBER) IS
6951: SELECT ID,DNZ_CHR_ID, START_DATE, END_DATE
6952: FROM OKC_K_LINES_B
6953: WHERE id = p_id;
6954:
6955: cr_cov_det CUR_GET_COV_DET%ROWTYPE;
6956:

Line 6966: SELECT count(*) FROM OKC_K_LINES_B

6962:
6963:
6964: -- check whether the coverage is template added by jvorugan
6965: CURSOR check_cov_tmpl(p_cov_id IN Number) IS
6966: SELECT count(*) FROM OKC_K_LINES_B
6967: WHERE id = p_cov_id
6968: AND lse_id in (2,15,20)
6969: and dnz_chr_id < 0;
6970:

Line 6975: FROM OKC_K_LINES_B

6971: -- get the coverage id for the service line
6972:
6973: CURSOR CUR_GET_COV_LINE_ID(p_contract_line_id IN NUMBER) IS
6974: SELECT ID,DNZ_CHR_ID, START_DATE, END_DATE
6975: FROM OKC_K_LINES_B
6976: WHERE cle_id = p_contract_line_id
6977: AND lse_id IN (2,15,20);
6978:
6979: cr_cov_line cur_get_cov_line_id%ROWTYPE;

Line 7002: FROM okc_k_lines_b lines1,

6998: oks.offset_duration offset_duration,
6999: oks.allow_bt_discount allow_bt_discount,
7000: oks.apply_default_timezone apply_default_timezone,
7001: oks.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7002: FROM okc_k_lines_b lines1,
7003: oks_k_lines_b oks,
7004: okc_k_items items
7005: WHERE lines1.cle_id = p_cle_id
7006: AND items.cle_id = lines1.id

Line 7024: FROM okc_k_lines_b lines1,

7020: oks.offset_duration offset_duration,
7021: oks.allow_bt_discount allow_bt_discount,
7022: oks.apply_default_timezone apply_default_timezone,
7023: oks.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7024: FROM okc_k_lines_b lines1,
7025: oks_k_lines_b oks
7026: WHERE lines1.cle_id = p_cle_id
7027: AND oks.cle_id = lines1.id
7028: AND lines1.lse_id IN (3,16,21);

Line 7033: FROM okc_k_lines_b lines1,

7029: /*
7030: CURSOR CUR_GET_NEW_BP(p_cle_id IN NUMBER ,P_Object1_Id1 IN NUMBER , p_old_bp_id in number) IS
7031: SELECT lines1.id bp_line_id, lines1.dnz_chr_id dnz_chr_id,lines1.start_date start_date, lines1.end_date end_date,
7032: to_number(items.object1_id1) object1_id1
7033: FROM okc_k_lines_b lines1,
7034: okc_k_items items
7035: WHERE lines1.cle_id = p_cle_id
7036: AND items.cle_id = lines1.id
7037: AND items.jtot_object1_code = 'OKX_BUSIPROC'

Line 7047: FROM okc_k_lines_b lines1

7043: -- CURSOR CUR_GET_NEW_BP modified for bug#4155384 - smohapat
7044:
7045: CURSOR CUR_GET_NEW_BP(p_cle_id IN NUMBER , p_old_bp_id in number) IS
7046: SELECT lines1.id bp_line_id, lines1.dnz_chr_id dnz_chr_id,lines1.start_date start_date, lines1.end_date end_date
7047: FROM okc_k_lines_b lines1
7048: WHERE lines1.cle_id = p_cle_id
7049: AND lines1.lse_id IN (3,16,21)
7050: AND lines1.orig_system_id1 = p_old_bp_id ;
7051:

Line 7070: FROM okc_k_lines_b lines1,

7066: oks.offset_duration offset_duration,
7067: oks.allow_bt_discount allow_bt_discount,
7068: oks.apply_default_timezone apply_default_timezone,
7069: oks.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
7070: FROM okc_k_lines_b lines1,
7071: oks_k_lines_v oks
7072: WHERE lines1.cle_id = p_cle_id
7073: AND oks.cle_id = lines1.id
7074: AND lines1.lse_id IN (4,17,22)

Line 7083: FROM okc_k_lines_b BT,

7079: l_orig_system_id1 IN NUMBER) IS
7080:
7081: SELECT RT.ID,
7082: RT.DNZ_CHR_ID
7083: FROM okc_k_lines_b BT,
7084: okc_k_lines_B RT,
7085: okc_k_items BT_Item
7086: WHERE BT.id = P_Bp_line_Id
7087: AND BT.dnz_chr_id = P_new_dnz_chr_id

Line 7084: okc_k_lines_B RT,

7080:
7081: SELECT RT.ID,
7082: RT.DNZ_CHR_ID
7083: FROM okc_k_lines_b BT,
7084: okc_k_lines_B RT,
7085: okc_k_items BT_Item
7086: WHERE BT.id = P_Bp_line_Id
7087: AND BT.dnz_chr_id = P_new_dnz_chr_id
7088: AND BT.lse_id IN (3,16,21)

Line 7102: FROM okc_k_lines_b RT

7098: -- CURSOR CUR_GET_NEW_RT modified for bug#4155384 - smohapat
7099: CURSOR CUR_GET_NEW_RT(p_bp_line_id IN NUMBER,p_old_rt_id in number) IS
7100: SELECT RT.ID,
7101: RT.DNZ_CHR_ID
7102: FROM okc_k_lines_b RT
7103: WHERE RT.cle_id = p_bp_line_id
7104: AND RT.lse_id in(4,17,22)
7105: AND RT.orig_system_id1 = p_old_rt_id;
7106:

Line 7148: FROM okc_k_lines_b lines1,

7144: to_number(items1.object1_id1) busi_proc_id,
7145: to_number(items2.object1_id1) bill_type_id,
7146: oks.discount_amount discount_amount,
7147: oks.discount_percent discount_percent
7148: FROM okc_k_lines_b lines1,
7149: okc_k_lines_b lines2,
7150: oks_k_lines_b oks,
7151: okc_k_items items1,
7152: okc_k_items items2

Line 7149: okc_k_lines_b lines2,

7145: to_number(items2.object1_id1) bill_type_id,
7146: oks.discount_amount discount_amount,
7147: oks.discount_percent discount_percent
7148: FROM okc_k_lines_b lines1,
7149: okc_k_lines_b lines2,
7150: oks_k_lines_b oks,
7151: okc_k_items items1,
7152: okc_k_items items2
7153: WHERE lines1.id = p_id

Line 7176: FROM okc_k_lines_b lines1,

7172: lines2.object_version_number object_version_number,
7173: lines1.line_number line_number,
7174: lines2.discount_amount discount_amount,
7175: lines2.discount_percent discount_percent
7176: FROM okc_k_lines_b lines1,
7177: oks_k_lines_b lines2
7178: WHERE lines1.cle_id = p_bp_id
7179: AND lines2.cle_id = lines1.id
7180: AND lines1.lse_id IN (5,23,59);

Line 7190: FROM okc_k_lines_b lines1,

7186: lines2.id bt_line_id, lines2.dnz_chr_id dnz_chr_id,
7187: lines2.object_version_number object_version_number,
7188: to_number(items1.object1_id1) busi_proc_id,
7189: to_number(items2.object1_id1) bill_type_id
7190: FROM okc_k_lines_b lines1,
7191: okc_k_lines_b lines2,
7192: okc_k_items items1,
7193: okc_k_items items2
7194: WHERE lines1.id = p_id

Line 7191: okc_k_lines_b lines2,

7187: lines2.object_version_number object_version_number,
7188: to_number(items1.object1_id1) busi_proc_id,
7189: to_number(items2.object1_id1) bill_type_id
7190: FROM okc_k_lines_b lines1,
7191: okc_k_lines_b lines2,
7192: okc_k_items items1,
7193: okc_k_items items2
7194: WHERE lines1.id = p_id
7195: AND lines2.cle_id = lines1.id

Line 7216: FROM okc_k_lines_b BT

7212:
7213: CURSOR CUR_GET_NEW_BT(p_bp_line_id IN NUMBER,p_old_bt_id in number) IS
7214: SELECT BT.id bt_line_id, BT.start_date start_date,BT.dnz_chr_id,
7215: BT.end_date end_date,BT.object_version_number
7216: FROM okc_k_lines_b BT
7217: WHERE BT.cle_id = p_bp_line_id
7218: AND BT.lse_id IN (5,23,59)
7219: AND BT.orig_system_id1 = p_old_bt_id;
7220:

Line 7251: FROM okc_k_lines_b BTY,

7247: BRS.uom uom,
7248: BRS.holiday_yn holiday_yn,
7249: BRS.percent_over_list_price percent_over_list_price,
7250: BRS.object_version_number object_version_number --Added
7251: FROM okc_k_lines_b BTY,
7252: okc_k_lines_b BRT,
7253: okc_k_items BTY_ITEM,
7254: oks_billrate_schedules BRS
7255: WHERE BTY.id = p_id --274672627862321176435113785401106834939--

Line 7252: okc_k_lines_b BRT,

7248: BRS.holiday_yn holiday_yn,
7249: BRS.percent_over_list_price percent_over_list_price,
7250: BRS.object_version_number object_version_number --Added
7251: FROM okc_k_lines_b BTY,
7252: okc_k_lines_b BRT,
7253: okc_k_items BTY_ITEM,
7254: oks_billrate_schedules BRS
7255: WHERE BTY.id = p_id --274672627862321176435113785401106834939--
7256: AND BTY.lse_id IN (5,23,59)

Line 7307: FROM okc_k_lines_b BTY,

7303: BTY.line_number line_number,
7304: BRT.ID BR_LINE_ID,
7305: BRT.dnz_chr_id dnz_chr_id,
7306: TO_NUMBER(BTY_ITEM.object1_id1) bill_type_id
7307: FROM okc_k_lines_b BTY,
7308: okc_k_lines_b BRT,
7309: okc_k_items BTY_ITEM
7310: WHERE BTY.id =p_id
7311: -- AND BTY.line_Number = p_line_number

Line 7308: okc_k_lines_b BRT,

7304: BRT.ID BR_LINE_ID,
7305: BRT.dnz_chr_id dnz_chr_id,
7306: TO_NUMBER(BTY_ITEM.object1_id1) bill_type_id
7307: FROM okc_k_lines_b BTY,
7308: okc_k_lines_b BRT,
7309: okc_k_items BTY_ITEM
7310: WHERE BTY.id =p_id
7311: -- AND BTY.line_Number = p_line_number
7312: AND BTY.lse_id IN (5,23,59)

Line 7328: FROM okc_k_lines_b BRT

7324: CURSOR CUR_GET_NEW_BILL_RATE(p_bt_id IN NUMBER,p_old_brs_id IN NUMBER)IS
7325: SELECT BRT.ID BRS_LINE_ID,
7326: BRT.CLE_ID BRS_CLE_LINE_ID,
7327: BRT.dnz_chr_id dnz_chr_id
7328: FROM okc_k_lines_b BRT
7329: WHERE BRT.cle_id = p_bt_id
7330: AND BRT.lse_id IN (6,24,60)
7331: AND BRT.orig_system_id1 = p_old_brs_id;
7332:

Line 7340: FROM okc_k_lines_b lines1,

7336: CURSOR CUR_GET_OLD_BUSI_PROC(p_cle_id IN NUMBER)
7337: IS
7338: SELECT lines1.id OLD_BP_LINE_ID,
7339: to_number(items.object1_id1) old_busi_proc_id
7340: FROM okc_k_lines_b lines1,
7341: okc_k_items items
7342: WHERE lines1.cle_id = p_cle_id
7343: AND lines1.lse_id IN (3,16,21)
7344: AND items.cle_id = lines1.id

Line 7355: FROM OKC_K_LINES_B lines1,

7351: SELECT tze.id timezone_line_id, tze.cle_id timezone_cle_id,
7352: tze.timezone_id timezone_id,tze.default_yn default_yn,
7353: tze.dnz_chr_id tze_dnz_chr_id,tze.object_version_number tze_object_version_number,
7354: to_number(items.object1_id1) busi_proc_id
7355: FROM OKC_K_LINES_B lines1,
7356: okc_k_items items,
7357: oks_coverage_timezones tze
7358: WHERE lines1.id = p_id
7359: AND lines1.cle_id = p_cle_id

Line 7404: FROM okc_k_lines_b lines1,

7400: CURSOR CUR_GET_NEW_BUSI_PROC_ID(p_cle_id IN NUMBER, p_busi_proc_id IN NUMBER)
7401: IS
7402: SELECT lines1.id NEW_BP_LINE_ID, lines1.dnz_chr_id new_dnz_chr_id,
7403: to_number(items1.object1_id1) busi_proc_id
7404: FROM okc_k_lines_b lines1,
7405: okc_k_items items1
7406: WHERE lines1.cle_id = p_cle_id
7407: AND lines1.lse_id IN (3,16,21)
7408: AND items1.cle_id = lines1.id

Line 7418: FROM okc_k_lines_b

7414:
7415: CURSOR Bill_rate_CUR (P_ID IN NUMBER,P_Dnz_Chr_ID IN NUMBER) IS
7416: SELECT id,
7417: dnz_chr_id
7418: FROM okc_k_lines_b
7419: WHERE cle_id = p_id
7420: AND dnz_chr_id = P_Dnz_Chr_ID;
7421:
7422:

Line 9370: Select id,dnz_chr_id from OKC_K_LINES_B

9366: -- OKS_PM_ACTIVITIES --
9367: -- End Preventive Maintainance --
9368:
9369: Cursor Cur_react_time (p_id NUMBER) IS
9370: Select id,dnz_chr_id from OKC_K_LINES_B
9371: Where cle_id = p_id
9372: And Lse_id in (4,17);
9373:
9374: Cursor cur_act_times (p_id NUMBER) IS

Line 9405: SELECT id,dnz_chr_id from okc_k_lines_b

9401:
9402: -- Business Process --
9403:
9404: CURSOR csr_BP_id(l_cle_id NUMBER) IS
9405: SELECT id,dnz_chr_id from okc_k_lines_b
9406: WHERE cle_id = l_cle_id
9407: AND LSE_ID IN (3,16);
9408:
9409: -- End Business Process--

Line 9425: Select id,dnz_chr_id from OKC_K_LINES_B

9421: Where cpl_id = p_id;
9422:
9423: -- Billing Type --
9424: Cursor cur_bill_type (p_id NUMBER) IS
9425: Select id,dnz_chr_id from OKC_K_LINES_B
9426: where cle_id=p_id
9427: and lse_id in ( 5,59,23);
9428:
9429: Cursor cur_item (p_id NUMBER) IS

Line 9443: Select id,dnz_chr_id from OKC_K_LINES_B

9439: Select id,dnz_chr_id,object_version_number from OKS_BILLRATE_SCHEDULES
9440: Where CLE_ID =p_id;
9441:
9442: Cursor cur_bill_rate (p_id NUMBER) IS
9443: Select id,dnz_chr_id from OKC_K_LINES_B
9444: where cle_id=p_id
9445: and lse_id in (6,60,24);
9446: -- End Bill Rate --
9447: -- Coverage_id --

Line 9449: Select dnz_chr_id from OKC_K_LINES_B

9445: and lse_id in (6,60,24);
9446: -- End Bill Rate --
9447: -- Coverage_id --
9448: Cursor Cur_Coverage (p_id NUMBER) IS
9449: Select dnz_chr_id from OKC_K_LINES_B
9450: where id =p_id ;
9451: -- End Coverage id --
9452:
9453:

Line 10137: FROM OKC_K_LINES_B

10133:
10134: CURSOR CUR_GET_LINE_DATES IS
10135: SELECT start_date,
10136: end_date
10137: FROM OKC_K_LINES_B
10138: WHERE ID = p_tgt_line_id; --p_contract_line_id;
10139:
10140: -- Modified by Jvorugan for Bug:4610475. Added pm_sch_exists_yn,pm_conf_req_yn
10141: CURSOR CUR_CHECK_PM_PROG IS

Line 10149: FROM OKC_K_LINES_B

10145:
10146: -- Added by Jvorugan
10147: CURSOR CUR_GET_LSE_ID IS
10148: SELECT lse_id
10149: FROM OKC_K_LINES_B
10150: WHERE ID = p_src_line_id; --p_standard_cov_id;
10151:
10152: GET_LSE_ID_REC CUR_GET_LSE_ID%ROWTYPE;
10153:

Line 10391: SELECT id from okc_k_lines_b

10387: x_new_coverage_id OUT NOCOPY NUMBER) IS
10388:
10389: -----------------------------------------------
10390: CURSOR CUR_GET_LINE_ID(p_cle_id NUMBER) is
10391: SELECT id from okc_k_lines_b
10392: where cle_id=p_cle_id;
10393:
10394: -----------------------------------------------
10395: CURSOR Cur_childline(P_cle_Id IN NUMBER)

Line 10398: FROM OKC_K_LINES_B

10394: -----------------------------------------------
10395: CURSOR Cur_childline(P_cle_Id IN NUMBER)
10396: IS
10397: SELECT ID,lse_id
10398: FROM OKC_K_LINES_B
10399: WHERE cle_Id=P_cle_Id;
10400: -----------------------------------------------
10401: CURSOR CUR_ItemDet(P_Id IN NUMBER) IS
10402: SELECT ID

Line 10408: FROM OKC_K_LINES_B

10404: WHERE cle_Id=P_Id;
10405: ------------------------------------------------
10406: CURSOR Cur_childline1(P_cle_Id IN NUMBER) IS
10407: SELECT ID,lse_id
10408: FROM OKC_K_LINES_B
10409: WHERE cle_Id=P_cle_Id ;
10410: -------------------------------------------------
10411: CURSOR Cur_PTRLDet(P_Cle_Id IN NUMBER,
10412: P_role_Code IN varchar2) IS

Line 10415: OKC_K_LINES_B lv

10411: CURSOR Cur_PTRLDet(P_Cle_Id IN NUMBER,
10412: P_role_Code IN varchar2) IS
10413: SELECT pr.ID
10414: FROM OKC_K_Party_Roles_V pr,
10415: OKC_K_LINES_B lv
10416: WHERE pr.cle_ID=p_cle_Id
10417: AND pr.Rle_Code=P_Role_Code
10418: AND pr.cle_id = lv.id
10419: AND pr.dnz_chr_id = lv.dnz_chr_id ;

Line 10430: FROM OKC_K_LINES_B

10426: WHERE cpl_id=P_cpl_Id;
10427: -------------------------------------------------
10428: CURSOR Cur_childline_br(P_cle_Id IN NUMBER) IS
10429: SELECT ID
10430: FROM OKC_K_LINES_B
10431: WHERE cle_Id=P_cle_Id;
10432: -------------------------------------------------
10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;

Line 10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;

10429: SELECT ID
10430: FROM OKC_K_LINES_B
10431: WHERE cle_Id=P_cle_Id;
10432: -------------------------------------------------
10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;

Line 10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;

10430: FROM OKC_K_LINES_B
10431: WHERE cle_Id=P_cle_Id;
10432: -------------------------------------------------
10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10438: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;

Line 10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;

10431: WHERE cle_Id=P_cle_Id;
10432: -------------------------------------------------
10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10438: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10439: l_old_rt_id OKC_K_LINES_B.ID%TYPE;

Line 10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;

10432: -------------------------------------------------
10433: l_old_coverage_id OKC_K_LINES_B.ID%TYPE;
10434: l_new_coverage_id OKC_K_LINES_B.ID%TYPE;
10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10438: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10439: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10440: l_new_rt_id OKC_K_LINES_B.ID%TYPE;

Line 10439: l_old_rt_id OKC_K_LINES_B.ID%TYPE;

10435: l_old_bp_id OKC_K_LINES_B.ID%TYPE;
10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10438: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10439: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10440: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10441: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10442: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

Line 10440: l_new_rt_id OKC_K_LINES_B.ID%TYPE;

10436: l_new_bp_id OKC_K_LINES_B.ID%TYPE;
10437: l_old_bp_item_id OKC_K_ITEMS.ID%TYPE;
10438: l_new_bp_item_id OKC_K_ITEMS.ID%TYPE;
10439: l_old_rt_id OKC_K_LINES_B.ID%TYPE;
10440: l_new_rt_id OKC_K_LINES_B.ID%TYPE;
10441: l_new_rt_item_id OKC_K_ITEMS.ID%TYPE;
10442: l_old_rt_item_id OKC_K_ITEMS.ID%TYPE;
10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;

Line 10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;

10443: l_old_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;

Line 10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;

10444: l_new_party_id OKC_K_PARTY_ROLES_B.ID%TYPE;
10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;
10452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;

10445: l_old_contact_id OKC_CONTACTS.ID%TYPE;
10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;
10452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10453:

Line 10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;

10446: l_new_contact_id OKC_CONTACTS.ID%TYPE;
10447: l_old_bt_id OKC_K_LINES_B.ID%TYPE;
10448: l_new_bt_id OKC_K_LINES_B.ID%TYPE;
10449: l_old_br_id OKC_K_LINES_B.ID%TYPE;
10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;
10452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10453:
10454: -- This function is called by copy_standard_coverage for insertion into okc_k_lines_b table

Line 10454: -- This function is called by copy_standard_coverage for insertion into okc_k_lines_b table

10450: l_new_br_id OKC_K_LINES_B.ID%TYPE;
10451: l_cov_flag NUMBER;
10452: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
10453:
10454: -- This function is called by copy_standard_coverage for insertion into okc_k_lines_b table
10455: FUNCTION CREATE_OKC_LINE(p_new_line_id NUMBER,
10456: p_old_line_id NUMBER,
10457: p_flag NUMBER,
10458: p_cle_id NUMBER DEFAULT NULL) return VARCHAR2 IS

Line 10476: INSERT INTO okc_k_lines_b

10472: l_start_date :=NULL;
10473: l_coverage_name := NULL;
10474: END IF;
10475:
10476: INSERT INTO okc_k_lines_b
10477: (
10478: ID,
10479: LINE_NUMBER,
10480: CHR_ID,

Line 10667: FROM okc_k_lines_b

10663: -- CANC_REASON_CODE,
10664: -- TRXN_EXTENSION_ID,
10665: TERM_CANCEL_SOURCE,
10666: ANNUALIZED_FACTOR
10667: FROM okc_k_lines_b
10668: WHERE id = p_old_line_id;
10669:
10670: INSERT INTO okc_k_lines_tl
10671: ( ID,