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

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 49: , p_hold_source_rec IN OE_Hold_Sources_Pvt.Hold_Source_REC

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
50: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC
51: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
52: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 50: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC

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
50: DEFAULT OE_Hold_Sources_Pvt.G_MISS_Hold_Source_REC
51: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
52: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
54: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 67: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,

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,
69: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
70: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 68: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,

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,
69: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
70: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
71: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
72: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );

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 171: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC

167: , p_entity_code IN VARCHAR2 DEFAULT NULL
168: , p_entity_id IN NUMBER DEFAULT NULL
169: , p_entity_code2 IN VARCHAR2 DEFAULT NULL
170: , p_entity_id2 IN NUMBER DEFAULT NULL
171: , p_hold_release_rec IN OE_Hold_Sources_Pvt.Hold_Release_REC
172: , p_check_authorization_flag IN VARCHAR2 DEFAULT 'N' -- bug 8477694
173: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
175: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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;