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_MODIFIERS dependencies on QP_MODIFIERS_PUB

Line 10: g_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Modifiers';
7:
8: -- Global variables holding cached record.
9:
10: g_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
11: g_db_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
11: g_db_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_MODIFIERS

Line 16: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_MODIFIERS
16: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_MODIFIERS

Line 24: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;

20: FUNCTION Get_MODIFIERS
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_list_line_id IN NUMBER
23: )
24: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
25:
26: PROCEDURE Clear_MODIFIERS;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

26: PROCEDURE Clear_MODIFIERS;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 147: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

143: , x_accum_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
145: )
146: IS
147: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);

Line 148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;

144: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
145: )
146: IS
147: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

145: )
146: IS
147: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

148: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

149: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

150: l_control_rec QP_GLOBALS.Control_Rec_Type;
151: l_return_status VARCHAR2(1);
152: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
158: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

153: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
158: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
159: BEGIN
160:
161: oe_debug_pub.add('BEGIN Default_Attributes in QPXFMLLB');

Line 158: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

154: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
157: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
158: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
159: BEGIN
160:
161: oe_debug_pub.add('BEGIN Default_Attributes in QPXFMLLB');
162:

Line 553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

549: , x_accum_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
550: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
551: )
552: IS
553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

550: , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
551: )
552: IS
553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;

551: )
552: IS
553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);

Line 556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

552: IS
553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

553: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
554: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
555: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

556: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
563: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
564: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

557: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
563: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
564: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

558: l_control_rec QP_GLOBALS.Control_Rec_Type;
559: l_return_status VARCHAR2(1);
560: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
563: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
564: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
566: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

561: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
563: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
564: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
566: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
567: BEGIN
568:
569: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');

Line 566: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

562: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
563: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
564: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
565: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
566: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
567: BEGIN
568:
569: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');
570:

Line 1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1548: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
1549: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1550: )
1551: IS
1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1549: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1550: )
1551: IS
1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);

Line 1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1550: )
1551: IS
1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1551: IS
1552: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1553: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1554: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1561: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1562: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1555: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1561: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1562: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1556: l_control_rec QP_GLOBALS.Control_Rec_Type;
1557: l_return_status VARCHAR2(1);
1558: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1561: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1562: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1564: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1559: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1561: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1562: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1564: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1565: BEGIN
1566:
1567: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');

Line 1564: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1560: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1561: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1562: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1563: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1564: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1565: BEGIN
1566:
1567: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');
1568:

Line 1721: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1717: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1718: , p_list_line_id IN NUMBER
1719: )
1720: IS
1721: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1718: , p_list_line_id IN NUMBER
1719: )
1720: IS
1721: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1721: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1728: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1729: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1722: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1728: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1729: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1723: l_control_rec QP_GLOBALS.Control_Rec_Type;
1724: l_return_status VARCHAR2(1);
1725: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1728: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1729: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1731: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1726: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1728: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1729: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1731: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1732: BEGIN
1733:
1734: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');

Line 1731: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1727: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1728: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1729: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1730: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1731: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1732: BEGIN
1733:
1734: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');
1735:

Line 1863: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1859: )
1860: IS
1861: l_control_rec QP_GLOBALS.Control_Rec_Type;
1862: l_return_status VARCHAR2(1);
1863: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1866: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1867: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1860: IS
1861: l_control_rec QP_GLOBALS.Control_Rec_Type;
1862: l_return_status VARCHAR2(1);
1863: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1866: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1867: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1861: l_control_rec QP_GLOBALS.Control_Rec_Type;
1862: l_return_status VARCHAR2(1);
1863: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1866: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1867: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1869: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1864: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1866: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1867: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1869: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1870: BEGIN
1871:
1872: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');

Line 1869: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1865: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1866: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1867: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1868: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1869: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1870: BEGIN
1871:
1872: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');
1873:

Line 2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2069: , p_continuous_price_break_flag IN VARCHAR2 --Continuous Price Breaks
2070: )
2071: IS
2072: l_return_status VARCHAR2(1);
2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2070: )
2071: IS
2072: l_return_status VARCHAR2(1);
2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2071: IS
2072: l_return_status VARCHAR2(1);
2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2079: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2072: l_return_status VARCHAR2(1);
2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2079: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2073: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2074: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2075: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2079: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2081: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2076: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2079: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2081: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2082: BEGIN
2083:
2084: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');

Line 2081: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2077: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2078: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2079: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2080: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2081: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2082: BEGIN
2083:
2084: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');
2085:

Line 2256: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type

2252:
2253: -- Procedures maintaining MODIFIERS record cache.
2254:
2255: PROCEDURE Write_MODIFIERS
2256: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2257: , p_db_record IN BOOLEAN := FALSE
2258: )
2259: IS
2260: BEGIN

Line 2280: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type

2276: FUNCTION Get_MODIFIERS
2277: ( p_db_record IN BOOLEAN := FALSE
2278: , p_list_line_id IN NUMBER
2279: )
2280: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
2281: IS
2282: BEGIN
2283:
2284: oe_debug_pub.add('BEGIN Get_Modifiers in QPXFMLLB');

Line 2325: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

2321: BEGIN
2322:
2323: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2324:
2325: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2326: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2327:
2328: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2329: END Clear_Modifiers;

Line 2326: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

2322:
2323: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2324:
2325: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2326: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2327:
2328: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2329: END Clear_Modifiers;
2330:

Line 2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2394: l_new_qualifier_id Number;
2395: l_number_of_lines Number := 1;
2396: l_control_rec QP_GLOBALS.Control_Rec_Type;
2397: l_return_status VARCHAR2(1);
2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2395: l_number_of_lines Number := 1;
2396: l_control_rec QP_GLOBALS.Control_Rec_Type;
2397: l_return_status VARCHAR2(1);
2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2396: l_control_rec QP_GLOBALS.Control_Rec_Type;
2397: l_return_status VARCHAR2(1);
2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2397: l_return_status VARCHAR2(1);
2398: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2399: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2400: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2407: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2408: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2401: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2407: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2408: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2409: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2402: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2403: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2404: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2407: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2408: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2409: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2410: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2409: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2405: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2407: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2408: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2409: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2410: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2411: l_continuous_price_break_flag varchar2(1);
2412:
2413: CURSOR l_LIST_LINE_csr(p_list_line_id Number) IS

Line 2410: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2406: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2407: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2408: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2409: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2410: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2411: l_continuous_price_break_flag varchar2(1);
2412:
2413: CURSOR l_LIST_LINE_csr(p_list_line_id Number) IS
2414: SELECT