50: taxable_flag po_line_locations.taxable_flag%TYPE,
51: note_to_vendor po_lines_all.note_to_vendor%TYPE,
52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
51: note_to_vendor po_lines_all.note_to_vendor%TYPE,
52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /*
64: end_date po_line_locations_all.end_date%TYPE, /*
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /*
64: end_date po_line_locations_all.end_date%TYPE, /*
65: --
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
64: end_date po_line_locations_all.end_date%TYPE, /*
65: --
66: from_header_id po_lines_all.from_header_id%type,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /*
65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /*
64: end_date po_line_locations_all.end_date%TYPE, /*
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
68: --
65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
68: --
69: drop_ship_flag po_line_locations_all.drop_ship_flag%TYPE --Bug 9356725
70: );
71:
72:
73: procedure generate_html (document_id in varchar2,
121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131: