APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_ST_GEN_PRC_PARAMS

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

806: ,TMPT_STATUS
807: FROM OKL_ST_GEN_TEMPLATES
808: where ID = p_gtt_id;
809:
810: CURSOR okl_st_gen_prc_params_csr(p_gtt_id IN OKL_ST_GEN_PRC_PARAMS.gtt_id%type) IS
811: SELECT ID
812: ,NAME
813: ,DESCRIPTION
814: ,DISPLAY_YN

Line 819: FROM OKL_ST_GEN_PRC_PARAMS

815: ,UPDATE_YN
816: ,PRC_ENG_IDENT
817: ,DEFAULT_VALUE
818: ,GTT_ID
819: FROM OKL_ST_GEN_PRC_PARAMS
820: where GTT_ID = p_gtt_id;
821:
822: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
823: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS

Line 1002: FOR gtpv_rec_temp IN okl_st_gen_prc_params_csr(l_gtt_id)

998: RAISE OKL_API.G_EXCEPTION_ERROR;
999: END IF;
1000: -- Fetch all the pricing parameters and call the API
1001: i := 0;
1002: FOR gtpv_rec_temp IN okl_st_gen_prc_params_csr(l_gtt_id)
1003: LOOP
1004: l_gtpv_tbl_in(i).name := gtpv_rec_temp.name;
1005: l_gtpv_tbl_in(i).description := gtpv_rec_temp.description ;
1006: l_gtpv_tbl_in(i).display_yn := gtpv_rec_temp.display_yn ;