[Home] [Help]
53: --
54: c_RETURN CONSTANT VARCHAR2(1) := '
55: ';
56: --
57: -- Standard performance fast formula introduction text
58: --
59: c_Perf_FF_intro_text CONSTANT VARCHAR2(250) :=
60: 'INPUTS are APPRAISAL_TEMPLATE_NAME (Text),
61: RATING
63: DEFAULT for RATING is 0
64: SKIP_REVIEW = ''Y''
65: ';
66: --
67: -- Standard performance fast formula closing text
68: --
69: c_Perf_FF_clsng_text CONSTANT VARCHAR2(250) :=
70: 'RETURN SKIP_REVIEW, NORMALIZED_RATING';
71: --
198: --
199: END display;
200: --
201: -- -----------------------------------------------------------------------------
202: -- Procedure to generate the standard error text for the main entry point
203: -- procedures.
204: --
205: PROCEDURE failure_exit_message IS
206: --
230: -- -----------------------------------------------------------------------------
231: -- Procedure used by the EXCEPTION statements in the main entry point
232: -- procedures called from DBI request sets.
233: --
234: -- This procedure will output a standard error message and set the status of
235: -- the process to 'WARNING' rather than error, to prevent fastformula issues
236: -- halting the request set.
237: --
238: --
243: l_success BOOLEAN DEFAULT FALSE;
244: --
245: BEGIN
246: --
247: -- Output standard failure message.
248: --
249: failure_exit_message;
250: --
251: -- Set process status to 'WARNING' if there has been an error
287: IF l_hr_installed = 'FALSE'
288: OR l_frc_shrd_hr_prfl_val = 'Y'
289: THEN
290: --
291: -- Separation of the full stop (period) '.' for GSCC standards.
292: --
293: dbg('This system has been configured for Shared HRMS'||'.');
294: dbg('FastFormula are not required in a shared HR environment.');
295: dbg('No further processing required.');
1289: --
1290: END gnrt_ss_prfrmnce_apprsl_ff;
1291: --
1292: -- ----------------------------------------------------------------------------
1293: -- Standard Entry point to be called from standalone concurrent process, where
1294: -- a user can generate performance apraisal fastformula for 1 or a number of
1295: -- business groups.
1296: --
1297: PROCEDURE gnrt_ss_prfrmnce_apprsl_ff
1495: --
1496: END delete_all_prfrmnc_formulas;
1497: --
1498: -- ----------------------------------------------------------------------------
1499: -- This is a standard entry point.
1500: -- This procedure controls the dynamic creation of DBI related fastformulas.
1501: -- This process is designed to be called from a full refresh request set.
1502: --
1503: -- The steps it follows are:
1623: --
1624: END fastformula_check_full;
1625: --
1626: -- ----------------------------------------------------------------------------
1627: -- This is a standard entry point:
1628: -- This procedure controls the dynamic creation of DBI related fastformulas.
1629: --
1630: -- This process is designed to be called from an incremental refresh request
1631: -- set.