1 PACKAGE PA_ONLINE_COPY_EXP AUTHID CURRENT_USER AS
2 /* $Header: PAXTRCPS.pls 120.1 2005/08/17 12:57:08 ramurthy noship $ */
3
4 PROCEDURE ValidateEmp ( X_ei_date IN DATE
5 , X_job_id IN OUT NOCOPY NUMBER
6 , X_status IN OUT NOCOPY VARCHAR2 );
7
8 PROCEDURE CopyItems ( X_orig_exp_id IN NUMBER
9 , X_new_exp_id IN NUMBER
10 , X_days_diff IN NUMBER
11 , x_total_exp_copied IN OUT NOCOPY NUMBER);
12
13 PROCEDURE Copy_exp ( orig_exp_id IN NUMBER
14 , old_exp_ending_date IN DATE
15 , new_exp_id IN NUMBER
16 , new_exp_ending_date IN DATE
17 , incurred_by_org_id IN NUMBER
18 , expenditure_class_code IN VARCHAR2
19 , x_exp_status_code IN VARCHAR2
20 , x_exp_source_code IN VARCHAR2
21 , x_copy_exp_type_flag IN VARCHAR2
22 , x_copy_qty_flag IN VARCHAR2
23 , x_copy_cmt_flag IN VARCHAR2
24 , x_copy_dff_flag IN VARCHAR2
25 , x_copy_attachment_flag IN VARCHAR2
26 , X_inc_by_person IN NUMBER
27 , X_entered_by_person_id IN NUMBER
28 , userid IN NUMBER
29 , x_total_exp_copied IN OUT NOCOPY NUMBER);
30
31 PROCEDURE Validate_item (x_project_id IN NUMBER,
32 x_task_id IN NUMBER,
33 x_expenditure_item_date IN DATE,
34 x_expenditure_type IN VARCHAR2,
35 x_sys_link_func IN VARCHAR2,
36 x_quantity IN NUMBER,
37 x_attribute_category IN VARCHAR2,
38 x_attribute1 IN VARCHAR2,
39 x_attribute2 IN VARCHAR2,
40 x_attribute3 IN VARCHAR2,
41 x_attribute4 IN VARCHAR2,
42 x_attribute5 IN VARCHAR2,
43 x_attribute6 IN VARCHAR2,
44 x_attribute7 IN VARCHAR2,
45 x_attribute8 IN VARCHAR2,
46 x_attribute9 IN VARCHAR2,
47 x_attribute10 IN VARCHAR2,
48 x_billable_flag IN OUT NOCOPY VARCHAR2,
49 x_job_id IN OUT NOCOPY NUMBER,
50 temp_outcome IN OUT NOCOPY VARCHAR2);
51
52 FUNCTION EXP_EXISTS_IN_DENORM(x_orig_exp_id IN NUMBER) RETURN VARCHAR2;
53 PRAGMA RESTRICT_REFERENCES (EXP_EXISTS_IN_DENORM, WNDS, WNPS ) ;
54
55 END PA_ONLINE_COPY_EXP;
[Home] [Help]