The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y' INTO x_return_status
FROM PO_HEADERS_ARCHIVE_ALL PHA,
PO_DRAFTS PD
WHERE pha.po_header_id = p_document_id
AND pha.revision_num = p_revision_num
AND pd.document_id = pha.po_header_id (+)
AND pd.draft_id = p_draft_id; --Always passed as 0 for Revision 0 Documents
PROCEDURE DELETE_DUMMY_DATA_FROM_DRAFT(p_draft_id IN NUMBER)
IS
d_api_name CONSTANT VARCHAR2(30) := 'DELETE_DUMMY_DATA_FROM_DRAFT';
PO_LOG.proc_begin(d_module,'Delete all entries from DRAFT Tables having draft_id: ',p_draft_id);
DELETE FROM po_drafts
WHERE draft_id = p_draft_id;
DELETE FROM po_headers_draft_all
WHERE draft_id = p_draft_id;
DELETE FROM po_lines_draft_all
WHERE draft_id = p_draft_id;
DELETE FROM po_line_locations_draft_all
WHERE draft_id = p_draft_id;
DELETE FROM po_distributions_draft_all
WHERE draft_id = p_draft_id;
DELETE FROM po_headers_all_ext_b
WHERE draft_id = p_draft_id;
DELETE FROM po_lines_all_ext_b
WHERE draft_id = p_draft_id;
DELETE FROM po_line_locations_all_ext_b
WHERE draft_id = p_draft_id;
DELETE FROM po_headers_all_ext_tl
WHERE draft_id = p_draft_id;
DELETE FROM po_lines_all_ext_tl
WHERE draft_id = p_draft_id;
DELETE FROM po_line_locations_all_ext_tl
WHERE draft_id = p_draft_id;
DELETE FROM po_ga_org_assign_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_attribute_values_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_attribute_values_tlp_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_price_diff_draft
WHERE entity_type in ('PO LINE','BLANKET LINE','PRICE BREAK')
AND draft_id = p_draft_id;
DELETE FROM po_price_adjustments_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_price_adj_attribs_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_notification_ctrl_draft
WHERE draft_id = p_draft_id;
DELETE FROM po_exhibit_details_draft
WHERE draft_id = p_draft_id;
PO_LOG.stmt(d_module, d_position, 'Rows deleted from DRAFT Tables');
END DELETE_DUMMY_DATA_FROM_DRAFT;
PO_LOG.stmt(d_module, d_position, 'Insert Dummy row in PO_DRAFTS with DRAFT_ID = 0');
INSERT INTO po_drafts
(draft_id,
document_id,
owner_user_id,
owner_role,
status,
draft_type,
last_update_date,
last_updated_by,
last_update_login,
creation_date,
created_by
)
VALUES
( p_draft_id, -- Always 0 for action View Base Document (Revision 0)
p_document_id,
FND_GLOBAL.user_id,
'BUYER',
'COMPLETED',
'ARCHIVE',
SYSDATE,
FND_GLOBAL.user_id,
FND_GLOBAL.login_id,
SYSDATE,
FND_GLOBAL.user_id
);
PO_LOG.stmt(d_module, d_position, 'Row inserted into PO_DRAFTS');
INSERT INTO po_headers_draft_all
( draft_id,
delete_flag,
change_accepted_flag,
change_status,
po_header_id,
agent_id,
type_lookup_code,
last_update_date,
last_updated_by,
segment1,
summary_flag,
enabled_flag,
segment2,
segment3,
segment4,
segment5,
start_date_active,
end_date_active,
last_update_login,
creation_date,
created_by,
vendor_id,
vendor_site_id,
vendor_contact_id,
ship_to_location_id,
bill_to_location_id,
terms_id,
ship_via_lookup_code,
fob_lookup_code,
freight_terms_lookup_code,
status_lookup_code,
currency_code,
rate_type,
rate_date,
rate,
from_header_id,
from_type_lookup_code,
start_date,
end_date,
blanket_total_amount,
authorization_status,
revision_num,
revised_date,
approved_flag,
approved_date,
amount_limit,
min_release_amount,
note_to_authorizer,
note_to_vendor,
note_to_receiver,
print_count,
printed_date,
vendor_order_num,
confirming_order_flag,
comments,
reply_date,
reply_method_lookup_code,
rfq_close_date,
quote_type_lookup_code,
quotation_class_code,
quote_warning_delay_unit,
quote_warning_delay,
quote_vendor_quote_number,
acceptance_required_flag,
acceptance_due_date,
closed_date,
user_hold_flag,
approval_required_flag,
cancel_flag,
firm_status_lookup_code,
firm_date,
frozen_flag,
supply_agreement_flag,
edi_processed_flag,
edi_processed_status,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
closed_code,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
program_update_date,
org_id,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
interface_source_code,
reference_num,
wf_item_type,
wf_item_key,
mrc_rate_type,
mrc_rate_date,
mrc_rate,
pcard_id,
price_update_tolerance,
pay_on_code,
xml_flag,
xml_send_date,
xml_change_send_date,
global_agreement_flag,
consigned_consumption_flag,
cbc_accounting_date,
consume_req_demand_flag,
change_requested_by,
shipping_control,
conterms_exist_flag,
conterms_articles_upd_date,
conterms_deliv_upd_date,
encumbrance_required_flag,
pending_signature_flag,
change_summary,
document_creation_method,
submit_date,
supplier_notif_method,
fax,
email_address,
retro_price_comm_updates_flag,
retro_price_apply_updates_flag,
update_sourcing_rules_flag,
auto_sourcing_flag,
created_language,
cpa_reference,
style_id,
tax_attribute_update_code, --
supplier_auth_enabled_flag, -- bug5022835
cat_admin_auth_enabled_flag, -- bug5022835
pay_when_paid, -- E and C ER
uda_template_id,
uda_template_date,
clm_effective_date,
clm_vendor_offer_number,
clm_award_administrator,
clm_no_signed_copies_to_return,
clm_min_guarantee_award_amt,
clm_min_guar_award_amt_percent,
clm_min_order_amount,
clm_max_order_amount,
clm_amt_synced_to_agreement,
clm_amount_released,
clm_external_idv,
clm_supplier_name,
clm_supplier_site_name,
clm_document_number,
clm_source_document_id,
clm_issuing_office,
clm_cotr_office,
clm_cotr_contact,
clm_priority_code,
clm_standard_form,
clm_document_format,
clm_mod_issuing_office,
ame_approval_id,
ame_transaction_type,
clm_award_type,
clm_contract_officer,
umbrella_program_id,
fon_ref_id,
clm_contract_finance_code, --
clm_special_contract_type, --
clm_payment_instr_code --
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
po_header_id,
agent_id,
type_lookup_code,
last_update_date,
last_updated_by,
segment1,
summary_flag,
enabled_flag,
segment2,
segment3,
segment4,
segment5,
start_date_active,
end_date_active,
last_update_login,
creation_date,
created_by,
vendor_id,
vendor_site_id,
vendor_contact_id,
ship_to_location_id,
bill_to_location_id,
terms_id,
ship_via_lookup_code,
fob_lookup_code,
freight_terms_lookup_code,
status_lookup_code,
currency_code,
rate_type,
rate_date,
rate,
from_header_id,
from_type_lookup_code,
start_date,
end_date,
blanket_total_amount,
authorization_status,
revision_num,
revised_date,
approved_flag,
approved_date,
amount_limit,
min_release_amount,
note_to_authorizer,
note_to_vendor,
note_to_receiver,
print_count,
printed_date,
vendor_order_num,
confirming_order_flag,
comments,
reply_date,
reply_method_lookup_code,
rfq_close_date,
quote_type_lookup_code,
quotation_class_code,
quote_warning_delay_unit,
quote_warning_delay,
quote_vendor_quote_number,
acceptance_required_flag,
acceptance_due_date,
closed_date,
user_hold_flag,
approval_required_flag,
cancel_flag,
firm_status_lookup_code,
firm_date,
frozen_flag,
supply_agreement_flag,
edi_processed_flag,
edi_processed_status,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
closed_code,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
program_update_date,
org_id,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
interface_source_code,
reference_num,
wf_item_type,
wf_item_key,
mrc_rate_type,
mrc_rate_date,
mrc_rate,
pcard_id,
price_update_tolerance,
pay_on_code,
xml_flag,
xml_send_date,
xml_change_send_date,
global_agreement_flag,
consigned_consumption_flag,
cbc_accounting_date,
consume_req_demand_flag,
change_requested_by,
shipping_control,
conterms_exist_flag,
conterms_articles_upd_date,
conterms_deliv_upd_date,
encumbrance_required_flag,
pending_signature_flag,
change_summary,
document_creation_method,
submit_date,
supplier_notif_method,
fax,
email_address,
retro_price_comm_updates_flag,
retro_price_apply_updates_flag,
update_sourcing_rules_flag,
auto_sourcing_flag,
created_language,
cpa_reference,
style_id,
tax_attribute_update_code, --
supplier_auth_enabled_flag, -- bug5022835
cat_admin_auth_enabled_flag, -- bug5022835
pay_when_paid, -- E and C ER
uda_template_id,
uda_template_date,
clm_effective_date,
clm_vendor_offer_number,
clm_award_administrator,
clm_no_signed_copies_to_return,
clm_min_guarantee_award_amt,
clm_min_guar_award_amt_percent,
clm_min_order_amount,
clm_max_order_amount,
clm_amt_synced_to_agreement,
clm_amount_released,
clm_external_idv,
clm_supplier_name,
clm_supplier_site_name,
clm_document_number,
clm_source_document_id,
clm_issuing_office,
clm_cotr_office,
clm_cotr_contact,
clm_priority_code,
clm_standard_form,
clm_document_format,
clm_mod_issuing_office,
ame_approval_id,
ame_transaction_type,
clm_award_type,
clm_contract_officer,
umbrella_program_id,
fon_ref_id,
clm_contract_finance_code, --
clm_special_contract_type, --
clm_payment_instr_code --
FROM po_headers_archive_all
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
INSERT INTO po_lines_draft_all
(
draft_id,
delete_flag,
change_accepted_flag,
change_status,
po_line_id,
last_update_date,
last_updated_by,
po_header_id,
line_type_id,
line_num,
last_update_login,
creation_date,
created_by,
item_id,
item_revision,
category_id,
item_description,
unit_meas_lookup_code,
quantity_committed,
committed_amount,
allow_price_override_flag,
not_to_exceed_price,
list_price_per_unit,
unit_price,
quantity,
un_number_id,
hazard_class_id,
note_to_vendor,
from_header_id,
from_line_id,
from_line_location_id,
min_order_quantity,
max_order_quantity,
qty_rcv_tolerance,
over_tolerance_error_flag,
market_price,
unordered_flag,
closed_flag,
user_hold_flag,
cancel_flag,
cancelled_by,
cancel_date,
cancel_reason,
firm_status_lookup_code,
firm_date,
vendor_product_num,
contract_num,
taxable_flag,
tax_name,
type_1099,
capital_expense_flag,
negotiated_by_preparer_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
reference_num,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
min_release_amount,
price_type_lookup_code,
closed_code,
price_break_lookup_code,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
program_update_date,
closed_date,
closed_reason,
closed_by,
transaction_reason_code,
org_id,
qc_grade,
base_uom,
base_qty,
secondary_uom,
secondary_qty,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
line_reference_num,
project_id,
task_id,
expiration_date,
tax_code_id,
oke_contract_header_id,
oke_contract_version_id,
secondary_quantity,
secondary_unit_of_measure,
preferred_grade,
auction_header_id,
auction_display_number,
auction_line_number,
bid_number,
bid_line_number,
retroactive_date,
supplier_ref_number,
contract_id,
start_date,
amount,
job_id,
contractor_first_name,
contractor_last_name,
order_type_lookup_code,
purchase_basis,
matching_basis,
svc_amount_notif_sent,
svc_completion_notif_sent,
base_unit_price,
manual_price_change_flag,
--
retainage_rate,
max_retainage_amount,
progress_payment_rate,
recoupment_rate,
--
catalog_name,
supplier_part_auxid,
ip_category_id,
tax_attribute_update_code, --
line_num_display,
group_line_id,
clm_info_flag,
clm_option_indicator,
clm_base_line_num,
clm_option_num,
clm_option_from_date,
clm_option_to_date,
clm_funded_flag,
contract_type,
cost_constraint,
clm_idc_type,
uda_template_id,
clm_min_total_amount,
clm_max_total_amount,
clm_min_total_quantity,
clm_max_total_quantity,
clm_min_order_amount,
clm_max_order_amount,
clm_min_order_quantity,
clm_max_order_quantity,
clm_total_amount_ordered,
clm_total_quantity_ordered,
clm_fsc_psc,
clm_mdaps_mais,
clm_naics,
clm_order_start_date,
clm_order_end_date,
clm_exercised_flag,
clm_exercised_date,
old_quantity,
clm_pop_exception_reason, --
clm_delivery_event_code, --
clm_payment_instr_code, --
CLM_UNDEF_FLAG, -- UCA Project Begin
CLM_UNDEF_ACTION_CODE,
CLM_APPROVED_UNDEF_AMOUNT,
CLM_UDA_PRICING_TOTAL, --UCA PRoject End
CLM_EXHIBIT_NAME -- Elins project
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
po_line_id,
last_update_date,
last_updated_by,
po_header_id,
line_type_id,
line_num,
last_update_login,
creation_date,
created_by,
item_id,
item_revision,
category_id,
item_description,
unit_meas_lookup_code,
quantity_committed,
committed_amount,
allow_price_override_flag,
not_to_exceed_price,
list_price_per_unit,
unit_price,
quantity,
un_number_id,
hazard_class_id,
note_to_vendor,
from_header_id,
from_line_id,
from_line_location_id,
min_order_quantity,
max_order_quantity,
qty_rcv_tolerance,
over_tolerance_error_flag,
market_price,
unordered_flag,
closed_flag,
user_hold_flag,
cancel_flag,
cancelled_by,
cancel_date,
cancel_reason,
firm_status_lookup_code,
firm_date,
vendor_product_num,
contract_num,
taxable_flag,
tax_name,
type_1099,
capital_expense_flag,
negotiated_by_preparer_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
reference_num,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
min_release_amount,
price_type_lookup_code,
closed_code,
price_break_lookup_code,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
program_update_date,
closed_date,
closed_reason,
closed_by,
transaction_reason_code,
org_id,
qc_grade,
base_uom,
base_qty,
secondary_uom,
secondary_qty,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
line_reference_num,
project_id,
task_id,
expiration_date,
tax_code_id,
oke_contract_header_id,
oke_contract_version_id,
secondary_quantity,
secondary_unit_of_measure,
preferred_grade,
auction_header_id,
auction_display_number,
auction_line_number,
bid_number,
bid_line_number,
retroactive_date,
supplier_ref_number,
contract_id,
start_date,
amount,
job_id,
contractor_first_name,
contractor_last_name,
order_type_lookup_code,
purchase_basis,
matching_basis,
svc_amount_notif_sent,
svc_completion_notif_sent,
base_unit_price,
manual_price_change_flag,
--
retainage_rate,
max_retainage_amount,
progress_payment_rate,
recoupment_rate,
--
catalog_name,
supplier_part_auxid,
ip_category_id,
tax_attribute_update_code, --
line_num_display,
group_line_id,
clm_info_flag,
clm_option_indicator,
clm_base_line_num,
clm_option_num,
clm_option_from_date,
clm_option_to_date,
clm_funded_flag,
contract_type,
cost_constraint,
clm_idc_type,
uda_template_id,
clm_min_total_amount,
clm_max_total_amount,
clm_min_total_quantity,
clm_max_total_quantity,
clm_min_order_amount,
clm_max_order_amount,
clm_min_order_quantity,
clm_max_order_quantity,
clm_total_amount_ordered,
clm_total_quantity_ordered,
clm_fsc_psc,
clm_mdaps_mais,
clm_naics,
clm_order_start_date,
clm_order_end_date,
clm_exercised_flag,
clm_exercised_date,
quantity,
clm_pop_exception_reason, --
clm_delivery_event_code, --
clm_payment_instr_code, --
CLM_UNDEF_FLAG, -- UCA Project Begin
CLM_UNDEF_ACTION_CODE,
CLM_APPROVED_UNDEF_AMOUNT,
CLM_UDA_PRICING_TOTAL , --UCA PRoject End
CLM_EXHIBIT_NAME -- Elins project
FROM po_lines_archive_all
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
INSERT INTO po_line_locations_draft_all
( draft_id,
delete_flag,
change_accepted_flag,
change_status,
line_location_id,
last_update_date,
last_updated_by,
po_header_id,
po_line_id,
last_update_login,
creation_date,
created_by,
quantity,
quantity_accepted,
quantity_received,
quantity_rejected,
quantity_billed,
quantity_cancelled,
unit_meas_lookup_code,
po_release_id,
ship_to_location_id,
ship_via_lookup_code,
need_by_date,
promised_date,
last_accept_date,
price_override,
encumbered_flag,
encumbered_date,
unencumbered_quantity,
fob_lookup_code,
freight_terms_lookup_code,
taxable_flag,
tax_name,
estimated_tax_amount,
from_header_id,
from_line_id,
from_line_location_id,
start_date,
end_date,
lead_time,
lead_time_unit,
price_discount,
terms_id,
approved_flag,
approved_date,
closed_flag,
cancel_flag,
cancelled_by,
cancel_date,
cancel_reason,
firm_status_lookup_code,
firm_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
unit_of_measure_class,
encumber_now,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
inspection_required_flag,
receipt_required_flag,
qty_rcv_tolerance,
qty_rcv_exception_code,
enforce_ship_to_location_code,
allow_substitute_receipts_flag,
days_early_receipt_allowed,
days_late_receipt_allowed,
receipt_days_exception_code,
invoice_close_tolerance,
receive_close_tolerance,
ship_to_organization_id,
shipment_num,
source_shipment_id,
shipment_type,
closed_code,
request_id,
program_application_id,
program_id,
program_update_date,
ussgl_transaction_code,
government_context,
receiving_routing_id,
accrue_on_receipt_flag,
closed_reason,
closed_date,
closed_by,
org_id,
quantity_shipped,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
country_of_origin_code,
tax_user_override_flag,
match_option,
tax_code_id,
calculate_tax_flag,
change_promised_date_reason,
note_to_receiver,
secondary_quantity,
secondary_unit_of_measure,
preferred_grade,
secondary_quantity_received,
secondary_quantity_accepted,
secondary_quantity_rejected,
secondary_quantity_cancelled,
secondary_quantity_shipped,
vmi_flag,
consigned_flag,
retroactive_date,
supplier_order_line_number,
amount,
amount_received,
amount_billed,
amount_cancelled,
amount_rejected,
amount_accepted,
drop_ship_flag,
sales_order_update_date,
transaction_flow_header_id,
final_match_flag,
manual_price_change_flag,
shipment_closed_date,
closed_for_receiving_date,
closed_for_invoice_date,
--
value_basis,
matching_basis,
payment_type,
description,
work_approver_id,
bid_payment_id,
quantity_financed,
amount_financed,
quantity_recouped,
amount_recouped,
retainage_withheld_amount,
retainage_released_amount,
--
outsourced_assembly,
tax_attribute_update_code, --
uda_template_id,
clm_period_perf_end_date,
clm_period_perf_start_date,
old_quantity,
clm_delivery_period, --
clm_delivery_period_uom, --
clm_promise_period, --
clm_promise_period_uom, --
clm_pop_duration, --
clm_pop_duration_uom --
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
line_location_id,
last_update_date,
last_updated_by,
po_header_id,
po_line_id,
last_update_login,
creation_date,
created_by,
quantity,
quantity_accepted,
quantity_received,
quantity_rejected,
quantity_billed,
quantity_cancelled,
unit_meas_lookup_code,
po_release_id,
ship_to_location_id,
ship_via_lookup_code,
need_by_date,
promised_date,
last_accept_date,
price_override,
encumbered_flag,
encumbered_date,
unencumbered_quantity,
fob_lookup_code,
freight_terms_lookup_code,
taxable_flag,
tax_name,
estimated_tax_amount,
from_header_id,
from_line_id,
from_line_location_id,
start_date,
end_date,
lead_time,
lead_time_unit,
price_discount,
terms_id,
approved_flag,
approved_date,
closed_flag,
cancel_flag,
cancelled_by,
cancel_date,
cancel_reason,
firm_status_lookup_code,
firm_date,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
unit_of_measure_class,
encumber_now,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
inspection_required_flag,
receipt_required_flag,
qty_rcv_tolerance,
qty_rcv_exception_code,
enforce_ship_to_location_code,
allow_substitute_receipts_flag,
days_early_receipt_allowed,
days_late_receipt_allowed,
receipt_days_exception_code,
invoice_close_tolerance,
receive_close_tolerance,
ship_to_organization_id,
shipment_num,
source_shipment_id,
shipment_type,
closed_code,
request_id,
program_application_id,
program_id,
program_update_date,
ussgl_transaction_code,
government_context,
receiving_routing_id,
accrue_on_receipt_flag,
closed_reason,
closed_date,
closed_by,
org_id,
quantity_shipped,
global_attribute_category,
global_attribute1,
global_attribute2,
global_attribute3,
global_attribute4,
global_attribute5,
global_attribute6,
global_attribute7,
global_attribute8,
global_attribute9,
global_attribute10,
global_attribute11,
global_attribute12,
global_attribute13,
global_attribute14,
global_attribute15,
global_attribute16,
global_attribute17,
global_attribute18,
global_attribute19,
global_attribute20,
country_of_origin_code,
tax_user_override_flag,
match_option,
tax_code_id,
calculate_tax_flag,
change_promised_date_reason,
note_to_receiver,
secondary_quantity,
secondary_unit_of_measure,
preferred_grade,
secondary_quantity_received,
secondary_quantity_accepted,
secondary_quantity_rejected,
secondary_quantity_cancelled,
secondary_quantity_shipped,
vmi_flag,
consigned_flag,
retroactive_date,
supplier_order_line_number,
amount,
amount_received,
amount_billed,
amount_cancelled,
amount_rejected,
amount_accepted,
drop_ship_flag,
sales_order_update_date,
transaction_flow_header_id,
final_match_flag,
manual_price_change_flag,
shipment_closed_date,
closed_for_receiving_date,
closed_for_invoice_date,
--
value_basis,
matching_basis,
payment_type,
description,
work_approver_id,
bid_payment_id,
quantity_financed,
amount_financed,
quantity_recouped,
amount_recouped,
retainage_withheld_amount,
retainage_released_amount,
--
outsourced_assembly,
tax_attribute_update_code, --
uda_template_id,
clm_period_perf_end_date,
clm_period_perf_start_date,
quantity,
clm_delivery_period, --
clm_delivery_period_uom, --
clm_promise_period, --
clm_promise_period_uom, --
clm_pop_duration, --
clm_pop_duration_uom --
FROM po_line_locations_archive_all
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
INSERT INTO po_distributions_draft_all
(
draft_id,
delete_flag,
change_accepted_flag,
change_status,
po_distribution_id,
last_update_date,
last_updated_by,
po_header_id,
po_line_id,
line_location_id,
set_of_books_id,
code_combination_id,
quantity_ordered,
last_update_login,
creation_date,
created_by,
po_release_id,
quantity_delivered,
quantity_billed,
quantity_cancelled,
req_header_reference_num,
req_line_reference_num,
req_distribution_id,
deliver_to_location_id,
deliver_to_person_id,
rate_date,
rate,
amount_billed,
accrued_flag,
encumbered_flag,
encumbered_amount,
unencumbered_quantity,
unencumbered_amount,
failed_funds_lookup_code,
gl_encumbered_date,
gl_encumbered_period_name,
gl_cancelled_date,
destination_type_code,
destination_organization_id,
destination_subinventory,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
wip_entity_id,
wip_operation_seq_num,
wip_resource_seq_num,
wip_repetitive_schedule_id,
wip_line_id,
bom_resource_id,
budget_account_id,
accrual_account_id,
variance_account_id,
prevent_encumbrance_flag,
ussgl_transaction_code,
government_context,
destination_context,
distribution_num,
source_distribution_id,
request_id,
program_application_id,
program_id,
program_update_date,
project_id,
task_id,
expenditure_type,
project_accounting_context,
expenditure_organization_id,
gl_closed_date,
accrue_on_receipt_flag,
expenditure_item_date,
org_id,
kanban_card_id,
award_id,
mrc_rate_date,
mrc_rate,
mrc_encumbered_amount,
mrc_unencumbered_amount,
end_item_unit_number,
tax_recovery_override_flag,
recoverable_tax,
nonrecoverable_tax,
recovery_rate,
oke_contract_line_id,
oke_contract_deliverable_id,
amount_ordered,
amount_delivered,
amount_cancelled,
distribution_type,
amount_to_encumber,
invoice_adjustment_flag,
dest_charge_account_id,
dest_variance_account_id,
--
quantity_financed,
amount_financed,
quantity_recouped,
amount_recouped,
retainage_withheld_amount,
retainage_released_amount,
--
tax_attribute_update_code, --
group_line_id,
uda_template_id,
clm_misc_loa,
clm_defence_funding,
clm_fms_case_number,
clm_agency_acct_identifier,
partial_funded_flag,
funded_value,
quantity_funded,
amount_funded,
change_in_funded_value,
old_quantity_ordered,
clm_payment_sequence_num --
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
po_distribution_id,
last_update_date,
last_updated_by,
po_header_id,
po_line_id,
line_location_id,
set_of_books_id,
code_combination_id,
quantity_ordered,
last_update_login,
creation_date,
created_by,
po_release_id,
quantity_delivered,
quantity_billed,
quantity_cancelled,
req_header_reference_num,
req_line_reference_num,
req_distribution_id,
deliver_to_location_id,
deliver_to_person_id,
rate_date,
rate,
amount_billed,
accrued_flag,
encumbered_flag,
encumbered_amount,
unencumbered_quantity,
unencumbered_amount,
failed_funds_lookup_code,
gl_encumbered_date,
gl_encumbered_period_name,
gl_cancelled_date,
destination_type_code,
destination_organization_id,
destination_subinventory,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
wip_entity_id,
wip_operation_seq_num,
wip_resource_seq_num,
wip_repetitive_schedule_id,
wip_line_id,
bom_resource_id,
budget_account_id,
accrual_account_id,
variance_account_id,
prevent_encumbrance_flag,
ussgl_transaction_code,
government_context,
destination_context,
distribution_num,
source_distribution_id,
request_id,
program_application_id,
program_id,
program_update_date,
project_id,
task_id,
expenditure_type,
project_accounting_context,
expenditure_organization_id,
gl_closed_date,
accrue_on_receipt_flag,
expenditure_item_date,
org_id,
kanban_card_id,
award_id,
mrc_rate_date,
mrc_rate,
mrc_encumbered_amount,
mrc_unencumbered_amount,
end_item_unit_number,
tax_recovery_override_flag,
recoverable_tax,
nonrecoverable_tax,
recovery_rate,
oke_contract_line_id,
oke_contract_deliverable_id,
amount_ordered,
amount_delivered,
amount_cancelled,
distribution_type,
amount_to_encumber,
invoice_adjustment_flag,
dest_charge_account_id,
dest_variance_account_id,
--
quantity_financed,
amount_financed,
quantity_recouped,
amount_recouped,
retainage_withheld_amount,
retainage_released_amount,
--
tax_attribute_update_code, --
group_line_id,
uda_template_id,
clm_misc_loa,
clm_defence_funding,
clm_fms_case_number,
clm_agency_acct_identifier,
partial_funded_flag,
funded_value,
quantity_funded,
amount_funded,
0, -- CLM Partial Funding Changes
quantity_ordered,
clm_payment_sequence_num --
FROM po_distributions_archive_all
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
INSERT INTO po_ga_org_assign_draft
(
draft_id,
delete_flag,
change_accepted_flag,
change_status,
org_assignment_id,
po_header_id,
organization_id,
enabled_flag,
vendor_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
purchasing_org_id
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
org_assignment_id,
po_header_id,
organization_id,
enabled_flag,
vendor_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
purchasing_org_id
FROM po_ga_org_assignments_archive
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
INSERT INTO po_price_diff_draft
(
draft_id,
delete_flag,
change_accepted_flag,
change_status,
price_differential_id,
price_differential_num,
entity_id,
entity_type,
price_type,
enabled_flag,
min_multiplier,
max_multiplier,
multiplier,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
price_differential_id,
price_differential_num,
entity_id,
entity_type,
price_type,
enabled_flag,
min_multiplier,
max_multiplier,
multiplier,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login
FROM po_price_differentials_archive POR
WHERE ((p_entity_type = 'PRICE BREAK' AND
POR.entity_id IN (SELECT line_location_id
FROM PO_LINE_LOCATIONS_ALL
WHERE po_header_id = p_document_id)) OR
(p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
POR.entity_id IN (SELECT po_line_id
FROM PO_LINES_ALL
WHERE po_header_id = p_document_id)))
AND POR.entity_type = p_entity_type
AND POR.revision_num = p_revision_num;
INSERT INTO po_attribute_values_draft
( draft_id,
delete_flag,
change_accepted_flag,
change_status,
attribute_values_id,
po_line_id,
req_template_name,
req_template_line_num,
ip_category_id,
inventory_item_id,
org_id,
manufacturer_part_num,
picture,
thumbnail_image,
supplier_url,
manufacturer_url,
attachment_url,
unspsc,
availability,
lead_time,
text_base_attribute1,
text_base_attribute2,
text_base_attribute3,
text_base_attribute4,
text_base_attribute5,
text_base_attribute6,
text_base_attribute7,
text_base_attribute8,
text_base_attribute9,
text_base_attribute10,
text_base_attribute11,
text_base_attribute12,
text_base_attribute13,
text_base_attribute14,
text_base_attribute15,
text_base_attribute16,
text_base_attribute17,
text_base_attribute18,
text_base_attribute19,
text_base_attribute20,
text_base_attribute21,
text_base_attribute22,
text_base_attribute23,
text_base_attribute24,
text_base_attribute25,
text_base_attribute26,
text_base_attribute27,
text_base_attribute28,
text_base_attribute29,
text_base_attribute30,
text_base_attribute31,
text_base_attribute32,
text_base_attribute33,
text_base_attribute34,
text_base_attribute35,
text_base_attribute36,
text_base_attribute37,
text_base_attribute38,
text_base_attribute39,
text_base_attribute40,
text_base_attribute41,
text_base_attribute42,
text_base_attribute43,
text_base_attribute44,
text_base_attribute45,
text_base_attribute46,
text_base_attribute47,
text_base_attribute48,
text_base_attribute49,
text_base_attribute50,
text_base_attribute51,
text_base_attribute52,
text_base_attribute53,
text_base_attribute54,
text_base_attribute55,
text_base_attribute56,
text_base_attribute57,
text_base_attribute58,
text_base_attribute59,
text_base_attribute60,
text_base_attribute61,
text_base_attribute62,
text_base_attribute63,
text_base_attribute64,
text_base_attribute65,
text_base_attribute66,
text_base_attribute67,
text_base_attribute68,
text_base_attribute69,
text_base_attribute70,
text_base_attribute71,
text_base_attribute72,
text_base_attribute73,
text_base_attribute74,
text_base_attribute75,
text_base_attribute76,
text_base_attribute77,
text_base_attribute78,
text_base_attribute79,
text_base_attribute80,
text_base_attribute81,
text_base_attribute82,
text_base_attribute83,
text_base_attribute84,
text_base_attribute85,
text_base_attribute86,
text_base_attribute87,
text_base_attribute88,
text_base_attribute89,
text_base_attribute90,
text_base_attribute91,
text_base_attribute92,
text_base_attribute93,
text_base_attribute94,
text_base_attribute95,
text_base_attribute96,
text_base_attribute97,
text_base_attribute98,
text_base_attribute99,
text_base_attribute100,
num_base_attribute1,
num_base_attribute2,
num_base_attribute3,
num_base_attribute4,
num_base_attribute5,
num_base_attribute6,
num_base_attribute7,
num_base_attribute8,
num_base_attribute9,
num_base_attribute10,
num_base_attribute11,
num_base_attribute12,
num_base_attribute13,
num_base_attribute14,
num_base_attribute15,
num_base_attribute16,
num_base_attribute17,
num_base_attribute18,
num_base_attribute19,
num_base_attribute20,
num_base_attribute21,
num_base_attribute22,
num_base_attribute23,
num_base_attribute24,
num_base_attribute25,
num_base_attribute26,
num_base_attribute27,
num_base_attribute28,
num_base_attribute29,
num_base_attribute30,
num_base_attribute31,
num_base_attribute32,
num_base_attribute33,
num_base_attribute34,
num_base_attribute35,
num_base_attribute36,
num_base_attribute37,
num_base_attribute38,
num_base_attribute39,
num_base_attribute40,
num_base_attribute41,
num_base_attribute42,
num_base_attribute43,
num_base_attribute44,
num_base_attribute45,
num_base_attribute46,
num_base_attribute47,
num_base_attribute48,
num_base_attribute49,
num_base_attribute50,
num_base_attribute51,
num_base_attribute52,
num_base_attribute53,
num_base_attribute54,
num_base_attribute55,
num_base_attribute56,
num_base_attribute57,
num_base_attribute58,
num_base_attribute59,
num_base_attribute60,
num_base_attribute61,
num_base_attribute62,
num_base_attribute63,
num_base_attribute64,
num_base_attribute65,
num_base_attribute66,
num_base_attribute67,
num_base_attribute68,
num_base_attribute69,
num_base_attribute70,
num_base_attribute71,
num_base_attribute72,
num_base_attribute73,
num_base_attribute74,
num_base_attribute75,
num_base_attribute76,
num_base_attribute77,
num_base_attribute78,
num_base_attribute79,
num_base_attribute80,
num_base_attribute81,
num_base_attribute82,
num_base_attribute83,
num_base_attribute84,
num_base_attribute85,
num_base_attribute86,
num_base_attribute87,
num_base_attribute88,
num_base_attribute89,
num_base_attribute90,
num_base_attribute91,
num_base_attribute92,
num_base_attribute93,
num_base_attribute94,
num_base_attribute95,
num_base_attribute96,
num_base_attribute97,
num_base_attribute98,
num_base_attribute99,
num_base_attribute100,
text_cat_attribute1,
text_cat_attribute2,
text_cat_attribute3,
text_cat_attribute4,
text_cat_attribute5,
text_cat_attribute6,
text_cat_attribute7,
text_cat_attribute8,
text_cat_attribute9,
text_cat_attribute10,
text_cat_attribute11,
text_cat_attribute12,
text_cat_attribute13,
text_cat_attribute14,
text_cat_attribute15,
text_cat_attribute16,
text_cat_attribute17,
text_cat_attribute18,
text_cat_attribute19,
text_cat_attribute20,
text_cat_attribute21,
text_cat_attribute22,
text_cat_attribute23,
text_cat_attribute24,
text_cat_attribute25,
text_cat_attribute26,
text_cat_attribute27,
text_cat_attribute28,
text_cat_attribute29,
text_cat_attribute30,
text_cat_attribute31,
text_cat_attribute32,
text_cat_attribute33,
text_cat_attribute34,
text_cat_attribute35,
text_cat_attribute36,
text_cat_attribute37,
text_cat_attribute38,
text_cat_attribute39,
text_cat_attribute40,
text_cat_attribute41,
text_cat_attribute42,
text_cat_attribute43,
text_cat_attribute44,
text_cat_attribute45,
text_cat_attribute46,
text_cat_attribute47,
text_cat_attribute48,
text_cat_attribute49,
text_cat_attribute50,
num_cat_attribute1,
num_cat_attribute2,
num_cat_attribute3,
num_cat_attribute4,
num_cat_attribute5,
num_cat_attribute6,
num_cat_attribute7,
num_cat_attribute8,
num_cat_attribute9,
num_cat_attribute10,
num_cat_attribute11,
num_cat_attribute12,
num_cat_attribute13,
num_cat_attribute14,
num_cat_attribute15,
num_cat_attribute16,
num_cat_attribute17,
num_cat_attribute18,
num_cat_attribute19,
num_cat_attribute20,
num_cat_attribute21,
num_cat_attribute22,
num_cat_attribute23,
num_cat_attribute24,
num_cat_attribute25,
num_cat_attribute26,
num_cat_attribute27,
num_cat_attribute28,
num_cat_attribute29,
num_cat_attribute30,
num_cat_attribute31,
num_cat_attribute32,
num_cat_attribute33,
num_cat_attribute34,
num_cat_attribute35,
num_cat_attribute36,
num_cat_attribute37,
num_cat_attribute38,
num_cat_attribute39,
num_cat_attribute40,
num_cat_attribute41,
num_cat_attribute42,
num_cat_attribute43,
num_cat_attribute44,
num_cat_attribute45,
num_cat_attribute46,
num_cat_attribute47,
num_cat_attribute48,
num_cat_attribute49,
num_cat_attribute50,
last_update_login,
last_updated_by,
last_update_date,
created_by,
creation_date,
request_id,
program_application_id,
program_id,
program_update_date
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
ATTR.attribute_values_id,
ATTR.po_line_id,
ATTR.req_template_name,
ATTR.req_template_line_num,
ATTR.ip_category_id,
ATTR.inventory_item_id,
ATTR.org_id,
ATTR.manufacturer_part_num,
ATTR.picture,
ATTR.thumbnail_image,
ATTR.supplier_url,
ATTR.manufacturer_url,
ATTR.attachment_url,
ATTR.unspsc,
ATTR.availability,
ATTR.lead_time,
ATTR.text_base_attribute1,
ATTR.text_base_attribute2,
ATTR.text_base_attribute3,
ATTR.text_base_attribute4,
ATTR.text_base_attribute5,
ATTR.text_base_attribute6,
ATTR.text_base_attribute7,
ATTR.text_base_attribute8,
ATTR.text_base_attribute9,
ATTR.text_base_attribute10,
ATTR.text_base_attribute11,
ATTR.text_base_attribute12,
ATTR.text_base_attribute13,
ATTR.text_base_attribute14,
ATTR.text_base_attribute15,
ATTR.text_base_attribute16,
ATTR.text_base_attribute17,
ATTR.text_base_attribute18,
ATTR.text_base_attribute19,
ATTR.text_base_attribute20,
ATTR.text_base_attribute21,
ATTR.text_base_attribute22,
ATTR.text_base_attribute23,
ATTR.text_base_attribute24,
ATTR.text_base_attribute25,
ATTR.text_base_attribute26,
ATTR.text_base_attribute27,
ATTR.text_base_attribute28,
ATTR.text_base_attribute29,
ATTR.text_base_attribute30,
ATTR.text_base_attribute31,
ATTR.text_base_attribute32,
ATTR.text_base_attribute33,
ATTR.text_base_attribute34,
ATTR.text_base_attribute35,
ATTR.text_base_attribute36,
ATTR.text_base_attribute37,
ATTR.text_base_attribute38,
ATTR.text_base_attribute39,
ATTR.text_base_attribute40,
ATTR.text_base_attribute41,
ATTR.text_base_attribute42,
ATTR.text_base_attribute43,
ATTR.text_base_attribute44,
ATTR.text_base_attribute45,
ATTR.text_base_attribute46,
ATTR.text_base_attribute47,
ATTR.text_base_attribute48,
ATTR.text_base_attribute49,
ATTR.text_base_attribute50,
ATTR.text_base_attribute51,
ATTR.text_base_attribute52,
ATTR.text_base_attribute53,
ATTR.text_base_attribute54,
ATTR.text_base_attribute55,
ATTR.text_base_attribute56,
ATTR.text_base_attribute57,
ATTR.text_base_attribute58,
ATTR.text_base_attribute59,
ATTR.text_base_attribute60,
ATTR.text_base_attribute61,
ATTR.text_base_attribute62,
ATTR.text_base_attribute63,
ATTR.text_base_attribute64,
ATTR.text_base_attribute65,
ATTR.text_base_attribute66,
ATTR.text_base_attribute67,
ATTR.text_base_attribute68,
ATTR.text_base_attribute69,
ATTR.text_base_attribute70,
ATTR.text_base_attribute71,
ATTR.text_base_attribute72,
ATTR.text_base_attribute73,
ATTR.text_base_attribute74,
ATTR.text_base_attribute75,
ATTR.text_base_attribute76,
ATTR.text_base_attribute77,
ATTR.text_base_attribute78,
ATTR.text_base_attribute79,
ATTR.text_base_attribute80,
ATTR.text_base_attribute81,
ATTR.text_base_attribute82,
ATTR.text_base_attribute83,
ATTR.text_base_attribute84,
ATTR.text_base_attribute85,
ATTR.text_base_attribute86,
ATTR.text_base_attribute87,
ATTR.text_base_attribute88,
ATTR.text_base_attribute89,
ATTR.text_base_attribute90,
ATTR.text_base_attribute91,
ATTR.text_base_attribute92,
ATTR.text_base_attribute93,
ATTR.text_base_attribute94,
ATTR.text_base_attribute95,
ATTR.text_base_attribute96,
ATTR.text_base_attribute97,
ATTR.text_base_attribute98,
ATTR.text_base_attribute99,
ATTR.text_base_attribute100,
ATTR.num_base_attribute1,
ATTR.num_base_attribute2,
ATTR.num_base_attribute3,
ATTR.num_base_attribute4,
ATTR.num_base_attribute5,
ATTR.num_base_attribute6,
ATTR.num_base_attribute7,
ATTR.num_base_attribute8,
ATTR.num_base_attribute9,
ATTR.num_base_attribute10,
ATTR.num_base_attribute11,
ATTR.num_base_attribute12,
ATTR.num_base_attribute13,
ATTR.num_base_attribute14,
ATTR.num_base_attribute15,
ATTR.num_base_attribute16,
ATTR.num_base_attribute17,
ATTR.num_base_attribute18,
ATTR.num_base_attribute19,
ATTR.num_base_attribute20,
ATTR.num_base_attribute21,
ATTR.num_base_attribute22,
ATTR.num_base_attribute23,
ATTR.num_base_attribute24,
ATTR.num_base_attribute25,
ATTR.num_base_attribute26,
ATTR.num_base_attribute27,
ATTR.num_base_attribute28,
ATTR.num_base_attribute29,
ATTR.num_base_attribute30,
ATTR.num_base_attribute31,
ATTR.num_base_attribute32,
ATTR.num_base_attribute33,
ATTR.num_base_attribute34,
ATTR.num_base_attribute35,
ATTR.num_base_attribute36,
ATTR.num_base_attribute37,
ATTR.num_base_attribute38,
ATTR.num_base_attribute39,
ATTR.num_base_attribute40,
ATTR.num_base_attribute41,
ATTR.num_base_attribute42,
ATTR.num_base_attribute43,
ATTR.num_base_attribute44,
ATTR.num_base_attribute45,
ATTR.num_base_attribute46,
ATTR.num_base_attribute47,
ATTR.num_base_attribute48,
ATTR.num_base_attribute49,
ATTR.num_base_attribute50,
ATTR.num_base_attribute51,
ATTR.num_base_attribute52,
ATTR.num_base_attribute53,
ATTR.num_base_attribute54,
ATTR.num_base_attribute55,
ATTR.num_base_attribute56,
ATTR.num_base_attribute57,
ATTR.num_base_attribute58,
ATTR.num_base_attribute59,
ATTR.num_base_attribute60,
ATTR.num_base_attribute61,
ATTR.num_base_attribute62,
ATTR.num_base_attribute63,
ATTR.num_base_attribute64,
ATTR.num_base_attribute65,
ATTR.num_base_attribute66,
ATTR.num_base_attribute67,
ATTR.num_base_attribute68,
ATTR.num_base_attribute69,
ATTR.num_base_attribute70,
ATTR.num_base_attribute71,
ATTR.num_base_attribute72,
ATTR.num_base_attribute73,
ATTR.num_base_attribute74,
ATTR.num_base_attribute75,
ATTR.num_base_attribute76,
ATTR.num_base_attribute77,
ATTR.num_base_attribute78,
ATTR.num_base_attribute79,
ATTR.num_base_attribute80,
ATTR.num_base_attribute81,
ATTR.num_base_attribute82,
ATTR.num_base_attribute83,
ATTR.num_base_attribute84,
ATTR.num_base_attribute85,
ATTR.num_base_attribute86,
ATTR.num_base_attribute87,
ATTR.num_base_attribute88,
ATTR.num_base_attribute89,
ATTR.num_base_attribute90,
ATTR.num_base_attribute91,
ATTR.num_base_attribute92,
ATTR.num_base_attribute93,
ATTR.num_base_attribute94,
ATTR.num_base_attribute95,
ATTR.num_base_attribute96,
ATTR.num_base_attribute97,
ATTR.num_base_attribute98,
ATTR.num_base_attribute99,
ATTR.num_base_attribute100,
ATTR.text_cat_attribute1,
ATTR.text_cat_attribute2,
ATTR.text_cat_attribute3,
ATTR.text_cat_attribute4,
ATTR.text_cat_attribute5,
ATTR.text_cat_attribute6,
ATTR.text_cat_attribute7,
ATTR.text_cat_attribute8,
ATTR.text_cat_attribute9,
ATTR.text_cat_attribute10,
ATTR.text_cat_attribute11,
ATTR.text_cat_attribute12,
ATTR.text_cat_attribute13,
ATTR.text_cat_attribute14,
ATTR.text_cat_attribute15,
ATTR.text_cat_attribute16,
ATTR.text_cat_attribute17,
ATTR.text_cat_attribute18,
ATTR.text_cat_attribute19,
ATTR.text_cat_attribute20,
ATTR.text_cat_attribute21,
ATTR.text_cat_attribute22,
ATTR.text_cat_attribute23,
ATTR.text_cat_attribute24,
ATTR.text_cat_attribute25,
ATTR.text_cat_attribute26,
ATTR.text_cat_attribute27,
ATTR.text_cat_attribute28,
ATTR.text_cat_attribute29,
ATTR.text_cat_attribute30,
ATTR.text_cat_attribute31,
ATTR.text_cat_attribute32,
ATTR.text_cat_attribute33,
ATTR.text_cat_attribute34,
ATTR.text_cat_attribute35,
ATTR.text_cat_attribute36,
ATTR.text_cat_attribute37,
ATTR.text_cat_attribute38,
ATTR.text_cat_attribute39,
ATTR.text_cat_attribute40,
ATTR.text_cat_attribute41,
ATTR.text_cat_attribute42,
ATTR.text_cat_attribute43,
ATTR.text_cat_attribute44,
ATTR.text_cat_attribute45,
ATTR.text_cat_attribute46,
ATTR.text_cat_attribute47,
ATTR.text_cat_attribute48,
ATTR.text_cat_attribute49,
ATTR.text_cat_attribute50,
ATTR.num_cat_attribute1,
ATTR.num_cat_attribute2,
ATTR.num_cat_attribute3,
ATTR.num_cat_attribute4,
ATTR.num_cat_attribute5,
ATTR.num_cat_attribute6,
ATTR.num_cat_attribute7,
ATTR.num_cat_attribute8,
ATTR.num_cat_attribute9,
ATTR.num_cat_attribute10,
ATTR.num_cat_attribute11,
ATTR.num_cat_attribute12,
ATTR.num_cat_attribute13,
ATTR.num_cat_attribute14,
ATTR.num_cat_attribute15,
ATTR.num_cat_attribute16,
ATTR.num_cat_attribute17,
ATTR.num_cat_attribute18,
ATTR.num_cat_attribute19,
ATTR.num_cat_attribute20,
ATTR.num_cat_attribute21,
ATTR.num_cat_attribute22,
ATTR.num_cat_attribute23,
ATTR.num_cat_attribute24,
ATTR.num_cat_attribute25,
ATTR.num_cat_attribute26,
ATTR.num_cat_attribute27,
ATTR.num_cat_attribute28,
ATTR.num_cat_attribute29,
ATTR.num_cat_attribute30,
ATTR.num_cat_attribute31,
ATTR.num_cat_attribute32,
ATTR.num_cat_attribute33,
ATTR.num_cat_attribute34,
ATTR.num_cat_attribute35,
ATTR.num_cat_attribute36,
ATTR.num_cat_attribute37,
ATTR.num_cat_attribute38,
ATTR.num_cat_attribute39,
ATTR.num_cat_attribute40,
ATTR.num_cat_attribute41,
ATTR.num_cat_attribute42,
ATTR.num_cat_attribute43,
ATTR.num_cat_attribute44,
ATTR.num_cat_attribute45,
ATTR.num_cat_attribute46,
ATTR.num_cat_attribute47,
ATTR.num_cat_attribute48,
ATTR.num_cat_attribute49,
ATTR.num_cat_attribute50,
ATTR.last_update_login,
ATTR.last_updated_by,
ATTR.last_update_date,
ATTR.created_by,
ATTR.creation_date,
ATTR.request_id,
ATTR.program_application_id,
ATTR.program_id,
ATTR.program_update_date
FROM PO_ATTR_VALUES_ARCHIVE ATTR,
PO_LINES_ALL POL
WHERE ATTR.po_line_id = POL.po_line_id
AND POL.po_header_id = p_document_id
AND ATTR.revision_num = p_revision_num;
INSERT INTO po_attribute_values_tlp_draft
(draft_id,
delete_flag,
change_accepted_flag,
change_status,
attribute_values_tlp_id,
po_line_id,
req_template_name,
req_template_line_num,
ip_category_id,
inventory_item_id,
org_id,
language,
description,
manufacturer,
comments,
alias,
long_description,
tl_text_base_attribute1,
tl_text_base_attribute2,
tl_text_base_attribute3,
tl_text_base_attribute4,
tl_text_base_attribute5,
tl_text_base_attribute6,
tl_text_base_attribute7,
tl_text_base_attribute8,
tl_text_base_attribute9,
tl_text_base_attribute10,
tl_text_base_attribute11,
tl_text_base_attribute12,
tl_text_base_attribute13,
tl_text_base_attribute14,
tl_text_base_attribute15,
tl_text_base_attribute16,
tl_text_base_attribute17,
tl_text_base_attribute18,
tl_text_base_attribute19,
tl_text_base_attribute20,
tl_text_base_attribute21,
tl_text_base_attribute22,
tl_text_base_attribute23,
tl_text_base_attribute24,
tl_text_base_attribute25,
tl_text_base_attribute26,
tl_text_base_attribute27,
tl_text_base_attribute28,
tl_text_base_attribute29,
tl_text_base_attribute30,
tl_text_base_attribute31,
tl_text_base_attribute32,
tl_text_base_attribute33,
tl_text_base_attribute34,
tl_text_base_attribute35,
tl_text_base_attribute36,
tl_text_base_attribute37,
tl_text_base_attribute38,
tl_text_base_attribute39,
tl_text_base_attribute40,
tl_text_base_attribute41,
tl_text_base_attribute42,
tl_text_base_attribute43,
tl_text_base_attribute44,
tl_text_base_attribute45,
tl_text_base_attribute46,
tl_text_base_attribute47,
tl_text_base_attribute48,
tl_text_base_attribute49,
tl_text_base_attribute50,
tl_text_base_attribute51,
tl_text_base_attribute52,
tl_text_base_attribute53,
tl_text_base_attribute54,
tl_text_base_attribute55,
tl_text_base_attribute56,
tl_text_base_attribute57,
tl_text_base_attribute58,
tl_text_base_attribute59,
tl_text_base_attribute60,
tl_text_base_attribute61,
tl_text_base_attribute62,
tl_text_base_attribute63,
tl_text_base_attribute64,
tl_text_base_attribute65,
tl_text_base_attribute66,
tl_text_base_attribute67,
tl_text_base_attribute68,
tl_text_base_attribute69,
tl_text_base_attribute70,
tl_text_base_attribute71,
tl_text_base_attribute72,
tl_text_base_attribute73,
tl_text_base_attribute74,
tl_text_base_attribute75,
tl_text_base_attribute76,
tl_text_base_attribute77,
tl_text_base_attribute78,
tl_text_base_attribute79,
tl_text_base_attribute80,
tl_text_base_attribute81,
tl_text_base_attribute82,
tl_text_base_attribute83,
tl_text_base_attribute84,
tl_text_base_attribute85,
tl_text_base_attribute86,
tl_text_base_attribute87,
tl_text_base_attribute88,
tl_text_base_attribute89,
tl_text_base_attribute90,
tl_text_base_attribute91,
tl_text_base_attribute92,
tl_text_base_attribute93,
tl_text_base_attribute94,
tl_text_base_attribute95,
tl_text_base_attribute96,
tl_text_base_attribute97,
tl_text_base_attribute98,
tl_text_base_attribute99,
tl_text_base_attribute100,
tl_text_cat_attribute1,
tl_text_cat_attribute2,
tl_text_cat_attribute3,
tl_text_cat_attribute4,
tl_text_cat_attribute5,
tl_text_cat_attribute6,
tl_text_cat_attribute7,
tl_text_cat_attribute8,
tl_text_cat_attribute9,
tl_text_cat_attribute10,
tl_text_cat_attribute11,
tl_text_cat_attribute12,
tl_text_cat_attribute13,
tl_text_cat_attribute14,
tl_text_cat_attribute15,
tl_text_cat_attribute16,
tl_text_cat_attribute17,
tl_text_cat_attribute18,
tl_text_cat_attribute19,
tl_text_cat_attribute20,
tl_text_cat_attribute21,
tl_text_cat_attribute22,
tl_text_cat_attribute23,
tl_text_cat_attribute24,
tl_text_cat_attribute25,
tl_text_cat_attribute26,
tl_text_cat_attribute27,
tl_text_cat_attribute28,
tl_text_cat_attribute29,
tl_text_cat_attribute30,
tl_text_cat_attribute31,
tl_text_cat_attribute32,
tl_text_cat_attribute33,
tl_text_cat_attribute34,
tl_text_cat_attribute35,
tl_text_cat_attribute36,
tl_text_cat_attribute37,
tl_text_cat_attribute38,
tl_text_cat_attribute39,
tl_text_cat_attribute40,
tl_text_cat_attribute41,
tl_text_cat_attribute42,
tl_text_cat_attribute43,
tl_text_cat_attribute44,
tl_text_cat_attribute45,
tl_text_cat_attribute46,
tl_text_cat_attribute47,
tl_text_cat_attribute48,
tl_text_cat_attribute49,
tl_text_cat_attribute50,
last_update_login,
last_updated_by,
last_update_date,
created_by,
creation_date,
request_id,
program_application_id,
program_id,
program_update_date
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
TLP.attribute_values_tlp_id,
TLP.po_line_id,
TLP.req_template_name,
TLP.req_template_line_num,
TLP.ip_category_id,
TLP.inventory_item_id,
TLP.org_id,
TLP.language,
TLP.description,
TLP.manufacturer,
TLP.comments,
TLP.alias,
TLP.long_description,
TLP.tl_text_base_attribute1,
TLP.tl_text_base_attribute2,
TLP.tl_text_base_attribute3,
TLP.tl_text_base_attribute4,
TLP.tl_text_base_attribute5,
TLP.tl_text_base_attribute6,
TLP.tl_text_base_attribute7,
TLP.tl_text_base_attribute8,
TLP.tl_text_base_attribute9,
TLP.tl_text_base_attribute10,
TLP.tl_text_base_attribute11,
TLP.tl_text_base_attribute12,
TLP.tl_text_base_attribute13,
TLP.tl_text_base_attribute14,
TLP.tl_text_base_attribute15,
TLP.tl_text_base_attribute16,
TLP.tl_text_base_attribute17,
TLP.tl_text_base_attribute18,
TLP.tl_text_base_attribute19,
TLP.tl_text_base_attribute20,
TLP.tl_text_base_attribute21,
TLP.tl_text_base_attribute22,
TLP.tl_text_base_attribute23,
TLP.tl_text_base_attribute24,
TLP.tl_text_base_attribute25,
TLP.tl_text_base_attribute26,
TLP.tl_text_base_attribute27,
TLP.tl_text_base_attribute28,
TLP.tl_text_base_attribute29,
TLP.tl_text_base_attribute30,
TLP.tl_text_base_attribute31,
TLP.tl_text_base_attribute32,
TLP.tl_text_base_attribute33,
TLP.tl_text_base_attribute34,
TLP.tl_text_base_attribute35,
TLP.tl_text_base_attribute36,
TLP.tl_text_base_attribute37,
TLP.tl_text_base_attribute38,
TLP.tl_text_base_attribute39,
TLP.tl_text_base_attribute40,
TLP.tl_text_base_attribute41,
TLP.tl_text_base_attribute42,
TLP.tl_text_base_attribute43,
TLP.tl_text_base_attribute44,
TLP.tl_text_base_attribute45,
TLP.tl_text_base_attribute46,
TLP.tl_text_base_attribute47,
TLP.tl_text_base_attribute48,
TLP.tl_text_base_attribute49,
TLP.tl_text_base_attribute50,
TLP.tl_text_base_attribute51,
TLP.tl_text_base_attribute52,
TLP.tl_text_base_attribute53,
TLP.tl_text_base_attribute54,
TLP.tl_text_base_attribute55,
TLP.tl_text_base_attribute56,
TLP.tl_text_base_attribute57,
TLP.tl_text_base_attribute58,
TLP.tl_text_base_attribute59,
TLP.tl_text_base_attribute60,
TLP.tl_text_base_attribute61,
TLP.tl_text_base_attribute62,
TLP.tl_text_base_attribute63,
TLP.tl_text_base_attribute64,
TLP.tl_text_base_attribute65,
TLP.tl_text_base_attribute66,
TLP.tl_text_base_attribute67,
TLP.tl_text_base_attribute68,
TLP.tl_text_base_attribute69,
TLP.tl_text_base_attribute70,
TLP.tl_text_base_attribute71,
TLP.tl_text_base_attribute72,
TLP.tl_text_base_attribute73,
TLP.tl_text_base_attribute74,
TLP.tl_text_base_attribute75,
TLP.tl_text_base_attribute76,
TLP.tl_text_base_attribute77,
TLP.tl_text_base_attribute78,
TLP.tl_text_base_attribute79,
TLP.tl_text_base_attribute80,
TLP.tl_text_base_attribute81,
TLP.tl_text_base_attribute82,
TLP.tl_text_base_attribute83,
TLP.tl_text_base_attribute84,
TLP.tl_text_base_attribute85,
TLP.tl_text_base_attribute86,
TLP.tl_text_base_attribute87,
TLP.tl_text_base_attribute88,
TLP.tl_text_base_attribute89,
TLP.tl_text_base_attribute90,
TLP.tl_text_base_attribute91,
TLP.tl_text_base_attribute92,
TLP.tl_text_base_attribute93,
TLP.tl_text_base_attribute94,
TLP.tl_text_base_attribute95,
TLP.tl_text_base_attribute96,
TLP.tl_text_base_attribute97,
TLP.tl_text_base_attribute98,
TLP.tl_text_base_attribute99,
TLP.tl_text_base_attribute100,
TLP.tl_text_cat_attribute1,
TLP.tl_text_cat_attribute2,
TLP.tl_text_cat_attribute3,
TLP.tl_text_cat_attribute4,
TLP.tl_text_cat_attribute5,
TLP.tl_text_cat_attribute6,
TLP.tl_text_cat_attribute7,
TLP.tl_text_cat_attribute8,
TLP.tl_text_cat_attribute9,
TLP.tl_text_cat_attribute10,
TLP.tl_text_cat_attribute11,
TLP.tl_text_cat_attribute12,
TLP.tl_text_cat_attribute13,
TLP.tl_text_cat_attribute14,
TLP.tl_text_cat_attribute15,
TLP.tl_text_cat_attribute16,
TLP.tl_text_cat_attribute17,
TLP.tl_text_cat_attribute18,
TLP.tl_text_cat_attribute19,
TLP.tl_text_cat_attribute20,
TLP.tl_text_cat_attribute21,
TLP.tl_text_cat_attribute22,
TLP.tl_text_cat_attribute23,
TLP.tl_text_cat_attribute24,
TLP.tl_text_cat_attribute25,
TLP.tl_text_cat_attribute26,
TLP.tl_text_cat_attribute27,
TLP.tl_text_cat_attribute28,
TLP.tl_text_cat_attribute29,
TLP.tl_text_cat_attribute30,
TLP.tl_text_cat_attribute31,
TLP.tl_text_cat_attribute32,
TLP.tl_text_cat_attribute33,
TLP.tl_text_cat_attribute34,
TLP.tl_text_cat_attribute35,
TLP.tl_text_cat_attribute36,
TLP.tl_text_cat_attribute37,
TLP.tl_text_cat_attribute38,
TLP.tl_text_cat_attribute39,
TLP.tl_text_cat_attribute40,
TLP.tl_text_cat_attribute41,
TLP.tl_text_cat_attribute42,
TLP.tl_text_cat_attribute43,
TLP.tl_text_cat_attribute44,
TLP.tl_text_cat_attribute45,
TLP.tl_text_cat_attribute46,
TLP.tl_text_cat_attribute47,
TLP.tl_text_cat_attribute48,
TLP.tl_text_cat_attribute49,
TLP.tl_text_cat_attribute50,
TLP.last_update_login,
TLP.last_updated_by,
TLP.last_update_date,
TLP.created_by,
TLP.creation_date,
TLP.request_id,
TLP.program_application_id,
TLP.program_id,
TLP.program_update_date
FROM PO_ATTR_VALUES_TLP_ARCHIVE TLP,
PO_LINES_ALL POL
WHERE TLP.po_line_id = POL.po_line_id
AND POL.po_header_id = p_document_id
AND TLP.revision_num = p_revision_num;
INSERT INTO PO_PRICE_ADJUSTMENTS_DRAFT
(DRAFT_ID
, DELETE_FLAG
, CHANGE_ACCEPTED_FLAG
, CHANGE_STATUS
, PRICE_ADJUSTMENT_ID
, ADJ_LINE_NUM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PO_HEADER_ID
, AUTOMATIC_FLAG
, PO_LINE_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORIG_SYS_DISCOUNT_REF
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, operand
, Arithmetic_operator
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, list_line_no
, source_system_code
, benefit_qty
, benefit_uom_code
, print_on_invoice_flag
, expiration_date
, rebate_transaction_type_code
, rebate_transaction_reference
, rebate_payment_system_code
, redeemed_date
, redeemed_flag
, accrual_flag
, range_break_quantity
, accrual_conversion_rate
, pricing_group_sequence
, modifier_level_code
, price_break_type_code
, substitution_attribute
, proration_type_code
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_CONTEXT
, AC_ATTRIBUTE1
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
, LOCK_CONTROL
)
SELECT
p_draft_id -- Always 0 for action View Base Document (Revision 0)
, NULL
, NULL
, 'NOCHANGE'
, ADJ.price_adjustment_id
, ADJ.adj_line_num
, ADJ.creation_date
, ADJ.created_by
, ADJ.last_update_date
, ADJ.last_updated_by
, ADJ.last_update_login
, ADJ.program_application_id
, ADJ.program_id
, ADJ.program_update_date
, ADJ.request_id
, ADJ.po_header_id
, ADJ.automatic_flag
, ADJ.po_line_id
, ADJ.context
, ADJ.attribute1
, ADJ.attribute2
, ADJ.attribute3
, ADJ.attribute4
, ADJ.attribute5
, ADJ.attribute6
, ADJ.attribute7
, ADJ.attribute8
, ADJ.attribute9
, ADJ.attribute10
, ADJ.attribute11
, ADJ.attribute12
, ADJ.attribute13
, ADJ.attribute14
, ADJ.attribute15
, ADJ.orig_sys_discount_ref
, ADJ.list_header_id
, ADJ.list_line_id
, ADJ.list_line_type_code
, ADJ.modified_from
, ADJ.modified_to
, ADJ.updated_flag
, ADJ.update_allowed
, ADJ.applied_flag
, ADJ.change_reason_code
, ADJ.change_reason_text
, ADJ.operand
, ADJ.arithmetic_operator
, ADJ.cost_id
, ADJ.tax_code
, ADJ.tax_exempt_flag
, ADJ.tax_exempt_number
, ADJ.tax_exempt_reason_code
, ADJ.parent_adjustment_id
, ADJ.invoiced_flag
, ADJ.estimated_flag
, ADJ.inc_in_sales_performance
, ADJ.adjusted_amount
, ADJ.pricing_phase_id
, ADJ.charge_type_code
, ADJ.charge_subtype_code
, ADJ.list_line_no
, ADJ.source_system_code
, ADJ.benefit_qty
, ADJ.benefit_uom_code
, ADJ.print_on_invoice_flag
, ADJ.expiration_date
, ADJ.rebate_transaction_type_code
, ADJ.rebate_transaction_reference
, ADJ.rebate_payment_system_code
, ADJ.redeemed_date
, ADJ.redeemed_flag
, ADJ.accrual_flag
, ADJ.range_break_quantity
, ADJ.accrual_conversion_rate
, ADJ.pricing_group_sequence
, ADJ.modifier_level_code
, ADJ.price_break_type_code
, ADJ.substitution_attribute
, ADJ.proration_type_code
, ADJ.credit_or_charge_flag
, ADJ.include_on_returns_flag
, ADJ.ac_context
, ADJ.ac_attribute1
, ADJ.ac_attribute2
, ADJ.ac_attribute3
, ADJ.ac_attribute4
, ADJ.ac_attribute5
, ADJ.ac_attribute6
, ADJ.ac_attribute7
, ADJ.ac_attribute8
, ADJ.ac_attribute9
, ADJ.ac_attribute10
, ADJ.ac_attribute11
, ADJ.ac_attribute12
, ADJ.ac_attribute13
, ADJ.ac_attribute14
, ADJ.ac_attribute15
, ADJ.operand_per_pqty
, ADJ.adjusted_amount_per_pqty
, 1
FROM PO_PRICE_ADJUSTMENTS_ARCHIVE ADJ,
PO_LINES_ALL POL
WHERE ADJ.po_line_id = POL.po_line_id
AND POL.po_header_id = p_document_id
AND ADJ.revision_num = p_revision_num;
INSERT INTO PO_PRICE_ADJ_ATTRIBS_DRAFT
(DRAFT_ID
, PRICE_ADJUSTMENT_ID
, PRICING_CONTEXT
, PRICING_ATTRIBUTE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO
, COMPARISON_OPERATOR
, FLEX_TITLE
, PRICE_ADJ_ATTRIB_ID
, LOCK_CONTROL
)
SELECT
p_draft_id -- Always 0 for action View Base Document (Revision 0)
, ATTR.price_adjustment_id
, ATTR.pricing_context
, ATTR.pricing_attribute
, ATTR.creation_date
, ATTR.created_by
, ATTR.last_update_date
, ATTR.last_updated_by
, ATTR.last_update_login
, ATTR.program_application_id
, ATTR.program_id
, ATTR.program_update_date
, ATTR.request_id
, ATTR.pricing_attr_value_from
, ATTR.pricing_attr_value_to
, ATTR.comparison_operator
, ATTR.flex_title
, ATTR.price_adj_attrib_id
, 1
FROM PO_PRICE_ADJ_ATTRIBS_ARCHIVE ATTR,
PO_PRICE_ADJUSTMENTS ADJ,
PO_LINES_ALL POL
WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
AND ADJ.po_line_id = POL.po_line_id
AND POL.po_header_id = p_document_id
AND ATTR.revision_num = p_revision_num;
INSERT INTO po_notification_ctrl_draft
(
draft_id,
delete_flag,
change_accepted_flag,
change_status,
notification_id,
po_header_id,
start_date_active,
end_date_active,
notification_amount,
notification_condition_code,
notification_qty_percentage,
last_update_date,
last_update_login,
last_updated_by,
program_id,
program_application_id,
program_update_date,
request_id,
created_by,
creation_date,
attribute_category,
attribute1,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9
)
SELECT
p_draft_id, -- Always 0 for action View Base Document (Revision 0)
NULL,
NULL,
'NOCHANGE',
notification_id,
po_header_id,
start_date_active,
end_date_active,
notification_amount,
notification_condition_code,
notification_qty_percentage,
last_update_date,
last_update_login,
last_updated_by,
program_id,
program_application_id,
program_update_date,
request_id,
created_by,
creation_date,
attribute_category,
attribute1,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9
FROM po_notification_controls
WHERE po_header_id = p_document_id;
SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
FROM PO_HEADERS_ALL_EXT_B_ARCHIVE
WHERE po_header_id = p_document_id
AND draft_id = -1
AND revision_num = p_revision_num;
SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,
PO_LINES_ALL POL
WHERE POL.po_header_id = p_document_id
AND POL.po_line_id = POLE.po_line_id
AND POLE.draft_id = -1
AND POLE.revision_num = p_revision_num;
SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POLE,
PO_LINE_LOCATIONS_ALL POL
WHERE POL.po_header_id = p_document_id
AND POL.line_location_id = POLE.line_location_id
AND POLE.draft_id = -1
AND POLE.revision_num = p_revision_num;
SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
INTO l_functional_area_code, l_document_type_code, l_document_style_id
FROM po_headers_all
WHERE PO_HEADER_ID = p_document_id;
INSERT INTO PO_HEADERS_ALL_EXT_B
(EXTENSION_ID
,ATTR_GROUP_ID
,PO_HEADER_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_hdr_ext_id_tbl(i)
,ATTR_GROUP_ID
,PO_HEADER_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_HEADERS_ALL_EXT_B_ARCHIVE
WHERE extension_id = l_old_hdr_ext_id_tbl(i)
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO PO_HEADERS_ALL_EXT_TL
(EXTENSION_ID
,ATTR_GROUP_ID
,PO_HEADER_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_hdr_ext_id_tbl(i)
,ATTR_GROUP_ID
,PO_HEADER_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_HEADERS_ALL_EXT_TL_ARCHIVE
WHERE extension_id = l_old_hdr_ext_id_tbl(i)
AND language = userenv('LANG')
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO PO_LINES_ALL_EXT_B
(EXTENSION_ID
,ATTR_GROUP_ID
,PO_LINE_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_line_ext_id_tbl(i)
,ATTR_GROUP_ID
,PO_LINE_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_LINES_ALL_EXT_B_ARCHIVE
WHERE extension_id = l_old_line_ext_id_tbl(i)
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO PO_LINES_ALL_EXT_TL
(EXTENSION_ID
,ATTR_GROUP_ID
,PO_LINE_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_line_ext_id_tbl(i)
,ATTR_GROUP_ID
,PO_LINE_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_LINES_ALL_EXT_TL_ARCHIVE
WHERE extension_id = l_old_line_ext_id_tbl(i)
AND language = userenv('LANG')
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B
(EXTENSION_ID
,ATTR_GROUP_ID
,LINE_LOCATION_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_line_loc_ext_id_tbl(i)
,ATTR_GROUP_ID
,LINE_LOCATION_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,C_EXT_ATTR1
,C_EXT_ATTR2
,C_EXT_ATTR3
,C_EXT_ATTR4
,C_EXT_ATTR5
,C_EXT_ATTR6
,C_EXT_ATTR7
,C_EXT_ATTR8
,C_EXT_ATTR9
,C_EXT_ATTR10
,C_EXT_ATTR11
,C_EXT_ATTR12
,C_EXT_ATTR13
,C_EXT_ATTR14
,C_EXT_ATTR15
,C_EXT_ATTR16
,C_EXT_ATTR17
,C_EXT_ATTR18
,C_EXT_ATTR19
,C_EXT_ATTR20
,C_EXT_ATTR21
,C_EXT_ATTR22
,C_EXT_ATTR23
,C_EXT_ATTR24
,C_EXT_ATTR25
,C_EXT_ATTR26
,C_EXT_ATTR27
,C_EXT_ATTR28
,C_EXT_ATTR29
,C_EXT_ATTR30
,C_EXT_ATTR31
,C_EXT_ATTR32
,C_EXT_ATTR33
,C_EXT_ATTR34
,C_EXT_ATTR35
,C_EXT_ATTR36
,C_EXT_ATTR37
,C_EXT_ATTR38
,C_EXT_ATTR39
,C_EXT_ATTR40
,N_EXT_ATTR1
,N_EXT_ATTR2
,N_EXT_ATTR3
,N_EXT_ATTR4
,N_EXT_ATTR5
,N_EXT_ATTR6
,N_EXT_ATTR7
,N_EXT_ATTR8
,N_EXT_ATTR9
,N_EXT_ATTR10
,N_EXT_ATTR11
,N_EXT_ATTR12
,N_EXT_ATTR13
,N_EXT_ATTR14
,N_EXT_ATTR15
,N_EXT_ATTR16
,N_EXT_ATTR17
,N_EXT_ATTR18
,N_EXT_ATTR19
,N_EXT_ATTR20
,UOM_EXT_ATTR1
,UOM_EXT_ATTR2
,UOM_EXT_ATTR3
,UOM_EXT_ATTR4
,UOM_EXT_ATTR5
,UOM_EXT_ATTR6
,UOM_EXT_ATTR7
,UOM_EXT_ATTR8
,UOM_EXT_ATTR9
,UOM_EXT_ATTR10
,UOM_EXT_ATTR11
,UOM_EXT_ATTR12
,UOM_EXT_ATTR13
,UOM_EXT_ATTR14
,UOM_EXT_ATTR15
,UOM_EXT_ATTR16
,UOM_EXT_ATTR17
,UOM_EXT_ATTR18
,UOM_EXT_ATTR19
,UOM_EXT_ATTR20
,D_EXT_ATTR1
,D_EXT_ATTR2
,D_EXT_ATTR3
,D_EXT_ATTR4
,D_EXT_ATTR5
,D_EXT_ATTR6
,D_EXT_ATTR7
,D_EXT_ATTR8
,D_EXT_ATTR9
,D_EXT_ATTR10
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE
WHERE extension_id = l_old_line_loc_ext_id_tbl(i)
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL
(EXTENSION_ID
,ATTR_GROUP_ID
,LINE_LOCATION_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,DRAFT_ID
)
SELECT
l_new_line_loc_ext_id_tbl(i)
,ATTR_GROUP_ID
,LINE_LOCATION_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,SOURCE_LANG
,LANGUAGE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,p_draft_id
FROM PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
WHERE extension_id = l_old_line_loc_ext_id_tbl(i)
AND language = userenv('LANG')
AND revision_num = p_revision_num;
PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
INSERT INTO po_line_ucas
(po_line_uca_id,
po_header_id,
po_line_id,
undef_draft_id,
undef_amount,
not_to_exceed_amount,
planned_def_date,
undef_description,
undef_approved_date,
def_draft_id,
def_description,
def_approved_date,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
undef_clm_document_number,
limit_gov_liability_amt,
def_par_draft_id)
SELECT po_line_ucas_s.NEXTVAL,
po_header_id,
po_line_id,
p_draft_id,
undef_amount,
not_to_exceed_amount,
planned_def_date,
undef_description,
undef_approved_date,
def_draft_id,
def_description,
def_approved_date,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
undef_clm_document_number,
limit_gov_liability_amt,
def_par_draft_id
FROM po_line_ucas
WHERE po_header_id = p_document_id
AND undef_draft_id = -1;
INSERT INTO po_exhibit_details_draft
(
po_exhibit_details_id,
po_header_id,
draft_id,
delete_flag,
change_accepted_flag,
exhibit_name,
exhibit_description,
is_cdrl,
reference_line_id,
change_status, --16698658
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
)
SELECT
po_exhibit_details_id,
po_header_id,
p_draft_id,
NULL,
NULL,
exhibit_name,
exhibit_description,
is_cdrl,
reference_line_id,
'NOCHANGE', --16698658
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
FROM po_exhibit_details_archive
WHERE po_header_id = p_document_id
AND revision_num = p_revision_num;
PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
delete_dummy_data_from_draft (p_draft_id);
SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,
po_core_s.g_undef_cont_act_col), 'N')
INTO l_isucaenabled
FROM po_headers_archive_all
WHERE po_header_id = p_document_id
and revision_num = p_revision_num;
PO_LOG.proc_begin(d_module,'Delete all entries from Draft Tables having draft_id: ',p_draft_id);
delete_dummy_data_from_draft (p_draft_id);
PO_LOG.stmt(d_module, d_position, 'Select global agreement flag - po_header_id');
SELECT NVL(global_agreement_flag, 'N')
INTO l_ga_flag
FROM po_headers_all
WHERE po_header_id = p_document_id;