DBA Data[Home] [Help]

APPS.CN_RT_QUOTA_ASGN_PVT dependencies on FND_API

Line 61: -- Default = FND_API.G_FALSE

57: -- Pre-reqs : None.
58: -- Parameters :
59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 63: -- Default = FND_API.G_FALSE

59: -- IN : p_api_version IN NUMBER Required
60: -- p_init_msg_list IN VARCHAR2 Optional
61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
67: -- OUT : x_return_status OUT VARCHAR2(1)

Line 65: -- Default = FND_API.G_VALID_LEVEL_FULL

61: -- Default = FND_API.G_FALSE
62: -- p_commit IN VARCHAR2 Optional
63: -- Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional
65: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
67: -- OUT : x_return_status OUT VARCHAR2(1)
68: -- x_msg_count OUT NUMBER
69: -- x_msg_data OUT VARCHAR2(2000)

Line 77: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

73: --
74: -- End of comments
75: PROCEDURE create_rate_table_assignment (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
78: p_commit IN VARCHAR2 := fnd_api.g_false,
79: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
80: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
81: x_return_status OUT NOCOPY VARCHAR2,

Line 78: p_commit IN VARCHAR2 := fnd_api.g_false,

74: -- End of comments
75: PROCEDURE create_rate_table_assignment (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
78: p_commit IN VARCHAR2 := fnd_api.g_false,
79: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
80: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,

Line 79: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

75: PROCEDURE create_rate_table_assignment (
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
78: p_commit IN VARCHAR2 := fnd_api.g_false,
79: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
80: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2

Line 94: -- Default = FND_API.G_FALSE

90: -- Pre-reqs : None.
91: -- Parameters :
92: -- IN : p_api_version IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 96: -- Default = FND_API.G_FALSE

92: -- IN : p_api_version IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
100: -- OUT : x_return_status OUT VARCHAR2(1)

Line 98: -- Default = FND_API.G_VALID_LEVEL_FULL

94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_rt_quota_asgn IN rt_quota_asgn_rec_type
100: -- OUT : x_return_status OUT VARCHAR2(1)
101: -- x_msg_count OUT NUMBER
102: -- x_msg_data OUT VARCHAR2(2000)

Line 109: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

105: --
106: -- End of comments
107: PROCEDURE update_rate_table_assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110: p_commit IN VARCHAR2 := fnd_api.g_false,
111: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
112: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
113: x_return_status OUT NOCOPY VARCHAR2,

Line 110: p_commit IN VARCHAR2 := fnd_api.g_false,

106: -- End of comments
107: PROCEDURE update_rate_table_assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110: p_commit IN VARCHAR2 := fnd_api.g_false,
111: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
112: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,

Line 111: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

107: PROCEDURE update_rate_table_assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
110: p_commit IN VARCHAR2 := fnd_api.g_false,
111: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
112: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2

Line 126: -- Default = FND_API.G_FALSE

122: -- Pre-reqs : None.
123: -- Parameters :
124: -- IN : p_api_version IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional
126: -- Default = FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Optional
128: -- Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional
130: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 128: -- Default = FND_API.G_FALSE

124: -- IN : p_api_version IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional
126: -- Default = FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Optional
128: -- Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional
130: -- Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_rt_quota_asgn IN quota_asgn_rec_type
132: -- OUT : x_return_status OUT VARCHAR2(1)

Line 130: -- Default = FND_API.G_VALID_LEVEL_FULL

126: -- Default = FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Optional
128: -- Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional
130: -- Default = FND_API.G_VALID_LEVEL_FULL
131: -- p_rt_quota_asgn IN quota_asgn_rec_type
132: -- OUT : x_return_status OUT VARCHAR2(1)
133: -- x_msg_count OUT NUMBER
134: -- x_msg_data OUT VARCHAR2(2000)

Line 141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

137: --
138: -- End of comments
139: PROCEDURE delete_rate_table_assignment (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,

Line 142: p_commit IN VARCHAR2 := fnd_api.g_false,

138: -- End of comments
139: PROCEDURE delete_rate_table_assignment (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,

Line 143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

139: PROCEDURE delete_rate_table_assignment (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
142: p_commit IN VARCHAR2 := fnd_api.g_false,
143: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
144: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2

Line 158: -- Default = FND_API.G_FALSE

154: -- Pre-reqs : None.
155: -- Parameters :
156: -- IN : p_api_version IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional
158: -- Default = FND_API.G_FALSE
159: -- p_commit IN VARCHAR2 Optional
160: -- Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional
162: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 160: -- Default = FND_API.G_FALSE

156: -- IN : p_api_version IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional
158: -- Default = FND_API.G_FALSE
159: -- p_commit IN VARCHAR2 Optional
160: -- Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional
162: -- Default = FND_API.G_VALID_LEVEL_FULL
163: -- p_quota_id IN NUMBER
164: -- OUT : x_return_status OUT VARCHAR2(1)

Line 162: -- Default = FND_API.G_VALID_LEVEL_FULL

158: -- Default = FND_API.G_FALSE
159: -- p_commit IN VARCHAR2 Optional
160: -- Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional
162: -- Default = FND_API.G_VALID_LEVEL_FULL
163: -- p_quota_id IN NUMBER
164: -- OUT : x_return_status OUT VARCHAR2(1)
165: -- x_msg_count OUT NUMBER
166: -- x_msg_data OUT VARCHAR2(2000)

Line 174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

170: --
171: -- End of comments
172: PROCEDURE get_formula_rate_tables (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_type IN VARCHAR2 := 'FORMULA',
178: p_quota_id IN NUMBER,

Line 175: p_commit IN VARCHAR2 := fnd_api.g_false,

171: -- End of comments
172: PROCEDURE get_formula_rate_tables (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_type IN VARCHAR2 := 'FORMULA',
178: p_quota_id IN NUMBER,
179: p_calc_formula_id IN NUMBER,

Line 176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

172: PROCEDURE get_formula_rate_tables (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_type IN VARCHAR2 := 'FORMULA',
178: p_quota_id IN NUMBER,
179: p_calc_formula_id IN NUMBER,
180: x_calc_formulas OUT NOCOPY calc_formulas_tbl_type,

Line 195: -- Default = FND_API.G_FALSE

191: -- Pre-reqs : None.
192: -- Parameters :
193: -- IN : p_api_version IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 197: -- Default = FND_API.G_FALSE

193: -- IN : p_api_version IN NUMBER Required
194: -- p_init_msg_list IN VARCHAR2 Optional
195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_quota_id IN NUMBER
201: -- OUT : x_return_status OUT VARCHAR2(1)

Line 199: -- Default = FND_API.G_VALID_LEVEL_FULL

195: -- Default = FND_API.G_FALSE
196: -- p_commit IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_validation_level IN NUMBER Optional
199: -- Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_quota_id IN NUMBER
201: -- OUT : x_return_status OUT VARCHAR2(1)
202: -- x_msg_count OUT NUMBER
203: -- x_msg_data OUT VARCHAR2(2000)

Line 211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

207: --
208: -- End of comments
209: PROCEDURE validate_rate_table_assignment (
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212: p_commit IN VARCHAR2 := fnd_api.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_action IN VARCHAR2,
215: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,

Line 212: p_commit IN VARCHAR2 := fnd_api.g_false,

208: -- End of comments
209: PROCEDURE validate_rate_table_assignment (
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212: p_commit IN VARCHAR2 := fnd_api.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_action IN VARCHAR2,
215: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
216: p_old_rt_quota_asgn IN rt_quota_asgn_rec_type := g_miss_rt_quota_asgn_rec,

Line 213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

209: PROCEDURE validate_rate_table_assignment (
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
212: p_commit IN VARCHAR2 := fnd_api.g_false,
213: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
214: p_action IN VARCHAR2,
215: p_rt_quota_asgn IN OUT NOCOPY rt_quota_asgn_rec_type,
216: p_old_rt_quota_asgn IN rt_quota_asgn_rec_type := g_miss_rt_quota_asgn_rec,
217: x_return_status OUT NOCOPY VARCHAR2,