APPS.IGR_GEN_001 dependencies on IGR_INQUIRY_PKG

Line 16: igr_inquiry_pkg

12: sjlaport 17-Feb-2005 Added Function Admp_Del_Eap_Eitpi and Admp_Ins_Eap_Eitpi
13: for IGR Migration
14: hreddych 26-may-2003 Capture Event Campaign
15: Added the x_source_promotion_id in the call to
16: igr_inquiry_pkg
17: rghosh 10-May-2005 Removed the procedure update_mailed_dt_inq_info and
18: replaced the calls to the proceure update_mailed_dt_inq_info
19: with update_mailed_dt. This is the new functionality
20: from the bug 4354270

Line 600: igr_inquiry_pkg.update_row (

596: END IF;
597: CLOSE c_pkgitems_exist_more;
598: v_enquiries_processed := v_enquiries_processed + 1;
599: /* Update only the last process date and enquiry status as complete*/
600: igr_inquiry_pkg.update_row (
601: x_rowid => v_eap_es_rec.Row_Id,
602: x_person_id => v_eap_es_rec.Person_Id,
603: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
604: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 690: igr_inquiry_pkg.update_row (

686: create_person_id_group_member(
687: v_group_id,
688: v_person_id);
689: /* Update The Enquiry Status obtained above and last process date of inquiry instance */
690: igr_inquiry_pkg.update_row (
691: x_rowid => v_eap_es_rec.Row_Id,
692: x_person_id => v_eap_es_rec.Person_Id,
693: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
694: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 792: igr_inquiry_pkg.update_row (

788: v_group_id,
789: v_person_id);
790: v_enquiries_processed := v_enquiries_processed + 1;
791: /* Update only the last process date and enquiry status as complete*/
792: igr_inquiry_pkg.update_row (
793: x_rowid => v_eap_es_rec.Row_Id,
794: x_person_id => v_eap_es_rec.Person_Id,
795: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
796: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 884: igr_inquiry_pkg.update_row (

880: v_group_id,
881: v_person_id);
882:
883: /* Update only the last process date */
884: igr_inquiry_pkg.update_row (
885: x_rowid => v_eap_es_rec.Row_Id,
886: x_person_id => v_eap_es_rec.Person_Id,
887: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
888: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1010: igr_inquiry_pkg.update_row (

1006: END IF;
1007: CLOSE c_pkgitems_exist_more;
1008:
1009: v_enquiries_processed := v_enquiries_processed + 1;
1010: igr_inquiry_pkg.update_row (
1011: x_rowid => v_eap_es_rec.Row_Id,
1012: x_person_id => v_eap_es_rec.Person_Id,
1013: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1014: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1094: igr_inquiry_pkg.update_row (

1090: v_group_id,
1091: v_person_id);
1092: --Update Process Date and Inquiry Status to 'Acknowledged'.
1093: v_enquiries_processed := v_enquiries_processed + 1;
1094: igr_inquiry_pkg.update_row (
1095: x_rowid => v_eap_es_rec.Row_Id,
1096: x_person_id => v_eap_es_rec.Person_Id,
1097: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1098: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1174: igr_inquiry_pkg.update_row (

1170: v_person_id);
1171:
1172: v_enquiries_processed := v_enquiries_processed + 1;
1173: -- Update the Last Process Date to current date and Inquiry Status to Acknowledged.
1174: igr_inquiry_pkg.update_row (
1175: x_rowid => v_eap_es_rec.Row_Id,
1176: x_person_id => v_eap_es_rec.Person_Id,
1177: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1178: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1275: igr_inquiry_pkg.update_row (

1271:
1272:
1273: v_enquiries_processed := v_enquiries_processed + 1;
1274: /* Update only the last process date and enquiry status as complete*/
1275: igr_inquiry_pkg.update_row (
1276: x_rowid => v_eap_es_rec.Row_Id,
1277: x_person_id => v_eap_es_rec.Person_Id,
1278: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1279: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1356: igr_inquiry_pkg.update_row (

1352: v_person_id);
1353:
1354: v_enquiries_processed := v_enquiries_processed + 1;
1355: /* Update only the last process date */
1356: igr_inquiry_pkg.update_row (
1357: x_rowid => v_eap_es_rec.Row_Id,
1358: x_person_id => v_eap_es_rec.Person_Id,
1359: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1360: x_sales_lead_id => v_eap_es_rec.sales_lead_id,

Line 1435: igr_inquiry_pkg.update_row (

1431: v_person_id);
1432:
1433: v_enquiries_processed := v_enquiries_processed + 1;
1434: /* Update only the last process date and enquiry status as acknowlege*/
1435: igr_inquiry_pkg.update_row (
1436: x_rowid => v_eap_es_rec.Row_Id,
1437: x_person_id => v_eap_es_rec.Person_Id,
1438: x_enquiry_appl_number => v_eap_es_rec.Enquiry_Appl_Number,
1439: x_sales_lead_id => v_eap_es_rec.sales_lead_id,