DBA Data[Home] [Help]

PACKAGE: APPS.EAM_ITEM_PVT

Source


1 PACKAGE EAM_ITEM_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMPITMS.pls 120.2 2006/06/13 22:40:57 hkarmach noship $ */
3 
4 -- Start of comments
5 --	API name 	: EAM_ITEM_PVT
6 --	Type		: Public
7 --	Function	: insert_item, update_item
8 --	Pre-reqs	: None.
9 --	Parameters	:
10 --	IN		:	p_api_version           	IN NUMBER	Required
11 --				p_init_msg_list		IN VARCHAR2 	Optional
12 --					Default = FND_API.G_FALSE
13 --				p_commit	    		IN VARCHAR2	Optional
14 --					Default = FND_API.G_FALSE
15 --				p_validation_level		IN NUMBER	Optional
16 --					Default = FND_API.G_VALID_LEVEL_FULL
17 --				parameter1
18 --				parameter2
19 --				.
20 --				.
21 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
22 --				x_msg_count			OUT	NUMBER
23 --				x_msg_data			OUT	VARCHAR2(2000)
24 --				parameter1
25 --				parameter2
26 --				.
27 --				.
28 --	Version	: Current version	x.x
29 --				Changed....
30 --			  previous version	y.y
31 --				Changed....
32 --			  .
33 --			  .
34 --			  previous version	2.0
35 --				Changed....
36 --			  Initial version 	1.0
37 --
38 --	Notes		: Note text
39 --
40 -- End of comments
41 
42 
43 PROCEDURE insert_item
44 (
45 	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE
46 	, x_return_status		OUT NOCOPY VARCHAR2
47 	, x_msg_count			OUT NOCOPY NUMBER
48 	, x_msg_data	    	OUT NOCOPY VARCHAR2
49 	, X_ITEM_ID			OUT NOCOPY NUMBER
50 	, p_asset_group		    IN	VARCHAR2
51 	, p_segment1			IN	VARCHAR2
52 	, p_segment2			IN	VARCHAR2
53 	, p_segment3			IN	VARCHAR2
54 	, p_segment4			IN	VARCHAR2
55 	, p_segment5			IN	VARCHAR2
56 	, p_segment6			IN	VARCHAR2
57 	, p_segment7			IN	VARCHAR2
58 	, p_segment8			IN	VARCHAR2
59 	, p_segment9			IN	VARCHAR2
60 	, p_segment10			IN	VARCHAR2
61 	, p_segment11			IN	VARCHAR2
62 	, p_segment12			IN	VARCHAR2
63 	, p_segment13			IN	VARCHAR2
64 	, p_segment14			IN	VARCHAR2
65 	, p_segment15			IN	VARCHAR2
66 	, p_segment16			IN	VARCHAR2
67 	, p_segment17			IN	VARCHAR2
68 	, p_segment18			IN	VARCHAR2
69 	, p_segment19			IN	VARCHAR2
70 	, p_segment20			IN	VARCHAR2
71 	, P_SOURCE_TMPL_ID		IN	NUMBER
72     , p_template_name       IN  VARCHAR2
73     , p_organization_id     IN  NUMBER
74     , p_description         IN  VARCHAR2
75     , p_serial_generation   IN  NUMBER
76     , p_prefix_text         IN  VARCHAR2
77     , p_prefix_number       IN  VARCHAR2
78     , p_eam_item_type       IN  NUMBER
79 );
80 
81 PROCEDURE update_item
82 (
83 	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE
84 	, x_return_status		OUT NOCOPY VARCHAR2
85 	, x_msg_count			OUT NOCOPY NUMBER
86 	, x_msg_data	    	OUT NOCOPY VARCHAR2
87     , p_inventory_item_id     IN NUMBER
88     , P_SOURCE_TMPL_ID		IN	NUMBER
89     , p_template_name       IN  VARCHAR2
90     , p_organization_id     IN NUMBER
91     , p_description         IN  VARCHAR2
92     , p_serial_generation   IN  NUMBER
93     , p_prefix_text         IN  VARCHAR2
94     , p_prefix_number       IN  VARCHAR2
95 );
96 
97 PROCEDURE Lock_Item(
98 	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE
99 	, x_return_status		OUT NOCOPY VARCHAR2
100 	, x_msg_count			OUT NOCOPY NUMBER
101 	, x_msg_data	    	OUT NOCOPY VARCHAR2
102     , p_inventory_item_id     IN NUMBER
103     , p_organization_id     IN NUMBER
104 );
105 
106 END;