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_PRL_FORM_QUALIFIERS dependencies on QP_QUALIFIER_RULES_PUB

Line 10: g_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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:

Line 11: g_db_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 16: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 24: RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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.

Line 30: g_opr__tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

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:

Line 88: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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);

Line 89: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

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;

Line 90: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_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;

Line 96: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_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;

Line 97: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_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;

Line 100: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_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;
102: BEGIN
103:
104: -- Set control flags.

Line 407: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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;

Line 408: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_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;

Line 409: l_QUALIFIERS_val_rec QP_Qualifier_Rules_PUB.Qualifiers_Val_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);

Line 410: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

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;

Line 411: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_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;

Line 414: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_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;

Line 415: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 416: l_x_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;
420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 951: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 952: l_old_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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);

Line 953: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

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;

Line 954: l_old_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_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;

Line 957: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_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;

Line 958: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 959: l_x_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;
963: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1150: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1151: l_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_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;

Line 1154: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_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;

Line 1155: l_x_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;
1159: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1156: l_x_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;
1160: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1305: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_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;

Line 1306: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1307: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1479: l_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1480: l_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;

Line 1481: l_x_QUALIFIER_RULES_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_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;

Line 1482: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1483: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_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;

Line 1626: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_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

Line 1646: RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 1683: g_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;

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:

Line 1684: g_db_QUALIFIERS_rec := QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC;

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

Line 1708: l_QUALIFIER_RULES_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Rec_Type;

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;

Line 1709: l_QUALIFIER_RULES_val_rec QP_Qualifier_Rules_pub.Qualifier_Rules_Val_Rec_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;

Line 1710: l_QUALIFIERS_tbl QP_Qualifier_Rules_pub.Qualifiers_Tbl_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;

Line 1711: l_QUALIFIERS_val_tbl QP_Qualifier_Rules_pub.Qualifiers_Val_Tbl_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;

Line 1712: l_x_qualifiers_tbl QP_Qualifier_Rules_pub.Qualifiers_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:

Line 1713: l_x_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:
1717: BEGIN

Line 1714: l_x_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
1718:

Line 1715: l_x_qualifiers_val_tbl QP_Qualifier_Rules_pub.Qualifiers_val_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:
1719: l_qualifier_rule_id := p_qualifier_rule_id;

Line 1733: qp_qualifier_rules_pub.get_qualifier_rules(

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,