PACKAGE: APPS.CSF_DEBRIEF_UPDATE_PKG

Source

1 PACKAGE CSF_DEBRIEF_UPDATE_PKG AUTHID CURRENT_USER as
2 /* $Header: csfuppds.pls 120.3.12020000.2 2012/07/27 09:10:19 shadas ship $ */
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     p_debrief_line_id       IN  NUMBER DEFAULT null
35 );
36 
37 
38 PROCEDURE Form_Call
39 (
40     p_api_version           IN  NUMBER,
41     p_debrief_header_id       IN  NUMBER
42 );
43 
44 
45 
46 
47 procedure relieve_reservations(p_task_assignment_id IN NUMBER,
48                                x_return_status      OUT NOCOPY varchar2,
49                                x_msg_data           OUT NOCOPY varchar2,
50                                x_msg_count          OUT NOCOPY varchar2
51 )  ;
52 
53 procedure relieve_reservations(p_task_assignment_id IN NUMBER,
54                                p_inventory_item_id  IN NUMBER,
55                                p_qty IN NUMBER,
56                                p_uom IN varchar2,
57                                x_return_status      OUT NOCOPY varchar2,
58                                x_msg_data           OUT NOCOPY varchar2,
59                                x_msg_count          OUT NOCOPY varchar2
60 )  ;
61 
62 PROCEDURE web_Call
63 (
64     p_api_version           IN  NUMBER,
65     p_task_assignment_id       IN  NUMBER
66 );
67 
68 PROCEDURE DEBRIEF_STATUS_CHECK  (
69             p_incident_id          in         number,
70             p_api_version          in         number,
71             p_validation_level     in         number default 0,
72             x_debrief_status       out nocopy debrief_status_tbl_type,
73             x_return_status        out nocopy varchar2,
74             x_msg_count            out nocopy number,
75             x_msg_data             out nocopy varchar2);
76 end;
77