PACKAGE: APPS.PV_PARTNER_ACCNT_MGMT_PVT

Source

1 PACKAGE PV_PARTNER_ACCNT_MGMT_PVT AUTHID CURRENT_USER as
2 /* $Header: pvxvpams.pls 120.1 2005/08/10 14:37:20 appldev ship $ */
3 
4 TYPE Location_Rec_Type IS RECORD
5 (
6        LOCATION_ID		NUMBER := FND_API.G_MISS_NUM,
7        ADDRESS1			VARCHAR2(240) := FND_API.G_MISS_CHAR,
8        ADDRESS2			VARCHAR2(240) := FND_API.G_MISS_CHAR,
9        ADDRESS3			VARCHAR2(240) := FND_API.G_MISS_CHAR,
10        ADDRESS4			VARCHAR2(240) := FND_API.G_MISS_CHAR,
11        COUNTRY_CODE		VARCHAR2(10) := FND_API.G_MISS_CHAR,
12        COUNTRY			VARCHAR2(60) := FND_API.G_MISS_CHAR,
13        CITY			VARCHAR2(60) := FND_API.G_MISS_CHAR,
14        POSTAL_CODE		VARCHAR2(60) := FND_API.G_MISS_CHAR,
15        STATE			VARCHAR2(60) := FND_API.G_MISS_CHAR,
16        PROVINCE			VARCHAR2(60) := FND_API.G_MISS_CHAR,
17        COUNTY			VARCHAR2(60) := FND_API.G_MISS_CHAR,
18     LAST_UPDATE_DATE                DATE := FND_API.G_MISS_DATE
19 
20 );
21 G_MISS_Location_Rec	Location_Rec_Type;
22 
23 
24 TYPE Party_Site_Rec_Type IS RECORD
25 (
26        party_site_use_id      NUMBER := FND_API.G_MISS_NUM,
27        PARTY_SITE_ID		NUMBER := FND_API.G_MISS_NUM,
28        PARTY_ID			NUMBER := FND_API.G_MISS_NUM,
29        PARTY_SITE_USE_TYPE	VARCHAR2(60) := FND_API.G_MISS_CHAR,
30        PRIMARY_FLAG             VARCHAR2(1) := FND_API.G_MISS_CHAR,
31        LOCATION		        Location_Rec_Type := G_MISS_Location_Rec,
32        LAST_UPDATE_DATE                DATE := FND_API.G_MISS_DATE,
33        party_site_last_update_Date DATE := FND_API.G_MISS_DATE
34 
35 );
36 G_MISS_Party_Site_Rec	Party_Site_Rec_Type;
37 
38 
39 PROCEDURE Get_Partner_Accnt_Id(
40    p_Partner_Party_Id  IN  NUMBER,
41    x_return_status OUT NOCOPY VARCHAR2,
42    x_Cust_Acct_Id  OUT NOCOPY NUMBER
43  );
44 
45 /* R12 Changes
46  * Added out parameter x_cust_acct_site_id which
47  * will be passed to calls to get_cust_acct_roles
48 */
49  PROCEDURE  Get_acct_site_uses(
50   p_party_site_id IN NUMBER,
51   p_acct_site_type IN VARCHAR2,
52   p_cust_account_id IN NUMBER,
53   p_party_id IN NUMBER,
54   x_return_status OUT NOCOPY VARCHAR2,
55   x_site_use_id OUT NOCOPY number,
56   x_cust_acct_site_id OUT NOCOPY NUMBER
57 );
58 
59 /* R12 Changes
60  * p_cust_account_site_id is no longer null as we will start passing
61  * this value in as per OM
62  * Removed paramter p_acct_site_type
63 */
64 PROCEDURE Get_cust_acct_roles(
65   p_contact_party_id IN NUMBER,
66   p_cust_account_site_id IN NUMBER,
67   p_cust_account_id IN NUMBER,
68   x_return_status OUT NOCOPY VARCHAR2,
69   x_cust_account_role_id OUT NOCOPY number
70 );
71 
72 PROCEDURE Create_Party_Site(
73   p_api_version       IN  NUMBER,
74   p_init_msg_list     IN  VARCHAR2  := FND_API.g_false,
75   p_commit            IN  VARCHAR2  := FND_API.g_false,
76   p_party_site_rec        IN      PARTY_SITE_REC_TYPE,
77   x_return_status         OUT NOCOPY     VARCHAR2,
78   x_party_site_id         OUT NOCOPY     NUMBER,
79   x_msg_count             OUT NOCOPY     NUMBER,
80   x_msg_data              OUT NOCOPY     VARCHAR2
81 );
82 
83 END PV_PARTNER_ACCNT_MGMT_PVT;