1 PACKAGE INVPOPIF AUTHID CURRENT_USER AS
2 /* $Header: INVPOPIS.pls 120.5.12010000.2 2009/07/06 06:52:02 sisankar ship $ */
3
4 PROCEDURE inopinp_open_interface_process(
5 ERRBUF OUT NOCOPY VARCHAR2,
6 RETCODE OUT NOCOPY NUMBER,
7 p_org_id IN NUMBER,
8 p_all_org IN NUMBER := 1,
9 p_val_item_flag IN NUMBER := 1,
10 p_pro_item_flag IN NUMBER := 1,
11 p_del_rec_flag IN NUMBER := 1,
12 p_xset_id IN NUMBER DEFAULT -999,
13 p_run_mode IN NUMBER DEFAULT 1,
14 p_gather_stats IN NUMBER DEFAULT 1, /* Added for Bug 8532728 */
15 source_org_id IN NUMBER DEFAULT -999 /*Added for bug 6372595*/);
16
17 FUNCTION inopinp_open_interface_process
18 (
19 org_id NUMBER,
20 all_org NUMBER := 1,
21 val_item_flag NUMBER := 1,
22 pro_item_flag NUMBER := 1,
23 del_rec_flag NUMBER := 1,
24 prog_appid NUMBER := -1,
25 prog_id NUMBER := -1,
26 request_id NUMBER := -1,
27 user_id NUMBER := -1,
28 login_id NUMBER := -1,
29 err_text IN OUT NOCOPY VARCHAR2,
30 xset_id IN NUMBER DEFAULT -999,
31 default_flag IN NUMBER DEFAULT 1,
32 commit_flag IN NUMBER := 1,
33 run_mode IN NUMBER := 1,
34 source_org_id IN NUMBER DEFAULT -999, /*Added for bug 6372595. Added functionality for looping over the master defaults assignment
35 when the import items program is called from the copy organization program*/
36 gather_stats IN NUMBER DEFAULT 1 /* Added for Bug 8532728 */
37 )
38 RETURN INTEGER;
39
40 FUNCTION inopinp_OI_process_update (
41 org_id NUMBER,
42 all_org NUMBER := 1,
43 val_item_flag NUMBER := 1,
44 pro_item_flag NUMBER := 1,
45 del_rec_flag NUMBER := 1,
46 prog_appid NUMBER := -1,
47 prog_id NUMBER := -1,
48 request_id NUMBER := -1,
49 user_id NUMBER := -1,
50 login_id NUMBER := -1,
51 err_text IN OUT NOCOPY VARCHAR2,
52 xset_id IN NUMBER DEFAULT -999,
53 commit_flag IN NUMBER DEFAULT 1,
54 default_flag IN NUMBER DEFAULT 1
55 )
56 return INTEGER;
57
58 FUNCTION inopinp_OI_process_create (
59 org_id NUMBER,
60 all_org NUMBER := 1,
61 val_item_flag NUMBER := 1,
62 pro_item_flag NUMBER := 1,
63 del_rec_flag NUMBER := 1,
64 prog_appid NUMBER := -1,
65 prog_id NUMBER := -1,
66 request_id NUMBER := -1,
67 user_id NUMBER := -1,
68 login_id NUMBER := -1,
69 err_text IN OUT NOCOPY VARCHAR2,
70 xset_id IN NUMBER DEFAULT -999,
71 commit_flag IN NUMBER DEFAULT 1,
72 default_flag IN NUMBER DEFAULT 1
73 )
74 return INTEGER;
75
76 FUNCTION indelitm_delete_item_oi (
77 err_text OUT NOCOPY VARCHAR2,
78 com_flag IN NUMBER DEFAULT 1,
79 xset_id IN NUMBER DEFAULT -999
80
81 )
82 return INTEGER;
83
84 g_source_org BOOLEAN := TRUE; /*Added for bug 6372595*/
85 END INVPOPIF;