DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on PER_JOBS

Line 63: job_id per_jobs.job_id%TYPE,

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,

Line 64: job_name per_jobs.name%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,

Line 373: || p_job_name - Job Name from per_jobs.

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

Line 374: || p_job_id - Job Id from per_jobs.

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:

Line 394: p_job_name IN per_jobs.name%TYPE DEFAULT NULL,

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:

Line 395: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL)

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: /*