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.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_PRODUCTS

Line 399: OKL_PRODUCTS C

395: SELECT a.contract_number,
396: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
397: c.reporting_pdt_id -- MGAAP 7263041
398: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
399: OKL_PRODUCTS C
400: WHERE A.id = p_chr_id
401: AND A.id = B.id
402: AND B.PDT_ID = C.ID;
403:

Line 404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;

400: WHERE A.id = p_chr_id
401: AND A.id = B.id
402: AND B.PDT_ID = C.ID;
403:
404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;
405: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
406:
407: -- bug 7577628
408: cursor get_sec_rep_method IS

Line 428: OKL_PRODUCTS pdt

424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,
427: OKL_K_HEADERS khr,
428: OKL_PRODUCTS pdt
429: WHERE khr.id = p_chr_id
430: AND stm.khr_id = khr.id
431: AND stm.say_code = 'CURR'
432: AND stm.active_yn = 'Y'

Line 997: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE

993: -- Procedure to select streams that need to be accrued
994: PROCEDURE GET_ACCRUAL_STREAMS(x_return_status OUT NOCOPY VARCHAR2
995: ,x_stream_tbl OUT NOCOPY stream_tbl_type
996: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE
997: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE
998: ,p_ctr_start_date IN DATE
999: ,p_period_end_date IN DATE
1000: ,p_accrual_rule_yn IN VARCHAR2) IS
1001:

Line 2332: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

2328: l_sob_id NUMBER;
2329: l_accrual_rec accrual_rec_type;
2330: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2331: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2332: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2333: l_total1 NUMBER := 0;
2334: l_total2 NUMBER := 0;
2335: l_try_id NUMBER;
2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

Line 2377: OKL_PRODUCTS pdt

2373: khr.generate_accrual_override_yn,
2374: khr.deal_type,
2375: pdt.reporting_pdt_id -- MGAAP 7263014
2376: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2377: OKL_PRODUCTS pdt
2378: WHERE chr.id = p_ctr_id
2379: AND chr.id = khr.id
2380: AND khr.pdt_id = pdt.id;
2381:

Line 2958: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041

2954: l_stream_tbl stream_tbl_type;
2955: l_accrual_rec accrual_rec_type;
2956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2957: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2958: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2959: l_apply_accrual_rule VARCHAR2(1) := '?';
2960: l_rule_result VARCHAR2(1);
2961: l_override_status VARCHAR2(1);
2962: l_total NUMBER := 0;

Line 3006: OKL_PRODUCTS pdt --MGAAP 7263041

3002: ,khr.currency_conversion_rate
3003: ,khr.currency_conversion_date
3004: ,pdt.reporting_pdt_id
3005: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
3006: OKL_PRODUCTS pdt --MGAAP 7263041
3007: WHERE chr.id = p_khr_id
3008: AND chr.id = khr.id
3009: AND khr.pdt_id = pdt.id;
3010:

Line 3088: OKL_PRODUCTS pdt

3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,
3087: OKL_K_HEADERS khr,
3088: OKL_PRODUCTS pdt
3089: WHERE sty.id = p_acceleration_rec.sty_id
3090: AND stm.khr_id = p_acceleration_rec.khr_id
3091: AND stm.kle_id = p_acceleration_rec.kle_id
3092: AND khr.id = stm.khr_id

Line 3126: OKL_PRODUCTS pdt

3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,
3125: OKL_K_HEADERS khr,
3126: OKL_PRODUCTS pdt
3127: WHERE sty.id = p_acceleration_rec.sty_id
3128: AND stm.khr_id = p_acceleration_rec.khr_id
3129: AND stm.kle_id = p_acceleration_rec.kle_id
3130: AND khr.id = stm.khr_id

Line 3164: OKL_PRODUCTS pdt

3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,
3163: OKL_K_HEADERS khr,
3164: OKL_PRODUCTS pdt
3165: WHERE stm.khr_id = p_acceleration_rec.khr_id
3166: AND khr.id = stm.khr_id
3167: AND sty.id = p_acceleration_rec.sty_id
3168: AND stm.sty_id = sty.id

Line 3202: OKL_PRODUCTS pdt

3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,
3201: OKL_K_HEADERS khr,
3202: OKL_PRODUCTS pdt
3203: WHERE stm.khr_id = p_acceleration_rec.khr_id
3204: AND khr.id = stm.khr_id
3205: AND sty.id = p_acceleration_rec.sty_id
3206: AND stm.sty_id = sty.id

Line 6279: OKL_PRODUCTS b

6275: CURSOR contract_multigaap_csr (p_contract_id NUMBER) IS
6276: SELECT NVL(a.multi_gaap_yn,'N') multi_gaap_yn,
6277: b.reporting_pdt_id
6278: FROM OKL_K_HEADERS a,
6279: OKL_PRODUCTS b
6280: WHERE a.ID = p_contract_id
6281: AND a.PDT_ID = b.ID;
6282:
6283: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

Line 6284: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

6280: WHERE a.ID = p_contract_id
6281: AND a.PDT_ID = b.ID;
6282:
6283: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
6284: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
6285: l_tcnv_tbl_cnt NUMBER;
6286: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
6287: -- MGAAP end 7263041
6288: