1 PACKAGE igf_se_payment_pkg AS
2 /* $Header: IGFSI02S.pls 120.0 2005/06/01 14:06:21 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_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 | Who When What |
30 | veramach July 2004 Obsoleted ld_cal_type,ld_sequence_number,|
31 | hrs_worked |
32 *=======================================================================*/
33
34 PROCEDURE insert_row (
35 x_rowid IN OUT NOCOPY VARCHAR2,
36 x_transaction_id IN OUT NOCOPY 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_source IN VARCHAR2,
45 x_mode IN VARCHAR2 DEFAULT 'R'
46 );
47
48 PROCEDURE lock_row (
49 x_rowid IN VARCHAR2,
50 x_transaction_id IN NUMBER,
51 x_payroll_id IN NUMBER,
52 x_payroll_date IN DATE,
53 x_auth_id IN NUMBER,
54 x_person_id IN NUMBER,
55 x_fund_id IN NUMBER,
56 x_paid_amount IN NUMBER,
57 x_org_unit_cd IN VARCHAR2,
58 x_source IN VARCHAR2
59 );
60
61 PROCEDURE update_row (
62 x_rowid IN VARCHAR2,
63 x_transaction_id IN NUMBER,
64 x_payroll_id IN NUMBER,
65 x_payroll_date IN DATE,
66 x_auth_id IN NUMBER,
67 x_person_id IN NUMBER,
68 x_fund_id IN NUMBER,
69 x_paid_amount IN NUMBER,
70 x_org_unit_cd IN VARCHAR2,
71 x_source IN VARCHAR2,
72 x_mode IN VARCHAR2 DEFAULT 'R'
73 );
74
75 PROCEDURE add_row (
76 x_rowid IN OUT NOCOPY VARCHAR2,
77 x_transaction_id IN OUT NOCOPY NUMBER,
78 x_payroll_id IN NUMBER,
79 x_payroll_date IN DATE,
80 x_auth_id IN NUMBER,
81 x_person_id IN NUMBER,
82 x_fund_id IN NUMBER,
83 x_paid_amount IN NUMBER,
84 x_org_unit_cd IN VARCHAR2,
85 x_source IN VARCHAR2,
86 x_mode IN VARCHAR2 DEFAULT 'R'
87 );
88
89 PROCEDURE delete_row (
90 x_rowid IN VARCHAR2
91 );
92
93 FUNCTION get_pk_for_validation (
94 x_transaction_id IN NUMBER
95 ) RETURN BOOLEAN;
96
97
98 PROCEDURE get_fk_hz_parties (
99 x_party_id IN NUMBER
100 );
101
102 PROCEDURE before_dml (
103 p_action IN VARCHAR2,
104 x_rowid IN VARCHAR2 DEFAULT NULL,
105 x_transaction_id IN NUMBER DEFAULT NULL,
106 x_payroll_id IN NUMBER DEFAULT NULL,
107 x_payroll_date IN DATE DEFAULT NULL,
108 x_auth_id IN NUMBER DEFAULT NULL,
109 x_person_id IN NUMBER DEFAULT NULL,
110 x_fund_id IN NUMBER DEFAULT NULL,
111 x_paid_amount IN NUMBER DEFAULT NULL,
112 x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
113 x_source IN VARCHAR2 DEFAULT NULL,
114 x_creation_date IN DATE DEFAULT NULL,
115 x_created_by IN NUMBER DEFAULT NULL,
116 x_last_update_date IN DATE DEFAULT NULL,
117 x_last_updated_by IN NUMBER DEFAULT NULL,
118 x_last_update_login IN NUMBER DEFAULT NULL
119 );
120
121 END igf_se_payment_pkg;