1 PACKAGE pa_self_service_msg_pub AUTHID CURRENT_USER AS
2 /* $Header: PAXPSSMS.pls 120.1 2005/08/19 17:18:20 mwasowic noship $ */
3
4 -- ==========================================================================
5 -- This API will be used to generate a customized message which will
6 -- be displayed in the final review screen and supervisor approval screens.
7 --
8 -- The message generated by this API could be used to ensure that the
9 -- employees are billable to a specified percentage determined as follows.
10 --
11 -- (billable hours in timecard )/(total hours on timecard) *100
12 --
13 -- The messages are customizable by customers, hence the customer could
14 -- generate message that would display total number of hours, % utilization
15 -- etc.
16 --
17 --
18 -- Parameters:
19 -- IN
20 --
21 -- P_Expenditure_Id pa_expenditures_all.expenditure_id%TYPE,
22 -- P_Person_id per_all_people_f.person_id%TYPE,
23 -- P_Week_Ending_Date Date,
24 --
25 -- OUT
26 --
27 -- X_Application_Name Fnd_Application.Application_short_name%TYPE,
28 -- X_Msg_Token1_Name Varchar2,
29 -- X_Msg_Token1_Value Varchar2,
30 -- X_Msg_Token2_Name Varchar2,
31 -- X_Msg_Token2_Value Varchar2,
32 -- X_Msg_Token3_Name Varchar2,
33 -- X_Msg_Token3_Value Varchar2
34
35 PROCEDURE business_message(
36 P_Expenditure_Id IN pa_expenditures_all.expenditure_id%TYPE,
37 P_Person_id IN per_all_people_f.person_id%TYPE,
38 P_Week_Ending_Date IN Date,
39 X_Msg_Application_Name OUT NOCOPY Fnd_Application.Application_short_name%TYPE, --File.Sql.39 bug 4440895
40 X_Msg_name OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
41 X_Msg_Token1_Name OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
42 X_Msg_Token1_Value OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
43 X_Msg_Token2_Name OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
44 X_Msg_Token2_Value OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
45 X_Msg_Token3_Name OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
46 X_Msg_Token3_Value OUT NOCOPY Varchar2); --File.Sql.39 bug 4440895
47
48 END pa_self_Service_msg_pub;