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_SETUPPRODUCTS_PVT dependencies on OKL_PRODUCTS_V

Line 24: -- PROCEDURE get_rec for: OKL_PRODUCTS_V

20: SUBTYPE psyv_rec_type IS Okl_Pdt_Stys_Pub.psyv_rec_type;
21: SUBTYPE psyv_tbl_type IS Okl_Pdt_Stys_Pub.psyv_tbl_type;
22:
23: ---------------------------------------------------------------------------
24: -- PROCEDURE get_rec for: OKL_PRODUCTS_V
25: ---------------------------------------------------------------------------
26: PROCEDURE get_rec (
27: p_pdtv_rec IN pdtv_rec_type,
28: x_return_status OUT NOCOPY VARCHAR2,

Line 67: FROM Okl_Products_V

63: CREATION_DATE,
64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE,
66: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
67: FROM Okl_Products_V
68: WHERE okl_products_v.id = p_id;
69: l_okl_pdtv_pk okl_pdtv_pk_csr%ROWTYPE;
70: l_pdtv_rec pdtv_rec_type;
71: BEGIN

Line 68: WHERE okl_products_v.id = p_id;

64: LAST_UPDATED_BY,
65: LAST_UPDATE_DATE,
66: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
67: FROM Okl_Products_V
68: WHERE okl_products_v.id = p_id;
69: l_okl_pdtv_pk okl_pdtv_pk_csr%ROWTYPE;
70: l_pdtv_rec pdtv_rec_type;
71: BEGIN
72: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 279: -- PROCEDURE check_constraints for: OKL_PRODUCTS_V

275: END delete_pdt_psys;
276:
277:
278: ---------------------------------------------------------------------------
279: -- PROCEDURE check_constraints for: OKL_PRODUCTS_V
280: -- To verify whether the dates are valid in the following entities
281: -- 1. Quality Value
282: -- 2. Option
283: -- 3. Option Value

Line 301: CURSOR okl_contracts_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,

297: x_return_status OUT NOCOPY VARCHAR2,
298:
299: x_valid OUT NOCOPY BOOLEAN
300: ) IS
301: CURSOR okl_contracts_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
302: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
303: p_to_date IN Okl_Products_V.TO_DATE%TYPE
304: ) IS
305: SELECT '1'

Line 302: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,

298:
299: x_valid OUT NOCOPY BOOLEAN
300: ) IS
301: CURSOR okl_contracts_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
302: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
303: p_to_date IN Okl_Products_V.TO_DATE%TYPE
304: ) IS
305: SELECT '1'
306: FROM Okl_K_Headers_V khr,

Line 303: p_to_date IN Okl_Products_V.TO_DATE%TYPE

299: x_valid OUT NOCOPY BOOLEAN
300: ) IS
301: CURSOR okl_contracts_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
302: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
303: p_to_date IN Okl_Products_V.TO_DATE%TYPE
304: ) IS
305: SELECT '1'
306: FROM Okl_K_Headers_V khr,
307: Okl_K_Headers_Full_V khf

Line 318: CURSOR okl_pdt_constraints_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,

314: ) IS
315: SELECT '1' FROM okl_k_headers_v khdr
316: WHERE khdr.pdt_id = p_pdt_id;
317:
318: CURSOR okl_pdt_constraints_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'

Line 319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,

315: SELECT '1' FROM okl_k_headers_v khdr
316: WHERE khdr.pdt_id = p_pdt_id;
317:
318: CURSOR okl_pdt_constraints_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pqy_Values_V qve,

Line 320: p_to_date IN Okl_Products_V.TO_DATE%TYPE

316: WHERE khdr.pdt_id = p_pdt_id;
317:
318: CURSOR okl_pdt_constraints_csr (p_pdt_id IN Okl_Products_V.ID%TYPE,
319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pqy_Values_V qve,
324: Okl_Pdt_Pqy_Vals_V pqv

Line 362: CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,

358: NVL(sty.END_DATE, p_to_date) < p_to_date)
359: */
360:
361:
362: CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,
363: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
365: p_to_date IN Okl_Products_V.TO_DATE%TYPE
366: ) IS

Line 363: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

359: */
360:
361:
362: CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,
363: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
365: p_to_date IN Okl_Products_V.TO_DATE%TYPE
366: ) IS
367: SELECT '1'

Line 364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,

360:
361:
362: CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,
363: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
365: p_to_date IN Okl_Products_V.TO_DATE%TYPE
366: ) IS
367: SELECT '1'
368: FROM Okl_Ae_Tmpt_Sets_V aes

Line 365: p_to_date IN Okl_Products_V.TO_DATE%TYPE

361:
362: CURSOR okl_pdt_aes_ptl_csr (p_aes_id IN Okl_Products_V.AES_ID%TYPE,
363: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
364: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
365: p_to_date IN Okl_Products_V.TO_DATE%TYPE
366: ) IS
367: SELECT '1'
368: FROM Okl_Ae_Tmpt_Sets_V aes
369: WHERE aes.ID = p_aes_id

Line 381: CURSOR c1(p_name okl_products_v.name%TYPE,

377: AND ((PTL.FROM_DATE > p_from_date OR
378: p_from_date > NVL(PTL.TO_DATE,p_from_date)) OR
379: NVL(PTL.TO_DATE, p_to_date) < p_to_date);
380:
381: CURSOR c1(p_name okl_products_v.name%TYPE,
382: p_version okl_products_v.version%TYPE) IS
383: SELECT '1'
384: FROM okl_products_v
385: WHERE name = p_name

Line 382: p_version okl_products_v.version%TYPE) IS

378: p_from_date > NVL(PTL.TO_DATE,p_from_date)) OR
379: NVL(PTL.TO_DATE, p_to_date) < p_to_date);
380:
381: CURSOR c1(p_name okl_products_v.name%TYPE,
382: p_version okl_products_v.version%TYPE) IS
383: SELECT '1'
384: FROM okl_products_v
385: WHERE name = p_name
386:

Line 384: FROM okl_products_v

380:
381: CURSOR c1(p_name okl_products_v.name%TYPE,
382: p_version okl_products_v.version%TYPE) IS
383: SELECT '1'
384: FROM okl_products_v
385: WHERE name = p_name
386:
387: AND version = p_version;
388:

Line 427: l_name okl_products_v.name%TYPE;

423: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
424: l_row_found BOOLEAN := FALSE;
425: l_check VARCHAR2(1) := '?';
426: l_row_not_found BOOLEAN := FALSE;
427: l_name okl_products_v.name%TYPE;
428: l_to_date okl_products_v.TO_DATE%TYPE;
429: BEGIN
430: x_valid := TRUE;
431: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 428: l_to_date okl_products_v.TO_DATE%TYPE;

424: l_row_found BOOLEAN := FALSE;
425: l_check VARCHAR2(1) := '?';
426: l_row_not_found BOOLEAN := FALSE;
427: l_name okl_products_v.name%TYPE;
428: l_to_date okl_products_v.TO_DATE%TYPE;
429: BEGIN
430: x_valid := TRUE;
431: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
432:

Line 847: CURSOR okl_pdt_parameters_cur(cp_pdt_id IN okl_products_v.id%TYPE)

843: p_product_date IN DATE DEFAULT SYSDATE,
844: p_pdt_parameter_rec OUT NOCOPY pdt_parameters_rec_type
845: )
846: IS
847: CURSOR okl_pdt_parameters_cur(cp_pdt_id IN okl_products_v.id%TYPE)
848: IS
849: SELECT
850: Name,
851: Product_subclass,

Line 983: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)

979: SELECT okl_wf_item_s.NEXTVAL
980: FROM dual;
981:
982: -- Get product Details
983: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)
984: IS
985: SELECT pdt.product_status_code status
986:
987: FROM okl_products_v pdt

Line 987: FROM okl_products_v pdt

983: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)
984: IS
985: SELECT pdt.product_status_code status
986:
987: FROM okl_products_v pdt
988: WHERE pdt.id = p_pdt_id;
989:
990: -- modification by dcshanmu for bug 5999276 ends
991: -- Get OU id for the ATS

Line 992: CURSOR c_get_ou_for_aes_id_csr(p_aes_id OKl_products_V.AES_ID%TYPE)

988: WHERE pdt.id = p_pdt_id;
989:
990: -- modification by dcshanmu for bug 5999276 ends
991: -- Get OU id for the ATS
992: CURSOR c_get_ou_for_aes_id_csr(p_aes_id OKl_products_V.AES_ID%TYPE)
993: IS
994: SELECT ORG_ID
995: FROM OKL_AE_TMPT_SETS_ALL aes
996: WHERE aes.ID = p_aes_id;

Line 1003: l_status OKL_PRODUCTS_V.product_status_code%TYPE;

999: -- modification by dcshanmu for bug 5999276 ends
1000:
1001:
1002: l_seq NUMBER ;
1003: l_status OKL_PRODUCTS_V.product_status_code%TYPE;
1004: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1005: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1006: l_api_version NUMBER := 1.0;
1007: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

Line 1004: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;

1000:
1001:
1002: l_seq NUMBER ;
1003: l_status OKL_PRODUCTS_V.product_status_code%TYPE;
1004: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1005: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1006: l_api_version NUMBER := 1.0;
1007: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1008: l_api_name CONSTANT VARCHAR2(30) := 'product_approval_process';

Line 1289: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;

1285:
1286: l_parameter_list wf_parameter_list_t;
1287: l_key VARCHAR2(240);
1288: l_event_name VARCHAR2(240);
1289: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1290:
1291: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
1292: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
1293: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

Line 1686: p_aes_id okl_products_v.aes_id%TYPE)

1682: AND a.id = p_pdt_id;
1683:
1684: /*
1685: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1686: p_aes_id okl_products_v.aes_id%TYPE)
1687: IS
1688: SELECT DISTINCT C.deal_type
1689: FROM okl_products_v a,
1690: okl_ae_tmpt_sets_v b,

Line 1689: FROM okl_products_v a,

1685: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1686: p_aes_id okl_products_v.aes_id%TYPE)
1687: IS
1688: SELECT DISTINCT C.deal_type
1689: FROM okl_products_v a,
1690: okl_ae_tmpt_sets_v b,
1691: OKL_ST_GEN_TMPT_SETS c
1692: WHERE a.aes_id = b.id
1693: AND b.gts_id = c.id

Line 1706: FROM okl_products_v a,

1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1703: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,
1707: okl_ae_tmpt_sets_v b,
1708: OKL_ST_GEN_TMPT_SETS c
1709: WHERE a.aes_id = b.id
1710: AND b.gts_id = c.id

Line 1910: FROM OKL_PRODUCTS_V PDT,

1906: gts.deal_type,
1907: gts.tax_owner,
1908: gts.interest_calc_meth_code,
1909: gts.revenue_recog_meth_code
1910: FROM OKL_PRODUCTS_V PDT,
1911: OKL_AE_TMPT_SETS_V AES,
1912: OKL_ST_GEN_TMPT_SETS GTS
1913: WHERE PDT.AES_ID = AES.ID
1914: AND AES.GTS_ID = GTS.ID

Line 1917: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,

1913: WHERE PDT.AES_ID = AES.ID
1914: AND AES.GTS_ID = GTS.ID
1915: AND PDT.ID = p_pdt_id;
1916:
1917: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1918: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1919: p_pdt_id IN Okl_Products_V.id%TYPE)
1920: IS
1921: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 1918: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

1914: AND AES.GTS_ID = GTS.ID
1915: AND PDT.ID = p_pdt_id;
1916:
1917: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1918: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1919: p_pdt_id IN Okl_Products_V.id%TYPE)
1920: IS
1921: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1922: FROM okl_ae_tmpt_sets_v b,

Line 1919: p_pdt_id IN Okl_Products_V.id%TYPE)

1915: AND PDT.ID = p_pdt_id;
1916:
1917: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1918: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1919: p_pdt_id IN Okl_Products_V.id%TYPE)
1920: IS
1921: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1922: FROM okl_ae_tmpt_sets_v b,
1923: OKL_ST_GEN_TMPT_SETS c

Line 1939: CURSOR c_st_gen_templates_cur (p_pdt_id IN okl_products_v.id%TYPE)

1935: CURSOR c_tax_sty_id_cur IS
1936: SELECT tax_upfront_sty_id
1937: FROM OKL_SYSTEM_PARAMS;
1938:
1939: CURSOR c_st_gen_templates_cur (p_pdt_id IN okl_products_v.id%TYPE)
1940: IS
1941: SELECT gttv.id gtt_id, gtsv.name name, gttv.version version
1942: FROM
1943: OKL_ST_GEN_TEMPLATES GTTV,

Line 1947: okl_products_v PDT

1943: OKL_ST_GEN_TEMPLATES GTTV,
1944: OKL_ST_GEN_TMPT_SETS GTSV,
1945:
1946: okl_ae_tmpt_sets_v AES,
1947: okl_products_v PDT
1948: WHERE
1949: GTTV.gts_id = GTSV.id AND
1950: GTTV.tmpt_status = 'ACTIVE' AND
1951: GTSV.id = AES.gts_id AND

Line 2006: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;

2002: l_qv_found BOOLEAN;
2003: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;
2004: -- Bug 6803437: Start
2005: l_rp_pdt_sts_code VARCHAR2(30);
2006: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;
2007: l_raise_exception BOOLEAN := FALSE;
2008: -- Bug 6803437: End
2009: --rkuttiya added for 12.1.1 Multi GAAP Project
2010: l_rpt_deal_type VARCHAR2(150);

Line 3176: p_table => 'Okl_Products_V',

3172: p_from_date => l_pdtv_rec.from_date,
3173: p_to_date => l_pdtv_rec.TO_DATE,
3174:
3175:
3176: p_table => 'Okl_Products_V',
3177: x_return_status => l_return_status,
3178: x_valid => l_valid);
3179: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 3240: -- PROCEDURE determine_action for: OKL_PRODUCTS_V

3236: END check_updates;
3237:
3238:
3239: ---------------------------------------------------------------------------
3240: -- PROCEDURE determine_action for: OKL_PRODUCTS_V
3241: -- This function helps in determining the various checks to be performed
3242: -- for the new/updated record and also helps in determining whether a new
3243: -- version is required or not
3244: ---------------------------------------------------------------------------

Line 3273: -- PROCEDURE get_prod_strm_types for: OKL_PRODUCTS_V

3269: RETURN(l_action);
3270: END determine_action;
3271:
3272: ---------------------------------------------------------------------------
3273: -- PROCEDURE get_prod_strm_types for: OKL_PRODUCTS_V
3274:
3275: -- To fetch the product Stream Types that are attached to the existing
3276: -- version of the product
3277: ---------------------------------------------------------------------------

Line 3349: -- PROCEDURE get_pdt_pqy_vals for: OKL_PRODUCTS_V

3345:
3346: END get_prod_strm_types;
3347:
3348: ---------------------------------------------------------------------------
3349: -- PROCEDURE get_pdt_pqy_vals for: OKL_PRODUCTS_V
3350: -- To fetch the product quality values that are attached to the existing
3351: -- version of the product
3352: ---------------------------------------------------------------------------
3353: PROCEDURE get_pdt_pqy_vals (p_upd_pdtv_rec IN pdtv_rec_type,

Line 3423: -- PROCEDURE get_pdt_opts for: OKL_PRODUCTS_V

3419:
3420: END get_pdt_pqy_vals;
3421:
3422: ---------------------------------------------------------------------------
3423: -- PROCEDURE get_pdt_opts for: OKL_PRODUCTS_V
3424: -- To fetch the product options that are attached to the existing
3425: -- version of the product
3426: ---------------------------------------------------------------------------
3427: PROCEDURE get_pdt_opts (p_upd_pdtv_rec IN pdtv_rec_type,

Line 3497: -- PROCEDURE get_pdt_opt_vals for: OKL_PRODUCTS_V

3493:
3494: END get_pdt_opts;
3495:
3496: ---------------------------------------------------------------------------
3497: -- PROCEDURE get_pdt_opt_vals for: OKL_PRODUCTS_V
3498: -- To fetch the valid option values for the attached options to the existing
3499: -- version of the product
3500: ---------------------------------------------------------------------------
3501: PROCEDURE get_pdt_opt_vals (p_upd_pdtv_rec IN pdtv_rec_type,

Line 3510: CURSOR okl_povv_fk_csr (p_pdt_id IN Okl_Products_V.id%TYPE) IS

3506: x_count OUT NOCOPY NUMBER,
3507: x_povv_tbl OUT NOCOPY povv_tbl_type
3508:
3509: ) IS
3510: CURSOR okl_povv_fk_csr (p_pdt_id IN Okl_Products_V.id%TYPE) IS
3511: SELECT pov.ID ID,
3512: ove.OPT_ID OPT_ID,
3513: pov.OVE_ID OVE_ID,
3514: pov.FROM_DATE FROM_DATE,

Line 3581: -- PROCEDURE copy_update_constraints for: OKL_PRODUCTS_V

3577:
3578: END get_pdt_opt_vals;
3579:
3580: ---------------------------------------------------------------------------
3581: -- PROCEDURE copy_update_constraints for: OKL_PRODUCTS_V
3582: -- To copy constraints data from one version to the other
3583: ---------------------------------------------------------------------------
3584: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
3585: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 3910: -- PROCEDURE insert_products for: OKL_PRODUCTS_V

3906:
3907: END copy_update_constraints;
3908:
3909: ---------------------------------------------------------------------------
3910: -- PROCEDURE insert_products for: OKL_PRODUCTS_V
3911: ---------------------------------------------------------------------------
3912:
3913: PROCEDURE insert_products(p_api_version IN NUMBER,
3914: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 3930: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,

3926: l_pdtv_rec pdtv_rec_type;
3927: l_db_pdtv_rec pdtv_rec_type;
3928: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3929:
3930: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3931: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3932: p_pdt_id IN Okl_Products_V.id%TYPE)
3933: IS
3934: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 3931: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

3927: l_db_pdtv_rec pdtv_rec_type;
3928: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3929:
3930: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3931: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3932: p_pdt_id IN Okl_Products_V.id%TYPE)
3933: IS
3934: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3935: FROM okl_ae_tmpt_sets_v b,

Line 3932: p_pdt_id IN Okl_Products_V.id%TYPE)

3928: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3929:
3930: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3931: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3932: p_pdt_id IN Okl_Products_V.id%TYPE)
3933: IS
3934: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3935: FROM okl_ae_tmpt_sets_v b,
3936: OKL_ST_GEN_TMPT_SETS c

Line 4089: -- PROCEDURE update_products for: OKL_PRODUCTS_V

4085: END insert_products;
4086:
4087:
4088: ---------------------------------------------------------------------------
4089: -- PROCEDURE update_products for: OKL_PRODUCTS_V
4090: ---------------------------------------------------------------------------
4091: PROCEDURE update_products(p_api_version IN NUMBER,
4092: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4093: x_return_status OUT NOCOPY VARCHAR2,

Line 4128: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,

4124: l_chk_bc VARCHAR2(100);
4125:
4126:
4127:
4128: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4129: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4130: p_pdt_id IN Okl_Products_V.id%TYPE)
4131: IS
4132: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 4129: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

4125:
4126:
4127:
4128: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4129: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4130: p_pdt_id IN Okl_Products_V.id%TYPE)
4131: IS
4132: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4133: FROM okl_ae_tmpt_sets_v b,

Line 4130: p_pdt_id IN Okl_Products_V.id%TYPE)

4126:
4127:
4128: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4129: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4130: p_pdt_id IN Okl_Products_V.id%TYPE)
4131: IS
4132: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4133: FROM okl_ae_tmpt_sets_v b,
4134: OKL_ST_GEN_TMPT_SETS c