1 PACKAGE INV_ShortCheckExec_PUB AUTHID CURRENT_USER AS
2 /* $Header: INVSEPUS.pls 120.1 2005/06/21 05:33:27 appldev ship $*/
3 -- Start OF comments
4 -- API name : ExecCheck
5 -- TYPE : Public
6 -- Pre-reqs : None
7 -- FUNCTION :
8 -- Parameters:
9 -- IN :
10 -- p_api_version IN NUMBER (required)
11 -- API Version of this procedure
12 --
13 -- p_init_msg_list IN VARCHAR2 (optional)
14 -- DEFAULT = FND_API.G_FALSE,
15 --
16 -- p_commit IN VARCHAR2 (optional)
17 -- DEFAULT = FND_API.G_FALSE
18 --
19 --
20 -- OUT :
21 -- x_return_status OUT NUMBER
22 -- Result of all the operations
23 --
24 -- x_msg_count OUT NUMBER,
25 --
26 -- x_msg_data OUT VARCHAR2,
27 --
28 -- Version: Current Version 1.0
29 -- Changed : Nothing
30 -- No Previous Version 0.0
31 -- Initial version 1.0
32 -- Notes :
33 -- END OF comments
34 PROCEDURE ExecCheck (
35 p_api_version IN NUMBER ,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
38 x_return_status IN OUT NOCOPY VARCHAR2,
39 x_msg_count IN OUT NOCOPY NUMBER,
40 x_msg_data IN OUT NOCOPY VARCHAR2,
41 p_sum_detail_flag IN NUMBER,
42 p_organization_id IN NUMBER,
43 p_inventory_item_id IN NUMBER,
44 p_comp_att_qty_flag IN NUMBER,
45 p_primary_quantity IN NUMBER DEFAULT 0,
46 x_seq_num OUT NOCOPY NUMBER,
47 x_check_result OUT NOCOPY VARCHAR2
48 );
49 -- Start OF comments
50 -- API name : CheckPrerequisites
51 -- TYPE : Public
52 -- Pre-reqs : None
53 -- FUNCTION :
54 -- Parameters:
55 -- IN :
56 -- p_api_version IN NUMBER (required)
57 -- API Version of this procedure
58 --
59 -- p_init_msg_list IN VARCHAR2 (optional)
60 -- DEFAULT = FND_API.G_FALSE,
61 --
62 -- p_commit IN VARCHAR2 (optional)
63 -- DEFAULT = FND_API.G_FALSE
64 --
65 --
66 -- OUT :
67 -- x_return_status OUT NUMBER
68 -- Result of all the operations
69 --
70 -- x_msg_count OUT NUMBER,
71 --
72 -- x_msg_data OUT VARCHAR2,
73 --
74 -- Version: Current Version 1.0
75 -- Changed : Nothing
76 -- No Previous Version 0.0
77 -- Initial version 1.0
78 -- Notes :
79 -- END OF comments
80 PROCEDURE CheckPrerequisites (
81 p_api_version IN NUMBER ,
82 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
83 x_return_status IN OUT NOCOPY VARCHAR2,
84 x_msg_count IN OUT NOCOPY NUMBER,
85 x_msg_data IN OUT NOCOPY VARCHAR2,
86 p_sum_detail_flag IN NUMBER,
87 p_organization_id IN NUMBER,
88 p_inventory_item_id IN NUMBER,
89 p_transaction_type_id IN NUMBER,
90 x_check_result OUT NOCOPY VARCHAR2
91 );
92 -- Start OF comments
93 -- API name : PurgeTempTable
94 -- TYPE : Public
95 -- Pre-reqs : None
96 -- FUNCTION :
97 -- Parameters:
98 -- IN :
99 -- p_api_version IN NUMBER (required)
100 -- API Version of this procedure
101 --
102 -- p_init_msg_list IN VARCHAR2 (optional)
103 -- DEFAULT = FND_API.G_FALSE,
104 --
105 -- p_commit IN VARCHAR2 (optional)
106 -- DEFAULT = FND_API.G_FALSE
107 --
108 -- p_seq_num IN NUMBER
109 -- Sequence number of rows which have to be deleted
110 --
111 --
112 -- OUT :
113 -- x_return_status OUT NUMBER
114 -- Result of all the operations
115 --
116 -- x_msg_count OUT NUMBER,
117 --
118 -- x_msg_data OUT VARCHAR2,
119 --
120 --
121 -- Version: Current Version 1.0
122 -- Changed : Nothing
123 -- No Previous Version 0.0
124 -- Initial version 1.0
125 -- Notes :
126 -- END OF comments
127 PROCEDURE PurgeTempTable (
128 p_api_version IN NUMBER ,
129 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
131 x_return_status IN OUT NOCOPY VARCHAR2,
132 x_msg_count IN OUT NOCOPY NUMBER,
133 x_msg_data IN OUT NOCOPY VARCHAR2,
134 p_seq_num IN NUMBER
135 );
136 END INV_ShortCheckExec_PUB;