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 104: , p_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE DEFAULT NULL --ER#7479609

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

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

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

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

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

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

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

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

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

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

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

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

218: PROCEDURE evaluate_holds( p_entity_code IN VARCHAR2
219: , p_entity_id IN NUMBER
220: , p_hold_entity_code IN VARCHAR2
221: --ER#7479609 , p_hold_entity_id IN NUMBER
222: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
223: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
224: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
225: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
226: );

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

236: ( p_entity_code IN VARCHAR2
237: , p_entity_id IN NUMBER
238: , p_hold_entity_code IN VARCHAR2
239: --ER#7479609 , p_hold_entity_id IN NUMBER
240: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
241: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
242: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
243: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
244: );

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

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

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

277: --ER 12363706 start
278:
279: FUNCTION Hold_exists
280: ( p_hold_entity_code IN VARCHAR2
281: , p_hold_entity_id IN oe_hold_sources_all.hold_entity_id%TYPE --ER#7479609
282: , p_hold_id IN NUMBER DEFAULT 1
283: , p_org_id IN NUMBER DEFAULT NULL
284: )
285: RETURN boolean;