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 OKS_K_LINES_B

Line 700: FROM OKS_K_LINES_B

696: -------------------------------------------------------------------------------
697: -- get the pm_program_id associated with the service line added by jvorugan for R12 bug:4610449
698: CURSOR CUR_GET_PROGRAM_ID(p_contract_line_id IN NUMBER) IS
699: SELECT PM_PROGRAM_ID
700: FROM OKS_K_LINES_B
701: WHERE cle_id =p_contract_line_id;
702:
703: -------------------------------------------------------------------------------
704: CURSOR Get_cov_timezones(p_cle_id IN Number) IS

Line 2326: FROM oks_k_lines_b

2322: -- End of Bug:4535339 by Jvorugan
2323:
2324: CURSOR k_line_cur(p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2325: SELECT ID,DNZ_CHR_ID
2326: FROM oks_k_lines_b
2327: WHERE cle_id = p_Id
2328: AND dnz_chr_id = p_dnz_chr_id;
2329:
2330: CURSOR Time_Zone_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS

Line 3484: FROM OKS_K_LINES_B

3480:
3481: -- Cursor for getting offset period for BP from OKS
3482: CURSOR cur_get_offset_bp(p_cle_id IN NUMBER) IS
3483: SELECT ID, OFFSET_DURATION, OFFSET_PERIOD
3484: FROM OKS_K_LINES_B
3485: WHERE CLE_ID = p_cle_id ;
3486:
3487: oks_offset_rec CUR_GET_OFFSET_BP%ROWTYPE;
3488: ------------------------------------------------

Line 4406: FROM OKS_K_LINES_B

4402:
4403: -- First compare coverage
4404: Cursor Cur_get_cov_info(p_contract_line_id NUMBER) IS
4405: SELECT coverage_id, standard_cov_yn
4406: FROM OKS_K_LINES_B
4407: WHERE cle_id = p_contract_line_id;
4408: -- get the coverage info
4409:
4410: Cursor Cur_Get_Cov_details(p_cov_line_id NUMBER) IS

Line 4426: FROM OKS_K_LINES_B

4422: PROD_UPGRADE_YN
4423: /* COmmented by Jvorugan for Bug:4610449 NVL(PM_PROGRAM_ID,0) PM_PROGRAM_ID,
4424: NVL(PM_CONF_REQ_YN,0) PM_CONF_REQ_YN,
4425: NVL(PM_SCH_EXISTS_YN,0) PM_SCH_EXISTS_YN */
4426: FROM OKS_K_LINES_B
4427: WHERE CLE_ID = p_cov_line_id;
4428:
4429: Source_Coverage_rules Get_Coverage_rules%ROWTYPE;
4430: Target_Coverage_rules Get_Coverage_rules%ROWTYPE;

Line 4433: -- Cursor to get the PM info. With R12, PM info will be stored with oks_k_lines_b record for the topline

4429: Source_Coverage_rules Get_Coverage_rules%ROWTYPE;
4430: Target_Coverage_rules Get_Coverage_rules%ROWTYPE;
4431:
4432: --Added by Jvorugan for Bug:4610449
4433: -- Cursor to get the PM info. With R12, PM info will be stored with oks_k_lines_b record for the topline
4434: Cursor Get_PM_rules(p_contract_line_id NUMBER) IS
4435: Select NVL(PM_PROGRAM_ID,0) PM_PROGRAM_ID,
4436: NVL(PM_CONF_REQ_YN,0) PM_CONF_REQ_YN,
4437: NVL(PM_SCH_EXISTS_YN,0) PM_SCH_EXISTS_YN

Line 4438: FROM OKS_K_LINES_B

4434: Cursor Get_PM_rules(p_contract_line_id NUMBER) IS
4435: Select NVL(PM_PROGRAM_ID,0) PM_PROGRAM_ID,
4436: NVL(PM_CONF_REQ_YN,0) PM_CONF_REQ_YN,
4437: NVL(PM_SCH_EXISTS_YN,0) PM_SCH_EXISTS_YN
4438: FROM OKS_K_LINES_B
4439: WHERE CLE_ID = p_contract_line_id;
4440:
4441: Source_PM_rules Get_PM_rules%ROWTYPE;
4442: Target_PM_rules Get_PM_rules%ROWTYPE;

Line 4469: OKS_K_LINES_B kines

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
4472: AND items.jtot_object1_code = 'OKX_BUSIPROC'
4473: AND lines.lse_id in (3,16,21)

Line 4580: OKS_K_LINES_B oksl,

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
4584: AND oksl.cle_id = lines.id

Line 4757: /* Commented by Jvorugan for Bug:4610449. With R12 Pm info will be stored with oks_k_lines_b

4753: OR (Source_Coverage_rules.EXCEPTION_COV_ID <> Target_Coverage_rules.EXCEPTION_COV_ID)
4754: OR (Source_Coverage_rules.TRANSFER_OPTION <> Target_Coverage_rules.TRANSFER_OPTION )
4755: OR (Source_Coverage_rules.PROD_UPGRADE_YN <> Target_Coverage_rules.PROD_UPGRADE_YN)
4756: OR (Source_Coverage_rules.INHERITANCE_TYPE <> Target_Coverage_rules.INHERITANCE_TYPE))
4757: /* Commented by Jvorugan for Bug:4610449. With R12 Pm info will be stored with oks_k_lines_b
4758: record associated with the service line.
4759: OR (Source_Coverage_rules.PM_PROGRAM_ID <> Target_Coverage_rules.PM_PROGRAM_ID )
4760: OR (Source_Coverage_rules.PM_CONF_REQ_YN <> Target_Coverage_rules.PM_CONF_REQ_YN )
4761: OR (Source_Coverage_rules.PM_SCH_EXISTS_YN <> Target_Coverage_rules.PM_SCH_EXISTS_YN)) */

Line 6960: FROM OKS_K_LINES_B

6956:
6957: -- get the pm_program_id associated with the service line added by jvorugan
6958: CURSOR CUR_GET_PROGRAM_ID(p_contract_line_id IN NUMBER) IS
6959: SELECT PM_PROGRAM_ID
6960: FROM OKS_K_LINES_B
6961: WHERE cle_id =p_contract_line_id;
6962:
6963:
6964: -- check whether the coverage is template added by jvorugan

Line 6981: -- get the coverage line attributes from oks_k_lines_b

6977: AND lse_id IN (2,15,20);
6978:
6979: cr_cov_line cur_get_cov_line_id%ROWTYPE;
6980:
6981: -- get the coverage line attributes from oks_k_lines_b
6982: CURSOR CUR_GET_COV_ATTR(p_cle_id IN NUMBER) IS
6983: SELECT ID, CLE_ID,
6984: COVERAGE_TYPE,EXCEPTION_COV_ID,SYNC_DATE_INSTALL,
6985: TRANSFER_OPTION, PROD_UPGRADE_YN,INHERITANCE_TYPE,

Line 6988: FROM OKS_K_LINES_B

6984: COVERAGE_TYPE,EXCEPTION_COV_ID,SYNC_DATE_INSTALL,
6985: TRANSFER_OPTION, PROD_UPGRADE_YN,INHERITANCE_TYPE,
6986: PM_PROGRAM_ID,
6987: PM_CONF_REQ_YN,PM_SCH_EXISTS_YN,object_version_number
6988: FROM OKS_K_LINES_B
6989: WHERE cle_id = p_cle_id ;
6990:
6991: -- get the old and new business process line details
6992: /*

Line 7003: oks_k_lines_b oks,

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
7007: AND items.jtot_object1_code = 'OKX_BUSIPROC'

Line 7025: oks_k_lines_b oks

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);
7029: /*

Line 7150: oks_k_lines_b oks,

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
7154: AND lines2.cle_id = lines1.id

Line 7177: oks_k_lines_b lines2

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);
7181:

Line 7433: checks if oks_k_lines_b record already exists and returns the status */

7429: l_pm_program_id NUMBER;
7430: l_oks_exist VARCHAR2(1);
7431:
7432: /* Added by jvorugan as part of Copy API Redesign,this function
7433: checks if oks_k_lines_b record already exists and returns the status */
7434: FUNCTION CHECK_OKSLINE_EXIST(p_new_cle_id NUMBER,
7435: x_oks_exist OUT NOCOPY VARCHAR2) return varchar2 is
7436:
7437: CURSOR check_line_exist IS

Line 7438: SELECT 1 FROM OKS_K_LINES_B

7434: FUNCTION CHECK_OKSLINE_EXIST(p_new_cle_id NUMBER,
7435: x_oks_exist OUT NOCOPY VARCHAR2) return varchar2 is
7436:
7437: CURSOR check_line_exist IS
7438: SELECT 1 FROM OKS_K_LINES_B
7439: WHERE cle_id = p_new_cle_id
7440: AND rownum=1;
7441:
7442: l_Count Number := 0;

Line 7544: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created

7540: END IF;
7541:
7542:
7543: IF l_old_cov_line_id IS NOT NULL AND l_new_cov_line_id IS NOT NULL THEN ---1
7544: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7545: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_new_cov_line_id,
7546: x_oks_exist =>l_oks_exist);
7547: IF (G_DEBUG_ENABLED = 'Y') THEN
7548: okc_debug.log('AFTER CHECK_OKSLINE_EXIST1'||l_return_status, 2);

Line 7638: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created

7634: l_klnv_tbl_in(i).CLE_ID := new_bp_rec.bp_line_id;
7635: l_klnv_tbl_in(i).DNZ_CHR_ID := new_bp_rec.dnz_chr_id;
7636:
7637: END LOOP ;
7638: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7639: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_new_Bp_line_Id,
7640: x_oks_exist =>l_oks_exist);
7641: IF (G_DEBUG_ENABLED = 'Y') THEN
7642: okc_debug.log('AFTER CHECK_OKSLINE_EXIST2'||l_return_status, 2);

Line 7805: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created

7801: l_klnv_tbl_in(l).CLE_ID := new_bp_rec.id;
7802: l_klnv_tbl_in(l).DNZ_CHR_ID := new_bp_rec.dnz_chr_id;
7803:
7804: END LOOP ; --2
7805: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7806: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(l).CLE_ID,
7807: x_oks_exist =>l_oks_exist);
7808:
7809: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 7976: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created

7972: l_klnv_tbl_in(i).dnz_chr_id := new_bt_rec.dnz_chr_id;
7973: l_klnv_tbl_in(i).object_version_number := new_bt_rec.object_version_number;
7974:
7975: END LOOP ;
7976: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
7977: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(i).cle_id,
7978: x_oks_exist =>l_oks_exist);
7979: IF (G_DEBUG_ENABLED = 'Y') THEN
7980: okc_debug.log('AFTER CHECK_OKSLINE_EXIST4'||l_return_status, 2);

Line 8023: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created

8019:
8020: FOR Bill_rate_REC IN Bill_rate_CUR (l_bill_Type_ID,l_bill_Type_Dnz_Chr_ID) LOOP
8021: l_klnv_tbl_in(I).CLE_ID := Bill_rate_REC.ID;
8022: l_klnv_tbl_in(I).DNZ_CHR_ID := Bill_rate_REC.DNZ_CHR_ID;
8023: -- Added by Jvorugan if oks_k_lines_b record already exists,then not created
8024: l_return_status := CHECK_OKSLINE_EXIST(p_new_cle_id =>l_klnv_tbl_in(I).CLE_ID,
8025: x_oks_exist =>l_oks_exist);
8026: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
8027: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 9330: -- OKS_K_LINES_B

9326: -- OKC_K_ITEMS
9327: l_cimv_tbl_in okc_contract_item_pub.cimv_tbl_type;
9328: l_cimv_tbl_out okc_contract_item_pub.cimv_tbl_type;
9329: --
9330: -- OKS_K_LINES_B
9331: l_klnv_tbl_in oks_contract_line_pub.klnv_tbl_type ;
9332: l_klnv_tbl_out oks_contract_line_pub.klnv_tbl_type ;
9333:
9334: l_timezone_tbl_in OKS_CTZ_PVT.OksCoverageTimezonesVTblType ;

Line 9673: -- OKS_K_LINES_B

9669: p_cimv_tbl => l_cimv_tbl_in,
9670: x_cimv_tbl => l_cimv_tbl_out );
9671: End if;
9672: -- End Contract Item
9673: -- OKS_K_LINES_B
9674: cnt1 :=0;
9675: For rec_line in cur_oks_id (rec_bp.id) LOOP
9676:
9677: If rec_line.dnz_chr_id <>p_dnz_chr_id then

Line 9698: -- End OKS_K_LINES_B --

9694: p_klnv_tbl => l_klnv_tbl_in,
9695: x_klnv_tbl => l_klnv_tbl_out,
9696: p_validate_yn => l_validate_yn);
9697: End if ;
9698: -- End OKS_K_LINES_B --
9699: cnt1 :=0;
9700:
9701: End Loop; -- end Loop BP
9702:

Line 10153: FROM OKS_K_LINES_B

10149:
10150: -- Modified by Jvorugan for Bug:4610475. Added pm_sch_exists_yn,pm_conf_req_yn
10151: CURSOR CUR_CHECK_PM_PROG IS
10152: SELECT pm_program_id,pm_sch_exists_yn,pm_conf_req_yn
10153: FROM OKS_K_LINES_B
10154: WHERE CLE_ID = p_src_line_id; --p_standard_cov_id; -- modified by Jvorugan Bug:4535339 ID = p_standard_cov_id;
10155:
10156: -- Added by Jvorugan
10157: CURSOR CUR_GET_LSE_ID IS

Line 10283: -- Update oks_k_lines_b record of the service line with the pm information.

10279: --(Now I am going to add this validation (IF condition) into CREATE_PM_PROGRAM_SCHEDULE for simplicity)
10280: IF l_pm_prog_id is not null then
10281: -- Added by Jvorugan for Bug:4610475
10282: -- From R12, PM will always be associated with service line instead of coverage.
10283: -- Update oks_k_lines_b record of the service line with the pm information.
10284: update oks_k_lines_b set pm_program_id =l_pm_prog_id,
10285: pm_sch_exists_yn=l_pm_sch_exists_yn,
10286: pm_conf_req_yn =l_pm_conf_req_yn
10287: where cle_id = p_tgt_line_id; --p_contract_line_id;

Line 10284: update oks_k_lines_b set pm_program_id =l_pm_prog_id,

10280: IF l_pm_prog_id is not null then
10281: -- Added by Jvorugan for Bug:4610475
10282: -- From R12, PM will always be associated with service line instead of coverage.
10283: -- Update oks_k_lines_b record of the service line with the pm information.
10284: update oks_k_lines_b set pm_program_id =l_pm_prog_id,
10285: pm_sch_exists_yn=l_pm_sch_exists_yn,
10286: pm_conf_req_yn =l_pm_conf_req_yn
10287: where cle_id = p_tgt_line_id; --p_contract_line_id;
10288: