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_REC_PUB dependencies on OKS_K_HEADERS_B

Line 163: FROM oks_k_headers_b hdr,

159: p_termination_date IN DATE
160: ) RETURN Date IS
161: Cursor check_hold(p_cle_id IN NUMBER) Is
162: SELECT hold_billing
163: FROM oks_k_headers_b hdr,
164: okc_k_lines_b line
165: WHERE line.id = p_cle_id
166: AND line.dnz_chr_id = hdr.chr_id;
167:

Line 958: FROM oks_k_headers_b

954: --Cursor declaration for partial periods
955: ------------------------------------------------
956: CURSOR l_period_type_csr(p_hdr_id IN NUMBER) IS
957: SELECT period_type,period_start
958: FROM oks_k_headers_b
959: WHERE chr_id = p_hdr_id;
960: -------------------------------------------------
961:
962: l_return_status VARCHAR2(10);

Line 986: l_period_type OKS_K_HEADERS_B.period_type%TYPE;

982: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
983:
984: --local variables for partial periods
985: ----------------------------------------------------------
986: l_period_type OKS_K_HEADERS_B.period_type%TYPE;
987: l_period_start OKS_K_HEADERS_B.period_start%TYPE;
988: l_hdr_id NUMBER;
989: ----------------------------------------------------------
990: l_line_rec OKS_QP_PKG.Input_details ;

Line 987: l_period_start OKS_K_HEADERS_B.period_start%TYPE;

983:
984: --local variables for partial periods
985: ----------------------------------------------------------
986: l_period_type OKS_K_HEADERS_B.period_type%TYPE;
987: l_period_start OKS_K_HEADERS_B.period_start%TYPE;
988: l_hdr_id NUMBER;
989: ----------------------------------------------------------
990: l_line_rec OKS_QP_PKG.Input_details ;
991: l_price_rec OKS_QP_PKG.Price_Details ;

Line 1401: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

1397: -- Date 30-MAY-2005
1398: -- local variables for partal periods
1399: -------------------------------------------------------------------------
1400: l_hdr_id NUMBER;
1401: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1402: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1403: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1404: l_pricing_method VARCHAR2(30);
1405: -------------------------------------------------------------------------

Line 1402: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

1398: -- local variables for partal periods
1399: -------------------------------------------------------------------------
1400: l_hdr_id NUMBER;
1401: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1402: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1403: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1404: l_pricing_method VARCHAR2(30);
1405: -------------------------------------------------------------------------
1406:

Line 1403: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

1399: -------------------------------------------------------------------------
1400: l_hdr_id NUMBER;
1401: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1402: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1403: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1404: l_pricing_method VARCHAR2(30);
1405: -------------------------------------------------------------------------
1406:
1407:

Line 2668: FROM oks_k_headers_b rhdr,

2664: SELECT rhdr.cc_no ,
2665: rhdr.cc_expiry_date,
2666: rhdr.cc_bank_acct_id,
2667: hdr.bill_to_site_use_id
2668: FROM oks_k_headers_b rhdr,
2669: okc_k_headers_b hdr
2670: WHERE rhdr.chr_id = hdr.id
2671: AND hdr.id = p_hdr_id;
2672:

Line 2755: UPDATE oks_k_headers_b

2751: x_status := 'E';
2752: Raise G_EXCEPTION_HALT_VALIDATION;
2753: ELSE
2754:
2755: UPDATE oks_k_headers_b
2756: SET cc_bank_acct_id = x_bank_account_id
2757: WHERE chr_id = p_dnz_chr_id;
2758:
2759: END IF; -- check null for bank account id

Line 3280: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

3276: -- Date 30-MAY-2005
3277: -- local variables for partal periods
3278: -------------------------------------------------------------------------
3279: l_hdr_id NUMBER;
3280: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3281: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3282: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3283: l_usage_type VARCHAR2(10);
3284: l_lse_id NUMBER; --Added for Bug#14647106

Line 3281: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

3277: -- local variables for partal periods
3278: -------------------------------------------------------------------------
3279: l_hdr_id NUMBER;
3280: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3281: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3282: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3283: l_usage_type VARCHAR2(10);
3284: l_lse_id NUMBER; --Added for Bug#14647106
3285: --------------------------------------------------------------------------

Line 3282: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

3278: -------------------------------------------------------------------------
3279: l_hdr_id NUMBER;
3280: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3281: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3282: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3283: l_usage_type VARCHAR2(10);
3284: l_lse_id NUMBER; --Added for Bug#14647106
3285: --------------------------------------------------------------------------
3286:

Line 4836: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from

4832: and okcline.cle_id = p_id
4833: and okcline.date_cancelled is null )
4834: where topline.cle_id = p_id;
4835:
4836: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
4837: oks_k_lines_b oksline, okc_k_lines_b okcline
4838: where okcline.id = oksline.cle_id
4839: and okcline.dnz_chr_id = l_line_parameter_rec.p_dnz_chr_id
4840: and okcline.date_cancelled is null

Line 5358: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from

5354: END IF;
5355:
5356: END IF ; -- l_terminate = TRUE|| ((l_terminate = FALSE) AND (check_all_lines_terminated%NOTFOUND)))
5357:
5358: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
5359: oks_k_lines_b oksline, okc_k_lines_b okcline
5360: where okcline.id = oksline.cle_id
5361: and okcline.dnz_chr_id = p_id
5362: and okcline.date_cancelled is null

Line 8554: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from

8550: and okcline.cle_id = l_top_line_id
8551: and okcline.date_cancelled is null )
8552: where topline.cle_id = l_top_line_id;
8553:
8554: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
8555: oks_k_lines_b oksline, okc_k_lines_b okcline
8556: where okcline.id = oksline.cle_id
8557: and okcline.dnz_chr_id = l_hdr_id
8558: and okcline.date_cancelled is null

Line 8697: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

8693: -- Date 30-MAY-2005
8694: -- local variables for partal periods
8695: -------------------------------------------------------------------------
8696: l_hdr_id NUMBER;
8697: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8698: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8699: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8700:
8701:

Line 8698: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

8694: -- local variables for partal periods
8695: -------------------------------------------------------------------------
8696: l_hdr_id NUMBER;
8697: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8698: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8699: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8700:
8701:
8702: BEGIN

Line 8699: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

8695: -------------------------------------------------------------------------
8696: l_hdr_id NUMBER;
8697: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8698: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8699: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8700:
8701:
8702: BEGIN
8703:

Line 9336: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

9332: -- Begin partial period computation logic
9333: -- Developer Mani Choudhary
9334: -- Date 04-MAY-2005
9335: -------------------------------------------------------------------------
9336: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9337: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9338: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9339: -------------------------------------------------------------------------
9340: /*Added for bug:10285124*/

Line 9337: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

9333: -- Developer Mani Choudhary
9334: -- Date 04-MAY-2005
9335: -------------------------------------------------------------------------
9336: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9337: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9338: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9339: -------------------------------------------------------------------------
9340: /*Added for bug:10285124*/
9341: l_flag number;

Line 9338: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

9334: -- Date 04-MAY-2005
9335: -------------------------------------------------------------------------
9336: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9337: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9338: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9339: -------------------------------------------------------------------------
9340: /*Added for bug:10285124*/
9341: l_flag number;
9342: BEGIN