1 PACKAGE PA_EXP_COPY AUTHID CURRENT_USER AS
2 /* $Header: PAXTEXCS.pls 120.1 2005/08/09 04:53:30 avajain noship $ */
3
4 PROCEDURE ValidateEmp ( X_person_id IN NUMBER
5 , X_date IN DATE
6 , X_status OUT NOCOPY VARCHAR2 );
7
8 PROCEDURE CopyItems ( X_orig_exp_id IN NUMBER
9 , X_new_exp_id IN NUMBER
10 , X_date IN DATE
11 , X_person_id IN NUMBER
12 , P_Inc_By_Org_Id IN NUMBER ); /* Added parameter for enhancement bug 2683803 */
13
14 PROCEDURE preapproved ( copy_option IN VARCHAR2
15 , copy_items IN VARCHAR2
16 , orig_exp_group IN VARCHAR2
17 , new_exp_group IN VARCHAR2
18 , orig_exp_id IN NUMBER
19 , exp_ending_date IN DATE
20 , new_inc_by_person IN NUMBER
21 , userid IN NUMBER
22 , procedure_num_copied IN OUT NOCOPY NUMBER
23 , procedure_num_rejected IN OUT NOCOPY NUMBER
24 , procedure_return_code IN OUT NOCOPY VARCHAR2
25 /** start of bug fix 2329146 **/
26 , p_sys_link_function IN VARCHAR2 default null
27 , p_exp_type_class_code IN VARCHAR2 default 'PT'
28 /** end of bug fix **/
29 , P_Update_Emp_Orgs IN VARCHAR2 default NULL /* Added parameter for bug 2683803 */
30 );
31
32 PROCEDURE online ( orig_exp_id IN NUMBER
33 , new_exp_id IN NUMBER
34 , exp_ending_date IN DATE
35 , X_inc_by_person IN NUMBER
36 , userid IN NUMBER
37 , procedure_return_code IN OUT NOCOPY VARCHAR2 );
38
39 PROCEDURE ReverseExpGroup ( X_orig_exp_group IN VARCHAR2
40 , X_new_exp_group IN VARCHAR2
41 , X_user_id IN NUMBER
42 , X_module IN VARCHAR2
43 , X_num_reversed IN OUT NOCOPY NUMBER
44 , X_num_rejected IN OUT NOCOPY NUMBER
45 , X_return_code IN OUT NOCOPY VARCHAR2
46 , X_expgrp_status IN VARCHAR2 DEFAULT 'WORKING' );
47
48 /* Added function below for Bug 2678790 */
49 Function Check_lcm(P_Lcm_Name IN Pa_Expenditure_Items_All.Labor_Cost_Multiplier_Name%TYPE,
50 P_Ei_Date IN Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE) RETURN VARCHAR2;
51
52 END PA_EXP_COPY;