eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PUB dependencies on FND_API

Line 43: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

39: -- Apply Holds
40:
41: PROCEDURE Apply_Holds
42: ( p_api_version IN NUMBER
43: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
45: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
46: , p_header_id IN NUMBER DEFAULT NULL
47: , p_line_id IN NUMBER DEFAULT NULL

Line 44: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

40:
41: PROCEDURE Apply_Holds
42: ( p_api_version IN NUMBER
43: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
45: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
46: , p_header_id IN NUMBER DEFAULT NULL
47: , p_line_id IN NUMBER DEFAULT NULL
48: , p_hold_source_id IN NUMBER DEFAULT NULL

Line 45: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

41: PROCEDURE Apply_Holds
42: ( p_api_version IN NUMBER
43: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
45: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
46: , p_header_id IN NUMBER DEFAULT NULL
47: , p_line_id IN NUMBER DEFAULT NULL
48: , p_hold_source_id IN NUMBER DEFAULT NULL
49: , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC

Line 61: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

57: -- New Overloaded APPLY_HOLD API --
58: -----------------------------------
59: Procedure Apply_Holds (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
64: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
65: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

Line 62: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

58: -----------------------------------
59: Procedure Apply_Holds (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
64: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
65: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
66: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,

Line 63: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

59: Procedure Apply_Holds (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
64: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
65: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
66: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
67: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,

Line 74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

70: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
71:
72: Procedure Apply_Holds(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,

Line 75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

71:
72: Procedure Apply_Holds(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
79: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',

Line 76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

72: Procedure Apply_Holds(
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
79: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
80: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',

Line 91: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

87: -- Check Holds
88:
89: PROCEDURE Check_Holds
90: ( p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
93: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
94: , p_header_id IN NUMBER DEFAULT NULL
95: , p_line_id IN NUMBER DEFAULT NULL

Line 92: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

88:
89: PROCEDURE Check_Holds
90: ( p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
93: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
94: , p_header_id IN NUMBER DEFAULT NULL
95: , p_line_id IN NUMBER DEFAULT NULL
96: , p_hold_id IN NUMBER DEFAULT NULL

Line 93: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

89: PROCEDURE Check_Holds
90: ( p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
92: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
93: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
94: , p_header_id IN NUMBER DEFAULT NULL
95: , p_line_id IN NUMBER DEFAULT NULL
96: , p_hold_id IN NUMBER DEFAULT NULL
97: , p_wf_item IN VARCHAR2 DEFAULT NULL

Line 135: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

131: );
132:
133: PROCEDURE Check_Hold_Sources
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
136: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
138: , p_hold_id IN NUMBER DEFAULT NULL
139: , p_wf_item IN VARCHAR2 DEFAULT NULL

Line 136: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

132:
133: PROCEDURE Check_Hold_Sources
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
136: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
138: , p_hold_id IN NUMBER DEFAULT NULL
139: , p_wf_item IN VARCHAR2 DEFAULT NULL
140: , p_wf_activity IN VARCHAR2 DEFAULT NULL

Line 137: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

133: PROCEDURE Check_Hold_Sources
134: ( p_api_version IN NUMBER
135: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
136: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
137: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
138: , p_hold_id IN NUMBER DEFAULT NULL
139: , p_wf_item IN VARCHAR2 DEFAULT NULL
140: , p_wf_activity IN VARCHAR2 DEFAULT NULL
141: , p_hold_entity_code IN VARCHAR2 DEFAULT NULL

Line 158: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

154: -- Release Holds
155:
156: PROCEDURE Release_Holds
157: ( p_api_version IN NUMBER DEFAULT 1.0
158: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
161: , p_header_id IN NUMBER DEFAULT NULL
162: , p_line_id IN NUMBER DEFAULT NULL

Line 159: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

155:
156: PROCEDURE Release_Holds
157: ( p_api_version IN NUMBER DEFAULT 1.0
158: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
161: , p_header_id IN NUMBER DEFAULT NULL
162: , p_line_id IN NUMBER DEFAULT NULL
163: , p_hold_id IN NUMBER DEFAULT NULL

Line 160: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

156: PROCEDURE Release_Holds
157: ( p_api_version IN NUMBER DEFAULT 1.0
158: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
161: , p_header_id IN NUMBER DEFAULT NULL
162: , p_line_id IN NUMBER DEFAULT NULL
163: , p_hold_id IN NUMBER DEFAULT NULL
164: , p_entity_code IN VARCHAR2 DEFAULT NULL

Line 180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

176: -- New Release Holds API --
177: ------------------------------------
178: Procedure Release_Holds (
179: p_api_version IN NUMBER DEFAULT 1.0,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,

Line 181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

177: ------------------------------------
178: Procedure Release_Holds (
179: p_api_version IN NUMBER DEFAULT 1.0,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
185: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

178: Procedure Release_Holds (
179: p_api_version IN NUMBER DEFAULT 1.0,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
185: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
186: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

187: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
188:
189: Procedure Release_Holds (
190: p_api_version IN NUMBER DEFAULT 1.0,
191: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
194: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
195: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,

Line 192: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

188:
189: Procedure Release_Holds (
190: p_api_version IN NUMBER DEFAULT 1.0,
191: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
194: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
195: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
196: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

Line 193: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

189: Procedure Release_Holds (
190: p_api_version IN NUMBER DEFAULT 1.0,
191: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
194: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
195: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
196: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
197: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

Line 206: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

202:
203: -- Delete Holds
204:
205: PROCEDURE Delete_Holds
206: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
207: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
208: );
209:
210:

Line 207: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

203: -- Delete Holds
204:
205: PROCEDURE Delete_Holds
206: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
207: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
208: );
209:
210:
211:

Line 259: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

255: -- For customer global holds
256:
257: PROCEDURE Process_Holds
258: ( p_api_version IN NUMBER
259: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
260: , p_hold_entity_code IN VARCHAR2
261: --ER#7479609 , p_hold_entity_id IN NUMBER
262: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
263: , p_hold_id IN NUMBER DEFAULT 1