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.QP_LIMIT_ATTRS_UTIL dependencies on QP_LIMITS

Line 12: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
16: )

Line 13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
16: )
17: IS

Line 14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
13: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
14: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
15: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 338: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

334:
335: -- Procedure Apply_Attribute_Changes
336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
339: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
340: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
341: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
342: )

Line 339: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

335: -- Procedure Apply_Attribute_Changes
336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
339: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
340: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
341: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
342: )
343: IS

Line 340: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

336:
337: PROCEDURE Apply_Attribute_Changes
338: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
339: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
340: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
341: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
342: )
343: IS
344: BEGIN

Line 341: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

337: PROCEDURE Apply_Attribute_Changes
338: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
339: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
340: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
341: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
342: )
343: IS
344: BEGIN
345:

Line 520: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

516:
517: -- Function Complete_Record
518:
519: FUNCTION Complete_Record
520: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
521: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
522: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
523: IS
524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;

Line 521: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

517: -- Function Complete_Record
518:
519: FUNCTION Complete_Record
520: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
521: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
522: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
523: IS
524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
525: BEGIN

Line 522: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type

518:
519: FUNCTION Complete_Record
520: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
521: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
522: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
523: IS
524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
525: BEGIN
526:

Line 524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;

520: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
521: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
522: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
523: IS
524: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
525: BEGIN
526:
527: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: l_LIMIT_ATTRS_rec.attribute1 := p_old_LIMIT_ATTRS_rec.attribute1;

Line 666: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

662:
663: -- Function Convert_Miss_To_Null
664:
665: FUNCTION Convert_Miss_To_Null
666: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
667: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
668: IS
669: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
670: BEGIN

Line 667: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type

663: -- Function Convert_Miss_To_Null
664:
665: FUNCTION Convert_Miss_To_Null
666: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
667: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
668: IS
669: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
670: BEGIN
671:

Line 669: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;

665: FUNCTION Convert_Miss_To_Null
666: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
667: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
668: IS
669: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
670: BEGIN
671:
672: IF l_LIMIT_ATTRS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
673: l_LIMIT_ATTRS_rec.attribute1 := NULL;

Line 811: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

807:
808: -- Procedure Update_Row
809:
810: PROCEDURE Update_Row
811: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
812: )
813: IS
814: l_check_active_flag VARCHAR2(1);
815: l_active_flag VARCHAR2(1);

Line 819: FROM QP_LIMITS a,QP_LIST_HEADERS_B b

815: l_active_flag VARCHAR2(1);
816: BEGIN
817: SELECT active_flag
818: INTO l_active_flag
819: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
820: WHERE a.limit_id=p_LIMIT_ATTRS_rec.limit_id
821: AND b.list_header_id=a.list_header_id;
822:
823:

Line 897: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

893:
894: -- Procedure Insert_Row
895:
896: PROCEDURE Insert_Row
897: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
898: )
899: IS
900: l_check_active_flag VARCHAR2(1);
901: l_active_flag VARCHAR2(1);

Line 906: FROM QP_LIMITS a,QP_LIST_HEADERS_B b

902:
903: BEGIN
904: SELECT active_flag
905: INTO l_active_flag
906: FROM QP_LIMITS a,QP_LIST_HEADERS_B b
907: WHERE a.limit_id=p_LIMIT_ATTRS_rec.limit_id
908: AND b.list_header_id=a.list_header_id;
909:
910: INSERT INTO QP_LIMIT_ATTRIBUTES

Line 1047: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type

1043: -- Function Query_Row
1044:
1045: FUNCTION Query_Row
1046: ( p_limit_attribute_id IN NUMBER
1047: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1048: IS
1049: BEGIN
1050:
1051: RETURN Query_Rows

Line 1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type

1062: ( p_limit_attribute_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: , p_limit_id IN NUMBER :=
1065: FND_API.G_MISS_NUM
1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type
1067: IS
1068: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1069: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1070:

Line 1068: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1064: , p_limit_id IN NUMBER :=
1065: FND_API.G_MISS_NUM
1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type
1067: IS
1068: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1069: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1070:
1071: CURSOR l_LIMIT_ATTRS_csr IS
1072: SELECT ATTRIBUTE1

Line 1069: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1065: FND_API.G_MISS_NUM
1066: ) RETURN QP_Limits_PUB.Limit_Attrs_Tbl_Type
1067: IS
1068: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1069: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1070:
1071: CURSOR l_LIMIT_ATTRS_csr IS
1072: SELECT ATTRIBUTE1
1073: , ATTRIBUTE10

Line 1221: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1217: --
1218:
1219: PROCEDURE Lock_Row
1220: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1221: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1222: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1223: )
1224: IS
1225: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 1222: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

1218:
1219: PROCEDURE Lock_Row
1220: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1221: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1222: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1223: )
1224: IS
1225: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1226: BEGIN

Line 1225: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1221: , p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1222: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1223: )
1224: IS
1225: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1226: BEGIN
1227:
1228: SELECT ATTRIBUTE1
1229: , ATTRIBUTE10

Line 1438: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1434:
1435: -- Function Get_Values
1436:
1437: FUNCTION Get_Values
1438: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1442: IS

Line 1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

1435: -- Function Get_Values
1436:
1437: FUNCTION Get_Values
1438: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1442: IS
1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;

Line 1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

1436:
1437: FUNCTION Get_Values
1438: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1442: IS
1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
1444: BEGIN

Line 1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type

1437: FUNCTION Get_Values
1438: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1442: IS
1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
1444: BEGIN
1445:

Line 1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;

1439: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1440: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1441: ) RETURN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1442: IS
1443: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
1444: BEGIN
1445:
1446: IF p_LIMIT_ATTRS_rec.comparison_operator_code IS NOT NULL AND
1447: p_LIMIT_ATTRS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND

Line 1483: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1479:
1480: -- Function Get_Ids
1481:
1482: FUNCTION Get_Ids
1483: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1484: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1485: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1486: IS
1487: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 1484: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type

1480: -- Function Get_Ids
1481:
1482: FUNCTION Get_Ids
1483: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1484: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1485: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1486: IS
1487: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1488: BEGIN

Line 1485: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type

1481:
1482: FUNCTION Get_Ids
1483: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1484: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1485: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1486: IS
1487: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1488: BEGIN
1489:

Line 1487: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1483: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1484: , p_LIMIT_ATTRS_val_rec IN QP_Limits_PUB.Limit_Attrs_Val_Rec_Type
1485: ) RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1486: IS
1487: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1488: BEGIN
1489:
1490: -- initialize return_status.
1491:

Line 1594: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1590:
1591: END Get_Ids;
1592:
1593: Procedure Pre_Write_Process
1594: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1595: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1596: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1598: )

Line 1595: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=

1591: END Get_Ids;
1592:
1593: Procedure Pre_Write_Process
1594: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1595: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1596: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1598: )
1599: IS

Line 1596: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC

1592:
1593: Procedure Pre_Write_Process
1594: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1595: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1596: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1598: )
1599: IS
1600:

Line 1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type

1593: Procedure Pre_Write_Process
1594: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1595: , p_old_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type :=
1596: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC
1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1598: )
1599: IS
1600:
1601: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;

Line 1601: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;

1597: , x_LIMIT_ATTRS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Rec_Type
1598: )
1599: IS
1600:
1601: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type := p_LIMIT_ATTRS_rec;
1602: l_return_status varchar2(30);
1603:
1604: BEGIN
1605: