APPS.GR_ITEM_SAFETY dependencies on GR_INV_ITEM_PROPERTIES

Line 60: FROM gr_inv_item_properties ip

56: ip.creation_date,
57: ip.last_updated_by,
58: ip.last_update_date,
59: ip.last_update_login
60: FROM gr_inv_item_properties ip
61: WHERE ip.organization_id = p_organization_id
62: AND ip.inventory_item_id = p_inventory_item_id
63: AND ip.label_code = p_label_code
64: AND ip.property_id = PropRecord.property_id;

Line 243: FROM gr_inv_item_properties ip

239: ip.label_code,
240: ip.number_value,
241: ip.alpha_value,
242: ip.date_value
243: FROM gr_inv_item_properties ip
244: WHERE ip.organization_id = p_organization_id
245: AND ip.inventory_item_id = p_copy_from_item;
246: LocalItemPropRecord c_get_item_properties%ROWTYPE;
247:

Line 254: FROM gr_inv_item_properties ip

250: */
251: CURSOR c_get_item_properties_rowid (V_label_code VARCHAR2, V_property_id VARCHAR2, V_sequence_number NUMBER)
252: IS
253: SELECT ip.rowid
254: FROM gr_inv_item_properties ip
255: WHERE ip.organization_id = p_organization_id
256: AND ip.inventory_item_id = p_paste_to_item
257: AND ip.label_code = V_label_code
258: AND ip.property_id = V_property_id

Line 398: l_code_block := ' table - gr_inv_item_properties ';

394: OPEN c_get_item_properties;
395: FETCH c_get_item_properties INTO LocalItemPropRecord;
396: IF c_get_item_properties%FOUND THEN
397: WHILE c_get_item_properties%FOUND LOOP
398: l_code_block := ' table - gr_inv_item_properties ';
399: l_return_status := FND_API.G_RET_STS_SUCCESS;
400: /*B1319565 Added for Technical Parameters */
401:
402: OPEN c_get_item_properties_rowid (LocalItemPropRecord.label_code,

Line 407: l_code_block := ' Insert table - gr_inv_item_properties ';

403: LocalItemPropRecord.property_id,
404: LocalItemPropRecord.sequence_number);
405: FETCH c_get_item_properties_rowid INTO LocalPItemPropRecord;
406: IF c_get_item_properties_rowid%NOTFOUND THEN
407: l_code_block := ' Insert table - gr_inv_item_properties ';
408: GR_INV_ITEM_PROPERTIES_PKG.Insert_Row
409: (l_commit,
410: l_called_by_form,
411: p_organization_id,

Line 408: GR_INV_ITEM_PROPERTIES_PKG.Insert_Row

404: LocalItemPropRecord.sequence_number);
405: FETCH c_get_item_properties_rowid INTO LocalPItemPropRecord;
406: IF c_get_item_properties_rowid%NOTFOUND THEN
407: l_code_block := ' Insert table - gr_inv_item_properties ';
408: GR_INV_ITEM_PROPERTIES_PKG.Insert_Row
409: (l_commit,
410: l_called_by_form,
411: p_organization_id,
412: p_paste_to_item,

Line 433: l_code_block := ' Update table - gr_inv_item_properties ';

429: IF l_return_status <> 'S' THEN
430: RAISE Insert_Rows_Error;
431: END IF;
432: ELSE
433: l_code_block := ' Update table - gr_inv_item_properties ';
434: GR_INV_ITEM_PROPERTIES_PKG.Update_Row
435: (l_commit,
436: l_called_by_form,
437: LocalPItemPropRecord.rowid,

Line 434: GR_INV_ITEM_PROPERTIES_PKG.Update_Row

430: RAISE Insert_Rows_Error;
431: END IF;
432: ELSE
433: l_code_block := ' Update table - gr_inv_item_properties ';
434: GR_INV_ITEM_PROPERTIES_PKG.Update_Row
435: (l_commit,
436: l_called_by_form,
437: LocalPItemPropRecord.rowid,
438: p_organization_id,