APPS.IGR_INQUIRY_LINES_PKG dependencies on IGR_I_A_LINES

Line 31: l_sales_lead_line_id igr_i_a_lines.sales_lead_line_id%TYPE;

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;
35: l_lead_proc_ret_status VARCHAR2(1);

Line 95: igr_i_a_lines_pkg.insert_row (

91: x_msg_data := trim(l_tmp_var);
92: END IF;
93: ELSE
94: lv_rowid := x_rowid ;
95: igr_i_a_lines_pkg.insert_row (
96: x_mode => 'R',
97: x_rowid => lv_rowid,
98: x_person_id => x_person_id,
99: x_enquiry_appl_number => x_enquiry_appl_number,

Line 163: l_sales_lead_line_id igr_i_a_lines.sales_lead_line_id%TYPE;

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;
167: l_lead_proc_ret_status VARCHAR2(1);

Line 234: igr_i_a_lines_pkg.update_row (

230: END LOOP;
231: x_msg_data := trim(l_tmp_var);
232: END IF;
233: ELSE
234: igr_i_a_lines_pkg.update_row (
235: x_mode => 'R',
236: x_rowid => x_rowid,
237: x_person_id => x_person_id,
238: x_enquiry_appl_number => x_enquiry_appl_number,

Line 287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,

283: || Change History :
284: || Who When What
285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS

Line 288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,

284: || Who When What
285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id

Line 289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,

285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v

Line 290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,

286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v
294: WHERE person_id = p_person_id

Line 293: FROM igr_i_a_lines_v

289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v
294: WHERE person_id = p_person_id
295: AND enquiry_appl_number = p_enquiry_appl_number
296: AND product_category_id = p_product_category_id
297: AND product_category_set_id = p_product_category_set_id