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_SEG_UTIL dependencies on QP_ATTRIBUTES_PUB

Line 63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

59: end;
60: --
61: PROCEDURE Clear_Dependent_Attr
62: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
65: QP_Attributes_PUB.G_MISS_SEG_REC
66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )

Line 64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=

60: --
61: PROCEDURE Clear_Dependent_Attr
62: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
65: QP_Attributes_PUB.G_MISS_SEG_REC
66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )
68: IS

Line 65: QP_Attributes_PUB.G_MISS_SEG_REC

61: PROCEDURE Clear_Dependent_Attr
62: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
65: QP_Attributes_PUB.G_MISS_SEG_REC
66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )
68: IS
69: l_index NUMBER := 0;

Line 66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type

62: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
65: QP_Attributes_PUB.G_MISS_SEG_REC
66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
67: )
68: IS
69: l_index NUMBER := 0;
70: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

Line 479: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

475:
476: -- Procedure Apply_Attribute_Changes
477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
480: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
481: QP_Attributes_PUB.G_MISS_SEG_REC
482: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
483: )

Line 480: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=

476: -- Procedure Apply_Attribute_Changes
477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
480: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
481: QP_Attributes_PUB.G_MISS_SEG_REC
482: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
483: )
484: IS

Line 481: QP_Attributes_PUB.G_MISS_SEG_REC

477:
478: PROCEDURE Apply_Attribute_Changes
479: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
480: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
481: QP_Attributes_PUB.G_MISS_SEG_REC
482: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
483: )
484: IS
485: BEGIN

Line 482: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type

478: PROCEDURE Apply_Attribute_Changes
479: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
480: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
481: QP_Attributes_PUB.G_MISS_SEG_REC
482: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
483: )
484: IS
485: BEGIN
486:

Line 710: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

706:
707: -- Function Complete_Record
708:
709: FUNCTION Complete_Record
710: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
711: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
712: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
713: IS
714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;

Line 711: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

707: -- Function Complete_Record
708:
709: FUNCTION Complete_Record
710: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
711: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
712: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
713: IS
714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
715: BEGIN

Line 712: ) RETURN QP_Attributes_PUB.Seg_Rec_Type

708:
709: FUNCTION Complete_Record
710: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
711: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
712: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
713: IS
714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
715: BEGIN
716:

Line 714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;

710: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
711: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
712: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
713: IS
714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
715: BEGIN
716:
717: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
718: l_SEG_rec.attribute1 := p_old_SEG_rec.attribute1;

Line 895: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

891:
892: -- Function Convert_Miss_To_Null
893:
894: FUNCTION Convert_Miss_To_Null
895: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
896: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
897: IS
898: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
899: BEGIN

Line 896: ) RETURN QP_Attributes_PUB.Seg_Rec_Type

892: -- Function Convert_Miss_To_Null
893:
894: FUNCTION Convert_Miss_To_Null
895: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
896: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
897: IS
898: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
899: BEGIN
900:

Line 898: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;

894: FUNCTION Convert_Miss_To_Null
895: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
896: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
897: IS
898: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
899: BEGIN
900:
901: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
902: l_SEG_rec.attribute1 := NULL;

Line 1080: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

1076:
1077: -- Procedure Update_Row
1078:
1079: PROCEDURE Update_Row
1080: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1081: )
1082: IS
1083: l_prc_context_code varchar2(30);
1084: l_prc_context_type varchar2(30);

Line 1212: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

1208:
1209: -- Procedure Insert_Row
1210:
1211: PROCEDURE Insert_Row
1212: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1213: )
1214: IS
1215: l_row_id varchar2(25);
1216: l_prc_context_type varchar2(30);

Line 1494: ) RETURN QP_Attributes_PUB.Seg_Rec_Type

1490: -- Function Query_Row
1491:
1492: FUNCTION Query_Row
1493: ( p_segment_id IN NUMBER
1494: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
1495: IS
1496: BEGIN
1497:
1498: RETURN Query_Rows

Line 1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type

1509: ( p_segment_id IN NUMBER :=
1510: FND_API.G_MISS_NUM
1511: , p_prc_context_id IN NUMBER :=
1512: FND_API.G_MISS_NUM
1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type
1514: IS
1515: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1516: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
1517:

Line 1515: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

1511: , p_prc_context_id IN NUMBER :=
1512: FND_API.G_MISS_NUM
1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type
1514: IS
1515: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1516: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
1517:
1518: CURSOR l_SEG_csr IS
1519: SELECT ATTRIBUTE1

Line 1516: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

1512: FND_API.G_MISS_NUM
1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type
1514: IS
1515: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1516: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
1517:
1518: CURSOR l_SEG_csr IS
1519: SELECT ATTRIBUTE1
1520: , ATTRIBUTE10

Line 1688: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

1684: --
1685:
1686: PROCEDURE Lock_Row
1687: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1688: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1689: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
1690: )
1691: IS
1692: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 1689: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type

1685:
1686: PROCEDURE Lock_Row
1687: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1688: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1689: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
1690: )
1691: IS
1692: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1693: BEGIN

Line 1692: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

1688: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1689: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type
1690: )
1691: IS
1692: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1693: BEGIN
1694:
1695: SELECT ATTRIBUTE1
1696: , ATTRIBUTE10

Line 1946: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

1942:
1943: -- Function Get_Values
1944:
1945: FUNCTION Get_Values
1946: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
1948: QP_Attributes_PUB.G_MISS_SEG_REC
1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type
1950: IS

Line 1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=

1943: -- Function Get_Values
1944:
1945: FUNCTION Get_Values
1946: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
1948: QP_Attributes_PUB.G_MISS_SEG_REC
1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type
1950: IS
1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;

Line 1948: QP_Attributes_PUB.G_MISS_SEG_REC

1944:
1945: FUNCTION Get_Values
1946: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
1948: QP_Attributes_PUB.G_MISS_SEG_REC
1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type
1950: IS
1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;
1952: BEGIN

Line 1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type

1945: FUNCTION Get_Values
1946: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
1948: QP_Attributes_PUB.G_MISS_SEG_REC
1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type
1950: IS
1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;
1952: BEGIN
1953:

Line 1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;

1947: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
1948: QP_Attributes_PUB.G_MISS_SEG_REC
1949: ) RETURN QP_Attributes_PUB.Seg_Val_Rec_Type
1950: IS
1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;
1952: BEGIN
1953:
1954: IF p_SEG_rec.prc_context_id IS NOT NULL AND
1955: p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM AND

Line 2011: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type

2007:
2008: -- Function Get_Ids
2009:
2010: FUNCTION Get_Ids
2011: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
2012: , p_SEG_val_rec IN QP_Attributes_PUB.Seg_Val_Rec_Type
2013: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
2014: IS
2015: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 2012: , p_SEG_val_rec IN QP_Attributes_PUB.Seg_Val_Rec_Type

2008: -- Function Get_Ids
2009:
2010: FUNCTION Get_Ids
2011: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
2012: , p_SEG_val_rec IN QP_Attributes_PUB.Seg_Val_Rec_Type
2013: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
2014: IS
2015: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
2016: BEGIN

Line 2013: ) RETURN QP_Attributes_PUB.Seg_Rec_Type

2009:
2010: FUNCTION Get_Ids
2011: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
2012: , p_SEG_val_rec IN QP_Attributes_PUB.Seg_Val_Rec_Type
2013: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
2014: IS
2015: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
2016: BEGIN
2017:

Line 2015: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

2011: ( p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
2012: , p_SEG_val_rec IN QP_Attributes_PUB.Seg_Val_Rec_Type
2013: ) RETURN QP_Attributes_PUB.Seg_Rec_Type
2014: IS
2015: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
2016: BEGIN
2017:
2018: -- initialize return_status.
2019: