[Home] [Help]
201:
202: if (nvl(X_WEB_ENTRY_FLAG,'N') = 'N') then
203: for c_type_agent_rec IN c_type_agent_csr
204: loop
205: insert into cs_sr_type_mapping
206: (
207: INCIDENT_TYPE_ID,
208: RESPONSIBILITY_ID,
209: APPLICATION_ID,
236: end loop;
237: elsif (nvl(X_WEB_ENTRY_FLAG,'N') = 'Y') THEN
238: for c_type_resp_rec IN c_type_resp_csr
239: loop
240: insert into cs_sr_type_mapping
241: (
242: INCIDENT_TYPE_ID,
243: RESPONSIBILITY_ID,
244: APPLICATION_ID,
493: ==
494: == Date Name Desc
495: == ---------- --------- ---------------------------------------------
496: == 12-Jan-2006 PRAYADUR FP Bug 4916688 Added a sql query to check whether
497: == the record already exists in cs_sr_type_mapping or not,
498: == if not then inserting the record else updating the table.
499: ========================================================================*/
500:
501:
634: then
635: for c1_rec IN c_create_map_csr
636: loop
637:
638: SELECT count(*) into mapping_exist FROM cs_sr_type_mapping
639: WHERE INCIDENT_TYPE_ID=X_INCIDENT_TYPE_ID and RESPONSIBILITY_ID=c1_rec.responsibility_id
640: and APPLICATION_ID=c1_rec.application_id;
641:
642: if mapping_exist=0 then
639: WHERE INCIDENT_TYPE_ID=X_INCIDENT_TYPE_ID and RESPONSIBILITY_ID=c1_rec.responsibility_id
640: and APPLICATION_ID=c1_rec.application_id;
641:
642: if mapping_exist=0 then
643: insert into cs_sr_type_mapping
644: (
645: INCIDENT_TYPE_ID,
646: RESPONSIBILITY_ID,
647: APPLICATION_ID,
672: 1
673: );
674: else
675:
676: update cs_sr_type_mapping
677: set
678: START_DATE=SYSDATE,LAST_UPDATED_BY=X_LAST_UPDATED_BY,
679: LAST_UPDATE_DATE=SYSDATE,LAST_UPDATE_LOGIN=X_LAST_UPDATE_LOGIN,
680: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
690: nvl(X_WEB_ENTRY_FLAG,'N') = 'N')
691: then
692: for c1_rec IN c_create_map_csr
693: loop
694: UPDATE cs_sr_type_mapping cst
695: SET end_date = sysdate
696: WHERE cst.incident_type_id = X_INCIDENT_TYPE_ID
697: AND cst.responsibility_id = c1_rec.responsibility_id;
698: end loop;