1 PACKAGE HR_BPL_MESSAGE AS
2 /* $Header: perbamsg.pkh 120.0 2005/05/31 16:40:39 appldev noship $ */
3 /*----------------------------------------------------*/
4 /* Function to return a MESSAGE in the Language of a */
5 /* Business Group */
6 /*----------------------------------------------------*/
7
8 FUNCTION GET_STRING_LNG_BG(APPIN in varchar2,
9 NAMEIN in varchar2)
10 return varchar2;
11
12 /*----------------------------------------------------*/
13 /* Updated version of the GET function, which allows */
14 /* the setting of the language */
15 /*----------------------------------------------------*/
16 function GET return varchar2;
17
18 /*----------------------------------------------------*/
19 /* New versiona of the SET_NAME function, which allow */
20 /* the passing of translation language. */
21 /*----------------------------------------------------*/
22
23
24
25 /* Sets the message with the language the of the person_id */
26 procedure SET_NAME_PSN(APPLICATION in varchar2,
27 NAME in varchar2,
28 p_person_id in number);
29
30 /* Sets the message with the language the of supervisor of the assignment id*/
31 procedure SET_NAME_SUP(APPLICATION in varchar2,
32 NAME in varchar2,
33 p_assignment_id in number);
34
35 /* Sets the message with the language the of primary supervisor of the */
36 /* assignment id */
37 procedure SET_NAME_PSUP(APPLICATION in varchar2,
38 NAME in varchar2,
39 p_assignment_id in number);
40
41 /* Sets the message with the language the of a person_ids primary */
42 /* supervisor */
43 procedure SET_NAME_PSN_PSUP(APPLICATION in varchar2,
44 NAME in varchar2,
45 p_person_id in number);
46
47 /* ** SET_NAME - sets the message name, */
48 procedure SET_NAME(APPLICATION in varchar2,
49 NAME in varchar2,
50 p_business_group_id in number);
51
52 /* --------------------------------------------------*/
53 /* Required unchanged FND_MESSAGE Functions */
54 /*---------------------------------------------------*/
55
56
57 /* FETCH_SQL_TOKEN- get the value for a SQL Query token */
58 /* This procedure is only to be called by the ATG */
59 /* not for external use */
60
61 function FETCH_SQL_TOKEN(TOK_VAL in varchar2) return varchar2;
62 pragma restrict_references(FETCH_SQL_TOKEN, WNDS);
63
64
65 /* ** SET_TOKEN - defines a message token with a value */
66 procedure SET_TOKEN(TOKEN in varchar2,
67 VALUE in varchar2,
68 TRANSLATE in boolean default false);
69 pragma restrict_references(SET_TOKEN, WNDS);
70
71 /* */
72 /* SET_TOKEN_SQL - define a message token with a SQL query value */
73 /* */
74 /* Description: */
75 /* Like SET_TOKEN, except here the value is a SQL statement which */
76 /* returns a single varchar2 value. (e.g. A translated concurrent*/
77 /* manager name.) This statement is run when the message text is */
78 /* resolved, and the result is used in the token substitution. */
79 /* */
80 /* Arguments: */
81 /* token - Token name */
82 /* value - Token value. A SQL statement */
83
84 procedure SET_TOKEN_SQL (TOKEN in varchar2,
85 VALUE in varchar2);
86
87 /* RETRIEVE - gets the message and token data, clears message buffer */
88
89 procedure RETRIEVE(MSGOUT out NOCOPY varchar2);
90 pragma restrict_references(RETRIEVE, WNDS);
91
92 /* CLEAR - clears the message buffer */
93 procedure CLEAR;
94 pragma restrict_references(CLEAR, WNDS);
95
96
97 end HR_BPL_MESSAGE;