APPS.PON_THREAD_DISC_PKG dependencies on PON_DISCUSSIONS

Line 6: function insert_pon_discussions(

2: /* $Header: PONTHDIB.pls 120.8.12010000.2 2009/02/11 15:56:59 ankusriv ship $ */
3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_THREAD_DISC_PKG.';
5:
6: function insert_pon_discussions(
7: p_entity_name IN VARCHAR2,
8: p_entity_pk1 IN VARCHAR2,
9: p_entity_pk2 IN VARCHAR2,
10: p_entity_pk3 IN VARCHAR2,

Line 27: FROM pon_discussions

23: -- bug 8224577
24: BEGIN
25: SELECT discussion_id
26: INTO l_discussion_id
27: FROM pon_discussions
28: WHERE ENTITY_NAME = p_entity_name
29: AND pk1_value = p_entity_pk1;
30:
31: EXCEPTION

Line 34: SELECT pon_discussions_s.nextval

30:
31: EXCEPTION
32: WHEN No_Data_Found THEN
33:
34: SELECT pon_discussions_s.nextval
35: INTO l_discussion_id
36: FROM dual;
37:
38: INSERT INTO pon_discussions(

Line 38: INSERT INTO pon_discussions(

34: SELECT pon_discussions_s.nextval
35: INTO l_discussion_id
36: FROM dual;
37:
38: INSERT INTO pon_discussions(
39: DISCUSSION_ID,
40: ENTITY_NAME,
41: PK1_VALUE,
42: SUBJECT,

Line 67: END insert_pon_discussions;

63: p_party_id);
64: END;
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,

Line 92: FROM pon_discussions

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(

Line 111: UPDATE pon_discussions

107: p_subject,
108: l_lang_code,
109: l_now_date);
110:
111: UPDATE pon_discussions
112: SET last_update_date = l_now_date
113: WHERE discussion_id = p_discussion_id;
114:
115: return l_prev_thread_number + 1;

Line 172: UPDATE pon_discussions

168: SET last_update_date = l_now_date
169: WHERE discussion_id = p_discussion_id
170: AND thread_number = p_thread_id;
171:
172: UPDATE pon_discussions
173: SET last_update_date = l_now_date
174: WHERE discussion_id = p_discussion_id;
175:
176: RETURN l_entry_id;