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 149: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

145: , x_service_duration OUT NOCOPY NUMBER -- service proj
146: , x_service_period OUT NOCOPY VARCHAR2 -- service proj
147: )
148: IS
149: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
150: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
151: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
152: l_control_rec QP_GLOBALS.Control_Rec_Type;
153: l_return_status VARCHAR2(1);

Line 150: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;

146: , x_service_period OUT NOCOPY VARCHAR2 -- service proj
147: )
148: IS
149: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
150: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
151: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
152: l_control_rec QP_GLOBALS.Control_Rec_Type;
153: l_return_status VARCHAR2(1);
154: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 151: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 154: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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

Line 155: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 156: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 159: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 160: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

556: , x_service_duration OUT NOCOPY NUMBER -- service project
557: , x_service_period OUT NOCOPY VARCHAR2 -- service project
558: )
559: IS
560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

557: , x_service_period OUT NOCOPY VARCHAR2 -- service project
558: )
559: IS
560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;

558: )
559: IS
560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);

Line 563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

559: IS
560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

560: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
561: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
562: l_MODIFIERS_val_rec QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

563: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

564: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

565: l_control_rec QP_GLOBALS.Control_Rec_Type;
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575:
576: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');

Line 573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575:
576: oe_debug_pub.add('BEGIN Change_attribute in QPXFMLLB');
577:

Line 1583: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1579: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
1580: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1581: )
1582: IS
1583: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1584: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1584: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1580: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1581: )
1582: IS
1583: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1584: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);

Line 1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1581: )
1582: IS
1583: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1584: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1582: IS
1583: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1584: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1585: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1586: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1587: l_control_rec QP_GLOBALS.Control_Rec_Type;
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1596: BEGIN
1597:
1598: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');

Line 1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1596: BEGIN
1597:
1598: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFMLLB');
1599:

Line 1752: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1748: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1749: , p_list_line_id IN NUMBER
1750: )
1751: IS
1752: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1753: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1754: l_control_rec QP_GLOBALS.Control_Rec_Type;
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1753: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1749: , p_list_line_id IN NUMBER
1750: )
1751: IS
1752: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1753: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1754: l_control_rec QP_GLOBALS.Control_Rec_Type;
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1752: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1753: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1754: l_control_rec QP_GLOBALS.Control_Rec_Type;
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1753: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1754: l_control_rec QP_GLOBALS.Control_Rec_Type;
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1754: l_control_rec QP_GLOBALS.Control_Rec_Type;
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1763: BEGIN
1764:
1765: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');

Line 1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1763: BEGIN
1764:
1765: oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');
1766:

Line 1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1890: )
1891: IS
1892: l_control_rec QP_GLOBALS.Control_Rec_Type;
1893: l_return_status VARCHAR2(1);
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1891: IS
1892: l_control_rec QP_GLOBALS.Control_Rec_Type;
1893: l_return_status VARCHAR2(1);
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1892: l_control_rec QP_GLOBALS.Control_Rec_Type;
1893: l_return_status VARCHAR2(1);
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1902:
1903: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');

Line 1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1902:
1903: oe_debug_pub.add('BEGIN Process_Entity in QPXFMLLB');
1904:

Line 2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2102: , p_service_period IN VARCHAR2 -- service proj
2103: )
2104: IS
2105: l_return_status VARCHAR2(1);
2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2103: )
2104: IS
2105: l_return_status VARCHAR2(1);
2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2104: IS
2105: l_return_status VARCHAR2(1);
2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2105: l_return_status VARCHAR2(1);
2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2106: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2115: BEGIN
2116:
2117: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');

Line 2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2115: BEGIN
2116:
2117: oe_debug_pub.add('BEGIN Lock_Row in QPXFMLLB');
2118:

Line 2291: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type

2287:
2288: -- Procedures maintaining MODIFIERS record cache.
2289:
2290: PROCEDURE Write_MODIFIERS
2291: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
2292: , p_db_record IN BOOLEAN := FALSE
2293: )
2294: IS
2295: BEGIN

Line 2315: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type

2311: FUNCTION Get_MODIFIERS
2312: ( p_db_record IN BOOLEAN := FALSE
2313: , p_list_line_id IN NUMBER
2314: )
2315: RETURN QP_Modifiers_PUB.Modifiers_Rec_Type
2316: IS
2317: BEGIN
2318:
2319: oe_debug_pub.add('BEGIN Get_Modifiers in QPXFMLLB');

Line 2360: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

2356: BEGIN
2357:
2358: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2359:
2360: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2361: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2362:
2363: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2364: END Clear_Modifiers;

Line 2361: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

2357:
2358: oe_debug_pub.add('BEGIN Clear_Modifiers in QPXFMLLB');
2359:
2360: g_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2361: g_db_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
2362:
2363: oe_debug_pub.add('END Clear_Modifiers in QPXFMLLB');
2364: END Clear_Modifiers;
2365:

Line 2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2429: l_new_qualifier_id Number;
2430: l_number_of_lines Number := 1;
2431: l_control_rec QP_GLOBALS.Control_Rec_Type;
2432: l_return_status VARCHAR2(1);
2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2430: l_number_of_lines Number := 1;
2431: l_control_rec QP_GLOBALS.Control_Rec_Type;
2432: l_return_status VARCHAR2(1);
2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2431: l_control_rec QP_GLOBALS.Control_Rec_Type;
2432: l_return_status VARCHAR2(1);
2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2432: l_return_status VARCHAR2(1);
2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2446: l_continuous_price_break_flag varchar2(1);
2447:
2448: CURSOR l_LIST_LINE_csr(p_list_line_id Number) IS

Line 2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2446: l_continuous_price_break_flag varchar2(1);
2447:
2448: CURSOR l_LIST_LINE_csr(p_list_line_id Number) IS
2449: SELECT