1 PACKAGE pa_online_exp_2 AUTHID CURRENT_USER AS
2 /* $Header: PAXTRONS.pls 120.1 2005/08/17 12:57:15 ramurthy noship $ */
3
4 PROCEDURE SUBMIT_EXP( X_exp_id IN NUMBER,
5 X_incurred_by_person_id IN NUMBER,
6 X_exp_status IN VARCHAR,
7 x_user_id IN NUMBER,
8 x_route_to_person_id IN NUMBER,
9 x_routing_comment IN VARCHAR2);
10
11 PROCEDURE UPDATE_ROUTING_REC (x_exp_id IN NUMBER,
12 x_user_id IN NUMBER,
13 x_last_update_login IN NUMBER);
14
15 PROCEDURE DEL_EXP_REC ( x_exp_id IN NUMBER);
16
17 PROCEDURE DEL_ITEM_COMMENTS(x_exp_id IN NUMBER);
18
19 PROCEDURE DEL_ITEMS(x_exp_id IN NUMBER);
20
21 PROCEDURE DEL_ROUTING_RECS(x_exp_id IN NUMBER);
22
23 PROCEDURE DEL_DENORM_RECS(x_exp_id IN NUMBER);
24
25 PROCEDURE CHECK_DFF_REQUIRED(DFF_NAME IN VARCHAR2,
26 DFF_REQUIRED OUT NOCOPY VARCHAR2);
27
28 PROCEDURE SET_DENORM_NET_ZERO_FLAG(x_denorm_id IN NUMBER,
29 x_ei_id IN NUMBER,
30 x_outcome OUT NOCOPY VARCHAR2);
31
32 PROCEDURE ADJUST_COST_IN_DENORM(x_denorm_id IN NUMBER,
33 x_ei_id IN NUMBER,
34 x_cost_rate IN NUMBER,
35 x_raw_cost IN NUMBER,
36 x_outcome OUT NOCOPY VARCHAR2);
37
38 PROCEDURE UPDATE_DATA_IN_EXP_ITEMS (X_exp_id IN NUMBER,
39 X_user IN NUMBER,
40 x_status IN OUT NOCOPY VARCHAR2);
41
42 PROCEDURE UPDATE_EXP_ITEM ( x_exp_id IN NUMBER,
43 x_denorm_id IN NUMBER,
44 x_person_id IN NUMBER,
45 x_project_id IN NUMBER,
46 x_task_id IN NUMBER,
47 x_billable_flag IN VARCHAR2,
48 x_exp_type IN VARCHAR2,
49 x_sys_link_function IN VARCHAR2,
50 x_exp_item_id IN NUMBER,
51 x_exp_item_date IN DATE,
52 x_qty IN NUMBER,
53 x_attrib_cat IN VARCHAR2,
54 x_attrib1 IN VARCHAR2,
55 x_attrib2 IN VARCHAR2,
56 x_attrib3 IN VARCHAR2,
57 x_attrib4 IN VARCHAR2,
58 x_attrib5 IN VARCHAR2,
59 x_attrib6 IN VARCHAR2,
60 x_attrib7 IN VARCHAR2,
61 x_attrib8 IN VARCHAR2,
62 x_attrib9 IN VARCHAR2,
63 x_attrib10 IN VARCHAR2,
64 x_orig_trans_ref IN VARCHAR2,
65 x_adj_exp_item_id IN NUMBER,
66 x_net_zero_adj_flag IN VARCHAR2,
67 x_item_comment IN VARCHAR2,
68 x_job_id IN NUMBER,
69 X_user IN NUMBER,
70 X_status IN OUT NOCOPY VARCHAR2);
71
72 PROCEDURE INSERT_EXP_ITEM ( x_exp_id IN NUMBER,
73 x_denorm_id IN NUMBER,
74 x_person_id IN NUMBER,
75 x_project_id IN NUMBER,
76 x_task_id IN NUMBER,
77 x_billable_flag IN VARCHAR2,
78 x_exp_type IN VARCHAR2,
79 x_sys_link_function IN VARCHAR2,
80 x_exp_item_id IN NUMBER,
81 x_item_date IN DATE,
82 x_qty IN NUMBER,
83 x_attrib_cat IN VARCHAR2,
84 x_attrib1 IN VARCHAR2,
85 x_attrib2 IN VARCHAR2,
86 x_attrib3 IN VARCHAR2,
87 x_attrib4 IN VARCHAR2,
88 x_attrib5 IN VARCHAR2,
89 x_attrib6 IN VARCHAR2,
90 x_attrib7 IN VARCHAR2,
91 x_attrib8 IN VARCHAR2,
92 x_attrib9 IN VARCHAR2,
93 x_attrib10 IN VARCHAR2,
94 x_orig_trans_ref IN VARCHAR2,
95 x_adj_exp_item_id IN NUMBER,
96 x_net_zero_adj_flag IN VARCHAR2,
97 x_item_comment IN VARCHAR2,
98 x_job_id IN NUMBER,
99 X_user IN NUMBER,
100 X_status IN OUT NOCOPY VARCHAR2);
101
102 PROCEDURE Summary_Validation(X_exp_id IN NUMBER,
103 X_inc_by_person_id NUMBER,
104 X_ending_Date IN DATE,
105 X_exp_class_code IN VARCHAR2,
106 x_exp_status IN OUT NOCOPY VARCHAR2,
107 x_comment OUT NOCOPY VARCHAR2);
108
109 PROCEDURE ClearReversedItem(x_adjusted_exp_item_id IN NUMBER);
110
111 PROCEDURE ClearDenormReversedItems(x_denorm_id IN NUMBER,
112 x_qty_1 IN NUMBER,
113 x_qty_2 IN NUMBER,
114 x_qty_3 IN NUMBER,
115 x_qty_4 IN NUMBER,
116 x_qty_5 IN NUMBER,
117 x_qty_6 IN NUMBER,
118 x_qty_7 IN NUMBER,
119 x_adj_ei_id_1 IN NUMBER,
120 x_adj_ei_id_2 IN NUMBER,
121 x_adj_ei_id_3 IN NUMBER,
122 x_adj_ei_id_4 IN NUMBER,
123 x_adj_ei_id_5 IN NUMBER,
124 x_adj_ei_id_6 IN NUMBER,
125 x_adj_ei_id_7 IN NUMBER);
126
127 PROCEDURE InsertExp ( x_row_id IN OUT NOCOPY VARCHAR2,
128 x_exp_id IN NUMBER,
129 x_update_date IN DATE,
130 x_last_updated_by IN NUMBER,
131 x_creation_date IN DATE,
132 x_created_by IN NUMBER,
133 x_status_code IN VARCHAR2,
134 x_ending_date IN DATE,
135 x_class_code IN VARCHAR2,
136 x_inc_by_person_id IN NUMBER,
137 x_inc_by_org_id IN NUMBER,
138 x_entered_by_person_id NUMBER,
139 x_desc IN VARCHAR2,
140 x_last_login IN NUMBER,
141 x_attrib_cat IN VARCHAR2,
142 x_attrib1 IN VARCHAR2,
143 x_attrib2 IN VARCHAR2,
144 x_attrib3 IN VARCHAR2,
145 x_attrib4 IN VARCHAR2,
146 x_attrib5 IN VARCHAR2,
147 x_attrib6 IN VARCHAR2,
148 x_attrib7 IN VARCHAR2,
149 x_attrib8 IN VARCHAR2,
150 x_attrib9 IN VARCHAR2,
151 x_attrib10 IN VARCHAR2,
152 -- Trx_import enhancement:
153 -- These new parameters are needed to populate
154 -- PA_EXPENDITURES_ALL table's new columns
155 x_orig_exp_txn_reference1 IN VARCHAR2 DEFAULT NULL,
156 x_orig_user_exp_txn_reference IN VARCHAR2 DEFAULT NULL,
157 x_vendor_id IN NUMBER DEFAULT NULL,
158 x_orig_exp_txn_reference2 IN VARCHAR2 DEFAULT NULL,
159 x_orig_exp_txn_reference3 IN VARCHAR2 DEFAULT NULL);
160
161 FUNCTION eis_exist(x_exp_id IN NUMBER) RETURN VARCHAR2;
162 PRAGMA RESTRICT_REFERENCES ( eis_exist, WNDS, WNPS ) ;
163
164 PROCEDURE DeleteDenormEIs(x_denorm_id IN NUMBER);
165
166 PROCEDURE ReworkExpRemoveEIs(x_exp_id IN NUMBER);
167
168 PROCEDURE CommentChange( X_exp_item_id IN NUMBER
169 , X_new_comment IN VARCHAR2
170 , X_user IN NUMBER
171 , X_login IN NUMBER
172 , X_status OUT NOCOPY NUMBER );
173
174 END pa_online_exp_2;