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

Line 10: g_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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

Line 11: g_db_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
11: g_db_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_MODIFIER_LIST

Line 16: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

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

Line 24: RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;

20: FUNCTION Get_MODIFIER_LIST
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_list_header_id IN NUMBER
23: )
24: RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type;
25:
26: PROCEDURE Clear_MODIFIER_LIST;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;

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

Line 100: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

96: --added for MOAC
97: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
98: )
99: IS
100: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
101: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
102: l_control_rec QP_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 101: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

97: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
98: )
99: IS
100: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
101: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
102: l_control_rec QP_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

100: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
101: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
102: l_control_rec QP_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
107: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
108: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

101: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
102: l_control_rec QP_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
107: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
108: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
109: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

102: l_control_rec QP_GLOBALS.Control_Rec_Type;
103: l_return_status VARCHAR2(1);
104: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
107: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
108: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
109: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
110: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 109: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

105: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
107: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
108: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
109: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
110: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
111: BEGIN
112:
113: oe_debug_pub.add('BEGIN default_attibutes in QPXFMLHB');

Line 110: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

106: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
107: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
108: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
109: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
110: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
111: BEGIN
112:
113: oe_debug_pub.add('BEGIN default_attibutes in QPXFMLHB');
114: -- Set control flags.

Line 402: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

398: --added for MOAC
399: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
400: )
401: IS
402: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
403: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);

Line 403: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

399: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
400: )
401: IS
402: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
403: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);
407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

400: )
401: IS
402: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
403: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);
407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

403: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);
407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
410: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
411: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

404: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);
407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
410: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
411: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

405: l_control_rec QP_GLOBALS.Control_Rec_Type;
406: l_return_status VARCHAR2(1);
407: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
410: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
411: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
413: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 412: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

408: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
410: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
411: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
413: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
414: BEGIN
415:
416: oe_debug_pub.add('BEGIN change_attibutes in QPXFMLHB');

Line 413: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

409: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
410: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
411: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
413: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
414: BEGIN
415:
416: oe_debug_pub.add('BEGIN change_attibutes in QPXFMLHB');
417: OE_Debug_Pub.add(to_char(p_attr_id)||'attr_id');

Line 1058: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1054: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
1055: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1056: )
1057: IS
1058: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1059: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1060: l_control_rec QP_GLOBALS.Control_Rec_Type;
1061: l_return_status VARCHAR2(1);
1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line 1059: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1055: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
1056: )
1057: IS
1058: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1059: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1060: l_control_rec QP_GLOBALS.Control_Rec_Type;
1061: l_return_status VARCHAR2(1);
1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1058: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1059: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1060: l_control_rec QP_GLOBALS.Control_Rec_Type;
1061: l_return_status VARCHAR2(1);
1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1065: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1066: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1059: l_old_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1060: l_control_rec QP_GLOBALS.Control_Rec_Type;
1061: l_return_status VARCHAR2(1);
1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1065: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1066: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1067: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1060: l_control_rec QP_GLOBALS.Control_Rec_Type;
1061: l_return_status VARCHAR2(1);
1062: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1065: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1066: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1067: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1068: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1067: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1063: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1065: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1066: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1067: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1068: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1069: BEGIN
1070:
1071: oe_debug_pub.add('BEGIN validate_and_write in QPXFMLHB');

Line 1068: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1064: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1065: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1066: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1067: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1068: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1069: BEGIN
1070:
1071: oe_debug_pub.add('BEGIN validate_and_write in QPXFMLHB');
1072: -- Set control flags.

Line 1217: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1213: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1214: , p_list_header_id IN NUMBER
1215: )
1216: IS
1217: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1218: l_control_rec QP_GLOBALS.Control_Rec_Type;
1219: l_return_status VARCHAR2(1);
1220: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

Line 1220: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1216: IS
1217: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1218: l_control_rec QP_GLOBALS.Control_Rec_Type;
1219: l_return_status VARCHAR2(1);
1220: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1223: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1224: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1217: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1218: l_control_rec QP_GLOBALS.Control_Rec_Type;
1219: l_return_status VARCHAR2(1);
1220: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1223: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1224: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1225: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1218: l_control_rec QP_GLOBALS.Control_Rec_Type;
1219: l_return_status VARCHAR2(1);
1220: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1223: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1224: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1225: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1226: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1225: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1221: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1223: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1224: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1225: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1226: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1227: BEGIN
1228:
1229: oe_debug_pub.add('BEGIN delete_row in QPXFMLHB');

Line 1226: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1222: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1223: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1224: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1225: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1226: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1227: BEGIN
1228:
1229: oe_debug_pub.add('BEGIN delete_row in QPXFMLHB');
1230: -- Set control flags.

Line 1352: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1348: )
1349: IS
1350: l_control_rec QP_GLOBALS.Control_Rec_Type;
1351: l_return_status VARCHAR2(1);
1352: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1353: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1355: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1356: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1353: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1349: IS
1350: l_control_rec QP_GLOBALS.Control_Rec_Type;
1351: l_return_status VARCHAR2(1);
1352: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1353: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1355: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1356: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1357: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1350: l_control_rec QP_GLOBALS.Control_Rec_Type;
1351: l_return_status VARCHAR2(1);
1352: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1353: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1355: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1356: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1357: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1358: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1357: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1353: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1355: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1356: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1357: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1358: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1359: BEGIN
1360:
1361: oe_debug_pub.add('BEGIN process_entity in QPXFMLHB');

Line 1358: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1354: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1355: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1356: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1357: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1358: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1359: BEGIN
1360:
1361: oe_debug_pub.add('BEGIN process_entity in QPXFMLHB');
1362: -- Set control flags.

Line 1469: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1465: )
1466: IS
1467: l_control_rec QP_GLOBALS.Control_Rec_Type;
1468: l_return_status VARCHAR2(1);
1469: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1470: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1472: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1473: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1470: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

1466: IS
1467: l_control_rec QP_GLOBALS.Control_Rec_Type;
1468: l_return_status VARCHAR2(1);
1469: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1470: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1472: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1473: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1474: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

Line 1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1467: l_control_rec QP_GLOBALS.Control_Rec_Type;
1468: l_return_status VARCHAR2(1);
1469: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1470: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1472: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1473: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1474: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1475: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1474: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

1470: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1472: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1473: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1474: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1475: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1476: BEGIN
1477:
1478: oe_debug_pub.add('BEGIN process_object in QPXFMLHB');

Line 1475: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1471: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1472: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1473: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1474: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1475: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1476: BEGIN
1477:
1478: oe_debug_pub.add('BEGIN process_object in QPXFMLHB');
1479: -- Set control flags.

Line 1594: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1590: x_msg_count number;
1591: x_msg_data Varchar2(2000);
1592: x_msg_index number;
1593:
1594: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1595: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1595: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

1591: x_msg_data Varchar2(2000);
1592: x_msg_index number;
1593:
1594: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1595: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1592: x_msg_index number;
1593:
1594: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1595: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

1593:
1594: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1595: l_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

Line 1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1596: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

Line 1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

1597: l_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1598: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1599: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1607: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

1600: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1607: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1608: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type

Line 1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

1601: l_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1607: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1608: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
1609: ;

Line 1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

1602:
1603: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1604: l_x_MODIFIER_LIST_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
1605: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1607: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1608: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
1609: ;
1610: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 1610: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1606: l_x_MODIFIERS_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
1607: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1608: l_x_QUALIFIERS_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
1609: ;
1610: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1611:
1612:
1613: l_x_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1614:

Line 1613: l_x_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

1609: ;
1610: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1611:
1612:
1613: l_x_PRICING_ATTR_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
1614:
1615: l_datatype VARCHAR2(1);
1616: l_precedence NUMBER;
1617: l_qualifier_grouping_no QP_QUALIFIERS.QUALIFIER_GROUPING_NO%TYPE;

Line 1712: QP_Modifiers_PUB.Process_Modifiers

1708:
1709: /* dhgupta for bug 1975291.Private package needs to be called instead of Public package */
1710:
1711: /*
1712: QP_Modifiers_PUB.Process_Modifiers
1713: ( p_api_version_number => 1.0
1714: , p_init_msg_list => FND_API.G_FALSE
1715: , p_return_values => FND_API.G_FALSE
1716: , p_commit => FND_API.G_FALSE

Line 1893: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

1889: , p_org_id IN NUMBER
1890: )
1891: IS
1892: l_return_status VARCHAR2(1);
1893: l_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

Line 1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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

Line 1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;

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

Line 1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

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

Line 1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;

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

Line 1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1902:
1903: oe_debug_pub.add('BEGIN lock_row in QPXFMLHB');
1904: -- Load MODIFIER_LIST record

Line 2033: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type

2029:
2030: -- Procedures maintaining MODIFIER_LIST record cache.
2031:
2032: PROCEDURE Write_MODIFIER_LIST
2033: ( p_MODIFIER_LIST_rec IN QP_Modifiers_PUB.Modifier_List_Rec_Type
2034: , p_db_record IN BOOLEAN := FALSE
2035: )
2036: IS
2037: BEGIN

Line 2055: RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type

2051: FUNCTION Get_MODIFIER_LIST
2052: ( p_db_record IN BOOLEAN := FALSE
2053: , p_list_header_id IN NUMBER
2054: )
2055: RETURN QP_Modifiers_PUB.Modifier_List_Rec_Type
2056: IS
2057: BEGIN
2058:
2059: oe_debug_pub.add('BEGIN get_modifier_list in QPXFMLHB');

Line 2096: g_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;

2092: PROCEDURE Clear_Modifier_List
2093: IS
2094: BEGIN
2095:
2096: g_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;
2097: g_db_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;
2098:
2099: END Clear_Modifier_List;
2100:

Line 2097: g_db_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;

2093: IS
2094: BEGIN
2095:
2096: g_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;
2097: g_db_MODIFIER_LIST_rec := QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC;
2098:
2099: END Clear_Modifier_List;
2100:
2101: