DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_CONTRACT_ITEM_PUB

Line 1461: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

1457: l_temp number;
1458: l_old_chr_id number;
1459: l_new_inst_id number;
1460: l_old_inst_id number;
1461: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1462: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1463:
1464: Cursor get_subscr_toplines(p_new_chr_id IN NUMBER,
1465: p_cle_id IN NUMBER) IS

Line 1462: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

1458: l_old_chr_id number;
1459: l_new_inst_id number;
1460: l_old_inst_id number;
1461: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1462: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1463:
1464: Cursor get_subscr_toplines(p_new_chr_id IN NUMBER,
1465: p_cle_id IN NUMBER) IS
1466: SELECT id, NVL(orig_system_id1, cle_id_renewed) old_line_id

Line 1551: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,

1547: For new_cp_rec in get_new_cps(l_old_inst_id) Loop
1548: -- update the item instance in object1_id1 to l_new_item_ins
1549: l_cimv_rec.id := new_cp_rec.id;
1550: l_cimv_rec.object1_id1 := l_new_inst_id;
1551: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,
1552: l_init_msg_list,
1553: l_return_status,
1554: l_msg_count,
1555: l_msg_data,

Line 1600: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,

1596: For new_cp_rec in get_new_cps(l_old_inst_id) Loop
1597: -- update the item instance in object1_id1 to l_new_item_ins
1598: l_cimv_rec.id := new_cp_rec.id;
1599: l_cimv_rec.object1_id1 := l_new_inst_id;
1600: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,
1601: l_init_msg_list,
1602: l_return_status,
1603: l_msg_count,
1604: l_msg_data,