[Home] [Help]
5483: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5484: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5485: l_ordered_item varchar2(300);
5486: cursor adj_cur is
5487: select modified_from from oe_price_adjustments
5488: where line_id=px_line_rec.line_id
5489: and list_line_type_code='IUE';
5490: begin
5491: adj_debug('Entering oe_order_Adj_pvt.Get_item_for_iue',1);
7247: Rownum < 2;
7248: */
7249:
7250: Select inventory_item_id into l_inventory_item_id
7251: from oe_price_adjustments opa,oe_order_lines_all ola
7252: where opa.line_id=ola.line_id and
7253: opa.price_adjustment_id=p_price_Adjustment_Id;
7254:
7255: Exception when no_data_found then
8835: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8836:
8837: Cursor prg_lines is
8838: Select radj.line_id
8839: from oe_price_adjustments radj,
8840: oe_price_adj_assocs assoc
8841: where radj.price_adjustment_id =assoc.rltd_price_adj_id and
8842: assoc.price_adjustment_id = p_price_adjustment_id;
8843:
8862: adj_debug('price_adjustment_id = ' || p_price_adjustment_id);
8863: begin
8864: select pricing_phase_id
8865: into pricing_ph_id
8866: from oe_price_adjustments
8867: where price_adjustment_id = p_price_adjustment_id;
8868: exception when no_data_found Then
8869: adj_debug('No pricing phase id for this price adjustment');
8870: pricing_ph_id := NULL;
11525: l_prev_line_hdr_id Number;
11526:
11527: cursor has_prg_lines(p_line_id IN NUMBER) is
11528: Select 'Y'
11529: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11530: Where b.line_id = p_line_id
11531: AND b.header_id = a.header_id
11532: And a.list_line_type_code = 'PRG';
11533:
11892: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11893:
11894: cursor has_prg_lines(p_line_id IN NUMBER) is
11895: Select 'Y'
11896: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
11897: Where b.line_id = p_line_id
11898: AND b.header_id = a.header_id
11899: And a.list_line_type_code = 'PRG';
11900:
12393: End get_quote;
12394:
12395: /***************************************************************************************************
12396: Procedure Create_Manual_Adjustments
12397: Purpose : Insert manual overriable adjustment into Oe_Price_Adjustments
12398: Called by : Mass Change pld
12399: Known Issues: Doesn't handle order level manual overriable adjustment
12400: ****************************************************************************************************/
12401: Procedure Create_Manual_Adjustments(p_line_id In Number)
12434: stmt:='2';
12435: i := l_manual_adj_tbl.First;
12436: While i Is Not Null Loop
12437: If l_manual_adj_tbl(i).override_flag = 'Y' Then
12438: --check if such modifier list exists in Oe_Price_Adjustments
12439: --If it is there don't insert a new one
12440: Oe_debug_Pub.add(' Override_flag:'||l_manual_adj_tbl(i).override_flag);
12441: Begin
12442: Select 'Y' Into l_found
12440: Oe_debug_Pub.add(' Override_flag:'||l_manual_adj_tbl(i).override_flag);
12441: Begin
12442: Select 'Y' Into l_found
12443: From Dual
12444: Where exists (Select 'X' From Oe_Price_Adjustments
12445: Where line_id = p_line_id
12446: and list_line_id = l_manual_adj_tbl(i).list_line_id);
12447: l_found:='Y';
12448: Exception
12451: End;
12452: stmt:='10';
12453: --Insert only if no modifier list line found.
12454: If l_found = 'N' Then
12455: oe_debug_pub.add(' Creating overridable manual in oe_price_adjustments');
12456: l_line_adj_tbl(1).list_line_no := l_manual_adj_tbl(i).modifier_number; /* Bug #3738023 */
12457: l_line_adj_tbl(1).list_header_id := l_manual_adj_tbl(i).list_header_id;
12458: l_line_adj_tbl(1).list_line_id := l_manual_adj_tbl(i).list_line_id;
12459: l_line_adj_tbl(1).list_line_type_code := l_manual_adj_tbl(i).list_line_type_code;
12466: l_line_adj_tbl(1).applied_flag := 'N';
12467: l_line_adj_tbl(1).updated_flag := 'N';
12468: l_line_adj_tbl(1).automatic_flag := 'N';
12469: l_line_adj_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
12470: Select Oe_Price_Adjustments_S.Nextval
12471: Into l_line_adj_tbl(1).price_adjustment_id
12472: From dual;
12473: stmt:='20';
12474: Line_Adjs(p_validation_level => FND_API.G_VALID_LEVEL_NONE,