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 409: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type

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

Line 410: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type

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

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

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

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

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

Line 419: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 420: l_p_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 421: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 422: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 423: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 469: l_old_MODIFIERS_rec := QP_Modifiers_PUB.G_MISS_MODIFIERS_REC;

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

Line 1447: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

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

Line 1448: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

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

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

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

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

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

Line 1466: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 1467: l_p_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 1468: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 1469: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 1470: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 1490: l_old_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;

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

Line 1996: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

Line 1997: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

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

Line 1998: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

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

Line 1999: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

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

Line 2000: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

1996: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
1997: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
1998: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
1999: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2000: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2001: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2002: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2003: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2004: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 2001: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

1997: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
1998: , p_old_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
1999: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2000: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2001: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2002: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2003: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2004: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2005: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 2002: , p_old_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

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

Line 2003: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

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

Line 2008: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

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

Line 2009: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

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

Line 2010: , p_old_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

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

Line 2011: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

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

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

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

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

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

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

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

Line 2024: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

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

Line 2025: l_p_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_MODIFIER_LIST_rec;

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

Line 2026: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

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

Line 2027: l_p_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type := p_old_MODIFIER_LIST_rec;

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

Line 2028: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 2029: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 2030: l_p_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 2031: l_old_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 2032: l_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 2033: l_p_old_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 2040: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 2041: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 2042: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 2043: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 2044: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2040: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2041: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2042: l_p_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2043: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2044: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2045: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2046: NO_UPDATE_PRIVILEGE EXCEPTION;
2047:
2048: -- Blanket Agreement

Line 2045: l_p_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=

2629: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2630: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2631: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2632: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2634: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=

Line 2634: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC

2630: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2631: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2632: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2634: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL

Line 2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=

2631: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2632: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2634: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

Line 2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL

2632: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2633: , p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type :=
2634: QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC
2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

Line 2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=

2635: , p_MODIFIERS_tbl IN QP_Modifiers_PUB.Modifiers_Tbl_Type :=
2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2641: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2642: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2643: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type

Line 2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL

2636: QP_Modifiers_PUB.G_MISS_MODIFIERS_TBL
2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2641: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2642: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2643: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2644: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type

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

2637: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2641: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2642: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2643: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2644: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2645: )

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

2638: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
2639: , p_PRICING_ATTR_tbl IN QP_Modifiers_PUB.Pricing_Attr_Tbl_Type :=
2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2641: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2642: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2643: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2644: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2645: )
2646: IS

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

2640: QP_Modifiers_PUB.G_MISS_PRICING_ATTR_TBL
2641: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2642: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2643: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2644: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2645: )
2646: IS
2647: l_api_version_number CONSTANT NUMBER := 1.0;
2648: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';

Line 2650: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

2646: IS
2647: l_api_version_number CONSTANT NUMBER := 1.0;
2648: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2649: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2650: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2651: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2652: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2653: BEGIN
2654:

Line 2652: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

2648: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Modifiers';
2649: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2650: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2651: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2652: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2653: BEGIN
2654:
2655: oe_debug_pub.add('BEGIN lock_modifiers in Private');
2656: -- Standard call to check for call compatibility

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

2858: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2859: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2860: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2861: , p_list_header_id IN NUMBER
2862: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2864: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2865: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2866: )

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

2859: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2860: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2861: , p_list_header_id IN NUMBER
2862: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2864: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2865: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2866: )
2867: IS

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

2861: , p_list_header_id IN NUMBER
2862: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifier_List_Rec_Type
2863: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Tbl_Type
2864: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
2865: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Pricing_Attr_Tbl_Type
2866: )
2867: IS
2868: l_api_version_number CONSTANT NUMBER := 1.0;
2869: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';

Line 2870: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

2866: )
2867: IS
2868: l_api_version_number CONSTANT NUMBER := 1.0;
2869: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2870: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2871: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2872: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 2871: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

2867: IS
2868: l_api_version_number CONSTANT NUMBER := 1.0;
2869: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2870: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2871: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2872: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2875: BEGIN

Line 2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2869: l_api_name CONSTANT VARCHAR2(30):= 'Get_Modifiers';
2870: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2871: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2872: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2875: BEGIN
2876:
2877: oe_debug_pub.add('BEGIN get_modifiers in Private');

Line 2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

2870: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2871: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2872: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2873: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2874: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2875: BEGIN
2876:
2877: oe_debug_pub.add('BEGIN get_modifiers in Private');
2878: -- Standard call to check for call compatibility