APPS.OKC_CONTRACT_PVT dependencies on OKC_ACY_PVT

Line 1273: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;

1269: x_msg_count OUT NOCOPY NUMBER,
1270: x_msg_data OUT NOCOPY VARCHAR2,
1271: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1272:
1273: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1274: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1276:
1277: -- cursor to get the next level_sequence

Line 1274: l_out_rec OKC_ACY_PVT.acyv_rec_type;

1270: x_msg_data OUT NOCOPY VARCHAR2,
1271: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1272:
1273: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1274: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1276:
1277: -- cursor to get the next level_sequence
1278: Cursor l_acyv_csr Is

Line 1304: OKC_ACY_PVT.insert_row(

1300: l_acyv_rec.cle_id := p_clev_rec.id;
1301: l_acyv_rec.cle_id_ascendant := p_clev_rec.cle_id;
1302:
1303: -- insert currect record to ancestry
1304: OKC_ACY_PVT.insert_row(
1305: p_api_version => p_api_version,
1306: p_init_msg_list => p_init_msg_list,
1307: x_return_status => l_return_status,
1308: x_msg_count => x_msg_count,

Line 1324: OKC_ACY_PVT.insert_row(

1320: fetch l_acyv_csr2 into l_acyv_rec.cle_id_ascendant,
1321: l_acyv_rec.level_sequence;
1322: while l_acyv_csr2%FOUND
1323: loop
1324: OKC_ACY_PVT.insert_row(
1325: p_api_version => p_api_version,
1326: p_init_msg_list => p_init_msg_list,
1327: x_return_status => l_return_status,
1328: x_msg_count => x_msg_count,

Line 1679: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;

1675: x_msg_count OUT NOCOPY NUMBER,
1676: x_msg_data OUT NOCOPY VARCHAR2,
1677: p_cle_id IN NUMBER) Is
1678:
1679: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1680: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1682:
1683: -- cursor to get ancestry records to delete

Line 1680: l_out_rec OKC_ACY_PVT.acyv_rec_type;

1676: x_msg_data OUT NOCOPY VARCHAR2,
1677: p_cle_id IN NUMBER) Is
1678:
1679: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1680: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1682:
1683: -- cursor to get ancestry records to delete
1684: Cursor l_acyv_csr Is

Line 1701: OKC_ACY_PVT.delete_row(

1697: fetch l_acyv_csr into l_acyv_rec.cle_id,
1698: l_acyv_rec.cle_id_ascendant;
1699: while l_acyv_csr%FOUND
1700: loop
1701: OKC_ACY_PVT.delete_row(
1702: p_api_version => p_api_version,
1703: p_init_msg_list => p_init_msg_list,
1704: x_return_status => l_return_status,
1705: x_msg_count => x_msg_count,