APPS.BSC_SCORECARD_PVT dependencies on BSC_TAB_CSF_TL

Line 25: | 1. Modified Update Query for BSC_TABS_TL, BSC_TAB_CSF_TL |

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 |

Line 167: g_db_object := 'BSC_TAB_CSF_TL';

163: ,p_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
164: ,p_Bsc_Tab_Entity_Rec.Bsc_Csf_Type
165: ,p_Bsc_Tab_Entity_Rec.Bsc_Intermediate_Flag);
166:
167: g_db_object := 'BSC_TAB_CSF_TL';
168:
169: IF (c_language%ISOPEN) THEN
170: CLOSE c_language;
171: END IF;

Line 178: INSERT INTO BSC_TAB_CSF_TL( TAB_ID

174: LOOP
175: FETCH c_language INTO l_language;
176: EXIT WHEN c_language%NOTFOUND;
177:
178: INSERT INTO BSC_TAB_CSF_TL( TAB_ID
179: ,CSF_ID
180: ,LANGUAGE
181: ,SOURCE_LANG
182: ,NAME

Line 302: ,BSC_TAB_CSF_TL D

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
305: AND C.TAB_ID = D.TAB_ID
306: AND A.TAB_ID = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id

Line 508: update BSC_TAB_CSF_TL

504: ,csf_type = l_Bsc_Tab_Entity_Rec.Bsc_Csf_Type
505: ,intermediate_flag = l_Bsc_Tab_Entity_Rec.Bsc_Intermediate_Flag
506: where tab_id = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
507:
508: update BSC_TAB_CSF_TL
509: set csf_id = l_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
510: ,name = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Name
511: ,help = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Help
512: ,SOURCE_LANG = userenv('LANG')

Line 721: DELETE FROM BSC_TAB_CSF_TL

717:
718: DELETE FROM BSC_TAB_CSF_B
719: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
720:
721: DELETE FROM BSC_TAB_CSF_TL
722: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
723:
724: DELETE FROM BSC_USER_TAB_ACCESS
725: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;