PACKAGE: APPS.IBE_M_AUTOPLACEMENT_PVT

Source

1 PACKAGE IBE_M_AUTOPLACEMENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVMAPS.pls 115.5 2002/12/12 13:44:53 schak ship $ */
3 
4 g_pkg_name   CONSTANT VARCHAR2(30):='IBE_M_AUTOPLACEMENT_PVT';
5 g_api_version CONSTANT NUMBER := 1.0;
6 
7 TYPE PRODUCT_REC_TYPE IS RECORD (
8   PRODUCT_NUMBER VARCHAR2(40),
9   PRODUCT_NAME VARCHAR2(240), -- Description
10   ACTION VARCHAR2(10),
11   SECTION_CODE VARCHAR2(240),
12   SECTION_NAME VARCHAR2(120));
13 
14 TYPE PRODUCT_TBL_TYPE IS TABLE OF PRODUCT_REC_TYPE INDEX BY
15   BINARY_INTEGER;
16 
17 FUNCTION checkSection(p_section_id IN NUMBER) RETURN VARCHAR2;
18 
19 FUNCTION check_section(p_section_id IN NUMBER,
20   p_master_mini_site_id IN NUMBER) RETURN VARCHAR2;
21 
22 
23 PROCEDURE prod_autoplacement(
24 	    p_placement_mode IN VARCHAR2 default NULL,
25 	    p_assignment_mode IN VARCHAR2 default NULL,
26 	    p_target_section IN NUMBER default NULL,
27 	    p_include_subsection IN VARCHAR2 default NULL,
28 	    p_product_name IN VARCHAR2 default NULL,
29 	    p_product_number VARCHAR2 default NULL,
30 	    p_publish_flag VARCHAR2 default NULL,
31 	    p_start_date IN DATE default NULL,
32 	    p_end_date IN DATE default NULL,
33 	    x_return_status OUT NOCOPY VARCHAR2,
34 	    x_msg_count OUT NOCOPY NUMBER,
35 	    x_msg_data OUT NOCOPY VARCHAR2);
36 
37 
38 PROCEDURE autoPlacement(errbuf OUT NOCOPY VARCHAR2,
39 				    retcode OUT NOCOPY VARCHAR2,
40 				    p_placement_mode IN VARCHAR2 default NULL,
41 				    p_assignment_mode IN VARCHAR2 default NULL,
42 				    p_target_section IN VARCHAR2 default NULL,
43 				    p_include_subsection IN VARCHAR2 default NULL,
44 				    p_product_name IN VARCHAR2 default NULL,
45 				    p_product_number IN VARCHAR2 default NULL,
46 				    p_publish_flag IN VARCHAR2 default NULL,
47 				    p_start_date IN VARCHAR2 default NULL,
48 				    p_end_date IN VARCHAR2 default NULL,
49 				    p_debug_flag IN VARCHAR2 default 'Y');
50 
51 END IBE_M_AUTOPLACEMENT_PVT;