APPS.MTL_PARAM_VALIDATE_PKG dependencies on MTL_PARAMETERS

Line 38: from mtl_parameters

34: v_garbage VARCHAR(255);
35: BEGIN
36: select 'org has children'
37: into v_garbage
38: from mtl_parameters
39: where master_organization_id =
40: org_id
41: and organization_id <>
42: org_id

Line 80: from mtl_parameters

76: elsif curr_lot_control = 2 then
77: BEGIN
78: select 'uniqueness already imposed'
79: into v_garbage
80: from mtl_parameters
81: where lot_number_uniqueness = 1
82: and organization_id <>
83: org_id
84: and rownum < 2;

Line 139: from mtl_parameters

135: elsif curr_serial_control = 4 then -- At item Level
136: BEGIN
137: select 'break constraint'
138: into v_garbage
139: from mtl_parameters
140: where serial_number_type = 3
141: and organization_id <> org_id
142: and rownum < 2;
143:

Line 173: from mtl_parameters

169: WHEN NO_DATA_FOUND THEN
170: BEGIN
171: select 'break constraint'
172: into v_garbage
173: from mtl_parameters
174: where serial_number_type = 3
175: and organization_id <> org_id
176: and rownum < 2;
177:

Line 241: from mtl_parameters

237: v_return_val := 4;
238: else
239: select 'break constraint'
240: into v_garbage
241: from mtl_parameters
242: where serial_number_type = 3
243: and organization_id <> org_id
244: and rownum < 2;
245: v_return_val := 3;