5: -- NAME
6: -- JTM_LOOKUPS_ACC_PKG
7: --
8: -- PURPOSE
9: -- TABLE-LEVEL PACKAGE for JTM_FND_LOOKUPS_ACC.
10: --
11: -- PROCEDURES:
12: --
13: --
37: ) IS
38:
39: BEGIN
40:
41: SELECT JTM_FND_LOOKUPS_ACC_S.NEXTVAL
42: INTO X_ACCESS_ID FROM DUAL;
43:
44: INSERT INTO JTM_FND_LOOKUPS_ACC (
45: ACCESS_ID ,
40:
41: SELECT JTM_FND_LOOKUPS_ACC_S.NEXTVAL
42: INTO X_ACCESS_ID FROM DUAL;
43:
44: INSERT INTO JTM_FND_LOOKUPS_ACC (
45: ACCESS_ID ,
46: LAST_UPDATE_DATE ,
47: LAST_UPDATED_BY ,
48: CREATION_DATE ,
83: X_APPLICATION_ID IN NUMBER
84: ) IS
85:
86: BEGIN
87: UPDATE JTM_FND_LOOKUPS_ACC
88: SET LAST_UPDATE_DATE = SYSDATE,
89: LAST_UPDATED_BY = 1,
90: CREATED_BY = 1,
91: CREATION_DATE = CREATION_DATE,
114: X_APPLICATION_ID IN NUMBER
115: ) IS
116:
117: BEGIN
118: DELETE FROM JTM_FND_LOOKUPS_ACC
119: WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
120: AND VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
121: AND SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
122: AND APPLICATION_ID = X_APPLICATION_ID;