9: TYPE hdr_tbl_type IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
10: -- GLOBAL VARIABLES
11:
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PVT';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14:
15: PROCEDURE create_contract_header(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: --Bug# 2525554 start
182: ------------------------
183: PROCEDURE update_contract_line(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
193: x_klev_rec OUT NOCOPY klev_rec_type);
194:
195: PROCEDURE update_contract_line(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
381: x_return_status OUT NOCOPY VARCHAR2,
382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,
384: p_chr_id IN NUMBER,
385: p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
382: x_msg_count OUT NOCOPY NUMBER,
383: x_msg_data OUT NOCOPY VARCHAR2,
384: p_chr_id IN NUMBER,
385: p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390: p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
383: x_msg_data OUT NOCOPY VARCHAR2,
384: p_chr_id IN NUMBER,
385: p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390: p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
391: x_hdr_tbl OUT NOCOPY hdr_tbl_type);
384: p_chr_id IN NUMBER,
385: p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390: p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
391: x_hdr_tbl OUT NOCOPY hdr_tbl_type);
392: /*
385: p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390: p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
391: x_hdr_tbl OUT NOCOPY hdr_tbl_type);
392: /*
393: FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
386: p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387: p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388: p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389: p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390: p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
391: x_hdr_tbl OUT NOCOPY hdr_tbl_type);
392: /*
393: FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
394: */