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 4014: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4010:
4011:
4012:
4013: cursor c_cont_email is
4014: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4015: WHERE PARTY_ID = l_rel_party_id
4016: and upper(COL26) = upper(p_email_address);
4017:
4018:

Line 4021: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4017:
4018:
4019: cursor c_cont_email_phone is
4020:
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: and COL28 = p_phone_area_code
4025: and COL29 = p_phone_number

Line 4029: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4025: and COL29 = p_phone_number
4026: and COL30 = p_phone_extension;
4027:
4028: cursor c_cont_phone is
4029: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4030: WHERE PARTY_ID = l_rel_party_id
4031: and COL28 = p_phone_area_code
4032: and COL29 = p_phone_number
4033: and COL30 = p_phone_extension;

Line 4117: insert into ams_party_sources

4113: p_overlay IN VARCHAR2
4114: ) IS
4115: l_return_status varchar2(1);
4116: begin
4117: insert into ams_party_sources
4118: (
4119: party_sources_id,
4120: party_id,
4121: IMPORT_SOURCE_LINE_ID,

Line 4222: ams_party_sources_s.nextval,

4218: COL249,
4219: COL250
4220: )
4221: select
4222: ams_party_sources_s.nextval,
4223: LINE.PARTY_ID,
4224: LINE.IMPORT_SOURCE_LINE_ID,
4225: LINE.OBJECT_VERSION_NUMBER,
4226: LINE.LAST_UPDATE_DATE,

Line 4907: SELECT PARTY_ID FROM AMS_PARTY_SOURCES

4903: l_ret_status varchar(1);
4904:
4905:
4906: cursor c_email_address is
4907: SELECT PARTY_ID FROM AMS_PARTY_SOURCES
4908: WHERE PARTY_ID = p_party_id
4909: and upper(COL26) = upper(p_email_address);
4910:
4911: cursor c_ph_number is

Line 4912: select party_id from AMS_PARTY_SOURCES

4908: WHERE PARTY_ID = p_party_id
4909: and upper(COL26) = upper(p_email_address);
4910:
4911: cursor c_ph_number is
4912: select party_id from AMS_PARTY_SOURCES
4913: where party_id = p_party_id
4914: and col29 = p_ph_number
4915: and nvl(col27,nvl(p_ph_country_code,'x')) = nvl(p_ph_country_code,'x')
4916: and nvl(col28,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');

Line 4919: select party_id from AMS_PARTY_SOURCES

4915: and nvl(col27,nvl(p_ph_country_code,'x')) = nvl(p_ph_country_code,'x')
4916: and nvl(col28,nvl(p_ph_area_code,'x')) = nvl(p_ph_area_code,'x');
4917:
4918: cursor c_address_country is
4919: select party_id from AMS_PARTY_SOURCES
4920: where party_id = p_party_id
4921: and col18 = p_address1
4922: and col17 = p_country;
4923: