eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_TEMPL_ATTRS_PUB dependencies on FND_API

Line 124: p_commit IN VARCHAR2 := FND_API.G_FALSE,

120: -- p_attribute_name is the full attribute name in mtl_item_templ_attributes
121: ----------------------------------------------------------------
122:
123: Procedure Sync_Template( p_template_id IN NUMBER,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_message_text OUT NOCOPY VARCHAR2
127: )
128: IS

Line 217: p_commit IN VARCHAR2 := FND_API.G_FALSE,

213: ( p_template_id IN NUMBER,
214: p_attribute_name IN VARCHAR2,
215: p_attribute_value IN VARCHAR2,
216: p_enabled_flag IN VARCHAR2,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_ego_attr_id IN NUMBER ,
219: p_ego_attr_group_id IN NUMBER ,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_message_text OUT NOCOPY VARCHAR2,

Line 222: p_always_insert IN VARCHAR2 := FND_API.G_FALSE

218: p_ego_attr_id IN NUMBER ,
219: p_ego_attr_group_id IN NUMBER ,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_message_text OUT NOCOPY VARCHAR2,
222: p_always_insert IN VARCHAR2 := FND_API.G_FALSE
223: )
224: IS
225:
226: --5101284 : Perf issues

Line 285: IF FND_API.TO_BOOLEAN(p_always_insert) THEN

281: ----------------------------------------------------------------------------
282: -- Determine whether an INSERT or UPDATE is required --
283: ----------------------------------------------------------------------------
284:
285: IF FND_API.TO_BOOLEAN(p_always_insert) THEN
286: l_insert := p_always_insert;
287: ELSE
288: --5101284 : Perf issues
289: OPEN c_check_template_attribute(p_template_id,p_attribute_name);

Line 315: l_insert := FND_API.G_TRUE;

311: */
312:
313: l_exists := NVL(l_exists,0);
314: IF( l_exists = 0 ) THEN
315: l_insert := FND_API.G_TRUE;
316: ELSE
317: l_insert := FND_API.G_FALSE;
318: END IF;
319: END IF;

Line 317: l_insert := FND_API.G_FALSE;

313: l_exists := NVL(l_exists,0);
314: IF( l_exists = 0 ) THEN
315: l_insert := FND_API.G_TRUE;
316: ELSE
317: l_insert := FND_API.G_FALSE;
318: END IF;
319: END IF;
320:
321: ----------------------------------------------------------------------------

Line 325: IF FND_API.TO_BOOLEAN(l_insert) THEN

321: ----------------------------------------------------------------------------
322: -- Carry out the necessary DML operation --
323: ----------------------------------------------------------------------------
324:
325: IF FND_API.TO_BOOLEAN(l_insert) THEN
326: Insert_Template_Attribute( p_template_id,
327: p_ego_attr_group_id,
328: p_ego_attr_id,
329: l_data_level_id,

Line 368: p_commit IN VARCHAR2 := FND_API.G_FALSE,

364:
365: Procedure Sync_Template_Attribute
366: ( p_template_id IN NUMBER,
367: p_attribute_name IN VARCHAR2,
368: p_commit IN VARCHAR2 := FND_API.G_FALSE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_message_text OUT NOCOPY VARCHAR2,
371: p_always_insert IN VARCHAR2 := FND_API.G_FALSE
372: )

Line 371: p_always_insert IN VARCHAR2 := FND_API.G_FALSE

367: p_attribute_name IN VARCHAR2,
368: p_commit IN VARCHAR2 := FND_API.G_FALSE,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_message_text OUT NOCOPY VARCHAR2,
371: p_always_insert IN VARCHAR2 := FND_API.G_FALSE
372: )
373: IS
374:
375: --5101284 : Perf issues

Line 448: IF FND_API.TO_BOOLEAN(p_always_insert) THEN

444: ----------------------------------------------------------------------------
445:
446: IF( l_attribute_id IS NOT null AND l_attribute_group_id IS NOT null ) THEN
447:
448: IF FND_API.TO_BOOLEAN(p_always_insert) THEN
449: l_insert := p_always_insert;
450: ELSE
451: --5101284 : Perf issues
452: OPEN c_check_template_attribute(p_template_id,p_attribute_name);

Line 476: l_insert := FND_API.G_TRUE;

472: END;
473: */
474: l_exists := NVL(l_exists,0);
475: IF( l_exists = 0 ) THEN
476: l_insert := FND_API.G_TRUE;
477: ELSE
478: l_insert := FND_API.G_FALSE;
479: END IF;
480: END IF;

Line 478: l_insert := FND_API.G_FALSE;

474: l_exists := NVL(l_exists,0);
475: IF( l_exists = 0 ) THEN
476: l_insert := FND_API.G_TRUE;
477: ELSE
478: l_insert := FND_API.G_FALSE;
479: END IF;
480: END IF;
481:
482: --------------------------------------------------------------------------

Line 486: IF FND_API.TO_BOOLEAN(l_insert) THEN

482: --------------------------------------------------------------------------
483: -- Carry out the necessary DML operation --
484: --------------------------------------------------------------------------
485:
486: IF FND_API.TO_BOOLEAN(l_insert) THEN
487: Debug_Msg(l_api_name || 'Performing insert.');
488: Insert_Template_Attribute( r_inv_templ_attribute.template_id,
489: l_attribute_group_id,
490: l_attribute_id,

Line 537: p_commit IN VARCHAR2 := FND_API.G_FALSE,

533: p_attribute_id IN NUMBER,
534: p_data_level_id IN NUMBER,
535: p_enabled_flag IN VARCHAR2,
536: p_attribute_value IN VARCHAR2,
537: p_commit IN VARCHAR2 := FND_API.G_FALSE,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_message_text OUT NOCOPY VARCHAR2
540: )
541: IS

Line 617: IF( p_commit = fnd_api.g_TRUE ) THEN

613: p_data_level_id
614: );
615:
616: x_return_status := 'S';
617: IF( p_commit = fnd_api.g_TRUE ) THEN
618: commit;
619: END IF;
620:
621: EXCEPTION

Line 638: p_commit IN VARCHAR2 := FND_API.G_FALSE,

634: p_attribute_id IN NUMBER,
635: p_data_level_id IN NUMBER,
636: p_enabled_flag IN VARCHAR2,
637: p_attribute_value IN VARCHAR2,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: x_return_status OUT NOCOPY VARCHAR2,
640: x_message_text OUT NOCOPY VARCHAR2
641: )
642: IS

Line 709: IF( p_commit = fnd_api.g_TRUE ) THEN

705: and template_id = p_template_id;
706:
707: x_return_status := 'S';
708:
709: IF( p_commit = fnd_api.g_TRUE ) THEN
710: commit;
711: END IF;
712:
713: EXCEPTION