PACKAGE: APPS.INVUPD2B

Source

1 package INVUPD2B AUTHID CURRENT_USER as
2 /* $Header: INVUPD2S.pls 120.3.12020000.3 2012/10/22 03:41:25 lanhuang ship $ */
3 
4 -- Bug 5870114
5 -- This value is set int he EGO_ITEM_PUB package when the user tries to update from PLM
6 TYPE OBJECT_VERSION_REC IS RECORD (
7      inventory_item_id   NUMBER := null,
8      org_id      NUMBER := null,
9      Object_Version_Number NUMBER := null
10 );
11 
12 obj_ver_rec OBJECT_VERSION_REC;
13 -- Code changes for Bug 5870114  Ends
14 
15 
16 FUNCTION validate_item_update_master
17 (
18 	org_id 		NUMBER,
19 	all_org 	NUMBER		:= 2,
20 	prog_appid 	NUMBER		:= -1,
21 	prog_id 	NUMBER		:= -1,
22 	request_id 	NUMBER		:= -1,
23 	user_id 	NUMBER		:= -1,
24 	login_id 	NUMBER		:= -1,
25 	err_text IN OUT	NOCOPY VARCHAR2,
26 	xset_id  IN	NUMBER		DEFAULT NULL
27 )
28 	return INTEGER;
29 
30 FUNCTION check_child_records
31 (
32 	master_row_id   ROWID,
33 	inv_item_id     NUMBER,
34 	org_id 		NUMBER,
35 	trans_id	NUMBER,
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 NULL
43 )
44 	return NUMBER;
45 
46 FUNCTION create_child_update_mast_attr
47 (
48 	master_row_id   ROWID,
49 	inv_item_id     NUMBER,
50 	org_id          NUMBER,
51 	xset_id IN      NUMBER
52 )
53 	return INTEGER;
54 
55 FUNCTION copy_master_to_child
56 (
57 	master_row_id   ROWID,
58 	inv_item_id     NUMBER,
59 	org_id IN          NUMBER,
60 	xset_id IN      NUMBER
61 )
62         return INTEGER;
63 
64 FUNCTION validate_item_update_child
65 (
66 	org_id 		NUMBER,
67 	all_org 	NUMBER		:= 2,
68 	prog_appid 	NUMBER		:= -1,
69 	prog_id 	NUMBER		:= -1,
70 	request_id 	NUMBER		:= -1,
71 	user_id 	NUMBER		:= -1,
72 	login_id 	NUMBER		:= -1,
73 	err_text IN OUT	NOCOPY VARCHAR2,
74 	xset_id  IN	NUMBER		DEFAULT NULL
75 )
76 	return INTEGER;
77 
78 FUNCTION update_validations
79 (
80 		row_id		ROWID,
81 		org_id		NUMBER,
82 		trans_id	NUMBER,
83 		user_id         NUMBER          := -1,
84 		login_id        NUMBER          := -1,
85 		prog_appid      NUMBER          := -1,
86 		prog_id         NUMBER          := -1,
87 		request_id      NUMBER          := -1
88 )
89 	return INTEGER;
90 
91 --added an extra parameter commit_flag a part of bug 8269256 fix
92 FUNCTION inproit_process_item_update
93 (
94 	prg_appid  IN   NUMBER,
95 	prg_id     IN   NUMBER,
96 	req_id     IN   NUMBER,
97 	user_id    IN   NUMBER,
98 	login_id   IN   NUMBER,
99 	error_message  OUT      NOCOPY VARCHAR2,
100 	message_name   OUT      NOCOPY VARCHAR2,
101 	table_name     OUT      NOCOPY VARCHAR2,
102 	xset_id    IN   NUMBER DEFAULT NULL,
103     commit_flag  IN     NUMBER       DEFAULT 1
104 
105 )
106 	return INTEGER;
107 
108 FUNCTION set_process_flag3
109 (
110 			   row_id  ROWID,
111 			   user_id NUMBER := -1,
112 			   login_id        NUMBER          := -1,
113 			   prog_appid      NUMBER          := -1,
114 			   prog_id         NUMBER          := -1,
115 			   reqst_id      NUMBER          := -1
116 
117 )
118 	return INTEGER;
119 
120 FUNCTION get_message
121 (
122 	msg_name        VARCHAR2,
123 	error_text OUT	NOCOPY VARCHAR2
124 )
125 	return INTEGER;
126 
127 
128 /* get_control_level(p_attrName IN VARCHAR2)
129  * PARAMETERS:
130  *	p_attrName	-	ATTRIBUTE_NAME specified in table MTL_ITEM_ATTRIBUTES
131  * RETURN VALUE:
132  *	0	-	ERROR: ATTRIBUTE_NAME NOT FOUND
133  *	1	-	CONTROLLED AT MASTER LEVEL
134  *	2	-	CONTROLLED AT ORG LEVEL
135 */
136 FUNCTION get_control_level(p_attrName IN VARCHAR2)
137 	RETURN	NUMBER;
138 
139 /* validate_recipe_enabled_flag(p_itemID IN NUMBER, p_orgID IN NUMBER)
140  * validate external dependency of attribute RECIPE_ENABLED_FLAG
141  * RETURN VALUE:
142  *	TRUE	-	no external dependency found
143  *	FALSE	-	external dependency found
144 */
145 FUNCTION validate_recipe_enabled_flag(p_itemID IN NUMBER, p_orgID IN NUMBER)
146 	RETURN	BOOLEAN;
147 
148 
149 end INVUPD2B;