DBA Data[Home] [Help]

APPS.RCV_GAPLESS_NUMBERING dependencies on MTL_PARAMETERS

Line 38: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

34: l_msg_data VARCHAR2 (2000);
35: l_msg_count NUMBER;
36: l_vendor_id NUMBER;
37: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
38: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
39: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
40: l_vendor_site_code PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE;
41: l_org_code_name VARCHAR2(300);
42: -- End of code bugfix 5197828

Line 133: FROM mtl_parameters

129:
130: BEGIN
131: SELECT organization_code
132: INTO l_organization_code
133: FROM mtl_parameters
134: WHERE organization_id = p_org_id;
135:
136: IF (g_asn_debug = 'Y')
137: THEN