1: PACKAGE BODY OE_Hold_Sources_Pvt AS
2: /* $Header: OEXVHLSB.pls 120.2 2005/08/10 12:08:44 zbutt noship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXVHLSB.pls 120.2 2005/08/10 12:08:44 zbutt noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Hold_Sources_Pvt';
7:
8:
9: PROCEDURE Utilities
10: ( p_user_id OUT NOCOPY NUMBER)
220: END ValidateHoldSource;
221:
222:
223: PROCEDURE Create_Hold_Source
224: ( p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC
225: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
226: , x_hold_source_id OUT NOCOPY NUMBER
227:
228: , x_return_status OUT NOCOPY VARCHAR2
242: --
243: BEGIN
244:
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( 'IN OE_HOLD_SOURCES_PVT.CREATE_HOLD_SOURCE' ) ;
247: END IF;
248: SAVEPOINT Create_Hold_Source;
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
440: , p_entity_code IN VARCHAR2 DEFAULT NULL
441: , p_entity_id IN NUMBER DEFAULT NULL
442: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
443: , p_entity_id2 IN NUMBER DEFAULT NULL
444: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
445: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
446: , x_return_status OUT NOCOPY VARCHAR2
447:
448: , x_msg_count OUT NOCOPY NUMBER
453: IS
454: l_user_id NUMBER;
455: l_hold_source_id NUMBER;
456: l_hold_release_id NUMBER;
457: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC;
458: CURSOR hold_source IS
459: SELECT HS.HOLD_SOURCE_ID
460: FROM OE_HOLD_SOURCES HS
461: WHERE HS.HOLD_ID = p_hold_id
498: END IF;
499:
500:
501: -- Inserting record into the hold releases table
502: OE_Hold_Sources_Pvt.Insert_Hold_Release
503: ( p_hold_release_rec => l_hold_release_rec
504: , p_validation_level => p_validation_level
505: , x_hold_release_id => l_hold_release_id
506: , x_return_status => x_return_status
559:
560:
561: PROCEDURE Query_Hold_Source
562: ( p_header_id IN NUMBER
563: , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL
564:
565: , x_return_status OUT NOCOPY VARCHAR2
566:
567: )
565: , x_return_status OUT NOCOPY VARCHAR2
566:
567: )
568: IS
569: l_hold_source_REC OE_Hold_Sources_Pvt.Hold_Source_REC;
570: i BINARY_INTEGER := 0;
571: CURSOR hold_source_REC IS
572: SELECT
573: HOLD_SOURCE_ID
642:
643:
644: PROCEDURE Query_Line__Hold_Source
645: ( p_line_id IN NUMBER
646: , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL
647: , x_return_status OUT NOCOPY VARCHAR2
648:
649: )
650: IS
647: , x_return_status OUT NOCOPY VARCHAR2
648:
649: )
650: IS
651: l_hold_source_REC OE_Hold_Sources_Pvt.Hold_Source_REC;
652: i BINARY_INTEGER := 0;
653: CURSOR hold_source_REC IS
654: SELECT
655: HOLD_SOURCE_ID
722:
723:
724:
725: PROCEDURE Insert_Hold_Release
726: ( p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_Rec
727: , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
728: , x_hold_release_id OUT NOCOPY NUMBER
729:
730: , x_return_status OUT NOCOPY VARCHAR2
1043:
1044: END Release_Hold_Source_WF;
1045:
1046:
1047: END OE_Hold_Sources_Pvt;