APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 54: FROM ORG_ORGANIZATION_DEFINITIONS

50:
51: -- This cursor is used to validate an organization Id against mtl_organization
52: CURSOR l_mtlorgcsr(cp_org_id NUMBER) IS
53: SELECT organization_name
54: FROM ORG_ORGANIZATION_DEFINITIONS
55: WHERE organization_id = cp_org_id;
56:
57:
58:

Line 626: FROM mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b

622: AND secondary_inventory_name = p_subinv_code;
623:
624: CURSOR l_mtlparam_csr(p_org_id NUMBER) IS
625: SELECT a.master_organization_id, b.organization_name master_org_name
626: FROM mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b
627: WHERE a.organization_id = p_org_id
628: AND a.master_organization_id = b.organization_id ;
629:
630:

Line 656: l_master_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;

652: l_api_name CONSTANT VARCHAR2(30) := 'create_inv_item';
653: l_api_version CONSTANT NUMBER := 1;
654: ---
655: l_master_org_id NUMBER;
656: l_master_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
657: l_iterations NUMBER;
658: l_current_org NUMBER;
659: l_current_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE; -- SECHAWLA 08-DEC-04 4047159
660: l_item_id NUMBER;

Line 659: l_current_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE; -- SECHAWLA 08-DEC-04 4047159

655: l_master_org_id NUMBER;
656: l_master_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE;
657: l_iterations NUMBER;
658: l_current_org NUMBER;
659: l_current_org_name ORG_ORGANIZATION_DEFINITIONS.organization_name%TYPE; -- SECHAWLA 08-DEC-04 4047159
660: l_item_id NUMBER;
661: l_New_Item_Number VARCHAR2(2000);
662: l_New_Item_Id NUMBER;
663: l_temp VARCHAR2(25);