28: -- End of comments
29:
30: PROCEDURE Create_Quota_Category(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_rec IN quota_category_rec_type,
36: x_return_status OUT NOCOPY VARCHAR2,
29:
30: PROCEDURE Create_Quota_Category(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_rec IN quota_category_rec_type,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
30: PROCEDURE Create_Quota_Category(
31: p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_rec IN quota_category_rec_type,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2,
49: -- End of comments
50:
51: PROCEDURE Update_Quota_Category(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_rec IN quota_category_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,
50:
51: PROCEDURE Update_Quota_Category(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_rec IN quota_category_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
51: PROCEDURE Update_Quota_Category(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2 := FND_API.G_FALSE,
55: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: p_rec IN quota_category_rec_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2);
69: -- End of comments
70:
71: PROCEDURE Delete_Quota_Category(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_quota_category_id IN NUMBER,
77: p_object_version_number IN NUMBER,
70:
71: PROCEDURE Delete_Quota_Category(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_quota_category_id IN NUMBER,
77: p_object_version_number IN NUMBER,
78: x_return_status OUT NOCOPY VARCHAR2,
71: PROCEDURE Delete_Quota_Category(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_quota_category_id IN NUMBER,
77: p_object_version_number IN NUMBER,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
89: --
90: --
91: -- Parameters :
92: -- IN : p_api_version NUMBER Require
93: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
94: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
95: -- OUT : x_return_status VARCHAR2(1)
96: -- x_msg_count NUMBER
97: -- x_msg_data VARCHAR2(2000)
90: --
91: -- Parameters :
92: -- IN : p_api_version NUMBER Require
93: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
94: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
95: -- OUT : x_return_status VARCHAR2(1)
96: -- x_msg_count NUMBER
97: -- x_msg_data VARCHAR2(2000)
98: -- IN : p_start_record NUMBER,
108: -- End of comments
109:
110: PROCEDURE Get_Quota_Category_details
111: ( p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
109:
110: PROCEDURE Get_Quota_Category_details
111: ( p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,