DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

2: /* $Header: OEXVHLDS.pls 120.6.12020000.1 2012/06/26 10:23:00 appldev ship $ */
3:
4: -- Hold Source
5: TYPE Hold_Source_Rec_Type IS RECORD (
6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE

Line 7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE

3:
4: -- Hold Source
5: TYPE Hold_Source_Rec_Type IS RECORD (
6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE

Line 8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE

4: -- Hold Source
5: TYPE Hold_Source_Rec_Type IS RECORD (
6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE

Line 9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE

5: TYPE Hold_Source_Rec_Type IS RECORD (
6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE

Line 10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE

6: HOLD_SOURCE_ID OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE

Line 11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE

7: , LAST_UPDATE_DATE OE_Hold_Sources_ALL.LAST_UPDATE_DATE%TYPE
8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE

Line 12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE

8: , LAST_UPDATED_BY OE_Hold_Sources_ALL.LAST_UPDATED_BY%TYPE
9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE

Line 13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE

9: , CREATION_DATE OE_Hold_Sources_ALL.CREATION_DATE%TYPE
10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE

Line 14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE

10: , CREATED_BY OE_Hold_Sources_ALL.CREATED_BY%TYPE
11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE

Line 15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE

11: , LAST_UPDATE_LOGIN OE_Hold_Sources_ALL.LAST_UPDATE_LOGIN%TYPE
12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE

Line 16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE

12: , PROGRAM_APPLICATION_ID OE_Hold_Sources_ALL.PROGRAM_APPLICATION_ID%TYPE
13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE

Line 17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE

13: , PROGRAM_ID OE_Hold_Sources_ALL.PROGRAM_ID%TYPE
14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE

Line 18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE

14: , PROGRAM_UPDATE_DATE OE_Hold_Sources_ALL.PROGRAM_UPDATE_DATE%TYPE
15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE

Line 19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE

15: , REQUEST_ID OE_Hold_Sources_ALL.REQUEST_ID%TYPE
16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE

Line 20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE

16: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE
17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE

Line 21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE

17: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE
18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE

Line 22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE

18: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE
19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE

Line 23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE

19: , HOLD_UNTIL_DATE OE_Hold_Sources_ALL.HOLD_UNTIL_DATE%TYPE
20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE

Line 24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE

20: , RELEASED_FLAG OE_Hold_Sources_ALL.RELEASED_FLAG%TYPE
21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE

Line 25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE

21: , HOLD_COMMENT OE_Hold_Sources_ALL.HOLD_COMMENT%TYPE
22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE

Line 26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE

22: , CONTEXT OE_Hold_Sources_ALL.CONTEXT%TYPE
23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE

Line 27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE

23: , ATTRIBUTE1 OE_Hold_Sources_ALL.ATTRIBUTE1%TYPE
24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE

Line 28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE

24: , ATTRIBUTE2 OE_Hold_Sources_ALL.ATTRIBUTE2%TYPE
25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE

Line 29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE

25: , ATTRIBUTE3 OE_Hold_Sources_ALL.ATTRIBUTE3%TYPE
26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE

Line 30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE

26: , ATTRIBUTE4 OE_Hold_Sources_ALL.ATTRIBUTE4%TYPE
27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE

Line 31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE

27: , ATTRIBUTE5 OE_Hold_Sources_ALL.ATTRIBUTE5%TYPE
28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE

Line 32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE

28: , ATTRIBUTE6 OE_Hold_Sources_ALL.ATTRIBUTE6%TYPE
29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE

Line 33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE

29: , ATTRIBUTE7 OE_Hold_Sources_ALL.ATTRIBUTE7%TYPE
30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE

Line 34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE

30: , ATTRIBUTE8 OE_Hold_Sources_ALL.ATTRIBUTE8%TYPE
31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE

Line 35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE

31: , ATTRIBUTE9 OE_Hold_Sources_ALL.ATTRIBUTE9%TYPE
32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE

Line 36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE

32: , ATTRIBUTE10 OE_Hold_Sources_ALL.ATTRIBUTE10%TYPE
33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE

Line 37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE

33: , ATTRIBUTE11 OE_Hold_Sources_ALL.ATTRIBUTE11%TYPE
34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE
41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE

Line 38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE

34: , ATTRIBUTE12 OE_Hold_Sources_ALL.ATTRIBUTE12%TYPE
35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE
41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE
42: -- Header and line id, in case only put this order or line on hold for

Line 39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE

35: , ATTRIBUTE13 OE_Hold_Sources_ALL.ATTRIBUTE13%TYPE
36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE
41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE
42: -- Header and line id, in case only put this order or line on hold for
43: -- a specific header or line. Also for line level hold we need to pass

Line 40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE

36: , ATTRIBUTE14 OE_Hold_Sources_ALL.ATTRIBUTE14%TYPE
37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE
41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE
42: -- Header and line id, in case only put this order or line on hold for
43: -- a specific header or line. Also for line level hold we need to pass
44: -- line id.

Line 41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE

37: , ATTRIBUTE15 OE_Hold_Sources_ALL.ATTRIBUTE15%TYPE
38: , ORG_ID OE_Hold_Sources_ALL.ORG_ID%TYPE
39: , HOLD_RELEASE_ID OE_Hold_Sources_ALL.HOLD_RELEASE_ID%TYPE
40: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE
41: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE
42: -- Header and line id, in case only put this order or line on hold for
43: -- a specific header or line. Also for line level hold we need to pass
44: -- line id.
45: , HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE

Line 183: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE

179:
180: x_msg_data OUT NOCOPY VARCHAR2);
181:
182: function entity_code_value (
183: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE
184: )
185: return VARCHAR2;
186:
187: function entity_id_value (

Line 188: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,

184: )
185: return VARCHAR2;
186:
187: function entity_id_value (
188: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
189: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
190: return VARCHAR2;
191:
192: function user_name (

Line 189: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )

185: return VARCHAR2;
186:
187: function entity_id_value (
188: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
189: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
190: return VARCHAR2;
191:
192: function user_name (
193: p_user_id IN FND_USER.USER_ID%TYPE )

Line 197: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)

193: p_user_id IN FND_USER.USER_ID%TYPE )
194: return VARCHAR2;
195:
196: function hold_name(
197: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)
198: return varchar2;
199:
200: procedure process_apply_holds_lines (
201: p_num_of_records IN NUMBER

Line 269: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

265: ,x_msg_data OUT NOCOPY VARCHAR2
266:
267: );
268: procedure process_release_source(
269: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
270: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
271: ,x_return_status OUT NOCOPY VARCHAR2
272:
273: ,x_msg_count OUT NOCOPY NUMBER

Line 368: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

364: ,x_msg_data OUT NOCOPY VARCHAR2
365: );
366: /*Added new overloaded procedure Process_release_source for ER 1373910 - Progress WF on hold release */
367: procedure process_release_source (
368: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
369: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
370: ,p_wf_release_action IN VARCHAR2
371: ,x_return_status OUT NOCOPY VARCHAR2
372: ,x_msg_count OUT NOCOPY NUMBER