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 218: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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

Line 223: p_always_insert IN VARCHAR2 := FND_API.G_FALSE

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

Line 286: IF FND_API.TO_BOOLEAN(p_always_insert) THEN

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

Line 316: l_insert := FND_API.G_TRUE;

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

Line 318: l_insert := FND_API.G_FALSE;

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

Line 326: IF FND_API.TO_BOOLEAN(l_insert) THEN

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

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

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

Line 372: p_always_insert IN VARCHAR2 := FND_API.G_FALSE

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

Line 449: IF FND_API.TO_BOOLEAN(p_always_insert) THEN

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

Line 477: l_insert := FND_API.G_TRUE;

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

Line 479: l_insert := FND_API.G_FALSE;

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

Line 487: IF FND_API.TO_BOOLEAN(l_insert) THEN

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

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

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

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

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

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

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

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

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