1 package pay_au_payment_summary as
2 /* $Header: pyaupsp.pkh 120.1.12010000.2 2008/08/06 06:52:57 ubhat ship $ */
3
4 level_cnt number;
5 pkg_lump_sum_c_def_bal_id number;
6 g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type;
7 --
8 type r_allowance_bal is record (balance_name pay_balance_types.balance_name%type, balance_value number);
9 type tab_allownace_balance is table of r_allowance_bal index by binary_integer;
10 t_allowance_balance tab_allownace_balance;
11 t_union_table tab_allownace_balance;
12 --
13
14 /* Bug 6470581 - Added the payment summary type global variable */
15 g_payment_summary_type VARCHAR2(10);
16
17 function adjust_retro_allowances
18 (t_allowance_balance in out nocopy tab_allownace_balance
19 ,p_year_start in date
20 ,p_year_end in date
21 ,p_assignment_id in pay_assignment_actions.assignment_id%type
22 ,p_registered_employer in number --2610141
23 )
24 return number;
25 --
26 --------------------------------------------------------------------
27 -- These are PUBLIC procedures are required by the Archive process.
28 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
29 -- the archive process knows what code to execute for each step of
30 -- the archive.
31 --------------------------------------------------------------------
32 --
33 --------------------------------------------------------------------
34 -- This procedure returns a sql string to select a range
35 -- of assignments eligible for archival.
36 --------------------------------------------------------------------
37 --
38 procedure range_code
39 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
40 p_sql out nocopy varchar2);
41 --
42 --------------------------------------------------------------------
43 -- This procedure is used to set global contexts
44 -- however in current case it is a dummy procedure. In case this
45 -- procedure is not present then archiver assumes that
46 -- no archival is required.
47 --------------------------------------------------------------------
48 --
49 procedure initialization_code
50 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
51 --
52 --------------------------------------------------------------------
53 -- This procedure further restricts the assignment_id's
54 -- returned by range_code
55 --------------------------------------------------------------------
56 --
57 procedure assignment_action_code
58 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
59 p_start_person_id in per_all_people_f.person_id%type,
60 p_end_person_id in per_all_people_f.person_id%type,
61 p_chunk in number);
62
63
64 --------------------------------------------------------------------
65 -- This procedure is actually used to archive data . It
66 -- internally calls private procedures to archive balances ,
67 -- employee details, employer details and supplier details .
68 --------------------------------------------------------------------
69 procedure archive_code
70 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
71 p_effective_date in date);
72
73
74
75 --------------------------------------------------------------------
76 -- These procedures are used by validation report
77 -- Called from
78 -- PYAUPSVR.rdf
79 -- PYAUPSSP.rdf
80 -- PYAUPSET.rdf
81
82 --------------------------------------------------------------------
83 -- This function is used to get end of year values for archive items
84 --------------------------------------------------------------------
85
86 function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,
87 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
88 return varchar2;
89
90 procedure spawn_data_file -- (Bug 3132178) Created to call magtape process
91 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
92
93 end pay_au_payment_summary;