APPS.CN_SEAS_SCHEDULES_PKG dependencies on FND_API

Line 35: MN NUMBER := FND_API.G_MISS_NUM;

31: p_last_update_date IN cn_seas_schedules.last_update_date%TYPE := NULL,
32: p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
33: p_OBJECT_VERSION_NUMBER IN cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
37: MD DATE := FND_API.G_MISS_DATE;
38:
39: BEGIN

Line 36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

32: p_last_updated_by IN cn_seas_schedules.last_updated_by%TYPE := NULL,
33: p_OBJECT_VERSION_NUMBER IN cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
37: MD DATE := FND_API.G_MISS_DATE;
38:
39: BEGIN
40: INSERT INTO cn_seas_schedules(

Line 37: MD DATE := FND_API.G_MISS_DATE;

33: p_OBJECT_VERSION_NUMBER IN cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE := NULL)
34: IS
35: MN NUMBER := FND_API.G_MISS_NUM;
36: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
37: MD DATE := FND_API.G_MISS_DATE;
38:
39: BEGIN
40: INSERT INTO cn_seas_schedules(
41: SEAS_SCHEDULE_ID,

Line 140: MN NUMBER := FND_API.G_MISS_NUM;

136: WHERE SEAS_SCHEDULE_ID = P_SEAS_SCHEDULE_ID;
137:
138: l_old_rec l_old_csr%ROWTYPE;
139:
140: MN NUMBER := FND_API.G_MISS_NUM;
141: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
142: MD DATE := FND_API.G_MISS_DATE;
143:
144: l_object_version_number NUMBER;

Line 141: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

137:
138: l_old_rec l_old_csr%ROWTYPE;
139:
140: MN NUMBER := FND_API.G_MISS_NUM;
141: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
142: MD DATE := FND_API.G_MISS_DATE;
143:
144: l_object_version_number NUMBER;
145:

Line 142: MD DATE := FND_API.G_MISS_DATE;

138: l_old_rec l_old_csr%ROWTYPE;
139:
140: MN NUMBER := FND_API.G_MISS_NUM;
141: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
142: MD DATE := FND_API.G_MISS_DATE;
143:
144: l_object_version_number NUMBER;
145:
146: BEGIN

Line 160: raise fnd_api.g_exc_error;

156: -- check object version number
157: IF l_object_version_number <> l_old_rec.object_version_number THEN
158: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
159: fnd_msg_pub.add;
160: raise fnd_api.g_exc_error;
161: END IF;
162:
163: UPDATE cn_seas_schedules SET
164: (name,