APPS.PO_EMAIL_GENERATE dependencies on PO_UN_NUMBERS

Line 113: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;

109: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
110:
111: l_org_id NUMBER;
112: x_orgid NUMBER;
113: l_un_number PO_UN_NUMBERS.UN_NUMBER%TYPE;
114: l_hazard_class PO_HAZARD_CLASSES.HAZARD_CLASS%TYPE;
115: l_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
116:
117: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;

Line 1040: select un_number into l_un_number from po_un_numbers pun

1036: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''');
1037:
1038: if (l_line_loc.un_number_id is not null) then
1039: begin
1040: select un_number into l_un_number from po_un_numbers pun
1041: where pun.un_number_id = l_line_loc.un_number_id;
1042: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
1043: /* Bug 2774206 */
1044: exception

Line 2142: select un_number into l_un_number from po_un_numbers pun

2138: l_date := to_char(nvl(l_line_loc.need_by_date, l_line_loc.promised_date),FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2139: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) , 'GREGORIAN' ) || '''');
2140:
2141: if (l_line_loc.un_number_id is not null) then
2142: select un_number into l_un_number from po_un_numbers pun
2143: where pun.un_number_id = l_line_loc.un_number_id;
2144: /* Bug 2774206 */
2145: /* l_un_number := fnd_message.get_string('PO', 'PO_WF_NOTIF_UN_NUMBER') || ' ' || l_un_number; */
2146: end if;