[Home] [Help]
40: p_option_expl_flag := 'N';
41: END get_phantom_option_expl_flag;
42:
43: PROCEDURE create_csi_transaction(
44: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
45: x_return_status OUT nocopy varchar2)
46: IS
47: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count number;
131:
132:
133: -- added for the bug 5464761
134: PROCEDURE auto_split_instances(
135: p_instance_rec IN csi_datastructures_pub.instance_rec,
136: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
137: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
138: x_return_status OUT nocopy varchar2)
139: IS
132:
133: -- added for the bug 5464761
134: PROCEDURE auto_split_instances(
135: p_instance_rec IN csi_datastructures_pub.instance_rec,
136: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
137: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
138: x_return_status OUT nocopy varchar2)
139: IS
140: l_src_instance_rec csi_datastructures_pub.instance_rec;
133: -- added for the bug 5464761
134: PROCEDURE auto_split_instances(
135: p_instance_rec IN csi_datastructures_pub.instance_rec,
136: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
137: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
138: x_return_status OUT nocopy varchar2)
139: IS
140: l_src_instance_rec csi_datastructures_pub.instance_rec;
141: l_instance_tbl csi_datastructures_pub.instance_tbl;
136: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
137: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
138: x_return_status OUT nocopy varchar2)
139: IS
140: l_src_instance_rec csi_datastructures_pub.instance_rec;
141: l_instance_tbl csi_datastructures_pub.instance_tbl;
142: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
143: l_msg_count number;
144: l_msg_data varchar2(2000);
137: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
138: x_return_status OUT nocopy varchar2)
139: IS
140: l_src_instance_rec csi_datastructures_pub.instance_rec;
141: l_instance_tbl csi_datastructures_pub.instance_tbl;
142: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
143: l_msg_count number;
144: l_msg_data varchar2(2000);
145: BEGIN
205:
206: -- added for the bug 5464761
207: PROCEDURE check_and_explode_bom
208: ( p_order_line_rec IN oe_order_lines_all%rowtype,
209: l_u_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
210: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
211: x_return_status OUT NOCOPY varchar2)
212:
213: IS
206: -- added for the bug 5464761
207: PROCEDURE check_and_explode_bom
208: ( p_order_line_rec IN oe_order_lines_all%rowtype,
209: l_u_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
210: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
211: x_return_status OUT NOCOPY varchar2)
212:
213: IS
214:
225:
226:
227: -- explode_bom variables
228: l_bom_ind binary_integer := 0;
229: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
230: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
231: l_bom_explode_flag BOOLEAN := FALSE;
232: l_split_flag varchar2(10);
233: l_auto_split_instances csi_datastructures_pub.instance_tbl;
226:
227: -- explode_bom variables
228: l_bom_ind binary_integer := 0;
229: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
230: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
231: l_bom_explode_flag BOOLEAN := FALSE;
232: l_split_flag varchar2(10);
233: l_auto_split_instances csi_datastructures_pub.instance_tbl;
234: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
229: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
230: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
231: l_bom_explode_flag BOOLEAN := FALSE;
232: l_split_flag varchar2(10);
233: l_auto_split_instances csi_datastructures_pub.instance_tbl;
234: l_ship_order_line_rec csi_order_ship_pub.order_line_rec;
235: l_order_line_rec oe_order_lines_all%rowtype;
236:
237:
597: /* We need to do this because the get_item_instances returns the header */
598: /* table and we operate on the instance table. */
599: /* -------------------------------------------------------------------- */
600: PROCEDURE make_non_header_rec(
601: p_instance_header_rec IN csi_datastructures_pub.instance_header_rec,
602: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
603: x_return_status OUT NOCOPY varchar2)
604: IS
605: BEGIN
598: /* table and we operate on the instance table. */
599: /* -------------------------------------------------------------------- */
600: PROCEDURE make_non_header_rec(
601: p_instance_header_rec IN csi_datastructures_pub.instance_header_rec,
602: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
603: x_return_status OUT NOCOPY varchar2)
604: IS
605: BEGIN
606:
675: x_instance_rec.object_version_number := p_instance_header_rec.object_version_number;
676: END make_non_header_rec;
677:
678: PROCEDURE make_non_header_tbl(
679: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
680: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
681: x_return_status OUT NOCOPY varchar2)
682: IS
683: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
676: END make_non_header_rec;
677:
678: PROCEDURE make_non_header_tbl(
679: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
680: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
681: x_return_status OUT NOCOPY varchar2)
682: IS
683: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
684: BEGIN
700: END make_non_header_tbl;
701:
702:
703: PROCEDURE split_instances_using_copy(
704: p_instance_rec IN csi_datastructures_pub.instance_rec,
705: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
706: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
707: x_return_status OUT nocopy varchar2)
708: IS
701:
702:
703: PROCEDURE split_instances_using_copy(
704: p_instance_rec IN csi_datastructures_pub.instance_rec,
705: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
706: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
707: x_return_status OUT nocopy varchar2)
708: IS
709:
702:
703: PROCEDURE split_instances_using_copy(
704: p_instance_rec IN csi_datastructures_pub.instance_rec,
705: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
706: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
707: x_return_status OUT nocopy varchar2)
708: IS
709:
710: l_instance_usage_code varchar2(80);
711: l_location_type_code varchar2(80);
712: l_quantity number;
713: l_parent_instance_id number;
714:
715: l_u_instance_rec csi_datastructures_pub.instance_rec;
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
712: l_quantity number;
713: l_parent_instance_id number;
714:
715: l_u_instance_rec csi_datastructures_pub.instance_rec;
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
713: l_parent_instance_id number;
714:
715: l_u_instance_rec csi_datastructures_pub.instance_rec;
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
714:
715: l_u_instance_rec csi_datastructures_pub.instance_rec;
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
715: l_u_instance_rec csi_datastructures_pub.instance_rec;
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
716: l_u_parties_tbl csi_datastructures_pub.party_tbl;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
717: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
718: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
719: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
726:
720: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
726:
727: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
728:
721: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
722: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
726:
727: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
728:
729: l_instance_tbl csi_datastructures_pub.instance_tbl;
723:
724: l_instance_rec csi_datastructures_pub.instance_rec;
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
726:
727: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
728:
729: l_instance_tbl csi_datastructures_pub.instance_tbl;
730: x_ind binary_integer := 0;
731:
725: l_copy_instance_tbl csi_datastructures_pub.instance_tbl;
726:
727: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
728:
729: l_instance_tbl csi_datastructures_pub.instance_tbl;
730: x_ind binary_integer := 0;
731:
732: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
733: l_msg_data varchar2(2000);
894:
895: PROCEDURE split_instance(
896: p_instance_id IN number,
897: p_quantity IN number,
898: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
899: x_instance_rec OUT nocopy csi_datastructures_pub.instance_rec,
900: x_return_status OUT nocopy varchar2)
901: IS
902: l_instance_quantity number;
895: PROCEDURE split_instance(
896: p_instance_id IN number,
897: p_quantity IN number,
898: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
899: x_instance_rec OUT nocopy csi_datastructures_pub.instance_rec,
900: x_return_status OUT nocopy varchar2)
901: IS
902: l_instance_quantity number;
903: l_instance_ovn number;
901: IS
902: l_instance_quantity number;
903: l_instance_ovn number;
904:
905: l_src_instance_rec csi_datastructures_pub.instance_rec;
906: l_new_instance_rec csi_datastructures_pub.instance_rec;
907:
908: l_quantity1 number;
909: l_quantity2 number;
902: l_instance_quantity number;
903: l_instance_ovn number;
904:
905: l_src_instance_rec csi_datastructures_pub.instance_rec;
906: l_new_instance_rec csi_datastructures_pub.instance_rec;
907:
908: l_quantity1 number;
909: l_quantity2 number;
910:
968: p_instance_id IN number,
969: p_qty_ratio IN number,
970: p_parent_qty IN number,
971: p_organization_id IN number,
972: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
973: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
974: x_return_status OUT NOCOPY varchar2)
975: IS
976:
969: p_qty_ratio IN number,
970: p_parent_qty IN number,
971: p_organization_id IN number,
972: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
973: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
974: x_return_status OUT NOCOPY varchar2)
975: IS
976:
977: l_qty_remaining number;
975: IS
976:
977: l_qty_remaining number;
978:
979: l_init_instance_rec csi_datastructures_pub.instance_rec;
980: l_parent_instance_id number;
981: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
982:
983: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
977: l_qty_remaining number;
978:
979: l_init_instance_rec csi_datastructures_pub.instance_rec;
980: l_parent_instance_id number;
981: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
982:
983: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
984: l_msg_data varchar2(2000);
985: l_msg_count number;
985: l_msg_count number;
986:
987: l_split_flag boolean := FALSE;
988:
989: l_splitted_instances csi_datastructures_pub.instance_tbl;
990: l_s_ind binary_integer;
991:
992: -- get_item_instance_details variables
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
989: l_splitted_instances csi_datastructures_pub.instance_tbl;
990: l_s_ind binary_integer;
991:
992: -- get_item_instance_details variables
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
990: l_s_ind binary_integer;
991:
992: -- get_item_instance_details variables
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
991:
992: -- get_item_instance_details variables
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
992: -- get_item_instance_details variables
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
993: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1001: l_g_time_stamp date;
994: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1001: l_g_time_stamp date;
1002:
995: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1001: l_g_time_stamp date;
1002:
1003: -- make_non_hdr variables
996: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
997: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
998: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
999: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1001: l_g_time_stamp date;
1002:
1003: -- make_non_hdr variables
1004: l_instance_rec csi_datastructures_pub.instance_rec;
1000: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1001: l_g_time_stamp date;
1002:
1003: -- make_non_hdr variables
1004: l_instance_rec csi_datastructures_pub.instance_rec;
1005:
1006: -- update_item_instance variables
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1003: -- make_non_hdr variables
1004: l_instance_rec csi_datastructures_pub.instance_rec;
1005:
1006: -- update_item_instance variables
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1004: l_instance_rec csi_datastructures_pub.instance_rec;
1005:
1006: -- update_item_instance variables
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1005:
1006: -- update_item_instance variables
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1006: -- update_item_instance variables
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1007: l_u_instance_rec csi_datastructures_pub.instance_rec;
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1008: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1016: -- create_item_instance varaibles
1009: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1010: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1011: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1012: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1013: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1014: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1015:
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015:
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1023: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1016: -- create_item_instance varaibles
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1023: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1024: c_pa_ind binary_integer;
1017: l_c_instance_rec csi_datastructures_pub.instance_rec;
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1023: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1024: c_pa_ind binary_integer;
1025:
1018: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1023: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1024: c_pa_ind binary_integer;
1025:
1026: BEGIN
1019: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1020: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1021: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1022: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1023: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1024: c_pa_ind binary_integer;
1025:
1026: BEGIN
1027:
2037: x_txn_line_dtl_id OUT nocopy number,
2038: x_return_status OUT nocopy varchar2)
2039: IS
2040:
2041: l_instance_rec csi_datastructures_pub.instance_rec;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2038: x_return_status OUT nocopy varchar2)
2039: IS
2040:
2041: l_instance_rec csi_datastructures_pub.instance_rec;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2039: IS
2040:
2041: l_instance_rec csi_datastructures_pub.instance_rec;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2040:
2041: l_instance_rec csi_datastructures_pub.instance_rec;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2041: l_instance_rec csi_datastructures_pub.instance_rec;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2042: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2050: l_g_time_stamp date;
2043: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2050: l_g_time_stamp date;
2051:
2044: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2050: l_g_time_stamp date;
2051:
2052: -- create_txn_line_dtls variables
2045: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
2046: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
2047: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2048: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
2049: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
2050: l_g_time_stamp date;
2051:
2052: -- create_txn_line_dtls variables
2053: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
2439: p_order_hdr_rec IN oe_order_headers_all%rowtype,
2440: p_order_line_rec IN oe_order_lines_all%rowtype,
2441: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
2442: px_default_info_rec IN OUT nocopy default_info_rec,
2443: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2444: x_return_status OUT NOCOPY varchar2)
2445: IS
2446:
2447: l_party_site_id number;
2453:
2454: l_location_type_code varchar2(80);
2455: l_inst_object_ver_num number;
2456:
2457: l_u_instance_rec csi_datastructures_pub.instance_rec;
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2454: l_location_type_code varchar2(80);
2455: l_inst_object_ver_num number;
2456:
2457: l_u_instance_rec csi_datastructures_pub.instance_rec;
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2455: l_inst_object_ver_num number;
2456:
2457: l_u_instance_rec csi_datastructures_pub.instance_rec;
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2456:
2457: l_u_instance_rec csi_datastructures_pub.instance_rec;
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2457: l_u_instance_rec csi_datastructures_pub.instance_rec;
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2458: l_u_party_tbl csi_datastructures_pub.party_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2459: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2460: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
2461: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2462: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
2463: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2464: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
2465:
2466: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2467: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2468: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
2903: p_inventory_item_id IN number,
2904: p_organization_id IN number,
2905: p_option_serial_code IN number,
2906: p_config_rec IN config_rec,
2907: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
2908: x_wip_instances OUT nocopy wip_instances,
2909: x_return_status OUT nocopy varchar2)
2910: IS
2911:
2952:
2953: n_wip_instances wip_instances;
2954: n_ind binary_integer := 0;
2955:
2956: l_soi_instance_rec csi_datastructures_pub.instance_rec;
2957:
2958: l_splitted_instances csi_datastructures_pub.instance_tbl;
2959: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2960:
2954: n_ind binary_integer := 0;
2955:
2956: l_soi_instance_rec csi_datastructures_pub.instance_rec;
2957:
2958: l_splitted_instances csi_datastructures_pub.instance_tbl;
2959: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2960:
2961: BEGIN
2962:
3080: p_option_serial_code IN number,
3081: p_class_option_ratio IN number,
3082: p_config_rec IN config_rec,
3083: p_config_instances IN config_serial_inst_tbl,
3084: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
3085: px_wip_instances IN OUT nocopy wip_instances,
3086: x_return_status OUT nocopy varchar2)
3087: IS
3088: l_ratio number;
3095:
3096: l_n_wip_instance wip_instance;
3097: n_ind binary_integer := 0;
3098: l_n_wip_instances wip_instances;
3099: l_splitted_instances csi_datastructures_pub.instance_tbl;
3100: l_option_count number := 0;
3101:
3102: l_new_instance_rec csi_datastructures_pub.instance_rec;
3103:
3098: l_n_wip_instances wip_instances;
3099: l_splitted_instances csi_datastructures_pub.instance_tbl;
3100: l_option_count number := 0;
3101:
3102: l_new_instance_rec csi_datastructures_pub.instance_rec;
3103:
3104: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3105:
3106: FUNCTION tot_wip_inst_qty(
3500: p_parent_line_rec IN oe_order_pub.line_rec_type,
3501: p_parent_instances IN parent_instances,
3502: p_wip_instances IN wip_instances,
3503: px_default_info_rec IN OUT nocopy default_info_rec,
3504: x_ii_rltns_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
3505: x_return_status OUT nocopy varchar2)
3506: IS
3507:
3508: l_parent_instances parent_instances;
3508: l_parent_instances parent_instances;
3509: l_wip_instances wip_instances;
3510: l_alloc_wip_instance wip_instance;
3511: ii_ind binary_integer := 0;
3512: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
3513:
3514: PROCEDURE mark_and_get(
3515: p_parent_instance IN parent_instance,
3516: px_wip_instances IN OUT NOCOPY wip_instances,
4040: PROCEDURE get_config_srl_instances(
4041: p_config_rec IN config_rec,
4042: p_sub_config_flag IN varchar2,
4043: px_default_info_rec IN OUT nocopy default_info_rec,
4044: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4045: x_config_instances OUT NOCOPY config_serial_inst_tbl,
4046: x_return_status OUT NOCOPY varchar2)
4047: IS
4048:
4374: END get_reship_count;
4375:
4376: PROCEDURE eliminate_reshipped_instances(
4377: p_config_instances IN config_serial_inst_tbl,
4378: px_instances_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
4379: x_return_status OUT NOCOPY varchar2)
4380: IS
4381: l_instances_tbl csi_datastructures_pub.instance_tbl;
4382: l_i_ind binary_integer := 0;
4377: p_config_instances IN config_serial_inst_tbl,
4378: px_instances_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
4379: x_return_status OUT NOCOPY varchar2)
4380: IS
4381: l_instances_tbl csi_datastructures_pub.instance_tbl;
4382: l_i_ind binary_integer := 0;
4383: l_reshipped boolean := FALSE;
4384: BEGIN
4385: x_return_status := fnd_api.g_ret_sts_success;
4416:
4417: PROCEDURE get_option_instances(
4418: p_config_instance_id IN number,
4419: p_option_item_id IN number,
4420: x_option_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
4421: x_return_status OUT NOCOPY varchar2)
4422: IS
4423: l_option_instances csi_datastructures_pub.instance_tbl;
4424:
4419: p_option_item_id IN number,
4420: x_option_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
4421: x_return_status OUT NOCOPY varchar2)
4422: IS
4423: l_option_instances csi_datastructures_pub.instance_tbl;
4424:
4425: CURSOR option_inst_cur IS
4426: SELECT cii.instance_id
4427: FROM csi_item_instances cii,
4451:
4452: PROCEDURE stamp_om_line(
4453: p_instance_id IN number,
4454: p_order_line_id IN number,
4455: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4456: x_return_status OUT NOCOPY varchar2)
4457: IS
4458:
4459: l_inst_object_ver_num number;
4457: IS
4458:
4459: l_inst_object_ver_num number;
4460:
4461: l_u_instance_rec csi_datastructures_pub.instance_rec;
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4458:
4459: l_inst_object_ver_num number;
4460:
4461: l_u_instance_rec csi_datastructures_pub.instance_rec;
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4459: l_inst_object_ver_num number;
4460:
4461: l_u_instance_rec csi_datastructures_pub.instance_rec;
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4460:
4461: l_u_instance_rec csi_datastructures_pub.instance_rec;
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4468: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4461: l_u_instance_rec csi_datastructures_pub.instance_rec;
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4468: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4469:
4462: l_u_party_tbl csi_datastructures_pub.party_tbl;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4468: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4469:
4470: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4463: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4468: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4469:
4470: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4471: l_msg_count number;
4464: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4465: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4466: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4468: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4469:
4470: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4471: l_msg_count number;
4472: l_msg_data varchar2(2000);
4529: p_order_line_rec IN oe_order_lines_all%rowtype,
4530: p_wip_instances IN wip_instances,
4531: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4532: px_default_info_rec IN OUT nocopy default_info_rec,
4533: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4534: x_return_status OUT nocopy varchar2)
4535: IS
4536: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4537: BEGIN
4609:
4610: PROCEDURE break_relation(
4611: p_relationship_id IN number,
4612: p_relationship_ovn IN number,
4613: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4614: x_return_status OUT nocopy varchar2)
4615: IS
4616: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4617: l_instance_id_lst csi_datastructures_pub.id_tbl;
4612: p_relationship_ovn IN number,
4613: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4614: x_return_status OUT nocopy varchar2)
4615: IS
4616: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4617: l_instance_id_lst csi_datastructures_pub.id_tbl;
4618:
4619: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4620: l_msg_count number;
4613: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4614: x_return_status OUT nocopy varchar2)
4615: IS
4616: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
4617: l_instance_id_lst csi_datastructures_pub.id_tbl;
4618:
4619: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4620: l_msg_count number;
4621: l_msg_data varchar2(2000);
4664: /* and breaks the relation */
4665:
4666: PROCEDURE check_and_break_relation(
4667: p_instance_id IN number,
4668: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4669: x_return_status OUT nocopy varchar2)
4670: IS
4671:
4672:
4669: x_return_status OUT nocopy varchar2)
4670: IS
4671:
4672:
4673: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4674: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4675: l_time_stamp date := sysdate;
4676:
4677: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4670: IS
4671:
4672:
4673: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
4674: l_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
4675: l_time_stamp date := sysdate;
4676:
4677: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4678: l_msg_count number := 0;
4788:
4789: PROCEDURE mark_and_get_nsrl_option(
4790: p_class_quantity IN number,
4791: p_quantity_ratio IN number,
4792: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4793: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4794: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4795: x_return_status OUT nocopy varchar2)
4796: IS
4789: PROCEDURE mark_and_get_nsrl_option(
4790: p_class_quantity IN number,
4791: p_quantity_ratio IN number,
4792: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4793: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4794: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4795: x_return_status OUT nocopy varchar2)
4796: IS
4797:
4790: p_class_quantity IN number,
4791: p_quantity_ratio IN number,
4792: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4793: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4794: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4795: x_return_status OUT nocopy varchar2)
4796: IS
4797:
4798: px_ind binary_integer := 0;
4800:
4801: l_instance_quantity number;
4802: l_vld_organization_id number;
4803:
4804: l_splitted_instances csi_datastructures_pub.instance_tbl;
4805:
4806: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4807: l_msg_count number;
4808: l_msg_data varchar2(2000);
4909: x_return_status := fnd_api.g_ret_sts_error;
4910: END mark_and_get_nsrl_option;
4911:
4912: PROCEDURE mark_and_get_srl_option(
4913: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4914: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4915: x_return_status OUT nocopy varchar2)
4916: IS
4917: px_ind binary_integer := 0;
4910: END mark_and_get_nsrl_option;
4911:
4912: PROCEDURE mark_and_get_srl_option(
4913: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4914: x_option_ii_rltns_rec OUT nocopy csi_datastructures_pub.ii_relationship_rec,
4915: x_return_status OUT nocopy varchar2)
4916: IS
4917: px_ind binary_integer := 0;
4918: BEGIN
4932: p_option_line_rec IN oe_order_pub.line_rec_type,
4933: p_option_serial_code IN number,
4934: p_config_rec IN config_rec,
4935: p_transaction_line_id IN number,
4936: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4937: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4938: x_return_status OUT nocopy varchar2)
4939: IS
4940: l_option_instance varchar2(1);
4933: p_option_serial_code IN number,
4934: p_config_rec IN config_rec,
4935: p_transaction_line_id IN number,
4936: px_ii_rltns_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4937: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4938: x_return_status OUT nocopy varchar2)
4939: IS
4940: l_option_instance varchar2(1);
4941: l_ind binary_integer := 0;
4938: x_return_status OUT nocopy varchar2)
4939: IS
4940: l_option_instance varchar2(1);
4941: l_ind binary_integer := 0;
4942: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4943: l_wip_instances wip_instances;
4944: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4945: CURSOR option_cp_cur IS
4946: SELECT cii.instance_id
5412: p_order_line_rec IN oe_order_lines_all%rowtype,
5413: p_config_rec IN config_rec,
5414: p_config_instances IN config_serial_inst_tbl,
5415: px_default_info_rec IN OUT NOCOPY default_info_rec,
5416: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5417: x_return_status OUT nocopy varchar2)
5418: IS
5419:
5420: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5440:
5441: oct_ind binary_integer := 0;
5442: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5443:
5444: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5445: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5446: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5447:
5448: l_time_stamp date := null;
5441: oct_ind binary_integer := 0;
5442: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5443:
5444: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5445: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5446: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5447:
5448: l_time_stamp date := null;
5449:
5442: l_oc_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
5443:
5444: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
5445: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5446: l_temp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5447:
5448: l_time_stamp date := null;
5449:
5450: l_pcm_tbl parent_child_map_tbl;
5451: pcm_ind binary_integer := 0;
5452:
5453: l_class_option_ratio number;
5454: l_option_serial_code number;
5455: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5456: l_option_ns_tld_id number;
5457:
5458: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5459: l_instance_id_lst csi_datastructures_pub.id_tbl;
5454: l_option_serial_code number;
5455: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5456: l_option_ns_tld_id number;
5457:
5458: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5459: l_instance_id_lst csi_datastructures_pub.id_tbl;
5460:
5461: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5462: l_wip_processing boolean := FALSE;
5455: l_option_ii_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5456: l_option_ns_tld_id number;
5457:
5458: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
5459: l_instance_id_lst csi_datastructures_pub.id_tbl;
5460:
5461: l_t_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
5462: l_wip_processing boolean := FALSE;
5463: l_non_wip_child_line_tbl oe_order_pub.line_tbl_type;
5496: p_parent_instance IN parent_instance,
5497: x_config_instance OUT nocopy config_serial_inst_rec,
5498: x_return_status OUT nocopy varchar2)
5499: IS
5500: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
5501: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5502: l_msg_count number;
5503: l_msg_data varchar2(2000);
5504: BEGIN
6208: p_identified_item_type IN varchar2,
6209: p_config_rec IN config_rec,
6210: p_config_instances IN config_serial_inst_tbl,
6211: px_default_info_rec IN OUT nocopy default_info_rec,
6212: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
6213: x_return_status OUT nocopy varchar2)
6214: IS
6215:
6216: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6212: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
6213: x_return_status OUT nocopy varchar2)
6214: IS
6215:
6216: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6217: l_party_query_rec csi_datastructures_pub.party_query_rec;
6218: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6213: x_return_status OUT nocopy varchar2)
6214: IS
6215:
6216: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6217: l_party_query_rec csi_datastructures_pub.party_query_rec;
6218: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6214: IS
6215:
6216: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6217: l_party_query_rec csi_datastructures_pub.party_query_rec;
6218: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6222:
6216: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6217: l_party_query_rec csi_datastructures_pub.party_query_rec;
6218: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6222:
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6217: l_party_query_rec csi_datastructures_pub.party_query_rec;
6218: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6219:
6220: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6221: l_instance_tbl csi_datastructures_pub.instance_tbl;
6222:
6223: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6224: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6225:
6521: END build_parent_relation;
6522:
6523: PROCEDURE mark_and_get_instances(
6524: p_qty_ratio IN number,
6525: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6526: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6527: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6528: x_return_status OUT nocopy varchar2)
6529: IS
6522:
6523: PROCEDURE mark_and_get_instances(
6524: p_qty_ratio IN number,
6525: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6526: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6527: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6528: x_return_status OUT nocopy varchar2)
6529: IS
6530: l_satisfied varchar2(1) := 'N';
6523: PROCEDURE mark_and_get_instances(
6524: p_qty_ratio IN number,
6525: px_instance_tbl IN OUT nocopy csi_datastructures_pub.instance_tbl,
6526: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6527: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
6528: x_return_status OUT nocopy varchar2)
6529: IS
6530: l_satisfied varchar2(1) := 'N';
6531: l_qty_allocated number := 0;
6534: x_ind binary_integer := 0;
6535: px_ind binary_integer := 0;
6536: --fix for bug5096435
6537: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6538: l_new_instance_rec csi_datastructures_pub.instance_rec;
6539: BEGIN
6540: x_return_status := fnd_api.g_ret_sts_success;
6541: api_log('mark_and_get_instances');
6542:
6593: PROCEDURE build_child_relation_lines (
6594: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6595: p_child_line_tbl IN oe_order_pub.line_tbl_type,
6596: px_default_info_rec IN OUT NOCOPY default_info_rec,
6597: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6598: x_return_status OUT NOCOPY varchar2)
6599: IS
6600: l_qty_ratio NUMBER;
6601: l_order_line_qty number;
6601: l_order_line_qty number;
6602: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6603: l_next_item_id number := 0;
6604: l_temp_idx number := 0;
6605: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6606: l_temp_index number := 0;
6607: l_child_line_tbl oe_order_pub.line_tbl_type;
6608:
6609: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6605: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6606: l_temp_index number := 0;
6607: l_child_line_tbl oe_order_pub.line_tbl_type;
6608:
6609: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6610: l_party_query_rec csi_datastructures_pub.party_query_rec;
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6612: l_instance_found boolean;
6613:
6606: l_temp_index number := 0;
6607: l_child_line_tbl oe_order_pub.line_tbl_type;
6608:
6609: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6610: l_party_query_rec csi_datastructures_pub.party_query_rec;
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6612: l_instance_found boolean;
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6607: l_child_line_tbl oe_order_pub.line_tbl_type;
6608:
6609: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6610: l_party_query_rec csi_datastructures_pub.party_query_rec;
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6612: l_instance_found boolean;
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610: l_party_query_rec csi_datastructures_pub.party_query_rec;
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6612: l_instance_found boolean;
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6616: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6617: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6618:
6611: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6612: l_instance_found boolean;
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6616: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6617: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6618:
6619: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6612: l_instance_found boolean;
6613:
6614: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6615: l_instance_tbl csi_datastructures_pub.instance_tbl;
6616: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6617: l_t_iir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6618:
6619: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6620: l_object_id number;
6867: p_order_line_rec IN oe_order_lines_all%ROWTYPE,
6868: p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6869: p_identified_item_type IN varchar2,
6870: px_default_info_rec IN OUT NOCOPY default_info_rec,
6871: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6872: x_return_status OUT NOCOPY varchar2)
6873: IS
6874:
6875: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6871: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6872: x_return_status OUT NOCOPY varchar2)
6873: IS
6874:
6875: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6876: l_party_query_rec csi_datastructures_pub.party_query_rec;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6872: x_return_status OUT NOCOPY varchar2)
6873: IS
6874:
6875: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6876: l_party_query_rec csi_datastructures_pub.party_query_rec;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6873: IS
6874:
6875: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6876: l_party_query_rec csi_datastructures_pub.party_query_rec;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6881: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6875: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6876: l_party_query_rec csi_datastructures_pub.party_query_rec;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6881: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6882:
6883:
6876: l_party_query_rec csi_datastructures_pub.party_query_rec;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6881: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6882:
6883:
6884: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6877: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6878:
6879: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6880: l_instance_tbl csi_datastructures_pub.instance_tbl;
6881: l_alloc_instance_tbl csi_datastructures_pub.instance_tbl;
6882:
6883:
6884: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6885:
6904: l_order_line_qty number;
6905: l_temp_child_line_rec oe_order_pub.Line_Rec_Type;
6906: l_next_item_id number := 0;
6907: l_temp_idx number := 0;
6908: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6909: l_temp_index number := 0;
6910:
6911: BEGIN
6912:
7154: px_default_info_rec IN OUT nocopy default_info_rec,
7155: x_return_status OUT nocopy Varchar2)
7156: IS
7157:
7158: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7159:
7160: l_parent_line_rec oe_order_pub.line_rec_type;
7161: l_option_serial_code number;
7162:
7166: l_config_instances config_serial_inst_tbl;
7167:
7168: l_qty_ratio number;
7169:
7170: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7171: l_ind binary_integer;
7172: l_msg_count number;
7173: l_msg_data varchar2(2000);
7174: l_return_status varchar2(1);
7441: x_config_instance OUT nocopy config_serial_inst_rec,
7442: x_return_status OUT nocopy varchar2)
7443: IS
7444:
7445: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
7446: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7447: l_time_stamp date := null;
7448:
7449: l_config_instance config_serial_inst_rec;
7442: x_return_status OUT nocopy varchar2)
7443: IS
7444:
7445: l_ii_rltns_qry_rec csi_datastructures_pub.relationship_query_rec;
7446: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7447: l_time_stamp date := null;
7448:
7449: l_config_instance config_serial_inst_rec;
7450:
7535: px_default_info_rec IN OUT nocopy default_info_rec,
7536: x_return_status OUT nocopy varchar2)
7537: IS
7538:
7539: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7540:
7541: l_parent_line_rec oe_order_pub.line_rec_type;
7542: l_option_serial_code number;
7543:
7549: l_config_class_ratio number;
7550:
7551: l_config_parent config_serial_inst_rec;
7552:
7553: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
7554: l_instance_id_lst csi_datastructures_pub.id_tbl;
7555:
7556: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7557: l_ii_ind binary_integer := 0;
7550:
7551: l_config_parent config_serial_inst_rec;
7552:
7553: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
7554: l_instance_id_lst csi_datastructures_pub.id_tbl;
7555:
7556: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7557: l_ii_ind binary_integer := 0;
7558:
7552:
7553: l_exp_rltns_rec csi_datastructures_pub.ii_relationship_rec;
7554: l_instance_id_lst csi_datastructures_pub.id_tbl;
7555:
7556: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
7557: l_ii_ind binary_integer := 0;
7558:
7559: l_msg_count number;
7560: l_msg_data varchar2(2000);
8059: PROCEDURE demo_fulfillment(
8060: p_txn_type_id IN number,
8061: p_order_line_rec IN oe_order_lines_all%rowtype,
8062: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
8063: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
8064: x_return_status OUT nocopy varchar2)
8065: IS
8066:
8067: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8063: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
8064: x_return_status OUT nocopy varchar2)
8065: IS
8066:
8067: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8068:
8069: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8070: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8071:
8078: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8079: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8080: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8081:
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8082: l_instance_rec csi_datastructures_pub.instance_header_rec;
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8083: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8084: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8085: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
8086: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
8087: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8088: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
8089: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
8090:
8091: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8092: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8093: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
8108: l_msg_data varchar2(2000);
8109: l_msg_count number;
8110: l_inst_loc_id number;
8111: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
8112: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
8113: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
8114: l_quantity1 NUMBER;
8115: l_vld_orgn_id number;
8116:
8109: l_msg_count number;
8110: l_inst_loc_id number;
8111: l_inst_loc_type csi_item_instances.location_type_code%TYPE;
8112: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
8113: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
8114: l_quantity1 NUMBER;
8115: l_vld_orgn_id number;
8116:
8117: BEGIN
8119: csi_t_gen_utility_pvt.dump_api_info(
8120: p_api_name => 'demo_fulfillment',
8121: p_pkg_name => 'csi_order_fulfill_pub');
8122:
8123: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8124: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
8125:
8126: -- create csi_transaction
8127: create_csi_transaction(
8120: p_api_name => 'demo_fulfillment',
8121: p_pkg_name => 'csi_order_fulfill_pub');
8122:
8123: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8124: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
8125:
8126: -- create csi_transaction
8127: create_csi_transaction(
8128: px_csi_txn_rec => px_csi_txn_rec,
8450:
8451: l_source_header_rec csi_interface_pkg.source_header_rec;
8452: l_source_line_rec csi_interface_pkg.source_line_rec;
8453:
8454: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8455:
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8457: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
8458:
8473: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8474: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8475: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8476:
8477: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8478:
8479: -- Added this for unlock_item_instances
8480: l_config_tbl csi_cz_int.config_tbl;
8481:
8691: PROCEDURE query_tld_and_update_ib(
8692: p_order_header_rec IN oe_order_headers_all%rowtype,
8693: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
8694: px_default_info_rec IN OUT NOCOPY default_info_rec,
8695: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
8696: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
8697: x_return_status OUT NOCOPY varchar2)
8698: IS
8699:
8692: p_order_header_rec IN oe_order_headers_all%rowtype,
8693: p_order_line_rec IN csi_order_ship_pub.order_line_rec, --fix for bug5589710
8694: px_default_info_rec IN OUT NOCOPY default_info_rec,
8695: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
8696: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
8697: x_return_status OUT NOCOPY varchar2)
8698: IS
8699:
8700: l_tl_query_rec csi_t_datastructures_grp.txn_line_query_rec;
8710: l_p_tiir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8711: l_p_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
8712: l_p_teav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8713: l_p_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
8714: l_p_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
8715: l_p_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
8716: l_p_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
8717:
8718: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9024: PROCEDURE order_fulfillment(
9025: p_order_line_id IN number,
9026: p_message_id IN number,
9027: x_return_status OUT NOCOPY varchar2,
9028: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
9029: IS
9030:
9031: l_api_name varchar2(30) := 'order_fulfillment';
9032:
9045: l_config_instances config_serial_inst_tbl;
9046: l_config_reship_found boolean := FALSE;
9047: l_config_reship_count number := 0;
9048:
9049: l_option_instances csi_datastructures_pub.instance_tbl;
9050:
9051: l_trk_child_tbl oe_order_pub.line_tbl_type;
9052: l_trk_parent_rec oe_order_pub.line_rec_type;
9053:
9080: l_p_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9081: l_p_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
9082: l_p_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
9083: l_p_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
9084: l_p_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
9085: l_p_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
9086: l_p_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
9087:
9088: l_tmp_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9113: l_order_line_rec oe_order_lines_all%rowtype;
9114: l_order_header_rec oe_order_headers_all%rowtype;
9115:
9116: l_p_order_line_rec csi_order_ship_pub.order_line_rec;
9117: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
9118:
9119: l_identified_item_type varchar2(30);
9120: l_processing_status varchar2(30);
9121:
9146: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
9147: ---Added (End) for m-to-m enhancements
9148:
9149: skip_regular_process exception;
9150: l_error_rec csi_datastructures_pub.transaction_error_rec;
9151:
9152: -- For partner prdering
9153: l_end_customer_id number;
9154: l_current_site_use_id number;
9158: l_src_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
9159: l_src_tld_total_qty number := 0;
9160: --
9161: l_ul_txn_line_id NUMBER;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9159: l_src_tld_total_qty number := 0;
9160: --
9161: l_ul_txn_line_id NUMBER;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9160: --
9161: l_ul_txn_line_id NUMBER;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9161: l_ul_txn_line_id NUMBER;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9169: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
9162: l_ul_instance_rec csi_datastructures_pub.instance_rec;
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9169: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
9170:
9163: l_u_parties_tbl csi_datastructures_pub.party_tbl;
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9169: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
9170:
9171: --Variables declared for bug 10329599
9164: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9169: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
9170:
9171: --Variables declared for bug 10329599
9172: l_option_flag VARCHAR2(1) := 'Y';
9165: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
9166: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
9167: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
9168: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
9169: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
9170:
9171: --Variables declared for bug 10329599
9172: l_option_flag VARCHAR2(1) := 'Y';
9173: l_phantom_option_flag VARCHAR2(1) := 'N';
9212: /* this routine checks if ib is active */
9213: csi_utility_grp.check_ib_active;
9214:
9215: l_default_info_rec.internal_party_id :=
9216: csi_datastructures_pub.g_install_param_rec.internal_party_id;
9217: l_default_info_rec.freeze_date :=
9218: csi_datastructures_pub.g_install_param_rec.freeze_date;
9219: l_default_info_rec.ownership_cascade_at_txn :=
9220: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
9214:
9215: l_default_info_rec.internal_party_id :=
9216: csi_datastructures_pub.g_install_param_rec.internal_party_id;
9217: l_default_info_rec.freeze_date :=
9218: csi_datastructures_pub.g_install_param_rec.freeze_date;
9219: l_default_info_rec.ownership_cascade_at_txn :=
9220: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
9221:
9222: /* get the default sub type id */
9216: csi_datastructures_pub.g_install_param_rec.internal_party_id;
9217: l_default_info_rec.freeze_date :=
9218: csi_datastructures_pub.g_install_param_rec.freeze_date;
9219: l_default_info_rec.ownership_cascade_at_txn :=
9220: csi_datastructures_pub.g_install_param_rec.ownership_cascade_at_txn;
9221:
9222: /* get the default sub type id */
9223: csi_utl_pkg.get_dflt_sub_type_id(
9224: p_transaction_type_id => l_txn_type_id,
10822: PROCEDURE logical_drop_ship(
10823: p_mtl_txn_id IN number,
10824: p_message_id IN number,
10825: x_return_status OUT NOCOPY varchar2,
10826: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
10827: IS
10828:
10829: l_api_name varchar2(30) := 'logical_drop_ship';
10830: l_txn_line_id number;
10839: l_msg_data varchar2(2000);
10840: l_msg_count number;
10841:
10842: skip_regular_process exception;
10843: l_error_rec csi_datastructures_pub.transaction_error_rec;
10844: l_order_line_rec csi_order_ship_pub.order_line_rec;
10845: x_order_shipment_tbl csi_order_ship_pub.order_shipment_tbl;
10846: l_count number := 0;
10847: l_party_id number;
10851: x_trx_line_id number;
10852:
10853: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
10854: l_trx_detail_exist boolean := FALSE;
10855: l_trx_rec csi_datastructures_pub.transaction_rec;
10856:
10857: l_exp_instance_rec csi_datastructures_pub.instance_rec;
10858: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
10859: l_exp_instance_id number;
10853: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
10854: l_trx_detail_exist boolean := FALSE;
10855: l_trx_rec csi_datastructures_pub.transaction_rec;
10856:
10857: l_exp_instance_rec csi_datastructures_pub.instance_rec;
10858: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
10859: l_exp_instance_id number;
10860: l_exp_obj_ver_num number;
10861: l_exp_active_end_date date;
10854: l_trx_detail_exist boolean := FALSE;
10855: l_trx_rec csi_datastructures_pub.transaction_rec;
10856:
10857: l_exp_instance_rec csi_datastructures_pub.instance_rec;
10858: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
10859: l_exp_instance_id number;
10860: l_exp_obj_ver_num number;
10861: l_exp_active_end_date date;
10862: l_exp_loc_type_code varchar2(30);
10860: l_exp_obj_ver_num number;
10861: l_exp_active_end_date date;
10862: l_exp_loc_type_code varchar2(30);
10863:
10864: p_instance_rec csi_datastructures_pub.instance_rec;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10861: l_exp_active_end_date date;
10862: l_exp_loc_type_code varchar2(30);
10863:
10864: p_instance_rec csi_datastructures_pub.instance_rec;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10862: l_exp_loc_type_code varchar2(30);
10863:
10864: p_instance_rec csi_datastructures_pub.instance_rec;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10863:
10864: p_instance_rec csi_datastructures_pub.instance_rec;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10864: p_instance_rec csi_datastructures_pub.instance_rec;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10872: x_instance_id_lst csi_datastructures_pub.id_tbl;
10865: p_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10872: x_instance_id_lst csi_datastructures_pub.id_tbl;
10873: -- x_return_status varchar2(2000);
10866: p_party_tbl csi_datastructures_pub.party_tbl;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10872: x_instance_id_lst csi_datastructures_pub.id_tbl;
10873: -- x_return_status varchar2(2000);
10874: x_msg_count number;
10867: p_party_account_tbl csi_datastructures_pub.party_account_tbl;
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10872: x_instance_id_lst csi_datastructures_pub.id_tbl;
10873: -- x_return_status varchar2(2000);
10874: x_msg_count number;
10875: x_msg_data varchar2(2000);
10868: p_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
10869: p_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
10870: p_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
10871: p_txn_rec csi_datastructures_pub.transaction_rec;
10872: x_instance_id_lst csi_datastructures_pub.id_tbl;
10873: -- x_return_status varchar2(2000);
10874: x_msg_count number;
10875: x_msg_data varchar2(2000);
10876: t_output varchar2(2000);
11603:
11604: l_return_status VARCHAR2(1);
11605: l_error_code VARCHAR2(30);
11606: l_error_message VARCHAR2(2000);
11607: l_error_rec csi_datastructures_pub.transaction_error_rec;
11608:
11609: BEGIN
11610:
11611: x_return_status := FND_API.G_RET_STS_SUCCESS;
11614: p_file_segment1 => 'csi',
11615: p_file_segment2 => to_char(sysdate, 'DDMMYY'),
11616: p_file_segment3 => 'invoke');
11617:
11618: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11619: csi_gen_utility_pvt.populate_install_param_rec;
11620: END IF;
11621:
11622: l_bypass := csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag;
11618: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11619: csi_gen_utility_pvt.populate_install_param_rec;
11620: END IF;
11621:
11622: l_bypass := csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag;
11623:
11624: IF l_bypass = 'Y' THEN
11625:
11626: csi_t_gen_utility_pvt.add('Bypassing the SDP queue for the order line id: '||p_order_line_id);
11749: end if;
11750: --
11751: -- Get the Date from CSI_INSTALL_PARAMETERS
11752:
11753: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11754: csi_gen_utility_pvt.populate_install_param_rec;
11755: END IF;
11756:
11757: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
11753: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
11754: csi_gen_utility_pvt.populate_install_param_rec;
11755: END IF;
11756:
11757: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
11758:
11759: --
11760: -- Get the Multi-org Flag.
11761: l_multi_org_flag := 'X';
12283: RETURN;
12284: End;
12285:
12286: -- Get the Date from CSI_INSTALL_PARAMETERS
12287: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12288: csi_gen_utility_pvt.populate_install_param_rec;
12289: END IF;
12290:
12291: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
12287: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12288: csi_gen_utility_pvt.populate_install_param_rec;
12289: END IF;
12290:
12291: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
12292:
12293: --
12294: l_multi_org_flag := 'X';
12295: Begin