DBA Data[Home] [Help]

APPS.OKL_CUV_PVT dependencies on OKL_CRTRN_USER_VALS_V

Line 95: p_token3_value => 'OKL_CRTRN_USER_VALS_V');

91: p_token1_value => 'CRN_ID_FOR',
92: p_token2 => G_CHILD_TABLE_TOKEN,
93: p_token2_value => G_VIEW,
94: p_token3 => G_PARENT_TABLE_TOKEN,
95: p_token3_value => 'OKL_CRTRN_USER_VALS_V');
96:
97: RAISE G_EXCEPTION_HALT_VALIDATION;
98: END IF;
99: END validate_crn_id;

Line 383: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_V

379: BEGIN
380: RETURN(get_rec(p_okl_crtrn_user_vals_tl_rec, l_row_notfound));
381: END get_rec;
382: ---------------------------------------------------------------------------
383: -- FUNCTION get_rec for: OKL_CRTRN_USER_VALS_V
384: ---------------------------------------------------------------------------
385: FUNCTION get_rec (
386: p_cuvv_rec IN cuvv_rec_type,
387: x_no_data_found OUT NOCOPY BOOLEAN

Line 419: FROM Okl_Crtrn_User_Vals_V

415: CREATION_DATE,
416: LAST_UPDATED_BY,
417: LAST_UPDATE_DATE,
418: LAST_UPDATE_LOGIN
419: FROM Okl_Crtrn_User_Vals_V
420: WHERE okl_crtrn_user_vals_v.id = p_id;
421: l_okl_cuvv_pk okl_cuvv_pk_csr%ROWTYPE;
422: l_cuvv_rec cuvv_rec_type;
423: BEGIN

Line 420: WHERE okl_crtrn_user_vals_v.id = p_id;

416: LAST_UPDATED_BY,
417: LAST_UPDATE_DATE,
418: LAST_UPDATE_LOGIN
419: FROM Okl_Crtrn_User_Vals_V
420: WHERE okl_crtrn_user_vals_v.id = p_id;
421: l_okl_cuvv_pk okl_cuvv_pk_csr%ROWTYPE;
422: l_cuvv_rec cuvv_rec_type;
423: BEGIN
424: x_no_data_found := TRUE;

Line 470: -- FUNCTION null_out_defaults for: OKL_CRTRN_USER_VALS_V --

466: RETURN(get_rec(p_cuvv_rec, l_row_notfound));
467: END get_rec;
468:
469: -----------------------------------------------------------
470: -- FUNCTION null_out_defaults for: OKL_CRTRN_USER_VALS_V --
471: -----------------------------------------------------------
472: FUNCTION null_out_defaults (
473: p_cuvv_rec IN cuvv_rec_type
474: ) RETURN cuvv_rec_type IS

Line 564: -- Validate_Attributes for:OKL_CRTRN_USER_VALS_V --

560: ---------------------------------------------------------------------------
561: -- PROCEDURE Validate_Attributes
562: ---------------------------------------------------------------------------
563: ---------------------------------------------------
564: -- Validate_Attributes for:OKL_CRTRN_USER_VALS_V --
565: ---------------------------------------------------
566: FUNCTION Validate_Attributes (
567: p_cuvv_rec IN cuvv_rec_type
568: ) RETURN VARCHAR2 IS

Line 660: -- Validate_Record for:OKL_CRTRN_USER_VALS_V --

656: ---------------------------------------------------------------------------
657: -- PROCEDURE Validate_Record
658: ---------------------------------------------------------------------------
659: -----------------------------------------------
660: -- Validate_Record for:OKL_CRTRN_USER_VALS_V --
661: -----------------------------------------------
662: FUNCTION Validate_Record (
663: p_cuvv_rec IN cuvv_rec_type
664: ) RETURN VARCHAR2 IS

Line 770: -- validate_row for:OKL_CRTRN_USER_VALS_V --

766: ---------------------------------------------------------------------------
767: -- PROCEDURE validate_row
768: ---------------------------------------------------------------------------
769: --------------------------------------------
770: -- validate_row for:OKL_CRTRN_USER_VALS_V --
771: --------------------------------------------
772: PROCEDURE validate_row(
773: p_api_version IN NUMBER,
774: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1166: -- insert_row for:OKL_CRTRN_USER_VALS_V --

1162: '_PVT'
1163: );
1164: END insert_row;
1165: ------------------------------------------
1166: -- insert_row for:OKL_CRTRN_USER_VALS_V --
1167: ------------------------------------------
1168: PROCEDURE insert_row(
1169: p_api_version IN NUMBER,
1170: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1202: -- Set_Attributes for:OKL_CRTRN_USER_VALS_V --

1198: l_cuvv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1199: RETURN(l_cuvv_rec);
1200: END fill_who_columns;
1201: ----------------------------------------------
1202: -- Set_Attributes for:OKL_CRTRN_USER_VALS_V --
1203: ----------------------------------------------
1204: FUNCTION Set_Attributes (
1205: p_cuvv_rec IN cuvv_rec_type,
1206: x_cuvv_rec OUT NOCOPY cuvv_rec_type

Line 1589: -- lock_row for:OKL_CRTRN_USER_VALS_V --

1585: '_PVT'
1586: );
1587: END lock_row;
1588: ----------------------------------------
1589: -- lock_row for:OKL_CRTRN_USER_VALS_V --
1590: ----------------------------------------
1591: PROCEDURE lock_row(
1592: p_api_version IN NUMBER,
1593: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2157: -- update_row for:OKL_CRTRN_USER_VALS_V --

2153: '_PVT'
2154: );
2155: END update_row;
2156: ------------------------------------------
2157: -- update_row for:OKL_CRTRN_USER_VALS_V --
2158: ------------------------------------------
2159: PROCEDURE update_row(
2160: p_api_version IN NUMBER,
2161: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2322: -- Set_Attributes for:OKL_CRTRN_USER_VALS_V --

2318: END IF;
2319: RETURN(l_return_status);
2320: END populate_new_record;
2321: ----------------------------------------------
2322: -- Set_Attributes for:OKL_CRTRN_USER_VALS_V --
2323: ----------------------------------------------
2324: FUNCTION Set_Attributes (
2325: p_cuvv_rec IN cuvv_rec_type,
2326: x_cuvv_rec OUT NOCOPY cuvv_rec_type

Line 2665: -- delete_row for:OKL_CRTRN_USER_VALS_V --

2661: '_PVT'
2662: );
2663: END delete_row;
2664: ------------------------------------------
2665: -- delete_row for:OKL_CRTRN_USER_VALS_V --
2666: ------------------------------------------
2667: PROCEDURE delete_row(
2668: p_api_version IN NUMBER,
2669: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,