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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
115:
116: Procedure Apply_Holds (
117: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
118: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
119: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
120: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
121: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
122: x_return_status OUT NOCOPY VARCHAR2,
123:
116: Procedure Apply_Holds (
117: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
118: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
119: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
120: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
121: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
122: x_return_status OUT NOCOPY VARCHAR2,
123:
124: x_msg_count OUT NOCOPY NUMBER,
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 (
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 (
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 )
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
200: procedure process_apply_holds_lines (
201: p_num_of_records IN NUMBER
202: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
203: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
204: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
205: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
206: ,x_return_status OUT NOCOPY VARCHAR2
207:
208: ,x_msg_count OUT NOCOPY NUMBER
201: p_num_of_records IN NUMBER
202: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
203: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
204: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
205: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
206: ,x_return_status OUT NOCOPY VARCHAR2
207:
208: ,x_msg_count OUT NOCOPY NUMBER
209:
214: procedure process_apply_holds_orders (
215: p_num_of_records IN NUMBER
216: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
217: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
218: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
219: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
220: ,x_return_status OUT NOCOPY VARCHAR2
221:
222: ,x_msg_count OUT NOCOPY NUMBER
215: p_num_of_records IN NUMBER
216: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
217: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
218: ,p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE
219: ,p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE
220: ,x_return_status OUT NOCOPY VARCHAR2
221:
222: ,x_msg_count OUT NOCOPY NUMBER
223:
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
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