1 package IBW_PAGES_PUB AS
2 /* $Header: ibwpgs.pls 120.5 2005/09/04 23:45 apgupta noship $ */
3 PROCEDURE INSERT_ROW (
4 x_rowid IN OUT NOCOPY VARCHAR2,
5 x_page_id IN NUMBER,
6 x_page_code IN VARCHAR2,
7 x_page_status IN VARCHAR2,
8 x_application_context IN VARCHAR2,
9 x_business_context IN VARCHAR2,
10 x_reference IN VARCHAR2,
11 x_page_matching_criteria IN VARCHAR2,
12 x_site_area_id IN NUMBER,
13 x_page_matching_value IN VARCHAR2,
14 x_object_version_number IN NUMBER,
15 x_program_login_id IN NUMBER,
16 x_request_id IN NUMBER,
17 x_page_name IN VARCHAR2,
18 x_description IN VARCHAR2,
19 x_creation_date IN DATE,
20 x_created_by IN NUMBER,
21 x_last_update_date IN DATE,
22 x_last_updated_by IN NUMBER,
23 x_last_update_login IN NUMBER
24 );
25
26 PROCEDURE LOCK_ROW (
27 x_page_id IN NUMBER,
28 x_page_code IN VARCHAR2,
29 x_page_status IN VARCHAR2,
30 x_application_context IN VARCHAR2,
31 x_business_context IN VARCHAR2,
32 x_reference IN VARCHAR2,
33 x_page_matching_criteria IN VARCHAR2,
34 x_site_area_id IN NUMBER,
35 x_page_matching_value IN VARCHAR2,
36 x_object_version_number IN NUMBER,
37 x_program_login_id IN NUMBER,
38 x_request_id IN NUMBER,
39 x_page_name IN VARCHAR2,
40 x_description IN VARCHAR2
41 );
42
43 PROCEDURE UPDATE_ROW (
44 x_page_id IN NUMBER,
45 x_page_code IN VARCHAR2,
46 x_page_status IN VARCHAR2,
47 x_application_context IN VARCHAR2,
48 x_business_context IN VARCHAR2,
49 x_reference IN VARCHAR2,
50 x_page_matching_criteria IN VARCHAR2,
51 x_site_area_id IN NUMBER,
52 x_page_matching_value IN VARCHAR2,
53 x_object_version_number IN NUMBER,
54 x_program_login_id IN NUMBER,
55 x_request_id IN NUMBER,
56 x_page_name IN VARCHAR2,
57 x_description IN VARCHAR2,
58 x_last_update_date IN DATE,
59 x_last_updated_by IN NUMBER,
60 x_last_update_login IN NUMBER,
61 x_custom_mode IN VARCHAR2
62 );
63
64 PROCEDURE DELETE_ROW (x_page_id IN NUMBER);
65
66 PROCEDURE ADD_LANGUAGE;
67
68 PROCEDURE TRANSLATE_ROW (
69 x_page_id IN NUMBER,
70 x_page_name IN VARCHAR2,
71 x_description IN VARCHAR2,
72 x_owner IN VARCHAR2,
73 x_custom_mode IN VARCHAR2,
74 x_last_update_date IN VARCHAR2
75 );
76
77 PROCEDURE LOAD_ROW (
78 x_page_id IN NUMBER,
79 x_page_code IN VARCHAR2,
80 x_page_status IN VARCHAR2,
81 x_application_context IN VARCHAR2,
82 x_business_context IN VARCHAR2,
83 x_reference IN VARCHAR2,
84 x_page_matching_criteria IN VARCHAR2,
85 x_site_area_id IN NUMBER,
86 x_page_matching_value IN VARCHAR2,
87 x_page_name IN VARCHAR2,
88 x_description IN VARCHAR2,
89 x_owner IN VARCHAR2,
90 x_custom_mode IN VARCHAR2,
91 x_last_update_date IN VARCHAR2
92 );
93
94 PROCEDURE LOAD_SEED_ROW (
95 x_upload_mode IN VARCHAR2,
96 x_page_id IN VARCHAR2,
97 x_page_name IN VARCHAR2,
98 x_description IN VARCHAR2,
99 x_owner IN VARCHAR2,
100 x_custom_mode IN VARCHAR2,
101 x_last_update_date IN VARCHAR2,
102 x_page_code IN VARCHAR2,
103 x_page_status IN VARCHAR2,
104 x_application_context IN VARCHAR2,
105 x_business_context IN VARCHAR2,
106 x_reference IN VARCHAR2,
107 x_page_matching_criteria IN VARCHAR2,
108 x_site_area_id IN VARCHAR2,
109 x_page_matching_value IN VARCHAR2
110 );
111
112 FUNCTION GET_SITEAREA_STATUS (x_site_area_id IN NUMBER)
113 RETURN VARCHAR2;
114
115 PROCEDURE FORCE_UPDATE_SITEAREA (
116 x_site_area_id IN NUMBER,
117 x_last_update_date IN DATE,
118 x_last_updated_by IN NUMBER,
119 x_last_update_login IN NUMBER
120 );
121 END IBW_PAGES_PUB;