PACKAGE: APPS.ITA_NOTIFICATION_PKG

Source

1 package ITA_NOTIFICATION_PKG as
2 /* $Header: itapnots.pls 120.2 2006/07/25 21:29:17 cpetriuc noship $ */
3 
4 
5 function GET_ORG_CONNECTIONS_STRING return VARCHAR2;
6 
7 
8 function GET_AUDIT_UNITS_STRING(p_org_id NUMBER) return VARCHAR2;
9 
10 
11 function GET_HIERARCHY_ENTITIES_STRING(p_org_type_code VARCHAR2, p_org_id NUMBER, p_control_id NUMBER) return VARCHAR2;
12 
13 
14 procedure SEND_NOTIFICATION_TO_ALL(p_change_id NUMBER);
15 
16 
17 procedure SEND_NOTIFICATION_TO_OWNER(
18 p_control_id IN NUMBER,
19 p_control_name IN VARCHAR2,
20 p_source IN VARCHAR2,
21 p_process_owner_id IN NUMBER,
22 p_return_status OUT NOCOPY VARCHAR2,
23 p_setup_group IN VARCHAR2,
24 p_application IN VARCHAR2,
25 p_org_type IN VARCHAR2,
26 p_org IN VARCHAR2,
27 p_setup_parameter IN VARCHAR2,
28 p_rec_value IN VARCHAR2,
29 p_prior_value IN VARCHAR2,
30 p_current_value IN VARCHAR2,
31 p_updated_on IN DATE,
32 p_updated_by IN VARCHAR2);
33 
34 
35 end ITA_NOTIFICATION_PKG;