[Home] [Help]
PACKAGE: APPS.BIS_PMV_PORTAL_UTIL_PVT
Source
1 PACKAGE BIS_PMV_PORTAL_UTIL_PVT as
2 /* $Header: BISPMVPS.pls 120.0 2005/06/01 14:33:23 appldev noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.4=120.0):~PROD:~PATH:~FILE
5
6 /*
7 REM +=======================================================================+
8 REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
9 REM | All rights reserved. |
10 REM +=======================================================================+
11 REM | FILENAME |
12 REM | BISPMVPS.pls |
13 REM | |
14 REM | DESCRIPTION |
15 REM | This is the utility package for Oracle Portal |
16 REM | |
17 REM | HISTORY |
18 REM | kiprabha 02/27/03 Initial Creation |
19 REM | kiprabha 08/01/03 Hanging Related Link Cleanup |
20 REM | nkishore 03/02/03 BugFix 3417849 |
21 REM +=======================================================================+
22 */
23
24 TYPE bis_pmv_ref_path_rec_type IS RECORD
25 (
26 ref_path VARCHAR2(100)
27 ) ;
28 TYPE bis_pmv_ref_path_tbl_type IS TABLE OF bis_pmv_ref_path_rec_type INDEX BY BINARY_INTEGER;
29
30 PROCEDURE clean_portlets
31 (
32 p_user_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
33 ,p_page_id in NUMBER DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
34 ,p_page_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_function_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
39 ) ;
40
41 PROCEDURE get_reference_paths
42 (
43 p_user_name IN VARCHAR2
44 ,p_page_id IN NUMBER
45 ,x_ref_path_tbl OUT NOCOPY BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_TBL_TYPE
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49
50 ) ;
51
52
53 --BugFix 3417849
54 -- OA Pages enhancement
55 PROCEDURE get_oa_reference_paths
56 (
57 p_page_id IN NUMBER
58 ,x_ref_path_tbl IN OUT NOCOPY BIS_PMV_PORTAL_UTIL_PVT.BIS_PMV_REF_PATH_TBL_TYPE
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62
63 ) ;
64
65 -- OA Pages enhancement
66 FUNCTION get_oa_page_id
67 (
68 p_page_name IN VARCHAR2 DEFAULT NULL
69 ,p_function_name in VARCHAR2 DEFAULT NULL-- jprabhud - 04/23/04 - Bug 3573468
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 ) RETURN NUMBER ;
74
75 PROCEDURE bulk_delete_schedules
76 (
77 p_schedule_ids IN BISVIEWER.t_num
78 ) ;
79
80 -- OA Pages : added p_page_id
81 PROCEDURE bulk_delete_attributes
82 (
83 p_schedule_ids IN BISVIEWER.t_num
84 ,p_page_id IN NUMBER
85 ) ;
86
87 --Delete Hanging Related Links -ansingh
88 PROCEDURE DELETE_HANGING_RELATED_LINKS (pUserId IN NUMBER, pPlugIdArray IN BISVIEWER.t_num);
89
90 END BIS_PMV_PORTAL_UTIL_PVT;