DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_HOLDS_PVT

Line 545: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

541: l_line_ids_rec Line_Id_rec_Type;
542: l_return_status VARCHAR2(1);
543: l_msg_count NUMBER;
544: l_msg_data VARCHAR2(2000);
545: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
546: --
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
548: --
549:

Line 636: OE_Holds_Pvt.apply_holds

632: l_hold_source_rec.hold_entity_id := l_line_ids_rec.header_id;
633: l_hold_source_rec.line_id := l_line_ids_rec.line_id; -- Line level hold
634: l_hold_source_rec.header_id := l_line_ids_rec.header_id;
635:
636: OE_Holds_Pvt.apply_holds
637: ( p_hold_source_rec => l_hold_source_rec
638: , x_return_status => l_return_status
639: , x_msg_count => l_msg_count
640: , x_msg_data => l_msg_data );

Line 705: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

701: l_header_id NUMBER;
702: l_return_status VARCHAR2(1);
703: l_msg_count NUMBER;
704: l_msg_data VARCHAR2(2000);
705: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
706: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
707: --
708: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
709: --

Line 706: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;

702: l_return_status VARCHAR2(1);
703: l_msg_count NUMBER;
704: l_msg_data VARCHAR2(2000);
705: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
706: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
707: --
708: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
709: --
710:

Line 809: OE_Holds_Pvt.Release_Holds( p_hold_source_rec => l_hold_source_rec

805: l_hold_release_rec.release_reason_code := 'IR_ISO_HOLD';
806: -- We need to seed a new reason as a lookup code
807: l_hold_release_rec.release_comment := 'IR ISO Change Management System hold is released';
808:
809: OE_Holds_Pvt.Release_Holds( p_hold_source_rec => l_hold_source_rec
810: , p_hold_release_rec => l_hold_release_rec
811: , x_return_status => l_return_status
812: , x_msg_count => l_msg_count
813: , x_msg_data => l_msg_data );

Line 921: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

917: l_return_status VARCHAR2(1);
918: l_msg_count NUMBER;
919: l_msg_data VARCHAR2(2000);
920: l_hold_applied_count NUMBER := 0;
921: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
922: --
923: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
924: --
925: