[Home] [Help]
505: RETURN l_uom_code;
506: END get_primay_uom;
507:
508: FUNCTION Check_relation_exists(
509: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
510: p_txn_line_detail_id IN NUMBER)
511: RETURN BOOLEAN
512: IS
513: l_ret_flag BOOLEAN := FALSE;
772: NULL;
773: END get_pricing_attribs;
774:
775: PROCEDURE split_ship_rec(
776: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
773: END get_pricing_attribs;
774:
775: PROCEDURE split_ship_rec(
776: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
774:
775: PROCEDURE split_ship_rec(
776: x_upd_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
777: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
778: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
779: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
780: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
781: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
782: p_proc_qty IN NUMBER,
792: l_party_site_id NUMBER;
793: x_msg_count NUMBER;
794: x_msg_data VARCHAR2(2000);
795:
796: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
793: x_msg_count NUMBER;
794: x_msg_data VARCHAR2(2000);
795:
796: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
801: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
794: x_msg_data VARCHAR2(2000);
795:
796: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
801: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
802:
795:
796: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
801: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
802:
803: l_install_party_site_id NUMBER;
796: x_txn_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
801: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
802:
803: l_install_party_site_id NUMBER;
804: BEGIN
797: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
798: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
799: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
800: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
801: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
802:
803: l_install_party_site_id NUMBER;
804: BEGIN
805:
1006: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1007: END split_ship_rec;
1008:
1009: PROCEDURE create_txn_details(
1010: x_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
1011: p_txn_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
1012: p_order_shipment_rec IN csi_order_ship_pub.order_shipment_rec,
1013: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
1014: x_return_status OUT NOCOPY VARCHAR2)
1023: l_party_site_id NUMBER;
1024: x_msg_data VARCHAR2(2000);
1025: x_msg_count NUMBER;
1026:
1027: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
1028: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1029: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1030: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1031: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1024: x_msg_data VARCHAR2(2000);
1025: x_msg_count NUMBER;
1026:
1027: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
1028: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1029: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1030: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1031: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1032:
1025: x_msg_count NUMBER;
1026:
1027: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
1028: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1029: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1030: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1031: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1032:
1033: BEGIN
1026:
1027: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
1028: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1029: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1030: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1031: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1032:
1033: BEGIN
1034:
1027: x_txn_party_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
1028: x_txn_pty_acct_dtl_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1029: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1030: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1031: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1032:
1033: BEGIN
1034:
1035: x_return_status := fnd_api.g_ret_sts_success;
1175: END create_txn_details;
1176:
1177:
1178: FUNCTION Check_config_exists(
1179: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
1180: p_txn_detail_id IN NUMBER)
1181: RETURN BOOLEAN IS
1182: l_flag BOOLEAN := FALSE;
1183: BEGIN
2185:
2186:
2187: PROCEDURE build_inst_ii_tbl
2188: ( p_orig_inst_id IN NUMBER,
2189: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2190: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,
2191: x_return_status OUT NOCOPY VARCHAR2
2192: ) IS
2193:
2190: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,
2191: x_return_status OUT NOCOPY VARCHAR2
2192: ) IS
2193:
2194: l_temp_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;
2195: l_start NUMBER;
2196: l_ind BINARY_INTEGER;
2197:
2198: BEGIN
2398: END check_standard_bom;
2399:
2400: PROCEDURE get_parties_and_accounts(
2401: p_instance_id IN number,
2402: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2399:
2400: PROCEDURE get_parties_and_accounts(
2401: p_instance_id IN number,
2402: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2400: PROCEDURE get_parties_and_accounts(
2401: p_instance_id IN number,
2402: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2439: l_msg_data varchar2(2000);
2440:
2441: PROCEDURE convert_tpty_to_ipty(
2442: p_instance_id IN number,
2443: p_t_party_rec IN csi_t_datastructures_grp.txn_party_detail_rec,
2444: x_i_party_rec OUT nocopy csi_datastructures_pub.party_rec)
2445: IS
2446: l_insance_party_id number;
2447: l_ovn number;
2498: PROCEDURE convert_tpa_to_ipa(
2499: p_instance_party_id IN number,
2500: p_parent_tbl_index IN number,
2501: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2502: p_t_pa_rec IN csi_t_datastructures_grp.txn_pty_acct_detail_rec,
2503: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)
2504: IS
2505: BEGIN
2506: x_i_pa_rec.parent_tbl_index := p_parent_tbl_index;
2560:
2561: PROCEDURE get_contact_parties(
2562: p_instance_id IN number,
2563: p_t_party_dtl_id IN number,
2564: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2565: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)
2566: IS
2567: x_ind binary_integer := 0;
2568: l_i_pty_rec csi_datastructures_pub.party_rec;
2860: p_source_trx_table IN varchar2,
2861: x_return_status OUT NOCOPY varchar2)
2862: IS
2863:
2864: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2865: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2861: x_return_status OUT NOCOPY varchar2)
2862: IS
2863:
2864: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2865: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2863:
2864: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2865: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2864: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2865: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2865: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2866:
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2867: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2868: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2869: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2870: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2871: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2872: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2873: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2874: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2875: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2876:
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2877: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2878:
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2879: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2880: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2881: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2882: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2890: l_msg_count number;
2883: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2884: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2885: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2886: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2887: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2888:
2889: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2890: l_msg_count number;
2891: l_msg_data varchar2(2000);
3028: PROCEDURE conv_to_prim_uom(
3029: p_inv_organization_id IN NUMBER,
3030: p_inventory_item_id IN NUMBER,
3031: p_uom IN VARCHAR2,
3032: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3033: x_return_status OUT NOCOPY VARCHAR2)
3034: IS
3035: l_primary_uom varchar2(100);
3036: l_uom_rate NUMBER;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3095: l_g_time_stamp date;
3096:
3097: -- create_txn_line_dtls variables
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3095: l_g_time_stamp date;
3096:
3097: -- create_txn_line_dtls variables
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3103: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3096:
3097: -- create_txn_line_dtls variables
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3103: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3104:
3097: -- create_txn_line_dtls variables
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3103: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3104:
3105: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3103: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3104:
3105: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3106: l_msg_count number;
3099: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3100: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3101: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3102: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3103: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3104:
3105: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3106: l_msg_count number;
3107: l_msg_data varchar2(4000);
3201:
3202: PROCEDURE build_parent_relation(
3203: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3204: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3205: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3206: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3207: x_return_status OUT NOCOPY VARCHAR2)
3208: IS
3209: l_txn_ii number := 0;
3202: PROCEDURE build_parent_relation(
3203: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3204: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3205: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3206: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3207: x_return_status OUT NOCOPY VARCHAR2)
3208: IS
3209: l_txn_ii number := 0;
3210: l_nsrc_line_dtl_id number;
3564: split_txn_dtl_id IN NUMBER,
3565: p_split_qty IN NUMBER,
3566: x_return_status OUT NOCOPY varchar2)
3567: IS
3568: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3569: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3565: p_split_qty IN NUMBER,
3566: x_return_status OUT NOCOPY varchar2)
3567: IS
3568: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3569: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3567: IS
3568: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3569: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3568: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3569: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3569: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3570:
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3571: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3572: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3580: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3573: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3580: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3581: l_transaction_line_id number;
3574: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3580: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3581: l_transaction_line_id number;
3582:
3575: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3580: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3581: l_transaction_line_id number;
3582:
3583: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3576: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3577: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3578: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3579: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3580: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3581: l_transaction_line_id number;
3582:
3583: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3584: l_msg_count number;
3680: x_txn_line_dtls_lst OUT NOCOPY txn_line_dtl_tbl,
3681: x_return_status OUT NOCOPY varchar2)
3682: IS
3683:
3684: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3685: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3681: x_return_status OUT NOCOPY varchar2)
3682: IS
3683:
3684: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3685: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3683:
3684: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3685: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3684: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3685: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3685: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3686:
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3687: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3688: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3696: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3689: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3696: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3697:
3690: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3696: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3697:
3698: x_msg_count number;
3691: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3696: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3697:
3698: x_msg_count number;
3699: x_msg_data varchar2(2000);
3692: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3693: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3694: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3695: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3696: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3697:
3698: x_msg_count number;
3699: x_msg_data varchar2(2000);
3700: l_transaction_line_id number;
3824: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3825: END split_txn_dtls;
3826:
3827: PROCEDURE get_system_tbl(
3828: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
3829: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)
3830: IS
3831: BEGIN
3832:
3869: END get_system_tbl;
3870:
3871:
3872: PROCEDURE get_org_assignment_tbl(
3873: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3874: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3875: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3876: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3877: x_return_status OUT NOCOPY VARCHAR2)
3870:
3871:
3872: PROCEDURE get_org_assignment_tbl(
3873: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3874: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3875: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3876: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3877: x_return_status OUT NOCOPY VARCHAR2)
3878: IS
4013: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4014: END get_org_assignment_tbl;
4015:
4016: PROCEDURE get_ext_attribs_tbl(
4017: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
4018: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4019: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4020: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4021: x_return_status OUT NOCOPY VARCHAR2)
4014: END get_org_assignment_tbl;
4015:
4016: PROCEDURE get_ext_attribs_tbl(
4017: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
4018: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4019: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4020: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4021: x_return_status OUT NOCOPY VARCHAR2)
4022: IS
4374: END amend_contracts;
4375:
4376: /* Added p_trx_rec for ER 2581101 */
4377: PROCEDURE get_ii_relation_tbl(
4378: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4375:
4376: /* Added p_trx_rec for ER 2581101 */
4377: PROCEDURE get_ii_relation_tbl(
4378: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4397: l_trx_rec csi_datastructures_pub.transaction_rec;
4398:
4399: --l_srl_code number := null;
4400: l_source_txn_header_id NUMBER ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4398:
4399: --l_srl_code number := null;
4400: l_source_txn_header_id NUMBER ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4399: --l_srl_code number := null;
4400: l_source_txn_header_id NUMBER ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4400: l_source_txn_header_id NUMBER ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4402: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4403: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4404: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4412: x_msg_count NUMBER ;
4405: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4412: x_msg_count NUMBER ;
4413: x_msg_data VARCHAR2(2000);
4406: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4412: x_msg_count NUMBER ;
4413: x_msg_data VARCHAR2(2000);
4414: x_xface_to_IB_flag VARCHAR2(1);
4407: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4408: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4409: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4410: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4411: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4412: x_msg_count NUMBER ;
4413: x_msg_data VARCHAR2(2000);
4414: x_xface_to_IB_flag VARCHAR2(1);
4415: l_index NUMBER ;
4414: x_xface_to_IB_flag VARCHAR2(1);
4415: l_index NUMBER ;
4416: l_txn_dtl_line_found BOOLEAN ;
4417: l_relation_exists BOOLEAN ;
4418: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4419: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4420: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4421: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4422: g_api_name varchar2(80);
4415: l_index NUMBER ;
4416: l_txn_dtl_line_found BOOLEAN ;
4417: l_relation_exists BOOLEAN ;
4418: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4419: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4420: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4421: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4422: g_api_name varchar2(80);
4423: l_old_instance_id NUMBER;
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5169: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5170: x_return_status OUT NOCOPY VARCHAR2)
5171: IS
5172:
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5169: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5170: x_return_status OUT NOCOPY VARCHAR2)
5171: IS
5172:
5173: l_instance_party_id NUMBER;
5402: p_ratio IN NUMBER,
5403: x_return_status OUT NOCOPY VARCHAR2
5404: ) IS
5405:
5406: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5407: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5403: x_return_status OUT NOCOPY VARCHAR2
5404: ) IS
5405:
5406: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5407: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5405:
5406: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5407: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5406: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5407: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5407: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5408:
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5409: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5410: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5418: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5411: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5418: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5419:
5412: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5418: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5419:
5420: x_msg_count number;
5413: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5418: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5419:
5420: x_msg_count number;
5421: x_msg_data varchar2(2000);
5414: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5415: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5416: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5417: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5418: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5419:
5420: x_msg_count number;
5421: x_msg_data varchar2(2000);
5422: l_end integer;
5622: x_return_status := fnd_api.g_ret_sts_error ;
5623: END derive_party_id;
5624:
5625: PROCEDURE get_party_owner(
5626: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5623: END derive_party_id;
5624:
5625: PROCEDURE get_party_owner(
5626: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5624:
5625: PROCEDURE get_party_owner(
5626: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5918: if the source instance is a replacement component.
5919: */
5920: PROCEDURE call_contracts_chk(
5921: p_txn_line_detail_id in number,
5922: p_txn_ii_rltns_tbl in csi_t_datastructures_grp.txn_ii_rltns_tbl,
5923: x_call_contracts OUT NOCOPY varchar2,
5924: x_return_status OUT NOCOPY varchar2)
5925: IS
5926: BEGIN
6073: --- 05/16 added procedure to check whether the TXN relations
6074: ---are already interfaced to IB
6075: -----------------------------------------------------------------------
6076:
6077: PROCEDURE rltns_xfaced_to_IB (p_xtn_ii_rltns_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6078: x_xface_to_IB_flag OUT NOCOPY VARCHAR2,
6079: x_return_status OUT NOCOPY VARCHAR2)
6080: IS
6081: CURSOR get_instance_id (c_txn_line_detail_id IN NUMBER)
6171: ---between TLD's based on the user entered TLD relations
6172: -----------------------------------------------------------------------
6173:
6174: PROCEDURE build_txn_relations (
6175: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
6176: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6177: x_return_status OUT NOCOPY VARCHAR2)
6178: IS
6179: l_orig_oe_tld NUMBER ;
6172: -----------------------------------------------------------------------
6173:
6174: PROCEDURE build_txn_relations (
6175: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
6176: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6177: x_return_status OUT NOCOPY VARCHAR2)
6178: IS
6179: l_orig_oe_tld NUMBER ;
6180: l_partner_oe_tld NUMBER ;
6178: IS
6179: l_orig_oe_tld NUMBER ;
6180: l_partner_oe_tld NUMBER ;
6181: l_relations_exists BOOLEAN := FALSE ;
6182: l_oe_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6183: l_partner_tld VARCHAR2(10) ;
6184: l_ii_indx NUMBER ;
6185: l_index NUMBER ;
6186: l_src_txn_table VARCHAR2(100);
6363: --associated with it. It also gets the details of the partner TLD's
6364: -------------------------------------------------------------------------------
6365:
6366:
6367: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6368: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6369: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6370: x_return_status OUT NOCOPY VARCHAR2)
6371: IS
6364: -------------------------------------------------------------------------------
6365:
6366:
6367: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6368: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6369: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6370: x_return_status OUT NOCOPY VARCHAR2)
6371: IS
6372: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6365:
6366:
6367: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6368: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6369: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6370: x_return_status OUT NOCOPY VARCHAR2)
6371: IS
6372: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6373: IS
6376: WHERE (( subject_type = 'T' AND subject_id = c_txn_line_detail_id )
6377: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6378: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6379:
6380: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6377: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6378: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6379:
6380: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6378: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6379:
6380: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6379:
6380: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6380: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6381: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6389: x_msg_count NUMBER ;
6382: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6389: x_msg_count NUMBER ;
6390: x_msg_data VARCHAR2(2000);
6383: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6389: x_msg_count NUMBER ;
6390: x_msg_data VARCHAR2(2000);
6391: l_index NUMBER := 0 ;
6384: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6385: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6386: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6387: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6388: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6389: x_msg_count NUMBER ;
6390: x_msg_data VARCHAR2(2000);
6391: l_index NUMBER := 0 ;
6392: l_indx NUMBER := 0;
6389: x_msg_count NUMBER ;
6390: x_msg_data VARCHAR2(2000);
6391: l_index NUMBER := 0 ;
6392: l_indx NUMBER := 0;
6393: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6394: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
6395:
6396: BEGIN
6397: debug('Begin get_partner_rltns'|| p_txn_line_detail_rec.txn_line_detail_id );
6390: x_msg_data VARCHAR2(2000);
6391: l_index NUMBER := 0 ;
6392: l_indx NUMBER := 0;
6393: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6394: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
6395:
6396: BEGIN
6397: debug('Begin get_partner_rltns'|| p_txn_line_detail_rec.txn_line_detail_id );
6398: FOR txn_ii_relns_rec IN txn_ii_relns_cur(p_txn_line_detail_rec.txn_line_detail_id)
6596: /* ------------------------------------------------------------------- */
6597:
6598: PROCEDURE distribute_instances(
6599: p_quantity_ratio IN number,
6600: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6601: p_split_flag IN varchar2,--bug 14534435
6602: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6603: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6604: x_return_status OUT NOCOPY varchar2)
6607: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;
6608:
6609: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6608:
6609: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6609: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6617: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6617: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6618:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6617: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6618:
6619: l_object_id number;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6617: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6618:
6619: l_object_id number;
6620: l_inst_ind binary_integer;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6614: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6615: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6616: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6617: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6618:
6619: l_object_id number;
6620: l_inst_ind binary_integer;
6621:
7024: END filter_processed_instances;
7025:
7026: PROCEDURE build_child_relation(
7027: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
7028: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
7029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7030: x_return_status OUT NOCOPY varchar2)
7031: IS
7032:
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;
7039:
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;
7039:
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7039:
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7042:
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7043: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7044: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7052: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7045: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7052: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7053:
7046: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7052: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7053:
7054: l_line_tbl oe_order_pub.line_tbl_type;
7047: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7052: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7053:
7054: l_line_tbl oe_order_pub.line_tbl_type;
7055: l_quantity_ratio number;
7048: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7049: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7050: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7051: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7052: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7053:
7054: l_line_tbl oe_order_pub.line_tbl_type;
7055: l_quantity_ratio number;
7056: