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

Line 77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

73:
74: PROCEDURE Modifier_List
75: ( p_validation_level IN NUMBER
76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
81: )

Line 78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

74: PROCEDURE Modifier_List
75: ( p_validation_level IN NUMBER
76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
81: )
82: IS

Line 79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

75: ( p_validation_level IN NUMBER
76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
81: )
82: IS
83: l_return_status VARCHAR2(1);

Line 80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

76: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
77: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
78: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
79: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
80: , x_old_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
81: )
82: IS
83: l_return_status VARCHAR2(1);
84: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 85: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

81: )
82: IS
83: l_return_status VARCHAR2(1);
84: l_control_rec QP_GLOBALS.Control_Rec_Type;
85: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
88: BEGIN
89:

Line 86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

82: IS
83: l_return_status VARCHAR2(1);
84: l_control_rec QP_GLOBALS.Control_Rec_Type;
85: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
88: BEGIN
89:
90: oe_debug_pub.add('BEGIN modifier list in Private');

Line 87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

83: l_return_status VARCHAR2(1);
84: l_control_rec QP_GLOBALS.Control_Rec_Type;
85: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
86: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
87: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
88: BEGIN
89:
90: oe_debug_pub.add('BEGIN modifier list in Private');
91: --dbms_output.put_line('BEGIN modifier list in Private');

Line 412: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type

408:
409: PROCEDURE Modifierss
410: ( p_validation_level IN NUMBER
411: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
412: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
413: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
415: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
416: )

Line 413: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type

409: PROCEDURE Modifierss
410: ( p_validation_level IN NUMBER
411: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
412: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
413: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
415: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
416: )
417: IS

Line 414: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

410: ( p_validation_level IN NUMBER
411: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
412: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
413: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
415: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
416: )
417: IS
418: l_return_status VARCHAR2(1);

Line 415: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

411: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
412: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
413: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type
414: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
415: , x_old_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
416: )
417: IS
418: l_return_status VARCHAR2(1);
419: l_rltd_modifiers_s NUMBER;

Line 422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

418: l_return_status VARCHAR2(1);
419: l_rltd_modifiers_s NUMBER;
420: l_to_rltd_modifier_id NUMBER;
421: l_control_rec QP_GLOBALS.Control_Rec_Type;
422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

419: l_rltd_modifiers_s NUMBER;
420: l_to_rltd_modifier_id NUMBER;
421: l_control_rec QP_GLOBALS.Control_Rec_Type;
422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
427: l_product_attribute varchar2(30) := null;

Line 424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

420: l_to_rltd_modifier_id NUMBER;
421: l_control_rec QP_GLOBALS.Control_Rec_Type;
422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
427: l_product_attribute varchar2(30) := null;
428: l_product_attr_value varchar2(240) := null;

Line 425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

421: l_control_rec QP_GLOBALS.Control_Rec_Type;
422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
427: l_product_attribute varchar2(30) := null;
428: l_product_attr_value varchar2(240) := null;
429: l_pricing_phase_id number;

Line 426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

422: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
423: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
424: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
425: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
426: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
427: l_product_attribute varchar2(30) := null;
428: l_product_attr_value varchar2(240) := null;
429: l_pricing_phase_id number;
430:

Line 472: l_old_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

468:
469: IF l_old_MODIFIERS_tbl.EXISTS(I) THEN
470: l_old_MODIFIERS_rec := l_old_MODIFIERS_tbl(I);
471: ELSE
472: l_old_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;
473: END IF;
474:
475: -- Load API control record
476:

Line 1450: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

1446:
1447: PROCEDURE Pricing_Attrs
1448: ( p_validation_level IN NUMBER
1449: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1450: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1451: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1452: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1453: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1454: )

Line 1451: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

1447: PROCEDURE Pricing_Attrs
1448: ( p_validation_level IN NUMBER
1449: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1450: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1451: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1452: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1453: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1454: )
1455: IS

Line 1452: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

1448: ( p_validation_level IN NUMBER
1449: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1450: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1451: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1452: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1453: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1454: )
1455: IS
1456:

Line 1453: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

1449: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1450: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1451: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1452: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1453: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
1454: )
1455: IS
1456:
1457: --- added by svdeshmu

Line 1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1465:
1466:
1467: l_return_status VARCHAR2(1);
1468: l_control_rec QP_GLOBALS.Control_Rec_Type;
1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1466:
1467: l_return_status VARCHAR2(1);
1468: l_control_rec QP_GLOBALS.Control_Rec_Type;
1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1474: l_continuous_price_break_flag VARCHAR2(1); --Continuous Price Breaks

Line 1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1467: l_return_status VARCHAR2(1);
1468: l_control_rec QP_GLOBALS.Control_Rec_Type;
1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1474: l_continuous_price_break_flag VARCHAR2(1); --Continuous Price Breaks
1475: BEGIN

Line 1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1468: l_control_rec QP_GLOBALS.Control_Rec_Type;
1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1474: l_continuous_price_break_flag VARCHAR2(1); --Continuous Price Breaks
1475: BEGIN
1476:

Line 1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1469: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1470: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1471: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1472: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1473: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1474: l_continuous_price_break_flag VARCHAR2(1); --Continuous Price Breaks
1475: BEGIN
1476:
1477: oe_debug_pub.add('BEGIN pricing_attrs in Private');

Line 1493: l_old_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;

1489:
1490: IF l_old_PRICING_ATTR_tbl.EXISTS(I) THEN
1491: l_old_PRICING_ATTR_rec := l_old_PRICING_ATTR_tbl(I);
1492: ELSE
1493: l_old_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1494: END IF;
1495:
1496: -- Load API control record
1497:

Line 1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

1995: QP_GLOBALS.G_MISS_CONTROL_REC
1996: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1997: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1998: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

Line 2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

1996: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1997: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1998: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

Line 2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

1997: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1998: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

Line 2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

1998: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

Line 2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

1999: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2007: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

2000: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2007: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2008: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

2001: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2007: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2008: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2009: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

2002: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2003: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2004: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2005: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2006: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2007: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2008: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2009: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2010: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

2007: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2008: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2009: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2010: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

Line 2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

2008: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2009: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2010: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

Line 2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

2009: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2010: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2017: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

2010: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2017: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2018: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

Line 2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

2011: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2017: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2018: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2019: )

Line 2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

2012: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2013: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2017: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2018: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2019: )
2020: IS

Line 2018: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

2014: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2015: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2016: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2017: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2018: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2019: )
2020: IS
2021: l_api_version_number CONSTANT NUMBER := 1.0;
2022: l_list_type_code VARCHAR2(30);

Line 2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

2023: l_api_name CONSTANT VARCHAR2(30):= 'Process_Modifiers';
2024: l_return_status VARCHAR2(1);
2025: l_qp_status VARCHAR2(1);
2026: l_control_rec QP_GLOBALS.Control_Rec_Type;
2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

2024: l_return_status VARCHAR2(1);
2025: l_qp_status VARCHAR2(1);
2026: l_control_rec QP_GLOBALS.Control_Rec_Type;
2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

2025: l_qp_status VARCHAR2(1);
2026: l_control_rec QP_GLOBALS.Control_Rec_Type;
2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

2026: l_control_rec QP_GLOBALS.Control_Rec_Type;
2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2027: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2028: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;
2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2029: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2037: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2030: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;
2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2037: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2038: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2031: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2037: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2038: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2039: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2032: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2033: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2034: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2035: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2036: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2037: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2038: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2039: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2040: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2039: l_p_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2040: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2041: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2042: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2040: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2041: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2042: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2041: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2042: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2049: NO_UPDATE_PRIVILEGE EXCEPTION;

Line 2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2042: l_p_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2049: NO_UPDATE_PRIVILEGE EXCEPTION;
2050:

Line 2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2043: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2049: NO_UPDATE_PRIVILEGE EXCEPTION;
2050:
2051: -- Blanket Agreement

Line 2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2044: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2047: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2048: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2049: NO_UPDATE_PRIVILEGE EXCEPTION;
2050:
2051: -- Blanket Agreement
2052: l_qual_exists VARCHAR2(1) := 'N';

Line 2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

2636: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2637: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2638: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2639: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2641: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 2641: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

2637: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2638: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2639: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2641: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

2638: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2639: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2641: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

Line 2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

2639: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2640: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2641: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

Line 2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

2642: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2650: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

2643: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2650: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2651: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

Line 2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

2644: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2650: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2651: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2652: )

Line 2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

2645: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2646: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2650: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2651: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2652: )
2653: IS

Line 2651: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

2647: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2648: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2649: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2650: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2651: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2652: )
2653: IS
2654: l_api_version_number CONSTANT NUMBER := 1.0;
2655: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';

Line 2657: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2653: IS
2654: l_api_version_number CONSTANT NUMBER := 1.0;
2655: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2656: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2657: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2658: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2659: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2660: BEGIN
2661:

Line 2659: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2655: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2656: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2657: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2658: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2659: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2660: BEGIN
2661:
2662: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2663: -- Standard call to check for call compatibility

Line 2869: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type

2865: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2866: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2867: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2868: , p_list_header_id IN NUMBER
2869: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2870: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2871: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2872: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2873: )

Line 2870: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type

2866: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2867: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2868: , p_list_header_id IN NUMBER
2869: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2870: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2871: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2872: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2873: )
2874: IS

Line 2872: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

2868: , p_list_header_id IN NUMBER
2869: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2870: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2871: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2872: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2873: )
2874: IS
2875: l_api_version_number CONSTANT NUMBER := 1.0;
2876: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';

Line 2877: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2873: )
2874: IS
2875: l_api_version_number CONSTANT NUMBER := 1.0;
2876: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2877: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2878: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2879: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2878: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2874: IS
2875: l_api_version_number CONSTANT NUMBER := 1.0;
2876: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2877: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2878: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2879: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2882: BEGIN

Line 2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2876: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2877: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2878: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2879: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2882: BEGIN
2883:
2884: oe_debug_pub.add('BEGIN get_modifiers in Private');

Line 2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2877: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2878: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2879: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2880: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2881: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2882: BEGIN
2883:
2884: oe_debug_pub.add('BEGIN get_modifiers in Private');
2885: -- Standard call to check for call compatibility