7:
8: ------------------------------------
9: -- Common constants and variables --
10: ------------------------------------
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
8: ------------------------------------
9: -- Common constants and variables --
10: ------------------------------------
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16:
9: -- Common constants and variables --
10: ------------------------------------
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16:
17: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');
10: ------------------------------------
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16:
17: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');
18:
11: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;
12: l_log_statement NUMBER := fnd_log.level_statement;
13: l_log_procedure NUMBER := fnd_log.level_procedure;
14: l_log_error NUMBER := fnd_log.level_error;
15: l_log_unexpected NUMBER := fnd_log.level_unexpected;
16:
17: G_BPEL_USER_ROLE_KEY VARCHAR2(240) := FND_PROFILE.VALUE('AHL_BPEL_USER_ROLE');
18:
19: FUNCTION init_user_and_role(p_user_id IN VARCHAR2) RETURN VARCHAR2 IS