APPS.EGO_ITEM_AML_PUB dependencies on FND_GLOBAL

Line 244: l_user_id := FND_GLOBAL.User_Id;

240: ,p_message => ' no rows to process - returning ');
241: RETURN;
242: END;
243:
244: l_user_id := FND_GLOBAL.User_Id;
245: l_login_id := FND_GLOBAL.Conc_Login_Id;
246: l_sysdate := SYSDATE;
247:
248: -- create save point

Line 245: l_login_id := FND_GLOBAL.Conc_Login_Id;

241: RETURN;
242: END;
243:
244: l_user_id := FND_GLOBAL.User_Id;
245: l_login_id := FND_GLOBAL.Conc_Login_Id;
246: l_sysdate := SYSDATE;
247:
248: -- create save point
249: IF FND_API.To_Boolean(p_commit) THEN

Line 1143: l_user_id := NVL(p_user_id, FND_GLOBAL.User_Id);

1139: ,p_message => ' EGO is installed '
1140: );
1141: l_party_id := p_party_id;
1142: IF l_party_id IS NULL THEN
1143: l_user_id := NVL(p_user_id, FND_GLOBAL.User_Id);
1144: IF l_user_id = -1 THEN
1145: -- bug 3600938 if user_id is returned as -1, query from user_name
1146: l_dynamic_sql := 'SELECT PARTY_ID FROM EGO_USER_V where user_name = :1';
1147: EXECUTE IMMEDIATE l_dynamic_sql INTO l_party_id USING FND_GLOBAL.USER_NAME;

Line 1147: EXECUTE IMMEDIATE l_dynamic_sql INTO l_party_id USING FND_GLOBAL.USER_NAME;

1143: l_user_id := NVL(p_user_id, FND_GLOBAL.User_Id);
1144: IF l_user_id = -1 THEN
1145: -- bug 3600938 if user_id is returned as -1, query from user_name
1146: l_dynamic_sql := 'SELECT PARTY_ID FROM EGO_USER_V where user_name = :1';
1147: EXECUTE IMMEDIATE l_dynamic_sql INTO l_party_id USING FND_GLOBAL.USER_NAME;
1148: ELSE
1149: l_dynamic_sql := 'SELECT PARTY_ID FROM EGO_USER_V where user_id = :1';
1150: EXECUTE IMMEDIATE l_dynamic_sql INTO l_party_id USING IN l_user_id;
1151: END IF;