1 PACKAGE py_za_total_package AS
2 /* $Header: pyzatotpkg.pkh 120.0.12000000.2 2007/06/29 08:43:24 rpahune noship $ */
3 /* Copyright (c) Oracle Corporation 2005. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Payroll - ZA Localisation
7
8 NAME
9 py_za_total_package
10
11 DESCRIPTION
12
13 NOTES
14 .
15
16 MODIFICATION HISTORY
17 Person Date Version Bug Comments
18 --------- ----------- ------- ------- ---------------------------------
19 J.N. Louw 04/04/2007 115.2 5964600
20 J.N. Louw 14/09/2005 115.1 4566053 Added annualisation to the split
21 R.V. Pahune 05/08/2005 115.0 4346920 Balance feed enhancement
22 J.N. Louw 17/08/2005 115.0 Initial Version
23 */
24
25 -------------------------------------------------------------------------------
26 -- PACKAGE GLOBAL AREA --
27 -------------------------------------------------------------------------------
28 -- hr_utility wrapper globals
29 g_HrTraceEnabled BOOLEAN DEFAULT FALSE;
30 g_HrTracePipeName VARCHAR2(30);
31 -- Indent
32 g_indent VARCHAR2(30);
33 -------------------------------------------------------------------------------
34 -- PACKAGE SPECIFICATION --
35 -------------------------------------------------------------------------------
36
37 FUNCTION split_totpkg(
38 -- Database Items
39 p_FXD_PRC IN NUMBER
40 ,p_TOT_PKG IN NUMBER
41 ,p_ZA_ACT_END_DTE IN DATE
42 ,p_ZA_ACT_STRT_DTE IN DATE
43 ,p_ZA_ASG_TAX_RTR_RSLTS IN VARCHAR2
44 ,p_ZA_ASG_TX_RTR_PRD IN VARCHAR2
45 ,p_ZA_ASG_TX_YR IN NUMBER
46 ,p_ZA_CUR_PRD_END_DTE IN DATE
47 ,p_ZA_CUR_PRD_STRT_DTE IN DATE
48 ,p_ZA_DYS_IN_YR IN NUMBER
49 ,p_ZA_PAY_PRDS_LFT IN NUMBER
50 ,p_ZA_PAY_PRDS_PER_YR IN NUMBER
51 ,p_ZA_TX_YR_END IN DATE
52 ,p_ZA_TX_YR_STRT IN DATE
53 -- Balances
54 ,p_ANN_TXB_PKG_CMP_NRFI_YTD IN NUMBER
55 ,p_ANN_TXB_PKG_CMP_RFI_YTD IN NUMBER
56 ,p_ANN_TXB_PKG_CMP_YTD IN NUMBER
57 ,p_BP_PTD IN NUMBER
58 ,p_BP_YTD IN NUMBER
59 ,p_RFIABLE_TOT_PKG_CYTD IN NUMBER
60 ,p_RFIABLE_TOT_PKG_PTD IN NUMBER
61 ,p_RFIABLE_TOT_PKG_YTD IN NUMBER
62 ,p_TOT_TXB_AB_RUN IN NUMBER
63 ,p_TOT_TXB_AP_YTD IN NUMBER
64 ,p_TOT_TXB_FB_CYTD IN NUMBER
65 ,p_TOT_TXB_FB_PTD IN NUMBER
66 ,p_TOT_TXB_FB_YTD IN NUMBER
67 ,p_TOT_TXB_NI_CYTD IN NUMBER
68 ,p_TOT_TXB_NI_PTD IN NUMBER
69 ,p_TOT_TXB_NI_YTD IN NUMBER
70 ,p_TOT_TXB_TA_CYTD IN NUMBER
71 ,p_TOT_TXB_TA_PTD IN NUMBER
72 ,p_TOT_TXB_TA_YTD IN NUMBER
73 ,p_TXB_PKG_CMP_CYTD IN NUMBER
74 ,p_TXB_PKG_CMP_NRFI_YTD IN NUMBER
75 ,p_TXB_PKG_CMP_PTD IN NUMBER
76 ,p_TXB_PKG_CMP_RFI_YTD IN NUMBER
77 ,p_TXB_PKG_CMP_YTD IN NUMBER
78 -- Out Parameters
79 ,p_RFIableTotPkgPTD_Upd OUT NOCOPY NUMBER
80 ,p_AnnTxbPkgCmpRFI_Upd OUT NOCOPY NUMBER
81 ,p_AnnTxbPkgCmpNRFI_Upd OUT NOCOPY NUMBER
82 ,p_TxbPkgCmpRFI_Upd OUT NOCOPY NUMBER
83 ,p_TxbPkgCmpNRFI_Upd OUT NOCOPY NUMBER
84 ) RETURN NUMBER;
85
86 END py_za_total_package;
87