PACKAGE: APPS.JTF_TTY_NACCT_SALES_PUB

Source

1 Package JTF_TTY_NACCT_SALES_PUB  AUTHID CURRENT_USER AS
2 /* $Header: jtfnacss.pls 120.0 2005/06/02 18:20:38 appldev ship $ */
3 /*===========================================================================+
4  |               Copyright (c) 2002 Oracle Corporation                       |
5  |                  Redwood Shores, California, USA                          |
6  |                       All rights reserved.                                |
7 +===========================================================================*/
8 --    Start of Comments
9 --    ---------------------------------------------------
10 --    PACKAGE NAME:   JTF_TTY_NACCT_SALES_PUB
11 --    ---------------------------------------------------
12 --    PURPOSE
13 --
14 --      Procedures:
15 --         (see below for specification)
16 --
17 --    NOTES
18 --
19 --    HISTORY
20 --
21 --    End of Comments
22 --
23 --*******************************************************
24 --    Start of Comments
25 --*******************************************************
26 
27 --*******************************************************
28 -- RECORD TYPES
29 
30 TYPE SALESREP_RSC_REC_TYPE IS RECORD(
31     resource_id     NUMBER,
32     group_id        NUMBER,
33     role_code       VARCHAR2(300),
34     mgr_resource_id     NUMBER,
35     mgr_group_id        NUMBER,
36     mgr_role_code       VARCHAR2(300),
37     resource_type   VARCHAR2(300),
38     attribute1      VARCHAR2(300),
39     attribute2      VARCHAR2(300),
40     attribute3      VARCHAR2(300),
41     attribute4      VARCHAR2(300),
42     attribute5      VARCHAR2(300),
43     attribute6      VARCHAR2(300),
44     attribute7      VARCHAR2(300),
45     attribute8      VARCHAR2(300)
46 );
47 
48 TYPE SALESREP_RSC_TBL_TYPE IS TABLE OF SALESREP_RSC_REC_TYPE;
49 
50 TYPE AFFECTED_PARTY_REC_TYPE IS RECORD(
51     party_id            NUMBER,
52     named_account_id    NUMBER,
53     terr_group_account_id    NUMBER,
54     attribute1          VARCHAR2(300),
55     attribute2          VARCHAR2(300),
56     attribute3          VARCHAR2(300),
57     attribute4          VARCHAR2(300),
58     attribute5          VARCHAR2(300),
59     attribute6          VARCHAR2(300),
60     attribute7          VARCHAR2(300),
61     attribute8          VARCHAR2(300)
62 );
63 
64 TYPE AFFECTED_PARTY_TBL_TYPE IS TABLE OF AFFECTED_PARTY_REC_TYPE;
65 
66 
67 --*******************************************************
68 -- GLOBAL TYPE INSTANCES
69 
70 G_ADD_SALESREP_TBL SALESREP_RSC_TBL_TYPE;
71 G_REM_SALESREP_TBL SALESREP_RSC_TBL_TYPE;
72 G_AFFECT_PARTY_TBL AFFECTED_PARTY_TBL_TYPE;
73 
74 
75 --*******************************************************
76 -- APIS
77 
78 PROCEDURE UPDATE_SALES_TEAM(
79       p_api_version_number    IN          NUMBER,
80       p_init_msg_list         IN         VARCHAR2  := FND_API.G_FALSE,
81       p_SQL_Trace             IN         VARCHAR2,
82       p_Debug_Flag            IN         VARCHAR2,
83       x_return_status         OUT NOCOPY         VARCHAR2,
84       x_msg_count             OUT NOCOPY        NUMBER,
85       x_msg_data              OUT NOCOPY        VARCHAR2,
86 
87       p_user_resource_id      IN          NUMBER,
88       p_terr_group_id         IN          NUMBER,
89       p_user_attribute1       IN          VARCHAR2,
90       p_user_attribute2       IN          VARCHAR2,
91       p_added_rscs_tbl        IN          SALESREP_RSC_TBL_TYPE,
92       p_removed_rscs_tbl      IN          SALESREP_RSC_TBL_TYPE,
93       p_affected_parties_tbl  IN          AFFECTED_PARTY_TBL_TYPE,
94       ERRBUF                  OUT NOCOPY         VARCHAR2,
95       RETCODE                 OUT NOCOPY        VARCHAR2
96   );
97 
98 
99 
100 END JTF_TTY_NACCT_SALES_PUB;