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.

[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_STRM_ELEMENTS

Line 1000: UPDATE okl_strm_elements

996: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sel_id_tbl.count : ' || sel_id_tbl.COUNT);
997: END IF;
998: IF sel_id_tbl.COUNT > 0 THEN
999: FORALL indx IN sel_id_tbl.FIRST..sel_id_tbl.LAST
1000: UPDATE okl_strm_elements
1001: SET date_billed = SYSDATE
1002: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG 14742784 change starts here
1003: ,last_update_date = sysdate
1004: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG 14742784 change ends here

Line 1016: FROM OKL_STRM_ELEMENTS ste,

1012: save exceptions
1013: UPDATE okl_k_control nbd
1014: set EARLIEST_STRM_BILL_DATE = (
1015: SELECT MIN(ste.stream_element_date)
1016: FROM OKL_STRM_ELEMENTS ste,
1017: OKL_STREAMS stm,
1018: okl_strm_type_v sty,
1019: okc_k_headers_b khr,
1020: OKL_K_HEADERS khl,

Line 1303: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;

1299: l_trx_status_code Okl_trx_ar_invoices_v.trx_status_code%TYPE;
1300:
1301:
1302: -- For currecy precision rounded amount
1303: l_ste_amount OKL_STRM_ELEMENTS.amount%TYPE := 0;
1304: l_curr_code okc_k_headers_b.currency_code%TYPE;
1305:
1306: -------------------------------------------------------------------------
1307: -- Account Builder Code

Line 1320: amount OKL_STRM_ELEMENTS.amount%TYPE,

1316: xsi_id NUMBER,
1317: bill_date DATE,
1318: contract_number okc_k_headers_b.contract_number%TYPE,
1319: stream_name okl_strm_type_v.name%TYPE,
1320: amount OKL_STRM_ELEMENTS.amount%TYPE,
1321: error_message VARCHAR2(2000)
1322: );
1323:
1324: TYPE sel_err_tbl_type IS TABLE OF sel_err_rec_type

Line 2577: FROM OKL_STRM_ELEMENTS ste,

2573: sty.name comments,
2574: sty.taxable_default_yn taxable_default_yn,
2575: ste.amount amount,
2576: khr.sts_code sts_code
2577: FROM OKL_STRM_ELEMENTS ste,
2578: OKL_STREAMS stm,
2579: okl_strm_type_v sty,
2580: okc_k_headers_b khr,
2581: OKL_K_HEADERS khl,

Line 2630: FROM OKL_STRM_ELEMENTS ste,

2626: sty.name comments,
2627: sty.taxable_default_yn taxable_default_yn,
2628: ste.amount amount,
2629: khr.sts_code sts_code
2630: FROM OKL_STRM_ELEMENTS ste,
2631: OKL_STREAMS stm,
2632: okl_strm_type_v sty,
2633: okc_k_headers_b khr,
2634: OKL_K_HEADERS khl,

Line 2678: FROM OKL_STRM_ELEMENTS ste,

2674: sty.name comments,
2675: sty.taxable_default_yn taxable_default_yn,
2676: ste.amount amount,
2677: khr.sts_code sts_code
2678: FROM OKL_STRM_ELEMENTS ste,
2679: OKL_STREAMS stm,
2680: okl_strm_type_v sty,
2681: okc_k_headers_b khr,
2682: OKL_K_HEADERS khl,

Line 2739: FROM OKL_STRM_ELEMENTS ste,

2735: sty.name comments,
2736: sty.taxable_default_yn taxable_default_yn,
2737: ste.amount amount,
2738: khr.sts_code sts_code
2739: FROM OKL_STRM_ELEMENTS ste,
2740: OKL_STREAMS stm,
2741: okl_strm_type_v sty,
2742: okc_k_headers_b khr,
2743: OKL_K_HEADERS khl,

Line 2802: FROM OKL_STRM_ELEMENTS ste,

2798: sty.name comments,
2799: sty.taxable_default_yn taxable_default_yn,
2800: ste.amount amount,
2801: khr.sts_code sts_code
2802: FROM OKL_STRM_ELEMENTS ste,
2803: OKL_STREAMS stm,
2804: okl_strm_type_v sty,
2805: okc_k_headers_b khr,
2806: OKL_K_HEADERS khl,

Line 2854: FROM OKL_STRM_ELEMENTS ste,

2850: sty.name comments,
2851: sty.taxable_default_yn taxable_default_yn,
2852: ste.amount amount,
2853: khr.sts_code sts_code
2854: FROM OKL_STRM_ELEMENTS ste,
2855: OKL_STREAMS stm,
2856: okl_strm_type_v sty,
2857: okc_k_headers_b khr,
2858: OKL_K_HEADERS khl,

Line 2903: FROM OKL_STRM_ELEMENTS ste,

2899: sty.name comments,
2900: sty.taxable_default_yn taxable_default_yn,
2901: ste.amount amount,
2902: khr.sts_code sts_code
2903: FROM OKL_STRM_ELEMENTS ste,
2904: OKL_STREAMS stm,
2905: okl_strm_type_v sty,
2906: okc_k_headers_b khr,
2907: OKL_K_HEADERS khl,

Line 2963: FROM OKL_STRM_ELEMENTS ste,

2959: sty.name comments,
2960: sty.taxable_default_yn taxable_default_yn,
2961: ste.amount amount,
2962: khr.sts_code sts_code
2963: FROM OKL_STRM_ELEMENTS ste,
2964: OKL_STREAMS stm,
2965: okl_strm_type_v sty,
2966: okc_k_headers_b khr,
2967: OKL_K_HEADERS khl,

Line 3026: FROM OKL_STRM_ELEMENTS ste,

3022: sty.name comments,
3023: sty.taxable_default_yn taxable_default_yn,
3024: ste.amount amount,
3025: khr.sts_code sts_code
3026: FROM OKL_STRM_ELEMENTS ste,
3027: OKL_STREAMS stm,
3028: okl_strm_type_v sty,
3029: okc_k_headers_b khr,
3030: OKL_K_HEADERS khl,

Line 3081: FROM OKL_STRM_ELEMENTS ste,

3077: sty.name comments,
3078: sty.taxable_default_yn taxable_default_yn,
3079: ste.amount amount,
3080: khr.sts_code sts_code
3081: FROM OKL_STRM_ELEMENTS ste,
3082: OKL_STREAMS stm,
3083: okl_strm_type_v sty,
3084: okc_k_headers_b khr,
3085: OKL_K_HEADERS khl,

Line 3134: FROM OKL_STRM_ELEMENTS ste,

3130: sty.name comments,
3131: sty.taxable_default_yn taxable_default_yn,
3132: ste.amount amount,
3133: khr.sts_code sts_code
3134: FROM OKL_STRM_ELEMENTS ste,
3135: OKL_STREAMS stm,
3136: okl_strm_type_v sty,
3137: okc_k_headers_b khr,
3138: OKL_K_HEADERS khl,

Line 3197: FROM OKL_STRM_ELEMENTS ste,

3193: sty.name comments,
3194: sty.taxable_default_yn taxable_default_yn,
3195: ste.amount amount,
3196: khr.sts_code sts_code
3197: FROM OKL_STRM_ELEMENTS ste,
3198: OKL_STREAMS stm,
3199: okl_strm_type_v sty,
3200: okc_k_headers_b khr,
3201: OKL_K_HEADERS khl,