APPS.EGO_ITEM_PVT dependencies on MTL_PARAMETERS

Line 151: from mtl_parameters

147: IF x_organization_id IS NOT NULL THEN
148: BEGIN
149: SELECT organization_id
150: INTO x_organization_id
151: from mtl_parameters
152: where organization_id = x_organization_id;
153: RETURN TRUE;
154: EXCEPTION
155: WHEN OTHERS THEN

Line 170: from mtl_parameters

166: ELSIF p_organization_code IS NOT NULL THEN
167: BEGIN
168: SELECT organization_id
169: INTO x_organization_id
170: from mtl_parameters
171: where organization_code = p_organization_code;
172: RETURN TRUE;
173: EXCEPTION
174: WHEN OTHERS THEN

Line 1008: FROM mtl_parameters

1004: IS
1005: CURSOR c_get_org_code(cp_org_id NUMBER) IS
1006: SELECT organization_code
1007: ,master_organization_id
1008: FROM mtl_parameters
1009: WHERE organization_id = cp_org_id;
1010:
1011: l_api_name CONSTANT VARCHAR2(30) := 'Process_Items';
1012: l_return_status VARCHAR2(1) := G_MISS_CHAR;

Line 2139: FROM mtl_parameters

2135: x_return_status := l_return_status;
2136: /*Fix for Bug 4013187*/
2137: ELSE /*Copy the Description into TL tables for all the languages supported*/
2138: SELECT MASTER_ORGANIZATION_ID INTO l_master_org
2139: FROM mtl_parameters
2140: WHERE ORGANIZATION_ID = l_Item_rec_in.ORGANIZATION_ID;
2141:
2142: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
2143: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)

Line 2661: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

2657: -----------------------------------------------
2658: DECLARE
2659:
2660: l_error_message_name VARCHAR2(30);
2661: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
2662: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
2663:
2664: BEGIN
2665:

Line 2680: FROM MTL_PARAMETERS

2676: AND ORGANIZATION_ID = p_organization_id;
2677:
2678: SELECT ORGANIZATION_CODE
2679: INTO l_org_code
2680: FROM MTL_PARAMETERS
2681: WHERE ORGANIZATION_ID = p_organization_id;
2682:
2683: l_token_table(1).TOKEN_NAME := 'USER_NAME';
2684: l_token_table(1).TOKEN_VALUE := FND_GLOBAL.USER_NAME;