APPS.OE_ORDER_PRICE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 1980: oe_price_adj_assocs assoc,

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

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

3640: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ATTRIBS' , 3 ) ;
3641: END IF;
3642:
3643: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3644: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE price_adjustment_id = p_adj_id_tbl(i);
3645: IF l_debug_level > 0 THEN
3646: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ASSOCS' , 3 ) ;
3647: END IF;
3648:

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

3646: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' ASSOCS' , 3 ) ;
3647: END IF;
3648:
3649: FORALL i IN p_adj_id_tbl.FIRST..p_adj_id_tbl.LAST
3650: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE rltd_price_adj_id = p_adj_id_tbl(i);
3651: IF l_debug_level > 0 THEN
3652: oe_debug_pub.add( ' DELETED '||SQL%ROWCOUNT||' RLTD ASSOCS' , 3 ) ;
3653: END IF;
3654:

Line 4605: INSERT INTO OE_PRICE_ADJ_ASSOCS

4601: END IF;
4602:
4603: /*Insert ASSO for header level adj
4604: * Comment out--Not possible to have header level adjustments with associations
4605: INSERT INTO OE_PRICE_ADJ_ASSOCS
4606: ( PRICE_ADJUSTMENT_ID
4607: ,CREATION_DATE
4608: ,CREATED_BY
4609: ,LAST_UPDATE_DATE

Line 4632: ,OE_PRICE_ADJ_ASSOCS_S.nextval

4628: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4629: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4630: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4631: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4632: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4633: ,ADJ.LINE_ID
4634: ,RADJ.PRICE_ADJUSTMENT_ID
4635: ,1
4636: FROM QP_PREQ_RLTD_LINES_TMP RLTD ,

Line 4651: INSERT INTO OE_PRICE_ADJ_ASSOCS

4647: QPL.LINE_INDEX = RLTD.LINE_INDEX AND
4648: QPL.LINE_TYPE_CODE = 'ORDER');
4649: */
4650: l_stmt:=8;
4651: INSERT INTO OE_PRICE_ADJ_ASSOCS
4652: ( PRICE_ADJUSTMENT_ID
4653: ,CREATION_DATE
4654: ,CREATED_BY
4655: ,LAST_UPDATE_DATE

Line 4678: ,OE_PRICE_ADJ_ASSOCS_S.nextval

4674: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
4675: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
4676: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
4677: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
4678: ,OE_PRICE_ADJ_ASSOCS_S.nextval
4679: ,ADJ.LINE_ID
4680: ,RADJ.PRICE_ADJUSTMENT_ID
4681: ,1
4682: FROM

Line 4697: FROM OE_PRICE_ADJ_ASSOCS

4693: RLTD.RELATED_LIST_LINE_ID = RADJ.LIST_LINE_ID AND
4694: ADJ.LINE_ID = RADJ.LINE_ID AND
4695: RADJ.PRICE_ADJUSTMENT_ID
4696: NOT IN (SELECT RLTD_PRICE_ADJ_ID
4697: FROM OE_PRICE_ADJ_ASSOCS
4698: WHERE PRICE_ADJUSTMENT_ID = ADJ.PRICE_ADJUSTMENT_ID ) AND
4699: RLTD.PRICING_STATUS_CODE = 'N');
4700:
4701: