DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF dependencies on OKE_APPROVAL_HISTORY

Line 114: FROM oke_approval_history

110: ) IS
111:
112: CURSOR c IS
113: SELECT nvl(max(action_sequence) , 0) + 1
114: FROM oke_approval_history
115: WHERE k_header_id = G_K_Header_ID
116: AND chg_request_id is null;
117: NextSeq NUMBER;
118:

Line 125: INSERT INTO oke_approval_history

121: OPEN c;
122: FETCH c INTO NextSeq;
123: CLOSE c;
124:
125: INSERT INTO oke_approval_history
126: ( k_header_id
127: , action_sequence
128: , creation_date
129: , created_by