1191: ROLLBACK TO update_location_event;
1192:
1193: END update_location_event;
1194:
1195: -- HZ_CONTACT_POINT_V2PUB
1196:
1197:
1198: -- MODIFICATION HISTORY:
1199: -- 19-NOV-2001 Joe del Callar Bug 2116225: Added support for bank
1198: -- MODIFICATION HISTORY:
1199: -- 19-NOV-2001 Joe del Callar Bug 2116225: Added support for bank
1200: -- consolidation - param p_eft_rec.
1201: PROCEDURE create_contact_point_event (
1202: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1199: -- 19-NOV-2001 Joe del Callar Bug 2116225: Added support for bank
1200: -- consolidation - param p_eft_rec.
1201: PROCEDURE create_contact_point_event (
1202: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1200: -- consolidation - param p_eft_rec.
1201: PROCEDURE create_contact_point_event (
1202: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1201: PROCEDURE create_contact_point_event (
1202: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1209: ) IS
1202: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1209: ) IS
1210:
1203: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1209: ) IS
1210:
1211: l_list WF_PARAMETER_LIST_T;
1204: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1205: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1206: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1207: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1209: ) IS
1210:
1211: l_list WF_PARAMETER_LIST_T;
1212: l_param WF_PARAMETER_T;
1278: -- 19-NOV-2001 Joe del Callar Bug 2116225: Added support for bank
1279: -- consolidation - params p_eft_rec and
1280: -- p_old_eft_rec.
1281: PROCEDURE update_contact_point_event (
1282: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1279: -- consolidation - params p_eft_rec and
1280: -- p_old_eft_rec.
1281: PROCEDURE update_contact_point_event (
1282: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1280: -- p_old_eft_rec.
1281: PROCEDURE update_contact_point_event (
1282: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1281: PROCEDURE update_contact_point_event (
1282: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1282: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1283: p_old_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1284: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1285: p_old_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1286: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1287: p_old_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1288: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1296: ) IS
1289: p_old_email_rec IN hz_contact_point_v2pub.email_rec_type,
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1296: ) IS
1297:
1290: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1296: ) IS
1297:
1298: l_list WF_PARAMETER_LIST_T;
1291: p_old_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
1292: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1293: p_old_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
1294: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1296: ) IS
1297:
1298: l_list WF_PARAMETER_LIST_T;
1299: l_param WF_PARAMETER_T;