[Home] [Help]
PACKAGE: APPS.PAY_PAYGBSOE_XMLP_PKG
Source
1 PACKAGE PAY_PAYGBSOE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYGBSOES.pls 120.1 2007/12/24 12:44:49 amakrish noship $ */
3 P_SESSION_DATE date;
4 P_PAYROLL_EXISTS varchar2(32767);
5 P_PAYROLL_ID number;
6 P_TIME_PERIOD_ID number;
7 P_PAY_ADVICE_DATE varchar2(32767);
8 P_conc_request_id number;
9 P_ASSIGNMENT_ID number;
10 P_SORT_ORDER1 varchar2(60);
11 P_SORT_ORDER1_dup varchar2(60);
12 P_SORT_ORDER2 varchar2(60);
13 P_SORT_ORDER2_dup varchar2(60);
14 P_SORT_ORDER3 varchar2(60);
15 P_SORT_ORDER3_dup varchar2(60);
16 P_SORT_ORDER4 varchar2(60);
17 P_SORT_ORDER4_dup varchar2(60);
18 P_SORT_ORDER5 varchar2(60);
19 P_SORT_ORDER5_dup varchar2(60);
20 P_SORT_ORDER6 varchar2(60);
21 P_SORT_ORDER6_dup varchar2(60);
22 P_SORT_ORDER7 varchar2(32767);
23 P_BUS_GRP_ID number;
24 C_ADDRESS1 varchar2(28);
25 C_ADDRESS2 varchar2(28);
26 C_ADDRESS3 varchar2(28);
27 C_REGION1 varchar2(28);
28 C_REGION2 varchar2(28);
29 C_REGION3 varchar2(28);
30 C_ACCOUNT_NO number;
31 C_TOWN varchar2(28);
32 C_ANNUAL_SALARY number;
33 C_PAY_DATE date;
34 C_TAX_PERIOD varchar2(30);
35 C_TAX_REFERENCE_NO varchar2(30);
36 C_TAX_CODE varchar2(15);
37 C_TAX_BASIS varchar2(30);
38 C_NI_CATEGORY varchar2(30);
39 C_TAX_TEL_NO varchar2(20);
40 C_BALANCE_R1_TXT varchar2(20);
41 C_BALANCE_R1_VAL number;
42 C_BALANCE_R2_TXT varchar2(20);
43 C_BALANCE_R2_VAL number;
44 C_BALANCE_R3_TXT varchar2(20);
45 C_BALANCE_R3_VAL number;
46 C_BALANCE_R4_TXT varchar2(20);
47 C_BALANCE_R4_VAL number;
48 C_BALANCE_R5_TXT varchar2(20);
49 C_BALANCE_R5_VAL number;
50 C_BALANCE_R6_TXT varchar2(20);
51 C_BALANCE_R6_VAL number;
52 C_BALANCE_R7_TXT varchar2(20);
53 C_BALANCE_R7_VAL number;
54 C_BALANCE_R8_TXT varchar2(20);
55 C_BALANCE_R8_VAL number;
56 C_BALANCE_R9_TXT varchar2(20);
57 C_BALANCE_R9_VAL number;
58 C_BALANCE_R10_TXT varchar2(20);
59 C_BALANCE_R10_VAL number;
60 C_BALANCE_R11_TXT varchar2(20);
61 C_BALANCE_R11_VAL number;
62 C_BALANCE_R12_TXT varchar2(20);
63 C_BALANCE_R12_VAL number;
64 C_OUTPUT2 number;
65 C_OUTPUT number;
66 C_2 number;
67 C_FORMULA_ID number;
68 C_DATE_EARNED varchar2(11);
69 C_FORMULA_ID2 number;
70 C_OUTPUT3 varchar2(32767);
71 function c_amount_paidformula(C_PAYMENT_TOTAL in number, C_DEDUCTION_TOTAL in number) return number ;
72 function BeforeReport return boolean ;
73 function P_SORT_ORDER3ValidTrigger return boolean ;
74 function P_SORT_ORDER4ValidTrigger return boolean ;
75 function P_SORT_ORDER5ValidTrigger return boolean ;
76 function P_SORT_ORDER6ValidTrigger return boolean ;
77 function c_nameformula(TITLE in varchar2, INITIALS in varchar2, LAST_NAME in varchar2) return varchar2 ;
78 Function Segment1 return varchar2 ;
79 Procedure Seg_name(a in varchar2 , b out NOCOPY varchar2) ;
80 Function Segment2 return varchar2 ;
81 Function Segment3 return varchar2 ;
82 Function Segment4 return varchar2 ;
83 Function Segment5 return varchar2 ;
84 Function Segment6 return varchar2 ;
85 function P_SORT_ORDER1ValidTrigger return boolean ;
86 function P_SORT_ORDER2ValidTrigger return boolean ;
87 function AfterPForm return boolean ;
88 function BeforePForm return boolean ;
89 function cf_euro_amountformula(c_amount_paid in number) return number ;
90 function AfterReport return boolean ;
91 Function C_ADDRESS1_p return varchar2;
92 Function C_ADDRESS2_p return varchar2;
93 Function C_ADDRESS3_p return varchar2;
94 Function C_REGION1_p return varchar2;
95 Function C_REGION2_p return varchar2;
96 Function C_REGION3_p return varchar2;
97 Function C_ACCOUNT_NO_p return number;
98 Function C_TOWN_p return varchar2;
99 Function C_ANNUAL_SALARY_p return number;
100 Function C_PAY_DATE_p return date;
101 Function C_TAX_PERIOD_p return varchar2;
102 Function C_TAX_REFERENCE_NO_p return varchar2;
103 Function C_TAX_CODE_p return varchar2;
104 Function C_TAX_BASIS_p return varchar2;
105 Function C_NI_CATEGORY_p return varchar2;
106 Function C_TAX_TEL_NO_p return varchar2;
107 Function C_BALANCE_R1_TXT_p return varchar2;
108 Function C_BALANCE_R1_VAL_p return number;
109 Function C_BALANCE_R2_TXT_p return varchar2;
110 Function C_BALANCE_R2_VAL_p return number;
111 Function C_BALANCE_R3_TXT_p return varchar2;
112 Function C_BALANCE_R3_VAL_p return number;
113 Function C_BALANCE_R4_TXT_p return varchar2;
114 Function C_BALANCE_R4_VAL_p return number;
115 Function C_BALANCE_R5_TXT_p return varchar2;
116 Function C_BALANCE_R5_VAL_p return number;
117 Function C_BALANCE_R6_TXT_p return varchar2;
118 Function C_BALANCE_R6_VAL_p return number;
119 Function C_BALANCE_R7_TXT_p return varchar2;
120 Function C_BALANCE_R7_VAL_p return number;
121 Function C_BALANCE_R8_TXT_p return varchar2;
122 Function C_BALANCE_R8_VAL_p return number;
123 Function C_BALANCE_R9_TXT_p return varchar2;
124 Function C_BALANCE_R9_VAL_p return number;
125 Function C_BALANCE_R10_TXT_p return varchar2;
126 Function C_BALANCE_R10_VAL_p return number;
127 Function C_BALANCE_R11_TXT_p return varchar2;
128 Function C_BALANCE_R11_VAL_p return number;
129 Function C_BALANCE_R12_TXT_p return varchar2;
130 Function C_BALANCE_R12_VAL_p return number;
131 Function C_OUTPUT2_p return number;
132 Function C_OUTPUT_p return number;
133 Function C_2_p return number;
134 Function C_FORMULA_ID_p return number;
135 Function C_DATE_EARNED_p return varchar2;
136 Function C_FORMULA_ID2_p return number;
137 Function C_OUTPUT3_p return varchar2;
138
139 --ADDED BY VALLI--
140 function populate_fields(expense_check_send_to_address IN VARCHAR2,
141 person_id IN NUMBER,segment1c IN VARCHAR2,segment2c IN VARCHAR2,segment3c IN VARCHAR2,segment4c IN VARCHAR2,segment5c IN VARCHAR2,segment6c IN VARCHAR2) return number;
142
143 function get_ff_data(run_effective_date IN DATE ,date_earned IN DATE,assignment_id IN NUMBER
144 ,run_assignment_action_id IN NUMBER,payroll_action_id IN NUMBER,p_bus_grp_id IN NUMBER)
145 return number ;
146
147 END PAY_PAYGBSOE_XMLP_PKG;