[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,
2437: l_msg_data varchar2(2000);
2438:
2439: PROCEDURE convert_tpty_to_ipty(
2440: p_instance_id IN number,
2441: p_t_party_rec IN csi_t_datastructures_grp.txn_party_detail_rec,
2442: x_i_party_rec OUT nocopy csi_datastructures_pub.party_rec)
2443: IS
2444: l_insance_party_id number;
2445: l_ovn number;
2496: PROCEDURE convert_tpa_to_ipa(
2497: p_instance_party_id IN number,
2498: p_parent_tbl_index IN number,
2499: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2500: p_t_pa_rec IN csi_t_datastructures_grp.txn_pty_acct_detail_rec,
2501: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)
2502: IS
2503: BEGIN
2504: x_i_pa_rec.parent_tbl_index := p_parent_tbl_index;
2558:
2559: PROCEDURE get_contact_parties(
2560: p_instance_id IN number,
2561: p_t_party_dtl_id IN number,
2562: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2563: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)
2564: IS
2565: x_ind binary_integer := 0;
2566: l_i_pty_rec csi_datastructures_pub.party_rec;
2818: p_source_trx_table IN varchar2,
2819: x_return_status OUT NOCOPY varchar2)
2820: IS
2821:
2822: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2823: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2819: x_return_status OUT NOCOPY varchar2)
2820: IS
2821:
2822: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2823: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2821:
2822: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2823: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2822: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
2823: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2823: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2824:
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2825: o_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2826: o_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2827: o_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2828: o_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2829: o_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2830: o_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2831: o_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2832: o_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2833: o_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2834:
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2835: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2836:
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2837: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2845: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2838: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2845: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2846:
2839: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2845: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2846:
2847: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2840: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2845: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2846:
2847: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2848: l_msg_count number;
2841: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2842: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
2843: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
2844: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
2845: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
2846:
2847: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2848: l_msg_count number;
2849: l_msg_data varchar2(2000);
2986: PROCEDURE conv_to_prim_uom(
2987: p_inv_organization_id IN NUMBER,
2988: p_inventory_item_id IN NUMBER,
2989: p_uom IN VARCHAR2,
2990: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
2991: x_return_status OUT NOCOPY VARCHAR2)
2992: IS
2993: l_primary_uom varchar2(100);
2994: l_uom_rate NUMBER;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3053: l_g_time_stamp date;
3054:
3055: -- create_txn_line_dtls variables
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3053: l_g_time_stamp date;
3054:
3055: -- create_txn_line_dtls variables
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3061: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3054:
3055: -- create_txn_line_dtls variables
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3061: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3062:
3055: -- create_txn_line_dtls variables
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3061: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3062:
3063: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3061: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3062:
3063: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3064: l_msg_count number;
3057: l_n_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3058: l_n_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3059: l_n_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3060: l_n_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3061: l_n_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3062:
3063: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3064: l_msg_count number;
3065: l_msg_data varchar2(4000);
3159:
3160: PROCEDURE build_parent_relation(
3161: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3162: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3163: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3164: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3165: x_return_status OUT NOCOPY VARCHAR2)
3166: IS
3167: l_txn_ii number := 0;
3160: PROCEDURE build_parent_relation(
3161: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
3162: x_model_inst_tbl IN OUT NOCOPY csi_order_ship_pub.model_inst_tbl,
3163: x_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
3164: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
3165: x_return_status OUT NOCOPY VARCHAR2)
3166: IS
3167: l_txn_ii number := 0;
3168: l_nsrc_line_dtl_id number;
3522: split_txn_dtl_id IN NUMBER,
3523: p_split_qty IN NUMBER,
3524: x_return_status OUT NOCOPY varchar2)
3525: IS
3526: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3527: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3523: p_split_qty IN NUMBER,
3524: x_return_status OUT NOCOPY varchar2)
3525: IS
3526: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3527: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3525: IS
3526: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3527: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3526: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3527: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3527: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3528:
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3529: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3530: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3538: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3531: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3538: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3539: l_transaction_line_id number;
3532: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3538: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3539: l_transaction_line_id number;
3540:
3533: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3538: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3539: l_transaction_line_id number;
3540:
3541: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3534: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3535: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3536: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3537: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3538: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3539: l_transaction_line_id number;
3540:
3541: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3542: l_msg_count number;
3638: x_txn_line_dtls_lst OUT NOCOPY txn_line_dtl_tbl,
3639: x_return_status OUT NOCOPY varchar2)
3640: IS
3641:
3642: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3643: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3639: x_return_status OUT NOCOPY varchar2)
3640: IS
3641:
3642: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3643: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3641:
3642: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3643: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3642: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3643: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3643: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3644:
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3645: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3646: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3654: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3647: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3654: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3655:
3648: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3654: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3655:
3656: x_msg_count number;
3649: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3654: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3655:
3656: x_msg_count number;
3657: x_msg_data varchar2(2000);
3650: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3651: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3652: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3653: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3654: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3655:
3656: x_msg_count number;
3657: x_msg_data varchar2(2000);
3658: l_transaction_line_id number;
3782: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3783: END split_txn_dtls;
3784:
3785: PROCEDURE get_system_tbl(
3786: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
3787: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)
3788: IS
3789: BEGIN
3790:
3827: END get_system_tbl;
3828:
3829:
3830: PROCEDURE get_org_assignment_tbl(
3831: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3832: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3833: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3834: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3835: x_return_status OUT NOCOPY VARCHAR2)
3828:
3829:
3830: PROCEDURE get_org_assignment_tbl(
3831: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3832: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3833: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3834: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3835: x_return_status OUT NOCOPY VARCHAR2)
3836: IS
3971: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3972: END get_org_assignment_tbl;
3973:
3974: PROCEDURE get_ext_attribs_tbl(
3975: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3976: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3977: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3978: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3979: x_return_status OUT NOCOPY VARCHAR2)
3972: END get_org_assignment_tbl;
3973:
3974: PROCEDURE get_ext_attribs_tbl(
3975: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3976: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3977: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3978: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3979: x_return_status OUT NOCOPY VARCHAR2)
3980: IS
4332: END amend_contracts;
4333:
4334: /* Added p_trx_rec for ER 2581101 */
4335: PROCEDURE get_ii_relation_tbl(
4336: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4337: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4339: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4333:
4334: /* Added p_trx_rec for ER 2581101 */
4335: PROCEDURE get_ii_relation_tbl(
4336: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4337: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4339: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4341: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4355: l_trx_rec csi_datastructures_pub.transaction_rec;
4356:
4357: --l_srl_code number := null;
4358: l_source_txn_header_id NUMBER ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4356:
4357: --l_srl_code number := null;
4358: l_source_txn_header_id NUMBER ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4357: --l_srl_code number := null;
4358: l_source_txn_header_id NUMBER ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4358: l_source_txn_header_id NUMBER ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4360: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4361: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4362: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4370: x_msg_count NUMBER ;
4363: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4370: x_msg_count NUMBER ;
4371: x_msg_data VARCHAR2(2000);
4364: x_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4370: x_msg_count NUMBER ;
4371: x_msg_data VARCHAR2(2000);
4372: x_xface_to_IB_flag VARCHAR2(1);
4365: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
4366: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
4367: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
4368: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
4369: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
4370: x_msg_count NUMBER ;
4371: x_msg_data VARCHAR2(2000);
4372: x_xface_to_IB_flag VARCHAR2(1);
4373: l_index NUMBER ;
4372: x_xface_to_IB_flag VARCHAR2(1);
4373: l_index NUMBER ;
4374: l_txn_dtl_line_found BOOLEAN ;
4375: l_relation_exists BOOLEAN ;
4376: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4377: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4378: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4379: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4380: g_api_name varchar2(80);
4373: l_index NUMBER ;
4374: l_txn_dtl_line_found BOOLEAN ;
4375: l_relation_exists BOOLEAN ;
4376: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4377: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4378: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4379: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4380: g_api_name varchar2(80);
4381: l_old_instance_id NUMBER;
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5125: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5126: x_return_status OUT NOCOPY VARCHAR2)
5127: IS
5128:
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5125: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5126: x_return_status OUT NOCOPY VARCHAR2)
5127: IS
5128:
5129: l_instance_party_id NUMBER;
5323: p_ratio IN NUMBER,
5324: x_return_status OUT NOCOPY VARCHAR2
5325: ) IS
5326:
5327: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5328: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5324: x_return_status OUT NOCOPY VARCHAR2
5325: ) IS
5326:
5327: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5328: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5326:
5327: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5328: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5327: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5328: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5328: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5329:
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5330: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5331: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5339: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5332: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5339: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5340:
5333: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5339: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5340:
5341: x_msg_count number;
5334: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5339: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5340:
5341: x_msg_count number;
5342: x_msg_data varchar2(2000);
5335: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
5336: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
5337: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
5338: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
5339: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
5340:
5341: x_msg_count number;
5342: x_msg_data varchar2(2000);
5343: l_end integer;
5543: x_return_status := fnd_api.g_ret_sts_error ;
5544: END derive_party_id;
5545:
5546: PROCEDURE get_party_owner(
5547: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5548: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5549: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5544: END derive_party_id;
5545:
5546: PROCEDURE get_party_owner(
5547: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5548: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5549: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5545:
5546: PROCEDURE get_party_owner(
5547: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
5548: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5549: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5839: if the source instance is a replacement component.
5840: */
5841: PROCEDURE call_contracts_chk(
5842: p_txn_line_detail_id in number,
5843: p_txn_ii_rltns_tbl in csi_t_datastructures_grp.txn_ii_rltns_tbl,
5844: x_call_contracts OUT NOCOPY varchar2,
5845: x_return_status OUT NOCOPY varchar2)
5846: IS
5847: BEGIN
5994: --- 05/16 added procedure to check whether the TXN relations
5995: ---are already interfaced to IB
5996: -----------------------------------------------------------------------
5997:
5998: PROCEDURE rltns_xfaced_to_IB (p_xtn_ii_rltns_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
5999: x_xface_to_IB_flag OUT NOCOPY VARCHAR2,
6000: x_return_status OUT NOCOPY VARCHAR2)
6001: IS
6002: CURSOR get_instance_id (c_txn_line_detail_id IN NUMBER)
6092: ---between TLD's based on the user entered TLD relations
6093: -----------------------------------------------------------------------
6094:
6095: PROCEDURE build_txn_relations (
6096: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
6097: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6098: x_return_status OUT NOCOPY VARCHAR2)
6099: IS
6100: l_orig_oe_tld NUMBER ;
6093: -----------------------------------------------------------------------
6094:
6095: PROCEDURE build_txn_relations (
6096: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl ,
6097: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6098: x_return_status OUT NOCOPY VARCHAR2)
6099: IS
6100: l_orig_oe_tld NUMBER ;
6101: l_partner_oe_tld NUMBER ;
6099: IS
6100: l_orig_oe_tld NUMBER ;
6101: l_partner_oe_tld NUMBER ;
6102: l_relations_exists BOOLEAN := FALSE ;
6103: l_oe_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6104: l_partner_tld VARCHAR2(10) ;
6105: l_ii_indx NUMBER ;
6106: l_index NUMBER ;
6107: l_src_txn_table VARCHAR2(100);
6284: --associated with it. It also gets the details of the partner TLD's
6285: -------------------------------------------------------------------------------
6286:
6287:
6288: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6289: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6290: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6291: x_return_status OUT NOCOPY VARCHAR2)
6292: IS
6285: -------------------------------------------------------------------------------
6286:
6287:
6288: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6289: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6290: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6291: x_return_status OUT NOCOPY VARCHAR2)
6292: IS
6293: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6286:
6287:
6288: PROCEDURE get_partner_rltns (p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec ,
6289: x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
6290: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
6291: x_return_status OUT NOCOPY VARCHAR2)
6292: IS
6293: CURSOR txn_ii_relns_cur (c_txn_line_detail_id IN NUMBER)
6294: IS
6297: WHERE (( subject_type = 'T' AND subject_id = c_txn_line_detail_id )
6298: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6299: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6300:
6301: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6298: OR (object_type = 'T' AND object_id = c_txn_line_detail_id ))
6299: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6300:
6301: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6299: AND NVL(active_end_date ,SYSDATE) >= SYSDATE ;
6300:
6301: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6300:
6301: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6301: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6302: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6310: x_msg_count NUMBER ;
6303: x_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl ;
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6310: x_msg_count NUMBER ;
6311: x_msg_data VARCHAR2(2000);
6304: x_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6310: x_msg_count NUMBER ;
6311: x_msg_data VARCHAR2(2000);
6312: l_index NUMBER := 0 ;
6305: x_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6306: x_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl ;
6307: x_csi_ext_attribs_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6308: x_csi_iea_values_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl ;
6309: x_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl ;
6310: x_msg_count NUMBER ;
6311: x_msg_data VARCHAR2(2000);
6312: l_index NUMBER := 0 ;
6313: l_indx NUMBER := 0;
6310: x_msg_count NUMBER ;
6311: x_msg_data VARCHAR2(2000);
6312: l_index NUMBER := 0 ;
6313: l_indx NUMBER := 0;
6314: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6315: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
6316:
6317: BEGIN
6318: debug('Begin get_partner_rltns'|| p_txn_line_detail_rec.txn_line_detail_id );
6311: x_msg_data VARCHAR2(2000);
6312: l_index NUMBER := 0 ;
6313: l_indx NUMBER := 0;
6314: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6315: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
6316:
6317: BEGIN
6318: debug('Begin get_partner_rltns'|| p_txn_line_detail_rec.txn_line_detail_id );
6319: FOR txn_ii_relns_rec IN txn_ii_relns_cur(p_txn_line_detail_rec.txn_line_detail_id)
6517: /* ------------------------------------------------------------------- */
6518:
6519: PROCEDURE distribute_instances(
6520: p_quantity_ratio IN number,
6521: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6522: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6523: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6524: x_return_status OUT NOCOPY varchar2)
6525: IS
6527: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;
6528:
6529: l_instance_tbl csi_datastructures_pub.instance_tbl;
6530:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6528:
6529: l_instance_tbl csi_datastructures_pub.instance_tbl;
6530:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6529: l_instance_tbl csi_datastructures_pub.instance_tbl;
6530:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6537: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6530:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6537: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6538:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6537: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6538:
6539: l_object_id number;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6537: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6538:
6539: l_object_id number;
6540: l_inst_ind binary_integer;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6534: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6535: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6536: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6537: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6538:
6539: l_object_id number;
6540: l_inst_ind binary_integer;
6541:
6936: END filter_processed_instances;
6937:
6938: PROCEDURE build_child_relation(
6939: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
6940: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6941: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6942: x_return_status OUT NOCOPY varchar2)
6943: IS
6944:
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;
6951:
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;
6951:
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6951:
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6954:
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6955: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6956: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6964: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6957: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6964: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6965:
6958: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6964: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6965:
6966: l_line_tbl oe_order_pub.line_tbl_type;
6959: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6964: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6965:
6966: l_line_tbl oe_order_pub.line_tbl_type;
6967: l_quantity_ratio number;
6960: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6961: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6962: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
6963: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6964: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
6965:
6966: l_line_tbl oe_order_pub.line_tbl_type;
6967: l_quantity_ratio number;
6968: