[Home] [Help]
621: -- Fixed the datatype of l_temp_org_name
622: -- SECHAWLA 16-JAN-02 Bug # 2754280
623: -- Changed the call to fn get_user_profile_option_name to refer it from am util
624: -- SECHAWLA 08-MAR-04 Bug # 3492490
625: -- Use ORG_ORGANIZATION_DEFINITIONS instead of mtl_organizations to validate the inventory org
626: -- Validate subinventory is defined for Master org when the remarketing inv org is a child org
627: -- SECHAWLA 19-MAY-04 Bug # 3634514
628: -- Populate subinventory fields on the item master only if 1) the remarketing org is a master org OR
629: -- 2) Remarketing org is a child org and the item is being assigned to the child org
648:
649: -- This cursor is used to validate an organization Id against mtl_organization
650: CURSOR l_mtlorgcsr(p_org_id NUMBER) IS
651: SELECT organization_name
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
649: -- This cursor is used to validate an organization Id against mtl_organization
650: CURSOR l_mtlorgcsr(p_org_id NUMBER) IS
651: SELECT organization_name
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
657: WHERE organization_id = p_org_id;
652: -- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
653: -- inventory organization. mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
654: -- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
655: --FROM mtl_organizations
656: FROM ORG_ORGANIZATION_DEFINITIONS
657: WHERE organization_id = p_org_id;
658:
659: -- This cursor is used to validate Organization and subinventory
660: CURSOR l_mtlsecinv_csr(p_inv_org_id NUMBER, p_subinv_code VARCHAR2) IS
695:
696: -- SECHAWLA 08-MAR-04 3492490 : Added master org name
697: CURSOR l_mtlparam_csr(p_org_id NUMBER) IS
698: SELECT a.master_organization_id, b.organization_name master_org_name
699: FROM mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b
700: WHERE a.organization_id = p_org_id
701: AND a.master_organization_id = b.organization_id ;
702:
703:
729:
730: --SECHAWLA Bug# 2679812 : new declarations
731: l_master_org_id NUMBER;
732: l_current_org NUMBER;
733: l_current_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE; -- SECHAWLA 08-DEC-04 4047159
734: l_iterations NUMBER;
735: l_item_id NUMBER;
736: l_item_number VARCHAR2(2000);
737: l_user_profile_name VARCHAR2(240);
738: l_org_id NUMBER; -- Added for bug 10081463
739:
740: -- SECHAWLA 08-MAR-04 3492490 : new declarations
741:
742: l_master_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
743:
744: --SECHAWLA 19-MAY-04 3634514 : new declaration
745: l_assign_subinv VARCHAR2(1);
746: