APPS.PO_EMAIL_GENERATE dependencies on PO_LINES_PRINT

Line 102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;

98: l_blanket_total_amount NUMBER := 0;
99: x_subtype po_headers.type_lookup_code%TYPE;
100: l_datatype_count NUMBER := 0;
101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%TYPE;
105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:

Line 103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;

99: x_subtype po_headers.type_lookup_code%TYPE;
100: l_datatype_count NUMBER := 0;
101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%TYPE;
105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
106:
107: l_org_id NUMBER;

Line 105: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI

101:
102: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
103: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
104: l_po_header_id po_headers.po_header_id%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;

Line 1158: from po_lines_print

1154: begin
1155: if (l_document_type in ('PO', 'PA')) then
1156:
1157: select vendor_quote_num into l_vendor_quote_num
1158: from po_lines_print
1159: where po_line_id = l_line_loc.po_line_id
1160: and po_header_id = l_document_id;
1161:
1162: elsif (l_document_type = 'RELEASE') then

Line 1164: from po_lines_print

1160: and po_header_id = l_document_id;
1161:
1162: elsif (l_document_type = 'RELEASE') then
1163: select vendor_quote_num into l_vendor_quote_num
1164: from po_lines_print
1165: where po_line_id = l_line_loc.po_line_id
1166: and po_release_id = l_document_id;
1167:
1168: else

Line 1187: from po_lines_print

1183: if (l_document_type in ('PO', 'PA')) then
1184:
1185: select po_quote_num, src_ga_flag
1186: into l_po_quote_num, l_src_ga_flag
1187: from po_lines_print
1188: where po_line_id = l_line_loc.po_line_id
1189: and po_header_id = l_document_id;
1190:
1191: elsif (l_document_type = 'RELEASE') then

Line 1194: from po_lines_print

1190:
1191: elsif (l_document_type = 'RELEASE') then
1192:
1193: select po_quote_num into l_po_quote_num
1194: from po_lines_print
1195: where po_line_id = l_line_loc.po_line_id
1196: and po_release_id = l_document_id;
1197: else
1198:

Line 2156: from po_lines_print

2152: end if;
2153:
2154:
2155: select vendor_quote_num into l_vendor_quote_num
2156: from po_lines_print
2157: where po_line_id = l_line_loc.po_line_id;
2158:
2159: if (l_vendor_quote_num is not null) then
2160: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;

Line 2165: from po_lines_print

2161: end if;
2162:
2163:
2164: select po_quote_num into l_po_quote_num
2165: from po_lines_print
2166: where po_line_id = l_line_loc.po_line_id;
2167:
2168: if (l_po_quote_num is not null) then
2169: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;