[Home] [Help]
PACKAGE: APPS.ENG_NEW_ITEM_REQ_UTIL
Source
1 PACKAGE ENG_NEW_ITEM_REQ_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ENGUNIRS.pls 120.3 2007/04/09 09:27:29 sdarbha ship $ */
3
4 PROCEDURE Create_New_Item_Request
5 (
6 x_return_status OUT NOCOPY VARCHAR2,
7 change_number IN VARCHAR2, --10
8 change_name IN VARCHAR2, --240
9 change_type_code IN VARCHAR2, --80
10 item_number IN VARCHAR2, --240
11 organization_code IN VARCHAR2, --3
12 requestor_user_name IN VARCHAR2, --100
13 batch_id IN NUMBER := null
14 ) ;
15
16
17 -- Added in R12
18 -- Item API will put returned NIR change id
19 -- to Item Open Interface table
20 PROCEDURE Create_New_Item_Request
21 (
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_change_id OUT NOCOPY NUMBER,
24 change_number IN VARCHAR2, --10
25 change_name IN VARCHAR2, --240
26 change_type_code IN VARCHAR2, --80
27 item_number IN VARCHAR2, --240
28 organization_code IN VARCHAR2, --3
29 requestor_user_name IN VARCHAR2, --100
30 batch_id IN NUMBER := null
31 ) ;
32
33
34 PROCEDURE CREATE_NEW_ITEM_REQUESTS(P_BATCH_ID IN NUMBER,
35 P_NIR_OPTION IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER);
39 END ENG_NEW_ITEM_REQ_UTIL;