1 package PA_CINT_RATE_PKG AUTHID CURRENT_USER AS
2 --$Header: PACINTRS.pls 115.1 2003/04/29 00:19:52 riyengar noship $
3 PROCEDURE insert_row_exp_excl (
4 x_rowid in out NOCOPY VARCHAR2
5 ,p_exp_type IN VARCHAR2
6 ,p_org_id IN NUMBER
7 ,p_ind_cost_code IN VARCHAR2
8 ,p_CREATED_BY IN NUMBER
9 ,p_CREATION_DATE IN DATE
10 ,p_LAST_UPDATED_BY IN NUMBER
11 ,p_LAST_UPDATE_DATE IN DATE
12 ,p_LAST_UPDATE_LOGIN IN NUMBER
13 ,x_return_status OUT NOCOPY VARCHAR2
14 ,x_error_msg_code OUT NOCOPY VARCHAR2
15 );
16
17 PROCEDURE update_row_exp_excl
18 (p_rowid IN VARCHAR2
19 ,p_exp_type IN VARCHAR2
20 ,p_org_id IN NUMBER
21 ,p_ind_cost_code IN VARCHAR2
22 ,p_LAST_UPDATED_BY IN NUMBER
23 ,p_LAST_UPDATE_DATE IN DATE
24 ,p_LAST_UPDATE_LOGIN IN NUMBER
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_error_msg_code OUT NOCOPY VARCHAR2
27 );
28 PROCEDURE delete_row_exp_excl (p_ind_cost_code in VARCHAR2
29 ,p_exp_type IN VARCHAR2
30 ,p_org_id IN NUMBER);
31
32 PROCEDURE delete_row_exp_excl (x_rowid in VARCHAR2);
33
34 PROCEDURE insert_row_rate_info (
35 x_rowid in out NOCOPY VARCHAR2
36 ,p_org_id IN NUMBER
37 ,p_ind_cost_code IN VARCHAR2
38 ,p_EXP_ORG_SOURCE IN VARCHAR2
39 ,p_PROJ_AMT_THRESHOLD IN NUMBER
40 ,p_TASK_AMT_THRESHOLD IN NUMBER
41 ,p_PROJ_DURATION_THRESHOLD IN NUMBER
42 ,p_TASK_DURATION_THRESHOLD IN NUMBER
43 ,p_CURR_PERIOD_CONVENTION IN VARCHAR2
44 ,p_INTEREST_CALCULATION_METHOD IN VARCHAR2
45 ,p_THRESHOLD_AMT_TYPE IN VARCHAR2
46 ,p_BUDGET_TYPE_CODE IN VARCHAR2
47 ,p_PERIOD_RATE_CODE IN VARCHAR2
48 ,p_CREATED_BY IN NUMBER
49 ,p_CREATION_DATE IN DATE
50 ,p_LAST_UPDATED_BY IN NUMBER
51 ,p_LAST_UPDATE_DATE IN DATE
52 ,p_LAST_UPDATE_LOGIN IN NUMBER
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_error_msg_code OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE update_row_rate_info
58 (p_rowid IN VARCHAR2
59 ,p_org_id IN NUMBER
60 ,p_ind_cost_code IN VARCHAR2
61 ,p_EXP_ORG_SOURCE IN VARCHAR2
62 ,p_PROJ_AMT_THRESHOLD IN NUMBER
63 ,p_TASK_AMT_THRESHOLD IN NUMBER
64 ,p_PROJ_DURATION_THRESHOLD IN NUMBER
65 ,p_TASK_DURATION_THRESHOLD IN NUMBER
66 ,p_CURR_PERIOD_CONVENTION IN VARCHAR2
67 ,p_INTEREST_CALCULATION_METHOD IN VARCHAR2
68 ,p_THRESHOLD_AMT_TYPE IN VARCHAR2
69 ,p_BUDGET_TYPE_CODE IN VARCHAR2
70 ,p_PERIOD_RATE_CODE IN VARCHAR2
71 ,p_LAST_UPDATED_BY IN NUMBER
72 ,p_LAST_UPDATE_DATE IN DATE
73 ,p_LAST_UPDATE_LOGIN IN NUMBER
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_error_msg_code OUT NOCOPY VARCHAR2
76 );
77 PROCEDURE delete_row_rate_info (p_ind_cost_code in VARCHAR2
78 ,p_org_id IN NUMBER
79 );
80 END PA_CINT_RATE_PKG;