APPS.IGR_I_A_PKGITM_PKG dependencies on IGR_I_APPL_V

Line 340: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,

336: X_PROGRAM_ID NUMBER;
337: X_PROGRAM_APPLICATION_ID NUMBER;
338: X_PROGRAM_UPDATE_DATE DATE;
339:
340: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
341: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
342: SELECT sales_lead_id
343: FROM igr_i_appl_v
344: WHERE person_id = p_person_id

Line 341: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS

337: X_PROGRAM_APPLICATION_ID NUMBER;
338: X_PROGRAM_UPDATE_DATE DATE;
339:
340: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
341: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
342: SELECT sales_lead_id
343: FROM igr_i_appl_v
344: WHERE person_id = p_person_id
345: AND enquiry_appl_number = p_enquiry_appl_number ;

Line 343: FROM igr_i_appl_v

339:
340: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
341: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
342: SELECT sales_lead_id
343: FROM igr_i_appl_v
344: WHERE person_id = p_person_id
345: AND enquiry_appl_number = p_enquiry_appl_number ;
346:
347: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;

Line 347: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;

343: FROM igr_i_appl_v
344: WHERE person_id = p_person_id
345: AND enquiry_appl_number = p_enquiry_appl_number ;
346:
347: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;
348:
349: begin
350: X_LAST_UPDATE_DATE := SYSDATE;
351: if(X_MODE = 'I') then

Line 513: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,

509: X_REQUEST_ID NUMBER;
510: X_PROGRAM_ID NUMBER;
511: X_PROGRAM_APPLICATION_ID NUMBER;
512: X_PROGRAM_UPDATE_DATE DATE;
513: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
514: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
515: SELECT sales_lead_id
516: FROM igr_i_appl_v
517: WHERE person_id = p_person_id

Line 514: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS

510: X_PROGRAM_ID NUMBER;
511: X_PROGRAM_APPLICATION_ID NUMBER;
512: X_PROGRAM_UPDATE_DATE DATE;
513: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
514: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
515: SELECT sales_lead_id
516: FROM igr_i_appl_v
517: WHERE person_id = p_person_id
518: AND enquiry_appl_number = p_enquiry_appl_number ;

Line 516: FROM igr_i_appl_v

512: X_PROGRAM_UPDATE_DATE DATE;
513: CURSOR cur_sales_lead_id (p_person_id igr_i_appl_v.person_id%TYPE,
514: p_enquiry_appl_number igr_i_appl_v.enquiry_appl_number%TYPE ) IS
515: SELECT sales_lead_id
516: FROM igr_i_appl_v
517: WHERE person_id = p_person_id
518: AND enquiry_appl_number = p_enquiry_appl_number ;
519:
520: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;

Line 520: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;

516: FROM igr_i_appl_v
517: WHERE person_id = p_person_id
518: AND enquiry_appl_number = p_enquiry_appl_number ;
519:
520: p_sales_lead_id igr_i_appl_v.sales_lead_id%TYPE;
521:
522: begin
523: X_LAST_UPDATE_DATE := SYSDATE;
524: if(X_MODE = 'I') then