DBA Data[Home] [Help]

APPS.PFT_PROFCAL_VALIDX_PUB dependencies on FND_GLOBAL

Line 229: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;

225: l_err_code NUMBER := 0;
226: l_num_msg NUMBER := 0;
227: l_value_set_id NUMBER;
228:
229: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
230: l_user_id NUMBER := FND_GLOBAL.User_Id;
231: l_login_id NUMBER := FND_GLOBAL.Login_Id;
232:
233: TYPE number_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 230: l_user_id NUMBER := FND_GLOBAL.User_Id;

226: l_num_msg NUMBER := 0;
227: l_value_set_id NUMBER;
228:
229: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
230: l_user_id NUMBER := FND_GLOBAL.User_Id;
231: l_login_id NUMBER := FND_GLOBAL.Login_Id;
232:
233: TYPE number_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
234: l_created_by_request_id_tbl number_type;

Line 231: l_login_id NUMBER := FND_GLOBAL.Login_Id;

227: l_value_set_id NUMBER;
228:
229: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
230: l_user_id NUMBER := FND_GLOBAL.User_Id;
231: l_login_id NUMBER := FND_GLOBAL.Login_Id;
232:
233: TYPE number_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
234: l_created_by_request_id_tbl number_type;
235: l_created_by_object_id_tbl number_type;

Line 1539: l_login_id NUMBER := FND_GLOBAL.Login_Id;

1535: l_where_stmt LONG;
1536: l_request_id NUMBER;
1537: l_effective_date DATE;
1538: l_user_id NUMBER;
1539: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1540:
1541: BEGIN
1542: l_request_id := FND_GLOBAL.Conc_Request_Id;
1543: l_user_id := FND_GLOBAL.User_Id;

Line 1542: l_request_id := FND_GLOBAL.Conc_Request_Id;

1538: l_user_id NUMBER;
1539: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1540:
1541: BEGIN
1542: l_request_id := FND_GLOBAL.Conc_Request_Id;
1543: l_user_id := FND_GLOBAL.User_Id;
1544: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1545:
1546:

Line 1543: l_user_id := FND_GLOBAL.User_Id;

1539: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1540:
1541: BEGIN
1542: l_request_id := FND_GLOBAL.Conc_Request_Id;
1543: l_user_id := FND_GLOBAL.User_Id;
1544: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1545:
1546:
1547:

Line 1663: l_login_id NUMBER := FND_GLOBAL.Login_Id;

1659: l_where_stmt LONG;
1660: l_request_id NUMBER;
1661: l_effective_date DATE;
1662: l_user_id NUMBER;
1663: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1664:
1665: BEGIN
1666: l_request_id := FND_GLOBAL.Conc_Request_Id;
1667: l_user_id := FND_GLOBAL.user_Id;

Line 1666: l_request_id := FND_GLOBAL.Conc_Request_Id;

1662: l_user_id NUMBER;
1663: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1664:
1665: BEGIN
1666: l_request_id := FND_GLOBAL.Conc_Request_Id;
1667: l_user_id := FND_GLOBAL.user_Id;
1668: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1669:
1670: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

Line 1667: l_user_id := FND_GLOBAL.user_Id;

1663: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1664:
1665: BEGIN
1666: l_request_id := FND_GLOBAL.Conc_Request_Id;
1667: l_user_id := FND_GLOBAL.user_Id;
1668: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1669:
1670: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1671: ,p_module => G_BLOCK||'.'||l_api_name

Line 1765: l_login_id NUMBER := FND_GLOBAL.login_id;

1761: l_where_stmt LONG;
1762: l_request_id NUMBER;
1763: l_effective_date DATE;
1764: l_user_id NUMBER;
1765: l_login_id NUMBER := FND_GLOBAL.login_id;
1766:
1767: BEGIN
1768: l_request_id := FND_GLOBAL.Conc_Request_Id;
1769: l_user_id := FND_GLOBAL.User_Id;

Line 1768: l_request_id := FND_GLOBAL.Conc_Request_Id;

1764: l_user_id NUMBER;
1765: l_login_id NUMBER := FND_GLOBAL.login_id;
1766:
1767: BEGIN
1768: l_request_id := FND_GLOBAL.Conc_Request_Id;
1769: l_user_id := FND_GLOBAL.User_Id;
1770: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1771:
1772:

Line 1769: l_user_id := FND_GLOBAL.User_Id;

1765: l_login_id NUMBER := FND_GLOBAL.login_id;
1766:
1767: BEGIN
1768: l_request_id := FND_GLOBAL.Conc_Request_Id;
1769: l_user_id := FND_GLOBAL.User_Id;
1770: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1771:
1772:
1773: