3:
4:
5:
6: TYPE copy_header_rec_type is RECORD (
7: p_id okc_k_headers_v.id%TYPE := OKL_API.G_MISS_NUM,
8: p_to_agreement_number okc_k_headers_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_template_yn VARCHAR2(3):= OKL_API.G_MISS_CHAR);
10:
11:
4:
5:
6: TYPE copy_header_rec_type is RECORD (
7: p_id okc_k_headers_v.id%TYPE := OKL_API.G_MISS_NUM,
8: p_to_agreement_number okc_k_headers_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_template_yn VARCHAR2(3):= OKL_API.G_MISS_CHAR);
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_COPY_CONTRACT_PVT' ;
5:
6: TYPE copy_header_rec_type is RECORD (
7: p_id okc_k_headers_v.id%TYPE := OKL_API.G_MISS_NUM,
8: p_to_agreement_number okc_k_headers_v.contract_number%TYPE := OKL_API.G_MISS_CHAR,
9: p_template_yn VARCHAR2(3):= OKL_API.G_MISS_CHAR);
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_COPY_CONTRACT_PVT' ;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: p_template_yn VARCHAR2(3):= OKL_API.G_MISS_CHAR);
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_COPY_CONTRACT_PVT' ;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14:
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_COPY_CONTRACT_PVT' ;
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14:
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14:
15:
16: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
17: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
20: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
21: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24:
25: PROCEDURE copy_contract(p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
22: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
23: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
24:
25: PROCEDURE copy_contract(p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_copy_rec IN copy_header_rec_type,