DBA Data[Home] [Help]

APPS.PQP_RIW_CLASS_WRAPPER dependencies on OTA_EVENTS_VL

Line 8: g_class_rec ota_events_vl%rowtype;

4: -- =============================================================================
5: -- ~ Package Body Global variables:
6: -- =============================================================================
7: g_package varchar2(33) := 'pqp_riw_class_wrapper';
8: g_class_rec ota_events_vl%rowtype;
9: g_interface_code varchar2(150);
10: g_course_end_time varchar2(9);
11: g_course_start_time varchar2(9);
12:

Line 17: return ota_events_vl%rowtype is

13: -- =============================================================================
14: -- Default_Record_Values:
15: -- =============================================================================
16: function Default_Class_Rec
17: return ota_events_vl%rowtype is
18: l_proc_name constant varchar2(150) := g_package||'Default_Class_Rec';
19: l_class_rec ota_events_vl%rowtype;
20:
21: begin

Line 19: l_class_rec ota_events_vl%rowtype;

15: -- =============================================================================
16: function Default_Class_Rec
17: return ota_events_vl%rowtype is
18: l_proc_name constant varchar2(150) := g_package||'Default_Class_Rec';
19: l_class_rec ota_events_vl%rowtype;
20:
21: begin
22:
23: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

Line 126: return ota_events_vl%rowtype is

122: -- Get_Record_Values:
123: -- =============================================================================
124: function Get_Record_Values
125: (p_interface_code in varchar2 default null)
126: return ota_events_vl%rowtype is
127:
128: cursor bne_cols(c_interface_code in varchar2) is
129: select lower(bic.interface_col_name) interface_col_name
130: from bne_interface_cols_b bic

Line 142: l_class_rec ota_events_vl%rowtype;

138: from bne_interface_cols_b bic
139: where bic.interface_code = c_interface_code
140: and bic.display_flag ='N';
141:
142: l_class_rec ota_events_vl%rowtype;
143: col_name varchar2(150);
144: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
145: begin
146:

Line 424: l_class_rec ota_events_vl%rowtype;

420:
421: l_ev_id number(9,0);
422: l_obj_ver_num number(3);
423: l_object_version_number number(3);
424: l_class_rec ota_events_vl%rowtype;
425: l_interface_code varchar2(40);
426: l_crt_upd varchar2(1);
427: l_crt_upd_len number;
428: