224: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
225: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
226:
227: begin
228: fnd_manager.register(sm_name || ': ' || node, 'FND',
229: mgr_name, sm_name, 'Service Manager',
230: null, null, node, null, null, null,
231: 'FNDSM', 'FND', null, 'US' );
232: end;
278: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
279: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
280:
281: begin
282: fnd_manager.register(im_name || ': ' || node, 'FND',
283: mgr_name, im_name, 'Internal Monitor',
284: null, null, node, null, null, null,
285: 'FNDIMON', 'FND', null, 'US' );
286: end;
338: where upper(CONCURRENT_QUEUE_NAME) = upper(mgr_name)
339: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
340:
341: begin
342: if not fnd_manager.Manager_exists(name || ':' ||node,'FND') then
343: fnd_manager.register_si(manager=>name || ': ' || node,
344: application=>'FND',
345: short_name=>mgr_name,
346: service_handle=>'OAMGCS',
339: AND application_id = (SELECT application_id FROM fnd_application WHERE application_short_name = 'FND');
340:
341: begin
342: if not fnd_manager.Manager_exists(name || ':' ||node,'FND') then
343: fnd_manager.register_si(manager=>name || ': ' || node,
344: application=>'FND',
345: short_name=>mgr_name,
346: service_handle=>'OAMGCS',
347: PRIMARY_NODE=>node);
348: end if;
349: /* Bug 2557014: use work_shift_id parameter insted of
350: workshift_name parameter to ensure Standard workshift
351: is found in NLS instances */
352: if not fnd_manager.manager_work_shift_exists(name || ':' ||node,'FND','Standard') then
353: fnd_manager.assign_work_shift(manager_short_name=>mgr_name,
354: manager_application=>'FND',
355: work_shift_id => 0,
356: processes=>1,
349: /* Bug 2557014: use work_shift_id parameter insted of
350: workshift_name parameter to ensure Standard workshift
351: is found in NLS instances */
352: if not fnd_manager.manager_work_shift_exists(name || ':' ||node,'FND','Standard') then
353: fnd_manager.assign_work_shift(manager_short_name=>mgr_name,
354: manager_application=>'FND',
355: work_shift_id => 0,
356: processes=>1,
357: sleep_seconds=>30,