APPS.OE_BULK_HOLDS_PVT dependencies on OE_HOLD_SOURCES

Line 102: FROM OE_HOLD_SOURCES HS,

98: HS.HOLD_ENTITY_ID2,
99: HS.HOLD_ENTITY_CODE2,
100: HLD.ACTIVITY_NAME,
101: HS.HOLD_ID --ER# 3667551
102: FROM OE_HOLD_SOURCES HS,
103: OE_HOLD_DEFINITIONS HLD
104: WHERE --ER#7479609 HS.HOLD_ENTITY_CODE IN ('C','I','B','W','S')
105: HS.HOLD_ENTITY_CODE IN ('C','I','B','D','W','S','PL','OT','CD','SC','P','SM','EC','IC') --ER#7479609 --ER# 12571983 added ,'EC' --ER# 13331078 added 'IC'
106: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=

Line 4614: INSERT INTO OE_HOLD_SOURCES

4610:
4611: IF g_hold_source_rec.HOLD_SOURCE_ID.COUNT > 0 THEN
4612: FORALL i IN 1..g_hold_source_rec.HOLD_SOURCE_ID.COUNT
4613: --added org_id in insert for bug 5488209
4614: INSERT INTO OE_HOLD_SOURCES
4615: ( HOLD_SOURCE_ID
4616: , LAST_UPDATE_DATE
4617: , LAST_UPDATED_BY
4618: , CREATION_DATE

Line 4888: SELECT OE_HOLD_SOURCES_S.NEXTVAL

4884:
4885: g_hold_source_rec.HOLD_ID(i+1) := p_hold_id;
4886:
4887: -- Get the Hold Source Id
4888: SELECT OE_HOLD_SOURCES_S.NEXTVAL
4889: INTO g_hold_source_rec.HOLD_SOURCE_ID(i+1)
4890: FROM DUAL;
4891:
4892: g_hold_source_rec.HOLD_ENTITY_CODE(i+1) := 'O';