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_STREAM_MIGRATION_PVT dependencies on OKL_ST_GEN_TEMPLATES

Line 918: okl_st_gen_templates gtt,

914: SELECT
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

Line 2192: l_gtt_id OKL_ST_GEN_TEMPLATES.id%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);
2196:

Line 2193: l_gtt_status OKL_ST_GEN_TEMPLATES.tmpt_status%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);
2196:
2197: l_api_version NUMBER DEFAULT 1.0;

Line 2194: l_gtt_out_status OKL_ST_GEN_TEMPLATES.tmpt_status%TYPE;

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);
2196:
2197: l_api_version NUMBER DEFAULT 1.0;
2198: l_init_msg_list VARCHAR2(1) DEFAULT Okl_Api.g_false;

Line 2243: OKL_ST_GEN_TEMPLATES gtt

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;
2247:

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