PACKAGE: APPS.PA_BILLING_VALUES

Source

1 PACKAGE pa_billing_values AS
2 /* $Header: PAXIVALS.pls 120.1 2005/08/19 17:15:16 mwasowic noship $ */
3 
4 ------------
5 --  OVERVIEW
6 --  Procedures/Functions created to return character fields from DB.
7 --
8 --
9 
10 ---------------------
11 --  SPECIAL CONSTANTS
12 --
13 --
14 --
15 
16 ----------------------------
17 --  PROCEDURES AND FUNCTIONS
18 --
19 --
20 --
21 --  1. Function Name:   funding_level
22 --
23 --     Usage:		If (funding_level(project_id) = 'TASK')
24 --
25 -- 			The function will return TASK if there is Task Level
26 -- 			funding and PROJECT if there is Project Level funding.
27 -- 			It will return NO FUNDING if there is no funding.
28 --
29 --     Parameters: 	X2_project_id (Mandatory)
30 --
31 --
32 --  2. Function Name:	get_dflt_org
33 --
34 --     Usage:		Org_id := get_dflt_org(project_id, task_id)
35 --
36 --			Returns task org of task_id is passed in else returns
37 --			the project org.
38 --
39 --
40 --  3. Procedure Name: 	get_dflt_desc
41 --
42 --     Usage:		event_desc := get_dflt_desc(extn_asgn_id, event_type,
43 --							description);
44 --
45 --       		Gets the default event description, and event_type
46 --			for the associated billing_extension.
47 --
48 --  4. Function Name:   message_text
49 --
50 --     Usage:           message := message_text('NULL_EVENT_TYPE')
51 --
52 --                      Returns the message associated with the code.
53 --
54 --
55 --
56 
57 ------------------------
58 -- FUNCTION DECLARATIONS
59 --
60 
61 FUNCTION funding_level(X2_project_id NUMBER)
62 	RETURN VARCHAR2;
63 
64 FUNCTION get_dflt_org(X2_project_id NUMBER, X2_top_task_id NUMBER)
65 	RETURN NUMBER;
66 
67 PROCEDURE get_dflt_desc(X2_billing_assignment_id NUMBER,
68 			X2_event_type OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 			X2_event_description OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70 
71 FUNCTION get_message(X2_message_code VARCHAR2)
72 	RETURN VARCHAR2;
73 
74 END pa_billing_values;