APPS.CN_SRP_TOTAL_COMPS_PKG dependencies on FND_API

Line 35: MN NUMBER := FND_API.G_MISS_NUM;

31: p_last_update_login IN cn_srp_total_comps.last_update_login%TYPE := NULL,
32: p_last_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%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_update_date IN cn_srp_total_comps.last_update_date%TYPE := NULL,
33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%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_srp_total_comps(

Line 37: MD DATE := FND_API.G_MISS_DATE;

33: p_last_updated_by IN cn_srp_total_comps.last_updated_by%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_srp_total_comps(
41: SRP_TOTAL_COMP_ID,

Line 144: MN NUMBER := FND_API.G_MISS_NUM;

140: WHERE srp_role_id = p_srp_role_id;
141:
142: l_old_rec l_old_csr%ROWTYPE;
143:
144: MN NUMBER := FND_API.G_MISS_NUM;
145: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
146: MD DATE := FND_API.G_MISS_DATE;
147:
148: l_object_version_number NUMBER;

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

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

Line 146: MD DATE := FND_API.G_MISS_DATE;

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

Line 165: raise fnd_api.g_exc_error;

161: -- check object version number
162: IF l_object_version_number <> l_old_rec.object_version_number THEN
163: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
164: fnd_msg_pub.add;
165: raise fnd_api.g_exc_error;
166: END IF;
167:
168: UPDATE cn_srp_total_comps SET
169: (percent,