DBA Data[Home] [Help]

APPS.IGR_INQUIRY_LINES_PKG dependencies on IGR_I_A_LINES_V

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