DBA Data[Home] [Help]

APPS.BSC_UTILITY dependencies on FND_GLOBAL

Line 2684: WHERE F.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID

2680: l_Resp_Key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
2681: BEGIN
2682: SELECT F.RESPONSIBILITY_KEY INTO l_Resp_Key
2683: FROM FND_RESPONSIBILITY F
2684: WHERE F.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
2685: AND F.APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
2686:
2687: RETURN l_Resp_Key;
2688:

Line 2685: AND F.APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;

2681: BEGIN
2682: SELECT F.RESPONSIBILITY_KEY INTO l_Resp_Key
2683: FROM FND_RESPONSIBILITY F
2684: WHERE F.RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
2685: AND F.APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
2686:
2687: RETURN l_Resp_Key;
2688:
2689: EXCEPTION

Line 3001: l_Temp_String1 := UPPER(Remove_Repeating_Comma(TRANSLATE(cPPS.TEXT, ',.() +-*/;'||fnd_global.local_chr(10)||fnd_global.local_chr(9) ,',,,,,,,,,,,,')));

2997: l_Package_Name := UPPER(SUBSTR(p_Report_Function, 1, INSTR(p_Report_Function, '.')-1));
2998: l_Function_Name := UPPER(SUBSTR(p_Report_Function, INSTR(p_Report_Function, '.')+1));
2999:
3000: FOR cPPS IN c_Parse_Package_Spec LOOP
3001: l_Temp_String1 := UPPER(Remove_Repeating_Comma(TRANSLATE(cPPS.TEXT, ',.() +-*/;'||fnd_global.local_chr(10)||fnd_global.local_chr(9) ,',,,,,,,,,,,,')));
3002: --DBMS_OUTPUT.PUT_LINE (' l_Temp_String1 - ' || l_Temp_String1);
3003: l_Package_Specification := Remove_Repeating_Comma(l_Package_Specification ||','||l_Temp_String1);
3004: END LOOP;
3005: