DBA Data[Home] [Help]

APPS.OE_HOLD_SOURCES_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 5: ( HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE := NULL

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

Line 6: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE := NULL

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

Line 7: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE := NULL

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

Line 8: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE := NULL

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

Line 9: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE := NULL

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

Line 10: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%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

Line 11: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%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

Line 12: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%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

Line 13: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_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

Line 14: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%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

Line 15: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%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'

Line 16: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%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

Line 17: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_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

Line 18: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_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

Line 19: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE := 'N'

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

Line 20: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%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

Line 21: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%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

Line 22: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%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

Line 23: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%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

Line 24: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE := NULL

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

Line 25: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%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

Line 26: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%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

Line 27: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%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

Line 28: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%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

Line 29: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%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

Line 30: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%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

Line 31: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%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

Line 32: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%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

Line 33: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%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

Line 34: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%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

Line 35: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%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

Line 36: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%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

Line 37: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%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: );

Line 38: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%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:

Line 39: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%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

Line 40: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%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