DBA Data[Home] [Help]

APPS.IGW_PROP_SCIENCE_CODES_TBH dependencies on FND_GLOBAL

Line 22: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);

18:
19: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
20:
21: l_last_update_date DATE := SYSDATE;
22: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid

Line 23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);

19: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
20:
21: l_last_update_date DATE := SYSDATE;
22: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
23: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
24:
25: CURSOR c IS
26: SELECT rowid
27: FROM igw_prop_science_codes

Line 113: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);

109:
110: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
111:
112: l_last_update_date DATE := SYSDATE;
113: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
115:
116: BEGIN
117:

Line 114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);

110: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
111:
112: l_last_update_date DATE := SYSDATE;
113: l_last_updated_by NUMBER := Nvl(Fnd_Global.User_Id,-1);
114: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
115:
116: BEGIN
117:
118: x_return_status := Fnd_Api.G_Ret_Sts_Success;