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.
PACKAGE: APPS.OE_HOLD_SOURCES_PVT

Source


1 PACKAGE OE_Hold_Sources_Pvt AS
2 /* $Header: OEXVHLSS.pls 120.0 2005/05/31 23:21:53 appldev noship $ */
3 
4 TYPE Hold_Source_REC IS RECORD
5 (	  HOLD_SOURCE_ID   		OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE := NULL
6 	, LAST_UPDATE_DATE    	OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE := NULL
7  	, LAST_UPDATED_BY       	OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE := NULL
8 	, CREATION_DATE         	OE_Hold_Sources_ALL.CREATION_DATE%TYPE := NULL
9  	, CREATED_BY            	OE_Hold_Sources_ALL.CREATED_BY%TYPE := NULL
10 	, LAST_UPDATE_LOGIN     	OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE := NULL
11  	, PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE := NULL
12  	, PROGRAM_ID            	OE_Hold_Sources_ALL.PROGRAM_ID%TYPE := NULL
13  	, PROGRAM_UPDATE_DATE   	OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE := NULL
14  	, REQUEST_ID            	OE_Hold_Sources_ALL.REQUEST_ID%TYPE := NULL
15  	, HOLD_ID               	OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
16  	, HOLD_ENTITY_CODE      	OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
17  	, HOLD_ENTITY_ID        	OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
18  	, HOLD_UNTIL_DATE        OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE := NULL
19  	, RELEASED_FLAG          OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE := 'N'
20  	, HOLD_COMMENT           OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE := NULL
21  	, CONTEXT               	OE_Hold_Sources_ALL.CONTEXT%TYPE := NULL
22  	, ATTRIBUTE1            	OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE := NULL
23  	, ATTRIBUTE2             OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE := NULL
24  	, ATTRIBUTE3			OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE := NULL
25  	, ATTRIBUTE4             OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE := NULL
26  	, ATTRIBUTE5             OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE := NULL
27  	, ATTRIBUTE6             OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE := NULL
28  	, ATTRIBUTE7             OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE := NULL
29  	, ATTRIBUTE8             OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE := NULL
30  	, ATTRIBUTE9             OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE := NULL
31  	, ATTRIBUTE10            OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE := NULL
32  	, ATTRIBUTE11            OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE := NULL
33  	, ATTRIBUTE12            OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE := NULL
34  	, ATTRIBUTE13    		OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE := NULL
35  	, ATTRIBUTE14           	OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE := NULL
36  	, ATTRIBUTE15           	OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE := NULL
37  	, ORG_ID                 OE_Hold_Sources_ALL.ORG_ID%TYPE := NULL
38  	, HOLD_RELEASE_ID        OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE := NULL
39  	, HOLD_ENTITY_CODE2     	OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
40  	, HOLD_ENTITY_ID2       	OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
41 );
42 
43 TYPE Hold_Release_REC IS RECORD
44 (	  HOLD_RELEASE_ID 		     OE_Hold_Releases.HOLD_RELEASE_ID%TYPE := NULL
45  	, CREATION_DATE           	OE_Hold_Releases.CREATION_DATE%TYPE := sysdate
46 	, CREATED_BY               	OE_Hold_Releases.CREATED_BY%TYPE := NULL
47  	, LAST_UPDATE_DATE        	OE_Hold_Releases.LAST_UPDATE_DATE%TYPE := sysdate
48  	, LAST_UPDATED_BY       	     OE_Hold_Releases.LAST_UPDATED_BY%TYPE := NULL
49  	, LAST_UPDATE_LOGIN        	OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE := NULL
50  	, PROGRAM_APPLICATION_ID   	OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE := NULL
51  	, PROGRAM_ID             	OE_Hold_Releases.PROGRAM_ID%TYPE := NULL
52  	, PROGRAM_UPDATE_DATE    	OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE := NULL
53  	, REQUEST_ID            	OE_Hold_Releases.REQUEST_ID%TYPE := NULL
54 	, HOLD_SOURCE_ID        	OE_Hold_Releases.HOLD_SOURCE_ID%TYPE := NULL
55  	, RELEASE_REASON_CODE  		OE_Hold_Releases.RELEASE_REASON_CODE%TYPE := NULL
56  	, RELEASE_COMMENT      		OE_Hold_Releases.RELEASE_COMMENT%TYPE := NULL
57  	, CONTEXT              		OE_Hold_Releases.CONTEXT%TYPE := NULL
58  	, ATTRIBUTE1           		OE_Hold_Releases.ATTRIBUTE1%TYPE := NULL
59  	, ATTRIBUTE2           		OE_Hold_Releases.ATTRIBUTE2%TYPE := NULL
60  	, ATTRIBUTE3           		OE_Hold_Releases.ATTRIBUTE3%TYPE := NULL
61  	, ATTRIBUTE4           		OE_Hold_Releases.ATTRIBUTE4%TYPE := NULL
62  	, ATTRIBUTE5            	OE_Hold_Releases.ATTRIBUTE5%TYPE := NULL
63  	, ATTRIBUTE6            	OE_Hold_Releases.ATTRIBUTE6%TYPE := NULL
64  	, ATTRIBUTE7            	OE_Hold_Releases.ATTRIBUTE7%TYPE := NULL
65  	, ATTRIBUTE8            	OE_Hold_Releases.ATTRIBUTE8%TYPE := NULL
66  	, ATTRIBUTE9            	OE_Hold_Releases.ATTRIBUTE9%TYPE := NULL
67  	, ATTRIBUTE10           	OE_Hold_Releases.ATTRIBUTE10%TYPE := NULL
68  	, ATTRIBUTE11           	OE_Hold_Releases.ATTRIBUTE11%TYPE := NULL
69  	, ATTRIBUTE12           	OE_Hold_Releases.ATTRIBUTE12%TYPE := NULL
70  	, ATTRIBUTE13           	OE_Hold_Releases.ATTRIBUTE13%TYPE := NULL
71  	, ATTRIBUTE14           	OE_Hold_Releases.ATTRIBUTE14%TYPE := NULL
72  	, ATTRIBUTE15            	OE_Hold_Releases.ATTRIBUTE15%TYPE := NULL
73 );
74 
75 G_MISS_HOLD_SOURCE_REC            Hold_Source_REC;
76 
77 G_MISS_HOLD_RELEASE_REC		  Hold_Release_REC;
78 
79 TYPE Hold_Source_TBL IS TABLE OF
80 	OE_Hold_Sources_Pvt.Hold_Source_REC
81 		INDEX BY BINARY_INTEGER;
82 
83 
84 PROCEDURE Create_Hold_Source
85 ( p_hold_source_rec	  IN   OE_Hold_Sources_Pvt.Hold_Source_REC
86 , p_validation_level  IN	  NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
87 , x_hold_source_id OUT NOCOPY NUMBER
88 
89 , x_return_status OUT NOCOPY VARCHAR2
90 
91 , x_msg_count OUT NOCOPY NUMBER
92 
93 , x_msg_data OUT NOCOPY VARCHAR2
94 
95 );
96 
97 
98 PROCEDURE Release_Hold_Source
99 ( p_hold_id			IN 	NUMBER DEFAULT NULL
100 , p_entity_code 		IN 	VARCHAR2 DEFAULT NULL
101 , p_entity_id   		IN 	NUMBER DEFAULT NULL
102 , p_entity_code2 		IN 	VARCHAR2 DEFAULT NULL
103 , p_entity_id2   		IN 	NUMBER DEFAULT NULL
104 , p_hold_release_rec	IN	OE_Hold_Sources_Pvt.Hold_Release_REC
105 , p_validation_level	IN	NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
106 , x_return_status OUT NOCOPY VARCHAR2
107 
108 , x_msg_count OUT NOCOPY NUMBER
109 
110 , x_msg_data OUT NOCOPY VARCHAR2
111 
112 );
113 
114 
115 PROCEDURE Query_Hold_Source
116 ( p_header_id			IN	NUMBER
117 , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL
118 
119 , x_return_status OUT NOCOPY VARCHAR2
120 
121 );
122 
123 PROCEDURE Query_Line__Hold_Source
124 ( p_line_id                     IN      NUMBER
125 , x_hold_source_tbl OUT NOCOPY OE_Hold_Sources_PVT.Hold_Source_TBL
126 , x_return_status OUT NOCOPY VARCHAR2
127 
128 );
129 
130 
131 PROCEDURE Insert_Hold_Release
132 ( p_hold_release_rec		IN	OE_Hold_Sources_Pvt.Hold_Release_Rec
133 , p_validation_level		IN	VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
134 , x_hold_release_id OUT NOCOPY NUMBER
135 
136 , x_return_status OUT NOCOPY VARCHAR2
137 
138  );
139 
140 
141 PROCEDURE Release_Hold_Source_WF
142 ( p_entity_code		IN VARCHAR2
143 , p_entity_id		IN NUMBER
144 , x_return_status OUT NOCOPY VARCHAR2
145 
146 );
147 
148 
149 END OE_Hold_Sources_Pvt;