PACKAGE: APPS.IGW_BUDGET_INTEGRATION

Source

1 PACKAGE IGW_BUDGET_INTEGRATION AUTHID CURRENT_USER AS
2 -- $Header: igwbuims.pls 115.18 2004/03/25 01:52:30 vmedikon ship $
3   G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGW_BUDGET_INTEGRATION';
4 
5 
6   FUNCTION  get_line_item_cost (p_line_item_id 	NUMBER) return number;
7   pragma restrict_references(get_line_item_cost, wnds, wnps);
8 
9   FUNCTION  get_oh_cost (p_line_item_id   	NUMBER) return number;
10   pragma restrict_references(get_oh_cost, wnds, wnps);
11 
12   FUNCTION  get_eb_cost (p_line_item_id   	NUMBER) return number;
13   pragma restrict_references(get_eb_cost, wnds, wnps);
14 
15   FUNCTION  get_eb_cost_personnel (p_personnel_detail_id   	NUMBER) return number;
16   pragma restrict_references(get_eb_cost_personnel, wnds, wnps);
17 
18   /* _ss functions return unrounded figures */
19   FUNCTION  get_oh_cost_ss (p_line_item_id   	NUMBER) return number;
20   pragma restrict_references(get_oh_cost, wnds, wnps);
21 
22   /* _ss functions return unrounded figures */
23   FUNCTION  get_eb_cost_ss (p_line_item_id   	NUMBER) return number;
24   pragma restrict_references(get_eb_cost, wnds, wnps);
25 
26   PROCEDURE get_resource_list_entry_method ( p_project_id        	NUMBER
27 					    ,x_budget_entry_method_code OUT NOCOPY VARCHAR2
28 					    ,x_resource_list_id         OUT NOCOPY NUMBER
29 					    ,x_time_phased_type_code    OUT NOCOPY VARCHAR2
30                                             ,x_entry_level_code         OUT NOCOPY VARCHAR2
31                                             ,x_categorization_code      OUT NOCOPY VARCHAR2 --bug 3523294
32 	  			  	    ,x_return_status            OUT NOCOPY VARCHAR2
33 				  	    ,x_msg_data                 OUT NOCOPY VARCHAR2);
34 
35   PROCEDURE get_resource_list_member_id_ss ( p_resource_list_id        		NUMBER
36 				  	    ,p_expenditure_type 	 	VARCHAR2
37 					    ,p_expenditure_category_flag	VARCHAR2
38     					    ,p_categorization_code              VARCHAR2  --bug 3523294
39 				  	    ,x_resource_list_member_id  	OUT NOCOPY NUMBER
40 	  			  	    ,x_return_status            	OUT NOCOPY VARCHAR2
41 				  	    ,x_msg_data                 	OUT NOCOPY VARCHAR2);
42 
43 
44 
45   -- This procedure is called from Self-Service Application
46   PROCEDURE create_award_budget( p_proposal_installment_id   IN  NUMBER
47              		  	 ,x_return_status            OUT NOCOPY VARCHAR2
48 				 ,x_msg_count                OUT NOCOPY NUMBER
49 				 ,x_msg_data                 OUT NOCOPY VARCHAR2);
50 
51 
52    FUNCTION valid_expenditure_type(p_project_id  		NUMBER
53   			          ,p_expenditure_type        	VARCHAR2
54   			          ,p_expenditure_category_flag	VARCHAR2) return VARCHAR2;
55   pragma restrict_references(valid_expenditure_type, wnds);
56 
57 
58 
59 
60 
61  END IGW_BUDGET_INTEGRATION;