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_STRM_TYPE_V

Line 24: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE

20: p_pdt_id IN NUMBER,
21: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
24: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE
25: )
26:
27: IS
28:

Line 53: OKL_STRM_TYPE_v STY

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:
55: WHERE
56: TLN.GTT_ID = TMPT.ID AND
57: TMPT.GTS_ID = Tst.ID AND

Line 73: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;

69: l_deal_type okl_k_headers.deal_type%Type;
70: l_report_product_id NUMBER;
71: l_contract_start_date DATE;
72: l_primary_sty_id NUMBER;
73: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;
74:
75: BEGIN
76:
77: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 142: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE

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
143: )
144:
145: IS
146:

Line 171: OKL_STRM_TYPE_v STY

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:
173: WHERE
174: TLN.GTT_ID = TMPT.ID AND
175: TMPT.GTS_ID = Tst.ID AND

Line 191: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;

187: l_deal_type okl_k_headers.deal_type%Type;
188: l_report_product_id NUMBER;
189: l_contract_start_date DATE;
190: l_primary_sty_id NUMBER;
191: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;
192:
193: BEGIN
194:
195: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 265: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS

261: p_pdt_id IN NUMBER,
262: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
265: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
266:
267: /*CURSOR get_k_info_csr (l_khr_id NUMBER)IS
268: SELECT pdt_id, start_date
269: FROM okl_k_headers_full_v

Line 299: OKL_STRM_TYPE_v STY

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
301: WHERE
302: TLN.GTT_ID = TMPT.ID AND
303: TMPT.GTS_ID = Tst.ID AND

Line 300: , OKL_STRM_TYPE_v STY1

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
301: WHERE
302: TLN.GTT_ID = TMPT.ID AND
303: TMPT.GTS_ID = Tst.ID AND
304: Tst.ID = AES.GTS_ID AND

Line 320: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;

316: l_deal_type okl_k_headers.deal_type%Type;
317: l_report_product_id NUMBER;
318: l_contract_start_date DATE;
319: l_dependetn_sty_id NUMBER;
320: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
321:
322: BEGIN
323: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
324:

Line 402: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS

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
403:
404: /*CURSOR get_k_info_csr (l_khr_id NUMBER)IS
405: SELECT pdt_id, start_date
406: FROM okl_k_headers_full_v

Line 436: OKL_STRM_TYPE_v STY

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
438: WHERE
439: TLN.GTT_ID = TMPT.ID AND
440: TMPT.GTS_ID = Tst.ID AND

Line 437: , OKL_STRM_TYPE_v STY1

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
438: WHERE
439: TLN.GTT_ID = TMPT.ID AND
440: TMPT.GTS_ID = Tst.ID AND
441: Tst.ID = AES.GTS_ID AND

Line 457: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;

453: l_deal_type okl_k_headers.deal_type%Type;
454: l_report_product_id NUMBER;
455: l_contract_start_date DATE;
456: l_dependetn_sty_id NUMBER;
457: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
458:
459: BEGIN
460: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
461:

Line 672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;

668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
675: l_fee_type VARCHAR2(30);
676: l_recurr_yn VARCHAR2(3):= OKL_API.G_FALSE;

Line 674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;

670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
675: l_fee_type VARCHAR2(30);
676: l_recurr_yn VARCHAR2(3):= OKL_API.G_FALSE;
677: l_pass_through_percentage NUMBER;
678: l_rec_period NUMBER;

Line 1260: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS

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,
1260: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
1261:
1262: CURSOR get_k_info_csr (l_khr_id NUMBER)IS
1263: SELECT pdt_id, start_date
1264: FROM okl_k_headers_full_v

Line 1277: OKL_STRM_TYPE_v STY

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
1279: WHERE
1280: TLN.GTT_ID = TMPT.ID AND
1281: TMPT.GTS_ID = Tst.ID AND

Line 1278: , OKL_STRM_TYPE_v STY1

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
1279: WHERE
1280: TLN.GTT_ID = TMPT.ID AND
1281: TMPT.GTS_ID = Tst.ID AND
1282: Tst.ID = AES.GTS_ID AND

Line 1297: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;

1293:
1294: l_product_id NUMBER;
1295: l_contract_start_date DATE;
1296: l_dependetn_sty_id NUMBER;
1297: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
1298: -- kthiruva bug#4371472 start
1299: l_deal_type okl_k_headers.deal_type%Type;
1300: l_report_product_id NUMBER;
1301: -- kthiruva bug#4371472 end

Line 1380: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,

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,
1381: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS
1382:
1383: CURSOR get_depend_strm_type_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
1384: SELECT

Line 1393: OKL_STRM_TYPE_v STY

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
1395: WHERE
1396: TLN.GTT_ID = TMPT.ID AND
1397: TMPT.GTS_ID = Tst.ID AND

Line 1394: , OKL_STRM_TYPE_v STY1

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
1395: WHERE
1396: TLN.GTT_ID = TMPT.ID AND
1397: TMPT.GTS_ID = Tst.ID AND
1398: Tst.ID = AES.GTS_ID AND

Line 1414: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;

1410: l_deal_type okl_k_headers.deal_type%Type;
1411: l_report_product_id NUMBER;
1412: l_contract_start_date DATE;
1413: l_dependetn_sty_id NUMBER;
1414: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
1415:
1416: BEGIN
1417: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1418:

Line 1490: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%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,
1490: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
1491: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS
1492:
1493: CURSOR get_depend_strm_type_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
1494: SELECT

Line 1503: OKL_STRM_TYPE_v STY

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
1505: WHERE
1506: TLN.GTT_ID = TMPT.ID AND
1507: TMPT.GTS_ID = Tst.ID AND

Line 1504: , OKL_STRM_TYPE_v STY1

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
1505: WHERE
1506: TLN.GTT_ID = TMPT.ID AND
1507: TMPT.GTS_ID = Tst.ID AND
1508: Tst.ID = AES.GTS_ID AND

Line 1523: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;

1519:
1520: l_product_id NUMBER;
1521: l_contract_start_date DATE;
1522: l_dependetn_sty_id NUMBER;
1523: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
1524: --bug#4371472 kthiruva start
1525: l_deal_type okl_k_headers.deal_type%Type;
1526: l_report_product_id NUMBER;
1527: --bug#4371472 kthiruva end