DBA Data[Home] [Help]

APPS.HRI_OPL_JOBH dependencies on HRI_OPL_JOBH

Line 1: PACKAGE BODY hri_opl_jobh AS

1: PACKAGE BODY hri_opl_jobh AS
2: /* $Header: hripjobh.pkb 120.4 2006/10/11 15:38:06 jtitmas noship $ */
3:
4: -- Value sets used to define job levels
5: g_job_fmly_vset_id NUMBER;

Line 961: 'hri_opl_jobh.decode_keyflex_value

957: -- Formulate the return column string
958: IF (p_flex_type = 'KEY') THEN
959:
960: l_column_string :=
961: 'hri_opl_jobh.decode_keyflex_value
962: (pjd.id_flex_num, ''' || p_job_type || ''',
963: pjd.segment1, pjd.segment2, pjd.segment3, pjd.segment4, pjd.segment5,
964: pjd.segment6, pjd.segment7, pjd.segment8, pjd.segment9, pjd.segment10,
965: pjd.segment11, pjd.segment12, pjd.segment13, pjd.segment14, pjd.segment15,

Line 973: 'hri_opl_jobh.decode_descr_flex_value

969:
970: ELSIF (p_flex_type = 'DESCRIPTIVE') THEN
971:
972: l_column_string :=
973: 'hri_opl_jobh.decode_descr_flex_value
974: (job.attribute_category, ''' || p_job_type || ''',
975: job.attribute1, job.attribute2, job.attribute3, job.attribute4, job.attribute5,
976: job.attribute6, job.attribute7, job.attribute8, job.attribute9, job.attribute10,
977: job.attribute11, job.attribute12, job.attribute13, job.attribute14, job.attribute15,

Line 1323: END hri_opl_jobh;

1319:
1320: incr_refresh;
1321:
1322: END incr_refresh;
1323: END hri_opl_jobh;