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_PRICE_LIST dependencies on QP_PRICE_LIST_PUB

Line 10: g_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Price_List';
7:
8: -- Global variables holding cached record.
9:
10: g_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
11: g_db_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
11: g_db_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PRICE_LIST

Line 16: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PRICE_LIST
16: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_PRICE_LIST

Line 24: RETURN QP_Price_List_PUB.Price_List_Rec_Type;

20: FUNCTION Get_PRICE_LIST
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_list_header_id IN NUMBER
23: )
24: RETURN QP_Price_List_PUB.Price_List_Rec_Type;
25:
26: PROCEDURE Clear_PRICE_LIST;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Price_List_PUB.Price_List_Tbl_Type;

26: PROCEDURE Clear_PRICE_LIST;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Price_List_PUB.Price_List_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 98: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

94: --added for MOAC
95: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
96: )
97: IS
98: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;

95: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
96: )
97: IS
98: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

98: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
105: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
106: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

99: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
105: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
106: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
107: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

100: l_control_rec QP_GLOBALS.Control_Rec_Type;
101: l_return_status VARCHAR2(1);
102: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
105: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
106: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
107: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
108: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 107: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

103: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
105: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
106: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
107: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
108: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
109: --fname varchar2(80);
110: BEGIN
111:

Line 108: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

104: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
105: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
106: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
107: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
108: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
109: --fname varchar2(80);
110: BEGIN
111:
112: --oe_debug_pub.debug_on;

Line 414: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

410: --added for MOAC
411: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
412: )
413: IS
414: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);

Line 415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

411: , x_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
412: )
413: IS
414: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;

412: )
413: IS
414: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

415: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
422: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
423: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

416: l_PRICE_LIST_val_rec QP_Price_List_PUB.Price_List_Val_Rec_Type;
417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
422: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
423: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
424: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

417: l_control_rec QP_GLOBALS.Control_Rec_Type;
418: l_return_status VARCHAR2(1);
419: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
422: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
423: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
424: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
425: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 424: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

420: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
422: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
423: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
424: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
425: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
426: BEGIN
427:
428: -- Set control flags.

Line 425: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

421: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
422: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
423: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
424: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
425: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
426: BEGIN
427:
428: -- Set control flags.
429:

Line 1035: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1031: , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
1032: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
1033: )
1034: IS
1035: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1032: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
1033: )
1034: IS
1035: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1035: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1042: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1043: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1036: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1042: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1043: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1044: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1037: l_control_rec QP_GLOBALS.Control_Rec_Type;
1038: l_return_status VARCHAR2(1);
1039: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1042: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1043: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1044: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1045: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1044: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1040: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1042: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1043: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1044: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1045: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1046: BEGIN
1047:
1048: -- Set control flags.

Line 1045: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1041: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1042: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1043: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1044: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1045: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1046: BEGIN
1047:
1048: -- Set control flags.
1049:

Line 1196: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1192: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1193: , p_list_header_id IN NUMBER
1194: )
1195: IS
1196: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1197: l_control_rec QP_GLOBALS.Control_Rec_Type;
1198: l_return_status VARCHAR2(1);
1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1195: IS
1196: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1197: l_control_rec QP_GLOBALS.Control_Rec_Type;
1198: l_return_status VARCHAR2(1);
1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1202: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1203: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1196: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1197: l_control_rec QP_GLOBALS.Control_Rec_Type;
1198: l_return_status VARCHAR2(1);
1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1202: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1203: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1204: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1197: l_control_rec QP_GLOBALS.Control_Rec_Type;
1198: l_return_status VARCHAR2(1);
1199: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1202: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1203: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1204: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1205: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1204: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1200: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1202: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1203: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1204: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1205: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1206: BEGIN
1207:
1208: -- Set control flags.

Line 1205: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1201: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1202: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1203: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1204: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1205: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1206: BEGIN
1207:
1208: -- Set control flags.
1209:

Line 1329: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1325: )
1326: IS
1327: l_control_rec QP_GLOBALS.Control_Rec_Type;
1328: l_return_status VARCHAR2(1);
1329: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1332: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1333: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1326: IS
1327: l_control_rec QP_GLOBALS.Control_Rec_Type;
1328: l_return_status VARCHAR2(1);
1329: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1332: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1333: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1334: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1327: l_control_rec QP_GLOBALS.Control_Rec_Type;
1328: l_return_status VARCHAR2(1);
1329: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1332: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1333: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1334: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1335: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1334: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1330: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1332: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1333: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1334: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1335: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1336: BEGIN
1337:
1338: -- Set control flags.

Line 1335: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1331: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1332: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1333: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1334: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1335: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1336: BEGIN
1337:
1338: -- Set control flags.
1339:

Line 1444: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1440: )
1441: IS
1442: l_control_rec QP_GLOBALS.Control_Rec_Type;
1443: l_return_status VARCHAR2(1);
1444: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1447: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1448: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1441: IS
1442: l_control_rec QP_GLOBALS.Control_Rec_Type;
1443: l_return_status VARCHAR2(1);
1444: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1447: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1448: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1449: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1442: l_control_rec QP_GLOBALS.Control_Rec_Type;
1443: l_return_status VARCHAR2(1);
1444: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1447: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1448: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1449: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1450: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1449: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1445: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1447: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1448: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1449: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1450: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1451: BEGIN
1452:
1453: -- Set control flags.

Line 1450: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1446: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1447: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1448: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1449: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1450: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1451: BEGIN
1452:
1453: -- Set control flags.
1454:

Line 1613: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1609: , p_org_id IN NUMBER
1610: )
1611: IS
1612: l_return_status VARCHAR2(1);
1613: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1614: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1614: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1610: )
1611: IS
1612: l_return_status VARCHAR2(1);
1613: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1614: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1618: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1611: IS
1612: l_return_status VARCHAR2(1);
1613: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1614: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1618: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1619: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1612: l_return_status VARCHAR2(1);
1613: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1614: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1618: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1619: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1620: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1619: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1615: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1618: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1619: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1620: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1621: BEGIN
1622:
1623: -- Load PRICE_LIST record

Line 1620: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1616: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1617: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1618: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1619: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1620: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1621: BEGIN
1622:
1623: -- Load PRICE_LIST record
1624: oe_debug_pub.add('Lock_Row in QPXFPLHB, next call to QPXVPRLB::Lock_PRICE_LIST');

Line 1756: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type

1752:
1753: -- Procedures maintaining PRICE_LIST record cache.
1754:
1755: PROCEDURE Write_PRICE_LIST
1756: ( p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
1757: , p_db_record IN BOOLEAN := FALSE
1758: )
1759: IS
1760: BEGIN

Line 1776: RETURN QP_Price_List_PUB.Price_List_Rec_Type

1772: FUNCTION Get_PRICE_LIST
1773: ( p_db_record IN BOOLEAN := FALSE
1774: , p_list_header_id IN NUMBER
1775: )
1776: RETURN QP_Price_List_PUB.Price_List_Rec_Type
1777: IS
1778: BEGIN
1779:
1780: IF p_list_header_id <> g_PRICE_LIST_rec.list_header_id

Line 1813: g_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;

1809: PROCEDURE Clear_Price_List
1810: IS
1811: BEGIN
1812:
1813: g_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;
1814: g_db_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;
1815:
1816: END Clear_Price_List;
1817:

Line 1814: g_db_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;

1810: IS
1811: BEGIN
1812:
1813: g_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;
1814: g_db_PRICE_LIST_rec := QP_Price_List_PUB.G_MISS_PRICE_LIST_REC;
1815:
1816: END Clear_Price_List;
1817:
1818: Procedure Clear_Record