PACKAGE: APPS.EAM_PM_LAST_SERVICE_PUB

Source

1 PACKAGE EAM_PM_LAST_SERVICE_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPPLSS.pls 115.1 2003/09/05 11:12:30 adharia noship $ */
3 -- Start of comments
4 --	API name 	: EAM_PM_LAST_SERVICE_PUB
5 --	Type		: Public
6 --	Function	: insert_pm_last_service, update_pm_last_service
7 --	Pre-reqs	: None.
8 --	Parameters	:
9 --	IN		:	p_api_version           	IN NUMBER	Required
10 --				p_init_msg_list		IN VARCHAR2 	Optional
11 --					Default = FND_API.G_FALSE
12 --				p_commit	    		IN VARCHAR2	Optional
13 --					Default = FND_API.G_FALSE
14 --				p_validation_level		IN NUMBER	Optional
15 --					Default = FND_API.G_VALID_LEVEL_FULL
16 --				parameter1
17 --				parameter2
18 --				.
19 --				.
20 --	OUT		:	x_return_status		OUT	VARCHAR2(1)
21 --				x_msg_count			OUT	NUMBER
22 --				x_msg_data			OUT	VARCHAR2(2000)
23 --				parameter1
24 --				parameter2
25 --				.
26 --				.
27 --	Version	: Current version	x.x
28 --				Changed....
29 --			  previous version	y.y
30 --				Changed....
31 --			  .
32 --			  .
33 --			  previous version	2.0
34 --				Changed....
35 --			  Initial version 	1.0
36 --
37 --	Notes		: Note text
38 --
39 -- End of comments
40 
41 TYPE pm_last_service_rec IS RECORD
42 (
43 	METER_ID			NUMBER	,
44 	LAST_SERVICE_READING        	NUMBER	DEFAULT NULL,
45 	PREV_SERVICE_READING        	NUMBER	DEFAULT NULL,
46 	WIP_ENTITY_ID               	NUMBER	DEFAULT NULL
47 );
48 TYPE pm_last_service_tbl IS TABLE OF pm_last_service_rec INDEX BY BINARY_INTEGER;
49 
50 PROCEDURE process_pm_last_service
51 (
52 	p_api_version       		IN	NUMBER			,
53   	p_init_msg_list			IN	VARCHAR2:= FND_API.G_FALSE	,
54 	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE	,
55 	p_validation_level		IN  	NUMBER  := FND_API.G_VALID_LEVEL_FULL,
56 	x_return_status			OUT NOCOPY VARCHAR2	,
57 	x_msg_count			OUT NOCOPY NUMBER	,
58 	x_msg_data	    		OUT NOCOPY VARCHAR2  ,
59 
60 	p_pm_last_service_tbl           IN       pm_last_service_tbl,
61 	p_actv_assoc_id                 in       number
62 );
63 
64 
65 END;