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 144: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

140: Procedure Release_Holds (
141: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
142: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
143: DEFAULT NULL,
144: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
145: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
146: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
147: x_return_status OUT NOCOPY VARCHAR2,
148:

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

141: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
142: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
143: DEFAULT NULL,
144: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
145: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE DEFAULT NULL,
146: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
147: x_return_status OUT NOCOPY VARCHAR2,
148:
149: x_msg_count OUT NOCOPY NUMBER,

Line 232: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 233: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

229: p_num_of_records IN NUMBER
230: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
231: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
232: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
233: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
234: ,x_return_status OUT NOCOPY VARCHAR2
235:
236: ,x_msg_count OUT NOCOPY NUMBER
237:

Line 246: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

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

Line 247: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

243: p_num_of_records IN NUMBER
244: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
245: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
246: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
247: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
248: ,x_return_status OUT NOCOPY VARCHAR2
249:
250: ,x_msg_count OUT NOCOPY NUMBER
251:

Line 347: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

343: procedure process_release_holds_lines (
344: p_num_of_records IN NUMBER
345: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
346: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
347: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
348: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
349: ,p_wf_release_action IN VARCHAR2
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER

Line 348: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

344: p_num_of_records IN NUMBER
345: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
346: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
347: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
348: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
349: ,p_wf_release_action IN VARCHAR2
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2

Line 359: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE

355: procedure process_release_holds_orders (
356: p_num_of_records IN NUMBER
357: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
358: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
359: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
360: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
361: ,p_wf_release_action IN VARCHAR2
362: ,x_return_status OUT NOCOPY VARCHAR2
363: ,x_msg_count OUT NOCOPY NUMBER

Line 360: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

356: p_num_of_records IN NUMBER
357: ,p_sel_rec_tbl IN OE_GLOBALS.Selected_Record_Tbl
358: ,p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
359: ,p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE
360: ,p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
361: ,p_wf_release_action IN VARCHAR2
362: ,x_return_status OUT NOCOPY VARCHAR2
363: ,x_msg_count OUT NOCOPY NUMBER
364: ,x_msg_data OUT NOCOPY VARCHAR2