APPS.CZ_IB_TSO_GRP dependencies on CZ_CONFIG_ITEMS

Line 160: FROM CZ_CONFIG_ITEMS

156: --
157: BEGIN
158: SELECT config_hdr_id,config_rev_nbr,NVL(returned_flag, '0'), NVL(tangible_item_flag,'0')
159: INTO l_config_hdr_id,l_config_rev_nbr,l_returned_flag, l_tangible_item_flag
160: FROM CZ_CONFIG_ITEMS
161: WHERE instance_hdr_id=p_instance_hdr_id AND
162: instance_rev_nbr=p_instance_rev_nbr AND
163: config_item_id=p_returned_config_item_id AND
164: deleted_flag='0';

Line 223: SELECT NVL(returned_flag, '0') INTO l_locked_item_returned_flag FROM CZ_CONFIG_ITEMS

219: -- and validate parameters p_instance_hdr_id/ p_locked_instance_rev_nbr/ p_returned_config_item_id
220: --
221: IF p_locked_instance_rev_nbr IS NOT NULL OR p_locked_instance_rev_nbr<>0 THEN
222: BEGIN
223: SELECT NVL(returned_flag, '0') INTO l_locked_item_returned_flag FROM CZ_CONFIG_ITEMS
224: WHERE instance_hdr_id=p_instance_hdr_id AND
225: instance_rev_nbr=p_locked_instance_rev_nbr AND
226: config_item_id=p_returned_config_item_id AND
227: deleted_flag='0';

Line 261: UPDATE CZ_CONFIG_ITEMS

257: IF ( l_returned_flag='0' ) THEN
258: --
259: -- set returned_flag to 1 for config_item corresponding to the returned tangible item
260: --
261: UPDATE CZ_CONFIG_ITEMS
262: SET returned_flag = '1'
263: WHERE instance_hdr_id=p_instance_hdr_id AND
264: instance_rev_nbr=p_instance_rev_nbr AND
265: config_item_id=p_returned_config_item_id AND

Line 276: UPDATE CZ_CONFIG_ITEMS

272: l_locked_item_returned_flag='0' THEN
273: --
274: -- set returned_flag to 1 for config_item corresponding to the pending order
275: --
276: UPDATE CZ_CONFIG_ITEMS
277: SET returned_flag = '1'
278: WHERE instance_hdr_id=p_instance_hdr_id AND
279: instance_rev_nbr= p_locked_instance_rev_nbr AND
280: config_item_id=p_returned_config_item_id AND

Line 357: UPDATE CZ_CONFIG_ITEMS

353: END;
354:
355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356:
357: UPDATE CZ_CONFIG_ITEMS
358: SET returned_flag = l_returned_flag
359: WHERE instance_hdr_id=p_instance_hdr_id AND
360: instance_rev_nbr= p_instance_rev_nbr AND
361: config_item_id=p_returned_config_item_id AND

Line 364: UPDATE CZ_CONFIG_ITEMS

360: instance_rev_nbr= p_instance_rev_nbr AND
361: config_item_id=p_returned_config_item_id AND
362: NVL(returned_flag, '0') <> l_returned_flag;
363:
364: UPDATE CZ_CONFIG_ITEMS
365: SET returned_flag = l_locked_item_returned_flag
366: WHERE instance_hdr_id=p_instance_hdr_id AND
367: instance_rev_nbr= p_locked_instance_rev_nbr AND
368: config_item_id=p_returned_config_item_id AND