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_PRICE_LIST_LINE_UTIL dependencies on QP_PRICE_LIST_PUB

Line 90: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

86: -- Procedure Clear_Dependent_Attr
87:
88: PROCEDURE Clear_Dependent_Attr
89: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
91: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
92: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
93: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
94: );

Line 91: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

87:
88: PROCEDURE Clear_Dependent_Attr
89: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
91: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
92: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
93: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
94: );
95:

Line 92: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

88: PROCEDURE Clear_Dependent_Attr
89: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
91: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
92: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
93: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
94: );
95:
96: -- Procedure Apply_Attribute_Changes

Line 93: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

89: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
90: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
91: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
92: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
93: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
94: );
95:
96: -- Procedure Apply_Attribute_Changes
97:

Line 99: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

95:
96: -- Procedure Apply_Attribute_Changes
97:
98: PROCEDURE Apply_Attribute_Changes
99: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
100: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
101: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
102: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
103: );

Line 100: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

96: -- Procedure Apply_Attribute_Changes
97:
98: PROCEDURE Apply_Attribute_Changes
99: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
100: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
101: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
102: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
103: );
104:

Line 101: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

97:
98: PROCEDURE Apply_Attribute_Changes
99: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
100: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
101: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
102: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
103: );
104:
105: -- Function Complete_Record

Line 102: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

98: PROCEDURE Apply_Attribute_Changes
99: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
100: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
101: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
102: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
103: );
104:
105: -- Function Complete_Record
106:

Line 108: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

104:
105: -- Function Complete_Record
106:
107: FUNCTION Complete_Record
108: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
109: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
110: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
111:
112: -- Function Convert_Miss_To_Null

Line 109: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

105: -- Function Complete_Record
106:
107: FUNCTION Complete_Record
108: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
109: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
110: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
111:
112: -- Function Convert_Miss_To_Null
113:

Line 110: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;

106:
107: FUNCTION Complete_Record
108: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
109: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
110: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
111:
112: -- Function Convert_Miss_To_Null
113:
114: FUNCTION Convert_Miss_To_Null

Line 115: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

111:
112: -- Function Convert_Miss_To_Null
113:
114: FUNCTION Convert_Miss_To_Null
115: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
116: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
117:
118: -- Procedure Update_Row
119:

Line 116: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;

112: -- Function Convert_Miss_To_Null
113:
114: FUNCTION Convert_Miss_To_Null
115: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
116: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
117:
118: -- Procedure Update_Row
119:
120: PROCEDURE Update_Row

Line 121: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

117:
118: -- Procedure Update_Row
119:
120: PROCEDURE Update_Row
121: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
122: );
123:
124: -- Procedure Insert_Row
125:

Line 127: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

123:
124: -- Procedure Insert_Row
125:
126: PROCEDURE Insert_Row
127: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
128: );
129:
130: -- Procedure Delete_Row
131:

Line 140: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;

136: -- Function Query_Row
137:
138: FUNCTION Query_Row
139: ( p_list_line_id IN NUMBER
140: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
141:
142: -- Function Query_Rows
143:
144: --

Line 151: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type;

147: ( p_list_line_id IN NUMBER :=
148: FND_API.G_MISS_NUM
149: , p_list_header_id IN NUMBER :=
150: FND_API.G_MISS_NUM
151: ) RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type;
152:
153: -- Procedure lock_Row
154: --
155:

Line 158: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

154: --
155:
156: PROCEDURE Lock_Row
157: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
159: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
160: );
161:
162: -- Function Get_Values

Line 159: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type

155:
156: PROCEDURE Lock_Row
157: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
159: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
160: );
161:
162: -- Function Get_Values
163:

Line 165: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

161:
162: -- Function Get_Values
163:
164: FUNCTION Get_Values
165: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
166: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
167: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
168: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
169:

Line 166: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=

162: -- Function Get_Values
163:
164: FUNCTION Get_Values
165: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
166: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
167: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
168: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
169:
170: -- Function Get_Ids

Line 167: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC

163:
164: FUNCTION Get_Values
165: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
166: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
167: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
168: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
169:
170: -- Function Get_Ids
171:

Line 168: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

164: FUNCTION Get_Values
165: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
166: , p_old_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type :=
167: QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
168: ) RETURN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
169:
170: -- Function Get_Ids
171:
172: FUNCTION Get_Ids

Line 173: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

169:
170: -- Function Get_Ids
171:
172: FUNCTION Get_Ids
173: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
174: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
175: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
176:
177: Procedure Print_Price_List_Line

Line 174: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type

170: -- Function Get_Ids
171:
172: FUNCTION Get_Ids
173: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
174: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
175: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
176:
177: Procedure Print_Price_List_Line
178: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,

Line 175: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;

171:
172: FUNCTION Get_Ids
173: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
174: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
175: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
176:
177: Procedure Print_Price_List_Line
178: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,
179: p_counter IN NUMBER);

Line 178: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,

174: , p_PRICE_LIST_LINE_val_rec IN QP_Price_List_PUB.Price_List_Line_Val_Rec_Type
175: ) RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
176:
177: Procedure Print_Price_List_Line
178: (p_PRICE_LIST_LINE_rec IN QP_PRICE_LIST_PUB.PRICE_LIST_LINE_REC_TYPE,
179: p_counter IN NUMBER);
180:
181: FUNCTION get_qualifier_attr_value(p_qual_attr_value in varchar2)
182: return varchar2;