APPS.AMS_GEO_AREAS_PVT dependencies on AMS_ACT_GEO_AREAS

Line 40: SELECT AMS_ACT_GEO_AREAS_S.NEXTVAL

36: l_geo_area_rec geo_area_rec_type := p_geo_area_rec;
37: l_geo_area_count NUMBER;
38:
39: CURSOR c_geo_area_seq IS
40: SELECT AMS_ACT_GEO_AREAS_S.NEXTVAL
41: FROM DUAL;
42:
43: CURSOR c_geo_area_count(geo_area_id IN NUMBER) IS
44: SELECT COUNT(*)

Line 45: FROM AMS_ACT_GEO_AREAS

41: FROM DUAL;
42:
43: CURSOR c_geo_area_count(geo_area_id IN NUMBER) IS
44: SELECT COUNT(*)
45: FROM AMS_ACT_GEO_AREAS
46: WHERE activity_geo_area_id = geo_area_id;
47:
48: BEGIN
49: -- initialize

Line 122: INSERT INTO AMS_ACT_GEO_AREAS

118: EXIT WHEN l_geo_area_count = 0;
119: END LOOP;
120: END IF;
121:
122: INSERT INTO AMS_ACT_GEO_AREAS
123: (
124: activity_geo_area_id,
125: last_update_date,
126: last_updated_by,

Line 358: UPDATE AMS_ACT_GEO_AREAS SET

354:
355: AMS_Utility_PVT.debug_message(l_full_name||': update');
356: END IF;
357:
358: UPDATE AMS_ACT_GEO_AREAS SET
359: last_update_date = SYSDATE,
360: last_updated_by = FND_GLOBAL.user_id,
361: last_update_login = FND_GLOBAL.conc_login_id,
362: object_version_number = l_geo_area_rec.object_version_number + 1,

Line 482: FROM ams_act_geo_areas

478: l_dummy NUMBER;
479:
480: CURSOR c_used_by IS
481: SELECT act_geo_area_used_by_id, arc_act_geo_area_used_by
482: FROM ams_act_geo_areas
483: WHERE activity_geo_area_id = p_geo_area_id;
484:
485: CURSOR c_geo IS
486: SELECT 1

Line 487: FROM ams_act_geo_areas

483: WHERE activity_geo_area_id = p_geo_area_id;
484:
485: CURSOR c_geo IS
486: SELECT 1
487: FROM ams_act_geo_areas
488: WHERE act_geo_area_used_by_id = l_used_by_id
489: AND arc_act_geo_area_used_by = l_used_by;
490:
491: BEGIN

Line 530: DELETE FROM AMS_ACT_GEO_AREAS

526:
527: AMS_Utility_PVT.debug_message(l_full_name || ': delete');
528: END IF;
529:
530: DELETE FROM AMS_ACT_GEO_AREAS
531: WHERE activity_geo_area_id = p_geo_area_id
532: AND object_version_number = p_object_version;
533:
534: IF (SQL%NOTFOUND) THEN

Line 661: FROM AMS_ACT_GEO_AREAS

657: l_geo_area_id NUMBER;
658:
659: CURSOR c_geo_area IS
660: SELECT activity_geo_area_id
661: FROM AMS_ACT_GEO_AREAS
662: WHERE activity_geo_area_id = p_geo_area_id
663: AND object_version_number = p_object_version
664: FOR UPDATE OF activity_geo_area_id NOWAIT;
665:

Line 1095: 'AMS_ACT_GEO_AREAS',

1091: AND p_geo_area_rec.activity_geo_area_id IS NOT NULL
1092: THEN
1093: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1094: (
1095: 'AMS_ACT_GEO_AREAS',
1096: 'activity_geo_area_id = ' || p_geo_area_rec.activity_geo_area_id
1097: );
1098: END IF;
1099:

Line 1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');

1098: END IF;
1099:
1100: IF l_uk_flag = FND_API.g_false THEN
1101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1102: FND_MESSAGE.set_name('AMS', 'AMS_ACT_GEO_AREAS_DUP_ID');
1103: FND_MSG_PUB.add;
1104: END IF;
1105:
1106: x_return_status := FND_API.g_ret_sts_error;

Line 1115: 'AMS_ACT_GEO_AREAS',

1111: IF p_geo_area_rec.activity_geo_area_id IS NOT NULL THEN -- UPDATE RECORD
1112:
1113: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1114: (
1115: 'AMS_ACT_GEO_AREAS',
1116: 'activity_geo_area_id <> ' || p_geo_area_rec.activity_geo_area_id
1117: || ' AND geo_hierarchy_id = ' || p_geo_area_rec.geo_hierarchy_id
1118: || ' AND act_geo_area_used_by_id = ' || p_geo_area_rec.act_geo_area_used_by_id
1119: || ' AND arc_act_geo_area_used_by = ''' || p_geo_area_rec.arc_act_geo_area_used_by || ''''

Line 1124: 'AMS_ACT_GEO_AREAS',

1120: );
1121: ELSE -- NEW RECORD
1122: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1123: (
1124: 'AMS_ACT_GEO_AREAS',
1125: 'act_geo_area_used_by_id = ' || p_geo_area_rec.act_geo_area_used_by_id
1126: || ' AND geo_hierarchy_id = ' || p_geo_area_rec.geo_hierarchy_id
1127: || ' AND arc_act_geo_area_used_by = ''' || p_geo_area_rec.arc_act_geo_area_used_by || ''''
1128: );

Line 1273: SELECT * FROM AMS_ACT_GEO_AREAS

1269: )
1270: IS
1271:
1272: CURSOR c_geo_area IS
1273: SELECT * FROM AMS_ACT_GEO_AREAS
1274: WHERE activity_geo_area_id = p_geo_area_rec.activity_geo_area_id;
1275:
1276: l_geo_area_rec c_geo_area%ROWTYPE;
1277: