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 161: FROM oks_k_headers_b hdr,

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

Line 939: FROM oks_k_headers_b

935: --Cursor declaration for partial periods
936: ------------------------------------------------
937: CURSOR l_period_type_csr(p_hdr_id IN NUMBER) IS
938: SELECT period_type,period_start
939: FROM oks_k_headers_b
940: WHERE chr_id = p_hdr_id;
941: -------------------------------------------------
942:
943: l_return_status VARCHAR2(10);

Line 967: l_period_type OKS_K_HEADERS_B.period_type%TYPE;

963: l_init_msg_list CONSTANT VARCHAR2(1):= 'F';
964:
965: --local variables for partial periods
966: ----------------------------------------------------------
967: l_period_type OKS_K_HEADERS_B.period_type%TYPE;
968: l_period_start OKS_K_HEADERS_B.period_start%TYPE;
969: l_hdr_id NUMBER;
970: ----------------------------------------------------------
971: l_line_rec OKS_QP_PKG.Input_details ;

Line 968: l_period_start OKS_K_HEADERS_B.period_start%TYPE;

964:
965: --local variables for partial periods
966: ----------------------------------------------------------
967: l_period_type OKS_K_HEADERS_B.period_type%TYPE;
968: l_period_start OKS_K_HEADERS_B.period_start%TYPE;
969: l_hdr_id NUMBER;
970: ----------------------------------------------------------
971: l_line_rec OKS_QP_PKG.Input_details ;
972: l_price_rec OKS_QP_PKG.Price_Details ;

Line 1382: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

1378: -- Date 30-MAY-2005
1379: -- local variables for partal periods
1380: -------------------------------------------------------------------------
1381: l_hdr_id NUMBER;
1382: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1383: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1384: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1385: l_pricing_method VARCHAR2(30);
1386: -------------------------------------------------------------------------

Line 1383: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

1379: -- local variables for partal periods
1380: -------------------------------------------------------------------------
1381: l_hdr_id NUMBER;
1382: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1383: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1384: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1385: l_pricing_method VARCHAR2(30);
1386: -------------------------------------------------------------------------
1387:

Line 1384: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

1380: -------------------------------------------------------------------------
1381: l_hdr_id NUMBER;
1382: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
1383: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
1384: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
1385: l_pricing_method VARCHAR2(30);
1386: -------------------------------------------------------------------------
1387:
1388:

Line 2654: FROM oks_k_headers_b rhdr,

2650: SELECT rhdr.cc_no ,
2651: rhdr.cc_expiry_date,
2652: rhdr.cc_bank_acct_id,
2653: hdr.bill_to_site_use_id
2654: FROM oks_k_headers_b rhdr,
2655: okc_k_headers_b hdr
2656: WHERE rhdr.chr_id = hdr.id
2657: AND hdr.id = p_hdr_id;
2658:

Line 2741: UPDATE oks_k_headers_b

2737: x_status := 'E';
2738: Raise G_EXCEPTION_HALT_VALIDATION;
2739: ELSE
2740:
2741: UPDATE oks_k_headers_b
2742: SET cc_bank_acct_id = x_bank_account_id
2743: WHERE chr_id = p_dnz_chr_id;
2744:
2745: END IF; -- check null for bank account id

Line 3257: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

3253: -- Date 30-MAY-2005
3254: -- local variables for partal periods
3255: -------------------------------------------------------------------------
3256: l_hdr_id NUMBER;
3257: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3258: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3259: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3260: l_usage_type VARCHAR2(10);
3261: --------------------------------------------------------------------------

Line 3258: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

3254: -- local variables for partal periods
3255: -------------------------------------------------------------------------
3256: l_hdr_id NUMBER;
3257: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3258: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3259: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3260: l_usage_type VARCHAR2(10);
3261: --------------------------------------------------------------------------
3262:

Line 3259: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

3255: -------------------------------------------------------------------------
3256: l_hdr_id NUMBER;
3257: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
3258: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
3259: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
3260: l_usage_type VARCHAR2(10);
3261: --------------------------------------------------------------------------
3262:
3263: BEGIN

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

4806: and okcline.cle_id = p_id
4807: and okcline.date_cancelled is null )
4808: where topline.cle_id = p_id;
4809:
4810: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
4811: oks_k_lines_b oksline, okc_k_lines_b okcline
4812: where okcline.id = oksline.cle_id
4813: and okcline.dnz_chr_id = l_line_parameter_rec.p_dnz_chr_id
4814: and okcline.date_cancelled is null

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

5328: END IF;
5329:
5330: END IF ; -- l_terminate = TRUE|| ((l_terminate = FALSE) AND (check_all_lines_terminated%NOTFOUND)))
5331:
5332: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
5333: oks_k_lines_b oksline, okc_k_lines_b okcline
5334: where okcline.id = oksline.cle_id
5335: and okcline.dnz_chr_id = p_id
5336: and okcline.date_cancelled is null

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

8513: and okcline.cle_id = l_top_line_id
8514: and okcline.date_cancelled is null )
8515: where topline.cle_id = l_top_line_id;
8516:
8517: update oks_k_headers_b hdr set hdr.tax_amount = ( select sum(tax_amount) from
8518: oks_k_lines_b oksline, okc_k_lines_b okcline
8519: where okcline.id = oksline.cle_id
8520: and okcline.dnz_chr_id = l_hdr_id
8521: and okcline.date_cancelled is null

Line 8657: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

8653: -- Date 30-MAY-2005
8654: -- local variables for partal periods
8655: -------------------------------------------------------------------------
8656: l_hdr_id NUMBER;
8657: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8658: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8659: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8660:
8661:

Line 8658: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

8654: -- local variables for partal periods
8655: -------------------------------------------------------------------------
8656: l_hdr_id NUMBER;
8657: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8658: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8659: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8660:
8661:
8662: BEGIN

Line 8659: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

8655: -------------------------------------------------------------------------
8656: l_hdr_id NUMBER;
8657: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
8658: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
8659: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
8660:
8661:
8662: BEGIN
8663:

Line 9288: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;

9284: -- Begin partial period computation logic
9285: -- Developer Mani Choudhary
9286: -- Date 04-MAY-2005
9287: -------------------------------------------------------------------------
9288: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9289: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9290: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9291: -------------------------------------------------------------------------
9292: BEGIN

Line 9289: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;

9285: -- Developer Mani Choudhary
9286: -- Date 04-MAY-2005
9287: -------------------------------------------------------------------------
9288: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9289: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9290: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9291: -------------------------------------------------------------------------
9292: BEGIN
9293:

Line 9290: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;

9286: -- Date 04-MAY-2005
9287: -------------------------------------------------------------------------
9288: l_price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE;
9289: l_period_start OKS_K_HEADERS_B.PERIOD_START%TYPE;
9290: l_period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE;
9291: -------------------------------------------------------------------------
9292: BEGIN
9293:
9294: x_return_status := 'S';