1 package PA_INTERFACE_UTILS_PUB AUTHID DEFINER as
2 --$Header: PAPMUTPS.pls 120.2 2005/08/16 23:33:13 avaithia noship $
3
4 G_PA_MISS_NUM CONSTANT NUMBER := 1.7E20;
5 G_PA_MISS_DATE CONSTANT DATE := TO_DATE('01/01/4712','DD/MM/YYYY');
6 G_PA_MISS_CHAR CONSTANT VARCHAR2(3) := '^';
7
8 --bug 2471668
9 --Advanced Project Security in AMG Changes
10 G_PROJECT_ID NUMBER;
11 G_ADVANCED_PROJ_SEC_FLAG VARCHAR2(1) := 'N'; /* Bug#2810699-Defaulted the value to N */
12 --bug 2471668
13
14
15 PROCEDURE get_messages
16 (p_encoded IN VARCHAR2 := FND_API.G_FALSE,
17 p_msg_index IN NUMBER := FND_API.G_MISS_NUM,
18 p_msg_count IN NUMBER := 1,
19 p_msg_data IN VARCHAR2 := FND_API.G_MISS_CHAR,
20 p_data OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
21 p_msg_index_out OUT NOCOPY NUMBER ) ; /*Added the nocopy check for 4537865 */
22
23 FUNCTION get_bg_id RETURN NUMBER;
24 pragma RESTRICT_REFERENCES (get_bg_id, WNDS, WNPS);
25
26 /** Bug 1940353 - Added a parameter p_resp_appl_id in this procedure **/
27
28 PROCEDURE Set_Global_Info
29 (p_api_version_number IN NUMBER,
30 p_responsibility_id IN NUMBER := G_PA_MISS_NUM,
31 p_user_id IN NUMBER := G_PA_MISS_NUM,
32 p_resp_appl_id IN NUMBER := 275,
33 p_advanced_proj_sec_flag IN VARCHAR2 := 'N', --bug 2471668
34 p_calling_mode IN VARCHAR2 := 'AMG', --bug 2783845
35 p_operating_unit_id IN NUMBER := G_PA_MISS_NUM, -- 4363092 Added for MOAC Changes
36 p_msg_count OUT NOCOPY NUMBER, /*Added the nocopy check for 4537865 */
37 p_msg_data OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
38 p_return_status OUT NOCOPY VARCHAR2 ) ; /*Added the nocopy check for 4537865 */
39
40 PROCEDURE GET_DEFAULTS (p_def_char OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
41 p_def_num OUT NOCOPY NUMBER, /*Added the nocopy check for 4537865 */
42 p_def_date OUT NOCOPY DATE, /*Added the nocopy check for 4537865 */
43 p_return_status OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
44 p_msg_count OUT NOCOPY NUMBER, /*Added the nocopy check for 4537865 */
45 p_msg_data OUT NOCOPY VARCHAR2); /*Added the nocopy check for 4537865 */
46
47 PROCEDURE Get_Accum_Period_Info
48 ( p_api_version_number IN NUMBER,
49 p_project_id IN NUMBER,
50 p_last_accum_period OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
51 p_last_accum_start_date OUT NOCOPY DATE, /*Added the nocopy check for 4537865 */
52 p_last_accum_end_date OUT NOCOPY DATE, /*Added the nocopy check for 4537865 */
53 p_current_reporting_period OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
54 p_current_period_start_date OUT NOCOPY DATE, /*Added the nocopy check for 4537865 */
55 p_current_period_end_date OUT NOCOPY DATE, /*Added the nocopy check for 4537865 */
56 p_return_status OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
57 p_msg_count OUT NOCOPY NUMBER, /*Added the nocopy check for 4537865 */
58 p_msg_data OUT NOCOPY VARCHAR2); /*Added the nocopy check for 4537865 */
59
60 PROCEDURE Get_Release_info (
61 p_current_release OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
62 p_return_status OUT NOCOPY VARCHAR2, /*Added the nocopy check for 4537865 */
63 p_msg_count OUT NOCOPY NUMBER, /*Added the nocopy check for 4537865 */
64 p_msg_data OUT NOCOPY VARCHAR2 ); /*Added the nocopy check for 4537865 */
65
66 TYPE pa_pm_message_amg_rec IS Record
67 (p_old_message_code VARCHAR2(50),
68 p_new_message_code VARCHAR2(50),
69 p_msg_context VARCHAR2(10));
70 TYPE pa_pm_message_amg IS TABLE OF pa_pm_message_amg_rec
71 INDEX BY BINARY_INTEGER;
72 pa_pm_message_amg_tbl pa_pm_message_amg;
73
74 FUNCTION get_new_message_code
75 ( p_message_code IN VARCHAR2 := FND_API.G_FALSE
76 ,p_msg_context IN VARCHAR2 := FND_API.G_FALSE
77 ) RETURN VARCHAR2;
78
79 PROCEDURE create_amg_mapping_msg;
80
81 PROCEDURE map_new_amg_msg
82 ( p_old_message_code IN VARCHAR2 := FND_API.G_FALSE
83 ,p_msg_attribute IN VARCHAR2 := FND_API.G_FALSE
84 ,p_resize_flag IN VARCHAR2 := FND_API.G_FALSE
85 ,p_msg_context IN VARCHAR2 := FND_API.G_FALSE
86 ,p_attribute1 IN VARCHAR2 := FND_API.G_FALSE
87 ,p_attribute2 IN VARCHAR2 := FND_API.G_FALSE
88 ,p_attribute3 IN VARCHAR2 := FND_API.G_FALSE
89 ,p_attribute4 IN VARCHAR2 := FND_API.G_FALSE
90 ,p_attribute5 IN VARCHAR2 := FND_API.G_FALSE
91 );
92
93 FUNCTION get_task_number_amg
94 ( p_task_number IN VARCHAR2 := FND_API.G_MISS_CHAR
95 ,p_task_reference IN VARCHAR2 := FND_API.G_MISS_CHAR
96 ,p_task_id IN VARCHAR2 := FND_API.G_MISS_CHAR
97 ) RETURN VARCHAR2;
98
99
100 END PA_INTERFACE_UTILS_PUB;