1 package gms_encumbrance_groups_pkg as
2 /* $Header: GMSEGRPS.pls 120.2 2007/02/06 09:46:56 rshaik ship $ */
3
4 /* Table handler procedures */
5
6 procedure insert_row (x_rowid in out NOCOPY VARCHAR2,
7 x_encumbrance_group in VARCHAR2,
8 x_last_update_date in DATE,
9 x_last_updated_by in NUMBER,
10 x_creation_date in DATE,
11 x_created_by in NUMBER,
12 x_encumbrance_group_status in VARCHAR2,
13 x_encumbrance_ending_date in DATE,
14 x_system_linkage_function in VARCHAR2,
15 x_control_count in NUMBER DEFAULT NULL,
16 x_control_total_amount in NUMBER DEFAULT NULL,
17 x_description in VARCHAR2 DEFAULT NULL,
18 x_last_update_login in NUMBER DEFAULT NULL,
19 x_transaction_source in VARCHAR2 DEFAULT NULL,
20 x_org_id in NUMBER,
21 x_request_id IN NUMBER DEFAULT NULL); /*Bug 5689213*/
22
23 procedure update_row (x_rowid in VARCHAR2,
24 x_encumbrance_group in VARCHAR2,
25 x_last_update_date in DATE,
26 x_last_updated_by in NUMBER,
27 x_encumbrance_group_status in VARCHAR2,
28 x_encumbrance_ending_date in DATE,
29 x_system_linkage_function in VARCHAR2,
30 x_control_count in NUMBER,
31 x_control_total_amount in NUMBER,
32 x_description in VARCHAR2,
33 x_last_update_login in NUMBER,
34 x_transaction_source in VARCHAR2);
35
36
37 procedure delete_row (x_rowid in VARCHAR2);
38
39 procedure lock_row (x_rowid in VARCHAR2);
40
41
42 /* Procedures to change the status of an encumbrance group */
43
44
45 -- Possible error codes for submit:
46 -- submit_only_working
47 -- control_amounts_must_match
48 -- exp_items_must_exist
49 -- no_null_quantity
50
51 procedure submit (x_encumbrance_group in VARCHAR2,
52 x_err_code in out NOCOPY NUMBER,
53 x_return_status in out NOCOPY VARCHAR2);
54
55 procedure release (x_encumbrance_group in VARCHAR2,
56 x_err_code in out NOCOPY NUMBER,
57 x_return_status in out NOCOPY VARCHAR2);
58
59 procedure rework (x_encumbrance_group in VARCHAR2,
60 x_err_code in out NOCOPY NUMBER,
61 x_return_status in out NOCOPY VARCHAR2);
62
63 END gms_encumbrance_groups_pkg;