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

Line 12: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_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_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PSG_REC
15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )

Line 13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PSG_REC
15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_PSG_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PSG_REC
15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PSG_REC
15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 345: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

341:
342: -- Procedure Apply_Attribute_Changes
343:
344: PROCEDURE Apply_Attribute_Changes
345: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
346: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
347: QP_Attr_Map_PUB.G_MISS_PSG_REC
348: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
349: )

Line 346: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

342: -- Procedure Apply_Attribute_Changes
343:
344: PROCEDURE Apply_Attribute_Changes
345: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
346: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
347: QP_Attr_Map_PUB.G_MISS_PSG_REC
348: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
349: )
350: IS

Line 347: QP_Attr_Map_PUB.G_MISS_PSG_REC

343:
344: PROCEDURE Apply_Attribute_Changes
345: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
346: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
347: QP_Attr_Map_PUB.G_MISS_PSG_REC
348: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
349: )
350: IS
351: BEGIN

Line 348: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

344: PROCEDURE Apply_Attribute_Changes
345: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
346: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
347: QP_Attr_Map_PUB.G_MISS_PSG_REC
348: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
349: )
350: IS
351: BEGIN
352:

Line 532: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

528:
529: -- Function Complete_Record
530:
531: FUNCTION Complete_Record
532: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
533: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
534: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
535: IS
536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;

Line 533: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

529: -- Function Complete_Record
530:
531: FUNCTION Complete_Record
532: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
533: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
534: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
535: IS
536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
537: BEGIN

Line 534: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type

530:
531: FUNCTION Complete_Record
532: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
533: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
534: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
535: IS
536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
537: BEGIN
538:

Line 536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;

532: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
533: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
534: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
535: IS
536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
537: BEGIN
538:
539: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
540: l_PSG_rec.attribute1 := p_old_PSG_rec.attribute1;

Line 682: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

678:
679: -- Function Convert_Miss_To_Null
680:
681: FUNCTION Convert_Miss_To_Null
682: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
683: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
684: IS
685: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
686: BEGIN

Line 683: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type

679: -- Function Convert_Miss_To_Null
680:
681: FUNCTION Convert_Miss_To_Null
682: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
683: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
684: IS
685: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
686: BEGIN
687:

Line 685: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;

681: FUNCTION Convert_Miss_To_Null
682: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
683: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
684: IS
685: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
686: BEGIN
687:
688: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
689: l_PSG_rec.attribute1 := NULL;

Line 831: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

827:
828: -- Procedure Update_Row
829:
830: PROCEDURE Update_Row
831: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
832: )
833: IS
834: BEGIN
835:

Line 893: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

889:
890: -- Procedure Insert_Row
891:
892: PROCEDURE Insert_Row
893: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
894: )
895: IS
896: BEGIN
897: oe_debug_pub.add('inserting data in psg ..............................');

Line 1020: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type

1016: -- Function Query_Row
1017:
1018: FUNCTION Query_Row
1019: ( p_segment_pte_id IN NUMBER
1020: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1021: IS
1022: BEGIN
1023:
1024: RETURN Query_Rows

Line 1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type

1035: ( p_segment_pte_id IN NUMBER :=
1036: FND_API.G_MISS_NUM
1037: , p_lookup_code IN VARCHAR2 :=
1038: FND_API.G_MISS_CHAR
1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type
1040: IS
1041: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1042: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1043:

Line 1041: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1037: , p_lookup_code IN VARCHAR2 :=
1038: FND_API.G_MISS_CHAR
1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type
1040: IS
1041: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1042: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1043:
1044: CURSOR l_PSG_csr IS
1045: SELECT ATTRIBUTE1

Line 1042: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1038: FND_API.G_MISS_CHAR
1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type
1040: IS
1041: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1042: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1043:
1044: CURSOR l_PSG_csr IS
1045: SELECT ATTRIBUTE1
1046: , ATTRIBUTE10

Line 1197: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

1193: --
1194:
1195: PROCEDURE Lock_Row
1196: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1198: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
1199: )
1200: IS
1201: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1198: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type

1194:
1195: PROCEDURE Lock_Row
1196: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1197: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1198: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
1199: )
1200: IS
1201: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1202: BEGIN

Line 1201: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1197: , p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1198: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Rec_Type
1199: )
1200: IS
1201: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1202: BEGIN
1203:
1204: SELECT ATTRIBUTE1
1205: , ATTRIBUTE10

Line 1418: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

1414:
1415: -- Function Get_Values
1416:
1417: FUNCTION Get_Values
1418: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
1420: QP_Attr_Map_PUB.G_MISS_PSG_REC
1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1422: IS

Line 1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=

1415: -- Function Get_Values
1416:
1417: FUNCTION Get_Values
1418: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
1420: QP_Attr_Map_PUB.G_MISS_PSG_REC
1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1422: IS
1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;

Line 1420: QP_Attr_Map_PUB.G_MISS_PSG_REC

1416:
1417: FUNCTION Get_Values
1418: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
1420: QP_Attr_Map_PUB.G_MISS_PSG_REC
1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1422: IS
1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
1424: BEGIN

Line 1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type

1417: FUNCTION Get_Values
1418: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
1420: QP_Attr_Map_PUB.G_MISS_PSG_REC
1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1422: IS
1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
1424: BEGIN
1425:

Line 1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;

1419: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
1420: QP_Attr_Map_PUB.G_MISS_PSG_REC
1421: ) RETURN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1422: IS
1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
1424: BEGIN
1425:
1426: IF p_PSG_rec.pte_code IS NOT NULL AND
1427: p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR AND

Line 1463: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

1459:
1460: -- Function Get_Ids
1461:
1462: FUNCTION Get_Ids
1463: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1464: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1465: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1466: IS
1467: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1464: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type

1460: -- Function Get_Ids
1461:
1462: FUNCTION Get_Ids
1463: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1464: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1465: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1466: IS
1467: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1468: BEGIN

Line 1465: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type

1461:
1462: FUNCTION Get_Ids
1463: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1464: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1465: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1466: IS
1467: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1468: BEGIN
1469:

Line 1467: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1463: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1464: , p_PSG_val_rec IN QP_Attr_Map_PUB.Psg_Val_Rec_Type
1465: ) RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1466: IS
1467: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1468: BEGIN
1469:
1470: -- initialize return_status.
1471: