[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
rcv_roi_header_common.default_last_update_info(p_header_record);
PROCEDURE insert_rma_header(
p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
) IS
x_sysdate DATE := SYSDATE;
INSERT INTO rcv_shipment_headers
(shipment_header_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
receipt_source_code,
vendor_id,
vendor_site_id,
organization_id,
shipment_num,
receipt_num,
ship_to_location_id,
ship_to_org_id,
bill_of_lading,
packing_slip,
shipped_date,
freight_carrier_code,
expected_receipt_date,
employee_id,
num_of_containers,
waybill_airbill_num,
comments,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
ussgl_transaction_code,
government_context,
request_id,
program_application_id,
program_id,
program_update_date,
asn_type,
edi_control_num,
notice_creation_date,
gross_weight,
gross_weight_uom_code,
net_weight,
net_weight_uom_code,
tar_weight,
tar_weight_uom_code,
packaging_code,
carrier_method,
carrier_equipment,
carrier_equipment_num,
carrier_equipment_alpha,
special_handling_code,
hazard_code,
hazard_class,
hazard_description,
freight_terms,
freight_bill_number,
invoice_date,
invoice_amount,
tax_name,
tax_amount,
freight_amount,
invoice_status_code,
asn_status,
currency_code,
conversion_rate_type,
conversion_rate,
conversion_date,
payment_terms_id,
invoice_num,
customer_id,
customer_site_id,
ship_from_location_id
)
VALUES (p_header_record.header_record.receipt_header_id,
p_header_record.header_record.last_update_date,
p_header_record.header_record.last_updated_by,
p_header_record.header_record.creation_date,
p_header_record.header_record.created_by,
p_header_record.header_record.last_update_login,
p_header_record.header_record.receipt_source_code,
p_header_record.header_record.vendor_id,
p_header_record.header_record.vendor_site_id,
p_header_record.header_record.ship_to_organization_id,
p_header_record.header_record.shipment_num,
p_header_record.header_record.receipt_num,
p_header_record.header_record.location_id,
p_header_record.header_record.ship_to_organization_id,
p_header_record.header_record.bill_of_lading,
p_header_record.header_record.packing_slip,
p_header_record.header_record.shipped_date,
p_header_record.header_record.freight_carrier_code,
p_header_record.header_record.expected_receipt_date,
p_header_record.header_record.employee_id,
p_header_record.header_record.num_of_containers,
p_header_record.header_record.waybill_airbill_num,
p_header_record.header_record.comments,
p_header_record.header_record.attribute_category,
p_header_record.header_record.attribute1,
p_header_record.header_record.attribute2,
p_header_record.header_record.attribute3,
p_header_record.header_record.attribute4,
p_header_record.header_record.attribute5,
p_header_record.header_record.attribute6,
p_header_record.header_record.attribute7,
p_header_record.header_record.attribute8,
p_header_record.header_record.attribute9,
p_header_record.header_record.attribute10,
p_header_record.header_record.attribute11,
p_header_record.header_record.attribute12,
p_header_record.header_record.attribute13,
p_header_record.header_record.attribute14,
p_header_record.header_record.attribute15,
p_header_record.header_record.usggl_transaction_code,
NULL, -- p_header_record.header_record.Government_Context
fnd_global.conc_request_id,
fnd_global.prog_appl_id,
fnd_global.conc_program_id,
x_sysdate,
p_header_record.header_record.asn_type,
p_header_record.header_record.edi_control_num,
p_header_record.header_record.notice_creation_date,
p_header_record.header_record.gross_weight,
p_header_record.header_record.gross_weight_uom_code,
p_header_record.header_record.net_weight,
p_header_record.header_record.net_weight_uom_code,
p_header_record.header_record.tar_weight,
p_header_record.header_record.tar_weight_uom_code,
p_header_record.header_record.packaging_code,
p_header_record.header_record.carrier_method,
p_header_record.header_record.carrier_equipment,
NULL, -- p_header_record.header_record.Carrier_Equipment_Num
NULL, -- p_header_record.header_record.Carrier_Equipment_Alpha
p_header_record.header_record.special_handling_code,
p_header_record.header_record.hazard_code,
p_header_record.header_record.hazard_class,
p_header_record.header_record.hazard_description,
p_header_record.header_record.freight_terms,
p_header_record.header_record.freight_bill_number,
p_header_record.header_record.invoice_date,
p_header_record.header_record.total_invoice_amount,
p_header_record.header_record.tax_name,
p_header_record.header_record.tax_amount,
p_header_record.header_record.freight_amount,
p_header_record.header_record.invoice_status_code,
'NEW_SHIP', -- p_header_record.header_record.Asn_Status
p_header_record.header_record.currency_code,
p_header_record.header_record.conversion_rate_type,
p_header_record.header_record.conversion_rate,
p_header_record.header_record.conversion_rate_date,
p_header_record.header_record.payment_terms_id,
p_header_record.header_record.invoice_num,
p_header_record.header_record.customer_id,
p_header_record.header_record.customer_site_id,
p_header_record.header_record.ship_from_location_id
);
rcv_error_pkg.set_sql_error_message('insert_rma_header', '000');
END insert_rma_header;
SELECT party.party_name
INTO p_header_record.header_record.customer_party_name
FROM hz_parties party,
hz_cust_accounts acct
WHERE acct.party_id = party.party_id
AND acct.cust_account_id = p_header_record.header_record.customer_id;
SELECT acct.cust_account_id
INTO p_header_record.header_record.customer_id
FROM hz_parties party,
hz_cust_accounts acct
WHERE party.party_id = acct.party_id
AND party.party_name = p_header_record.header_record.customer_party_name
AND acct.account_number = p_header_record.header_record.customer_account_number;
/* We do not insert customer_site_id now from forms */
/* customer_site_id = from_org_id */
PROCEDURE derive_customer_site_info(
p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
) IS
BEGIN
NULL;
SELECT status
INTO l_status
FROM hz_cust_accounts acct
WHERE acct.cust_account_id = p_header_record.header_record.customer_id;