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 62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 63: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 64: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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

Line 76: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 77: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 78: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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

Line 94: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 95: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 96: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 138: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 139: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 140: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 161: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 162: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 163: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

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

Line 184: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

181: ------------------------------------
182: Procedure Release_Holds (
183: p_api_version IN NUMBER DEFAULT 1.0,
184: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
188: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
189: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 186: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

182: Procedure Release_Holds (
183: p_api_version IN NUMBER DEFAULT 1.0,
184: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
188: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
189: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
190: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

193:
194: Procedure Release_Holds (
195: p_api_version IN NUMBER DEFAULT 1.0,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
200: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
201: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,

Line 198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

194: Procedure Release_Holds (
195: p_api_version IN NUMBER DEFAULT 1.0,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
200: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
201: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
202: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE

Line 212: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

208:
209: -- Delete Holds
210:
211: PROCEDURE Delete_Holds
212: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
214: );
215:
216:

Line 213: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

209: -- Delete Holds
210:
211: PROCEDURE Delete_Holds
212: ( p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: , p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
214: );
215:
216:
217:

Line 265: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

261: -- For customer global holds
262:
263: PROCEDURE Process_Holds
264: ( p_api_version IN NUMBER
265: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
266: , p_hold_entity_code IN VARCHAR2
267: --ER#7479609 , p_hold_entity_id IN NUMBER
268: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
269: , p_hold_id IN NUMBER DEFAULT 1