APPS.OE_HOLDS_PVT dependencies on OE_HOLD_RELEASES

Line 51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE

47: );
48:
49: -- Hold Release
50: TYPE Hold_Release_Rec_Type IS RECORD
51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE
52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE

Line 52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE

48:
49: -- Hold Release
50: TYPE Hold_Release_Rec_Type IS RECORD
51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE
52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE

Line 53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE

49: -- Hold Release
50: TYPE Hold_Release_Rec_Type IS RECORD
51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE
52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE

Line 54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE

50: TYPE Hold_Release_Rec_Type IS RECORD
51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE
52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE

Line 55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE

51: ( HOLD_RELEASE_ID OE_Hold_Releases.HOLD_RELEASE_ID%TYPE
52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE

Line 56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE

52: , CREATION_DATE OE_Hold_Releases.CREATION_DATE%TYPE
53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE

Line 57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE

53: , CREATED_BY OE_Hold_Releases.CREATED_BY%TYPE
54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE

Line 58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE

54: , LAST_UPDATE_DATE OE_Hold_Releases.LAST_UPDATE_DATE%TYPE
55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE

Line 59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE

55: , LAST_UPDATED_BY OE_Hold_Releases.LAST_UPDATED_BY%TYPE
56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE

Line 60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE

56: , LAST_UPDATE_LOGIN OE_Hold_Releases.LAST_UPDATE_LOGIN%TYPE
57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE

Line 61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE

57: , PROGRAM_APPLICATION_ID OE_Hold_Releases.PROGRAM_APPLICATION_ID%TYPE
58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE

Line 62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE

58: , PROGRAM_ID OE_Hold_Releases.PROGRAM_ID%TYPE
59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE

Line 63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE

59: , PROGRAM_UPDATE_DATE OE_Hold_Releases.PROGRAM_UPDATE_DATE%TYPE
60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE

Line 64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE

60: , REQUEST_ID OE_Hold_Releases.REQUEST_ID%TYPE
61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE

Line 65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE

61: , HOLD_SOURCE_ID OE_Hold_Releases.HOLD_SOURCE_ID%TYPE
62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE

Line 66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE

62: , RELEASE_REASON_CODE OE_Hold_Releases.RELEASE_REASON_CODE%TYPE
63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE

Line 67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE

63: , RELEASE_COMMENT OE_Hold_Releases.RELEASE_COMMENT%TYPE
64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE

Line 68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE

64: , CONTEXT OE_Hold_Releases.CONTEXT%TYPE
65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE

Line 69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE

65: , ORDER_HOLD_ID OE_Hold_Releases.ORDER_HOLD_ID%TYPE
66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE

Line 70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE

66: , ATTRIBUTE1 OE_Hold_Releases.ATTRIBUTE1%TYPE
67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE

Line 71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE

67: , ATTRIBUTE2 OE_Hold_Releases.ATTRIBUTE2%TYPE
68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE

Line 72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE

68: , ATTRIBUTE3 OE_Hold_Releases.ATTRIBUTE3%TYPE
69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE

Line 73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE

69: , ATTRIBUTE4 OE_Hold_Releases.ATTRIBUTE4%TYPE
70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE

Line 74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE

70: , ATTRIBUTE5 OE_Hold_Releases.ATTRIBUTE5%TYPE
71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE

Line 75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE

71: , ATTRIBUTE6 OE_Hold_Releases.ATTRIBUTE6%TYPE
72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE

Line 76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE

72: , ATTRIBUTE7 OE_Hold_Releases.ATTRIBUTE7%TYPE
73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE
80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE

Line 77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE

73: , ATTRIBUTE8 OE_Hold_Releases.ATTRIBUTE8%TYPE
74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE
80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE
81: );

Line 78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE

74: , ATTRIBUTE9 OE_Hold_Releases.ATTRIBUTE9%TYPE
75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE
80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE
81: );
82:

Line 79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE

75: , ATTRIBUTE10 OE_Hold_Releases.ATTRIBUTE10%TYPE
76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE
80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE
81: );
82:
83: G_MISS_HOLD_SOURCE_REC Hold_Source_REC_type;

Line 80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE

76: , ATTRIBUTE11 OE_Hold_Releases.ATTRIBUTE11%TYPE
77: , ATTRIBUTE12 OE_Hold_Releases.ATTRIBUTE12%TYPE
78: , ATTRIBUTE13 OE_Hold_Releases.ATTRIBUTE13%TYPE
79: , ATTRIBUTE14 OE_Hold_Releases.ATTRIBUTE14%TYPE
80: , ATTRIBUTE15 OE_Hold_Releases.ATTRIBUTE15%TYPE
81: );
82:
83: G_MISS_HOLD_SOURCE_REC Hold_Source_REC_type;
84:

Line 141: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

137: Procedure Release_Holds (
138: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
139: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
140: DEFAULT NULL,
141: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
142: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
143: x_return_status OUT NOCOPY VARCHAR2,
144:
145: x_msg_count OUT NOCOPY NUMBER,

Line 142: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,

138: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
139: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
140: DEFAULT NULL,
141: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
142: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
143: x_return_status OUT NOCOPY VARCHAR2,
144:
145: x_msg_count OUT NOCOPY NUMBER,
146:

Line 228: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

224: procedure process_release_holds_lines (
225: p_num_of_records IN NUMBER
226: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
227: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
228: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
229: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
230: ,x_return_status OUT NOCOPY VARCHAR2
231:
232: ,x_msg_count OUT NOCOPY NUMBER

Line 229: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

225: p_num_of_records IN NUMBER
226: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
227: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
228: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
229: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
230: ,x_return_status OUT NOCOPY VARCHAR2
231:
232: ,x_msg_count OUT NOCOPY NUMBER
233:

Line 242: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

238: procedure process_release_holds_orders (
239: p_num_of_records IN NUMBER
240: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
241: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
242: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
243: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2
245:
246: ,x_msg_count OUT NOCOPY NUMBER

Line 243: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

239: p_num_of_records IN NUMBER
240: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
241: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
242: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
243: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
244: ,x_return_status OUT NOCOPY VARCHAR2
245:
246: ,x_msg_count OUT NOCOPY NUMBER
247:

Line 342: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

338: procedure process_release_holds_lines (
339: p_num_of_records IN NUMBER
340: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
341: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
342: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
343: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
344: ,p_wf_release_action IN VARCHAR2
345: ,x_return_status OUT NOCOPY VARCHAR2
346: ,x_msg_count OUT NOCOPY NUMBER

Line 343: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

339: p_num_of_records IN NUMBER
340: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
341: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
342: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
343: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
344: ,p_wf_release_action IN VARCHAR2
345: ,x_return_status OUT NOCOPY VARCHAR2
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2

Line 354: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

350: procedure process_release_holds_orders (
351: p_num_of_records IN NUMBER
352: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
353: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
354: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
355: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
356: ,p_wf_release_action IN VARCHAR2
357: ,x_return_status OUT NOCOPY VARCHAR2
358: ,x_msg_count OUT NOCOPY NUMBER

Line 355: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

351: p_num_of_records IN NUMBER
352: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
353: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
354: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
355: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
356: ,p_wf_release_action IN VARCHAR2
357: ,x_return_status OUT NOCOPY VARCHAR2
358: ,x_msg_count OUT NOCOPY NUMBER
359: ,x_msg_data OUT NOCOPY VARCHAR2