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_STRM_GEN_TEMPLATE_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 276: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )

272: l_return_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;
273:
274: -- Modified by RGOOTY
275: -- Bug 4094361: Start
276: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
277: IS
278: SELECT PDT.ID PDT_ID
279: ,PRODUCT_STATUS_CODE
280: FROM OKL_PRODUCTS PDT,

Line 281: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

277: IS
278: SELECT PDT.ID PDT_ID
279: ,PRODUCT_STATUS_CODE
280: FROM OKL_PRODUCTS PDT,
281: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
282: WHERE PDT.AES_ID = ATS.ID
283: AND ATS.GTS_ID = SGT.ID
284: AND SGT.ID = p_gts_id;
285:

Line 324: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

320: and chr.sts_code in ('APPROVED','BOOKED','COMPLETE','EVERGREEN','BANKRUPTCY_HOLD','UNDER REVISION','LITIGATION_HOLD','TERMINATION_HOLD')
321: --srsreeni Bug5996170 end
322: ;
323:
324: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
325: l_version OKL_ST_GEN_TEMPLATES.version%TYPE;
326: l_tmpt_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;
327: l_start_date OKL_ST_GEN_TEMPLATES.start_date%TYPE;
328: l_end_date OKL_ST_GEN_TEMPLATES.end_date%TYPE;

Line 783: CURSOR okl_st_gen_tmpt_sets_csr(p_gts_id IN OKL_ST_GEN_TMPT_SETS.id%type) IS

779: l_gtlv_tbl_dep_out gtlv_tbl_type;
780: i NUMBER;
781: l_dummy VARCHAR2(1) := okl_api.G_FALSE;
782:
783: CURSOR okl_st_gen_tmpt_sets_csr(p_gts_id IN OKL_ST_GEN_TMPT_SETS.id%type) IS
784: SELECT ID
785: ,NAME
786: ,DESCRIPTION
787: ,PRODUCT_TYPE

Line 797: FROM OKL_ST_GEN_TMPT_SETS

793: ,days_in_month_code
794: ,days_in_yr_code
795: -- Added new field by DPSINGH for ER 6274342
796: ,isg_arrears_pay_dates_option
797: FROM OKL_ST_GEN_TMPT_SETS
798: WHERE ID = p_gts_id;
799:
800: CURSOR okl_st_gen_templates_csr(p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
801: SELECT ID

Line 894: FOR gtsv_rec_temp IN okl_st_gen_tmpt_sets_csr(l_gttv_rec_in.gts_id)

890: RAISE OKL_API.G_EXCEPTION_ERROR;
891: END IF;
892:
893: l_dummy := Okl_Api.G_FALSE;
894: FOR gtsv_rec_temp IN okl_st_gen_tmpt_sets_csr(l_gttv_rec_in.gts_id)
895: LOOP
896: l_gtsv_rec_in.id := gtsv_rec_temp.id;
897: l_gtsv_rec_in.name := gtsv_rec_temp.name;
898: l_gtsv_rec_in.description := gtsv_rec_temp.description;

Line 1465: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );

1461: ---------------------------------------------------------------------------
1462: FUNCTION belongs_to_ls( p_book_classification IN VARCHAR2 )
1463: RETURN BOOLEAN
1464: IS
1465: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1466: BEGIN
1467: IF ( l_book_classification = G_LEASEDF_DEAL_TYPE OR
1468: l_book_classification = G_LEASEOP_DEAL_TYPE OR
1469: l_book_classification = G_LEASEST_DEAL_TYPE )

Line 1480: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );

1476:
1477: FUNCTION belongs_to_ln( p_book_classification IN VARCHAR2 )
1478: RETURN BOOLEAN
1479: IS
1480: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1481: BEGIN
1482: IF ( l_book_classification = G_LOAN_DEAL_TYPE OR
1483: l_book_classification = G_LOAN_REV_DEAL_TYPE )
1484: THEN

Line 1494: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );

1490:
1491: FUNCTION belongs_to_df_st( p_book_classification IN VARCHAR2 )
1492: RETURN BOOLEAN
1493: IS
1494: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1495: BEGIN
1496: IF ( l_book_classification = G_LEASEDF_DEAL_TYPE OR
1497: l_book_classification = G_LEASEST_DEAL_TYPE )
1498: THEN

Line 1508: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );

1504:
1505: FUNCTION belongs_to_op( p_book_classification IN VARCHAR2 )
1506: RETURN BOOLEAN
1507: IS
1508: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1509: BEGIN
1510: IF ( l_book_classification = G_LEASEOP_DEAL_TYPE )
1511: THEN
1512: RETURN TRUE;

Line 1593: FROM OKL_ST_GEN_TMPT_SETS

1589: revenue_recog_meth_code,
1590: pricing_engine ,
1591: days_in_month_code ,
1592: days_in_yr_code
1593: FROM OKL_ST_GEN_TMPT_SETS
1594: WHERE ID = (
1595: SELECT gts_id
1596: FROM okl_st_gen_templates
1597: WHERE id = p_gtt_id

Line 1632: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;

1628: AND gtl.PRIMARY_STY_ID = stb.id
1629: AND gtl.primary_yn = 'Y'
1630: AND stb.stream_type_purpose ='RENT';
1631: --Local variable declarations
1632: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1633: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1634: l_purpose okl_strm_type_b.billable_yn%TYPE;
1635: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;

Line 1633: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

1629: AND gtl.primary_yn = 'Y'
1630: AND stb.stream_type_purpose ='RENT';
1631: --Local variable declarations
1632: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1633: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1634: l_purpose okl_strm_type_b.billable_yn%TYPE;
1635: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1637: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;

Line 1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;

1632: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1633: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1634: l_purpose okl_strm_type_b.billable_yn%TYPE;
1635: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1637: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1638: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1639: l_days_month_yr_concat VARCHAR2(2700);
1640: l_msgs_count NUMBER := 0;

Line 1637: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;

1633: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1634: l_purpose okl_strm_type_b.billable_yn%TYPE;
1635: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1637: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1638: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1639: l_days_month_yr_concat VARCHAR2(2700);
1640: l_msgs_count NUMBER := 0;
1641: l_message VARCHAR2(2700);

Line 1638: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;

1634: l_purpose okl_strm_type_b.billable_yn%TYPE;
1635: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1636: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1637: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1638: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1639: l_days_month_yr_concat VARCHAR2(2700);
1640: l_msgs_count NUMBER := 0;
1641: l_message VARCHAR2(2700);
1642: get_billable_flag_rec get_billable_flag%ROWTYPE;

Line 3158: FROM OKL_ST_GEN_TMPT_SETS gts,

3154: CURSOR fetch_sgt_info( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type)
3155: IS
3156: SELECT gts.revenue_recog_meth_code revenue_recog_meth_code,
3157: gts.interest_calc_meth_code interest_calc_meth_code
3158: FROM OKL_ST_GEN_TMPT_SETS gts,
3159: OKL_ST_GEN_TEMPLATES gtt
3160: WHERE gtt.gts_id = gts.id
3161: AND gtt.id = p_gtt_id;
3162: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

Line 3162: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

3158: FROM OKL_ST_GEN_TMPT_SETS gts,
3159: OKL_ST_GEN_TEMPLATES gtt
3160: WHERE gtt.gts_id = gts.id
3161: AND gtt.id = p_gtt_id;
3162: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
3163: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3164:
3165: l_purpose_list VARCHAR2(10000);
3166: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents

Line 3163: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;

3159: OKL_ST_GEN_TEMPLATES gtt
3160: WHERE gtt.gts_id = gts.id
3161: AND gtt.id = p_gtt_id;
3162: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
3163: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3164:
3165: l_purpose_list VARCHAR2(10000);
3166: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents
3167: l_purpose_list_rv VARCHAR2(10000); -- For Residual Value Dependents

Line 4159: ,OKL_ST_GEN_TMPT_SETS GTS

4155: ,GTS.DEAL_TYPE DEAL_TYPE
4156: ,STB.ID STRM_TYPE_ID
4157: ,STB.CODE STRM_NAME
4158: FROM OKL_ST_GEN_TMPT_LNS GTL
4159: ,OKL_ST_GEN_TMPT_SETS GTS
4160: ,OKL_ST_GEN_TEMPLATES GTT
4161: ,OKL_STRM_TYPE_B STB
4162: WHERE GTL.GTT_ID = p_gtt_id
4163: AND GTL.GTT_ID = GTT.ID

Line 4291: ,OKL_ST_GEN_TMPT_SETS GTS

4287: ,GTT.END_DATE END_DATE
4288: ,GTT.TMPT_STATUS TMPT_STATUS
4289: ,GTT.VERSION VERSION
4290: FROM OKL_ST_GEN_TEMPLATES GTT
4291: ,OKL_ST_GEN_TMPT_SETS GTS
4292: WHERE GTT.GTS_ID = GTS.ID
4293: AND GTT.ID = p_gtt_id;
4294: l_tmpt_set_rec okl_st_gen_templates_csr%ROWTYPE;
4295: BEGIN

Line 4548: l_deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE;

4544: l_purp_list VARCHAR2(250);
4545: -- Bug 4054596: Issue No. 5: End
4546:
4547: l_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;
4548: l_deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE;
4549:
4550: CURSOR tmpt_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE ) IS
4551: SELECT GTS.DEAL_TYPE DEAL_TYPE
4552: ,GTT.TMPT_STATUS TMPT_STATUS

Line 4554: FROM OKL_ST_GEN_TMPT_SETS GTS

4550: CURSOR tmpt_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE ) IS
4551: SELECT GTS.DEAL_TYPE DEAL_TYPE
4552: ,GTT.TMPT_STATUS TMPT_STATUS
4553: ,GTS.ID GTS_ID -- Bug 4094361, Modified by RGOOTY
4554: FROM OKL_ST_GEN_TMPT_SETS GTS
4555: ,OKL_ST_GEN_TEMPLATES GTT
4556: WHERE GTS.ID = GTT.GTS_ID
4557: AND GTT.ID = p_gtt_id;
4558:

Line 4576: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )

4572: l_pri_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE;
4573:
4574: -- Modified by RGOOTY
4575: -- Bug 4094361: Start
4576: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4577: IS
4578: SELECT PDT.ID PDT_ID
4579: ,PRODUCT_STATUS_CODE
4580: FROM OKL_PRODUCTS PDT,

Line 4581: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

4577: IS
4578: SELECT PDT.ID PDT_ID
4579: ,PRODUCT_STATUS_CODE
4580: FROM OKL_PRODUCTS PDT,
4581: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4582: WHERE PDT.AES_ID = ATS.ID
4583: AND ATS.GTS_ID = SGT.ID
4584: AND SGT.ID = p_gts_id;
4585:

Line 4586: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

4582: WHERE PDT.AES_ID = ATS.ID
4583: AND ATS.GTS_ID = SGT.ID
4584: AND SGT.ID = p_gts_id;
4585:
4586: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
4587: -- Bug 4094361: End
4588: BEGIN
4589: -- Perform the Initializations
4590: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4861: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )

4857: GROUP BY STYP.STREAM_TYPE_PURPOSE, STYP.CODE, STY.STREAM_TYPE_PURPOSE
4858: -- gboomina Bug 4874272 - Added STREAM_TYPE_PURPOSE in Group by - End
4859: HAVING COUNT( STY.STREAM_TYPE_PURPOSE) > 1;
4860: -- Cursor to fetch all the products which uses this SGT
4861: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4862: IS
4863: SELECT PDT.ID PDT_ID
4864: ,PRODUCT_STATUS_CODE
4865: FROM OKL_PRODUCTS PDT,

Line 4867: OKL_ST_GEN_TMPT_SETS SGT

4863: SELECT PDT.ID PDT_ID
4864: ,PRODUCT_STATUS_CODE
4865: FROM OKL_PRODUCTS PDT,
4866: OKL_AE_TMPT_SETS ATS,
4867: OKL_ST_GEN_TMPT_SETS SGT
4868: WHERE PDT.AES_ID = ATS.ID
4869: AND ATS.GTS_ID = SGT.ID
4870: AND SGT.ID = p_gts_id;
4871:

Line 4880: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

4876: l_missing_deps VARCHAR2(10000);
4877: l_show_warn_flag VARCHAR2(30);
4878: l_error_msgs_tbl error_msgs_tbl_type;
4879: l_return_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;
4880: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
4881: l_pri_purpose_list VARCHAR2(10000);
4882: l_found VARCHAR2(30);
4883: l_msg VARCHAR2(10000);
4884: l_pri_stream_name OKL_STRM_TYPE_B.CODE%TYPE;