24: /*----------------------------------------------------------------*/
25: PROCEDURE Get_EmailDetails
26: (
27: p_api_version IN NUMBER,
28: p_commit IN VARCHAR2 := fnd_api.g_false,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_party_id IN NUMBER,
32: x_email_cnt_point_id OUT NOCOPY NUMBER,
25: PROCEDURE Get_EmailDetails
26: (
27: p_api_version IN NUMBER,
28: p_commit IN VARCHAR2 := fnd_api.g_false,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_party_id IN NUMBER,
32: x_email_cnt_point_id OUT NOCOPY NUMBER,
33: x_email_last_update_date OUT NOCOPY DATE,
26: (
27: p_api_version IN NUMBER,
28: p_commit IN VARCHAR2 := fnd_api.g_false,
29: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
30: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
31: p_party_id IN NUMBER,
32: x_email_cnt_point_id OUT NOCOPY NUMBER,
33: x_email_last_update_date OUT NOCOPY DATE,
34: x_return_status OUT NOCOPY VARCHAR2,
58: /*----------------------------------------------------------------*/
59: PROCEDURE Get_AddrDetails
60: (
61: p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_party_id IN NUMBER,
66: x_addr_location_id OUT NOCOPY NUMBER,
59: PROCEDURE Get_AddrDetails
60: (
61: p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_party_id IN NUMBER,
66: x_addr_location_id OUT NOCOPY NUMBER,
67: x_party_site_id OUT NOCOPY NUMBER,
60: (
61: p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_party_id IN NUMBER,
66: x_addr_location_id OUT NOCOPY NUMBER,
67: x_party_site_id OUT NOCOPY NUMBER,
68: x_addr_last_update_date OUT NOCOPY DATE,
91: /*----------------------------------------------------------------*/
92: PROCEDURE Get_PhoneDetails
93: (
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := fnd_api.g_false,
96: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_phone_cnt_point_id IN NUMBER,
99: x_phone_last_update_date OUT NOCOPY DATE,
92: PROCEDURE Get_PhoneDetails
93: (
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := fnd_api.g_false,
96: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_phone_cnt_point_id IN NUMBER,
99: x_phone_last_update_date OUT NOCOPY DATE,
100: x_return_status OUT NOCOPY VARCHAR2,
93: (
94: p_api_version IN NUMBER,
95: p_commit IN VARCHAR2 := fnd_api.g_false,
96: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
97: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
98: p_phone_cnt_point_id IN NUMBER,
99: x_phone_last_update_date OUT NOCOPY DATE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
120: /*----------------------------------------------------------------*/
121: PROCEDURE Get_PartyDetails
122: (
123: p_api_version IN NUMBER,
124: p_commit IN VARCHAR2 := fnd_api.g_false,
125: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
126: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
127: p_party_id IN NUMBER,
128: x_last_update_date OUT NOCOPY DATE,
121: PROCEDURE Get_PartyDetails
122: (
123: p_api_version IN NUMBER,
124: p_commit IN VARCHAR2 := fnd_api.g_false,
125: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
126: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
127: p_party_id IN NUMBER,
128: x_last_update_date OUT NOCOPY DATE,
129: x_return_status OUT NOCOPY VARCHAR2,
122: (
123: p_api_version IN NUMBER,
124: p_commit IN VARCHAR2 := fnd_api.g_false,
125: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
126: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
127: p_party_id IN NUMBER,
128: x_last_update_date OUT NOCOPY DATE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,