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.6 2011/10/25 07:12:31 vepravee noship $ */
3:
4: -- Value sets used to define job levels
5: g_job_fmly_vset_id NUMBER;

Line 968: 'hri_opl_jobh.decode_keyflex_value

964: -- Formulate the return column string
965: IF (p_flex_type = 'KEY') THEN
966:
967: l_column_string :=
968: 'hri_opl_jobh.decode_keyflex_value
969: (pjd.id_flex_num, ''' || p_job_type || ''',
970: pjd.segment1, pjd.segment2, pjd.segment3, pjd.segment4, pjd.segment5,
971: pjd.segment6, pjd.segment7, pjd.segment8, pjd.segment9, pjd.segment10,
972: pjd.segment11, pjd.segment12, pjd.segment13, pjd.segment14, pjd.segment15,

Line 980: 'hri_opl_jobh.decode_descr_flex_value

976:
977: ELSIF (p_flex_type = 'DESCRIPTIVE') THEN
978:
979: l_column_string :=
980: 'hri_opl_jobh.decode_descr_flex_value
981: (job.attribute_category, ''' || p_job_type || ''',
982: job.attribute1, job.attribute2, job.attribute3, job.attribute4, job.attribute5,
983: job.attribute6, job.attribute7, job.attribute8, job.attribute9, job.attribute10,
984: job.attribute11, job.attribute12, job.attribute13, job.attribute14, job.attribute15,

Line 1330: END hri_opl_jobh;

1326:
1327: incr_refresh;
1328:
1329: END incr_refresh;
1330: END hri_opl_jobh;