1 PACKAGE pay_au_tfn_magtape_flags AUTHID CURRENT_USER AS
2 /* $Header: pyautfnf.pkh 120.0.12010000.3 2009/10/13 13:52:37 dduvvuri ship $*/
3 --------------------------------------------------------------------------+
4
5 --------------------------------------------------------------------------+
6 -- Record type to store the current reporting period's tax
7 -- details field values to be used by the cursor for printing details
8 --------------------------------------------------------------------------+
9
10 TYPE tfn_flags_record IS RECORD
11 (
12 k_assignment_id per_all_assignments_f.assignment_id%TYPE,
13 australian_res_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,
14 tax_free_threshold_flag pay_au_tfn_tax_info_v.tax_free_threshold_flag%TYPE,
15 fta_claim_flag pay_au_tfn_tax_info_v.fta_claim_flag%TYPE,
16 basis_of_payment pay_au_tfn_tax_info_v.basis_of_payment%TYPE,
17 hecs_flag pay_au_tfn_tax_info_v.hecs_flag%TYPE,
18 sfss_flag pay_au_tfn_tax_info_v.sfss_flag%TYPE,
19 declaration_signed_date pay_au_tfn_tax_info_v.declaration_signed_date%TYPE,
20 rebate_flag pay_au_tfn_tax_info_v.rebate_flag%TYPE,
21 tax_file_number pay_au_tfn_tax_info_v.tax_file_number%TYPE,
22 effective_start_date pay_au_tfn_tax_info_v.effective_start_date%TYPE,
23 tfn_for_super pay_payautax_spr_ent_v.tfn_for_super_flag%TYPE,
24 senior_flag pay_au_tfn_tax_info_v.australian_resident_flag%TYPE,/*bug7270073*/
25 current_or_terminated varchar2(1)
26 );
27
28 TYPE tfn_flags_table IS TABLE OF tfn_flags_record INDEX BY BINARY_INTEGER;
29
30 g_tfn_flags_table tfn_flags_table;
31
32
33 --------------------------------------------------------------------------+
34 -- PROCEDURE to populate the plsql table with tax detail field values
35 -- for current reporting period
36 --------------------------------------------------------------------------+
37 PROCEDURE populate_tfn_flags
38 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
39 p_business_group_id in per_business_groups.business_group_id%TYPE,
40 p_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
41 p_report_end_date in date);
42
43
44 --------------------------------------------------------------------------+
45 -- FUNCTION to return the values of the tax details feilds
46 --------------------------------------------------------------------------+
47 FUNCTION get_tfn_flag_values
48 (p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
49 p_flag_name in varchar2) return varchar2;
50
51
52 --------------------------------------------------------------------------+
53 -- Bug 9000052 - Declaration of the new function remove_extra_spaces
54 --------------------------------------------------------------------------+
55
56 FUNCTION remove_extra_spaces(p_str in varchar2) return varchar2;
57
58
59 END PAY_AU_TFN_MAGTAPE_FLAGS;