17: p_pkg_name => 'csi_order_fulfill_pub');
18: END api_log;
19:
20: PROCEDURE create_csi_transaction(
21: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
22: x_return_status OUT nocopy varchar2)
23: IS
24: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
25: l_msg_count number;
108:
109:
110: -- added for the bug 5464761
111: PROCEDURE auto_split_instances(
112: p_instance_rec IN csi_datastructures_pub.instance_rec,
113: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
114: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
115: x_return_status OUT nocopy varchar2)
116: IS
109:
110: -- added for the bug 5464761
111: PROCEDURE auto_split_instances(
112: p_instance_rec IN csi_datastructures_pub.instance_rec,
113: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
114: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
115: x_return_status OUT nocopy varchar2)
116: IS
117: l_src_instance_rec csi_datastructures_pub.instance_rec;
110: -- added for the bug 5464761
111: PROCEDURE auto_split_instances(
112: p_instance_rec IN csi_datastructures_pub.instance_rec,
113: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
114: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
115: x_return_status OUT nocopy varchar2)
116: IS
117: l_src_instance_rec csi_datastructures_pub.instance_rec;
118: l_instance_tbl csi_datastructures_pub.instance_tbl;
113: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
114: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
115: x_return_status OUT nocopy varchar2)
116: IS
117: l_src_instance_rec csi_datastructures_pub.instance_rec;
118: l_instance_tbl csi_datastructures_pub.instance_tbl;
119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
120: l_msg_count number;
121: l_msg_data varchar2(2000);
114: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
115: x_return_status OUT nocopy varchar2)
116: IS
117: l_src_instance_rec csi_datastructures_pub.instance_rec;
118: l_instance_tbl csi_datastructures_pub.instance_tbl;
119: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
120: l_msg_count number;
121: l_msg_data varchar2(2000);
122: BEGIN
182:
183: -- added for the bug 5464761
184: PROCEDURE check_and_explode_bom
185: ( p_order_line_rec IN oe_order_lines_all%rowtype,
186: l_u_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
187: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
188: x_return_status OUT NOCOPY varchar2)
189:
190: IS
183: -- added for the bug 5464761
184: PROCEDURE check_and_explode_bom
185: ( p_order_line_rec IN oe_order_lines_all%rowtype,
186: l_u_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
187: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
188: x_return_status OUT NOCOPY varchar2)
189:
190: IS
191:
202:
203:
204: -- explode_bom variables
205: l_bom_ind binary_integer := 0;
206: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
207: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
208: l_bom_explode_flag BOOLEAN := FALSE;
209: l_split_flag varchar2(10);
210: l_auto_split_instances csi_datastructures_pub.instance_tbl;
203:
204: -- explode_bom variables
205: l_bom_ind binary_integer := 0;
206: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
207: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
208: l_bom_explode_flag BOOLEAN := FALSE;
209: l_split_flag varchar2(10);
210: l_auto_split_instances csi_datastructures_pub.instance_tbl;
211: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
206: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
207: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
208: l_bom_explode_flag BOOLEAN := FALSE;
209: l_split_flag varchar2(10);
210: l_auto_split_instances csi_datastructures_pub.instance_tbl;
211: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
212: l_order_line_rec oe_order_lines_all%rowtype;
213:
214:
557: /* We need to do this because the get_item_instances returns the header */
558: /* table and we operate on the instance table. */
559: /* -------------------------------------------------------------------- */
560: PROCEDURE make_non_header_rec(
561: p_instance_header_rec IN csi_datastructures_pub.instance_header_rec,
562: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
563: x_return_status OUT NOCOPY varchar2)
564: IS
565: BEGIN
558: /* table and we operate on the instance table. */
559: /* -------------------------------------------------------------------- */
560: PROCEDURE make_non_header_rec(
561: p_instance_header_rec IN csi_datastructures_pub.instance_header_rec,
562: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
563: x_return_status OUT NOCOPY varchar2)
564: IS
565: BEGIN
566:
635: x_instance_rec.object_version_number := p_instance_header_rec.object_version_number;
636: END make_non_header_rec;
637:
638: PROCEDURE make_non_header_tbl(
639: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
640: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
641: x_return_status OUT NOCOPY varchar2)
642: IS
643: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
636: END make_non_header_rec;
637:
638: PROCEDURE make_non_header_tbl(
639: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
640: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
641: x_return_status OUT NOCOPY varchar2)
642: IS
643: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
644: BEGIN
660: END make_non_header_tbl;
661:
662:
663: PROCEDURE split_instances_using_copy(
664: p_instance_rec IN csi_datastructures_pub.instance_rec,
665: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
666: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
667: x_return_status OUT nocopy varchar2)
668: IS
661:
662:
663: PROCEDURE split_instances_using_copy(
664: p_instance_rec IN csi_datastructures_pub.instance_rec,
665: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
666: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
667: x_return_status OUT nocopy varchar2)
668: IS
669:
662:
663: PROCEDURE split_instances_using_copy(
664: p_instance_rec IN csi_datastructures_pub.instance_rec,
665: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
666: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
667: x_return_status OUT nocopy varchar2)
668: IS
669:
670: l_instance_usage_code varchar2(80);
671: l_location_type_code varchar2(80);
672: l_quantity number;
673: l_parent_instance_id number;
674:
675: l_u_instance_rec csi_datastructures_pub.instance_rec;
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
672: l_quantity number;
673: l_parent_instance_id number;
674:
675: l_u_instance_rec csi_datastructures_pub.instance_rec;
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
673: l_parent_instance_id number;
674:
675: l_u_instance_rec csi_datastructures_pub.instance_rec;
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
674:
675: l_u_instance_rec csi_datastructures_pub.instance_rec;
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
675: l_u_instance_rec csi_datastructures_pub.instance_rec;
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
676: l_u_parties_tbl csi_datastructures_pub.party_tbl;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
677: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
678: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
679: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
686:
680: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
686:
687: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
688:
681: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
682: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
686:
687: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
688:
689: l_instance_tbl csi_datastructures_pub.instance_tbl;
683:
684: l_instance_rec csi_datastructures_pub.instance_rec;
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
686:
687: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
688:
689: l_instance_tbl csi_datastructures_pub.instance_tbl;
690: x_ind binary_integer := 0;
691:
685: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
686:
687: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
688:
689: l_instance_tbl csi_datastructures_pub.instance_tbl;
690: x_ind binary_integer := 0;
691:
692: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
693: l_msg_data varchar2(2000);
854:
855: PROCEDURE split_instance(
856: p_instance_id IN number,
857: p_quantity IN number,
858: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
859: x_instance_rec OUT nocopy csi_datastructures_pub.instance_rec,
860: x_return_status OUT nocopy varchar2)
861: IS
862: l_instance_quantity number;
855: PROCEDURE split_instance(
856: p_instance_id IN number,
857: p_quantity IN number,
858: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
859: x_instance_rec OUT nocopy csi_datastructures_pub.instance_rec,
860: x_return_status OUT nocopy varchar2)
861: IS
862: l_instance_quantity number;
863: l_instance_ovn number;
861: IS
862: l_instance_quantity number;
863: l_instance_ovn number;
864:
865: l_src_instance_rec csi_datastructures_pub.instance_rec;
866: l_new_instance_rec csi_datastructures_pub.instance_rec;
867:
868: l_quantity1 number;
869: l_quantity2 number;
862: l_instance_quantity number;
863: l_instance_ovn number;
864:
865: l_src_instance_rec csi_datastructures_pub.instance_rec;
866: l_new_instance_rec csi_datastructures_pub.instance_rec;
867:
868: l_quantity1 number;
869: l_quantity2 number;
870:
928: p_instance_id IN number,
929: p_qty_ratio IN number,
930: p_parent_qty IN number,
931: p_organization_id IN number,
932: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
933: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
934: x_return_status OUT NOCOPY varchar2)
935: IS
936:
929: p_qty_ratio IN number,
930: p_parent_qty IN number,
931: p_organization_id IN number,
932: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
933: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
934: x_return_status OUT NOCOPY varchar2)
935: IS
936:
937: l_qty_remaining number;
935: IS
936:
937: l_qty_remaining number;
938:
939: l_init_instance_rec csi_datastructures_pub.instance_rec;
940: l_parent_instance_id number;
941: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
942:
943: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
937: l_qty_remaining number;
938:
939: l_init_instance_rec csi_datastructures_pub.instance_rec;
940: l_parent_instance_id number;
941: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
942:
943: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
944: l_msg_data varchar2(2000);
945: l_msg_count number;
945: l_msg_count number;
946:
947: l_split_flag boolean := FALSE;
948:
949: l_splitted_instances csi_datastructures_pub.instance_tbl;
950: l_s_ind binary_integer;
951:
952: -- get_item_instance_details variables
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
949: l_splitted_instances csi_datastructures_pub.instance_tbl;
950: l_s_ind binary_integer;
951:
952: -- get_item_instance_details variables
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
950: l_s_ind binary_integer;
951:
952: -- get_item_instance_details variables
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
951:
952: -- get_item_instance_details variables
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
952: -- get_item_instance_details variables
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
953: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
961: l_g_time_stamp date;
954: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
961: l_g_time_stamp date;
962:
955: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
961: l_g_time_stamp date;
962:
963: -- make_non_hdr variables
956: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
957: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
958: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
959: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
961: l_g_time_stamp date;
962:
963: -- make_non_hdr variables
964: l_instance_rec csi_datastructures_pub.instance_rec;
960: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
961: l_g_time_stamp date;
962:
963: -- make_non_hdr variables
964: l_instance_rec csi_datastructures_pub.instance_rec;
965:
966: -- update_item_instance variables
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
963: -- make_non_hdr variables
964: l_instance_rec csi_datastructures_pub.instance_rec;
965:
966: -- update_item_instance variables
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
964: l_instance_rec csi_datastructures_pub.instance_rec;
965:
966: -- update_item_instance variables
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
965:
966: -- update_item_instance variables
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
966: -- update_item_instance variables
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
967: l_u_instance_rec csi_datastructures_pub.instance_rec;
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
968: l_u_parties_tbl csi_datastructures_pub.party_tbl;
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
976: -- create_item_instance varaibles
969: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
970: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
971: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
972: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
973: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
974: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
975:
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
975:
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
983: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
976: -- create_item_instance varaibles
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
983: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
984: c_pa_ind binary_integer;
977: l_c_instance_rec csi_datastructures_pub.instance_rec;
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
983: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
984: c_pa_ind binary_integer;
985:
978: l_c_parties_tbl csi_datastructures_pub.party_tbl;
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
983: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
984: c_pa_ind binary_integer;
985:
986: BEGIN
979: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
980: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
981: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
982: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
983: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
984: c_pa_ind binary_integer;
985:
986: BEGIN
987:
1997: x_txn_line_dtl_id OUT nocopy number,
1998: x_return_status OUT nocopy varchar2)
1999: IS
2000:
2001: l_instance_rec csi_datastructures_pub.instance_rec;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1998: x_return_status OUT nocopy varchar2)
1999: IS
2000:
2001: l_instance_rec csi_datastructures_pub.instance_rec;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1999: IS
2000:
2001: l_instance_rec csi_datastructures_pub.instance_rec;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2000:
2001: l_instance_rec csi_datastructures_pub.instance_rec;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2001: l_instance_rec csi_datastructures_pub.instance_rec;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2002: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2010: l_g_time_stamp date;
2003: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2010: l_g_time_stamp date;
2011:
2004: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2010: l_g_time_stamp date;
2011:
2012: -- create_txn_line_dtls variables
2005: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2006: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2007: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2008: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2009: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2010: l_g_time_stamp date;
2011:
2012: -- create_txn_line_dtls variables
2013: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2399: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2400: p_order_line_rec IN oe_order_lines_all%rowtype,
2401: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2402: px_default_info_rec IN OUT nocopy default_info_rec,
2403: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2404: x_return_status OUT NOCOPY varchar2)
2405: IS
2406:
2407: l_party_site_id number;
2413:
2414: l_location_type_code varchar2(80);
2415: l_inst_object_ver_num number;
2416:
2417: l_u_instance_rec csi_datastructures_pub.instance_rec;
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2414: l_location_type_code varchar2(80);
2415: l_inst_object_ver_num number;
2416:
2417: l_u_instance_rec csi_datastructures_pub.instance_rec;
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2415: l_inst_object_ver_num number;
2416:
2417: l_u_instance_rec csi_datastructures_pub.instance_rec;
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2416:
2417: l_u_instance_rec csi_datastructures_pub.instance_rec;
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2417: l_u_instance_rec csi_datastructures_pub.instance_rec;
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2418: l_u_party_tbl csi_datastructures_pub.party_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2419: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2420: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2421: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2422: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2423: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2424: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2425:
2426: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2427: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2428: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2863: p_inventory_item_id IN number,
2864: p_organization_id IN number,
2865: p_option_serial_code IN number,
2866: p_config_rec IN config_rec,
2867: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2868: x_wip_instances OUT nocopy wip_instances,
2869: x_return_status OUT nocopy varchar2)
2870: IS
2871:
2906:
2907: n_wip_instances wip_instances;
2908: n_ind binary_integer := 0;
2909:
2910: l_soi_instance_rec csi_datastructures_pub.instance_rec;
2911:
2912: l_splitted_instances csi_datastructures_pub.instance_tbl;
2913: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2914:
2908: n_ind binary_integer := 0;
2909:
2910: l_soi_instance_rec csi_datastructures_pub.instance_rec;
2911:
2912: l_splitted_instances csi_datastructures_pub.instance_tbl;
2913: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2914:
2915: BEGIN
2916:
3034: p_option_serial_code IN number,
3035: p_class_option_ratio IN number,
3036: p_config_rec IN config_rec,
3037: p_config_instances IN config_serial_inst_tbl,
3038: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3039: px_wip_instances IN OUT nocopy wip_instances,
3040: x_return_status OUT nocopy varchar2)
3041: IS
3042: l_ratio number;
3049:
3050: l_n_wip_instance wip_instance;
3051: n_ind binary_integer := 0;
3052: l_n_wip_instances wip_instances;
3053: l_splitted_instances csi_datastructures_pub.instance_tbl;
3054: l_option_count number := 0;
3055:
3056: l_new_instance_rec csi_datastructures_pub.instance_rec;
3057:
3052: l_n_wip_instances wip_instances;
3053: l_splitted_instances csi_datastructures_pub.instance_tbl;
3054: l_option_count number := 0;
3055:
3056: l_new_instance_rec csi_datastructures_pub.instance_rec;
3057:
3058: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3059:
3060: FUNCTION tot_wip_inst_qty(
3452: p_parent_line_rec IN oe_order_pub.line_rec_type,
3453: p_parent_instances IN parent_instances,
3454: p_wip_instances IN wip_instances,
3455: px_default_info_rec IN OUT nocopy default_info_rec,
3456: x_ii_rltns_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
3457: x_return_status OUT nocopy varchar2)
3458: IS
3459:
3460: l_parent_instances parent_instances;
3460: l_parent_instances parent_instances;
3461: l_wip_instances wip_instances;
3462: l_alloc_wip_instance wip_instance;
3463: ii_ind binary_integer := 0;
3464: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
3465:
3466: PROCEDURE mark_and_get(
3467: p_parent_instance IN parent_instance,
3468: px_wip_instances IN OUT NOCOPY wip_instances,
3992: PROCEDURE get_config_srl_instances(
3993: p_config_rec IN config_rec,
3994: p_sub_config_flag IN varchar2,
3995: px_default_info_rec IN OUT nocopy default_info_rec,
3996: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3997: x_config_instances OUT NOCOPY config_serial_inst_tbl,
3998: x_return_status OUT NOCOPY varchar2)
3999: IS
4000:
4326: END get_reship_count;
4327:
4328: PROCEDURE eliminate_reshipped_instances(
4329: p_config_instances IN config_serial_inst_tbl,
4330: px_instances_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
4331: x_return_status OUT NOCOPY varchar2)
4332: IS
4333: l_instances_tbl csi_datastructures_pub.instance_tbl;
4334: l_i_ind binary_integer := 0;
4329: p_config_instances IN config_serial_inst_tbl,
4330: px_instances_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
4331: x_return_status OUT NOCOPY varchar2)
4332: IS
4333: l_instances_tbl csi_datastructures_pub.instance_tbl;
4334: l_i_ind binary_integer := 0;
4335: l_reshipped boolean := FALSE;
4336: BEGIN
4337: x_return_status := fnd_api.g_ret_sts_success;
4368:
4369: PROCEDURE get_option_instances(
4370: p_config_instance_id IN number,
4371: p_option_item_id IN number,
4372: x_option_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
4373: x_return_status OUT NOCOPY varchar2)
4374: IS
4375: l_option_instances csi_datastructures_pub.instance_tbl;
4376:
4371: p_option_item_id IN number,
4372: x_option_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
4373: x_return_status OUT NOCOPY varchar2)
4374: IS
4375: l_option_instances csi_datastructures_pub.instance_tbl;
4376:
4377: CURSOR option_inst_cur IS
4378: SELECT cii.instance_id
4379: FROM csi_item_instances cii,
4403:
4404: PROCEDURE stamp_om_line(
4405: p_instance_id IN number,
4406: p_order_line_id IN number,
4407: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4408: x_return_status OUT NOCOPY varchar2)
4409: IS
4410:
4411: l_inst_object_ver_num number;
4409: IS
4410:
4411: l_inst_object_ver_num number;
4412:
4413: l_u_instance_rec csi_datastructures_pub.instance_rec;
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4410:
4411: l_inst_object_ver_num number;
4412:
4413: l_u_instance_rec csi_datastructures_pub.instance_rec;
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4411: l_inst_object_ver_num number;
4412:
4413: l_u_instance_rec csi_datastructures_pub.instance_rec;
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4412:
4413: l_u_instance_rec csi_datastructures_pub.instance_rec;
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4420: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4413: l_u_instance_rec csi_datastructures_pub.instance_rec;
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4420: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4421:
4414: l_u_party_tbl csi_datastructures_pub.party_tbl;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4420: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4421:
4422: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4415: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4420: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4421:
4422: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4423: l_msg_count number;
4416: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4417: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4418: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4419: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4420: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4421:
4422: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4423: l_msg_count number;
4424: l_msg_data varchar2(2000);
4481: p_order_line_rec IN oe_order_lines_all%rowtype,
4482: p_wip_instances IN wip_instances,
4483: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4484: px_default_info_rec IN OUT nocopy default_info_rec,
4485: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4486: x_return_status OUT nocopy varchar2)
4487: IS
4488: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4489: BEGIN
4561:
4562: PROCEDURE break_relation(
4563: p_relationship_id IN number,
4564: p_relationship_ovn IN number,
4565: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4566: x_return_status OUT nocopy varchar2)
4567: IS
4568: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4569: l_instance_id_lst csi_datastructures_pub.id_tbl;
4564: p_relationship_ovn IN number,
4565: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4566: x_return_status OUT nocopy varchar2)
4567: IS
4568: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4569: l_instance_id_lst csi_datastructures_pub.id_tbl;
4570:
4571: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4572: l_msg_count number;
4565: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4566: x_return_status OUT nocopy varchar2)
4567: IS
4568: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4569: l_instance_id_lst csi_datastructures_pub.id_tbl;
4570:
4571: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4572: l_msg_count number;
4573: l_msg_data varchar2(2000);
4616: /* and breaks the relation */
4617:
4618: PROCEDURE check_and_break_relation(
4619: p_instance_id IN number,
4620: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4621: x_return_status OUT nocopy varchar2)
4622: IS
4623:
4624:
4621: x_return_status OUT nocopy varchar2)
4622: IS
4623:
4624:
4625: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4626: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4627: l_time_stamp date := sysdate;
4628:
4629: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4622: IS
4623:
4624:
4625: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4626: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4627: l_time_stamp date := sysdate;
4628:
4629: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4630: l_msg_count number := 0;
4740:
4741: PROCEDURE mark_and_get_nsrl_option(
4742: p_class_quantity IN number,
4743: p_quantity_ratio IN number,
4744: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4745: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4746: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4747: x_return_status OUT nocopy varchar2)
4748: IS
4741: PROCEDURE mark_and_get_nsrl_option(
4742: p_class_quantity IN number,
4743: p_quantity_ratio IN number,
4744: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4745: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4746: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4747: x_return_status OUT nocopy varchar2)
4748: IS
4749:
4742: p_class_quantity IN number,
4743: p_quantity_ratio IN number,
4744: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4745: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4746: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4747: x_return_status OUT nocopy varchar2)
4748: IS
4749:
4750: px_ind binary_integer := 0;
4752:
4753: l_instance_quantity number;
4754: l_vld_organization_id number;
4755:
4756: l_splitted_instances csi_datastructures_pub.instance_tbl;
4757:
4758: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4759: l_msg_count number;
4760: l_msg_data varchar2(2000);
4861: x_return_status := fnd_api.g_ret_sts_error;
4862: END mark_and_get_nsrl_option;
4863:
4864: PROCEDURE mark_and_get_srl_option(
4865: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4866: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4867: x_return_status OUT nocopy varchar2)
4868: IS
4869: px_ind binary_integer := 0;
4862: END mark_and_get_nsrl_option;
4863:
4864: PROCEDURE mark_and_get_srl_option(
4865: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4866: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4867: x_return_status OUT nocopy varchar2)
4868: IS
4869: px_ind binary_integer := 0;
4870: BEGIN
4884: p_option_line_rec IN oe_order_pub.line_rec_type,
4885: p_option_serial_code IN number,
4886: p_config_rec IN config_rec,
4887: p_transaction_line_id IN number,
4888: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4889: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4890: x_return_status OUT nocopy varchar2)
4891: IS
4892: l_option_instance varchar2(1);
4885: p_option_serial_code IN number,
4886: p_config_rec IN config_rec,
4887: p_transaction_line_id IN number,
4888: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4889: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4890: x_return_status OUT nocopy varchar2)
4891: IS
4892: l_option_instance varchar2(1);
4893: l_ind binary_integer := 0;
4890: x_return_status OUT nocopy varchar2)
4891: IS
4892: l_option_instance varchar2(1);
4893: l_ind binary_integer := 0;
4894: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4895: l_wip_instances wip_instances;
4896: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4897: CURSOR option_cp_cur IS
4898: SELECT cii.instance_id
5030: p_order_line_rec IN oe_order_lines_all%rowtype,
5031: p_config_rec IN config_rec,
5032: p_config_instances IN config_serial_inst_tbl,
5033: px_default_info_rec IN OUT NOCOPY default_info_rec,
5034: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5035: x_return_status OUT nocopy varchar2)
5036: IS
5037:
5038: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5058:
5059: oct_ind binary_integer := 0;
5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5061:
5062: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5063: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5064: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5065:
5066: l_time_stamp date := null;
5059: oct_ind binary_integer := 0;
5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5061:
5062: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5063: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5064: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5065:
5066: l_time_stamp date := null;
5067:
5060: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5061:
5062: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5063: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5064: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5065:
5066: l_time_stamp date := null;
5067:
5068: l_pcm_tbl parent_child_map_tbl;
5069: pcm_ind binary_integer := 0;
5070:
5071: l_class_option_ratio number;
5072: l_option_serial_code number;
5073: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5074: l_option_ns_tld_id number;
5075:
5076: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5077: l_instance_id_lst csi_datastructures_pub.id_tbl;
5072: l_option_serial_code number;
5073: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5074: l_option_ns_tld_id number;
5075:
5076: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5077: l_instance_id_lst csi_datastructures_pub.id_tbl;
5078:
5079: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5080: l_wip_processing boolean := FALSE;
5073: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5074: l_option_ns_tld_id number;
5075:
5076: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5077: l_instance_id_lst csi_datastructures_pub.id_tbl;
5078:
5079: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5080: l_wip_processing boolean := FALSE;
5081:
5105: p_parent_instance IN parent_instance,
5106: x_config_instance OUT nocopy config_serial_inst_rec,
5107: x_return_status OUT nocopy varchar2)
5108: IS
5109: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
5110: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5111: l_msg_count number;
5112: l_msg_data varchar2(2000);
5113: BEGIN
5711: p_identified_item_type IN varchar2,
5712: p_config_rec IN config_rec,
5713: p_config_instances IN config_serial_inst_tbl,
5714: px_default_info_rec IN OUT nocopy default_info_rec,
5715: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5716: x_return_status OUT nocopy varchar2)
5717: IS
5718:
5719: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5715: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5716: x_return_status OUT nocopy varchar2)
5717: IS
5718:
5719: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5720: l_party_query_rec csi_datastructures_pub.party_query_rec;
5721: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5716: x_return_status OUT nocopy varchar2)
5717: IS
5718:
5719: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5720: l_party_query_rec csi_datastructures_pub.party_query_rec;
5721: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5717: IS
5718:
5719: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5720: l_party_query_rec csi_datastructures_pub.party_query_rec;
5721: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5725:
5719: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5720: l_party_query_rec csi_datastructures_pub.party_query_rec;
5721: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5725:
5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5720: l_party_query_rec csi_datastructures_pub.party_query_rec;
5721: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5722:
5723: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5724: l_instance_tbl csi_datastructures_pub.instance_tbl;
5725:
5726: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5727: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5728:
6024: END build_parent_relation;
6025:
6026: PROCEDURE mark_and_get_instances(
6027: p_qty_ratio IN number,
6028: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6030: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6031: x_return_status OUT nocopy varchar2)
6032: IS
6025:
6026: PROCEDURE mark_and_get_instances(
6027: p_qty_ratio IN number,
6028: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6030: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6031: x_return_status OUT nocopy varchar2)
6032: IS
6033: l_satisfied varchar2(1) := 'N';
6026: PROCEDURE mark_and_get_instances(
6027: p_qty_ratio IN number,
6028: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6030: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6031: x_return_status OUT nocopy varchar2)
6032: IS
6033: l_satisfied varchar2(1) := 'N';
6034: l_qty_allocated number := 0;
6037: x_ind binary_integer := 0;
6038: px_ind binary_integer := 0;
6039: --fix for bug5096435
6040: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6041: l_new_instance_rec csi_datastructures_pub.instance_rec;
6042: BEGIN
6043: x_return_status := fnd_api.g_ret_sts_success;
6044: api_log('mark_and_get_instances');
6045:
6097: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6098: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6099: p_identified_item_type IN varchar2,
6100: px_default_info_rec IN OUT NOCOPY default_info_rec,
6101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6102: x_return_status OUT NOCOPY varchar2)
6103: IS
6104:
6105: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6102: x_return_status OUT NOCOPY varchar2)
6103: IS
6104:
6105: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6106: l_party_query_rec csi_datastructures_pub.party_query_rec;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6102: x_return_status OUT NOCOPY varchar2)
6103: IS
6104:
6105: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6106: l_party_query_rec csi_datastructures_pub.party_query_rec;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6103: IS
6104:
6105: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6106: l_party_query_rec csi_datastructures_pub.party_query_rec;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6111: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6105: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6106: l_party_query_rec csi_datastructures_pub.party_query_rec;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6111: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6112:
6113:
6106: l_party_query_rec csi_datastructures_pub.party_query_rec;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6111: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6112:
6113:
6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6107: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6108:
6109: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6110: l_instance_tbl csi_datastructures_pub.instance_tbl;
6111: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6112:
6113:
6114: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6115:
6134: l_order_line_qty number;
6135: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6136: l_next_item_id number := 0;
6137: l_temp_idx number := 0;
6138: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6139: l_temp_index number := 0;
6140:
6141: BEGIN
6142:
6384: px_default_info_rec IN OUT nocopy default_info_rec,
6385: x_return_status OUT nocopy Varchar2)
6386: IS
6387:
6388: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6389:
6390: l_parent_line_rec oe_order_pub.line_rec_type;
6391: l_option_serial_code number;
6392:
6396: l_config_instances config_serial_inst_tbl;
6397:
6398: l_qty_ratio number;
6399:
6400: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6401: l_ind binary_integer;
6402: l_msg_count number;
6403: l_msg_data varchar2(2000);
6404: l_return_status varchar2(1);
6671: x_config_instance OUT nocopy config_serial_inst_rec,
6672: x_return_status OUT nocopy varchar2)
6673: IS
6674:
6675: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
6676: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6677: l_time_stamp date := null;
6678:
6679: l_config_instance config_serial_inst_rec;
6672: x_return_status OUT nocopy varchar2)
6673: IS
6674:
6675: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
6676: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6677: l_time_stamp date := null;
6678:
6679: l_config_instance config_serial_inst_rec;
6680:
6765: px_default_info_rec IN OUT nocopy default_info_rec,
6766: x_return_status OUT nocopy varchar2)
6767: IS
6768:
6769: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6770:
6771: l_parent_line_rec oe_order_pub.line_rec_type;
6772: l_option_serial_code number;
6773:
6779: l_config_class_ratio number;
6780:
6781: l_config_parent config_serial_inst_rec;
6782:
6783: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
6784: l_instance_id_lst csi_datastructures_pub.id_tbl;
6785:
6786: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6787: l_ii_ind binary_integer := 0;
6780:
6781: l_config_parent config_serial_inst_rec;
6782:
6783: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
6784: l_instance_id_lst csi_datastructures_pub.id_tbl;
6785:
6786: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6787: l_ii_ind binary_integer := 0;
6788:
6782:
6783: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
6784: l_instance_id_lst csi_datastructures_pub.id_tbl;
6785:
6786: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6787: l_ii_ind binary_integer := 0;
6788:
6789: l_msg_count number;
6790: l_msg_data varchar2(2000);
7262: PROCEDURE demo_fulfillment(
7263: p_txn_type_id IN number,
7264: p_order_line_rec IN oe_order_lines_all%rowtype,
7265: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
7266: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
7267: x_return_status OUT nocopy varchar2)
7268: IS
7269:
7270: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7266: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
7267: x_return_status OUT nocopy varchar2)
7268: IS
7269:
7270: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7271:
7272: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7273: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7274:
7281: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7282: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7283: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7284:
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7285: l_instance_rec csi_datastructures_pub.instance_header_rec;
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7286: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7287: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7288: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
7289: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
7290: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7291: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
7292: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
7293:
7294: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
7295: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
7296: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
7311: l_msg_data varchar2(2000);
7312: l_msg_count number;
7313: l_inst_loc_id number;
7314: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
7315: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
7316: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
7317: l_quantity1 NUMBER;
7318: l_vld_orgn_id number;
7319:
7312: l_msg_count number;
7313: l_inst_loc_id number;
7314: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
7315: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
7316: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
7317: l_quantity1 NUMBER;
7318: l_vld_orgn_id number;
7319:
7320: BEGIN
7322: csi_t_gen_utility_pvt.dump_api_info(
7323: p_api_name => 'demo_fulfillment',
7324: p_pkg_name => 'csi_order_fulfill_pub');
7325:
7326: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7327: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
7328:
7329: -- create csi_transaction
7330: create_csi_transaction(
7323: p_api_name => 'demo_fulfillment',
7324: p_pkg_name => 'csi_order_fulfill_pub');
7325:
7326: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7327: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
7328:
7329: -- create csi_transaction
7330: create_csi_transaction(
7331: px_csi_txn_rec => px_csi_txn_rec,
7653:
7654: l_source_header_rec csi_interface_pkg.source_header_rec;
7655: l_source_line_rec csi_interface_pkg.source_line_rec;
7656:
7657: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7658:
7659: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7660: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7661:
7676: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7677: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7678: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
7679:
7680: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
7681:
7682: -- Added this for unlock_item_instances
7683: l_config_tbl csi_cz_int.config_tbl;
7684:
7894: PROCEDURE query_tld_and_update_ib(
7895: p_order_header_rec IN oe_order_headers_all%rowtype,
7896: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
7897: px_default_info_rec IN OUT NOCOPY default_info_rec,
7898: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7899: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
7900: x_return_status OUT NOCOPY varchar2)
7901: IS
7902:
7895: p_order_header_rec IN oe_order_headers_all%rowtype,
7896: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
7897: px_default_info_rec IN OUT NOCOPY default_info_rec,
7898: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7899: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
7900: x_return_status OUT NOCOPY varchar2)
7901: IS
7902:
7903: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7913: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
7914: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
7915: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
7916: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
7917: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
7918: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
7919: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
7920:
7921: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8124: PROCEDURE order_fulfillment(
8125: p_order_line_id IN number,
8126: p_message_id IN number,
8127: x_return_status OUT NOCOPY varchar2,
8128: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
8129: IS
8130:
8131: l_api_name varchar2(30) := 'order_fulfillment';
8132:
8145: l_config_instances config_serial_inst_tbl;
8146: l_config_reship_found boolean := FALSE;
8147: l_config_reship_count number := 0;
8148:
8149: l_option_instances csi_datastructures_pub.instance_tbl;
8150:
8151: l_trk_child_tbl oe_order_pub.line_tbl_type;
8152: l_trk_parent_rec oe_order_pub.line_rec_type;
8153:
8180: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8181: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8182: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8183: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8184: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8185: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8186: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8187:
8188: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8213: l_order_line_rec oe_order_lines_all%rowtype;
8214: l_order_header_rec oe_order_headers_all%rowtype;
8215:
8216: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
8217: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8218:
8219: l_identified_item_type varchar2(30);
8220: l_processing_status varchar2(30);
8221:
8243: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8244: ---Added (End) for m-to-m enhancements
8245:
8246: skip_regular_process exception;
8247: l_error_rec csi_datastructures_pub.transaction_error_rec;
8248:
8249: -- For partner prdering
8250: l_end_customer_id number;
8251: l_current_site_use_id number;
8255: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8256: l_src_tld_total_qty number := 0;
8257: --
8258: l_ul_txn_line_id NUMBER;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8256: l_src_tld_total_qty number := 0;
8257: --
8258: l_ul_txn_line_id NUMBER;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8257: --
8258: l_ul_txn_line_id NUMBER;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8258: l_ul_txn_line_id NUMBER;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8266: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
8259: l_ul_instance_rec csi_datastructures_pub.instance_rec;
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8266: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
8267:
8260: l_u_parties_tbl csi_datastructures_pub.party_tbl;
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8266: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
8267:
8268: BEGIN
8261: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8266: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
8267:
8268: BEGIN
8269:
8262: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8263: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8264: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8265: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8266: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
8267:
8268: BEGIN
8269:
8270: savepoint order_fulfillment;
8291: /* this routine checks if ib is active */
8292: csi_utility_grp.check_ib_active;
8293:
8294: l_default_info_rec.internal_party_id :=
8295: csi_datastructures_pub.g_install_param_rec.internal_party_id;
8296: l_default_info_rec.freeze_date :=
8297: csi_datastructures_pub.g_install_param_rec.freeze_date;
8298: l_default_info_rec.ownership_cascade_at_txn :=
8299: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
8293:
8294: l_default_info_rec.internal_party_id :=
8295: csi_datastructures_pub.g_install_param_rec.internal_party_id;
8296: l_default_info_rec.freeze_date :=
8297: csi_datastructures_pub.g_install_param_rec.freeze_date;
8298: l_default_info_rec.ownership_cascade_at_txn :=
8299: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
8300:
8301: /* get the default sub type id */
8295: csi_datastructures_pub.g_install_param_rec.internal_party_id;
8296: l_default_info_rec.freeze_date :=
8297: csi_datastructures_pub.g_install_param_rec.freeze_date;
8298: l_default_info_rec.ownership_cascade_at_txn :=
8299: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
8300:
8301: /* get the default sub type id */
8302: csi_utl_pkg.get_dflt_sub_type_id(
8303: p_transaction_type_id => l_txn_type_id,
9806: PROCEDURE logical_drop_ship(
9807: p_mtl_txn_id IN number,
9808: p_message_id IN number,
9809: x_return_status OUT NOCOPY varchar2,
9810: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
9811: IS
9812:
9813: l_api_name varchar2(30) := 'logical_drop_ship';
9814: l_txn_line_id number;
9823: l_msg_data varchar2(2000);
9824: l_msg_count number;
9825:
9826: skip_regular_process exception;
9827: l_error_rec csi_datastructures_pub.transaction_error_rec;
9828: l_order_line_rec csi_order_ship_pub.order_line_rec;
9829: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
9830: l_count number := 0;
9831: l_party_id number;
9835: x_trx_line_id number;
9836:
9837: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9838: l_trx_detail_exist boolean := FALSE;
9839: l_trx_rec csi_datastructures_pub.transaction_rec;
9840:
9841: l_exp_instance_rec csi_datastructures_pub.instance_rec;
9842: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
9843: l_exp_instance_id number;
9837: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
9838: l_trx_detail_exist boolean := FALSE;
9839: l_trx_rec csi_datastructures_pub.transaction_rec;
9840:
9841: l_exp_instance_rec csi_datastructures_pub.instance_rec;
9842: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
9843: l_exp_instance_id number;
9844: l_exp_obj_ver_num number;
9845: l_exp_active_end_date date;
9838: l_trx_detail_exist boolean := FALSE;
9839: l_trx_rec csi_datastructures_pub.transaction_rec;
9840:
9841: l_exp_instance_rec csi_datastructures_pub.instance_rec;
9842: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
9843: l_exp_instance_id number;
9844: l_exp_obj_ver_num number;
9845: l_exp_active_end_date date;
9846: l_exp_loc_type_code varchar2(30);
9844: l_exp_obj_ver_num number;
9845: l_exp_active_end_date date;
9846: l_exp_loc_type_code varchar2(30);
9847:
9848: p_instance_rec csi_datastructures_pub.instance_rec;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9845: l_exp_active_end_date date;
9846: l_exp_loc_type_code varchar2(30);
9847:
9848: p_instance_rec csi_datastructures_pub.instance_rec;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9846: l_exp_loc_type_code varchar2(30);
9847:
9848: p_instance_rec csi_datastructures_pub.instance_rec;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9847:
9848: p_instance_rec csi_datastructures_pub.instance_rec;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9848: p_instance_rec csi_datastructures_pub.instance_rec;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9856: x_instance_id_lst csi_datastructures_pub.id_tbl;
9849: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9856: x_instance_id_lst csi_datastructures_pub.id_tbl;
9857: -- x_return_status varchar2(2000);
9850: p_party_tbl csi_datastructures_pub.party_tbl;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9856: x_instance_id_lst csi_datastructures_pub.id_tbl;
9857: -- x_return_status varchar2(2000);
9858: x_msg_count number;
9851: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9856: x_instance_id_lst csi_datastructures_pub.id_tbl;
9857: -- x_return_status varchar2(2000);
9858: x_msg_count number;
9859: x_msg_data varchar2(2000);
9852: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
9853: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
9854: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
9855: p_txn_rec csi_datastructures_pub.transaction_rec;
9856: x_instance_id_lst csi_datastructures_pub.id_tbl;
9857: -- x_return_status varchar2(2000);
9858: x_msg_count number;
9859: x_msg_data varchar2(2000);
9860: t_output varchar2(2000);
10587:
10588: l_return_status VARCHAR2(1);
10589: l_error_code VARCHAR2(30);
10590: l_error_message VARCHAR2(2000);
10591: l_error_rec csi_datastructures_pub.transaction_error_rec;
10592:
10593: BEGIN
10594:
10595: x_return_status := FND_API.G_RET_STS_SUCCESS;
10598: p_file_segment1 => 'csi',
10599: p_file_segment2 => to_char(sysdate, 'DDMMYY'),
10600: p_file_segment3 => 'invoke');
10601:
10602: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10603: csi_gen_utility_pvt.populate_install_param_rec;
10604: END IF;
10605:
10606: l_bypass := csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag;
10602: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10603: csi_gen_utility_pvt.populate_install_param_rec;
10604: END IF;
10605:
10606: l_bypass := csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag;
10607:
10608: IF l_bypass = 'Y' THEN
10609:
10610: csi_t_gen_utility_pvt.add('Bypassing the SDP queue for the order line id: '||p_order_line_id);
10733: end if;
10734: --
10735: -- Get the Date from CSI_INSTALL_PARAMETERS
10736:
10737: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10738: csi_gen_utility_pvt.populate_install_param_rec;
10739: END IF;
10740:
10741: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
10737: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10738: csi_gen_utility_pvt.populate_install_param_rec;
10739: END IF;
10740:
10741: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
10742:
10743: --
10744: -- Get the Multi-org Flag.
10745: l_multi_org_flag := 'X';
11267: RETURN;
11268: End;
11269:
11270: -- Get the Date from CSI_INSTALL_PARAMETERS
11271: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11272: csi_gen_utility_pvt.populate_install_param_rec;
11273: END IF;
11274:
11275: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
11271: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11272: csi_gen_utility_pvt.populate_install_param_rec;
11273: END IF;
11274:
11275: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
11276:
11277: --
11278: l_multi_org_flag := 'X';
11279: Begin