APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_ITEM_PROPERTY_VALUES

Line 4519: UPDATE cz_item_property_values

4515:
4516: IF (l_item_id_tbl.COUNT > 0) THEN
4517:
4518: FORALL i IN l_item_id_tbl.FIRST..l_item_id_tbl.LAST
4519: UPDATE cz_item_property_values
4520: SET deleted_flag = '1'
4521: WHERE item_id = l_item_id_tbl(i);
4522:
4523: END IF;

Line 12104: /*Bug-9788241: New API to populate the table cz_item_property_values table as

12100: LOG_REPORT( -1, 'Exception in end_model_report :' || SQLERRM );
12101: END end_model_report;
12102:
12103:
12104: /*Bug-9788241: New API to populate the table cz_item_property_values table as
12105: * required by SUN (Oracle) to directly insert/update the table.
12106: * p_property_value will be always passed as char and will be populated in
12107: *respective column as per the data_type of the property.
12108: */

Line 12167: -- check if cz_item_property_values exists, if not, then insert it.

12163: NULL;
12164: END;
12165: END IF;
12166:
12167: -- check if cz_item_property_values exists, if not, then insert it.
12168: -- Not expecting item_type for this item is deleted.
12169: BEGIN
12170: SELECT item_type_id INTO l_item_type_exists FROM cz_item_type_properties
12171: WHERE item_type_id=l_item_type_id

Line 12187: FROM cz_item_property_values

12183: -- Create the record in cz_item_property_value when not exists using decode in
12184: -- the appropriate columns value
12185: BEGIN
12186: SELECT item_id INTO l_data_exists
12187: FROM cz_item_property_values
12188: WHERE item_id = p_item_id
12189: AND property_id = p_property_id;
12190:
12191: EXCEPTION

Line 12193: INSERT INTO cz_item_property_values(property_id, item_id, deleted_flag, checkout_user, property_value, property_num_value)

12189: AND property_id = p_property_id;
12190:
12191: EXCEPTION
12192: WHEN NO_DATA_FOUND THEN
12193: INSERT INTO cz_item_property_values(property_id, item_id, deleted_flag, checkout_user, property_value, property_num_value)
12194: VALUES(p_property_id, p_item_id, '0','API CREATED', DECODE(l_data_type,4,p_property_value,NULL),
12195: DECODE(l_data_type,1,p_property_value,2,p_property_value,3,p_property_value,NULL));
12196: WHEN OTHERS THEN
12197: x_return_status := 'F';

Line 12208: UPDATE cz_item_property_values

12204: -- No check for update deleted property values as well for simplicity
12205:
12206: IF (l_data_exists IS NOT NULL) THEN
12207:
12208: UPDATE cz_item_property_values
12209: SET property_value = DECODE(l_data_type,4,p_property_value, NULL),
12210: property_num_value = DECODE(l_data_type,1,p_property_value,2,p_property_value,3,p_property_value,NULL)
12211: WHERE item_id = p_item_id
12212: AND property_id = p_property_id