DBA Data[Home] [Help]

APPS.QP_QP_FORM_PLL_PRICING_ATTR dependencies on QP_PRICE_LIST_PUB

Line 10: g_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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

Line 11: g_db_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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

Line 16: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

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

Line 24: RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type;

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

Line 30: g_opr__tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

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

Line 83: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

79: , p_pricing_attribute_context IN VARCHAR2 := NULL
80: , p_pricing_attribute IN VARCHAR2 := NULL
81: )
82: IS
83: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);

Line 84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;

80: , p_pricing_attribute IN VARCHAR2 := NULL
81: )
82: IS
83: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

81: )
82: IS
83: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

84: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
91: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
92: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

85: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
91: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
92: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
91: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
92: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
94: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

89: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
91: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
92: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
94: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
95: BEGIN
96:
97: oe_debug_pub.add('Ren: inside default attr of prc attr 1');

Line 94: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

90: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
91: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
92: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
94: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
95: BEGIN
96:
97: oe_debug_pub.add('Ren: inside default attr of prc attr 1');
98: -- Set control flags.

Line 377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

373: , x_pricing_attribute_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374: , x_product_attribute_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
375: )
376: IS
377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

374: , x_product_attribute_datatype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
375: )
376: IS
377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;

375: )
376: IS
377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);

Line 380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

376: IS
377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

377: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
378: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
379: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

380: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
387: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
388: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

381: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
387: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
388: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
389: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

382: l_control_rec QP_GLOBALS.Control_Rec_Type;
383: l_return_status VARCHAR2(1);
384: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
387: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
388: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
389: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
390: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 389: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

385: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
387: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
388: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
389: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
390: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
391: BEGIN
392:
393: -- Set control flags.

Line 390: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

386: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
387: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
388: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
389: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
390: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
391: BEGIN
392:
393: -- Set control flags.
394:

Line 882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

878: , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
879: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
880: )
881: IS
882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

879: , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
880: )
881: IS
882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);

Line 884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

880: )
881: IS
882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

881: IS
882: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
883: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

884: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
891: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
892: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

885: l_old_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
891: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
892: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

886: l_control_rec QP_GLOBALS.Control_Rec_Type;
887: l_return_status VARCHAR2(1);
888: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
891: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
892: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
894: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

889: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
891: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
892: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
894: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
895: BEGIN
896:
897: oe_debug_pub.add('entering validate_and_write');

Line 894: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

890: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
891: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
892: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
894: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
895: BEGIN
896:
897: oe_debug_pub.add('entering validate_and_write');
898: -- Set control flags.

Line 1059: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1055: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1056: , p_pricing_attribute_id IN NUMBER
1057: )
1058: IS
1059: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1056: , p_pricing_attribute_id IN NUMBER
1057: )
1058: IS
1059: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1059: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1066: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1067: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1060: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1066: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1067: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1068: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1061: l_control_rec QP_GLOBALS.Control_Rec_Type;
1062: l_return_status VARCHAR2(1);
1063: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1066: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1067: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1068: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1069: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1068: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1064: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1066: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1067: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1068: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1069: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1070: -- start bug2301959
1071: l_revision VARCHAR2(30);
1072: l_start_date_active DATE;

Line 1069: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1065: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1066: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1067: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1068: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1069: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1070: -- start bug2301959
1071: l_revision VARCHAR2(30);
1072: l_start_date_active DATE;
1073: l_end_date_active DATE;

Line 1258: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1254: )
1255: IS
1256: l_control_rec QP_GLOBALS.Control_Rec_Type;
1257: l_return_status VARCHAR2(1);
1258: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1261: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1262: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1255: IS
1256: l_control_rec QP_GLOBALS.Control_Rec_Type;
1257: l_return_status VARCHAR2(1);
1258: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1261: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1262: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1263: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1256: l_control_rec QP_GLOBALS.Control_Rec_Type;
1257: l_return_status VARCHAR2(1);
1258: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1261: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1262: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1263: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1264: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1263: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1259: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1261: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1262: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1263: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1264: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1265: BEGIN
1266:
1267: -- Set control flags.

Line 1264: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1260: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1261: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1262: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1263: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1264: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1265: BEGIN
1266:
1267: -- Set control flags.
1268:

Line 1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1409: , p_product_attribute_datatype IN VARCHAR2
1410: )
1411: IS
1412: l_return_status VARCHAR2(1);
1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1410: )
1411: IS
1412: l_return_status VARCHAR2(1);
1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1411: IS
1412: l_return_status VARCHAR2(1);
1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1419: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1412: l_return_status VARCHAR2(1);
1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1419: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1413: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1414: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1415: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1419: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1421: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1416: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1419: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1421: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1422: BEGIN
1423:
1424: -- Load PRICING_ATTR record

Line 1421: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1417: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1418: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1419: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1420: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1421: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1422: BEGIN
1423:
1424: -- Load PRICING_ATTR record
1425:

Line 1541: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type

1537:
1538: -- Procedures maintaining PRICING_ATTR record cache.
1539:
1540: PROCEDURE Write_PRICING_ATTR
1541: ( p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
1542: , p_db_record IN BOOLEAN := FALSE
1543: )
1544: IS
1545: BEGIN

Line 1561: RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type

1557: FUNCTION Get_PRICING_ATTR
1558: ( p_db_record IN BOOLEAN := FALSE
1559: , p_pricing_attribute_id IN NUMBER
1560: )
1561: RETURN QP_Price_List_PUB.Pricing_Attr_Rec_Type
1562: IS
1563: BEGIN
1564:
1565: IF p_pricing_attribute_id <> g_PRICING_ATTR_rec.pricing_attribute_id

Line 1598: g_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;

1594: PROCEDURE Clear_Pricing_Attr
1595: IS
1596: BEGIN
1597:
1598: g_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1599: g_db_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1600:
1601: END Clear_Pricing_Attr;
1602:

Line 1599: g_db_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;

1595: IS
1596: BEGIN
1597:
1598: g_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1599: g_db_PRICING_ATTR_rec := QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC;
1600:
1601: END Clear_Pricing_Attr;
1602:
1603: -- This procedure will be called from the client when the user

Line 1693: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1689: l_new_pricing_attribute_id Number;
1690: --added for related lines duplication
1691: l_new_list_line_id Number;
1692: l_list_line_type_code Varchar2(30);
1693: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1690: --added for related lines duplication
1691: l_new_list_line_id Number;
1692: l_list_line_type_code Varchar2(30);
1693: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

Line 1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1692: l_list_line_type_code Varchar2(30);
1693: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1693: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;

1694: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

1695: --added for related lines duplication
1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;

1696: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1697: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1698: l_x_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1704: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

1699: l_x_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1704: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1705: l_control_rec QP_GLOBALS.Control_Rec_Type;
1706: l_return_status varchar2(1);
1707: l_continuous_price_break_flag varchar2(1);

Line 1704: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

1700: l_x_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
1701: l_x_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
1702: l_x_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
1703: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1704: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1705: l_control_rec QP_GLOBALS.Control_Rec_Type;
1706: l_return_status varchar2(1);
1707: l_continuous_price_break_flag varchar2(1);
1708: