DBA Data[Home] [Help]

APPS.CN_ROLLUP_PVT dependencies on FND_API

Line 80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

76: --
77: --
78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER

Line 81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

77: --
78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER
85: -- x_msg_data VARCHAR2(2000)

Line 82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)

78: -- Parameters :
79: -- IN : p_api_version NUMBER Required
80: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
81: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
82: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
83: -- OUT : x_return_status VARCHAR2(1)
84: -- x_msg_count NUMBER
85: -- x_msg_data VARCHAR2(2000)
86: -- IN :

Line 101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

97: -- End of comments
98:
99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,

Line 102: p_commit IN VARCHAR2 := FND_API.G_FALSE,

98:
99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,

Line 103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

99: PROCEDURE get_active_role
100: ( p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_org_id IN NUMBER,

Line 113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

109: x_role OUT NOCOPY role_tbl_type);
110:
111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,

Line 114: p_commit IN VARCHAR2 := FND_API.G_FALSE,

110:
111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,

Line 115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

111: PROCEDURE get_active_group_member
112: ( p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
115: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_org_id IN NUMBER,

Line 125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

121: x_group_mem OUT NOCOPY group_mem_tbl_type);
122:
123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,

Line 126: p_commit IN VARCHAR2 := FND_API.G_FALSE,

122:
123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,

Line 127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

123: PROCEDURE get_active_group_member
124: ( p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_org_id IN NUMBER,

Line 137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

133: x_group_mem OUT NOCOPY srp_group_tbl_type);
134:
135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,

Line 138: p_commit IN VARCHAR2 := FND_API.G_FALSE,

134:
135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,

Line 139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

135: PROCEDURE get_active_group
136: ( p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_org_id IN NUMBER,

Line 149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

145: x_active_group OUT NOCOPY active_group_tbl_type);
146:
147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,

Line 150: p_commit IN VARCHAR2 := FND_API.G_FALSE,

146:
147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,

Line 151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

147: PROCEDURE get_ancestor_group
148: ( p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_group IN group_rec_type,

Line 160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

156: x_group OUT NOCOPY group_tbl_type);
157:
158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,

Line 161: p_commit IN VARCHAR2 := FND_API.G_FALSE,

157:
158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,

Line 162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

158: PROCEDURE get_descendant_group
159: ( p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_group IN group_rec_type,

Line 171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

167: x_group OUT NOCOPY group_tbl_type);
168:
169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,

Line 172: p_commit IN VARCHAR2 := FND_API.G_FALSE,

168:
169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,

Line 173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

169: PROCEDURE get_ancestor_salesrep
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_org_id IN NUMBER,

Line 183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

179: x_srp OUT NOCOPY srp_group_tbl_type);
180:
181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,

Line 184: p_commit IN VARCHAR2 := FND_API.G_FALSE,

180:
181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,

Line 185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

181: PROCEDURE get_descendant_salesrep
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_org_id IN NUMBER,

Line 195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

191: x_srp OUT NOCOPY srp_group_tbl_type);
192:
193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,

Line 196: p_commit IN VARCHAR2 := FND_API.G_FALSE,

192:
193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,

Line 197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

193: PROCEDURE get_descendant_salesrep
194: ( p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_org_id IN NUMBER,