APPS.OKC_CONTRACT_PVT dependencies on OKC_ACY_PVT

Line 1215: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;

1211: x_msg_count OUT NOCOPY NUMBER,
1212: x_msg_data OUT NOCOPY VARCHAR2,
1213: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1214:
1215: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1216: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1218:
1219: -- cursor to get the next level_sequence

Line 1216: l_out_rec OKC_ACY_PVT.acyv_rec_type;

1212: x_msg_data OUT NOCOPY VARCHAR2,
1213: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1214:
1215: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1216: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1218:
1219: -- cursor to get the next level_sequence
1220: Cursor l_acyv_csr Is

Line 1246: OKC_ACY_PVT.insert_row(

1242: l_acyv_rec.cle_id := p_clev_rec.id;
1243: l_acyv_rec.cle_id_ascendant := p_clev_rec.cle_id;
1244:
1245: -- insert currect record to ancestry
1246: OKC_ACY_PVT.insert_row(
1247: p_api_version => p_api_version,
1248: p_init_msg_list => p_init_msg_list,
1249: x_return_status => l_return_status,
1250: x_msg_count => x_msg_count,

Line 1266: OKC_ACY_PVT.insert_row(

1262: fetch l_acyv_csr2 into l_acyv_rec.cle_id_ascendant,
1263: l_acyv_rec.level_sequence;
1264: while l_acyv_csr2%FOUND
1265: loop
1266: OKC_ACY_PVT.insert_row(
1267: p_api_version => p_api_version,
1268: p_init_msg_list => p_init_msg_list,
1269: x_return_status => l_return_status,
1270: x_msg_count => x_msg_count,

Line 1621: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;

1617: x_msg_count OUT NOCOPY NUMBER,
1618: x_msg_data OUT NOCOPY VARCHAR2,
1619: p_cle_id IN NUMBER) Is
1620:
1621: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1622: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1624:
1625: -- cursor to get ancestry records to delete

Line 1622: l_out_rec OKC_ACY_PVT.acyv_rec_type;

1618: x_msg_data OUT NOCOPY VARCHAR2,
1619: p_cle_id IN NUMBER) Is
1620:
1621: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1622: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1623: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1624:
1625: -- cursor to get ancestry records to delete
1626: Cursor l_acyv_csr Is

Line 1643: OKC_ACY_PVT.delete_row(

1639: fetch l_acyv_csr into l_acyv_rec.cle_id,
1640: l_acyv_rec.cle_id_ascendant;
1641: while l_acyv_csr%FOUND
1642: loop
1643: OKC_ACY_PVT.delete_row(
1644: p_api_version => p_api_version,
1645: p_init_msg_list => p_init_msg_list,
1646: x_return_status => l_return_status,
1647: x_msg_count => x_msg_count,