1 PACKAGE PA_COSTING AS
2 /* $Header: PAXCOSTS.pls 120.3 2005/09/15 23:46:11 rahariha noship $ */
3
4 PROCEDURE ReverseCdl( X_expenditure_item_id IN NUMBER
5 , X_billable_flag IN VARCHAR2
6 , X_amount IN NUMBER DEFAULT NULL
7 , X_quantity IN NUMBER DEFAULT NULL
8 , X_burdened_cost IN NUMBER DEFAULT NULL
9 , X_dr_ccid IN NUMBER DEFAULT NULL
10 , X_cr_ccid IN NUMBER DEFAULT NULL
11 , X_tr_source_accounted IN VARCHAR2 DEFAULT NULL
12 , X_line_type IN VARCHAR2
13 , X_user IN NUMBER
14 , X_denom_currency_code IN VARCHAR2
15 , X_denom_raw_cost IN NUMBER
16 , X_denom_burden_cost IN NUMBER
17 , X_acct_currency_code IN VARCHAR2
18 , X_acct_rate_date IN DATE
19 , X_acct_rate_type IN VARCHAR2
20 , X_acct_exchange_rate IN NUMBER
21 , X_acct_raw_cost IN NUMBER
22 , X_acct_burdened_cost IN NUMBER
23 , X_project_currency_code IN VARCHAR2
24 , X_project_rate_date IN DATE
25 , X_project_rate_type IN VARCHAR2
26 , X_project_exchange_rate IN NUMBER
27 , P_Projfunc_currency_code IN VARCHAR2 default null
28 , P_Projfunc_cost_rate_date IN DATE default null
29 , P_Projfunc_cost_rate_type IN VARCHAR2 default null
30 , P_Projfunc_cost_exchange_rate IN NUMBER default null
31 , P_project_raw_cost IN NUMBER default null
32 , P_project_burdened_cost IN NUMBER default null
33 , P_Work_Type_Id IN NUMBER default null
34 , X_err_code IN OUT NOCOPY NUMBER
35 , X_err_stage IN OUT NOCOPY VARCHAR2
36 , X_err_stack IN OUT NOCOPY VARCHAR2
37 , p_mode IN VARCHAR2 default 'COSTING'
38 , X_line_num IN NUMBER DEFAULT NULL ) ; -- Bug 4374769 : A new parameter X_line_num is added.
39
40 /*
41 ** PROCEDURE CreateNewCdl( X_expenditure_item_id IN NUMBER
42 ** , X_err_stack IN OUT VARCHAR2 );
43 */
44 -- comment this out since told to not use overloading...
45
46 -- create another spec for CreateNewCdl due to bug 666884.
47
48 PROCEDURE CreateNewCdl( X_expenditure_item_id IN NUMBER
49 , X_amount IN NUMBER
50 , X_dr_ccid IN NUMBER
51 , X_cr_ccid IN NUMBER
52 , X_transfer_status_code IN VARCHAR2
53 , X_quantity IN NUMBER
54 , X_billable_flag IN VARCHAR2
55 , X_request_id IN NUMBER
56 , X_program_application_id IN NUMBER
57 , x_program_id IN NUMBER
58 , x_program_update_date IN DATE
59 , X_pa_date IN DATE
60 , X_recvr_pa_date IN DATE /**CBGA**/
61 , X_gl_date IN DATE
62 , X_transferred_date IN DATE
63 , X_transfer_rejection_reason IN VARCHAR2
64 , X_line_type IN VARCHAR2
65 , X_ind_compiled_set_id IN NUMBER
66 , X_burdened_cost IN NUMBER
67 , X_line_num_reversed IN NUMBER
68 , X_reverse_flag IN VARCHAR2
69 , X_user IN NUMBER
70 , X_err_code IN OUT NOCOPY NUMBER
71 , X_err_stage IN OUT NOCOPY VARCHAR2
72 , X_err_stack IN OUT NOCOPY VARCHAR2
73 , X_project_id IN NUMBER
74 , X_task_id IN NUMBER
75 , X_cdlsr1 IN VARCHAR2 default null
76 , X_cdlsr2 IN VARCHAR2 default null
77 , X_cdlsr3 IN VARCHAR2 default null
78 , X_denom_currency_code IN VARCHAR2 default null
79 , X_denom_raw_cost IN NUMBER default null
80 , X_denom_burden_cost IN NUMBER default null
81 , X_acct_currency_code IN VARCHAR2 default null
82 , X_acct_rate_date IN DATE default null
83 , X_acct_rate_type IN VARCHAR2 default null
84 , X_acct_exchange_rate IN NUMBER default null
85 , X_acct_raw_cost IN NUMBER default null
86 , X_acct_burdened_cost IN NUMBER default null
87 , X_project_currency_code IN VARCHAR2 default null
88 , X_project_rate_date IN DATE default null
89 , X_project_rate_type IN VARCHAR2 default null
90 , X_project_exchange_rate IN NUMBER default null
91 , P_PaPeriodName IN Varchar2 default null
92 , P_RecvrPaPeriodName IN Varchar2 default null
93 , P_GlPeriodName IN Varchar2 default null
94 , P_RecvrGlDate IN DATE default null
95 , P_RecvrGlPeriodName IN Varchar2 default null
96 , P_Projfunc_currency_code IN VARCHAR2 default null
97 , P_Projfunc_cost_rate_date IN DATE default null
98 , P_Projfunc_cost_rate_type IN VARCHAR2 default null
99 , P_Projfunc_cost_exchange_rate IN NUMBER default null
100 , P_project_raw_cost IN NUMBER default null
101 , P_project_burdened_cost IN NUMBER default null
102 , P_Work_Type_Id IN NUMBER default null
103 , p_mode IN VARCHAR2 default 'COSTING'
104 , p_cdlsr4 IN VARCHAR2 default null
105 , p_si_assets_addition_flag IN VARCHAR2 default NULL
106 , p_cdlsr5 IN NUMBER default null
107 , P_Parent_Line_Num IN NUMBER DEFAULT NULL);
108
109 PROCEDURE CreateExternalCdl( X_expenditure_item_id IN NUMBER
110 , X_ei_date IN DATE
111 , X_amount IN NUMBER
112 , X_dr_ccid IN NUMBER
113 , X_cr_ccid IN NUMBER
114 , X_transfer_status_code IN VARCHAR2
115 , X_quantity IN NUMBER
116 , X_billable_flag IN VARCHAR2
117 , X_request_id IN NUMBER
118 , X_program_application_id IN NUMBER
119 , x_program_id IN NUMBER
120 , x_program_update_date IN DATE
121 , X_pa_date IN DATE
122 , X_recvr_pa_date IN DATE /**CBGA**/
123 , X_gl_date IN DATE
124 , X_transferred_date IN DATE
125 , X_transfer_rejection_reason IN VARCHAR2
126 , X_line_type IN VARCHAR2
127 , X_ind_compiled_set_id IN NUMBER
128 , X_burdened_cost IN NUMBER
129 , X_user IN NUMBER
130 , X_project_id IN NUMBER
131 , X_task_id IN NUMBER
132 , X_cdlsr1 IN VARCHAR2 default null
133 , X_cdlsr2 IN VARCHAR2 default null
134 , X_cdlsr3 IN VARCHAR2 default null
135 , X_denom_currency_code IN VARCHAR2 default null
136 , X_denom_raw_cost IN NUMBER default null
137 , X_denom_burden_cost IN NUMBER default null
138 , X_acct_currency_code IN VARCHAR2 default null
139 , X_acct_rate_date IN DATE default null
140 , X_acct_rate_type IN VARCHAR2 default null
141 , X_acct_exchange_rate IN NUMBER default null
142 , X_acct_raw_cost IN NUMBER default null
143 , X_acct_burdened_cost IN NUMBER default null
144 , X_project_currency_code IN VARCHAR2 default null
145 , X_project_rate_date IN DATE default null
146 , X_project_rate_type IN VARCHAR2 default null
147 , X_project_exchange_rate IN NUMBER default null
148 , P_PaPeriodName IN Varchar2 default null
149 , P_RecvrPaPeriodName IN Varchar2 default null
150 , P_GlPeriodName IN Varchar2 default null
151 , P_RecvrGlDate IN DATE default null
152 , P_RecvrGlPeriodName IN Varchar2 default null
153 , P_Projfunc_currency_code IN VARCHAR2 default null
154 , P_Projfunc_cost_rate_date IN DATE default null
155 , P_Projfunc_cost_rate_type IN VARCHAR2 default null
156 , P_Projfunc_cost_exchange_rate IN NUMBER default null
157 , P_Project_raw_cost IN NUMBER default null
158 , P_Project_burdened_cost IN NUMBER default null
159 , P_Work_Type_Id IN NUMBER default null
160 , p_cdlsr4 IN VARCHAR2 default null
161 , p_si_assets_addition_flag IN VARCHAR2 default NULL
162 , p_cdlsr5 IN NUMBER default null
163 , X_err_code IN OUT NOCOPY NUMBER
164 , X_err_stage IN OUT NOCOPY VARCHAR2
165 , X_err_stack IN OUT NOCOPY VARCHAR2 );
166
167 FUNCTION Is_Accounted(X_Transaction_Source IN VARCHAR2)
168 RETURN VARCHAR2;
169
170 PRAGMA RESTRICT_REFERENCES(Is_Accounted,WNDS,WNPS);
171
172 PROCEDURE CreateReverseCdl ( X_exp_item_id IN NUMBER,
173 X_backout_id IN NUMBER,
174 X_user IN NUMBER,
175 X_status OUT NOCOPY NUMBER);
176 END PA_COSTING ;