DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_CONTRACT_ITEM_PUB

Line 1453: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

1449: l_temp number;
1450: l_old_chr_id number;
1451: l_new_inst_id number;
1452: l_old_inst_id number;
1453: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1454: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1455:
1456: Cursor get_subscr_toplines(p_new_chr_id IN NUMBER,
1457: p_cle_id IN NUMBER) IS

Line 1454: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;

1450: l_old_chr_id number;
1451: l_new_inst_id number;
1452: l_old_inst_id number;
1453: l_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1454: x_cimv_rec OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
1455:
1456: Cursor get_subscr_toplines(p_new_chr_id IN NUMBER,
1457: p_cle_id IN NUMBER) IS
1458: SELECT id, NVL(orig_system_id1, cle_id_renewed) old_line_id

Line 1543: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,

1539: For new_cp_rec in get_new_cps(l_old_inst_id) Loop
1540: -- update the item instance in object1_id1 to l_new_item_ins
1541: l_cimv_rec.id := new_cp_rec.id;
1542: l_cimv_rec.object1_id1 := l_new_inst_id;
1543: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,
1544: l_init_msg_list,
1545: l_return_status,
1546: l_msg_count,
1547: l_msg_data,

Line 1592: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,

1588: For new_cp_rec in get_new_cps(l_old_inst_id) Loop
1589: -- update the item instance in object1_id1 to l_new_item_ins
1590: l_cimv_rec.id := new_cp_rec.id;
1591: l_cimv_rec.object1_id1 := l_new_inst_id;
1592: OKC_CONTRACT_ITEM_PUB.update_contract_item(l_api_version,
1593: l_init_msg_list,
1594: l_return_status,
1595: l_msg_count,
1596: l_msg_data,