DBA Data[Home] [Help]

PACKAGE BODY: APPS.OEP_CMERGE

Source


1 PACKAGE BODY OEP_CMERGE AS
2 /* $Header: oeoempb.pls 115.1 99/07/16 08:27:22 porting ship  $ */
3 
4 PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
5 BEGIN
6 
7   IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
8 
9 	OE_CUST_MERGE.Merge(Req_id, Set_Num, Process_Mode);
10 
11   ELSE /* old OE */
12 
13 	OEP_CMERGE_OESET.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
14   	OEP_CMERGE_OEDIS.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
15 	OEP_CMERGE_OEORD.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
16 	OEP_CMERGE_OEHLD.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
17 	OEP_CMERGE_OENTS.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
18 	OEP_CMERGE_OEPIC.MERGE(REQ_ID, SET_NUM, PROCESS_MODE);
19 
20   END IF;
21 
22 EXCEPTION
23   	WHEN OTHERS THEN RAISE;
24 
25 END MERGE;
26 
27 END OEP_CMERGE;