1 package pa_expenditure_groups_pkg as
2 /* $Header: PAXTGRPS.pls 120.2 2005/08/09 04:53:49 avajain noship $ */
3
4 /* Table handler procedures */
5
6 procedure insert_row (x_rowid in out NOCOPY VARCHAR2,
7 x_expenditure_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_expenditure_group_status in VARCHAR2,
13 x_expenditure_ending_date in DATE,
14 x_system_linkage_function in VARCHAR2,
15 x_control_count in NUMBER,
16 x_control_total_amount in NUMBER,
17 x_description in VARCHAR2,
18 x_last_update_login in NUMBER,
19 x_transaction_source in VARCHAR2,
20 x_period_accrual_flag in VARCHAR2,
21 P_Org_Id In NUMBER); -- 12i MOAC changes
22
23 procedure update_row (x_rowid in VARCHAR2,
24 x_expenditure_group in VARCHAR2,
25 x_last_update_date in DATE,
26 x_last_updated_by in NUMBER,
27 x_expenditure_group_status in VARCHAR2,
28 x_expenditure_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 x_period_accrual_flag in VARCHAR2);
36
37
38 procedure delete_row (x_rowid in VARCHAR2);
39
40 procedure lock_row (x_rowid in VARCHAR2);
41
42
43 /* Procedures to change the status of an expenditure group */
44
45
46 -- Possible error codes for submit:
47 -- submit_only_working
48 -- control_amounts_must_match
49 -- exp_items_must_exist
50 -- no_null_quantity
51
52 procedure submit (x_expenditure_group in VARCHAR2,
53 x_err_code in out NOCOPY NUMBER,
54 x_return_status in out NOCOPY VARCHAR2);
55
56 procedure release (x_expenditure_group in VARCHAR2,
57 x_err_code in out NOCOPY NUMBER,
58 x_return_status in out NOCOPY VARCHAR2);
59
60 procedure rework (x_expenditure_group in VARCHAR2,
61 x_err_code in out NOCOPY NUMBER,
62 x_return_status in out NOCOPY VARCHAR2);
63
64 END pa_expenditure_groups_pkg;