1 PACKAGE PAY_ASSIGNMENT_ACTIONS_PKG AS
2 /* $Header: pyasa01t.pkh 120.1 2007/01/22 14:54:52 alogue noship $ */
3 /*
4
5 PRODUCT
6 Oracle*Payroll
7 --
8 NAME
9 pyasa01t.pkb
10 --
11 DESCRIPTION
12 Contains routines used to support the Assignment level windows in the
13 Payroll Process Results window.
14 --
15 MODIFIED (DD-MON-YYYY)
16 dkerr 40.0 02-NOV-1993 Created
17 dkerr 40.4 11-APP-1996 Added get_action_status and
18 get_payment_status to support
19 void payments process.
20 J ALLOUN 30-JUL-1996 Added error handling.
21 ccarter 12-OCT-1999 Bug 1027169, removed pragma
22 restriction from get_action_status
23 Ed Jones 16-JAN-2002 Added ability to switch off the
24 get_action_status function to
25 improve query performance in
26 PAYWSACT
27 Ed Jones 03-MAY-2002 Added dbdrv commands and commit
28 M.Reid 115.5 29-MAY-2003 Added get_payment_status_code
29 function for bug 2976050
30 A.Logue 115.6 13-JUN-2003 Added message_line_exists
31 function for 2981945
32 A.Logue 115.7 22-JAN-2007 Added archive_assignment_start_date
33 and archive_person_start_date.
34 */
35 --
36 --
37 procedure update_row(p_rowid in varchar2,
38 p_action_status in varchar2 ) ;
39
40 procedure delete_row ( p_rowid in varchar2 ) ;
41 --
42 procedure lock_row (p_rowid in varchar2,
43 p_action_status in varchar2 ) ;
44 --
45 -- Name
46 -- get_action_status
47 -- Purpose
48 -- Returns the assignment action status for use in the Assignment Process
49 -- results window.
50 -- The action status is displayed as it is unless the action is part of
51 -- a ChequeWriter process in which case it is displayed as 'Void' if the
52 -- action has been voided by Void Payments process.
53 --
54 function get_action_status ( p_assignment_action_id in number,
55 p_action_type in varchar2,
56 p_action_status in varchar2 ) return varchar2 ;
57 --pragma restrict_references ( get_action_status , WNDS , WNPS ) ;
58 --
59 -- Switch on/off the get_action_status function so that it can be deferred when
60 -- the form (PAYWSACT) fetches from the view and then 'manually' populated
61 -- for each row via the POST-QUERY trigger
62 procedure enable_action_status;
63 procedure disable_action_status;
64 function action_status_enabled return varchar2;
65 --
66 -- Name
67 -- get_payment_status
68 -- Purpose
69 -- Returns the Pre-Payments status for use in the Pre-Payments window
70 -- There are three statuses :
71 -- Paid - There exists a complete check action which is not voided.
72 -- Void - There exists a completed check action but which are all voided.
73 -- UnPaid - There are no completed check actions for the pre-payment.
74 --
75 function get_payment_status_code ( p_assignment_action_id in number,
76 p_pre_payment_id in number )
77 return varchar2 ;
78
79 function get_payment_status ( p_assignment_action_id in number,
80 p_pre_payment_id in number )
81 return varchar2 ;
82 --pragma restrict_references ( get_payment_status , WNDS , WNPS ) ;
83
84 --
85 -- Name
86 -- message_line_exists
87 -- Purpose
88 -- Returns whether a line exists in pay_message_lines for the passed assignment action
89 --
90 function message_line_exists (p_assignment_action_id in number)
91 return varchar2;
92
93 --
94 -- Functions to get assignemnt and person start dates : archives may process end-dated
95 -- or future started assignments
96 --
97 function archive_assignment_start_date( p_assignment_id in number,
98 p_effective_date in date )
99 return date;
100
101 function archive_person_start_date( p_person_id in number,
102 p_effective_date in date )
103 return date;
104
105 END PAY_ASSIGNMENT_ACTIONS_PKG;