1 Package ghr_nfc_error_proc As
2 /* $Header: ghrnfcerrext.pkh 120.1 2005/07/12 15:49:50 hgattu noship $ */
3
4
5 g_proc_name Varchar2(200) :='PQP_NFC_Position_Extracts.';
6
7
8 -- =============================================================================
9 -- ~ NFC_Extract_Process: This is called by the conc. program as is a
10 -- ~ wrapper around the benefits conc. program Extract Process.
11 -- =============================================================================
12 PROCEDURE NFC_Error_Process
13 (errbuf OUT NOCOPY VARCHAR2
14 ,retcode OUT NOCOPY VARCHAR2
15 ,p_business_group_id IN NUMBER
16 ,p_file_type IN VARCHAR2
17 ,p_pos_dummy IN VARCHAR2
18 ,p_pa_dummy IN VARCHAR2
19 ,p_dummy IN VARCHAR2
20 ,p_request_id IN NUMBER
21 );
22 --================================================================================
23 ---PROCEDURE chk_for_err_data_pos
24 --Checks for error positions and takes action accordingly
25 --================================================================================
26 PROCEDURE chk_for_err_data_pos (p_request_id IN NUMBER
27 ,p_rslt_id IN NUMBER
28 );
29 --================================================================================
30 ---PROCEDURE chk_same_day_act
31 --Checks for the action that exists on same day with either correction or
32 --cancellation
33 --================================================================================
34 PROCEDURE chk_same_day_act (p_request_id IN NUMBER
35 ,p_rslt_id IN NUMBER
36 );
37
38 ---============================================================================
39 --PROCEDURE chk_for_err_data_pa
40 --Check personnel action rows that errored with temp table.
41 ---===========================================================================
42 PROCEDURE chk_for_err_data_pa (p_request_id IN NUMBER
43 ,p_rslt_id IN NUMBER
44 );
45
46 ---============================================================================
47 --PROCEDURE Ins_Rslt_Dt
48 --insert new row.
49 ---===========================================================================
50 PROCEDURE Ins_Rslt_Dtl
51 (p_val_tab in out NOCOPY ben_ext_rslt_dtl%rowtype
52 ,p_rslt_dtl_id out NOCOPY number
53 );
54 END ghr_nfc_error_proc;