DBA Data[Home] [Help]

APPS.QP_QP_FORM_LIMIT_ATTRS dependencies on QP_GLOBALS

Line 70: l_control_rec QP_GLOBALS.Control_Rec_Type;

66: IS
67: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 119: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;

115: l_LIMIT_ATTRS_rec.context := NULL;
116:
117: -- Set Operation to Create
118:
119: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
120:
121: -- Populate LIMIT_ATTRS table
122:
123: l_LIMIT_ATTRS_tbl(1) := l_LIMIT_ATTRS_rec;

Line 311: l_control_rec QP_GLOBALS.Control_Rec_Type;

307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 415: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

411:
412: -- Set Operation.
413:
414: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
415: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
416: ELSE
417: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
418: END IF;
419:

Line 417: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;

413:
414: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
415: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
416: ELSE
417: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
418: END IF;
419:
420: -- Populate LIMIT_ATTRS table
421:

Line 491: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute1,

487: );
488:
489: -- Return changed attributes.
490:
491: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute1,
492: l_LIMIT_ATTRS_rec.attribute1)
493: THEN
494: x_attribute1 := l_x_LIMIT_ATTRS_rec.attribute1;
495: END IF;

Line 497: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute10,

493: THEN
494: x_attribute1 := l_x_LIMIT_ATTRS_rec.attribute1;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute10,
498: l_LIMIT_ATTRS_rec.attribute10)
499: THEN
500: x_attribute10 := l_x_LIMIT_ATTRS_rec.attribute10;
501: END IF;

Line 503: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute11,

499: THEN
500: x_attribute10 := l_x_LIMIT_ATTRS_rec.attribute10;
501: END IF;
502:
503: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute11,
504: l_LIMIT_ATTRS_rec.attribute11)
505: THEN
506: x_attribute11 := l_x_LIMIT_ATTRS_rec.attribute11;
507: END IF;

Line 509: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute12,

505: THEN
506: x_attribute11 := l_x_LIMIT_ATTRS_rec.attribute11;
507: END IF;
508:
509: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute12,
510: l_LIMIT_ATTRS_rec.attribute12)
511: THEN
512: x_attribute12 := l_x_LIMIT_ATTRS_rec.attribute12;
513: END IF;

Line 515: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute13,

511: THEN
512: x_attribute12 := l_x_LIMIT_ATTRS_rec.attribute12;
513: END IF;
514:
515: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute13,
516: l_LIMIT_ATTRS_rec.attribute13)
517: THEN
518: x_attribute13 := l_x_LIMIT_ATTRS_rec.attribute13;
519: END IF;

Line 521: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute14,

517: THEN
518: x_attribute13 := l_x_LIMIT_ATTRS_rec.attribute13;
519: END IF;
520:
521: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute14,
522: l_LIMIT_ATTRS_rec.attribute14)
523: THEN
524: x_attribute14 := l_x_LIMIT_ATTRS_rec.attribute14;
525: END IF;

Line 527: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute15,

523: THEN
524: x_attribute14 := l_x_LIMIT_ATTRS_rec.attribute14;
525: END IF;
526:
527: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute15,
528: l_LIMIT_ATTRS_rec.attribute15)
529: THEN
530: x_attribute15 := l_x_LIMIT_ATTRS_rec.attribute15;
531: END IF;

Line 533: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute2,

529: THEN
530: x_attribute15 := l_x_LIMIT_ATTRS_rec.attribute15;
531: END IF;
532:
533: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute2,
534: l_LIMIT_ATTRS_rec.attribute2)
535: THEN
536: x_attribute2 := l_x_LIMIT_ATTRS_rec.attribute2;
537: END IF;

Line 539: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute3,

535: THEN
536: x_attribute2 := l_x_LIMIT_ATTRS_rec.attribute2;
537: END IF;
538:
539: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute3,
540: l_LIMIT_ATTRS_rec.attribute3)
541: THEN
542: x_attribute3 := l_x_LIMIT_ATTRS_rec.attribute3;
543: END IF;

Line 545: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute4,

541: THEN
542: x_attribute3 := l_x_LIMIT_ATTRS_rec.attribute3;
543: END IF;
544:
545: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute4,
546: l_LIMIT_ATTRS_rec.attribute4)
547: THEN
548: x_attribute4 := l_x_LIMIT_ATTRS_rec.attribute4;
549: END IF;

Line 551: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute5,

547: THEN
548: x_attribute4 := l_x_LIMIT_ATTRS_rec.attribute4;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute5,
552: l_LIMIT_ATTRS_rec.attribute5)
553: THEN
554: x_attribute5 := l_x_LIMIT_ATTRS_rec.attribute5;
555: END IF;

Line 557: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute6,

553: THEN
554: x_attribute5 := l_x_LIMIT_ATTRS_rec.attribute5;
555: END IF;
556:
557: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute6,
558: l_LIMIT_ATTRS_rec.attribute6)
559: THEN
560: x_attribute6 := l_x_LIMIT_ATTRS_rec.attribute6;
561: END IF;

Line 563: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute7,

559: THEN
560: x_attribute6 := l_x_LIMIT_ATTRS_rec.attribute6;
561: END IF;
562:
563: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute7,
564: l_LIMIT_ATTRS_rec.attribute7)
565: THEN
566: x_attribute7 := l_x_LIMIT_ATTRS_rec.attribute7;
567: END IF;

Line 569: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute8,

565: THEN
566: x_attribute7 := l_x_LIMIT_ATTRS_rec.attribute7;
567: END IF;
568:
569: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute8,
570: l_LIMIT_ATTRS_rec.attribute8)
571: THEN
572: x_attribute8 := l_x_LIMIT_ATTRS_rec.attribute8;
573: END IF;

Line 575: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute9,

571: THEN
572: x_attribute8 := l_x_LIMIT_ATTRS_rec.attribute8;
573: END IF;
574:
575: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.attribute9,
576: l_LIMIT_ATTRS_rec.attribute9)
577: THEN
578: x_attribute9 := l_x_LIMIT_ATTRS_rec.attribute9;
579: END IF;

Line 581: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.comparison_operator_code,

577: THEN
578: x_attribute9 := l_x_LIMIT_ATTRS_rec.attribute9;
579: END IF;
580:
581: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.comparison_operator_code,
582: l_LIMIT_ATTRS_rec.comparison_operator_code)
583: THEN
584: x_comparison_operator_code := l_x_LIMIT_ATTRS_rec.comparison_operator_code;
585: x_comparison_operator := l_LIMIT_ATTRS_val_rec.comparison_operator;

Line 588: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.context,

584: x_comparison_operator_code := l_x_LIMIT_ATTRS_rec.comparison_operator_code;
585: x_comparison_operator := l_LIMIT_ATTRS_val_rec.comparison_operator;
586: END IF;
587:
588: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.context,
589: l_LIMIT_ATTRS_rec.context)
590: THEN
591: x_context := l_x_LIMIT_ATTRS_rec.context;
592: END IF;

Line 594: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute,

590: THEN
591: x_context := l_x_LIMIT_ATTRS_rec.context;
592: END IF;
593:
594: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute,
595: l_LIMIT_ATTRS_rec.limit_attribute)
596: THEN
597: x_limit_attribute := l_x_LIMIT_ATTRS_rec.limit_attribute;
598: END IF;

Line 600: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_context,

596: THEN
597: x_limit_attribute := l_x_LIMIT_ATTRS_rec.limit_attribute;
598: END IF;
599:
600: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_context,
601: l_LIMIT_ATTRS_rec.limit_attribute_context)
602: THEN
603: x_limit_attribute_context := l_x_LIMIT_ATTRS_rec.limit_attribute_context;
604: END IF;

Line 606: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_id,

602: THEN
603: x_limit_attribute_context := l_x_LIMIT_ATTRS_rec.limit_attribute_context;
604: END IF;
605:
606: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_id,
607: l_LIMIT_ATTRS_rec.limit_attribute_id)
608: THEN
609: x_limit_attribute_id := l_x_LIMIT_ATTRS_rec.limit_attribute_id;
610: x_limit_attribute := l_LIMIT_ATTRS_val_rec.limit_attribute;

Line 613: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_type,

609: x_limit_attribute_id := l_x_LIMIT_ATTRS_rec.limit_attribute_id;
610: x_limit_attribute := l_LIMIT_ATTRS_val_rec.limit_attribute;
611: END IF;
612:
613: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attribute_type,
614: l_LIMIT_ATTRS_rec.limit_attribute_type)
615: THEN
616: x_limit_attribute_type := l_x_LIMIT_ATTRS_rec.limit_attribute_type;
617: END IF;

Line 619: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attr_datatype,

615: THEN
616: x_limit_attribute_type := l_x_LIMIT_ATTRS_rec.limit_attribute_type;
617: END IF;
618:
619: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attr_datatype,
620: l_LIMIT_ATTRS_rec.limit_attr_datatype)
621: THEN
622: x_limit_attr_datatype := l_x_LIMIT_ATTRS_rec.limit_attr_datatype;
623: END IF;

Line 625: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attr_value,

621: THEN
622: x_limit_attr_datatype := l_x_LIMIT_ATTRS_rec.limit_attr_datatype;
623: END IF;
624:
625: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_attr_value,
626: l_LIMIT_ATTRS_rec.limit_attr_value)
627: THEN
628: x_limit_attr_value := l_x_LIMIT_ATTRS_rec.limit_attr_value;
629: END IF;

Line 631: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_id,

627: THEN
628: x_limit_attr_value := l_x_LIMIT_ATTRS_rec.limit_attr_value;
629: END IF;
630:
631: IF NOT QP_GLOBALS.Equal(l_x_LIMIT_ATTRS_rec.limit_id,
632: l_LIMIT_ATTRS_rec.limit_id)
633: THEN
634: x_limit_id := l_x_LIMIT_ATTRS_rec.limit_id;
635: x_limit := l_LIMIT_ATTRS_val_rec.limit;

Line 721: l_control_rec QP_GLOBALS.Control_Rec_Type;

717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 760: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

756:
757: -- Set Operation.
758:
759: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
760: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
761: ELSE
762: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
763: END IF;
764:

Line 762: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;

758:
759: IF FND_API.To_Boolean(l_LIMIT_ATTRS_rec.db_flag) THEN
760: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
761: ELSE
762: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
763: END IF;
764:
765: -- Populate LIMIT_ATTRS table
766:

Line 881: l_control_rec QP_GLOBALS.Control_Rec_Type;

877: )
878: IS
879: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 914: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_DELETE;

910: );
911:
912: -- Set Operation.
913:
914: l_LIMIT_ATTRS_rec.operation := QP_GLOBALS.G_OPR_DELETE;
915:
916: -- Populate LIMIT_ATTRS table
917:
918: l_LIMIT_ATTRS_tbl(1) := l_LIMIT_ATTRS_rec;

Line 1012: l_control_rec QP_GLOBALS.Control_Rec_Type;

1008: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1009: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1010: )
1011: IS
1012: l_control_rec QP_GLOBALS.Control_Rec_Type;
1013: l_return_status VARCHAR2(1);
1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1025: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_LIMIT_ATTRS;

1021: -- Set control flags.
1022:
1023: l_control_rec.controlled_operation := TRUE;
1024: l_control_rec.process := TRUE;
1025: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_LIMIT_ATTRS;
1026:
1027: l_control_rec.default_attributes := FALSE;
1028: l_control_rec.change_attributes := FALSE;
1029: l_control_rec.validate_entity := FALSE;