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_SOURCES

Line 1: PACKAGE BODY OE_Hold_Sources_Pvt AS

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:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Hold_Sources_Pvt';

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)

Line 224: ( p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC

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

Line 246: oe_debug_pub.add( 'IN OE_HOLD_SOURCES_PVT.CREATE_HOLD_SOURCE' ) ;

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;

Line 296: FROM OE_HOLD_SOURCES

292:
293: -- Check for duplicate hold source
294: SELECT count(*)
295: INTO l_count
296: FROM OE_HOLD_SOURCES
297: WHERE hold_id = p_hold_source_rec.hold_id
298: AND hold_entity_code = p_hold_source_rec.hold_entity_code
299: AND hold_entity_id = p_hold_source_rec.hold_entity_id
300: AND nvl(hold_entity_code2, 'NO_ENTITY_CODE2') =

Line 322: SELECT OE_HOLD_SOURCES_S.NEXTVAL

318:
319:
320: -- Inserting a NEW HOLD SOURCE record
321:
322: SELECT OE_HOLD_SOURCES_S.NEXTVAL
323: INTO x_hold_source_id
324: FROM DUAL;
325:
326:

Line 327: INSERT INTO OE_HOLD_SOURCES_ALL

323: INTO x_hold_source_id
324: FROM DUAL;
325:
326:
327: INSERT INTO OE_HOLD_SOURCES_ALL
328: ( HOLD_SOURCE_ID
329: , LAST_UPDATE_DATE
330: , LAST_UPDATED_BY
331: , CREATION_DATE

Line 444: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC

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

Line 457: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC;

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

Line 460: FROM OE_HOLD_SOURCES HS

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
462: AND HS.RELEASED_FLAG = 'N'
463: AND NVL(HS.HOLD_UNTIL_DATE, SYSDATE + 1) > SYSDATE
464: AND HS.HOLD_ENTITY_CODE = p_entity_code

Line 502: OE_Hold_Sources_Pvt.Insert_Hold_Release

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

Line 535: UPDATE oe_hold_sources

531: , x_return_status => x_return_status
532: );
533:
534: -- Flag the hold source as released
535: UPDATE oe_hold_sources
536: SET hold_release_id = l_hold_release_id
537: , released_flag = 'Y'
538: , LAST_UPDATED_BY = l_user_id
539: , LAST_UPDATE_DATE = sysdate

Line 563: , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL

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: )

Line 569: l_hold_source_REC OE_Hold_Sources_Pvt.Hold_Source_REC;

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

Line 609: FROM OE_HOLD_SOURCES

605: , ORG_ID
606: , HOLD_RELEASE_ID
607: , HOLD_ENTITY_CODE2
608: , HOLD_ENTITY_ID2
609: FROM OE_HOLD_SOURCES
610: WHERE hold_source_id IN (SELECT hold_source_id
611: FROM OE_ORDER_HOLDS
612: WHERE header_id = p_header_id
613: AND line_id IS NULL

Line 646: , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL

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

Line 651: l_hold_source_REC OE_Hold_Sources_Pvt.Hold_Source_REC;

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

Line 691: FROM OE_HOLD_SOURCES

687: , ORG_ID
688: , HOLD_RELEASE_ID
689: , HOLD_ENTITY_CODE2
690: , HOLD_ENTITY_ID2
691: FROM OE_HOLD_SOURCES
692: WHERE hold_source_id IN (SELECT hold_source_id
693: FROM OE_ORDER_HOLDS
694: WHERE line_id = p_line_id
695: AND hold_release_id IS NULL

Line 726: ( p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_Rec

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

Line 785: --FROM oe_hold_sources

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;
787:
788:
789: IF l_debug_level > 0 THEN

Line 1047: END OE_Hold_Sources_Pvt;

1043:
1044: END Release_Hold_Source_WF;
1045:
1046:
1047: END OE_Hold_Sources_Pvt;