PACKAGE: APPS.CSF_DEBRIEF_UPDATE_PKG

Source

1 PACKAGE CSF_DEBRIEF_UPDATE_PKG as
2 /* $Header: csfuppds.pls 120.1 2006/01/05 13:34:34 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name     : CSF_DEBRIEF_UPDATE_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 TYPE debrief_status_rec_type IS RECORD (
11   task_id                    NUMBER := null,
12   task_number                VARCHAR2(30) := null,
13   debrief_header_id          number := null,
14   debrief_number             varchar2(50) := null,
15   debrief_status             VARCHAR2(1) := null);
16 
17   g_miss_debrief_status_rec  debrief_status_rec_type;
18   g_debrief_status_rec       debrief_status_rec_type;
19 
20 TYPE  debrief_status_tbl_type IS TABLE OF debrief_status_rec_type
21                                     INDEX BY BINARY_INTEGER;
22   g_miss_debrief_status_tbl debrief_status_tbl_type;
23   g_debrief_status_tbl      debrief_status_tbl_type;
24 
25   g_debrief_line_id         number := null;
26   g_account_id              number := null;
27 
28 PROCEDURE main
29 (   errbuf                  OUT NOCOPY VARCHAR2,
30     retcode                 OUT NOCOPY NUMBER,
31     p_api_version           IN  NUMBER,
32     p_debrief_header_id     IN  NUMBER DEFAULT null,
33     p_incident_id           IN  NUMBER DEFAULT null
34 );
35 
36 
37 PROCEDURE Form_Call
38 (
39     p_api_version           IN  NUMBER,
40     p_debrief_header_id       IN  NUMBER
41 );
42 
43 
44 
45 
46 procedure relieve_reservations(p_task_assignment_id IN NUMBER,
47                                x_return_status      OUT NOCOPY varchar2,
48                                x_msg_data           OUT NOCOPY varchar2,
49                                x_msg_count          OUT NOCOPY varchar2
50 )  ;
51 
52 PROCEDURE web_Call
53 (
54     p_api_version           IN  NUMBER,
55     p_task_assignment_id       IN  NUMBER
56 );
57 
58 PROCEDURE DEBRIEF_STATUS_CHECK  (
59             p_incident_id          in         number,
60             p_api_version          in         number,
61             p_validation_level     in         number default 0,
62             x_debrief_status       out nocopy debrief_status_tbl_type,
63             x_return_status        out nocopy varchar2,
64             x_msg_count            out nocopy number,
65             x_msg_data             out nocopy varchar2);
66 end;
67