1 package pay_au_payment_summary_report as
2 /* $Header: pyaupsrp.pkh 120.1.12010000.1 2008/07/27 22:06:16 appldev ship $*/
3
4 /*
5 *** ------------------------------------------------------------------------+
6 *** Program: pay_au_payment_summary_reprot (Package Specification)
7 *** Description: Procedures to assist Processing of Payment Summary
8 *** Self Printed Report and ETP Payment Summary Self
9 *** Printed Report.
10 *** Change History
11 ***
12 *** Date Changed By Version Description of Change
13 *** --------- ---------- ------- ----------------------------------------+
14 *** 30 MAR 01 kaverma 1.0 Initial version
15 *** 28 NOV 01 nnaresh 1.1 Updated for GSCC Standards
16 *** 03 DEC 02 Ragovind 1.2 Added NOCOPY for the function range_code.
17 *** 03 Jan 06 abhargav 1.3 4726357 Added function to get the self serivce option.
18 *** ------------------------------------------------------------------------+
19
20 *** R12 VERSIONS Change History
21 ***
22 *** Date Changed By Version Description of Change
23 *** --------- ---------- ------- ----------------------------------------+
24 *** 24 APR 06 abhargav 12.1 5174524 Copy of Version 115.03. R12 Fix for Bug 4726357
25 ***
26 */
27
28 ---------------------------------------------------------------------------
29 -- These are PUBLIC procedures and are required by the Payroll Archive
30 -- Reeporter process.
31 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that the
32 -- Payroll Archive Reeporter process knows what code to execute for each
33 -- step of the report.
34 --------------------------------------------------------------------------
35
36 --------------------------------------------------------------------------
37 -- This procedure returns a sql string to select a range
38 -- of assignments eligible for archive report process.
39 --------------------------------------------------------------------------
40 procedure range_code
41 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
42 p_sql out NOCOPY varchar2);
43
44
45
46 --------------------------------------------------------------------------
47 -- This procedure further restricts the assignment_id's
48 -- returned by range_code and locks the Assignment Actions for which
49 -- a Payment Summry Report has been printed.
50 -------------------------------------------------------------------------
51 procedure assignment_action_code
52 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
53 p_start_person_id in per_all_people_f.person_id%type,
54 p_end_person_id in per_all_people_f.person_id%type,
55 p_chunk in number);
56
57
58
59 ---------------------------------------------------------------------------
60 -- This Procedure Actually Calls the Payment Summary Report.
61 ---------------------------------------------------------------------------
62 procedure spawn_archive_reports;
63
64 ---
65 -- Bug 4726357 Added to check whether Self Service Option is enabled for the employee
66 ---
67 function ss_pref(p_assignemnt_id per_assignments_f.assignment_id%type) return varchar2;
68
69 end pay_au_payment_summary_report;