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 OE_HOLD_SOURCES_ALL

Line 17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL

13: G_HDR_PAYMENT VARCHAR2(1) :='N'; --ER#7479609
14:
15: TYPE Any_Line_Hold_Rec IS RECORD
16: ( HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE := NULL
17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL

Line 18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL

14:
15: TYPE Any_Line_Hold_Rec IS RECORD
16: ( HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE := NULL
17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
22: , WF_ITEM_TYPE VARCHAR2(30) DEFAULT NULL

Line 19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL

15: TYPE Any_Line_Hold_Rec IS RECORD
16: ( HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE := NULL
17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
22: , WF_ITEM_TYPE VARCHAR2(30) DEFAULT NULL
23: , WF_ACTIVITY_NAME VARCHAR2(30) DEFAULT NULL

Line 20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL

16: ( HEADER_ID OE_ORDER_HEADERS.HEADER_ID%TYPE := NULL
17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
22: , WF_ITEM_TYPE VARCHAR2(30) DEFAULT NULL
23: , WF_ACTIVITY_NAME VARCHAR2(30) DEFAULT NULL
24: , p_chk_act_hold_only VARCHAR2(1) DEFAULT 'N'

Line 21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL

17: , HOLD_ID OE_Hold_Sources_ALL.HOLD_ID%TYPE := NULL
18: , HOLD_ENTITY_CODE OE_Hold_Sources_ALL.HOLD_ENTITY_CODE%TYPE := NULL
19: , HOLD_ENTITY_ID OE_Hold_Sources_ALL.HOLD_ENTITY_ID%TYPE := NULL
20: , HOLD_ENTITY_CODE2 OE_Hold_Sources_ALL.HOLD_ENTITY_CODE2%TYPE := NULL
21: , HOLD_ENTITY_ID2 OE_Hold_Sources_ALL.HOLD_ENTITY_ID2%TYPE := NULL
22: , WF_ITEM_TYPE VARCHAR2(30) DEFAULT NULL
23: , WF_ACTIVITY_NAME VARCHAR2(30) DEFAULT NULL
24: , p_chk_act_hold_only VARCHAR2(1) DEFAULT 'N'
25: , x_result_out VARCHAR2(30)

Line 101: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

97: , p_wf_item IN VARCHAR2 DEFAULT NULL
98: , p_wf_activity IN VARCHAR2 DEFAULT NULL
99: , p_entity_code IN VARCHAR2 DEFAULT NULL
100: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
101: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
102: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
103: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
104: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
105: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 104: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

100: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
101: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
102: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
103: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
104: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
105: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
106: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 121: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

117: , p_wf_item IN VARCHAR2 DEFAULT NULL
118: , p_wf_activity IN VARCHAR2 DEFAULT NULL
119: , p_entity_code IN VARCHAR2 DEFAULT NULL
120: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
121: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
122: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
123: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
124: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
125: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 124: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

120: --ER#7479609, p_entity_id IN NUMBER DEFAULT NULL
121: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
122: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
123: --ER#7479609, p_entity_id2 IN NUMBER DEFAULT NULL
124: , p_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
125: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
126: , p_ii_parent_flag IN VARCHAR2 DEFAULT 'N'
127: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 143: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

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
142: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
143: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
144: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
145: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
146: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
147: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'

Line 146: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609

142: --ER#7479609 , p_hold_entity_id IN NUMBER DEFAULT NULL
143: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609
144: , p_hold_entity_code2 IN VARCHAR2 DEFAULT NULL
145: --ER#7479609 , p_hold_entity_id2 IN NUMBER DEFAULT NULL
146: , p_hold_entity_id2 IN oe_hold_sources_all.hold_entity_id2%TYPE DEFAULT NULL --ER#7479609
147: , p_chk_act_hold_only IN VARCHAR2 DEFAULT 'N'
148: , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 216: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

212: PROCEDURE evaluate_holds( p_entity_code IN VARCHAR2
213: , p_entity_id IN NUMBER
214: , p_hold_entity_code IN VARCHAR2
215: --ER#7479609 , p_hold_entity_id IN NUMBER
216: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
217: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
219: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
220: );

Line 234: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

230: ( p_entity_code IN VARCHAR2
231: , p_entity_id IN NUMBER
232: , p_hold_entity_code IN VARCHAR2
233: --ER#7479609 , p_hold_entity_id IN NUMBER
234: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
235: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
237: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238: );

Line 262: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609

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
264: , p_release_reason_code IN VARCHAR2 DEFAULT NULL
265: , p_action IN VARCHAR2
266: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2