1 package PON_THREAD_DISC_PKG AUTHID CURRENT_USER as
2 /* $Header: PONTHDIS.pls 120.3 2007/08/13 04:49:29 adsahay ship $ */
3
4
5 function insert_pon_discussions(
6 p_entity_name IN VARCHAR2,
7 p_entity_pk1 IN VARCHAR2,
8 p_entity_pk2 IN VARCHAR2,
9 p_entity_pk3 IN VARCHAR2,
10 p_entity_pk4 IN VARCHAR2,
11 p_entity_pk5 IN VARCHAR2,
12 p_subject IN VARCHAR2,
13 p_language_code IN VARCHAR2,
14 p_party_id IN NUMBER,
15 p_validation_class IN VARCHAR2)
16 return NUMBER;
17
18 function insert_pon_threads(
19 p_discussion_id IN NUMBER,
20 p_subject IN VARCHAR2,
21 p_language_code IN VARCHAR2,
22 p_party_id IN NUMBER)
23 return NUMBER;
24
25 function insert_thread_entry(
26 p_from_id in NUMBER,
27 p_from_first_name in VARCHAR2,
28 p_from_last_name in VARCHAR2,
29 p_subject in VARCHAR2,
30 p_discussion_id in VARCHAR2,
31 p_thread_id in NUMBER,
32 p_broadcast_flag in VARCHAR2,
33 p_parent_id in NUMBER)
34 return NUMBER;
35
36 /*=======================================================================+
37 -- API Name: GET_REPLIED_BY_LIST
38 --
39 -- Type : Public
40 --
41 -- Pre-reqs: None
42 --
43 -- Function: This API is called by the Online Discussion code.
44 -- It returns the list of Buyer's who has already replied to
45 -- the message for given entry id.
46 --
47 -- Parameters:
48 --
49 -- p_to_id IN NUMBER
50 -- p_entry_id IN NUMBER
51 -- p_auctioneer_tp_id IN NUMBER
52 -- p_message_type IN VARCHAR2
53 --
54 *=======================================================================*/
55
56
57 function GET_REPLIED_BY_LIST (p_to_id IN NUMBER,
58 p_entry_id IN NUMBER,
59 p_auctioneer_tp_id IN NUMBER,
60 p_message_type IN VARCHAR2)
61 return VARCHAR2;
62
63
64 PROCEDURE update_recipient_to_read(
65 p_entry_id in NUMBER,
66 p_recipient_id in NUMBER,
67 p_to_company_id in NUMBER,
68 p_to_first_name in VARCHAR2,
69 p_to_last_name in VARCHAR2,
70 p_to_company_name in VARCHAR2);
71
72
73 procedure insert_or_update_recipient(
74 p_entry_id in NUMBER,
75 p_recipient_id in NUMBER,
76 p_read_flag in VARCHAR2,
77 p_replied_flag in VARCHAR2,
78 p_to_company_id in NUMBER,
79 p_to_first_name in VARCHAR2,
80 p_to_last_name in VARCHAR2,
81 p_to_company_name in VARCHAR2);
82
83
84 procedure record_read(
85 p_reader in NUMBER,
86 p_entry_id in NUMBER);
87
88 /*=======================================================================+
89 -- API Name: GET_REPLIED_BY_LIST
90 --
91 -- Type : Public
92 --
93 -- Pre-reqs: None
94 --
95 -- Function: This API is called by the Online Discussion code.
96 -- It returns the list of message recipients for
97 -- the message for given entry id.
98 --
99 -- Parameters:
100 --
101 -- p_from_id IN NUMBER
102 -- p_entry_id IN NUMBER
103 -- p_message_type IN VARCHAR2
104 --
105 *=======================================================================*/
106 function GET_RECIPIENTS_LIST (p_from_id IN NUMBER,
107 p_entry_id IN NUMBER,
108 p_message_type IN VARCHAR2)
109 RETURN VARCHAR2;
110
111 /*=======================================================================+
112 -- API Name: GET_MESSAGE_STATUS_DISP
113 --
114 -- Type : Public
115 --
116 -- Pre-reqs: None
117 --
118 -- Function: This API is called by the Print Discussion code.
119 -- It returns read, unread or replied status of
120 -- the message for given entry id, depending on viewer.
121 --
122 -- Parameters:
123 --
124 -- p_viewer_id IN NUMBER
125 -- p_entry_id IN NUMBER
126 --
127 *=======================================================================*/
128 function GET_MESSAGE_STATUS_DISP (p_viewer_id IN NUMBER,
129 p_entry_id IN NUMBER)
130 RETURN VARCHAR2;
131
132 end PON_THREAD_DISC_PKG;
133