DBA Data[Home] [Help]

APPS.CN_REASON_HISTORY_PKG dependencies on CN_REASON_HISTORY_ALL

Line 22: INSERT into CN_REASON_HISTORY_ALL

18: l_reason VARCHAR2(8000);
19: --
20: BEGIN
21: l_reason := p_reason_history_all_rec.reason;
22: INSERT into CN_REASON_HISTORY_ALL
23: ( REASON_HISTORY_ID,
24: REASON_ID,
25: UPDATED_TABLE,
26: UPD_TABLE_ID,

Line 125: DELETE FROM CN_REASON_HISTORY_ALL

121: PROCEDURE delete_row(
122: p_reason_history_id NUMBER) IS
123:
124: BEGIN
125: DELETE FROM CN_REASON_HISTORY_ALL
126: WHERE reason_history_id = p_reason_history_id;
127: IF (SQL%ROWCOUNT=0) THEN
128: RAISE NO_DATA_FOUND;
129: END IF;