APPS.BIS_REGION_EXTENSION_PVT dependencies on BIS_AK_REGION_EXTENSION

Line 7: -- BIS_AK_REGION_EXTENSION table --

3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_REGION_EXTENSION_PVT --
5: -- --
6: -- DESCRIPTION: Private package to create records in --
7: -- BIS_AK_REGION_EXTENSION table --
8: -- --
9: -- --
10: -- MODIFICATIONS --
11: -- Date User Modification --

Line 50: INSERT INTO bis_ak_region_extension

46: l_user_id NUMBER;
47: BEGIN
48: l_user_id := fnd_global.user_id;
49: BEGIN
50: INSERT INTO bis_ak_region_extension
51: ( REGION_CODE,
52: REGION_APPLICATION_ID,
53: ATTRIBUTE16,
54: ATTRIBUTE17,

Line 163: UPDATE bis_ak_region_extension

159: BEGIN
160:
161: l_user_id := fnd_global.user_id;
162: BEGIN
163: UPDATE bis_ak_region_extension
164: SET
165: attribute16 = pAttribute16
166: ,attribute17 = pAttribute17
167: ,attribute18 = pAttribute18

Line 213: DELETE FROM bis_ak_region_extension

209: ,pRegionCode IN VARCHAR2
210: ,pRegionAppId IN NUMBER
211: ) IS
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;