APPS.OKL_CRN_PVT dependencies on OKL_CRITERIA_V

Line 153: FROM OKL_CRITERIA_V

149: ) RETURN VARCHAR2 IS
150:
151: CURSOR l_crnv_csr IS
152: SELECT 'x'
153: FROM OKL_CRITERIA_V
154: WHERE name = p_crnv_rec.name
155: AND id <> nvl (p_crnv_rec.id, -99999);
156:
157: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 450: -- FUNCTION get_rec for: OKL_CRITERIA_V

446: BEGIN
447: RETURN(get_rec(p_okl_criteria_tl_rec, l_row_notfound));
448: END get_rec;
449: ---------------------------------------------------------------------------
450: -- FUNCTION get_rec for: OKL_CRITERIA_V
451: ---------------------------------------------------------------------------
452: FUNCTION get_rec (
453: p_crnv_rec IN crnv_rec_type,
454: x_no_data_found OUT NOCOPY BOOLEAN

Line 487: FROM Okl_Criteria_V

483: CREATION_DATE,
484: LAST_UPDATED_BY,
485: LAST_UPDATE_DATE,
486: LAST_UPDATE_LOGIN
487: FROM Okl_Criteria_V
488: WHERE okl_criteria_v.id = p_id;
489: l_okl_crnv_pk okl_crnv_pk_csr%ROWTYPE;
490: l_crnv_rec crnv_rec_type;
491: BEGIN

Line 488: WHERE okl_criteria_v.id = p_id;

484: LAST_UPDATED_BY,
485: LAST_UPDATE_DATE,
486: LAST_UPDATE_LOGIN
487: FROM Okl_Criteria_V
488: WHERE okl_criteria_v.id = p_id;
489: l_okl_crnv_pk okl_crnv_pk_csr%ROWTYPE;
490: l_crnv_rec crnv_rec_type;
491: BEGIN
492: x_no_data_found := TRUE;

Line 539: -- FUNCTION null_out_defaults for: OKL_CRITERIA_V --

535: RETURN(get_rec(p_crnv_rec, l_row_notfound));
536: END get_rec;
537:
538: ----------------------------------------------------
539: -- FUNCTION null_out_defaults for: OKL_CRITERIA_V --
540: ----------------------------------------------------
541: FUNCTION null_out_defaults (
542: p_crnv_rec IN crnv_rec_type
543: ) RETURN crnv_rec_type IS

Line 636: -- Validate_Attributes for:OKL_CRITERIA_V --

632: ---------------------------------------------------------------------------
633: -- PROCEDURE Validate_Attributes
634: ---------------------------------------------------------------------------
635: --------------------------------------------
636: -- Validate_Attributes for:OKL_CRITERIA_V --
637: --------------------------------------------
638: FUNCTION Validate_Attributes (
639: p_crnv_rec IN crnv_rec_type
640: ) RETURN VARCHAR2 IS

Line 715: -- Validate_Record for:OKL_CRITERIA_V --

711: ---------------------------------------------------------------------------
712: -- PROCEDURE Validate_Record
713: ---------------------------------------------------------------------------
714: ----------------------------------------
715: -- Validate_Record for:OKL_CRITERIA_V --
716: ----------------------------------------
717: FUNCTION Validate_Record (
718: p_crnv_rec IN crnv_rec_type
719: ) RETURN VARCHAR2 IS

Line 853: -- validate_row for:OKL_CRITERIA_V --

849: ---------------------------------------------------------------------------
850: -- PROCEDURE validate_row
851: ---------------------------------------------------------------------------
852: -------------------------------------
853: -- validate_row for:OKL_CRITERIA_V --
854: -------------------------------------
855: PROCEDURE validate_row(
856: p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1251: -- insert_row for:OKL_CRITERIA_V --

1247: '_PVT'
1248: );
1249: END insert_row;
1250: -----------------------------------
1251: -- insert_row for:OKL_CRITERIA_V --
1252: -----------------------------------
1253: PROCEDURE insert_row(
1254: p_api_version IN NUMBER,
1255: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1287: -- Set_Attributes for:OKL_CRITERIA_V --

1283: l_crnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1284: RETURN(l_crnv_rec);
1285: END fill_who_columns;
1286: ---------------------------------------
1287: -- Set_Attributes for:OKL_CRITERIA_V --
1288: ---------------------------------------
1289: FUNCTION Set_Attributes (
1290: p_crnv_rec IN crnv_rec_type,
1291: x_crnv_rec OUT NOCOPY crnv_rec_type

Line 1674: -- lock_row for:OKL_CRITERIA_V --

1670: '_PVT'
1671: );
1672: END lock_row;
1673: ---------------------------------
1674: -- lock_row for:OKL_CRITERIA_V --
1675: ---------------------------------
1676: PROCEDURE lock_row(
1677: p_api_version IN NUMBER,
1678: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2247: -- update_row for:OKL_CRITERIA_V --

2243: '_PVT'
2244: );
2245: END update_row;
2246: -----------------------------------
2247: -- update_row for:OKL_CRITERIA_V --
2248: -----------------------------------
2249: PROCEDURE update_row(
2250: p_api_version IN NUMBER,
2251: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2416: -- Set_Attributes for:OKL_CRITERIA_V --

2412: END IF;
2413: RETURN(l_return_status);
2414: END populate_new_record;
2415: ---------------------------------------
2416: -- Set_Attributes for:OKL_CRITERIA_V --
2417: ---------------------------------------
2418: FUNCTION Set_Attributes (
2419: p_crnv_rec IN crnv_rec_type,
2420: x_crnv_rec OUT NOCOPY crnv_rec_type

Line 2759: -- delete_row for:OKL_CRITERIA_V --

2755: '_PVT'
2756: );
2757: END delete_row;
2758: -----------------------------------
2759: -- delete_row for:OKL_CRITERIA_V --
2760: -----------------------------------
2761: PROCEDURE delete_row(
2762: p_api_version IN NUMBER,
2763: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,