DBA Data[Home] [Help]

APPS.CSF_PLAN_TERRS_PKG dependencies on FND_GLOBAL

Line 136: l_last_updated_by := FND_GLOBAL.User_Id;

132:
133: BEGIN
134:
135: l_last_update_date := SYSDATE;
136: l_last_updated_by := FND_GLOBAL.User_Id;
137: l_creation_date := SYSDATE;
138: l_created_by := FND_GLOBAL.User_Id;
139: l_last_update_login := FND_GLOBAL.Login_Id;
140:

Line 138: l_created_by := FND_GLOBAL.User_Id;

134:
135: l_last_update_date := SYSDATE;
136: l_last_updated_by := FND_GLOBAL.User_Id;
137: l_creation_date := SYSDATE;
138: l_created_by := FND_GLOBAL.User_Id;
139: l_last_update_login := FND_GLOBAL.Login_Id;
140:
141: SELECT CSF_PLAN_TERRS_S.NEXTVAL
142: INTO l_plan_terr_id

Line 139: l_last_update_login := FND_GLOBAL.Login_Id;

135: l_last_update_date := SYSDATE;
136: l_last_updated_by := FND_GLOBAL.User_Id;
137: l_creation_date := SYSDATE;
138: l_created_by := FND_GLOBAL.User_Id;
139: l_last_update_login := FND_GLOBAL.Login_Id;
140:
141: SELECT CSF_PLAN_TERRS_S.NEXTVAL
142: INTO l_plan_terr_id
143: FROM dual;

Line 203: l_selected_terr := csf_util_pvt.get_selected_terr(fnd_global.user_id);

199: RAISE NO_DATA_FOUND;
200: END IF;
201: CLOSE c_deleted_terr;
202: -- Get selected territories
203: l_selected_terr := csf_util_pvt.get_selected_terr(fnd_global.user_id);
204:
205: if l_selected_terr is not null
206: then
207: l_selected_terr := replace(l_selected_terr, l_del_terr);

Line 213: csf_util_pvt.set_selected_terr( l_selected_terr, fnd_global.user_id );

209: l_selected_terr := ltrim(l_selected_terr,',');
210: l_selected_terr := rtrim(l_selected_terr,',');
211:
212: -- Save the modified list
213: csf_util_pvt.set_selected_terr( l_selected_terr, fnd_global.user_id );
214: end if;
215: DELETE FROM csf_plan_terrs
216: WHERE rowid = p_rowid;
217: IF (SQL%NOTFOUND) THEN