[Home] [Help]
PACKAGE: APPS.INVPUOPI
Source
1 PACKAGE INVPUOPI AUTHID CURRENT_USER 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;