40:
41: SELECT JTM_FND_DESC_FLEXS_ACC_S.NEXTVAL
42: INTO X_ACCESS_ID FROM DUAL;
43:
44: INSERT INTO JTM_FND_DESCR_FLEXS_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_DESCR_FLEXS_ACC
88: SET LAST_UPDATE_DATE = SYSDATE,
89: LAST_UPDATED_BY = 1,
90: CREATED_BY = 1,
91: CREATION_DATE = CREATION_DATE,
113: X_APPLICATION_ID IN NUMBER
114: ) IS
115:
116: BEGIN
117: DELETE FROM JTM_FND_DESCR_FLEXS_ACC
118: WHERE BASE_APPLICATION_ID = X_BASE_APPLICATION_ID
119: AND DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
120: AND MOBILE_TABLE_NAME = X_MOBILE_TABLE_NAME
121: AND APPLICATION_ID = X_APPLICATION_ID;