[Home] [Help]
397: x_return_status := fnd_api.g_ret_sts_error;
398: END get_mmt_info;
399:
400: PROCEDURE make_non_hdr_rec(
401: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
402: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
403: x_return_status OUT NOCOPY varchar2)
404: IS
405:
398: END get_mmt_info;
399:
400: PROCEDURE make_non_hdr_rec(
401: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
402: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
403: x_return_status OUT NOCOPY varchar2)
404: IS
405:
406: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
402: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
403: x_return_status OUT NOCOPY varchar2)
404: IS
405:
406: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
407: l_instance_tbl csi_datastructures_pub.instance_tbl;
408:
409: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
410:
403: x_return_status OUT NOCOPY varchar2)
404: IS
405:
406: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
407: l_instance_tbl csi_datastructures_pub.instance_tbl;
408:
409: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
410:
411: BEGIN
435:
436: PROCEDURE increment_comp_instance(
437: p_instance_id IN number,
438: p_quantity IN number,
439: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
440: x_return_status OUT NOCOPY varchar2)
441: IS
442:
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
439: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
440: x_return_status OUT NOCOPY varchar2)
441: IS
442:
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
440: x_return_status OUT NOCOPY varchar2)
441: IS
442:
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
441: IS
442:
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
442:
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
450: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
443: l_u_instance_rec csi_datastructures_pub.instance_rec;
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
450: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
451:
444: l_u_parties_tbl csi_datastructures_pub.party_tbl;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
450: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
451:
452: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
445: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
450: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
451:
452: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
453: l_msg_count number;
446: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
447: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
448: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
449: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
450: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
451:
452: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
453: l_msg_count number;
454: l_msg_data varchar2(2000);
508:
509: PROCEDURE decrement_wip_instance(
510: p_instance_id IN number,
511: p_quantity IN number,
512: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
513: x_return_status OUT NOCOPY varchar2)
514: IS
515:
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
512: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
513: x_return_status OUT NOCOPY varchar2)
514: IS
515:
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
513: x_return_status OUT NOCOPY varchar2)
514: IS
515:
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
514: IS
515:
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
515:
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
523: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
516: l_u_instance_rec csi_datastructures_pub.instance_rec;
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
523: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
524:
517: l_u_parties_tbl csi_datastructures_pub.party_tbl;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
523: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
524:
525: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
518: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
523: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
524:
525: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
526: l_msg_count number;
519: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
520: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
521: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
522: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
523: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
524:
525: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
526: l_msg_count number;
527: l_msg_data varchar2(2000);
583: p_instance_id IN number,
584: p_quantity IN number,
585: p_organization_id IN number,
586: x_new_instance_id OUT NOCOPY number,
587: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
588: x_return_status OUT NOCOPY varchar2)
589: IS
590:
591: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
592: l_msg_data varchar2(2000);
593: l_msg_count number;
594:
595: -- get_item_instance_details variables
596: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
593: l_msg_count number;
594:
595: -- get_item_instance_details variables
596: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
594:
595: -- get_item_instance_details variables
596: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
595: -- get_item_instance_details variables
596: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
596: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
604: l_g_time_stamp date;
597: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
604: l_g_time_stamp date;
605:
598: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
604: l_g_time_stamp date;
605:
606: -- make_non_hdr variables
599: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
600: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
601: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
602: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
604: l_g_time_stamp date;
605:
606: -- make_non_hdr variables
607: l_instance_rec csi_datastructures_pub.instance_rec;
603: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
604: l_g_time_stamp date;
605:
606: -- make_non_hdr variables
607: l_instance_rec csi_datastructures_pub.instance_rec;
608:
609: -- create_item_instance varaibles
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
606: -- make_non_hdr variables
607: l_instance_rec csi_datastructures_pub.instance_rec;
608:
609: -- create_item_instance varaibles
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
607: l_instance_rec csi_datastructures_pub.instance_rec;
608:
609: -- create_item_instance varaibles
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
608:
609: -- create_item_instance varaibles
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
616: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
609: -- create_item_instance varaibles
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
616: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
617:
610: l_c_instance_rec csi_datastructures_pub.instance_rec;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
616: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
617:
618: c_pa_ind binary_integer := 0;
611: l_c_parties_tbl csi_datastructures_pub.party_tbl;
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
616: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
617:
618: c_pa_ind binary_integer := 0;
619:
612: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
613: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
614: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
615: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
616: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
617:
618: c_pa_ind binary_integer := 0;
619:
620: BEGIN
750: x_return_status := fnd_api.g_ret_sts_error;
751: END create_wip_instance_as;
752:
753: PROCEDURE apportion_always(
754: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
755: p_splitted_instances IN csi_datastructures_pub.instance_tbl,
756: p_job_quantity IN number,
757: p_comp_serial_code IN number,
758: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
751: END create_wip_instance_as;
752:
753: PROCEDURE apportion_always(
754: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
755: p_splitted_instances IN csi_datastructures_pub.instance_tbl,
756: p_job_quantity IN number,
757: p_comp_serial_code IN number,
758: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
759: x_return_status OUT NOCOPY varchar2)
758: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
759: x_return_status OUT NOCOPY varchar2)
760: IS
761:
762: l_assy_tbl csi_datastructures_pub.instance_tbl;
763: l_issues_tbl csi_datastructures_pub.instance_tbl;
764:
765: l_ac_mapping_tbl assy_comp_map_tbl;
766: l_ac_ind binary_integer;
759: x_return_status OUT NOCOPY varchar2)
760: IS
761:
762: l_assy_tbl csi_datastructures_pub.instance_tbl;
763: l_issues_tbl csi_datastructures_pub.instance_tbl;
764:
765: l_ac_mapping_tbl assy_comp_map_tbl;
766: l_ac_ind binary_integer;
767: l_remaining_quantity number;
981: p_organization_id IN number,
982: p_assembly_item_id IN number,
983: p_completion_quantity IN number,
984: p_location_code IN varchar2,
985: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
986: x_return_status OUT NOCOPY varchar2)
987: IS
988:
989: --l_inventory_item_id wip_discrete_jobs.primary_item_id%TYPE;
990: l_completion_quantity number;
991: l_relation_found varchar2(1) := 'N';
992:
993: -- get_item_instances variables
994: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
995: l_party_query_rec csi_datastructures_pub.party_query_rec;
996: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
997:
998: --
991: l_relation_found varchar2(1) := 'N';
992:
993: -- get_item_instances variables
994: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
995: l_party_query_rec csi_datastructures_pub.party_query_rec;
996: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
997:
998: --
999: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
992:
993: -- get_item_instances variables
994: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
995: l_party_query_rec csi_datastructures_pub.party_query_rec;
996: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
997:
998: --
999: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1000: l_instance_tbl csi_datastructures_pub.instance_tbl;
995: l_party_query_rec csi_datastructures_pub.party_query_rec;
996: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
997:
998: --
999: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1000: l_instance_tbl csi_datastructures_pub.instance_tbl;
1001:
1002: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1003: l_msg_data varchar2(2000);
996: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
997:
998: --
999: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1000: l_instance_tbl csi_datastructures_pub.instance_tbl;
1001:
1002: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1003: l_msg_data varchar2(2000);
1004: l_msg_count number;
1259: p_wip_entity_id IN number,
1260: p_organization_id IN number,
1261: p_inventory_item_id IN number,
1262: p_serial_number IN varchar2,
1263: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1264: x_return_status OUT NOCOPY varchar2)
1265: IS
1266:
1267: -- get_item_instances variables
1264: x_return_status OUT NOCOPY varchar2)
1265: IS
1266:
1267: -- get_item_instances variables
1268: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1269: l_party_query_rec csi_datastructures_pub.party_query_rec;
1270: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1271:
1272: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1265: IS
1266:
1267: -- get_item_instances variables
1268: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1269: l_party_query_rec csi_datastructures_pub.party_query_rec;
1270: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1271:
1272: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1273:
1266:
1267: -- get_item_instances variables
1268: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1269: l_party_query_rec csi_datastructures_pub.party_query_rec;
1270: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1271:
1272: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1273:
1274: l_instance_tbl csi_datastructures_pub.instance_tbl;
1268: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1269: l_party_query_rec csi_datastructures_pub.party_query_rec;
1270: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1271:
1272: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1273:
1274: l_instance_tbl csi_datastructures_pub.instance_tbl;
1275: --
1276: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1270: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1271:
1272: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1273:
1274: l_instance_tbl csi_datastructures_pub.instance_tbl;
1275: --
1276: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1277: l_msg_data varchar2(2000);
1278: l_msg_count number;
1338:
1339: PROCEDURE get_serial_instance(
1340: p_inventory_item_id IN number,
1341: p_serial_number IN varchar2,
1342: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
1343: x_return_status OUT NOCOPY varchar2)
1344: IS
1345:
1346: -- get_item_instances variables
1343: x_return_status OUT NOCOPY varchar2)
1344: IS
1345:
1346: -- get_item_instances variables
1347: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1348: l_party_query_rec csi_datastructures_pub.party_query_rec;
1349: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1350:
1351: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1344: IS
1345:
1346: -- get_item_instances variables
1347: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1348: l_party_query_rec csi_datastructures_pub.party_query_rec;
1349: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1350:
1351: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1352: l_instance_tbl csi_datastructures_pub.instance_tbl;
1345:
1346: -- get_item_instances variables
1347: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1348: l_party_query_rec csi_datastructures_pub.party_query_rec;
1349: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1350:
1351: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1352: l_instance_tbl csi_datastructures_pub.instance_tbl;
1353:
1347: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1348: l_party_query_rec csi_datastructures_pub.party_query_rec;
1349: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1350:
1351: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1352: l_instance_tbl csi_datastructures_pub.instance_tbl;
1353:
1354: --
1355: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1348: l_party_query_rec csi_datastructures_pub.party_query_rec;
1349: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1350:
1351: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1352: l_instance_tbl csi_datastructures_pub.instance_tbl;
1353:
1354: --
1355: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1356: l_msg_data varchar2(2000);
1356: l_msg_data varchar2(2000);
1357: l_msg_count number;
1358:
1359: l_t_ind binary_integer := 0;
1360: l_tmp_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
1361:
1362: BEGIN
1363:
1364: x_return_status := fnd_api.g_ret_sts_success;
1427: p_instance_id IN number,
1428: p_qty_ratio IN number,
1429: p_qty_completed IN number,
1430: p_organization_id IN number,
1431: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1432: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1433: x_return_status OUT NOCOPY varchar2)
1434: IS
1435:
1428: p_qty_ratio IN number,
1429: p_qty_completed IN number,
1430: p_organization_id IN number,
1431: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1432: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1433: x_return_status OUT NOCOPY varchar2)
1434: IS
1435:
1436: l_qty_remaining number;
1434: IS
1435:
1436: l_qty_remaining number;
1437:
1438: l_init_instance_rec csi_datastructures_pub.instance_rec;
1439:
1440: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1441: l_msg_data varchar2(2000);
1442: l_msg_count number;
1442: l_msg_count number;
1443:
1444: l_split_flag boolean := FALSE;
1445:
1446: l_splitted_instances csi_datastructures_pub.instance_tbl;
1447: l_s_ind binary_integer;
1448:
1449: -- get_item_instance_details variables
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1446: l_splitted_instances csi_datastructures_pub.instance_tbl;
1447: l_s_ind binary_integer;
1448:
1449: -- get_item_instance_details variables
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1447: l_s_ind binary_integer;
1448:
1449: -- get_item_instance_details variables
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1448:
1449: -- get_item_instance_details variables
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1449: -- get_item_instance_details variables
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1450: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1458: l_g_time_stamp date;
1451: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1458: l_g_time_stamp date;
1459:
1452: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1458: l_g_time_stamp date;
1459:
1460: -- make_non_hdr variables
1453: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1454: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1455: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1456: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1458: l_g_time_stamp date;
1459:
1460: -- make_non_hdr variables
1461: l_instance_rec csi_datastructures_pub.instance_rec;
1457: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1458: l_g_time_stamp date;
1459:
1460: -- make_non_hdr variables
1461: l_instance_rec csi_datastructures_pub.instance_rec;
1462:
1463: -- update_item_instance variables
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1460: -- make_non_hdr variables
1461: l_instance_rec csi_datastructures_pub.instance_rec;
1462:
1463: -- update_item_instance variables
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1461: l_instance_rec csi_datastructures_pub.instance_rec;
1462:
1463: -- update_item_instance variables
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1462:
1463: -- update_item_instance variables
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1463: -- update_item_instance variables
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1464: l_u_instance_rec csi_datastructures_pub.instance_rec;
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1465: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1473: -- create_item_instance varaibles
1466: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1467: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1468: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1469: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1470: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1471: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1472:
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1472:
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1480: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1473: -- create_item_instance varaibles
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1480: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1481: c_pa_ind binary_integer;
1474: l_c_instance_rec csi_datastructures_pub.instance_rec;
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1480: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1481: c_pa_ind binary_integer;
1482:
1475: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1480: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1481: c_pa_ind binary_integer;
1482:
1483: BEGIN
1476: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1477: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1478: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1479: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1480: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1481: c_pa_ind binary_integer;
1482:
1483: BEGIN
1484:
1712: PROCEDURE split_instances_using_ratio(
1713: p_qty_ratio IN number,
1714: p_qty_completed IN number,
1715: p_organization_id IN number,
1716: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1717: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1718: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1719: x_return_status OUT NOCOPY varchar2)
1720: IS
1713: p_qty_ratio IN number,
1714: p_qty_completed IN number,
1715: p_organization_id IN number,
1716: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1717: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1718: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1719: x_return_status OUT NOCOPY varchar2)
1720: IS
1721: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1714: p_qty_completed IN number,
1715: p_organization_id IN number,
1716: p_issued_instances IN csi_datastructures_pub.instance_tbl,
1717: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1718: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1719: x_return_status OUT NOCOPY varchar2)
1720: IS
1721: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1722: l_splitted_instances csi_datastructures_pub.instance_tbl;
1718: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1719: x_return_status OUT NOCOPY varchar2)
1720: IS
1721: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1722: l_splitted_instances csi_datastructures_pub.instance_tbl;
1723: BEGIN
1724:
1725: x_return_status := fnd_api.g_ret_sts_success;
1726:
1757: PROCEDURE split_issued_instances(
1758: p_organization_id IN number,
1759: p_job_quantity IN number,
1760: p_completion_quantity IN number,
1761: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1762: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1763: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1764: x_return_status OUT NOCOPY varchar2)
1765: IS
1758: p_organization_id IN number,
1759: p_job_quantity IN number,
1760: p_completion_quantity IN number,
1761: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1762: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1763: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1764: x_return_status OUT NOCOPY varchar2)
1765: IS
1766:
1759: p_job_quantity IN number,
1760: p_completion_quantity IN number,
1761: px_issued_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
1762: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1763: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
1764: x_return_status OUT NOCOPY varchar2)
1765: IS
1766:
1767: l_allocated_quantity number;
1766:
1767: l_allocated_quantity number;
1768: l_remaining_quantity number;
1769:
1770: l_new_instance_rec csi_datastructures_pub.instance_rec;
1771:
1772: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1773: l_msg_data varchar2(2000);
1774: l_msg_count number;
1774: l_msg_count number;
1775:
1776: l_split_counter number;
1777:
1778: l_splitted_instances csi_datastructures_pub.instance_tbl;
1779: l_s_ind binary_integer;
1780:
1781: -- get_item_instance_details variables
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1778: l_splitted_instances csi_datastructures_pub.instance_tbl;
1779: l_s_ind binary_integer;
1780:
1781: -- get_item_instance_details variables
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1779: l_s_ind binary_integer;
1780:
1781: -- get_item_instance_details variables
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1780:
1781: -- get_item_instance_details variables
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1781: -- get_item_instance_details variables
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1782: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1790: l_g_time_stamp date;
1783: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1790: l_g_time_stamp date;
1791:
1784: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1790: l_g_time_stamp date;
1791:
1792: -- update_item_instance variables
1785: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
1786: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
1787: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1788: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1790: l_g_time_stamp date;
1791:
1792: -- update_item_instance variables
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1789: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
1790: l_g_time_stamp date;
1791:
1792: -- update_item_instance variables
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1790: l_g_time_stamp date;
1791:
1792: -- update_item_instance variables
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1791:
1792: -- update_item_instance variables
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1792: -- update_item_instance variables
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1793: l_u_instance_rec csi_datastructures_pub.instance_rec;
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1794: l_u_parties_tbl csi_datastructures_pub.party_tbl;
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1802: -- create_item_instance varaibles
1795: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1796: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1797: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1798: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1799: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1800: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
1801:
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1801:
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1802: -- create_item_instance varaibles
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1810: c_pa_ind binary_integer;
1803: l_c_instance_rec csi_datastructures_pub.instance_rec;
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1810: c_pa_ind binary_integer;
1811:
1804: l_c_parties_tbl csi_datastructures_pub.party_tbl;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1810: c_pa_ind binary_integer;
1811:
1812: l_instance_rec csi_datastructures_pub.instance_rec;
1805: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1806: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1807: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1810: c_pa_ind binary_integer;
1811:
1812: l_instance_rec csi_datastructures_pub.instance_rec;
1813: --
1808: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1809: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1810: c_pa_ind binary_integer;
1811:
1812: l_instance_rec csi_datastructures_pub.instance_rec;
1813: --
1814:
1815: BEGIN
1816:
2037: END split_issued_instances;
2038:
2039: PROCEDURE create_assy_comp_relation(
2040: p_assy_comp_map_tbl IN assy_comp_map_tbl,
2041: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2042: x_return_status OUT NOCOPY varchar2)
2043: IS
2044:
2045: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
2041: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2042: x_return_status OUT NOCOPY varchar2)
2043: IS
2044:
2045: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
2046:
2047: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2048: l_msg_count number;
2049: l_msg_data varchar2(2000);
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: END create_assy_comp_relation;
2121:
2122: PROCEDURE get_genealogy_children(
2123: px_assembly_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
2124: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2125: x_return_status OUT NOCOPY varchar2)
2126: IS
2127:
2138: AND nvl(mog.end_date_active, sysdate+1);
2139:
2140: l_ac_map_tbl assy_comp_map_tbl;
2141: l_ac_ind binary_integer := 0;
2142: l_assy_tbl csi_datastructures_pub.instance_tbl;
2143: l_parent_object_id number;
2144: l_children_count number;
2145:
2146: l_child_instance_id number;
2270: p_qty_per_assy IN number,
2271: p_total_qty_issued IN number,
2272: p_job_qty IN number,
2273: p_component_item_id IN number,
2274: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2275: p_component_instances IN csi_datastructures_pub.instance_tbl,
2276: px_assy_comp_map_tbl IN OUT NOCOPY assy_comp_map_tbl,
2277: x_return_status IN OUT NOCOPY varchar2)
2278: IS
2271: p_total_qty_issued IN number,
2272: p_job_qty IN number,
2273: p_component_item_id IN number,
2274: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2275: p_component_instances IN csi_datastructures_pub.instance_tbl,
2276: px_assy_comp_map_tbl IN OUT NOCOPY assy_comp_map_tbl,
2277: x_return_status IN OUT NOCOPY varchar2)
2278: IS
2279:
2278: IS
2279:
2280: l_qty_remaining number;
2281:
2282: l_assy_tbl csi_datastructures_pub.instance_tbl;
2283: l_comp_tbl csi_datastructures_pub.instance_tbl;
2284: l_ac_map_tbl assy_comp_map_tbl;
2285:
2286: l_already_alloc_count number := 0;
2279:
2280: l_qty_remaining number;
2281:
2282: l_assy_tbl csi_datastructures_pub.instance_tbl;
2283: l_comp_tbl csi_datastructures_pub.instance_tbl;
2284: l_ac_map_tbl assy_comp_map_tbl;
2285:
2286: l_already_alloc_count number := 0;
2287: l_c_ind binary_integer := 0;
2476: p_qty_issued IN number,
2477: p_total_qty_issued IN number,
2478: p_job_qty IN number,
2479: p_organization_id IN number,
2480: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2481: p_component_instance IN csi_datastructures_pub.instance_rec,
2482: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2483: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2484: x_return_status IN OUT NOCOPY varchar2)
2477: p_total_qty_issued IN number,
2478: p_job_qty IN number,
2479: p_organization_id IN number,
2480: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2481: p_component_instance IN csi_datastructures_pub.instance_rec,
2482: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2483: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2484: x_return_status IN OUT NOCOPY varchar2)
2485: IS
2478: p_job_qty IN number,
2479: p_organization_id IN number,
2480: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2481: p_component_instance IN csi_datastructures_pub.instance_rec,
2482: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2483: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2484: x_return_status IN OUT NOCOPY varchar2)
2485: IS
2486:
2503: l_tot_qty_remaining number := 0;
2504:
2505: l_comp_found boolean := FALSE;
2506:
2507: l_assy_tbl csi_datastructures_pub.instance_tbl;
2508: l_comp_rec csi_datastructures_pub.instance_rec;
2509:
2510: l_ac_ind binary_integer := 0;
2511: l_ac_map_tbl assy_comp_map_tbl;
2504:
2505: l_comp_found boolean := FALSE;
2506:
2507: l_assy_tbl csi_datastructures_pub.instance_tbl;
2508: l_comp_rec csi_datastructures_pub.instance_rec;
2509:
2510: l_ac_ind binary_integer := 0;
2511: l_ac_map_tbl assy_comp_map_tbl;
2512:
2511: l_ac_map_tbl assy_comp_map_tbl;
2512:
2513: l_new_instance_id number;
2514:
2515: l_instance_rec csi_datastructures_pub.instance_rec;
2516:
2517: -- update_item_instance variables
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2514:
2515: l_instance_rec csi_datastructures_pub.instance_rec;
2516:
2517: -- update_item_instance variables
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2515: l_instance_rec csi_datastructures_pub.instance_rec;
2516:
2517: -- update_item_instance variables
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2516:
2517: -- update_item_instance variables
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2517: -- update_item_instance variables
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2525: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2518: l_u_instance_rec csi_datastructures_pub.instance_rec;
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2525: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2526:
2519: l_u_parties_tbl csi_datastructures_pub.party_tbl;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2525: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2526:
2527: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2520: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2525: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2526:
2527: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2528: l_msg_data varchar2(2000);
2521: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
2522: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
2523: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
2524: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
2525: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
2526:
2527: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2528: l_msg_data varchar2(2000);
2529: l_msg_count number;
2703: p_qty_issued IN number,
2704: p_total_qty_issued IN number,
2705: p_job_qty IN number,
2706: p_organization_id IN number,
2707: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2708: p_component_instances IN csi_datastructures_pub.instance_tbl,
2709: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2710: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2711: x_return_status IN OUT NOCOPY varchar2)
2704: p_total_qty_issued IN number,
2705: p_job_qty IN number,
2706: p_organization_id IN number,
2707: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2708: p_component_instances IN csi_datastructures_pub.instance_tbl,
2709: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2710: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2711: x_return_status IN OUT NOCOPY varchar2)
2712: IS
2705: p_job_qty IN number,
2706: p_organization_id IN number,
2707: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2708: p_component_instances IN csi_datastructures_pub.instance_tbl,
2709: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2710: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
2711: x_return_status IN OUT NOCOPY varchar2)
2712: IS
2713:
2763: END apportion_non_serialized;
2764:
2765: PROCEDURE build_discrete_rltn_at_wipac(
2766: p_txn_ref IN txn_ref,
2767: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2768: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2769: x_return_status OUT NOCOPY varchar2)
2770: IS
2771: l_auto_allocate varchar2(1);
2764:
2765: PROCEDURE build_discrete_rltn_at_wipac(
2766: p_txn_ref IN txn_ref,
2767: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2768: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2769: x_return_status OUT NOCOPY varchar2)
2770: IS
2771: l_auto_allocate varchar2(1);
2772:
2770: IS
2771: l_auto_allocate varchar2(1);
2772:
2773: l_requirements_tbl requirements_tbl;
2774: l_issued_instances csi_datastructures_pub.instance_tbl;
2775: l_assembly_instances csi_datastructures_pub.instance_tbl;
2776:
2777: l_splitted_instances csi_datastructures_pub.instance_tbl;
2778: l_assy_comp_map_tbl assy_comp_map_tbl;
2771: l_auto_allocate varchar2(1);
2772:
2773: l_requirements_tbl requirements_tbl;
2774: l_issued_instances csi_datastructures_pub.instance_tbl;
2775: l_assembly_instances csi_datastructures_pub.instance_tbl;
2776:
2777: l_splitted_instances csi_datastructures_pub.instance_tbl;
2778: l_assy_comp_map_tbl assy_comp_map_tbl;
2779: l_comp_serial_code number;
2773: l_requirements_tbl requirements_tbl;
2774: l_issued_instances csi_datastructures_pub.instance_tbl;
2775: l_assembly_instances csi_datastructures_pub.instance_tbl;
2776:
2777: l_splitted_instances csi_datastructures_pub.instance_tbl;
2778: l_assy_comp_map_tbl assy_comp_map_tbl;
2779: l_comp_serial_code number;
2780:
2781: end_process exception;
2789: x_return_status := fnd_api.g_ret_sts_success;
2790:
2791: api_log('build_discrete_rltn_at_wipac');
2792:
2793: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
2794:
2795: l_assembly_instances := p_assembly_instances;
2796:
2797: debug('Assembly Instances Count: '||l_assembly_instances.COUNT);
2969: END build_discrete_rltn_at_wipac;
2970:
2971: PROCEDURE filter_assembly_instances(
2972: p_wip_entity_id IN number,
2973: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2974: p_component_item_id IN number,
2975: p_quantity_ratio IN number,
2976: x_filtered_assy_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
2977: x_return_status OUT NOCOPY varchar2)
2972: p_wip_entity_id IN number,
2973: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
2974: p_component_item_id IN number,
2975: p_quantity_ratio IN number,
2976: x_filtered_assy_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
2977: x_return_status OUT NOCOPY varchar2)
2978: IS
2979:
2980: CURSOR rltns_cur(p_parent_instance_id IN number) IS
2992: AND sysdate between nvl(cii.active_start_date, sysdate-1)
2993: and nvl(cii.active_end_date, sysdate+1);
2994: */
2995:
2996: l_filtered_assy_instances csi_datastructures_pub.instance_tbl;
2997: l_relation_found boolean := FALSE;
2998: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2999: l_f_ind binary_integer := 0;
3000:
3042: x_return_status := fnd_api.g_ret_sts_error;
3043: END filter_assembly_instances;
3044:
3045: PROCEDURE get_genealogy_parent(
3046: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3047: x_assy_comp_map_tbl OUT NOCOPY assy_comp_map_tbl,
3048: x_return_status OUT NOCOPY varchar2)
3049: IS
3050: l_parent_item_id number;
3108: x_return_status := fnd_api.g_ret_sts_error;
3109: END get_genealogy_parent;
3110:
3111: PROCEDURE get_unprocessed_instances(
3112: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3113: x_return_status OUT NOCOPY varchar2)
3114: IS
3115: l_upc_instances csi_datastructures_pub.instance_tbl;
3116: l_upc_ind binary_integer := 0;
3111: PROCEDURE get_unprocessed_instances(
3112: px_component_instances IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
3113: x_return_status OUT NOCOPY varchar2)
3114: IS
3115: l_upc_instances csi_datastructures_pub.instance_tbl;
3116: l_upc_ind binary_integer := 0;
3117:
3118: BEGIN
3119: x_return_status := fnd_api.g_ret_sts_success;
3141: END get_unprocessed_instances;
3142:
3143: PROCEDURE build_discrete_rltn_at_wipci(
3144: p_txn_ref IN txn_ref,
3145: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3146: x_return_status OUT NOCOPY varchar2)
3147: IS
3148:
3149: l_auto_allocate varchar2(1);
3147: IS
3148:
3149: l_auto_allocate varchar2(1);
3150:
3151: l_issued_instances csi_datastructures_pub.instance_tbl;
3152: l_assembly_instances csi_datastructures_pub.instance_tbl;
3153: l_splitted_instances csi_datastructures_pub.instance_tbl;
3154: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3155: l_assy_comp_map_tbl assy_comp_map_tbl;
3148:
3149: l_auto_allocate varchar2(1);
3150:
3151: l_issued_instances csi_datastructures_pub.instance_tbl;
3152: l_assembly_instances csi_datastructures_pub.instance_tbl;
3153: l_splitted_instances csi_datastructures_pub.instance_tbl;
3154: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3155: l_assy_comp_map_tbl assy_comp_map_tbl;
3156:
3149: l_auto_allocate varchar2(1);
3150:
3151: l_issued_instances csi_datastructures_pub.instance_tbl;
3152: l_assembly_instances csi_datastructures_pub.instance_tbl;
3153: l_splitted_instances csi_datastructures_pub.instance_tbl;
3154: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3155: l_assy_comp_map_tbl assy_comp_map_tbl;
3156:
3157: l_f_assy_count number;
3150:
3151: l_issued_instances csi_datastructures_pub.instance_tbl;
3152: l_assembly_instances csi_datastructures_pub.instance_tbl;
3153: l_splitted_instances csi_datastructures_pub.instance_tbl;
3154: l_f_assy_instances csi_datastructures_pub.instance_tbl;
3155: l_assy_comp_map_tbl assy_comp_map_tbl;
3156:
3157: l_f_assy_count number;
3158: l_qty_per_assy number;
3166: x_return_status := fnd_api.g_ret_sts_success;
3167:
3168: api_log('build_discrete_rltn_at_wipci');
3169:
3170: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
3171:
3172: get_issued_instances(
3173: p_wip_entity_id => p_txn_ref.wip_entity_id,
3174: p_organization_id => p_txn_ref.organization_id,
3425: p_mtl_txn_id IN number,
3426: p_wip_entity_id IN number,
3427: p_organization_id IN number,
3428: p_qty_completed IN number,
3429: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3430: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3431: x_return_status OUT NOCOPY varchar2)
3432: IS
3433:
3426: p_wip_entity_id IN number,
3427: p_organization_id IN number,
3428: p_qty_completed IN number,
3429: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3430: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3431: x_return_status OUT NOCOPY varchar2)
3432: IS
3433:
3434: l_assembly_instances csi_datastructures_pub.instance_tbl;
3430: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3431: x_return_status OUT NOCOPY varchar2)
3432: IS
3433:
3434: l_assembly_instances csi_datastructures_pub.instance_tbl;
3435: l_issued_instances csi_datastructures_pub.instance_tbl;
3436: l_splitted_instances csi_datastructures_pub.instance_tbl;
3437: l_assy_comp_map_tbl assy_comp_map_tbl;
3438:
3431: x_return_status OUT NOCOPY varchar2)
3432: IS
3433:
3434: l_assembly_instances csi_datastructures_pub.instance_tbl;
3435: l_issued_instances csi_datastructures_pub.instance_tbl;
3436: l_splitted_instances csi_datastructures_pub.instance_tbl;
3437: l_assy_comp_map_tbl assy_comp_map_tbl;
3438:
3439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3432: IS
3433:
3434: l_assembly_instances csi_datastructures_pub.instance_tbl;
3435: l_issued_instances csi_datastructures_pub.instance_tbl;
3436: l_splitted_instances csi_datastructures_pub.instance_tbl;
3437: l_assy_comp_map_tbl assy_comp_map_tbl;
3438:
3439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3440: l_comp_serial_code number;
3568:
3569: PROCEDURE build_wo_less_rltn_at_wipci(
3570: p_txn_ref IN txn_ref,
3571: p_qty_completed IN number,
3572: p_issued_instances IN csi_datastructures_pub.instance_tbl,
3573: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3574: x_return_status OUT NOCOPY varchar2)
3575: IS
3576:
3569: PROCEDURE build_wo_less_rltn_at_wipci(
3570: p_txn_ref IN txn_ref,
3571: p_qty_completed IN number,
3572: p_issued_instances IN csi_datastructures_pub.instance_tbl,
3573: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3574: x_return_status OUT NOCOPY varchar2)
3575: IS
3576:
3577: l_assembly_instances csi_datastructures_pub.instance_tbl;
3573: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3574: x_return_status OUT NOCOPY varchar2)
3575: IS
3576:
3577: l_assembly_instances csi_datastructures_pub.instance_tbl;
3578: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3579: l_issued_instances csi_datastructures_pub.instance_tbl;
3580: l_splitted_instances csi_datastructures_pub.instance_tbl;
3581: l_assy_comp_map_tbl assy_comp_map_tbl;
3574: x_return_status OUT NOCOPY varchar2)
3575: IS
3576:
3577: l_assembly_instances csi_datastructures_pub.instance_tbl;
3578: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3579: l_issued_instances csi_datastructures_pub.instance_tbl;
3580: l_splitted_instances csi_datastructures_pub.instance_tbl;
3581: l_assy_comp_map_tbl assy_comp_map_tbl;
3582:
3575: IS
3576:
3577: l_assembly_instances csi_datastructures_pub.instance_tbl;
3578: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3579: l_issued_instances csi_datastructures_pub.instance_tbl;
3580: l_splitted_instances csi_datastructures_pub.instance_tbl;
3581: l_assy_comp_map_tbl assy_comp_map_tbl;
3582:
3583: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3576:
3577: l_assembly_instances csi_datastructures_pub.instance_tbl;
3578: l_f_assy_instances csi_datastructures_pub.instance_tbl; --included for bug 5395829
3579: l_issued_instances csi_datastructures_pub.instance_tbl;
3580: l_splitted_instances csi_datastructures_pub.instance_tbl;
3581: l_assy_comp_map_tbl assy_comp_map_tbl;
3582:
3583: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3584: l_comp_serial_code number;
3755: api_log('check_prior_wip_txns_in_csi');
3756:
3757: x_return_status := fnd_api.g_ret_sts_success;
3758:
3759: l_migration_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3760:
3761: debug(' migration_date :'||l_migration_date);
3762:
3763: FOR mtl_txn_rec IN mtl_txn_cur(l_migration_date)
3885:
3886: /* process relationships at the time of WIP assembly completion */
3887: PROCEDURE process_relation_at_wipac(
3888: p_txn_ref IN txn_ref,
3889: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3890: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3891: x_return_status OUT NOCOPY varchar2)
3892: IS
3893:
3886: /* process relationships at the time of WIP assembly completion */
3887: PROCEDURE process_relation_at_wipac(
3888: p_txn_ref IN txn_ref,
3889: p_assembly_instances IN csi_datastructures_pub.instance_tbl,
3890: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3891: x_return_status OUT NOCOPY varchar2)
3892: IS
3893:
3894: l_context CONSTANT char(10) := 'COMPLETION';
3912: x_return_status := l_return_status;
3913:
3914: api_log('process_relation_at_wipac');
3915:
3916: l_auto_allocate := csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip;
3917:
3918: IF p_txn_ref.srl_control_code in (1, 6) THEN
3919: debug('no relationship processing for non serial assemblies.');
3920: RAISE process_no_relation;
3998: END process_relation_at_wipac;
3999:
4000: PROCEDURE process_relation_at_wipci(
4001: p_txn_ref IN txn_ref,
4002: p_component_instances IN csi_datastructures_pub.instance_tbl,
4003: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4004: x_return_status OUT NOCOPY varchar2)
4005: IS
4006:
3999:
4000: PROCEDURE process_relation_at_wipci(
4001: p_txn_ref IN txn_ref,
4002: p_component_instances IN csi_datastructures_pub.instance_tbl,
4003: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4004: x_return_status OUT NOCOPY varchar2)
4005: IS
4006:
4007: l_context CONSTANT char(5) := 'ISSUE';
4134: x_return_status := fnd_api.g_ret_sts_success;
4135:
4136: api_log('bld_inst_tables_for_issue');
4137:
4138: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4139: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
4140:
4141: -- build destination location attribs
4142: x_dest_loc_rec.location_type_code := 'WIP';
4135:
4136: api_log('bld_inst_tables_for_issue');
4137:
4138: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4139: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
4140:
4141: -- build destination location attribs
4142: x_dest_loc_rec.location_type_code := 'WIP';
4143: x_dest_loc_rec.location_id := nvl(p_mmt_rec.subinv_location_id,p_mmt_rec.hr_location_id); --5277935
4203:
4204: PROCEDURE Delink_ReplaceRebuilds(
4205: p_wip_entity_id IN number,
4206: p_organization_id IN number,
4207: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4208: x_replace_rebuilds OUT nocopy eam_utility_grp.replace_rebuild_tbl_type,
4209: x_return_status OUT nocopy varchar2)
4210: IS
4211: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4271: END Delink_ReplaceRebuilds;
4272:
4273: PROCEDURE wip_issue(
4274: p_mmt_rec IN mtl_material_transactions%rowtype,
4275: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4276: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4277: x_return_status OUT NOCOPY varchar2)
4278: IS
4279:
4272:
4273: PROCEDURE wip_issue(
4274: p_mmt_rec IN mtl_material_transactions%rowtype,
4275: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4276: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4277: x_return_status OUT NOCOPY varchar2)
4278: IS
4279:
4280: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_component_issue';
4291: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
4292: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
4293: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
4294:
4295: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4296:
4297: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
4298: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
4299: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
4304: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4305: l_msg_count number;
4306: l_msg_data varchar2(2000);
4307:
4308: l_issued_instances csi_datastructures_pub.instance_tbl;
4309: l_i_ind binary_integer := 0;
4310:
4311: l_error_rec csi_datastructures_pub.transaction_error_rec;
4312:
4307:
4308: l_issued_instances csi_datastructures_pub.instance_tbl;
4309: l_i_ind binary_integer := 0;
4310:
4311: l_error_rec csi_datastructures_pub.transaction_error_rec;
4312:
4313: BEGIN
4314:
4315: x_return_status := fnd_api.g_ret_sts_success;
4430:
4431: PROCEDURE wip_comp_issue(
4432: p_transaction_id IN number,
4433: p_message_id IN number,
4434: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4435: x_return_status OUT nocopy varchar2)
4436: IS
4437:
4438: l_mmt_rec mtl_material_transactions%rowtype;
4435: x_return_status OUT nocopy varchar2)
4436: IS
4437:
4438: l_mmt_rec mtl_material_transactions%rowtype;
4439: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4440: l_error_rec csi_datastructures_pub.transaction_error_rec;
4441: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4442:
4443: BEGIN
4436: IS
4437:
4438: l_mmt_rec mtl_material_transactions%rowtype;
4439: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4440: l_error_rec csi_datastructures_pub.transaction_error_rec;
4441: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4442:
4443: BEGIN
4444: x_return_status := fnd_api.g_ret_sts_success;
4459:
4460: fnd_msg_pub.initialize;
4461:
4462: --
4463: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4464: csi_gen_utility_pvt.populate_install_param_rec;
4465: END IF;
4466:
4467: l_error_rec := px_trx_error_rec;
4520:
4521: PROCEDURE wip_assy_return(
4522: p_transaction_id IN number,
4523: p_message_id IN number,
4524: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4525: x_return_status OUT nocopy varchar2)
4526: IS
4527:
4528: l_mmt_rec mtl_material_transactions%rowtype;
4525: x_return_status OUT nocopy varchar2)
4526: IS
4527:
4528: l_mmt_rec mtl_material_transactions%rowtype;
4529: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4530: l_error_rec csi_datastructures_pub.transaction_error_rec;
4531: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4532:
4533: BEGIN
4526: IS
4527:
4528: l_mmt_rec mtl_material_transactions%rowtype;
4529: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4530: l_error_rec csi_datastructures_pub.transaction_error_rec;
4531: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4532:
4533: BEGIN
4534: x_return_status := fnd_api.g_ret_sts_success;
4549:
4550: fnd_msg_pub.initialize;
4551:
4552: --
4553: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4554: csi_gen_utility_pvt.populate_install_param_rec;
4555: END IF;
4556:
4557: l_error_rec := px_trx_error_rec;
4613:
4614: PROCEDURE wip_byproduct_return(
4615: p_transaction_id IN number,
4616: p_message_id IN number,
4617: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4618: x_return_status OUT nocopy varchar2)
4619: IS
4620:
4621: l_mmt_rec mtl_material_transactions%rowtype;
4618: x_return_status OUT nocopy varchar2)
4619: IS
4620:
4621: l_mmt_rec mtl_material_transactions%rowtype;
4622: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4623: l_error_rec csi_datastructures_pub.transaction_error_rec;
4624: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4625:
4626: BEGIN
4619: IS
4620:
4621: l_mmt_rec mtl_material_transactions%rowtype;
4622: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4623: l_error_rec csi_datastructures_pub.transaction_error_rec;
4624: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4625:
4626: BEGIN
4627: x_return_status := fnd_api.g_ret_sts_success;
4642:
4643: fnd_msg_pub.initialize;
4644:
4645: --
4646: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4647: csi_gen_utility_pvt.populate_install_param_rec;
4648: END IF;
4649:
4650: l_error_rec := px_trx_error_rec;
4704:
4705: PROCEDURE wip_neg_comp_return(
4706: p_transaction_id IN number,
4707: p_message_id IN number,
4708: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
4709: x_return_status OUT nocopy varchar2)
4710: IS
4711:
4712: l_mmt_rec mtl_material_transactions%rowtype;
4709: x_return_status OUT nocopy varchar2)
4710: IS
4711:
4712: l_mmt_rec mtl_material_transactions%rowtype;
4713: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4714: l_error_rec csi_datastructures_pub.transaction_error_rec;
4715: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4716:
4717: BEGIN
4710: IS
4711:
4712: l_mmt_rec mtl_material_transactions%rowtype;
4713: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4714: l_error_rec csi_datastructures_pub.transaction_error_rec;
4715: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4716:
4717: BEGIN
4718: x_return_status := fnd_api.g_ret_sts_success;
4733:
4734: fnd_msg_pub.initialize;
4735:
4736: --
4737: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4738: csi_gen_utility_pvt.populate_install_param_rec;
4739: END IF;
4740:
4741: l_error_rec := px_trx_error_rec;
4795: PROCEDURE get_issued_serial_instance(
4796: px_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
4797: x_return_status OUT NOCOPY varchar2)
4798: IS
4799: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4800: l_party_query_rec csi_datastructures_pub.party_query_rec;
4801: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4802:
4803: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4796: px_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
4797: x_return_status OUT NOCOPY varchar2)
4798: IS
4799: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4800: l_party_query_rec csi_datastructures_pub.party_query_rec;
4801: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4802:
4803: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4804: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4797: x_return_status OUT NOCOPY varchar2)
4798: IS
4799: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4800: l_party_query_rec csi_datastructures_pub.party_query_rec;
4801: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4802:
4803: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4804: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4805: l_msg_count number;
4799: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4800: l_party_query_rec csi_datastructures_pub.party_query_rec;
4801: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4802:
4803: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4804: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4805: l_msg_count number;
4806: l_msg_data varchar2(2000);
4807:
4860: already tied up in relations.
4861: */
4862:
4863: PROCEDURE get_instances(
4864: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
4865: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4866: x_return_status OUT NOCOPY varchar2)
4867: IS
4868:
4861: */
4862:
4863: PROCEDURE get_instances(
4864: p_instance_query_rec IN csi_datastructures_pub.instance_query_rec,
4865: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4866: x_return_status OUT NOCOPY varchar2)
4867: IS
4868:
4869: l_party_query_rec csi_datastructures_pub.party_query_rec;
4865: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4866: x_return_status OUT NOCOPY varchar2)
4867: IS
4868:
4869: l_party_query_rec csi_datastructures_pub.party_query_rec;
4870: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4871:
4872: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4873: l_instance_tbl csi_datastructures_pub.instance_tbl;
4866: x_return_status OUT NOCOPY varchar2)
4867: IS
4868:
4869: l_party_query_rec csi_datastructures_pub.party_query_rec;
4870: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4871:
4872: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4873: l_instance_tbl csi_datastructures_pub.instance_tbl;
4874:
4868:
4869: l_party_query_rec csi_datastructures_pub.party_query_rec;
4870: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4871:
4872: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4873: l_instance_tbl csi_datastructures_pub.instance_tbl;
4874:
4875:
4876: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4869: l_party_query_rec csi_datastructures_pub.party_query_rec;
4870: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4871:
4872: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4873: l_instance_tbl csi_datastructures_pub.instance_tbl;
4874:
4875:
4876: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4877: l_msg_count number;
4928: p_wip_entity_id IN number,
4929: p_component_item_id IN number,
4930: p_organization_id IN number,
4931: p_lot_number IN varchar2,
4932: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4933: x_return_status OUT NOCOPY varchar2)
4934: IS
4935:
4936: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4932: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4933: x_return_status OUT NOCOPY varchar2)
4934: IS
4935:
4936: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4937: l_inst_tbl csi_datastructures_pub.instance_tbl;
4938: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4939:
4940: BEGIN
4933: x_return_status OUT NOCOPY varchar2)
4934: IS
4935:
4936: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4937: l_inst_tbl csi_datastructures_pub.instance_tbl;
4938: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4939:
4940: BEGIN
4941:
4971: p_wip_entity_id IN number,
4972: p_component_item_id IN number,
4973: p_organization_id IN number,
4974: p_lot_number IN varchar2,
4975: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4976: x_return_status OUT NOCOPY varchar2)
4977: IS
4978:
4979: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4975: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
4976: x_return_status OUT NOCOPY varchar2)
4977: IS
4978:
4979: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4980: l_inst_tbl csi_datastructures_pub.instance_tbl;
4981: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4982:
4983: BEGIN
4976: x_return_status OUT NOCOPY varchar2)
4977: IS
4978:
4979: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4980: l_inst_tbl csi_datastructures_pub.instance_tbl;
4981: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4982:
4983: BEGIN
4984:
5029: p_wip_entity_id IN number,
5030: p_component_item_id IN number,
5031: p_organization_id IN number,
5032: p_lot_number IN varchar2,
5033: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5034: x_return_status OUT NOCOPY varchar2)
5035: IS
5036:
5037: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5033: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5034: x_return_status OUT NOCOPY varchar2)
5035: IS
5036:
5037: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5038: l_inst_tbl csi_datastructures_pub.instance_tbl;
5039: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5040:
5041: BEGIN
5034: x_return_status OUT NOCOPY varchar2)
5035: IS
5036:
5037: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5038: l_inst_tbl csi_datastructures_pub.instance_tbl;
5039: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5040:
5041: BEGIN
5042:
5067:
5068: PROCEDURE deallocate_using_qty_per_assy(
5069: p_qty_returned IN number,
5070: p_qty_per_assy IN number,
5071: p_instances_tbl IN csi_datastructures_pub.instance_tbl,
5072: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5073: x_qty_remaining IN OUT NOCOPY number,
5074: x_return_status OUT NOCOPY varchar2)
5075: IS
5068: PROCEDURE deallocate_using_qty_per_assy(
5069: p_qty_returned IN number,
5070: p_qty_per_assy IN number,
5071: p_instances_tbl IN csi_datastructures_pub.instance_tbl,
5072: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5073: x_qty_remaining IN OUT NOCOPY number,
5074: x_return_status OUT NOCOPY varchar2)
5075: IS
5076:
5084: l_qty_remaining number;
5085: l_qty_available number;
5086: l_qty_dealloc number;
5087:
5088: l_inst_tbl csi_datastructures_pub.instance_tbl;
5089: l_ind binary_integer := 0;
5090: l_f_ind binary_integer := 0;
5091: l_da_ind binary_integer := 0;
5092: l_da_tbl da_tbl;
5189: p_organization_id IN number,
5190: p_lot_number IN varchar2,
5191: p_returned_quantity IN number,
5192: p_auto_allocate IN varchar2,
5193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5194: x_return_status OUT NOCOPY varchar2)
5195: IS
5196:
5197: l_qty_remaining number;
5199:
5200: l_qty_per_assy number;
5201: l_total_qty_issued number;
5202:
5203: l_instance_tbl csi_datastructures_pub.instance_tbl;
5204: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5205:
5206: BEGIN
5207:
5332:
5333: PROCEDURE bld_inst_tables_for_return(
5334: p_txn_ref IN txn_ref,
5335: p_mmt_rec IN mmt_rec,
5336: p_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5337: x_dest_loc_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
5338: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
5339: x_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
5340: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
5358: l_dest_loc_rec csi_process_txn_grp.dest_location_rec;
5359: l_instances_tbl csi_process_txn_grp.txn_instances_tbl;
5360: l_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
5361:
5362: l_csi_instance_tbl csi_datastructures_pub.instance_tbl;
5363:
5364: l_maintenance_source number := 0;
5365: l_relation_found varchar2(1) := 'N';
5366: l_parent_instance_id number;
5370: x_return_status := fnd_api.g_ret_sts_success;
5371:
5372: api_log('bld_inst_tables_for_return');
5373:
5374: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5375: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5376: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5377:
5378: -- build destination location attribs
5371:
5372: api_log('bld_inst_tables_for_return');
5373:
5374: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5375: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5376: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5377:
5378: -- build destination location attribs
5379: l_dest_loc_rec.location_type_code := 'INVENTORY';
5372: api_log('bld_inst_tables_for_return');
5373:
5374: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5375: l_auto_allocate := nvl(csi_datastructures_pub.g_install_param_rec.auto_allocate_comp_at_wip, 'N');
5376: -- l_wip_loc_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
5377:
5378: -- build destination location attribs
5379: l_dest_loc_rec.location_type_code := 'INVENTORY';
5380: l_dest_loc_rec.location_id := p_mmt_rec.subinv_location_id;
5570: /* main routine for the wip component return transaction. */
5571: PROCEDURE wip_comp_receipt(
5572: p_transaction_id IN number,
5573: p_message_id IN number,
5574: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
5575: x_return_status OUT nocopy VARCHAR2)
5576: IS
5577:
5578: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_component_return';
5589: l_pricing_attribs_tbl csi_process_txn_grp.txn_pricing_attribs_tbl;
5590: l_instance_asset_tbl csi_process_txn_grp.txn_instance_asset_tbl;
5591: l_ii_relationships_tbl csi_process_txn_grp.txn_ii_relationships_tbl;
5592:
5593: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
5594:
5595: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
5596: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
5597: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
5601: l_error_message varchar2(2000);
5602: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5603: l_msg_count number;
5604: l_msg_data varchar2(2000);
5605: l_error_rec csi_datastructures_pub.transaction_error_rec;
5606:
5607: BEGIN
5608:
5609: savepoint wip_component_receipt;
5625:
5626: -- This procedure check if the installed base is active
5627: csi_utility_grp.check_ib_active;
5628:
5629: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5630: csi_gen_utility_pvt.populate_install_param_rec;
5631: END IF;
5632:
5633: l_error_rec := px_trx_error_rec;
5749:
5750: PROCEDURE bld_inst_tables_for_compl(
5751: p_txn_ref IN txn_ref,
5752: p_mmt_rec IN mmt_rec,
5753: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
5754: x_dest_loc_rec OUT NOCOPY csi_process_txn_grp.dest_location_rec,
5755: x_instances_tbl OUT NOCOPY csi_process_txn_grp.txn_instances_tbl,
5756: x_parties_tbl OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,
5757: x_org_units_tbl OUT NOCOPY csi_process_txn_grp.txn_org_units_tbl,
5758: x_return_status OUT NOCOPY varchar2)
5759: IS
5760: l_int_party_id number;
5761: l_comp_is_assy varchar2(1) := 'N';
5762: l_issued_instances csi_datastructures_pub.instance_tbl;
5763: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5764: l_instance_found boolean := FALSE;
5765: BEGIN
5766:
5766:
5767: x_return_status := fnd_api.g_ret_sts_success;
5768: api_log('bld_inst_tables_for_compl');
5769:
5770: l_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5771:
5772: -- destination location attributes
5773: x_dest_loc_rec.location_type_code := 'INVENTORY';
5774: x_dest_loc_rec.location_id := p_mmt_rec.subinv_location_id;
5912:
5913: PROCEDURE wip_byproduct_completion(
5914: p_transaction_id IN number,
5915: p_message_id IN number,
5916: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
5917: x_return_status OUT nocopy varchar2)
5918: IS
5919:
5920: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_Byproduct_completion';
5934: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5935: l_msg_count number;
5936: l_msg_data varchar2(240);
5937:
5938: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
5939:
5940: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
5941: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
5942: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
5944:
5945: l_api_success varchar2(1) := fnd_api.g_ret_sts_success;
5946: l_error_message varchar2(2000);
5947:
5948: l_completed_instances csi_datastructures_pub.instance_tbl;
5949: l_c_ind binary_integer := 0;
5950:
5951: l_error_rec csi_datastructures_pub.transaction_error_rec;
5952: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
5947:
5948: l_completed_instances csi_datastructures_pub.instance_tbl;
5949: l_c_ind binary_integer := 0;
5950:
5951: l_error_rec csi_datastructures_pub.transaction_error_rec;
5952: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
5953:
5954: BEGIN
5955:
5970: debug(' Transaction ID : '||p_transaction_id);
5971:
5972: csi_utility_grp.check_ib_active;
5973:
5974: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5975: csi_gen_utility_pvt.populate_install_param_rec;
5976: END IF;
5977:
5978: l_error_rec := px_trx_error_rec;
6142:
6143: PROCEDURE wip_assy_completion(
6144: p_transaction_id IN number,
6145: p_message_id IN number,
6146: px_trx_error_rec IN OUT nocopy csi_datastructures_pub.transaction_error_rec,
6147: x_return_status OUT nocopy varchar2)
6148: IS
6149:
6150: l_api_name varchar2(100):= 'csi_wip_trxs_pkg.wip_Assembly_completion';
6164: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6165: l_msg_count number;
6166: l_msg_data varchar2(240);
6167:
6168: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6169:
6170: l_c_dest_loc_rec csi_process_txn_grp.dest_location_rec;
6171: l_c_instances_tbl csi_process_txn_grp.txn_instances_tbl;
6172: l_c_parties_tbl csi_process_txn_grp.txn_i_parties_tbl;
6174:
6175: l_api_success varchar2(1) := fnd_api.g_ret_sts_success;
6176: l_error_message varchar2(2000);
6177:
6178: l_completed_instances csi_datastructures_pub.instance_tbl;
6179: l_c_ind binary_integer := 0;
6180:
6181: l_error_rec csi_datastructures_pub.transaction_error_rec;
6182: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6177:
6178: l_completed_instances csi_datastructures_pub.instance_tbl;
6179: l_c_ind binary_integer := 0;
6180:
6181: l_error_rec csi_datastructures_pub.transaction_error_rec;
6182: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6183:
6184: BEGIN
6185:
6200: debug(' Transaction ID : '||p_transaction_id);
6201:
6202: csi_utility_grp.check_ib_active;
6203:
6204: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6205: csi_gen_utility_pvt.populate_install_param_rec;
6206: END IF;
6207:
6208: l_error_rec := px_trx_error_rec;
6368:
6369: PROCEDURE build_ii_relation_rec(
6370: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6371: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6372: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6373: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6374: x_return_status OUT NOCOPY varchar2)
6375: IS
6376:
6369: PROCEDURE build_ii_relation_rec(
6370: p_tiir_rec IN csi_t_datastructures_grp.txn_ii_rltns_rec,
6371: p_tld_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
6372: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6373: x_iir_rec OUT NOCOPY csi_datastructures_pub.ii_relationship_rec,
6374: x_return_status OUT NOCOPY varchar2)
6375: IS
6376:
6377: l_obj_instance_id number;
6380: l_sub_instance_qty number;
6381: l_sub_tld_id number := -999999;
6382: l_vld_organization_id number;
6383:
6384: l_source_instance_rec csi_datastructures_pub.instance_rec;
6385: l_new_instance_rec csi_datastructures_pub.instance_rec;
6386: l_source_instance_qty number;
6387: l_new_instance_qty number;
6388:
6381: l_sub_tld_id number := -999999;
6382: l_vld_organization_id number;
6383:
6384: l_source_instance_rec csi_datastructures_pub.instance_rec;
6385: l_new_instance_rec csi_datastructures_pub.instance_rec;
6386: l_source_instance_qty number;
6387: l_new_instance_qty number;
6388:
6389: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6385: l_new_instance_rec csi_datastructures_pub.instance_rec;
6386: l_source_instance_qty number;
6387: l_new_instance_qty number;
6388:
6389: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6390:
6391: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6392: l_msg_count number;
6393: l_msg_data varchar2(2000);
6531: l_ceav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6537: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6538: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6539: l_c_ind binary_integer := 0;
6532: l_toa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl ;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6537: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6538: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6539: l_c_ind binary_integer := 0;
6540: l_u_ind binary_integer := 0;
6533: l_tsys_tbl csi_t_datastructures_grp.txn_systems_tbl;
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6537: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6538: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6539: l_c_ind binary_integer := 0;
6540: l_u_ind binary_integer := 0;
6541:
6534:
6535: l_txn_rec csi_datastructures_pub.transaction_rec;
6536: l_iir_rec csi_datastructures_pub.ii_relationship_rec;
6537: l_c_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6538: l_u_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
6539: l_c_ind binary_integer := 0;
6540: l_u_ind binary_integer := 0;
6541:
6542: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6698:
6699: PROCEDURE eam_wip_completion(
6700: p_wip_entity_id IN number,
6701: p_organization_id IN number,
6702: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
6703: x_return_status OUT nocopy varchar2)
6704: IS
6705: CURSOR mtl_txn_cur(p_wip_entity_id IN number, p_migration_date IN date) IS
6706: SELECT transaction_id
6726: AND wip_job_id = p_wip_entity_id
6727: AND instance_id <> p_instance_id;
6728:
6729: l_instance_id number;
6730: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6731: l_iir_ind binary_integer := 0;
6732: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6733: l_msg_count number;
6734: l_msg_data varchar2(2000);
6728:
6729: l_instance_id number;
6730: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6731: l_iir_ind binary_integer := 0;
6732: l_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
6733: l_msg_count number;
6734: l_msg_data varchar2(2000);
6735: l_replace_rebuilds EAM_Utility_GRP.Replace_Rebuild_TBL_Type;
6736:
6766: debug(' Transaction Time : '||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
6767: debug(' Transaction Type : EAM Work Order Completion');
6768: debug(' Transaction ID : '||p_wip_entity_id);
6769:
6770: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6771: csi_gen_utility_pvt.populate_install_param_rec;
6772: END IF;
6773:
6774: l_csi_txn_rec.transaction_type_id := 92;
6798: END IF;
6799:
6800: FOR mtl_txn_rec IN mtl_txn_cur(
6801: p_wip_entity_id => p_wip_entity_id,
6802: p_migration_date => csi_datastructures_pub.g_install_param_rec.freeze_date)
6803: LOOP
6804:
6805: debug(' prior transaction_id : '||mtl_txn_rec.transaction_id);
6806:
6890: PROCEDURE eam_rebuildable_return(
6891: p_wip_entity_id IN number,
6892: p_organization_id IN number,
6893: p_instance_id IN number,
6894: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
6895: x_return_status OUT nocopy varchar2)
6896: IS
6897: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6898: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6893: p_instance_id IN number,
6894: px_trx_error_rec OUT nocopy csi_datastructures_pub.transaction_error_rec,
6895: x_return_status OUT nocopy varchar2)
6896: IS
6897: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6898: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6899: BEGIN
6900:
6901: x_return_status := fnd_api.g_ret_sts_success;
6909: debug(' Transaction Time : '||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
6910: debug(' Transaction Type : EAM Rebuildable Return');
6911: debug(' Transaction ID : '||p_wip_entity_id);
6912:
6913: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6914: csi_gen_utility_pvt.populate_install_param_rec;
6915: END IF;
6916:
6917: l_csi_txn_rec.transaction_type_id := 93;