59: person_id per_people_f.person_id%TYPE,
60: person_full_name per_people_f.full_name%TYPE,
61: supervisor_id per_people_f.person_id%TYPE,
62: supervisor_full_name per_people_f.full_name%TYPE,
63: job_id per_jobs.job_id%TYPE,
64: job_name per_jobs.name%TYPE,
65: organization_id hr_organization_units.organization_id%TYPE,
66: organization_name hr_organization_units.name%TYPE,
67: assignment_number per_assignments_f.assignment_number%TYPE,
60: person_full_name per_people_f.full_name%TYPE,
61: supervisor_id per_people_f.person_id%TYPE,
62: supervisor_full_name per_people_f.full_name%TYPE,
63: job_id per_jobs.job_id%TYPE,
64: job_name per_jobs.name%TYPE,
65: organization_id hr_organization_units.organization_id%TYPE,
66: organization_name hr_organization_units.name%TYPE,
67: assignment_number per_assignments_f.assignment_number%TYPE,
68: business_group_id per_assignments_f.business_group_id%TYPE,
369: || Pre Conditions:
370: ||
371: || In Arguments:
372: || p_job_segments - User defined Segment string.
373: || p_job_name - Job Name from per_jobs.
374: || p_job_id - Job Id from per_jobs.
375: ||
376: || out nocopy Arguments: Derived string.
377: ||
370: ||
371: || In Arguments:
372: || p_job_segments - User defined Segment string.
373: || p_job_name - Job Name from per_jobs.
374: || p_job_id - Job Id from per_jobs.
375: ||
376: || out nocopy Arguments: Derived string.
377: ||
378: || In out nocopy Arguments:
390:
391:
392: FUNCTION get_user_defined_job_segments
393: ( p_job_segments IN varchar2 DEFAULT NULL,
394: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,
395: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)
396: RETURN VARCHAR2;
397:
398:
391:
392: FUNCTION get_user_defined_job_segments
393: ( p_job_segments IN varchar2 DEFAULT NULL,
394: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,
395: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)
396: RETURN VARCHAR2;
397:
398:
399: /*