APPS.EGO_ITEM_PVT dependencies on MTL_PARAMETERS

Line 147: from mtl_parameters

143: IF x_organization_id IS NOT NULL THEN
144: BEGIN
145: SELECT organization_id
146: INTO x_organization_id
147: from mtl_parameters
148: where organization_id = x_organization_id;
149: RETURN TRUE;
150: EXCEPTION
151: WHEN OTHERS THEN

Line 166: from mtl_parameters

162: ELSIF p_organization_code IS NOT NULL THEN
163: BEGIN
164: SELECT organization_id
165: INTO x_organization_id
166: from mtl_parameters
167: where organization_code = p_organization_code;
168: RETURN TRUE;
169: EXCEPTION
170: WHEN OTHERS THEN

Line 810: FROM mtl_parameters

806: IS
807: CURSOR c_get_org_code(cp_org_id NUMBER) IS
808: SELECT organization_code
809: ,master_organization_id
810: FROM mtl_parameters
811: WHERE organization_id = cp_org_id;
812:
813: l_api_name CONSTANT VARCHAR2(30) := 'Process_Items';
814: l_return_status VARCHAR2(1) := G_MISS_CHAR;

Line 1913: FROM mtl_parameters

1909: x_return_status := l_return_status;
1910: /*Fix for Bug 4013187*/
1911: ELSE /*Copy the Description into TL tables for all the languages supported*/
1912: SELECT MASTER_ORGANIZATION_ID INTO l_master_org
1913: FROM mtl_parameters
1914: WHERE ORGANIZATION_ID = l_Item_rec_in.ORGANIZATION_ID;
1915:
1916: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
1917: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)

Line 2435: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

2431: -----------------------------------------------
2432: DECLARE
2433:
2434: l_error_message_name VARCHAR2(30);
2435: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
2436: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2437:
2438: BEGIN
2439:

Line 2454: FROM MTL_PARAMETERS

2450: AND ORGANIZATION_ID = p_organization_id;
2451:
2452: SELECT ORGANIZATION_CODE
2453: INTO l_org_code
2454: FROM MTL_PARAMETERS
2455: WHERE ORGANIZATION_ID = p_organization_id;
2456:
2457: l_token_table(1).TOKEN_NAME := 'USER_NAME';
2458: l_token_table(1).TOKEN_VALUE := FND_GLOBAL.USER_NAME;