21: | History: |
22: | 13-JAN-2003 ASHANKAR Bug Fix #2742973 Runtime Error "3021" when clicking on |
23: | the next button in VB-Builder. |
24: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
25: | 1. Modified Update Query for BSC_TABS_TL, BSC_TAB_CSF_TL |
26: | 30-APR-2003 PWALI Bug #2926199 |
27: | 1. Modified Retrieve_Tab(), to change the Query filter |
28: | 13-MAY-2003 PWALI Bug #2942895, SQL BIND COMPLIANCE |
29: | 18-MAY-04 adrao Modified PL/SQL records and CRUD to accept SHORT_NAME |
125: ,p_Bsc_Tab_Entity_Rec.Bsc_Owner_Id
126: ,p_Bsc_Tab_Entity_Rec.Bsc_Short_Name);
127:
128:
129: g_db_object := 'BSC_TABS_TL';
130:
131: IF (c_language%ISOPEN) THEN
132: CLOSE c_language;
133: END IF;
136: LOOP
137: FETCH c_language INTO l_language;
138: EXIT WHEN c_language%NOTFOUND;
139:
140: INSERT INTO BSC_TABS_TL( TAB_ID
141: ,LANGUAGE
142: ,SOURCE_LANG
143: ,NAME
144: ,HELP
296: ,x_Bsc_Tab_Entity_Rec.Bsc_Csf_Type
297: ,x_Bsc_Tab_Entity_Rec.Bsc_Intermediate_Flag
298: ,x_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
299: FROM BSC_TABS_B A
300: ,BSC_TABS_TL B
301: ,BSC_TAB_CSF_B C
302: ,BSC_TAB_CSF_TL D
303: WHERE A.TAB_ID = B.TAB_ID
304: AND A.TAB_ID = C.TAB_ID
490: ,parent_tab_id = l_Bsc_Tab_Entity_Rec.Bsc_Parent_Tab_Id
491: ,owner_id = l_Bsc_Tab_Entity_Rec.Bsc_Owner_Id
492: where tab_id = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
493:
494: update BSC_TABS_TL
495: set name = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name
496: ,help = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Help
497: ,ADDITIONAL_INFO = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Info
498: ,SOURCE_LANG = userenv('LANG')
705: -- delete pertinent values from pertinent tables.
706: DELETE FROM BSC_TABS_B
707: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
708:
709: DELETE FROM BSC_TABS_TL
710: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
711:
712: DELETE FROM BSC_TAB_IND_GROUPS_B
713: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
1236: begin
1237:
1238: select count(*)
1239: into l_count
1240: from BSC_TABS_TL
1241: where upper(name) = upper(p_Tab_Name);
1242:
1243: return l_count;
1244: