APPS.IGR_INQUIRY_LINES_PKG dependencies on IGR_I_APPL_ALL

Line 30: l_sales_lead_id igr_i_appl_all.sales_lead_id%TYPE;

26: || (reverse chronological order - newest change first)
27: */
28: l_tmp_var VARCHAR2(2000);
29: lv_rowid VARCHAR2(30);
30: l_sales_lead_id igr_i_appl_all.sales_lead_id%TYPE;
31: l_sales_lead_line_id igr_i_a_lines.sales_lead_line_id%TYPE;
32: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
33: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
34: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

Line 40: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,

36: l_lead_proc_msg_count NUMBER;
37: l_lead_proc_msg_data VARCHAR2(2000);
38:
39:
40: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
41: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
42: SELECT sales_lead_id
43: FROM igr_i_appl_all
44: WHERE person_id =p_person_id

Line 41: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS

37: l_lead_proc_msg_data VARCHAR2(2000);
38:
39:
40: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
41: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
42: SELECT sales_lead_id
43: FROM igr_i_appl_all
44: WHERE person_id =p_person_id
45: AND enquiry_appl_number = p_enquiry_appl_number ;

Line 43: FROM igr_i_appl_all

39:
40: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
41: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
42: SELECT sales_lead_id
43: FROM igr_i_appl_all
44: WHERE person_id =p_person_id
45: AND enquiry_appl_number = p_enquiry_appl_number ;
46:
47: BEGIN

Line 162: l_sales_lead_id igr_i_appl_all.sales_lead_id%TYPE;

158: */
159:
160: l_tmp_var VARCHAR2(2000);
161: lv_rowid VARCHAR2(30);
162: l_sales_lead_id igr_i_appl_all.sales_lead_id%TYPE;
163: l_sales_lead_line_id igr_i_a_lines.sales_lead_line_id%TYPE;
164: ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
165: ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
166: ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

Line 171: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,

167: l_lead_proc_ret_status VARCHAR2(1);
168: l_lead_proc_msg_count NUMBER;
169: l_lead_proc_msg_data VARCHAR2(2000);
170:
171: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
172: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
173: SELECT sales_lead_id
174: FROM igr_i_appl_all
175: WHERE person_id =p_person_id

Line 172: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS

168: l_lead_proc_msg_count NUMBER;
169: l_lead_proc_msg_data VARCHAR2(2000);
170:
171: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
172: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
173: SELECT sales_lead_id
174: FROM igr_i_appl_all
175: WHERE person_id =p_person_id
176: AND enquiry_appl_number = p_enquiry_appl_number ;

Line 174: FROM igr_i_appl_all

170:
171: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_all.person_id%TYPE,
172: p_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE) IS
173: SELECT sales_lead_id
174: FROM igr_i_appl_all
175: WHERE person_id =p_person_id
176: AND enquiry_appl_number = p_enquiry_appl_number ;
177:
178: CURSOR cur_last_update_date IS