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_RQT_UTIL dependencies on QP_ATTR_MAP_PUB

Line 12: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_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_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_RQT_REC
15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
16: )

Line 13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_RQT_REC
15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_RQT_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_RQT_REC
15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
13: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_RQT_REC
15: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 336: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

332:
333: -- Procedure Apply_Attribute_Changes
334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
337: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
338: QP_Attr_Map_PUB.G_MISS_RQT_REC
339: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
340: )

Line 337: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=

333: -- Procedure Apply_Attribute_Changes
334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
337: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
338: QP_Attr_Map_PUB.G_MISS_RQT_REC
339: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
340: )
341: IS

Line 338: QP_Attr_Map_PUB.G_MISS_RQT_REC

334:
335: PROCEDURE Apply_Attribute_Changes
336: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
337: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
338: QP_Attr_Map_PUB.G_MISS_RQT_REC
339: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
340: )
341: IS
342: BEGIN

Line 339: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type

335: PROCEDURE Apply_Attribute_Changes
336: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
337: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
338: QP_Attr_Map_PUB.G_MISS_RQT_REC
339: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
340: )
341: IS
342: BEGIN
343:

Line 518: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

514:
515: -- Function Complete_Record
516:
517: FUNCTION Complete_Record
518: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
519: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
520: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
521: IS
522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;

Line 519: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

515: -- Function Complete_Record
516:
517: FUNCTION Complete_Record
518: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
519: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
520: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
521: IS
522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
523: BEGIN

Line 520: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type

516:
517: FUNCTION Complete_Record
518: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
519: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
520: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
521: IS
522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
523: BEGIN
524:

Line 522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;

518: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
519: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
520: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
521: IS
522: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
523: BEGIN
524:
525: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_RQT_rec.attribute1 := p_old_RQT_rec.attribute1;

Line 664: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

660:
661: -- Function Convert_Miss_To_Null
662:
663: FUNCTION Convert_Miss_To_Null
664: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
665: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
666: IS
667: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
668: BEGIN

Line 665: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type

661: -- Function Convert_Miss_To_Null
662:
663: FUNCTION Convert_Miss_To_Null
664: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
665: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
666: IS
667: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
668: BEGIN
669:

Line 667: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;

663: FUNCTION Convert_Miss_To_Null
664: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
665: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
666: IS
667: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type := p_RQT_rec;
668: BEGIN
669:
670: IF l_RQT_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_RQT_rec.attribute1 := NULL;

Line 809: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

805:
806: -- Procedure Update_Row
807:
808: PROCEDURE Update_Row
809: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
810: )
811: IS
812: BEGIN
813:

Line 918: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

914:
915: -- Procedure Insert_Row
916:
917: PROCEDURE Insert_Row
918: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
919: )
920: IS
921: BEGIN
922:

Line 1149: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type

1145: -- Function Query_Row
1146:
1147: FUNCTION Query_Row
1148: ( p_request_type_code IN VARCHAR2
1149: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1150: IS
1151: BEGIN
1152:
1153: RETURN Query_Rows

Line 1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type

1164: ( p_request_type_code IN VARCHAR2 :=
1165: FND_API.G_MISS_CHAR
1166: , p_lookup_code IN VARCHAR2 :=
1167: FND_API.G_MISS_CHAR
1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type
1169: IS
1170: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1171: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1172:

Line 1170: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1166: , p_lookup_code IN VARCHAR2 :=
1167: FND_API.G_MISS_CHAR
1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type
1169: IS
1170: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1171: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1172:
1173: CURSOR l_RQT_csr IS
1174: SELECT ATTRIBUTE1

Line 1171: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1167: FND_API.G_MISS_CHAR
1168: ) RETURN QP_Attr_Map_PUB.Rqt_Tbl_Type
1169: IS
1170: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1171: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1172:
1173: CURSOR l_RQT_csr IS
1174: SELECT ATTRIBUTE1
1175: , ATTRIBUTE10

Line 1324: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

1320: --
1321:
1322: PROCEDURE Lock_Row
1323: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1324: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1325: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
1326: )
1327: IS
1328: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 1325: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type

1321:
1322: PROCEDURE Lock_Row
1323: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1324: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1325: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
1326: )
1327: IS
1328: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1329: BEGIN

Line 1328: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1324: , p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1325: , x_RQT_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Rec_Type
1326: )
1327: IS
1328: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1329: BEGIN
1330:
1331: SELECT ATTRIBUTE1
1332: , ATTRIBUTE10

Line 1541: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

1537:
1538: -- Function Get_Values
1539:
1540: FUNCTION Get_Values
1541: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
1543: QP_Attr_Map_PUB.G_MISS_RQT_REC
1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1545: IS

Line 1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=

1538: -- Function Get_Values
1539:
1540: FUNCTION Get_Values
1541: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
1543: QP_Attr_Map_PUB.G_MISS_RQT_REC
1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1545: IS
1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;

Line 1543: QP_Attr_Map_PUB.G_MISS_RQT_REC

1539:
1540: FUNCTION Get_Values
1541: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
1543: QP_Attr_Map_PUB.G_MISS_RQT_REC
1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1545: IS
1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
1547: BEGIN

Line 1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type

1540: FUNCTION Get_Values
1541: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
1543: QP_Attr_Map_PUB.G_MISS_RQT_REC
1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1545: IS
1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
1547: BEGIN
1548:

Line 1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;

1542: , p_old_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type :=
1543: QP_Attr_Map_PUB.G_MISS_RQT_REC
1544: ) RETURN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1545: IS
1546: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
1547: BEGIN
1548:
1549: IF p_RQT_rec.enabled_flag IS NOT NULL AND
1550: p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

Line 1596: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

1592:
1593: -- Function Get_Ids
1594:
1595: FUNCTION Get_Ids
1596: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1597: , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1598: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1599: IS
1600: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 1597: , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type

1593: -- Function Get_Ids
1594:
1595: FUNCTION Get_Ids
1596: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1597: , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1598: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1599: IS
1600: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1601: BEGIN

Line 1598: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type

1594:
1595: FUNCTION Get_Ids
1596: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1597: , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1598: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1599: IS
1600: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1601: BEGIN
1602:

Line 1600: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1596: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1597: , p_RQT_val_rec IN QP_Attr_Map_PUB.Rqt_Val_Rec_Type
1598: ) RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1599: IS
1600: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1601: BEGIN
1602:
1603: -- initialize return_status.
1604: