DBA Data[Home] [Help]

APPS.QP_LIMITS_PVT dependencies on QP_LIMIT_ATTRS_UTIL

Line 366: QP_Limit_Attrs_Util.Convert_Miss_To_Null (l_old_LIMIT_ATTRS_rec);

362:
363: -- Set missing old record elements to NULL.
364:
365: l_old_LIMIT_ATTRS_rec :=
366: QP_Limit_Attrs_Util.Convert_Miss_To_Null (l_old_LIMIT_ATTRS_rec);
367:
368: ELSIF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
369: OR l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_DELETE
370: THEN

Line 379: l_old_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Query_Row

375:
376: IF l_old_LIMIT_ATTRS_rec.limit_attribute_id = FND_API.G_MISS_NUM
377: THEN
378:
379: l_old_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Query_Row
380: ( p_limit_attribute_id => l_LIMIT_ATTRS_rec.limit_attribute_id
381: );
382:
383: ELSE

Line 388: QP_Limit_Attrs_Util.Convert_Miss_To_Null (l_old_LIMIT_ATTRS_rec);

384:
385: -- Set missing old record elements to NULL.
386:
387: l_old_LIMIT_ATTRS_rec :=
388: QP_Limit_Attrs_Util.Convert_Miss_To_Null (l_old_LIMIT_ATTRS_rec);
389:
390: END IF;
391:
392: -- Complete new record from old

Line 394: l_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Complete_Record

390: END IF;
391:
392: -- Complete new record from old
393:
394: l_LIMIT_ATTRS_rec := QP_Limit_Attrs_Util.Complete_Record
395: ( p_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
396: , p_old_LIMIT_ATTRS_rec => l_old_LIMIT_ATTRS_rec
397: );
398:

Line 435: QP_Limit_Attrs_Util.Clear_Dependent_Attr

431: IF l_control_rec.change_attributes THEN
432:
433: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
434:
435: QP_Limit_Attrs_Util.Clear_Dependent_Attr
436: ( p_LIMIT_ATTRS_rec => l_p_LIMIT_ATTRS_rec
437: , p_old_LIMIT_ATTRS_rec => l_old_LIMIT_ATTRS_rec
438: , x_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
439: );

Line 467: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);

463: IF l_control_rec.default_attributes
464: OR l_control_rec.change_attributes
465: THEN
466:
467: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);
468: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);
469:
470: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
471:

Line 468: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);

464: OR l_control_rec.change_attributes
465: THEN
466:
467: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);
468: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);
469:
470: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
471:
472: QP_Limit_Attrs_Util.Apply_Attribute_Changes

Line 472: QP_Limit_Attrs_Util.Apply_Attribute_Changes

468: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Apply_Attribute_Changes' || l_return_status);
469:
470: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
471:
472: QP_Limit_Attrs_Util.Apply_Attribute_Changes
473: ( p_LIMIT_ATTRS_rec => l_p_LIMIT_ATTRS_rec
474: , p_old_LIMIT_ATTRS_rec => l_old_LIMIT_ATTRS_rec
475: , x_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
476: );

Line 540: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);

536: -- Step 4. Write to DB
537:
538: IF l_control_rec.write_to_db THEN
539:
540: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
541: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
542: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
543:
544: QP_Limit_Attrs_Util.PRE_WRITE_PROCESS

Line 541: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);

537:
538: IF l_control_rec.write_to_db THEN
539:
540: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
541: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
542: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
543:
544: QP_Limit_Attrs_Util.PRE_WRITE_PROCESS
545: ( p_LIMIT_ATTRS_rec => l_p_LIMIT_ATTRS_rec

Line 544: QP_Limit_Attrs_Util.PRE_WRITE_PROCESS

540: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
541: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.PRE_WRITE_PROCESS' || l_return_status);
542: l_p_LIMIT_ATTRS_rec := l_LIMIT_ATTRS_rec; --[prarasto]
543:
544: QP_Limit_Attrs_Util.PRE_WRITE_PROCESS
545: ( p_LIMIT_ATTRS_rec => l_p_LIMIT_ATTRS_rec
546: , p_old_LIMIT_ATTRS_rec => l_old_LIMIT_ATTRS_rec
547: , x_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
548: );

Line 556: QP_Limit_Attrs_Util.Delete_Row

552: IF l_control_rec.write_to_db THEN
553:
554: IF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
555:
556: QP_Limit_Attrs_Util.Delete_Row
557: ( p_limit_attribute_id => l_LIMIT_ATTRS_rec.limit_attribute_id
558: );
559:
560: ELSE

Line 570: QP_Limit_Attrs_Util.Update_Row (l_LIMIT_ATTRS_rec);

566: l_LIMIT_ATTRS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
567:
568: IF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
569:
570: QP_Limit_Attrs_Util.Update_Row (l_LIMIT_ATTRS_rec);
571:
572: ELSIF l_LIMIT_ATTRS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
573:
574: l_LIMIT_ATTRS_rec.creation_date := SYSDATE;

Line 577: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);

573:
574: l_LIMIT_ATTRS_rec.creation_date := SYSDATE;
575: l_LIMIT_ATTRS_rec.created_by := FND_GLOBAL.USER_ID;
576:
577: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
578: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
579: QP_Limit_Attrs_Util.Insert_Row (l_LIMIT_ATTRS_rec);
580:
581: END IF;

Line 578: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);

574: l_LIMIT_ATTRS_rec.creation_date := SYSDATE;
575: l_LIMIT_ATTRS_rec.created_by := FND_GLOBAL.USER_ID;
576:
577: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
578: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
579: QP_Limit_Attrs_Util.Insert_Row (l_LIMIT_ATTRS_rec);
580:
581: END IF;
582:

Line 579: QP_Limit_Attrs_Util.Insert_Row (l_LIMIT_ATTRS_rec);

575: l_LIMIT_ATTRS_rec.created_by := FND_GLOBAL.USER_ID;
576:
577: --dbms_output.put_line('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
578: oe_debug_pub.add('Processing Limit Attributes- Calling QP_Limit_Attrs_Util.Insert_Row' || l_return_status);
579: QP_Limit_Attrs_Util.Insert_Row (l_LIMIT_ATTRS_rec);
580:
581: END IF;
582:
583: END IF;

Line 1436: QP_Limit_Attrs_Util.Lock_Row

1432: FOR I IN 1..p_LIMIT_ATTRS_tbl.COUNT LOOP
1433:
1434: IF p_LIMIT_ATTRS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
1435:
1436: QP_Limit_Attrs_Util.Lock_Row
1437: ( p_LIMIT_ATTRS_rec => p_LIMIT_ATTRS_tbl(I)
1438: , x_LIMIT_ATTRS_rec => l_LIMIT_ATTRS_rec
1439: , x_return_status => l_return_status
1440: );

Line 1608: l_LIMIT_ATTRS_tbl := QP_Limit_Attrs_Util.Query_Rows

1604: );
1605:
1606: -- Get LIMIT_ATTRS ( parent = LIMITS )
1607:
1608: l_LIMIT_ATTRS_tbl := QP_Limit_Attrs_Util.Query_Rows
1609: ( p_limit_id => l_LIMITS_rec.limit_id
1610: );
1611:
1612: