DBA Data[Home] [Help]

APPS.OKC_OCE_PVT dependencies on OKC_OUTCOMES_V

Line 321: -- FUNCTION get_rec for: OKC_OUTCOMES_V

317: BEGIN
318: RETURN(get_rec(p_okc_outcomes_tl_rec, l_row_notfound));
319: END get_rec;
320: ---------------------------------------------------------------------------
321: -- FUNCTION get_rec for: OKC_OUTCOMES_V
322: ---------------------------------------------------------------------------
323: FUNCTION get_rec (
324: p_ocev_rec IN ocev_rec_type,
325: x_no_data_found OUT NOCOPY BOOLEAN

Line 362: FROM Okc_Outcomes_V

358: CREATION_DATE,
359: LAST_UPDATED_BY,
360: LAST_UPDATE_DATE,
361: LAST_UPDATE_LOGIN
362: FROM Okc_Outcomes_V
363: WHERE okc_outcomes_v.id = p_id;
364: l_okc_ocev_pk okc_ocev_pk_csr%ROWTYPE;
365: l_ocev_rec ocev_rec_type;
366: BEGIN

Line 363: WHERE okc_outcomes_v.id = p_id;

359: LAST_UPDATED_BY,
360: LAST_UPDATE_DATE,
361: LAST_UPDATE_LOGIN
362: FROM Okc_Outcomes_V
363: WHERE okc_outcomes_v.id = p_id;
364: l_okc_ocev_pk okc_ocev_pk_csr%ROWTYPE;
365: l_ocev_rec ocev_rec_type;
366: BEGIN
367: x_no_data_found := TRUE;

Line 418: -- FUNCTION null_out_defaults for: OKC_OUTCOMES_V --

414: RETURN(get_rec(p_ocev_rec, l_row_notfound));
415: END get_rec;
416:
417: ----------------------------------------------------
418: -- FUNCTION null_out_defaults for: OKC_OUTCOMES_V --
419: ----------------------------------------------------
420: FUNCTION null_out_defaults (
421: p_ocev_rec IN ocev_rec_type
422: ) RETURN ocev_rec_type IS

Line 529: -- Validate_Attributes for:OKC_OUTCOMES_V --

525: ---------------------------------------------------------------------------
526: -- PROCEDURE Validate_Attributes
527: ---------------------------------------------------------------------------
528: --------------------------------------------
529: -- Validate_Attributes for:OKC_OUTCOMES_V --
530: --------------------------------------------
531: FUNCTION Validate_Attributes (
532: p_ocev_rec IN ocev_rec_type
533: ) RETURN VARCHAR2 IS

Line 569: -- Validate_Record for:OKC_OUTCOMES_V --

565: ---------------------------------------------------------------------------
566: -- PROCEDURE Validate_Record
567: ---------------------------------------------------------------------------
568: ----------------------------------------
569: -- Validate_Record for:OKC_OUTCOMES_V --
570: ----------------------------------------
571: FUNCTION Validate_Record (
572: p_ocev_rec IN ocev_rec_type
573: ) RETURN VARCHAR2 IS

Line 779: -- Validate_Attributes for:OKC_OUTCOMES_V --

775: ---------------------------------------------------------------------------
776: -- PROCEDURE Validate_Attributes
777: ---------------------------------------------------------------------------
778: --------------------------------------------
779: -- Validate_Attributes for:OKC_OUTCOMES_V --
780: --------------------------------------------
781: -- Start of comments
782: -- Procedure Name : validate_object_version_number
783: -- Description : Check if object_version_number is not null

Line 1138: p_token2_value => 'OKC_OUTCOMES_V',

1134: p_msg_name => g_no_parent_record,
1135: p_token1 => g_col_name_token,
1136: p_token1_value => 'cnh_id',
1137: p_token2 => g_child_table_token,
1138: p_token2_value => 'OKC_OUTCOMES_V',
1139: p_token3 => g_parent_table_token,
1140: p_token3_value => 'OKC_CONDITION_HEADERS_V');
1141: x_return_status := OKC_API.G_RET_STS_ERROR;
1142: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1193: From okc_process_defs_v pdf, okc_outcomes_v oce

1189: and cnh.acn_id = acn.id;
1190:
1191: CURSOR pdf_type_csr(p_pdf_id IN NUMBER) IS
1192: Select pdf.usage, pdf.pdf_type
1193: From okc_process_defs_v pdf, okc_outcomes_v oce
1194: where pdf.id = p_pdf_id
1195: and pdf.id = oce.pdf_id;
1196:
1197: l_dummy VARCHAR2(1) := '?';

Line 1227: p_token2_value => 'OKC_OUTCOMES_V',

1223: p_msg_name => g_no_parent_record,
1224: p_token1 => g_col_name_token,
1225: p_token1_value => 'pdf_id',
1226: p_token2 => g_child_table_token,
1227: p_token2_value => 'OKC_OUTCOMES_V',
1228: p_token3 => g_parent_table_token,
1229: p_token3_value => 'OKC_PROCESS_DEFS_V');
1230: x_return_status := OKC_API.G_RET_STS_ERROR;
1231: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1493: -- Validate_Record for:OKC_OUTCOMES_V --

1489: ---------------------------------------------------------------------------
1490: -- PROCEDURE Validate_Record
1491: ---------------------------------------------------------------------------
1492: ----------------------------------------
1493: -- Validate_Record for:OKC_OUTCOMES_V --
1494: ----------------------------------------
1495: FUNCTION Validate_Record (
1496: p_ocev_rec IN ocev_rec_type
1497: ) RETURN VARCHAR2 IS

Line 1613: -- validate_row for:OKC_OUTCOMES_V --

1609: ---------------------------------------------------------------------------
1610: -- PROCEDURE validate_row
1611: ---------------------------------------------------------------------------
1612: -------------------------------------
1613: -- validate_row for:OKC_OUTCOMES_V --
1614: -------------------------------------
1615: PROCEDURE validate_row(
1616: p_api_version IN NUMBER,
1617: p_init_msg_list IN VARCHAR2 ,

Line 2019: -- insert_row for:OKC_OUTCOMES_V --

2015: '_PVT'
2016: );
2017: END insert_row;
2018: -----------------------------------
2019: -- insert_row for:OKC_OUTCOMES_V --
2020: -----------------------------------
2021: PROCEDURE insert_row(
2022: p_api_version IN NUMBER,
2023: p_init_msg_list IN VARCHAR2 ,

Line 2056: -- Set_Attributes for:OKC_OUTCOMES_V --

2052: l_ocev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2053: RETURN(l_ocev_rec);
2054: END fill_who_columns;
2055: ---------------------------------------
2056: -- Set_Attributes for:OKC_OUTCOMES_V --
2057: ---------------------------------------
2058: FUNCTION Set_Attributes (
2059: p_ocev_rec IN ocev_rec_type,
2060: x_ocev_rec OUT NOCOPY ocev_rec_type

Line 2453: -- lock_row for:OKC_OUTCOMES_V --

2449: '_PVT'
2450: );
2451: END lock_row;
2452: ---------------------------------
2453: -- lock_row for:OKC_OUTCOMES_V --
2454: ---------------------------------
2455: PROCEDURE lock_row(
2456: p_api_version IN NUMBER,
2457: p_init_msg_list IN VARCHAR2 ,

Line 3047: -- update_row for:OKC_OUTCOMES_V --

3043: '_PVT'
3044: );
3045: END update_row;
3046: -----------------------------------
3047: -- update_row for:OKC_OUTCOMES_V --
3048: -----------------------------------
3049: PROCEDURE update_row(
3050: p_api_version IN NUMBER,
3051: p_init_msg_list IN VARCHAR2 ,

Line 3232: -- Set_Attributes for:OKC_OUTCOMES_V --

3228: END IF;
3229: RETURN(l_return_status);
3230: END populate_new_record;
3231: ---------------------------------------
3232: -- Set_Attributes for:OKC_OUTCOMES_V --
3233: ---------------------------------------
3234: FUNCTION Set_Attributes (
3235: p_ocev_rec IN ocev_rec_type,
3236: x_ocev_rec OUT NOCOPY ocev_rec_type

Line 3583: -- delete_row for:OKC_OUTCOMES_V --

3579: '_PVT'
3580: );
3581: END delete_row;
3582: -----------------------------------
3583: -- delete_row for:OKC_OUTCOMES_V --
3584: -----------------------------------
3585: PROCEDURE delete_row(
3586: p_api_version IN NUMBER,
3587: p_init_msg_list IN VARCHAR2 ,