DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_BILLING_PVT dependencies on FND_GLOBAL

Line 172: L_UserID NUMBER := FND_GLOBAL.User_ID;

168: l_api_name CONSTANT VARCHAR2(30) := 'Revert_Billing_Event';
169: L_Event_ID NUMBER;
170: L_Event_Num NUMBER;
171: L_RowID VARCHAR2(18);
172: L_UserID NUMBER := FND_GLOBAL.User_ID;
173: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
174:
175: CURSOR EventInfo ( C_Event_ID NUMBER ) IS
176: SELECT project_id

Line 173: L_LoginID NUMBER := FND_GLOBAL.Login_ID;

169: L_Event_ID NUMBER;
170: L_Event_Num NUMBER;
171: L_RowID VARCHAR2(18);
172: L_UserID NUMBER := FND_GLOBAL.User_ID;
173: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
174:
175: CURSOR EventInfo ( C_Event_ID NUMBER ) IS
176: SELECT project_id
177: , task_id

Line 902: L_UserID NUMBER := FND_GLOBAL.User_ID;

898: , X_Msg_Data OUT NOCOPY VARCHAR2
899: ) IS
900:
901: L_RowID VARCHAR2(18);
902: L_UserID NUMBER := FND_GLOBAL.User_ID;
903: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
904: l_api_name CONSTANT VARCHAR2(30) := 'Update_Billing_Event';
905: CURSOR EventID IS
906: SELECT pa_events_s.nextval

Line 903: L_LoginID NUMBER := FND_GLOBAL.Login_ID;

899: ) IS
900:
901: L_RowID VARCHAR2(18);
902: L_UserID NUMBER := FND_GLOBAL.User_ID;
903: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
904: l_api_name CONSTANT VARCHAR2(30) := 'Update_Billing_Event';
905: CURSOR EventID IS
906: SELECT pa_events_s.nextval
907: FROM dual;

Line 1160: L_UserID NUMBER := FND_GLOBAL.User_ID;

1156: L_Project_ID NUMBER;
1157: L_Rev_Dist VARCHAR2(80);
1158: L_RowID VARCHAR2(18);
1159: L_Bill_Amount NUMBER;
1160: L_UserID NUMBER := FND_GLOBAL.User_ID;
1161: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
1162: L_Result VARCHAR2(1);
1163: l_api_name CONSTANT VARCHAR2(30) := 'Update_Billing_Event';
1164:

Line 1161: L_LoginID NUMBER := FND_GLOBAL.Login_ID;

1157: L_Rev_Dist VARCHAR2(80);
1158: L_RowID VARCHAR2(18);
1159: L_Bill_Amount NUMBER;
1160: L_UserID NUMBER := FND_GLOBAL.User_ID;
1161: L_LoginID NUMBER := FND_GLOBAL.Login_ID;
1162: L_Result VARCHAR2(1);
1163: l_api_name CONSTANT VARCHAR2(30) := 'Update_Billing_Event';
1164:
1165: BEGIN

Line 1317: , last_updated_by = FND_GLOBAL.User_ID

1313:
1314:
1315: UPDATE pa_events
1316: SET last_update_date = sysdate
1317: , last_updated_by = FND_GLOBAL.User_ID
1318: , last_update_login = FND_GLOBAL.Login_ID
1319: , event_type = nvl( P_Event_Type , event_type )
1320: , description = nvl( P_Description , description )
1321: , bill_amount = nvl( P_Bill_Amount , bill_amount )

Line 1318: , last_update_login = FND_GLOBAL.Login_ID

1314:
1315: UPDATE pa_events
1316: SET last_update_date = sysdate
1317: , last_updated_by = FND_GLOBAL.User_ID
1318: , last_update_login = FND_GLOBAL.Login_ID
1319: , event_type = nvl( P_Event_Type , event_type )
1320: , description = nvl( P_Description , description )
1321: , bill_amount = nvl( P_Bill_Amount , bill_amount )
1322: , revenue_amount = nvl( P_Revenue_Amount , revenue_amount )