DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on POR_ITEM_ATTRIBUTE_VALUES

Line 119: DELETE FROM por_item_attribute_values

115: l_progress := '060';
116:
117: -- delete the one time locations
118: FORALL idx IN 1..l_line_ids.COUNT
119: DELETE FROM por_item_attribute_values
120: WHERE requisition_line_id = l_line_ids(idx);
121:
122: l_progress := '070';
123:

Line 1265: UPDATE por_item_attribute_values

1261: /*Bug#5982685-- Requisition header_id also needs to be flipped
1262: for One-Time Location*/
1263: -- flip the one time locations
1264: FORALL idx IN 1..p_tempLineIds.COUNT
1265: UPDATE por_item_attribute_values
1266: SET requisition_line_id = p_origLineIds(idx),
1267: requisition_header_id = p_origHeaderId
1268: WHERE requisition_line_id = p_tempLineIds(idx);
1269: