APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_ST_GEN_PRC_PARAMS

Line 824: CURSOR okl_st_gen_prc_params_csr(p_gtt_id IN OKL_ST_GEN_PRC_PARAMS.gtt_id%type) IS

820: ,TMPT_STATUS
821: FROM OKL_ST_GEN_TEMPLATES
822: where ID = p_gtt_id;
823:
824: CURSOR okl_st_gen_prc_params_csr(p_gtt_id IN OKL_ST_GEN_PRC_PARAMS.gtt_id%type) IS
825: SELECT ID
826: ,NAME
827: ,DESCRIPTION
828: ,DISPLAY_YN

Line 833: FROM OKL_ST_GEN_PRC_PARAMS

829: ,UPDATE_YN
830: ,PRC_ENG_IDENT
831: ,DEFAULT_VALUE
832: ,GTT_ID
833: FROM OKL_ST_GEN_PRC_PARAMS
834: where GTT_ID = p_gtt_id;
835:
836: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
837: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS

Line 1016: FOR gtpv_rec_temp IN okl_st_gen_prc_params_csr(l_gtt_id)

1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1014: -- Fetch all the pricing parameters and call the API
1015: i := 0;
1016: FOR gtpv_rec_temp IN okl_st_gen_prc_params_csr(l_gtt_id)
1017: LOOP
1018: l_gtpv_tbl_in(i).name := gtpv_rec_temp.name;
1019: l_gtpv_tbl_in(i).description := gtpv_rec_temp.description ;
1020: l_gtpv_tbl_in(i).display_yn := gtpv_rec_temp.display_yn ;