APPS.GR_ITEM_PROPERTIES_PUB dependencies on GR_INV_ITEM_PROPERTIES

Line 738: -- With the exception of those values listed above, all other records will be inserted into the GR_INV_ITEM_PROPERTIES table.

734: fnd_global.user_id,
735: sysdate,
736: l_last_update_login);
737:
738: -- With the exception of those values listed above, all other records will be inserted into the GR_INV_ITEM_PROPERTIES table.
739: -- An error message will be written to the log file if the record already exists
740:
741: ELSE
742:

Line 758: GR_INV_ITEM_PROPERTIES_PKG.Insert_Row (

754: END IF;
755: CLOSE Cur_get_seq_no;
756: END IF; -- IF l_property_id is not null then
757:
758: GR_INV_ITEM_PROPERTIES_PKG.Insert_Row (
759: p_commit => p_commit,
760: p_called_by_form => 'F',
761: p_organization_id => l_organization_id,
762: p_inventory_item_id => l_inventory_item_id,

Line 806: update gr_inv_item_properties

802: ELSIF l_action = 'U' then
803:
804: IF l_property_type_indicator not in ('S','R','P') then
805:
806: update gr_inv_item_properties
807: set number_value = l_numeric_value ,
808: alpha_value = l_alpha_value,
809: date_value = l_date_value,
810: last_updated_by = fnd_global.user_id,

Line 907: -- With the exception of those values listed above, all other records will be deleted from the GR_INV_ITEM_PROPERTIES table.

903: l_msg_token := l_organization_id || ' ' || l_inventory_item_id || ' ' || l_phrase_code;
904: RAISE loop_exception;
905: END IF;
906:
907: -- With the exception of those values listed above, all other records will be deleted from the GR_INV_ITEM_PROPERTIES table.
908: -- An error message will be written to the log file if the record does not exist
909:
910:
911: ELSE

Line 913: GR_INV_ITEM_PROPERTIES_PKG.delete_Rows

909:
910:
911: ELSE
912:
913: GR_INV_ITEM_PROPERTIES_PKG.delete_Rows
914: (p_commit => p_commit,
915: p_called_by_form => 'F',
916: p_delete_option => 'B', -- 'B' Delete all rows using the item and label combination.
917: p_organization_id => l_organization_id,