DBA Data[Home] [Help]

APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on FND_PROFILE

Line 29: user_id := fnd_profile.value('USER_ID');

25: user_id NUMBER;
26: login_id NUMBER;
27: BEGIN
28:
29: user_id := fnd_profile.value('USER_ID');
30: login_id := fnd_profile.value('LOGIN_ID');
31:
32: -- Delete all the existing values
33: DELETE FROM GL_JE_SEGMENT_VALUES

Line 30: login_id := fnd_profile.value('LOGIN_ID');

26: login_id NUMBER;
27: BEGIN
28:
29: user_id := fnd_profile.value('USER_ID');
30: login_id := fnd_profile.value('LOGIN_ID');
31:
32: -- Delete all the existing values
33: DELETE FROM GL_JE_SEGMENT_VALUES
34: WHERE je_header_id = x_je_header_id;

Line 262: user_id := fnd_profile.value('USER_ID');

258: user_id NUMBER;
259: login_id NUMBER;
260: BEGIN
261:
262: user_id := fnd_profile.value('USER_ID');
263: login_id := fnd_profile.value('LOGIN_ID');
264:
265: -- Delete all the existing values
266: DELETE FROM GL_JE_SEGMENT_VALUES

Line 263: login_id := fnd_profile.value('LOGIN_ID');

259: login_id NUMBER;
260: BEGIN
261:
262: user_id := fnd_profile.value('USER_ID');
263: login_id := fnd_profile.value('LOGIN_ID');
264:
265: -- Delete all the existing values
266: DELETE FROM GL_JE_SEGMENT_VALUES
267: WHERE je_header_id IN (SELECT je_header_id

Line 388: fnd_profile.get('GL_ACCESS_SET_ID', temp);

384:
385: -- Build the statements for the current
386: -- chart of accounts
387: IF (insert_stmt IS NULL) THEN
388: fnd_profile.get('GL_ACCESS_SET_ID', temp);
389: asid := to_number(temp);
390:
391: SELECT bal_seg_column_name,
392: mgt_seg_column_name