APPS.OKE_CHECK_HOLD_PKG dependencies on OKE_K_HOLDS

Line 19: from oke_k_holds

15: dummy NUMBER;
16:
17: BEGIN
18: select 1 into dummy
19: from oke_k_holds
20: where k_header_id = p_k_header_id
21: and k_line_id is null
22: and deliverable_id is null
23: and remove_date is null;

Line 49: from oke_k_holds

45: dummy NUMBER;
46:
47: BEGIN
48: select 1 into dummy
49: from oke_k_holds
50: where deliverable_id = p_deliverable_id
51: and remove_date is null;
52: x_msg_data := 'DELIVERABLE ' || p_deliverable_id;
53: return TRUE;

Line 79: from oke_k_holds

75: l_parent_line_id NUMBER;
76:
77: BEGIN
78: select 1 into dummy
79: from oke_k_holds
80: where k_line_id = p_k_line_id
81: and deliverable_id is null
82: and remove_date is null;
83: x_msg_data := 'LINE ' || p_k_line_id;