DBA Data[Home] [Help]

APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_GE_NUMBER

Line 2184: IGS_GE_NUMBER.TO_CANN(p_person_id);

2180: p_tac_person_id || ' ' ||
2181: p_surname || ' ' ||
2182: p_given_names || ' ' ||
2183: 'matched Callista person' || ' ' ||
2184: IGS_GE_NUMBER.TO_CANN(p_person_id);
2185: -- Record the new TAC ID
2186: -- First check if this TAC ID already exists in
2187: -- IGS_PE_ALT_PERS_ID rec
2188: OPEN c_api;

Line 2219: p_message_out := 'Creating ID '|| IGS_GE_NUMBER.TO_CANN(v_new_person_id);

2215: v_new_sex := 'U';
2216: ELSE
2217: v_new_sex := p_sex;
2218: END IF;
2219: p_message_out := 'Creating ID '|| IGS_GE_NUMBER.TO_CANN(v_new_person_id);
2220:
2221: -- Code added for Leap Frogging after customer bug#1700178 on ver 1.7 -tray -(03-05-2001)
2222: -- changed by ssawhney bug 2225917 -- OSS Will not create customer account
2223: