PACKAGE: APPS.OKC_OKS_PUB

Source

1 package OKC_OKS_PUB 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