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 277: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )

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

Line 282: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

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

Line 325: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

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

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

793: l_gtlv_tbl_dep_out gtlv_tbl_type;
794: i NUMBER;
795: l_dummy VARCHAR2(1) := okl_api.G_FALSE;
796:
797: CURSOR okl_st_gen_tmpt_sets_csr(p_gts_id IN OKL_ST_GEN_TMPT_SETS.id%type) IS
798: SELECT ID
799: ,NAME
800: ,DESCRIPTION
801: ,PRODUCT_TYPE

Line 811: FROM OKL_ST_GEN_TMPT_SETS

807: ,days_in_month_code
808: ,days_in_yr_code
809: -- Added new field by DPSINGH for ER 6274342
810: ,isg_arrears_pay_dates_option
811: FROM OKL_ST_GEN_TMPT_SETS
812: WHERE ID = p_gts_id;
813:
814: CURSOR okl_st_gen_templates_csr(p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
815: SELECT ID

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

904: RAISE OKL_API.G_EXCEPTION_ERROR;
905: END IF;
906:
907: l_dummy := Okl_Api.G_FALSE;
908: FOR gtsv_rec_temp IN okl_st_gen_tmpt_sets_csr(l_gttv_rec_in.gts_id)
909: LOOP
910: l_gtsv_rec_in.id := gtsv_rec_temp.id;
911: l_gtsv_rec_in.name := gtsv_rec_temp.name;
912: l_gtsv_rec_in.description := gtsv_rec_temp.description;

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

1475: ---------------------------------------------------------------------------
1476: FUNCTION belongs_to_ls( p_book_classification IN VARCHAR2 )
1477: RETURN BOOLEAN
1478: IS
1479: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1480: BEGIN
1481: IF ( l_book_classification = G_LEASEDF_DEAL_TYPE OR
1482: l_book_classification = G_LEASEOP_DEAL_TYPE OR
1483: l_book_classification = G_LEASEST_DEAL_TYPE )

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

1490:
1491: FUNCTION belongs_to_ln( 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_LOAN_DEAL_TYPE OR
1497: l_book_classification = G_LOAN_REV_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_df_st( 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_LEASEDF_DEAL_TYPE OR
1511: l_book_classification = G_LEASEST_DEAL_TYPE )
1512: THEN

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

1518:
1519: FUNCTION belongs_to_op( p_book_classification IN VARCHAR2 )
1520: RETURN BOOLEAN
1521: IS
1522: l_book_classification OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE := UPPER( p_book_classification );
1523: BEGIN
1524: IF ( l_book_classification = G_LEASEOP_DEAL_TYPE )
1525: THEN
1526: RETURN TRUE;

Line 1607: FROM OKL_ST_GEN_TMPT_SETS

1603: revenue_recog_meth_code,
1604: pricing_engine ,
1605: days_in_month_code ,
1606: days_in_yr_code
1607: FROM OKL_ST_GEN_TMPT_SETS
1608: WHERE ID = (
1609: SELECT gts_id
1610: FROM okl_st_gen_templates
1611: WHERE id = p_gtt_id

Line 1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;

1642: AND gtl.PRIMARY_STY_ID = stb.id
1643: AND gtl.primary_yn = 'Y'
1644: AND stb.stream_type_purpose ='RENT';
1645: --Local variable declarations
1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;

Line 1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

1643: AND gtl.primary_yn = 'Y'
1644: AND stb.stream_type_purpose ='RENT';
1645: --Local variable declarations
1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;

Line 1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;

1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1653: l_days_month_yr_concat VARCHAR2(2700);
1654: l_msgs_count NUMBER := 0;

Line 1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;

1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1653: l_days_month_yr_concat VARCHAR2(2700);
1654: l_msgs_count NUMBER := 0;
1655: l_message VARCHAR2(2700);

Line 1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;

1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1653: l_days_month_yr_concat VARCHAR2(2700);
1654: l_msgs_count NUMBER := 0;
1655: l_message VARCHAR2(2700);
1656: get_billable_flag_rec get_billable_flag%ROWTYPE;

Line 3173: FROM OKL_ST_GEN_TMPT_SETS gts,

3169: CURSOR fetch_sgt_info( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type)
3170: IS
3171: SELECT gts.revenue_recog_meth_code revenue_recog_meth_code,
3172: gts.interest_calc_meth_code interest_calc_meth_code
3173: FROM OKL_ST_GEN_TMPT_SETS gts,
3174: OKL_ST_GEN_TEMPLATES gtt
3175: WHERE gtt.gts_id = gts.id
3176: AND gtt.id = p_gtt_id;
3177: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

Line 3177: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;

3173: FROM OKL_ST_GEN_TMPT_SETS gts,
3174: OKL_ST_GEN_TEMPLATES gtt
3175: WHERE gtt.gts_id = gts.id
3176: AND gtt.id = p_gtt_id;
3177: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
3178: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3179:
3180: l_purpose_list VARCHAR2(10000);
3181: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents

Line 3178: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;

3174: OKL_ST_GEN_TEMPLATES gtt
3175: WHERE gtt.gts_id = gts.id
3176: AND gtt.id = p_gtt_id;
3177: l_rrm OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
3178: l_icm OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
3179:
3180: l_purpose_list VARCHAR2(10000);
3181: l_purpose_list_rent VARCHAR2(10000); -- For Rent Dependents
3182: l_purpose_list_rv VARCHAR2(10000); -- For Residual Value Dependents

Line 4174: ,OKL_ST_GEN_TMPT_SETS GTS

4170: ,GTS.DEAL_TYPE DEAL_TYPE
4171: ,STB.ID STRM_TYPE_ID
4172: ,STB.CODE STRM_NAME
4173: FROM OKL_ST_GEN_TMPT_LNS GTL
4174: ,OKL_ST_GEN_TMPT_SETS GTS
4175: ,OKL_ST_GEN_TEMPLATES GTT
4176: ,OKL_STRM_TYPE_B STB
4177: WHERE GTL.GTT_ID = p_gtt_id
4178: AND GTL.GTT_ID = GTT.ID

Line 4306: ,OKL_ST_GEN_TMPT_SETS GTS

4302: ,GTT.END_DATE END_DATE
4303: ,GTT.TMPT_STATUS TMPT_STATUS
4304: ,GTT.VERSION VERSION
4305: FROM OKL_ST_GEN_TEMPLATES GTT
4306: ,OKL_ST_GEN_TMPT_SETS GTS
4307: WHERE GTT.GTS_ID = GTS.ID
4308: AND GTT.ID = p_gtt_id;
4309: l_tmpt_set_rec okl_st_gen_templates_csr%ROWTYPE;
4310: BEGIN

Line 4563: l_deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE;

4559: l_purp_list VARCHAR2(250);
4560: -- Bug 4054596: Issue No. 5: End
4561:
4562: l_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;
4563: l_deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE;
4564:
4565: CURSOR tmpt_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE ) IS
4566: SELECT GTS.DEAL_TYPE DEAL_TYPE
4567: ,GTT.TMPT_STATUS TMPT_STATUS

Line 4569: FROM OKL_ST_GEN_TMPT_SETS GTS

4565: CURSOR tmpt_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE ) IS
4566: SELECT GTS.DEAL_TYPE DEAL_TYPE
4567: ,GTT.TMPT_STATUS TMPT_STATUS
4568: ,GTS.ID GTS_ID -- Bug 4094361, Modified by RGOOTY
4569: FROM OKL_ST_GEN_TMPT_SETS GTS
4570: ,OKL_ST_GEN_TEMPLATES GTT
4571: WHERE GTS.ID = GTT.GTS_ID
4572: AND GTT.ID = p_gtt_id;
4573:

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

4587: l_pri_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE;
4588:
4589: -- Modified by RGOOTY
4590: -- Bug 4094361: Start
4591: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4592: IS
4593: SELECT PDT.ID PDT_ID
4594: ,PRODUCT_STATUS_CODE
4595: FROM OKL_PRODUCTS PDT,

Line 4596: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

4592: IS
4593: SELECT PDT.ID PDT_ID
4594: ,PRODUCT_STATUS_CODE
4595: FROM OKL_PRODUCTS PDT,
4596: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4597: WHERE PDT.AES_ID = ATS.ID
4598: AND ATS.GTS_ID = SGT.ID
4599: AND SGT.ID = p_gts_id;
4600:

Line 4601: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

4597: WHERE PDT.AES_ID = ATS.ID
4598: AND ATS.GTS_ID = SGT.ID
4599: AND SGT.ID = p_gts_id;
4600:
4601: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
4602: -- Bug 4094361: End
4603: BEGIN
4604: -- Perform the Initializations
4605: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

4872: GROUP BY STYP.STREAM_TYPE_PURPOSE, STYP.CODE, STY.STREAM_TYPE_PURPOSE
4873: -- gboomina Bug 4874272 - Added STREAM_TYPE_PURPOSE in Group by - End
4874: HAVING COUNT( STY.STREAM_TYPE_PURPOSE) > 1;
4875: -- Cursor to fetch all the products which uses this SGT
4876: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )
4877: IS
4878: SELECT PDT.ID PDT_ID
4879: ,PRODUCT_STATUS_CODE
4880: FROM OKL_PRODUCTS PDT,

Line 4882: OKL_ST_GEN_TMPT_SETS SGT

4878: SELECT PDT.ID PDT_ID
4879: ,PRODUCT_STATUS_CODE
4880: FROM OKL_PRODUCTS PDT,
4881: OKL_AE_TMPT_SETS ATS,
4882: OKL_ST_GEN_TMPT_SETS SGT
4883: WHERE PDT.AES_ID = ATS.ID
4884: AND ATS.GTS_ID = SGT.ID
4885: AND SGT.ID = p_gts_id;
4886:

Line 4895: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;

4891: l_missing_deps VARCHAR2(32000);
4892: l_show_warn_flag VARCHAR2(30);
4893: l_error_msgs_tbl error_msgs_tbl_type;
4894: l_return_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;
4895: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
4896: l_pri_purpose_list VARCHAR2(32000);
4897: l_found VARCHAR2(30);
4898: l_msg VARCHAR2(10000);
4899: l_pri_stream_name OKL_STRM_TYPE_B.CODE%TYPE;