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
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);
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);
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:
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;
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:
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;