235: -- multi org changes
236: l_old_org_id NUMBER;
237: l_old_policy VARCHAR2(2);
238:
239: l_style_name po_doc_style_headers.style_name%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
236: l_old_org_id NUMBER;
237: l_old_policy VARCHAR2(2);
238:
239: l_style_name po_doc_style_headers.style_name%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
237: l_old_policy VARCHAR2(2);
238:
239: l_style_name po_doc_style_headers.style_name%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
238:
239: l_style_name po_doc_style_headers.style_name%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
239: l_style_name po_doc_style_headers.style_name%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
240: l_style_description po_doc_style_headers.style_description%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
241: l_style_type po_doc_style_headers.style_type%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
249: l_line_type_allowed po_doc_style_headers.line_type_allowed%TYPE;
242: l_status po_doc_style_headers.status%TYPE;
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
249: l_line_type_allowed po_doc_style_headers.line_type_allowed%TYPE;
250:
243: l_advances_flag po_doc_style_headers.advances_flag%TYPE;
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
249: l_line_type_allowed po_doc_style_headers.line_type_allowed%TYPE;
250:
251: BEGIN
244: l_retainage_flag po_doc_style_headers.retainage_flag%TYPE;
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
249: l_line_type_allowed po_doc_style_headers.line_type_allowed%TYPE;
250:
251: BEGIN
252:
245: l_price_breaks_flag po_doc_style_headers.price_breaks_flag%TYPE;
246: l_price_differentials_flag po_doc_style_headers.price_differentials_flag%TYPE;
247: l_progress_payment_flag po_doc_style_headers.progress_payment_flag%TYPE;
248: l_contract_financing_flag po_doc_style_headers.contract_financing_flag%TYPE;
249: l_line_type_allowed po_doc_style_headers.line_type_allowed%TYPE;
250:
251: BEGIN
252:
253: -- Set a savepoint, so that we can always rollback to it.