DBA Data[Home] [Help]

PACKAGE: APPS.HZ_EXTRACT_PARTY_SITE_BO_PVT

Source


1 PACKAGE HZ_EXTRACT_PARTY_SITE_BO_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHEPSVS.pls 120.1 2005/07/13 21:25:04 awu noship $ */
3 /*
4  * This package contains the private APIs for logical party site.
5  * @rep:scope private
6  * @rep:product HZ
7  * @rep:displayname party site
8  * @rep:category BUSINESS_ENTITY HZ_PARTIES
9  * @rep:lifecycle active
10  * @rep:doccd 115hztig.pdf party site Get APIs
11  */
12 
13   --------------------------------------
14   --
15   -- PROCEDURE get_party_site_bo
16   --
17   -- DESCRIPTION
18   --     Get a logical party site.
19   --
20   -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
21   --
22   -- ARGUMENTS
23   --   IN:
24   --     p_init_msg_list      Initialize message stack if it is set to  FND_API.G_TRUE. Default is FND_API.G_FALSE.
25  --       p_party_id          party ID.
26  --       p_party_site_id     party site ID. If this id is not passed in, multiple site objects will be returned.
27   --     p_party_site_os          party site orig system.
28   --     p_party_site_osr         party site orig system reference.
29   --
30   --   OUT:
31   --     x_party_site_objs         Logical party site records.
32   --     x_return_status      Return status after the call. The status can
33   --                          be fnd_api.g_ret_sts_success (success),
34   --                          fnd_api.g_ret_sts_error (error),
35   --                          FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36   --     x_msg_count          Number of messages in message stack.
37   --     x_msg_data           Message text if x_msg_count is 1.
38   --
39   -- NOTES
40   --
41   -- MODIFICATION HISTORY
42   --
43   --
44   --   15-MAY-2005   AWU                Created.
45   --
46 
47 /*
48 The Get party site API Procedure is a retrieval service that returns a full party site business object.
49 The user identifies a particular party site business object using the TCA identifier and/or
50 the object Source System information. Upon proper validation of the object,
51 the full party site business object is returned. The object consists of all data included within
52 the party site business object, at all embedded levels. This includes the set of all data stored
53 in the TCA tables for each embedded entity.
54 
55 To retrieve the appropriate embedded business objects within the party site business object,
56 the Get procedure calls the equivalent procedure for the following embedded objects:
57 
58 Embedded BO	    Mandatory	Multiple Logical API Procedure		Comments
59 Phone			N	Y		get_phone_bos
60 Telex			N	Y		get_telex_bos
61 Email			N	Y		get_email_bos
62 Web			N	Y		get_web_bos
63 
64 To retrieve the appropriate embedded entities within the party site business object,
65 the Get procedure returns all records for the particular party site from these TCA entity tables:
66 
67 Embedded TCA Entity	Mandatory	Multiple	TCA Table Entities
68 
69 Location		Y		N	HZ_LOCATIONS
70 Party Site		Y		N	HZ_PARTY_SITES
71 Party Site Use		N		Y	HZ_PARTY_SITE_USES
72 Contact Preference	N		Y	HZ_CONTACT_PREFERENCES
73 */
74 
75 
76  PROCEDURE get_party_site_bos(
77     p_init_msg_list       IN            VARCHAR2 := fnd_api.g_false,
78     p_party_id            IN NUMBER,
79     p_party_site_id           IN            NUMBER,
80     p_action_type	  IN VARCHAR2 := NULL,
81     x_party_site_objs          OUT NOCOPY    HZ_PARTY_SITE_BO_TBL,
82     x_return_status       OUT NOCOPY    VARCHAR2,
83     x_msg_count           OUT NOCOPY    NUMBER,
84     x_msg_data            OUT NOCOPY    VARCHAR2
85   );
86 
87 END;