APPS.AMS_USER_STATUSES_PVT dependencies on AMS_USER_STATUSES_VL

Line 8: -- AMS_USER_STATUSES_VL:

4: -- PACKAGE
5: -- AMS_USER_STATUSES_PVT
6: --
7: -- PROCEDURES
8: -- AMS_USER_STATUSES_VL:
9: -- Check_User_Status_Req_Items
10: -- Check_User_Status_UK_Items
11: -- Check_User_Status_FK_Items
12: -- Check_User_Status_Lookup_Items

Line 102: FROM ams_user_statuses_vl

98: CURSOR c_id_exists (x_id IN NUMBER) IS
99: SELECT 1
100: FROM dual
101: WHERE EXISTS (SELECT 1
102: FROM ams_user_statuses_vl
103: WHERE user_status_id = x_id);
104: BEGIN
105: --------------------- initialize -----------------------
106: SAVEPOINT Create_User_Status;

Line 512: FROM ams_user_statuses_vl

508: )
509: IS
510: CURSOR c_user_status IS
511: SELECT *
512: FROM ams_user_statuses_vl
513: WHERE user_status_id = p_user_status_id;
514: --
515: -- This is the only exception for using %ROWTYPE.
516: -- We are selecting from the VL view, which may

Line 661: FROM ams_user_statuses_vl

657: -- and perform comparison in the body and raise the
658: -- exception there.
659: CURSOR c_lock IS
660: SELECT object_version_number
661: FROM ams_user_statuses_vl
662: WHERE user_status_id = p_user_status_id
663: AND object_version_number = p_object_version
664: FOR UPDATE NOWAIT;
665: BEGIN

Line 1021: FROM ams_user_statuses_vl

1017: )
1018: IS
1019: CURSOR c_user_status IS
1020: SELECT *
1021: FROM ams_user_statuses_vl
1022: WHERE user_status_id = p_user_status_rec.user_status_id;
1023: --
1024: -- This is the only exception for using %ROWTYPE.
1025: -- We are selecting from the VL view, which may

Line 1114: from ams_user_statuses_vl

1110: if l_user_status_rec.end_Date_active is NOT NULL then
1111:
1112: BEGIN
1113: select 1 into l_count
1114: from ams_user_statuses_vl
1115: where user_status_id = l_user_status_rec.user_status_id
1116: and name = l_user_status_rec.name
1117: and start_date_active = l_user_status_rec.start_date_active
1118: and end_date_active = l_user_status_rec.end_Date_active

Line 1129: from ams_user_statuses_vl

1125: END;
1126: else -- for end date
1127: BEGIN
1128: select 1 into l_count
1129: from ams_user_statuses_vl
1130: where user_status_id = l_user_status_rec.user_status_id
1131: and name = l_user_status_rec.name
1132: and start_date_active = l_user_status_rec.start_date_active
1133: and system_status_type = l_user_status_rec.system_status_type

Line 1144: from ams_user_statuses_vl

1140: end if; -- for end date
1141: else
1142: BEGIN
1143: select 1 into l_count
1144: from ams_user_statuses_vl
1145: where user_status_id = l_user_status_rec.user_status_id
1146: and name = l_user_status_rec.name
1147: and system_status_type = l_user_status_rec.system_status_type
1148: and system_status_code = l_user_status_rec.system_status_code

Line 1180: from ams_user_statuses_vl

1176:
1177: BEGIN
1178: BEGIN
1179: select 1 into l_count
1180: from ams_user_statuses_vl
1181: where user_status_id = l_user_status_rec.user_status_id
1182: and enabled_flag = l_user_status_rec.enabled_flag
1183: and default_flag = l_user_status_rec.default_flag
1184: and seeded_flag = 'Y';

Line 1264: 'ams_user_statuses_vl',

1260: IF p_validation_mode = JTF_PLSQL_API.g_create
1261: AND p_user_status_rec.user_status_id IS NOT NULL
1262: THEN
1263: IF AMS_Utility_PVT.check_uniqueness(
1264: 'ams_user_statuses_vl',
1265: 'user_status_id = ' || p_user_status_rec.user_status_id
1266: ) = FND_API.g_false
1267: THEN
1268: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1280: 'ams_user_statuses_vl',

1276: -- check if NAME is UNIQUE
1277: -- modified sugupta 02/22/2000 UNIQUENESS OF NAME LIMITED TO THAT ACTIVITY TYPE
1278: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1279: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1280: 'ams_user_statuses_vl',
1281: 'name = ''' || p_user_status_rec.name ||
1282: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type || ''''
1283: );
1284: ELSE

Line 1286: 'ams_user_statuses_vl',

1282: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type || ''''
1283: );
1284: ELSE
1285: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1286: 'ams_user_statuses_vl',
1287: 'name = ''' || p_user_status_rec.name ||
1288: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type ||
1289: ''' AND user_status_id <> ' || p_user_status_rec.user_status_id
1290: );