APPS.AMS_LISTENTRY_PVT dependencies on AMS_LIST_ENTRIES

Line 201: FROM Ams_List_Entries

197: )
198: IS
199: --Check if The Pin Code is Unique across all lists.
200: Cursor C_Is_Pin_Unique IS SELECT Count(*)
201: FROM Ams_List_Entries
202: WHERE Pin_Code = p_entry_rec.pin_code
203: AND List_Entry_Id <> p_entry_rec.List_Entry_Id;
204:
205: l_pin_count number;

Line 209: FROM Ams_List_Entries

205: l_pin_count number;
206:
207: --Check if The List Entry System ID and type is Unique for this list.
208: Cursor C_Is_SysID_Unique IS SELECT COUNT(*)
209: FROM Ams_List_Entries
210: WHERE List_Header_Id = p_entry_rec.list_header_id
211: AND List_Entry_Source_System_id = p_entry_rec.List_Entry_Source_System_ID
212: AND List_Entry_Source_System_Type = p_entry_rec.List_Entry_Source_System_Type
213: AND List_Entry_Id <> p_entry_rec.List_Entry_Id;

Line 800: SELECT ams_list_entries_s.NEXTVAL

796: l_arc_list_used_by VARCHAR2(30);
797:
798:
799: CURSOR c_entry_seq IS
800: SELECT ams_list_entries_s.NEXTVAL
801: FROM DUAL;
802:
803: CURSOR c_entry_count(entry_id IN NUMBER) IS
804: SELECT COUNT(*)

Line 805: FROM ams_list_entries

801: FROM DUAL;
802:
803: CURSOR c_entry_count(entry_id IN NUMBER) IS
804: SELECT COUNT(*)
805: FROM ams_list_entries
806: WHERE list_entry_id = entry_id;
807:
808:
809: l_created_by NUMBER; --batoleti added this var. For bug# 6688996

Line 911: INSERT INTO ams_list_entries

907: CLOSE cur_get_created_by;
908:
909: -- batoleti coding ends for bug# 6688996
910:
911: INSERT INTO ams_list_entries
912: (list_entry_id
913:
914: ,last_update_date
915: ,last_updated_by

Line 1830: update ams_list_entries

1826: RAISE FND_API.g_exc_error;
1827: END IF;
1828: END IF;
1829:
1830: update ams_list_entries
1831: set
1832: last_update_date = sysdate
1833: ,last_updated_by = FND_GLOBAL.User_Id
1834: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 2347: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT - DELETE FROM ams_list_entries', TRUE);

2343:
2344:
2345: IF (AMS_DEBUG_LOW_ON) THEN
2346: FND_MESSAGE.set_name('AMS', 'API_DEBUG_MESSAGE');
2347: FND_MESSAGE.Set_Token('ROW', 'AMS_List_Entry_PVT - DELETE FROM ams_list_entries', TRUE);
2348: FND_MSG_PUB.Add;
2349: END IF;
2350:
2351:

Line 2354: FROM ams_list_entries

2350:
2351:
2352: -- Delete header data
2353: DELETE
2354: FROM ams_list_entries
2355: WHERE list_entry_id = p_entry_id
2356: AND object_version_number = p_object_version_number;
2357:
2358: if (SQL%NOTFOUND) then

Line 2485: FROM ams_list_entries

2481: l_entry_id NUMBER;
2482:
2483: CURSOR c_entry IS
2484: SELECT list_entry_id
2485: FROM ams_list_entries
2486: WHERE list_entry_id = p_entry_id
2487: AND object_version_number = p_object_version
2488: FOR UPDATE OF list_entry_id NOWAIT;
2489:

Line 3116: FROM ams_list_entries

3112: IS
3113:
3114: CURSOR c_entry IS
3115: SELECT *
3116: FROM ams_list_entries
3117: WHERE list_entry_id = p_entry_rec.list_entry_id;
3118:
3119: l_entry_rec c_entry%ROWTYPE;
3120:

Line 4729: from ams_list_entries

4725: From ams_list_headers_all
4726: where list_header_id = p_list_id;
4727:
4728: Cursor C_Current_Code IS select max(Source_Code)
4729: from ams_list_entries
4730: where list_header_id = p_list_id;
4731:
4732: l_current_code varchar(30);
4733:

Line 4810: update ams_list_entries

4806:
4807: --found a valid source code
4808: if(l_return_status = FND_API.G_TRUE)then
4809: if(l_current_code <> l_source_code)then
4810: update ams_list_entries
4811: set source_code = l_source_code,
4812: arc_list_used_by_source = l_arc_list_used_by,
4813: source_code_for_id = l_list_used_by_id
4814: where list_header_id = p_list_id;