31: -- Desc : Procedure to RT Quota Asgns
32: -- Parameters :
33: -- IN : p_api_version IN NUMBER Require
34: -- p_init_msg_list IN VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Optional
37: -- Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional
39: -- Default = FND_API.G_VALID_LEVEL_FULL
33: -- IN : p_api_version IN NUMBER Require
34: -- p_init_msg_list IN VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Optional
37: -- Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional
39: -- Default = FND_API.G_VALID_LEVEL_FULL
40: -- OUT : x_return_status OUT VARCHAR2(1)
41: -- x_msg_count OUT NUMBER
35: -- Default = FND_API.G_FALSE
36: -- p_commit IN VARCHAR2 Optional
37: -- Default = FND_API.G_FALSE
38: -- p_validation_level IN NUMBER Optional
39: -- Default = FND_API.G_VALID_LEVEL_FULL
40: -- OUT : x_return_status OUT VARCHAR2(1)
41: -- x_msg_count OUT NUMBER
42: -- x_msg_data OUT VARCHAR2(2000)
43: -- IN p_rt_quota_asgns_tbl_rec IN rt_quota_asgns_rec_tbl_type,
50: -- End of comments
51:
52: PROCEDURE Create_rt_quota_asgns
53: ( p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER :=
57: FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
51:
52: PROCEDURE Create_rt_quota_asgns
53: ( p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER :=
57: FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
53: ( p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: p_validation_level IN NUMBER :=
57: FND_API.G_VALID_LEVEL_FULL,
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
61: p_quota_name IN cn_quotas.name%TYPE,
72: -- Desc : Procedure to RT Quota Asgns
73: -- Parameters :
74: -- IN : p_api_version IN NUMBER Require
75: -- p_init_msg_list IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- IN : p_api_version IN NUMBER Require
75: -- p_init_msg_list IN VARCHAR2 Optional
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
82: -- p_quota_name IN VARCHAR2
76: -- Default = FND_API.G_FALSE
77: -- p_commit IN VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional
80: -- Default = FND_API.G_VALID_LEVEL_FULL
81: -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
82: -- p_quota_name IN VARCHAR2
83: -- OUT : x_return_status OUT VARCHAR2(1)
84: -- x_msg_count OUT NUMBER
90: --
91: -- End of comments
92: PROCEDURE Update_rt_quota_asgns
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER :=
97: FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
91: -- End of comments
92: PROCEDURE Update_rt_quota_asgns
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER :=
97: FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95: p_commit IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN NUMBER :=
97: FND_API.G_VALID_LEVEL_FULL,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_quota_name IN cn_quotas.name%TYPE,
112: -- Desc : Procedure to RT Quota Asgns
113: -- Parameters :
114: -- IN : p_api_version IN NUMBER Require
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
114: -- IN : p_api_version IN NUMBER Require
115: -- p_init_msg_list IN VARCHAR2 Optional
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
122: -- p_quota_name IN VARCHAR2
116: -- Default = FND_API.G_FALSE
117: -- p_commit IN VARCHAR2 Optional
118: -- Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional
120: -- Default = FND_API.G_VALID_LEVEL_FULL
121: -- p_rt_quota_asgns_rec_tbl rt_quota_asgns_rec_tbl_type
122: -- p_quota_name IN VARCHAR2
123: -- OUT : x_return_status OUT VARCHAR2(1)
124: -- x_msg_count OUT NUMBER
131: -- End of comments
132:
133: PROCEDURE Delete_rt_quota_asgns
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER :=
138: FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
132:
133: PROCEDURE Delete_rt_quota_asgns
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER :=
138: FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
134: ( p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
136: p_commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER :=
138: FND_API.G_VALID_LEVEL_FULL,
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: p_quota_name IN cn_quotas.name%TYPE,