eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_CONTRACT_PUB dependencies on OKE_CLE_PVT

Line 1104: p_cle_rec IN oke_cle_pvt.cle_rec_type,

1100: x_return_status OUT NOCOPY VARCHAR2,
1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1104: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1105: p_clev_rec IN okc_contract_pub.clev_rec_type,
1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:

Line 1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,

1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1104: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1105: p_clev_rec IN okc_contract_pub.clev_rec_type,
1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:
1109: l_cle_rec oke_cle_pvt.cle_rec_type;
1110: l_clev_rec okc_contract_pub.clev_rec_type;

Line 1109: l_cle_rec oke_cle_pvt.cle_rec_type;

1105: p_clev_rec IN okc_contract_pub.clev_rec_type,
1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:
1109: l_cle_rec oke_cle_pvt.cle_rec_type;
1110: l_clev_rec okc_contract_pub.clev_rec_type;
1111: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
1112: l_api_version CONSTANT NUMBER := 1.0;
1113: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1296: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

1292: x_return_status OUT NOCOPY VARCHAR2,
1293: x_msg_count OUT NOCOPY NUMBER,
1294: x_msg_data OUT NOCOPY VARCHAR2,
1295: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1296: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1297: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1298: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1299: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1300:

Line 1298: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,

1294: x_msg_data OUT NOCOPY VARCHAR2,
1295: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1296: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1297: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1298: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1299: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1300:
1301: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
1302: l_api_version CONSTANT NUMBER := 1.0;

Line 1306: l_cle_tbl oke_cle_pvt.cle_tbl_type;

1302: l_api_version CONSTANT NUMBER := 1.0;
1303: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1304: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1305: i NUMBER;
1306: l_cle_tbl oke_cle_pvt.cle_tbl_type;
1307: BEGIN
1308:
1309: -- call START_ACTIVITY to create savepoint, check compatibility
1310: -- and initialize message list

Line 1404: p_cle_rec IN oke_cle_pvt.cle_rec_type,

1400: x_return_status OUT NOCOPY VARCHAR2,
1401: x_msg_count OUT NOCOPY NUMBER,
1402: x_msg_data OUT NOCOPY VARCHAR2,
1403: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1404: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1405: p_clev_rec IN okc_contract_pub.clev_rec_type,
1406: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1407: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1408:

Line 1406: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,

1402: x_msg_data OUT NOCOPY VARCHAR2,
1403: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1404: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1405: p_clev_rec IN okc_contract_pub.clev_rec_type,
1406: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1407: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1408:
1409: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
1410: l_api_version CONSTANT NUMBER := 1.0;

Line 1525: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

1521: x_return_status OUT NOCOPY VARCHAR2,
1522: x_msg_count OUT NOCOPY NUMBER,
1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1525: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1526: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1527: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1528: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1529:

Line 1527: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,

1523: x_msg_data OUT NOCOPY VARCHAR2,
1524: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1525: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1526: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1527: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1528: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1529:
1530: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
1531: l_api_version CONSTANT NUMBER := 1.0;

Line 1632: p_cle_rec IN oke_cle_pvt.cle_rec_type,

1628: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1629: x_return_status OUT NOCOPY VARCHAR2,
1630: x_msg_count OUT NOCOPY NUMBER,
1631: x_msg_data OUT NOCOPY VARCHAR2,
1632: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1633: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1634:
1635: l_cle_rec oke_cle_pvt.cle_rec_type;
1636: l_clev_rec okc_contract_pub.clev_rec_type;

Line 1635: l_cle_rec oke_cle_pvt.cle_rec_type;

1631: x_msg_data OUT NOCOPY VARCHAR2,
1632: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1633: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1634:
1635: l_cle_rec oke_cle_pvt.cle_rec_type;
1636: l_clev_rec okc_contract_pub.clev_rec_type;
1637: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
1638: l_api_version CONSTANT NUMBER := 1.0;
1639: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1750: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

1746: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1747: x_return_status OUT NOCOPY VARCHAR2,
1748: x_msg_count OUT NOCOPY NUMBER,
1749: x_msg_data OUT NOCOPY VARCHAR2,
1750: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1751: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS
1752:
1753: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
1754: l_api_version CONSTANT NUMBER := 1.0;

Line 1961: p_cle_rec IN oke_cle_pvt.cle_rec_type,

1957: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
1958: x_return_status OUT NOCOPY VARCHAR2,
1959: x_msg_count OUT NOCOPY NUMBER,
1960: x_msg_data OUT NOCOPY VARCHAR2,
1961: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1962: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1963:
1964: l_cle_rec oke_cle_pvt.cle_rec_type;
1965: l_clev_rec okc_contract_pub.clev_rec_type;

Line 1964: l_cle_rec oke_cle_pvt.cle_rec_type;

1960: x_msg_data OUT NOCOPY VARCHAR2,
1961: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1962: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1963:
1964: l_cle_rec oke_cle_pvt.cle_rec_type;
1965: l_clev_rec okc_contract_pub.clev_rec_type;
1966: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
1967: l_api_version CONSTANT NUMBER := 1.0;
1968: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 2085: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

2081: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
2082: x_return_status OUT NOCOPY VARCHAR2,
2083: x_msg_count OUT NOCOPY NUMBER,
2084: x_msg_data OUT NOCOPY VARCHAR2,
2085: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
2086: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS
2087:
2088: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
2089:

Line 2094: l_cle_tbl oke_cle_pvt.cle_tbl_type := p_cle_tbl;

2090: l_api_version CONSTANT NUMBER := 1.0;
2091: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2092: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2093: i NUMBER;
2094: l_cle_tbl oke_cle_pvt.cle_tbl_type := p_cle_tbl;
2095: BEGIN
2096: -- call START_ACTIVITY to create savepoint, check compatibility
2097: -- and initialize message list
2098: l_return_status := OKE_API.START_ACTIVITY(

Line 4141: l_cle_tbl OKE_CLE_PVT.cle_tbl_type;

4137:
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:

Line 4530: OKE_CLE_PVT.delete_row(

4526: i:= i+1;
4527: end loop;
4528:
4529:
4530: OKE_CLE_PVT.delete_row(
4531: p_api_version => l_api_version,
4532: p_init_msg_list => OKE_API.G_FALSE,
4533: x_return_status => l_status,
4534: x_msg_count => x_msg_count,