DBA Data[Home] [Help]

APPS.BIS_DIMENSION_LEVEL_PVT dependencies on FND_GLOBAL

Line 1189: l_Dimension_Level_Rec.Last_Update_Login := fnd_global.LOGIN_ID;

1185: IF (l_Dimension_Level_Rec.Last_Updated_By IS NULL) THEN
1186: l_Dimension_Level_Rec.Last_Updated_By := l_Dimension_Level_Rec.Created_By;
1187: END IF;
1188: IF (l_Dimension_Level_Rec.Last_Update_Login IS NULL) THEN
1189: l_Dimension_Level_Rec.Last_Update_Login := fnd_global.LOGIN_ID;
1190: END IF;
1191:
1192: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)
1193: = FND_API.G_TRUE)

Line 1595: l_login_id := fnd_global.LOGIN_ID;

1591: END IF;
1592: END IF;
1593:
1594: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1595: l_login_id := fnd_global.LOGIN_ID;
1596:
1597: ----------------
1598: --Adding this for the source column
1599: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)

Line 1769: l_login_id := fnd_global.LOGIN_ID;

1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767: --
1768: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1769: l_login_id := fnd_global.LOGIN_ID;
1770: --
1771: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1772: Update bis_levels_TL
1773: set

Line 2108: l_user_id := FND_GLOBAL.USER_ID;

2104:
2105: BEGIN
2106: SAVEPOINT TransDimObjByLangPvt;
2107:
2108: l_user_id := FND_GLOBAL.USER_ID;
2109:
2110: l_login_id := fnd_global.LOGIN_ID;
2111:
2112:

Line 2110: l_login_id := fnd_global.LOGIN_ID;

2106: SAVEPOINT TransDimObjByLangPvt;
2107:
2108: l_user_id := FND_GLOBAL.USER_ID;
2109:
2110: l_login_id := fnd_global.LOGIN_ID;
2111:
2112:
2113: SELECT LEVEL_ID
2114: INTO l_dim_level_id

Line 2168: AND (user_id = fnd_global.user_id

2164: ORG_ID,
2165: SITE_ID
2166: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2167: WHERE LEVEL_ID = p_dim_level_id
2168: AND (user_id = fnd_global.user_id
2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;

Line 2169: OR responsibility_id = fnd_global.RESP_ID

2165: SITE_ID
2166: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2167: WHERE LEVEL_ID = p_dim_level_id
2168: AND (user_id = fnd_global.user_id
2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;

Line 2170: OR application_id = fnd_global.RESP_APPL_ID

2166: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2167: WHERE LEVEL_ID = p_dim_level_id
2168: AND (user_id = fnd_global.user_id
2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;

Line 2171: OR org_id = fnd_global.ORG_ID

2167: WHERE LEVEL_ID = p_dim_level_id
2168: AND (user_id = fnd_global.user_id
2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;

Line 2229: AND (user_id = fnd_global.user_id

2225: ORG_ID,
2226: SITE_ID
2227: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2228: WHERE LEVEL_ID = p_dim_level_id
2229: AND (user_id = fnd_global.user_id
2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;

Line 2230: OR responsibility_id = fnd_global.RESP_ID

2226: SITE_ID
2227: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2228: WHERE LEVEL_ID = p_dim_level_id
2229: AND (user_id = fnd_global.user_id
2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;

Line 2231: OR application_id = fnd_global.RESP_APPL_ID

2227: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2228: WHERE LEVEL_ID = p_dim_level_id
2229: AND (user_id = fnd_global.user_id
2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;

Line 2232: OR org_id = fnd_global.ORG_ID

2228: WHERE LEVEL_ID = p_dim_level_id
2229: AND (user_id = fnd_global.user_id
2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;

Line 2311: AND (user_id = fnd_global.user_id

2307: ORG_ID,
2308: SITE_ID
2309: FROM BIS_LEVELS_CUSTOMIZATIONS
2310: WHERE LEVEL_ID = p_dim_level_id
2311: AND (user_id = fnd_global.user_id
2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;

Line 2312: OR responsibility_id = fnd_global.RESP_ID

2308: SITE_ID
2309: FROM BIS_LEVELS_CUSTOMIZATIONS
2310: WHERE LEVEL_ID = p_dim_level_id
2311: AND (user_id = fnd_global.user_id
2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;

Line 2313: OR application_id = fnd_global.RESP_APPL_ID

2309: FROM BIS_LEVELS_CUSTOMIZATIONS
2310: WHERE LEVEL_ID = p_dim_level_id
2311: AND (user_id = fnd_global.user_id
2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;

Line 2314: OR org_id = fnd_global.ORG_ID

2310: WHERE LEVEL_ID = p_dim_level_id
2311: AND (user_id = fnd_global.user_id
2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;