1 PACKAGE AS_SALES_GROUP_PUB AUTHID CURRENT_USER as
2 /* $Header: asxpsgrs.pls 115.4 2002/11/06 00:46:32 appldev ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_SALES_GROUP_PUB
8 --
9 -- PURPOSE
10 -- This package is a public API for Sales Group related api's
11 --
12
13 --
14 -- HISTORY
15 -- 7/31/98 ALHUNG created
16 --
17 -- End of Comments
18
19 -- Sales Member Record : SALES_GROUP_rec_type
20 --
21 -- Parameters:
22 -- sales_group_id Sales_group identifier (PK for salesgroup)
23 -- Name Sales group name
24 -- Start_Date_Active The first day this sales group is active
25 -- Enabled_Flag Flag indicating whether sales group is active
26 -- Description description of the sales group
27 -- Parent_Sales_Group_id Parent Sales group identifier
28 -- Manager_Person_Id Identifier of the group's manager
29 -- Manager_Salesforce_Id Salesforce identifier of the manager
30 -- End_Date_Active The last day this sales group is active
31 -- Accounting_Code Cost Center Code
32
33
34 TYPE SALES_GROUP_rec_type IS RECORD (
35 sales_group_id Number :=FND_API.G_MISS_NUM
36 ,Name Varchar2(60) :=FND_API.G_MISS_CHAR
37 ,Start_Date_Active Date :=FND_API.G_MISS_DATE
38 -- ,Enabled_Flag Varchar2(1) :=FND_API.G_MISS_CHAR
39 ,Description Varchar2(240) :=FND_API.G_MISS_CHAR
40 ,Parent_Sales_Group_id Number :=FND_API.G_MISS_NUM
41 ,Manager_Person_Id Number :=FND_API.G_MISS_NUM
42 ,Manager_Salesforce_Id Number :=FND_API.G_MISS_NUM
43 ,End_Date_Active Date :=FND_API.G_MISS_DATE
44 ,Accounting_Code Varchar2(80) :=FND_API.G_MISS_CHAR
45
46 );
47
48 G_MISS_SALES_GROUP_REC SALES_GROUP_rec_type;
49
50 TYPE SALES_GROUP_tbl_type is TABLE OF SALES_GROUP_rec_type
51 INDEX BY BINARY_INTEGER;
52
53
54
55
56
57 END AS_SALES_GROUP_PUB;
58