[Home] [Help]
PACKAGE: APPS.PA_PAGE_CONTENTS_PKG
Source
1 PACKAGE PA_PAGE_CONTENTS_PKG AUTHID CURRENT_USER AS
2 --$Header: PAPGCTTS.pls 115.2 2002/12/03 18:19:42 mwasowic noship $
3
4
5 procedure INSERT_PAGE_CONTENTS_ROW (
6
7 P_PAGE_CONTENT_ID IN NUMBER,
8 P_OBJECT_TYPE IN VARCHAR2,
9 P_PK1_VALUE IN VARCHAR2,
10 P_PK2_VALUE IN VARCHAR2,
11 P_PK3_VALUE IN VARCHAR2,
12 P_PK4_VALUE IN VARCHAR2,
13 P_PK5_VALUE IN VARCHAR2,
14
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_msg_count OUT NOCOPY NUMBER,
17 x_msg_data OUT NOCOPY VARCHAR2
18 );
19
20
21 procedure CLEAR_CLOB (
22 P_PAGE_CONTENT_ID IN NUMBER,
23 --P_RECORD_VERSION_NUMBER IN NUMBER := NULL,
24
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 procedure UPDATE_PAGE_CONTENTS_ROW (
31 P_PAGE_CONTENT_ID in NUMBER,
32 P_OBJECT_TYPE in VARCHAR2,
33 P_PK1_VALUE in VARCHAR2,
34 P_PK2_VALUE in VARCHAR2,
35 P_PK3_VALUE in VARCHAR2,
36 P_PK4_VALUE in VARCHAR2,
37 P_PK5_VALUE in VARCHAR2,
38 p_record_version_number IN NUMBER,
39
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45
46
47 procedure DELETE_PAGE_CONTENTS_ROW (
48 P_PAGE_CONTENT_ID in NUMBER,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53 END PA_PAGE_CONTENTS_PKG;