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
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;
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
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
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