1 PACKAGE EGO_ITEM_OPEN_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: EGOPOPIS.pls 120.9 2011/07/14 11:53:38 nendrapu ship $ */
3
4 PROCEDURE item_open_interface_process(
5 ERRBUF OUT NOCOPY VARCHAR2
6 ,RETCODE OUT NOCOPY VARCHAR2
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 := -999
13 ,p_run_mode IN NUMBER := 1
14 ,p_prog_appid IN NUMBER := -1
15 ,p_prog_id IN NUMBER := -1
16 ,p_request_id IN NUMBER := -1
17 ,p_user_id IN NUMBER := -1
18 ,p_login_id IN NUMBER := -1
19 ,p_commit_flag IN NUMBER := 1
20 ,p_default_flag IN NUMBER DEFAULT 1 );
21
22 --4717744 : All item entities in a new prg
23 PROCEDURE process_item_entities(
24 ERRBUF OUT NOCOPY VARCHAR2
25 ,RETCODE OUT NOCOPY VARCHAR2
26 ,p_del_rec_flag IN NUMBER := 1
27 ,p_xset_id IN NUMBER := -999
28 ,p_request_id IN NUMBER := -1
29 ,p_call_uda_process IN BOOLEAN DEFAULT TRUE -- Bug 12635842
30
31 );
32
33
34 -------------------------------------------------------------------
35 -- In this method we call methods for copying
36 -- 1. Item People
37 -- 2. Item LC Project
38 -- 3. Item Attachments
39 -------------------------------------------------------------------
40 PROCEDURE Post_Import_Defaulting(ERRBUF OUT NOCOPY VARCHAR2,
41 RETCODE OUT NOCOPY VARCHAR2,
42 p_batch_id IN NUMBER,
43 p_del_rec_flag IN NUMBER := 1);
44
45 --------------------------------------------------------------------
46 -- EGO Concurrent Wrapper API for INV Concurrent API for processing
47 -- Item Category Assignments (from MTL_ITEM_CATEGORIES_INTERFACE)
48 --
49 -- Fix for Bug# 3616946 (PPEDDAMA)
50 -- Removed the parameters: Upload Processed Records and Delete
51 -- Processed Records from UI. So, defaulting the values in this API:
52 -- Upload Processed Records = 1 (Yes)
53 -- Delete Processed Records = 0 (No)
54 --------------------------------------------------------------------
55
56 PROCEDURE process_Item_Category_records(
57 ERRBUF OUT NOCOPY VARCHAR2
58 ,RETCODE OUT NOCOPY VARCHAR2
59 ,p_rec_set_id IN NUMBER
60 ,p_upload_rec_flag IN NUMBER := 1
61 ,p_delete_rec_flag IN NUMBER := 0
62 ,p_commit_flag IN NUMBER := 1
63 ,p_prog_appid IN NUMBER := NULL
64 ,p_prog_id IN NUMBER := NULL
65 ,p_request_id IN NUMBER := NULL
66 ,p_user_id IN NUMBER := NULL
67 ,p_login_id IN NUMBER := NULL);
68
69
70 ------------------------------------------------------------------------------------
71 /*
72 Procedure for Displaying Error in the Concurrent Log.
73 In case the Error Page is not working, helps in Debugging.
74 Fix for Bug#4540712 (RSOUNDAR)
75
76 param p_entity_name:Entity for which the Error is reported.
77 param p_table_name :Table from which the Error is generated.
78 param p_selectQuery:Query for getting ITEM_NUMBER,ORGANIZATION_CODE,ERROR_MESSAGE
79 from the respective interface tables calling this API.
80 param p_request_id :Request ID of the transaction.
81 param x_return_status:Returns the unexpected error encountered during processing.
82 param x_msg_count: Indicates how many messages exist on ERROR_HANDLER
83 message stack upon completion of processing.
84 param x_msg_data:Contains message in ERROR_HANDLER message stack
85 upon completion of processing.
86 */
87 --------------------------------------------------------------------------------------
88 PROCEDURE Write_Error_into_ConcurrentLog(
89 p_entity_name IN VARCHAR2
90 ,p_table_name IN VARCHAR2
91 ,p_selectQuery IN VARCHAR2
92 ,p_request_id IN NUMBER
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2);
96
97 ------------------------------------------------------------------------------------
98 /*
99 Procedure for Applying the specfied template to the specified interface row.
100 */
101 --------------------------------------------------------------------------------------
102
103 FUNCTION APPLY_MULTIPLE_TEMPLATE( p_template_id IN NUMBER
104 ,p_org_id IN NUMBER
105 ,p_all_org IN NUMBER := 2
106 ,p_prog_appid IN NUMBER := -1
107 ,p_prog_id IN NUMBER := -1
108 ,p_request_id IN NUMBER := -1
109 ,p_user_id IN NUMBER := -1
110 ,p_login_id IN NUMBER := -1
111 ,p_xset_id IN NUMBER := -999
112 ,x_err_text IN OUT NOCOPY VARCHAR2)
113 RETURN INTEGER;
114
115 END EGO_ITEM_OPEN_INTERFACE_PVT;