DBA Data[Home] [Help]

APPS.IGS_OR_CONTACTS_PKG dependencies on DUAL

Line 231: FROM DUAL;

227: CLOSE cur_or_cntcts;
228:
229: SELECT hz_contact_points_s.NEXTVAL
230: INTO l_contact_point_id
231: FROM DUAL;
232:
233: -- Assign the values in the Contacts Record
234: org_rel_rec.subject_id := x_contact_party_id;
235: org_rel_rec.object_id := x_party_id;

Line 277: FROM dual;

273: -- Generating And Passing the party number if the profile value is set to 'No' for generating the party number
274: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
275: SELECT hz_party_number_s.NEXTVAL
276: INTO l_party_rec.party_number
277: FROM dual;
278:
279: org_rel_rec.party_rec.party_number := l_party_rec.party_number;
280:
281: END IF;

Line 599: FROM dual;

595: email_rec.email_address := x_email_address;
596:
597: SELECT hz_contact_points_s.NEXTVAL
598: INTO cpoint_rec.contact_point_id
599: FROM dual;
600:
601: cpoint_rec.created_by_module := 'IGS' ;
602: cpoint_rec.content_source_type := 'USER_ENTERED';
603: