APPS.DPP_XLA_EVENT_MAP_PKG dependencies on DPP_XLA_EVENT_MAP

Line 1: package body DPP_XLA_EVENT_MAP_PKG as

1: package body DPP_XLA_EVENT_MAP_PKG as
2: /* $Header: dpptxemb.pls 120.0.12010000.1 2008/10/30 09:29:03 anbbalas noship $ */
3:
4: procedure LOAD_ROW (
5: p_owner IN VARCHAR2,

Line 16: CURSOR c(C_PP_TRANSACTION_TYPE VARCHAR2) IS SELECT rowid FROM DPP_XLA_EVENT_MAP

12: l_user_id NUMBER := 0;
13: l_login_id NUMBER := 0;
14: l_rowid VARCHAR2(256);
15:
16: CURSOR c(C_PP_TRANSACTION_TYPE VARCHAR2) IS SELECT rowid FROM DPP_XLA_EVENT_MAP
17: WHERE PP_TRANSACTION_TYPE = C_PP_TRANSACTION_TYPE;
18:
19: begin
20:

Line 23: update DPP_XLA_EVENT_MAP

19: begin
20:
21: l_user_id := fnd_load_util.owner_id(p_owner);
22:
23: update DPP_XLA_EVENT_MAP
24: set ENTITY_CODE = P_ENTITY_CODE,
25: EVENT_CLASS_CODE = P_EVENT_CLASS_CODE,
26: EVENT_TYPE_CODE = P_EVENT_TYPE_CODE,
27: LAST_UPDATE_DATE = SYSDATE,

Line 34: Insert into DPP_XLA_EVENT_MAP

30: where PP_TRANSACTION_TYPE = P_PP_TRANSACTION_TYPE;
31:
32: IF SQL%NOTFOUND then
33:
34: Insert into DPP_XLA_EVENT_MAP
35: (PP_TRANSACTION_TYPE,
36: ENTITY_CODE,
37: EVENT_CLASS_CODE,
38: EVENT_TYPE_CODE,

Line 66: end DPP_XLA_EVENT_MAP_PKG;

62: END IF;
63:
64: end LOAD_ROW;
65:
66: end DPP_XLA_EVENT_MAP_PKG;