DBA Data[Home] [Help]

APPS.QP_QP_FORM_FORMULA dependencies on QP_GLOBALS

Line 66: l_control_rec QP_GLOBALS.Control_Rec_Type;

62: )
63: IS
64: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
65: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;
66: l_control_rec QP_GLOBALS.Control_Rec_Type;
67: l_return_status VARCHAR2(1);
68: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
69: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
70: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 113: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;

109: l_FORMULA_rec.context := NULL;
110:
111: -- Set Operation to Create
112:
113: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
114:
115: -- Call QP_Price_Formula_PVT.Process_Price_Formula
116:
117: QP_Price_Formula_PVT.Process_Price_Formula

Line 288: l_control_rec QP_GLOBALS.Control_Rec_Type;

284: IS
285: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
286: l_old_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
287: l_FORMULA_val_rec QP_Price_Formula_PUB.Formula_Val_Rec_Type;
288: l_control_rec QP_GLOBALS.Control_Rec_Type;
289: l_return_status VARCHAR2(1);
290: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
291: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
292: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 386: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

382:
383: -- Set Operation.
384:
385: IF FND_API.To_Boolean(l_FORMULA_rec.db_flag) THEN
386: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
387: ELSE
388: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
389: END IF;
390:

Line 388: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;

384:
385: IF FND_API.To_Boolean(l_FORMULA_rec.db_flag) THEN
386: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
387: ELSE
388: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
389: END IF;
390:
391: -- Call QP_Price_Formula_PVT.Process_Price_Formula
392:

Line 449: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute1,

445: );
446:
447: -- Return changed attributes.
448:
449: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute1,
450: l_FORMULA_rec.attribute1)
451: THEN
452: x_attribute1 := l_x_FORMULA_rec.attribute1;
453: END IF;

Line 455: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute10,

451: THEN
452: x_attribute1 := l_x_FORMULA_rec.attribute1;
453: END IF;
454:
455: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute10,
456: l_FORMULA_rec.attribute10)
457: THEN
458: x_attribute10 := l_x_FORMULA_rec.attribute10;
459: END IF;

Line 461: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute11,

457: THEN
458: x_attribute10 := l_x_FORMULA_rec.attribute10;
459: END IF;
460:
461: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute11,
462: l_FORMULA_rec.attribute11)
463: THEN
464: x_attribute11 := l_x_FORMULA_rec.attribute11;
465: END IF;

Line 467: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute12,

463: THEN
464: x_attribute11 := l_x_FORMULA_rec.attribute11;
465: END IF;
466:
467: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute12,
468: l_FORMULA_rec.attribute12)
469: THEN
470: x_attribute12 := l_x_FORMULA_rec.attribute12;
471: END IF;

Line 473: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute13,

469: THEN
470: x_attribute12 := l_x_FORMULA_rec.attribute12;
471: END IF;
472:
473: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute13,
474: l_FORMULA_rec.attribute13)
475: THEN
476: x_attribute13 := l_x_FORMULA_rec.attribute13;
477: END IF;

Line 479: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute14,

475: THEN
476: x_attribute13 := l_x_FORMULA_rec.attribute13;
477: END IF;
478:
479: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute14,
480: l_FORMULA_rec.attribute14)
481: THEN
482: x_attribute14 := l_x_FORMULA_rec.attribute14;
483: END IF;

Line 485: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute15,

481: THEN
482: x_attribute14 := l_x_FORMULA_rec.attribute14;
483: END IF;
484:
485: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute15,
486: l_FORMULA_rec.attribute15)
487: THEN
488: x_attribute15 := l_x_FORMULA_rec.attribute15;
489: END IF;

Line 491: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute2,

487: THEN
488: x_attribute15 := l_x_FORMULA_rec.attribute15;
489: END IF;
490:
491: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute2,
492: l_FORMULA_rec.attribute2)
493: THEN
494: x_attribute2 := l_x_FORMULA_rec.attribute2;
495: END IF;

Line 497: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute3,

493: THEN
494: x_attribute2 := l_x_FORMULA_rec.attribute2;
495: END IF;
496:
497: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute3,
498: l_FORMULA_rec.attribute3)
499: THEN
500: x_attribute3 := l_x_FORMULA_rec.attribute3;
501: END IF;

Line 503: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute4,

499: THEN
500: x_attribute3 := l_x_FORMULA_rec.attribute3;
501: END IF;
502:
503: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute4,
504: l_FORMULA_rec.attribute4)
505: THEN
506: x_attribute4 := l_x_FORMULA_rec.attribute4;
507: END IF;

Line 509: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute5,

505: THEN
506: x_attribute4 := l_x_FORMULA_rec.attribute4;
507: END IF;
508:
509: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute5,
510: l_FORMULA_rec.attribute5)
511: THEN
512: x_attribute5 := l_x_FORMULA_rec.attribute5;
513: END IF;

Line 515: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute6,

511: THEN
512: x_attribute5 := l_x_FORMULA_rec.attribute5;
513: END IF;
514:
515: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute6,
516: l_FORMULA_rec.attribute6)
517: THEN
518: x_attribute6 := l_x_FORMULA_rec.attribute6;
519: END IF;

Line 521: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute7,

517: THEN
518: x_attribute6 := l_x_FORMULA_rec.attribute6;
519: END IF;
520:
521: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute7,
522: l_FORMULA_rec.attribute7)
523: THEN
524: x_attribute7 := l_x_FORMULA_rec.attribute7;
525: END IF;

Line 527: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute8,

523: THEN
524: x_attribute7 := l_x_FORMULA_rec.attribute7;
525: END IF;
526:
527: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute8,
528: l_FORMULA_rec.attribute8)
529: THEN
530: x_attribute8 := l_x_FORMULA_rec.attribute8;
531: END IF;

Line 533: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute9,

529: THEN
530: x_attribute8 := l_x_FORMULA_rec.attribute8;
531: END IF;
532:
533: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.attribute9,
534: l_FORMULA_rec.attribute9)
535: THEN
536: x_attribute9 := l_x_FORMULA_rec.attribute9;
537: END IF;

Line 539: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.context,

535: THEN
536: x_attribute9 := l_x_FORMULA_rec.attribute9;
537: END IF;
538:
539: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.context,
540: l_FORMULA_rec.context)
541: THEN
542: x_context := l_x_FORMULA_rec.context;
543: END IF;

Line 545: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.description,

541: THEN
542: x_context := l_x_FORMULA_rec.context;
543: END IF;
544:
545: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.description,
546: l_FORMULA_rec.description)
547: THEN
548: x_description := l_x_FORMULA_rec.description;
549: END IF;

Line 551: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.end_date_active,

547: THEN
548: x_description := l_x_FORMULA_rec.description;
549: END IF;
550:
551: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.end_date_active,
552: l_FORMULA_rec.end_date_active)
553: THEN
554: x_end_date_active := l_x_FORMULA_rec.end_date_active;
555: END IF;

Line 557: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.formula,

553: THEN
554: x_end_date_active := l_x_FORMULA_rec.end_date_active;
555: END IF;
556:
557: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.formula,
558: l_FORMULA_rec.formula)
559: THEN
560: x_formula := l_x_FORMULA_rec.formula;
561: END IF;

Line 563: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.name,

559: THEN
560: x_formula := l_x_FORMULA_rec.formula;
561: END IF;
562:
563: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.name,
564: l_FORMULA_rec.name)
565: THEN
566: x_name := l_x_FORMULA_rec.name;
567: END IF;

Line 569: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.price_formula_id,

565: THEN
566: x_name := l_x_FORMULA_rec.name;
567: END IF;
568:
569: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.price_formula_id,
570: l_FORMULA_rec.price_formula_id)
571: THEN
572: x_price_formula_id := l_x_FORMULA_rec.price_formula_id;
573: x_price_formula := l_FORMULA_val_rec.price_formula;

Line 576: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.start_date_active,

572: x_price_formula_id := l_x_FORMULA_rec.price_formula_id;
573: x_price_formula := l_FORMULA_val_rec.price_formula;
574: END IF;
575:
576: IF NOT QP_GLOBALS.Equal(l_x_FORMULA_rec.start_date_active,
577: l_FORMULA_rec.start_date_active)
578: THEN
579: x_start_date_active := l_x_FORMULA_rec.start_date_active;
580: END IF;

Line 663: l_control_rec QP_GLOBALS.Control_Rec_Type;

659: )
660: IS
661: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
662: l_old_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
663: l_control_rec QP_GLOBALS.Control_Rec_Type;
664: l_return_status VARCHAR2(1);
665: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
666: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
667: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 700: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

696:
697: -- Set Operation.
698:
699: IF FND_API.To_Boolean(l_FORMULA_rec.db_flag) THEN
700: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
701: ELSE
702: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
703: END IF;
704:

Line 702: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;

698:
699: IF FND_API.To_Boolean(l_FORMULA_rec.db_flag) THEN
700: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
701: ELSE
702: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_CREATE;
703: END IF;
704:
705: -- Call QP_Price_Formula_PVT.Process_Price_Formula
706:

Line 813: l_control_rec QP_GLOBALS.Control_Rec_Type;

809: , p_price_formula_id IN NUMBER
810: )
811: IS
812: l_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
813: l_control_rec QP_GLOBALS.Control_Rec_Type;
814: l_return_status VARCHAR2(1);
815: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
816: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
817: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 844: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_DELETE;

840: );
841:
842: -- Set Operation.
843:
844: l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_DELETE;
845:
846: -- Call QP_Price_Formula_PVT.Process_Price_Formula
847:
848: QP_Price_Formula_PVT.Process_Price_Formula

Line 937: l_control_rec QP_GLOBALS.Control_Rec_Type;

933: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
934: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
935: )
936: IS
937: l_control_rec QP_GLOBALS.Control_Rec_Type;
938: l_return_status VARCHAR2(1);
939: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
940: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
941: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 948: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_FORMULA;

944: -- Set control flags.
945:
946: l_control_rec.controlled_operation := TRUE;
947: l_control_rec.process := TRUE;
948: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_FORMULA;
949:
950: l_control_rec.default_attributes := FALSE;
951: l_control_rec.change_attributes := FALSE;
952: l_control_rec.validate_entity := FALSE;

Line 1046: l_control_rec QP_GLOBALS.Control_Rec_Type;

1042: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1043: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1044: )
1045: IS
1046: l_control_rec QP_GLOBALS.Control_Rec_Type;
1047: l_return_status VARCHAR2(1);
1048: l_x_FORMULA_rec QP_Price_Formula_PUB.Formula_Rec_Type;
1049: l_x_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1050: l_x_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 1057: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_ALL;

1053: -- Set control flags.
1054:
1055: l_control_rec.controlled_operation := TRUE;
1056: l_control_rec.process := TRUE;
1057: l_control_rec.process_entity := QP_GLOBALS.G_ENTITY_ALL;
1058:
1059: l_control_rec.default_attributes := FALSE;
1060: l_control_rec.change_attributes := FALSE;
1061: l_control_rec.validate_entity := FALSE;

Line 1221: -- l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_LOCK;

1217: l_FORMULA_rec.start_date_active := p_start_date_active;
1218:
1219: -- Call QP_Price_Formula_PVT.Lock_Price_Formula
1220:
1221: -- l_FORMULA_rec.operation := QP_GLOBALS.G_OPR_LOCK;
1222:
1223: QP_Price_Formula_PVT.Lock_Price_Formula
1224: ( p_api_version_number => 1.0
1225: , p_init_msg_list => FND_API.G_TRUE