[Home] [Help]
PACKAGE: APPS.NTN
Source
1 package ntn AUTHID CURRENT_USER as
2 /* $Header: PONSENDS.pls 115.2 2002/11/25 19:50:56 sbull ship $ */
3
4 type char_array is table of varchar2(300) index by binary_integer;
5
6
7 procedure Send_Notification(
8 p_employee_id number,
9 p_message_name varchar2,
10 object_id number,
11 priority number default 3,
12 deletable varchar2 default 'Y',
13 from_id number default NULL,
14 p_application_id number default 0,
15 doc_type varchar2 default NULL,
16 doc_number varchar2 default NULL,
17 amount number default NULL,
18 currency varchar2 default NULL,
19 note varchar2 default NULL,
20 start_effective_date date default NULL,
21 end_effective_date date default NULL,
22 doc_creation_date date default NULL,
23 date1 date default NULL,
24 date2 date default NULL,
25 date3 date default NULL,
26 attribute_array char_array,
27 array_lb number,
28 array_ub number,
29 return_code out NOCOPY number,
30 notification_id out NOCOPY number);
31
32
33 procedure Delete_Notification(
34 p_notification_id number,
35 return_code out NOCOPY number);
36
37 /*
38 procedure Get_Notification_Attribute(
39 p_notification_id number,
40 attribute_name varchar2,
41 attribute_value out NOCOPY varchar2);
42 */
43
44
45 procedure Delete_Notif_By_ID_Type(
46 p_object_id number,
47 p_doc_type varchar2);
48
49 procedure Forward_Notification(
50 p_notification_id number,
51 p_new_recip number,
52 p_note varchar2 default NULL);
53
54
55 /*===========================================================================
56
57 PROCEDURE NAME: notif_current
58
59 ===========================================================================*/
60
61 FUNCTION notif_current (x_notification_id NUMBER) RETURN BOOLEAN;
62
63 procedure test_in(i number);
64
65 end ntn;