APPS.AMS_LIST_IMPORT_PUB dependencies on AMS_PARTY_SOURCES

Line 162: -- This procedure is used to create party records in ams_party_sources table.

158: p_relationship_code IN VARCHAR2,
159: p_relationship_type IN VARCHAR2
160: );
161:
162: -- This procedure is used to create party records in ams_party_sources table.
163: --
164: --
165: PROCEDURE create_party_source (
166: p_import_list_header_id IN NUMBER,

Line 4021: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4017:
4018:
4019:
4020: cursor c_cont_email is
4021: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4022: WHERE PARTY_ID = l_rel_party_id
4023: and upper(COL26) = upper(p_email_address);
4024:
4025:

Line 4028: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4024:
4025:
4026: cursor c_cont_email_phone is
4027:
4028: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4029: WHERE PARTY_ID = l_rel_party_id
4030: and upper(COL26) = upper(p_email_address)
4031: and COL28 = p_phone_area_code
4032: and COL29 = p_phone_number

Line 4036: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4032: and COL29 = p_phone_number
4033: and COL30 = p_phone_extension;
4034:
4035: cursor c_cont_phone is
4036: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4037: WHERE PARTY_ID = l_rel_party_id
4038: and COL28 = p_phone_area_code
4039: and COL29 = p_phone_number
4040: and COL30 = p_phone_extension;

Line 4124: insert into ams_party_sources

4120: p_overlay IN VARCHAR2
4121: ) IS
4122: l_return_status varchar2(1);
4123: begin
4124: insert into ams_party_sources
4125: (
4126: party_sources_id,
4127: party_id,
4128: IMPORT_SOURCE_LINE_ID,

Line 4229: ams_party_sources_s.nextval,

4225: COL249,
4226: COL250
4227: )
4228: select
4229: ams_party_sources_s.nextval,
4230: LINE.PARTY_ID,
4231: LINE.IMPORT_SOURCE_LINE_ID,
4232: LINE.OBJECT_VERSION_NUMBER,
4233: LINE.LAST_UPDATE_DATE,

Line 4914: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4910: l_ret_status varchar(1);
4911:
4912:
4913: cursor c_email_address is
4914: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4915: WHERE PARTY_ID = p_party_id
4916: and upper(COL26) = upper(p_email_address);
4917:
4918: cursor c_ph_number is

Line 4919: select party_id from AMS_PARTY_SOURCES

4915: WHERE PARTY_ID = p_party_id
4916: and upper(COL26) = upper(p_email_address);
4917:
4918: cursor c_ph_number is
4919: select party_id from AMS_PARTY_SOURCES
4920: where party_id = p_party_id
4921: and col29 = p_ph_number
4922: and nvl(col27,nvl(p_ph_country_code,'x')) = nvl(p_ph_country_code,'x')
4923: and nvl(col28,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');

Line 4926: select party_id from AMS_PARTY_SOURCES

4922: and nvl(col27,nvl(p_ph_country_code,'x')) = nvl(p_ph_country_code,'x')
4923: and nvl(col28,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4924:
4925: cursor c_address_country is
4926: select party_id from AMS_PARTY_SOURCES
4927: where party_id = p_party_id
4928: and col18 = p_address1
4929: and col17 = p_country;
4930: