APPS.CN_SF_PARAMS_PKG dependencies on FND_API

Line 39: MN NUMBER := FND_API.G_MISS_NUM;

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

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

36: p_last_updated_by IN cn_sf_repositories.last_updated_by%TYPE := NULL,
37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS
39: MN NUMBER := FND_API.G_MISS_NUM;
40: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
41: MD DATE := FND_API.G_MISS_DATE;
42:
43: BEGIN
44:

Line 41: MD DATE := FND_API.G_MISS_DATE;

37: p_OBJECT_VERSION_NUMBER IN cn_sf_repositories.OBJECT_VERSION_NUMBER%TYPE := NULL)
38: IS
39: MN NUMBER := FND_API.G_MISS_NUM;
40: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
41: MD DATE := FND_API.G_MISS_DATE;
42:
43: BEGIN
44:
45: --DBMS_OUTPUT.PUT_LINE('Begin : I have just ran the insert_row.');

Line 168: MN NUMBER := FND_API.G_MISS_NUM;

164: WHERE REPOSITORY_ID = P_REPOSITORY_ID;
165:
166: l_old_rec l_old_csr%ROWTYPE;
167:
168: MN NUMBER := FND_API.G_MISS_NUM;
169: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
170: MD DATE := FND_API.G_MISS_DATE;
171:
172: l_object_version_number NUMBER;

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

165:
166: l_old_rec l_old_csr%ROWTYPE;
167:
168: MN NUMBER := FND_API.G_MISS_NUM;
169: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
170: MD DATE := FND_API.G_MISS_DATE;
171:
172: l_object_version_number NUMBER;
173: l_num NUMBER ;

Line 170: MD DATE := FND_API.G_MISS_DATE;

166: l_old_rec l_old_csr%ROWTYPE;
167:
168: MN NUMBER := FND_API.G_MISS_NUM;
169: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;
170: MD DATE := FND_API.G_MISS_DATE;
171:
172: l_object_version_number NUMBER;
173: l_num NUMBER ;
174:

Line 192: raise fnd_api.g_exc_error;

188: -- check object version number
189: IF l_object_version_number <> l_old_rec.object_version_number THEN
190: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
191: fnd_msg_pub.add;
192: raise fnd_api.g_exc_error;
193: END IF;
194:
195: --DBMS_OUTPUT.PUT_LINE(' Table Handlers update : Started. ID : ');
196: --DBMS_OUTPUT.PUT_LINE('Old Num : ' || l_num || ' ID in procedure : ' || p_repository_id);