[Home] [Help]
PACKAGE: APPS.CSE_UTIL_PKG
Source
1 PACKAGE CSE_UTIL_PKG AS
2 -- $Header: CSEUTILS.pls 120.6 2006/05/31 07:30:46 brmanesh ship $
3 x_cse_install VARCHAR2(1) := NULL;
4 PROCEDURE Check_item_Trackable(
5 p_inventory_item_id IN NUMBER,
6 p_nl_trackable_flag OUT NOCOPY VARCHAR2);
7
8 PROCEDURE check_lot_control(
9 p_inventory_item_id IN NUMBER,
10 p_organization_id IN NUMBER,
11 p_lot_control OUT NOCOPY VARCHAR2);
12
13 PROCEDURE check_serial_control(
14 p_inventory_item_id IN NUMBER,
15 p_organization_id IN NUMBER,
16 p_serial_control OUT NOCOPY VARCHAR2);
17
18 PROCEDURE check_depreciable_subinv(
19 p_subinventory IN VARCHAR2,
20 p_organization_id IN NUMBER,
21 p_depreciable OUT NOCOPY VARCHAR2);
22
23 PROCEDURE get_asset_creation_code(
24 p_inventory_item_id IN NUMBER,
25 p_asset_creation_code OUT NOCOPY VARCHAR2);
26
27 PROCEDURE check_depreciable(
28 p_inventory_item_id IN NUMBER,
29 p_depreciable OUT NOCOPY VARCHAR2);
30
31 PROCEDURE get_combine_segments(
32 p_short_name IN VARCHAR2,
33 p_flex_code IN VARCHAR2,
34 p_concat_segments IN VARCHAR2,
35 x_combine_segments OUT NOCOPY VARCHAR2,
36 x_Return_Status OUT NOCOPY VARCHAR2,
37 x_Error_Message OUT NOCOPY VARCHAR2);
38
39 PROCEDURE get_concat_segments(
40 p_short_name IN VARCHAR2,
41 p_flex_code IN VARCHAR2,
42 p_combination_id IN NUMBER,
43 x_concat_segments OUT NOCOPY VARCHAR2,
44 x_Return_Status OUT NOCOPY VARCHAR2,
45 x_Error_Message OUT NOCOPY VARCHAR2);
46
47 PROCEDURE get_destination_instance(
48 P_Dest_Instance_tbl IN csi_datastructures_pub.instance_header_tbl,
49 X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
50 X_Return_Status OUT NOCOPY VARCHAR2,
51 x_Error_Message OUT NOCOPY VARCHAR2);
52
53 PROCEDURE get_master_organization(p_organization_id IN NUMBER,
54 p_master_organization_id OUT NOCOPY NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_error_message OUT NOCOPY VARCHAR2);
57
58 PROCEDURE get_hz_location (
59 p_network_location_code IN VARCHAR2,
60 x_hz_location_id OUT NOCOPY NUMBER,
61 x_Return_Status OUT NOCOPY VARCHAR2,
62 x_Error_Message OUT NOCOPY VARCHAR2);
63
64 PROCEDURE get_hz_location (
65 p_party_site_id IN NUMBER,
66 x_hz_location_id OUT NOCOPY NUMBER,
67 x_Return_Status OUT NOCOPY VARCHAR2,
68 x_Error_Message OUT NOCOPY VARCHAR2);
69
70 PROCEDURE get_fa_location (
71 p_hz_location_id IN NUMBER,
72 p_loc_type_code IN VARCHAR2,
73 x_fa_location_id OUT NOCOPY NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_error_message OUT NOCOPY VARCHAR2);
76
77 PROCEDURE build_error_string (
78 p_string IN OUT NOCOPY VARCHAR2,
79 p_attribute IN VARCHAR2,
80 p_value IN VARCHAR2);
81
82 PROCEDURE get_string_value (
83 p_string IN VARCHAR2,
84 p_attribute IN VARCHAR2,
85 x_value OUT NOCOPY VARCHAR2);
86
87 FUNCTION is_eib_installed RETURN VARCHAR2;
88
89 FUNCTION bypass_event_queue RETURN boolean;
90
91 PRAGMA RESTRICT_REFERENCES(is_eib_installed, WNDS);
92
93 FUNCTION get_neg_inv_code (p_org_id in NUMBER) RETURN NUMBER;
94
95 PRAGMA RESTRICT_REFERENCES(get_neg_inv_code, WNDS);
96
97 FUNCTION Get_Default_Status_Id(p_transaction_id IN NUMBER) RETURN NUMBER;
98
99 --PRAGMA RESTRICT_REFERENCES(get_default_status_id, WNDS);
100
101 FUNCTION Init_Instance_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Query_Rec;
102 FUNCTION Init_Instance_Create_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
103
104 FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec;
105
106 FUNCTION Init_Txn_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Rec;
107
108 FUNCTION Init_Txn_Error_Rec RETURN CSI_DATASTRUCTURES_PUB.TRANSACTION_Error_Rec;
109
110 FUNCTION Init_Party_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Tbl;
111
112 FUNCTION Init_Account_Tbl RETURN CSI_DATASTRUCTURES_PUB.Party_Account_Tbl;
113
114 FUNCTION Init_ext_attrib_values_tbl RETURN CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
115
116 FUNCTION Init_Pricing_Attribs_Tbl RETURN CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
117
118 FUNCTION Init_Org_Assignments_Tbl RETURN CSI_DATASTRUCTURES_PUB.organization_units_tbl;
119
120 FUNCTION Init_Asset_Assignment_Tbl RETURN CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
121
122 FUNCTION Get_Dflt_Project_Location_Id RETURN NUMBER;
123
124 FUNCTION Get_Location_Type_Code(P_Location_Meaning IN VARCHAR2) RETURN VARCHAR2;
125
126 PRAGMA RESTRICT_REFERENCES(Get_Location_Type_Code, WNDS);
127
128 FUNCTION Get_Txn_Type_Id(P_Txn_Type IN VARCHAR2, P_App_Short_Name IN VARCHAR2) RETURN NUMBER;
129
130 PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Id, WNDS);
131
132 FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2;
133
134 PRAGMA RESTRICT_REFERENCES(Get_Txn_Type_Code, WNDS);
135
136 FUNCTION Get_Txn_Status_Code(P_Txn_Status IN VARCHAR2) RETURN VARCHAR2;
137
138 FUNCTION Get_Txn_Action_Code(P_Txn_Action IN VARCHAR2) RETURN VARCHAR2;
139
140 FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER;
141
142 FUNCTION Init_Instance_Asset_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Query_Rec;
143
144 FUNCTION Init_Instance_Asset_Rec RETURN CSI_DATASTRUCTURES_PUB.instance_asset_Rec;
145
146 FUNCTION Init_Party_Query_Rec RETURN CSI_DATASTRUCTURES_PUB.Party_Query_Rec;
147
148 FUNCTION IS_Conc_Prg_Running(P_Request_Id IN NUMBER,P_Executable IN VARCHAR2) RETURN BOOLEAN;
149
150 PROCEDURE Write_Log(P_Message IN VARCHAR2);
151
152 FUNCTION get_inv_name (p_transaction_id IN NUMBER) RETURN VARCHAR2;
153
154 PROCEDURE Check_if_top_assembly(p_instance_id IN NUMBER,
155 x_yes_top_assembly OUT NOCOPY BOOLEAN,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_error_message OUT NOCOPY VARCHAR2);
158 ------------------------------------------------------------------------------
159 ---
160 --- Added for Redeployment functionality.
161 --- This procedure returns x_redeploy_flag as 'Y'
162 --- If there exists a OUT-OF-SERVICE' transaction
163 --- previous to the p_transaction_date (by default, it is SYSDATE
164 ---
165 ------------------------------------------------------------------------------
166
167 PROCEDURE get_redeploy_flag(
168 p_inventory_item_id IN NUMBER
169 ,p_serial_number IN VARCHAR2
170 ,p_transaction_date IN DATE
171 ,x_redeploy_flag OUT NOCOPY VARCHAR2
172 ,x_return_status OUT NOCOPY VARCHAR2
173 ,x_error_message OUT NOCOPY VARCHAR2);
174
175
176 ------------------------------------------------------------------------------
177
178 PROCEDURE get_inst_n_comp_dtls(
179 p_instance_id IN NUMBER
180 ,p_transaction_id IN NUMBER
181 ,p_transaction_date IN DATE
182 ,x_inst_dtls_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
183 ,x_return_status OUT NOCOPY VARCHAR2
184 ,x_error_message OUT NOCOPY VARCHAR2) ;
185 -------------------------------------------------------------------------------------
186
187
188 FUNCTION dump_error_stack RETURN VARCHAR2 ;
189
190 PROCEDURE set_debug;
191
192 END CSE_UTIL_PKG;