DBA Data[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;