DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_ORDER_SHIP_PUB

Line 192: l_cps_tbl csi_order_ship_pub.customer_products_tbl;

188: x_return_status OUT NOCOPY varchar2)
189:
190: IS
191:
192: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
193: l_cp_ind binary_integer := 0;
194: l_ind binary_integer := 0;
195: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
196: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;

Line 195: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;

191:
192: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
193: l_cp_ind binary_integer := 0;
194: l_ind binary_integer := 0;
195: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
196: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;
197: l_acp_ind binary_integer := 0;
198: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
199: l_msg_count number;

Line 196: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;

192: l_cps_tbl csi_order_ship_pub.customer_products_tbl;
193: l_cp_ind binary_integer := 0;
194: l_ind binary_integer := 0;
195: l_all_cps_tbl csi_order_ship_pub.customer_products_tbl;
196: l_single_cps_tbl csi_order_ship_pub.customer_products_tbl;
197: l_acp_ind binary_integer := 0;
198: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
199: l_msg_count number;
200: l_msg_data varchar2(2000);

Line 211: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;

207: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
208: l_bom_explode_flag BOOLEAN := FALSE;
209: l_split_flag varchar2(10);
210: l_auto_split_instances csi_datastructures_pub.instance_tbl;
211: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
212: l_order_line_rec oe_order_lines_all%rowtype;
213:
214:
215: begin

Line 2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;

2429: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2430: l_upd_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
2431: l_upd_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2432: l_upd_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2433: l_upd_order_line_rec csi_order_ship_pub.order_line_rec;
2434: l_tld_found VARCHAR2(1);
2435:
2436: l_instance_party_id number;
2437: l_pty_object_ver_num number;

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

7892: END cz_fulfillment;
7893:
7894: PROCEDURE query_tld_and_update_ib(
7895: p_order_header_rec IN oe_order_headers_all%rowtype,
7896: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
7897: px_default_info_rec IN OUT NOCOPY default_info_rec,
7898: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7899: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
7900: x_return_status OUT NOCOPY varchar2)

Line 7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;

7902:
7903: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7904: l_tld_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7905:
7906: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
7907:
7908: l_p_tl_rec csi_t_datastructures_grp.txn_line_rec;
7909:
7910: l_p_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 8087: csi_order_ship_pub.update_install_base(

8083: l_p_order_line_rec.customer_id := px_default_info_rec.owner_party_acct_id;
8084: l_p_order_line_rec.end_customer_id := px_default_info_rec.owner_party_acct_id;
8085: l_p_order_line_rec.trx_line_id := px_default_info_rec.transaction_line_id;
8086:
8087: csi_order_ship_pub.update_install_base(
8088: p_api_version => 1.0,
8089: p_commit => fnd_api.g_false,
8090: p_init_msg_list => fnd_api.g_true,
8091: p_validation_level => fnd_api.g_valid_level_full,

Line 8216: l_p_order_line_rec csi_order_ship_pub.order_line_rec;

8212:
8213: l_order_line_rec oe_order_lines_all%rowtype;
8214: l_order_header_rec oe_order_headers_all%rowtype;
8215:
8216: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8217: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8218:
8219: l_identified_item_type varchar2(30);
8220: l_processing_status varchar2(30);

Line 9440: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,

9436:
9437: END order_fulfillment;
9438:
9439: PROCEDURE construct_txn_dtls(
9440: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
9441: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
9442: p_trackable_parent IN boolean,
9443: x_trx_line_id OUT NOCOPY NUMBER,
9444: x_return_status OUT NOCOPY varchar2)

Line 9441: p_order_line_rec IN csi_order_ship_pub.order_line_rec,

9437: END order_fulfillment;
9438:
9439: PROCEDURE construct_txn_dtls(
9440: x_order_shipment_tbl IN OUT NOCOPY csi_order_ship_pub.order_shipment_tbl,
9441: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
9442: p_trackable_parent IN boolean,
9443: x_trx_line_id OUT NOCOPY NUMBER,
9444: x_return_status OUT NOCOPY varchar2)
9445: IS

Line 9828: l_order_line_rec csi_order_ship_pub.order_line_rec;

9824: l_msg_count number;
9825:
9826: skip_regular_process exception;
9827: l_error_rec csi_datastructures_pub.transaction_error_rec;
9828: l_order_line_rec csi_order_ship_pub.order_line_rec;
9829: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
9830: l_count number := 0;
9831: l_party_id number;
9832: l_uom_rate number;

Line 9829: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;

9825:
9826: skip_regular_process exception;
9827: l_error_rec csi_datastructures_pub.transaction_error_rec;
9828: l_order_line_rec csi_order_ship_pub.order_line_rec;
9829: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
9830: l_count number := 0;
9831: l_party_id number;
9832: l_uom_rate number;
9833: l_shipped_qty number;