1 package JTF_DPF_PHYSICAL_PAGES_PKG as
2 /* $Header: jtfdpfps.pls 120.2 2005/10/25 05:18:11 psanyal ship $ */
3 procedure INSERT_ROW (
4 X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5 X_PHYSICAL_PAGE_ID in NUMBER,
6 X_PHYSICAL_PAGE_NAME in VARCHAR2,
7 X_APPLICATION_ID in NUMBER,
8 X_OBJECT_VERSION_NUMBER in NUMBER,
9 X_PHYSICAL_PAGE_DESCRIPTION in VARCHAR2,
10 X_CREATION_DATE in DATE,
11 X_CREATED_BY in NUMBER,
12 X_LAST_UPDATE_DATE in DATE,
13 X_LAST_UPDATED_BY in NUMBER,
14 X_LAST_UPDATE_LOGIN in NUMBER);
15 procedure LOCK_ROW (
16 X_PHYSICAL_PAGE_ID in NUMBER,
17 X_PHYSICAL_PAGE_NAME in VARCHAR2,
18 X_APPLICATION_ID in NUMBER,
19 X_OBJECT_VERSION_NUMBER in NUMBER,
20 X_PHYSICAL_PAGE_DESCRIPTION in VARCHAR2
21 );
22 procedure UPDATE_ROW (
23 X_PHYSICAL_PAGE_ID in NUMBER,
24 X_PHYSICAL_PAGE_NAME in VARCHAR2,
25 X_APPLICATION_ID in NUMBER,
26 X_OBJECT_VERSION_NUMBER in NUMBER,
27 X_PHYSICAL_PAGE_DESCRIPTION in VARCHAR2,
28 X_LAST_UPDATE_DATE in DATE,
29 X_LAST_UPDATED_BY in NUMBER,
30 X_LAST_UPDATE_LOGIN in NUMBER
31 );
32 procedure DELETE_ROW (
33 X_PHYSICAL_PAGE_ID in NUMBER
34 );
35 procedure ADD_LANGUAGE;
36
37 procedure TRANSLATE_ROW (
38 X_PAGE_NAME IN VARCHAR2,
39 X_APPLICATION_ID IN VARCHAR2,
40 X_PAGE_DESCRIPTION IN VARCHAR2,
41 X_OWNER IN VARCHAR2
42 );
43
44 procedure LOAD_ROW (
45 X_PAGE_NAME IN VARCHAR2,
46 X_APPLICATION_ID IN VARCHAR2,
47 X_PAGE_DESCRIPTION IN VARCHAR2,
48 X_OWNER IN VARCHAR2
49 );
50
51 -- insert a row for the JTF_DPF_PHY_ATTRIBS table
52 procedure insert_phy_attributes(
53 X_PHYS_ID IN NUMBER,
54 X_PAGE_ATTRIBUTE_NAME IN VARCHAR2,
55 X_PAGE_ATTRIBUTE_VALUE IN VARCHAR2,
56 X_OWNER IN VARCHAR2
57 );
58
59 -- update a row for the JTF_DPF_PHY_ATTRIBS table
60 procedure update_phy_attributes(
61 X_PHYS_ID IN NUMBER,
62 X_PAGE_ATTRIBUTE_NAME IN VARCHAR2,
63 X_PAGE_ATTRIBUTE_VALUE IN VARCHAR2,
64 X_OWNER IN VARCHAR2
65 );
66
67 -- Find the physical_page_id to a page which has the given
68 -- name and appid. If more than one physical matches
69 -- those criteria, preference is given to:
70 -- (1) the oldest which has last_updated_by = x_last_updated_by, if any, else
71 -- (2) the oldest
72 -- where 'oldest' means that it has the earliest last_update_date
73 --
74 -- If no pages have that name and appid, returns null
75
76 function find_oldest_prefer_owned_by(
77 x_page_name in varchar2,
78 x_application_id in varchar2,
79 x_last_updated_by number) return number;
80
81 end JTF_DPF_PHYSICAL_PAGES_PKG;