6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_PRL_Form_Qualifiers';
7:
8: -- Global variables holding cached record.
9:
10: g_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
11: g_db_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
7:
8: -- Global variables holding cached record.
9:
10: g_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
11: g_db_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_QUALIFIERS
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_QUALIFIERS
16: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_QUALIFIERS
20: FUNCTION Get_QUALIFIERS
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_qualifier_id IN NUMBER
23: )
24: RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
25:
26: PROCEDURE Clear_QUALIFIERS;
27:
28: -- Global variable holding performed operations.
26: PROCEDURE Clear_QUALIFIERS;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:
84: , x_qualifier_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85: , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
86: )
87: IS
88: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
89: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
90: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
85: , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
86: )
87: IS
88: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
89: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
90: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
86: )
87: IS
88: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
89: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
90: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
91: l_control_rec QP_GLOBALS.Control_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
92: l_return_status VARCHAR2(1);
93: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
95: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
97: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
99: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
93: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
94: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
95: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
96: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
97: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
99: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
101: l_qualifier_group_no number := -1;
96: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
97: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
98: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
99: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
100: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
101: l_qualifier_group_no number := -1;
102: BEGIN
103:
104: -- Set control flags.
403: , x_qualifier_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
404: , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
405: )
406: IS
407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
404: , x_qualify_hier_descendent_flag OUT NOCOPY VARCHAR2 -- Added for TCA
405: )
406: IS
407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
405: )
406: IS
407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
406: IS
407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
415: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
415: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
416: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
417: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
418: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
415: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
416: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
417: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
418: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
419: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
412: l_control_rec QP_GLOBALS.Control_Rec_Type;
413: l_return_status VARCHAR2(1);
414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
415: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
416: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
417: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
418: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
419: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
947: , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
948: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
949: )
950: IS
951: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
952: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
948: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
949: )
950: IS
951: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
952: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
949: )
950: IS
951: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
952: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
950: IS
951: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
952: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
958: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
958: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
959: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
960: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
961: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
958: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
959: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
960: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
961: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
962: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
955: l_control_rec QP_GLOBALS.Control_Rec_Type;
956: l_return_status VARCHAR2(1);
957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
958: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
959: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
960: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
961: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
962: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
963: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1146: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1147: , p_qualifier_id IN NUMBER
1148: )
1149: IS
1150: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1151: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1152: l_control_rec QP_GLOBALS.Control_Rec_Type;
1153: l_return_status VARCHAR2(1);
1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1147: , p_qualifier_id IN NUMBER
1148: )
1149: IS
1150: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1151: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1152: l_control_rec QP_GLOBALS.Control_Rec_Type;
1153: l_return_status VARCHAR2(1);
1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1150: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1151: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1152: l_control_rec QP_GLOBALS.Control_Rec_Type;
1153: l_return_status VARCHAR2(1);
1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1157: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1158: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1151: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1152: l_control_rec QP_GLOBALS.Control_Rec_Type;
1153: l_return_status VARCHAR2(1);
1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1157: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1158: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1159: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1152: l_control_rec QP_GLOBALS.Control_Rec_Type;
1153: l_return_status VARCHAR2(1);
1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1155: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1156: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1157: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1158: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1159: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1160: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1301: )
1302: IS
1303: l_control_rec QP_GLOBALS.Control_Rec_Type;
1304: l_return_status VARCHAR2(1);
1305: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1306: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1307: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1308: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1309: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1302: IS
1303: l_control_rec QP_GLOBALS.Control_Rec_Type;
1304: l_return_status VARCHAR2(1);
1305: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1306: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1307: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1308: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1309: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1310: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1303: l_control_rec QP_GLOBALS.Control_Rec_Type;
1304: l_return_status VARCHAR2(1);
1305: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1306: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1307: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1308: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1309: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1310: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1311: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1475: , p_qualify_hier_descendent_flag IN VARCHAR2 -- Added for TCA
1476: )
1477: IS
1478: l_return_status VARCHAR2(1);
1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1480: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1476: )
1477: IS
1478: l_return_status VARCHAR2(1);
1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1480: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1484: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1477: IS
1478: l_return_status VARCHAR2(1);
1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1480: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1484: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1485: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1478: l_return_status VARCHAR2(1);
1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1480: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1484: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1485: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1486: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1480: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1484: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1485: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1486: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1487: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1622:
1623: -- Procedures maintaining QUALIFIERS record cache.
1624:
1625: PROCEDURE Write_QUALIFIERS
1626: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1627: , p_db_record IN BOOLEAN := FALSE
1628: )
1629: IS
1630: BEGIN
1642: FUNCTION Get_QUALIFIERS
1643: ( p_db_record IN BOOLEAN := FALSE
1644: , p_qualifier_id IN NUMBER
1645: )
1646: RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
1647: IS
1648: BEGIN
1649:
1650: IF p_qualifier_id <> g_QUALIFIERS_rec.qualifier_id
1679: PROCEDURE Clear_Qualifiers
1680: IS
1681: BEGIN
1682:
1683: g_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;
1684: g_db_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;
1685:
1686: END Clear_Qualifiers;
1687:
1680: IS
1681: BEGIN
1682:
1683: g_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;
1684: g_db_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;
1685:
1686: END Clear_Qualifiers;
1687:
1688: --spgopal added out parameters to error out when copy failed
1704: l_list_line_id number;
1705: l_max_grouping_no NUMBER;
1706: l_list_type_code VARCHAR2(30);
1707:
1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1705: l_max_grouping_no NUMBER;
1706: l_list_type_code VARCHAR2(30);
1707:
1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1706: l_list_type_code VARCHAR2(30);
1707:
1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1707:
1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_tbl_type;
1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_tbl_type;
1716:
1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_Type;
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_tbl_type;
1716:
1717: BEGIN
1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_tbl_type;
1716:
1717: BEGIN
1718:
1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_Type;
1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_Type;
1713: l_x_qualifier_rules_rec QP_Qualifier_Rules_pub.Qualifier_rules_rec_type;
1714: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_pub.Qualifier_rules_val_rec_type;
1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_tbl_type;
1716:
1717: BEGIN
1718:
1719: l_qualifier_rule_id := p_qualifier_rule_id;
1729: WHEN OTHERS THEN
1730: l_list_type_code := '';
1731: END;
1732:
1733: qp_qualifier_rules_pub.get_qualifier_rules(
1734: p_api_version_number => 1.0,
1735: p_init_msg_list => 'F',
1736: p_return_values => 'F',
1737: x_return_status => l_return_status,