DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on QP_GLOBALS

Line 77: l_control_rec QP_GLOBALS.Control_Rec_Type;

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

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

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

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

146: l_qualifiers_tbl(1).qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
147: -- Blanket Header ID is the qualifier attribute value
148: l_qualifiers_tbl(1).qualifier_attr_value := l_blanket_header_id;
149: l_qualifiers_tbl(1).qualifier_grouping_no := 1;
150: l_qualifiers_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
151: -- Bug 3314789
152: l_qualifiers_tbl(1).active_flag := 'Y'; /* jhkuo */
153: l_qualifiers_tbl(1).list_type_code := 'DLT'; /* jhkuo */
154:

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

227: ELSIF l_request_rec.param2 IS NOT NULL THEN
228: l_modifiers_tbl(J).arithmetic_operator := 'AMT';
229: l_modifiers_tbl(J).operand := l_request_rec.param2;
230: END IF;
231: l_modifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
232:
233: -----------------------------------------------------------
234: -- Set up the item context on pricing attributes record
235: -----------------------------------------------------------

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

247: l_pricing_attr_tbl(J).product_attribute:= 'PRICING_ATTRIBUTE1';
248: l_pricing_attr_tbl(J).PRODUCT_ATTR_VALUE := l_request_rec.param3;
249: end if;
250: l_pricing_attr_tbl(J).modifiers_index := J;
251: l_pricing_attr_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
252:
253: -- Keep track of which modifier line index corresponds to which
254: -- blanket line ID.
255: l_line_id_tbl(J) := l_request_rec.entity_id;

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

328: -- Blanket Line ID is the qualifier attribute value
329: oe_debug_pub.add('entity id :'||l_line_id_tbl(J));
330: l_qualifiers_tbl(J).qualifier_attr_value := l_line_id_tbl(J);
331: l_qualifiers_tbl(J).qualifier_grouping_no := 1;
332: l_qualifiers_tbl(J).operation := QP_GLOBALS.G_OPR_CREATE;
333: -- Copy list line ID from created modiifer lines table
334: l_qualifiers_tbl(J).list_header_id :=
335: l_x_modifiers_tbl(J).list_header_id;
336: l_qualifiers_tbl(J).list_line_id :=

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

371: -- Update modifier IDs on blanket tables
372: -------------------------------------------------------------------
373:
374: -- Update modifier list header id on blanket header table
375: IF l_modifier_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
376:
377: if l_debug_level > 0 then
378: oe_debug_pub.add('blanket header id :'||l_blanket_header_id);
379: oe_debug_pub.add('set modifier list id :'||

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

476: end if;
477:
478: IF p_list_header_id IS NOT NULL THEN
479: gpr_price_list_rec.list_header_id := p_list_header_id;
480: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
481: gpr_price_list_rec.end_date_active := trunc(sysdate);
482: END IF;
483:
484: IF p_list_line_id IS NOT NULL THEN

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

482: END IF;
483:
484: IF p_list_line_id IS NOT NULL THEN
485: gpr_price_list_line_tbl(1).list_line_id := p_list_line_id;
486: gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;
487: gpr_price_list_line_tbl(1).end_date_active := trunc(sysdate);
488: END IF;
489:
490: QP_PRICE_LIST_GRP.Process_Price_List

Line 552: l_control_rec QP_GLOBALS.Control_Rec_Type;

548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
551: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
552: l_control_rec QP_GLOBALS.Control_Rec_Type;
553: BEGIN
554:
555: if l_debug_level > 0 then
556: oe_debug_pub.add('Enter Deactivate_Modifier');

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

559: end if;
560:
561: IF p_list_header_id IS NOT NULL THEN
562: l_modifier_list_rec.list_header_id := p_list_header_id;
563: l_modifier_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
564: l_modifier_list_rec.end_date_active := trunc(sysdate);
565: END IF;
566:
567: IF p_list_line_id IS NOT NULL THEN

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

565: END IF;
566:
567: IF p_list_line_id IS NOT NULL THEN
568: l_modifiers_tbl(1).list_line_id := p_list_line_id;
569: l_modifiers_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;
570: l_modifiers_tbl(1).end_date_active := trunc(sysdate);
571: END IF;
572:
573: -------------------------------------------------------------------