1 PACKAGE Oe_Config_Pvt AS
2 /* $Header: OEXVCFGS.pls 120.1.12010000.1 2008/07/25 07:58:43 appldev ship $ */
3
4 -- to avoid recursive calls to process_order.
5 OECFG_VALIDATE_CONFIG VARCHAR2(1) := 'Y';
6
7 -- to do pricing only once for a call to save options
8 OECFG_CONFIGURATION_PRICING VARCHAR2(1) := 'N';
9
10 -- to freeze included items at entry.
11 -- we will store line_id in apply_attribute_changes.
12
13 TYPE OE_FREEZE_INC_ITEMS IS TABLE OF NUMBER
14 INDEX BY BINARY_INTEGER;
15
16 OE_FREEZE_INC_ITEMS_TBL OE_FREEZE_INC_ITEMS;
17
18 OE_MODIFY_INC_ITEMS_TBL OE_Order_PUB.request_tbl_type
19 := OE_Order_Pub.G_MISS_REQUEST_TBL;
20
21
22 G_CONFIG_INSTANCE_TBL csi_datastructures_pub.instance_cz_tbl;
23
24 Procedure Process_Config
25 ( p_header_id IN NUMBER
26 ,p_config_hdr_id IN NUMBER
27 ,p_config_rev_nbr IN NUMBER
28 ,p_top_model_line_id IN NUMBER
29 ,p_ui_flag IN VARCHAR2
30 := 'Y'
31 ,p_config_instance_tbl IN csi_datastructures_pub.instance_cz_tbl
32 := G_CONFIG_INSTANCE_TBL
33 ,x_change_flag OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,x_return_status OUT NOCOPY VARCHAR2);
37
38
39 Procedure Delete_Config
40 (p_config_hdr_id IN NUMBER ,
41 p_config_rev_nbr IN NUMBER ,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44
45 Procedure Copy_Config
46 (p_top_model_line_id IN NUMBER ,
47 p_config_hdr_id IN NUMBER ,
48 p_config_rev_nbr IN NUMBER ,
49 p_configuration_id IN NUMBER ,
50 p_remnant_flag IN VARCHAR2 ,
51 x_return_status OUT NOCOPY VARCHAR2 );
52
53
54 -- below temp
55 Procedure Copy_Config1
56 (p_config_hdr_id IN NUMBER ,
57 p_config_rev_nbr IN NUMBER ,
58 x_config_hdr_id OUT NOCOPY NUMBER ,
59 x_config_rev_nbr OUT NOCOPY NUMBER ,
60 x_return_status OUT NOCOPY VARCHAR2 );
61
62
63 PROCEDURE put_hold_and_release_hold
64 ( p_header_id IN NUMBER,
65 p_line_id IN NUMBER,
66 p_valid_config IN VARCHAR2,
67 p_complete_config IN VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER ,
69 x_msg_data OUT NOCOPY VARCHAR2 ,
70 x_return_status OUT NOCOPY VARCHAR2 );
71
72
73 Procedure Explode_Bill
74 ( p_model_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
75 ,p_do_update IN BOOLEAN := TRUE
76 ,p_check_effective_date IN VARCHAR2 := 'Y'
77 ,x_config_effective_date OUT NOCOPY DATE
78 ,x_frozen_model_bill OUT NOCOPY VARCHAR2
79 ,x_return_status OUT NOCOPY VARCHAR2);
80
81
82
83 PROCEDURE Call_Process_Order
84 ( p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
85 ,p_class_line_tbl IN OE_Order_Pub.Line_Tbl_Type
86 := OE_ORDER_PUB.G_MISS_LINE_TBL
87 ,p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type
88 ,p_ui_flag IN VARCHAR2 := 'N'
89 ,p_top_model_line_id IN NUMBER := null
90 ,p_config_hdr_id IN NUMBER := null
91 ,p_config_rev_nbr IN NUMBER := null
92 ,p_update_columns IN BOOLEAN := FALSE
93 ,x_return_status OUT NOCOPY VARCHAR2);
94
95
96 Procedure Change_Columns
97 ( p_top_model_line_id IN NUMBER
98 ,p_config_hdr_id IN NUMBER
99 ,p_config_rev_nbr IN NUMBER
100 ,p_ui_flag IN VARCHAR2 := 'N'
101 ,p_operation IN VARCHAR2 := 'A');
102
103
104 PROCEDURE Included_Items_DML
105 ( p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
106 ,p_top_model_line_id IN NUMBER
107 ,p_ui_flag IN VARCHAR2
108 ,x_return_status OUT NOCOPY VARCHAR2);
109
110
111 PROCEDURE Modify_Included_Items
112 (x_return_status OUT NOCOPY VARCHAR2);
113
114
115 PROCEDURE Is_Cancel_OR_Delete
116 ( p_line_id IN NUMBER
117 ,p_change_reason IN VARCHAR2 := null
118 ,p_change_comments IN VARCHAR2 := null
119 ,x_cancellation OUT NOCOPY BOOLEAN
120 ,x_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type);
121
122 END Oe_Config_Pvt;