DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 1710: from OKC_K_ITEMS

1706: where cle_id = p_clev_rec.id;
1707:
1708: Cursor l_cimv_csr Is
1709: select count(*)
1710: from OKC_K_ITEMS
1711: where cle_id = p_clev_rec.id;
1712:
1713: Cursor l_crjv_csr Is
1714: SELECT id, object_version_number

Line 1808: p_token1_value => 'OKC_K_ITEMS_V',

1804: Else
1805: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1806: p_msg_name => g_no_parent_record,
1807: p_token1 => g_child_table_token,
1808: p_token1_value => 'OKC_K_ITEMS_V',
1809: p_token2 => g_parent_table_token,
1810: p_token2_value => 'OKC_K_LINES_V');
1811: -- notify caller of an error
1812: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 2050: FROM Okc_K_ITEMS

2046: WHERE cle_Id=P_Parent_Id;
2047:
2048: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2049: IS SELECT ID
2050: FROM Okc_K_ITEMS
2051: WHERE cle_Id=P_Line_Id;
2052:
2053: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
2054: IS SELECT Tve_ID

Line 2505: FROM Okc_K_ITEMS

2501: WHERE cle_Id=P_Parent_Id;
2502:
2503: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2504: IS SELECT ID
2505: FROM Okc_K_ITEMS
2506: WHERE cle_Id=P_Line_Id;
2507:
2508: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
2509: IS SELECT Tve_ID