APPS.CN_SRP_PAYOUT_DTLS_PKG dependencies on FND_API

Line 36: MN NUMBER := FND_API.G_MISS_NUM;

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

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

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

Line 38: MD DATE := FND_API.G_MISS_DATE;

34: p_last_updated_by IN cn_srp_payout_dtls.last_updated_by%TYPE := NULL)
35: IS
36: MN NUMBER := FND_API.G_MISS_NUM;
37: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
38: MD DATE := FND_API.G_MISS_DATE;
39:
40: BEGIN
41:
42: INSERT INTO cn_srp_payout_dtls(

Line 150: MN NUMBER := FND_API.G_MISS_NUM;

146: WHERE srp_role_id = p_srp_role_id;
147:
148: l_old_rec l_old_csr%ROWTYPE;
149:
150: MN NUMBER := FND_API.G_MISS_NUM;
151: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
152: MD DATE := FND_API.G_MISS_DATE;
153:
154: l_object_version_number NUMBER;

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

147:
148: l_old_rec l_old_csr%ROWTYPE;
149:
150: MN NUMBER := FND_API.G_MISS_NUM;
151: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
152: MD DATE := FND_API.G_MISS_DATE;
153:
154: l_object_version_number NUMBER;
155:

Line 152: MD DATE := FND_API.G_MISS_DATE;

148: l_old_rec l_old_csr%ROWTYPE;
149:
150: MN NUMBER := FND_API.G_MISS_NUM;
151: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
152: MD DATE := FND_API.G_MISS_DATE;
153:
154: l_object_version_number NUMBER;
155:
156: BEGIN

Line 171: raise fnd_api.g_exc_error;

167: -- check object version number
168: IF l_object_version_number <> l_old_rec.object_version_number THEN
169: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
170: fnd_msg_pub.add;
171: raise fnd_api.g_exc_error;
172: END IF;
173:
174: UPDATE cn_srp_payout_dtls SET
175: (percent,