1 package gms_encumbrance_items_pkg AUTHID CURRENT_USER as
2 /* $Header: GMSTITMS.pls 115.8 2002/11/28 07:10:01 mmalhotr ship $ */
3
4
5 procedure insert_row (x_rowid in out NOCOPY VARCHAR2 ,
6 x_encumbrance_item_id in out NOCOPY NUMBER,
7 x_last_update_date in DATE,
8 x_last_updated_by in NUMBER,
9 x_creation_date in DATE,
10 x_created_by in NUMBER,
11 x_encumbrance_id in NUMBER,
12 x_task_id in NUMBER,
13 x_encumbrance_item_date in DATE,
14 x_encumbrance_type in VARCHAR2,
15 x_enc_distributed_flag in VARCHAR2,
16 x_amount in NUMBER DEFAULT NULL,
17 x_override_to_organization_id in NUMBER DEFAULT NULL,
18 x_adjusted_encumbrance_item_id in NUMBER DEFAULT NULL,
19 x_net_zero_adjustment_flag in VARCHAR2 DEFAULT NULL,
20 x_transferred_from_enc_item_id in NUMBER DEFAULT NULL,
21 x_last_update_login in NUMBER DEFAULT NULL,
22 x_request_id in NUMBER DEFAULT NULL,
23 x_attribute_category in VARCHAR2 DEFAULT NULL,
24 x_attribute1 in VARCHAR2 DEFAULT NULL,
25 x_attribute2 in VARCHAR2 DEFAULT NULL,
26 x_attribute3 in VARCHAR2 DEFAULT NULL,
27 x_attribute4 in VARCHAR2 DEFAULT NULL,
28 x_attribute5 in VARCHAR2 DEFAULT NULL,
29 x_attribute6 in VARCHAR2 DEFAULT NULL,
30 x_attribute7 in VARCHAR2 DEFAULT NULL,
31 x_attribute8 in VARCHAR2 DEFAULT NULL,
32 x_attribute9 in VARCHAR2 DEFAULT NULL,
33 x_attribute10 in VARCHAR2 DEFAULT NULL,
34 x_orig_transaction_reference in VARCHAR2 DEFAULT NULL,
35 x_transaction_source in VARCHAR2 DEFAULT NULL,
36 x_project_id in NUMBER DEFAULT NULL,
37 x_source_encumbrance_item_id in NUMBER DEFAULT NULL,
38 x_job_id in NUMBER DEFAULT NULL,
39 x_system_linkage_function in VARCHAR2,
40 x_denom_currency_code in VARCHAR2 DEFAULT NULL,
41 x_denom_raw_amount in NUMBER DEFAULT NULL,
42 x_acct_exchange_rounding_limit in NUMBER DEFAULT NULL,
43 x_acct_currency_code in VARCHAR2 DEFAULT NULL,
44 x_acct_rate_date in DATE DEFAULT NULL,
45 x_acct_rate_type in VARCHAR2 DEFAULT NULL,
46 x_acct_exchange_rate in NUMBER DEFAULT NULL,
47 x_acct_raw_cost in NUMBER DEFAULT NULL,
48 x_project_currency_code in VARCHAR2 DEFAULT NULL,
49 x_project_rate_date in DATE DEFAULT NULL,
50 x_project_rate_type in VARCHAR2 DEFAULT NULL,
51 x_project_exchange_rate in NUMBER DEFAULT NULL,
52 x_encumbrance_comment in VARCHAR2 DEFAULT NULL,
53 x_org_id in NUMBER ,
54 x_denom_tp_currency_code in VARCHAR2 DEFAULT NULL,
55 x_denom_transfer_price in NUMBER DEFAULT NULL,
56 x_person_id in NUMBER DEFAULT NULL,
57 x_incurred_by_person_id in NUMBER DEFAULT NULL,
58 x_ind_compiled_set_id in NUMBER DEFAULT NULL,
59 x_pa_date in DATE DEFAULT NULL,
60 x_gl_date in DATE DEFAULT NULL,
61 x_line_num in NUMBER DEFAULT 1,
62 x_burden_sum_dest_run_id in NUMBER DEFAULT NULL,
63 x_burden_sum_source_run_id in NUMBER DEFAULT NULL) ;
64
65
66 procedure update_row (x_rowid in VARCHAR2,
67 x_encumbrance_item_id in NUMBER,
68 x_last_update_date in DATE,
69 x_last_updated_by in NUMBER,
70 x_encumbrance_id in NUMBER,
71 x_task_id in NUMBER,
72 x_encumbrance_item_date in DATE,
73 x_encumbrance_type in VARCHAR2,
74 x_enc_distributed_flag in VARCHAR2,
75 x_amount in NUMBER,
76 x_override_to_organization_id in NUMBER,
77 x_adjusted_encumbrance_item_id in NUMBER,
78 x_net_zero_adjustment_flag in VARCHAR2,
79 x_transferred_from_enc_item_id in NUMBER,
80 x_last_update_login in NUMBER,
81 x_attribute_category in VARCHAR2,
82 x_attribute1 in VARCHAR2,
83 x_attribute2 in VARCHAR2,
84 x_attribute3 in VARCHAR2,
85 x_attribute4 in VARCHAR2,
86 x_attribute5 in VARCHAR2,
87 x_attribute6 in VARCHAR2,
88 x_attribute7 in VARCHAR2,
89 x_attribute8 in VARCHAR2,
90 x_attribute9 in VARCHAR2,
91 x_attribute10 in VARCHAR2,
92 x_orig_transaction_reference in VARCHAR2,
93 x_transaction_source in VARCHAR2,
94 x_project_id in NUMBER,
95 x_source_encumbrance_item_id in NUMBER,
96 x_job_id in NUMBER,
97 x_system_linkage_function in VARCHAR2,
98 x_denom_currency_code in VARCHAR2,
99 x_denom_raw_amount in NUMBER ,
100 x_acct_exchange_rounding_limit in NUMBER,
101 x_acct_currency_code in VARCHAR2,
102 x_acct_rate_date in DATE,
103 x_acct_rate_type in VARCHAR2,
104 x_acct_exchange_rate in NUMBER,
105 x_acct_raw_cost in NUMBER,
106 x_project_currency_code in VARCHAR2,
107 x_project_rate_date in DATE,
108 x_project_rate_type in VARCHAR2,
109 x_project_exchange_rate in NUMBER ,
110 x_encumbrance_comment in VARCHAR2,
111 x_pa_date in DATE,
112 x_gl_date in DATE );
113 /*
114 x_denom_tp_currency_code in VARCHAR2,
115 x_denom_transfer_price in NUMBER ,
116 x_person_id in NUMBER,
117 x_incurred_by_person_id in NUMBER,
118 x_ind_compiled_set_id in NUMBER,
119 x_line_num in NUMBER,
120 x_burden_sum_dest_run_id in NUMBER,
121 x_burden_sum_source_run_id in NUMBER) ;
122 */
123 -- overload delete_row to tkae both rowid or enc_id as arguments
124 procedure delete_row (x_encumbrance_item_id in NUMBER);
125 procedure delete_row (x_rowid in VARCHAR2);
126
127 procedure lock_row (x_rowid in VARCHAR2);
128
129 END gms_encumbrance_items_pkg;