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:
430: l_rep_ptl_id NUMBER; -- racheruv..R12.1.2
431: BEGIN

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:
430: l_rep_ptl_id NUMBER; -- racheruv..R12.1.2
431: BEGIN
432: x_valid := TRUE;

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

860: p_product_date IN DATE DEFAULT SYSDATE,
861: p_pdt_parameter_rec OUT NOCOPY pdt_parameters_rec_type
862: )
863: IS
864: CURSOR okl_pdt_parameters_cur(cp_pdt_id IN okl_products_v.id%TYPE)
865: IS
866: SELECT
867: Name,
868: Product_subclass,

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

996: SELECT okl_wf_item_s.NEXTVAL
997: FROM dual;
998:
999: -- Get product Details
1000: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)
1001: IS
1002: SELECT pdt.product_status_code status
1003:
1004: FROM okl_products_v pdt

Line 1004: FROM okl_products_v pdt

1000: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)
1001: IS
1002: SELECT pdt.product_status_code status
1003:
1004: FROM okl_products_v pdt
1005: WHERE pdt.id = p_pdt_id;
1006:
1007: -- modification by dcshanmu for bug 5999276 ends
1008: -- Get OU id for the ATS

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

1005: WHERE pdt.id = p_pdt_id;
1006:
1007: -- modification by dcshanmu for bug 5999276 ends
1008: -- Get OU id for the ATS
1009: CURSOR c_get_ou_for_aes_id_csr(p_aes_id OKl_products_V.AES_ID%TYPE)
1010: IS
1011: SELECT ORG_ID
1012: FROM OKL_AE_TMPT_SETS_ALL aes
1013: WHERE aes.ID = p_aes_id;

Line 1020: l_status OKL_PRODUCTS_V.product_status_code%TYPE;

1016: -- modification by dcshanmu for bug 5999276 ends
1017:
1018:
1019: l_seq NUMBER ;
1020: l_status OKL_PRODUCTS_V.product_status_code%TYPE;
1021: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1022: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1023: l_api_version NUMBER := 1.0;
1024: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

Line 1021: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;

1017:
1018:
1019: l_seq NUMBER ;
1020: l_status OKL_PRODUCTS_V.product_status_code%TYPE;
1021: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1022: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1023: l_api_version NUMBER := 1.0;
1024: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1025: l_api_name CONSTANT VARCHAR2(30) := 'product_approval_process';

Line 1306: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;

1302:
1303: l_parameter_list wf_parameter_list_t;
1304: l_key VARCHAR2(240);
1305: l_event_name VARCHAR2(240);
1306: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1307:
1308: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
1309: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
1310: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

Line 1703: p_aes_id okl_products_v.aes_id%TYPE)

1699: AND a.id = p_pdt_id;
1700:
1701: /*
1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1703: p_aes_id okl_products_v.aes_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,
1707: okl_ae_tmpt_sets_v b,

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_aes_id okl_products_v.aes_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 1723: FROM okl_products_v a,

1719: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1720: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1721: IS
1722: SELECT DISTINCT C.deal_type
1723: FROM okl_products_v a,
1724: okl_ae_tmpt_sets_v b,
1725: OKL_ST_GEN_TMPT_SETS c
1726: WHERE a.aes_id = b.id
1727: AND b.gts_id = c.id

Line 1927: FROM OKL_PRODUCTS_V PDT,

1923: gts.deal_type,
1924: gts.tax_owner,
1925: gts.interest_calc_meth_code,
1926: gts.revenue_recog_meth_code
1927: FROM OKL_PRODUCTS_V PDT,
1928: OKL_AE_TMPT_SETS_V AES,
1929: OKL_ST_GEN_TMPT_SETS GTS
1930: WHERE PDT.AES_ID = AES.ID
1931: AND AES.GTS_ID = GTS.ID

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

1930: WHERE PDT.AES_ID = AES.ID
1931: AND AES.GTS_ID = GTS.ID
1932: AND PDT.ID = p_pdt_id;
1933:
1934: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1935: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1936: p_pdt_id IN Okl_Products_V.id%TYPE)
1937: IS
1938: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 1935: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

1931: AND AES.GTS_ID = GTS.ID
1932: AND PDT.ID = p_pdt_id;
1933:
1934: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1935: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1936: p_pdt_id IN Okl_Products_V.id%TYPE)
1937: IS
1938: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1939: FROM okl_ae_tmpt_sets_v b,

Line 1936: p_pdt_id IN Okl_Products_V.id%TYPE)

1932: AND PDT.ID = p_pdt_id;
1933:
1934: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
1935: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
1936: p_pdt_id IN Okl_Products_V.id%TYPE)
1937: IS
1938: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
1939: FROM okl_ae_tmpt_sets_v b,
1940: OKL_ST_GEN_TMPT_SETS c

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

1952: CURSOR c_tax_sty_id_cur IS
1953: SELECT tax_upfront_sty_id
1954: FROM OKL_SYSTEM_PARAMS;
1955:
1956: CURSOR c_st_gen_templates_cur (p_pdt_id IN okl_products_v.id%TYPE)
1957: IS
1958: SELECT gttv.id gtt_id, gtsv.name name, gttv.version version
1959: FROM
1960: OKL_ST_GEN_TEMPLATES GTTV,

Line 1964: okl_products_v PDT

1960: OKL_ST_GEN_TEMPLATES GTTV,
1961: OKL_ST_GEN_TMPT_SETS GTSV,
1962:
1963: okl_ae_tmpt_sets_v AES,
1964: okl_products_v PDT
1965: WHERE
1966: GTTV.gts_id = GTSV.id AND
1967: GTTV.tmpt_status = 'ACTIVE' AND
1968: GTSV.id = AES.gts_id AND

Line 2023: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;

2019: l_qv_found BOOLEAN;
2020: l_inv_deal_type OKL_ST_GEN_TMPT_SETS.deal_type%TYPE;
2021: -- Bug 6803437: Start
2022: l_rp_pdt_sts_code VARCHAR2(30);
2023: l_rp_pdt_name OKL_PRODUCTS_V.NAME%TYPE;
2024: l_raise_exception BOOLEAN := FALSE;
2025: -- Bug 6803437: End
2026: --rkuttiya added for 12.1.1 Multi GAAP Project
2027: l_rpt_deal_type VARCHAR2(150);

Line 3205: p_table => 'Okl_Products_V',

3201: p_from_date => l_pdtv_rec.from_date,
3202: p_to_date => l_pdtv_rec.TO_DATE,
3203:
3204:
3205: p_table => 'Okl_Products_V',
3206: x_return_status => l_return_status,
3207: x_valid => l_valid);
3208: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3209: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 3269: -- PROCEDURE determine_action for: OKL_PRODUCTS_V

3265: END check_updates;
3266:
3267:
3268: ---------------------------------------------------------------------------
3269: -- PROCEDURE determine_action for: OKL_PRODUCTS_V
3270: -- This function helps in determining the various checks to be performed
3271: -- for the new/updated record and also helps in determining whether a new
3272: -- version is required or not
3273: ---------------------------------------------------------------------------

Line 3302: -- PROCEDURE get_prod_strm_types for: OKL_PRODUCTS_V

3298: RETURN(l_action);
3299: END determine_action;
3300:
3301: ---------------------------------------------------------------------------
3302: -- PROCEDURE get_prod_strm_types for: OKL_PRODUCTS_V
3303:
3304: -- To fetch the product Stream Types that are attached to the existing
3305: -- version of the product
3306: ---------------------------------------------------------------------------

Line 3378: -- PROCEDURE get_pdt_pqy_vals for: OKL_PRODUCTS_V

3374:
3375: END get_prod_strm_types;
3376:
3377: ---------------------------------------------------------------------------
3378: -- PROCEDURE get_pdt_pqy_vals for: OKL_PRODUCTS_V
3379: -- To fetch the product quality values that are attached to the existing
3380: -- version of the product
3381: ---------------------------------------------------------------------------
3382: PROCEDURE get_pdt_pqy_vals (p_upd_pdtv_rec IN pdtv_rec_type,

Line 3452: -- PROCEDURE get_pdt_opts for: OKL_PRODUCTS_V

3448:
3449: END get_pdt_pqy_vals;
3450:
3451: ---------------------------------------------------------------------------
3452: -- PROCEDURE get_pdt_opts for: OKL_PRODUCTS_V
3453: -- To fetch the product options that are attached to the existing
3454: -- version of the product
3455: ---------------------------------------------------------------------------
3456: PROCEDURE get_pdt_opts (p_upd_pdtv_rec IN pdtv_rec_type,

Line 3526: -- PROCEDURE get_pdt_opt_vals for: OKL_PRODUCTS_V

3522:
3523: END get_pdt_opts;
3524:
3525: ---------------------------------------------------------------------------
3526: -- PROCEDURE get_pdt_opt_vals for: OKL_PRODUCTS_V
3527: -- To fetch the valid option values for the attached options to the existing
3528: -- version of the product
3529: ---------------------------------------------------------------------------
3530: PROCEDURE get_pdt_opt_vals (p_upd_pdtv_rec IN pdtv_rec_type,

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

3535: x_count OUT NOCOPY NUMBER,
3536: x_povv_tbl OUT NOCOPY povv_tbl_type
3537:
3538: ) IS
3539: CURSOR okl_povv_fk_csr (p_pdt_id IN Okl_Products_V.id%TYPE) IS
3540: SELECT pov.ID ID,
3541: ove.OPT_ID OPT_ID,
3542: pov.OVE_ID OVE_ID,
3543: pov.FROM_DATE FROM_DATE,

Line 3610: -- PROCEDURE copy_update_constraints for: OKL_PRODUCTS_V

3606:
3607: END get_pdt_opt_vals;
3608:
3609: ---------------------------------------------------------------------------
3610: -- PROCEDURE copy_update_constraints for: OKL_PRODUCTS_V
3611: -- To copy constraints data from one version to the other
3612: ---------------------------------------------------------------------------
3613: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
3614: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 3939: -- PROCEDURE insert_products for: OKL_PRODUCTS_V

3935:
3936: END copy_update_constraints;
3937:
3938: ---------------------------------------------------------------------------
3939: -- PROCEDURE insert_products for: OKL_PRODUCTS_V
3940: ---------------------------------------------------------------------------
3941:
3942: PROCEDURE insert_products(p_api_version IN NUMBER,
3943: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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

3955: l_pdtv_rec pdtv_rec_type;
3956: l_db_pdtv_rec pdtv_rec_type;
3957: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3958:
3959: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3960: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3961: p_pdt_id IN Okl_Products_V.id%TYPE)
3962: IS
3963: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 3960: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

3956: l_db_pdtv_rec pdtv_rec_type;
3957: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3958:
3959: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3960: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3961: p_pdt_id IN Okl_Products_V.id%TYPE)
3962: IS
3963: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3964: FROM okl_ae_tmpt_sets_v b,

Line 3961: p_pdt_id IN Okl_Products_V.id%TYPE)

3957: l_sysdate DATE := to_date(to_char(SYSDATE, 'DD/MM/YYYY'), 'DD/MM/YYYY');
3958:
3959: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
3960: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
3961: p_pdt_id IN Okl_Products_V.id%TYPE)
3962: IS
3963: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
3964: FROM okl_ae_tmpt_sets_v b,
3965: OKL_ST_GEN_TMPT_SETS c

Line 4118: -- PROCEDURE update_products for: OKL_PRODUCTS_V

4114: END insert_products;
4115:
4116:
4117: ---------------------------------------------------------------------------
4118: -- PROCEDURE update_products for: OKL_PRODUCTS_V
4119: ---------------------------------------------------------------------------
4120: PROCEDURE update_products(p_api_version IN NUMBER,
4121: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
4122: x_return_status OUT NOCOPY VARCHAR2,

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

4153: l_chk_bc VARCHAR2(100);
4154:
4155:
4156:
4157: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4158: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4159: p_pdt_id IN Okl_Products_V.id%TYPE)
4160: IS
4161: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')

Line 4158: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,

4154:
4155:
4156:
4157: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4158: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4159: p_pdt_id IN Okl_Products_V.id%TYPE)
4160: IS
4161: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4162: FROM okl_ae_tmpt_sets_v b,

Line 4159: p_pdt_id IN Okl_Products_V.id%TYPE)

4155:
4156:
4157: CURSOR chk_ptl_aes_bc(p_aes_id IN Okl_Products_V.AES_ID%TYPE,
4158: p_ptl_id IN Okl_Products_V.PTL_ID%TYPE,
4159: p_pdt_id IN Okl_Products_V.id%TYPE)
4160: IS
4161: SELECT DISTINCT DECODE(C.product_type,'FINANCIAL','LEASE','INVESTOR')
4162: FROM okl_ae_tmpt_sets_v b,
4163: OKL_ST_GEN_TMPT_SETS c