1 Package IBU_MULTIPARTY_PUB AUTHID CURRENT_USER as
2 /* $Header: ibuspubs.pls 120.2 2008/04/23 10:01:13 majha noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 /* Purpose:Craeted the public API to be used by the customers to send emil notification
8 to persons in case of addition or removal of parties */
9 -- Enter package declarations as shown below
10
11 g_file_name VARCHAR2(32) := 'ibuspubs.pls';
12
13 /* Use the procedure to send the email notification to the persons when thers is a addition or removal of
14 parties. */
15
16 /* p_operation_type will consist two values
17 1. A - In case of addition
18 2. R - In case of removal*/
19
20 /*p_user_id is the id of the user for which association or removal is performed */
21
22 /* p_party_id is the id the organisation being associated or removed from a user*/
23
24 PROCEDURE send_email_notification( p_user_id IN SYSTEM.IBU_NUM_TBL_TYPE,
25 p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,
26 p_operation_type IN system.IBU_VAR_3_TBL_TYPE
27 );
28
29 END IBU_MULTIPARTY_PUB;