DBA Data[Home] [Help]

APPS.PFT_PROFCAL_RGNCNT_PUB dependencies on FND_GLOBAL

Line 183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;

179: l_total_customers NUMBER;
180: l_region_code NUMBER;
181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF

Line 184: l_user_id NUMBER := FND_GLOBAL.User_Id;

180: l_region_code NUMBER;
181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
188: fem_mp_process_ctl_t.message%TYPE;

Line 185: l_login_id NUMBER := FND_GLOBAL.Login_Id;

181: l_object_def_id NUMBER;
182: l_cust_wo_rgn_code NUMBER;
183: l_request_id NUMBER := FND_GLOBAL.Conc_Request_Id;
184: l_user_id NUMBER := FND_GLOBAL.User_Id;
185: l_login_id NUMBER := FND_GLOBAL.Login_Id;
186:
187: TYPE v_msg_list_type IS VARRAY(20) OF
188: fem_mp_process_ctl_t.message%TYPE;
189: v_msg_list v_msg_list_type;

Line 901: l_login_id NUMBER := FND_GLOBAL.Login_Id;

897: l_msg_data VARCHAR2(500);
898: l_return_status VARCHAR2(20);
899: l_effective_date DATE;
900: l_user_id NUMBER;
901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;

Line 904: l_request_id := FND_GLOBAL.Conc_Request_Id;

900: l_user_id NUMBER;
901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
906: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

Line 905: l_user_id := FND_GLOBAL.User_Id;

901: l_login_id NUMBER := FND_GLOBAL.Login_Id;
902:
903: BEGIN
904: l_request_id := FND_GLOBAL.Conc_Request_Id;
905: l_user_id := FND_GLOBAL.User_Id;
906: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
907:
908: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
909: ,p_module => G_BLOCK||'.'||l_api_name

Line 1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;

1158: l_msg_data VARCHAR2(500);
1159: l_return_status VARCHAR2(20);
1160: l_effective_date DATE;
1161: l_user_id NUMBER;
1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;

Line 1165: l_request_id := FND_GLOBAL.Conc_Request_Id;

1161: l_user_id NUMBER;
1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1167: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1168:
1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2

Line 1166: l_user_id := FND_GLOBAL.User_Id;

1162: l_login_id NUMBER := FND_GLOBAL.Login_Id;
1163:
1164: BEGIN
1165: l_request_id := FND_GLOBAL.Conc_Request_Id;
1166: l_user_id := FND_GLOBAL.User_Id;
1167: l_effective_date := FND_DATE.Canonical_To_Date(p_effective_date);
1168:
1169: FEM_ENGINES_PKG.Tech_Message ( p_severity => g_log_level_2
1170: ,p_module => G_BLOCK||'.'||l_api_name