1 package PA_FUNDS_CONTROL_UTILS2 as
2 -- $Header: PAFUTL2S.pls 120.1 2005/08/10 14:18:44 bkattupa noship $
3
4 /* declare the global variables */
5 g_cwk_implemented_flag varchar2(100) := Null;
6 g_bd_cache_exp_string varchar2(1000);
7 g_bd_cache_proj_id Number;
8 g_bd_cache_task_id Number;
9 g_bd_cache_doc_line_id Number;
10 g_bd_cache_exp_type Varchar2(150);
11 g_bd_cache_Ei_date Date;
12 g_bd_cache_result_code Varchar2(150);
13 g_bd_cache_status_code Varchar2(150);
14
15
16 FUNCTION is_CWK_PO(p_po_header_id Number
17 ,p_po_line_id Number
18 ,p_po_dist_id Number
19 ,p_proj_org_id Number ) Return varchar2 ;
20
21
22 /* This api will return the resource list member id from the summary record
23 * for the given document header and line for contingent worker record
24 */
25 FUNCTION get_CWK_RLMI(p_project_id IN Number
26 ,p_task_id IN Number
27 ,p_budget_version_id IN Number
28 ,p_document_header_id IN Number
29 ,p_document_dist_id IN Number
30 ,p_document_line_id IN Number
31 ,p_document_type IN VARCHAR2
32 ,p_expenditure_type IN VARCHAR2
33 ,p_line_type IN VARCHAR2
34 ,p_calling_module IN VARCHAR2 ) Return Number ;
35
36
37 /* This Function returns the Baseline Budget version OR Draft budget version
38 * based on the calling mode 'DRAFT'/ 'BASELINE'
39 */
40 FUNCTION get_draftORbaseLine_bdgtver(p_project_id IN Number
41 ,p_ext_bdgt_type IN varchar2
42 ,p_mode IN varchar2 ) Return Number ;
43
44
45
46 /* This API will checks the burden components for CWK transactions has been changed, if so return error
47 * if the burden componenets are not same as the summary record , later we cannot
48 * derive the budget ccid and resource list member id.
49 * so mark the trasnaction as Error.
50 * This check should be carried only for the Burden display method is different
51 * Example: PO is entered for exp 'Airfare' which maps to the following cost codes
52 * Cost Base ind_cost_codes
53 * -----------------------------------
54 * Expenses GA
55 * FEE
56 *
57 * When timecard is entered for expenditure type which maps
58 * Labor GA
59 * FEE
60 * Fringe
61 * Overhead
62 * Since we cannot map RLMI for the Fringe and Overhead, later the transactions get rejected
63 * so mark the bc_packet and parent_bc_packet records as rejected with reason
64 * "Burden cost codes not mapping to summary record expenditure types" - F100
65 *
66 */
67 PROCEDURE checkCWKbdCostCodes( p_calling_module varchar2
68 ,p_project_id Number
69 ,p_task_id Number
70 ,p_doc_line_id Number
71 ,p_exp_type varchar2
72 ,p_exp_item_date date
73 ,x_return_status OUT NOCOPY varchar2
74 ,x_result_code OUT NOCOPY varchar2
75 ,x_status_code OUT NOCOPY varchar2
76 );
77 end;