PACKAGE: APPS.INVUPD2B

Source

1 package INVUPD2B as
2 /* $Header: INVUPD2S.pls 120.1.12010000.2 2008/07/29 13:48:08 ptkumar 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 FUNCTION inproit_process_item_update
92 (
93 	prg_appid  IN   NUMBER,
94 	prg_id     IN   NUMBER,
95 	req_id     IN   NUMBER,
96 	user_id    IN   NUMBER,
97 	login_id   IN   NUMBER,
98 	error_message  OUT      NOCOPY VARCHAR2,
99 	message_name   OUT      NOCOPY VARCHAR2,
100 	table_name     OUT      NOCOPY VARCHAR2,
101 	xset_id    IN   NUMBER DEFAULT NULL
102 )
103 	return INTEGER;
104 
105 FUNCTION set_process_flag3
106 (
107 			   row_id  ROWID,
108 			   user_id NUMBER := -1,
109 			   login_id        NUMBER          := -1,
110 			   prog_appid      NUMBER          := -1,
111 			   prog_id         NUMBER          := -1,
112 			   reqst_id      NUMBER          := -1
113 
114 )
115 	return INTEGER;
116 
117 FUNCTION get_message
118 (
119 	msg_name        VARCHAR2,
120 	error_text OUT	NOCOPY VARCHAR2
121 )
122 	return INTEGER;
123 
124 end INVUPD2B;