PACKAGE: APPS.INVUPD1B

Source

1 package INVUPD1B AUTHID CURRENT_USER as
2 /* $Header: INVUPD1S.pls 115.6 2002/12/01 02:15:02 rbande ship $ */
3 
4 FUNCTION mtl_pr_assign_item_data_update
5 (
6 	org_id		NUMBER,
7 	all_org		NUMBER		:= 2,
8 	prog_appid	NUMBER		:= -1,
9 	prog_id		NUMBER		:= -1,
10 	request_id	NUMBER		:= -1,
11 	user_id		NUMBER		:= -1,
12 	login_id	NUMBER		:= -1,
13 	err_text IN OUT	NOCOPY VARCHAR2,
14 	xset_id  IN	NUMBER		DEFAULT -999
15 )
16 	return INTEGER;
17 
18 FUNCTION chk_exist_copy_template_attr
19 (
20 	org_id		NUMBER,
21 	all_org		NUMBER		:= 2,
22 	prog_appid	NUMBER		:= -1,
23 	prog_id		NUMBER		:= -1,
24 	request_id	NUMBER		:= -1,
25 	user_id		NUMBER		:= -1,
26 	login_id	NUMBER		:= -1,
27 	err_text IN OUT	NOCOPY VARCHAR2,
28 	xset_id  IN	NUMBER		DEFAULT -999
29 )
30 	return INTEGER;
31 
32 FUNCTION check_inv_item_id
33 (
34 	org_id		NUMBER,
35 	all_org		NUMBER		:= 2,
36 	prog_appid	NUMBER		:= -1,
37 	prog_id		NUMBER		:= -1,
38 	request_id	NUMBER		:= -1,
39 	user_id		NUMBER		:= -1,
40 	login_id	NUMBER		:= -1,
41 	err_text IN OUT	NOCOPY VARCHAR2,
42 	xset_id  IN	NUMBER		DEFAULT -999
43 )
44 	return INTEGER;
45 
46 FUNCTION exists_in_msi
47 (
48 	row_id          	ROWID,
49 	org_id			NUMBER,
50 	inv_item_id IN OUT	NOCOPY NUMBER,
51 	prog_appid		NUMBER		:= -1,
52 	prog_id			NUMBER		:= -1,
53 	request_id		NUMBER		:= -1,
54 	user_id			NUMBER		:= -1,
55 	login_id		NUMBER		:= -1,
56 	trans_id		NUMBER,
57 	err_text IN OUT		NOCOPY VARCHAR2,
58 	xset_id  IN		NUMBER		DEFAULT NULL
59 )
60 	return INTEGER;
61 
62 FUNCTION exists_onhand_quantities
63 (
64 	org_id		NUMBER,
65 	inv_item_id	NUMBER
66 )
67 	return INTEGER;
68 
69 FUNCTION exists_onhand_child_qties
70 (
71 	org_id		NUMBER,
72 	inv_item_id	NUMBER
73 )
74 	return INTEGER;
75 
76 FUNCTION copy_msi_to_msii
77 (
78 	row_id          ROWID,
79 	org_id          NUMBER,
80 	inv_item_id     NUMBER
81 )
82 	return INTEGER;
83 
84 FUNCTION mtl_pr_validate_item_update
85 (
86 	org_id 		NUMBER,
87 	all_org 	NUMBER		:= 2,
88 	prog_appid 	NUMBER		:= -1,
89 	prog_id 	NUMBER		:= -1,
90 	request_id 	NUMBER		:= -1,
91 	user_id 	NUMBER		:= -1,
92 	login_id 	NUMBER		:= -1,
93 	err_text IN OUT	NOCOPY VARCHAR2,
94 	xset_id  IN	NUMBER		DEFAULT NULL
95 )
96 	return INTEGER;
97 
98 --
99 -- Check for attribute dependencies impacted by onhand quantites.
100 --
101 
102 FUNCTION mtl_validate_attr_upd
103 (
104    org_id		IN  NUMBER
105 ,  item_id              IN  NUMBER
106 ,  row_id		IN  ROWID
107 ,  attr_err_mesg_name   OUT NOCOPY VARCHAR2
108 )
109 RETURN  INTEGER;
110 
111 
112 END INVUPD1B;