1 PACKAGE igf_se_payment_int_pkg AS
2 /* $Header: IGFSI03S.pls 120.0 2005/06/01 12:49:09 appldev noship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL spec for package: IGF_SE_PAYMENT_INT_PKG
11 | |
12 | NOTES |
13 | |
14 | This package has a flag on the end of some of the procedures called |
15 | X_MODE. Pass either 'R' for runtime, or 'I' for Install-time. |
16 | This will control how the who columns are filled in; If you are |
17 | running in runtime mode, they are taken from the profiles, whereas in |
18 | install-time mode they get defaulted with special values to indicate |
19 | that they were inserted by datamerge. |
20 | |
21 | The ADD_ROW routine will see whether a row exists by selecting |
22 | based on the primary key, and updates the row if it exists, |
23 | or inserts the row if it doesn't already exist. |
24 | |
25 | This module is called by AutoInstall (afplss.drv) on install and |
26 | upgrade. The WHENEVER SQLERROR and EXIT (at bottom) are required. |
27 | |
28 | HISTORY |
29 | veramach July 2004 Obsoleted ld_cal_type,ld_sequence_number,|
30 | hrs_worked |
31 *=======================================================================*/
32
33 PROCEDURE insert_row (
34 x_rowid IN OUT NOCOPY VARCHAR2,
35 x_transaction_id IN OUT NOCOPY NUMBER,
36 x_batch_id IN NUMBER,
37 x_payroll_id IN NUMBER,
38 x_payroll_date IN DATE,
39 x_auth_id IN NUMBER,
40 x_person_id IN NUMBER,
41 x_fund_id IN NUMBER,
42 x_paid_amount IN NUMBER,
43 x_org_unit_cd IN VARCHAR2,
44 x_status IN VARCHAR2,
45 x_error_code IN VARCHAR2,
46 x_mode IN VARCHAR2 DEFAULT 'R'
47 );
48
49 PROCEDURE lock_row (
50 x_rowid IN VARCHAR2,
51 x_transaction_id IN NUMBER,
52 x_batch_id IN NUMBER,
53 x_payroll_id IN NUMBER,
54 x_payroll_date IN DATE,
55 x_auth_id IN NUMBER,
56 x_person_id IN NUMBER,
57 x_fund_id IN NUMBER,
58 x_paid_amount IN NUMBER,
59 x_org_unit_cd IN VARCHAR2,
60 x_status IN VARCHAR2,
61 x_error_code IN VARCHAR2
62 );
63
64 PROCEDURE update_row (
65 x_rowid IN VARCHAR2,
66 x_transaction_id IN NUMBER,
67 x_batch_id IN NUMBER,
68 x_payroll_id IN NUMBER,
69 x_payroll_date IN DATE,
70 x_auth_id IN NUMBER,
71 x_person_id IN NUMBER,
72 x_fund_id IN NUMBER,
73 x_paid_amount IN NUMBER,
74 x_org_unit_cd IN VARCHAR2,
75 x_status IN VARCHAR2,
76 x_error_code IN VARCHAR2,
77 x_mode IN VARCHAR2 DEFAULT 'R'
78 );
79
80 PROCEDURE add_row (
81 x_rowid IN OUT NOCOPY VARCHAR2,
82 x_transaction_id IN OUT NOCOPY NUMBER,
83 x_batch_id IN NUMBER,
84 x_payroll_id IN NUMBER,
85 x_payroll_date IN DATE,
86 x_auth_id IN NUMBER,
87 x_person_id IN NUMBER,
88 x_fund_id IN NUMBER,
89 x_paid_amount IN NUMBER,
90 x_org_unit_cd IN VARCHAR2,
91 x_status IN VARCHAR2,
92 x_error_code IN VARCHAR2,
93 x_mode IN VARCHAR2 DEFAULT 'R'
94 );
95
96 PROCEDURE delete_row (
97 x_rowid IN VARCHAR2
98 );
99
100 PROCEDURE check_constraints (
101 column_name IN VARCHAR2 DEFAULT NULL,
102 column_value IN VARCHAR2 DEFAULT NULL
103 );
104
105 FUNCTION get_pk_for_validation (
106 x_transaction_id IN NUMBER
107 ) RETURN BOOLEAN;
108
109 FUNCTION get_uk_for_validation (
110 x_payroll_id IN NUMBER,
111 x_auth_id IN NUMBER
112 ) RETURN BOOLEAN;
113
114 PROCEDURE before_dml (
115 p_action IN VARCHAR2,
116 x_rowid IN VARCHAR2 DEFAULT NULL,
117 x_transaction_id IN NUMBER DEFAULT NULL,
118 x_batch_id IN NUMBER DEFAULT NULL,
119 x_payroll_id IN NUMBER DEFAULT NULL,
120 x_payroll_date IN DATE DEFAULT NULL,
121 x_auth_id IN NUMBER DEFAULT NULL,
122 x_person_id IN NUMBER DEFAULT NULL,
123 x_fund_id IN NUMBER DEFAULT NULL,
124 x_paid_amount IN NUMBER DEFAULT NULL,
125 x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
126 x_status IN VARCHAR2 DEFAULT NULL,
127 x_error_code IN VARCHAR2 DEFAULT NULL,
128 x_creation_date IN DATE DEFAULT NULL,
129 x_created_by IN NUMBER DEFAULT NULL,
130 x_last_update_date IN DATE DEFAULT NULL,
131 x_last_updated_by IN NUMBER DEFAULT NULL,
132 x_last_update_login IN NUMBER DEFAULT NULL
133 );
134
135 END igf_se_payment_int_pkg;