32: -- Pre-reqs : None.
33: -- Parameters :
34: -- IN : p_api_version IN NUMBER Required
35: -- p_init_msg_list IN VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL
34: -- IN : p_api_version IN NUMBER Required
35: -- p_init_msg_list IN VARCHAR2 Optional
36: -- Default = FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL
41: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
42: -- OUT : x_return_status OUT VARCHAR2(1)
36: -- Default = FND_API.G_FALSE
37: -- p_commit IN VARCHAR2 Optional
38: -- Default = FND_API.G_FALSE
39: -- p_validation_level IN NUMBER Optional
40: -- Default = FND_API.G_VALID_LEVEL_FULL
41: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
42: -- OUT : x_return_status OUT VARCHAR2(1)
43: -- x_msg_count OUT NUMBER
44: -- x_msg_data OUT VARCHAR2(2000)
47: --
48: -- End of comments
49: PROCEDURE validate_uplift (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52: p_commit IN VARCHAR2 := fnd_api.g_false,
53: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
54: p_action IN VARCHAR2,
55: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
48: -- End of comments
49: PROCEDURE validate_uplift (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52: p_commit IN VARCHAR2 := fnd_api.g_false,
53: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
54: p_action IN VARCHAR2,
55: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
56: p_old_quota_rule_uplift IN quota_rule_uplift_rec_type := g_miss_quota_uplift_rec,
49: PROCEDURE validate_uplift (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52: p_commit IN VARCHAR2 := fnd_api.g_false,
53: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
54: p_action IN VARCHAR2,
55: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
56: p_old_quota_rule_uplift IN quota_rule_uplift_rec_type := g_miss_quota_uplift_rec,
57: x_return_status OUT NOCOPY VARCHAR2,
66: -- Pre-reqs : None.
67: -- Parameters :
68: -- IN : p_api_version IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
68: -- IN : p_api_version IN NUMBER Required
69: -- p_init_msg_list IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
76: -- OUT : x_return_status OUT VARCHAR2(1)
70: -- Default = FND_API.G_FALSE
71: -- p_commit IN VARCHAR2 Optional
72: -- Default = FND_API.G_FALSE
73: -- p_validation_level IN NUMBER Optional
74: -- Default = FND_API.G_VALID_LEVEL_FULL
75: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
76: -- OUT : x_return_status OUT VARCHAR2(1)
77: -- x_msg_count OUT NUMBER
78: -- x_msg_data OUT VARCHAR2(2000)
82: --
83: -- End of comments
84: PROCEDURE create_uplift (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
87: p_commit IN VARCHAR2 := fnd_api.g_false,
88: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
89: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
90: x_return_status OUT NOCOPY VARCHAR2,
83: -- End of comments
84: PROCEDURE create_uplift (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
87: p_commit IN VARCHAR2 := fnd_api.g_false,
88: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
89: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
84: PROCEDURE create_uplift (
85: p_api_version IN NUMBER,
86: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
87: p_commit IN VARCHAR2 := fnd_api.g_false,
88: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
89: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2
99: -- Pre-reqs : None.
100: -- Parameters :
101: -- IN : p_api_version IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
101: -- IN : p_api_version IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
109: -- OUT : x_return_status OUT VARCHAR2(1)
103: -- Default = FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Optional
105: -- Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional
107: -- Default = FND_API.G_VALID_LEVEL_FULL
108: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
109: -- OUT : x_return_status OUT VARCHAR2(1)
110: -- x_msg_count OUT NUMBER
111: -- x_msg_data OUT VARCHAR2(2000)
114: --
115: -- End of comments
116: PROCEDURE update_uplift (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
121: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
122: x_return_status OUT NOCOPY VARCHAR2,
115: -- End of comments
116: PROCEDURE update_uplift (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
121: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
116: PROCEDURE update_uplift (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
121: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2
131: -- Pre-reqs : None.
132: -- Parameters :
133: -- IN : p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
133: -- IN : p_api_version IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
141: -- OUT : x_return_status OUT VARCHAR2(1)
135: -- Default = FND_API.G_FALSE
136: -- p_commit IN VARCHAR2 Optional
137: -- Default = FND_API.G_FALSE
138: -- p_validation_level IN NUMBER Optional
139: -- Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_quota_rule_uplift IN quota_rule_uplift_rec_type
141: -- OUT : x_return_status OUT VARCHAR2(1)
142: -- x_msg_count OUT NUMBER
143: -- x_msg_data OUT VARCHAR2(2000)
146: --
147: -- End of comments
148: PROCEDURE delete_uplift (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
153: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
154: x_return_status OUT NOCOPY VARCHAR2,
147: -- End of comments
148: PROCEDURE delete_uplift (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
153: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
148: PROCEDURE delete_uplift (
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
151: p_commit IN VARCHAR2 := fnd_api.g_false,
152: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
153: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2