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

Line 12: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_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_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_REC
15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
16: )

Line 13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_REC
15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_SOU_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_REC
15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_REC
15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 354: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

350:
351: -- Procedure Apply_Attribute_Changes
352:
353: PROCEDURE Apply_Attribute_Changes
354: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
355: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
356: QP_Attr_Map_PUB.G_MISS_SOU_REC
357: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
358: )

Line 355: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=

351: -- Procedure Apply_Attribute_Changes
352:
353: PROCEDURE Apply_Attribute_Changes
354: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
355: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
356: QP_Attr_Map_PUB.G_MISS_SOU_REC
357: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
358: )
359: IS

Line 356: QP_Attr_Map_PUB.G_MISS_SOU_REC

352:
353: PROCEDURE Apply_Attribute_Changes
354: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
355: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
356: QP_Attr_Map_PUB.G_MISS_SOU_REC
357: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
358: )
359: IS
360: BEGIN

Line 357: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type

353: PROCEDURE Apply_Attribute_Changes
354: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
355: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
356: QP_Attr_Map_PUB.G_MISS_SOU_REC
357: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
358: )
359: IS
360: BEGIN
361:

Line 547: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

543:
544: -- Function Complete_Record
545:
546: FUNCTION Complete_Record
547: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
548: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
550: IS
551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;

Line 548: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

544: -- Function Complete_Record
545:
546: FUNCTION Complete_Record
547: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
548: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
550: IS
551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
552: BEGIN

Line 549: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type

545:
546: FUNCTION Complete_Record
547: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
548: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
550: IS
551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
552: BEGIN
553:

Line 551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;

547: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
548: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
549: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
550: IS
551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
552: BEGIN
553:
554: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
555: l_SOU_rec.attribute1 := p_old_SOU_rec.attribute1;

Line 701: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

697:
698: -- Function Convert_Miss_To_Null
699:
700: FUNCTION Convert_Miss_To_Null
701: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
702: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
703: IS
704: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
705: BEGIN

Line 702: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type

698: -- Function Convert_Miss_To_Null
699:
700: FUNCTION Convert_Miss_To_Null
701: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
702: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
703: IS
704: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
705: BEGIN
706:

Line 704: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;

700: FUNCTION Convert_Miss_To_Null
701: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
702: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
703: IS
704: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
705: BEGIN
706:
707: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_SOU_rec.attribute1 := NULL;

Line 854: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

850:
851: -- Procedure Update_Row
852:
853: PROCEDURE Update_Row
854: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
855: )
856: IS
857: BEGIN
858:

Line 917: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

913:
914: -- Procedure Insert_Row
915:
916: PROCEDURE Insert_Row
917: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
918: )
919: IS
920: BEGIN
921:

Line 1045: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type

1041: -- Function Query_Row
1042:
1043: FUNCTION Query_Row
1044: ( p_attribute_sourcing_id IN NUMBER
1045: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1046: IS
1047: BEGIN
1048:
1049: RETURN Query_Rows

Line 1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type

1060: ( p_attribute_sourcing_id IN NUMBER :=
1061: FND_API.G_MISS_NUM
1062: , p_segment_pte_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type
1065: IS
1066: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1067: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1068:

Line 1066: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1062: , p_segment_pte_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type
1065: IS
1066: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1067: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1068:
1069: CURSOR l_SOU_csr IS
1070: SELECT ATTRIBUTE1

Line 1067: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1063: FND_API.G_MISS_NUM
1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type
1065: IS
1066: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1067: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1068:
1069: CURSOR l_SOU_csr IS
1070: SELECT ATTRIBUTE1
1071: , ATTRIBUTE10

Line 1223: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

1219: --
1220:
1221: PROCEDURE Lock_Row
1222: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1223: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1224: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
1225: )
1226: IS
1227: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1224: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type

1220:
1221: PROCEDURE Lock_Row
1222: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1223: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1224: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
1225: )
1226: IS
1227: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1228: BEGIN

Line 1227: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1223: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1224: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type
1225: )
1226: IS
1227: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1228: BEGIN
1229:
1230: SELECT ATTRIBUTE1
1231: , ATTRIBUTE10

Line 1448: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

1444:
1445: -- Function Get_Values
1446:
1447: FUNCTION Get_Values
1448: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
1450: QP_Attr_Map_PUB.G_MISS_SOU_REC
1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1452: IS

Line 1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=

1445: -- Function Get_Values
1446:
1447: FUNCTION Get_Values
1448: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
1450: QP_Attr_Map_PUB.G_MISS_SOU_REC
1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1452: IS
1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;

Line 1450: QP_Attr_Map_PUB.G_MISS_SOU_REC

1446:
1447: FUNCTION Get_Values
1448: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
1450: QP_Attr_Map_PUB.G_MISS_SOU_REC
1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1452: IS
1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
1454: BEGIN

Line 1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type

1447: FUNCTION Get_Values
1448: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
1450: QP_Attr_Map_PUB.G_MISS_SOU_REC
1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1452: IS
1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
1454: BEGIN
1455:

Line 1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;

1449: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
1450: QP_Attr_Map_PUB.G_MISS_SOU_REC
1451: ) RETURN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1452: IS
1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
1454: BEGIN
1455:
1456: IF p_SOU_rec.attribute_sourcing_id IS NOT NULL AND
1457: p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM AND

Line 1513: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

1509:
1510: -- Function Get_Ids
1511:
1512: FUNCTION Get_Ids
1513: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1514: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1515: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1516: IS
1517: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1514: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type

1510: -- Function Get_Ids
1511:
1512: FUNCTION Get_Ids
1513: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1514: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1515: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1516: IS
1517: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1518: BEGIN

Line 1515: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type

1511:
1512: FUNCTION Get_Ids
1513: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1514: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1515: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1516: IS
1517: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1518: BEGIN
1519:

Line 1517: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1513: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1514: , p_SOU_val_rec IN QP_Attr_Map_PUB.Sou_Val_Rec_Type
1515: ) RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1516: IS
1517: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1518: BEGIN
1519:
1520: -- initialize return_status.
1521: