APPS.PQP_RIW_COURSE_WRAPPER dependencies on OTA_ACTIVITY_VERSIONS_VL

Line 8: g_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;

4: -- =============================================================================
5: -- ~ Package Body Global variables:
6: -- =============================================================================
7: g_package varchar2(33) := 'pqp_riw_course_wrapper.';
8: g_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
9: g_interface_code varchar2(150);
10: --
11:
12: -- =============================================================================

Line 16: return OTA_ACTIVITY_VERSIONS_VL%rowtype is

12: -- =============================================================================
13: -- Default_Record_Values:
14: -- =============================================================================
15: function Default_Course_Rec
16: return OTA_ACTIVITY_VERSIONS_VL%rowtype is
17: l_proc_name constant varchar2(150) := g_package||'Default_Course_Rec';
18: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
19: begin
20:

Line 18: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;

14: -- =============================================================================
15: function Default_Course_Rec
16: return OTA_ACTIVITY_VERSIONS_VL%rowtype is
17: l_proc_name constant varchar2(150) := g_package||'Default_Course_Rec';
18: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
19: begin
20:
21: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
22: /*

Line 109: return OTA_ACTIVITY_VERSIONS_VL%rowtype is

105: -- Get_Record_Values:
106: -- =============================================================================
107: function Get_Record_Values
108: (p_interface_code in varchar2 default null)
109: return OTA_ACTIVITY_VERSIONS_VL%rowtype is
110:
111: cursor bne_cols(c_interface_code in varchar2) is
112: select lower(bic.interface_col_name) interface_col_name
113: from bne_interface_cols_b bic

Line 125: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;

121: from bne_interface_cols_b bic
122: where bic.interface_code = c_interface_code
123: and bic.display_flag ='N';
124:
125: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
126: col_name varchar2(150);
127: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
128: begin
129:

Line 373: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;

369: p_aci_information18 varchar2(72);
370: p_aci_information19 varchar2(72);
371: p_aci_information20 varchar2(72);
372: l_error_msg varchar2(4000);
373: l_course_rec OTA_ACTIVITY_VERSIONS_VL%rowtype;
374: l_interface_code varchar2(40);
375: l_crt_upd varchar2(1);
376: -- =============================================================================
377: -- ~ Package Body Cursor variables: