[Home] [Help]
PACKAGE: APPS.OKC_OKS_PUB
Source
1 package OKC_OKS_PUB AUTHID CURRENT_USER as
2 /* $Header: OKCPOKSS.pls 120.0 2005/05/26 09:29:43 appldev noship $ */
3 --------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_RENEW_UNEXPECTED_ERROR';
7 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9
10
11 ---------------------------------------------------------------------------
12 -- GLOBAL VARIABLES
13 ---------------------------------------------------------------------------
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OKS_PUB';
15 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
16 -- *******************************************************
17 -- Start of Comments
18 -- *******************************************************
19 -- API Name: OKS_UPDATE_CONTRACT
20 -- Pre-Req : None.
21 -- Parameters:
22 -- IN - All IN parameters are REQUIRED.
23 -- p_from_id NUMBER - Id of the Old Parent
24 -- p_to_id NUMBER - Id of the New Parent
25 -- OUT:
26 -- x_return_status VARCHAR2 - Return the status of the procedure
27 --
28 -- End of Comments
29 --
30
31 PROCEDURE OKS_UPDATE_CONTRACT
32 ( p_from_id IN hz_merge_parties.from_party_id%type,
33 p_to_id IN hz_merge_parties.to_party_id%type,
34 x_return_status OUT NOCOPY VARCHAR2);
35
36 -- *******************************************************
37 -- Start of Comments
38 -- *******************************************************
39 -- API Name: IS_RENEW_ALLOWED
40 -- Pre-Req : None.
41 -- Parameters:
42 -- IN - All IN parameters are REQUIRED.
43 -- p_chr_id NUMBER - Contract id
44 -- OUT:
45 -- x_return_status VARCHAR2 - Return status
46 --
47 -- End of Comments
48 --
49 FUNCTION Is_Renew_Allowed(p_chr_id IN NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2)
51 RETURN BOOLEAN;
52
53 FUNCTION VALIDATE_OKS_LINES(p_chr_id IN NUMBER
54 ) RETURN VARCHAR2;
55
56 END OKC_OKS_PUB;
57
58