65: return l_discussion_id;
66:
67: END insert_pon_discussions;
68:
69: function insert_pon_threads(
70: p_discussion_id IN NUMBER,
71: p_subject IN VARCHAR2,
72: p_language_code IN VARCHAR2,
73: p_party_id IN NUMBER)
83: l_now_date := sysdate;
84:
85: SELECT nvl(max(thread_number), -1)
86: INTO l_prev_thread_number
87: FROM pon_threads
88: WHERE discussion_id = p_discussion_id;
89:
90: SELECT nvl(p_language_code, language_code)
91: INTO l_lang_code
92: FROM pon_discussions
93: WHERE discussion_id = p_discussion_id;
94:
95:
96: INSERT INTO pon_threads(
97: THREAD_NUMBER,
98: OWNER_PARTY_ID,
99: DISCUSSION_ID,
100: SUBJECT,
113: WHERE discussion_id = p_discussion_id;
114:
115: return l_prev_thread_number + 1;
116:
117: END insert_pon_threads;
118:
119:
120: function insert_thread_entry(
121: p_from_id in NUMBER,
163: p_discussion_id,
164: p_broadcast_flag,
165: empty_clob());
166:
167: UPDATE pon_threads
168: SET last_update_date = l_now_date
169: WHERE discussion_id = p_discussion_id
170: AND thread_number = p_thread_id;
171: