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 2352: UPDATE oks_stream_levels_b

2348: END IF;
2349:
2350: FOR l_index IN l_sll_prorate_tbl.FIRST .. l_sll_prorate_tbl.LAST
2351: LOOP
2352: UPDATE oks_stream_levels_b
2353: Set level_amount = l_sll_prorate_tbl(l_index).sll_amount
2354: WHERE id = x_sll_out_tbl(l_index).id;
2355:
2356: x_sll_out_tbl(l_index).amount := l_sll_prorate_tbl(l_index).sll_amount;

Line 2394: FROM oks_stream_levels_b

2390: FUNCTION chk_Sll_Exists(p_id IN NUMBER) return number IS
2391:
2392: CURSOR l_sll_csr(p_sll_id NUMBER) IS
2393: SELECT id ,object_version_number
2394: FROM oks_stream_levels_b
2395: WHERE ID = p_sll_id;
2396:
2397: l_sll_rec l_sll_csr%ROWTYPE;
2398: BEGIN

Line 2600: FROM oks_level_elements element, oks_stream_levels_b sll

2596: element.sequence_number, element.date_transaction,
2597: element.date_start, element.date_to_interface,
2598: element.date_completed, element.amount,element.date_end,
2599: element.rul_id
2600: FROM oks_level_elements element, oks_stream_levels_b sll
2601: WHERE sll.id = element.rul_id
2602: AND sll.cle_id = p_cle_id
2603: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2604:

Line 2611: FROM oks_level_elements element, oks_stream_levels_b sll

2607: element.sequence_number, element.date_transaction,
2608: element.date_start, element.date_to_interface,
2609: element.date_completed, element.amount, element.date_end,
2610: element.rul_id
2611: FROM oks_level_elements element, oks_stream_levels_b sll
2612: WHERE sll.id = element.rul_id
2613: AND sll.chr_id = p_chr_id
2614: ORDER BY sll.sequence_no,to_number(element.sequence_number);
2615:

Line 2718: oks_stream_levels_b sll1,

2714: ----- Bug 5047257 End
2715:
2716: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2717: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2718: oks_stream_levels_b sll1,
2719: oks_stream_levels_b sll2
2720: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2721: and a.date_start <= last_start_date
2722: and a.rul_id = sll1.id

Line 2719: oks_stream_levels_b sll2

2715:
2716: Cursor l_element_count1(p_sll_id in number, last_start_date in Date) is
2717: select count(a.id) periods from oks_level_elements a, oks_k_lines_b line,
2718: oks_stream_levels_b sll1,
2719: oks_stream_levels_b sll2
2720: where a.cle_id = ( select max(parent_cle_id) from oks_level_elements b where rul_id = p_sll_id )
2721: and a.date_start <= last_start_date
2722: and a.rul_id = sll1.id
2723: and sll1.sequence_no = sll2.sequence_no

Line 2744: select count(id) from oks_stream_levels_b strm

2740: and lin.cle_id in (select top.id from okc_k_lines_b top
2741: where lin.start_date > top.start_date);
2742:
2743: Cursor sll_csr(p_top_cle_id in number) is
2744: select count(id) from oks_stream_levels_b strm
2745: where strm.cle_id = p_top_cle_id;
2746:
2747:
2748: l_bill_end_date date;

Line 4033: FROM oks_stream_levels_b sll

4029: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
4030: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
4031: sll.interface_offset_days, sll.cle_id, sll.chr_id,
4032: sll.dnz_chr_id, sll.end_date,sll.object_version_number
4033: FROM oks_stream_levels_b sll
4034: WHERE sll.cle_id = p_line_id
4035: ORDER BY sll.sequence_no;
4036:
4037: l_Line_Csr_Rec l_Line_Csr%Rowtype;

Line 4274: UPDATE oks_stream_levels_b

4270: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
4271: FOR i IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
4272: LOOP
4273:
4274: UPDATE oks_stream_levels_b
4275: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4276: WHERE id = l_strm_lvl_tbl_in(i).id;
4277:
4278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4550: FROM oks_stream_levels_b

4546:
4547: BEGIN
4548:
4549: SELECT COUNT(id) INTO l_sll_rule_count
4550: FROM oks_stream_levels_b
4551: WHERE cle_id = p_subline_id ;
4552:
4553: RETURN l_sll_rule_count;
4554:

Line 4607: FROM OKS_STREAM_LEVELS_B sll

4603:
4604: DELETE FROM OKS_LEVEL_ELEMENTS
4605: WHERE rul_id IN
4606: (SELECT sll.id
4607: FROM OKS_STREAM_LEVELS_B sll
4608: WHERE sll.dnz_chr_id = p_hdr_id);
4609:
4610:
4611:

Line 4614: DELETE FROM OKS_STREAM_LEVELS_B

4610:
4611:
4612: ---delete sll for line and cp.
4613:
4614: DELETE FROM OKS_STREAM_LEVELS_B
4615: WHERE dnz_chr_id = p_hdr_id
4616: AND chr_id IS NULL;
4617:
4618: EXCEPTION

Line 4650: FROM oks_stream_levels_b sll

4646: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
4647: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
4648: sll.interface_offset_days, sll.cle_id, sll.chr_id,
4649: sll.dnz_chr_id, sll.end_date, sll.object_version_number
4650: FROM oks_stream_levels_b sll
4651: WHERE sll.chr_id = p_hdr_id
4652: ORDER BY sll.sequence_no;
4653:
4654: l_hdr_Csr_Rec l_hdr_Csr%Rowtype;

Line 4861: UPDATE oks_stream_levels_b

4857: IF l_strm_lvl_tbl_in.COUNT > 0 THEN
4858: FOR i IN l_strm_lvl_tbl_in.FIRST .. l_strm_lvl_tbl_in.LAST
4859: LOOP
4860:
4861: UPDATE oks_stream_levels_b
4862: set level_amount = l_strm_lvl_tbl_in(i).level_amount
4863: WHERE id = l_strm_lvl_tbl_in(i).id;
4864: END LOOP; --tbl for loop
4865: END IF; ---sll tbl count chk

Line 5099: FROM oks_stream_levels_b sll

5095: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
5096: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
5097: sll.interface_offset_days, sll.cle_id, sll.chr_id,
5098: sll.dnz_chr_id,sll.end_date
5099: FROM oks_stream_levels_b sll
5100: WHERE sll.cle_id = p_top_line_id
5101: ORDER BY sll.sequence_no;
5102:
5103: CURSOR l_line_BS_csr(p_line_id NUMBER) IS

Line 5565: FROM oks_stream_levels_b sll

5561: SELECT sll.Id , sll.sequence_no , sll.start_date, sll.level_periods,
5562: sll.uom_per_period, sll.uom_code, sll.level_amount, sll.invoice_offset_days,
5563: sll.interface_offset_days, sll.cle_id, sll.chr_id,
5564: sll.dnz_chr_id, sll.end_date
5565: FROM oks_stream_levels_b sll
5566: WHERE sll.cle_id = p_top_line_id
5567: ORDER BY sll.sequence_no;
5568:
5569:

Line 6992: DELETE FROM OKS_STREAM_LEVELS_B

6988:
6989:
6990: ---delete sll of all cp
6991:
6992: DELETE FROM OKS_STREAM_LEVELS_B
6993: WHERE cle_id IN ( select id
6994: FROM okc_k_lines_b cp
6995: WHERE cp.cle_id = p_top_line_id
6996: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 7150: FROM OKs_stream_levels_b

7146: CURSOR l_line_sll_csr IS
7147: SELECT id, cle_id, chr_id, dnz_chr_id , uom_code,
7148: sequence_no, Start_Date, end_Date, level_periods,
7149: uom_per_period, level_amount, invoice_offset_days, interface_offset_days
7150: FROM OKs_stream_levels_b
7151: WHERE cle_id = p_top_line_id
7152: ORDER BY sequence_no;
7153:
7154:

Line 7365: delete FROM OKS_STREAM_LEVELS_B

7361:
7362:
7363: ---delete sll of cp
7364:
7365: delete FROM OKS_STREAM_LEVELS_B
7366: WHERE cle_id IN (SELECT id
7367: FROM OKC_k_LINES_B cp
7368: WHERE cp.cle_id = p_top_line_id
7369: and cp.lse_id in (35,7,8,9,10,11,13,18,25));

Line 7373: delete FROM OKS_STREAM_LEVELS_B

7369: and cp.lse_id in (35,7,8,9,10,11,13,18,25));
7370:
7371: --DELETE sll of top line
7372:
7373: delete FROM OKS_STREAM_LEVELS_B
7374: WHERE cle_id = p_top_line_id;
7375:
7376: --update billing type to null for cp
7377: UPDATE oks_k_lines_b

Line 7580: Delete oks_stream_levels_b

7576:
7577:
7578: ----Delete sll of cp
7579:
7580: Delete oks_stream_levels_b
7581: where cle_id = p_sub_line_id;
7582:
7583:
7584:

Line 7867: FROM OKS_STREAM_LEVELS_B

7863: Cursor l_Line_SLL_CSR(l_line_id NUMBER) is
7864: SELECT id, cle_id, chr_id, dnz_chr_id , uom_code,
7865: sequence_no, Start_Date, end_Date, level_periods,
7866: uom_per_period, level_amount, invoice_offset_days, interface_offset_days
7867: FROM OKS_STREAM_LEVELS_B
7868: WHERE cle_id = l_line_id
7869: ORDER BY sequence_no;
7870:
7871: CURSOR l_lvl_element_csr(l_sll_id NUMBER) IS

Line 8594: FROM OKS_STREAM_LEVELS_B

8590: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
8591: uom_per_period, uom_code, TRUNC(end_date) end_date,
8592: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
8593: chr_id, level_amount
8594: FROM OKS_STREAM_LEVELS_B
8595: WHERE cle_id = p_top_line_id
8596: ORDER BY sequence_no;
8597:
8598:

Line 8846: FROM OKS_STREAM_LEVELS_B

8842: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
8843: uom_per_period, uom_code, TRUNC(end_date) end_date,
8844: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
8845: chr_id, level_amount
8846: FROM OKS_STREAM_LEVELS_B
8847: WHERE cle_id = p_line_id
8848: ORDER BY sequence_no;
8849:
8850: l_sll_tbl OKS_BILL_SCH.StreamLvl_tbl;

Line 10559: FROM OKS_STREAM_LEVELS_B

10555: SELECT id,sequence_no,TRUNC(start_date) start_date, level_periods,
10556: uom_per_period, uom_code, TRUNC(end_date) end_date,
10557: interface_offset_days, invoice_offset_days, cle_id, dnz_chr_id,
10558: chr_id, level_amount
10559: FROM OKS_STREAM_LEVELS_B
10560: WHERE chr_id = p_contract_id
10561: ORDER BY sequence_no;
10562:
10563:

Line 10776: FROM OKS_STREAM_LEVELS_B sll

10772:
10773: --------delete lvl elemets for line
10774: DELETE FROM OKS_LEVEL_ELEMENTS
10775: WHERE rul_id IN (SELECT sll.id
10776: FROM OKS_STREAM_LEVELS_B sll
10777: WHERE sll.cle_id = p_line_id);
10778:
10779: ---delete sll info
10780: DELETE FROM OKS_STREAM_LEVELS_B

Line 10780: DELETE FROM OKS_STREAM_LEVELS_B

10776: FROM OKS_STREAM_LEVELS_B sll
10777: WHERE sll.cle_id = p_line_id);
10778:
10779: ---delete sll info
10780: DELETE FROM OKS_STREAM_LEVELS_B
10781: WHERE cle_id = p_line_id;
10782:
10783: ----update billing type to 'P'
10784:

Line 10822: DELETE FROM OKS_STREAM_LEVELS_B

10818: WHERE dnz_chr_id = p_contract_id;
10819:
10820:
10821: ---delete sll info for contract (header,line and subline)
10822: DELETE FROM OKS_STREAM_LEVELS_B
10823: WHERE dnz_chr_id = p_contract_id;
10824:
10825:
10826:

Line 10852: FROM oks_level_elements element, oks_stream_levels_b sll

10848: Cursor l_LineSch_Csr is
10849: SELECT sll.start_date,sll.uom_code, sll.uom_per_period,
10850: element.id,element.sequence_number,element.date_start,
10851: element.date_end,element.date_completed
10852: FROM oks_level_elements element, oks_stream_levels_b sll
10853: WHERE sll.id = element.rul_id
10854: AND sll.cle_id = p_line_id
10855: ORDER BY element.date_start;
10856:

Line 10862: FROM oks_stream_levels_b

10858: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
10859: start_date,
10860: uom_code,
10861: uom_per_period * level_periods) sll_end_date
10862: FROM oks_stream_levels_b
10863: WHERE cle_id = p_line_id;
10864:
10865: CURSOR l_bcl_csr(p_line_id number, p_start_date date) IS
10866: SELECT date_billed_to

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

10890:
10891: BEGIN
10892:
10893: --The procedure update the sll end date and level elements end date for a line and subline.
10894: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
10895:
10896: x_return_status := 'S';
10897: l_period_end_dt := null;
10898:

Line 10903: update oks_stream_levels_b set end_date = l_line_sll_rec.sll_end_date

10899: l_lvl_ele_tbl_in.DELETE;
10900:
10901: FOR l_line_sll_rec IN l_line_sll_csr
10902: LOOP
10903: update oks_stream_levels_b set end_date = l_line_sll_rec.sll_end_date
10904: WHERE id = l_line_sll_rec.id;
10905: END LOOP;
10906:
10907:

Line 11018: FROM oks_level_elements element, oks_stream_levels_b sll

11014:
11015: Cursor l_hdrSch_Csr Is
11016: SELECT sll.uom_code, sll.uom_per_period,
11017: element.id,element.date_start
11018: FROM oks_level_elements element, oks_stream_levels_b sll
11019: WHERE sll.id = element.rul_id
11020: AND sll.chr_id = p_chr_id
11021: ORDER BY element.date_start;
11022:

Line 11028: FROM oks_stream_levels_b

11024: SELECT id, start_date, OKC_TIME_UTIL_PUB.get_enddate(
11025: start_DATE,
11026: uom_code,
11027: uom_per_period * level_periods) sll_end_date
11028: FROM oks_stream_levels_b
11029: WHERE chr_id = p_chr_id;
11030:
11031: CURSOR l_line_csr IS
11032: SELECT TRUNC(end_date) end_date, trunc(date_terminated) date_terminated, lse_id

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

11053:
11054: BEGIN
11055:
11056: --The procedure update the sll end date and level elements end date for a hdr schedule.
11057: ---this is written as end date in oks_stream_levels_b and oks_level_elements didn't get migrated .
11058:
11059:
11060:
11061: x_return_status := 'S';

Line 11067: update oks_stream_levels_b set end_date = l_hdr_sll_rec.sll_end_date

11063:
11064: IF p_chr_id IS NOT NULL THEN
11065: FOR l_hdr_sll_rec IN l_hdr_sll_csr
11066: LOOP
11067: update oks_stream_levels_b set end_date = l_hdr_sll_rec.sll_end_date
11068: WHERE id = l_hdr_sll_rec.id;
11069: END LOOP;
11070:
11071:

Line 11643: FROM OKS_STREAM_LEVELS_B

11639: end_date, uom_per_period,advance_periods,level_periods,
11640: level_amount, invoice_offset_days,interface_offset_days,
11641: comments, due_arr_yn,amount,
11642: lines_detailed_yn, security_group_id
11643: FROM OKS_STREAM_LEVELS_B
11644: WHERE cle_id = p_old_cp_id
11645: ORDER BY START_DATE;
11646:
11647: CURSOR l_old_bill_type_csr IS

Line 11836: UPDATE oks_stream_levels_b

11832:
11833: IF l_old_bill_type IN ('E', 'P') THEN
11834: ---update lvl amount to 0 of old line sll
11835:
11836: UPDATE oks_stream_levels_b
11837: SET level_amount = 0
11838: WHERE cle_id = p_old_cp_id;
11839:
11840: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 12565: UPDATE oks_stream_levels_b

12561: LOOP
12562:
12563: IF l_billing_type IN ('E', 'P') THEN
12564:
12565: UPDATE oks_stream_levels_b
12566: SET level_amount = l_sll_db_tbl(l_index).level_amount
12567: WHERE id = l_sll_db_tbl(l_index).id;
12568:
12569: