398: l_job_content VARCHAR2(15599);
399: l_length NUMBER;
400: l_available_size NUMBER := 13500;
401: l_break VARCHAR2(10) := '
';
402: l_function_name fnd_profile_option_values.profile_option_value%type;
403: l_resp_key fnd_responsibility.responsibility_key%type;
404: l_resp_id fnd_responsibility.responsibility_id%type;
405: --
406: BEGIN
515: l_job_content VARCHAR2(15599);
516: l_length NUMBER;
517: l_available_size NUMBER := 13500;
518: l_new_line VARCHAR2(10) := '\n';
519: l_function_name fnd_profile_option_values.profile_option_value%type;
520: --
521: BEGIN
522: --
523: IF (irc_utilities_pkg.is_internal_person(p_person_id,trunc(sysdate))='TRUE') THEN
778: WHERE responsibility_key = resp_key;
779:
780: l_resp_key fnd_responsibility.responsibility_key%type;
781: l_resp_id fnd_responsibility.responsibility_id%type;
782: l_function_name fnd_profile_option_values.profile_option_value%type;
783: BEGIN
784:
785: if(lower(p_is_internal) = 'y')
786: then