[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
p_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
p_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
p_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
p_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
p_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_display_arithmetic_operator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
p_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_credit_update_date IN DATE := FND_API.G_MISS_DATE,
p_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
p_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_automatic_price_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_automatic_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_assistance_requested IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_assistance_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_end_customer_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
p_header_paynow_charges IN NUMBER := FND_API.G_MISS_NUM
)
RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
IS
cursor l_last_update_date_csr(p_qte_header_id NUMBER) IS
SELECT aqh.last_update_date
FROM aso_quote_headers_all aqh
WHERE aqh.quote_header_id = p_qte_header_id;
l_last_update_date DATE;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_qte_header.last_updated_by := FND_API.G_MISS_NUM;
l_qte_header.last_updated_by := p_last_updated_by;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.last_update_date := FND_API.G_MISS_DATE;
l_qte_header.last_update_date := p_last_update_date;
IF p_last_update_date= FND_API.G_MISS_DATE THEN
OPEN l_last_update_date_csr(p_quote_header_id);
FETCH l_last_update_date_csr into l_last_update_date;
IF l_last_update_date_csr%FOUND THEN
l_qte_header.last_update_date := l_last_update_date;
CLOSE l_last_update_date_csr;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_qte_header.last_update_login := FND_API.G_MISS_NUM;
l_qte_header.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.program_update_date := FND_API.G_MISS_DATE;
l_qte_header.program_update_date := p_program_update_date;
IF p_price_updated_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.price_updated_date := FND_API.G_MISS_DATE;
l_qte_header.price_updated_date := p_price_updated_date;
IF p_tax_updated_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.tax_updated_date := FND_API.G_MISS_DATE;
l_qte_header.tax_updated_date := p_tax_updated_date;
IF p_credit_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.credit_update_date := FND_API.G_MISS_DATE;
l_qte_header.credit_update_date := p_credit_update_date;
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_line_number IN NUMBER := FND_API.G_MISS_NUM,
p_line_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_item_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM,
p_organization_id IN NUMBER := FND_API.G_MISS_NUM,
p_quantity IN NUMBER := FND_API.G_MISS_NUM,
p_uom_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_start_date_active IN DATE := FND_API.G_MISS_DATE,
p_end_date_active IN DATE := FND_API.G_MISS_DATE,
p_order_line_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_line_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_line_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_line_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_line_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_related_item_id IN NUMBER := FND_API.G_MISS_NUM,
p_item_relationship_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_split_shipment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_backorder_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_selling_price_change IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_ffm_content_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ffm_content_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ffm_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ffm_media_id IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ffm_media_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ffm_user_note IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_pricing_quantity_uom IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
p_section_id IN NUMBER := FND_API.G_MISS_NUM,
p_priced_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_agreement_id IN NUMBER := FND_API.G_MISS_NUM,
p_commitment_id IN NUMBER := FND_API.G_MISS_NUM,
p_display_arithmetic_operator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_model_complete_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_charge_periodicity_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_end_customer_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_end_customer_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
p_line_paynow_charges IN NUMBER := FND_API.G_MISS_NUM,
p_line_paynow_tax IN NUMBER := FND_API.G_MISS_NUM,
p_line_paynow_subtotal IN NUMBER := FND_API.G_MISS_NUM,
p_config_model_type IN VARCHAR2 := FND_API.G_MISS_CHAR
)
RETURN ASO_Quote_Pub.Qte_Line_Rec_Type
IS
l_qte_line_rec ASO_Quote_Pub.Qte_Line_Rec_Type;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_qte_line_rec.last_updated_by := FND_API.G_MISS_NUM;
l_qte_line_rec.last_updated_by := p_last_updated_by;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_rec.last_update_date := FND_API.G_MISS_DATE;
l_qte_line_rec.last_update_date := p_last_update_date;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_qte_line_rec.last_update_login := FND_API.G_MISS_NUM;
l_qte_line_rec.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_rec.program_update_date := FND_API.G_MISS_DATE;
l_qte_line_rec.program_update_date := p_program_update_date;
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_date IN jtf_date_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_org_id IN jtf_number_table := NULL,
p_line_number IN jtf_number_table := NULL,
p_line_category_code IN jtf_varchar2_table_100 := NULL,
p_item_type_code IN jtf_varchar2_table_100 := NULL,
p_inventory_item_id IN jtf_number_table := NULL,
p_organization_id IN jtf_number_table := NULL,
p_quantity IN jtf_number_table := NULL,
p_uom_code IN jtf_varchar2_table_100 := NULL,
p_start_date_active IN jtf_date_table := NULL,
p_end_date_active IN jtf_date_table := NULL,
p_order_line_type_id IN jtf_number_table := NULL,
p_price_list_id IN jtf_number_table := NULL,
p_price_list_line_id IN jtf_number_table := NULL,
p_currency_code IN jtf_varchar2_table_100 := NULL,
p_line_list_price IN jtf_number_table := NULL,
p_line_adjusted_amount IN jtf_number_table := NULL,
p_line_adjusted_percent IN jtf_number_table := NULL,
p_line_quote_price IN jtf_number_table := NULL,
p_related_item_id IN jtf_number_table := NULL,
p_item_relationship_type IN jtf_varchar2_table_100 := NULL,
p_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
p_backorder_flag IN jtf_varchar2_table_100 := NULL,
p_selling_price_change IN jtf_varchar2_table_100 := NULL,
p_recalculate_flag IN jtf_varchar2_table_100 := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_accounting_rule_id IN jtf_number_table := NULL,
p_ffm_content_name IN jtf_varchar2_table_300 := NULL,
p_ffm_content_type IN jtf_varchar2_table_300 := NULL,
p_ffm_document_type IN jtf_varchar2_table_300 := NULL,
p_ffm_media_id IN jtf_varchar2_table_300 := NULL,
p_ffm_media_type IN jtf_varchar2_table_300 := NULL,
p_ffm_user_note IN jtf_varchar2_table_300 := NULL,
p_invoice_to_party_id IN jtf_number_table := NULL,
p_invoice_to_party_site_id IN jtf_number_table := NULL,
p_invoicing_rule_id IN jtf_number_table := NULL,
p_marketing_source_code_id IN jtf_number_table := NULL,
p_operation_code IN jtf_varchar2_table_100 := NULL,
p_invoice_to_cust_account_id IN jtf_number_table := NULL,
p_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
p_minisite_id IN jtf_number_table := NULL,
p_section_id IN jtf_number_table := NULL,
p_priced_price_list_id IN jtf_number_table := NULL,
p_agreement_id IN jtf_number_table := NULL,
p_commitment_id IN jtf_number_table := NULL,
p_display_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
p_invoice_to_cust_party_id IN jtf_number_table := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_ship_model_complete_flag IN jtf_varchar2_table_100 := NULL,
p_charge_periodicity_code IN jtf_varchar2_table_100 := NULL,
p_end_customer_party_id IN jtf_number_table := NULL,
p_end_customer_party_site_id IN jtf_number_table := NULL,
p_end_customer_cust_account_id IN jtf_number_table := NULL,
p_end_customer_cust_party_id IN jtf_number_table := NULL,
p_object_version_number IN jtf_number_table := NULL,
p_line_paynow_charges IN jtf_number_table := NULL,
p_line_paynow_tax IN jtf_number_table := NULL,
p_line_paynow_subtotal IN jtf_number_table := NULL,
p_config_model_type IN jtf_varchar2_table_100 := NULL
)
RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
IS
l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_qte_line_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_qte_line_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_qte_line_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_qte_line_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_qte_line_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_qte_line_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_config_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_config_revision_num IN NUMBER := FND_API.G_MISS_NUM,
p_config_item_id IN NUMBER := FND_API.G_MISS_NUM,
p_complete_configuration IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_valid_configuration_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_component_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_service_coterminate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_service_duration IN NUMBER := FND_API.G_MISS_NUM,
p_service_period IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_service_unit_selling IN NUMBER := FND_API.G_MISS_NUM,
p_service_unit_list IN NUMBER := FND_API.G_MISS_NUM,
p_service_number IN NUMBER := FND_API.G_MISS_NUM,
p_unit_percent_base_price IN NUMBER := FND_API.G_MISS_NUM,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_service_ref_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_service_ref_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_line_number IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_qte_line_ind IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_system_id IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_option_numb IN NUMBER := FND_API.G_MISS_NUM,
p_service_ref_shipment IN NUMBER := FND_API.G_MISS_NUM,
p_return_ref_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_ref_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_return_ref_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_return_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qte_line_index IN NUMBER := FND_API.G_MISS_NUM,
p_return_attr_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_return_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_change_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_top_model_line_index IN NUMBER := FND_API.G_MISS_NUM,
p_ato_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_ato_line_index IN NUMBER := FND_API.G_MISS_NUM,
p_component_sequence_id IN NUMBER := FND_API.G_MISS_NUM,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
)
RETURN ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type
IS
l_qte_line_dtl_rec ASO_Quote_Pub.Qte_Line_Dtl_Rec_Type;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_dtl_rec.last_update_date := FND_API.G_MISS_DATE;
l_qte_line_dtl_rec.last_update_date := p_last_update_date;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_qte_line_dtl_rec.last_updated_by := FND_API.G_MISS_NUM;
l_qte_line_dtl_rec.last_updated_by := p_last_updated_by;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_qte_line_dtl_rec.last_update_login := FND_API.G_MISS_NUM;
l_qte_line_dtl_rec.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_dtl_rec.program_update_date := FND_API.G_MISS_DATE;
l_qte_line_dtl_rec.program_update_date := p_program_update_date;
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_config_header_id IN jtf_number_table := NULL,
p_config_revision_num IN jtf_number_table := NULL,
p_config_item_id IN jtf_number_table := NULL,
p_complete_configuration IN jtf_varchar2_table_100 := NULL,
p_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
p_component_code IN jtf_varchar2_table_1200 := NULL,
p_service_coterminate_flag IN jtf_varchar2_table_100 := NULL,
p_service_duration IN jtf_number_table := NULL,
p_service_period IN jtf_varchar2_table_100 := NULL,
p_service_unit_selling IN jtf_number_table := NULL,
p_service_unit_list IN jtf_number_table := NULL,
p_service_number IN jtf_number_table := NULL,
p_unit_percent_base_price IN jtf_number_table := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_service_ref_type_code IN jtf_varchar2_table_100 := NULL,
p_service_ref_order_number IN jtf_number_table := NULL,
p_service_ref_line_number IN jtf_number_table := NULL,
p_service_ref_qte_line_ind IN jtf_number_table := NULL,
p_service_ref_line_id IN jtf_number_table := NULL,
p_service_ref_system_id IN jtf_number_table := NULL,
p_service_ref_option_numb IN jtf_number_table := NULL,
p_service_ref_shipment IN jtf_number_table := NULL,
p_return_ref_type IN jtf_varchar2_table_100 := NULL,
p_return_ref_header_id IN jtf_number_table := NULL,
p_return_ref_line_id IN jtf_number_table := NULL,
p_return_attribute1 IN jtf_varchar2_table_300 := NULL,
p_return_attribute2 IN jtf_varchar2_table_300 := NULL,
p_return_attribute3 IN jtf_varchar2_table_300 := NULL,
p_return_attribute4 IN jtf_varchar2_table_300 := NULL,
p_return_attribute5 IN jtf_varchar2_table_300 := NULL,
p_return_attribute6 IN jtf_varchar2_table_300 := NULL,
p_return_attribute7 IN jtf_varchar2_table_300 := NULL,
p_return_attribute8 IN jtf_varchar2_table_300 := NULL,
p_return_attribute9 IN jtf_varchar2_table_300 := NULL,
p_return_attribute10 IN jtf_varchar2_table_300 := NULL,
p_return_attribute11 IN jtf_varchar2_table_300 := NULL,
p_return_attribute12 IN jtf_varchar2_table_300 := NULL,
p_return_attribute13 IN jtf_varchar2_table_300 := NULL,
p_return_attribute14 IN jtf_varchar2_table_300 := NULL,
p_return_attribute15 IN jtf_varchar2_table_300 := NULL,
p_operation_code IN jtf_varchar2_table_100 := NULL,
p_qte_line_index IN jtf_number_table := NULL,
p_return_attr_category IN jtf_varchar2_table_100 := NULL,
p_return_reason_code IN jtf_varchar2_table_100 := NULL,
p_change_reason_code IN jtf_varchar2_table_100 := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_top_model_line_id IN jtf_number_table := NULL,
p_top_model_line_index IN jtf_number_table := NULL,
p_ato_line_id IN jtf_number_table := NULL,
p_ato_line_index IN jtf_number_table := NULL,
p_component_sequence_id IN jtf_number_table := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
IS
l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_dtl_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_qte_line_dtl_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_qte_line_dtl_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_qte_line_dtl_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_qte_line_dtl_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_qte_line_dtl_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_line_dtl_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_qte_line_dtl_tbl(i).program_update_date := p_program_update_date(i);
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_date IN jtf_date_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_related_quote_line_id IN jtf_number_table := NULL,
p_relationship_type_code IN jtf_varchar2_table_100 := NULL,
p_reciprocal_flag IN jtf_varchar2_table_100 := NULL,
p_qte_line_index IN jtf_number_table := NULL,
p_related_qte_line_index IN jtf_number_table := NULL,
p_operation_code IN jtf_varchar2_table_100 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
IS
l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_line_rltship_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_line_rltship_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_line_rltship_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_line_rltship_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_line_rltship_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_line_rltship_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_line_rltship_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_line_rltship_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_payment_type_code IN jtf_varchar2_table_100 := NULL,
p_payment_ref_number IN jtf_varchar2_table_300 := NULL,
p_payment_option IN jtf_varchar2_table_300 := NULL,
p_payment_term_id IN jtf_number_table := NULL,
p_credit_card_code IN jtf_varchar2_table_100 := NULL,
p_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
p_credit_card_exp_date IN jtf_date_table := NULL,
p_credit_card_approval_code IN jtf_varchar2_table_100 := NULL,
p_credit_card_approval_date IN jtf_date_table := NULL,
p_payment_amount IN jtf_number_table := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_shipment_index IN jtf_number_table := NULL,
p_quote_shipment_id IN jtf_number_table := NULL,
p_cust_po_number IN jtf_varchar2_table_100 := NULL,
p_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_trxn_extension_id IN jtf_number_table := NULL,
p_instrument_id IN jtf_number_table := NULL,
p_instr_assignment_id IN jtf_number_table := NULL,
p_cvv2 IN jtf_varchar2_table_100 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Payment_Tbl_Type
IS
l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_payment_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_payment_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_payment_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_payment_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_payment_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_payment_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_payment_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_payment_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_payment_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_payment_ref_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_payment_option IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_payment_term_id IN NUMBER := FND_API.G_MISS_NUM,
p_credit_card_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_credit_card_holder_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_credit_card_exp_date IN DATE := FND_API.G_MISS_DATE,
p_credit_card_approval_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_credit_card_approval_date IN DATE := FND_API.G_MISS_DATE,
p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_shipment_index IN NUMBER := FND_API.G_MISS_NUM,
p_quote_shipment_id IN NUMBER := FND_API.G_MISS_NUM,
p_cust_po_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_cust_po_line_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
p_trxn_extension_id IN NUMBER := FND_API.G_MISS_NUM,
p_instrument_id IN NUMBER := FND_API.G_MISS_NUM,
p_instr_assignment_id IN NUMBER := FND_API.G_MISS_NUM,
p_cvv2 IN VARCHAR2 := FND_API.G_MISS_CHAR
)
RETURN ASO_Quote_Pub.Payment_Rec_Type
is
l_payment_rec ASO_Quote_Pub.Payment_Rec_Type;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_payment_rec.last_update_date := FND_API.G_MISS_DATE;
l_payment_rec.last_update_date := p_last_update_date;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_payment_rec.last_updated_by := FND_API.G_MISS_NUM;
l_payment_rec.last_updated_by := p_last_updated_by;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_payment_rec.last_update_login := FND_API.G_MISS_NUM;
l_payment_rec.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_payment_rec.program_update_date := FND_API.G_MISS_DATE;
l_payment_rec.program_update_date := p_program_update_date;
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_promise_date IN DATE := FND_API.G_MISS_DATE,
p_request_date IN DATE := FND_API.G_MISS_DATE,
p_schedule_ship_date IN DATE := FND_API.G_MISS_DATE,
p_ship_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_partial_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_method_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_freight_terms_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_freight_carrier_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_fob_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_shipping_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_packing_instructions IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quantity IN NUMBER := FND_API.G_MISS_NUM,
p_reserved_quantity IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_reservation_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_pricing_quantity IN NUMBER := FND_API.G_MISS_NUM,
p_shipment_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_request_date_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
)
RETURN ASO_Quote_Pub.Shipment_Rec_Type
IS
l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_shipment_rec.last_update_date := FND_API.G_MISS_DATE;
l_shipment_rec.last_update_date := p_last_update_date;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_shipment_rec.last_updated_by := FND_API.G_MISS_NUM;
l_shipment_rec.last_updated_by := p_last_updated_by;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_shipment_rec.last_update_login := FND_API.G_MISS_NUM;
l_shipment_rec.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_shipment_rec.program_update_date := FND_API.G_MISS_DATE;
l_shipment_rec.program_update_date := p_program_update_date;
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_promise_date IN jtf_date_table := NULL,
p_request_date IN jtf_date_table := NULL,
p_schedule_ship_date IN jtf_date_table := NULL,
p_ship_to_party_site_id IN jtf_number_table := NULL,
p_ship_to_party_id IN jtf_number_table := NULL,
p_ship_to_cust_account_id IN jtf_number_table := NULL,
p_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
p_ship_set_id IN jtf_number_table := NULL,
p_ship_method_code IN jtf_varchar2_table_100 := NULL,
p_freight_terms_code IN jtf_varchar2_table_100 := NULL,
p_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
p_fob_code IN jtf_varchar2_table_100 := NULL,
p_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
p_packing_instructions IN jtf_varchar2_table_2000 := NULL,
p_quantity IN jtf_number_table := NULL,
p_reserved_quantity IN jtf_varchar2_table_300 := NULL,
p_reservation_id IN jtf_number_table := NULL,
p_order_line_id IN jtf_number_table := NULL,
p_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
p_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
p_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
p_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
p_ship_to_address1 IN jtf_varchar2_table_300 := NULL,
p_ship_to_address2 IN jtf_varchar2_table_300 := NULL,
p_ship_to_address3 IN jtf_varchar2_table_300 := NULL,
p_ship_to_address4 IN jtf_varchar2_table_300 := NULL,
p_ship_to_country_code IN jtf_varchar2_table_100 := NULL,
p_ship_to_country IN jtf_varchar2_table_100 := NULL,
p_ship_to_city IN jtf_varchar2_table_100 := NULL,
p_ship_to_postal_code IN jtf_varchar2_table_100 := NULL,
p_ship_to_state IN jtf_varchar2_table_100 := NULL,
p_ship_to_province IN jtf_varchar2_table_100 := NULL,
p_ship_to_county IN jtf_varchar2_table_100 := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_ship_quote_price IN jtf_number_table := NULL,
p_pricing_quantity IN jtf_number_table := NULL,
p_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
p_ship_from_org_id IN jtf_number_table := NULL,
p_ship_to_cust_party_id IN jtf_number_table := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_request_date_type IN jtf_varchar2_table_100 := NULL,
p_demand_class_code IN jtf_varchar2_table_100 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Shipment_Tbl_Type
IS
l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_shipment_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_shipment_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_shipment_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_shipment_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_shipment_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_shipment_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_shipment_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_shipment_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_orig_tax_code IN jtf_varchar2_table_300 := NULL,
p_tax_code IN jtf_varchar2_table_100 := NULL,
p_tax_rate IN jtf_number_table := NULL,
p_tax_date IN jtf_date_table := NULL,
p_tax_amount IN jtf_number_table := NULL,
p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_object_version_number IN jtf_number_table := NULL,
p_tax_rate_id IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
IS
l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_tax_detail_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_tax_detail_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_tax_detail_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_tax_detail_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_tax_detail_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_tax_detail_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_tax_detail_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_tax_detail_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_orig_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_rate IN NUMBER := FND_API.G_MISS_NUM,
p_tax_date IN DATE := FND_API.G_MISS_DATE,
p_tax_amount IN NUMBER := FND_API.G_MISS_NUM,
p_tax_exempt_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_exempt_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_exempt_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
p_tax_rate_id IN NUMBER := FND_API.G_MISS_NUM
)
RETURN ASO_Quote_Pub.Tax_Detail_Rec_Type
is
l_tax_detail_rec ASO_Quote_Pub.Tax_Detail_Rec_Type;
IF p_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
l_tax_detail_rec.last_update_date := FND_API.G_MISS_DATE;
l_tax_detail_rec.last_update_date := p_last_update_date;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_tax_detail_rec.last_updated_by := FND_API.G_MISS_NUM;
l_tax_detail_rec.last_updated_by := p_last_updated_by;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_tax_detail_rec.last_update_login := FND_API.G_MISS_NUM;
l_tax_detail_rec.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_tax_detail_rec.program_update_date := FND_API.G_MISS_DATE;
l_tax_detail_rec.program_update_date := p_program_update_date;
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_flex_title IN jtf_varchar2_table_100 := NULL,
p_pricing_context IN jtf_varchar2_table_100 := NULL,
p_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute3 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute4 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute5 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute6 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute7 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute8 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute9 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute10 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute11 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute12 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute13 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute14 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute15 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute16 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute17 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute18 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute19 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute20 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute21 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute22 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute23 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute24 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute25 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute26 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute27 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute28 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute29 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute30 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute31 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute32 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute33 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute34 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute35 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute36 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute37 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute38 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute39 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute40 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute41 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute42 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute43 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute44 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute45 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute46 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute47 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute48 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute49 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute50 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute51 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute52 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute53 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute54 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute55 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute56 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute57 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute58 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute59 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute60 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute61 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute62 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute63 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute64 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute65 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute66 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute67 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute68 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute69 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute70 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute71 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute72 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute73 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute74 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute75 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute76 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute77 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute78 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute79 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute80 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute81 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute82 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute83 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute84 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute85 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute86 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute87 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute88 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute89 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute90 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute91 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute92 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute93 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute94 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute95 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute96 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute97 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute98 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute99 IN jtf_varchar2_table_300 := NULL,
p_pricing_attribute100 IN jtf_varchar2_table_300 := NULL,
p_context IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
IS
l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_price_attributes_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_price_attributes_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_price_attributes_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_price_attributes_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_price_attributes_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_price_attributes_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_price_attributes_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_price_attributes_tbl(i).program_update_date := p_program_update_date(i);
p_last_update_date IN jtf_date_table := NULL,
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_modifier_header_id IN jtf_number_table := NULL,
p_modifier_line_id IN jtf_number_table := NULL,
p_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
p_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
p_modified_from IN jtf_number_table := NULL,
p_modified_to IN jtf_number_table := NULL,
p_operand IN jtf_number_table := NULL,
p_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
p_automatic_flag IN jtf_varchar2_table_100 := NULL,
p_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
p_updated_flag IN jtf_varchar2_table_100 := NULL,
p_applied_flag IN jtf_varchar2_table_100 := NULL,
p_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
p_pricing_phase_id IN jtf_number_table := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_orig_sys_discount_ref IN jtf_varchar2_table_100 := NULL,
p_change_sequence IN jtf_varchar2_table_100 := NULL,
p_update_allowed IN jtf_varchar2_table_100 := NULL,
p_change_reason_code IN jtf_varchar2_table_100 := NULL,
p_change_reason_text IN jtf_varchar2_table_2000 := NULL,
p_cost_id IN jtf_number_table := NULL,
p_tax_code IN jtf_varchar2_table_100 := NULL,
p_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
p_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
p_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
p_parent_adjustment_id IN jtf_number_table := NULL,
p_invoiced_flag IN jtf_varchar2_table_100 := NULL,
p_estimated_flag IN jtf_varchar2_table_100 := NULL,
p_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
p_split_action_code IN jtf_varchar2_table_100 := NULL,
p_adjusted_amount IN jtf_number_table := NULL,
p_charge_type_code IN jtf_varchar2_table_100 := NULL,
p_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
p_range_break_quantity IN jtf_number_table := NULL,
p_accrual_conv_rate IN jtf_number_table := NULL,
p_pricing_group_sequence IN jtf_number_table := NULL,
p_accrual_flag IN jtf_varchar2_table_100 := NULL,
p_list_line_no IN jtf_varchar2_table_300 := NULL,
p_source_system_code IN jtf_varchar2_table_100 := NULL,
p_benefit_qty IN jtf_number_table := NULL,
p_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
p_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
p_expiration_date IN jtf_date_table := NULL,
p_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
p_rebate_trans_reference IN jtf_varchar2_table_100 := NULL,
p_rebate_pay_system_code IN jtf_varchar2_table_100 := NULL,
p_redeemed_date IN jtf_date_table := NULL,
p_redeemed_flag IN jtf_varchar2_table_100 := NULL,
p_modifier_level_code IN jtf_varchar2_table_100 := NULL,
p_price_break_type_code IN jtf_varchar2_table_100 := NULL,
p_substitution_attribute IN jtf_varchar2_table_100 := NULL,
p_proration_type_code IN jtf_varchar2_table_100 := NULL,
p_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
p_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
p_shipment_index IN jtf_number_table := NULL,
p_quote_shipment_id IN jtf_number_table := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
IS
l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_price_adj_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_price_adj_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_price_adj_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_price_adj_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_price_adj_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_price_adj_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_price_adj_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_price_adj_tbl(i).program_update_date := p_program_update_date(i);
IF p_update_allowable_flag IS NOT NULL THEN
l_price_adj_tbl(i).update_allowable_flag := p_update_allowable_flag(i);
IF p_updated_flag IS NOT NULL THEN
l_price_adj_tbl(i).updated_flag := p_updated_flag(i);
IF p_update_allowed IS NOT NULL THEN
l_price_adj_tbl(i).update_allowed := p_update_allowed(i);
p_last_updated_by IN jtf_varchar2_table_300 := NULL,
p_last_update_date IN jtf_date_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_percent IN jtf_number_table := NULL,
p_resource_id IN jtf_number_table := NULL,
p_first_name IN jtf_varchar2_table_300 := NULL,
p_last_name IN jtf_varchar2_table_300 := NULL,
p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
p_resource_group_id IN jtf_number_table := NULL,
p_employee_person_id IN jtf_number_table := NULL,
p_sales_credit_type_id IN jtf_number_table := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
p_credit_rule_id IN jtf_number_table := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_object_version_number IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type
IS
l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
IF p_last_updated_by IS NOT NULL THEN
l_sales_credit_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_sales_credit_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_sales_credit_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_sales_credit_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_sales_credit_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_sales_credit_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_sales_credit_tbl(i).program_update_date := p_program_update_date(i);
p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
p_org_id IN NUMBER := FND_API.G_MISS_NUM
)
RETURN ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type
IS
l_opp_qte_in ASO_Opp_Qte_Pub.Opp_Qte_In_Rec_Type;
IF p_price_updated_date = ROSETTA_G_MISTAKE_DATE THEN
l_opp_qte_in.price_updated_date := FND_API.G_MISS_DATE;
l_opp_qte_in.price_updated_date := p_price_updated_date;
IF p_tax_updated_date = ROSETTA_G_MISTAKE_DATE THEN
l_opp_qte_in.tax_updated_date := FND_API.G_MISS_DATE;
l_opp_qte_in.tax_updated_date := p_tax_updated_date;
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_last_update_date IN jtf_date_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_keep_flag IN jtf_varchar2_table_100 := NULL,
p_update_access_flag IN jtf_varchar2_table_100 := NULL,
p_created_by_tap_flag IN jtf_varchar2_table_100 := NULL,
p_role_id IN jtf_number_table := NULL,
p_territory_id IN jtf_number_table := NULL,
p_territory_source_flag IN jtf_varchar2_table_100 := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL,
p_attribute16 IN jtf_varchar2_table_300 := NULL,
p_attribute17 IN jtf_varchar2_table_300 := NULL,
p_attribute18 IN jtf_varchar2_table_300 := NULL,
p_attribute19 IN jtf_varchar2_table_300 := NULL,
p_attribute20 IN jtf_varchar2_table_300 := NULL,
p_object_version_number IN jtf_number_table := NULL,
p_batch_price_flag IN jtf_varchar2_table_100 := NULL,
p_operation_code IN jtf_varchar2_table_100 := NULL
)
RETURN ASO_QUOTE_PUB.Qte_Access_Tbl_Type
IS
l_qte_access_tbl ASO_QUOTE_PUB.Qte_Access_Tbl_Type;
IF p_last_update_date IS NOT NULL THEN
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_access_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_qte_access_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_updated_by IS NOT NULL THEN
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_qte_access_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_qte_access_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_login IS NOT NULL THEN
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_qte_access_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_qte_access_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date IS NOT NULL THEN
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_qte_access_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_qte_access_tbl(i).program_update_date := p_program_update_date(i);
IF p_update_access_flag IS NOT NULL THEN
l_qte_access_tbl(i).update_access_flag := p_update_access_flag(i);
p_price_updated_date IN DATE := FND_API.G_MISS_DATE,
p_tax_updated_date IN DATE := FND_API.G_MISS_DATE
)
RETURN ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type
IS
l_copy_qte_hdr ASO_Copy_Quote_Pub.Copy_Quote_Header_Rec_Type;
IF p_price_updated_date= ROSETTA_G_MISTAKE_DATE THEN
l_copy_qte_hdr.price_updated_date := FND_API.G_MISS_DATE;
l_copy_qte_hdr.price_updated_date := p_price_updated_date;
IF p_tax_updated_date= ROSETTA_G_MISTAKE_DATE THEN
l_copy_qte_hdr.tax_updated_date := FND_API.G_MISS_DATE;
l_copy_qte_hdr.tax_updated_date := p_tax_updated_date;
p_last_update_date DATE := FND_API.G_MISS_DATE,
p_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
p_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_functionality_code VARCHAR2 := FND_API.G_MISS_CHAR,
p_copy_task_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_copy_notes_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_copy_att_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_deactivate_all VARCHAR2 := FND_API.G_MISS_CHAR,
p_price_mode VARCHAR2 := FND_API.G_MISS_CHAR,
p_dependency_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_defaulting_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_defaulting_fwk_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_application_type_code VARCHAR2 := FND_API.G_MISS_CHAR,
x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
)
IS
BEGIN
IF p_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
x_control_rec.last_update_date := FND_API.G_MISS_DATE;
x_control_rec.last_update_date := p_last_update_date;
p_dc_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_dc_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
x_def_control_rec OUT NOCOPY ASO_Defaulting_Int.Control_Rec_Type
)
IS
BEGIN
x_def_control_rec.override_Trigger_Flag := p_dc_override_Trigger_Flag;
IF p_dc_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
x_def_control_rec.last_update_date := FND_API.G_MISS_DATE;
x_def_control_rec.last_update_date := p_dc_last_update_date;
x_last_update_date OUT NOCOPY jtf_date_table
/*-- The following output parameters are ignored
x_creation_date OUT NOCOPY jtf_date_table,
x_created_by OUT NOCOPY jtf_number_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_org_id OUT NOCOPY jtf_number_table,
x_quote_name OUT NOCOPY jtf_varchar2_table_100,
x_quote_number OUT NOCOPY jtf_number_table,
x_quote_version OUT NOCOPY jtf_number_table,
x_quote_status_id OUT NOCOPY jtf_number_table,
x_quote_source_code OUT NOCOPY jtf_varchar2_table_300,
x_quote_expiration_date OUT NOCOPY jtf_date_table,
x_price_frozen_date OUT NOCOPY jtf_date_table,
x_quote_password OUT NOCOPY jtf_varchar2_table_300,
x_original_system_reference OUT NOCOPY jtf_varchar2_table_300,
x_party_id OUT NOCOPY jtf_number_table,
x_cust_account_id OUT NOCOPY jtf_number_table,
x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
x_org_contact_id OUT NOCOPY jtf_number_table,
x_phone_id OUT NOCOPY jtf_number_table,
x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
x_invoice_to_party_id OUT NOCOPY jtf_number_table,
x_orig_mktg_source_code_id OUT NOCOPY jtf_number_table,
x_marketing_source_code_id OUT NOCOPY jtf_number_table,
x_order_type_id OUT NOCOPY jtf_number_table,
x_quote_category_code OUT NOCOPY jtf_varchar2_table_300,
x_ordered_date OUT NOCOPY jtf_date_table,
x_accounting_rule_id OUT NOCOPY jtf_number_table,
x_invoicing_rule_id OUT NOCOPY jtf_number_table,
x_employee_person_id OUT NOCOPY jtf_number_table,
x_price_list_id OUT NOCOPY jtf_number_table,
x_currency_code OUT NOCOPY jtf_varchar2_table_100,
x_total_list_price OUT NOCOPY jtf_number_table,
x_total_adjusted_amount OUT NOCOPY jtf_number_table,
x_total_adjusted_percent OUT NOCOPY jtf_number_table,
x_total_tax OUT NOCOPY jtf_number_table,
x_total_shipping_charge OUT NOCOPY jtf_number_table,
x_surcharge OUT NOCOPY jtf_number_table,
x_total_quote_price OUT NOCOPY jtf_number_table,
x_payment_amount OUT NOCOPY jtf_number_table,
x_exchange_rate OUT NOCOPY jtf_number_table,
x_exchange_type_code OUT NOCOPY jtf_varchar2_table_100,
x_exchange_rate_date OUT NOCOPY jtf_date_table,
x_contract_id OUT NOCOPY jtf_number_table,
x_sales_channel_code OUT NOCOPY jtf_varchar2_table_100,
x_order_id OUT NOCOPY jtf_number_table,
x_order_number OUT NOCOPY jtf_number_table,
x_ffm_request_id OUT NOCOPY jtf_number_table,
x_qte_contract_id OUT NOCOPY jtf_number_table,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_salesrep_first_name OUT NOCOPY jtf_varchar2_table_300,
x_salesrep_last_name OUT NOCOPY jtf_varchar2_table_300,
x_price_list_name OUT NOCOPY jtf_varchar2_table_300,
x_quote_status_code OUT NOCOPY jtf_varchar2_table_100,
x_quote_status OUT NOCOPY jtf_varchar2_table_300,
x_party_name OUT NOCOPY jtf_varchar2_table_300,
x_party_type OUT NOCOPY jtf_varchar2_table_100,
x_person_first_name OUT NOCOPY jtf_varchar2_table_200,
x_person_middle_name OUT NOCOPY jtf_varchar2_table_100,
x_person_last_name OUT NOCOPY jtf_varchar2_table_200,
x_marketing_source_name OUT NOCOPY jtf_varchar2_table_200,
x_marketing_source_code OUT NOCOPY jtf_varchar2_table_200,
x_order_type_name OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_party_name OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
x_invoice_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
x_invoice_to_address1 OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_address2 OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_address3 OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_address4 OUT NOCOPY jtf_varchar2_table_300,
x_invoice_to_country_code OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_country OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_city OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_state OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_province OUT NOCOPY jtf_varchar2_table_100,
x_invoice_to_county OUT NOCOPY jtf_varchar2_table_100,
x_resource_id OUT NOCOPY jtf_number_table
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_header_tbl.count);
x_last_updated_by.extend(p_qte_header_tbl.count);
x_last_update_login.extend(p_qte_header_tbl.count);
x_program_update_date.extend(p_qte_header_tbl.count);
x_last_update_date(indx) := p_qte_header_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_header_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_header_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_header_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_org_id OUT NOCOPY jtf_number_table,
x_line_category_code OUT NOCOPY jtf_varchar2_table_100,
x_item_type_code OUT NOCOPY jtf_varchar2_table_100,
x_line_number OUT NOCOPY jtf_number_table,
x_start_date_active OUT NOCOPY jtf_date_table,
x_end_date_active OUT NOCOPY jtf_date_table,
x_order_line_type_id OUT NOCOPY jtf_number_table,
x_invoice_to_party_site_id OUT NOCOPY jtf_number_table,
x_invoice_to_party_id OUT NOCOPY jtf_number_table,
x_invoice_to_cust_account_id OUT NOCOPY jtf_number_table,
x_organization_id OUT NOCOPY jtf_number_table,
x_inventory_item_id OUT NOCOPY jtf_number_table,
x_quantity OUT NOCOPY jtf_number_table,
x_uom_code OUT NOCOPY jtf_varchar2_table_100,
x_pricing_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
x_marketing_source_code_id OUT NOCOPY jtf_number_table,
x_price_list_id OUT NOCOPY jtf_number_table,
x_price_list_line_id OUT NOCOPY jtf_number_table,
x_currency_code OUT NOCOPY jtf_varchar2_table_100,
x_line_list_price OUT NOCOPY jtf_number_table,
x_line_adjusted_amount OUT NOCOPY jtf_number_table,
x_line_adjusted_percent OUT NOCOPY jtf_number_table,
x_line_quote_price OUT NOCOPY jtf_number_table,
x_related_item_id OUT NOCOPY jtf_number_table,
x_item_relationship_type OUT NOCOPY jtf_varchar2_table_100,
x_accounting_rule_id OUT NOCOPY jtf_number_table,
x_invoicing_rule_id OUT NOCOPY jtf_number_table,
x_split_shipment_flag OUT NOCOPY jtf_varchar2_table_100,
x_backorder_flag OUT NOCOPY jtf_varchar2_table_100,
x_minisite_id OUT NOCOPY jtf_number_table,
x_section_id OUT NOCOPY jtf_number_table,
x_selling_price_change OUT NOCOPY jtf_varchar2_table_100,
x_recalculate_flag OUT NOCOPY jtf_varchar2_table_100,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_ffm_content_name OUT NOCOPY jtf_varchar2_table_300,
x_ffm_document_type OUT NOCOPY jtf_varchar2_table_300,
x_ffm_media_type OUT NOCOPY jtf_varchar2_table_300,
x_ffm_media_id OUT NOCOPY jtf_varchar2_table_300,
x_ffm_content_type OUT NOCOPY jtf_varchar2_table_300,
x_ffm_user_note OUT NOCOPY jtf_varchar2_table_300
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_line_tbl.count);
x_last_updated_by.extend(p_qte_line_tbl.count);
x_last_update_login.extend(p_qte_line_tbl.count);
x_program_update_date.extend(p_qte_line_tbl.count);
x_last_update_date(indx) := p_qte_line_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_line_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_line_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_line_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_config_header_id OUT NOCOPY jtf_number_table,
x_config_revision_num OUT NOCOPY jtf_number_table,
x_config_item_id OUT NOCOPY jtf_number_table,
x_complete_configuration OUT NOCOPY jtf_varchar2_table_100,
x_valid_configuration_flag OUT NOCOPY jtf_varchar2_table_100,
x_component_code OUT NOCOPY jtf_varchar2_table_1200,
x_service_coterminate_flag OUT NOCOPY jtf_varchar2_table_100,
x_service_duration OUT NOCOPY jtf_number_table,
x_service_period OUT NOCOPY jtf_varchar2_table_100,
x_service_unit_selling OUT NOCOPY jtf_number_table,
x_service_unit_list OUT NOCOPY jtf_number_table,
x_service_number OUT NOCOPY jtf_number_table,
x_unit_percent_base_price OUT NOCOPY jtf_number_table,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_service_ref_type_code OUT NOCOPY jtf_varchar2_table_100,
x_service_ref_order_number OUT NOCOPY jtf_number_table,
x_service_ref_line_number OUT NOCOPY jtf_number_table,
x_service_ref_qte_line_ind OUT NOCOPY jtf_number_table,
x_service_ref_line_id OUT NOCOPY jtf_number_table,
x_service_ref_system_id OUT NOCOPY jtf_number_table,
x_service_ref_option_numb OUT NOCOPY jtf_number_table,
x_service_ref_shipment OUT NOCOPY jtf_number_table,
x_return_ref_type OUT NOCOPY jtf_varchar2_table_100,
x_return_ref_header_id OUT NOCOPY jtf_number_table,
x_return_ref_line_id OUT NOCOPY jtf_number_table,
x_return_attribute1 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute2 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute3 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute4 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute5 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute6 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute7 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute8 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute9 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute10 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute11 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute15 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute12 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute13 OUT NOCOPY jtf_varchar2_table_300,
x_return_attribute14 OUT NOCOPY jtf_varchar2_table_300,
x_return_attr_category OUT NOCOPY jtf_varchar2_table_100,
x_return_reason_code OUT NOCOPY jtf_varchar2_table_100,
x_change_reason_code OUT NOCOPY jtf_varchar2_table_100
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_line_dtl_tbl.count);
x_last_updated_by.extend(p_qte_line_dtl_tbl.count);
x_last_update_login.extend(p_qte_line_dtl_tbl.count);
x_program_update_date.extend(p_qte_line_dtl_tbl.count);
x_last_update_date(indx) := p_qte_line_dtl_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_line_dtl_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_line_dtl_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_line_dtl_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_qte_line_index OUT NOCOPY jtf_number_table,
x_related_quote_line_id OUT NOCOPY jtf_number_table,
x_related_qte_line_index OUT NOCOPY jtf_number_table,
x_relationship_type_code OUT NOCOPY jtf_varchar2_table_100,
x_reciprocal_flag OUT NOCOPY jtf_varchar2_table_100
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_line_rltship_tbl.count);
x_last_updated_by.extend(p_qte_line_rltship_tbl.count);
x_last_update_login.extend(p_qte_line_rltship_tbl.count);
x_program_update_date.extend(p_qte_line_rltship_tbl.count);
x_last_update_date(indx) := p_qte_line_rltship_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_line_rltship_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_line_rltship_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_line_rltship_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_quote_shipment_id OUT NOCOPY jtf_number_table,
x_payment_type_code OUT NOCOPY jtf_varchar2_table_100,
x_payment_ref_number OUT NOCOPY jtf_varchar2_table_300,
x_payment_option OUT NOCOPY jtf_varchar2_table_300,
x_payment_term_id OUT NOCOPY jtf_number_table,
x_credit_card_code OUT NOCOPY jtf_varchar2_table_100,
x_credit_card_holder_name OUT NOCOPY jtf_varchar2_table_100,
x_credit_card_exp_date OUT NOCOPY jtf_date_table,
x_credit_card_approval_code OUT NOCOPY jtf_varchar2_table_100,
x_credit_card_approval_date OUT NOCOPY jtf_date_table,
x_payment_amount OUT NOCOPY jtf_number_table,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_cust_po_number OUT NOCOPY jtf_varchar2_table_100
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_payment_tbl.count);
x_last_updated_by.extend(p_qte_payment_tbl.count);
x_last_update_login.extend(p_qte_payment_tbl.count);
x_program_update_date.extend(p_qte_payment_tbl.count);
x_last_update_date(indx) := p_qte_payment_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_payment_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_payment_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_payment_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_promise_date OUT NOCOPY jtf_date_table,
x_request_date OUT NOCOPY jtf_date_table,
x_schedule_ship_date OUT NOCOPY jtf_date_table,
x_ship_to_party_site_id OUT NOCOPY jtf_number_table,
x_ship_to_party_id OUT NOCOPY jtf_number_table,
x_ship_to_cust_account_id OUT NOCOPY jtf_number_table,
x_ship_partial_flag OUT NOCOPY jtf_varchar2_table_300,
x_ship_set_id OUT NOCOPY jtf_number_table,
x_ship_method_code OUT NOCOPY jtf_varchar2_table_100,
x_freight_terms_code OUT NOCOPY jtf_varchar2_table_100,
x_freight_carrier_code OUT NOCOPY jtf_varchar2_table_100,
x_fob_code OUT NOCOPY jtf_varchar2_table_100,
x_shipping_instructions OUT NOCOPY jtf_varchar2_table_2000,
x_packing_instructions OUT NOCOPY jtf_varchar2_table_2000,
x_ship_quote_price OUT NOCOPY jtf_number_table,
x_quantity OUT NOCOPY jtf_number_table,
x_pricing_quantity OUT NOCOPY jtf_number_table,
x_reserved_quantity OUT NOCOPY jtf_varchar2_table_300,
x_reservation_id OUT NOCOPY jtf_number_table,
x_order_line_id OUT NOCOPY jtf_number_table,
x_ship_to_party_name OUT NOCOPY jtf_varchar2_table_300,
x_ship_to_cont_first_name OUT NOCOPY jtf_varchar2_table_200,
x_ship_to_cont_mid_name OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_cont_last_name OUT NOCOPY jtf_varchar2_table_200,
x_ship_to_address1 OUT NOCOPY jtf_varchar2_table_300,
x_ship_to_address2 OUT NOCOPY jtf_varchar2_table_300,
x_ship_to_address3 OUT NOCOPY jtf_varchar2_table_300,
x_ship_to_address4 OUT NOCOPY jtf_varchar2_table_300,
x_ship_to_country_code OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_country OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_city OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_postal_code OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_state OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_province OUT NOCOPY jtf_varchar2_table_100,
x_ship_to_county OUT NOCOPY jtf_varchar2_table_100,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_shipment_priority_code OUT NOCOPY jtf_varchar2_table_100,
x_ship_from_org_id OUT NOCOPY jtf_number_table
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_shipment_tbl.count);
x_last_updated_by.extend(p_qte_shipment_tbl.count);
x_last_update_login.extend(p_qte_shipment_tbl.count);
x_program_update_date.extend(p_qte_shipment_tbl.count);
x_last_update_date(indx) := p_qte_shipment_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_shipment_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_shipment_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_shipment_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_orig_tax_code OUT NOCOPY jtf_varchar2_table_300,
x_tax_code OUT NOCOPY jtf_varchar2_table_100,
x_tax_rate OUT NOCOPY jtf_number_table,
x_tax_date OUT NOCOPY jtf_date_table,
x_tax_amount OUT NOCOPY jtf_number_table,
x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_tax_detail_tbl.count);
x_last_updated_by.extend(p_qte_tax_detail_tbl.count);
x_last_update_login.extend(p_qte_tax_detail_tbl.count);
x_program_update_date.extend(p_qte_tax_detail_tbl.count);
x_last_update_date(indx) := p_qte_tax_detail_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_tax_detail_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_tax_detail_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_tax_detail_tbl(ddindx).program_update_date;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_request_id OUT NOCOPY jtf_number_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_quote_shipment_id OUT NOCOPY jtf_number_table,
x_modifier_header_id OUT NOCOPY jtf_number_table,
x_modifier_line_id OUT NOCOPY jtf_number_table,
x_modifier_line_type_code OUT NOCOPY jtf_varchar2_table_100,
x_modifier_mechanism_type_code OUT NOCOPY jtf_varchar2_table_100,
x_modified_from OUT NOCOPY jtf_number_table,
x_modified_to OUT NOCOPY jtf_number_table,
x_operand OUT NOCOPY jtf_number_table,
x_arithmetic_operator OUT NOCOPY jtf_varchar2_table_100,
x_automatic_flag OUT NOCOPY jtf_varchar2_table_100,
x_update_allowable_flag OUT NOCOPY jtf_varchar2_table_100,
x_updated_flag OUT NOCOPY jtf_varchar2_table_100,
x_applied_flag OUT NOCOPY jtf_varchar2_table_100,
x_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
x_pricing_phase_id OUT NOCOPY jtf_number_table,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_orig_sys_discount_ref OUT NOCOPY jtf_varchar2_table_100,
x_change_sequence OUT NOCOPY jtf_varchar2_table_100,
x_update_allowed OUT NOCOPY jtf_varchar2_table_100,
x_change_reason_code OUT NOCOPY jtf_varchar2_table_100,
x_change_reason_text OUT NOCOPY jtf_varchar2_table_2000,
x_cost_id OUT NOCOPY jtf_number_table,
x_tax_code OUT NOCOPY jtf_varchar2_table_100,
x_tax_exempt_flag OUT NOCOPY jtf_varchar2_table_100,
x_tax_exempt_number OUT NOCOPY jtf_varchar2_table_100,
x_tax_exempt_reason_code OUT NOCOPY jtf_varchar2_table_100,
x_parent_adjustment_id OUT NOCOPY jtf_number_table,
x_invoiced_flag OUT NOCOPY jtf_varchar2_table_100,
x_estimated_flag OUT NOCOPY jtf_varchar2_table_100,
x_inc_in_sales_performance OUT NOCOPY jtf_varchar2_table_100,
x_split_action_code OUT NOCOPY jtf_varchar2_table_100,
x_adjusted_amount OUT NOCOPY jtf_number_table,
x_charge_type_code OUT NOCOPY jtf_varchar2_table_100,
x_charge_subtype_code OUT NOCOPY jtf_varchar2_table_100,
x_range_break_quantity OUT NOCOPY jtf_number_table,
x_accrual_conversion_rate OUT NOCOPY jtf_number_table,
x_pricing_group_sequence OUT NOCOPY jtf_number_table,
x_accrual_flag OUT NOCOPY jtf_varchar2_table_100,
x_list_line_no OUT NOCOPY jtf_varchar2_table_300,
x_source_system_code OUT NOCOPY jtf_varchar2_table_100,
x_benefit_qty OUT NOCOPY jtf_number_table,
x_benefit_uom_code OUT NOCOPY jtf_varchar2_table_100,
x_print_on_invoice_flag OUT NOCOPY jtf_varchar2_table_100,
x_expiration_date OUT NOCOPY jtf_date_table,
x_rebate_transaction_type_code OUT NOCOPY jtf_varchar2_table_100,
x_rebate_transaction_reference OUT NOCOPY jtf_varchar2_table_100,
x_rebate_payment_system_code OUT NOCOPY jtf_varchar2_table_100,
x_redeemed_date OUT NOCOPY jtf_date_table,
x_redeemed_flag OUT NOCOPY jtf_varchar2_table_100,
x_modifier_level_code OUT NOCOPY jtf_varchar2_table_100,
x_price_break_type_code OUT NOCOPY jtf_varchar2_table_100,
x_substitution_attribute OUT NOCOPY jtf_varchar2_table_100,
x_proration_type_code OUT NOCOPY jtf_varchar2_table_100,
x_include_on_returns_flag OUT NOCOPY jtf_varchar2_table_100,
x_credit_or_charge_flag OUT NOCOPY jtf_varchar2_table_100
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_update_allowable_flag := jtf_varchar2_table_100();
x_updated_flag := jtf_varchar2_table_100();
x_update_allowed := jtf_varchar2_table_100();
x_last_update_date.extend(p_qte_price_adj_tbl.count);
x_last_updated_by.extend(p_qte_price_adj_tbl.count);
x_last_update_login.extend(p_qte_price_adj_tbl.count);
x_program_update_date.extend(p_qte_price_adj_tbl.count);
x_update_allowable_flag.extend(p_qte_price_adj_tbl.count);
x_updated_flag.extend(p_qte_price_adj_tbl.count);
x_update_allowed.extend(p_qte_price_adj_tbl.count);
x_last_update_date(indx) := p_qte_price_adj_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_price_adj_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_price_adj_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_price_adj_tbl(ddindx).program_update_date;
x_update_allowable_flag(indx) := p_qte_price_adj_tbl(ddindx).update_allowable_flag;
x_updated_flag(indx) := p_qte_price_adj_tbl(ddindx).updated_flag;
x_update_allowed(indx) := p_qte_price_adj_tbl(ddindx).update_allowed;
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_flex_title OUT NOCOPY jtf_varchar2_table_100,
x_pricing_context OUT NOCOPY jtf_varchar2_table_100,
x_pricing_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute15 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute16 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute17 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute18 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute19 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute20 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute21 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute22 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute23 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute24 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute25 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute26 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute27 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute28 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute29 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute30 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute31 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute32 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute33 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute34 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute35 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute36 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute37 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute38 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute39 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute40 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute41 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute42 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute43 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute44 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute45 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute46 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute47 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute48 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute49 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute50 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute51 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute52 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute53 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute54 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute55 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute56 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute57 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute58 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute59 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute60 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute61 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute62 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute63 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute64 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute65 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute66 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute67 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute68 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute69 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute70 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute71 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute72 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute73 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute74 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute75 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute76 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute77 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute78 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute79 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute80 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute81 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute82 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute83 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute84 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute85 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute86 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute87 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute88 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute89 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute90 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute91 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute92 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute93 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute94 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute95 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute96 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute97 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute98 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute99 OUT NOCOPY jtf_varchar2_table_200,
x_pricing_attribute100 OUT NOCOPY jtf_varchar2_table_200,
x_context OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_200,
x_attribute2 OUT NOCOPY jtf_varchar2_table_200,
x_attribute3 OUT NOCOPY jtf_varchar2_table_200,
x_attribute4 OUT NOCOPY jtf_varchar2_table_200,
x_attribute5 OUT NOCOPY jtf_varchar2_table_200,
x_attribute6 OUT NOCOPY jtf_varchar2_table_200,
x_attribute7 OUT NOCOPY jtf_varchar2_table_200,
x_attribute8 OUT NOCOPY jtf_varchar2_table_200,
x_attribute9 OUT NOCOPY jtf_varchar2_table_200,
x_attribute10 OUT NOCOPY jtf_varchar2_table_200,
x_attribute11 OUT NOCOPY jtf_varchar2_table_200,
x_attribute12 OUT NOCOPY jtf_varchar2_table_200,
x_attribute13 OUT NOCOPY jtf_varchar2_table_200,
x_attribute14 OUT NOCOPY jtf_varchar2_table_200,
x_attribute15 OUT NOCOPY jtf_varchar2_table_200
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_update_date := jtf_date_table();
x_last_updated_by := jtf_number_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_update_date.extend(p_qte_price_attributes_tbl.count);
x_last_updated_by.extend(p_qte_price_attributes_tbl.count);
x_last_update_login.extend(p_qte_price_attributes_tbl.count);
x_program_update_date.extend(p_qte_price_attributes_tbl.count);
x_last_update_date(indx) := p_qte_price_attributes_tbl(ddindx).last_update_date;
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_price_attributes_tbl(ddindx).last_updated_by);
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_price_attributes_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_price_attributes_tbl(ddindx).program_update_date;
x_last_updated_by OUT NOCOPY jtf_number_table,
x_last_update_date OUT NOCOPY jtf_date_table,
x_last_update_login OUT NOCOPY jtf_number_table,
x_request_id OUT NOCOPY jtf_number_table,
x_program_application_id OUT NOCOPY jtf_number_table,
x_program_id OUT NOCOPY jtf_number_table,
x_program_update_date OUT NOCOPY jtf_date_table,
x_quote_header_id OUT NOCOPY jtf_number_table,
x_quote_line_id OUT NOCOPY jtf_number_table,
x_percent OUT NOCOPY jtf_number_table,
x_resource_id OUT NOCOPY jtf_number_table,
x_first_name OUT NOCOPY jtf_varchar2_table_300,
x_last_name OUT NOCOPY jtf_varchar2_table_300,
x_sales_credit_type OUT NOCOPY jtf_varchar2_table_300,
x_resource_group_id OUT NOCOPY jtf_number_table,
x_employee_person_id OUT NOCOPY jtf_number_table,
x_sales_credit_type_id OUT NOCOPY jtf_number_table,
x_attribute_category OUT NOCOPY jtf_varchar2_table_100,
x_attribute1 OUT NOCOPY jtf_varchar2_table_300,
x_attribute2 OUT NOCOPY jtf_varchar2_table_300,
x_attribute3 OUT NOCOPY jtf_varchar2_table_300,
x_attribute4 OUT NOCOPY jtf_varchar2_table_300,
x_attribute5 OUT NOCOPY jtf_varchar2_table_300,
x_attribute6 OUT NOCOPY jtf_varchar2_table_300,
x_attribute7 OUT NOCOPY jtf_varchar2_table_300,
x_attribute8 OUT NOCOPY jtf_varchar2_table_300,
x_attribute9 OUT NOCOPY jtf_varchar2_table_300,
x_attribute10 OUT NOCOPY jtf_varchar2_table_300,
x_attribute11 OUT NOCOPY jtf_varchar2_table_300,
x_attribute12 OUT NOCOPY jtf_varchar2_table_300,
x_attribute13 OUT NOCOPY jtf_varchar2_table_300,
x_attribute14 OUT NOCOPY jtf_varchar2_table_300,
x_attribute15 OUT NOCOPY jtf_varchar2_table_300
--*/
)
AS
ddindx binary_integer; indx binary_integer;
x_last_updated_by := jtf_number_table();
x_last_update_date := jtf_date_table();
x_last_update_login := jtf_number_table();
x_program_update_date := jtf_date_table();
x_last_updated_by.extend(p_qte_sales_credit_tbl.count);
x_last_update_date.extend(p_qte_sales_credit_tbl.count);
x_last_update_login.extend(p_qte_sales_credit_tbl.count);
x_program_update_date.extend(p_qte_sales_credit_tbl.count);
x_last_updated_by(indx) := rosetta_g_miss_num_map(p_qte_sales_credit_tbl(ddindx).last_updated_by);
x_last_update_date(indx) := p_qte_sales_credit_tbl(ddindx).last_update_date;
x_last_update_login(indx) := rosetta_g_miss_num_map(p_qte_sales_credit_tbl(ddindx).last_update_login);
x_program_update_date(indx) := p_qte_sales_credit_tbl(ddindx).program_update_date;
Select decode(orig_system, 'FND_USR', orig_system_id, 'PER', a.user_id, NULL) user_id
From wf_roles b, wf_notifications c, fnd_user a
Where b.name = c.recipient_role
And c.notification_id = c_notif_id
And a.employee_id (+) = b.ORIG_SYSTEM_ID;
x_q_last_updated_by OUT NOCOPY NUMBER,
x_q_last_update_date OUT NOCOPY DATE,
x_q_last_update_login OUT NOCOPY NUMBER,
x_q_request_id OUT NOCOPY NUMBER,
x_q_program_application_id OUT NOCOPY NUMBER,
x_q_program_id OUT NOCOPY NUMBER,
x_q_program_update_date OUT NOCOPY DATE,
x_q_org_id OUT NOCOPY NUMBER,
x_q_quote_name OUT NOCOPY VARCHAR2,
x_q_quote_number OUT NOCOPY NUMBER,
x_q_quote_version OUT NOCOPY NUMBER,
x_q_quote_status_id OUT NOCOPY NUMBER,
x_q_quote_source_code OUT NOCOPY VARCHAR2,
x_q_quote_expiration_date OUT NOCOPY DATE,
x_q_price_frozen_date OUT NOCOPY DATE,
x_q_quote_password OUT NOCOPY VARCHAR2,
x_q_original_system_reference OUT NOCOPY VARCHAR2,
x_q_party_id OUT NOCOPY NUMBER,
x_q_cust_account_id OUT NOCOPY NUMBER,
x_q_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
x_q_org_contact_id OUT NOCOPY NUMBER,
x_q_party_name OUT NOCOPY VARCHAR2,
x_q_party_type OUT NOCOPY VARCHAR2,
x_q_person_first_name OUT NOCOPY VARCHAR2,
x_q_person_last_name OUT NOCOPY VARCHAR2,
x_q_person_middle_name OUT NOCOPY VARCHAR2,
x_q_phone_id OUT NOCOPY NUMBER,
x_q_price_list_id OUT NOCOPY NUMBER,
x_q_price_list_name OUT NOCOPY VARCHAR2,
x_q_currency_code OUT NOCOPY VARCHAR2,
x_q_total_list_price OUT NOCOPY NUMBER,
x_q_total_adjusted_amount OUT NOCOPY NUMBER,
x_q_total_adjusted_percent OUT NOCOPY NUMBER,
x_q_total_tax OUT NOCOPY NUMBER,
x_q_total_shipping_charge OUT NOCOPY NUMBER,
x_q_surcharge OUT NOCOPY NUMBER,
x_q_total_quote_price OUT NOCOPY NUMBER,
x_q_payment_amount OUT NOCOPY NUMBER,
x_q_accounting_rule_id OUT NOCOPY NUMBER,
x_q_exchange_rate OUT NOCOPY NUMBER,
x_q_exchange_type_code OUT NOCOPY VARCHAR2,
x_q_exchange_rate_date OUT NOCOPY DATE,
x_q_quote_category_code OUT NOCOPY VARCHAR2,
x_q_quote_status_code OUT NOCOPY VARCHAR2,
x_q_quote_status OUT NOCOPY VARCHAR2,
x_q_employee_person_id OUT NOCOPY NUMBER,
x_q_sales_channel_code OUT NOCOPY VARCHAR2,
x_q_salesrep_first_name OUT NOCOPY VARCHAR2,
x_q_salesrep_last_name OUT NOCOPY VARCHAR2,
x_q_attribute_category OUT NOCOPY VARCHAR2,
x_q_attribute1 OUT NOCOPY VARCHAR2,
x_q_attribute10 OUT NOCOPY VARCHAR2,
x_q_attribute11 OUT NOCOPY VARCHAR2,
x_q_attribute12 OUT NOCOPY VARCHAR2,
x_q_attribute13 OUT NOCOPY VARCHAR2,
x_q_attribute14 OUT NOCOPY VARCHAR2,
x_q_attribute15 OUT NOCOPY VARCHAR2,
x_q_attribute16 OUT NOCOPY VARCHAR2,
x_q_attribute17 OUT NOCOPY VARCHAR2,
x_q_attribute18 OUT NOCOPY VARCHAR2,
x_q_attribute19 OUT NOCOPY VARCHAR2,
x_q_attribute20 OUT NOCOPY VARCHAR2,
x_q_attribute2 OUT NOCOPY VARCHAR2,
x_q_attribute3 OUT NOCOPY VARCHAR2,
x_q_attribute4 OUT NOCOPY VARCHAR2,
x_q_attribute5 OUT NOCOPY VARCHAR2,
x_q_attribute6 OUT NOCOPY VARCHAR2,
x_q_attribute7 OUT NOCOPY VARCHAR2,
x_q_attribute8 OUT NOCOPY VARCHAR2,
x_q_attribute9 OUT NOCOPY VARCHAR2,
x_q_contract_id OUT NOCOPY NUMBER,
x_q_qte_contract_id OUT NOCOPY NUMBER,
x_q_ffm_request_id OUT NOCOPY NUMBER,
x_q_invoice_to_address1 OUT NOCOPY VARCHAR2,
x_q_invoice_to_address2 OUT NOCOPY VARCHAR2,
x_q_invoice_to_address3 OUT NOCOPY VARCHAR2,
x_q_invoice_to_address4 OUT NOCOPY VARCHAR2,
x_q_invoice_to_city OUT NOCOPY VARCHAR2,
x_q_invoice_to_cont_first_name OUT NOCOPY VARCHAR2,
x_q_invoice_to_cont_last_name OUT NOCOPY VARCHAR2,
x_q_invoice_to_cont_mid_name OUT NOCOPY VARCHAR2,
x_q_invoice_to_country_code OUT NOCOPY VARCHAR2,
x_q_invoice_to_country OUT NOCOPY VARCHAR2,
x_q_invoice_to_county OUT NOCOPY VARCHAR2,
x_q_invoice_to_party_id OUT NOCOPY NUMBER,
x_q_invoice_to_party_name OUT NOCOPY VARCHAR2,
x_q_invoice_to_party_site_id OUT NOCOPY NUMBER,
x_q_invoice_to_postal_code OUT NOCOPY VARCHAR2,
x_q_invoice_to_province OUT NOCOPY VARCHAR2,
x_q_invoice_to_state OUT NOCOPY VARCHAR2,
x_q_invoicing_rule_id OUT NOCOPY NUMBER,
x_q_marketing_source_code_id OUT NOCOPY NUMBER,
x_q_marketing_source_code OUT NOCOPY VARCHAR2,
x_q_marketing_source_name OUT NOCOPY VARCHAR2,
x_q_orig_mktg_source_code_id OUT NOCOPY NUMBER,
x_q_order_type_id OUT NOCOPY NUMBER,
x_q_order_id OUT NOCOPY NUMBER,
x_q_order_number OUT NOCOPY NUMBER,
x_q_order_type_name OUT NOCOPY VARCHAR2,
x_q_ordered_date OUT NOCOPY DATE,
x_q_resource_id OUT NOCOPY NUMBER,
x_q_contract_template_id OUT NOCOPY NUMBER,
x_q_contract_template_maj_ver OUT NOCOPY NUMBER,
x_q_contract_requester_id OUT NOCOPY NUMBER,
x_q_contract_approval_level OUT NOCOPY VARCHAR2,
x_q_publish_flag OUT NOCOPY VARCHAR2,
x_q_resource_grp_id OUT NOCOPY NUMBER,
x_q_sold_to_party_site_id OUT NOCOPY NUMBER,
x_q_display_arithmetic_op OUT NOCOPY VARCHAR2,
x_q_quote_description OUT NOCOPY VARCHAR2,
x_q_quote_type OUT NOCOPY VARCHAR2,
x_q_minisite_id OUT NOCOPY NUMBER,
x_q_cust_party_id OUT NOCOPY NUMBER,
x_q_invoice_to_cust_party_id OUT NOCOPY NUMBER,
x_q_pricing_status_indicator OUT NOCOPY VARCHAR2,
x_q_tax_status_indicator OUT NOCOPY VARCHAR2,
x_q_price_updated_date OUT NOCOPY DATE,
x_q_tax_updated_date OUT NOCOPY DATE,
x_q_recalculate_flag OUT NOCOPY VARCHAR2,
x_q_price_request_id OUT NOCOPY NUMBER,
x_q_credit_update_date OUT NOCOPY DATE,
x_q_customer_name_and_title OUT NOCOPY VARCHAR2,
x_q_customer_signature_date OUT NOCOPY DATE,
x_q_supplier_name_and_title OUT NOCOPY VARCHAR2,
x_q_supplier_signature_date OUT NOCOPY DATE,
x_q_end_cust_party_id OUT NOCOPY NUMBER,
x_q_end_cust_party_site_id OUT NOCOPY NUMBER,
x_q_end_cust_cust_account_id OUT NOCOPY NUMBER,
x_q_end_cust_cust_party_id OUT NOCOPY NUMBER,
x_q_automatic_price_flag OUT NOCOPY VARCHAR2,
x_q_automatic_tax_flag OUT NOCOPY VARCHAR2,
x_q_assistance_requested OUT NOCOPY VARCHAR2,
x_q_assistance_reason_code OUT NOCOPY VARCHAR2,
x_q_object_version_number OUT NOCOPY NUMBER,
x_q_header_paynow_charges OUT NOCOPY NUMBER
) is
Begin
x_q_quote_header_id := p_qte_header_rec.quote_header_id;
x_q_last_updated_by := p_qte_header_rec.last_updated_by;
x_q_last_update_date := p_qte_header_rec.last_update_date ;
x_q_last_update_login := p_qte_header_rec.last_update_login;
x_q_program_update_date := p_qte_header_rec.program_update_date;
x_q_price_updated_date := p_qte_header_rec.price_updated_date;
x_q_tax_updated_date := p_qte_header_rec.tax_updated_date;
x_q_credit_update_date := p_qte_header_rec.credit_update_date;
x_qs_last_update_date OUT NOCOPY DATE,
x_qs_last_updated_by OUT NOCOPY NUMBER,
x_qs_last_update_login OUT NOCOPY NUMBER,
x_qs_request_id OUT NOCOPY NUMBER,
x_qs_program_application_id OUT NOCOPY NUMBER,
x_qs_program_id OUT NOCOPY NUMBER,
x_qs_program_update_date OUT NOCOPY DATE,
x_qs_quote_header_id OUT NOCOPY NUMBER,
x_qs_quote_line_id OUT NOCOPY NUMBER,
x_qs_promise_date OUT NOCOPY DATE,
x_qs_request_date OUT NOCOPY DATE,
x_qs_schedule_ship_date OUT NOCOPY DATE,
x_qs_ship_to_party_site_id OUT NOCOPY NUMBER,
x_qs_ship_to_party_id OUT NOCOPY NUMBER,
x_qs_ship_to_cust_account_id OUT NOCOPY NUMBER,
x_qs_ship_partial_flag OUT NOCOPY VARCHAR2,
x_qs_ship_set_id OUT NOCOPY NUMBER,
x_qs_ship_method_code OUT NOCOPY VARCHAR2,
x_qs_freight_terms_code OUT NOCOPY VARCHAR2,
x_qs_freight_carrier_code OUT NOCOPY VARCHAR2,
x_qs_fob_code OUT NOCOPY VARCHAR2,
x_qs_shipping_instructions OUT NOCOPY VARCHAR2,
x_qs_packing_instructions OUT NOCOPY VARCHAR2,
x_qs_quantity OUT NOCOPY NUMBER,
x_qs_reserved_quantity OUT NOCOPY VARCHAR2,
x_qs_reservation_id OUT NOCOPY NUMBER,
x_qs_order_line_id OUT NOCOPY NUMBER,
x_qs_ship_to_party_name OUT NOCOPY VARCHAR2,
x_qs_ship_to_cont_first_name OUT NOCOPY VARCHAR2,
x_qs_ship_to_cont_mid_name OUT NOCOPY VARCHAR2,
x_qs_ship_to_cont_last_name OUT NOCOPY VARCHAR2,
x_qs_ship_to_address1 OUT NOCOPY VARCHAR2,
x_qs_ship_to_address2 OUT NOCOPY VARCHAR2,
x_qs_ship_to_address3 OUT NOCOPY VARCHAR2,
x_qs_ship_to_address4 OUT NOCOPY VARCHAR2,
x_qs_ship_to_country_code OUT NOCOPY VARCHAR2,
x_qs_ship_to_country OUT NOCOPY VARCHAR2,
x_qs_ship_to_city OUT NOCOPY VARCHAR2,
x_qs_ship_to_postal_code OUT NOCOPY VARCHAR2,
x_qs_ship_to_state OUT NOCOPY VARCHAR2,
x_qs_ship_to_province OUT NOCOPY VARCHAR2,
x_qs_ship_to_county OUT NOCOPY VARCHAR2,
x_qs_attribute_category OUT NOCOPY VARCHAR2,
x_qs_attribute1 OUT NOCOPY VARCHAR2,
x_qs_attribute2 OUT NOCOPY VARCHAR2,
x_qs_attribute3 OUT NOCOPY VARCHAR2,
x_qs_attribute4 OUT NOCOPY VARCHAR2,
x_qs_attribute5 OUT NOCOPY VARCHAR2,
x_qs_attribute6 OUT NOCOPY VARCHAR2,
x_qs_attribute7 OUT NOCOPY VARCHAR2,
x_qs_attribute8 OUT NOCOPY VARCHAR2,
x_qs_attribute9 OUT NOCOPY VARCHAR2,
x_qs_attribute10 OUT NOCOPY VARCHAR2,
x_qs_attribute11 OUT NOCOPY VARCHAR2,
x_qs_attribute12 OUT NOCOPY VARCHAR2,
x_qs_attribute13 OUT NOCOPY VARCHAR2,
x_qs_attribute14 OUT NOCOPY VARCHAR2,
x_qs_attribute15 OUT NOCOPY VARCHAR2,
x_qs_attribute16 OUT NOCOPY VARCHAR2,
x_qs_attribute17 OUT NOCOPY VARCHAR2,
x_qs_attribute18 OUT NOCOPY VARCHAR2,
x_qs_attribute19 OUT NOCOPY VARCHAR2,
x_qs_attribute20 OUT NOCOPY VARCHAR2,
x_qs_ship_quote_price OUT NOCOPY NUMBER,
x_qs_pricing_quantity OUT NOCOPY NUMBER,
x_qs_shipment_priority_code OUT NOCOPY VARCHAR2,
x_qs_ship_from_org_id OUT NOCOPY NUMBER,
x_qs_ship_to_cust_party_id OUT NOCOPY NUMBER,
x_qs_request_date_type OUT NOCOPY VARCHAR2,
x_qs_demand_class_code OUT NOCOPY VARCHAR2,
x_qs_object_version_number OUT NOCOPY NUMBER
)is
Begin
x_qs_operation_code := p_shipment_rec.operation_code;
x_qs_last_update_date := p_shipment_rec.last_update_date;
x_qs_last_updated_by := p_shipment_rec.last_updated_by;
x_qs_last_update_login := p_shipment_rec.last_update_login;
x_qs_program_update_date := p_shipment_rec.program_update_date;
x_qp_last_update_date OUT NOCOPY DATE,
x_qp_last_updated_by OUT NOCOPY NUMBER,
x_qp_last_update_login OUT NOCOPY NUMBER,
x_qp_request_id OUT NOCOPY NUMBER,
x_qp_program_application_id OUT NOCOPY NUMBER,
x_qp_program_id OUT NOCOPY NUMBER,
x_qp_program_update_date OUT NOCOPY DATE,
x_qp_quote_header_id OUT NOCOPY NUMBER,
x_qp_quote_line_id OUT NOCOPY NUMBER,
x_qp_payment_type_code OUT NOCOPY VARCHAR2,
x_qp_payment_ref_number OUT NOCOPY VARCHAR2,
x_qp_payment_option OUT NOCOPY VARCHAR2,
x_qp_payment_term_id OUT NOCOPY NUMBER,
x_qp_credit_card_code OUT NOCOPY VARCHAR2,
x_qp_credit_card_holder_name OUT NOCOPY VARCHAR2,
x_qp_credit_card_exp_date OUT NOCOPY DATE,
x_qp_credit_card_aprv_code OUT NOCOPY VARCHAR2,
x_qp_credit_card_aprv_date OUT NOCOPY DATE,
x_qp_payment_amount OUT NOCOPY NUMBER,
x_qp_attribute_category OUT NOCOPY VARCHAR2,
x_qp_attribute1 OUT NOCOPY VARCHAR2,
x_qp_attribute2 OUT NOCOPY VARCHAR2,
x_qp_attribute3 OUT NOCOPY VARCHAR2,
x_qp_attribute4 OUT NOCOPY VARCHAR2,
x_qp_attribute5 OUT NOCOPY VARCHAR2,
x_qp_attribute6 OUT NOCOPY VARCHAR2,
x_qp_attribute7 OUT NOCOPY VARCHAR2,
x_qp_attribute8 OUT NOCOPY VARCHAR2,
x_qp_attribute9 OUT NOCOPY VARCHAR2,
x_qp_attribute10 OUT NOCOPY VARCHAR2,
x_qp_attribute11 OUT NOCOPY VARCHAR2,
x_qp_attribute12 OUT NOCOPY VARCHAR2,
x_qp_attribute13 OUT NOCOPY VARCHAR2,
x_qp_attribute14 OUT NOCOPY VARCHAR2,
x_qp_attribute15 OUT NOCOPY VARCHAR2,
x_qp_attribute16 OUT NOCOPY VARCHAR2,
x_qp_attribute17 OUT NOCOPY VARCHAR2,
x_qp_attribute18 OUT NOCOPY VARCHAR2,
x_qp_attribute19 OUT NOCOPY VARCHAR2,
x_qp_attribute20 OUT NOCOPY VARCHAR2,
x_qp_shipment_index OUT NOCOPY NUMBER,
x_qp_quote_shipment_id OUT NOCOPY NUMBER,
x_qp_cust_po_number OUT NOCOPY VARCHAR2,
x_qp_cust_po_line_number OUT NOCOPY VARCHAR2,
x_qp_object_version_number OUT NOCOPY NUMBER,
x_qp_trxn_extension_id OUT NOCOPY NUMBER,
x_qp_instrument_id OUT NOCOPY NUMBER,
x_qp_instr_assignment_id OUT NOCOPY NUMBER,
x_qp_cvv2 OUT NOCOPY VARCHAR2
)is
Begin
x_qp_operation_code := p_payment_rec.operation_code;
x_qp_last_update_date := p_payment_rec.last_update_date;
x_qp_last_updated_by := p_payment_rec.last_updated_by;
x_qp_last_update_login := p_payment_rec.last_update_login ;
x_qp_program_update_date := p_payment_rec.program_update_date;
x_qt_last_update_date OUT NOCOPY DATE,
x_qt_last_updated_by OUT NOCOPY NUMBER,
x_qt_last_update_login OUT NOCOPY NUMBER,
x_qt_request_id OUT NOCOPY NUMBER,
x_qt_program_application_id OUT NOCOPY NUMBER,
x_qt_program_id OUT NOCOPY NUMBER,
x_qt_program_update_date OUT NOCOPY DATE,
x_qt_orig_tax_code OUT NOCOPY VARCHAR2,
x_qt_tax_code OUT NOCOPY VARCHAR2,
x_qt_tax_rate OUT NOCOPY NUMBER,
x_qt_tax_date OUT NOCOPY DATE,
x_qt_tax_amount OUT NOCOPY NUMBER,
x_qt_tax_exempt_flag OUT NOCOPY VARCHAR2,
x_qt_tax_exempt_number OUT NOCOPY VARCHAR2,
x_qt_tax_exempt_reason_code OUT NOCOPY VARCHAR2,
x_qt_attribute_category OUT NOCOPY VARCHAR2,
x_qt_attribute1 OUT NOCOPY VARCHAR2,
x_qt_attribute2 OUT NOCOPY VARCHAR2,
x_qt_attribute3 OUT NOCOPY VARCHAR2,
x_qt_attribute4 OUT NOCOPY VARCHAR2,
x_qt_attribute5 OUT NOCOPY VARCHAR2,
x_qt_attribute6 OUT NOCOPY VARCHAR2,
x_qt_attribute7 OUT NOCOPY VARCHAR2,
x_qt_attribute8 OUT NOCOPY VARCHAR2,
x_qt_attribute9 OUT NOCOPY VARCHAR2,
x_qt_attribute10 OUT NOCOPY VARCHAR2,
x_qt_attribute11 OUT NOCOPY VARCHAR2,
x_qt_attribute12 OUT NOCOPY VARCHAR2,
x_qt_attribute13 OUT NOCOPY VARCHAR2,
x_qt_attribute14 OUT NOCOPY VARCHAR2,
x_qt_attribute15 OUT NOCOPY VARCHAR2,
x_qt_attribute16 OUT NOCOPY VARCHAR2,
x_qt_attribute17 OUT NOCOPY VARCHAR2,
x_qt_attribute18 OUT NOCOPY VARCHAR2,
x_qt_attribute19 OUT NOCOPY VARCHAR2,
x_qt_attribute20 OUT NOCOPY VARCHAR2,
x_qt_object_version_number OUT NOCOPY NUMBER,
x_qt_tax_rate_id OUT NOCOPY NUMBER
)is
Begin
x_qt_operation_code := p_tax_detail_rec.operation_code;
x_qt_last_update_date := p_tax_detail_rec.last_update_date;
x_qt_last_updated_by := p_tax_detail_rec.last_updated_by ;
x_qt_last_update_login := p_tax_detail_rec.last_update_login;
x_qt_program_update_date := p_tax_detail_rec.program_update_date;
x_ql_last_updated_by OUT NOCOPY NUMBER,
x_ql_last_update_date OUT NOCOPY DATE,
x_ql_last_update_login OUT NOCOPY NUMBER,
x_ql_request_id OUT NOCOPY NUMBER,
x_ql_program_application_id OUT NOCOPY NUMBER,
x_ql_program_id OUT NOCOPY NUMBER,
x_ql_program_update_date OUT NOCOPY DATE,
x_ql_quote_line_id OUT NOCOPY NUMBER,
x_ql_quote_header_id OUT NOCOPY NUMBER,
x_ql_org_id OUT NOCOPY NUMBER,
x_ql_line_number OUT NOCOPY NUMBER,
x_ql_line_category_code OUT NOCOPY VARCHAR2,
x_ql_item_type_code OUT NOCOPY VARCHAR2,
x_ql_inventory_item_id OUT NOCOPY NUMBER,
x_ql_organization_id OUT NOCOPY NUMBER,
x_ql_quantity OUT NOCOPY NUMBER,
x_ql_uom_code OUT NOCOPY VARCHAR2,
x_ql_start_date_active OUT NOCOPY VARCHAR2,
x_ql_end_date_active OUT NOCOPY VARCHAR2,
x_ql_order_line_type_id OUT NOCOPY NUMBER,
x_ql_price_list_id OUT NOCOPY NUMBER,
x_ql_price_list_line_id OUT NOCOPY NUMBER,
x_ql_currency_code OUT NOCOPY VARCHAR2,
x_ql_line_list_price OUT NOCOPY NUMBER,
x_ql_line_adjusted_amount OUT NOCOPY NUMBER,
x_ql_line_adjusted_percent OUT NOCOPY NUMBER,
x_ql_line_quote_price OUT NOCOPY NUMBER,
x_ql_related_item_id OUT NOCOPY NUMBER,
x_ql_item_relationship_type OUT NOCOPY VARCHAR2,
x_ql_split_shipment_flag OUT NOCOPY VARCHAR2,
x_ql_backorder_flag OUT NOCOPY VARCHAR2,
x_ql_selling_price_change OUT NOCOPY VARCHAR2,
x_ql_recalculate_flag OUT NOCOPY VARCHAR2,
x_ql_attribute_category OUT NOCOPY VARCHAR2,
x_ql_attribute1 OUT NOCOPY VARCHAR2,
x_ql_attribute2 OUT NOCOPY VARCHAR2,
x_ql_attribute3 OUT NOCOPY VARCHAR2,
x_ql_attribute4 OUT NOCOPY VARCHAR2,
x_ql_attribute5 OUT NOCOPY VARCHAR2,
x_ql_attribute6 OUT NOCOPY VARCHAR2,
x_ql_attribute7 OUT NOCOPY VARCHAR2,
x_ql_attribute8 OUT NOCOPY VARCHAR2,
x_ql_attribute9 OUT NOCOPY VARCHAR2,
x_ql_attribute10 OUT NOCOPY VARCHAR2,
x_ql_attribute11 OUT NOCOPY VARCHAR2,
x_ql_attribute12 OUT NOCOPY VARCHAR2,
x_ql_attribute13 OUT NOCOPY VARCHAR2,
x_ql_attribute14 OUT NOCOPY VARCHAR2,
x_ql_attribute15 OUT NOCOPY VARCHAR2,
x_ql_attribute16 OUT NOCOPY VARCHAR2,
x_ql_attribute17 OUT NOCOPY VARCHAR2,
x_ql_attribute18 OUT NOCOPY VARCHAR2,
x_ql_attribute19 OUT NOCOPY VARCHAR2,
x_ql_attribute20 OUT NOCOPY VARCHAR2,
x_ql_accounting_rule_id OUT NOCOPY NUMBER,
x_ql_ffm_content_name OUT NOCOPY VARCHAR2,
x_ql_ffm_content_type OUT NOCOPY VARCHAR2,
x_ql_ffm_document_type OUT NOCOPY VARCHAR2,
x_ql_ffm_media_id OUT NOCOPY VARCHAR2,
x_ql_ffm_media_type OUT NOCOPY VARCHAR2,
x_ql_ffm_user_note OUT NOCOPY VARCHAR2,
x_ql_invoice_to_party_id OUT NOCOPY NUMBER,
x_ql_invoice_to_party_site_id OUT NOCOPY NUMBER,
x_ql_invoicing_rule_id OUT NOCOPY NUMBER,
x_ql_marketing_source_code_id OUT NOCOPY NUMBER,
x_ql_operation_code OUT NOCOPY VARCHAR2,
x_ql_invoice_to_cust_acct_id OUT NOCOPY NUMBER,
x_ql_pricing_quantity_uom OUT NOCOPY VARCHAR2,
x_ql_minisite_id OUT NOCOPY NUMBER,
x_ql_section_id OUT NOCOPY NUMBER,
x_ql_priced_price_list_id OUT NOCOPY NUMBER,
x_ql_agreement_id OUT NOCOPY NUMBER,
x_ql_commitment_id OUT NOCOPY NUMBER,
x_ql_display_arithmetic_op OUT NOCOPY VARCHAR2,
x_ql_invoice_to_cust_party_id OUT NOCOPY NUMBER,
x_ql_ship_model_complete_flag OUT NOCOPY VARCHAR2,
x_ql_charge_periodicity_code OUT NOCOPY VARCHAR2,
x_ql_end_cust_party_id OUT NOCOPY NUMBER,
x_ql_end_cust_party_site_id OUT NOCOPY NUMBER,
x_ql_end_cust_cust_account_id OUT NOCOPY NUMBER,
x_ql_end_cust_cust_party_id OUT NOCOPY NUMBER,
x_ql_object_version_number OUT NOCOPY NUMBER,
x_ql_line_paynow_charges OUT NOCOPY NUMBER,
x_ql_line_paynow_tax OUT NOCOPY NUMBER,
x_ql_line_paynow_subtotal OUT NOCOPY NUMBER,
x_ql_config_model_type OUT NOCOPY VARCHAR2
)is
Begin
x_ql_creation_date := p_qte_line_rec.creation_date;
x_ql_last_updated_by := p_qte_line_rec.last_updated_by;
x_ql_last_update_date := p_qte_line_rec.last_update_date;
x_ql_last_update_login := p_qte_line_rec.last_update_login;
x_ql_program_update_date := p_qte_line_rec.program_update_date;
p_LAST_UPDATE_DATE IN jtf_date_table := null,
p_LAST_UPDATED_BY IN jtf_number_table := NULL,
p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL,
p_REQUEST_ID IN jtf_number_table := NULL,
p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL,
p_PROGRAM_ID IN jtf_number_table := NULL,
p_PROGRAM_UPDATE_DATE IN jtf_date_table := null,
p_QUOTE_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
p_QUOTE_OBJECT_ID IN jtf_number_table := NULL,
p_OBJECT_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
p_OBJECT_ID IN jtf_number_table := NULL,
p_RELATIONSHIP_TYPE_CODE IN jtf_varchar2_table_300 := NULL,
p_RECIPROCAL_FLAG IN jtf_varchar2_table_100 := NULL,
p_QUOTE_OBJECT_CODE IN jtf_number_table := NULL,
p_OBJECT_VERSION_NUMBER IN jtf_number_table := NULL
)
RETURN ASO_Quote_Pub.RELATED_OBJ_Tbl_Type
IS
l_rel_obj_tbl ASO_QUOTE_PUB.RELATED_OBJ_Tbl_Type := ASO_Quote_Pub.G_MISS_RELATED_OBJ_TBL;
IF P_LAST_UPDATED_BY IS NOT NULL THEN
IF P_LAST_UPDATED_BY(i)= ROSETTA_G_MISS_NUM THEN
l_rel_obj_tbl(i).LAST_UPDATED_BY:= FND_API.G_MISS_NUM;
l_rel_obj_tbl(i).LAST_UPDATED_BY:= P_LAST_UPDATED_BY(i);
IF P_LAST_UPDATE_DATE IS NOT NULL THEN
IF P_LAST_UPDATE_DATE(i)= ROSETTA_G_MISTAKE_DATE THEN
l_rel_obj_tbl(i).LAST_UPDATE_DATE:= FND_API.G_MISS_DATE;
l_rel_obj_tbl(i).LAST_UPDATE_DATE:= P_LAST_UPDATE_DATE(i);
IF P_LAST_UPDATE_LOGIN IS NOT NULL THEN
IF P_LAST_UPDATE_LOGIN(i)= ROSETTA_G_MISS_NUM THEN
l_rel_obj_tbl(i).LAST_UPDATE_LOGIN:= FND_API.G_MISS_NUM;
l_rel_obj_tbl(i).LAST_UPDATE_LOGIN:= P_LAST_UPDATE_LOGIN(i);
IF P_PROGRAM_UPDATE_DATE IS NOT NULL THEN
IF P_PROGRAM_UPDATE_DATE(i)= ROSETTA_G_MISTAKE_DATE THEN
l_rel_obj_tbl(i).PROGRAM_UPDATE_DATE:= FND_API.G_MISS_DATE;
l_rel_obj_tbl(i).PROGRAM_UPDATE_DATE:= P_PROGRAM_UPDATE_DATE(i);