APPS.OE_BULK_VALUE_TO_ID dependencies on OE_PRICE_ADJS_INTERFACE

Line 1991: UPDATE OE_PRICE_ADJS_INTERFACE a

1987:
1988: -- Value to ID conversions for adjustments
1989: -- List Header ID, List Line ID
1990:
1991: UPDATE OE_PRICE_ADJS_INTERFACE a
1992: SET (LIST_HEADER_ID, ERROR_FLAG) =
1993: (SELECT b.list_header_id
1994: , decode(b.list_header_id,NULL,'Y',NULL)
1995: FROM QP_LIST_HEADERS_TL b

Line 2007: UPDATE OE_PRICE_ADJS_INTERFACE a

2003: WHERE batch_id = p_batch_id)
2004: AND a.LIST_HEADER_ID IS NULL
2005: AND a.LIST_NAME IS NOT NULL;
2006:
2007: UPDATE OE_PRICE_ADJS_INTERFACE a
2008: SET (LIST_LINE_ID, LIST_LINE_TYPE_CODE, ERROR_FLAG) =
2009: (SELECT b.list_line_id
2010: , b.list_line_type_code
2011: , decode(b.list_line_id,NULL,'Y',NULL)

Line 2045: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h

2041: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_LINE_TYPE_CODE'
2042: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2043: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2044: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2045: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2046: WHERE h.batch_id = p_batch_id
2047: AND a.order_source_id = h.order_source_id
2048: AND a.orig_sys_document_ref = h.orig_sys_document_ref
2049: AND (a.list_line_type_code NOT IN ('DIS','FREIGHT_CHARGE','SUR','PBH')