DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on QP_GLOBALS

Line 76: l_control_rec QP_GLOBALS.Control_Rec_Type;

72: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
73: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
74: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
75: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77:
78: l_line_id_tbl OE_GLOBALS.Number_Tbl_Type;
79: l_hdr_req_index NUMBER;
80: l_line_req_index_tbl OE_GLOBALS.Number_Tbl_Type;

Line 117: l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;

113: -- Bug 3210361 -
114: -- Blanket modifiers were not being applied
115: l_modifier_list_rec.start_date_active := trunc(sysdate);
116: l_modifier_list_rec.automatic_flag := 'Y';
117: l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
118: l_hdr_req_index := p_index;
119:
120: -- Add blanket header qualifier
121: l_qualifiers_tbl(1).excluder_flag := 'N';

Line 129: l_qualifiers_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;

125: l_qualifiers_tbl(1).qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
126: -- Blanket Header ID is the qualifier attribute value
127: l_qualifiers_tbl(1).qualifier_attr_value := l_blanket_header_id;
128: l_qualifiers_tbl(1).qualifier_grouping_no := 1;
129: l_qualifiers_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
130: -- Bug 3314789
131: l_qualifiers_tbl(1).active_flag := 'Y'; /* jhkuo */
132: l_qualifiers_tbl(1).list_type_code := 'DLT'; /* jhkuo */
133:

Line 210: l_modifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;

206: ELSIF l_request_rec.param2 IS NOT NULL THEN
207: l_modifiers_tbl(J).arithmetic_operator := 'AMT';
208: l_modifiers_tbl(J).operand := l_request_rec.param2;
209: END IF;
210: l_modifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
211:
212: -----------------------------------------------------------
213: -- Set up the item context on pricing attributes record
214: -----------------------------------------------------------

Line 230: l_pricing_attr_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;

226: l_pricing_attr_tbl(J).product_attribute:= 'PRICING_ATTRIBUTE1';
227: l_pricing_attr_tbl(J).PRODUCT_ATTR_VALUE := l_request_rec.param3;
228: end if;
229: l_pricing_attr_tbl(J).modifiers_index := J;
230: l_pricing_attr_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
231:
232: -- Keep track of which modifier line index corresponds to which
233: -- blanket line ID.
234: l_line_id_tbl(J) := l_request_rec.entity_id;

Line 311: l_qualifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;

307: -- Blanket Line ID is the qualifier attribute value
308: oe_debug_pub.add('entity id :'||l_line_id_tbl(J));
309: l_qualifiers_tbl(J).qualifier_attr_value := l_line_id_tbl(J);
310: l_qualifiers_tbl(J).qualifier_grouping_no := 1;
311: l_qualifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
312: -- Copy list line ID from created modiifer lines table
313: l_qualifiers_tbl(J).list_header_id :=
314: l_x_modifiers_tbl(J).list_header_id;
315: l_qualifiers_tbl(J).list_line_id :=

Line 354: IF l_modifier_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

350: -- Update modifier IDs on blanket tables
351: -------------------------------------------------------------------
352:
353: -- Update modifier list header id on blanket header table
354: IF l_modifier_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
355:
356: if l_debug_level > 0 then
357: oe_debug_pub.add('blanket header id :'||l_blanket_header_id);
358: oe_debug_pub.add('set modifier list id :'||

Line 459: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

455: end if;
456:
457: IF p_list_header_id IS NOT NULL THEN
458: gpr_price_list_rec.list_header_id := p_list_header_id;
459: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
460: gpr_price_list_rec.end_date_active := trunc(sysdate);
461: END IF;
462:
463: IF p_list_line_id IS NOT NULL THEN

Line 465: gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;

461: END IF;
462:
463: IF p_list_line_id IS NOT NULL THEN
464: gpr_price_list_line_tbl(1).list_line_id := p_list_line_id;
465: gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;
466: gpr_price_list_line_tbl(1).end_date_active := trunc(sysdate);
467: END IF;
468:
469: QP_PRICE_LIST_GRP.Process_Price_List

Line 531: l_control_rec QP_GLOBALS.Control_Rec_Type;

527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
530: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
531: l_control_rec QP_GLOBALS.Control_Rec_Type;
532: BEGIN
533:
534: if l_debug_level > 0 then
535: oe_debug_pub.add('Enter Deactivate_Modifier');

Line 542: l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

538: end if;
539:
540: IF p_list_header_id IS NOT NULL THEN
541: l_modifier_list_rec.list_header_id := p_list_header_id;
542: l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
543: l_modifier_list_rec.end_date_active := trunc(sysdate);
544: END IF;
545:
546: IF p_list_line_id IS NOT NULL THEN

Line 548: l_modifiers_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;

544: END IF;
545:
546: IF p_list_line_id IS NOT NULL THEN
547: l_modifiers_tbl(1).list_line_id := p_list_line_id;
548: l_modifiers_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;
549: l_modifiers_tbl(1).end_date_active := trunc(sysdate);
550: END IF;
551:
552: -------------------------------------------------------------------