[Home] [Help]
PACKAGE: APPS.JTF_TTY_NACCT_SALES_PUB
Source
1 Package JTF_TTY_NACCT_SALES_PUB 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;