APPS.PQP_RIW_OFFERING_WRAPPER dependencies on OTA_OFFERINGS

Line 8: g_offering_rec ota_offerings_vl%rowtype;

4: -- =============================================================================
5: -- ~ Package Body Global variables:
6: -- =============================================================================
7: g_package varchar2(33) := 'pqp_riw_offering_wrapper.';
8: g_offering_rec ota_offerings_vl%rowtype;
9: g_interface_code varchar2(150);
10: g_player_toolbar_flag varchar2(9);
11: g_player_new_window_flag varchar2(9);
12:

Line 17: return ota_offerings_vl%rowtype is

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

Line 19: l_offering_rec ota_offerings_vl%rowtype;

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

Line 117: return ota_offerings_vl%rowtype is

113: -- Get_Record_Values:
114: -- =============================================================================
115: function Get_Record_Values
116: (p_interface_code in varchar2 default null)
117: return ota_offerings_vl%rowtype is
118:
119: cursor bne_cols(c_interface_code in varchar2) is
120: select lower(bic.interface_col_name) interface_col_name
121: from bne_interface_cols_b bic

Line 133: l_offering_rec ota_offerings_vl%rowtype;

129: from bne_interface_cols_b bic
130: where bic.interface_code = c_interface_code
131: and bic.display_flag ='N';
132:
133: l_offering_rec ota_offerings_vl%rowtype;
134: col_name varchar2(150);
135: l_proc_name constant varchar2(150) := g_package||'Get_Record_Values';
136: begin
137:

Line 380: l_offering_rec ota_offerings_vl%rowtype;

376: e_upl_not_allowed exception; -- when mode is 'View Only'
377: e_crt_not_allowed exception; -- when mode is 'Update Only'
378: g_upl_err_msg varchar2(100) := 'Upload NOT allowed.';
379: g_crt_err_msg varchar2(100) := 'Creating NOT allowed.';
380: l_offering_rec ota_offerings_vl%rowtype;
381: l_interface_code varchar2(40);
382: l_crt_upd varchar2(1);
383: l_crt_upd_len number;
384:

Line 647: from ota_offerings where

643: g_offering_rec.competency_update_level := p_competency_update_level ;
644: g_offering_rec.language_code := p_language_code ;
645:
646: select object_version_number into l_object_version_number
647: from ota_offerings where
648: offering_id = l_offering_id;
649:
650: l_offering_rec := Get_Record_Values(g_interface_code);
651: ota_offering_api.update_offering