APPS.BIS_REGION_EXTENSION_PVT dependencies on FND_API

Line 16: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

12: -- 02/03/04 nbarik Initial Creation --
13: ----------------------------------------------------------------------------
14:
15: PROCEDURE CREATE_REGION_EXTN_RECORD
16: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
17: ,pRegionCode IN VARCHAR2
18: ,pRegionAppId IN NUMBER
19: ,pAttribute16 IN VARCHAR2 DEFAULT NULL
20: ,pAttribute17 IN VARCHAR2 DEFAULT NULL

Line 117: IF (p_commit = FND_API.G_TRUE) THEN

113: ,l_user_id
114: ,SYSDATE
115: ,l_user_id
116: );
117: IF (p_commit = FND_API.G_TRUE) THEN
118: COMMIT;
119: END IF;
120:
121: EXCEPTION

Line 128: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

124: END;
125: END CREATE_REGION_EXTN_RECORD;
126:
127: PROCEDURE UPDATE_REGION_EXTN_RECORD
128: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
129: ,pRegionCode IN VARCHAR2
130: ,pRegionAppId IN NUMBER
131: ,pAttribute16 IN VARCHAR2 DEFAULT NULL
132: ,pAttribute17 IN VARCHAR2 DEFAULT NULL

Line 197: IF (p_commit = FND_API.G_TRUE) THEN

193: ,last_update_date = SYSDATE
194: ,last_update_login = l_user_id
195: WHERE region_code = pRegionCode AND region_application_id = pRegionAppId;
196:
197: IF (p_commit = FND_API.G_TRUE) THEN
198: COMMIT;
199: END IF;
200:
201: EXCEPTION

Line 208: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

204: END;
205: END UPDATE_REGION_EXTN_RECORD;
206:
207: PROCEDURE DELETE_REGION_EXTN_RECORD
208: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
209: ,pRegionCode IN VARCHAR2
210: ,pRegionAppId IN NUMBER
211: ) IS
212: BEGIN

Line 216: IF (p_commit = FND_API.G_TRUE) THEN

212: BEGIN
213: DELETE FROM bis_ak_region_extension
214: WHERE region_code = pRegionCode AND region_application_id = pRegionAppId;
215:
216: IF (p_commit = FND_API.G_TRUE) THEN
217: COMMIT;
218: END IF;
219: END DELETE_REGION_EXTN_RECORD;
220: