APPS.OE_ORDER_PRICE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 1979: oe_price_adj_assocs assoc,

1975: line_Tbl_Index pls_integer;
1976: Cursor prg_lines is
1977: select adj1.line_id prg_line_id, assoc.rltd_price_adj_id
1978: from oe_price_adjustments adj1,
1979: oe_price_adj_assocs assoc,
1980: oe_price_adjustments adj2
1981: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
1982: assoc.price_adjustment_id = adj2.price_adjustment_id AND
1983: adj2.list_line_type_code = 'PRG' AND

Line 3531: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE price_adjustment_id = p_adj_id_tbl(i);

3527: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ATTRIBS' , 3 ) ;
3528: END IF;
3529:
3530: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3531: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE price_adjustment_id = p_adj_id_tbl(i);
3532: IF l_debug_level > 0 THEN
3533: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ASSOCS' , 3 ) ;
3534: END IF;
3535:

Line 3537: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE rltd_price_adj_id = p_adj_id_tbl(i);

3533: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ASSOCS' , 3 ) ;
3534: END IF;
3535:
3536: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3537: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE rltd_price_adj_id = p_adj_id_tbl(i);
3538: IF l_debug_level > 0 THEN
3539: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' RLTD ASSOCS' , 3 ) ;
3540: END IF;
3541:

Line 4490: INSERT INTO OE_PRICE_ADJ_ASSOCS

4486: END IF;
4487:
4488: /*Insert ASSO for header level adj
4489: * Comment out--Not possible to have header level adjustments with associations
4490: INSERT INTO OE_PRICE_ADJ_ASSOCS
4491: ( PRICE_ADJUSTMENT_ID
4492: ,CREATION_DATE
4493: ,CREATED_BY
4494: ,LAST_UPDATE_DATE

Line 4517: ,OE_PRICE_ADJ_ASSOCS_S.nextval

4513: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4514: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4515: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4516: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4517: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4518: ,ADJ.LINE_ID
4519: ,RADJ.PRICE_ADJUSTMENT_ID
4520: ,1
4521: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,

Line 4536: INSERT INTO OE_PRICE_ADJ_ASSOCS

4532: QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4533: QPL.LINE_TYPE_CODE = 'ORDER');
4534: */
4535: l_stmt:=8;
4536: INSERT INTO OE_PRICE_ADJ_ASSOCS
4537: ( PRICE_ADJUSTMENT_ID
4538: ,CREATION_DATE
4539: ,CREATED_BY
4540: ,LAST_UPDATE_DATE

Line 4563: ,OE_PRICE_ADJ_ASSOCS_S.nextval

4559: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4560: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4561: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4562: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4563: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4564: ,ADJ.LINE_ID
4565: ,RADJ.PRICE_ADJUSTMENT_ID
4566: ,1
4567: FROM

Line 4582: FROM OE_PRICE_ADJ_ASSOCS

4578: RLTD.RELATED_LIST_LINE_ID = RADJ.LIST_LINE_ID AND
4579: ADJ.LINE_ID = RADJ.LINE_ID AND
4580: RADJ.PRICE_ADJUSTMENT_ID
4581: NOT IN (SELECT RLTD_PRICE_ADJ_ID
4582: FROM OE_PRICE_ADJ_ASSOCS
4583: WHERE PRICE_ADJUSTMENT_ID = ADJ.PRICE_ADJUSTMENT_ID ) AND
4584: RLTD.PRICING_STATUS_CODE = 'N');
4585:
4586: