[Home] [Help]
116:
117: l_ship_tbl order_shipment_tbl;
118:
119: l_c_ind binary_integer := 0;
120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
117: l_ship_tbl order_shipment_tbl;
118:
119: l_c_ind binary_integer := 0;
120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
118:
119: l_c_ind binary_integer := 0;
120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
119: l_c_ind binary_integer := 0;
120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
128:
121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
128:
129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
128:
129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
130:
123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_tbl;
127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
128:
129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
130:
131: l_msg_count number;
369:
370: l_src_change_owner_to_code varchar2(1);
371: l_src_change_owner varchar2(1);
372:
373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
370: l_src_change_owner_to_code varchar2(1);
371: l_src_change_owner varchar2(1);
372:
373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
371: l_src_change_owner varchar2(1);
372:
373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
372:
373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
380:
373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
380:
381: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
380:
381: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
382: l_msg_count number;
375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;
379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
380:
381: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
382: l_msg_count number;
383: l_msg_data varchar2(2000);
507: x_msg_count number;
508: x_msg_data varchar2(2000);
509:
510: x_order_shipment_tbl order_shipment_tbl;
511: x_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
510: x_order_shipment_tbl order_shipment_tbl;
511: x_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
511: x_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
519: l_order_line_rec order_line_rec;
512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
519: l_order_line_rec order_line_rec;
520: l_trk_oe_line_tbl oe_order_pub.line_tbl_type;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
519: l_order_line_rec order_line_rec;
520: l_trk_oe_line_tbl oe_order_pub.line_tbl_type;
521: l_trackable_parent boolean := FALSE;
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;
518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
519: l_order_line_rec order_line_rec;
520: l_trk_oe_line_tbl oe_order_pub.line_tbl_type;
521: l_trackable_parent boolean := FALSE;
522:
519: l_order_line_rec order_line_rec;
520: l_trk_oe_line_tbl oe_order_pub.line_tbl_type;
521: l_trackable_parent boolean := FALSE;
522:
523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
520: l_trk_oe_line_tbl oe_order_pub.line_tbl_type;
521: l_trackable_parent boolean := FALSE;
522:
523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
521: l_trackable_parent boolean := FALSE;
522:
523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
522:
523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
535: l_trx_rec csi_datastructures_pub.transaction_rec;
529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
535: l_trx_rec csi_datastructures_pub.transaction_rec;
536:
537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
535: l_trx_rec csi_datastructures_pub.transaction_rec;
536:
537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
538:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
535: l_trx_rec csi_datastructures_pub.transaction_rec;
536:
537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
538:
539: x_trx_sub_type_rec txn_sub_type_rec;
540: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
541: x_model_inst_tbl model_inst_tbl;
536:
537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
538:
539: x_trx_sub_type_rec txn_sub_type_rec;
540: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
541: x_model_inst_tbl model_inst_tbl;
542:
543: l_item_control_rec csi_order_ship_pub.item_control_rec;
544: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
543: l_item_control_rec csi_order_ship_pub.item_control_rec;
544: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
545: l_msg_count number;
546: l_msg_data varchar2(2000);
547: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
548: l_t_ii_indx NUMBER := 0;
549:
550: l_error_rec csi_datastructures_pub.transaction_error_rec;
551: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
1395: debug('Error(O) :'||l_error_rec.error_text);
1396: END order_shipment;
1397:
1398: PROCEDURE process_non_source(
1399: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
1400: p_call_contracts IN varchar2 := fnd_api.g_true,
1401: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1402: x_return_status OUT NOCOPY varchar2)
1403: IS
2372: x_msg_count number;
2373: x_msg_data varchar2(2000);
2374: x_trx_line_id number;
2375:
2376: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2377: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2373: x_msg_data varchar2(2000);
2374: x_trx_line_id number;
2375:
2376: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2377: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2374: x_trx_line_id number;
2375:
2376: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2377: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2376: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2377: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2377: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2378: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2379:
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2380: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2381: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2382: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2383: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2384: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2385: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2386: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2387: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2388: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2396: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2389:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2396: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2397:
2390: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2396: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2397:
2398: x_model_inst_tbl model_inst_tbl;
2391: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2396: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2397:
2398: x_model_inst_tbl model_inst_tbl;
2399: l_qty_ratio number;
2392: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2393: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2394: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2395: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2396: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2397:
2398: x_model_inst_tbl model_inst_tbl;
2399: l_qty_ratio number;
2400: l_model_exist boolean := FALSE;
2406: -- Included Transaction rec as part of fix for Bug 2767338
2407: l_trx_rec csi_datastructures_pub.transaction_rec;
2408:
2409: ---Added (Start) for m-to-m enhancements
2410: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2411: ---Added (End) for m-to-m enhancements
2412:
2413: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
2414: --
2845: END build_shtd_table;
2846:
2847:
2848: PROCEDURE check_return_processing(
2849: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2850: x_return_status OUT NOCOPY varchar2)
2851: IS
2852: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2853: l_instance_usage_code varchar2(30) := 'NULL';
2900: PROCEDURE construct_for_txn_exists(
2901: p_txn_sub_type_rec IN txn_sub_type_rec,
2902: p_order_line_rec IN order_line_rec,
2903: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2904: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2905: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2906: x_return_status OUT NOCOPY varchar2)
2907: IS
2908: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2901: p_txn_sub_type_rec IN txn_sub_type_rec,
2902: p_order_line_rec IN order_line_rec,
2903: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2904: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2905: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2906: x_return_status OUT NOCOPY varchar2)
2907: IS
2908: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2909: BEGIN
2962: /* ------------------------------------------------------------------------*/
2963:
2964: PROCEDURE match_txn_with_ship(
2965: p_serial_code IN number,
2966: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2967: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2968: x_return_status OUT NOCOPY varchar2)
2969: IS
2970: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3150: PROCEDURE process_txn_dtl(
3151: p_serial_code IN NUMBER,
3152: p_txn_sub_type_rec IN txn_sub_type_rec,
3153: p_order_line_rec IN order_line_rec,
3154: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3155: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3156: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
3157: x_return_status OUT NOCOPY varchar2)
3158: IS
3151: p_serial_code IN NUMBER,
3152: p_txn_sub_type_rec IN txn_sub_type_rec,
3153: p_order_line_rec IN order_line_rec,
3154: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3155: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3156: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
3157: x_return_status OUT NOCOPY varchar2)
3158: IS
3159:
3166: l_proc_qty number;
3167: l_total_proc_qty number;
3168: l_rem_qty number; --fix for bug 4354267
3169:
3170: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3167: l_total_proc_qty number;
3168: l_rem_qty number; --fix for bug 4354267
3169:
3170: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3168: l_rem_qty number; --fix for bug 4354267
3169:
3170: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3176: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3169:
3170: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3176: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3177:
3170: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3176: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3177:
3178: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3171: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3176: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3177:
3178: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3179: l_msg_count number;
3172: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3173: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3174: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3175: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3176: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3177:
3178: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3179: l_msg_count number;
3180: l_msg_data varchar2(2000);
4574: x_return_status := fnd_api.g_ret_sts_error;
4575: END get_comp_instances_from_wip;
4576:
4577: PROCEDURE get_tld_set(
4578: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4579: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4575: END get_comp_instances_from_wip;
4576:
4577: PROCEDURE get_tld_set(
4578: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4579: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4576:
4577: PROCEDURE get_tld_set(
4578: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4579: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4577: PROCEDURE get_tld_set(
4578: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4579: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4578: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4579: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4586: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4580: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4586: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4587: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4588: x_return_status OUT NOCOPY varchar2)
4581: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4586: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4587: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4588: x_return_status OUT NOCOPY varchar2)
4589: IS
4582: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4586: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4587: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4588: x_return_status OUT NOCOPY varchar2)
4589: IS
4590:
4583: -- out set
4584: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4585: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4586: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4587: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4588: x_return_status OUT NOCOPY varchar2)
4589: IS
4590:
4591: l_create_flag varchar2(1) := 'N';
4589: IS
4590:
4591: l_create_flag varchar2(1) := 'N';
4592:
4593: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4594: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4595: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4596: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4597:
4590:
4591: l_create_flag varchar2(1) := 'N';
4592:
4593: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4594: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4595: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4596: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4597:
4598: l_p_ind binary_integer := 0;
4591: l_create_flag varchar2(1) := 'N';
4592:
4593: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4594: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4595: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4596: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4597:
4598: l_p_ind binary_integer := 0;
4599: l_a_ind binary_integer := 0;
4592:
4593: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4594: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4595: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4596: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4597:
4598: l_p_ind binary_integer := 0;
4599: l_a_ind binary_integer := 0;
4600: l_oa_ind binary_integer := 0;
4694:
4695: -- convert txn_systems in to csi_systems
4696: PROCEDURE create_csi_systems(
4697: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4698: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4699: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4700: x_return_status OUT NOCOPY varchar2)
4701: IS
4702: l_system_exist boolean := FALSE;
4695: -- convert txn_systems in to csi_systems
4696: PROCEDURE create_csi_systems(
4697: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4698: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4699: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4700: x_return_status OUT NOCOPY varchar2)
4701: IS
4702: l_system_exist boolean := FALSE;
4703: l_system_rec csi_datastructures_pub.system_rec;
5065: p_api_version IN number,
5066: p_commit IN varchar2 := fnd_api.g_false,
5067: p_init_msg_list IN varchar2 := fnd_api.g_false,
5068: p_validation_level IN number := fnd_api.g_valid_level_full,
5069: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5066: p_commit IN varchar2 := fnd_api.g_false,
5067: p_init_msg_list IN varchar2 := fnd_api.g_false,
5068: p_validation_level IN number := fnd_api.g_valid_level_full,
5069: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5067: p_init_msg_list IN varchar2 := fnd_api.g_false,
5068: p_validation_level IN number := fnd_api.g_valid_level_full,
5069: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5068: p_validation_level IN number := fnd_api.g_valid_level_full,
5069: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5069: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5070: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5078: p_order_line_rec IN order_line_rec,
5071: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5078: p_order_line_rec IN order_line_rec,
5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,
5072: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5078: p_order_line_rec IN order_line_rec,
5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,
5080: p_source IN varchar2,
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5134: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5135: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5136: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5137: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5138: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5139: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5146: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5147: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5140: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5146: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5147: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5148:
5141: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5146: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5147: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5148:
5149: /* Pricing Attributes variables */
5142:
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5146: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5147: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5148:
5149: /* Pricing Attributes variables */
5150: l_old_index NUMBER := 0;
5143: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5144: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5145: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5146: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5147: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5148:
5149: /* Pricing Attributes variables */
5150: l_old_index NUMBER := 0;
5151: l_new_index NUMBER := 0;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5214: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5215: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5214: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5215: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5216:
5209: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5214: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5215: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5216:
5217: l_quantity1 NUMBER;
5210:
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5214: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5215: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5216:
5217: l_quantity1 NUMBER;
5218: l_quantity2 NUMBER;
5211: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5212: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5213: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5214: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5215: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5216:
5217: l_quantity1 NUMBER;
5218: l_quantity2 NUMBER;
5219: x_system_id NUMBER;
7591: /* txn line details and the child tables */
7592: /*----------------------------------------------------------*/
7593:
7594: PROCEDURE validate_txn_tbl(
7595: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7592: /*----------------------------------------------------------*/
7593:
7594: PROCEDURE validate_txn_tbl(
7595: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7600: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7593:
7594: PROCEDURE validate_txn_tbl(
7595: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7600: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7601: p_order_line_rec IN OUT NOCOPY order_line_rec,
7594: PROCEDURE validate_txn_tbl(
7595: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7600: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7601: p_order_line_rec IN OUT NOCOPY order_line_rec,
7602: p_source IN varchar2,
7595: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7600: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7601: p_order_line_rec IN OUT NOCOPY order_line_rec,
7602: p_source IN varchar2,
7603: x_return_status OUT NOCOPY varchar2)
7596: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7597: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7598: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7599: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7600: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7601: p_order_line_rec IN OUT NOCOPY order_line_rec,
7602: p_source IN varchar2,
7603: x_return_status OUT NOCOPY varchar2)
7604: IS
8224: x_msg_data varchar2(2000);
8225: l_party_site_id NUMBER;
8226: l_trx_line_id NUMBER;
8227:
8228: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8225: l_party_site_id NUMBER;
8226: l_trx_line_id NUMBER;
8227:
8228: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8226: l_trx_line_id NUMBER;
8227:
8228: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8227:
8228: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8228: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8236: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8229: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8236: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8237:
8230: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8236: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8237:
8238: l_install_party_site_id NUMBER;
8231: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8236: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8237:
8238: l_install_party_site_id NUMBER;
8239: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
8232: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8233: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8234: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8235: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8236: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8237:
8238: l_install_party_site_id NUMBER;
8239: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
8240: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;
8744:
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8744:
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8755:
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8755:
8756: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8755:
8756: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8757:
8750: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8751: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8755:
8756: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8757:
8758: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;