DBA Data[Home] [Help]

APPS.PO_REQUISITION_LINES_PKG2 dependencies on PO_ATTRIBUTE_VALUES

Line 140: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;

136: x_progress VARCHAR2(3) := NULL;
137: x_return_status VARCHAR2(1);
138:
139: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
140: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
141: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
142: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
143:
144: BEGIN

Line 141: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;

137: x_return_status VARCHAR2(1);
138:
139: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
140: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
141: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
142: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
143:
144: BEGIN
145: if (X_Requisition_Line_Id is NULL) then

Line 142: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;

138:
139: l_manufacturer_id po_requisition_lines_All.MANUFACTURER_ID%TYPE;
140: l_manufacturer_name PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE;
141: l_manufacturer_pn PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE;
142: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
143:
144: BEGIN
145: if (X_Requisition_Line_Id is NULL) then
146: OPEN C2;

Line 191: po_attribute_values_pvt.get_item_attributes_values(X_Item_Id, l_manufacturer_pn,l_manufacturer_name,

187: END;
188: -- End
189:
190: IF (x_item_id IS NOT NULL) Then
191: po_attribute_values_pvt.get_item_attributes_values(X_Item_Id, l_manufacturer_pn,l_manufacturer_name,
192: l_lead_time,l_manufacturer_id) ;
193:
194: END IF ;
195: