DBA Data[Home] [Help]

APPS.BSC_SCORECARD_PVT dependencies on BSC_TAB_CSF_B

Line 156: g_db_object := 'BSC_TAB_CSF_B';

152:
153: END LOOP;
154: CLOSE c_language;
155:
156: g_db_object := 'BSC_TAB_CSF_B';
157:
158: INSERT INTO BSC_TAB_CSF_B( TAB_ID
159: ,CSF_ID
160: ,CSF_TYPE

Line 158: INSERT INTO BSC_TAB_CSF_B( TAB_ID

154: CLOSE c_language;
155:
156: g_db_object := 'BSC_TAB_CSF_B';
157:
158: INSERT INTO BSC_TAB_CSF_B( TAB_ID
159: ,CSF_ID
160: ,CSF_TYPE
161: ,INTERMEDIATE_FLAG)
162: VALUES( p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id

Line 301: ,BSC_TAB_CSF_B C

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

Line 502: update BSC_TAB_CSF_B

498: ,SOURCE_LANG = userenv('LANG')
499: where tab_id = l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
500: and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
501:
502: update BSC_TAB_CSF_B
503: set csf_id = l_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
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;

Line 718: DELETE FROM BSC_TAB_CSF_B

714:
715: DELETE FROM BSC_TAB_IND_GROUPS_TL
716: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
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;