91: null;
92: END api_copy;
93:
94: ---------------------------------------------------------------------------
95: -- FUNCTION get_rec for: OKS_LEVEL_ELEMENTS_V
96: ---------------------------------------------------------------------------
97: FUNCTION get_rec (
98: p_letv_rec IN letv_rec_type,
99: x_no_data_found OUT NOCOPY BOOLEAN
120: CREATED_BY,
121: CREATION_DATE,
122: LAST_UPDATED_BY,
123: LAST_UPDATE_DATE
124: FROM Oks_Level_Elements_V
125: WHERE oks_level_elements_v.id = p_id;
126: l_oks_let_pk oks_let_pk_csr%ROWTYPE;
127: l_letv_rec letv_rec_type;
128: BEGIN
121: CREATION_DATE,
122: LAST_UPDATED_BY,
123: LAST_UPDATE_DATE
124: FROM Oks_Level_Elements_V
125: WHERE oks_level_elements_v.id = p_id;
126: l_oks_let_pk oks_let_pk_csr%ROWTYPE;
127: l_letv_rec letv_rec_type;
128: BEGIN
129: x_no_data_found := TRUE;
277: BEGIN
278: RETURN(get_rec(p_let_rec, l_row_not_found));
279: END get_rec;
280: ---------------------------------------------------------------------------
281: -- FUNCTION null_out_defaults for: OKS_LEVEL_ELEMENTS_V
282: ---------------------------------------------------------------------------
283: FUNCTION null_out_defaults (
284: p_letv_rec IN letv_rec_type
285: ) RETURN letv_rec_type IS
434: ---------------------------------------------------------------------------
435: -- FUNCTION Validate_Attributes
436: ---------------------------------------------------------------------------
437: --------------------------------------------------
438: -- Validate_Attributes for:OKS_LEVEL_ELEMENTS_V --
439: --------------------------------------------------
440: FUNCTION Validate_Attributes (
441: p_letv_rec IN letv_rec_type
442: ) RETURN VARCHAR2 IS
490: ---------------------------------------------------------------------------
491: -- PROCEDURE Validate_Record
492: ---------------------------------------------------------------------------
493: ----------------------------------------------
494: -- Validate Record for:OKS_LEVEL_ELEMENTS_V --
495: ----------------------------------------------
496: FUNCTION Validate_Record (
497: p_letv_rec IN letv_rec_type,
498: p_db_letv_rec IN letv_rec_type
572: ---------------------------------------------------------------------------
573: -- PROCEDURE validate_row
574: ---------------------------------------------------------------------------
575: -------------------------------------------
576: -- validate_row for:OKS_LEVEL_ELEMENTS_V --
577: -------------------------------------------
578: PROCEDURE validate_row(
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2,
649: '_PVT'
650: );
651: END validate_row;
652: ------------------------------------------------------
653: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --
654: ------------------------------------------------------
655: PROCEDURE validate_row(
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2,
745: );
746: END validate_row;
747:
748: ------------------------------------------------------
749: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --
750: ------------------------------------------------------
751: PROCEDURE validate_row(
752: p_api_version IN NUMBER,
753: p_init_msg_list IN VARCHAR2,
938: '_PVT'
939: );
940: END insert_row;
941: ------------------------------------------
942: -- insert_row for :OKS_LEVEL_ELEMENTS_V --
943: ------------------------------------------
944: PROCEDURE insert_row(
945: p_api_version IN NUMBER,
946: p_init_msg_list IN VARCHAR2,
972: -- l_letv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
973: RETURN(l_letv_rec);
974: END fill_who_columns;
975: ---------------------------------------------
976: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --
977: ---------------------------------------------
978: FUNCTION Set_Attributes (
979: p_letv_rec IN letv_rec_type,
980: x_letv_rec OUT NOCOPY letv_rec_type
1357: '_PVT'
1358: );
1359: END lock_row;
1360: ----------------------------------------
1361: -- lock_row for: OKS_LEVEL_ELEMENTS_V --
1362: ----------------------------------------
1363: PROCEDURE lock_row(
1364: p_api_version IN NUMBER,
1365: p_init_msg_list IN VARCHAR2,
1813: '_PVT'
1814: );
1815: END update_row;
1816: -----------------------------------------
1817: -- update_row for:OKS_LEVEL_ELEMENTS_V --
1818: -----------------------------------------
1819: PROCEDURE update_row(
1820: p_api_version IN NUMBER,
1821: p_init_msg_list IN VARCHAR2,
1945: END IF;
1946: RETURN(l_return_status);
1947: END populate_new_record;
1948: ---------------------------------------------
1949: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --
1950: ---------------------------------------------
1951: FUNCTION Set_Attributes (
1952: p_letv_rec IN letv_rec_type,
1953: x_letv_rec OUT NOCOPY letv_rec_type
2302: '_PVT'
2303: );
2304: END delete_row;
2305: -----------------------------------------
2306: -- delete_row for:OKS_LEVEL_ELEMENTS_V --
2307: -----------------------------------------
2308: PROCEDURE delete_row(
2309: p_api_version IN NUMBER,
2310: p_init_msg_list IN VARCHAR2,
2384: '_PVT'
2385: );
2386: END delete_row;
2387: ----------------------------------------------------
2388: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --
2389: ----------------------------------------------------
2390: PROCEDURE delete_row(
2391: p_api_version IN NUMBER,
2392: p_init_msg_list IN VARCHAR2,
2480: );
2481: END delete_row;
2482:
2483: ----------------------------------------------------
2484: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --
2485: ----------------------------------------------------
2486: PROCEDURE delete_row(
2487: p_api_version IN NUMBER,
2488: p_init_msg_list IN VARCHAR2,