1 PACKAGE CSM_TASK_ASSIGNMENT_EVENT_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmetas.pls 120.1 2005/07/25 00:26:36 trajasek noship $ */
3
4 -- Generated 6/13/2002 7:56:05 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 -- Enter package declarations as shown below
15
16 PROCEDURE PURGE_TASK_ASSIGNMENTS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2);
17
18 PROCEDURE TASK_ASSIGNMENT_INITIALIZER (p_task_assignment_id IN NUMBER,
19 p_error_msg OUT NOCOPY VARCHAR2,
20 x_return_status IN OUT NOCOPY VARCHAR2);
21
22 PROCEDURE SPAWN_DEBRIEF_HEADER_INS (p_task_assignment_id IN NUMBER,
23 p_user_id IN NUMBER,
24 p_flow_type IN VARCHAR2);
25
26 PROCEDURE SPAWN_DEBRIEF_LINE_INS (p_task_assignment_id IN NUMBER,
27 p_user_id IN NUMBER,
28 p_flow_type IN VARCHAR2);
29
30 PROCEDURE SPAWN_REQUIREMENT_HEADER_INS(p_task_assignment_id IN NUMBER,
31 p_user_id IN NUMBER,
32 p_flow_type IN VARCHAR2);
33
34 PROCEDURE SPAWN_REQUIREMENT_LINES_INS(p_task_assignment_id IN NUMBER,
35 p_user_id IN NUMBER,
36 p_flow_type IN VARCHAR2);
37
38 PROCEDURE TASK_ASSIGNMENTS_ACC_PROCESSOR(p_task_assignment_id IN NUMBER,
39 p_incident_id IN NUMBER,
40 p_task_id IN NUMBER,
41 p_source_object_type_code IN VARCHAR2,
42 p_flow_type IN VARCHAR2,
43 p_user_id IN NUMBER);
44
45 PROCEDURE ACC_INSERT(p_task_assignment_id IN NUMBER, p_user_id IN NUMBER);
46
47 PROCEDURE LOBS_MDIRTY_I(p_task_assignment_id IN NUMBER, p_resource_id IN NUMBER);
48
49 PROCEDURE TASK_ASSIGNMENT_HIST_INIT(p_task_assignment_id IN NUMBER,
50 p_parent_incident_id IN NUMBER,
51 p_user_id IN NUMBER,
52 p_error_msg OUT NOCOPY VARCHAR2,
53 x_return_status IN OUT NOCOPY VARCHAR2);
54
55 PROCEDURE TASK_ASSIGNMENT_PURGE_INIT (p_task_assignment_id IN NUMBER,
56 p_error_msg OUT NOCOPY VARCHAR2,
57 x_return_status IN OUT NOCOPY VARCHAR2);
58
59 PROCEDURE LOBS_MDIRTY_D(p_task_assignment_id IN NUMBER, p_resource_id IN NUMBER);
60
61 PROCEDURE SPAWN_DEBRIEF_LINE_DEL (p_task_assignment_id IN NUMBER,
62 p_user_id IN NUMBER,
63 p_flow_type IN VARCHAR2);
64
65 PROCEDURE SPAWN_DEBRIEF_HEADER_DEL (p_task_assignment_id IN NUMBER,
66 p_user_id IN NUMBER,
67 p_flow_type IN VARCHAR2);
68
69 PROCEDURE SPAWN_REQUIREMENT_HEADER_DEL(p_task_assignment_id IN NUMBER,
70 p_user_id IN NUMBER,
71 p_flow_type IN VARCHAR2);
72
73 PROCEDURE SPAWN_REQUIREMENT_LINES_DEL(p_task_assignment_id IN NUMBER,
74 p_user_id IN NUMBER,
75 p_flow_type IN VARCHAR2);
76
77 PROCEDURE TASK_ASSIGNMENTS_ACC_D(p_task_assignment_id IN NUMBER,
78 p_incident_id IN NUMBER,
79 p_task_id IN NUMBER,
80 p_source_object_type_code IN VARCHAR2,
81 p_flow_type IN VARCHAR2,
82 p_user_id IN NUMBER);
83
84 PROCEDURE ACC_DELETE(p_task_assignment_id IN NUMBER, p_user_id IN NUMBER);
85
86 PROCEDURE TASK_ASSIGNMENT_HIST_DEL_INIT(p_task_assignment_id IN NUMBER,
87 p_parent_incident_id IN NUMBER,
88 p_user_id IN NUMBER,
89 p_error_msg OUT NOCOPY VARCHAR2,
90 x_return_status IN OUT NOCOPY VARCHAR2);
91
92 END CSM_TASK_ASSIGNMENT_EVENT_PKG;
93 -- Package spec