[Home] [Help]
PACKAGE: APPS.PAY_PAYSGI21_XMLP_PKG
Source
1 PACKAGE PAY_PAYSGI21_XMLP_PKG AS
2 /* $Header: PAYSGI21S.pls 120.0 2007/12/13 12:13:16 amakrish noship $ */
3 P_business_group_id number;
4 P_person_id number;
5 P_basis_year number;
6 P_ir21_mode varchar2(32767);
7 P_conc_request_id number;
8 P_CR_YEAR_AMOUNT number;
9 P_PR_YEAR_AMOUNT number;
10 LP_business_group_id number;
11 LP_person_id number;
12 LP_basis_year number;
13 LP_ir21_mode varchar2(32767);
14 LP_CR_YEAR_AMOUNT number;
15 LP_PR_YEAR_AMOUNT number;
16 DebugFlag varchar2(1);
17 t_run varchar2(10);
18 CP_outstanding_stocks number;
19 CP_outstanding_no varchar2(20);
20 CP_outstanding_yes varchar2(20);
21 CP_cr_year_amount number;
22 CP_pr_year_amount number;
23 CP_taxable_residence_basis number;
24 CP_taxable_residence_basis_1 number;
25 CP_taxable_residence_basis_2 number;
26 CP_ir21_cessation_from date;
27 CP_ir21_cessation_to date;
28 CP_ir21_cessation_from_1 date;
29 CP_ir21_cessation_to_1 date;
30 CP_ir21_cessation_from_2 date;
31 CP_ir21_cessation_to_2 date;
32 CP_ir21a_employ_from date;
33 CP_ir21a_employ_to date;
34 CP_ir21a_employ_from_1 date;
35 CP_ir21a_employ_to_1 date;
36 CP_ir21a_employ_from_2 date;
37 CP_ir21a_employ_to_2 date;
38 CP_date_premise_from date;
39 CP_date_premise_from_1 date;
40 CP_date_premise_from_2 date;
41 CP_date_premise_to date;
42 CP_date_premise_to_1 date;
43 CP_date_premise_to_2 date;
44 CP_days_occupying_premise varchar2(20);
45 CP_days_occupying_premise_1 varchar2(20);
46 CP_days_occupying_premise_2 varchar2(20);
47 CP_emps_sharing_premise varchar2(20);
48 CP_emps_sharing_premise_1 varchar2(20);
49 CP_emps_sharing_premise_2 varchar2(20);
50 CP_child_seq number;
51 function CF_business_group_nameFormula return Char ;
52 --function cf_ir21a_total_basisformula(CS_ir21a_furniture_bas ;
53 function cf_ir21a_total_basisformula(CS_ir21a_furniture_basis in number, CS_ir21a_furniture_basis_sub in number, CS_ir21a_hotel_basis in number, CS_ir21a_others_basis in number) return number;
54 function cf_ir21a_total_basis_1formula(CS_ir21a_furniture_basis_1 in number, CS_ir21a_furniture_basis_sub1 in number, CS_ir21a_hotel_basis_1 in number, CS_ir21a_others_basis_1 in number) return number ;
55 --function cf_taxable_value_residenceform(CS_ir21_income_bas ;
56 function cf_taxable_value_residenceform(CS_ir21_income_basis in number, CS_ir21_others_basis in number, CS_ir21a_furniture_basis in number, CS_ir21a_others_basis in number, CS_a8a_moa_501_basis in number,
57 CS_a8a_moa_502_basis in number, CS_ir21_income_basis_1 in number, CS_ir21_others_basis_1 in number, CS_ir21a_furniture_basis_1 in number, CS_ir21a_others_basis_1 in number, CS_a8a_moa_501_basis_1 in number,
58 CS_a8a_moa_502_basis_1 in number) return number;
59 --function cf_ir21_subtotal_basisformula(CS_ir21_others_bas ;
60 function cf_ir21_subtotal_basisformula(CS_ir21_others_basis in number, CF_ir21a_total_basis in number) return number;
61 function cf_ir21_subtotal_basis_1formul(CS_ir21_others_basis_1 in number, CF_ir21a_total_basis_1 in number) return number ;
62 --function cf_ir21_total_basisformula(CS_ir21_income_bas ;
63 function cf_ir21_total_basisformula(CS_ir21_income_basis in number, CS_ir21_others_basis in number, CF_ir21a_total_basis in number) return number;
64 function cf_ir21_total_basis_1formula(CS_ir21_income_basis_1 in number, CS_ir21_others_basis_1 in number, CF_ir21a_total_basis_1 in number) return number ;
65 function cf_ir21_cessation_datesformula(date_start in date, actual_termination_date in date) return number ;
66 function CF_ir21_dateFormula return Date ;
67 function CF_child_seqFormula return Number ;
68 function BeforeReport return boolean ;
69 function AfterReport return boolean ;
70 function cf_end_of_reportformula(cs_no_data_exists in number) return char ;
71 --function cf_ir21_totalformula(CF_ir21_total_bas ;
72 function cf_ir21_totalformula(CF_ir21_total_basis in number, CF_ir21_total_basis_1 in number) return number;
73 --function cf_pay_basisformula(organization_id in varchar2, person_id in number, actual_termination_date in date) return char ;
74 function cf_pay_basisformula(organization_id_v in varchar2, person_id in number, actual_termination_date in date) return char ;
75 function cf_employer_premiseformula(person_id in number) return number ;
76 PROCEDURE set_ir21_date ;
77 function CF_stock_outstandingFormula (date_start in date,actual_termination_date in date,organization_id in varchar2)return Number ;
78 function latest_le(organization_id in varchar2, date_start in date, actual_termination_date in date) return boolean ;
79 function P_CR_YEAR_AMOUNTValidTrigger return boolean ;
80 function P_PR_YEAR_AMOUNTValidTrigger return boolean ;
81 Function CP_outstanding_stocks_p return number;
82 Function CP_outstanding_no_p return varchar2;
83 Function CP_outstanding_yes_p return varchar2;
84 Function CP_cr_year_amount_p return number;
85 Function CP_pr_year_amount_p return number;
86 Function CP_taxable_residence_basis_p return number;
87 Function CP_taxable_residence_basis_1_p return number;
88 Function CP_taxable_residence_basis_2_p return number;
89 Function CP_ir21_cessation_from_p return date;
90 Function CP_ir21_cessation_to_p return date;
91 Function CP_ir21_cessation_from_1_p return date;
92 Function CP_ir21_cessation_to_1_p return date;
93 Function CP_ir21_cessation_from_2_p return date;
94 Function CP_ir21_cessation_to_2_p return date;
95 Function CP_ir21a_employ_from_p return date;
96 Function CP_ir21a_employ_to_p return date;
97 Function CP_ir21a_employ_from_1_p return date;
98 Function CP_ir21a_employ_to_1_p return date;
99 Function CP_ir21a_employ_from_2_p return date;
100 Function CP_ir21a_employ_to_2_p return date;
101 Function CP_date_premise_from_p return date;
102 Function CP_date_premise_from_1_p return date;
103 Function CP_date_premise_from_2_p return date;
104 Function CP_date_premise_to_p return date;
105 Function CP_date_premise_to_1_p return date;
106 Function CP_date_premise_to_2_p return date;
107 Function CP_days_occupying_premise_p return varchar2;
108 Function CP_days_occupying_premise_1_p return varchar2;
109 Function CP_days_occupying_premise_2_p return varchar2;
110 Function CP_emps_sharing_premise_p return varchar2;
111 Function CP_emps_sharing_premise_1_p return varchar2;
112 Function CP_emps_sharing_premise_2_p return varchar2;
113 Function CP_child_seq_p return number;
114 END PAY_PAYSGI21_XMLP_PKG;