APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on AR_LOOKUPS

Line 693: vskumar 12-Jul-2006 Bug No: 4068301 & 4068322. Added a new cursor c_ar_lookups for address_types to display meaning

689: asbala 12-SEP-03 Bug No:2667343 Replaced Hard coded strings populating lv_Data_Emt by
690: lookup_codes from a lookup_type
691: gmaheswa 07-JUL-05 Bug No: 4327807 Added condition to skip Person Type Mandatory data validation
692: incase of Self-Service applications.
693: vskumar 12-Jul-2006 Bug No: 4068301 & 4068322. Added a new cursor c_ar_lookups for address_types to display meaning
694: instead of lookup_code in the error message, when it is mendatory.
695: ***************************************************************/
696:
697: CURSOR Mand_Emt IS

Line 716: CURSOR c_ar_lookups(cp_lookup_type VARCHAR2,

712: FROM IGS_LOOKUP_VALUES
713: WHERE lookup_type=cp_lookup_type AND
714: lookup_code=cp_lookup_code;
715:
716: CURSOR c_ar_lookups(cp_lookup_type VARCHAR2,
717: cp_lookup_code VARCHAR2) IS
718: SELECT meaning
719: FROM ar_lookups
720: WHERE lookup_type = cp_lookup_type

Line 719: FROM ar_lookups

715:
716: CURSOR c_ar_lookups(cp_lookup_type VARCHAR2,
717: cp_lookup_code VARCHAR2) IS
718: SELECT meaning
719: FROM ar_lookups
720: WHERE lookup_type = cp_lookup_type
721: AND lookup_code = cp_lookup_code;
722:
723: lvc_SQLStmt VARCHAR2(2000) ;

Line 801: OPEN c_ar_lookups('PARTY_SITE_USE_CODE', c_Mand_Emt.Value);

797: OPEN c_lookup_meaning(l_lookup_type,l_lookup_code);
798: FETCH c_lookup_meaning INTO lv_DataEmt;
799: CLOSE c_lookup_meaning;
800:
801: OPEN c_ar_lookups('PARTY_SITE_USE_CODE', c_Mand_Emt.Value);
802: FETCH c_ar_lookups INTO lv_ar_description;
803: CLOSE c_ar_lookups;
804: lv_DataEmt := lv_DataEmt || ' ' || lv_ar_description;
805: ELSIF c_Mand_Emt.data_element = 'PERSON_ID_TYPE' THEN

Line 802: FETCH c_ar_lookups INTO lv_ar_description;

798: FETCH c_lookup_meaning INTO lv_DataEmt;
799: CLOSE c_lookup_meaning;
800:
801: OPEN c_ar_lookups('PARTY_SITE_USE_CODE', c_Mand_Emt.Value);
802: FETCH c_ar_lookups INTO lv_ar_description;
803: CLOSE c_ar_lookups;
804: lv_DataEmt := lv_DataEmt || ' ' || lv_ar_description;
805: ELSIF c_Mand_Emt.data_element = 'PERSON_ID_TYPE' THEN
806: l_lookup_code := 'PERSON_ID_TYP';

Line 803: CLOSE c_ar_lookups;

799: CLOSE c_lookup_meaning;
800:
801: OPEN c_ar_lookups('PARTY_SITE_USE_CODE', c_Mand_Emt.Value);
802: FETCH c_ar_lookups INTO lv_ar_description;
803: CLOSE c_ar_lookups;
804: lv_DataEmt := lv_DataEmt || ' ' || lv_ar_description;
805: ELSIF c_Mand_Emt.data_element = 'PERSON_ID_TYPE' THEN
806: l_lookup_code := 'PERSON_ID_TYP';
807: OPEN c_lookup_meaning(l_lookup_type,l_lookup_code);