[Home] [Help]
PACKAGE: APPS.HZ_TAX_ASSIGNMENT_V2PUB
Source
1 PACKAGE HZ_TAX_ASSIGNMENT_V2PUB AUTHID CURRENT_USER as
2 /*$Header: ARH2TASS.pls 120.9 2006/08/17 10:20:04 idali noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 /**
9 * PROCEDURE create_loc_assignment
10 *
11 * DESCRIPTION
12 * Creates location assignment.
13 *
14 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15 *
16 * ARGUMENTS
17 * IN:
18 * p_init_msg_list Initialize message stack if it is set to
19 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
20 * p_location_id Location ID.
21 * p_lock_flag Lock record or not. Default is FND_API.G_FALSE.
22 * p_created_by_module Module name which creates this record.
23 * p_application_id Application ID which creates this record.
24 * IN/OUT:
25 * OUT:
26 * x_return_status Return status after the call. The status can
27 * be FND_API.G_RET_STS_SUCCESS (success),
28 * FND_API.G_RET_STS_ERROR (error),
29 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
30 * x_msg_count Number of messages in message stack.
31 * x_msg_data Message text if x_msg_count is 1.
32 * x_loc_id Location assignment ID.
33 *
34 * NOTES
35 *
36 * MODIFICATION HISTORY
37 *
38 * 07-23-2001 Indrajit Sen o Created.
39 *
40 */
41
42 PROCEDURE create_loc_assignment(
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_location_id IN NUMBER,
45 p_lock_flag IN VARCHAR2 := FND_API.G_FALSE,
46 p_created_by_module IN VARCHAR2,
47 p_application_id IN NUMBER,
48 x_return_status IN OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 x_loc_id OUT NOCOPY NUMBER
52 );
53
54 /**
55 * PROCEDURE update_loc_assignment
56 *
57 * DESCRIPTION
58 * Updates location assignment.
59 *
60 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
61 *
62 * ARGUMENTS
63 * IN:
64 * p_init_msg_list Initialize message stack if it is set to
65 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
66 * p_location_id Location ID.
67 * p_lock_flag Lock record or not. Default is FND_API.G_TRUE.
68 * p_created_by_module Module name which creates this record.
69 * p_application_id Application ID which creates this record.
70 * IN/OUT:
71 * OUT:
72 * x_return_status Return status after the call. The status can
73 * be FND_API.G_RET_STS_SUCCESS (success),
74 * FND_API.G_RET_STS_ERROR (error),
75 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
76 * x_msg_count Number of messages in message stack.
77 * x_msg_data Message text if x_msg_count is 1.
78 * x_loc_id Location assignment ID.
79 *
80 * NOTES
81 *
82 * MODIFICATION HISTORY
83 *
84 * 07-23-2001 Indrajit Sen o Created.
85 * 06-17-2002 Rajeshwari P o Bug 2413694.Changed the default value
86 * of p_lock_flag from FND_API.G_TRUE to
87 * FND_API.G_FALSE.
88 * 06-17-2002 Rajeshwari P o Bug 2413694.Reverted the previous change
89 *
90 */
91
92 PROCEDURE update_loc_assignment(
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_location_id IN NUMBER,
95 p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
96 p_created_by_module IN VARCHAR2,
97 p_application_id IN NUMBER,
98 x_return_status IN OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_loc_id OUT NOCOPY NUMBER,
102 x_org_id OUT NOCOPY VARCHAR2
103 );
104
105
106 PROCEDURE update_loc_assignment(
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_location_id IN NUMBER,
109 p_lock_flag IN VARCHAR2 := FND_API.G_TRUE,
110 p_created_by_module IN VARCHAR2,
111 p_application_id IN NUMBER,
112 x_return_status IN OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 x_loc_id OUT NOCOPY NUMBER
116 );
117
118
119 /*
120 * overloaded procedure with address validation.
121 */
122
123 PROCEDURE update_loc_assignment(
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
125 p_location_id IN NUMBER,
126 p_lock_flag IN VARCHAR2 :=FND_API.G_TRUE,
127 p_do_addr_val IN VARCHAR2,
128 x_addr_val_status OUT NOCOPY VARCHAR2,
129 x_addr_warn_msg OUT NOCOPY VARCHAR2,
130 x_return_status IN OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2
133 );
134
135
136 END HZ_TAX_ASSIGNMENT_V2PUB;
137