APPS.CS_AUDIT_UPGRADE_CON_PRG dependencies on CS_INCIDENTS_AUDIT_B

Line 312: FROM cs_incidents_audit_b

308: PRIMARY_CONTACT_ID ,
309: CHANGE_PRIMARY_CONTACT_FLAG ,
310: OLD_PRIMARY_CONTACT_ID ,
311: SECURITY_GROUP_ID
312: FROM cs_incidents_audit_b
313: WHERE INCIDENT_ID = c_incident_id
314: AND NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
315: AND NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER'
316: ORDER BY creation_date desc, incident_audit_id desc;

Line 453: FROM cs_incidents_audit_b

449: PRIMARY_CONTACT_ID ,
450: CHANGE_PRIMARY_CONTACT_FLAG ,
451: OLD_PRIMARY_CONTACT_ID ,
452: SECURITY_GROUP_ID
453: FROM cs_incidents_audit_b
454: WHERE INCIDENT_ID = c_incident_id
455: AND NVL(UPGRADE_FLAG_FOR_CREATE,'N') = 'N'
456: AND NVL(updated_entity_code,'SR_HEADER') = 'SR_HEADER'
457: ORDER BY creation_date, incident_audit_id asc;

Line 686: from cs_incidents_audit_b

682:
683: l_request_id := l_create_audit_rec.incident_id;
684: --l_loop_counter := 0;
685: select count(incident_audit_id) into l_audit_count
686: from cs_incidents_audit_b
687: where incident_id= l_request_id
688: and NVL(upgrade_flag_for_create,'N') = 'N'
689: and NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER';
690:

Line 1366: Update cs_incidents_audit_b

1362: if (l_create_audit_rec.CLOSE_DATE > sysdate) then
1363: l_create_audit_rec.CLOSE_DATE := l_create_audit_rec.creation_date;
1364: end if;
1365:
1366: Update cs_incidents_audit_b
1367: set INCIDENT_STATUS_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_STATUS_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_STATUS_ID,l_create_audit_rec.INCIDENT_STATUS_ID),
1368: CHANGE_INCIDENT_STATUS_FLAG = decode(l_create_audit_rec.INCIDENT_STATUS_ID,NULL,'N','Y'),
1369: INCIDENT_TYPE_ID = decode(l_create_audit_rec.CHANGE_INCIDENT_TYPE_FLAG,'Y',l_create_audit_rec.OLD_INCIDENT_TYPE_ID,l_create_audit_rec.INCIDENT_TYPE_ID),
1370: CHANGE_INCIDENT_TYPE_FLAG = decode(l_create_audit_rec.INCIDENT_TYPE_ID,NULL,'N','Y'),

Line 2142: UPDATE cs_incidents_audit_b

2138: l_create_audit_rec.OLD_CLOSE_DATE = FND_API.G_MISS_DATE) then
2139: l_create_audit_rec.old_CLOSE_DATE := l_create_audit_rec.creation_date;
2140: end if;
2141:
2142: UPDATE cs_incidents_audit_b
2143: SET LAST_UPDATE_DATE = sysdate,
2144:
2145: INCIDENT_STATUS_ID = l_create_audit_rec.INCIDENT_STATUS_ID,
2146: OLD_INCIDENT_STATUS_ID = l_create_audit_rec.OLD_INCIDENT_STATUS_ID,