APPS.CN_QUOTA_CATEGORIES_PKG dependencies on FND_API

Line 58: DECODE(p_quota_categories_rec.NAME, FND_API.G_MISS_CHAR, NULL,

54: CREATED_BY,
55: OBJECT_VERSION_NUMBER)
56: select
57: l_quota_category_id,
58: DECODE(p_quota_categories_rec.NAME, FND_API.G_MISS_CHAR, NULL,
59: p_quota_categories_rec.NAME),
60: DECODE(p_quota_categories_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
61: p_quota_categories_rec.DESCRIPTION),
62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,

Line 60: DECODE(p_quota_categories_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,

56: select
57: l_quota_category_id,
58: DECODE(p_quota_categories_rec.NAME, FND_API.G_MISS_CHAR, NULL,
59: p_quota_categories_rec.NAME),
60: DECODE(p_quota_categories_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
61: p_quota_categories_rec.DESCRIPTION),
62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
63: p_quota_categories_rec.TYPE),
64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,

Line 62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,

58: DECODE(p_quota_categories_rec.NAME, FND_API.G_MISS_CHAR, NULL,
59: p_quota_categories_rec.NAME),
60: DECODE(p_quota_categories_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
61: p_quota_categories_rec.DESCRIPTION),
62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
63: p_quota_categories_rec.TYPE),
64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,
65: p_quota_categories_rec.COMPUTE_FLAG),
66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,

Line 64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,

60: DECODE(p_quota_categories_rec.DESCRIPTION, FND_API.G_MISS_CHAR, NULL,
61: p_quota_categories_rec.DESCRIPTION),
62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
63: p_quota_categories_rec.TYPE),
64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,
65: p_quota_categories_rec.COMPUTE_FLAG),
66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,
67: p_quota_categories_rec.INTERVAL_TYPE_ID),
68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,

Line 66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,

62: DECODE(p_quota_categories_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
63: p_quota_categories_rec.TYPE),
64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,
65: p_quota_categories_rec.COMPUTE_FLAG),
66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,
67: p_quota_categories_rec.INTERVAL_TYPE_ID),
68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,
69: p_quota_categories_rec.QUOTA_UNIT_CODE),
70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

Line 68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,

64: DECODE(p_quota_categories_rec.COMPUTE_FLAG, FND_API.G_MISS_CHAR, NULL,
65: p_quota_categories_rec.COMPUTE_FLAG),
66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,
67: p_quota_categories_rec.INTERVAL_TYPE_ID),
68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,
69: p_quota_categories_rec.QUOTA_UNIT_CODE),
70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
71: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

Line 70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,

66: DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID, FND_API.G_MISS_NUM, NULL,
67: p_quota_categories_rec.INTERVAL_TYPE_ID),
68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,
69: p_quota_categories_rec.QUOTA_UNIT_CODE),
70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
71: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
73: p_quota_categories_rec.ATTRIBUTE1),
74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

Line 72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,

68: DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE, FND_API.G_MISS_CHAR, NULL,
69: p_quota_categories_rec.QUOTA_UNIT_CODE),
70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
71: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
73: p_quota_categories_rec.ATTRIBUTE1),
74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
75: p_quota_categories_rec.ATTRIBUTE2),
76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

Line 74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,

70: DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
71: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
73: p_quota_categories_rec.ATTRIBUTE1),
74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
75: p_quota_categories_rec.ATTRIBUTE2),
76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
77: p_quota_categories_rec.ATTRIBUTE3),
78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

Line 76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,

72: DECODE(p_quota_categories_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
73: p_quota_categories_rec.ATTRIBUTE1),
74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
75: p_quota_categories_rec.ATTRIBUTE2),
76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
77: p_quota_categories_rec.ATTRIBUTE3),
78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
79: p_quota_categories_rec.ATTRIBUTE4),
80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

Line 78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,

74: DECODE(p_quota_categories_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
75: p_quota_categories_rec.ATTRIBUTE2),
76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
77: p_quota_categories_rec.ATTRIBUTE3),
78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
79: p_quota_categories_rec.ATTRIBUTE4),
80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
81: p_quota_categories_rec.ATTRIBUTE5),
82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

Line 80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,

76: DECODE(p_quota_categories_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
77: p_quota_categories_rec.ATTRIBUTE3),
78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
79: p_quota_categories_rec.ATTRIBUTE4),
80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
81: p_quota_categories_rec.ATTRIBUTE5),
82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
83: p_quota_categories_rec.ATTRIBUTE6),
84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

Line 82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,

78: DECODE(p_quota_categories_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
79: p_quota_categories_rec.ATTRIBUTE4),
80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
81: p_quota_categories_rec.ATTRIBUTE5),
82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
83: p_quota_categories_rec.ATTRIBUTE6),
84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
85: p_quota_categories_rec.ATTRIBUTE7),
86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

Line 84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,

80: DECODE(p_quota_categories_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
81: p_quota_categories_rec.ATTRIBUTE5),
82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
83: p_quota_categories_rec.ATTRIBUTE6),
84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
85: p_quota_categories_rec.ATTRIBUTE7),
86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
87: p_quota_categories_rec.ATTRIBUTE8),
88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

Line 86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,

82: DECODE(p_quota_categories_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
83: p_quota_categories_rec.ATTRIBUTE6),
84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
85: p_quota_categories_rec.ATTRIBUTE7),
86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
87: p_quota_categories_rec.ATTRIBUTE8),
88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
89: p_quota_categories_rec.ATTRIBUTE9),
90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

Line 88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,

84: DECODE(p_quota_categories_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
85: p_quota_categories_rec.ATTRIBUTE7),
86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
87: p_quota_categories_rec.ATTRIBUTE8),
88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
89: p_quota_categories_rec.ATTRIBUTE9),
90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
91: p_quota_categories_rec.ATTRIBUTE10),
92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

Line 90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,

86: DECODE(p_quota_categories_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
87: p_quota_categories_rec.ATTRIBUTE8),
88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
89: p_quota_categories_rec.ATTRIBUTE9),
90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
91: p_quota_categories_rec.ATTRIBUTE10),
92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
93: p_quota_categories_rec.ATTRIBUTE11),
94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

Line 92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,

88: DECODE(p_quota_categories_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
89: p_quota_categories_rec.ATTRIBUTE9),
90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
91: p_quota_categories_rec.ATTRIBUTE10),
92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
93: p_quota_categories_rec.ATTRIBUTE11),
94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
95: p_quota_categories_rec.ATTRIBUTE12),
96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

Line 94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,

90: DECODE(p_quota_categories_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
91: p_quota_categories_rec.ATTRIBUTE10),
92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
93: p_quota_categories_rec.ATTRIBUTE11),
94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
95: p_quota_categories_rec.ATTRIBUTE12),
96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
97: p_quota_categories_rec.ATTRIBUTE13),
98: DECODE(p_quota_categories_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

Line 96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,

92: DECODE(p_quota_categories_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
93: p_quota_categories_rec.ATTRIBUTE11),
94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
95: p_quota_categories_rec.ATTRIBUTE12),
96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
97: p_quota_categories_rec.ATTRIBUTE13),
98: DECODE(p_quota_categories_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
99: p_quota_categories_rec.ATTRIBUTE14),
100: DECODE(p_quota_categories_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

Line 98: DECODE(p_quota_categories_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,

94: DECODE(p_quota_categories_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
95: p_quota_categories_rec.ATTRIBUTE12),
96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
97: p_quota_categories_rec.ATTRIBUTE13),
98: DECODE(p_quota_categories_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
99: p_quota_categories_rec.ATTRIBUTE14),
100: DECODE(p_quota_categories_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
101: p_quota_categories_rec.ATTRIBUTE15),
102: G_LAST_UPDATE_DATE,

Line 100: DECODE(p_quota_categories_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,

96: DECODE(p_quota_categories_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
97: p_quota_categories_rec.ATTRIBUTE13),
98: DECODE(p_quota_categories_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
99: p_quota_categories_rec.ATTRIBUTE14),
100: DECODE(p_quota_categories_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
101: p_quota_categories_rec.ATTRIBUTE15),
102: G_LAST_UPDATE_DATE,
103: G_LAST_UPDATED_BY,
104: G_LAST_UPDATE_LOGIN,

Line 132: FND_API.G_MISS_CHAR,

128:
129: UPDATE CN_QUOTA_CATEGORIES oldrec
130: SET
131: NAME = DECODE(p_quota_categories_rec.NAME,
132: FND_API.G_MISS_CHAR,
133: oldrec.NAME,
134: p_quota_categories_rec.NAME),
135: DESCRIPTION = DECODE(p_quota_categories_rec.DESCRIPTION,
136: FND_API.G_MISS_CHAR,

Line 136: FND_API.G_MISS_CHAR,

132: FND_API.G_MISS_CHAR,
133: oldrec.NAME,
134: p_quota_categories_rec.NAME),
135: DESCRIPTION = DECODE(p_quota_categories_rec.DESCRIPTION,
136: FND_API.G_MISS_CHAR,
137: oldrec.DESCRIPTION,
138: p_quota_categories_rec.DESCRIPTION),
139: TYPE = DECODE(p_quota_categories_rec.TYPE,
140: FND_API.G_MISS_CHAR,

Line 140: FND_API.G_MISS_CHAR,

136: FND_API.G_MISS_CHAR,
137: oldrec.DESCRIPTION,
138: p_quota_categories_rec.DESCRIPTION),
139: TYPE = DECODE(p_quota_categories_rec.TYPE,
140: FND_API.G_MISS_CHAR,
141: oldrec.TYPE,
142: p_quota_categories_rec.TYPE),
143: COMPUTE_FLAG = DECODE(p_quota_categories_rec.COMPUTE_FLAG,
144: FND_API.G_MISS_CHAR,

Line 144: FND_API.G_MISS_CHAR,

140: FND_API.G_MISS_CHAR,
141: oldrec.TYPE,
142: p_quota_categories_rec.TYPE),
143: COMPUTE_FLAG = DECODE(p_quota_categories_rec.COMPUTE_FLAG,
144: FND_API.G_MISS_CHAR,
145: oldrec.COMPUTE_FLAG,
146: p_quota_categories_rec.COMPUTE_FLAG),
147: INTERVAL_TYPE_ID = DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID,
148: FND_API.G_MISS_NUM,

Line 148: FND_API.G_MISS_NUM,

144: FND_API.G_MISS_CHAR,
145: oldrec.COMPUTE_FLAG,
146: p_quota_categories_rec.COMPUTE_FLAG),
147: INTERVAL_TYPE_ID = DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID,
148: FND_API.G_MISS_NUM,
149: oldrec.INTERVAL_TYPE_ID,
150: p_quota_categories_rec.INTERVAL_TYPE_ID),
151: QUOTA_UNIT_CODE = DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE,
152: FND_API.G_MISS_CHAR,

Line 152: FND_API.G_MISS_CHAR,

148: FND_API.G_MISS_NUM,
149: oldrec.INTERVAL_TYPE_ID,
150: p_quota_categories_rec.INTERVAL_TYPE_ID),
151: QUOTA_UNIT_CODE = DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE,
152: FND_API.G_MISS_CHAR,
153: oldrec.QUOTA_UNIT_CODE,
154: p_quota_categories_rec.QUOTA_UNIT_CODE),
155: ATTRIBUTE_CATEGORY = DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY,
156: FND_API.G_MISS_CHAR,

Line 156: FND_API.G_MISS_CHAR,

152: FND_API.G_MISS_CHAR,
153: oldrec.QUOTA_UNIT_CODE,
154: p_quota_categories_rec.QUOTA_UNIT_CODE),
155: ATTRIBUTE_CATEGORY = DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY,
156: FND_API.G_MISS_CHAR,
157: oldrec.ATTRIBUTE_CATEGORY,
158: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
159: ATTRIBUTE1 = DECODE(p_quota_categories_rec.ATTRIBUTE1,
160: FND_API.G_MISS_CHAR,

Line 160: FND_API.G_MISS_CHAR,

156: FND_API.G_MISS_CHAR,
157: oldrec.ATTRIBUTE_CATEGORY,
158: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
159: ATTRIBUTE1 = DECODE(p_quota_categories_rec.ATTRIBUTE1,
160: FND_API.G_MISS_CHAR,
161: oldrec.ATTRIBUTE1,
162: p_quota_categories_rec.ATTRIBUTE1),
163: ATTRIBUTE2 = DECODE(p_quota_categories_rec.ATTRIBUTE2,
164: FND_API.G_MISS_CHAR,

Line 164: FND_API.G_MISS_CHAR,

160: FND_API.G_MISS_CHAR,
161: oldrec.ATTRIBUTE1,
162: p_quota_categories_rec.ATTRIBUTE1),
163: ATTRIBUTE2 = DECODE(p_quota_categories_rec.ATTRIBUTE2,
164: FND_API.G_MISS_CHAR,
165: oldrec.ATTRIBUTE2,
166: p_quota_categories_rec.ATTRIBUTE2),
167: ATTRIBUTE3 = DECODE(p_quota_categories_rec.ATTRIBUTE3,
168: FND_API.G_MISS_CHAR,

Line 168: FND_API.G_MISS_CHAR,

164: FND_API.G_MISS_CHAR,
165: oldrec.ATTRIBUTE2,
166: p_quota_categories_rec.ATTRIBUTE2),
167: ATTRIBUTE3 = DECODE(p_quota_categories_rec.ATTRIBUTE3,
168: FND_API.G_MISS_CHAR,
169: oldrec.ATTRIBUTE3,
170: p_quota_categories_rec.ATTRIBUTE3),
171: ATTRIBUTE4 = DECODE(p_quota_categories_rec.ATTRIBUTE4,
172: FND_API.G_MISS_CHAR,

Line 172: FND_API.G_MISS_CHAR,

168: FND_API.G_MISS_CHAR,
169: oldrec.ATTRIBUTE3,
170: p_quota_categories_rec.ATTRIBUTE3),
171: ATTRIBUTE4 = DECODE(p_quota_categories_rec.ATTRIBUTE4,
172: FND_API.G_MISS_CHAR,
173: oldrec.ATTRIBUTE4,
174: p_quota_categories_rec.ATTRIBUTE4),
175: ATTRIBUTE5 = DECODE(p_quota_categories_rec.ATTRIBUTE5,
176: FND_API.G_MISS_CHAR,

Line 176: FND_API.G_MISS_CHAR,

172: FND_API.G_MISS_CHAR,
173: oldrec.ATTRIBUTE4,
174: p_quota_categories_rec.ATTRIBUTE4),
175: ATTRIBUTE5 = DECODE(p_quota_categories_rec.ATTRIBUTE5,
176: FND_API.G_MISS_CHAR,
177: oldrec.ATTRIBUTE5,
178: p_quota_categories_rec.ATTRIBUTE5),
179: ATTRIBUTE6 = DECODE(p_quota_categories_rec.ATTRIBUTE6,
180: FND_API.G_MISS_CHAR,

Line 180: FND_API.G_MISS_CHAR,

176: FND_API.G_MISS_CHAR,
177: oldrec.ATTRIBUTE5,
178: p_quota_categories_rec.ATTRIBUTE5),
179: ATTRIBUTE6 = DECODE(p_quota_categories_rec.ATTRIBUTE6,
180: FND_API.G_MISS_CHAR,
181: oldrec.ATTRIBUTE6,
182: p_quota_categories_rec.ATTRIBUTE6),
183: ATTRIBUTE7 = DECODE(p_quota_categories_rec.ATTRIBUTE7,
184: FND_API.G_MISS_CHAR,

Line 184: FND_API.G_MISS_CHAR,

180: FND_API.G_MISS_CHAR,
181: oldrec.ATTRIBUTE6,
182: p_quota_categories_rec.ATTRIBUTE6),
183: ATTRIBUTE7 = DECODE(p_quota_categories_rec.ATTRIBUTE7,
184: FND_API.G_MISS_CHAR,
185: oldrec.ATTRIBUTE7,
186: p_quota_categories_rec.ATTRIBUTE7),
187: ATTRIBUTE8 = DECODE(p_quota_categories_rec.ATTRIBUTE8,
188: FND_API.G_MISS_CHAR,

Line 188: FND_API.G_MISS_CHAR,

184: FND_API.G_MISS_CHAR,
185: oldrec.ATTRIBUTE7,
186: p_quota_categories_rec.ATTRIBUTE7),
187: ATTRIBUTE8 = DECODE(p_quota_categories_rec.ATTRIBUTE8,
188: FND_API.G_MISS_CHAR,
189: oldrec.ATTRIBUTE8,
190: p_quota_categories_rec.ATTRIBUTE8),
191: ATTRIBUTE9 = DECODE(p_quota_categories_rec.ATTRIBUTE9,
192: FND_API.G_MISS_CHAR,

Line 192: FND_API.G_MISS_CHAR,

188: FND_API.G_MISS_CHAR,
189: oldrec.ATTRIBUTE8,
190: p_quota_categories_rec.ATTRIBUTE8),
191: ATTRIBUTE9 = DECODE(p_quota_categories_rec.ATTRIBUTE9,
192: FND_API.G_MISS_CHAR,
193: oldrec.ATTRIBUTE9,
194: p_quota_categories_rec.ATTRIBUTE9),
195: ATTRIBUTE10 = DECODE(p_quota_categories_rec.ATTRIBUTE10,
196: FND_API.G_MISS_CHAR,

Line 196: FND_API.G_MISS_CHAR,

192: FND_API.G_MISS_CHAR,
193: oldrec.ATTRIBUTE9,
194: p_quota_categories_rec.ATTRIBUTE9),
195: ATTRIBUTE10 = DECODE(p_quota_categories_rec.ATTRIBUTE10,
196: FND_API.G_MISS_CHAR,
197: oldrec.ATTRIBUTE10,
198: p_quota_categories_rec.ATTRIBUTE10),
199: ATTRIBUTE11 = DECODE(p_quota_categories_rec.ATTRIBUTE11,
200: FND_API.G_MISS_CHAR,

Line 200: FND_API.G_MISS_CHAR,

196: FND_API.G_MISS_CHAR,
197: oldrec.ATTRIBUTE10,
198: p_quota_categories_rec.ATTRIBUTE10),
199: ATTRIBUTE11 = DECODE(p_quota_categories_rec.ATTRIBUTE11,
200: FND_API.G_MISS_CHAR,
201: oldrec.ATTRIBUTE11,
202: p_quota_categories_rec.ATTRIBUTE11),
203: ATTRIBUTE12 = DECODE(p_quota_categories_rec.ATTRIBUTE12,
204: FND_API.G_MISS_CHAR,

Line 204: FND_API.G_MISS_CHAR,

200: FND_API.G_MISS_CHAR,
201: oldrec.ATTRIBUTE11,
202: p_quota_categories_rec.ATTRIBUTE11),
203: ATTRIBUTE12 = DECODE(p_quota_categories_rec.ATTRIBUTE12,
204: FND_API.G_MISS_CHAR,
205: oldrec.ATTRIBUTE12,
206: p_quota_categories_rec.ATTRIBUTE12),
207: ATTRIBUTE13 = DECODE(p_quota_categories_rec.ATTRIBUTE13,
208: FND_API.G_MISS_CHAR,

Line 208: FND_API.G_MISS_CHAR,

204: FND_API.G_MISS_CHAR,
205: oldrec.ATTRIBUTE12,
206: p_quota_categories_rec.ATTRIBUTE12),
207: ATTRIBUTE13 = DECODE(p_quota_categories_rec.ATTRIBUTE13,
208: FND_API.G_MISS_CHAR,
209: oldrec.ATTRIBUTE13,
210: p_quota_categories_rec.ATTRIBUTE13),
211: ATTRIBUTE14 = DECODE(p_quota_categories_rec.ATTRIBUTE14,
212: FND_API.G_MISS_CHAR,

Line 212: FND_API.G_MISS_CHAR,

208: FND_API.G_MISS_CHAR,
209: oldrec.ATTRIBUTE13,
210: p_quota_categories_rec.ATTRIBUTE13),
211: ATTRIBUTE14 = DECODE(p_quota_categories_rec.ATTRIBUTE14,
212: FND_API.G_MISS_CHAR,
213: oldrec.ATTRIBUTE14,
214: p_quota_categories_rec.ATTRIBUTE14),
215: ATTRIBUTE15 = DECODE(p_quota_categories_rec.ATTRIBUTE15,
216: FND_API.G_MISS_CHAR,

Line 216: FND_API.G_MISS_CHAR,

212: FND_API.G_MISS_CHAR,
213: oldrec.ATTRIBUTE14,
214: p_quota_categories_rec.ATTRIBUTE14),
215: ATTRIBUTE15 = DECODE(p_quota_categories_rec.ATTRIBUTE15,
216: FND_API.G_MISS_CHAR,
217: oldrec.ATTRIBUTE15,
218: p_quota_categories_rec.ATTRIBUTE15),
219: LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,
220: LAST_UPDATED_BY = G_LAST_UPDATED_BY,

Line 260: raise fnd_api.g_exc_unexpected_error;

256: if (c%notfound) then
257: close c;
258: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
259: fnd_msg_pub.add;
260: raise fnd_api.g_exc_unexpected_error;
261: end if;
262: close c;
263:
264: if (tlinfo.object_version_number <> p_quota_categories_rec.object_version_number) then

Line 267: raise fnd_api.g_exc_unexpected_error;

263:
264: if (tlinfo.object_version_number <> p_quota_categories_rec.object_version_number) then
265: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
266: fnd_msg_pub.add;
267: raise fnd_api.g_exc_unexpected_error;
268: end if;
269: UPDATE CN_QUOTA_CATEGORIES oldrec
270: SET
271: NAME = DECODE(p_quota_categories_rec.NAME,

Line 272: FND_API.G_MISS_CHAR,

268: end if;
269: UPDATE CN_QUOTA_CATEGORIES oldrec
270: SET
271: NAME = DECODE(p_quota_categories_rec.NAME,
272: FND_API.G_MISS_CHAR,
273: oldrec.NAME,
274: p_quota_categories_rec.NAME),
275: DESCRIPTION = DECODE(p_quota_categories_rec.DESCRIPTION,
276: FND_API.G_MISS_CHAR,

Line 276: FND_API.G_MISS_CHAR,

272: FND_API.G_MISS_CHAR,
273: oldrec.NAME,
274: p_quota_categories_rec.NAME),
275: DESCRIPTION = DECODE(p_quota_categories_rec.DESCRIPTION,
276: FND_API.G_MISS_CHAR,
277: oldrec.DESCRIPTION,
278: p_quota_categories_rec.DESCRIPTION),
279: TYPE = DECODE(p_quota_categories_rec.TYPE,
280: FND_API.G_MISS_CHAR,

Line 280: FND_API.G_MISS_CHAR,

276: FND_API.G_MISS_CHAR,
277: oldrec.DESCRIPTION,
278: p_quota_categories_rec.DESCRIPTION),
279: TYPE = DECODE(p_quota_categories_rec.TYPE,
280: FND_API.G_MISS_CHAR,
281: oldrec.TYPE,
282: p_quota_categories_rec.TYPE),
283: COMPUTE_FLAG = DECODE(p_quota_categories_rec.COMPUTE_FLAG,
284: FND_API.G_MISS_CHAR,

Line 284: FND_API.G_MISS_CHAR,

280: FND_API.G_MISS_CHAR,
281: oldrec.TYPE,
282: p_quota_categories_rec.TYPE),
283: COMPUTE_FLAG = DECODE(p_quota_categories_rec.COMPUTE_FLAG,
284: FND_API.G_MISS_CHAR,
285: oldrec.COMPUTE_FLAG,
286: p_quota_categories_rec.COMPUTE_FLAG),
287: INTERVAL_TYPE_ID = DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID,
288: FND_API.G_MISS_NUM,

Line 288: FND_API.G_MISS_NUM,

284: FND_API.G_MISS_CHAR,
285: oldrec.COMPUTE_FLAG,
286: p_quota_categories_rec.COMPUTE_FLAG),
287: INTERVAL_TYPE_ID = DECODE(p_quota_categories_rec.INTERVAL_TYPE_ID,
288: FND_API.G_MISS_NUM,
289: oldrec.INTERVAL_TYPE_ID,
290: p_quota_categories_rec.INTERVAL_TYPE_ID),
291: QUOTA_UNIT_CODE = DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE,
292: FND_API.G_MISS_CHAR,

Line 292: FND_API.G_MISS_CHAR,

288: FND_API.G_MISS_NUM,
289: oldrec.INTERVAL_TYPE_ID,
290: p_quota_categories_rec.INTERVAL_TYPE_ID),
291: QUOTA_UNIT_CODE = DECODE(p_quota_categories_rec.QUOTA_UNIT_CODE,
292: FND_API.G_MISS_CHAR,
293: oldrec.QUOTA_UNIT_CODE,
294: p_quota_categories_rec.QUOTA_UNIT_CODE),
295: ATTRIBUTE_CATEGORY = DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY,
296: FND_API.G_MISS_CHAR,

Line 296: FND_API.G_MISS_CHAR,

292: FND_API.G_MISS_CHAR,
293: oldrec.QUOTA_UNIT_CODE,
294: p_quota_categories_rec.QUOTA_UNIT_CODE),
295: ATTRIBUTE_CATEGORY = DECODE(p_quota_categories_rec.ATTRIBUTE_CATEGORY,
296: FND_API.G_MISS_CHAR,
297: oldrec.ATTRIBUTE_CATEGORY,
298: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
299: ATTRIBUTE1 = DECODE(p_quota_categories_rec.ATTRIBUTE1,
300: FND_API.G_MISS_CHAR,

Line 300: FND_API.G_MISS_CHAR,

296: FND_API.G_MISS_CHAR,
297: oldrec.ATTRIBUTE_CATEGORY,
298: p_quota_categories_rec.ATTRIBUTE_CATEGORY),
299: ATTRIBUTE1 = DECODE(p_quota_categories_rec.ATTRIBUTE1,
300: FND_API.G_MISS_CHAR,
301: oldrec.ATTRIBUTE1,
302: p_quota_categories_rec.ATTRIBUTE1),
303: ATTRIBUTE2 = DECODE(p_quota_categories_rec.ATTRIBUTE2,
304: FND_API.G_MISS_CHAR,

Line 304: FND_API.G_MISS_CHAR,

300: FND_API.G_MISS_CHAR,
301: oldrec.ATTRIBUTE1,
302: p_quota_categories_rec.ATTRIBUTE1),
303: ATTRIBUTE2 = DECODE(p_quota_categories_rec.ATTRIBUTE2,
304: FND_API.G_MISS_CHAR,
305: oldrec.ATTRIBUTE2,
306: p_quota_categories_rec.ATTRIBUTE2),
307: ATTRIBUTE3 = DECODE(p_quota_categories_rec.ATTRIBUTE3,
308: FND_API.G_MISS_CHAR,

Line 308: FND_API.G_MISS_CHAR,

304: FND_API.G_MISS_CHAR,
305: oldrec.ATTRIBUTE2,
306: p_quota_categories_rec.ATTRIBUTE2),
307: ATTRIBUTE3 = DECODE(p_quota_categories_rec.ATTRIBUTE3,
308: FND_API.G_MISS_CHAR,
309: oldrec.ATTRIBUTE3,
310: p_quota_categories_rec.ATTRIBUTE3),
311: ATTRIBUTE4 = DECODE(p_quota_categories_rec.ATTRIBUTE4,
312: FND_API.G_MISS_CHAR,

Line 312: FND_API.G_MISS_CHAR,

308: FND_API.G_MISS_CHAR,
309: oldrec.ATTRIBUTE3,
310: p_quota_categories_rec.ATTRIBUTE3),
311: ATTRIBUTE4 = DECODE(p_quota_categories_rec.ATTRIBUTE4,
312: FND_API.G_MISS_CHAR,
313: oldrec.ATTRIBUTE4,
314: p_quota_categories_rec.ATTRIBUTE4),
315: ATTRIBUTE5 = DECODE(p_quota_categories_rec.ATTRIBUTE5,
316: FND_API.G_MISS_CHAR,

Line 316: FND_API.G_MISS_CHAR,

312: FND_API.G_MISS_CHAR,
313: oldrec.ATTRIBUTE4,
314: p_quota_categories_rec.ATTRIBUTE4),
315: ATTRIBUTE5 = DECODE(p_quota_categories_rec.ATTRIBUTE5,
316: FND_API.G_MISS_CHAR,
317: oldrec.ATTRIBUTE5,
318: p_quota_categories_rec.ATTRIBUTE5),
319: ATTRIBUTE6 = DECODE(p_quota_categories_rec.ATTRIBUTE6,
320: FND_API.G_MISS_CHAR,

Line 320: FND_API.G_MISS_CHAR,

316: FND_API.G_MISS_CHAR,
317: oldrec.ATTRIBUTE5,
318: p_quota_categories_rec.ATTRIBUTE5),
319: ATTRIBUTE6 = DECODE(p_quota_categories_rec.ATTRIBUTE6,
320: FND_API.G_MISS_CHAR,
321: oldrec.ATTRIBUTE6,
322: p_quota_categories_rec.ATTRIBUTE6),
323: ATTRIBUTE7 = DECODE(p_quota_categories_rec.ATTRIBUTE7,
324: FND_API.G_MISS_CHAR,

Line 324: FND_API.G_MISS_CHAR,

320: FND_API.G_MISS_CHAR,
321: oldrec.ATTRIBUTE6,
322: p_quota_categories_rec.ATTRIBUTE6),
323: ATTRIBUTE7 = DECODE(p_quota_categories_rec.ATTRIBUTE7,
324: FND_API.G_MISS_CHAR,
325: oldrec.ATTRIBUTE7,
326: p_quota_categories_rec.ATTRIBUTE7),
327: ATTRIBUTE8 = DECODE(p_quota_categories_rec.ATTRIBUTE8,
328: FND_API.G_MISS_CHAR,

Line 328: FND_API.G_MISS_CHAR,

324: FND_API.G_MISS_CHAR,
325: oldrec.ATTRIBUTE7,
326: p_quota_categories_rec.ATTRIBUTE7),
327: ATTRIBUTE8 = DECODE(p_quota_categories_rec.ATTRIBUTE8,
328: FND_API.G_MISS_CHAR,
329: oldrec.ATTRIBUTE8,
330: p_quota_categories_rec.ATTRIBUTE8),
331: ATTRIBUTE9 = DECODE(p_quota_categories_rec.ATTRIBUTE9,
332: FND_API.G_MISS_CHAR,

Line 332: FND_API.G_MISS_CHAR,

328: FND_API.G_MISS_CHAR,
329: oldrec.ATTRIBUTE8,
330: p_quota_categories_rec.ATTRIBUTE8),
331: ATTRIBUTE9 = DECODE(p_quota_categories_rec.ATTRIBUTE9,
332: FND_API.G_MISS_CHAR,
333: oldrec.ATTRIBUTE9,
334: p_quota_categories_rec.ATTRIBUTE9),
335: ATTRIBUTE10 = DECODE(p_quota_categories_rec.ATTRIBUTE10,
336: FND_API.G_MISS_CHAR,

Line 336: FND_API.G_MISS_CHAR,

332: FND_API.G_MISS_CHAR,
333: oldrec.ATTRIBUTE9,
334: p_quota_categories_rec.ATTRIBUTE9),
335: ATTRIBUTE10 = DECODE(p_quota_categories_rec.ATTRIBUTE10,
336: FND_API.G_MISS_CHAR,
337: oldrec.ATTRIBUTE10,
338: p_quota_categories_rec.ATTRIBUTE10),
339: ATTRIBUTE11 = DECODE(p_quota_categories_rec.ATTRIBUTE11,
340: FND_API.G_MISS_CHAR,

Line 340: FND_API.G_MISS_CHAR,

336: FND_API.G_MISS_CHAR,
337: oldrec.ATTRIBUTE10,
338: p_quota_categories_rec.ATTRIBUTE10),
339: ATTRIBUTE11 = DECODE(p_quota_categories_rec.ATTRIBUTE11,
340: FND_API.G_MISS_CHAR,
341: oldrec.ATTRIBUTE11,
342: p_quota_categories_rec.ATTRIBUTE11),
343: ATTRIBUTE12 = DECODE(p_quota_categories_rec.ATTRIBUTE12,
344: FND_API.G_MISS_CHAR,

Line 344: FND_API.G_MISS_CHAR,

340: FND_API.G_MISS_CHAR,
341: oldrec.ATTRIBUTE11,
342: p_quota_categories_rec.ATTRIBUTE11),
343: ATTRIBUTE12 = DECODE(p_quota_categories_rec.ATTRIBUTE12,
344: FND_API.G_MISS_CHAR,
345: oldrec.ATTRIBUTE12,
346: p_quota_categories_rec.ATTRIBUTE12),
347: ATTRIBUTE13 = DECODE(p_quota_categories_rec.ATTRIBUTE13,
348: FND_API.G_MISS_CHAR,

Line 348: FND_API.G_MISS_CHAR,

344: FND_API.G_MISS_CHAR,
345: oldrec.ATTRIBUTE12,
346: p_quota_categories_rec.ATTRIBUTE12),
347: ATTRIBUTE13 = DECODE(p_quota_categories_rec.ATTRIBUTE13,
348: FND_API.G_MISS_CHAR,
349: oldrec.ATTRIBUTE13,
350: p_quota_categories_rec.ATTRIBUTE13),
351: ATTRIBUTE14 = DECODE(p_quota_categories_rec.ATTRIBUTE14,
352: FND_API.G_MISS_CHAR,

Line 352: FND_API.G_MISS_CHAR,

348: FND_API.G_MISS_CHAR,
349: oldrec.ATTRIBUTE13,
350: p_quota_categories_rec.ATTRIBUTE13),
351: ATTRIBUTE14 = DECODE(p_quota_categories_rec.ATTRIBUTE14,
352: FND_API.G_MISS_CHAR,
353: oldrec.ATTRIBUTE14,
354: p_quota_categories_rec.ATTRIBUTE14),
355: ATTRIBUTE15 = DECODE(p_quota_categories_rec.ATTRIBUTE15,
356: FND_API.G_MISS_CHAR,

Line 356: FND_API.G_MISS_CHAR,

352: FND_API.G_MISS_CHAR,
353: oldrec.ATTRIBUTE14,
354: p_quota_categories_rec.ATTRIBUTE14),
355: ATTRIBUTE15 = DECODE(p_quota_categories_rec.ATTRIBUTE15,
356: FND_API.G_MISS_CHAR,
357: oldrec.ATTRIBUTE15,
358: p_quota_categories_rec.ATTRIBUTE15),
359: LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,
360: LAST_UPDATED_BY = G_LAST_UPDATED_BY,