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 14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14457: -- backward compatibility.
14458: --
14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,

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

14458: --
14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,

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

14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,

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

14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2

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

14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2
14469: ) IS

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

14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2
14469: ) IS
14470: l_debug_prefix VARCHAR2(30) := '';

Line 14539: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14535: -- backward compatibility.
14536: --
14537: PROCEDURE validate_edi_contact_point (
14538: p_create_update_flag IN VARCHAR2,
14539: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14540: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14541: p_rowid IN ROWID,
14542: x_return_status IN OUT NOCOPY VARCHAR2
14543: ) IS

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

14536: --
14537: PROCEDURE validate_edi_contact_point (
14538: p_create_update_flag IN VARCHAR2,
14539: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14540: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14541: p_rowid IN ROWID,
14542: x_return_status IN OUT NOCOPY VARCHAR2
14543: ) IS
14544: l_debug_prefix VARCHAR2(30) := '';

Line 14609: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14605: -- backward compatibility.
14606: --
14607: PROCEDURE validate_eft_contact_point (
14608: p_create_update_flag IN VARCHAR2,
14609: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14610: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14611: p_rowid IN ROWID,
14612: x_return_status IN OUT NOCOPY VARCHAR2
14613: ) IS

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

14606: --
14607: PROCEDURE validate_eft_contact_point (
14608: p_create_update_flag IN VARCHAR2,
14609: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14610: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14611: p_rowid IN ROWID,
14612: x_return_status IN OUT NOCOPY VARCHAR2
14613: ) IS
14614: l_debug_prefix VARCHAR2(30) := '';

Line 14679: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14675: -- backward compatibility.
14676: --
14677: PROCEDURE validate_web_contact_point (
14678: p_create_update_flag IN VARCHAR2,
14679: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14681: p_rowid IN ROWID,
14682: x_return_status IN OUT NOCOPY VARCHAR2
14683: ) IS

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

14676: --
14677: PROCEDURE validate_web_contact_point (
14678: p_create_update_flag IN VARCHAR2,
14679: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14681: p_rowid IN ROWID,
14682: x_return_status IN OUT NOCOPY VARCHAR2
14683: ) IS
14684: l_debug_prefix VARCHAR2(30) := '';

Line 14750: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14746: -- backward compatibility.
14747: --
14748: PROCEDURE validate_phone_contact_point (
14749: p_create_update_flag IN VARCHAR2,
14750: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14751: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14752: p_rowid IN ROWID,
14753: x_return_status IN OUT NOCOPY VARCHAR2
14754: ) IS

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

14747: --
14748: PROCEDURE validate_phone_contact_point (
14749: p_create_update_flag IN VARCHAR2,
14750: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14751: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14752: p_rowid IN ROWID,
14753: x_return_status IN OUT NOCOPY VARCHAR2
14754: ) IS
14755: l_debug_prefix VARCHAR2(30) := '';

Line 14820: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14816: -- backward compatibility.
14817: --
14818: PROCEDURE validate_telex_contact_point (
14819: p_create_update_flag IN VARCHAR2,
14820: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14821: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14822: p_rowid IN ROWID,
14823: x_return_status IN OUT NOCOPY VARCHAR2
14824: ) IS

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

14817: --
14818: PROCEDURE validate_telex_contact_point (
14819: p_create_update_flag IN VARCHAR2,
14820: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14821: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14822: p_rowid IN ROWID,
14823: x_return_status IN OUT NOCOPY VARCHAR2
14824: ) IS
14825: l_debug_prefix VARCHAR2(30) := '';

Line 14890: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

14886: -- backward compatibility.
14887: --
14888: PROCEDURE validate_email_contact_point (
14889: p_create_update_flag IN VARCHAR2,
14890: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14891: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14892: p_rowid IN ROWID,
14893: x_return_status IN OUT NOCOPY VARCHAR2
14894: ) IS

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

14887: --
14888: PROCEDURE validate_email_contact_point (
14889: p_create_update_flag IN VARCHAR2,
14890: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14891: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14892: p_rowid IN ROWID,
14893: x_return_status IN OUT NOCOPY VARCHAR2
14894: ) IS
14895: l_debug_prefix VARCHAR2(30) := '';