APPS.CN_SEASONALITIES_PKG dependencies on FND_API

Line 33: MN NUMBER := FND_API.G_MISS_NUM;

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

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

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

Line 35: MD DATE := FND_API.G_MISS_DATE;

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

Line 135: MN NUMBER := FND_API.G_MISS_NUM;

131: WHERE SEASONALITY_ID = P_SEASONALITY_ID AND SEAS_SCHEDULE_ID = P_SEAS_SCHEDULE_ID ;
132:
133: l_old_rec l_old_csr%ROWTYPE;
134:
135: MN NUMBER := FND_API.G_MISS_NUM;
136: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
137: MD DATE := FND_API.G_MISS_DATE;
138:
139: l_object_version_number NUMBER;

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

132:
133: l_old_rec l_old_csr%ROWTYPE;
134:
135: MN NUMBER := FND_API.G_MISS_NUM;
136: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
137: MD DATE := FND_API.G_MISS_DATE;
138:
139: l_object_version_number NUMBER;
140:

Line 137: MD DATE := FND_API.G_MISS_DATE;

133: l_old_rec l_old_csr%ROWTYPE;
134:
135: MN NUMBER := FND_API.G_MISS_NUM;
136: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
137: MD DATE := FND_API.G_MISS_DATE;
138:
139: l_object_version_number NUMBER;
140:
141: BEGIN

Line 155: raise fnd_api.g_exc_error;

151: -- check object version number
152: IF l_object_version_number <> l_old_rec.object_version_number THEN
153: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
154: fnd_msg_pub.add;
155: raise fnd_api.g_exc_error;
156: END IF;
157:
158: UPDATE cn_seasonalities SET
159: (PCT_SEASONALITY,