DBA Data[Home] [Help]

APPS.CSI_ASSET_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 81: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,

77: /*----------------------------------------------------------*/
78:
79: PROCEDURE Initialize_asset_rec
80: (
81: x_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec,
82: p_inst_asset_hist_id IN NUMBER ,
83: x_nearest_full_dump IN OUT NOCOPY DATE
84: );
85:

Line 94: x_instance_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl,

90: /*----------------------------------------------------------*/
91:
92: PROCEDURE Construct_asset_from_hist
93: (
94: x_instance_asset_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl,
95: p_time_stamp IN DATE
96: );
97:
98: /*----------------------------------------------------------*/

Line 107: x_inst_asset_rec OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec );

103:
104: PROCEDURE Get_Asset_Column_Values
105: (
106: p_get_asset_cursor_id IN NUMBER ,
107: x_inst_asset_rec OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec );
108:
109: /*----------------------------------------------------------*/
110: /* Procedure name: Define_Asset_Columns */
111: /* Description : This procudure defines the columns */

Line 127: p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec,

123: /*----------------------------------------------------------*/
124:
125: PROCEDURE Bind_asset_variable
126: (
127: p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec,
128: p_get_asset_cursor_id IN NUMBER );
129:
130: /*----------------------------------------------------------*/
131: /* Procedure name: Resolve_id_columns */

Line 137: ( p_asset_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl);

133: /* id columns */
134: /*----------------------------------------------------------*/
135:
136: PROCEDURE Resolve_id_columns
137: ( p_asset_header_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl);
138:
139: /*----------------------------------------------------------*/
140: /* Procedure name: Gen_Asset_Where_Clause */
141: /* Description : Procedure used to generate the where */

Line 146: ( p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

142: /* cluase for Party relationship */
143: /*----------------------------------------------------------*/
144:
145: PROCEDURE Gen_Asset_Where_Clause
146: ( p_inst_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
147: ,x_where_clause OUT NOCOPY VARCHAR2 );
148:
149: /*-------------------------------------------------------*/
150: /* procedure name: Get_instance_assets */

Line 161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec

157: p_api_version IN NUMBER
158: ,p_commit IN VARCHAR2 := fnd_api.g_false
159: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_time_stamp IN DATE
164: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
165: ,x_return_status OUT NOCOPY VARCHAR2

Line 164: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl

160: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
161: ,p_instance_asset_query_rec IN csi_datastructures_pub.instance_asset_query_rec
162: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
163: ,p_time_stamp IN DATE
164: ,x_instance_asset_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
165: ,x_return_status OUT NOCOPY VARCHAR2
166: ,x_msg_count OUT NOCOPY NUMBER
167: ,x_msg_data OUT NOCOPY VARCHAR2
168: );

Line 182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec

178: p_api_version IN NUMBER
179: ,p_commit IN VARCHAR2 := fnd_api.g_false
180: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
181: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
184: ,x_return_status OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY NUMBER
186: ,x_msg_data OUT NOCOPY VARCHAR2

Line 183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

179: ,p_commit IN VARCHAR2 := fnd_api.g_false
180: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
181: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
182: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
183: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
184: ,x_return_status OUT NOCOPY VARCHAR2
185: ,x_msg_count OUT NOCOPY NUMBER
186: ,x_msg_data OUT NOCOPY VARCHAR2
187: ,p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl

Line 206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec

202: p_api_version IN NUMBER
203: ,p_commit IN VARCHAR2 := fnd_api.g_false
204: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2

Line 207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

203: ,p_commit IN VARCHAR2 := fnd_api.g_false
204: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
205: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
206: ,p_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec
207: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
208: ,x_return_status OUT NOCOPY VARCHAR2
209: ,x_msg_count OUT NOCOPY NUMBER
210: ,x_msg_data OUT NOCOPY VARCHAR2
211: ,p_lookup_tbl IN OUT NOCOPY csi_asset_pvt.lookup_tbl

Line 230: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl

226: ,p_commit IN VARCHAR2 := fnd_api.g_false
227: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
228: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
229: ,p_transaction_id IN NUMBER
230: ,x_ins_asset_hist_tbl OUT NOCOPY csi_datastructures_pub.ins_asset_history_tbl
231: ,x_return_status OUT NOCOPY VARCHAR2
232: ,x_msg_count OUT NOCOPY NUMBER
233: ,x_msg_data OUT NOCOPY VARCHAR2
234: ) ;

Line 299: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,

295: p_api_version IN number,
296: p_commit IN varchar2,
297: p_init_msg_list IN varchar2,
298: p_validation_level IN number,
299: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
300: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
301: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
302: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
303: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,

Line 300: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

296: p_commit IN varchar2,
297: p_init_msg_list IN varchar2,
298: p_validation_level IN number,
299: p_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
300: p_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
301: p_lookup_tbl IN OUT nocopy csi_asset_pvt.lookup_tbl,
302: p_asset_count_rec IN OUT nocopy csi_asset_pvt.asset_count_rec,
303: p_asset_id_tbl IN OUT nocopy csi_asset_pvt.asset_id_tbl,
304: p_asset_loc_tbl IN OUT nocopy csi_asset_pvt.asset_loc_tbl,

Line 310: px_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,

306: x_msg_count OUT nocopy number,
307: x_msg_data OUT nocopy varchar2);
308: --
309: PROCEDURE set_fa_sync_flag (
310: px_instance_asset_rec IN OUT NOCOPY csi_datastructures_pub.instance_asset_rec,
311: p_location_id IN NUMBER DEFAULT -9999, -- should be passed only from GRP API (Create)
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_error_msg OUT NOCOPY VARCHAR2);
314: END csi_asset_pvt;