57: );
58:
59: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
60: TYPE svctl_rec_type IS RECORD (
61: id okl_services_tl.id%TYPE
62: ,short_description okl_services_tl.short_description%TYPE
63: ,description okl_services_tl.description%TYPE
64: ,comments okl_services_tl.comments%TYPE
65: );
58:
59: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
60: TYPE svctl_rec_type IS RECORD (
61: id okl_services_tl.id%TYPE
62: ,short_description okl_services_tl.short_description%TYPE
63: ,description okl_services_tl.description%TYPE
64: ,comments okl_services_tl.comments%TYPE
65: );
66:
59: -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
60: TYPE svctl_rec_type IS RECORD (
61: id okl_services_tl.id%TYPE
62: ,short_description okl_services_tl.short_description%TYPE
63: ,description okl_services_tl.description%TYPE
64: ,comments okl_services_tl.comments%TYPE
65: );
66:
67: -- view record structure
60: TYPE svctl_rec_type IS RECORD (
61: id okl_services_tl.id%TYPE
62: ,short_description okl_services_tl.short_description%TYPE
63: ,description okl_services_tl.description%TYPE
64: ,comments okl_services_tl.comments%TYPE
65: );
66:
67: -- view record structure
68: TYPE svcv_rec_type IS RECORD (
88: ,parent_object_code okl_services_b.parent_object_code%TYPE
89: ,parent_object_id okl_services_b.parent_object_id%TYPE
90: ,effective_from okl_services_b.effective_from%TYPE
91: ,supplier_id okl_services_b.supplier_id%TYPE
92: ,short_description okl_services_tl.short_description%TYPE
93: ,description okl_services_tl.description%TYPE
94: ,comments okl_services_tl.comments%TYPE
95: );
96:
89: ,parent_object_id okl_services_b.parent_object_id%TYPE
90: ,effective_from okl_services_b.effective_from%TYPE
91: ,supplier_id okl_services_b.supplier_id%TYPE
92: ,short_description okl_services_tl.short_description%TYPE
93: ,description okl_services_tl.description%TYPE
94: ,comments okl_services_tl.comments%TYPE
95: );
96:
97: TYPE svcv_tbl_type IS TABLE OF svcv_rec_type INDEX BY BINARY_INTEGER;
90: ,effective_from okl_services_b.effective_from%TYPE
91: ,supplier_id okl_services_b.supplier_id%TYPE
92: ,short_description okl_services_tl.short_description%TYPE
93: ,description okl_services_tl.description%TYPE
94: ,comments okl_services_tl.comments%TYPE
95: );
96:
97: TYPE svcv_tbl_type IS TABLE OF svcv_rec_type INDEX BY BINARY_INTEGER;
98: