eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_PARTIES_UTIL dependencies on STANDARD

Line 24: /* p_api_version Standard IN param */

20: /* This procedure accepts party id and returns */
21: /* the email contact point id and last updated */
22: /* date for that party. */
23: /* */
24: /* p_api_version Standard IN param */
25: /* p_commit Standard IN param */
26: /* p_init_msg_list Standard IN param */
27: /* p_validation_level Standard IN param */
28: /* p_party_id Party ID to get email details for */

Line 25: /* p_commit Standard IN param */

21: /* the email contact point id and last updated */
22: /* date for that party. */
23: /* */
24: /* p_api_version Standard IN param */
25: /* p_commit Standard IN param */
26: /* p_init_msg_list Standard IN param */
27: /* p_validation_level Standard IN param */
28: /* p_party_id Party ID to get email details for */
29: /* x_email_cnt_point_id Email Contact Point ID */

Line 26: /* p_init_msg_list Standard IN param */

22: /* date for that party. */
23: /* */
24: /* p_api_version Standard IN param */
25: /* p_commit Standard IN param */
26: /* p_init_msg_list Standard IN param */
27: /* p_validation_level Standard IN param */
28: /* p_party_id Party ID to get email details for */
29: /* x_email_cnt_point_id Email Contact Point ID */
30: /* x_email_last_update_date Last Updated Date for Contact Pt */

Line 27: /* p_validation_level Standard IN param */

23: /* */
24: /* p_api_version Standard IN param */
25: /* p_commit Standard IN param */
26: /* p_init_msg_list Standard IN param */
27: /* p_validation_level Standard IN param */
28: /* p_party_id Party ID to get email details for */
29: /* x_email_cnt_point_id Email Contact Point ID */
30: /* x_email_last_update_date Last Updated Date for Contact Pt */
31: /* x_return_status Standard OUT param */

Line 31: /* x_return_status Standard OUT param */

27: /* p_validation_level Standard IN param */
28: /* p_party_id Party ID to get email details for */
29: /* x_email_cnt_point_id Email Contact Point ID */
30: /* x_email_last_update_date Last Updated Date for Contact Pt */
31: /* x_return_status Standard OUT param */
32: /* x_msg_count Standard OUT param */
33: /* x_msg_data Standard OUT param */
34: /* */
35: /*----------------------------------------------------------------*/

Line 32: /* x_msg_count Standard OUT param */

28: /* p_party_id Party ID to get email details for */
29: /* x_email_cnt_point_id Email Contact Point ID */
30: /* x_email_last_update_date Last Updated Date for Contact Pt */
31: /* x_return_status Standard OUT param */
32: /* x_msg_count Standard OUT param */
33: /* x_msg_data Standard OUT param */
34: /* */
35: /*----------------------------------------------------------------*/
36: PROCEDURE Get_EmailDetails

Line 33: /* x_msg_data Standard OUT param */

29: /* x_email_cnt_point_id Email Contact Point ID */
30: /* x_email_last_update_date Last Updated Date for Contact Pt */
31: /* x_return_status Standard OUT param */
32: /* x_msg_count Standard OUT param */
33: /* x_msg_data Standard OUT param */
34: /* */
35: /*----------------------------------------------------------------*/
36: PROCEDURE Get_EmailDetails
37: (

Line 62: -- Standard Start of API savepoint

58: AND owner_table_name = 'HZ_PARTIES'
59: AND contact_point_type='EMAIL'
60: AND primary_flag='Y' ;
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT Get_EmailDetails_Utl;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 65: -- Standard call to check for call compatibility.

61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT Get_EmailDetails_Utl;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version,
67: p_api_version,
68: l_api_name,
69: G_PKG_NAME)

Line 94: -- Standard check of p_commit.

90: --
91: -- End API Body
92: --
93:
94: -- Standard check of p_commit.
95: IF FND_API.To_Boolean( p_commit ) THEN
96: COMMIT WORK;
97: END IF;
98:

Line 99: -- Standard call to get message count and IF count is get message info.

95: IF FND_API.To_Boolean( p_commit ) THEN
96: COMMIT WORK;
97: END IF;
98:
99: -- Standard call to get message count and IF count is get message info.
100: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
101: p_data => x_msg_data );
102:
103: EXCEPTION

Line 134: /* p_api_version Standard IN param */

130: /* This procedure accepts party id and returns */
131: /* the address location and site ids and last */
132: /* updated date of both items for that party. */
133: /* */
134: /* p_api_version Standard IN param */
135: /* p_commit Standard IN param */
136: /* p_init_msg_list Standard IN param */
137: /* p_validation_level Standard IN param */
138: /* p_party_id Party ID to get addr details for */

Line 135: /* p_commit Standard IN param */

131: /* the address location and site ids and last */
132: /* updated date of both items for that party. */
133: /* */
134: /* p_api_version Standard IN param */
135: /* p_commit Standard IN param */
136: /* p_init_msg_list Standard IN param */
137: /* p_validation_level Standard IN param */
138: /* p_party_id Party ID to get addr details for */
139: /* x_addr_location_id Location ID for party */

Line 136: /* p_init_msg_list Standard IN param */

132: /* updated date of both items for that party. */
133: /* */
134: /* p_api_version Standard IN param */
135: /* p_commit Standard IN param */
136: /* p_init_msg_list Standard IN param */
137: /* p_validation_level Standard IN param */
138: /* p_party_id Party ID to get addr details for */
139: /* x_addr_location_id Location ID for party */
140: /* x_party_site_id Site ID for location */

Line 137: /* p_validation_level Standard IN param */

133: /* */
134: /* p_api_version Standard IN param */
135: /* p_commit Standard IN param */
136: /* p_init_msg_list Standard IN param */
137: /* p_validation_level Standard IN param */
138: /* p_party_id Party ID to get addr details for */
139: /* x_addr_location_id Location ID for party */
140: /* x_party_site_id Site ID for location */
141: /* x_addr_last_update_date Last updated date for location */

Line 143: /* x_return_status Standard OUT param */

139: /* x_addr_location_id Location ID for party */
140: /* x_party_site_id Site ID for location */
141: /* x_addr_last_update_date Last updated date for location */
142: /* x_party_site_last_update_date Last updated date for site */
143: /* x_return_status Standard OUT param */
144: /* x_msg_count Standard OUT param */
145: /* x_msg_data Standard OUT param */
146: /* */
147: /*----------------------------------------------------------------*/

Line 144: /* x_msg_count Standard OUT param */

140: /* x_party_site_id Site ID for location */
141: /* x_addr_last_update_date Last updated date for location */
142: /* x_party_site_last_update_date Last updated date for site */
143: /* x_return_status Standard OUT param */
144: /* x_msg_count Standard OUT param */
145: /* x_msg_data Standard OUT param */
146: /* */
147: /*----------------------------------------------------------------*/
148: PROCEDURE Get_AddrDetails

Line 145: /* x_msg_data Standard OUT param */

141: /* x_addr_last_update_date Last updated date for location */
142: /* x_party_site_last_update_date Last updated date for site */
143: /* x_return_status Standard OUT param */
144: /* x_msg_count Standard OUT param */
145: /* x_msg_data Standard OUT param */
146: /* */
147: /*----------------------------------------------------------------*/
148: PROCEDURE Get_AddrDetails
149: (

Line 178: -- Standard Start of API savepoint

174: AND loc.location_id = sites.location_id
175: AND sites.identifying_address_flag='Y' ;
176:
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT Get_AddrDetails_Utl;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 181: -- Standard call to check for call compatibility.

177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT Get_AddrDetails_Utl;
180:
181: -- Standard call to check for call compatibility.
182: IF NOT FND_API.Compatible_API_Call (l_api_version,
183: p_api_version,
184: l_api_name,
185: G_PKG_NAME)

Line 212: -- Standard check of p_commit.

208: --
209: -- End API Body
210: --
211:
212: -- Standard check of p_commit.
213: IF FND_API.To_Boolean( p_commit ) THEN
214: COMMIT WORK;
215: END IF;
216:

Line 217: -- Standard call to get message count and IF count is get message info.

213: IF FND_API.To_Boolean( p_commit ) THEN
214: COMMIT WORK;
215: END IF;
216:
217: -- Standard call to get message count and IF count is get message info.
218: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
219: p_data => x_msg_data );
220:
221: EXCEPTION

Line 251: /* p_api_version Standard IN param */

247: /* description : This procedure accepts phone contact point id */
248: /* and returns the last updated for that contact */
249: /* point. */
250: /* */
251: /* p_api_version Standard IN param */
252: /* p_commit Standard IN param */
253: /* p_init_msg_list Standard IN param */
254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */

Line 252: /* p_commit Standard IN param */

248: /* and returns the last updated for that contact */
249: /* point. */
250: /* */
251: /* p_api_version Standard IN param */
252: /* p_commit Standard IN param */
253: /* p_init_msg_list Standard IN param */
254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */

Line 253: /* p_init_msg_list Standard IN param */

249: /* point. */
250: /* */
251: /* p_api_version Standard IN param */
252: /* p_commit Standard IN param */
253: /* p_init_msg_list Standard IN param */
254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */
257: /* x_return_status Standard OUT param */

Line 254: /* p_validation_level Standard IN param */

250: /* */
251: /* p_api_version Standard IN param */
252: /* p_commit Standard IN param */
253: /* p_init_msg_list Standard IN param */
254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */
257: /* x_return_status Standard OUT param */
258: /* x_msg_count Standard OUT param */

Line 257: /* x_return_status Standard OUT param */

253: /* p_init_msg_list Standard IN param */
254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */
257: /* x_return_status Standard OUT param */
258: /* x_msg_count Standard OUT param */
259: /* x_msg_data Standard OUT param */
260: /* */
261: /*----------------------------------------------------------------*/

Line 258: /* x_msg_count Standard OUT param */

254: /* p_validation_level Standard IN param */
255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */
257: /* x_return_status Standard OUT param */
258: /* x_msg_count Standard OUT param */
259: /* x_msg_data Standard OUT param */
260: /* */
261: /*----------------------------------------------------------------*/
262: PROCEDURE Get_PhoneDetails

Line 259: /* x_msg_data Standard OUT param */

255: /* p_phone_cnt_point_id Phone Contact Point ID */
256: /* x_phone_last_update_date Last Updated Date for Contact Pt */
257: /* x_return_status Standard OUT param */
258: /* x_msg_count Standard OUT param */
259: /* x_msg_data Standard OUT param */
260: /* */
261: /*----------------------------------------------------------------*/
262: PROCEDURE Get_PhoneDetails
263: (

Line 284: -- Standard Start of API savepoint

280: FROM HZ_CONTACT_POINTS
281: WHERE CONTACT_POINT_ID = l_phone_cnt_point_id;
282:
283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT Get_PhoneDetails_Utl;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 287: -- Standard call to check for call compatibility.

283: BEGIN
284: -- Standard Start of API savepoint
285: SAVEPOINT Get_PhoneDetails_Utl;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (l_api_version,
289: p_api_version,
290: l_api_name,
291: G_PKG_NAME)

Line 315: -- Standard check of p_commit.

311: --
312: -- End API Body
313: --
314:
315: -- Standard check of p_commit.
316: IF FND_API.To_Boolean( p_commit ) THEN
317: COMMIT WORK;
318: END IF;
319:

Line 320: -- Standard call to get message count and IF count is get message info.

316: IF FND_API.To_Boolean( p_commit ) THEN
317: COMMIT WORK;
318: END IF;
319:
320: -- Standard call to get message count and IF count is get message info.
321: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
322: p_data => x_msg_data );
323:
324: EXCEPTION

Line 353: /* p_api_version Standard IN param */

349: /* procedure name: Get_PartyDetails */
350: /* description : This procedure accepts TCA party id and */
351: /* returns the last updated for that party. */
352: /* */
353: /* p_api_version Standard IN param */
354: /* p_commit Standard IN param */
355: /* p_init_msg_list Standard IN param */
356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */

Line 354: /* p_commit Standard IN param */

350: /* description : This procedure accepts TCA party id and */
351: /* returns the last updated for that party. */
352: /* */
353: /* p_api_version Standard IN param */
354: /* p_commit Standard IN param */
355: /* p_init_msg_list Standard IN param */
356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */

Line 355: /* p_init_msg_list Standard IN param */

351: /* returns the last updated for that party. */
352: /* */
353: /* p_api_version Standard IN param */
354: /* p_commit Standard IN param */
355: /* p_init_msg_list Standard IN param */
356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */
359: /* x_return_status Standard OUT param */

Line 356: /* p_validation_level Standard IN param */

352: /* */
353: /* p_api_version Standard IN param */
354: /* p_commit Standard IN param */
355: /* p_init_msg_list Standard IN param */
356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */
359: /* x_return_status Standard OUT param */
360: /* x_msg_count Standard OUT param */

Line 359: /* x_return_status Standard OUT param */

355: /* p_init_msg_list Standard IN param */
356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */
359: /* x_return_status Standard OUT param */
360: /* x_msg_count Standard OUT param */
361: /* x_msg_data Standard OUT param */
362: /* */
363: /*----------------------------------------------------------------*/

Line 360: /* x_msg_count Standard OUT param */

356: /* p_validation_level Standard IN param */
357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */
359: /* x_return_status Standard OUT param */
360: /* x_msg_count Standard OUT param */
361: /* x_msg_data Standard OUT param */
362: /* */
363: /*----------------------------------------------------------------*/
364: PROCEDURE Get_PartyDetails

Line 361: /* x_msg_data Standard OUT param */

357: /* p_party_id Party ID to get details for */
358: /* x_last_update_date Last Updated Date for Party */
359: /* x_return_status Standard OUT param */
360: /* x_msg_count Standard OUT param */
361: /* x_msg_data Standard OUT param */
362: /* */
363: /*----------------------------------------------------------------*/
364: PROCEDURE Get_PartyDetails
365: (

Line 385: -- Standard Start of API savepoint

381: FROM HZ_PARTIES
382: WHERE PARTY_ID=l_curr_party_id;
383:
384: BEGIN
385: -- Standard Start of API savepoint
386: SAVEPOINT Get_PartyDetails_Utl;
387:
388: -- Standard call to check for call compatibility.
389: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 388: -- Standard call to check for call compatibility.

384: BEGIN
385: -- Standard Start of API savepoint
386: SAVEPOINT Get_PartyDetails_Utl;
387:
388: -- Standard call to check for call compatibility.
389: IF NOT FND_API.Compatible_API_Call (l_api_version,
390: p_api_version,
391: l_api_name,
392: G_PKG_NAME)

Line 417: -- Standard check of p_commit.

413: --
414: -- End API Body
415: --
416:
417: -- Standard check of p_commit.
418: IF FND_API.To_Boolean( p_commit ) THEN
419: COMMIT WORK;
420: END IF;
421:

Line 422: -- Standard call to get message count and IF count is get message info.

418: IF FND_API.To_Boolean( p_commit ) THEN
419: COMMIT WORK;
420: END IF;
421:
422: -- Standard call to get message count and IF count is get message info.
423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
424: p_data => x_msg_data );
425:
426: EXCEPTION