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_ISG_UTILS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 50: OKL_ST_GEN_TMPT_SETS Tst,

46: STY.NAME PRIMARY_STY_NAME
47: FROM
48: OKL_ST_GEN_TMPT_LNS TLN,
49: OKL_ST_GEN_TEMPLATES TMPT,
50: OKL_ST_GEN_TMPT_SETS Tst,
51: OKL_AE_TMPT_SETS AES,
52: OKL_PRODUCTS_V PDT,
53: OKL_STRM_TYPE_v STY
54:

Line 138: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

134:
135: PROCEDURE get_primary_stream_type
136: (
137: p_khr_id IN NUMBER,
138: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
139: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
142: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE

Line 168: OKL_ST_GEN_TMPT_SETS Tst,

164: STY.NAME PRIMARY_STY_NAME
165: FROM
166: OKL_ST_GEN_TMPT_LNS TLN,
167: OKL_ST_GEN_TEMPLATES TMPT,
168: OKL_ST_GEN_TMPT_SETS Tst,
169: OKL_AE_TMPT_SETS AES,
170: OKL_PRODUCTS_V PDT,
171: OKL_STRM_TYPE_v STY
172:

Line 296: OKL_ST_GEN_TMPT_SETS Tst,

292: STY1.NAME DEPENDENT_STY_NAME
293: FROM
294: OKL_ST_GEN_TMPT_LNS TLN,
295: OKL_ST_GEN_TEMPLATES TMPT,
296: OKL_ST_GEN_TMPT_SETS Tst,
297: OKL_AE_TMPT_SETS AES,
298: OKL_PRODUCTS_V PDT,
299: OKL_STRM_TYPE_v STY
300: , OKL_STRM_TYPE_v STY1

Line 398: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

394: -- End of comments
395:
396: PROCEDURE get_dependent_stream_type(
397: p_khr_id IN NUMBER,
398: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
399: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
402: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS

Line 433: OKL_ST_GEN_TMPT_SETS Tst,

429: STY1.NAME DEPENDENT_STY_NAME
430: FROM
431: OKL_ST_GEN_TMPT_LNS TLN,
432: OKL_ST_GEN_TEMPLATES TMPT,
433: OKL_ST_GEN_TMPT_SETS Tst,
434: OKL_AE_TMPT_SETS AES,
435: OKL_PRODUCTS_V PDT,
436: OKL_STRM_TYPE_v STY
437: , OKL_STRM_TYPE_v STY1

Line 1255: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

1251: -- End of comments
1252:
1253: PROCEDURE get_dependent_stream_type(
1254: p_khr_id IN NUMBER,
1255: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1256: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1257: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1258: x_return_status OUT NOCOPY VARCHAR2,
1259: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

Line 1274: OKL_ST_GEN_TMPT_SETS Tst,

1270: STY1.NAME DEPENDENT_STY_NAME
1271: FROM
1272: OKL_ST_GEN_TMPT_LNS TLN,
1273: OKL_ST_GEN_TEMPLATES TMPT,
1274: OKL_ST_GEN_TMPT_SETS Tst,
1275: OKL_AE_TMPT_SETS AES,
1276: OKL_PRODUCTS_V PDT,
1277: OKL_STRM_TYPE_v STY
1278: , OKL_STRM_TYPE_v STY1

Line 1376: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

1372: -- Added by RGOOTY: Start
1373: -- Functions Added for improving the performance for ISG
1374: PROCEDURE get_dep_stream_type(
1375: p_khr_id IN NUMBER,
1376: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1377: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1380: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,

Line 1390: OKL_ST_GEN_TMPT_SETS Tst,

1386: STY1.NAME DEPENDENT_STY_NAME
1387: FROM
1388: OKL_ST_GEN_TMPT_LNS TLN,
1389: OKL_ST_GEN_TEMPLATES TMPT,
1390: OKL_ST_GEN_TMPT_SETS Tst,
1391: OKL_AE_TMPT_SETS AES,
1392: OKL_PRODUCTS_V PDT,
1393: OKL_STRM_TYPE_v STY
1394: , OKL_STRM_TYPE_v STY1

Line 1485: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,

1481:
1482: -- Overloaded get_dep_stream_type
1483: PROCEDURE get_dep_stream_type(
1484: p_khr_id IN NUMBER,
1485: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1486: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1487: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1488: x_return_status OUT NOCOPY VARCHAR2,
1489: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

Line 1500: OKL_ST_GEN_TMPT_SETS Tst,

1496: STY1.NAME DEPENDENT_STY_NAME
1497: FROM
1498: OKL_ST_GEN_TMPT_LNS TLN,
1499: OKL_ST_GEN_TEMPLATES TMPT,
1500: OKL_ST_GEN_TMPT_SETS Tst,
1501: OKL_AE_TMPT_SETS AES,
1502: OKL_PRODUCTS_V PDT,
1503: OKL_STRM_TYPE_v STY
1504: , OKL_STRM_TYPE_v STY1

Line 1631: okl_st_gen_tmpt_sets tst,

1627: IS
1628: SELECT
1629: tst.isg_arrears_pay_dates_option
1630: FROM
1631: okl_st_gen_tmpt_sets tst,
1632: okl_ae_tmpt_sets_all aes,
1633: okl_products_v pdt,
1634: okl_k_headers khr
1635: WHERE