DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_ORDER_SHIP_PUB

Line 215: l_cps_tbl csi_order_ship_pub.customer_products_tbl;

211: x_return_status OUT NOCOPY varchar2)
212:
213: IS
214:
215: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
216: l_cp_ind binary_integer := 0;
217: l_ind binary_integer := 0;
218: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
219: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;

Line 218: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;

214:
215: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
216: l_cp_ind binary_integer := 0;
217: l_ind binary_integer := 0;
218: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
219: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;
220: l_acp_ind binary_integer := 0;
221: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
222: l_msg_count number;

Line 219: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;

215: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
216: l_cp_ind binary_integer := 0;
217: l_ind binary_integer := 0;
218: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
219: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;
220: l_acp_ind binary_integer := 0;
221: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
222: l_msg_count number;
223: l_msg_data varchar2(2000);

Line 234: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;

230: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
231: l_bom_explode_flag BOOLEAN := FALSE;
232: l_split_flag varchar2(10);
233: l_auto_split_instances csi_datastructures_pub.instance_tbl;
234: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
235: l_order_line_rec oe_order_lines_all%rowtype;
236:
237:
238: begin

Line 2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;

2469: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2470: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2471: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2472: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2473: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2474: l_tld_found VARCHAR2(1);
2475:
2476: l_instance_party_id number;
2477: l_pty_object_ver_num number;

Line 8693: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710

8689: END cz_fulfillment;
8690:
8691: PROCEDURE query_tld_and_update_ib(
8692: p_order_header_rec IN oe_order_headers_all%rowtype,
8693: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
8694: px_default_info_rec IN OUT NOCOPY default_info_rec,
8695: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
8696: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
8697: x_return_status OUT NOCOPY varchar2)

Line 8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;

8699:
8700: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8701: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8702:
8703: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8704:
8705: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
8706:
8707: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 8937: csi_order_ship_pub.update_install_base(

8933: l_p_order_line_rec.customer_id := px_default_info_rec.owner_party_acct_id;
8934: l_p_order_line_rec.end_customer_id := px_default_info_rec.owner_party_acct_id;
8935: l_p_order_line_rec.trx_line_id := px_default_info_rec.transaction_line_id;
8936:
8937: csi_order_ship_pub.update_install_base(
8938: p_api_version => 1.0,
8939: p_commit => fnd_api.g_false,
8940: p_init_msg_list => fnd_api.g_true,
8941: p_validation_level => fnd_api.g_valid_level_full,

Line 9116: l_p_order_line_rec csi_order_ship_pub.order_line_rec;

9112:
9113: l_order_line_rec oe_order_lines_all%rowtype;
9114: l_order_header_rec oe_order_headers_all%rowtype;
9115:
9116: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
9117: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
9118:
9119: l_identified_item_type varchar2(30);
9120: l_processing_status varchar2(30);

Line 10456: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,

10452:
10453: END order_fulfillment;
10454:
10455: PROCEDURE construct_txn_dtls(
10456: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
10457: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
10458: p_trackable_parent IN boolean,
10459: x_trx_line_id OUT NOCOPY NUMBER,
10460: x_return_status OUT NOCOPY varchar2)

Line 10457: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

10453: END order_fulfillment;
10454:
10455: PROCEDURE construct_txn_dtls(
10456: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
10457: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
10458: p_trackable_parent IN boolean,
10459: x_trx_line_id OUT NOCOPY NUMBER,
10460: x_return_status OUT NOCOPY varchar2)
10461: IS

Line 10844: l_order_line_rec csi_order_ship_pub.order_line_rec;

10840: l_msg_count number;
10841:
10842: skip_regular_process exception;
10843: l_error_rec csi_datastructures_pub.transaction_error_rec;
10844: l_order_line_rec csi_order_ship_pub.order_line_rec;
10845: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
10846: l_count number := 0;
10847: l_party_id number;
10848: l_uom_rate number;

Line 10845: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;

10841:
10842: skip_regular_process exception;
10843: l_error_rec csi_datastructures_pub.transaction_error_rec;
10844: l_order_line_rec csi_order_ship_pub.order_line_rec;
10845: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
10846: l_count number := 0;
10847: l_party_id number;
10848: l_uom_rate number;
10849: l_shipped_qty number;