APPS.POR_AMENDMENT_PKG dependencies on POR_ITEM_ATTRIBUTE_VALUES

Line 3329: DELETE FROM por_item_attribute_values

3325: END IF;
3326:
3327: /* Merging one time location - start */
3328:
3329: DELETE FROM por_item_attribute_values
3330: WHERE requisition_line_id = p_to_line_id;
3331:
3332: v_progress := '002';
3333:

Line 3334: INSERT INTO por_item_attribute_values(

3330: WHERE requisition_line_id = p_to_line_id;
3331:
3332: v_progress := '002';
3333:
3334: INSERT INTO por_item_attribute_values(
3335: item_type,
3336: requisition_header_id,
3337: requisition_line_id,
3338: attribute1,

Line 3383: FROM por_item_attribute_values piav

3379: piav.creation_date,
3380: piav.last_updated_by,
3381: piav.last_update_date,
3382: piav.last_update_login
3383: FROM por_item_attribute_values piav
3384: WHERE piav.requisition_line_id = p_from_line_id;
3385:
3386: v_progress := '003';
3387:

Line 4638: INSERT INTO por_item_attribute_values (

4634:
4635: /* Copying One Time location */
4636: v_progress := '004';
4637:
4638: INSERT INTO por_item_attribute_values (
4639: item_type,
4640: requisition_header_id,
4641: requisition_line_id,
4642: attribute1,

Line 4688: FROM por_item_attribute_values

4684: creation_date,
4685: last_updated_by,
4686: last_update_date,
4687: last_update_login
4688: FROM por_item_attribute_values
4689: WHERE requisition_header_id = p_from_req_header_id
4690: AND requisition_line_id = from_req_line_id
4691: AND item_type = 'AD_HOC_LOCATION';
4692: