DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGN_PVT dependencies on FND_API

Line 10: NAME CN_QUOTAS.NAME%TYPE := FND_API.G_MISS_CHAR,

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,

Line 11: DESCRIPTION CN_QUOTAS.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,

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,

Line 12: START_DATE CN_QUOTAS.START_DATE%TYPE := FND_API.G_MISS_DATE,

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,

Line 13: END_DATE CN_QUOTAS.END_DATE%TYPE := FND_API.G_MISS_DATE,

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

Line 14: QUOTA_SEQUENCE CN_QUOTA_ASSIGNS.QUOTA_SEQUENCE%TYPE := FND_API.G_MISS_NUM,

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: ) ;

Line 37: -- Default = FND_API.G_FALSE

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

Line 39: -- Default = FND_API.G_FALSE

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)

Line 41: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 52: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 53: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 54: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);

Line 68: -- Default = FND_API.G_FALSE

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

Line 70: -- Default = FND_API.G_FALSE

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)

Line 72: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 84: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 85: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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 );

Line 99: -- Default = FND_API.G_FALSE

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

Line 101: -- Default = FND_API.G_FALSE

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)

Line 103: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 115: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);

Line 131: -- Default = FND_API.G_FALSE

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

Line 133: -- Default = FND_API.G_FALSE

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)

Line 135: -- Default = FND_API.G_VALID_LEVEL_FULL

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)

Line 147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 148: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,