[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT itl.tax_line_id,
itl.tax_line_num,
itl.tax_code,
itl.ship_header_id,
itl.parent_tax_line_id,
itl.adjustment_num,
itl.match_id,
itl.match_amount_id,
itl.source_parent_table_name,
itl.source_parent_table_id,
itl.tax_amt,
itl.nrec_tax_amt,
itl.currency_code,
itl.currency_conversion_type,
itl.currency_conversion_date,
itl.currency_conversion_rate,
itl.tax_amt_included_flag,
itl.created_by,
itl.creation_date,
itl.last_updated_by,
itl.last_update_date,
itl.last_update_login,
ias.allocation_basis,
ias.allocation_uom_code
FROM inl_tax_lines itl,
inl_associations ias
WHERE ias.from_parent_table_name = 'INL_TAX_LINES'
AND ias.from_parent_table_id = p_from_parent_table_id
AND ias.to_parent_table_name = p_to_parent_table_name
AND ias.to_parent_table_id = p_current_to_parent_table_id
AND itl.tax_line_id = p_from_parent_table_id
AND ias.ship_header_id = p_current_ship_header_id;
SELECT inl_tax_lines_s.NEXTVAL
INTO l_tax_line_id
FROM dual;
p_debug_info => 'Insert into INL_TAX_LINES');
INSERT INTO inl_tax_lines (tax_line_id,
tax_line_num,
tax_code,
ship_header_id,
parent_tax_line_id,
adjustment_num,
match_id,
match_amount_id,
source_parent_table_name,
source_parent_table_id,
tax_amt,
nrec_tax_amt,
currency_code,
currency_conversion_type,
currency_conversion_date,
currency_conversion_rate,
tax_amt_included_flag,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (l_tax_line_id,
TaxLines_List(i).tax_line_num,
TaxLines_List(i).tax_code,
p_new_ship_header_id,
TaxLines_List(i).parent_tax_line_id,
TaxLines_List(i).adjustment_num,
TaxLines_List(i).match_id,
TaxLines_List(i).match_amount_id,
TaxLines_List(i).source_parent_table_name,
TaxLines_List(i).source_parent_table_id,
TaxLines_List(i).tax_amt,
TaxLines_List(i).nrec_tax_amt,
TaxLines_List(i).currency_code,
TaxLines_List(i).currency_conversion_type,
TaxLines_List(i).currency_conversion_date,
TaxLines_List(i).currency_conversion_rate,
TaxLines_List(i).tax_amt_included_flag,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id);
p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
INSERT INTO inl_associations (association_id,
ship_header_id,
from_parent_table_name,
from_parent_table_id,
to_parent_table_name,
to_parent_table_id,
allocation_basis,
allocation_uom_code,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (inl_associations_s.NEXTVAL,
p_new_ship_header_id,
'INL_TAX_LINES',
l_tax_line_id,
p_to_parent_table_name,
p_new_to_parent_table_id,
TaxLines_List(i).allocation_basis,
TaxLines_List(i).allocation_uom_code,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id);
SELECT icl.charge_line_id,
icl.charge_line_num,
icl.charge_line_type_id,
icl.landed_cost_flag,
icl.update_allowed,
icl.source_code,
icl.parent_charge_line_id,
icl.adjustment_num,
icl.match_id,
icl.match_amount_id,
icl.charge_amt,
icl.currency_code,
icl.currency_conversion_type,
icl.currency_conversion_date,
icl.currency_conversion_rate,
icl.party_id,
icl.party_site_id,
icl.trx_business_category,
icl.intended_use,
icl.product_fiscal_class,
icl.product_category,
icl.product_type,
icl.user_def_fiscal_class,
icl.tax_classification_code,
icl.assessable_value,
icl.tax_already_calculated_flag,
icl.ship_from_party_id,
icl.ship_from_party_site_id,
icl.ship_to_organization_id,
icl.ship_to_location_id,
icl.bill_from_party_id,
icl.bill_from_party_site_id,
icl.bill_to_organization_id,
icl.bill_to_location_id,
icl.poa_party_id,
icl.poa_party_site_id,
icl.poo_organization_id,
icl.poo_location_id,
icl.created_by,
icl.creation_date,
icl.last_updated_by,
icl.last_update_date,
icl.last_update_login,
ias.allocation_basis,
ias.allocation_uom_code
FROM inl_charge_lines icl,
inl_associations ias
WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
AND ias.from_parent_table_id = p_from_parent_table_id
AND ias.to_parent_table_name = p_to_parent_table_name
AND ias.to_parent_table_id = p_current_to_parent_table_id
AND icl.charge_line_id = p_from_parent_table_id
AND ias.ship_header_id = p_current_ship_header_id;
SELECT inl_charge_lines_s.NEXTVAL
INTO l_charge_line_id
FROM dual;
p_debug_info => 'Insert into INL_CHARGE_LINES');
INSERT INTO inl_charge_lines (charge_line_id,
charge_line_num,
charge_line_type_id,
landed_cost_flag,
update_allowed,
source_code,
parent_charge_line_id,
adjustment_num,
match_id,
match_amount_id,
charge_amt,
currency_code,
currency_conversion_type,
currency_conversion_date,
currency_conversion_rate,
party_id,
party_site_id,
trx_business_category,
intended_use,
product_fiscal_class,
product_category,
product_type,
user_def_fiscal_class,
tax_classification_code,
assessable_value,
tax_already_calculated_flag,
ship_from_party_id,
ship_from_party_site_id,
ship_to_organization_id,
ship_to_location_id,
bill_from_party_id,
bill_from_party_site_id,
bill_to_organization_id,
bill_to_location_id,
poa_party_id,
poa_party_site_id,
poo_organization_id,
poo_location_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (l_charge_line_id,
ChargeLines_List(i).charge_line_num,
ChargeLines_List(i).charge_line_type_id,
ChargeLines_List(i).landed_cost_flag,
ChargeLines_List(i).update_allowed,
ChargeLines_List(i).source_code,
ChargeLines_List(i).parent_charge_line_id,
ChargeLines_List(i).adjustment_num,
ChargeLines_List(i).match_id,
ChargeLines_List(i).match_amount_id,
ChargeLines_List(i).charge_amt,
ChargeLines_List(i).currency_code,
ChargeLines_List(i).currency_conversion_type,
ChargeLines_List(i).currency_conversion_date,
ChargeLines_List(i).currency_conversion_rate,
ChargeLines_List(i).party_id,
ChargeLines_List(i).party_site_id,
ChargeLines_List(i).trx_business_category,
ChargeLines_List(i).intended_use,
ChargeLines_List(i).product_fiscal_class,
ChargeLines_List(i).product_category,
ChargeLines_List(i).product_type,
ChargeLines_List(i).user_def_fiscal_class,
ChargeLines_List(i).tax_classification_code,
ChargeLines_List(i).assessable_value,
ChargeLines_List(i).tax_already_calculated_flag,
ChargeLines_List(i).ship_from_party_id,
ChargeLines_List(i).ship_from_party_site_id,
ChargeLines_List(i).ship_to_organization_id,
ChargeLines_List(i).ship_to_location_id,
ChargeLines_List(i).bill_from_party_id,
ChargeLines_List(i).bill_from_party_site_id,
ChargeLines_List(i).bill_to_organization_id,
ChargeLines_List(i).bill_to_location_id,
ChargeLines_List(i).poa_party_id,
ChargeLines_List(i).poa_party_site_id,
ChargeLines_List(i).poo_organization_id,
ChargeLines_List(i).poo_location_id,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id);
p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
INSERT INTO inl_associations (association_id,
ship_header_id,
from_parent_table_name,
from_parent_table_id,
to_parent_table_name,
to_parent_table_id,
allocation_basis,
allocation_uom_code,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
VALUES (inl_associations_s.NEXTVAL,
p_new_ship_header_id,
'INL_CHARGE_LINES',
l_charge_line_id,
p_to_parent_table_name,
p_new_to_parent_table_id,
ChargeLines_List(i).allocation_basis,
ChargeLines_List(i).allocation_uom_code,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id);
SELECT ship_header_id,
ship_line_group_id,
ship_line_id,
ship_line_num,
ship_line_type_id,
ship_line_src_type_code,
ship_line_source_id,
parent_ship_line_id,
adjustment_num,
match_id,
currency_code,
currency_conversion_type,
currency_conversion_date,
currency_conversion_rate,
inventory_item_id,
txn_qty,
txn_uom_code,
txn_unit_price,
primary_qty,
primary_uom_code,
primary_unit_price,
secondary_qty,
secondary_uom_code,
secondary_unit_price,
landed_cost_flag,
allocation_enabled_flag,
trx_business_category,
intended_use,
product_fiscal_class,
product_category,
product_type,
user_def_fiscal_class,
tax_classification_code,
assessable_value,
tax_already_calculated_flag,
ship_from_party_id,
ship_from_party_site_id,
ship_to_organization_id,
ship_to_location_id,
bill_from_party_id,
bill_from_party_site_id,
bill_to_organization_id,
bill_to_location_id,
poa_party_id,
poa_party_site_id,
poo_organization_id,
poo_location_id,
org_id,
ship_line_int_id,
interface_source_table,
interface_source_line_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
nrq_zero_exception_flag
FROM inl_ship_lines_all
WHERE ship_line_group_id = p_current_ship_line_group_id;
SELECT ship_header_id
INTO l_ship_header_id
FROM inl_ship_line_groups
WHERE ship_line_group_id = p_new_ship_line_group_id;
SELECT inl_ship_lines_all_s.NEXTVAL
INTO l_ship_line_id
FROM dual;
p_debug_info => 'Insert into INL_SHIP_LINES_ALL');
INSERT INTO inl_ship_lines_all (ship_header_id,
ship_line_group_id,
ship_line_id,
ship_line_num,
ship_line_type_id,
ship_line_src_type_code,
ship_line_source_id,
parent_ship_line_id,
adjustment_num,
match_id,
currency_code,
currency_conversion_type,
currency_conversion_date,
currency_conversion_rate,
inventory_item_id,
txn_qty,
txn_uom_code,
txn_unit_price,
primary_qty,
primary_uom_code,
primary_unit_price,
secondary_qty,
secondary_uom_code,
secondary_unit_price,
landed_cost_flag,
allocation_enabled_flag,
trx_business_category,
intended_use,
product_fiscal_class,
product_category,
product_type,
user_def_fiscal_class,
tax_classification_code,
assessable_value,
tax_already_calculated_flag,
ship_from_party_id,
ship_from_party_site_id,
ship_to_organization_id,
ship_to_location_id,
bill_from_party_id,
bill_from_party_site_id,
bill_to_organization_id,
bill_to_location_id,
poa_party_id,
poa_party_site_id,
poo_organization_id,
poo_location_id,
org_id,
ship_line_int_id,
interface_source_table,
interface_source_line_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
nrq_zero_exception_flag)
VALUES (l_ship_header_id,
p_new_ship_line_group_id,
l_ship_line_id,
ShipLines_List(i).ship_line_num,
ShipLines_List(i).ship_line_type_id,
ShipLines_List(i).ship_line_src_type_code,
ShipLines_List(i).ship_line_source_id,
ShipLines_List(i).parent_ship_line_id,
ShipLines_List(i).adjustment_num,
ShipLines_List(i).match_id,
ShipLines_List(i).currency_code,
ShipLines_List(i).currency_conversion_type,
ShipLines_List(i).currency_conversion_date,
ShipLines_List(i).currency_conversion_rate,
ShipLines_List(i).inventory_item_id,
ShipLines_List(i).txn_qty,
ShipLines_List(i).txn_uom_code,
ShipLines_List(i).txn_unit_price,
ShipLines_List(i).primary_qty,
ShipLines_List(i).primary_uom_code,
ShipLines_List(i).primary_unit_price,
ShipLines_List(i).secondary_qty,
ShipLines_List(i).secondary_uom_code,
ShipLines_List(i).secondary_unit_price,
ShipLines_List(i).landed_cost_flag,
ShipLines_List(i).allocation_enabled_flag,
ShipLines_List(i).trx_business_category,
ShipLines_List(i).intended_use,
ShipLines_List(i).product_fiscal_class,
ShipLines_List(i).product_category,
ShipLines_List(i).product_type,
ShipLines_List(i).user_def_fiscal_class,
ShipLines_List(i).tax_classification_code,
ShipLines_List(i).assessable_value,
ShipLines_List(i).tax_already_calculated_flag,
ShipLines_List(i).ship_from_party_id,
ShipLines_List(i).ship_from_party_site_id,
ShipLines_List(i).ship_to_organization_id,
ShipLines_List(i).ship_to_location_id,
ShipLines_List(i).bill_from_party_id,
ShipLines_List(i).bill_from_party_site_id,
ShipLines_List(i).bill_to_organization_id,
ShipLines_List(i).bill_to_location_id,
ShipLines_List(i).poa_party_id,
ShipLines_List(i).poa_party_site_id,
ShipLines_List(i).poo_organization_id,
ShipLines_List(i).poo_location_id,
ShipLines_List(i).org_id,
NULL, -- ship_line_int_id
ShipLines_List(i).interface_source_table,
ShipLines_List(i).interface_source_line_id,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id,
ShipLines_List(i).program_id,
ShipLines_List(i).program_update_date,
ShipLines_List(i).program_application_id,
ShipLines_List(i).request_id,
ShipLines_List(i).attribute_category,
ShipLines_List(i).attribute1,
ShipLines_List(i).attribute2,
ShipLines_List(i).attribute3,
ShipLines_List(i).attribute4,
ShipLines_List(i).attribute5,
ShipLines_List(i).attribute6,
ShipLines_List(i).attribute7,
ShipLines_List(i).attribute8,
ShipLines_List(i).attribute9,
ShipLines_List(i).attribute10,
ShipLines_List(i).attribute11,
ShipLines_List(i).attribute12,
ShipLines_List(i).attribute13,
ShipLines_List(i).attribute14,
ShipLines_List(i).attribute15,
ShipLines_List(i).nrq_zero_exception_flag);
SELECT from_parent_table_name,
from_parent_table_id
BULK COLLECT INTO l_from_association_tbl
FROM inl_associations
WHERE to_parent_table_name = 'INL_SHIP_LINES'
AND to_parent_table_id = ShipLines_List(i).ship_line_id
AND ship_header_id = ShipLines_List(i).ship_header_id;
SELECT ship_line_group_id,
ship_line_group_reference,
ship_header_id,
ship_line_group_num,
src_type_code,
party_id,
party_site_id,
source_organization_id,
ship_line_int_id,
interface_source_table,
interface_source_line_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM inl_ship_line_groups
WHERE ship_header_id = p_current_ship_header_id;
SELECT inl_ship_line_groups_s.NEXTVAL
INTO l_ship_line_group_id
FROM dual;
p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');
INSERT INTO inl_ship_line_groups (ship_line_group_id,
ship_line_group_reference,
ship_header_id,
ship_line_group_num,
src_type_code,
party_id,
party_site_id,
source_organization_id,
ship_line_int_id,
interface_source_table,
interface_source_line_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES (l_ship_line_group_id,
LineGroups_List(i).ship_line_group_reference,
p_new_ship_header_id,
LineGroups_List(i).ship_line_group_num,
LineGroups_List(i).src_type_code,
LineGroups_List(i).party_id,
LineGroups_List(i).party_site_id,
LineGroups_List(i).source_organization_id,
NULL, --ship_line_int_id
LineGroups_List(i).interface_source_table,
LineGroups_List(i).interface_source_line_id,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id,
LineGroups_List(i).program_id,
LineGroups_List(i).program_update_date,
LineGroups_List(i).program_application_id,
LineGroups_List(i).request_id,
LineGroups_List(i).attribute_category,
LineGroups_List(i).attribute1,
LineGroups_List(i).attribute2,
LineGroups_List(i).attribute3,
LineGroups_List(i).attribute4,
LineGroups_List(i).attribute5,
LineGroups_List(i).attribute6,
LineGroups_List(i).attribute7,
LineGroups_List(i).attribute8,
LineGroups_List(i).attribute9,
LineGroups_List(i).attribute10,
LineGroups_List(i).attribute11,
LineGroups_List(i).attribute12,
LineGroups_List(i).attribute13,
LineGroups_List(i).attribute14,
LineGroups_List(i).attribute15);
SELECT from_parent_table_name,
from_parent_table_id
BULK COLLECT INTO l_from_association_tbl
FROM inl_associations
WHERE to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
AND to_parent_table_id = LineGroups_List(i).ship_line_group_id
AND ship_header_id = p_current_ship_header_id;
SELECT ship_header_id,
ship_num,
ship_date,
ship_type_id,
ship_status_code,
pending_matching_flag,
legal_entity_id,
organization_id,
location_id,
org_id,
taxation_country,
document_sub_type,
ship_header_int_id,
interface_source_code,
interface_source_table,
interface_source_line_id,
simulation_id,
adjustment_num,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
rcv_enabled_flag
FROM inl_ship_headers_all
WHERE simulation_id = p_current_simulation_id;
p_debug_info => 'Select data from_association_rec INL_SIMULATIONS');
SELECT s.simulation_id,
'N',
s.parent_table_name,
s.parent_table_id,
s.parent_table_revision_num,
s.version_num,
s.vendor_id,
s.vendor_site_id,
s.freight_code
INTO l_simulation_rec.simulation_id,
l_simulation_rec.firmed_flag,
l_simulation_rec.parent_table_name,
l_simulation_rec.parent_table_id,
l_simulation_rec.parent_table_revision_num,
l_simulation_rec.version_num,
l_simulation_rec.vendor_id,
l_simulation_rec.vendor_site_id,
l_simulation_rec.freight_code
FROM inl_simulations s
WHERE s.simulation_id = p_new_simulation_id;
SELECT segment1
INTO l_src_number
FROM po_headers_all ph
WHERE ph.po_header_id = l_simulation_rec.parent_table_id;
SELECT segment1
INTO l_src_number
FROM po_headers_all ph,
po_releases_all pr
WHERE ph.po_header_id = pr.po_header_id
AND pr.po_release_id = l_simulation_rec.parent_table_id;
SELECT inl_ship_headers_all_s.NEXTVAL
INTO l_ship_header_id
FROM dual;
p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');
INSERT INTO inl_ship_headers_all (ship_header_id,
ship_num,
ship_date,
ship_type_id,
ship_status_code,
pending_matching_flag,
rcv_enabled_flag,
legal_entity_id,
organization_id,
location_id,
org_id,
taxation_country,
document_sub_type,
ship_header_int_id,
interface_source_code,
interface_source_table,
interface_source_line_id,
simulation_id,
adjustment_num,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
program_id,
program_update_date,
program_application_id,
request_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES (l_ship_header_id,
l_next_ship_num,
SYSDATE, -- ship_date
ShipHeaders_List(i).ship_type_id,
'INCOMPLETE',
NULL, -- pending_matching_flag
ShipHeaders_List(i).rcv_enabled_flag,
ShipHeaders_List(i).legal_entity_id,
ShipHeaders_List(i).organization_id,
ShipHeaders_List(i).location_id,
ShipHeaders_List(i).org_id,
ShipHeaders_List(i).taxation_country,
ShipHeaders_List(i).document_sub_type,
NULL, -- ship_header_int_id
ShipHeaders_List(i).interface_source_code,
ShipHeaders_List(i).interface_source_table,
ShipHeaders_List(i).interface_source_line_id,
p_new_simulation_id,
0,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id,
fnd_global.conc_program_id,
SYSDATE,
fnd_global.prog_appl_id,
fnd_global.conc_request_id,
ShipHeaders_List(i).attribute_category,
ShipHeaders_List(i).attribute1,
ShipHeaders_List(i).attribute2,
ShipHeaders_List(i).attribute3,
ShipHeaders_List(i).attribute4,
ShipHeaders_List(i).attribute5,
ShipHeaders_List(i).attribute6,
ShipHeaders_List(i).attribute7,
ShipHeaders_List(i).attribute8,
ShipHeaders_List(i).attribute9,
ShipHeaders_List(i).attribute10,
ShipHeaders_List(i).attribute11,
ShipHeaders_List(i).attribute12,
ShipHeaders_List(i).attribute13,
ShipHeaders_List(i).attribute14,
ShipHeaders_List(i).attribute15);
SELECT from_parent_table_name,
from_parent_table_id
BULK COLLECT INTO l_from_association_tbl
FROM inl_associations
WHERE to_parent_table_name = 'INL_SHIP_HEADERS'
AND to_parent_table_id = ShipHeaders_List(i).ship_header_id
AND ship_header_id = ShipHeaders_List(i).ship_header_id;
SELECT MAX(a.version_num) + 1
INTO l_version_num
FROM inl_simulations a,
inl_simulations b
WHERE a.parent_table_name = b.parent_table_name
AND a.parent_table_id = b.parent_table_id
AND a.parent_table_revision_num = b.parent_table_revision_num
AND b.simulation_id = p_simulation_id;
SELECT inl_simulations_s.NEXTVAL
INTO l_simulation_id
FROM dual;
p_debug_info => 'Populate Simulation record to be used on INSERT');
SELECT 'N',
parent_table_name,
parent_table_id,
parent_table_revision_num,
vendor_id,
vendor_site_id,
freight_code,
org_id,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
INTO l_simulation_rec.firmed_flag,
l_simulation_rec.parent_table_name,
l_simulation_rec.parent_table_id,
l_simulation_rec.parent_table_revision_num,
l_simulation_rec.vendor_id,
l_simulation_rec.vendor_site_id,
l_simulation_rec.freight_code,
l_simulation_rec.org_id,
l_simulation_rec.attribute_category,
l_simulation_rec.attribute1,
l_simulation_rec.attribute2,
l_simulation_rec.attribute3,
l_simulation_rec.attribute4,
l_simulation_rec.attribute5,
l_simulation_rec.attribute6,
l_simulation_rec.attribute7,
l_simulation_rec.attribute8,
l_simulation_rec.attribute9,
l_simulation_rec.attribute10,
l_simulation_rec.attribute11,
l_simulation_rec.attribute12,
l_simulation_rec.attribute13,
l_simulation_rec.attribute14,
l_simulation_rec.attribute15
FROM inl_simulations
WHERE simulation_id = p_simulation_id;
p_debug_info => 'Insert into Simulation table a copy of the existing record');
INSERT INTO inl_simulations (simulation_id,
firmed_flag,
parent_table_name,
parent_table_id,
parent_table_revision_num,
version_num,
vendor_id,
vendor_site_id,
freight_code,
org_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15)
VALUES (l_simulation_id,
l_simulation_rec.firmed_flag,
l_simulation_rec.parent_table_name,
l_simulation_rec.parent_table_id,
l_simulation_rec.parent_table_revision_num,
l_version_num,
l_simulation_rec.vendor_id,
l_simulation_rec.vendor_site_id,
l_simulation_rec.freight_code,
l_simulation_rec.org_id,
fnd_global.user_id,
SYSDATE,
fnd_global.user_id,
SYSDATE,
fnd_global.login_id,
l_simulation_rec.attribute_category,
l_simulation_rec.attribute1,
l_simulation_rec.attribute2,
l_simulation_rec.attribute3,
l_simulation_rec.attribute4,
l_simulation_rec.attribute5,
l_simulation_rec.attribute6,
l_simulation_rec.attribute7,
l_simulation_rec.attribute8,
l_simulation_rec.attribute9,
l_simulation_rec.attribute10,
l_simulation_rec.attribute11,
l_simulation_rec.attribute12,
l_simulation_rec.attribute13,
l_simulation_rec.attribute14,
l_simulation_rec.attribute15);
SELECT NVL(MAX(sml.version_num),0) + 1
INTO p_simulation_rec.version_num
FROM inl_simulations sml
WHERE sml.parent_table_name = p_simulation_rec.parent_table_name
AND sml.parent_table_id = p_simulation_rec.parent_table_id
AND parent_table_revision_num = p_simulation_rec.parent_table_revision_num;
SELECT inl_simulations_s.NEXTVAL
INTO p_simulation_rec.simulation_id
FROM dual;
l_debug_msg := 'Inserting data into inl_simulations table';
INSERT INTO inl_simulations sml
(sml.simulation_id, -- 01
sml.firmed_flag, -- 02
sml.parent_table_name, -- 03
sml.parent_table_id, -- 04
sml.parent_table_revision_num, -- 05
sml.version_num, -- 06
sml.vendor_id, -- 09
sml.vendor_site_id, -- 10
sml.freight_code, -- 11
sml.org_id, -- 12
created_by, -- 13
creation_date, -- 14
last_updated_by, -- 15
last_update_date, -- 16
attribute_category, -- 17
attribute1, -- 18
attribute2, -- 19
attribute3, -- 20
attribute4, -- 21
attribute5, -- 22
attribute6, -- 23
attribute7, -- 24
attribute8, -- 25
attribute9, -- 25
attribute10, -- 27
attribute11, -- 28
attribute12, -- 29
attribute13, -- 30
attribute14, -- 31
attribute15) -- 32
VALUES
(p_simulation_rec.simulation_id, -- 01
p_simulation_rec.firmed_flag, -- 02
p_simulation_rec.parent_table_name, -- 03
p_simulation_rec.parent_table_id, -- 04
p_simulation_rec.parent_table_revision_num, -- 05
p_simulation_rec.version_num, -- 06
p_simulation_rec.vendor_id, -- 09
p_simulation_rec.vendor_site_id, -- 10
p_simulation_rec.freight_code, -- 11
p_simulation_rec.org_id, -- 12
fnd_global.user_id, -- 13
SYSDATE, -- 14
fnd_global.user_id, -- 15
SYSDATE, -- 16
l_attribute_category, -- 17
l_attribute1, -- 18
l_attribute2, -- 19
l_attribute3, -- 20
l_attribute4, -- 21
l_attribute5, -- 22
l_attribute6, -- 23
l_attribute7, -- 24
l_attribute8, -- 25
l_attribute9, -- 26
l_attribute10, -- 27
l_attribute11, -- 28
l_attribute12, -- 29
l_attribute13, -- 30
l_attribute14, -- 31
l_attribute15); -- 32
SELECT simulation_id
FROM inl_simulations s
WHERE org_id = p_org_id
ORDER BY s.parent_table_name,
s.parent_table_id,
s.parent_table_revision_num,
s.version_num;
SELECT sh.ship_header_id
FROM inl_ship_headers sh
WHERE sh.simulation_id = p_simulation_id;
INL_INTERFACE_PVT.Delete_Ship(p_ship_header_id => c_ship_hdr_tbl(j).ship_header_id,
x_return_status => l_return_status);
DELETE FROM inl_simulations s
WHERE s.simulation_id = c_simul_tbl(i).simulation_id;