1 PACKAGE CSM_SR_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmesrs.pls 120.3.12020000.2 2013/04/09 10:59:52 saradhak ship $ */
3
4 -- Generated 6/13/2002 7:54:10 PM from [email protected]
5
6 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
7 -- directory of SQL Navigator
8 --
9 -- Purpose: Briefly explain the functionality of the package
10 --
11 -- MODIFICATION HISTORY
12 -- Person Date Comments
13 -- --------- ------ ------------------------------------------
14 -- Melvin P 05/02/02 Base creation
15 -- Enter package declarations as shown below
16
17 -- global variable to track count of IB items at a location
18 g_ib_count NUMBER := 0;
19
20 PROCEDURE PURGE_INCIDENTS_CONC (p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
21
22 FUNCTION IS_SR_TASK ( p_task_id IN NUMBER) RETURN BOOLEAN;
23
24 FUNCTION IS_TASK_STATUS_DOWNLOADABLE(p_task_id IN NUMBER) RETURN BOOLEAN;
25
26 FUNCTION IS_ASSGN_STATUS_DOWNLOADABLE(p_task_assignment_id IN NUMBER) RETURN BOOLEAN;
27
28 PROCEDURE SPAWN_SR_CONTACTS_INS(p_incident_id IN NUMBER, p_sr_contact_point_id IN NUMBER DEFAULT NULL,
29 p_user_id IN NUMBER, p_flowtype IN VARCHAR2);
30
31 PROCEDURE SR_ITEM_INS_INIT(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER,
32 p_party_id IN NUMBER, p_location_id IN NUMBER, p_organization_id IN NUMBER,
33 p_user_id IN NUMBER, p_flow_type IN VARCHAR2);
34
35 PROCEDURE SPAWN_ITEM_INSTANCES_INS (p_instance_id IN NUMBER, p_organization_id IN NUMBER, p_user_id IN NUMBER);
36
37 PROCEDURE INCIDENTS_ACC_I(p_incident_id IN NUMBER, p_user_id IN NUMBER);
38
39 PROCEDURE SPAWN_SR_CONTACT_DEL(p_incident_id IN NUMBER, p_sr_contact_point_id IN NUMBER DEFAULT NULL,
40 p_user_id IN NUMBER, p_flowtype IN VARCHAR2);
41
42 PROCEDURE SR_ITEM_DEL_INIT(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER,
43 p_party_id IN NUMBER, p_location_id IN NUMBER, p_organization_id IN NUMBER,
44 p_user_id IN NUMBER, p_flow_type IN VARCHAR2);
45
46 PROCEDURE SPAWN_ITEM_INSTANCES_DEL (p_instance_id IN NUMBER, p_organization_id IN NUMBER,
47 p_user_id IN NUMBER);
48
49 PROCEDURE INCIDENTS_ACC_D(p_incident_id IN NUMBER, p_user_id IN NUMBER);
50
51 PROCEDURE SR_INS_INIT(p_incident_id IN NUMBER);
52
53 --12.1
54 PROCEDURE SR_DEL_INIT(p_incident_id IN NUMBER,p_user_id IN NUMBER DEFAULT NULL);
55
56 PROCEDURE SR_UPD_INIT(p_incident_id IN NUMBER, p_is_install_site_updated IN VARCHAR2,
57 p_old_install_site_id IN NUMBER,
58 p_is_incident_location_updated IN VARCHAR2,
59 p_old_incident_location_id IN NUMBER, p_is_sr_customer_updated IN VARCHAR2,
60 p_old_sr_customer_id IN NUMBER, p_is_sr_instance_updated IN VARCHAR2,
61 p_old_instance_id IN NUMBER, p_is_inventory_item_updated IN VARCHAR2,
62 p_old_inventory_item_id IN NUMBER, p_old_organization_id IN NUMBER,
63 p_old_party_id IN NUMBER, p_old_location_id IN NUMBER,
64 p_is_contr_service_id_updated IN VARCHAR2, p_old_contr_service_id IN NUMBER);
65
66 FUNCTION IS_SR_OPEN ( p_task_id IN NUMBER) RETURN BOOLEAN;
67
68 --12.1
69 FUNCTION IS_SR_DOWNLOADED_TO_OWNER( p_task_id IN NUMBER) RETURN BOOLEAN;
70
71 --12.1.2 procedure called by workflow through mobile query
72 PROCEDURE GET_PROFORMA_INVOICE (
73 itemtype IN VARCHAR2
74 ,itemkey IN VARCHAR2
75 ,actid IN NUMBER
76 ,funcmode IN VARCHAR2
77 ,RESULT IN OUT NOCOPY VARCHAR2
78 );
79
80
81 END csm_sr_event_pkg; -- Package spec