4: ---------------------------------------------------------------------------
5: -- GLOBAL VARIABLES
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_EXTEND_PUB';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9:
10:
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_EXTEND_PUB';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9:
10:
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9:
10:
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
16: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
14: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
16: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
17: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
18:
19: SUBTYPE extension_header_rec_type is okl_vp_extend_pvt.extension_header_rec_type;
20:
21:
21:
22: -- SUBTYPE extension_header_rec_type is okl_vp_extend_cuhk.extension_header_rec_type;
23:
24: PROCEDURE extend_contract(p_api_version IN NUMBER,
25: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: p_ext_header_rec IN extension_header_rec_type);