1 package gms_encumbrances_pkg AUTHID CURRENT_USER as
2 /* $Header: GMSTEXPS.pls 115.5 2002/11/26 12:40:13 mmalhotr ship $ */
3
4 procedure insert_row (x_rowid in out NOCOPY VARCHAR2 ,
5 x_encumbrance_id in out NOCOPY NUMBER,
6 x_last_update_date in DATE,
7 x_last_updated_by in NUMBER,
8 x_creation_date in DATE,
9 x_created_by in NUMBER,
10 x_encumbrance_status_code in VARCHAR2,
11 x_encumbrance_ending_date in DATE,
12 x_encumbrance_class_code in VARCHAR2,
13 x_incurred_by_person_id in NUMBER DEFAULT NULL,
14 x_incurred_by_organization_id in NUMBER DEFAULT NULL,
15 x_encumbrance_group in VARCHAR2 DEFAULT NULL,
16 x_control_total_amount in NUMBER DEFAULT NULL,
17 x_entered_by_person_id in NUMBER DEFAULT NULL,
18 x_description in VARCHAR2 DEFAULT NULL,
19 x_initial_submission_date in DATE DEFAULT NULL,
20 x_last_update_login in NUMBER DEFAULT NULL,
21 x_attribute_category in VARCHAR2 DEFAULT NULL,
22 x_attribute1 in VARCHAR2 DEFAULT NULL,
23 x_attribute2 in VARCHAR2 DEFAULT NULL,
24 x_attribute3 in VARCHAR2 DEFAULT NULL,
25 x_attribute4 in VARCHAR2 DEFAULT NULL,
26 x_attribute5 in VARCHAR2 DEFAULT NULL,
27 x_attribute6 in VARCHAR2 DEFAULT NULL,
28 x_attribute7 in VARCHAR2 DEFAULT NULL,
29 x_attribute8 in VARCHAR2 DEFAULT NULL,
30 x_attribute9 in VARCHAR2 DEFAULT NULL,
31 x_attribute10 in VARCHAR2 DEFAULT NULL,
32 x_denom_currency_code in VARCHAR2 DEFAULT NULL,
33 x_acct_currency_code in VARCHAR2 DEFAULT NULL,
34 x_acct_rate_type in VARCHAR2 DEFAULT NULL,
35 x_acct_rate_date in DATE DEFAULT NULL,
36 x_acct_exchange_rate in NUMBER DEFAULT NULL,
37 x_orig_enc_txn_reference1 in VARCHAR2 DEFAULT NULL,
38 x_orig_enc_txn_reference2 in VARCHAR2 DEFAULT NULL,
39 x_orig_enc_txn_reference3 in VARCHAR2 DEFAULT NULL,
40 x_orig_user_enc_txn_reference in VARCHAR2 DEFAULT NULL,
41 x_vendor_id in NUMBER DEFAULT NULL,
42 x_org_id in NUMBER );
43
44 procedure update_row (x_rowid in VARCHAR2,
45 x_encumbrance_id in NUMBER,
46 x_last_update_date in DATE,
47 x_last_updated_by in NUMBER,
48 x_encumbrance_status_code in VARCHAR2,
49 x_encumbrance_ending_date in DATE,
50 x_encumbrance_class_code in VARCHAR2,
51 x_incurred_by_person_id in NUMBER,
52 x_incurred_by_organization_id in NUMBER,
53 x_encumbrance_group in VARCHAR2,
54 x_control_total_amount in NUMBER,
55 x_entered_by_person_id in NUMBER,
56 x_description in VARCHAR2,
57 x_initial_submission_date in DATE,
58 x_last_update_login in NUMBER,
59 x_attribute_category in VARCHAR2,
60 x_attribute1 in VARCHAR2,
61 x_attribute2 in VARCHAR2,
62 x_attribute3 in VARCHAR2,
63 x_attribute4 in VARCHAR2,
64 x_attribute5 in VARCHAR2,
65 x_attribute6 in VARCHAR2,
66 x_attribute7 in VARCHAR2,
67 x_attribute8 in VARCHAR2,
68 x_attribute9 in VARCHAR2,
69 x_attribute10 in VARCHAR2,
70 x_denom_currency_code in VARCHAR2,
71 x_acct_currency_code in VARCHAR2,
72 x_acct_rate_type in VARCHAR2,
73 x_acct_rate_date in DATE,
74 x_acct_exchange_rate in NUMBER,
75 -- Trx_import enhancement
76 x_orig_enc_txn_reference1 in VARCHAR2,
77 x_orig_enc_txn_reference2 in VARCHAR2,
78 x_orig_enc_txn_reference3 in VARCHAR2,
79 x_orig_user_enc_txn_reference in VARCHAR2,
80 x_vendor_id in NUMBER);
81
82 -- overload delete_row to take the rowid or the encumbrance_id
83 procedure delete_row (x_encumbrance_id in NUMBER);
84 procedure delete_row (x_rowid in VARCHAR2);
85
86 procedure lock_row (x_rowid in VARCHAR2);
87
88 END gms_encumbrances_pkg;