DBA Data[Home] [Help]

APPS.JTM_FND_DESC_FLEXS_ACC_PKG dependencies on JTM_FND_DESCR_FLEXS_ACC

Line 44: INSERT INTO JTM_FND_DESCR_FLEXS_ACC (

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 ,

Line 87: UPDATE JTM_FND_DESCR_FLEXS_ACC

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,

Line 117: DELETE FROM JTM_FND_DESCR_FLEXS_ACC

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;