1 PACKAGE INVPOPIF AS
2 /* $Header: INVPOPIS.pls 120.5 2008/01/24 09:37:16 ajmittal noship $ */
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 source_org_id IN NUMBER DEFAULT -999 /*Added for bug 6372595*/);
15
16 FUNCTION inopinp_open_interface_process
17 (
18 org_id NUMBER,
19 all_org NUMBER := 1,
20 val_item_flag NUMBER := 1,
21 pro_item_flag NUMBER := 1,
22 del_rec_flag NUMBER := 1,
23 prog_appid NUMBER := -1,
24 prog_id NUMBER := -1,
25 request_id NUMBER := -1,
26 user_id NUMBER := -1,
27 login_id NUMBER := -1,
28 err_text IN OUT NOCOPY VARCHAR2,
29 xset_id IN NUMBER DEFAULT -999,
30 default_flag IN NUMBER DEFAULT 1,
31 commit_flag IN NUMBER := 1,
32 run_mode IN NUMBER := 1,
33 source_org_id IN NUMBER DEFAULT -999 /*Added for bug 6372595. Added functionality for looping over the master defaults assignment
34 when the import items program is called from the copy organization program*/
35 )
36 RETURN INTEGER;
37
38 FUNCTION inopinp_OI_process_update (
39 org_id NUMBER,
40 all_org NUMBER := 1,
41 val_item_flag NUMBER := 1,
42 pro_item_flag NUMBER := 1,
43 del_rec_flag NUMBER := 1,
44 prog_appid NUMBER := -1,
45 prog_id NUMBER := -1,
46 request_id NUMBER := -1,
47 user_id NUMBER := -1,
48 login_id NUMBER := -1,
49 err_text IN OUT NOCOPY VARCHAR2,
50 xset_id IN NUMBER DEFAULT -999,
51 commit_flag IN NUMBER DEFAULT 1,
52 default_flag IN NUMBER DEFAULT 1
53 )
54 return INTEGER;
55
56 FUNCTION inopinp_OI_process_create (
57 org_id NUMBER,
58 all_org NUMBER := 1,
59 val_item_flag NUMBER := 1,
60 pro_item_flag NUMBER := 1,
61 del_rec_flag NUMBER := 1,
62 prog_appid NUMBER := -1,
63 prog_id NUMBER := -1,
64 request_id NUMBER := -1,
65 user_id NUMBER := -1,
66 login_id NUMBER := -1,
67 err_text IN OUT NOCOPY VARCHAR2,
68 xset_id IN NUMBER DEFAULT -999,
69 commit_flag IN NUMBER DEFAULT 1,
70 default_flag IN NUMBER DEFAULT 1
71 )
72 return INTEGER;
73
74 FUNCTION indelitm_delete_item_oi (
75 err_text OUT NOCOPY VARCHAR2,
76 com_flag IN NUMBER DEFAULT 1,
77 xset_id IN NUMBER DEFAULT -999
78
79 )
80 return INTEGER;
81
82 g_source_org BOOLEAN := TRUE; /*Added for bug 6372595*/
83 END INVPOPIF;