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