DBA Data[Home] [Help]

APPS.GL_JOURNALS_AUTOCOPY dependencies on FND_PROFILE

Line 15: dmode_profile fnd_profile_option_values.profile_option_value%TYPE;

11:
12: GLUJECPB_FATAL_ERR EXCEPTION;
13: usr_id NUMBER;
14: log_id NUMBER;
15: dmode_profile fnd_profile_option_values.profile_option_value%TYPE;
16: dmode BOOLEAN;
17: new_jeb_id NUMBER;
18: bc_flag VARCHAR2(1);
19: approval_flag VARCHAR2(1);

Line 21: x_org_id fnd_profile_option_values.profile_option_value%TYPE;

17: new_jeb_id NUMBER;
18: bc_flag VARCHAR2(1);
19: approval_flag VARCHAR2(1);
20: tmp NUMBER;
21: x_org_id fnd_profile_option_values.profile_option_value%TYPE;
22: seq_num fnd_profile_option_values.profile_option_value%TYPE;
23: act_flag VARCHAR2(1);
24: org_id NUMBER;
25: temp NUMBER;

Line 22: seq_num fnd_profile_option_values.profile_option_value%TYPE;

18: bc_flag VARCHAR2(1);
19: approval_flag VARCHAR2(1);
20: tmp NUMBER;
21: x_org_id fnd_profile_option_values.profile_option_value%TYPE;
22: seq_num fnd_profile_option_values.profile_option_value%TYPE;
23: act_flag VARCHAR2(1);
24: org_id NUMBER;
25: temp NUMBER;
26: BEGIN

Line 35: FND_PROFILE.GET('GL_DEBUG_MODE', dmode_profile);

31: usr_id := FND_GLOBAL.User_Id;
32: log_id := FND_GLOBAL.Login_Id;
33:
34: -- Get profile option values
35: FND_PROFILE.GET('GL_DEBUG_MODE', dmode_profile);
36: FND_PROFILE.GET('ORG_ID', x_org_id);
37: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', seq_num);
38:
39: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',

Line 36: FND_PROFILE.GET('ORG_ID', x_org_id);

32: log_id := FND_GLOBAL.Login_Id;
33:
34: -- Get profile option values
35: FND_PROFILE.GET('GL_DEBUG_MODE', dmode_profile);
36: FND_PROFILE.GET('ORG_ID', x_org_id);
37: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', seq_num);
38:
39: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
40: token_num => 3 ,

Line 37: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', seq_num);

33:
34: -- Get profile option values
35: FND_PROFILE.GET('GL_DEBUG_MODE', dmode_profile);
36: FND_PROFILE.GET('ORG_ID', x_org_id);
37: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS', seq_num);
38:
39: GL_MESSAGE.Write_Log(msg_name =>'SHRD0181',
40: token_num => 3 ,
41: t1 =>'ROUTINE',