[Home] [Help]
5566: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5567: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5568: l_ordered_item varchar2(300);
5569: cursor adj_cur is
5570: select modified_from from oe_price_adjustments
5571: where line_id=px_line_rec.line_id
5572: and list_line_type_code='IUE';
5573: begin
5574: adj_debug('Entering oe_order_Adj_pvt.Get_item_for_iue',1);
7339: Rownum < 2;
7340: */
7341:
7342: Select inventory_item_id into l_inventory_item_id
7343: from oe_price_adjustments opa,oe_order_lines_all ola
7344: where opa.line_id=ola.line_id and
7345: opa.price_adjustment_id=p_price_Adjustment_Id;
7346:
7347: Exception when no_data_found then
8927: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8928:
8929: Cursor prg_lines is
8930: Select radj.line_id
8931: from oe_price_adjustments radj,
8932: oe_price_adj_assocs assoc
8933: where radj.price_adjustment_id =assoc.rltd_price_adj_id and
8934: assoc.price_adjustment_id = p_price_adjustment_id;
8935:
8954: adj_debug('price_adjustment_id = ' || p_price_adjustment_id);
8955: begin
8956: select pricing_phase_id
8957: into pricing_ph_id
8958: from oe_price_adjustments
8959: where price_adjustment_id = p_price_adjustment_id;
8960: exception when no_data_found Then
8961: adj_debug('No pricing phase id for this price adjustment');
8962: pricing_ph_id := NULL;
11634: l_locked_header_rec OE_ORDER_PUB.Header_Rec_Type; --13727700
11635:
11636: cursor has_prg_lines(p_line_id IN NUMBER) is
11637: Select 'Y'
11638: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11639: Where b.line_id = p_line_id
11640: AND b.header_id = a.header_id
11641: And a.list_line_type_code = 'PRG';
11642:
12032: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
12033:
12034: cursor has_prg_lines(p_line_id IN NUMBER) is
12035: Select 'Y'
12036: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
12037: Where b.line_id = p_line_id
12038: AND b.header_id = a.header_id
12039: And a.list_line_type_code = 'PRG';
12040:
12548: End get_quote;
12549:
12550: /***************************************************************************************************
12551: Procedure Create_Manual_Adjustments
12552: Purpose : Insert manual overriable adjustment into Oe_Price_Adjustments
12553: Called by : Mass Change pld
12554: Known Issues: Doesn't handle order level manual overriable adjustment
12555: ****************************************************************************************************/
12556: Procedure Create_Manual_Adjustments(p_line_id In Number)
12589: stmt:='2';
12590: i := l_manual_adj_tbl.First;
12591: While i Is Not Null Loop
12592: If l_manual_adj_tbl(i).override_flag = 'Y' Then
12593: --check if such modifier list exists in Oe_Price_Adjustments
12594: --If it is there don't insert a new one
12595: Oe_debug_Pub.add(' Override_flag:'||l_manual_adj_tbl(i).override_flag);
12596: Begin
12597: Select 'Y' Into l_found
12595: Oe_debug_Pub.add(' Override_flag:'||l_manual_adj_tbl(i).override_flag);
12596: Begin
12597: Select 'Y' Into l_found
12598: From Dual
12599: Where exists (Select 'X' From Oe_Price_Adjustments
12600: Where line_id = p_line_id
12601: and list_line_id = l_manual_adj_tbl(i).list_line_id);
12602: l_found:='Y';
12603: Exception
12606: End;
12607: stmt:='10';
12608: --Insert only if no modifier list line found.
12609: If l_found = 'N' Then
12610: oe_debug_pub.add(' Creating overridable manual in oe_price_adjustments');
12611: l_line_adj_tbl(1).list_line_no := l_manual_adj_tbl(i).modifier_number; /* Bug #3738023 */
12612: l_line_adj_tbl(1).list_header_id := l_manual_adj_tbl(i).list_header_id;
12613: l_line_adj_tbl(1).list_line_id := l_manual_adj_tbl(i).list_line_id;
12614: l_line_adj_tbl(1).list_line_type_code := l_manual_adj_tbl(i).list_line_type_code;
12621: l_line_adj_tbl(1).applied_flag := 'N';
12622: l_line_adj_tbl(1).updated_flag := 'N';
12623: l_line_adj_tbl(1).automatic_flag := 'N';
12624: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
12625: Select Oe_Price_Adjustments_S.Nextval
12626: Into l_line_adj_tbl(1).price_adjustment_id
12627: From dual;
12628: stmt:='20';
12629: Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,