PACKAGE: APPS.WSH_FOLDER_EXTENSIONS_PVT

Source

1 PACKAGE WSH_FOLDER_EXTENSIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: WSHFDEXS.pls 115.1 2003/08/13 07:25:34 anxsharm noship $ */
3 
4 TYPE folder_ext_rec_type IS RECORD(
5      FOLDER_EXTENSION_ID NUMBER,
6      OBJECT              VARCHAR2(30),
7      USER_ID             NUMBER,
8      FOLDER_ID           NUMBER,
9      APPLICATION_ID      NUMBER,
10      DISPLAY_DLVY_MAIN   VARCHAR2(1),
11      DISPLAY_DLVY_OTHERS VARCHAR2(1),
12      DISPLAY_LINE_MAIN   VARCHAR2(1),
13      DISPLAY_LINE_OTHERS VARCHAR2(1),
14      DISPLAY_TRIP_MAIN   VARCHAR2(1),
15      DISPLAY_TRIP_OTHERS VARCHAR2(1),
16      DISPLAY_STOP_MAIN   VARCHAR2(1),
17      DISPLAY_STOP_OTHERS VARCHAR2(1),
18      DISPLAY_QM_LINE_MAIN VARCHAR2(1),
19      DISPLAY_QM_LINE_OTHERS VARCHAR2(1),
20      DISPLAY_SHIP_CONF_DIALOGUE VARCHAR2(1),
21      DISPLAY_TRIP_CONF_DIALOGUE VARCHAR2(1),
22      DISPLAY_TRIP_INFO   VARCHAR2(1),
23      CREATION_DATE       DATE,
24      CREATED_BY          NUMBER,
25      LAST_UPDATE_DATE    DATE,
26      LAST_UPDATED_BY     NUMBER,
27      LAST_UPDATE_LOGIN   NUMBER
28 );
29 
30 
31 TYPE folder_cust_rec_type IS RECORD(
32      ACTION_ID           NUMBER,
33      ACTION_NAME         VARCHAR2(30),
34      OBJECT              VARCHAR2(30),
35      USER_ENTERED_PROMPT VARCHAR2(30),
36      USER_ID             NUMBER,
37      FOLDER_ID           NUMBER,
38      WIDTH               NUMBER,
39      ACCESS_KEY          VARCHAR2(1),
40      DISPLAY_AS_BUTTON_FLAG VARCHAR2(1),
41      DEFAULT_PROMPT      VARCHAR2(80),
42      CREATION_DATE       DATE,
43      CREATED_BY          NUMBER,
44      LAST_UPDATE_DATE    DATE,
45      LAST_UPDATED_BY     NUMBER,
46      LAST_UPDATE_LOGIN   NUMBER
47 );
48 
49 TYPE folder_cust_tab_type IS TABLE OF folder_cust_rec_type INDEX BY BINARY_INTEGER;
50 
51 Procedure Insert_Update_Folder_Ext(
52           p_folder_ext_rec IN folder_ext_rec_type,
53           x_return_status  OUT NOCOPY VARCHAR2);
54 
55 Procedure Delete_Folder_Ext(
56           p_folder_id           IN NUMBER,
57           x_return_status       OUT NOCOPY VARCHAR2);
58 
59 
60 Procedure Insert_Update_Folder_Custom(
61           p_folder_cust_tab IN folder_cust_tab_type,
62           x_return_status  OUT NOCOPY VARCHAR2);
63 
64 Procedure Delete_Folder_Custom(
65           p_folder_id           IN NUMBER,
66           x_return_status       OUT NOCOPY VARCHAR2);
67 
68 END WSH_FOLDER_EXTENSIONS_PVT;