APPS.PO_EMAIL_GENERATE dependencies on PO_UN_NUMBERS

Line 109: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;

105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:
107: l_org_id NUMBER;
108: x_orgid NUMBER;
109: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;
110: l_hazard_class PO_HAZARD_CLASSES.HAZARD_CLASS%TYPE;
111: l_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
112:
113: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;

Line 891: select un_number into l_un_number from po_un_numbers pun

887: l_needby_date := to_char(l_line_loc.need_by_date);
888:
889: if (l_line_loc.un_number_id is not null) then
890: begin
891: select un_number into l_un_number from po_un_numbers pun
892: where pun.un_number_id = l_line_loc.un_number_id;
893: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
894: /* Bug 2774206 */
895: exception

Line 1941: select un_number into l_un_number from po_un_numbers pun

1937:
1938: l_date := to_char(nvl(l_line_loc.need_by_date, l_line_loc.promised_date));
1939:
1940: if (l_line_loc.un_number_id is not null) then
1941: select un_number into l_un_number from po_un_numbers pun
1942: where pun.un_number_id = l_line_loc.un_number_id;
1943: /* Bug 2774206 */
1944: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
1945: end if;