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

Line 10: g_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Price_List_Line';
7:
8: -- Global variables holding cached record.
9:
10: g_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
11: g_db_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
11: g_db_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PRICE_LIST_LINE

Line 16: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PRICE_LIST_LINE
16: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_PRICE_LIST_LINE

Line 24: RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;

20: FUNCTION Get_PRICE_LIST_LINE
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_list_line_id IN NUMBER
23: )
24: RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type;
25:
26: PROCEDURE Clear_PRICE_LIST_LINE;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

26: PROCEDURE Clear_PRICE_LIST_LINE;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 125: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

121: , x_break_uom_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
122: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
123: )
124: IS
125: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);

Line 126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

122: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
123: )
124: IS
125: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

123: )
124: IS
125: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

126: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
133: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
134: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

127: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
133: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
134: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
135: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

128: l_control_rec QP_GLOBALS.Control_Rec_Type;
129: l_return_status VARCHAR2(1);
130: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
133: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
134: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
135: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
136: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 135: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

131: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
133: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
134: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
135: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
136: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
137: BEGIN
138:
139: -- Set control flags.

Line 136: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

132: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
133: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
134: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
135: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
136: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
137: BEGIN
138:
139: -- Set control flags.
140:

Line 490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

486: , x_break_uom_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
487: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
488: )
489: IS
490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

487: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
488: )
489: IS
490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

488: )
489: IS
490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);

Line 493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

489: IS
490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

490: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
491: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
492: l_PRICE_LIST_LINE_val_rec QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

493: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
500: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
501: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

494: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
500: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
501: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
502: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

495: l_control_rec QP_GLOBALS.Control_Rec_Type;
496: l_return_status VARCHAR2(1);
497: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
500: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
501: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
502: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
503: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 502: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

498: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
500: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
501: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
502: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
503: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
504: BEGIN
505:
506: -- Set control flags.

Line 503: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

499: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
500: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
501: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
502: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
503: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
504: BEGIN
505:
506: -- Set control flags.
507:

Line 1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1290: , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
1291: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
1292: )
1293: IS
1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1291: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
1292: )
1293: IS
1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);

Line 1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1292: )
1293: IS
1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1293: IS
1294: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1295: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1296: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1304: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1297: l_old_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1304: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1305: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1298: l_control_rec QP_GLOBALS.Control_Rec_Type;
1299: l_return_status VARCHAR2(1);
1300: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1304: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1305: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1306: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1305: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1301: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1304: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1305: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1306: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1307: BEGIN
1308:
1309: -- Set control flags.

Line 1306: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1302: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1304: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1305: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1306: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1307: BEGIN
1308:
1309: -- Set control flags.
1310: l_control_rec.controlled_operation := TRUE;

Line 1462: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1458: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1459: , p_list_line_id IN NUMBER
1460: )
1461: IS
1462: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1459: , p_list_line_id IN NUMBER
1460: )
1461: IS
1462: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1462: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1469: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1470: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1463: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1469: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1470: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1471: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1464: l_control_rec QP_GLOBALS.Control_Rec_Type;
1465: l_return_status VARCHAR2(1);
1466: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1469: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1470: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1471: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1472: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1471: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1467: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1469: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1470: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1471: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1472: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1473: BEGIN
1474:
1475: -- Set control flags.

Line 1472: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1468: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1469: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1470: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1471: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1472: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1473: BEGIN
1474:
1475: -- Set control flags.
1476:

Line 1600: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1596: )
1597: IS
1598: l_control_rec QP_GLOBALS.Control_Rec_Type;
1599: l_return_status VARCHAR2(1);
1600: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1603: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1604: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1597: IS
1598: l_control_rec QP_GLOBALS.Control_Rec_Type;
1599: l_return_status VARCHAR2(1);
1600: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1603: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1604: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1605: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1598: l_control_rec QP_GLOBALS.Control_Rec_Type;
1599: l_return_status VARCHAR2(1);
1600: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1603: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1604: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1605: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1606: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1605: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1601: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1603: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1604: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1605: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1606: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1607: BEGIN
1608:
1609: -- Set control flags.

Line 1606: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1602: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1603: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1604: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1605: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1606: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1607: BEGIN
1608:
1609: -- Set control flags.
1610:

Line 1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1779: , p_continuous_price_break_flag IN VARCHAR2 --Continuous price breaks
1780: )
1781: IS
1782: l_return_status VARCHAR2(1);
1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1780: )
1781: IS
1782: l_return_status VARCHAR2(1);
1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1781: IS
1782: l_return_status VARCHAR2(1);
1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1789: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1782: l_return_status VARCHAR2(1);
1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1789: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1790: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1783: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1784: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1785: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1789: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1790: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1791: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1790: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1786: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1789: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1790: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1791: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1792: BEGIN
1793:
1794: oe_debug_pub.add('inside lock price list - form 1');

Line 1791: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1787: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1788: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1789: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1790: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1791: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1792: BEGIN
1793:
1794: oe_debug_pub.add('inside lock price list - form 1');
1795:

Line 1951: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type

1947:
1948: -- Procedures maintaining PRICE_LIST_LINE record cache.
1949:
1950: PROCEDURE Write_PRICE_LIST_LINE
1951: ( p_PRICE_LIST_LINE_rec IN QP_Price_List_PUB.Price_List_Line_Rec_Type
1952: , p_db_record IN BOOLEAN := FALSE
1953: )
1954: IS
1955: BEGIN

Line 1971: RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type

1967: FUNCTION Get_PRICE_LIST_LINE
1968: ( p_db_record IN BOOLEAN := FALSE
1969: , p_list_line_id IN NUMBER
1970: )
1971: RETURN QP_Price_List_PUB.Price_List_Line_Rec_Type
1972: IS
1973: BEGIN
1974: IF p_list_line_id <> g_PRICE_LIST_LINE_rec.list_line_id
1975: THEN

Line 2009: g_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;

2005: PROCEDURE Clear_Price_List_Line
2006: IS
2007: BEGIN
2008:
2009: g_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
2010: g_db_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
2011:
2012: END Clear_Price_List_Line;
2013:

Line 2010: g_db_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;

2006: IS
2007: BEGIN
2008:
2009: g_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
2010: g_db_PRICE_LIST_LINE_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
2011:
2012: END Clear_Price_List_Line;
2013:
2014: -- This procedure will be called from the client when the user