588: l_Tab_Short_Name := NULL;
589: END;
590:
591: -- added for Bug#4563456
592: l_Responsibility_Key := BSC_UTILITY.Get_Responsibility_Key;
593:
594: IF UPPER(l_Responsibility_Key) = 'BSC_DESIGNER' OR upper(l_Responsibility_Key) = 'BSC_MANAGER' OR l_Tab_Short_Name IS NOT NULL THEN
595: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
596: bsc_utility.c_BSC_Manager ||','||
592: l_Responsibility_Key := BSC_UTILITY.Get_Responsibility_Key;
593:
594: IF UPPER(l_Responsibility_Key) = 'BSC_DESIGNER' OR upper(l_Responsibility_Key) = 'BSC_MANAGER' OR l_Tab_Short_Name IS NOT NULL THEN
595: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
596: bsc_utility.c_BSC_Manager ||','||
597: bsc_utility.c_BSC_DESIGNER ||','||
598: bsc_utility.c_BSC_PMD_USER ||','||
599: bsc_utility.c_BIS_BID_RESP ||','||
600: bsc_utility.c_BIS_DBI_ADMIN||','||
593:
594: IF UPPER(l_Responsibility_Key) = 'BSC_DESIGNER' OR upper(l_Responsibility_Key) = 'BSC_MANAGER' OR l_Tab_Short_Name IS NOT NULL THEN
595: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
596: bsc_utility.c_BSC_Manager ||','||
597: bsc_utility.c_BSC_DESIGNER ||','||
598: bsc_utility.c_BSC_PMD_USER ||','||
599: bsc_utility.c_BIS_BID_RESP ||','||
600: bsc_utility.c_BIS_DBI_ADMIN||','||
601: l_Responsibility_Key;
594: IF UPPER(l_Responsibility_Key) = 'BSC_DESIGNER' OR upper(l_Responsibility_Key) = 'BSC_MANAGER' OR l_Tab_Short_Name IS NOT NULL THEN
595: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
596: bsc_utility.c_BSC_Manager ||','||
597: bsc_utility.c_BSC_DESIGNER ||','||
598: bsc_utility.c_BSC_PMD_USER ||','||
599: bsc_utility.c_BIS_BID_RESP ||','||
600: bsc_utility.c_BIS_DBI_ADMIN||','||
601: l_Responsibility_Key;
602: ELSE
595: l_Comma_Sep_Resp_Key := l_Comma_Sep_Resp_Key ||','||
596: bsc_utility.c_BSC_Manager ||','||
597: bsc_utility.c_BSC_DESIGNER ||','||
598: bsc_utility.c_BSC_PMD_USER ||','||
599: bsc_utility.c_BIS_BID_RESP ||','||
600: bsc_utility.c_BIS_DBI_ADMIN||','||
601: l_Responsibility_Key;
602: ELSE
603: l_Comma_Sep_Resp_Key := l_Responsibility_Key;
596: bsc_utility.c_BSC_Manager ||','||
597: bsc_utility.c_BSC_DESIGNER ||','||
598: bsc_utility.c_BSC_PMD_USER ||','||
599: bsc_utility.c_BIS_BID_RESP ||','||
600: bsc_utility.c_BIS_DBI_ADMIN||','||
601: l_Responsibility_Key;
602: ELSE
603: l_Comma_Sep_Resp_Key := l_Responsibility_Key;
604: END IF;