[Home] [Help]
199: l_msg_data VARCHAR2(4000);
200: l_msg_count NUMBER := 0;
201: l_return_status VARCHAR2(1);
202: l_lock_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
203: l_locked_models cz_security_pvt.number_type_tbl;
204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: --bug fix 8689041 Modified the criteria to retrieve last_logic_update and logic creation_date
207: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, max(proj.last_logic_update),max(head.creation_date)' ||
11181: FORALL i IN 1..NewHeaders.COUNT
11182: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11183: WHERE lce_header_id = NewHeaders(i);
11184:
11185: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11186:
11187: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11188: FOR jmessage IN 1..l_msg_count LOOP
11189: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11214: UPDATE cz_lce_load_specs SET deleted_flag = FLAG_NOT_DELETED
11215: WHERE lce_header_id = OldHeaders(i);
11216: END IF;
11217:
11218: cz_security_pvt.unlock_model(1.0, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11219:
11220: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11221: FOR jmessage IN 1..l_msg_count LOOP
11222: REPORT(fnd_msg_pub.get(jmessage, FND_API.G_FALSE), 0);
11447:
11448: BEGIN
11449:
11450: l_locked_models.DELETE;
11451: cz_security_pvt.lock_model(1.0, inDevlProjectId, FND_API.G_TRUE, FND_API.G_TRUE, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
11452:
11453: IF(l_lock_status <> FND_API.G_RET_STS_SUCCESS)THEN
11454: RAISE FAILED_TO_LOCK_MODEL;
11455: END IF;