1 PACKAGE OE_COMMITMENT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXUCMTS.pls 120.0 2005/06/01 02:21:47 appldev noship $ */
3
4
5 ----------------------------------------
6 -- Procedure Get_Commitment_Info
7 -- This procedure is provided to be called by OTA team.
8 -- Abstract: given a line id, return the
9 -- commitment id, number, start date and end date.
10 -- Return NULL if there is no commitment on the line.
11 ---------------------------------------
12
13 PROCEDURE Get_Commitment_Info
14 ( p_line_id IN NUMBER := FND_API.G_MISS_NUM
15 , x_commitment_id OUT NOCOPY NUMBER
16
17 , x_commitment_number OUT NOCOPY VARCHAR2
18
19 , x_commitment_start_date OUT NOCOPY DATE
20
21 , x_commitment_end_date OUT NOCOPY DATE
22
23 );
24
25
26
27 END OE_COMMITMENT_UTIL;