1 PACKAGE OE_CONFIG_TSO_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVTSOS.pls 120.3.12010000.1 2008/07/25 08:07:55 appldev ship $ */
3
4 /*
5 TYPE Instance_Rec_type IS RECORD
6 (
7 --Instance_header_id NUMBER
8 --, Instance_rev_nbr NUMBER
9 --, Ship_to_org_id NUMBER
10 --, Bill_to_org_id NUMBER
11 item_instance_id NUMBER
12 ,config_instance_hdr_id NUMBER
13 ,config_instance_rev_number NUMBER
14 ,config_instance_item_id NUMBER
15 ,bill_to_site_use_id NUMBER
16 ,ship_to_site_use_id NUMBER
17 ,instance_name VARCHAR2(255)
18 --, Config_instance_item_id NUMBER
19 );
20 */
21
22 --TYPE Instance_Tbl_Type IS TABLE OF Instance_Rec_Type
23 --INDEX BY BINARY_INTEGER;
24
25
26 MACD_SYSTEM_CALL VARCHAR2(1) := 'N';
27
28 PROCEDURE Is_Part_of_Container_Model
29 ( p_line_id IN NUMBER DEFAULT NULL
30 , p_top_model_line_id IN NUMBER DEFAULT NULL
31 , p_ato_line_id IN NUMBER DEFAULT NULL
32 , p_inventory_item_id IN NUMBER DEFAULT NULL
33 , p_operation IN VARCHAR2 DEFAULT NULL
34 , p_org_id IN NUMBER DEFAULT NULL --Bug 5524710
35 , x_top_container_model OUT NOCOPY VARCHAR2
36 , x_part_of_container OUT NOCOPY VARCHAR2
37 );
38
39 /*
40 PROCEDURE Get_MACD_Action_Mode
41 ( p_line_id IN NUMBER
42 , p_top_model_line_id IN NUMBER DEFAULT NULL
43 , p_ato_line_id IN NUMBER DEFAULT NULL
44 , p_check_if_container IN VARCHAR2 DEFAULT NULL
45 , x_top_container_model OUT NOCOPY VARCHAR2
46 , x_config_mode OUT NOCOPY VARCHAR2
47 );
48 */
49
50 PROCEDURE Get_MACD_Action_Mode
51 ( p_line_rec IN OE_Order_pub.Line_Rec_Type := null
52 , p_line_id IN NUMBER := null
53 , p_top_model_line_id IN NUMBER := null
54 , p_check_ibreconfig IN VARCHAR2 := null
55 , x_config_mode OUT NOCOPY NUMBER
56 , x_return_status OUT NOCOPY VARCHAR2
57 );
58
59
60 PROCEDURE Validate_Container_Model
61 ( p_line_rec IN OE_Order_pub.Line_Rec_Type
62 , p_old_line_rec IN OE_Order_Pub.Line_Rec_Type
63 , x_return_status OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE Remove_Unchanged_Lines
67 ( p_top_model_line_id IN NUMBER
68 , p_line_id IN NUMBER
69 , p_ato_line_id IN NUMBER
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 , x_return_status OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE Remove_Unchanged_Components
76 ( p_header_id IN NUMBER
77 , p_line_id IN NUMBER
78 , p_top_model_line_id IN NUMBER
79 , p_ato_line_id IN NUMBER
80 , x_msg_data OUT NOCOPY VARCHAR2
81 , x_msg_count OUT NOCOPY NUMBER
82 , x_return_status OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE Populate_TSO_Order_Lines
86 ( p_header_id IN NUMBER
87 , p_top_model_line_id IN NUMBER
88 --, p_instance_tbl IN Instance_Tbl_Type
89 , p_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
90 , p_mode IN NUMBER
91 , x_msg_data OUT NOCOPY VARCHAR2
92 , x_msg_count OUT NOCOPY NUMBER
93 , x_return_status OUT NOCOPY VARCHAR2
94 );
95
96 Procedure Process_MACD_Order
97 (P_api_version_number IN NUMBER,
98 P_caller IN VARCHAR2,
99 P_x_header_id IN OUT NOCOPY NUMBER,
100 P_sold_to_org_id IN NUMBER,
101 P_MACD_Action IN VARCHAR2,
102 P_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
103 P_Instance_Tbl IN csi_datastructures_pub.instance_cz_tbl,
104 P_Extended_Attrib_Tbl IN csi_datastructures_pub.ext_attrib_values_tbl,
105 x_container_line_id OUT NOCOPY NUMBER,
106 x_number_of_containers OUT NOCOPY NUMBER,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY VARCHAR2,
109 x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 END OE_CONFIG_TSO_PVT;