DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PUB dependencies on OKE_CHR_PVT

Line 84: p_chr_rec IN oke_chr_pvt.chr_rec_type,

80: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_chr_rec IN oke_chr_pvt.chr_rec_type,
85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:

Line 86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,

82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_chr_rec IN oke_chr_pvt.chr_rec_type,
85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:
89: l_chr_rec oke_chr_pvt.chr_rec_type;
90: l_chrv_rec okc_contract_pub.chrv_rec_type;

Line 89: l_chr_rec oke_chr_pvt.chr_rec_type;

85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:
89: l_chr_rec oke_chr_pvt.chr_rec_type;
90: l_chrv_rec okc_contract_pub.chrv_rec_type;
91: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
92: l_api_version CONSTANT NUMBER := 1.0;
93: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 258: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,

254: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
259: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
260: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
261: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
262:

Line 260: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,

256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
259: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
260: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
261: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
262:
263: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
264: l_api_version CONSTANT NUMBER := 1.0;

Line 268: l_chr_tbl OKE_CHR_PVT.chr_tbl_type := p_chr_tbl;

264: l_api_version CONSTANT NUMBER := 1.0;
265: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
266: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
267: i NUMBER;
268: l_chr_tbl OKE_CHR_PVT.chr_tbl_type := p_chr_tbl;
269: BEGIN
270: -- call START_ACTIVITY to create savepoint, check compatibility
271: -- and initialize message list
272: l_return_status := OKE_API.START_ACTIVITY(

Line 363: p_chr_rec IN oke_chr_pvt.chr_rec_type,

359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
363: p_chr_rec IN oke_chr_pvt.chr_rec_type,
364: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
365: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
366: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
367:

Line 365: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,

361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
363: p_chr_rec IN oke_chr_pvt.chr_rec_type,
364: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
365: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
366: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
367:
368: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
369: l_api_version CONSTANT NUMBER := 1.0;

Line 484: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,

480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
484: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
485: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
486: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
487: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
488:

Line 486: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,

482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
484: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
485: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
486: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
487: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
488:
489: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
490: l_api_version CONSTANT NUMBER := 1.0;

Line 590: p_chr_rec IN oke_chr_pvt.chr_rec_type,

586: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,
589: x_msg_data OUT NOCOPY VARCHAR2,
590: p_chr_rec IN oke_chr_pvt.chr_rec_type,
591: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
592:
593: l_chr_rec oke_chr_pvt.chr_rec_type;
594: l_chrv_rec okc_contract_pub.chrv_rec_type;

Line 593: l_chr_rec oke_chr_pvt.chr_rec_type;

589: x_msg_data OUT NOCOPY VARCHAR2,
590: p_chr_rec IN oke_chr_pvt.chr_rec_type,
591: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
592:
593: l_chr_rec oke_chr_pvt.chr_rec_type;
594: l_chrv_rec okc_contract_pub.chrv_rec_type;
595: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
596: l_api_version CONSTANT NUMBER := 1.0;
597: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 708: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,

704: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2,
708: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
709: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS
710:
711: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
712: l_api_version CONSTANT NUMBER := 1.0;

Line 843: p_chr_rec IN oke_chr_pvt.chr_rec_type,

839: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_chr_rec IN oke_chr_pvt.chr_rec_type,
844: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
845:
846: l_chr_rec oke_chr_pvt.chr_rec_type;
847: l_chrv_rec okc_contract_pub.chrv_rec_type;

Line 846: l_chr_rec oke_chr_pvt.chr_rec_type;

842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_chr_rec IN oke_chr_pvt.chr_rec_type,
844: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
845:
846: l_chr_rec oke_chr_pvt.chr_rec_type;
847: l_chrv_rec okc_contract_pub.chrv_rec_type;
848: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
849: l_api_version CONSTANT NUMBER := 1.0;
850: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 967: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,

963: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
968: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS
969:
970: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
971:

Line 976: l_chr_tbl oke_chr_pvt.chr_tbl_type := p_chr_tbl;

972: l_api_version CONSTANT NUMBER := 1.0;
973: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
974: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
975: i NUMBER;
976: l_chr_tbl oke_chr_pvt.chr_tbl_type := p_chr_tbl;
977: BEGIN
978: -- call START_ACTIVITY to create savepoint, check compatibility
979: -- and initialize message list
980: l_return_status := OKE_API.START_ACTIVITY(

Line 4142: l_chr_rec OKE_CHR_PVT.chr_rec_type;

4138: l_item_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
4139: l_item_out_tbl OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
4140:
4141: l_cle_tbl OKE_CLE_PVT.cle_tbl_type;
4142: l_chr_rec OKE_CHR_PVT.chr_rec_type;
4143: l_clev_tbl OKC_CONTRACT_PVT.clev_tbl_type;
4144: l_chrv_rec OKC_CONTRACT_PVT.chrv_rec_type;
4145:
4146:

Line 4567: OKE_CHR_PVT.delete_row(

4563: l_chr_rec.k_header_id := p_chr_id;
4564: l_chrv_rec.id := p_chr_id;
4565:
4566:
4567: OKE_CHR_PVT.delete_row(
4568: p_api_version => l_api_version,
4569: p_init_msg_list => OKE_API.G_FALSE,
4570: x_return_status => l_status,
4571: x_msg_count => x_msg_count,