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_BILL_SCH dependencies on OKS_STREAM_LEVELS_B

Line 1808: DELETE FROM oks_stream_levels_b WHERE cle_id = l_subline_csr_rec.subline_id;

1804: ---the form can only be changed if no records are billed.
1805:
1806: DELETE FROM oks_level_elements WHERE cle_id = l_subline_csr_rec.subline_id;
1807:
1808: DELETE FROM oks_stream_levels_b WHERE cle_id = l_subline_csr_rec.subline_id;
1809: END IF; --if sub line billing type <> p_billing_type
1810:
1811: --------------------------------------------------------------------------
1812: -- Begin partial period computation logic

Line 1926: SELECT id , object_version_number FROM oks_stream_levels_b

1922: )
1923: Is
1924:
1925: CURSOR l_subline_sll_csr(p_seq_no NUMBER, p_line_id NUMBER) IS
1926: SELECT id , object_version_number FROM oks_stream_levels_b
1927: WHERE sequence_no = p_seq_no
1928: AND cle_id = p_line_id;
1929:
1930: l_subline_sll_rec l_subline_sll_csr%ROWTYPE;

Line 2335: UPDATE oks_stream_levels_b

2331: END IF;
2332:
2333: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
2334: LOOP
2335: UPDATE oks_stream_levels_b
2336: Set level_amount = l_sll_prorate_tbl(l_index).sll_amount
2337: WHERE id = x_sll_out_tbl(l_index).id;
2338:
2339: x_sll_out_tbl(l_index).amount := l_sll_prorate_tbl(l_index).sll_amount;

Line 2377: FROM oks_stream_levels_b

2373: FUNCTION chk_Sll_Exists(p_id IN NUMBER) return number IS
2374:
2375: CURSOR l_sll_csr(p_sll_id NUMBER) IS
2376: SELECT id ,object_version_number
2377: FROM oks_stream_levels_b
2378: WHERE ID = p_sll_id;
2379:
2380: l_sll_rec l_sll_csr%ROWTYPE;
2381: BEGIN

Line 2583: FROM oks_level_elements element, oks_stream_levels_b sll

2579: element.sequence_number, element.date_transaction,
2580: element.date_start, element.date_to_interface,
2581: element.date_completed, element.amount,element.date_end,
2582: element.rul_id
2583: FROM oks_level_elements element, oks_stream_levels_b sll
2584: WHERE sll.id = element.rul_id
2585: AND sll.cle_id = p_cle_id
2586: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2587:

Line 2594: FROM oks_level_elements element, oks_stream_levels_b sll

2590: element.sequence_number, element.date_transaction,
2591: element.date_start, element.date_to_interface,
2592: element.date_completed, element.amount, element.date_end,
2593: element.rul_id
2594: FROM oks_level_elements element, oks_stream_levels_b sll
2595: WHERE sll.id = element.rul_id
2596: AND sll.chr_id = p_chr_id
2597: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2598:

Line 2701: oks_stream_levels_b sll1,

2697: ----- Bug 5047257 End
2698:
2699: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2700: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2701: oks_stream_levels_b sll1,
2702: oks_stream_levels_b sll2
2703: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2704: and a.date_start <= last_start_date
2705: and a.rul_id = sll1.id

Line 2702: oks_stream_levels_b sll2

2698:
2699: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2700: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2701: oks_stream_levels_b sll1,
2702: oks_stream_levels_b sll2
2703: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2704: and a.date_start <= last_start_date
2705: and a.rul_id = sll1.id
2706: and sll1.sequence_no = sll2.sequence_no

Line 2727: select count(id) from oks_stream_levels_b strm

2723: and lin.cle_id in (select top.id from okc_k_lines_b top
2724: where lin.start_date > top.start_date);
2725:
2726: Cursor sll_csr(p_top_cle_id in number) is
2727: select count(id) from oks_stream_levels_b strm
2728: where strm.cle_id = p_top_cle_id;
2729:
2730:
2731: l_bill_end_date date;

Line 4016: FROM oks_stream_levels_b sll

4012: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
4013: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
4014: sll.interface_offset_days, sll.cle_id, sll.chr_id,
4015: sll.dnz_chr_id, sll.end_date,sll.object_version_number
4016: FROM oks_stream_levels_b sll
4017: WHERE sll.cle_id = p_line_id
4018: ORDER BY sll.sequence_no;
4019:
4020: l_Line_Csr_Rec l_Line_Csr%Rowtype;

Line 4257: UPDATE oks_stream_levels_b

4253: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
4254: FOR i IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
4255: LOOP
4256:
4257: UPDATE oks_stream_levels_b
4258: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4259: WHERE id = l_strm_lvl_tbl_in(i).id;
4260:
4261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4533: FROM oks_stream_levels_b

4529:
4530: BEGIN
4531:
4532: SELECT COUNT(id) INTO l_sll_rule_count
4533: FROM oks_stream_levels_b
4534: WHERE cle_id = p_subline_id ;
4535:
4536: RETURN l_sll_rule_count;
4537:

Line 4590: FROM OKS_STREAM_LEVELS_B sll

4586:
4587: DELETE FROM OKS_LEVEL_ELEMENTS
4588: WHERE rul_id IN
4589: (SELECT sll.id
4590: FROM OKS_STREAM_LEVELS_B sll
4591: WHERE sll.dnz_chr_id = p_hdr_id);
4592:
4593:
4594:

Line 4597: DELETE FROM OKS_STREAM_LEVELS_B

4593:
4594:
4595: ---delete sll for line and cp.
4596:
4597: DELETE FROM OKS_STREAM_LEVELS_B
4598: WHERE dnz_chr_id = p_hdr_id
4599: AND chr_id IS NULL;
4600:
4601: EXCEPTION

Line 4633: FROM oks_stream_levels_b sll

4629: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
4630: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
4631: sll.interface_offset_days, sll.cle_id, sll.chr_id,
4632: sll.dnz_chr_id, sll.end_date, sll.object_version_number
4633: FROM oks_stream_levels_b sll
4634: WHERE sll.chr_id = p_hdr_id
4635: ORDER BY sll.sequence_no;
4636:
4637: l_hdr_Csr_Rec l_hdr_Csr%Rowtype;

Line 4844: UPDATE oks_stream_levels_b

4840: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
4841: FOR i IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
4842: LOOP
4843:
4844: UPDATE oks_stream_levels_b
4845: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4846: WHERE id = l_strm_lvl_tbl_in(i).id;
4847: END LOOP; --tbl for loop
4848: END IF; ---sll tbl count chk

Line 5082: FROM oks_stream_levels_b sll

5078: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
5079: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
5080: sll.interface_offset_days, sll.cle_id, sll.chr_id,
5081: sll.dnz_chr_id,sll.end_date
5082: FROM oks_stream_levels_b sll
5083: WHERE sll.cle_id = p_top_line_id
5084: ORDER BY sll.sequence_no;
5085:
5086: CURSOR l_line_BS_csr(p_line_id NUMBER) IS

Line 5548: FROM oks_stream_levels_b sll

5544: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
5545: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
5546: sll.interface_offset_days, sll.cle_id, sll.chr_id,
5547: sll.dnz_chr_id, sll.end_date
5548: FROM oks_stream_levels_b sll
5549: WHERE sll.cle_id = p_top_line_id
5550: ORDER BY sll.sequence_no;
5551:
5552:

Line 6780: DELETE FROM OKS_STREAM_LEVELS_B

6776:
6777:
6778: ---delete sll of all cp
6779:
6780: DELETE FROM OKS_STREAM_LEVELS_B
6781: WHERE cle_id IN ( select id
6782: FROM okc_k_lines_b cp
6783: WHERE cp.cle_id = p_top_line_id
6784: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 6938: FROM OKs_stream_levels_b

6934: CURSOR l_line_sll_csr IS
6935: SELECT id, cle_id, chr_id, dnz_chr_id , uom_code,
6936: sequence_no, Start_Date, end_Date, level_periods,
6937: uom_per_period, level_amount, invoice_offset_days, interface_offset_days
6938: FROM OKs_stream_levels_b
6939: WHERE cle_id = p_top_line_id
6940: ORDER BY sequence_no;
6941:
6942:

Line 7153: delete FROM OKS_STREAM_LEVELS_B

7149:
7150:
7151: ---delete sll of cp
7152:
7153: delete FROM OKS_STREAM_LEVELS_B
7154: WHERE cle_id IN (SELECT id
7155: FROM OKC_k_LINES_B cp
7156: WHERE cp.cle_id = p_top_line_id
7157: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 7161: delete FROM OKS_STREAM_LEVELS_B

7157: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7158:
7159: --DELETE sll of top line
7160:
7161: delete FROM OKS_STREAM_LEVELS_B
7162: WHERE cle_id = p_top_line_id;
7163:
7164: --update billing type to null for cp
7165: UPDATE oks_k_lines_b

Line 7367: Delete oks_stream_levels_b

7363:
7364:
7365: ----Delete sll of cp
7366:
7367: Delete oks_stream_levels_b
7368: where cle_id = p_sub_line_id;
7369:
7370:
7371:

Line 7654: FROM OKS_STREAM_LEVELS_B

7650: Cursor l_Line_SLL_CSR(l_line_id NUMBER) is
7651: SELECT id, cle_id, chr_id, dnz_chr_id , uom_code,
7652: sequence_no, Start_Date, end_Date, level_periods,
7653: uom_per_period, level_amount, invoice_offset_days, interface_offset_days
7654: FROM OKS_STREAM_LEVELS_B
7655: WHERE cle_id = l_line_id
7656: ORDER BY sequence_no;
7657:
7658: CURSOR l_lvl_element_csr(l_sll_id NUMBER) IS

Line 8381: FROM OKS_STREAM_LEVELS_B

8377: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
8378: uom_per_period, uom_code, TRUNC(end_date) end_date,
8379: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
8380: chr_id, level_amount
8381: FROM OKS_STREAM_LEVELS_B
8382: WHERE cle_id = p_top_line_id
8383: ORDER BY sequence_no;
8384:
8385:

Line 8633: FROM OKS_STREAM_LEVELS_B

8629: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
8630: uom_per_period, uom_code, TRUNC(end_date) end_date,
8631: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
8632: chr_id, level_amount
8633: FROM OKS_STREAM_LEVELS_B
8634: WHERE cle_id = p_line_id
8635: ORDER BY sequence_no;
8636:
8637: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

Line 10316: FROM OKS_STREAM_LEVELS_B

10312: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
10313: uom_per_period, uom_code, TRUNC(end_date) end_date,
10314: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
10315: chr_id, level_amount
10316: FROM OKS_STREAM_LEVELS_B
10317: WHERE chr_id = p_contract_id
10318: ORDER BY sequence_no;
10319:
10320:

Line 10533: FROM OKS_STREAM_LEVELS_B sll

10529:
10530: --------delete lvl elemets for line
10531: DELETE FROM OKS_LEVEL_ELEMENTS
10532: WHERE rul_id IN (SELECT sll.id
10533: FROM OKS_STREAM_LEVELS_B sll
10534: WHERE sll.cle_id = p_line_id);
10535:
10536: ---delete sll info
10537: DELETE FROM OKS_STREAM_LEVELS_B

Line 10537: DELETE FROM OKS_STREAM_LEVELS_B

10533: FROM OKS_STREAM_LEVELS_B sll
10534: WHERE sll.cle_id = p_line_id);
10535:
10536: ---delete sll info
10537: DELETE FROM OKS_STREAM_LEVELS_B
10538: WHERE cle_id = p_line_id;
10539:
10540: ----update billing type to 'P'
10541:

Line 10579: DELETE FROM OKS_STREAM_LEVELS_B

10575: WHERE dnz_chr_id = p_contract_id;
10576:
10577:
10578: ---delete sll info for contract (header,line and subline)
10579: DELETE FROM OKS_STREAM_LEVELS_B
10580: WHERE dnz_chr_id = p_contract_id;
10581:
10582:
10583:

Line 10609: FROM oks_level_elements element, oks_stream_levels_b sll

10605: Cursor l_LineSch_Csr is
10606: SELECT sll.start_date,sll.uom_code, sll.uom_per_period,
10607: element.id,element.sequence_number,element.date_start,
10608: element.date_end,element.date_completed
10609: FROM oks_level_elements element, oks_stream_levels_b sll
10610: WHERE sll.id = element.rul_id
10611: AND sll.cle_id = p_line_id
10612: ORDER BY element.date_start;
10613:

Line 10619: FROM oks_stream_levels_b

10615: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10616: start_date,
10617: uom_code,
10618: uom_per_period * level_periods) sll_end_date
10619: FROM oks_stream_levels_b
10620: WHERE cle_id = p_line_id;
10621:
10622: CURSOR l_bcl_csr(p_line_id number, p_start_date date) IS
10623: SELECT date_billed_to

Line 10651: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .

10647:
10648: BEGIN
10649:
10650: --The procedure update the sll end date and level elements end date for a line and subline.
10651: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10652:
10653: x_return_status := 'S';
10654: l_period_end_dt := null;
10655:

Line 10660: update oks_stream_levels_b set end_date = l_line_sll_rec.sll_end_date

10656: l_lvl_ele_tbl_in.DELETE;
10657:
10658: FOR l_line_sll_rec IN l_line_sll_csr
10659: LOOP
10660: update oks_stream_levels_b set end_date = l_line_sll_rec.sll_end_date
10661: WHERE id = l_line_sll_rec.id;
10662: END LOOP;
10663:
10664:

Line 10775: FROM oks_level_elements element, oks_stream_levels_b sll

10771:
10772: Cursor l_hdrSch_Csr Is
10773: SELECT sll.uom_code, sll.uom_per_period,
10774: element.id,element.date_start
10775: FROM oks_level_elements element, oks_stream_levels_b sll
10776: WHERE sll.id = element.rul_id
10777: AND sll.chr_id = p_chr_id
10778: ORDER BY element.date_start;
10779:

Line 10785: FROM oks_stream_levels_b

10781: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10782: start_DATE,
10783: uom_code,
10784: uom_per_period * level_periods) sll_end_date
10785: FROM oks_stream_levels_b
10786: WHERE chr_id = p_chr_id;
10787:
10788: CURSOR l_line_csr IS
10789: SELECT TRUNC(end_date) end_date, trunc(date_terminated) date_terminated, lse_id

Line 10814: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .

10810:
10811: BEGIN
10812:
10813: --The procedure update the sll end date and level elements end date for a hdr schedule.
10814: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10815:
10816:
10817:
10818: x_return_status := 'S';

Line 10824: update oks_stream_levels_b set end_date = l_hdr_sll_rec.sll_end_date

10820:
10821: IF p_chr_id IS NOT NULL THEN
10822: FOR l_hdr_sll_rec IN l_hdr_sll_csr
10823: LOOP
10824: update oks_stream_levels_b set end_date = l_hdr_sll_rec.sll_end_date
10825: WHERE id = l_hdr_sll_rec.id;
10826: END LOOP;
10827:
10828:

Line 11400: FROM OKS_STREAM_LEVELS_B

11396: end_date, uom_per_period,advance_periods,level_periods,
11397: level_amount, invoice_offset_days,interface_offset_days,
11398: comments, due_arr_yn,amount,
11399: lines_detailed_yn, security_group_id
11400: FROM OKS_STREAM_LEVELS_B
11401: WHERE cle_id = p_old_cp_id
11402: ORDER BY START_DATE;
11403:
11404: CURSOR l_old_bill_type_csr IS

Line 11593: UPDATE oks_stream_levels_b

11589:
11590: IF l_old_bill_type IN ('E', 'P') THEN
11591: ---update lvl amount to 0 of old line sll
11592:
11593: UPDATE oks_stream_levels_b
11594: SET level_amount = 0
11595: WHERE cle_id = p_old_cp_id;
11596:
11597: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12299: UPDATE oks_stream_levels_b

12295: LOOP
12296:
12297: IF l_billing_type IN ('E', 'P') THEN
12298:
12299: UPDATE oks_stream_levels_b
12300: SET level_amount = l_sll_db_tbl(l_index).level_amount
12301: WHERE id = l_sll_db_tbl(l_index).id;
12302:
12303: