DBA Data[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;