1 PACKAGE WIP_TRANSACTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: wiptxnss.pls 115.8 2002/11/29 14:44:12 rmahidha ship $ */
3
4 /*=====================================================================+
5 | PROCEDURE
6 | MOV_CLEANUP
7 |
8 | PURPOSE
9 | Cleanup move transactions from the database after a online server
10 | side processor fails using Remote Procedure calls; reposts records
11 |
12 | ARGUMENTS
13 | IN
14 | mov_group_id Move transaction group id
15 | res_group_id Resource transaction group id
16 | mtl_header_id Material transaction header id
17 | bf_page If 2, then issues savepoint and posts bf records
18 | save_point save point name to issue
19 | OUT
20 | err_code 0 on success, -1 on error
21 | err_app Mesg dictionary application
22 | err_msg Mesg dictionary message to display on error
23 |
24 | EXCEPTIONS
25 |
26 | NOTES
27 |
28 +=====================================================================*/
29 procedure mov_cleanup(
30 mov_group_id in number,
31 res_group_id in number,
32 mtl_header_id in number,
33 bf_page in number,
34 save_point in varchar2,
35 err_code out NOCOPY number,
36 err_app out NOCOPY varchar2,
37 err_msg out NOCOPY varchar2);
38
39 /*=====================================================================+
40 | PROCEDURE
41 | CMP_CLEANUP
42 |
43 | PURPOSE
44 | Cleanup completion transactions from the database after a online server
45 | side processor fails using Remote Procedure calls; reposts records
46 |
47 | ARGUMENTS
48 | IN
49 | mtl_header_id Material transaction header id
50 | action_id Action ID: return or completion
51 | criteria_sp Save point for criteria entry
52 | entry_sp Save point for completion entry
53 | insert_sp Save point for completion inserts
54 | bf_page If 2, then issues savepoint and posts bf records
55 | OUT
56 | err_code 0 on success, -1 on error
57 | err_app Mesg dictionary application
58 | err_msg Mesg dictionary message to display on error
59 |
60 | EXCEPTIONS
61 |
62 | NOTES
63 |
64 +=====================================================================*/
65 procedure cmp_cleanup(
66 mtl_header_id in number,
67 action_id in number,
68 criteria_sp in varchar2,
69 entry_sp in varchar2,
70 insert_sp in varchar2,
71 bf_page in number,
72 err_code out NOCOPY number,
73 err_app out NOCOPY varchar2,
74 err_msg out NOCOPY varchar2);
75
76 /*=====================================================================+
77 | PROCEDURE
78 | MTL_CLEANUP
79 |
80 | PURPOSE
81 | Cleanup WIP material transactions from the database after a online server
82 | side processor fails using Remote Procedure calls; reposts records
83 |
84 | ARGUMENTS
85 | IN
86 | mtl_header_id Material transaction header id
87 | entry_sp Save point for material entry
88 | OUT
89 | err_code 0 on success, -1 on error
90 | err_app Mesg dictionary application
91 | err_msg Mesg dictionary message to display on error
92 |
93 | EXCEPTIONS
94 |
95 | NOTES
96 |
97 +=====================================================================*/
98 procedure mtl_cleanup(
99 mtl_header_id in number,
100 entry_sp in varchar2,
101 err_code out NOCOPY number,
102 err_app out NOCOPY varchar2,
103 err_msg out NOCOPY varchar2);
104
105 /*=====================================================================+
106 | PROCEDURE
107 | CLEANUP
108 |
109 | PURPOSE
110 | Cleanup move, resource, and wip material transactions from the
111 | database after a online server side processor fails using
112 | Remote Procedure calls
113 |
114 | ARGUMENTS
115 | IN
116 | mov_group_id Move transaction group id
117 | res_group_id Resource transaction group id
118 | mtl_header_id Material transaction header id
119 |
120 | EXCEPTIONS
121 | Calls FND_MESSAGE.RAISE_ERROR upon detection of error.
122 |
123 | NOTES
124 |
125 +=====================================================================*/
126 procedure cleanup(
127 mov_group_id in number,
128 res_group_id in number,
129 mtl_header_id in number);
130
131
132 function rec_count_MMTT (mtl_hdr_id in NUMBER) return NUMBER;
133 procedure cln_up_MMTT (txn_hdr_id in NUMBER);
134 procedure cln_up_MTI (txn_hdr_id in NUMBER);
135
136 PRAGMA RESTRICT_REFERENCES(rec_count_MMTT, WNDS, WNPS);
137
138 end WIP_TRANSACTIONS_PKG;