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_V

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 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 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 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 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 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 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