1 PACKAGE AS_SALES_MEMBER_PUB as
2 /* $Header: asxpsmbs.pls 120.1 2005/06/05 22:52:30 appldev $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_SALES_MEMBER_PUB
8 --
9 -- PURPOSE
10 -- This package is a public API for Sales Member related api's
11 --
12
13 --
14 -- HISTORY
15 -- 6/19/98 ALHUNG created
16 --
17 -- End of Comments
18
19 -- Sales Member Record : sales_member_rec_type
20 --
21 -- Parameters:
22 -- salesforce_id Salesforce identifier (PK for salesrep)
23 -- Type Sales Member Type: Employee or sales partner
24 -- Start_date_active Start active date of sales member
25 -- End_Date_active End active date of sales member
26 -- Employee_Person_Id Employee identifier
27 -- Sales_Group_Id Salesgroup identifier
28 -- Partner_Customer_Id Partner identifier
29 -- Partner_Address_Id Address identifier of the partner
30 -- Partner_Contact_Id Contact identifier of the partner
31 -- Last_name Sales Member First name if employee
32 -- First_name Sales Member Last name if employee
33 -- Full_name Sales Member Full name if employee
34 -- Email_address Sales Member Email Address if employee
35 -- Job_title Job title of Salesrep
36 -- Sales_Group_Name Name of the sales group this member belongs to
37 -- Customer_name Partner Name if partner
38 -- City Partner City if partner
39 -- State Partner State if partner
40 -- Address Partner Address if partner
41 -- User_id Fnd User identifier. Only used as criteria
42
43 G_EMPLOYEE_SALES_MEMBER CONSTANT VARCHAR2(30) := 'EMPLOYEE';
44 G_PARTNER_SALES_MEMBER CONSTANT VARCHAR2(30) := 'PARTNER';
45 G_OTHER_SALES_MEMBER CONSTANT VARCHAR2(30) := 'OTHERS';
46
47 TYPE sales_member_rec_type IS RECORD (
48 salesforce_id Number :=FND_API.G_MISS_NUM
49 ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50 ,Start_date_active DATE :=FND_API.G_MISS_DATE
51 ,End_date_active DATE :=FND_API.G_MISS_DATE
52 ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53 ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54 ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55 ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56 ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57 ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58 ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59 ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60 ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61 ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62 ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63 ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64 ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65 ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66 ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67 ,user_id Number :=FND_API.G_MISS_NUM
68 ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69 ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR
70 );
71
72 G_MISS_SALES_MEMBER_REC sales_member_rec_type;
73
74 TYPE sales_member_tbl_type is TABLE OF sales_member_rec_type
75 INDEX BY BINARY_INTEGER;
76
77
78 -- Start of Comments
79 --
80 -- API name : Convert_SFID_to_Values
81 -- Type : Public
82 -- Function : Return sales member record with values given
83 -- salesforce_id
84 --
85 -- Pre-reqs : None
86 -- Paramaeters :
87 -- IN :
88 -- p_api_version_number IN NUMBER Required
89 -- p_identity_salesforce_id IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional
91 -- Default = :=FND_API.G_FALSE
92 --
93 -- OUT NOCOPY /* file.sql.39 change */ :
94 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
95 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
96 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
97 -- x_sales_member_rec OUT NOCOPY /* file.sql.39 change */ Sales_Member_Rec_Type
98 --
99 -- Version : Current version 1.0
100 -- Initial version 1.0
101 --
102 -- Business Rules: This procedure use p_salesforce_id to identify a sales member.
103 -- If the member is a sales person, the person's last_name, first_name
104 -- etc are looked up. If the member is a sales partner, customer_name,
105 -- address, city, etc are looked up.
106 -- Notes:
107
108 PROCEDURE Convert_SFID_to_Values
109 ( p_api_version_number IN NUMBER,
110 p_init_msg_list IN VARCHAR2
111 := FND_API.G_FALSE,
112 p_salesforce_id IN NUMBER,
113
114 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
115 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
116 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
117 x_sales_member_rec OUT NOCOPY /* file.sql.39 change */ Sales_Member_Rec_Type
118 );
119
120
121 -- Start of Comments
122 --
123 -- API name : Convert_Partner_to_ID
124 -- Type : Public
125 -- Function : Return sales member record with values given
126 -- salesforce_id
127 --
128 -- Pre-reqs : None
129 -- Paramaeters :
130 -- IN :
131 -- p_api_version_number IN NUMBER Required
132 -- p_partner_customer_id IN NUMBER Required
133 -- p_partner_address_id IN NUMBER Required
134 -- p_init_msg_list IN VARCHAR2 Optional
135 -- Default = :=FND_API.G_FALSE
136 --
137 -- OUT NOCOPY /* file.sql.39 change */ :
138 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
139 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
140 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
141 -- x_sales_member_rec OUT NOCOPY /* file.sql.39 change */ Sales_Member_Rec_Type
142 --
143 -- Version : Current version 1.0
144 -- Initial version 1.0
145 --
146 -- Business Rules:
147 -- Notes:
148
149 Procedure Convert_Partner_to_ID( p_api_version_number IN NUMBER
150 ,p_init_msg_list IN VARCHAR2
151 := FND_API.G_FALSE
152 ,p_partner_customer_id IN Number
153 ,p_partner_address_id IN Number
154 ,x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
155 ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
156 ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 ,x_sales_member_rec OUT NOCOPY /* file.sql.39 change */ Sales_Member_Rec_Type );
158
159
160
161
162 END AS_SALES_MEMBER_PUB;
163