1 PACKAGE AS_ATA_UHK AS
2 /* $Header: asxcatas.pls 120.0 2005/06/02 17:20:40 appldev noship $ */
3
4 -- Start of Comments
5 -- Package Name : AS_ATA_UHK
6 --
7 -- Purpose : If user want to implement custom territory assignment
8 -- logic, create a package body for this spec.
9 --
10 -- NOTE : Please do not 'commit' in the package body. Once the
11 -- transaction is completed, Oracle Application code will
12 -- issue a commit.
13 --
14 -- This user hooks will be called before/after Assign
15 -- Territory Accesses
16 --
17 -- History :
18 -- 06/13/2002 FFANG Created
19 --
20 -- End of Comments
21
22 /*-------------------------------------------------------------------------*
23 |
24 | PUBLIC CONSTANTS
25 |
26 *-------------------------------------------------------------------------*/
27
28 /*-------------------------------------------------------------------------*
29 |
30 | PUBLIC DATATYPES
31 |
32 *-------------------------------------------------------------------------*/
33
34 /*-------------------------------------------------------------------------*
35 |
36 | PUBLIC VARIABLES
37 |
38 *-------------------------------------------------------------------------*/
39
40 /*-------------------------------------------------------------------------*
41 |
42 | PUBLIC ROUTINES
43 |
44 *-------------------------------------------------------------------------*/
45
46 -- Start of Comments
47 --
48 -- API name : ATA_Pre
49 -- Parameters :
50 -- IN :
51 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
52 -- p_init_msg_list : Initialize message stack or not. It's
53 -- FND_API.G_FALSE by default.
54 -- p_validation_level : Validation level for pass-in values.
55 -- It's FND_API.G_VALID_LEVEL_FULL by default.
56 -- p_commit : Whether commit the whole API at the end of API.
57 -- It's FND_API.G_FALSE by default.
58 --
59 -- The above four parameters are standard input.
60 --
61 -- IN :
62 -- p_param1 :
63 -- p_param2 :
64 -- p_param3 :
65 --
66 -- OUT :
67 -- x_return_status :
68 -- The return status. If your code completes
69 -- successfully, then FND_API.G_RET_STS_SUCCESS
70 -- should be returned; if you get an expected error,
71 -- then return FND_API.G_RET_STS_ERROR; otherwise
72 -- return FND_API.G_RET_STS_UNEXP_ERROR.
73 -- x_msg_count :
74 -- The message count.
75 -- Call FND_MSG_PUB.Count_And_Get to get the message
76 -- count and messages.
77 -- x_msg_data :
78 -- The messages.
79 -- Call FND_MSG_PUB.Count_And_Get to get the message
80 -- count and messages.
81 --
82 -- The above three parameters are standard output
83 -- parameters.
84 --
85 PROCEDURE ATA_Pre(
86 p_api_version_number IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_param1 IN VARCHAR2,
91 p_param2 IN VARCHAR2,
92 p_param3 IN VARCHAR2,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97
98 -- Start of Comments
99 --
100 -- API name : ATA_Post
101 -- Parameters :
102 -- IN :
103 -- p_api_version_number: For 11i Oracle Sales application, this is 2.0.
104 -- p_init_msg_list : Initialize message stack or not. It's
105 -- FND_API.G_FALSE by default.
106 -- p_validation_level : Validation level for pass-in values.
107 -- It's FND_API.G_VALID_LEVEL_FULL by default.
108 -- p_commit : Whether commit the whole API at the end of API.
109 -- It's FND_API.G_FALSE by default.
110 --
111 -- The above four parameters are standard input.
112 --
113 -- IN :
114 -- p_param1 :
115 -- p_param2 :
116 -- p_param3 :
117 --
118 -- OUT :
119 -- x_return_status :
120 -- The return status. If your code completes
121 -- successfully, then FND_API.G_RET_STS_SUCCESS
122 -- should be returned; if you get an expected error,
123 -- then return FND_API.G_RET_STS_ERROR; otherwise
124 -- return FND_API.G_RET_STS_UNEXP_ERROR.
125 -- x_msg_count :
126 -- The message count.
127 -- Call FND_MSG_PUB.Count_And_Get to get the message
128 -- count and messages.
129 -- x_msg_data :
130 -- The messages.
131 -- Call FND_MSG_PUB.Count_And_Get to get the message
132 -- count and messages.
133 --
134 -- The above three parameters are standard output
135 -- parameters.
136 --
137 PROCEDURE ATA_Post(
138 p_api_version_number IN NUMBER,
139 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
141 p_commit IN VARCHAR2 := FND_API.G_FALSE,
142 p_param1 IN VARCHAR2,
143 p_param2 IN VARCHAR2,
144 p_param3 IN VARCHAR2,
145 p_request_id IN NUMBER,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2);
149
150
151 END AS_ATA_UHK;
152