DBA Data[Home] [Help]

APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on FND_GLOBAL

Line 16: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;

12: G_SQL_ERR_MSG_TOKEN CONSTANT VARCHAR2(11) := 'SQL_ERR_MSG';
13: G_PLSQL_ERR CONSTANT VARCHAR2(17) := 'EGO_PLSQL_ERR';
14:
15: G_EGO_ITEM CONSTANT VARCHAR2(20) := 'EGO_ITEM';
16: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
18:
19:
20: ----------------------------------------------------------------------

Line 17: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;

13: G_PLSQL_ERR CONSTANT VARCHAR2(17) := 'EGO_PLSQL_ERR';
14:
15: G_EGO_ITEM CONSTANT VARCHAR2(20) := 'EGO_ITEM';
16: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
17: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
18:
19:
20: ----------------------------------------------------------------------
21: -- Private Procedures / Functions

Line 497: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)

493: THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
498: THEN
499: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
500: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
501: END IF;

Line 499: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

495: END IF;
496:
497: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
498: THEN
499: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
500: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
501: END IF;
502:
503: --

Line 500: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

496:
497: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
498: THEN
499: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
500: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
501: END IF;
502:
503: --
504: -- replaced call to EGO_INV_ITEM_CATALOG_PVT.Check_pending_Change_Orders

Line 1146: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)

1142: THEN
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1146: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1147: THEN
1148: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1149: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1150: END IF;

Line 1148: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

1144: END IF;
1145:
1146: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1147: THEN
1148: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1149: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1150: END IF;
1151:
1152: IF (p_inventory_item_id IS NULL

Line 1149: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

1145:
1146: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1147: THEN
1148: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1149: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1150: END IF;
1151:
1152: IF (p_inventory_item_id IS NULL
1153: OR

Line 1556: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)

1552: THEN
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1557: THEN
1558: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1559: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1560: END IF;

Line 1558: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;

1554: END IF;
1555:
1556: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1557: THEN
1558: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1559: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1560: END IF;
1561:
1562:

Line 1559: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

1555:
1556: IF Nvl(FND_GLOBAL.User_Id,-1) <> Nvl(G_CURRENT_USER_ID,-1)
1557: THEN
1558: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1559: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;
1560: END IF;
1561:
1562:
1563: IF ( p_inventory_item_id IS NULL

Line 2054: WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID

2050: SELECT
2051: ORGANIZATION_ID BULK COLLECT INTO l_orgs
2052: FROM
2053: ORG_ACCESS_VIEW
2054: WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
2055: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
2056:
2057: ELSE
2058:

Line 2055: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;

2051: ORGANIZATION_ID BULK COLLECT INTO l_orgs
2052: FROM
2053: ORG_ACCESS_VIEW
2054: WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
2055: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
2056:
2057: ELSE
2058:
2059: l_orgs := ORG_TABLE(p_organization_id);