DBA Data[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;