eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_PRICING_ATTR dependencies on QP_MODIFIERS_PUB

Line 10: g_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 11: g_db_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
11: g_db_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PRICING_ATTR

Line 16: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

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

Line 24: RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

20: FUNCTION Get_PRICING_ATTR
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_pricing_attribute_id IN NUMBER
23: )
24: RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
25:
26: PROCEDURE Clear_PRICING_ATTR;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

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

Line 78: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

74: , x_pricing_attribute_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75: , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76: )
77: IS
78: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
79: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);

Line 79: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;

75: , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76: )
77: IS
78: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
79: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);
83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

76: )
77: IS
78: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
79: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);
83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

79: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);
83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
86: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
87: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

80: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);
83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
86: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
87: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

81: l_control_rec QP_GLOBALS.Control_Rec_Type;
82: l_return_status VARCHAR2(1);
83: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
86: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
87: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
89: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

84: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
86: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
87: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
89: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
90: BEGIN
91:
92: oe_debug_pub.add('BEGIN Default_Attributes in QPXFPRAB');

Line 89: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

85: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
86: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
87: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
88: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
89: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
90: BEGIN
91:
92: oe_debug_pub.add('BEGIN Default_Attributes in QPXFPRAB');
93:

Line 347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

343: , x_pricing_attribute_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
344: , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
345: )
346: IS
347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

344: , x_comparison_operator_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
345: )
346: IS
347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;

345: )
346: IS
347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);

Line 350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

346: IS
347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);
354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

347: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
348: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
349: l_PRICING_ATTR_val_rec QP_Modifiers_PUB.Pricing_Attr_Val_Rec_Type;
350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);
354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

350: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);
354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
357: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
358: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

351: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);
354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
357: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
358: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

352: l_control_rec QP_GLOBALS.Control_Rec_Type;
353: l_return_status VARCHAR2(1);
354: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
357: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
358: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
360: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

355: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
357: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
358: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
360: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
361: BEGIN
362:
363: oe_debug_pub.add('BEGIN Change_Attribute in QPXFPRAB');

Line 360: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

356: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
357: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
358: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
359: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
360: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
361: BEGIN
362:
363: oe_debug_pub.add('BEGIN Change_Attribute in QPXFPRAB');
364:

Line 847: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

843: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
844: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
845: )
846: IS
847: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
848: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 848: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

844: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
845: )
846: IS
847: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
848: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);

Line 849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

845: )
846: IS
847: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
848: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);
853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

846: IS
847: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
848: l_old_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);
853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

849: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);
853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
856: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
857: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

850: l_old_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);
853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
856: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
857: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

851: l_control_rec QP_GLOBALS.Control_Rec_Type;
852: l_return_status VARCHAR2(1);
853: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
856: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
857: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
859: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

854: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
856: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
857: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
859: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
860: BEGIN
861:
862: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFPRAB');

Line 859: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

855: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
856: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
857: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
858: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
859: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
860: BEGIN
861:
862: oe_debug_pub.add('BEGIN Validate_And_Write in QPXFPRAB');
863:

Line 1015: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1011: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1012: , p_pricing_attribute_id IN NUMBER
1013: )
1014: IS
1015: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1016: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1017: l_control_rec QP_GLOBALS.Control_Rec_Type;
1018: l_return_status VARCHAR2(1);
1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1016: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1012: , p_pricing_attribute_id IN NUMBER
1013: )
1014: IS
1015: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1016: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1017: l_control_rec QP_GLOBALS.Control_Rec_Type;
1018: l_return_status VARCHAR2(1);
1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1015: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1016: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1017: l_control_rec QP_GLOBALS.Control_Rec_Type;
1018: l_return_status VARCHAR2(1);
1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1022: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1023: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1016: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1017: l_control_rec QP_GLOBALS.Control_Rec_Type;
1018: l_return_status VARCHAR2(1);
1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1022: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1023: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1017: l_control_rec QP_GLOBALS.Control_Rec_Type;
1018: l_return_status VARCHAR2(1);
1019: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1022: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1023: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1025: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1020: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1022: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1023: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1025: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1026: BEGIN
1027:
1028: oe_debug_pub.add('BEGIN Delete_Row in QPXFPRAB');

Line 1025: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1021: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1022: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1023: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1024: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1025: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1026: BEGIN
1027:
1028: oe_debug_pub.add('BEGIN Delete_Row in QPXFPRAB');
1029:

Line 1172: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1168: )
1169: IS
1170: l_control_rec QP_GLOBALS.Control_Rec_Type;
1171: l_return_status VARCHAR2(1);
1172: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1173: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1175: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1176: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1173: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1169: IS
1170: l_control_rec QP_GLOBALS.Control_Rec_Type;
1171: l_return_status VARCHAR2(1);
1172: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1173: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1175: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1176: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1170: l_control_rec QP_GLOBALS.Control_Rec_Type;
1171: l_return_status VARCHAR2(1);
1172: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1173: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1175: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1176: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1178: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1173: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1175: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1176: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1178: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1179: BEGIN
1180:
1181: oe_debug_pub.add('BEGIN Process_Entity in QPXFPRAB');

Line 1178: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1174: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1175: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1176: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1177: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1178: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1179: BEGIN
1180:
1181: oe_debug_pub.add('BEGIN Process_Entity in QPXFPRAB');
1182:

Line 1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1326: , p_comparison_operator_code IN VARCHAR2
1327: )
1328: IS
1329: l_return_status VARCHAR2(1);
1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1327: )
1328: IS
1329: l_return_status VARCHAR2(1);
1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1328: IS
1329: l_return_status VARCHAR2(1);
1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1336: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1329: l_return_status VARCHAR2(1);
1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1336: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1330: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1331: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1332: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1336: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1333: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1336: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1339: BEGIN
1340:
1341: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');

Line 1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1334: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1335: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1336: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1337: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1338: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1339: BEGIN
1340:
1341: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');
1342: oe_debug_pub.add('BEGIN Lock_Row in QPXFPRAB');

Line 1463: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

1459:
1460: -- Procedures maintaining PRICING_ATTR record cache.
1461:
1462: PROCEDURE Write_PRICING_ATTR
1463: ( p_PRICING_ATTR_rec IN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
1464: , p_db_record IN BOOLEAN := FALSE
1465: )
1466: IS
1467: BEGIN

Line 1487: RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type

1483: FUNCTION Get_PRICING_ATTR
1484: ( p_db_record IN BOOLEAN := FALSE
1485: , p_pricing_attribute_id IN NUMBER
1486: )
1487: RETURN QP_Modifiers_PUB.Pricing_Attr_Rec_Type
1488: IS
1489: BEGIN
1490: OE_Debug_PUB.Add('Begin Get_Pricing_Attr in QPXFPRAB');
1491:

Line 1530: g_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;

1526: IS
1527: BEGIN
1528:
1529: oe_debug_pub.add('BEGIN Clear_Pricing_Attr in QPXFPRAB');
1530: g_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1531: g_db_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1532:
1533: oe_debug_pub.add('END Clear_Pricing_Attr in QPXFPRAB');
1534: END Clear_Pricing_Attr;

Line 1531: g_db_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;

1527: BEGIN
1528:
1529: oe_debug_pub.add('BEGIN Clear_Pricing_Attr in QPXFPRAB');
1530: g_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1531: g_db_PRICING_ATTR_rec := QP_Modifiers_PUB.G_MISS_PRICING_ATTR_REC;
1532:
1533: oe_debug_pub.add('END Clear_Pricing_Attr in QPXFPRAB');
1534: END Clear_Pricing_Attr;
1535: