APPS.PO_EMAIL_GENERATE dependencies on PO_LINES_PRINT

Line 106: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;

102: l_blanket_total_amount NUMBER := 0;
103: x_subtype po_headers.type_lookup_code%TYPE;
104: l_datatype_count NUMBER := 0;
105:
106: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
107: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
108: l_po_header_id po_headers.po_header_id%TYPE;
109: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
110:

Line 107: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;

103: x_subtype po_headers.type_lookup_code%TYPE;
104: l_datatype_count NUMBER := 0;
105:
106: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
107: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
108: l_po_header_id po_headers.po_header_id%TYPE;
109: l_src_ga_flag po_lines_print.SRC_GA_FLAG%TYPE; -- GA FPI
110:
111: l_org_id NUMBER;

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

105:
106: l_vendor_quote_num po_lines_print.VENDOR_QUOTE_NUM%TYPE;
107: l_po_quote_num po_lines_print.PO_QUOTE_NUM%TYPE;
108: l_po_header_id po_headers.po_header_id%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;

Line 1307: from po_lines_print

1303: begin
1304: if (l_document_type in ('PO', 'PA')) then
1305:
1306: select vendor_quote_num into l_vendor_quote_num
1307: from po_lines_print
1308: where po_line_id = l_line_loc.po_line_id
1309: and po_header_id = l_document_id;
1310:
1311: elsif (l_document_type = 'RELEASE') then

Line 1313: from po_lines_print

1309: and po_header_id = l_document_id;
1310:
1311: elsif (l_document_type = 'RELEASE') then
1312: select vendor_quote_num into l_vendor_quote_num
1313: from po_lines_print
1314: where po_line_id = l_line_loc.po_line_id
1315: and po_release_id = l_document_id;
1316:
1317: else

Line 1336: from po_lines_print

1332: if (l_document_type in ('PO', 'PA')) then
1333:
1334: select po_quote_num, src_ga_flag
1335: into l_po_quote_num, l_src_ga_flag
1336: from po_lines_print
1337: where po_line_id = l_line_loc.po_line_id
1338: and po_header_id = l_document_id;
1339:
1340: elsif (l_document_type = 'RELEASE') then

Line 1343: from po_lines_print

1339:
1340: elsif (l_document_type = 'RELEASE') then
1341:
1342: select po_quote_num into l_po_quote_num
1343: from po_lines_print
1344: where po_line_id = l_line_loc.po_line_id
1345: and po_release_id = l_document_id;
1346: else
1347:

Line 2359: from po_lines_print

2355: end if;
2356:
2357:
2358: select vendor_quote_num into l_vendor_quote_num
2359: from po_lines_print
2360: where po_line_id = l_line_loc.po_line_id;
2361:
2362: if (l_vendor_quote_num is not null) then
2363: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_VENDOR_QUOTE') || ' ' || l_vendor_quote_num || NL;

Line 2368: from po_lines_print

2364: end if;
2365:
2366:
2367: select po_quote_num into l_po_quote_num
2368: from po_lines_print
2369: where po_line_id = l_line_loc.po_line_id;
2370:
2371: if (l_po_quote_num is not null) then
2372: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_QUOTE') || ' ' || l_po_quote_num || NL;