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 1297: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

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

Line 1299: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,

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

Line 1307: l_cle_tbl oke_cle_pvt.cle_tbl_type;

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

Line 1405: p_cle_rec IN oke_cle_pvt.cle_rec_type,

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

Line 1407: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,

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

Line 1526: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

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

Line 1528: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,

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

Line 1633: p_cle_rec IN oke_cle_pvt.cle_rec_type,

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

Line 1636: l_cle_rec oke_cle_pvt.cle_rec_type;

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

Line 1751: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

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

Line 1962: p_cle_rec IN oke_cle_pvt.cle_rec_type,

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

Line 1965: l_cle_rec oke_cle_pvt.cle_rec_type;

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

Line 2086: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,

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

Line 2095: l_cle_tbl oke_cle_pvt.cle_tbl_type := p_cle_tbl;

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

Line 4143: l_cle_tbl OKE_CLE_PVT.cle_tbl_type;

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

Line 4532: OKE_CLE_PVT.delete_row(

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