[Home] [Help]
33: chr.start_date,
34: khr.deal_type,
35: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
36: FROM okc_k_headers_v chr,
37: okl_k_headers khr,
38: okl_products_v pdt
39: WHERE khr.id = chr.id
40: AND chr.id = l_khr_id
41: AND khr.pdt_id = pdt.id(+);
65: AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
66: AND STY.STREAM_TYPE_PURPOSE = p_primary_sty_purpose;
67:
68: l_product_id NUMBER;
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;
151: chr.start_date,
152: khr.deal_type,
153: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
154: FROM okc_k_headers_v chr,
155: okl_k_headers khr,
156: okl_products_v pdt
157: WHERE khr.id = chr.id
158: AND chr.id = l_khr_id
159: AND khr.pdt_id = pdt.id(+);
183: AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
184: AND STY.STREAM_TYPE_PURPOSE = p_primary_sty_purpose;
185:
186: l_product_id NUMBER;
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;
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
270: WHERE id = l_khr_id; */
271: -- 30-NOV-04 GKADARKA V115.3 -- Fixes for bug 4036231
272: -- Added support for multi GAPP product
273: -- Changed the below cursor to get report product id also
279: chr.start_date,
280: khr.deal_type,
281: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
282: FROM okc_k_headers_v chr,
283: okl_k_headers khr,
284: okl_products_v pdt
285: WHERE khr.id = chr.id
286: AND chr.id = l_khr_id
287: AND khr.pdt_id = pdt.id(+);
312: AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
313: AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
314:
315: l_product_id NUMBER;
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;
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
407: WHERE id = l_khr_id; */
408: -- 30-NOV-04 GKADARKA V115.3 -- Fixes for bug 4036231
409: -- Added support for multi GAPP product
410: -- Changed the below cursor to get report product id also
416: chr.start_date,
417: khr.deal_type,
418: nvl(pdt.reporting_pdt_id, -1) report_pdt_id
419: FROM okc_k_headers_v chr,
420: okl_k_headers khr,
421: okl_products_v pdt
422: WHERE khr.id = chr.id
423: AND chr.id = l_khr_id
424: AND khr.pdt_id = pdt.id(+);
449: AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
450: AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
451:
452: l_product_id NUMBER;
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;
545: ) AS
546:
547: CURSOR get_k_info_csr (l_khr_id NUMBER)IS
548: SELECT deal_type
549: FROM okl_k_headers_h
550: WHERE id = l_khr_id;
551:
552: CURSOR get_strm_type_purpose(l_lookup_code VARCHAR2) IS
553: SELECT LOOKUP_CODE FROM fnd_lookups
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
1265: WHERE id = l_khr_id;
1266:
1267: CURSOR get_depend_strm_type_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
1268: SELECT
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
1302: BEGIN
1303: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1406: AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
1407: AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
1408:
1409: l_product_id NUMBER;
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;
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
1528:
1529: BEGIN
1606: -- or overwritten at STG
1607: -- Parameters :
1608: -- IN : p_khr_id IN NUMBER Required
1609: -- Corresponds to the column ID
1610: -- in the table okl_k_headers.
1611: -- Version : 1.0
1612: -- History : Added by DJANASWA for ER 6274342
1613: -- End of comments
1614:
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
1636: khr.id = p_khr_id
1637: AND pdt.id = khr.pdt_id
1638: AND aes.id = pdt.aes_id