DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on CSI_ORDER_SHIP_PUB

Line 97: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec

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

Line 98: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec

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

Line 99: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec

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

Line 105: ,p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec

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

Line 106: ,p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec

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

Line 107: ,p_order_line_rec IN csi_order_ship_pub.order_line_rec

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

Line 162: x_order_line_rec OUT NOCOPY csi_order_ship_pub.order_line_rec,

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

Line 181: x_trx_sub_type_rec OUT NOCOPY csi_order_ship_pub.txn_sub_type_rec,

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

Line 196: x_model_inst_tbl OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

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

Line 228: p_order_line_rec IN csi_order_ship_pub.order_line_rec)

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

Line 245: x_mtl_txn_rec OUT NOCOPY csi_order_ship_pub.MTL_TXN_REC,

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

Line 284: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 316: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,

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

Line 317: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 337: x_item_control_rec OUT NOCOPY csi_order_ship_pub.item_control_rec,

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

Line 360: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 361: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,

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

Line 367: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 373: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 391: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

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

Line 399: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,

395:
396: PROCEDURE get_unit_price_in_primary_uom(
397: p_unit_price IN number,
398: p_unit_price_uom IN varchar2,
399: px_item_control_rec IN OUT nocopy csi_order_ship_pub.item_control_rec,
400: x_unit_price_in_primary_uom OUT nocopy number,
401: x_return_status OUT nocopy varchar2);
402:
403: END csi_utl_pkg ;