APPS.DPP_TRANSACTION_STATUS_MAP_PKG dependencies on DPP_TRANSACTION_STATUS_MAP

Line 1: package body DPP_TRANSACTION_STATUS_MAP_PKG as

1: package body DPP_TRANSACTION_STATUS_MAP_PKG as
2: /* $Header: dppttsmb.pls 120.0.12010000.1 2008/10/30 09:27:34 anbbalas noship $ */
3:
4: procedure LOAD_ROW (
5: p_owner IN VARCHAR2,

Line 16: SELECT rowid FROM DPP_TRANSACTION_STATUS_MAP

12: l_login_id NUMBER := 0;
13: l_rowid VARCHAR2(256);
14:
15: CURSOR c(C_FROM_STATUS VARCHAR2,C_TO_STATUS VARCHAR2 ) IS
16: SELECT rowid FROM DPP_TRANSACTION_STATUS_MAP
17: WHERE FROM_STATUS = C_FROM_STATUS
18: AND TO_STATUS = C_TO_STATUS;
19:
20: begin

Line 24: update DPP_TRANSACTION_STATUS_MAP

20: begin
21:
22: l_user_id := fnd_load_util.owner_id(p_owner);
23:
24: update DPP_TRANSACTION_STATUS_MAP
25: set ENABLED_FLAG = P_ENABLED_FLAG,
26: LAST_UPDATE_DATE = SYSDATE,
27: LAST_UPDATED_BY = l_user_id,
28: LAST_UPDATE_LOGIN = l_login_id

Line 34: Insert into DPP_TRANSACTION_STATUS_MAP

30: and to_status= P_TO_STATUS;
31:
32: IF SQL%NOTFOUND then
33:
34: Insert into DPP_TRANSACTION_STATUS_MAP
35: (FROM_STATUS,
36: TO_STATUS,
37: ENABLED_FLAG,
38: CREATION_DATE,

Line 64: end DPP_TRANSACTION_STATUS_MAP_PKG;

60: END IF;
61:
62: end LOAD_ROW;
63:
64: end DPP_TRANSACTION_STATUS_MAP_PKG;