1 PACKAGE PA_COSTING AUTHID CURRENT_USER AS
2 /* $Header: PAXCOSTS.pls 120.5.12020000.2 2013/03/31 03:47:46 arbandyo ship $ */
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 --, p_agreement_id IN NUMBER DEFAULT NULL ) ; --FSIO Changes
40
41 /*
42 ** PROCEDURE CreateNewCdl( X_expenditure_item_id IN NUMBER
43 ** , X_err_stack IN OUT VARCHAR2 );
44 */
45 -- comment this out since told to not use overloading...
46
47 -- create another spec for CreateNewCdl due to bug 666884.
48
49 PROCEDURE CreateNewCdl( X_expenditure_item_id IN NUMBER
50 , X_amount IN NUMBER
51 , X_dr_ccid IN NUMBER
52 , X_cr_ccid IN NUMBER
53 , X_transfer_status_code IN VARCHAR2
54 , X_quantity IN NUMBER
55 , X_billable_flag IN VARCHAR2
56 , X_request_id IN NUMBER
57 , X_program_application_id IN NUMBER
58 , x_program_id IN NUMBER
59 , x_program_update_date IN DATE
60 , X_pa_date IN DATE
61 , X_recvr_pa_date IN DATE /**CBGA**/
62 , X_gl_date IN DATE
63 , X_transferred_date IN DATE
64 , X_transfer_rejection_reason IN VARCHAR2
65 , X_line_type IN VARCHAR2
66 , X_ind_compiled_set_id IN NUMBER
67 , X_burdened_cost IN NUMBER
68 , X_line_num_reversed IN NUMBER
69 , X_reverse_flag IN VARCHAR2
70 , X_user IN NUMBER
71 , X_err_code IN OUT NOCOPY NUMBER
72 , X_err_stage IN OUT NOCOPY VARCHAR2
73 , X_err_stack IN OUT NOCOPY VARCHAR2
74 , X_project_id IN NUMBER
75 , X_task_id IN NUMBER
76 , X_cdlsr1 IN VARCHAR2 default null
77 , X_cdlsr2 IN VARCHAR2 default null
78 , X_cdlsr3 IN VARCHAR2 default null
79 , X_denom_currency_code IN VARCHAR2 default null
80 , X_denom_raw_cost IN NUMBER default null
81 , X_denom_burden_cost IN NUMBER default null
82 , X_acct_currency_code IN VARCHAR2 default null
83 , X_acct_rate_date IN DATE default null
84 , X_acct_rate_type IN VARCHAR2 default null
85 , X_acct_exchange_rate IN NUMBER default null
86 , X_acct_raw_cost IN NUMBER default null
87 , X_acct_burdened_cost IN NUMBER default null
88 , X_project_currency_code IN VARCHAR2 default null
89 , X_project_rate_date IN DATE default null
90 , X_project_rate_type IN VARCHAR2 default null
91 , X_project_exchange_rate IN NUMBER default null
92 , P_PaPeriodName IN Varchar2 default null
93 , P_RecvrPaPeriodName IN Varchar2 default null
94 , P_GlPeriodName IN Varchar2 default null
95 , P_RecvrGlDate IN DATE default null
96 , P_RecvrGlPeriodName IN Varchar2 default null
97 , P_Projfunc_currency_code IN VARCHAR2 default null
98 , P_Projfunc_cost_rate_date IN DATE default null
99 , P_Projfunc_cost_rate_type IN VARCHAR2 default null
100 , P_Projfunc_cost_exchange_rate IN NUMBER default null
101 , P_project_raw_cost IN NUMBER default null
102 , P_project_burdened_cost IN NUMBER default null
103 , P_Work_Type_Id IN NUMBER default null
104 , p_mode IN VARCHAR2 default 'COSTING'
105 , p_cdlsr4 IN VARCHAR2 default null
106 , p_si_assets_addition_flag IN VARCHAR2 default NULL
107 , p_cdlsr5 IN NUMBER default null
108 , P_Parent_Line_Num IN NUMBER DEFAULT NULL
109 /* 12.2 payroll intg .. start */
110 , p_rate_source_code IN VARCHAR2 default null
111 , p_costing_method IN VARCHAR2 default null
112 /* 12.2 payroll intg .. end */
113 --, p_agreement_id IN NUMBER Default NULL); --FSIO Changes
114 , p_cbs_element_id IN NUMBER default null -- Added for CBS Enhancement Bug 16220146
115 );
116
117 PROCEDURE CreateExternalCdl( X_expenditure_item_id IN NUMBER
118 , X_ei_date IN DATE
119 , X_amount IN NUMBER
120 , X_dr_ccid IN NUMBER
121 , X_cr_ccid IN NUMBER
122 , X_transfer_status_code IN VARCHAR2
123 , X_quantity IN NUMBER
124 , X_billable_flag IN VARCHAR2
125 , X_request_id IN NUMBER
126 , X_program_application_id IN NUMBER
127 , x_program_id IN NUMBER
128 , x_program_update_date IN DATE
129 , X_pa_date IN DATE
130 , X_recvr_pa_date IN DATE /**CBGA**/
131 , X_gl_date IN DATE
132 , X_transferred_date IN DATE
133 , X_transfer_rejection_reason IN VARCHAR2
134 , X_line_type IN VARCHAR2
135 , X_ind_compiled_set_id IN NUMBER
136 , X_burdened_cost IN NUMBER
137 , X_user IN NUMBER
138 , X_project_id IN NUMBER
139 , X_task_id IN NUMBER
140 , X_cdlsr1 IN VARCHAR2 default null
141 , X_cdlsr2 IN VARCHAR2 default null
142 , X_cdlsr3 IN VARCHAR2 default null
143 , X_denom_currency_code IN VARCHAR2 default null
144 , X_denom_raw_cost IN NUMBER default null
145 , X_denom_burden_cost IN NUMBER default null
146 , X_acct_currency_code IN VARCHAR2 default null
147 , X_acct_rate_date IN DATE default null
148 , X_acct_rate_type IN VARCHAR2 default null
149 , X_acct_exchange_rate IN NUMBER default null
150 , X_acct_raw_cost IN NUMBER default null
151 , X_acct_burdened_cost IN NUMBER default null
152 , X_project_currency_code IN VARCHAR2 default null
153 , X_project_rate_date IN DATE default null
154 , X_project_rate_type IN VARCHAR2 default null
155 , X_project_exchange_rate IN NUMBER default null
156 , P_PaPeriodName IN Varchar2 default null
157 , P_RecvrPaPeriodName IN Varchar2 default null
158 , P_GlPeriodName IN Varchar2 default null
159 , P_RecvrGlDate IN DATE default null
160 , P_RecvrGlPeriodName IN Varchar2 default null
161 , P_Projfunc_currency_code IN VARCHAR2 default null
162 , P_Projfunc_cost_rate_date IN DATE default null
163 , P_Projfunc_cost_rate_type IN VARCHAR2 default null
164 , P_Projfunc_cost_exchange_rate IN NUMBER default null
165 , P_Project_raw_cost IN NUMBER default null
166 , P_Project_burdened_cost IN NUMBER default null
167 , P_Work_Type_Id IN NUMBER default null
168 , p_cdlsr4 IN VARCHAR2 default null
169 , p_si_assets_addition_flag IN VARCHAR2 default NULL
170 , p_cdlsr5 IN NUMBER default null
171 , p_cbs_element_id IN NUMBER default null -- Added for CBS Enhancement Bug 16220146
175 --, p_agreement_id IN NUMBER default null); --FSIO Changes
172 , X_err_code IN OUT NOCOPY NUMBER
173 , X_err_stage IN OUT NOCOPY VARCHAR2
174 , X_err_stack IN OUT NOCOPY VARCHAR2);
176
177 FUNCTION Is_Accounted(X_Transaction_Source IN VARCHAR2)
178 RETURN VARCHAR2;
179
180 PRAGMA RESTRICT_REFERENCES(Is_Accounted,WNDS,WNPS);
181
182 PROCEDURE CreateReverseCdl ( X_exp_item_id IN NUMBER,
183 X_backout_id IN NUMBER,
184 X_user IN NUMBER,
185 X_status OUT NOCOPY NUMBER);
186 END PA_COSTING ;
[Home] [Help]