APPS.OE_BULK_HOLDS_PVT dependencies on OE_HOLD_SOURCES

Line 65: FROM OE_HOLD_SOURCES HS,

61: HS.HOLD_ENTITY_CODE,
62: HS.HOLD_ENTITY_ID2,
63: HS.HOLD_ENTITY_CODE2,
64: HLD.ACTIVITY_NAME
65: FROM OE_HOLD_SOURCES HS,
66: OE_HOLD_DEFINITIONS HLD
67: WHERE --ER#7479609 HS.HOLD_ENTITY_CODE IN ('C','I','B','W','S')
68: HS.HOLD_ENTITY_CODE IN ('C','I','B','D','W','S','PL','OT','CD','SC','P','SM') --ER#7479609
69: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=

Line 3014: INSERT INTO OE_HOLD_SOURCES

3010:
3011: IF g_hold_source_rec.HOLD_SOURCE_ID.COUNT > 0 THEN
3012: FORALL i IN 1..g_hold_source_rec.HOLD_SOURCE_ID.COUNT
3013: --added org_id in insert for bug 5488209
3014: INSERT INTO OE_HOLD_SOURCES
3015: ( HOLD_SOURCE_ID
3016: , LAST_UPDATE_DATE
3017: , LAST_UPDATED_BY
3018: , CREATION_DATE

Line 3288: SELECT OE_HOLD_SOURCES_S.NEXTVAL

3284:
3285: g_hold_source_rec.HOLD_ID(i+1) := p_hold_id;
3286:
3287: -- Get the Hold Source Id
3288: SELECT OE_HOLD_SOURCES_S.NEXTVAL
3289: INTO g_hold_source_rec.HOLD_SOURCE_ID(i+1)
3290: FROM DUAL;
3291:
3292: g_hold_source_rec.HOLD_ENTITY_CODE(i+1) := 'O';