PACKAGE: APPS.OKS_EVTREN_PUB

Source

1 PACKAGE OKS_EVTREN_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPERWS.pls 120.2 2005/11/23 16:25:52 skekkar noship $*/
3 
4  -- GLOBAL VARIABLES
5   ---------------------------------------------------------------------------
6     G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_EVTREN_PUB';
7     G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8 
9   ---------------------------------------------------------------------------
10 
11   -- GLOBAL_MESSAGE_CONSTANTS
12   ---------------------------------------------------------------------------
13     G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14     G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15     G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16     G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17     G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18     G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19     G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20     G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21     G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22     G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23     G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24     G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25     G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26     G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
27   ---------------------------------------------------------------------------
28 
29   -- GLOBAL EXCEPTION
30   ---------------------------------------------------------------------------
31     G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32   ---------------------------------------------------------------------------
33 
34     PROCEDURE Renew
35     (
36      p_api_version IN NUMBER,
37      p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38      p_contract_id IN NUMBER,
39      p_contract_number IN okc_k_headers_v.contract_number%TYPE DEFAULT NULL,
40      p_contract_version IN VARCHAR2 DEFAULT NULL,
41      p_contract_modifier IN okc_k_headers_v.contract_number_modifier%TYPE DEFAULT NULL,
42      p_object_version_number IN NUMBER DEFAULT NULL,
43      p_new_contract_number IN okc_k_headers_v.contract_number%TYPE DEFAULT NULL,
44      p_new_contract_modifier IN okc_k_headers_v.contract_number_modifier%TYPE DEFAULT NULL,
45      p_start_date IN DATE DEFAULT NULL,
46      p_end_date IN DATE DEFAULT NULL,
47      p_orig_start_date IN DATE DEFAULT NULL,
48      p_orig_end_date IN DATE DEFAULT NULL,
49      p_uom_code IN okx_units_of_measure_v.uom_code%TYPE DEFAULT NULL,
50      p_duration IN NUMBER DEFAULT NULL,
51      p_Renewal_Type IN VARCHAR2 DEFAULT NULL,
52      p_Renewal_Pricing_Type IN VARCHAR2 DEFAULT NULL,
53      p_Markup_Percent IN NUMBER DEFAULT NULL,
54      p_Price_List_Id1 IN VARCHAR2 DEFAULT NULL,
55      p_Price_List_Id2 IN VARCHAR2 DEFAULT NULL,
56      p_PDF_ID IN NUMBER DEFAULT NULL,
57      p_QCL_ID IN NUMBER DEFAULT NULL,
58      p_CGP_NEW_ID IN NUMBER DEFAULT NULL,
59      p_CGP_RENEW_ID IN NUMBER DEFAULT NULL,
60      p_PO_REQUIRED_YN IN VARCHAR2 DEFAULT NULL,
61      p_RLE_CODE IN VARCHAR2 DEFAULT NULL,
62      p_Function_Name IN VARCHAR2 DEFAULT NULL,
63      x_msg_count OUT NOCOPY NUMBER,
64      x_msg_data OUT NOCOPY VARCHAR2,
65      x_return_status OUT NOCOPY VARCHAR2
66      );
67 END OKS_EVTREN_PUB;