DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_HOLDS_PVT

Line 548: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

544: l_line_ids_rec Line_Id_rec_Type;
545: l_return_status VARCHAR2(1);
546: l_msg_count NUMBER;
547: l_msg_data VARCHAR2(2000);
548: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
549: --
550: -- Modified for 8583903
551: l_file_val VARCHAR2(2000);
552: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

Line 659: OE_Holds_Pvt.apply_holds

655: l_hold_source_rec.line_id := l_line_ids_rec.line_id; -- Line level hold
656: l_hold_source_rec.header_id := l_line_ids_rec.header_id;
657:
658: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397
659: OE_Holds_Pvt.apply_holds
660: ( p_hold_source_rec => l_hold_source_rec
661: , x_return_status => l_return_status
662: , x_msg_count => l_msg_count
663: , x_msg_data => l_msg_data );

Line 752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

748: l_header_id NUMBER;
749: l_return_status VARCHAR2(1);
750: l_msg_count NUMBER;
751: l_msg_data VARCHAR2(2000);
752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
753: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
754: --
755: -- Added for 8583903
756: l_file_val VARCHAR2(2000);

Line 753: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;

749: l_return_status VARCHAR2(1);
750: l_msg_count NUMBER;
751: l_msg_data VARCHAR2(2000);
752: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
753: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
754: --
755: -- Added for 8583903
756: l_file_val VARCHAR2(2000);
757: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

Line 876: OE_Holds_Pvt.Release_Holds( p_hold_source_rec => l_hold_source_rec

872: -- We need to seed a new reason as a lookup code
873: l_hold_release_rec.release_comment := 'IR ISO Change Management System hold is released';
874:
875: OE_GLOBALS.G_SYS_HOLD := TRUE; -- bug 9494397
876: OE_Holds_Pvt.Release_Holds( p_hold_source_rec => l_hold_source_rec
877: , p_hold_release_rec => l_hold_release_rec
878: , x_return_status => l_return_status
879: , x_msg_count => l_msg_count
880: , x_msg_data => l_msg_data );

Line 1013: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;

1009: l_return_status VARCHAR2(1);
1010: l_msg_count NUMBER;
1011: l_msg_data VARCHAR2(2000);
1012: l_hold_applied_count NUMBER := 0;
1013: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
1014: --
1015: -- Added for 8583903
1016: l_file_val VARCHAR2(2000);
1017: l_debug_level NUMBER := oe_debug_pub.g_debug_level;