APPS.OKC_LSE_PVT dependencies on OKC_LINE_STYLES_V

Line 289: -- FUNCTION get_rec for: OKC_LINE_STYLES_V

285: BEGIN
286: RETURN(get_rec(p_okc_line_styles_tl_rec, l_row_notfound));
287: END get_rec;
288: ---------------------------------------------------------------------------
289: -- FUNCTION get_rec for: OKC_LINE_STYLES_V
290: ---------------------------------------------------------------------------
291: FUNCTION get_rec (
292: p_lsev_rec IN lsev_rec_type,
293: x_no_data_found OUT NOCOPY BOOLEAN

Line 334: FROM Okc_Line_Styles_v

330: ITEM_TO_PRICE_YN,
331: PRICE_BASIS_YN,
332: ACCESS_LEVEL,
333: SERVICE_ITEM_YN
334: FROM Okc_Line_Styles_v
335: WHERE okc_line_styles_v.id = p_id;
336: l_okc_lsev_pk okc_lsev_pk_csr%ROWTYPE;
337: l_lsev_rec lsev_rec_type;
338: BEGIN

Line 335: WHERE okc_line_styles_v.id = p_id;

331: PRICE_BASIS_YN,
332: ACCESS_LEVEL,
333: SERVICE_ITEM_YN
334: FROM Okc_Line_Styles_v
335: WHERE okc_line_styles_v.id = p_id;
336: l_okc_lsev_pk okc_lsev_pk_csr%ROWTYPE;
337: l_lsev_rec lsev_rec_type;
338: BEGIN
339: x_no_data_found := TRUE;

Line 394: -- FUNCTION null_out_defaults for: OKC_LINE_STYLES_V --

390: RETURN(get_rec(p_lsev_rec, l_row_notfound));
391: END get_rec;
392:
393: -------------------------------------------------------
394: -- FUNCTION null_out_defaults for: OKC_LINE_STYLES_V --
395: -------------------------------------------------------
396: FUNCTION null_out_defaults (
397: p_lsev_rec IN lsev_rec_type
398: ) RETURN lsev_rec_type IS

Line 515: -- Validate_Attributes for:OKC_LINE_STYLES_V --

511: ---------------------------------------------------------------------------
512: -- PROCEDURE Validate_Attributes
513: ---------------------------------------------------------------------------
514: -----------------------------------------------
515: -- Validate_Attributes for:OKC_LINE_STYLES_V --
516: -----------------------------------------------
517: --**** Change from TAPI Code---follow till end of change---------------
518:
519: FUNCTION Check_Unique_Name (

Line 536: select name from okc_line_styles_v

532: connect by prior id = lse_parent_id
533: start with id = p_id;
534:
535: CURSOR par_name_csr(p_id IN NUMBER) is
536: select name from okc_line_styles_v
537: where id = p_id;
538:
539: CURSOR C1 is select id from okc_line_styles_v
540: where lse_type='TLS' and UPPER(name)=UPPER(p_lsev_rec.name);

Line 539: CURSOR C1 is select id from okc_line_styles_v

535: CURSOR par_name_csr(p_id IN NUMBER) is
536: select name from okc_line_styles_v
537: where id = p_id;
538:
539: CURSOR C1 is select id from okc_line_styles_v
540: where lse_type='TLS' and UPPER(name)=UPPER(p_lsev_rec.name);
541:
542: loc_top_rec loc_top_csr%rowtype;
543: loc_bot_rec loc_bot_csr%rowtype;

Line 1339: -- Validate_Record for:OKC_LINE_STYLES_V --

1335: ---------------------------------------------------------------------------
1336: -- PROCEDURE Validate_Record
1337: ---------------------------------------------------------------------------
1338: ------------------------------------------
1339: -- Validate_Record for:OKC_LINE_STYLES_V --
1340: ------------------------------------------
1341: FUNCTION Validate_Record (
1342: p_lsev_rec IN lsev_rec_type
1343: ) RETURN VARCHAR2 IS

Line 1471: -- validate_row for:OKC_LINE_STYLES_V --

1467: ---------------------------------------------------------------------------
1468: -- PROCEDURE validate_row
1469: ---------------------------------------------------------------------------
1470: ----------------------------------------
1471: -- validate_row for:OKC_LINE_STYLES_V --
1472: ----------------------------------------
1473: PROCEDURE validate_row(
1474: p_api_version IN NUMBER,
1475: p_init_msg_list IN VARCHAR2 ,

Line 1885: -- insert_row for:OKC_LINE_STYLES_V --

1881: '_PVT'
1882: );
1883: END insert_row;
1884: --------------------------------------
1885: -- insert_row for:OKC_LINE_STYLES_V --
1886: --------------------------------------
1887: PROCEDURE insert_row(
1888: p_api_version IN NUMBER,
1889: p_init_msg_list IN VARCHAR2 ,

Line 1921: -- Set_Attributes for:OKC_LINE_STYLES_V --

1917: l_lsev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1918: RETURN(l_lsev_rec);
1919: END fill_who_columns;
1920: ------------------------------------------
1921: -- Set_Attributes for:OKC_LINE_STYLES_V --
1922: ------------------------------------------
1923: FUNCTION Set_Attributes (
1924: p_lsev_rec IN lsev_rec_type,
1925: x_lsev_rec OUT NOCOPY lsev_rec_type

Line 2308: -- lock_row for:OKC_LINE_STYLES_V --

2304: '_PVT'
2305: );
2306: END lock_row;
2307: ------------------------------------
2308: -- lock_row for:OKC_LINE_STYLES_V --
2309: ------------------------------------
2310: PROCEDURE lock_row(
2311: p_api_version IN NUMBER,
2312: p_init_msg_list IN VARCHAR2 ,

Line 2919: -- update_row for:OKC_LINE_STYLES_V --

2915: '_PVT'
2916: );
2917: END update_row;
2918: --------------------------------------
2919: -- update_row for:OKC_LINE_STYLES_V --
2920: --------------------------------------
2921: PROCEDURE update_row(
2922: p_api_version IN NUMBER,
2923: p_init_msg_list IN VARCHAR2 ,

Line 3112: -- Set_Attributes for:OKC_LINE_STYLES_V --

3108: END IF;
3109: RETURN(l_return_status);
3110: END populate_new_record;
3111: ------------------------------------------
3112: -- Set_Attributes for:OKC_LINE_STYLES_V --
3113: ------------------------------------------
3114: FUNCTION Set_Attributes (
3115: p_lsev_rec IN lsev_rec_type,
3116: x_lsev_rec OUT NOCOPY lsev_rec_type

Line 3460: -- delete_row for:OKC_LINE_STYLES_V --

3456: '_PVT'
3457: );
3458: END delete_row;
3459: --------------------------------------
3460: -- delete_row for:OKC_LINE_STYLES_V --
3461: --------------------------------------
3462: PROCEDURE delete_row(
3463: p_api_version IN NUMBER,
3464: p_init_msg_list IN VARCHAR2 ,