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

Line 11: RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type

7:
8: --Function to query a Price List Line and if is a PBH also its child break lines
9: FUNCTION Query_Rows(p_list_header_id IN NUMBER,
10: p_list_line_id IN NUMBER)
11: RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
12: IS
13: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
14: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
15:

Line 13: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

9: FUNCTION Query_Rows(p_list_header_id IN NUMBER,
10: p_list_line_id IN NUMBER)
11: RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
12: IS
13: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
14: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
15:
16: CURSOR price_list_line_cur(a_list_header_id NUMBER, a_list_line_id NUMBER)
17: IS

Line 14: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

10: p_list_line_id IN NUMBER)
11: RETURN QP_Price_List_PUB.Price_List_Line_Tbl_Type
12: IS
13: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
14: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
15:
16: CURSOR price_list_line_cur(a_list_header_id NUMBER, a_list_line_id NUMBER)
17: IS
18: SELECT ACCRUAL_QTY

Line 223: x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type,

219:
220: PROCEDURE Get_Price_List
221: (p_list_header_id IN NUMBER,
222: p_list_line_id IN NUMBER,
223: x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type,
224: x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type,
225: x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type,
226: x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type,
227: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 224: x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type,

220: PROCEDURE Get_Price_List
221: (p_list_header_id IN NUMBER,
222: p_list_line_id IN NUMBER,
223: x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type,
224: x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type,
225: x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type,
226: x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type,
227: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 226: x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type,

222: p_list_line_id IN NUMBER,
223: x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type,
224: x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type,
225: x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type,
226: x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type,
227: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
230: )

Line 232: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

228: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
230: )
231: IS
232: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
233: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
234: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
235: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
236: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 233: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

229: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
230: )
231: IS
232: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
233: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
234: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
235: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
236: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
237:

Line 235: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

231: IS
232: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
233: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
234: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
235: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
236: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
237:
238: BEGIN
239: --Get Price List Header

Line 236: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

232: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
233: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
234: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
235: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
236: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
237:
238: BEGIN
239: --Get Price List Header
240: l_PRICE_LIST_rec := QP_Price_List_Util.Query_Row

Line 329: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

325: l_pte_code VARCHAR2(30);
326:
327: p_control_rec QP_GLOBALS.Control_Rec_Type;
328:
329: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

Line 330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

326:
327: p_control_rec QP_GLOBALS.Control_Rec_Type;
328:
329: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

Line 331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

327: p_control_rec QP_GLOBALS.Control_Rec_Type;
328:
329: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
335: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

Line 333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;

329: p_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
335: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
336: x_qualifiers_tbl QP_QUALIFIER_RULES_PUB.Qualifiers_Tbl_Type;
337:

Line 334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;

330: p_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
335: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
336: x_qualifiers_tbl QP_QUALIFIER_RULES_PUB.Qualifiers_Tbl_Type;
337:
338: i number := 1;

Line 335: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;

331: p_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
332:
333: x_price_list_rec QP_PRICE_LIST_PUB.Price_List_Rec_Type;
334: x_price_list_line_tbl QP_PRICE_LIST_PUB.Price_List_Line_Tbl_Type;
335: x_pricing_attr_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
336: x_qualifiers_tbl QP_QUALIFIER_RULES_PUB.Qualifiers_Tbl_Type;
337:
338: i number := 1;
339: ii number := 1;