DBA Data[Home] [Help]

APPS.OKS_BILL_LEVEL_ELEMENTS_PVT dependencies on OKS_LEVEL_ELEMENTS_V

Line 95: -- FUNCTION get_rec for: OKS_LEVEL_ELEMENTS_V

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

Line 124: FROM Oks_Level_Elements_V

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

Line 125: WHERE oks_level_elements_v.id = p_id;

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;

Line 281: -- FUNCTION null_out_defaults for: OKS_LEVEL_ELEMENTS_V

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

Line 438: -- Validate_Attributes for:OKS_LEVEL_ELEMENTS_V --

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

Line 494: -- Validate Record for:OKS_LEVEL_ELEMENTS_V --

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

Line 576: -- validate_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 653: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 749: -- PL/SQL TBL validate_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 942: -- insert_row for :OKS_LEVEL_ELEMENTS_V --

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,

Line 976: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --

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

Line 1361: -- lock_row for: OKS_LEVEL_ELEMENTS_V --

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,

Line 1817: -- update_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 1949: -- Set_Attributes for:OKS_LEVEL_ELEMENTS_V --

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

Line 2306: -- delete_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 2388: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --

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,

Line 2484: -- PL/SQL TBL delete_row for:OKS_LEVEL_ELEMENTS_V --

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,