1 PACKAGE CSD_PARTIES_UTIL AUTHID CURRENT_USER AS
2 /* $Header: csdvptus.pls 115.2 2002/12/03 20:37:57 sangigup noship $ */
3
4
5
6 /*----------------------------------------------------------------*/
7 /* procedure name: Get_EmailDetails */
8 /* description : Gets email contact point for a given party */
9 /* This procedure accepts party id and returns */
10 /* the email contact point id and last updated */
11 /* date for that party. */
12 /* */
13 /* p_api_version Standard IN param */
14 /* p_commit Standard IN param */
15 /* p_init_msg_list Standard IN param */
16 /* p_validation_level Standard IN param */
17 /* p_party_id Party ID to get email details for */
18 /* x_email_cnt_point_id Email Contact Point ID */
19 /* x_email_last_update_date Last Updated Date for Contact Pt */
20 /* x_return_status Standard OUT param */
21 /* x_msg_count Standard OUT param */
22 /* x_msg_data Standard OUT param */
23 /* */
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,
33 x_email_last_update_date OUT NOCOPY DATE,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2 );
37
38 /*----------------------------------------------------------------*/
39 /* procedure name: Get_AddrDetails */
40 /* description : Gets address location and site for a party */
41 /* This procedure accepts party id and returns */
42 /* the address location and site ids and last */
43 /* updated date of both items for that party. */
44 /* */
45 /* p_api_version Standard IN param */
46 /* p_commit Standard IN param */
47 /* p_init_msg_list Standard IN param */
48 /* p_validation_level Standard IN param */
49 /* p_party_id Party ID to get addr details for */
50 /* x_addr_location_id Location ID for party */
51 /* x_party_site_id Site ID for location */
52 /* x_addr_last_update_date Last updated date for location */
53 /* x_party_site_last_update_date Last updated date for site */
54 /* x_return_status Standard OUT param */
55 /* x_msg_count Standard OUT param */
56 /* x_msg_data Standard OUT param */
57 /* */
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,
67 x_party_site_id OUT NOCOPY NUMBER,
68 x_addr_last_update_date OUT NOCOPY DATE,
69 x_party_site_last_update_date OUT NOCOPY DATE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2 );
73
74
75 /*----------------------------------------------------------------*/
76 /* procedure name: Get_PhoneDetails */
77 /* description : This procedure accepts phone contact point id */
78 /* and returns the last updated for that contact */
79 /* point. */
80 /* */
81 /* p_api_version Standard IN param */
82 /* p_commit Standard IN param */
83 /* p_init_msg_list Standard IN param */
84 /* p_validation_level Standard IN param */
85 /* p_phone_cnt_point_id Phone Contact Point ID */
86 /* x_phone_last_update_date Last Updated Date for Contact Pt */
87 /* x_return_status Standard OUT param */
88 /* x_msg_count Standard OUT param */
89 /* x_msg_data Standard OUT param */
90 /* */
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,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2 );
103
104
105 /*----------------------------------------------------------------*/
106 /* procedure name: Get_PartyDetails */
107 /* description : This procedure accepts TCA party id and */
108 /* returns the last updated for that party. */
109 /* */
110 /* p_api_version Standard IN param */
111 /* p_commit Standard IN param */
112 /* p_init_msg_list Standard IN param */
113 /* p_validation_level Standard IN param */
114 /* p_party_id Party ID to get details for */
115 /* x_last_update_date Last Updated Date for Party */
116 /* x_return_status Standard OUT param */
117 /* x_msg_count Standard OUT param */
118 /* x_msg_data Standard OUT param */
119 /* */
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,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2 );
132
133
134 END CSD_PARTIES_UTIL ;
[Home] [Help]