APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_API_INT

Line 1921: -- Populate the IGS_AD_API_INT table

1917: fnd_file.put_line(fnd_file.log, fnd_message.get);
1918:
1919: ELSE
1920:
1921: -- Populate the IGS_AD_API_INT table
1922: INSERT INTO igs_ad_api_int (
1923: interface_api_id
1924: ,interface_id
1925: ,person_id_type

Line 1922: INSERT INTO igs_ad_api_int (

1918:
1919: ELSE
1920:
1921: -- Populate the IGS_AD_API_INT table
1922: INSERT INTO igs_ad_api_int (
1923: interface_api_id
1924: ,interface_id
1925: ,person_id_type
1926: ,alternate_id

Line 1934: IGS_AD_API_INT_S.NEXTVAL

1930: ,last_updated_by
1931: ,last_update_date
1932: ,last_update_login )
1933: VALUES(
1934: IGS_AD_API_INT_S.NEXTVAL
1935: ,p_interface_id
1936: ,p_ninumber_alt_type
1937: ,p_ni_number
1938: ,'2'

Line 1997: INSERT INTO igs_ad_api_int (

1993: fnd_file.put_line(fnd_file.log, fnd_message.get);
1994:
1995: ELSE
1996:
1997: INSERT INTO igs_ad_api_int (
1998: interface_api_id
1999: ,interface_id
2000: ,person_id_type
2001: ,alternate_id

Line 2009: IGS_AD_API_INT_S.NEXTVAL

2005: ,last_updated_by
2006: ,last_update_date
2007: ,last_update_login )
2008: VALUES (
2009: IGS_AD_API_INT_S.NEXTVAL
2010: ,p_interface_id
2011: ,'UCASREGNO'
2012: ,p_scn
2013: ,'2'