eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLD_SOURCES_PVT dependencies on OE_HOLD_RELEASES

Line 782: -- and hold_entity_code are removed from OE_HOLD_RELEASES.

778:
779: END IF; -- End of Validation
780:
781: -- To_do : Remove the following code when the redundant columns hold_entity_id
782: -- and hold_entity_code are removed from OE_HOLD_RELEASES.
783: --SELECT hold_entity_id, hold_entity_code
784: --INTO l_hold_entity_id, l_hold_entity_code
785: --FROM oe_hold_sources
786: --WHERE hold_source_id = p_hold_release_rec.hold_source_id;

Line 794: SELECT OE_HOLD_RELEASES_S.NEXTVAL

790: oe_debug_pub.add( 'BEFORE INSERT' ) ;
791: END IF;
792:
793:
794: SELECT OE_HOLD_RELEASES_S.NEXTVAL
795: INTO x_hold_release_id
796: FROM DUAL;
797:
798: INSERT INTO OE_HOLD_RELEASES

Line 798: INSERT INTO OE_HOLD_RELEASES

794: SELECT OE_HOLD_RELEASES_S.NEXTVAL
795: INTO x_hold_release_id
796: FROM DUAL;
797:
798: INSERT INTO OE_HOLD_RELEASES
799: ( HOLD_RELEASE_ID
800: , CREATION_DATE
801: , CREATED_BY
802: , LAST_UPDATE_DATE

Line 844: -- and hold_entity_code are removed from OE_HOLD_RELEASES.

840: , p_hold_release_rec.PROGRAM_UPDATE_DATE
841: , p_hold_release_rec.REQUEST_ID
842: , p_hold_release_rec.HOLD_SOURCE_ID
843: -- To_do : Remove the following code when the redundant columns hold_entity_id
844: -- and hold_entity_code are removed from OE_HOLD_RELEASES.
845: -- , l_hold_entity_id
846: -- , l_hold_entity_code
847: , p_hold_release_rec.RELEASE_REASON_CODE
848: , p_hold_release_rec.RELEASE_COMMENT