DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

1099: -- timezone from fnd_timezones_vl view.
1100:
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,

Line 1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,

1100:
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

Line 1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,

1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

Line 1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,

1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,

Line 1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,

1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2

Line 1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2
1112: ) IS

Line 1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2
1112: ) IS
1113: l_debug_prefix VARCHAR2(30) := ''; --'validate_contact_point'

Line 14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14477: -- backward compatibility.
14478: --
14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

Line 14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,

14478: --
14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

Line 14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,

14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,

Line 14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,

14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2

Line 14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2
14489: ) IS

Line 14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2
14489: ) IS
14490: l_debug_prefix VARCHAR2(30) := '';

Line 14559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14555: -- backward compatibility.
14556: --
14557: PROCEDURE validate_edi_contact_point (
14558: p_create_update_flag IN VARCHAR2,
14559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14561: p_rowid IN ROWID,
14562: x_return_status IN OUT NOCOPY VARCHAR2
14563: ) IS

Line 14560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,

14556: --
14557: PROCEDURE validate_edi_contact_point (
14558: p_create_update_flag IN VARCHAR2,
14559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14561: p_rowid IN ROWID,
14562: x_return_status IN OUT NOCOPY VARCHAR2
14563: ) IS
14564: l_debug_prefix VARCHAR2(30) := '';

Line 14629: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14625: -- backward compatibility.
14626: --
14627: PROCEDURE validate_eft_contact_point (
14628: p_create_update_flag IN VARCHAR2,
14629: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14630: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14631: p_rowid IN ROWID,
14632: x_return_status IN OUT NOCOPY VARCHAR2
14633: ) IS

Line 14630: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,

14626: --
14627: PROCEDURE validate_eft_contact_point (
14628: p_create_update_flag IN VARCHAR2,
14629: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14630: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14631: p_rowid IN ROWID,
14632: x_return_status IN OUT NOCOPY VARCHAR2
14633: ) IS
14634: l_debug_prefix VARCHAR2(30) := '';

Line 14699: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14695: -- backward compatibility.
14696: --
14697: PROCEDURE validate_web_contact_point (
14698: p_create_update_flag IN VARCHAR2,
14699: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14700: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14701: p_rowid IN ROWID,
14702: x_return_status IN OUT NOCOPY VARCHAR2
14703: ) IS

Line 14700: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

14696: --
14697: PROCEDURE validate_web_contact_point (
14698: p_create_update_flag IN VARCHAR2,
14699: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14700: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14701: p_rowid IN ROWID,
14702: x_return_status IN OUT NOCOPY VARCHAR2
14703: ) IS
14704: l_debug_prefix VARCHAR2(30) := '';

Line 14770: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14766: -- backward compatibility.
14767: --
14768: PROCEDURE validate_phone_contact_point (
14769: p_create_update_flag IN VARCHAR2,
14770: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14771: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14772: p_rowid IN ROWID,
14773: x_return_status IN OUT NOCOPY VARCHAR2
14774: ) IS

Line 14771: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,

14767: --
14768: PROCEDURE validate_phone_contact_point (
14769: p_create_update_flag IN VARCHAR2,
14770: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14771: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14772: p_rowid IN ROWID,
14773: x_return_status IN OUT NOCOPY VARCHAR2
14774: ) IS
14775: l_debug_prefix VARCHAR2(30) := '';

Line 14840: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14836: -- backward compatibility.
14837: --
14838: PROCEDURE validate_telex_contact_point (
14839: p_create_update_flag IN VARCHAR2,
14840: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14841: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14842: p_rowid IN ROWID,
14843: x_return_status IN OUT NOCOPY VARCHAR2
14844: ) IS

Line 14841: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

14837: --
14838: PROCEDURE validate_telex_contact_point (
14839: p_create_update_flag IN VARCHAR2,
14840: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14841: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14842: p_rowid IN ROWID,
14843: x_return_status IN OUT NOCOPY VARCHAR2
14844: ) IS
14845: l_debug_prefix VARCHAR2(30) := '';

Line 14910: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14906: -- backward compatibility.
14907: --
14908: PROCEDURE validate_email_contact_point (
14909: p_create_update_flag IN VARCHAR2,
14910: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14911: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14912: p_rowid IN ROWID,
14913: x_return_status IN OUT NOCOPY VARCHAR2
14914: ) IS

Line 14911: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,

14907: --
14908: PROCEDURE validate_email_contact_point (
14909: p_create_update_flag IN VARCHAR2,
14910: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14911: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14912: p_rowid IN ROWID,
14913: x_return_status IN OUT NOCOPY VARCHAR2
14914: ) IS
14915: l_debug_prefix VARCHAR2(30) := '';