DBA Data[Home] [Help]

APPS.PO_CREATE_REQUISITION_SV dependencies on PO_ATTRIBUTE_VALUES

Line 653: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;

649: d_chart_of_accounts_id NUMBER; /* bug 5637277 - Please refer the bug for the details */
650:
651:
652: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
653: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
654: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
655: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
656:
657:

Line 654: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;

650:
651:
652: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
653: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
654: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
655: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
656:
657:
658:

Line 655: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;

651:
652: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
653: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
654: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
655: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
656:
657:
658:
659: -- bug5176308

Line 1122: po_attribute_values_pvt.get_item_attributes_values(l_line_tbl(i).item_id, l_manufacturer_pn,l_manufacturer_name,

1118:
1119: IF (l_line_tbl(i).item_id IS NOT NULL) Then
1120:
1121:
1122: po_attribute_values_pvt.get_item_attributes_values(l_line_tbl(i).item_id, l_manufacturer_pn,l_manufacturer_name,
1123: l_lead_time,l_manufacturer_id) ;
1124:
1125: END IF ;
1126: