[Home] [Help]
PACKAGE: APPS.PAY_PAYSGSOE_XMLP_PKG
Source
1 PACKAGE PAY_PAYSGSOE_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAYSGSOES.pls 120.0 2007/12/13 12:13:28 amakrish noship $ */
3 P_ASSIGNMENT_ID number;
4 P_BUSINESS_GROUP_ID number;
5 P_LOCATION_ID number;
6 P_ORGANIZATION_NAME varchar2(80);
7 P_PAYROLL_ACTION_ID number;
8 P_PAYROLL_ID number;
9 P_SORT_ORDER_1 varchar2(32767);
10 P_SORT_ORDER_2 varchar2(32767);
11 P_SORT_ORDER_3 varchar2(32767);
12 P_SORT_ORDER_4 varchar2(32767);
13 P_CONC_REQUEST_ID number;
14 CP_ADDRESS_LINE2 varchar2(100);
15 CP_ADDRESS_LINE3 varchar2(100);
16 CP_TOWN varchar2(100);
17 CP_POST_CODE varchar2(100);
18 CP_COUNTRY varchar2(100);
19 CP_GROSS_PAY_YTD number := 0 ;
20 CP_STAT_DED_CURR number := 0 ;
21 CP_STAT_DED_YTD number := 0 ;
22 CP_OTHER_CURR number := 0 ;
23 CP_OTHER_YTD number := 0 ;
24 CP_NON_PAY_CURR number := 0 ;
25 CP_NON_PAY_YTD number := 0 ;
26 CP_NET_PAY_CURR number := 0 ;
27 CP_NET_PAY_YTD number := 0 ;
28 CP_EMPLOYEE_CPF_CURR number := 0 ;
29 CP_EMPLOYEE_CPF_YTD number := 0 ;
30 CP_EMPLOYER_CPF_CURR number := 0 ;
31 CP_EMPLOYER_CPF_YTD number := 0 ;
32 CP_TOTAL_CPF_CURR number := 0 ;
33 CP_TOTAL_CPF_YTD number := 0 ;
34 CP_ABS_THIS_PERIOD number;
35 CP_NET_ACCRUAL number;
36 CP_WHERE_CLAUSE varchar2(2000);
37 CP_ORDER_BY varchar2(2000);
38 CP_DISPLAY_EARNINGS varchar2(20);
39 CP_DISPLAY_DEDUCTIONS varchar2(20);
40 CP_DISPLAY_MESSAGES varchar2(20);
41 function cf_gross_pay_currformula(assignment_action_id in number, person_id in number) return number ;
42 function cf_address_line1formula(expense_check_send_to_address in varchar2, person_id in number, location_id in number) return char ;
43 function cf_get_absence_detailsformula(assignment_id_l in number, accrual_plan_id_l in number, period_end_date in date, period_start_date in date, payroll_id_l in number, business_group_id_l in number, effective_date_l in date) return number ;
44 function cf_hourly_rateformula(hours in number, amount in number) return number ;
45 function CF_CURRENCY_FORMAT_MASKFormula return Char ;
46 function CF_PERCENT_FORMAT_MASKFormula return Char ;
47 function CF_HOURS_FORMAT_MASKFormula return Char ;
48 function CF_RATE_FORMAT_MASKFormula return Char ;
49 function CF_FX_RATE_FORMAT_MASKFormula return Char ;
50 function BeforeReport return boolean ;
51 PROCEDURE construct_where_clause ;
52 PROCEDURE construct_order_by ;
53 function AfterReport return boolean ;
54 function cf_1formula(ELEMENT_REPORTING_NAME in varchar2) return char ;
55 function cf_deductions_existformula(ELEMENT_REPORTING_NAME1 in varchar2) return char ;
56 function cf_messages_existformula(PAY_ADVICE_MESSAGE in varchar2) return char ;
57 function cf_fx_amountformula(exchange_rate in number, amount in number) return number ;
58 Function CP_ADDRESS_LINE2_p return varchar2;
59 Function CP_ADDRESS_LINE3_p return varchar2;
60 Function CP_TOWN_p return varchar2;
61 Function CP_POST_CODE_p return varchar2;
62 Function CP_COUNTRY_p return varchar2;
63 Function CP_GROSS_PAY_YTD_p return number;
64 Function CP_STAT_DED_CURR_p return number;
65 Function CP_STAT_DED_YTD_p return number;
66 Function CP_OTHER_CURR_p return number;
67 Function CP_OTHER_YTD_p return number;
68 Function CP_NON_PAY_CURR_p return number;
69 Function CP_NON_PAY_YTD_p return number;
70 Function CP_NET_PAY_CURR_p return number;
71 Function CP_NET_PAY_YTD_p return number;
72 Function CP_EMPLOYEE_CPF_CURR_p return number;
73 Function CP_EMPLOYEE_CPF_YTD_p return number;
74 Function CP_EMPLOYER_CPF_CURR_p return number;
75 Function CP_EMPLOYER_CPF_YTD_p return number;
76 Function CP_TOTAL_CPF_CURR_p return number;
77 Function CP_TOTAL_CPF_YTD_p return number;
78 Function CP_ABS_THIS_PERIOD_p return number;
79 Function CP_NET_ACCRUAL_p return number;
80 Function CP_WHERE_CLAUSE_p return varchar2;
81 Function CP_ORDER_BY_p return varchar2;
82 Function CP_DISPLAY_EARNINGS_p return varchar2;
83 Function CP_DISPLAY_DEDUCTIONS_p return varchar2;
84 Function CP_DISPLAY_MESSAGES_p return varchar2;
85 END PAY_PAYSGSOE_XMLP_PKG;