PACKAGE: APPS.INVPUOPI

Source

1 PACKAGE INVPUOPI AS
2 /* $Header: INVPUP1S.pls 120.1.12010000.2 2009/03/02 21:23:16 sanmani ship $ */
3 
4 ---Start:  Bug Fix 3051653
5 FUNCTION mtl_pr_parse_item_segments
6 (p_row_id      in            rowid
7 ,item_number   out    NOCOPY VARCHAR2
8 ,item_id       out    NOCOPY NUMBER
9 ,err_text      out    NOCOPY varchar2
10 ) RETURN INTEGER ;
11 ---End: Bug Fix 3051653
12 
13 --Start :New overloaded procedure mtl_pr_parse_item_number
14 PROCEDURE mtl_pr_parse_item_number(
15    p_item_number     IN         VARCHAR2
16   ,p_segment1        OUT NOCOPY VARCHAR2
17   ,p_segment2        OUT NOCOPY VARCHAR2
18   ,p_segment3        OUT NOCOPY VARCHAR2
19   ,p_segment4        OUT NOCOPY VARCHAR2
20   ,p_segment5        OUT NOCOPY VARCHAR2
21   ,p_segment6        OUT NOCOPY VARCHAR2
22   ,p_segment7        OUT NOCOPY VARCHAR2
23   ,p_segment8        OUT NOCOPY VARCHAR2
24   ,p_segment9        OUT NOCOPY VARCHAR2
25   ,p_segment10       OUT NOCOPY VARCHAR2
26   ,p_segment11       OUT NOCOPY VARCHAR2
27   ,p_segment12       OUT NOCOPY VARCHAR2
28   ,p_segment13       OUT NOCOPY VARCHAR2
29   ,p_segment14       OUT NOCOPY VARCHAR2
30   ,p_segment15       OUT NOCOPY VARCHAR2
31   ,p_segment16       OUT NOCOPY VARCHAR2
32   ,p_segment17       OUT NOCOPY VARCHAR2
33   ,p_segment18       OUT NOCOPY VARCHAR2
34   ,p_segment19       OUT NOCOPY VARCHAR2
35   ,p_segment20       OUT NOCOPY VARCHAR2
36   ,x_err_text        OUT NOCOPY VARCHAR2);
37 --End :New overloaded procedure mtl_pr_parse_item_number
38 
39 FUNCTION mtl_pr_parse_item_number
40 (
41 item_number     varchar2,
42 item_id         number,
43 trans_id	number,
44 org_id          number,
45 err_text out	NOCOPY varchar2,
46 p_rowid         rowid
47 )
48 RETURN INTEGER;
49 
50 FUNCTION mtl_pr_parse_flex_name
51 (
52 org_id		number,
53 flex_code	varchar2,
54 flex_name	varchar2,
55 flex_id in out	NOCOPY number,
56 set_id		number,
57 err_text out    NOCOPY varchar2,
58 structure_id number default -1 /*fix for bug 8288281*/
59 )
60 RETURN INTEGER;
61 
62 function mtl_pr_trans_prod_item
63 (
64 item_number_in          varchar2,
65 org_id                  number,
66 item_id_out  out        NOCOPY number,
67 err_text     out	NOCOPY varchar2
68 )
69 RETURN INTEGER;
70 
71 function mtl_pr_trans_org_id
72 (
73 org_code	varchar2,
74 org_id out	NOCOPY number,
75 err_text out    NOCOPY varchar2
76 )
77 RETURN INTEGER;
78 
79 function mtl_pr_trans_template_id
80 (
81 templ_name	varchar2,
82 templ_id out 	NOCOPY number,
83 err_text out	NOCOPY varchar2
84 )
85 RETURN INTEGER;
86 
87 FUNCTION mtl_log_interface_err
88 (
89 org_id		number,
90 user_id		number,
91 login_id        number,
92 prog_appid      number,
93 prog_id         number,
94 req_id      	number,
95 trans_id  	number,
96 error_text	varchar2,
97 p_column_name   VARCHAR2 := NULL,
98 tbl_name        varchar2,
99 msg_name        varchar2,
100 err_text       OUT  NOCOPY VARCHAR2
101 )
102 RETURN INTEGER;
103 
104 FUNCTION mtl_pr_parse_item_name
105 (
106 item_number_in                  varchar2,
107 item_id_out  out       NOCOPY   number,
108 err_text     out       NOCOPY   varchar2
109 )RETURN INTEGER;
110 
111 
112 END INVPUOPI;