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

Line 12: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_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_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SSC_REC
15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
16: )

Line 13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SSC_REC
15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
16: )
17: IS

Line 14: QP_Attr_Map_PUB.G_MISS_SSC_REC

10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SSC_REC
15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;

Line 15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
13: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SSC_REC
15: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 291: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

287:
288: -- Procedure Apply_Attribute_Changes
289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
292: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
293: QP_Attr_Map_PUB.G_MISS_SSC_REC
294: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
295: )

Line 292: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

288: -- Procedure Apply_Attribute_Changes
289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
292: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
293: QP_Attr_Map_PUB.G_MISS_SSC_REC
294: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
295: )
296: IS

Line 293: QP_Attr_Map_PUB.G_MISS_SSC_REC

289:
290: PROCEDURE Apply_Attribute_Changes
291: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
292: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
293: QP_Attr_Map_PUB.G_MISS_SSC_REC
294: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
295: )
296: IS
297: BEGIN

Line 294: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

290: PROCEDURE Apply_Attribute_Changes
291: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
292: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
293: QP_Attr_Map_PUB.G_MISS_SSC_REC
294: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
295: )
296: IS
297: BEGIN
298:

Line 448: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

444:
445: -- Function Complete_Record
446:
447: FUNCTION Complete_Record
448: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
449: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
450: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
451: IS
452: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;

Line 449: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

445: -- Function Complete_Record
446:
447: FUNCTION Complete_Record
448: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
449: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
450: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
451: IS
452: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
453: BEGIN

Line 450: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type

446:
447: FUNCTION Complete_Record
448: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
449: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
450: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
451: IS
452: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
453: BEGIN
454:

Line 452: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;

448: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
449: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
450: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
451: IS
452: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
453: BEGIN
454:
455: IF l_SSC_rec.application_short_name = FND_API.G_MISS_CHAR THEN
456: l_SSC_rec.application_short_name := p_old_SSC_rec.application_short_name;

Line 574: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

570:
571: -- Function Convert_Miss_To_Null
572:
573: FUNCTION Convert_Miss_To_Null
574: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
575: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
576: IS
577: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
578: BEGIN

Line 575: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type

571: -- Function Convert_Miss_To_Null
572:
573: FUNCTION Convert_Miss_To_Null
574: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
575: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
576: IS
577: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
578: BEGIN
579:

Line 577: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;

573: FUNCTION Convert_Miss_To_Null
574: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
575: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
576: IS
577: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type := p_SSC_rec;
578: BEGIN
579:
580: IF l_SSC_rec.application_short_name = FND_API.G_MISS_CHAR THEN
581: l_SSC_rec.application_short_name := NULL;

Line 699: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

695:
696: -- Procedure Update_Row
697:
698: PROCEDURE Update_Row
699: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
700: )
701: IS
702: BEGIN
703:

Line 755: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

751:
752: -- Procedure Insert_Row
753:
754: PROCEDURE Insert_Row
755: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
756: )
757: IS
758: BEGIN
759:

Line 869: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type

865: -- Function Query_Row
866:
867: FUNCTION Query_Row
868: ( p_pte_source_system_id IN NUMBER
869: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
870: IS
871: BEGIN
872:
873: RETURN Query_Rows

Line 888: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type

884: ( p_pte_source_system_id IN NUMBER :=
885: FND_API.G_MISS_NUM
886: , p_lookup_code IN VARCHAR2 :=
887: FND_API.G_MISS_CHAR
888: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type
889: IS
890: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
891: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
892:

Line 890: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

886: , p_lookup_code IN VARCHAR2 :=
887: FND_API.G_MISS_CHAR
888: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type
889: IS
890: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
891: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
892:
893: CURSOR l_SSC_csr IS
894: SELECT APPLICATION_SHORT_NAME

Line 891: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

887: FND_API.G_MISS_CHAR
888: ) RETURN QP_Attr_Map_PUB.Ssc_Tbl_Type
889: IS
890: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
891: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
892:
893: CURSOR l_SSC_csr IS
894: SELECT APPLICATION_SHORT_NAME
895: , ATTRIBUTE1

Line 1034: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

1030: --
1031:
1032: PROCEDURE Lock_Row
1033: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1034: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1035: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
1036: )
1037: IS
1038: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1035: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type

1031:
1032: PROCEDURE Lock_Row
1033: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1034: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1035: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
1036: )
1037: IS
1038: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1039: BEGIN

Line 1038: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1034: , p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1035: , x_SSC_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Rec_Type
1036: )
1037: IS
1038: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1039: BEGIN
1040:
1041: SELECT APPLICATION_SHORT_NAME
1042: , ATTRIBUTE1

Line 1231: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

1227:
1228: -- Function Get_Values
1229:
1230: FUNCTION Get_Values
1231: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
1233: QP_Attr_Map_PUB.G_MISS_SSC_REC
1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1235: IS

Line 1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=

1228: -- Function Get_Values
1229:
1230: FUNCTION Get_Values
1231: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
1233: QP_Attr_Map_PUB.G_MISS_SSC_REC
1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1235: IS
1236: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;

Line 1233: QP_Attr_Map_PUB.G_MISS_SSC_REC

1229:
1230: FUNCTION Get_Values
1231: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
1233: QP_Attr_Map_PUB.G_MISS_SSC_REC
1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1235: IS
1236: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
1237: BEGIN

Line 1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type

1230: FUNCTION Get_Values
1231: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
1233: QP_Attr_Map_PUB.G_MISS_SSC_REC
1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1235: IS
1236: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
1237: BEGIN
1238:

Line 1236: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;

1232: , p_old_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type :=
1233: QP_Attr_Map_PUB.G_MISS_SSC_REC
1234: ) RETURN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1235: IS
1236: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
1237: BEGIN
1238:
1239: IF p_SSC_rec.enabled_flag IS NOT NULL AND
1240: p_SSC_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

Line 1276: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

1272:
1273: -- Function Get_Ids
1274:
1275: FUNCTION Get_Ids
1276: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1277: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1278: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
1279: IS
1280: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1277: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type

1273: -- Function Get_Ids
1274:
1275: FUNCTION Get_Ids
1276: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1277: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1278: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
1279: IS
1280: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1281: BEGIN

Line 1278: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type

1274:
1275: FUNCTION Get_Ids
1276: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1277: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1278: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
1279: IS
1280: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1281: BEGIN
1282:

Line 1280: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1276: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1277: , p_SSC_val_rec IN QP_Attr_Map_PUB.Ssc_Val_Rec_Type
1278: ) RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
1279: IS
1280: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1281: BEGIN
1282:
1283: -- initialize return_status.
1284: