DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on CSI_ORDER_SHIP_PUB

Line 99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec

95: PROCEDURE split_ship_rec(
96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
102: ,p_proc_qty IN NUMBER
103: ,x_return_status OUT NOCOPY VARCHAR2);

Line 100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec

96: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
102: ,p_proc_qty IN NUMBER
103: ,x_return_status OUT NOCOPY VARCHAR2);
104:

Line 101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec

97: ,x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
98: ,x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
99: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
100: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
101: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
102: ,p_proc_qty IN NUMBER
103: ,x_return_status OUT NOCOPY VARCHAR2);
104:
105: PROCEDURE create_txn_details

Line 107: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec

103: ,x_return_status OUT NOCOPY VARCHAR2);
104:
105: PROCEDURE create_txn_details
106: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
107: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
108: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
109: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
110: ,x_return_status OUT NOCOPY VARCHAR2 );
111:

Line 108: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec

104:
105: PROCEDURE create_txn_details
106: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
107: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
108: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
109: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
110: ,x_return_status OUT NOCOPY VARCHAR2 );
111:
112: PROCEDURE get_party_id(

Line 109: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec

105: PROCEDURE create_txn_details
106: ( x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec
107: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec
108: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec
109: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec
110: ,x_return_status OUT NOCOPY VARCHAR2 );
111:
112: PROCEDURE get_party_id(
113: p_cust_acct_id IN number,

Line 164: x_order_line_rec OUT NOCOPY csi_order_ship_pub.order_line_rec,

160: p_line_id IN NUMBER )RETURN BOOLEAN ;
161:
162: PROCEDURE get_order_line_dtls
163: ( p_mtl_transaction_id IN NUMBER,
164: x_order_line_rec OUT NOCOPY csi_order_ship_pub.order_line_rec,
165: x_return_status OUT NOCOPY VARCHAR2 );
166:
167: PROCEDURE get_master_organization
168: (p_organization_id IN NUMBER,

Line 183: x_trx_sub_type_rec OUT NOCOPY csi_order_ship_pub.txn_sub_type_rec,

179:
180: PROCEDURE get_sub_type_rec
181: ( p_sub_type_id IN NUMBER,
182: p_trx_type_id IN NUMBER,
183: x_trx_sub_type_rec OUT NOCOPY csi_order_ship_pub.txn_sub_type_rec,
184: x_return_status OUT NOCOPY VARCHAR2 );
185:
186: PROCEDURE get_int_party
187: ( x_int_party_id OUT NOCOPY NUMBER,

Line 198: x_model_inst_tbl OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

194: x_return_status OUT NOCOPY VARCHAR2 );
195:
196: PROCEDURE get_model_inst_lst(
197: p_parent_line_id IN number,
198: x_model_inst_tbl OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
199: x_return_status OUT NOCOPY varchar2);
200:
201: PROCEDURE get_qty_ratio --fix for 5096435
202: ( p_order_line_qty IN NUMBER,

Line 230: p_order_line_rec IN csi_order_ship_pub.order_line_rec)

226: p_instance_id IN NUMBER)
227: RETURN boolean;
228:
229: FUNCTION check_standard_bom(
230: p_order_line_rec IN csi_order_ship_pub.order_line_rec)
231: RETURN boolean;
232:
233: PROCEDURE create_txn_dtls(
234: p_source_trx_id IN NUMBER,

Line 247: x_mtl_txn_rec OUT NOCOPY csi_order_ship_pub.MTL_TXN_REC,

243: x_return_status OUT NOCOPY varchar2);
244:
245: PROCEDURE get_source_trx_dtls(
246: p_mtl_transaction_id IN NUMBER,
247: x_mtl_txn_rec OUT NOCOPY csi_order_ship_pub.MTL_TXN_REC,
248: x_error_message OUT NOCOPY VARCHAR2,
249: x_return_status OUT NOCOPY VARCHAR2);
250:
251: PROCEDURE split_txn_dtls(

Line 286: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

282: PROCEDURE get_ii_relation_tbl(
283: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
284: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
285: p_trx_rec IN csi_datastructures_pub.transaction_rec,
286: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
287: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
288: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
289: x_return_status OUT NOCOPY VARCHAR2 );
290:

Line 318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,

314: PROCEDURE get_party_owner(
315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
320: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

Line 319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

315: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
316: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
317: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
318: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
319: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
320: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
321: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
322: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
323: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

Line 339: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,

335: x_return_status OUT NOCOPY varchar2);
336:
337: PROCEDURE get_item_control_rec(
338: p_mtl_txn_id IN number,
339: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,
340: x_return_status OUT NOCOPY varchar2);
341:
342: ---Added (Start) for m-to-m enhancements
343: PROCEDURE rltns_xfaced_to_IB (

Line 362: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

358: x_return_status OUT NOCOPY VARCHAR2) ;
359: ---Added (End) for m-to-m enhancements
360:
361: PROCEDURE build_parent_relation (
362: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
363: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
364: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
366: x_return_status OUT NOCOPY VARCHAR2);

Line 363: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

359: ---Added (End) for m-to-m enhancements
360:
361: PROCEDURE build_parent_relation (
362: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
363: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
364: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
366: x_return_status OUT NOCOPY VARCHAR2);
367:

Line 369: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

365: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
366: x_return_status OUT NOCOPY VARCHAR2);
367:
368: PROCEDURE build_child_relation(
369: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
370: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
371: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
372: x_return_status OUT NOCOPY varchar2);
373:

Line 375: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

371: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
372: x_return_status OUT NOCOPY varchar2);
373:
374: PROCEDURE get_ib_trackable_children(
375: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
376: x_trackable_line_tbl OUT NOCOPY oe_order_pub.line_tbl_type,
377: x_return_status OUT NOCOPY varchar2);
378:
379: PROCEDURE amend_contracts(

Line 393: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

389: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
390: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
391: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
392: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
393: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
394: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
395: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
396: x_return_status OUT nocopy varchar2);
397:

Line 401: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,

397:
398: PROCEDURE get_unit_price_in_primary_uom(
399: p_unit_price IN number,
400: p_unit_price_uom IN varchar2,
401: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,
402: x_unit_price_in_primary_uom OUT nocopy number,
403: x_return_status OUT nocopy varchar2);
404:
405: -- Added for bug#14835893