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_BILLRATE_SCHEDULES

Line 614: FROM OKS_BILLRATE_SCHEDULES

610: LAST_UPDATE_DATE,
611: LAST_UPDATE_LOGIN,
612: SECURITY_GROUP_ID,
613: object_version_number --Added
614: FROM OKS_BILLRATE_SCHEDULES
615: WHERE CLE_ID = p_cle_id ;
616:
617: -------------------------------------------------
618:

Line 1918: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,

1914: p_init_msg_list => l_init_msg_list,
1915: x_return_status => l_return_status,
1916: x_msg_count => l_msg_count,
1917: x_msg_data => l_msg_data,
1918: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
1919: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
1920:
1921: IF (G_DEBUG_ENABLED = 'Y') THEN
1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);

Line 1919: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);

1915: x_return_status => l_return_status,
1916: x_msg_count => l_msg_count,
1917: x_msg_data => l_msg_data,
1918: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
1919: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
1920:
1921: IF (G_DEBUG_ENABLED = 'Y') THEN
1922: okc_debug.log('Exiting Create_Actual_Coverage', 2);
1923: okc_debug.Reset_Indentation;

Line 2291: OKS_BILLRATE_SCHEDULES BRS

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
2295: AND lines4.cle_id = lines3.id

Line 2357: FROM OKS_BILLRATE_SCHEDULES

2353: AND dnz_chr_id =p_dnz_chr_id;
2354:
2355: CURSOR Bill_Rate_Csr (p_ID IN NUMBER,p_DNZ_CHR_ID IN NUMBER) IS
2356: SELECT ID,DNZ_CHR_ID
2357: FROM OKS_BILLRATE_SCHEDULES
2358: WHERE CLE_ID = p_id
2359: AND dnz_chr_id =p_dnz_chr_id;
2360:
2361: l_brs_tbl_in OKS_BRS_PVT.OksBillrateSchedulesVTblType;

Line 2539: p_oks_billrate_schedules_v_tbl => l_brs_tbl_in);

2535: p_init_msg_list => l_init_msg_list,
2536: x_return_status => l_return_status,
2537: x_msg_count => l_msg_count,
2538: x_msg_data => l_msg_data,
2539: p_oks_billrate_schedules_v_tbl => l_brs_tbl_in);
2540:
2541: if not (l_return_status = OKC_API.G_RET_STS_SUCCESS) then
2542: RAISE e_Error;
2543: end if;

Line 2732: p_oks_billrate_schedules_v_tbl => l_brsv_tbl_in);

2728: p_init_msg_list => l_init_msg_list,
2729: x_return_status => l_return_status,
2730: x_msg_count => l_msg_count,
2731: x_msg_data => l_msg_data,
2732: p_oks_billrate_schedules_v_tbl => l_brsv_tbl_in);
2733:
2734:
2735:
2736: IF NOT (l_return_status = OKC_API.G_RET_STS_SUCCESS) then

Line 4616: FROM OKS_BILLRATE_SCHEDULES brs

4612: NVL(brs.FLAT_RATE,0)FLAT_RATE,
4613: NVL(brs.UOM,'N') UOM,
4614: NVL(brs.HOLIDAY_YN,'N') HOLIDAY_YN,
4615: NVL(brs.PERCENT_OVER_LIST_PRICE,0) PERC_OVER_LIST_PRICE
4616: FROM OKS_BILLRATE_SCHEDULES brs
4617: WHERE brs.bt_cle_id = p_bt_cle_id ;
4618:
4619:
4620: i NUMBER:= 0 ;

Line 5709: FROM OKS_BILLRATE_SCHEDULES_V

5705:
5706: CURSOR Cur_monday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5707: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5708: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5709: FROM OKS_BILLRATE_SCHEDULES_V
5710: WHERE BT_CLE_ID = l_bt_id
5711: AND MONDAY_FLAG = 'Y'
5712: AND holiday_yn = l_holiday;
5713:

Line 5717: FROM OKS_BILLRATE_SCHEDULES_V

5713:
5714: CURSOR Cur_tuesday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5715: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5716: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5717: FROM OKS_BILLRATE_SCHEDULES_V
5718: WHERE BT_CLE_ID = l_bt_id
5719: AND TUESDAY_FLAG = 'Y'
5720: AND holiday_yn = l_holiday;
5721:

Line 5725: FROM OKS_BILLRATE_SCHEDULES_V

5721:
5722: CURSOR Cur_wednesday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5723: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5724: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5725: FROM OKS_BILLRATE_SCHEDULES_V
5726: WHERE BT_CLE_ID = l_bt_id
5727: AND WEDNESDAY_FLAG = 'Y'
5728: AND holiday_yn = l_holiday;
5729:

Line 5733: FROM OKS_BILLRATE_SCHEDULES_V

5729:
5730: CURSOR Cur_thursday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5731: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5732: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5733: FROM OKS_BILLRATE_SCHEDULES_V
5734: WHERE BT_CLE_ID = l_bt_id
5735: AND THURSDAY_FLAG = 'Y'
5736: AND holiday_yn = l_holiday;
5737:

Line 5741: FROM OKS_BILLRATE_SCHEDULES_V

5737:
5738: CURSOR Cur_friday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5739: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5740: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5741: FROM OKS_BILLRATE_SCHEDULES_V
5742: WHERE BT_CLE_ID = l_bt_id
5743: AND FRIDAY_FLAG = 'Y'
5744: AND holiday_yn = l_holiday;
5745:

Line 5749: FROM OKS_BILLRATE_SCHEDULES_V

5745:
5746: CURSOR Cur_saturday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5747: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5748: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5749: FROM OKS_BILLRATE_SCHEDULES_V
5750: WHERE BT_CLE_ID = l_bt_id
5751: AND SATURDAY_FLAG = 'Y'
5752: AND holiday_yn = l_holiday;
5753:

Line 5757: FROM OKS_BILLRATE_SCHEDULES_V

5753:
5754: CURSOR Cur_sunday(l_bt_id IN NUMBER, l_holiday IN Varchar2) IS
5755: SELECT to_number(START_HOUR||decode(LENGTH(START_MINUTE),1,'0'||START_MINUTE,START_MINUTE)) start_time,
5756: to_number(END_HOUR||decode(LENGTH(END_MINUTE),1,'0'||END_MINUTE,END_MINUTE)) end_time
5757: FROM OKS_BILLRATE_SCHEDULES_V
5758: WHERE BT_CLE_ID = l_bt_id
5759: AND SUNDAY_FLAG = 'Y'
5760: AND holiday_yn = l_holiday;
5761:

Line 6165: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,

6161: p_init_msg_list => l_init_msg_list,
6162: x_return_status => l_return_status,
6163: x_msg_count => l_msg_count,
6164: x_msg_data => l_msg_data,
6165: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6166: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6167:
6168:
6169: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

Line 6166: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);

6162: x_return_status => l_return_status,
6163: x_msg_count => l_msg_count,
6164: x_msg_data => l_msg_data,
6165: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6166: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6167:
6168:
6169: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
6170: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 6183: UPDATE OKS_BILLRATE_SCHEDULES

6179: END LOOP ;
6180:
6181: IF l_check_Flag = 'N' THEN --Added
6182:
6183: UPDATE OKS_BILLRATE_SCHEDULES
6184: SET object_version_number = 1 ;
6185:
6186: END IF;
6187:

Line 6308: OKS_BILLRATE_SCHEDULES bills

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
6309: WHERE
6310: lines1.lse_id IN (3,16,21)
6311: and lines2.lse_id IN (5,23,59)
6312: and lines3.lse_id IN (6,24,60)

Line 6429: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,

6425: p_init_msg_list => p_init_msg_list,
6426: x_return_status => l_return_status,
6427: x_msg_count => l_msg_count,
6428: x_msg_data => l_msg_data,
6429: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');

Line 6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);

6426: x_return_status => l_return_status,
6427: x_msg_count => l_msg_count,
6428: x_msg_data => l_msg_data,
6429: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6430: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6431:
6432: IF fnd_global.conc_request_id <> -1 THEN
6433: fnd_file.put_line(FND_FILE.LOG, 'AFTER OKS_BRS_PVT.UPDATE_ROW......');
6434: fnd_file.put_line(FND_FILE.LOG, 'Return Status from OKS_BRS_PVT.UPDATE_ROW API...'||l_return_status);

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 6522: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,

6518: p_init_msg_list => l_init_msg_list,
6519: x_return_status => l_return_status,
6520: x_msg_count => l_msg_count,
6521: x_msg_data => l_msg_data,
6522: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6523: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6524:
6525: x_return_status := l_return_status;
6526:

Line 6523: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);

6519: x_return_status => l_return_status,
6520: x_msg_count => l_msg_count,
6521: x_msg_data => l_msg_data,
6522: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in,
6523: x_oks_billrate_schedules_v_tbl => x_bill_rate_tbl_out);
6524:
6525: x_return_status := l_return_status;
6526:
6527:

Line 7254: oks_billrate_schedules BRS

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)
7257: -- AND BRT.line_number = p_line_number
7258: AND BTY_ITEM.cle_id = BTY.id

Line 7293: FROM oks_billrate_schedules BRS

7289: BRS.uom uom,
7290: BRS.holiday_yn holiday_yn,
7291: BRS.percent_over_list_price percent_over_list_price,
7292: BRS.object_version_number object_version_number --Added
7293: FROM oks_billrate_schedules BRS
7294: WHERE BRS.bt_cle_id = p_id ;
7295:
7296:
7297:

Line 8096: p_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_in,

8092: p_init_msg_list => l_init_msg_list,
8093: x_return_status => l_return_status,
8094: x_msg_count => l_msg_count,
8095: x_msg_data => l_msg_data,
8096: p_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_in,
8097: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);
8098:
8099:
8100: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 8097: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);

8093: x_return_status => l_return_status,
8094: x_msg_count => l_msg_count,
8095: x_msg_data => l_msg_data,
8096: p_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_in,
8097: x_oks_billrate_schedules_v_tbl => l_billrate_sch_tbl_out);
8098:
8099:
8100: IF (G_DEBUG_ENABLED = 'Y') THEN
8101: okc_debug.log('After oks_brs_pvt insert_row'||l_return_status, 2);

Line 9035: DELETE OKS_BILLRATE_SCHEDULES_H

9031:
9032: DELETE OKS_COVERAGE_TIMEZONES_H
9033: WHERE dnz_chr_id = l_chr_id;
9034:
9035: DELETE OKS_BILLRATE_SCHEDULES_H
9036: WHERE dnz_chr_id = l_chr_id;
9037:
9038:
9039: OKS_PM_PROGRAMS_PVT.Delete_PMHistory(

Line 9138: DELETE OKS_BILLRATE_SCHEDULES_H

9134: DELETE OKS_COVERAGE_TIMEZONES_H
9135: WHERE dnz_chr_id = l_chr_id
9136: And major_version = -1;
9137:
9138: DELETE OKS_BILLRATE_SCHEDULES_H
9139: WHERE dnz_chr_id = l_chr_id
9140: And major_version = -1;
9141:
9142:

Line 9449: Select id,dnz_chr_id,object_version_number from OKS_BILLRATE_SCHEDULES

9445: -- End Billing Type --
9446:
9447: -- Bill Rate --
9448: Cursor cur_bill_sch (p_id NUMBER) IS
9449: Select id,dnz_chr_id,object_version_number from OKS_BILLRATE_SCHEDULES
9450: Where CLE_ID =p_id;
9451:
9452: Cursor cur_bill_rate (p_id NUMBER) IS
9453: Select id,dnz_chr_id from OKC_K_LINES_B

Line 10007: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in ,

10003: p_init_msg_list => l_init_msg_list,
10004: x_return_status => l_return_status,
10005: x_msg_count => l_msg_count,
10006: x_msg_data => l_msg_data,
10007: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in ,
10008: x_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_out);
10009: End If;
10010: cnt1 :=0;
10011:

Line 10008: x_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_out);

10004: x_return_status => l_return_status,
10005: x_msg_count => l_msg_count,
10006: x_msg_data => l_msg_data,
10007: p_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_in ,
10008: x_oks_billrate_schedules_v_tbl => l_bill_rate_tbl_out);
10009: End If;
10010: cnt1 :=0;
10011:
10012: End LOOP; -- billrate