[Home] [Help]
411: x_return_status := fnd_api.g_ret_sts_error;
412: END get_mmt_info;
413:
414: PROCEDURE make_non_hdr_rec(
415: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
416: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
417: x_return_status OUT NOCOPY varchar2)
418: IS
419:
412: END get_mmt_info;
413:
414: PROCEDURE make_non_hdr_rec(
415: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
416: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
417: x_return_status OUT NOCOPY varchar2)
418: IS
419:
420: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
416: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
417: x_return_status OUT NOCOPY varchar2)
418: IS
419:
420: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
421: l_instance_tbl csi_datastructures_pub.instance_tbl;
422:
423: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
424:
417: x_return_status OUT NOCOPY varchar2)
418: IS
419:
420: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
421: l_instance_tbl csi_datastructures_pub.instance_tbl;
422:
423: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
424:
425: BEGIN
449:
450: PROCEDURE increment_comp_instance(
451: p_instance_id IN number,
452: p_quantity IN number,
453: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
454: x_return_status OUT NOCOPY varchar2)
455: IS
456:
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
453: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
454: x_return_status OUT NOCOPY varchar2)
455: IS
456:
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
454: x_return_status OUT NOCOPY varchar2)
455: IS
456:
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
455: IS
456:
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
456:
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
464: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
457: l_u_instance_rec csi_datastructures_pub.instance_rec;
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
464: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
465:
458: l_u_parties_tbl csi_datastructures_pub.party_tbl;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
464: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
465:
466: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
459: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
464: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
465:
466: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
467: l_msg_count number;
460: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
461: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
462: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
463: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
464: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
465:
466: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
467: l_msg_count number;
468: l_msg_data varchar2(2000);
522:
523: PROCEDURE decrement_wip_instance(
524: p_instance_id IN number,
525: p_quantity IN number,
526: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
527: x_return_status OUT NOCOPY varchar2)
528: IS
529:
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
526: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
527: x_return_status OUT NOCOPY varchar2)
528: IS
529:
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
527: x_return_status OUT NOCOPY varchar2)
528: IS
529:
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
528: IS
529:
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
529:
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
537: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
530: l_u_instance_rec csi_datastructures_pub.instance_rec;
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
537: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
538:
531: l_u_parties_tbl csi_datastructures_pub.party_tbl;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
537: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
538:
539: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
532: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
537: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
538:
539: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
540: l_msg_count number;
533: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
534: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
535: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
536: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
537: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
538:
539: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
540: l_msg_count number;
541: l_msg_data varchar2(2000);
597: p_instance_id IN number,
598: p_quantity IN number,
599: p_organization_id IN number,
600: x_new_instance_id OUT NOCOPY number,
601: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
602: x_return_status OUT NOCOPY varchar2)
603: IS
604:
605: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
606: l_msg_data varchar2(2000);
607: l_msg_count number;
608:
609: -- get_item_instance_details variables
610: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
607: l_msg_count number;
608:
609: -- get_item_instance_details variables
610: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
608:
609: -- get_item_instance_details variables
610: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
609: -- get_item_instance_details variables
610: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
610: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
618: l_g_time_stamp date;
611: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
618: l_g_time_stamp date;
619:
612: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
618: l_g_time_stamp date;
619:
620: -- make_non_hdr variables
613: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
614: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
615: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
616: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
618: l_g_time_stamp date;
619:
620: -- make_non_hdr variables
621: l_instance_rec csi_datastructures_pub.instance_rec;
617: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
618: l_g_time_stamp date;
619:
620: -- make_non_hdr variables
621: l_instance_rec csi_datastructures_pub.instance_rec;
622:
623: -- create_item_instance varaibles
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
620: -- make_non_hdr variables
621: l_instance_rec csi_datastructures_pub.instance_rec;
622:
623: -- create_item_instance varaibles
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_instance_rec csi_datastructures_pub.instance_rec;
622:
623: -- create_item_instance varaibles
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
622:
623: -- create_item_instance varaibles
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
630: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
623: -- create_item_instance varaibles
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
630: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
631:
624: l_c_instance_rec csi_datastructures_pub.instance_rec;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
630: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
631:
632: c_pa_ind binary_integer := 0;
625: l_c_parties_tbl csi_datastructures_pub.party_tbl;
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
630: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
631:
632: c_pa_ind binary_integer := 0;
633:
626: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
627: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
628: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
629: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
630: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
631:
632: c_pa_ind binary_integer := 0;
633:
634: BEGIN
764: x_return_status := fnd_api.g_ret_sts_error;
765: END create_wip_instance_as;
766:
767: PROCEDURE apportion_always(
768: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
769: p_splitted_instances IN csi_datastructures_pub.instance_tbl,
770: p_job_quantity IN number,
771: p_comp_serial_code IN number,
772: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
765: END create_wip_instance_as;
766:
767: PROCEDURE apportion_always(
768: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
769: p_splitted_instances IN csi_datastructures_pub.instance_tbl,
770: p_job_quantity IN number,
771: p_comp_serial_code IN number,
772: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
773: x_return_status OUT NOCOPY varchar2)
772: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
773: x_return_status OUT NOCOPY varchar2)
774: IS
775:
776: l_assy_tbl csi_datastructures_pub.instance_tbl;
777: l_issues_tbl csi_datastructures_pub.instance_tbl;
778:
779: l_ac_mapping_tbl assy_comp_map_tbl;
780: l_ac_ind binary_integer;
773: x_return_status OUT NOCOPY varchar2)
774: IS
775:
776: l_assy_tbl csi_datastructures_pub.instance_tbl;
777: l_issues_tbl csi_datastructures_pub.instance_tbl;
778:
779: l_ac_mapping_tbl assy_comp_map_tbl;
780: l_ac_ind binary_integer;
781: l_remaining_quantity number;
1001: p_organization_id IN number,
1002: p_assembly_item_id IN number,
1003: p_completion_quantity IN number,
1004: p_location_code IN varchar2,
1005: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1006: x_return_status OUT NOCOPY varchar2)
1007: IS
1008:
1009: --l_inventory_item_id wip_discrete_jobs.primary_item_id%TYPE;
1010: l_completion_quantity number;
1011: l_relation_found varchar2(1) := 'N';
1012:
1013: -- get_item_instances variables
1014: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1015: l_party_query_rec csi_datastructures_pub.party_query_rec;
1016: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1017:
1018: --
1011: l_relation_found varchar2(1) := 'N';
1012:
1013: -- get_item_instances variables
1014: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1015: l_party_query_rec csi_datastructures_pub.party_query_rec;
1016: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1017:
1018: --
1019: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1012:
1013: -- get_item_instances variables
1014: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1015: l_party_query_rec csi_datastructures_pub.party_query_rec;
1016: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1017:
1018: --
1019: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1020: l_instance_tbl csi_datastructures_pub.instance_tbl;
1015: l_party_query_rec csi_datastructures_pub.party_query_rec;
1016: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1017:
1018: --
1019: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1020: l_instance_tbl csi_datastructures_pub.instance_tbl;
1021:
1022: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1023: l_msg_data varchar2(2000);
1016: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1017:
1018: --
1019: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1020: l_instance_tbl csi_datastructures_pub.instance_tbl;
1021:
1022: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1023: l_msg_data varchar2(2000);
1024: l_msg_count number;
1279: p_wip_entity_id IN number,
1280: p_organization_id IN number,
1281: p_inventory_item_id IN number,
1282: p_serial_number IN varchar2,
1283: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1284: x_return_status OUT NOCOPY varchar2)
1285: IS
1286:
1287: -- get_item_instances variables
1284: x_return_status OUT NOCOPY varchar2)
1285: IS
1286:
1287: -- get_item_instances variables
1288: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1289: l_party_query_rec csi_datastructures_pub.party_query_rec;
1290: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1291:
1292: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1285: IS
1286:
1287: -- get_item_instances variables
1288: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1289: l_party_query_rec csi_datastructures_pub.party_query_rec;
1290: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1291:
1292: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1293:
1286:
1287: -- get_item_instances variables
1288: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1289: l_party_query_rec csi_datastructures_pub.party_query_rec;
1290: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1291:
1292: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1293:
1294: l_instance_tbl csi_datastructures_pub.instance_tbl;
1288: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1289: l_party_query_rec csi_datastructures_pub.party_query_rec;
1290: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1291:
1292: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1293:
1294: l_instance_tbl csi_datastructures_pub.instance_tbl;
1295: --
1296: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1290: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1291:
1292: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1293:
1294: l_instance_tbl csi_datastructures_pub.instance_tbl;
1295: --
1296: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1297: l_msg_data varchar2(2000);
1298: l_msg_count number;
1358:
1359: PROCEDURE get_serial_instance(
1360: p_inventory_item_id IN number,
1361: p_serial_number IN varchar2,
1362: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1363: x_return_status OUT NOCOPY varchar2)
1364: IS
1365:
1366: -- get_item_instances variables
1363: x_return_status OUT NOCOPY varchar2)
1364: IS
1365:
1366: -- get_item_instances variables
1367: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1368: l_party_query_rec csi_datastructures_pub.party_query_rec;
1369: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1370:
1371: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1364: IS
1365:
1366: -- get_item_instances variables
1367: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1368: l_party_query_rec csi_datastructures_pub.party_query_rec;
1369: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1370:
1371: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1372: l_instance_tbl csi_datastructures_pub.instance_tbl;
1365:
1366: -- get_item_instances variables
1367: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1368: l_party_query_rec csi_datastructures_pub.party_query_rec;
1369: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1370:
1371: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1372: l_instance_tbl csi_datastructures_pub.instance_tbl;
1373:
1367: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1368: l_party_query_rec csi_datastructures_pub.party_query_rec;
1369: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1370:
1371: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1372: l_instance_tbl csi_datastructures_pub.instance_tbl;
1373:
1374: --
1375: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1368: l_party_query_rec csi_datastructures_pub.party_query_rec;
1369: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1370:
1371: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1372: l_instance_tbl csi_datastructures_pub.instance_tbl;
1373:
1374: --
1375: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1376: l_msg_data varchar2(2000);
1376: l_msg_data varchar2(2000);
1377: l_msg_count number;
1378:
1379: l_t_ind binary_integer := 0;
1380: l_tmp_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1381:
1382: BEGIN
1383:
1384: x_return_status := fnd_api.g_ret_sts_success;
1447: p_instance_id IN number,
1448: p_qty_ratio IN number,
1449: p_qty_completed IN number,
1450: p_organization_id IN number,
1451: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1452: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1453: x_return_status OUT NOCOPY varchar2)
1454: IS
1455:
1448: p_qty_ratio IN number,
1449: p_qty_completed IN number,
1450: p_organization_id IN number,
1451: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1452: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1453: x_return_status OUT NOCOPY varchar2)
1454: IS
1455:
1456: l_qty_remaining number;
1454: IS
1455:
1456: l_qty_remaining number;
1457:
1458: l_init_instance_rec csi_datastructures_pub.instance_rec;
1459:
1460: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1461: l_msg_data varchar2(2000);
1462: l_msg_count number;
1462: l_msg_count number;
1463:
1464: l_split_flag boolean := FALSE;
1465:
1466: l_splitted_instances csi_datastructures_pub.instance_tbl;
1467: l_s_ind binary_integer;
1468:
1469: -- get_item_instance_details variables
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1466: l_splitted_instances csi_datastructures_pub.instance_tbl;
1467: l_s_ind binary_integer;
1468:
1469: -- get_item_instance_details variables
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1467: l_s_ind binary_integer;
1468:
1469: -- get_item_instance_details variables
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1468:
1469: -- get_item_instance_details variables
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1469: -- get_item_instance_details variables
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1470: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1478: l_g_time_stamp date;
1471: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1478: l_g_time_stamp date;
1479:
1472: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1478: l_g_time_stamp date;
1479:
1480: -- make_non_hdr variables
1473: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1474: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1475: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1476: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1478: l_g_time_stamp date;
1479:
1480: -- make_non_hdr variables
1481: l_instance_rec csi_datastructures_pub.instance_rec;
1477: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1478: l_g_time_stamp date;
1479:
1480: -- make_non_hdr variables
1481: l_instance_rec csi_datastructures_pub.instance_rec;
1482:
1483: -- update_item_instance variables
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1480: -- make_non_hdr variables
1481: l_instance_rec csi_datastructures_pub.instance_rec;
1482:
1483: -- update_item_instance variables
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1481: l_instance_rec csi_datastructures_pub.instance_rec;
1482:
1483: -- update_item_instance variables
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1482:
1483: -- update_item_instance variables
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1483: -- update_item_instance variables
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1484: l_u_instance_rec csi_datastructures_pub.instance_rec;
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1485: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1493: -- create_item_instance varaibles
1486: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1487: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1488: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1489: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1490: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1491: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1492:
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1492:
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1500: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1493: -- create_item_instance varaibles
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1500: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1501: c_pa_ind binary_integer;
1494: l_c_instance_rec csi_datastructures_pub.instance_rec;
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1500: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1501: c_pa_ind binary_integer;
1502:
1495: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1500: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1501: c_pa_ind binary_integer;
1502:
1503: BEGIN
1496: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1497: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1498: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1499: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1500: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1501: c_pa_ind binary_integer;
1502:
1503: BEGIN
1504:
1733: PROCEDURE split_instances_using_ratio(
1734: p_qty_ratio IN number,
1735: p_qty_completed IN number,
1736: p_organization_id IN number,
1737: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1738: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1739: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1734: p_qty_ratio IN number,
1735: p_qty_completed IN number,
1736: p_organization_id IN number,
1737: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1738: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1739: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1735: p_qty_completed IN number,
1736: p_organization_id IN number,
1737: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1738: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1739: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1743: l_splitted_instances csi_datastructures_pub.instance_tbl;
1739: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1740: x_return_status OUT NOCOPY varchar2)
1741: IS
1742: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1743: l_splitted_instances csi_datastructures_pub.instance_tbl;
1744: BEGIN
1745:
1746: x_return_status := fnd_api.g_ret_sts_success;
1747:
1778: PROCEDURE split_issued_instances(
1779: p_organization_id IN number,
1780: p_job_quantity IN number,
1781: p_completion_quantity IN number,
1782: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1783: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1784: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1785: x_return_status OUT NOCOPY varchar2)
1786: IS
1779: p_organization_id IN number,
1780: p_job_quantity IN number,
1781: p_completion_quantity IN number,
1782: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1783: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1784: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1785: x_return_status OUT NOCOPY varchar2)
1786: IS
1787:
1780: p_job_quantity IN number,
1781: p_completion_quantity IN number,
1782: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1783: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1784: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1785: x_return_status OUT NOCOPY varchar2)
1786: IS
1787:
1788: l_allocated_quantity number;
1787:
1788: l_allocated_quantity number;
1789: l_remaining_quantity number;
1790:
1791: l_new_instance_rec csi_datastructures_pub.instance_rec;
1792:
1793: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1794: l_msg_data varchar2(2000);
1795: l_msg_count number;
1795: l_msg_count number;
1796:
1797: l_split_counter number;
1798:
1799: l_splitted_instances csi_datastructures_pub.instance_tbl;
1800: l_s_ind binary_integer;
1801:
1802: -- get_item_instance_details variables
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1799: l_splitted_instances csi_datastructures_pub.instance_tbl;
1800: l_s_ind binary_integer;
1801:
1802: -- get_item_instance_details variables
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1800: l_s_ind binary_integer;
1801:
1802: -- get_item_instance_details variables
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1801:
1802: -- get_item_instance_details variables
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1802: -- get_item_instance_details variables
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1803: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1811: l_g_time_stamp date;
1804: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1811: l_g_time_stamp date;
1812:
1805: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1811: l_g_time_stamp date;
1812:
1813: -- update_item_instance variables
1806: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1807: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1808: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1809: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1811: l_g_time_stamp date;
1812:
1813: -- update_item_instance variables
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1810: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1811: l_g_time_stamp date;
1812:
1813: -- update_item_instance variables
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1811: l_g_time_stamp date;
1812:
1813: -- update_item_instance variables
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1812:
1813: -- update_item_instance variables
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1813: -- update_item_instance variables
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1814: l_u_instance_rec csi_datastructures_pub.instance_rec;
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1815: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1823: -- create_item_instance varaibles
1816: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1817: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1818: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1819: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1820: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1821: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1822:
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1822:
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1823: -- create_item_instance varaibles
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1831: c_pa_ind binary_integer;
1824: l_c_instance_rec csi_datastructures_pub.instance_rec;
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1831: c_pa_ind binary_integer;
1832:
1825: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1831: c_pa_ind binary_integer;
1832:
1833: l_instance_rec csi_datastructures_pub.instance_rec;
1826: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1827: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1828: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1831: c_pa_ind binary_integer;
1832:
1833: l_instance_rec csi_datastructures_pub.instance_rec;
1834: --
1829: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1830: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1831: c_pa_ind binary_integer;
1832:
1833: l_instance_rec csi_datastructures_pub.instance_rec;
1834: --
1835:
1836: BEGIN
1837:
2058: END split_issued_instances;
2059:
2060: PROCEDURE create_assy_comp_relation(
2061: p_assy_comp_map_tbl IN assy_comp_map_tbl,
2062: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2063: x_return_status OUT NOCOPY varchar2)
2064: IS
2065:
2066: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
2062: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2063: x_return_status OUT NOCOPY varchar2)
2064: IS
2065:
2066: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
2067:
2068: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2069: l_msg_count number;
2070: l_msg_data varchar2(2000);
2159: x_return_status := fnd_api.g_ret_sts_error;
2160: END create_assy_comp_relation;
2161:
2162: PROCEDURE get_genealogy_children(
2163: px_assembly_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
2164: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2165: x_return_status OUT NOCOPY varchar2)
2166: IS
2167:
2184: AND nvl(mog.end_date_active, sysdate+1);
2185:
2186: l_ac_map_tbl assy_comp_map_tbl;
2187: l_ac_ind binary_integer := 0;
2188: l_assy_tbl csi_datastructures_pub.instance_tbl;
2189: l_parent_object_id number;
2190: l_children_count number;
2191:
2192: l_child_instance_id number;
2331: p_qty_per_assy IN number,
2332: p_total_qty_issued IN number,
2333: p_job_qty IN number,
2334: p_component_item_id IN number,
2335: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2336: p_component_instances IN csi_datastructures_pub.instance_tbl,
2337: px_assy_comp_map_tbl IN OUT NOCOPY assy_comp_map_tbl,
2338: x_return_status IN OUT NOCOPY varchar2)
2339: IS
2332: p_total_qty_issued IN number,
2333: p_job_qty IN number,
2334: p_component_item_id IN number,
2335: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2336: p_component_instances IN csi_datastructures_pub.instance_tbl,
2337: px_assy_comp_map_tbl IN OUT NOCOPY assy_comp_map_tbl,
2338: x_return_status IN OUT NOCOPY varchar2)
2339: IS
2340:
2339: IS
2340:
2341: l_qty_remaining number;
2342:
2343: l_assy_tbl csi_datastructures_pub.instance_tbl;
2344: l_comp_tbl csi_datastructures_pub.instance_tbl;
2345: l_ac_map_tbl assy_comp_map_tbl;
2346:
2347: l_already_alloc_count number := 0;
2340:
2341: l_qty_remaining number;
2342:
2343: l_assy_tbl csi_datastructures_pub.instance_tbl;
2344: l_comp_tbl csi_datastructures_pub.instance_tbl;
2345: l_ac_map_tbl assy_comp_map_tbl;
2346:
2347: l_already_alloc_count number := 0;
2348: l_c_ind binary_integer := 0;
2540: p_qty_issued IN number,
2541: p_total_qty_issued IN number,
2542: p_job_qty IN number,
2543: p_organization_id IN number,
2544: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2545: p_component_instance IN csi_datastructures_pub.instance_rec,
2546: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2547: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2548: x_return_status IN OUT NOCOPY varchar2)
2541: p_total_qty_issued IN number,
2542: p_job_qty IN number,
2543: p_organization_id IN number,
2544: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2545: p_component_instance IN csi_datastructures_pub.instance_rec,
2546: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2547: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2548: x_return_status IN OUT NOCOPY varchar2)
2549: IS
2542: p_job_qty IN number,
2543: p_organization_id IN number,
2544: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2545: p_component_instance IN csi_datastructures_pub.instance_rec,
2546: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2547: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2548: x_return_status IN OUT NOCOPY varchar2)
2549: IS
2550:
2567: l_tot_qty_remaining number := 0;
2568:
2569: l_comp_found boolean := FALSE;
2570:
2571: l_assy_tbl csi_datastructures_pub.instance_tbl;
2572: l_comp_rec csi_datastructures_pub.instance_rec;
2573:
2574: l_ac_ind binary_integer := 0;
2575: l_ac_map_tbl assy_comp_map_tbl;
2568:
2569: l_comp_found boolean := FALSE;
2570:
2571: l_assy_tbl csi_datastructures_pub.instance_tbl;
2572: l_comp_rec csi_datastructures_pub.instance_rec;
2573:
2574: l_ac_ind binary_integer := 0;
2575: l_ac_map_tbl assy_comp_map_tbl;
2576:
2575: l_ac_map_tbl assy_comp_map_tbl;
2576:
2577: l_new_instance_id number;
2578:
2579: l_instance_rec csi_datastructures_pub.instance_rec;
2580:
2581: -- update_item_instance variables
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2578:
2579: l_instance_rec csi_datastructures_pub.instance_rec;
2580:
2581: -- update_item_instance variables
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2579: l_instance_rec csi_datastructures_pub.instance_rec;
2580:
2581: -- update_item_instance variables
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2580:
2581: -- update_item_instance variables
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2581: -- update_item_instance variables
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2589: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2582: l_u_instance_rec csi_datastructures_pub.instance_rec;
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2589: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2590:
2583: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2589: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2590:
2591: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2584: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2589: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2590:
2591: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2592: l_msg_data varchar2(2000);
2585: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2586: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2587: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2588: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2589: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2590:
2591: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2592: l_msg_data varchar2(2000);
2593: l_msg_count number;
2767: p_qty_issued IN number,
2768: p_total_qty_issued IN number,
2769: p_job_qty IN number,
2770: p_organization_id IN number,
2771: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2772: p_component_instances IN csi_datastructures_pub.instance_tbl,
2773: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2774: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2775: x_return_status IN OUT NOCOPY varchar2)
2768: p_total_qty_issued IN number,
2769: p_job_qty IN number,
2770: p_organization_id IN number,
2771: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2772: p_component_instances IN csi_datastructures_pub.instance_tbl,
2773: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2774: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2775: x_return_status IN OUT NOCOPY varchar2)
2776: IS
2769: p_job_qty IN number,
2770: p_organization_id IN number,
2771: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2772: p_component_instances IN csi_datastructures_pub.instance_tbl,
2773: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2774: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2775: x_return_status IN OUT NOCOPY varchar2)
2776: IS
2777:
2827: END apportion_non_serialized;
2828:
2829: PROCEDURE build_discrete_rltn_at_wipac(
2830: p_txn_ref IN txn_ref,
2831: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2832: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2833: x_return_status OUT NOCOPY varchar2)
2834: IS
2835: l_auto_allocate varchar2(1);
2828:
2829: PROCEDURE build_discrete_rltn_at_wipac(
2830: p_txn_ref IN txn_ref,
2831: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2832: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2833: x_return_status OUT NOCOPY varchar2)
2834: IS
2835: l_auto_allocate varchar2(1);
2836:
2834: IS
2835: l_auto_allocate varchar2(1);
2836:
2837: l_requirements_tbl requirements_tbl;
2838: l_issued_instances csi_datastructures_pub.instance_tbl;
2839: l_assembly_instances csi_datastructures_pub.instance_tbl;
2840:
2841: l_splitted_instances csi_datastructures_pub.instance_tbl;
2842: l_assy_comp_map_tbl assy_comp_map_tbl;
2835: l_auto_allocate varchar2(1);
2836:
2837: l_requirements_tbl requirements_tbl;
2838: l_issued_instances csi_datastructures_pub.instance_tbl;
2839: l_assembly_instances csi_datastructures_pub.instance_tbl;
2840:
2841: l_splitted_instances csi_datastructures_pub.instance_tbl;
2842: l_assy_comp_map_tbl assy_comp_map_tbl;
2843: l_comp_serial_code number;
2837: l_requirements_tbl requirements_tbl;
2838: l_issued_instances csi_datastructures_pub.instance_tbl;
2839: l_assembly_instances csi_datastructures_pub.instance_tbl;
2840:
2841: l_splitted_instances csi_datastructures_pub.instance_tbl;
2842: l_assy_comp_map_tbl assy_comp_map_tbl;
2843: l_comp_serial_code number;
2844:
2845: end_process exception;
2855: x_return_status := fnd_api.g_ret_sts_success;
2856:
2857: api_log('build_discrete_rltn_at_wipac');
2858:
2859: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
2860:
2861: l_assembly_instances := p_assembly_instances;
2862:
2863: debug('Assembly Instances Count: '||l_assembly_instances.COUNT);
3070: END build_discrete_rltn_at_wipac;
3071:
3072: PROCEDURE filter_assembly_instances(
3073: p_wip_entity_id IN number,
3074: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3075: p_component_item_id IN number,
3076: p_quantity_ratio IN number,
3077: x_filtered_assy_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3078: x_return_status OUT NOCOPY varchar2)
3073: p_wip_entity_id IN number,
3074: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3075: p_component_item_id IN number,
3076: p_quantity_ratio IN number,
3077: x_filtered_assy_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3078: x_return_status OUT NOCOPY varchar2)
3079: IS
3080:
3081: CURSOR rltns_cur(p_parent_instance_id IN number) IS
3093: AND sysdate between nvl(cii.active_start_date, sysdate-1)
3094: and nvl(cii.active_end_date, sysdate+1);
3095: */
3096:
3097: l_filtered_assy_instances csi_datastructures_pub.instance_tbl;
3098: l_relation_found boolean := FALSE;
3099: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3100: l_f_ind binary_integer := 0;
3101:
3143: x_return_status := fnd_api.g_ret_sts_error;
3144: END filter_assembly_instances;
3145:
3146: PROCEDURE get_genealogy_parent(
3147: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3148: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
3149: x_return_status OUT NOCOPY varchar2)
3150: IS
3151: l_parent_item_id number;
3209: x_return_status := fnd_api.g_ret_sts_error;
3210: END get_genealogy_parent;
3211:
3212: PROCEDURE get_unprocessed_instances(
3213: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3214: x_return_status OUT NOCOPY varchar2)
3215: IS
3216: l_upc_instances csi_datastructures_pub.instance_tbl;
3217: l_upc_ind binary_integer := 0;
3212: PROCEDURE get_unprocessed_instances(
3213: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3214: x_return_status OUT NOCOPY varchar2)
3215: IS
3216: l_upc_instances csi_datastructures_pub.instance_tbl;
3217: l_upc_ind binary_integer := 0;
3218:
3219: BEGIN
3220: x_return_status := fnd_api.g_ret_sts_success;
3242: END get_unprocessed_instances;
3243:
3244: PROCEDURE build_discrete_rltn_at_wipci(
3245: p_txn_ref IN txn_ref,
3246: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3247: x_return_status OUT NOCOPY varchar2)
3248: IS
3249:
3250: l_auto_allocate varchar2(1);
3248: IS
3249:
3250: l_auto_allocate varchar2(1);
3251:
3252: l_issued_instances csi_datastructures_pub.instance_tbl;
3253: l_assembly_instances csi_datastructures_pub.instance_tbl;
3254: l_splitted_instances csi_datastructures_pub.instance_tbl;
3255: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3256: l_assy_comp_map_tbl assy_comp_map_tbl;
3249:
3250: l_auto_allocate varchar2(1);
3251:
3252: l_issued_instances csi_datastructures_pub.instance_tbl;
3253: l_assembly_instances csi_datastructures_pub.instance_tbl;
3254: l_splitted_instances csi_datastructures_pub.instance_tbl;
3255: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3256: l_assy_comp_map_tbl assy_comp_map_tbl;
3257:
3250: l_auto_allocate varchar2(1);
3251:
3252: l_issued_instances csi_datastructures_pub.instance_tbl;
3253: l_assembly_instances csi_datastructures_pub.instance_tbl;
3254: l_splitted_instances csi_datastructures_pub.instance_tbl;
3255: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3256: l_assy_comp_map_tbl assy_comp_map_tbl;
3257:
3258: l_f_assy_count number;
3251:
3252: l_issued_instances csi_datastructures_pub.instance_tbl;
3253: l_assembly_instances csi_datastructures_pub.instance_tbl;
3254: l_splitted_instances csi_datastructures_pub.instance_tbl;
3255: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3256: l_assy_comp_map_tbl assy_comp_map_tbl;
3257:
3258: l_f_assy_count number;
3259: l_qty_per_assy number;
3270: x_return_status := fnd_api.g_ret_sts_success;
3271:
3272: api_log('build_discrete_rltn_at_wipci');
3273:
3274: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
3275:
3276: get_issued_instances(
3277: p_wip_entity_id => p_txn_ref.wip_entity_id,
3278: p_organization_id => p_txn_ref.organization_id,
3554: p_mtl_txn_id IN number,
3555: p_wip_entity_id IN number,
3556: p_organization_id IN number,
3557: p_qty_completed IN number,
3558: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3559: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3560: x_return_status OUT NOCOPY varchar2)
3561: IS
3562:
3555: p_wip_entity_id IN number,
3556: p_organization_id IN number,
3557: p_qty_completed IN number,
3558: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3559: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3560: x_return_status OUT NOCOPY varchar2)
3561: IS
3562:
3563: l_assembly_instances csi_datastructures_pub.instance_tbl;
3559: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3560: x_return_status OUT NOCOPY varchar2)
3561: IS
3562:
3563: l_assembly_instances csi_datastructures_pub.instance_tbl;
3564: l_issued_instances csi_datastructures_pub.instance_tbl;
3565: l_splitted_instances csi_datastructures_pub.instance_tbl;
3566: l_assy_comp_map_tbl assy_comp_map_tbl;
3567:
3560: x_return_status OUT NOCOPY varchar2)
3561: IS
3562:
3563: l_assembly_instances csi_datastructures_pub.instance_tbl;
3564: l_issued_instances csi_datastructures_pub.instance_tbl;
3565: l_splitted_instances csi_datastructures_pub.instance_tbl;
3566: l_assy_comp_map_tbl assy_comp_map_tbl;
3567:
3568: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3561: IS
3562:
3563: l_assembly_instances csi_datastructures_pub.instance_tbl;
3564: l_issued_instances csi_datastructures_pub.instance_tbl;
3565: l_splitted_instances csi_datastructures_pub.instance_tbl;
3566: l_assy_comp_map_tbl assy_comp_map_tbl;
3567:
3568: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3569: l_comp_serial_code number;
3697:
3698: PROCEDURE build_wo_less_rltn_at_wipci(
3699: p_txn_ref IN txn_ref,
3700: p_qty_completed IN number,
3701: p_issued_instances IN csi_datastructures_pub.instance_tbl,
3702: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3703: x_return_status OUT NOCOPY varchar2)
3704: IS
3705:
3698: PROCEDURE build_wo_less_rltn_at_wipci(
3699: p_txn_ref IN txn_ref,
3700: p_qty_completed IN number,
3701: p_issued_instances IN csi_datastructures_pub.instance_tbl,
3702: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3703: x_return_status OUT NOCOPY varchar2)
3704: IS
3705:
3706: l_assembly_instances csi_datastructures_pub.instance_tbl;
3702: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3703: x_return_status OUT NOCOPY varchar2)
3704: IS
3705:
3706: l_assembly_instances csi_datastructures_pub.instance_tbl;
3707: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3708: l_issued_instances csi_datastructures_pub.instance_tbl;
3709: l_splitted_instances csi_datastructures_pub.instance_tbl;
3710: l_assy_comp_map_tbl assy_comp_map_tbl;
3703: x_return_status OUT NOCOPY varchar2)
3704: IS
3705:
3706: l_assembly_instances csi_datastructures_pub.instance_tbl;
3707: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3708: l_issued_instances csi_datastructures_pub.instance_tbl;
3709: l_splitted_instances csi_datastructures_pub.instance_tbl;
3710: l_assy_comp_map_tbl assy_comp_map_tbl;
3711:
3704: IS
3705:
3706: l_assembly_instances csi_datastructures_pub.instance_tbl;
3707: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3708: l_issued_instances csi_datastructures_pub.instance_tbl;
3709: l_splitted_instances csi_datastructures_pub.instance_tbl;
3710: l_assy_comp_map_tbl assy_comp_map_tbl;
3711:
3712: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3705:
3706: l_assembly_instances csi_datastructures_pub.instance_tbl;
3707: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3708: l_issued_instances csi_datastructures_pub.instance_tbl;
3709: l_splitted_instances csi_datastructures_pub.instance_tbl;
3710: l_assy_comp_map_tbl assy_comp_map_tbl;
3711:
3712: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3713: l_comp_serial_code number;
3890: api_log('check_prior_wip_txns_in_csi');
3891:
3892: x_return_status := fnd_api.g_ret_sts_success;
3893:
3894: l_migration_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3895:
3896: debug(' migration_date :'||l_migration_date);
3897:
3898: FOR mtl_txn_rec IN mtl_txn_cur(l_migration_date)
4020:
4021: /* process relationships at the time of WIP assembly completion */
4022: PROCEDURE process_relation_at_wipac(
4023: p_txn_ref IN txn_ref,
4024: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
4025: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4026: x_return_status OUT NOCOPY varchar2)
4027: IS
4028:
4021: /* process relationships at the time of WIP assembly completion */
4022: PROCEDURE process_relation_at_wipac(
4023: p_txn_ref IN txn_ref,
4024: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
4025: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4026: x_return_status OUT NOCOPY varchar2)
4027: IS
4028:
4029: l_context CONSTANT char(10) := 'COMPLETION';
4047: x_return_status := l_return_status;
4048:
4049: api_log('process_relation_at_wipac');
4050:
4051: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
4052:
4053: IF p_txn_ref.srl_control_code in (1, 6) THEN
4054: debug('no relationship processing for non serial assemblies.');
4055: RAISE process_no_relation;
4133: END process_relation_at_wipac;
4134:
4135: PROCEDURE process_relation_at_wipci(
4136: p_txn_ref IN txn_ref,
4137: p_component_instances IN csi_datastructures_pub.instance_tbl,
4138: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4139: x_return_status OUT NOCOPY varchar2)
4140: IS
4141:
4134:
4135: PROCEDURE process_relation_at_wipci(
4136: p_txn_ref IN txn_ref,
4137: p_component_instances IN csi_datastructures_pub.instance_tbl,
4138: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4139: x_return_status OUT NOCOPY varchar2)
4140: IS
4141:
4142: l_context CONSTANT char(5) := 'ISSUE';
4269: x_return_status := fnd_api.g_ret_sts_success;
4270:
4271: api_log('bld_inst_tables_for_issue');
4272:
4273: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4274: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
4275:
4276: -- build destination location attribs
4277: x_dest_loc_rec.location_type_code := 'WIP';
4270:
4271: api_log('bld_inst_tables_for_issue');
4272:
4273: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4274: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
4275:
4276: -- build destination location attribs
4277: x_dest_loc_rec.location_type_code := 'WIP';
4278: x_dest_loc_rec.location_id := nvl(p_mmt_rec.subinv_location_id,p_mmt_rec.hr_location_id); --5277935
4338:
4339: PROCEDURE Delink_ReplaceRebuilds(
4340: p_wip_entity_id IN number,
4341: p_organization_id IN number,
4342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4343: x_replace_rebuilds OUT nocopy eam_utility_grp.replace_rebuild_tbl_type,
4344: x_return_status OUT nocopy varchar2)
4345: IS
4346: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4406: END Delink_ReplaceRebuilds;
4407:
4408: PROCEDURE wip_issue(
4409: p_mmt_rec IN mtl_material_transactions%rowtype,
4410: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4412: x_return_status OUT NOCOPY varchar2)
4413: IS
4414:
4407:
4408: PROCEDURE wip_issue(
4409: p_mmt_rec IN mtl_material_transactions%rowtype,
4410: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4412: x_return_status OUT NOCOPY varchar2)
4413: IS
4414:
4415: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_component_issue';
4426: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
4427: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
4428: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
4429:
4430: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4431:
4432: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
4433: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
4434: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
4439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4440: l_msg_count number;
4441: l_msg_data varchar2(2000);
4442:
4443: l_issued_instances csi_datastructures_pub.instance_tbl;
4444: l_i_ind binary_integer := 0;
4445:
4446: l_error_rec csi_datastructures_pub.transaction_error_rec;
4447:
4442:
4443: l_issued_instances csi_datastructures_pub.instance_tbl;
4444: l_i_ind binary_integer := 0;
4445:
4446: l_error_rec csi_datastructures_pub.transaction_error_rec;
4447:
4448: BEGIN
4449:
4450: x_return_status := fnd_api.g_ret_sts_success;
4565:
4566: PROCEDURE wip_comp_issue(
4567: p_transaction_id IN number,
4568: p_message_id IN number,
4569: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4570: x_return_status OUT nocopy varchar2)
4571: IS
4572:
4573: l_mmt_rec mtl_material_transactions%rowtype;
4570: x_return_status OUT nocopy varchar2)
4571: IS
4572:
4573: l_mmt_rec mtl_material_transactions%rowtype;
4574: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4575: l_error_rec csi_datastructures_pub.transaction_error_rec;
4576: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4577:
4578: BEGIN
4571: IS
4572:
4573: l_mmt_rec mtl_material_transactions%rowtype;
4574: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4575: l_error_rec csi_datastructures_pub.transaction_error_rec;
4576: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4577:
4578: BEGIN
4579: x_return_status := fnd_api.g_ret_sts_success;
4594:
4595: fnd_msg_pub.initialize;
4596:
4597: --
4598: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4599: csi_gen_utility_pvt.populate_install_param_rec;
4600: END IF;
4601:
4602: l_error_rec := px_trx_error_rec;
4655:
4656: PROCEDURE wip_assy_return(
4657: p_transaction_id IN number,
4658: p_message_id IN number,
4659: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4660: x_return_status OUT nocopy varchar2)
4661: IS
4662:
4663: l_mmt_rec mtl_material_transactions%rowtype;
4660: x_return_status OUT nocopy varchar2)
4661: IS
4662:
4663: l_mmt_rec mtl_material_transactions%rowtype;
4664: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4665: l_error_rec csi_datastructures_pub.transaction_error_rec;
4666: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4667:
4668: BEGIN
4661: IS
4662:
4663: l_mmt_rec mtl_material_transactions%rowtype;
4664: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4665: l_error_rec csi_datastructures_pub.transaction_error_rec;
4666: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4667:
4668: BEGIN
4669: x_return_status := fnd_api.g_ret_sts_success;
4684:
4685: fnd_msg_pub.initialize;
4686:
4687: --
4688: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4689: csi_gen_utility_pvt.populate_install_param_rec;
4690: END IF;
4691:
4692: l_error_rec := px_trx_error_rec;
4748:
4749: PROCEDURE wip_byproduct_return(
4750: p_transaction_id IN number,
4751: p_message_id IN number,
4752: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4753: x_return_status OUT nocopy varchar2)
4754: IS
4755:
4756: l_mmt_rec mtl_material_transactions%rowtype;
4753: x_return_status OUT nocopy varchar2)
4754: IS
4755:
4756: l_mmt_rec mtl_material_transactions%rowtype;
4757: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4758: l_error_rec csi_datastructures_pub.transaction_error_rec;
4759: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4760:
4761: BEGIN
4754: IS
4755:
4756: l_mmt_rec mtl_material_transactions%rowtype;
4757: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4758: l_error_rec csi_datastructures_pub.transaction_error_rec;
4759: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4760:
4761: BEGIN
4762: x_return_status := fnd_api.g_ret_sts_success;
4777:
4778: fnd_msg_pub.initialize;
4779:
4780: --
4781: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4782: csi_gen_utility_pvt.populate_install_param_rec;
4783: END IF;
4784:
4785: l_error_rec := px_trx_error_rec;
4839:
4840: PROCEDURE wip_neg_comp_return(
4841: p_transaction_id IN number,
4842: p_message_id IN number,
4843: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4844: x_return_status OUT nocopy varchar2)
4845: IS
4846:
4847: l_mmt_rec mtl_material_transactions%rowtype;
4844: x_return_status OUT nocopy varchar2)
4845: IS
4846:
4847: l_mmt_rec mtl_material_transactions%rowtype;
4848: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4849: l_error_rec csi_datastructures_pub.transaction_error_rec;
4850: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4851:
4852: BEGIN
4845: IS
4846:
4847: l_mmt_rec mtl_material_transactions%rowtype;
4848: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4849: l_error_rec csi_datastructures_pub.transaction_error_rec;
4850: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4851:
4852: BEGIN
4853: x_return_status := fnd_api.g_ret_sts_success;
4868:
4869: fnd_msg_pub.initialize;
4870:
4871: --
4872: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4873: csi_gen_utility_pvt.populate_install_param_rec;
4874: END IF;
4875:
4876: l_error_rec := px_trx_error_rec;
4930: PROCEDURE get_issued_serial_instance(
4931: px_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
4932: x_return_status OUT NOCOPY varchar2)
4933: IS
4934: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4935: l_party_query_rec csi_datastructures_pub.party_query_rec;
4936: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4937:
4938: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4931: px_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
4932: x_return_status OUT NOCOPY varchar2)
4933: IS
4934: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4935: l_party_query_rec csi_datastructures_pub.party_query_rec;
4936: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4937:
4938: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4939: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4932: x_return_status OUT NOCOPY varchar2)
4933: IS
4934: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4935: l_party_query_rec csi_datastructures_pub.party_query_rec;
4936: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4937:
4938: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4939: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4940: l_msg_count number;
4934: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4935: l_party_query_rec csi_datastructures_pub.party_query_rec;
4936: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4937:
4938: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4939: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4940: l_msg_count number;
4941: l_msg_data varchar2(2000);
4942:
4995: already tied up in relations.
4996: */
4997:
4998: PROCEDURE get_instances(
4999: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
5000: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5001: x_return_status OUT NOCOPY varchar2)
5002: IS
5003:
4996: */
4997:
4998: PROCEDURE get_instances(
4999: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
5000: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5001: x_return_status OUT NOCOPY varchar2)
5002: IS
5003:
5004: l_party_query_rec csi_datastructures_pub.party_query_rec;
5000: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5001: x_return_status OUT NOCOPY varchar2)
5002: IS
5003:
5004: l_party_query_rec csi_datastructures_pub.party_query_rec;
5005: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5006:
5007: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5008: l_instance_tbl csi_datastructures_pub.instance_tbl;
5001: x_return_status OUT NOCOPY varchar2)
5002: IS
5003:
5004: l_party_query_rec csi_datastructures_pub.party_query_rec;
5005: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5006:
5007: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5008: l_instance_tbl csi_datastructures_pub.instance_tbl;
5009:
5003:
5004: l_party_query_rec csi_datastructures_pub.party_query_rec;
5005: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5006:
5007: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5008: l_instance_tbl csi_datastructures_pub.instance_tbl;
5009:
5010:
5011: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5004: l_party_query_rec csi_datastructures_pub.party_query_rec;
5005: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5006:
5007: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5008: l_instance_tbl csi_datastructures_pub.instance_tbl;
5009:
5010:
5011: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5012: l_msg_count number;
5063: p_wip_entity_id IN number,
5064: p_component_item_id IN number,
5065: p_organization_id IN number,
5066: p_lot_number IN varchar2,
5067: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5068: x_return_status OUT NOCOPY varchar2)
5069: IS
5070:
5071: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5067: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5068: x_return_status OUT NOCOPY varchar2)
5069: IS
5070:
5071: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5072: l_inst_tbl csi_datastructures_pub.instance_tbl;
5073: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5074:
5075: BEGIN
5068: x_return_status OUT NOCOPY varchar2)
5069: IS
5070:
5071: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5072: l_inst_tbl csi_datastructures_pub.instance_tbl;
5073: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5074:
5075: BEGIN
5076:
5106: p_wip_entity_id IN number,
5107: p_component_item_id IN number,
5108: p_organization_id IN number,
5109: p_lot_number IN varchar2,
5110: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5111: x_return_status OUT NOCOPY varchar2)
5112: IS
5113:
5114: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5110: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5111: x_return_status OUT NOCOPY varchar2)
5112: IS
5113:
5114: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5115: l_inst_tbl csi_datastructures_pub.instance_tbl;
5116: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5117:
5118: BEGIN
5111: x_return_status OUT NOCOPY varchar2)
5112: IS
5113:
5114: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5115: l_inst_tbl csi_datastructures_pub.instance_tbl;
5116: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5117:
5118: BEGIN
5119:
5164: p_wip_entity_id IN number,
5165: p_component_item_id IN number,
5166: p_organization_id IN number,
5167: p_lot_number IN varchar2,
5168: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5169: x_return_status OUT NOCOPY varchar2)
5170: IS
5171:
5172: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5168: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5169: x_return_status OUT NOCOPY varchar2)
5170: IS
5171:
5172: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5173: l_inst_tbl csi_datastructures_pub.instance_tbl;
5174: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5175:
5176: BEGIN
5169: x_return_status OUT NOCOPY varchar2)
5170: IS
5171:
5172: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5173: l_inst_tbl csi_datastructures_pub.instance_tbl;
5174: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5175:
5176: BEGIN
5177:
5202:
5203: PROCEDURE deallocate_using_qty_per_assy(
5204: p_qty_returned IN number,
5205: p_qty_per_assy IN number,
5206: p_instances_tbl IN csi_datastructures_pub.instance_tbl,
5207: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5208: x_qty_remaining IN OUT NOCOPY number,
5209: x_return_status OUT NOCOPY varchar2)
5210: IS
5203: PROCEDURE deallocate_using_qty_per_assy(
5204: p_qty_returned IN number,
5205: p_qty_per_assy IN number,
5206: p_instances_tbl IN csi_datastructures_pub.instance_tbl,
5207: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5208: x_qty_remaining IN OUT NOCOPY number,
5209: x_return_status OUT NOCOPY varchar2)
5210: IS
5211:
5219: l_qty_remaining number;
5220: l_qty_available number;
5221: l_qty_dealloc number;
5222:
5223: l_inst_tbl csi_datastructures_pub.instance_tbl;
5224: l_ind binary_integer := 0;
5225: l_f_ind binary_integer := 0;
5226: l_da_ind binary_integer := 0;
5227: l_da_tbl da_tbl;
5324: p_organization_id IN number,
5325: p_lot_number IN varchar2,
5326: p_returned_quantity IN number,
5327: p_auto_allocate IN varchar2,
5328: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5329: x_return_status OUT NOCOPY varchar2)
5330: IS
5331:
5332: l_qty_remaining number;
5334:
5335: l_qty_per_assy number;
5336: l_total_qty_issued number;
5337:
5338: l_instance_tbl csi_datastructures_pub.instance_tbl;
5339: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5340:
5341: BEGIN
5342:
5467:
5468: PROCEDURE bld_inst_tables_for_return(
5469: p_txn_ref IN txn_ref,
5470: p_mmt_rec IN mmt_rec,
5471: p_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5472: x_dest_loc_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
5473: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
5474: x_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
5475: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
5493: l_dest_loc_rec csi_process_txn_grp.dest_location_rec;
5494: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
5495: l_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
5496:
5497: l_csi_instance_tbl csi_datastructures_pub.instance_tbl;
5498:
5499: l_maintenance_source number := 0;
5500: l_relation_found varchar2(1) := 'N';
5501: l_parent_instance_id number;
5541: x_return_status := fnd_api.g_ret_sts_success;
5542:
5543: api_log('bld_inst_tables_for_return');
5544:
5545: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5546: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5547: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5548:
5549: -- build destination location attribs
5542:
5543: api_log('bld_inst_tables_for_return');
5544:
5545: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5546: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5547: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5548:
5549: -- build destination location attribs
5550: l_dest_loc_rec.location_type_code := 'INVENTORY';
5543: api_log('bld_inst_tables_for_return');
5544:
5545: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5546: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5547: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5548:
5549: -- build destination location attribs
5550: l_dest_loc_rec.location_type_code := 'INVENTORY';
5551: l_dest_loc_rec.location_id := p_mmt_rec.subinv_location_id;
5776: /* main routine for the wip component return transaction. */
5777: PROCEDURE wip_comp_receipt(
5778: p_transaction_id IN number,
5779: p_message_id IN number,
5780: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
5781: x_return_status OUT nocopy VARCHAR2)
5782: IS
5783:
5784: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_component_return';
5795: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
5796: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
5797: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
5798:
5799: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
5800:
5801: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
5802: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
5803: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
5807: l_error_message varchar2(2000);
5808: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5809: l_msg_count number;
5810: l_msg_data varchar2(2000);
5811: l_error_rec csi_datastructures_pub.transaction_error_rec;
5812:
5813: BEGIN
5814:
5815: savepoint wip_component_receipt;
5831:
5832: -- This procedure check if the installed base is active
5833: csi_utility_grp.check_ib_active;
5834:
5835: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5836: csi_gen_utility_pvt.populate_install_param_rec;
5837: END IF;
5838:
5839: l_error_rec := px_trx_error_rec;
5955:
5956: PROCEDURE bld_inst_tables_for_compl(
5957: p_txn_ref IN txn_ref,
5958: p_mmt_rec IN mmt_rec,
5959: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5960: x_dest_loc_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
5961: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
5962: x_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
5963: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
5964: x_return_status OUT NOCOPY varchar2)
5965: IS
5966: l_int_party_id number;
5967: l_comp_is_assy varchar2(1) := 'N';
5968: l_issued_instances csi_datastructures_pub.instance_tbl;
5969: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5970: l_instance_found boolean := FALSE;
5971: BEGIN
5972:
5972:
5973: x_return_status := fnd_api.g_ret_sts_success;
5974: api_log('bld_inst_tables_for_compl');
5975:
5976: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5977:
5978: -- destination location attributes
5979: x_dest_loc_rec.location_type_code := 'INVENTORY';
5980: x_dest_loc_rec.location_id := p_mmt_rec.subinv_location_id;
6118:
6119: PROCEDURE wip_byproduct_completion(
6120: p_transaction_id IN number,
6121: p_message_id IN number,
6122: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
6123: x_return_status OUT nocopy varchar2)
6124: IS
6125:
6126: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_Byproduct_completion';
6140: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6141: l_msg_count number;
6142: l_msg_data varchar2(240);
6143:
6144: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6145:
6146: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
6147: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
6148: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
6150:
6151: l_api_success varchar2(1) := fnd_api.g_ret_sts_success;
6152: l_error_message varchar2(2000);
6153:
6154: l_completed_instances csi_datastructures_pub.instance_tbl;
6155: l_c_ind binary_integer := 0;
6156:
6157: l_error_rec csi_datastructures_pub.transaction_error_rec;
6158: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6153:
6154: l_completed_instances csi_datastructures_pub.instance_tbl;
6155: l_c_ind binary_integer := 0;
6156:
6157: l_error_rec csi_datastructures_pub.transaction_error_rec;
6158: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6159:
6160: BEGIN
6161:
6176: debug(' Transaction ID : '||p_transaction_id);
6177:
6178: csi_utility_grp.check_ib_active;
6179:
6180: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6181: csi_gen_utility_pvt.populate_install_param_rec;
6182: END IF;
6183:
6184: l_error_rec := px_trx_error_rec;
6348:
6349: PROCEDURE wip_assy_completion(
6350: p_transaction_id IN number,
6351: p_message_id IN number,
6352: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
6353: x_return_status OUT nocopy varchar2)
6354: IS
6355:
6356: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_Assembly_completion';
6370: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6371: l_msg_count number;
6372: l_msg_data varchar2(240);
6373:
6374: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6375:
6376: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
6377: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
6378: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
6380:
6381: l_api_success varchar2(1) := fnd_api.g_ret_sts_success;
6382: l_error_message varchar2(2000);
6383:
6384: l_completed_instances csi_datastructures_pub.instance_tbl;
6385: l_c_ind binary_integer := 0;
6386:
6387: l_error_rec csi_datastructures_pub.transaction_error_rec;
6388: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6383:
6384: l_completed_instances csi_datastructures_pub.instance_tbl;
6385: l_c_ind binary_integer := 0;
6386:
6387: l_error_rec csi_datastructures_pub.transaction_error_rec;
6388: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6389:
6390: BEGIN
6391:
6406: debug(' Transaction ID : '||p_transaction_id);
6407:
6408: csi_utility_grp.check_ib_active;
6409:
6410: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6411: csi_gen_utility_pvt.populate_install_param_rec;
6412: END IF;
6413:
6414: l_error_rec := px_trx_error_rec;
6574:
6575: PROCEDURE build_ii_relation_rec(
6576: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6577: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6578: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6579: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6580: x_return_status OUT NOCOPY varchar2)
6581: IS
6582:
6575: PROCEDURE build_ii_relation_rec(
6576: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6577: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6578: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6579: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6580: x_return_status OUT NOCOPY varchar2)
6581: IS
6582:
6583: l_obj_instance_id number;
6586: l_sub_instance_qty number;
6587: l_sub_tld_id number := -999999;
6588: l_vld_organization_id number;
6589:
6590: l_source_instance_rec csi_datastructures_pub.instance_rec;
6591: l_new_instance_rec csi_datastructures_pub.instance_rec;
6592: l_source_instance_qty number;
6593: l_new_instance_qty number;
6594:
6587: l_sub_tld_id number := -999999;
6588: l_vld_organization_id number;
6589:
6590: l_source_instance_rec csi_datastructures_pub.instance_rec;
6591: l_new_instance_rec csi_datastructures_pub.instance_rec;
6592: l_source_instance_qty number;
6593: l_new_instance_qty number;
6594:
6595: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6591: l_new_instance_rec csi_datastructures_pub.instance_rec;
6592: l_source_instance_qty number;
6593: l_new_instance_qty number;
6594:
6595: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6596:
6597: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6598: l_msg_count number;
6599: l_msg_data varchar2(2000);
6737: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6738: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6739: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6740:
6741: l_txn_rec csi_datastructures_pub.transaction_rec;
6742: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6743: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6744: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6745: l_c_ind binary_integer := 0;
6738: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6739: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6740:
6741: l_txn_rec csi_datastructures_pub.transaction_rec;
6742: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6743: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6744: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6745: l_c_ind binary_integer := 0;
6746: l_u_ind binary_integer := 0;
6739: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6740:
6741: l_txn_rec csi_datastructures_pub.transaction_rec;
6742: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6743: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6744: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6745: l_c_ind binary_integer := 0;
6746: l_u_ind binary_integer := 0;
6747:
6740:
6741: l_txn_rec csi_datastructures_pub.transaction_rec;
6742: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6743: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6744: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6745: l_c_ind binary_integer := 0;
6746: l_u_ind binary_integer := 0;
6747:
6748: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6904:
6905: PROCEDURE eam_wip_completion(
6906: p_wip_entity_id IN number,
6907: p_organization_id IN number,
6908: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
6909: x_return_status OUT nocopy varchar2)
6910: IS
6911: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6912: SELECT transaction_id
6932: AND wip_job_id = p_wip_entity_id
6933: AND instance_id <> p_instance_id;
6934:
6935: l_instance_id number;
6936: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6937: l_iir_ind binary_integer := 0;
6938: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6939: l_msg_count number;
6940: l_msg_data varchar2(2000);
6934:
6935: l_instance_id number;
6936: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6937: l_iir_ind binary_integer := 0;
6938: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6939: l_msg_count number;
6940: l_msg_data varchar2(2000);
6941: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6942:
6972: debug(' Transaction Time : '||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
6973: debug(' Transaction Type : EAM Work Order Completion');
6974: debug(' Transaction ID : '||p_wip_entity_id);
6975:
6976: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6977: csi_gen_utility_pvt.populate_install_param_rec;
6978: END IF;
6979:
6980: l_csi_txn_rec.transaction_type_id := 92;
7004: END IF;
7005:
7006: FOR mtl_txn_rec IN mtl_txn_cur(
7007: p_wip_entity_id => p_wip_entity_id,
7008: p_migration_date => csi_datastructures_pub.g_install_param_rec.freeze_date)
7009: LOOP
7010:
7011: debug(' prior transaction_id : '||mtl_txn_rec.transaction_id);
7012:
7096: PROCEDURE eam_rebuildable_return(
7097: p_wip_entity_id IN number,
7098: p_organization_id IN number,
7099: p_instance_id IN number,
7100: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
7101: x_return_status OUT nocopy varchar2)
7102: IS
7103: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7104: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7099: p_instance_id IN number,
7100: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
7101: x_return_status OUT nocopy varchar2)
7102: IS
7103: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
7104: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7105: BEGIN
7106:
7107: x_return_status := fnd_api.g_ret_sts_success;
7115: debug(' Transaction Time : '||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
7116: debug(' Transaction Type : EAM Rebuildable Return');
7117: debug(' Transaction ID : '||p_wip_entity_id);
7118:
7119: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7120: csi_gen_utility_pvt.populate_install_param_rec;
7121: END IF;
7122:
7123: l_csi_txn_rec.transaction_type_id := 93;