[Home] [Help]
PACKAGE: APPS.OE_OE_FOLDER_EXT
Source
1 PACKAGE Oe_Oe_Folder_Ext AUTHID CURRENT_USER AS
2 /* $Header: OEXFEXTS.pls 120.1.12010000.1 2008/07/25 07:47:57 appldev ship $ */
3
4 TYPE Config_Buttons_Rec IS RECORD
5 (
6 Action_Id NUMBER,
7 OBJECT VARCHAR2(30),
8 ACTION_NAME Varchar2(500),
9 User_Entered_Prompt Varchar2(500),
10 Default_Prompt Varchar2(500),
11 Display_As_Button Varchar2(1),
12 Access_Key Varchar2(6), ---- Bug 5528134, increased the width to 6
13 width Number,
14 Folder_Id Varchar2(10)
15 );
16
17
18 TYPE Config_Buttons_Tbl IS TABLE OF Config_Buttons_Rec
19 INDEX BY BINARY_INTEGER;
20
21 PROCEDURE Get_Customized_Buttons
22 (
23 p_folder_id IN Number
24 , x_custom_buttons_tbl OUT NOCOPY /* file.sql.39 change */ Oe_Oe_Folder_Ext.Config_Buttons_Tbl
25 , x_default_buttons_tbl OUT NOCOPY /* file.sql.39 change */ Oe_Oe_Folder_Ext.Config_Buttons_Tbl
26 );
27 PROCEDURE Get_Buttons_List
28 (
29 p_folder_id IN Number
30 , p_displayed_buttons IN Oe_Oe_Folder_Ext.Config_Buttons_Tbl
31 , x_buttons_tbl OUT NOCOPY /* file.sql.39 change */ Oe_Oe_Folder_Ext.Config_Buttons_Tbl
32 );
33 PROCEDURE Store_Custom_Buttons
34 (
35 p_folder_id IN Number
36 , p_config_buttons_tbl IN Oe_Oe_Folder_Ext.Config_Buttons_Tbl
37 , l_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
38 , x_custom_buttons_tbl OUT NOCOPY /* file.sql.39 change */ Oe_Oe_Folder_Ext.Config_Buttons_Tbl
39 , x_default_buttons_tbl OUT NOCOPY /* file.sql.39 change */ Oe_Oe_Folder_Ext.Config_Buttons_Tbl
40 );
41
42 PROCEDURE INSERT_FOLDER
43 (p_folder_extension_id IN Number,
44 p_object IN Varchar2,
45 p_user_id IN Number,
46 p_folder_id IN Number,
47 p_pricing_tab IN Varchar2 Default Null,
48 p_service_tab IN Varchar2 Default Null,
49 p_others_tab IN Varchar2 Default Null,
50 p_addresses_tab IN varchar2 Default Null,
51 p_returns_tab IN Varchar2 Default Null,
52 p_shipping_tab IN Varchar2 Default Null,
53 p_headers_others_tab IN Varchar2 Default Null,
54 p_options_details IN Varchar2 Default Null,
55 p_services_details IN Varchar2 Default Null,
56 p_adjustment_details IN Varchar2 Default Null,
57 p_related_item_details IN Varchar2 Default Null,
58 p_pricing_ava_details IN Varchar2 Default Null,
59 p_default_line_region IN Varchar2 Default Null
60 );
61
62 PROCEDURE FOLDER_ACTIONS_INIT( x_others_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
63 x_pricing_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
64 x_addresses_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
65 x_services_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
66 x_shipping_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
67 x_returns_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
68 x_header_others_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
69 x_options_details OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70 x_services_details OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71 x_adjustment_details OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
72 x_related_item_details OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
73 x_pricing_ava_details OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74 x_default_line_region OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 x_custom_buttons_tbl OUT NOCOPY /* file.sql.39 change */
76 Oe_Oe_Folder_Ext.Config_Buttons_Tbl,
77 x_default_buttons_tbl OUT NOCOPY /* file.sql.39 change */
78 Oe_Oe_Folder_Ext.Config_Buttons_Tbl,
79 p_order_folder_object IN Varchar DEFAULT 'OE_ORDERS_TELESALES',
80 p_line_folder_object IN Varchar DEFAULT 'OE_LINE_TELESALES'
81 );
82
83 PROCEDURE DELETE_FOLDER(p_folder_extension_id IN Number Default Null ,
84 p_folder_id IN Number
85 );
86
87 PROCEDURE Defer_Pricing(p_mode In Varchar2);
88 END Oe_Oe_Folder_Ext;
89