1 PACKAGE csp_pp_util AUTHID CURRENT_USER AS
2 /* $Header: cspgtpps.pls 115.4 2002/11/26 06:42:47 hhaugeru ship $ */
3
4
5 TYPE g_mmtt_tbl_type IS TABLE OF mtl_material_transactions_temp%ROWTYPE
6 INDEX BY BINARY_INTEGER;
7 TYPE g_mtlt_tbl_type IS TABLE OF mtl_transaction_lots_temp%ROWTYPE
8 INDEX BY BINARY_INTEGER;
9 TYPE g_msnt_tbl_type IS TABLE OF mtl_serial_numbers_temp%ROWTYPE
10 INDEX BY BINARY_INTEGER;
11
12 PROCEDURE insert_mtlt
13 (
14 x_return_status OUT NOCOPY VARCHAR2
15 ,p_mtlt_tbl IN g_mtlt_tbl_type
16 ,p_mtlt_tbl_size IN INTEGER
17 );
18 --
19 -- insert record into mtl_serial_numbers_temp
20 -- who columns will be derived in the procedure
21 PROCEDURE insert_msnt
22 (
23 x_return_status OUT NOCOPY VARCHAR2
24 ,p_msnt_tbl IN g_msnt_tbl_type
25 ,p_msnt_tbl_size IN INTEGER
26 );
27 --
28 -- Start of comments
29 -- Name : split_prefix_num
30 -- Function : Separates prefix and numeric part of a serial number
31 -- Pre-reqs : none
32 -- Parameters :
33 -- p_serial_number in varchar2
34 -- p_prefix in/out varchar2 the prefix
35 -- x_num out varchar2(30) the numeric portion
36 -- Notes : privat procedure for internal use only
37 -- needed only once serial numbers are supported
38 -- End of comments
39 --
40 PROCEDURE split_prefix_num
41 (
42 p_serial_number IN VARCHAR2
43 ,p_prefix IN OUT NOCOPY VARCHAR2
44 ,x_num OUT NOCOPY VARCHAR2
45 );
46 --
47 -- For serial number support
48 FUNCTION subtract_serials
49 (
50 p_operand1 IN VARCHAR2,
51 p_operand2 IN VARCHAR2
52 ) RETURN NUMBER;
53
54 FUNCTION get_item_name (p_item_id NUMBER)
55 RETURN VARCHAR2;
56
57 END csp_pp_util;