APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_DATASTRUCTURES_GRP

Line 120: l_c_tl_rec csi_t_datastructures_grp.txn_line_rec ;

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;

Line 121: l_c_tld_tbl csi_t_datastructures_grp.txn_line_detail_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;

Line 122: l_c_t_pty_tbl csi_t_datastructures_grp.txn_party_detail_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;

Line 123: l_c_t_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 124: l_c_t_oa_tbl csi_t_datastructures_grp.txn_org_assgn_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:

Line 125: l_c_t_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

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;

Line 126: l_c_t_sys_tbl csi_t_datastructures_grp.txn_systems_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;
130:

Line 127: l_c_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_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:
131: l_msg_count number;

Line 373: l_c_tld_rec csi_t_datastructures_grp.txn_line_detail_rec ;

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;

Line 374: l_c_tpd_tbl csi_t_datastructures_grp.txn_party_detail_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;

Line 375: l_c_tpad_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 376: l_c_toa_tbl csi_t_datastructures_grp.txn_org_assgn_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:

Line 377: l_c_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

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;

Line 378: l_c_ts_tbl csi_t_datastructures_grp.txn_systems_tbl;

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;

Line 379: l_c_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_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;
383: l_msg_data varchar2(2000);

Line 511: x_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;

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;

Line 514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_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;

Line 515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_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;

Line 516: l_txn_line_rec csi_t_datastructures_grp.txn_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;

Line 517: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;

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;

Line 518: l_tmp_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

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:

Line 523: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

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;

Line 524: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_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;

Line 525: l_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_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;

Line 526: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_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 ;

Line 527: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_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;

Line 528: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_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:

Line 529: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_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:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 530: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_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;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_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;
535: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_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;

Line 534: l_new_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:

Line 537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

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;

Line 540: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_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;

Line 547: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

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;

Line 1342: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,

1338: debug('Error(O) :'||l_error_rec.error_text);
1339: END order_shipment;
1340:
1341: PROCEDURE process_non_source(
1342: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
1343: p_call_contracts IN varchar2 := fnd_api.g_true,
1344: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1345: x_return_status OUT NOCOPY varchar2)
1346: IS

Line 2317: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

2313: x_msg_count number;
2314: x_msg_data varchar2(2000);
2315: x_trx_line_id number;
2316:
2317: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

2314: x_msg_data varchar2(2000);
2315: x_trx_line_id number;
2316:
2317: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

2315: x_trx_line_id number;
2316:
2317: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2317: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2318: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2319: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2320:
2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;

Line 2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2321: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

2322: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:

Line 2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

2323: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;

2324: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

2325: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2326: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

2327: l_extend_attrib_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

2328: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2329: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

2330:
2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2338:

Line 2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

2331: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2338:
2339: x_model_inst_tbl model_inst_tbl;

Line 2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

2332: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2338:
2339: x_model_inst_tbl model_inst_tbl;
2340: l_qty_ratio number;

Line 2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

2333: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2334: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2335: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2336: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2337: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2338:
2339: x_model_inst_tbl model_inst_tbl;
2340: l_qty_ratio number;
2341: l_model_exist boolean := FALSE;

Line 2351: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

2347: -- Included Transaction rec as part of fix for Bug 2767338
2348: l_trx_rec csi_datastructures_pub.transaction_rec;
2349:
2350: ---Added (Start) for m-to-m enhancements
2351: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2352: ---Added (End) for m-to-m enhancements
2353:
2354: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
2355: --

Line 2790: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2786: END build_shtd_table;
2787:
2788:
2789: PROCEDURE check_return_processing(
2790: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2791: x_return_status OUT NOCOPY varchar2)
2792: IS
2793: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2794: l_instance_usage_code varchar2(30) := 'NULL';

Line 2845: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

2841: PROCEDURE construct_for_txn_exists(
2842: p_txn_sub_type_rec IN txn_sub_type_rec,
2843: p_order_line_rec IN order_line_rec,
2844: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2845: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2846: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2847: x_return_status OUT NOCOPY varchar2)
2848: IS
2849: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2846: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2842: p_txn_sub_type_rec IN txn_sub_type_rec,
2843: p_order_line_rec IN order_line_rec,
2844: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2845: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2846: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2847: x_return_status OUT NOCOPY varchar2)
2848: IS
2849: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2850: BEGIN

Line 2907: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

2903: /* ------------------------------------------------------------------------*/
2904:
2905: PROCEDURE match_txn_with_ship(
2906: p_serial_code IN number,
2907: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2908: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
2909: x_return_status OUT NOCOPY varchar2)
2910: IS
2911: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 3095: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

3091: PROCEDURE process_txn_dtl(
3092: p_serial_code IN NUMBER,
3093: p_txn_sub_type_rec IN txn_sub_type_rec,
3094: p_order_line_rec IN order_line_rec,
3095: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3096: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3097: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
3098: x_return_status OUT NOCOPY varchar2)
3099: IS

Line 3096: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

3092: p_serial_code IN NUMBER,
3093: p_txn_sub_type_rec IN txn_sub_type_rec,
3094: p_order_line_rec IN order_line_rec,
3095: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3096: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3097: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
3098: x_return_status OUT NOCOPY varchar2)
3099: IS
3100:

Line 3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

3107: l_proc_qty number;
3108: l_total_proc_qty number;
3109: l_rem_qty number; --fix for bug 4354267
3110:
3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

3108: l_total_proc_qty number;
3109: l_rem_qty number; --fix for bug 4354267
3110:
3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

3109: l_rem_qty number; --fix for bug 4354267
3110:
3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

3110:
3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3118:

Line 3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

3111: l_upd_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3118:
3119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

3112: l_upd_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3118:
3119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3120: l_msg_count number;

Line 3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

3113: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3114: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3115: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3116: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3117: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3118:
3119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3120: l_msg_count number;
3121: l_msg_data varchar2(2000);

Line 4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

4495: x_return_status := fnd_api.g_ret_sts_error;
4496: END get_comp_instances_from_wip;
4497:
4498: PROCEDURE get_tld_set(
4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

4496: END get_comp_instances_from_wip;
4497:
4498: PROCEDURE get_tld_set(
4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set

Line 4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

4497:
4498: PROCEDURE get_tld_set(
4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

4498: PROCEDURE get_tld_set(
4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

4499: px_tld_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
4500: px_tld_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

4501: px_tld_account_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4508: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4509: x_return_status OUT NOCOPY varchar2)

Line 4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

4502: px_tld_oa_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4508: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4509: x_return_status OUT NOCOPY varchar2)
4510: IS

Line 4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

4503: px_tld_ea_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4508: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4509: x_return_status OUT NOCOPY varchar2)
4510: IS
4511:

Line 4508: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

4504: -- out set
4505: x_tld_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4506: x_tld_account_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4507: x_tld_oa_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4508: x_tld_ea_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4509: x_return_status OUT NOCOPY varchar2)
4510: IS
4511:
4512: l_create_flag varchar2(1) := 'N';

Line 4514: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

4510: IS
4511:
4512: l_create_flag varchar2(1) := 'N';
4513:
4514: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4515: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4516: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4517: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4518:

Line 4515: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

4511:
4512: l_create_flag varchar2(1) := 'N';
4513:
4514: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4515: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4516: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4517: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4518:
4519: l_p_ind binary_integer := 0;

Line 4516: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

4512: l_create_flag varchar2(1) := 'N';
4513:
4514: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4515: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4516: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4517: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4518:
4519: l_p_ind binary_integer := 0;
4520: l_a_ind binary_integer := 0;

Line 4517: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

4513:
4514: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4515: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4516: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4517: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4518:
4519: l_p_ind binary_integer := 0;
4520: l_a_ind binary_integer := 0;
4521: l_oa_ind binary_integer := 0;

Line 4619: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

4615:
4616: -- convert txn_systems in to csi_systems
4617: PROCEDURE create_csi_systems(
4618: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4619: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4620: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4621: x_return_status OUT NOCOPY varchar2)
4622: IS
4623: l_system_exist boolean := FALSE;

Line 4620: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

4616: -- convert txn_systems in to csi_systems
4617: PROCEDURE create_csi_systems(
4618: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4619: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4620: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4621: x_return_status OUT NOCOPY varchar2)
4622: IS
4623: l_system_exist boolean := FALSE;
4624: l_system_rec csi_datastructures_pub.system_rec;

Line 4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

4865: p_api_version IN number,
4866: p_commit IN varchar2 := fnd_api.g_false,
4867: p_init_msg_list IN varchar2 := fnd_api.g_false,
4868: p_validation_level IN number := fnd_api.g_valid_level_full,
4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

4866: p_commit IN varchar2 := fnd_api.g_false,
4867: p_init_msg_list IN varchar2 := fnd_api.g_false,
4868: p_validation_level IN number := fnd_api.g_valid_level_full,
4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

4867: p_init_msg_list IN varchar2 := fnd_api.g_false,
4868: p_validation_level IN number := fnd_api.g_valid_level_full,
4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

4868: p_validation_level IN number := fnd_api.g_valid_level_full,
4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

Line 4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

4869: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

4870: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4878: p_order_line_rec IN order_line_rec,

Line 4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

4871: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4878: p_order_line_rec IN order_line_rec,
4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,

Line 4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

4872: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4878: p_order_line_rec IN order_line_rec,
4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4880: p_source IN varchar2,

Line 4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;

Line 4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

4934: l_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:

Line 4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

4935: l_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;

4936: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

4937: l_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4938: l_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

4939: l_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

4940: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4948:

Line 4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

4941: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4948:
4949: /* Pricing Attributes variables */

Line 4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

4942:
4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4948:
4949: /* Pricing Attributes variables */
4950: l_old_index NUMBER := 0;

Line 4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

4943: l_upd_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
4944: l_upd_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
4945: l_upd_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4946: l_upd_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
4947: l_upd_txn_ext_attr_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
4948:
4949: /* Pricing Attributes variables */
4950: l_old_index NUMBER := 0;
4951: l_new_index NUMBER := 0;

Line 5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:

Line 5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;

5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5016:

Line 5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

5009: l_all_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5016:
5017: l_quantity1 NUMBER;

Line 5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

5010:
5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5016:
5017: l_quantity1 NUMBER;
5018: l_quantity2 NUMBER;

Line 5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

5011: l_tld_rec csi_t_datastructures_grp.txn_line_detail_rec;
5012: l_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5013: l_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5014: l_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5015: l_tld_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5016:
5017: l_quantity1 NUMBER;
5018: l_quantity2 NUMBER;
5019: x_system_id NUMBER;

Line 7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

7272: /* txn line details and the child tables */
7273: /*----------------------------------------------------------*/
7274:
7275: PROCEDURE validate_txn_tbl(
7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

7273: /*----------------------------------------------------------*/
7274:
7275: PROCEDURE validate_txn_tbl(
7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

7274:
7275: PROCEDURE validate_txn_tbl(
7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7282: p_order_line_rec IN OUT NOCOPY order_line_rec,

Line 7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

7275: PROCEDURE validate_txn_tbl(
7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7282: p_order_line_rec IN OUT NOCOPY order_line_rec,
7283: p_source IN varchar2,

Line 7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

7276: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7282: p_order_line_rec IN OUT NOCOPY order_line_rec,
7283: p_source IN varchar2,
7284: x_return_status OUT NOCOPY varchar2)

Line 7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

7277: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
7278: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
7279: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
7280: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
7281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
7282: p_order_line_rec IN OUT NOCOPY order_line_rec,
7283: p_source IN varchar2,
7284: x_return_status OUT NOCOPY varchar2)
7285: IS

Line 7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;

7905: x_msg_data varchar2(2000);
7906: l_party_site_id NUMBER;
7907: l_trx_line_id NUMBER;
7908:
7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

7906: l_party_site_id NUMBER;
7907: l_trx_line_id NUMBER;
7908:
7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

7907: l_trx_line_id NUMBER;
7908:
7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;

7908:
7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

7909: x_cre_txn_line_rec csi_t_datastructures_grp.txn_line_rec ;
7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

7910: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7918:

Line 7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

7911: x_cre_txn_line_dtls_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7918:
7919: l_install_party_site_id NUMBER;

Line 7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

7912: x_cre_txn_party_dtls_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7918:
7919: l_install_party_site_id NUMBER;
7920: l_parent_line_qty NUMBER := fnd_api.g_miss_num;

Line 7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

7913: x_cre_txn_pty_acct_dtls_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7914: x_cre_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: x_cre_txn_ext_attb_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: x_cre_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: x_cre_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7918:
7919: l_install_party_site_id NUMBER;
7920: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
7921: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

8424: l_source_line_rec csi_interface_pkg.source_line_rec;
8425:
8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

8425:
8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8436:

Line 8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8436:
8437: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8436:
8437: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8438:

Line 8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

8431: l_txn_party_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
8432: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8436:
8437: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8438:
8439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;