696: l_inv_Org NUMBER;
697:
698: CURSOR get_inventory_org (p_chr NUMBER) IS
699: SELECT inv_organization_id
700: FROM OKC_K_HEADERS_B
701: WHERE ID = p_chr;
702:
703:
704: BEGIN
1171: l_del_rec OKE_CONTRACT_PUB.del_rec_type;
1172:
1173: CURSOR get_inv_org IS
1174: SELECT INV_ORGANIZATION_ID
1175: FROM OKC_K_HEADERS_B
1176: WHERE ID = p_del_rec.k_header_id;
1177:
1178: CURSOR get_intent IS
1179: SELECT BUY_OR_SELL
1176: WHERE ID = p_del_rec.k_header_id;
1177:
1178: CURSOR get_intent IS
1179: SELECT BUY_OR_SELL
1180: FROM OKC_K_HEADERS_B
1181: WHERE ID = p_del_rec.k_header_id;
1182:
1183: l_intent VARCHAR2(10);
1184: