DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 1768: from OKC_K_ITEMS

1764: where cle_id = p_clev_rec.id;
1765:
1766: Cursor l_cimv_csr Is
1767: select count(*)
1768: from OKC_K_ITEMS
1769: where cle_id = p_clev_rec.id;
1770:
1771: Cursor l_crjv_csr Is
1772: SELECT id, object_version_number

Line 1866: p_token1_value => 'OKC_K_ITEMS_V',

1862: Else
1863: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1864: p_msg_name => g_no_parent_record,
1865: p_token1 => g_child_table_token,
1866: p_token1_value => 'OKC_K_ITEMS_V',
1867: p_token2 => g_parent_table_token,
1868: p_token2_value => 'OKC_K_LINES_V');
1869: -- notify caller of an error
1870: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 2108: FROM Okc_K_ITEMS

2104: WHERE cle_Id=P_Parent_Id;
2105:
2106: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2107: IS SELECT ID
2108: FROM Okc_K_ITEMS
2109: WHERE cle_Id=P_Line_Id;
2110:
2111: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
2112: IS SELECT Tve_ID

Line 2563: FROM Okc_K_ITEMS

2559: WHERE cle_Id=P_Parent_Id;
2560:
2561: CURSOR Item_Cur(P_Line_Id IN NUMBER)
2562: IS SELECT ID
2563: FROM Okc_K_ITEMS
2564: WHERE cle_Id=P_Line_Id;
2565:
2566: CURSOR RT_Cur(P_Rule_Id IN NUMBER)
2567: IS SELECT Tve_ID