APPS.CS_TP_CHOICES_PVT dependencies on CS_TP_CHOICES_VL

Line 29: select max(SEQUENCE_NUMBER) from CS_TP_CHOICES_VL;

25: l_lookup_count NUMBER;
26: l_choice_id NUMBER;
27: l_ROWID VARCHAR2(30);
28: Cursor C is
29: select max(SEQUENCE_NUMBER) from CS_TP_CHOICES_VL;
30: l_current_date DATE :=FND_API.G_MISS_DATE;
31: l_created_by NUMBER :=FND_API.G_MISS_NUM;
32: l_login NUMBER :=FND_API.G_MISS_NUM;
33: l_max_sequence NUMBER;

Line 209: select last_update_date, LOOKUP_ID, SCORE, VALUE from CS_TP_CHOICES_VL where choice_ID = V_Choice_ID;

205: l_lookup_id NUMBER;
206: l_score NUMBER;
207: l_value VARCHAR2(500);
208: Cursor last_updateC (V_Choice_ID Number) is
209: select last_update_date, LOOKUP_ID, SCORE, VALUE from CS_TP_CHOICES_VL where choice_ID = V_Choice_ID;
210: l_last_update_date DATE;
211: begin
212: -- Initialize message list if p_init_msg_list is set to TRUE.
213: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 324: l_statement := 'SELECT CHOICE_ID, VALUE, LOOKUP_ID, SCORE, LAST_UPDATE_DATE, DEFAULT_CHOICE_FLAG from CS_TP_CHOICES_VL where LOOKUP_ID = : v_lookup_id';

320:
321: -- Start API Body
322:
323: -- Construct query statement, open cursor, execute query statement, retrieve results
324: l_statement := 'SELECT CHOICE_ID, VALUE, LOOKUP_ID, SCORE, LAST_UPDATE_DATE, DEFAULT_CHOICE_FLAG from CS_TP_CHOICES_VL where LOOKUP_ID = : v_lookup_id';
325:
326: if (P_Display_Order is NULL OR P_Display_Order=FND_API.G_MISS_CHAR OR length(P_Display_Order)<=0 OR P_Display_Order =NORMAL) then
327: l_statement := l_statement || ' ORDER BY SEQUENCE_NUMBER ';
328:

Line 421: select last_update_date,sequence_number,value from CS_TP_CHOICES_VL

417: l_api_name CONSTANT VARCHAR2(30) := 'Update_Choices';
418: l_api_version CONSTANT NUMBER := 1.0;
419:
420: Cursor last_updateC (V_Choice_ID Number) is
421: select last_update_date,sequence_number,value from CS_TP_CHOICES_VL
422: where choice_ID = V_Choice_ID;
423: l_last_update_date DATE;
424: l_sequence_number NUMBER;
425: l_value VARCHAR2(240);