DBA Data[Home] [Help]

APPS.CSM_TA_AUDIT_PKG dependencies on DUAL

Line 28: SELECT JTF_TASK_AUDITS_S.nextval INTO l_t_id FROM DUAL;

24: l_r_id ROWID;
25: l_ovn NUMBER;
26: BEGIN
27:
28: SELECT JTF_TASK_AUDITS_S.nextval INTO l_t_id FROM DUAL;
29:
30: CSM_UTIL_PKG.LOG('Entered CSM_TA_AUDIT_PKG.DO_TASK_AUDIT for audit Id:'||l_t_id||' for Task ID ' || p_record.TASK_ID ,
31: 'CSM_TA_AUDIT_PKG.DO_TASK_AUDIT',FND_LOG.LEVEL_PROCEDURE);
32:

Line 127: SELECT JTF_TASK_ASSIGNMENTS_AUDIT_S.nextval INTO l_t_id FROM DUAL;

123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124: CSM_UTIL_PKG.LOG('Entering CSM_TA_AUDIT_PKG.APPLY_INSERT for Task Assignment Audit ID ' || p_record.ASSIGNMENT_AUDIT_ID ,
125: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
126:
127: SELECT JTF_TASK_ASSIGNMENTS_AUDIT_S.nextval INTO l_t_id FROM DUAL;
128:
129: CSM_UTIL_PKG.LOG('Before calling JTF_TASK_ASSIGNMENT_AUDIT_PKG.INSERT_ROW for Task Assignment Audit ID ' || l_t_id ,
130: 'CSM_TA_AUDIT_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
131: --We are calling this API as they do not support old values