[Home] [Help]
PACKAGE: APPS.PAY_ORG_PAY_METH_USAGES_F_PKG
Source
1 PACKAGE PAY_ORG_PAY_METH_USAGES_F_PKG AUTHID CURRENT_USER as
2 /* $Header: pyopu01t.pkh 115.1 2002/12/16 18:38:48 dsaxby ship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9 Name
10 pay_org_pay_meth_usages_f_pkg
11 Purpose
12 Supports the OPU block in the form PAYWSDPG (Define Payroll).
13 Notes
14
15 History
16 16-Dec-02 D.E.Saxby 115.1 Bug 2692195 - nocopy changes.
17 31-Jan-95 J.S.Hobbs 40.4 Removed aol WHO columns.
18 11-Mar-94 J.S.Hobbs 40.0 Date created.
19 ============================================================================*/
20 --
21 -----------------------------------------------------------------------------
22 -- Name --
23 -- opmu_end_date --
24 -- Purpose --
25 -- Returns the date effective end date of an OPMU that is about to be --
26 -- created. This takes into account future opmu's and also the end date --
27 -- of the opm. --
28 -- Arguments --
29 -- See below. --
30 -- Notes --
31 -- --
32 -----------------------------------------------------------------------------
33 --
34 function opmu_end_date
35 (
36 p_org_pay_method_usage_id number,
37 p_payroll_id number,
38 p_org_payment_method_id number,
39 p_session_date date,
40 p_validation_start_date date
41 ) return date;
42 --
43 -----------------------------------------------------------------------------
44 -- Name --
45 -- validate_delete_opmu --
46 -- Purpose --
47 -- Checks to see if it is valid to delete the opmu. --
48 -- Arguments --
49 -- See below. --
50 -- Notes --
51 -- --
52 -----------------------------------------------------------------------------
53 --
54 procedure validate_delete_opmu
55 (
56 p_payroll_id number,
57 p_org_payment_method_id number,
58 p_effective_start_date date,
59 p_effective_end_date date,
60 p_dt_delete_mode varchar2,
61 p_validation_start_date date,
62 p_validation_end_date date
63 );
64 --
65 -----------------------------------------------------------------------------
66 -- Name --
67 -- Insert_Row --
68 -- Purpose --
69 -- Table handler procedure that supports the insert of an OPMU via the --
70 -- Define Payroll form. --
71 -- Arguments --
72 -- See below. --
73 -- Notes --
74 -- --
75 -----------------------------------------------------------------------------
76 --
77 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
78 X_Org_Pay_Method_Usage_Id IN OUT NOCOPY NUMBER,
79 X_Effective_Start_Date DATE,
80 X_Effective_End_Date IN OUT NOCOPY DATE,
81 X_Payroll_Id NUMBER,
82 X_Org_Payment_Method_Id NUMBER);
83 --
84 -----------------------------------------------------------------------------
85 -- Name --
86 -- Lock_Row --
87 -- Purpose --
88 -- Table handler procedure that supports the insert , update and delete --
89 -- of a formula by applying a lock on a formula in the Define Payroll --
90 -- form. --
91 -- Arguments --
92 -- See below. --
93 -- Notes --
94 -- None. --
95 -----------------------------------------------------------------------------
96 --
97 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
98 X_Org_Pay_Method_Usage_Id NUMBER,
99 X_Effective_Start_Date DATE,
100 X_Effective_End_Date DATE,
101 X_Payroll_Id NUMBER,
102 X_Org_Payment_Method_Id NUMBER);
103 --
104 -----------------------------------------------------------------------------
105 -- Name --
106 -- Update_Row --
107 -- Purpose --
108 -- Table handler procedure that supports the update of an OPMU via the --
109 -- Define Payroll form. --
110 -- Arguments --
111 -- See below. --
112 -- Notes --
113 -- None. --
114 -----------------------------------------------------------------------------
115 --
116 PROCEDURE Update_Row(X_Rowid VARCHAR2,
117 X_Org_Pay_Method_Usage_Id NUMBER,
118 X_Effective_Start_Date DATE,
119 X_Effective_End_Date DATE,
120 X_Payroll_Id NUMBER,
121 X_Org_Payment_Method_Id NUMBER);
122 --
123 -----------------------------------------------------------------------------
124 -- Name --
125 -- Delete_Row --
126 -- Purpose --
127 -- Table handler procedure that supports the delete of a OPMU via the --
128 -- Define Payroll form. --
129 -- Arguments --
130 -- See below. --
131 -- Notes --
132 -- --
133 -----------------------------------------------------------------------------
134 --
135 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
136 --
137 END PAY_ORG_PAY_METH_USAGES_F_PKG;