35: RETURN VARCHAR2 IS
36:
37: l_api_name CONSTANT VARCHAR2(30) := 'Get_Lookup_Code';
38:
39: l_lookup_code fnd_lookups.lookup_code%TYPE;
40:
41: BEGIN
42:
43: null;
98: p_proposal_number IN igw_proposals_all.proposal_number%TYPE,
99: p_proposal_short_title IN VARCHAR2,
100: p_proposal_title IN igw_proposals_all.proposal_title%TYPE,
101: p_proposal_status IN igw_proposals_all.proposal_status%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
102: p_proposal_status_meaning IN fnd_lookups.meaning%TYPE,
103: p_proposal_start_date IN igw_proposals_all.proposal_start_date%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
104: p_proposal_end_date IN igw_proposals_all.proposal_end_date%TYPE,
105: p_proposal_type_code IN igw_proposals_all.proposal_type_code%type,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111: p_proposal_purpose_code IN VARCHAR2,
112: p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
106: p_proposal_type_meaning IN fnd_lookups.meaning%TYPE,
107: p_activity_type_code IN igw_proposals_all.activity_type_code%type,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111: p_proposal_purpose_code IN VARCHAR2,
112: p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
113: p_cross_cut_type_code IN VARCHAR2,
114: p_cross_cut_type_meaning IN fnd_lookups.meaning%TYPE,
108: p_activity_type_meaning IN fnd_lookups.meaning%TYPE,
109: p_proposal_category_code IN VARCHAR2,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111: p_proposal_purpose_code IN VARCHAR2,
112: p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
113: p_cross_cut_type_code IN VARCHAR2,
114: p_cross_cut_type_meaning IN fnd_lookups.meaning%TYPE,
115: p_proposal_url IN VARCHAR2,
116: p_grantor_id IN NUMBER,
110: p_proposal_category_meaning IN fnd_lookups.meaning%TYPE,
111: p_proposal_purpose_code IN VARCHAR2,
112: p_proposal_purpose_meaning IN fnd_lookups.meaning%TYPE,
113: p_cross_cut_type_code IN VARCHAR2,
114: p_cross_cut_type_meaning IN fnd_lookups.meaning%TYPE,
115: p_proposal_url IN VARCHAR2,
116: p_grantor_id IN NUMBER,
117: p_grantor_name IN VARCHAR2,
118: p_proposal_manager_id IN NUMBER,