APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 919: okl_st_gen_tmpt_sets gts

915: 'Y'
916: FROM
917: okl_st_gen_tmpt_lns gtl,
918: okl_st_gen_templates gtt,
919: okl_st_gen_tmpt_sets gts
920: WHERE
921: gtl.primary_sty_id = p_sty_id AND
922: gtl.gtt_id = gtt.id AND
923: gtt.gts_id = gts.id AND

Line 2190: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;

2186:
2187: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
2188: l_error_msgs_tbl error_msgs_tbl_type;
2189:
2190: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2191: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2192: l_gtt_id OKL_ST_GEN_TEMPLATES.id%TYPE;
2193: l_gtt_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;
2194: l_gtt_out_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;

Line 2191: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;

2187: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
2188: l_error_msgs_tbl error_msgs_tbl_type;
2189:
2190: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2191: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2192: l_gtt_id OKL_ST_GEN_TEMPLATES.id%TYPE;
2193: l_gtt_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;
2194: l_gtt_out_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;
2195: l_gts_found VARCHAR2(1);

Line 2242: OKL_ST_GEN_TMPT_SETS gts,

2238: gts.name,
2239: gtt.id gtt_id,
2240: gtt.tmpt_status
2241: FROM
2242: OKL_ST_GEN_TMPT_SETS gts,
2243: OKL_ST_GEN_TEMPLATES gtt
2244: WHERE
2245: gts.id = gtt.gts_id AND
2246: gts.name = l_name;

Line 2718: FROM OKL_ST_GEN_TMPT_SETS gts, OKL_ST_GEN_TEMPLATES gtt

2714: -- of deal type and tax owner.
2715:
2716: CURSOR st_tmpt_csr (p_deal_type VARCHAR2, p_tax_owner VARCHAR2, l_name VARCHAR2) IS
2717: SELECT gts.id, gts.name
2718: FROM OKL_ST_GEN_TMPT_SETS gts, OKL_ST_GEN_TEMPLATES gtt
2719: WHERE gts.id = gtt.gts_id AND
2720: gts.deal_type = p_deal_type
2721: AND gts.tax_owner = p_tax_owner AND
2722: gts.name = l_name AND

Line 2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;

2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;
2863: l_template_id okl_ae_templates.id%TYPE;
2864: l_new_template_id okl_ae_templates.id%TYPE;
2865:
2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2867: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;
2869:
2870: l_row_found VARCHAR2(1000);

Line 2867: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;

2863: l_template_id okl_ae_templates.id%TYPE;
2864: l_new_template_id okl_ae_templates.id%TYPE;
2865:
2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2867: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;
2869:
2870: l_row_found VARCHAR2(1000);
2871: l_template_set_found VARCHAR2(1);