6: (
7: QUOTA_ASSIGN_ID CN_QUOTA_ASSIGNS.QUOTA_ASSIGN_ID%TYPE := CN_API.G_MISS_ID,
8: QUOTA_ID CN_QUOTA_ASSIGNS.QUOTA_ID%TYPE := CN_API.G_MISS_ID,
9: COMP_PLAN_ID CN_QUOTA_ASSIGNS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
7: QUOTA_ASSIGN_ID CN_QUOTA_ASSIGNS.QUOTA_ASSIGN_ID%TYPE := CN_API.G_MISS_ID,
8: QUOTA_ID CN_QUOTA_ASSIGNS.QUOTA_ID%TYPE := CN_API.G_MISS_ID,
9: COMP_PLAN_ID CN_QUOTA_ASSIGNS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER CN_QUOTA_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE := NULL,
8: QUOTA_ID CN_QUOTA_ASSIGNS.QUOTA_ID%TYPE := CN_API.G_MISS_ID,
9: COMP_PLAN_ID CN_QUOTA_ASSIGNS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER CN_QUOTA_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE := NULL,
16: ORG_ID CN_QUOTA_ASSIGNS.ORG_ID%TYPE := NULL,
9: COMP_PLAN_ID CN_QUOTA_ASSIGNS.COMP_PLAN_ID%TYPE := CN_API.G_MISS_ID,
10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER CN_QUOTA_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE := NULL,
16: ORG_ID CN_QUOTA_ASSIGNS.ORG_ID%TYPE := NULL,
17: IDQ_FLAG varchar(10) := NULL
10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,
11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,
13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,
14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,
15: OBJECT_VERSION_NUMBER CN_QUOTA_ASSIGNS.OBJECT_VERSION_NUMBER%TYPE := NULL,
16: ORG_ID CN_QUOTA_ASSIGNS.ORG_ID%TYPE := NULL,
17: IDQ_FLAG varchar(10) := NULL
18: ) ;
33: -- Pre-reqs : None.
34: -- Parameters :
35: -- IN : p_api_version IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional
37: -- Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional
39: -- Default = FND_API.G_FALSE
40: -- p_validation_level IN NUMBER Optional
41: -- Default = FND_API.G_VALID_LEVEL_FULL
35: -- IN : p_api_version IN NUMBER Required
36: -- p_init_msg_list IN VARCHAR2 Optional
37: -- Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional
39: -- Default = FND_API.G_FALSE
40: -- p_validation_level IN NUMBER Optional
41: -- Default = FND_API.G_VALID_LEVEL_FULL
42: -- p_quota_assign IN quota_assign_rec_type
43: -- OUT : x_return_status OUT VARCHAR2(1)
37: -- Default = FND_API.G_FALSE
38: -- p_commit IN VARCHAR2 Optional
39: -- Default = FND_API.G_FALSE
40: -- p_validation_level IN NUMBER Optional
41: -- Default = FND_API.G_VALID_LEVEL_FULL
42: -- p_quota_assign IN quota_assign_rec_type
43: -- OUT : x_return_status OUT VARCHAR2(1)
44: -- x_msg_count OUT NUMBER
45: -- x_msg_data OUT VARCHAR2(2000)
48: --
49: -- End of comments
50: PROCEDURE Create_Quota_Assign
51: (p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
49: -- End of comments
50: PROCEDURE Create_Quota_Assign
51: (p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
50: PROCEDURE Create_Quota_Assign
51: (p_api_version IN NUMBER,
52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53: p_commit IN VARCHAR2 := FND_API.G_FALSE,
54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
55: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2);
64: -- Pre-reqs : None.
65: -- Parameters :
66: -- IN : p_api_version IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
66: -- IN : p_api_version IN NUMBER Required
67: -- p_init_msg_list IN VARCHAR2 Optional
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- p_quota_assign IN quota_assign_rec_type
74: -- OUT : x_return_status OUT VARCHAR2(1)
68: -- Default = FND_API.G_FALSE
69: -- p_commit IN VARCHAR2 Optional
70: -- Default = FND_API.G_FALSE
71: -- p_validation_level IN NUMBER Optional
72: -- Default = FND_API.G_VALID_LEVEL_FULL
73: -- p_quota_assign IN quota_assign_rec_type
74: -- OUT : x_return_status OUT VARCHAR2(1)
75: -- x_msg_count OUT NUMBER
76: -- x_msg_data OUT VARCHAR2(2000)
79: --
80: -- End of comments
81: PROCEDURE Update_Quota_Assign
82: (p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
87: x_return_status OUT NOCOPY VARCHAR2,
80: -- End of comments
81: PROCEDURE Update_Quota_Assign
82: (p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
81: PROCEDURE Update_Quota_Assign
82: (p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_commit IN VARCHAR2 := FND_API.G_FALSE,
85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86: p_quota_assign IN OUT NOCOPY quota_assign_rec_type,
87: x_return_status OUT NOCOPY VARCHAR2,
88: x_msg_count OUT NOCOPY NUMBER,
89: x_msg_data OUT NOCOPY VARCHAR2 );
95: -- Pre-reqs : None.
96: -- Parameters :
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
97: -- IN : p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_quota_assign IN quota_assign_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
99: -- Default = FND_API.G_FALSE
100: -- p_commit IN VARCHAR2 Optional
101: -- Default = FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Optional
103: -- Default = FND_API.G_VALID_LEVEL_FULL
104: -- p_quota_assign IN quota_assign_rec_type
105: -- OUT : x_return_status OUT VARCHAR2(1)
106: -- x_msg_count OUT NUMBER
107: -- x_msg_data OUT VARCHAR2(2000)
110: --
111: -- End of comments
112: PROCEDURE Delete_Quota_Assign
113: (p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_quota_assign IN quota_assign_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
111: -- End of comments
112: PROCEDURE Delete_Quota_Assign
113: (p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_quota_assign IN quota_assign_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
112: PROCEDURE Delete_Quota_Assign
113: (p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_quota_assign IN quota_assign_rec_type,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2);
127: -- Pre-reqs : None.
128: -- Parameters :
129: -- IN : p_api_version IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
129: -- IN : p_api_version IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_comp_plan_id IN NUMBER
137: -- OUT : x_return_status OUT VARCHAR2(1)
131: -- Default = FND_API.G_FALSE
132: -- p_commit IN VARCHAR2 Optional
133: -- Default = FND_API.G_FALSE
134: -- p_validation_level IN NUMBER Optional
135: -- Default = FND_API.G_VALID_LEVEL_FULL
136: -- p_comp_plan_id IN NUMBER
137: -- OUT : x_return_status OUT VARCHAR2(1)
138: -- x_msg_count OUT NUMBER
139: -- x_msg_data OUT VARCHAR2(2000)
143: --
144: -- End of comments
145: PROCEDURE Get_Quota_Assign
146: (p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_comp_plan_id IN NUMBER,
151: x_quota_assign OUT NOCOPY quota_assign_tbl_type,
144: -- End of comments
145: PROCEDURE Get_Quota_Assign
146: (p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_comp_plan_id IN NUMBER,
151: x_quota_assign OUT NOCOPY quota_assign_tbl_type,
152: x_return_status OUT NOCOPY VARCHAR2,
145: PROCEDURE Get_Quota_Assign
146: (p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
150: p_comp_plan_id IN NUMBER,
151: x_quota_assign OUT NOCOPY quota_assign_tbl_type,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,