eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_QUOTE_W1_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22


   p_last_update_date          IN  jtf_date_table    ,
   p_last_updated_by           IN  jtf_number_table  ,
   p_last_update_login         IN  jtf_number_table  ,
   p_request_id                IN  jtf_number_table  ,
   p_program_application_id    IN  jtf_number_table  ,
   p_program_id                IN  jtf_number_table  ,
   p_program_update_date       IN  jtf_date_table    ,
   p_quote_header_id           IN  jtf_number_table  ,
   p_quote_line_id             IN  jtf_number_table  ,
   p_payment_type_code         IN  jtf_varchar2_table_100  ,
   p_payment_ref_number        IN  jtf_varchar2_table_300  ,
   p_payment_option            IN  jtf_varchar2_table_300  ,
   p_payment_term_id           IN  jtf_number_table  ,
   p_credit_card_code          IN  jtf_varchar2_table_100  ,
   p_credit_card_holder_name   IN  jtf_varchar2_table_100  ,
   p_credit_card_exp_date      IN  jtf_date_table    ,
   p_credit_card_approval_code IN  jtf_varchar2_table_100  ,
   p_credit_card_approval_date IN  jtf_date_table    ,
   p_payment_amount            IN  jtf_number_table  ,
   p_cust_po_number            IN  jtf_varchar2_table_100  ,
   p_attribute_category        IN  jtf_varchar2_table_100  ,
   p_attribute1                IN  jtf_varchar2_table_200  ,
   p_attribute2                IN  jtf_varchar2_table_200  ,
   p_attribute3                IN  jtf_varchar2_table_200  ,
   p_attribute4                IN  jtf_varchar2_table_200  ,
   p_attribute5                IN  jtf_varchar2_table_200  ,
   p_attribute6                IN  jtf_varchar2_table_200  ,
   p_attribute7                IN  jtf_varchar2_table_200  ,
   p_attribute8                IN  jtf_varchar2_table_200  ,
   p_attribute9                IN  jtf_varchar2_table_200  ,
   p_attribute10               IN  jtf_varchar2_table_200  ,
   p_attribute11               IN  jtf_varchar2_table_200  ,
   p_attribute12               IN  jtf_varchar2_table_200  ,
   p_attribute13               IN  jtf_varchar2_table_200  ,
   p_attribute14               IN  jtf_varchar2_table_200  ,
   p_attribute15               IN  jtf_varchar2_table_200  ,
   p_assignment_id             IN  jtf_number_table  ,
   p_cvv2                      IN  jtf_varchar2_table_200
)
RETURN ASO_Quote_Pub.Payment_Tbl_Type
IS
   l_payment_tbl ASO_Quote_Pub.Payment_Tbl_Type;

Line: 97


         IF ((p_last_update_date is not null ) and ((p_last_update_date(i) is null) or (p_last_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_payment_tbl(i).last_update_date := p_last_update_date(i);

Line: 101


         IF ((p_last_updated_by is not null ) and ((p_last_updated_by(i) is null) or (p_last_updated_by(i) <> ROSETTA_G_MISS_NUM))) THEN
            l_payment_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 105


         IF ((p_last_update_login is not null ) and ((p_last_update_login(i) is null) or (p_last_update_login(i) <> ROSETTA_G_MISS_NUM))) THEN
            l_payment_tbl(i).last_update_login := p_last_update_login(i);

Line: 121


         IF ((p_program_update_date is not null ) and ((p_program_update_date(i) is null) or (p_program_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_payment_tbl(i).program_update_date := p_program_update_date(i);

Line: 330


   p_c_last_update_date        DATE ,
   p_c_auto_version_flag       VARCHAR2,
   p_c_pricing_request_type    VARCHAR2,
   p_c_header_pricing_event    VARCHAR2,
   p_c_line_pricing_event      VARCHAR2,
   p_c_cal_tax_flag            VARCHAR2,
   p_c_cal_freight_charge_flag VARCHAR2,
   p_c_price_mode  	       VARCHAR2 := 'ENTIRE_QUOTE',	-- change line logic pricing
   x_control_rec               OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
)
IS
BEGIN
   IF p_c_last_update_date = ROSETTA_G_MISTAKE_DATE THEN
      x_control_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 345


      x_control_rec.last_update_date := p_c_last_update_date;

Line: 362


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_request_id             IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_quote_line_id          IN jtf_number_table        ,
   p_qte_line_index         IN jtf_number_table        ,
   p_price_adjustment_id    IN jtf_number_table        ,
   p_price_adj_index        IN jtf_number_table        ,
   p_rltd_price_adj_id      IN jtf_number_table        ,
   p_rltd_price_adj_index   IN jtf_number_table
)
RETURN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
IS
   l_price_adj_rltship_tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

Line: 404


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_rltship_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 407


            l_price_adj_rltship_tbl(i).last_update_date := p_last_update_date(i);

Line: 410


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_rltship_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 413


            l_price_adj_rltship_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 415


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_rltship_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 418


            l_price_adj_rltship_tbl(i).last_update_login := p_last_update_login(i);

Line: 435


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_rltship_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 438


            l_price_adj_rltship_tbl(i).program_update_date := p_program_update_date(i);

Line: 483


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_request_id             IN jtf_number_table        ,
   p_quote_header_id        IN jtf_number_table        ,
   p_quote_line_id          IN jtf_number_table        ,
   p_modifier_header_id     IN jtf_number_table        ,
   p_modifier_line_id       IN jtf_number_table        ,
   p_mod_line_type_code     IN jtf_varchar2_table_100  ,
   p_mod_mech_type_code     IN jtf_varchar2_table_100  ,
   p_modified_from          IN jtf_number_table        ,
   p_modified_to            IN jtf_number_table        ,
   p_operand                IN jtf_number_table        ,
   p_arithmetic_operator    IN jtf_varchar2_table_100  ,
   p_automatic_flag         IN jtf_varchar2_table_100  ,
   p_update_allowable_flag  IN jtf_varchar2_table_100  ,
   p_updated_flag           IN jtf_varchar2_table_100  ,
   p_applied_flag           IN jtf_varchar2_table_100  ,
   p_on_invoice_flag        IN jtf_varchar2_table_100  ,
   p_pricing_phase_id       IN jtf_number_table        ,
   p_attribute_category     IN jtf_varchar2_table_100  ,
   p_attribute1             IN jtf_varchar2_table_200  ,
   p_attribute2             IN jtf_varchar2_table_200  ,
   p_attribute3             IN jtf_varchar2_table_200  ,
   p_attribute4             IN jtf_varchar2_table_200  ,
   p_attribute5             IN jtf_varchar2_table_200  ,
   p_attribute6             IN jtf_varchar2_table_200  ,
   p_attribute7             IN jtf_varchar2_table_200  ,
   p_attribute8             IN jtf_varchar2_table_200  ,
   p_attribute9             IN jtf_varchar2_table_200  ,
   p_attribute10            IN jtf_varchar2_table_200  ,
   p_attribute11            IN jtf_varchar2_table_200  ,
   p_attribute12            IN jtf_varchar2_table_200  ,
   p_attribute13            IN jtf_varchar2_table_200  ,
   p_attribute14            IN jtf_varchar2_table_200  ,
   p_attribute15            IN jtf_varchar2_table_200  ,
   p_orig_sys_discount_ref  IN jtf_varchar2_table_100  ,
   p_change_sequence        IN jtf_varchar2_table_100  ,
   p_update_allowed         IN jtf_varchar2_table_100  ,
   p_change_reason_code     IN jtf_varchar2_table_100  ,
   p_change_reason_text     IN jtf_varchar2_table_2000  ,
   p_cost_id                IN jtf_number_table        ,
   p_tax_code               IN jtf_varchar2_table_100  ,
   p_tax_exempt_flag        IN jtf_varchar2_table_100  ,
   p_tax_exempt_number      IN jtf_varchar2_table_100  ,
   p_tax_exempt_reason_code IN jtf_varchar2_table_100  ,
   p_parent_adjustment_id   IN jtf_number_table        ,
   p_invoiced_flag          IN jtf_varchar2_table_100  ,
   p_estimated_flag         IN jtf_varchar2_table_100  ,
   p_inc_in_sales_perfce    IN jtf_varchar2_table_100  ,
   p_split_action_code      IN jtf_varchar2_table_100  ,
   p_adjusted_amount        IN jtf_number_table        ,
   p_charge_type_code       IN jtf_varchar2_table_100  ,
   p_charge_subtype_code    IN jtf_varchar2_table_100  ,
   p_range_break_quantity   IN jtf_number_table        ,
   p_accrual_conv_rate      IN jtf_number_table        ,
   p_pricing_group_sequence IN jtf_number_table        ,
   p_accrual_flag           IN jtf_varchar2_table_100  ,
   p_list_line_no           IN jtf_varchar2_table_300  ,
   p_source_system_code     IN jtf_varchar2_table_100  ,
   p_benefit_qty            IN jtf_number_table        ,
   p_benefit_uom_code       IN jtf_varchar2_table_100  ,
   p_print_on_invoice_flag  IN jtf_varchar2_table_100  ,
   p_expiration_date        IN jtf_date_table          ,
   p_rebate_trans_type_code IN jtf_varchar2_table_100  ,
   p_rebate_trans_reference IN jtf_varchar2_table_100  ,
   p_rebate_pay_system_code IN jtf_varchar2_table_100  ,
   p_redeemed_date          IN jtf_date_table          ,
   p_redeemed_flag          IN jtf_varchar2_table_100  ,
   p_modifier_level_code    IN jtf_varchar2_table_100  ,
   p_price_break_type_code  IN jtf_varchar2_table_100  ,
   p_substitution_attribute IN jtf_varchar2_table_100  ,
   p_proration_type_code    IN jtf_varchar2_table_100  ,
   p_include_on_ret_flag    IN jtf_varchar2_table_100  ,
   p_credit_or_charge_flag  IN jtf_varchar2_table_100
)
RETURN ASO_Quote_Pub.Price_Adj_Tbl_Type
IS
   l_price_adj_tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line: 595


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 598


            l_price_adj_tbl(i).last_update_date := p_last_update_date(i);

Line: 600


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 603


            l_price_adj_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 605


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 608


            l_price_adj_tbl(i).last_update_login := p_last_update_login(i);

Line: 620


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 623


            l_price_adj_tbl(i).program_update_date := p_program_update_date(i);

Line: 669


         l_price_adj_tbl(i).update_allowable_flag := p_update_allowable_flag(i);

Line: 670


         l_price_adj_tbl(i).updated_flag := p_updated_flag(i);

Line: 696


         l_price_adj_tbl(i).update_allowed := p_update_allowed(i);

Line: 783


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_request_id             IN jtf_number_table        ,
   p_price_adjustment_id    IN jtf_number_table        ,
   p_pricing_context        IN jtf_varchar2_table_100  ,
   p_pricing_attribute      IN jtf_varchar2_table_100  ,
   p_prc_attr_value_from    IN jtf_varchar2_table_300  ,
   p_pricing_attr_value_to  IN jtf_varchar2_table_300  ,
   p_comparison_operator    IN jtf_varchar2_table_100  ,
   p_flex_title             IN jtf_varchar2_table_100
)
RETURN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type
IS
   l_price_adj_attr_tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;

Line: 836


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_attr_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 839


            l_price_adj_attr_tbl(i).last_update_date := p_last_update_date(i);

Line: 841


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_attr_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 844


            l_price_adj_attr_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 846


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_price_adj_attr_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 849


            l_price_adj_attr_tbl(i).last_update_login := p_last_update_login(i);

Line: 861


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_adj_attr_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 864


            l_price_adj_attr_tbl(i).program_update_date := p_program_update_date(i);

Line: 895


   p_last_update_date       IN jtf_date_table           ,
   p_last_updated_by        IN jtf_number_table         ,
   p_last_update_login      IN jtf_number_table         ,
   p_request_id             IN jtf_number_table         ,
   p_program_application_id IN jtf_number_table         ,
   p_program_id             IN jtf_number_table         ,
   p_program_update_date    IN jtf_date_table           ,
   p_quote_header_id        IN jtf_number_table         ,
   p_quote_line_id          IN jtf_number_table         ,
   p_quote_shipment_id      IN jtf_number_table         ,
   p_attribute_type_code    IN jtf_varchar2_table_100   ,
   p_name                   IN jtf_varchar2_table_100   ,
   p_value                  IN jtf_varchar2_table_2000  ,
   p_value_type             IN jtf_varchar2_table_300   ,
   p_status                 IN jtf_varchar2_table_100   ,
   p_application_id         IN jtf_number_table         ,
   p_start_date_active      IN jtf_date_table           ,
   p_end_date_active        IN jtf_date_table           ,
   p_operation_code         IN jtf_varchar2_table_100
)
RETURN ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type
IS
   l_line_attribs_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_Tbl_Type;

Line: 952


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_line_attribs_ext_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 955


            l_line_attribs_ext_tbl(i).last_update_date := p_last_update_date(i);

Line: 957


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_line_attribs_ext_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 960


            l_line_attribs_ext_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 962


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_line_attribs_ext_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 965


            l_line_attribs_ext_tbl(i).last_update_login := p_last_update_login(i);

Line: 982


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_line_attribs_ext_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 985


            l_line_attribs_ext_tbl(i).program_update_date := p_program_update_date(i);

Line: 1035


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_creation_date          IN jtf_date_table          ,
   p_created_by             IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_request_id             IN jtf_number_table        ,
   p_quote_shipment_id      IN jtf_number_table        ,
   p_quote_line_id          IN jtf_number_table        ,
   p_freight_charge_type_id IN jtf_number_table        ,
   p_charge_amount          IN jtf_number_table        ,
   p_attribute_category     IN jtf_varchar2_table_200  ,
   p_attribute1             IN jtf_varchar2_table_200  ,
   p_attribute2             IN jtf_varchar2_table_200  ,
   p_attribute3             IN jtf_varchar2_table_200  ,
   p_attribute4             IN jtf_varchar2_table_200  ,
   p_attribute5             IN jtf_varchar2_table_200  ,
   p_attribute6             IN jtf_varchar2_table_200  ,
   p_attribute7             IN jtf_varchar2_table_200  ,
   p_attribute8             IN jtf_varchar2_table_200  ,
   p_attribute9             IN jtf_varchar2_table_200  ,
   p_attribute10            IN jtf_varchar2_table_200  ,
   p_attribute11            IN jtf_varchar2_table_200  ,
   p_attribute12            IN jtf_varchar2_table_200  ,
   p_attribute13            IN jtf_varchar2_table_200  ,
   p_attribute14            IN jtf_varchar2_table_200  ,
   p_attribute15            IN jtf_varchar2_table_200
)
RETURN ASO_Quote_Pub.Freight_Charge_Tbl_Type
IS
   l_freight_charge_tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type;

Line: 1093


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_freight_charge_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 1096


            l_freight_charge_tbl(i).last_update_date := p_last_update_date(i);

Line: 1098


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_freight_charge_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 1101


            l_freight_charge_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 1113


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_freight_charge_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 1116


            l_freight_charge_tbl(i).last_update_login := p_last_update_login(i);

Line: 1128


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_freight_charge_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 1131


            l_freight_charge_tbl(i).program_update_date := p_program_update_date(i);

Line: 1187


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_request_id             IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_quote_header_id        IN jtf_number_table        ,
   p_quote_line_id          IN jtf_number_table        ,
   p_flex_title             IN jtf_varchar2_table_100  ,
   p_pricing_context        IN jtf_varchar2_table_100  ,
   p_pricing_attribute1     IN jtf_varchar2_table_300  ,
   p_pricing_attribute2     IN jtf_varchar2_table_300  ,
   p_pricing_attribute3     IN jtf_varchar2_table_300  ,
   p_pricing_attribute4     IN jtf_varchar2_table_300  ,
   p_pricing_attribute5     IN jtf_varchar2_table_300  ,
   p_pricing_attribute6     IN jtf_varchar2_table_300  ,
   p_pricing_attribute7     IN jtf_varchar2_table_300  ,
   p_pricing_attribute8     IN jtf_varchar2_table_300  ,
   p_pricing_attribute9     IN jtf_varchar2_table_300  ,
   p_pricing_attribute10    IN jtf_varchar2_table_300  ,
   p_pricing_attribute11    IN jtf_varchar2_table_300  ,
   p_pricing_attribute12    IN jtf_varchar2_table_300  ,
   p_pricing_attribute13    IN jtf_varchar2_table_300  ,
   p_pricing_attribute14    IN jtf_varchar2_table_300  ,
   p_pricing_attribute15    IN jtf_varchar2_table_300  ,
   p_pricing_attribute16    IN jtf_varchar2_table_300  ,
   p_pricing_attribute17    IN jtf_varchar2_table_300  ,
   p_pricing_attribute18    IN jtf_varchar2_table_300  ,
   p_pricing_attribute19    IN jtf_varchar2_table_300  ,
   p_pricing_attribute20    IN jtf_varchar2_table_300  ,
   p_pricing_attribute21    IN jtf_varchar2_table_300  ,
   p_pricing_attribute22    IN jtf_varchar2_table_300  ,
   p_pricing_attribute23    IN jtf_varchar2_table_300  ,
   p_pricing_attribute24    IN jtf_varchar2_table_300  ,
   p_pricing_attribute25    IN jtf_varchar2_table_300  ,
   p_pricing_attribute26    IN jtf_varchar2_table_300  ,
   p_pricing_attribute27    IN jtf_varchar2_table_300  ,
   p_pricing_attribute28    IN jtf_varchar2_table_300  ,
   p_pricing_attribute29    IN jtf_varchar2_table_300  ,
   p_pricing_attribute30    IN jtf_varchar2_table_300  ,
   p_pricing_attribute31    IN jtf_varchar2_table_300  ,
   p_pricing_attribute32    IN jtf_varchar2_table_300  ,
   p_pricing_attribute33    IN jtf_varchar2_table_300  ,
   p_pricing_attribute34    IN jtf_varchar2_table_300  ,
   p_pricing_attribute35    IN jtf_varchar2_table_300  ,
   p_pricing_attribute36    IN jtf_varchar2_table_300  ,
   p_pricing_attribute37    IN jtf_varchar2_table_300  ,
   p_pricing_attribute38    IN jtf_varchar2_table_300  ,
   p_pricing_attribute39    IN jtf_varchar2_table_300  ,
   p_pricing_attribute40    IN jtf_varchar2_table_300  ,
   p_pricing_attribute41    IN jtf_varchar2_table_300  ,
   p_pricing_attribute42    IN jtf_varchar2_table_300  ,
   p_pricing_attribute43    IN jtf_varchar2_table_300  ,
   p_pricing_attribute44    IN jtf_varchar2_table_300  ,
   p_pricing_attribute45    IN jtf_varchar2_table_300  ,
   p_pricing_attribute46    IN jtf_varchar2_table_300  ,
   p_pricing_attribute47    IN jtf_varchar2_table_300  ,
   p_pricing_attribute48    IN jtf_varchar2_table_300  ,
   p_pricing_attribute49    IN jtf_varchar2_table_300  ,
   p_pricing_attribute50    IN jtf_varchar2_table_300  ,
   p_pricing_attribute51    IN jtf_varchar2_table_300  ,
   p_pricing_attribute52    IN jtf_varchar2_table_300  ,
   p_pricing_attribute53    IN jtf_varchar2_table_300  ,
   p_pricing_attribute54    IN jtf_varchar2_table_300  ,
   p_pricing_attribute55    IN jtf_varchar2_table_300  ,
   p_pricing_attribute56    IN jtf_varchar2_table_300  ,
   p_pricing_attribute57    IN jtf_varchar2_table_300  ,
   p_pricing_attribute58    IN jtf_varchar2_table_300  ,
   p_pricing_attribute59    IN jtf_varchar2_table_300  ,
   p_pricing_attribute60    IN jtf_varchar2_table_300  ,
   p_pricing_attribute61    IN jtf_varchar2_table_300  ,
   p_pricing_attribute62    IN jtf_varchar2_table_300  ,
   p_pricing_attribute63    IN jtf_varchar2_table_300  ,
   p_pricing_attribute64    IN jtf_varchar2_table_300  ,
   p_pricing_attribute65    IN jtf_varchar2_table_300  ,
   p_pricing_attribute66    IN jtf_varchar2_table_300  ,
   p_pricing_attribute67    IN jtf_varchar2_table_300  ,
   p_pricing_attribute68    IN jtf_varchar2_table_300  ,
   p_pricing_attribute69    IN jtf_varchar2_table_300  ,
   p_pricing_attribute70    IN jtf_varchar2_table_300  ,
   p_pricing_attribute71    IN jtf_varchar2_table_300  ,
   p_pricing_attribute72    IN jtf_varchar2_table_300  ,
   p_pricing_attribute73    IN jtf_varchar2_table_300  ,
   p_pricing_attribute74    IN jtf_varchar2_table_300  ,
   p_pricing_attribute75    IN jtf_varchar2_table_300  ,
   p_pricing_attribute76    IN jtf_varchar2_table_300  ,
   p_pricing_attribute77    IN jtf_varchar2_table_300  ,
   p_pricing_attribute78    IN jtf_varchar2_table_300  ,
   p_pricing_attribute79    IN jtf_varchar2_table_300  ,
   p_pricing_attribute80    IN jtf_varchar2_table_300  ,
   p_pricing_attribute81    IN jtf_varchar2_table_300  ,
   p_pricing_attribute82    IN jtf_varchar2_table_300  ,
   p_pricing_attribute83    IN jtf_varchar2_table_300  ,
   p_pricing_attribute84    IN jtf_varchar2_table_300  ,
   p_pricing_attribute85    IN jtf_varchar2_table_300  ,
   p_pricing_attribute86    IN jtf_varchar2_table_300  ,
   p_pricing_attribute87    IN jtf_varchar2_table_300  ,
   p_pricing_attribute88    IN jtf_varchar2_table_300  ,
   p_pricing_attribute89    IN jtf_varchar2_table_300  ,
   p_pricing_attribute90    IN jtf_varchar2_table_300  ,
   p_pricing_attribute91    IN jtf_varchar2_table_300  ,
   p_pricing_attribute92    IN jtf_varchar2_table_300  ,
   p_pricing_attribute93    IN jtf_varchar2_table_300  ,
   p_pricing_attribute94    IN jtf_varchar2_table_300  ,
   p_pricing_attribute95    IN jtf_varchar2_table_300  ,
   p_pricing_attribute96    IN jtf_varchar2_table_300  ,
   p_pricing_attribute97    IN jtf_varchar2_table_300  ,
   p_pricing_attribute98    IN jtf_varchar2_table_300  ,
   p_pricing_attribute99    IN jtf_varchar2_table_300  ,
   p_pricing_attribute100   IN jtf_varchar2_table_300  ,
   p_context                IN jtf_varchar2_table_100  ,
   p_attribute1             IN jtf_varchar2_table_300  ,
   p_attribute2             IN jtf_varchar2_table_300  ,
   p_attribute3             IN jtf_varchar2_table_300  ,
   p_attribute4             IN jtf_varchar2_table_300  ,
   p_attribute5             IN jtf_varchar2_table_300  ,
   p_attribute6             IN jtf_varchar2_table_300  ,
   p_attribute7             IN jtf_varchar2_table_300  ,
   p_attribute8             IN jtf_varchar2_table_300  ,
   p_attribute9             IN jtf_varchar2_table_300  ,
   p_attribute10            IN jtf_varchar2_table_300  ,
   p_attribute11            IN jtf_varchar2_table_300  ,
   p_attribute12            IN jtf_varchar2_table_300  ,
   p_attribute13            IN jtf_varchar2_table_300  ,
   p_attribute14            IN jtf_varchar2_table_300  ,
   p_attribute15            IN jtf_varchar2_table_300
)
RETURN ASO_Quote_Pub.Price_Attributes_Tbl_Type
IS
   l_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line: 1348


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_attributes_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 1351


            l_price_attributes_tbl(i).last_update_date := p_last_update_date(i);

Line: 1354


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_price_attributes_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 1357


            l_price_attributes_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 1359


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_price_attributes_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 1362


            l_price_attributes_tbl(i).last_update_login := p_last_update_login(i);

Line: 1379


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_price_attributes_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 1382


            l_price_attributes_tbl(i).program_update_date := p_program_update_date(i);

Line: 1525


   p_last_update_date       IN DATE           ,
   p_last_updated_by        IN NUMBER         ,
   p_last_update_login      IN NUMBER         ,
   p_request_id             IN NUMBER         ,
   p_program_application_id IN NUMBER         ,
   p_program_id             IN NUMBER         ,
   p_program_update_date    IN DATE           ,
   p_quote_header_id        IN NUMBER         ,
   p_quote_line_id          IN NUMBER         ,
   p_promise_date           IN DATE           ,
   p_request_date           IN DATE           ,
   p_schedule_ship_date     IN DATE           ,
   p_ship_to_party_site_id  IN NUMBER         ,
   p_ship_to_party_id       IN NUMBER         ,
   p_ship_to_cust_acct_id   IN NUMBER         ,
   p_ship_partial_flag      IN VARCHAR2       ,
   p_ship_set_id            IN NUMBER         ,
   p_ship_method_code       IN VARCHAR2       ,
   p_freight_terms_code     IN VARCHAR2       ,
   p_freight_carrier_code   IN VARCHAR2       ,
   p_fob_code               IN VARCHAR2       ,
   p_shipment_priority_code IN VARCHAR2       ,
   p_shipping_instructions  IN VARCHAR2       ,
   p_packing_instructions   IN VARCHAR2       ,
   p_quantity               IN NUMBER         ,
   p_reserved_quantity      IN NUMBER         ,
   p_reservation_id         IN NUMBER         ,
   p_order_line_id          IN NUMBER         ,
   p_ship_to_party_name     IN VARCHAR2       ,
   p_ship_to_cont_fst_name  IN VARCHAR2       ,
   p_ship_to_cont_mid_name  IN VARCHAR2       ,
   p_ship_to_cont_lst_name  IN VARCHAR2       ,
   p_ship_to_address1       IN VARCHAR2       ,
   p_ship_to_address2       IN VARCHAR2       ,
   p_ship_to_address3       IN VARCHAR2       ,
   p_ship_to_address4       IN VARCHAR2       ,
   p_ship_to_country_code   IN VARCHAR2       ,
   p_ship_to_country        IN VARCHAR2       ,
   p_ship_to_city           IN VARCHAR2       ,
   p_ship_to_postal_code    IN VARCHAR2       ,
   p_ship_to_state          IN VARCHAR2       ,
   p_ship_to_province       IN VARCHAR2       ,
   p_ship_to_county         IN VARCHAR2       ,
   p_attribute_category     IN VARCHAR2       ,
   p_attribute1             IN VARCHAR2       ,
   p_attribute2             IN VARCHAR2       ,
   p_attribute3             IN VARCHAR2       ,
   p_attribute4             IN VARCHAR2       ,
   p_attribute5             IN VARCHAR2       ,
   p_attribute6             IN VARCHAR2       ,
   p_attribute7             IN VARCHAR2       ,
   p_attribute8             IN VARCHAR2       ,
   p_attribute9             IN VARCHAR2       ,
   p_attribute10            IN VARCHAR2       ,
   p_attribute11            IN VARCHAR2       ,
   p_attribute12            IN VARCHAR2       ,
   p_attribute13            IN VARCHAR2       ,
   p_attribute14            IN VARCHAR2       ,
   p_attribute15            IN VARCHAR2
)
RETURN ASO_Quote_Pub.Shipment_Rec_Type
IS
   l_shipment_Rec ASO_Quote_Pub.Shipment_Rec_Type;

Line: 1611


         IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
            l_shipment_rec.last_update_date := FND_API.G_MISS_DATE;

Line: 1614


            l_shipment_rec.last_update_date := p_last_update_date;

Line: 1616


         IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
            l_shipment_rec.last_updated_by := FND_API.G_MISS_NUM;

Line: 1619


            l_shipment_rec.last_updated_by := p_last_updated_by;

Line: 1621


         IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
            l_shipment_rec.last_update_login := FND_API.G_MISS_NUM;

Line: 1624


            l_shipment_rec.last_update_login := p_last_update_login;

Line: 1641


         IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
            l_shipment_rec.program_update_date := FND_API.G_MISS_DATE;

Line: 1644


            l_shipment_rec.program_update_date := p_program_update_date;

Line: 1762


   p_last_update_date       IN jtf_date_table           ,
   p_last_updated_by        IN jtf_number_table         ,
   p_last_update_login      IN jtf_number_table         ,
   p_request_id             IN jtf_number_table         ,
   p_program_application_id IN jtf_number_table         ,
   p_program_id             IN jtf_number_table         ,
   p_program_update_date    IN jtf_date_table           ,
   p_quote_header_id        IN jtf_number_table         ,
   p_quote_line_id          IN jtf_number_table         ,
   p_promise_date           IN jtf_date_table           ,
   p_request_date           IN jtf_date_table           ,
   p_schedule_ship_date     IN jtf_date_table           ,
   p_ship_to_party_site_id  IN jtf_number_table         ,
   p_ship_to_party_id       IN jtf_number_table         ,
   p_ship_to_cust_acct_id   IN jtf_number_table         ,
   p_ship_partial_flag      IN jtf_varchar2_table_300   ,
   p_ship_set_id            IN jtf_number_table         ,
   p_ship_method_code       IN jtf_varchar2_table_100   ,
   p_freight_terms_code     IN jtf_varchar2_table_100   ,
   p_freight_carrier_code   IN jtf_varchar2_table_100   ,
   p_fob_code               IN jtf_varchar2_table_100   ,
   p_shipment_priority_code IN jtf_varchar2_table_100   ,
   p_shipping_instructions  IN jtf_varchar2_table_2000  ,
   p_packing_instructions   IN jtf_varchar2_table_2000  ,
   p_quantity               IN jtf_number_table         ,
   p_reserved_quantity      IN jtf_number_table         ,
   p_reservation_id         IN jtf_number_table         ,
   p_order_line_id          IN jtf_number_table         ,
   p_ship_to_party_name     IN jtf_varchar2_table_300   ,
   p_ship_to_cont_fst_name  IN jtf_varchar2_table_100   ,
   p_ship_to_cont_mid_name  IN jtf_varchar2_table_100   ,
   p_ship_to_cont_lst_name  IN jtf_varchar2_table_100   ,
   p_ship_to_address1       IN jtf_varchar2_table_300   ,
   p_ship_to_address2       IN jtf_varchar2_table_300   ,
   p_ship_to_address3       IN jtf_varchar2_table_300   ,
   p_ship_to_address4       IN jtf_varchar2_table_300   ,
   p_ship_to_country_code   IN jtf_varchar2_table_100   ,
   p_ship_to_country        IN jtf_varchar2_table_100   ,
   p_ship_to_city           IN jtf_varchar2_table_100   ,
   p_ship_to_postal_code    IN jtf_varchar2_table_100   ,
   p_ship_to_state          IN jtf_varchar2_table_100   ,
   p_ship_to_province       IN jtf_varchar2_table_100   ,
   p_ship_to_county         IN jtf_varchar2_table_100   ,
   p_attribute_category     IN jtf_varchar2_table_100   ,
   p_attribute1             IN jtf_varchar2_table_200   ,
   p_attribute2             IN jtf_varchar2_table_200   ,
   p_attribute3             IN jtf_varchar2_table_200   ,
   p_attribute4             IN jtf_varchar2_table_200   ,
   p_attribute5             IN jtf_varchar2_table_200   ,
   p_attribute6             IN jtf_varchar2_table_200   ,
   p_attribute7             IN jtf_varchar2_table_200   ,
   p_attribute8             IN jtf_varchar2_table_200   ,
   p_attribute9             IN jtf_varchar2_table_200   ,
   p_attribute10            IN jtf_varchar2_table_200   ,
   p_attribute11            IN jtf_varchar2_table_200   ,
   p_attribute12            IN jtf_varchar2_table_200   ,
   p_attribute13            IN jtf_varchar2_table_200   ,
   p_attribute14            IN jtf_varchar2_table_200   ,
   p_attribute15            IN jtf_varchar2_table_200
)
RETURN ASO_Quote_Pub.Shipment_Tbl_Type
IS
   l_shipment_tbl ASO_Quote_Pub.Shipment_Tbl_Type;

Line: 1858


         IF ((p_last_update_date is not null ) and ((p_last_update_date(i) is null) or (p_last_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_shipment_tbl(i).last_update_date := p_last_update_date(i);

Line: 1862


         IF ((p_last_updated_by is not null ) and ((p_last_updated_by(i) is null) or (p_last_updated_by(i) <> ROSETTA_G_MISS_NUM))) THEN
            l_shipment_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 1866


         IF ((p_last_update_login is not null ) and ((p_last_update_login(i) is null) or (p_last_update_login(i) <> ROSETTA_G_MISS_NUM))) THEN
            l_shipment_tbl(i).last_update_login := p_last_update_login(i);

Line: 1882


         IF ((p_program_update_date is not null ) and ((p_program_update_date(i) is null) or (p_program_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_shipment_tbl(i).program_update_date := p_program_update_date(i);

Line: 2115


   p_last_update_date       IN jtf_date_table          ,
   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_login      IN jtf_number_table        ,
   p_request_id             IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_orig_tax_code          IN jtf_varchar2_table_300  ,
   p_tax_code               IN jtf_varchar2_table_100  ,
   p_tax_rate               IN jtf_number_table        ,
   p_tax_date               IN jtf_date_table          ,
   p_tax_amount             IN jtf_number_table        ,
   p_tax_exempt_flag        IN jtf_varchar2_table_100  ,
   p_tax_exempt_number      IN jtf_varchar2_table_100  ,
   p_tax_exempt_reason_code IN jtf_varchar2_table_100  ,
   p_attribute_category     IN jtf_varchar2_table_100  ,
   p_attribute1             IN jtf_varchar2_table_200  ,
   p_attribute2             IN jtf_varchar2_table_200  ,
   p_attribute3             IN jtf_varchar2_table_200  ,
   p_attribute4             IN jtf_varchar2_table_200  ,
   p_attribute5             IN jtf_varchar2_table_200  ,
   p_attribute6             IN jtf_varchar2_table_200  ,
   p_attribute7             IN jtf_varchar2_table_200  ,
   p_attribute8             IN jtf_varchar2_table_200  ,
   p_attribute9             IN jtf_varchar2_table_200  ,
   p_attribute10            IN jtf_varchar2_table_200  ,
   p_attribute11            IN jtf_varchar2_table_200  ,
   p_attribute12            IN jtf_varchar2_table_200  ,
   p_attribute13            IN jtf_varchar2_table_200  ,
   p_attribute14            IN jtf_varchar2_table_200  ,
   p_attribute15            IN jtf_varchar2_table_200
)
RETURN ASO_Quote_Pub.Tax_Detail_Tbl_Type
IS
   l_tax_detail_tbl ASO_Quote_Pub.Tax_Detail_Tbl_Type;

Line: 2195


         IF ((p_last_update_date is not null) and ((p_last_update_date(i) is null) or (p_last_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_tax_detail_tbl(i).last_update_date := p_last_update_date(i);

Line: 2199


         IF ((p_last_updated_by is not null) and ((p_last_updated_by(i) is null) or (p_last_updated_by(i)  <> ROSETTA_G_MISS_NUM))) THEN
            l_tax_detail_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 2203


         IF ((p_last_update_login is not null) and ((p_last_update_login(i) is null) or (p_last_update_login(i)  <> ROSETTA_G_MISS_NUM))) THEN
            l_tax_detail_tbl(i).last_update_login := p_last_update_login(i);

Line: 2219


         IF ((p_program_update_date is not null) and ((p_program_update_date(i) is null) or (p_program_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
            l_tax_detail_tbl(i).program_update_date := p_program_update_date(i);

Line: 2334


   p_last_updated_by            IN NUMBER    ,
   p_last_update_date           IN DATE      ,
   p_last_update_login          IN NUMBER    ,
   p_request_id                 IN NUMBER    ,
   p_program_application_id     IN NUMBER    ,
   p_program_id                 IN NUMBER    ,
   p_program_update_date        IN DATE      ,
   p_org_id                     IN NUMBER    ,
   p_quote_name                 IN VARCHAR2  ,
   p_quote_number               IN NUMBER    ,
   p_quote_version              IN NUMBER    ,
   p_quote_status_id            IN NUMBER    ,
   p_quote_source_code          IN VARCHAR2  ,
   p_quote_expiration_date      IN DATE      ,
   p_price_frozen_date          IN DATE      ,
   p_quote_password             IN VARCHAR2  ,
   p_original_system_reference  IN VARCHAR2  ,
   p_party_id                   IN NUMBER    ,
   p_cust_account_id            IN NUMBER    ,
   p_invoice_to_cust_account_id IN NUMBER    ,
   p_org_contact_id             IN NUMBER    ,
   p_party_name                 IN VARCHAR2  ,
   p_party_type                 IN VARCHAR2  ,
   p_person_first_name          IN VARCHAR2  ,
   p_person_last_name           IN VARCHAR2  ,
   p_person_middle_name         IN VARCHAR2  ,
   p_phone_id                   IN NUMBER    ,
   p_price_list_id              IN NUMBER    ,
   p_price_list_name            IN VARCHAR2  ,
   p_currency_code              IN VARCHAR2  ,
   p_total_list_price           IN NUMBER    ,
   p_total_adjusted_amount      IN NUMBER    ,
   p_total_adjusted_percent     IN NUMBER    ,
   p_total_tax                  IN NUMBER    ,
   p_total_shipping_charge      IN NUMBER    ,
   p_surcharge                  IN NUMBER    ,
   p_total_quote_price          IN NUMBER    ,
   p_payment_amount             IN NUMBER    ,
   p_accounting_rule_id         IN NUMBER    ,
   p_exchange_rate              IN NUMBER    ,
   p_exchange_type_code         IN VARCHAR2  ,
   p_exchange_rate_date         IN DATE      ,
   p_quote_category_code        IN VARCHAR2  ,
   p_quote_status_code          IN VARCHAR2  ,
   p_quote_status               IN VARCHAR2  ,
   p_employee_person_id         IN NUMBER    ,
   p_sales_channel_code         IN VARCHAR2  ,
--   p_salesrep_full_name         IN VARCHAR2  ,
   p_attribute_category         IN VARCHAR2  ,
-- added attribute 16-20 for bug 6873117 mgiridha
   p_attribute1                 IN VARCHAR2  ,
   p_attribute10                IN VARCHAR2  ,
   p_attribute11                IN VARCHAR2  ,
   p_attribute12                IN VARCHAR2  ,
   p_attribute13                IN VARCHAR2  ,
   p_attribute14                IN VARCHAR2  ,
   p_attribute15                IN VARCHAR2  ,
   p_attribute16                IN VARCHAR2  ,
   p_attribute17                IN VARCHAR2  ,
   p_attribute18                IN VARCHAR2  ,
   p_attribute19                IN VARCHAR2  ,
   p_attribute2                 IN VARCHAR2  ,
   p_attribute20                IN VARCHAR2  ,
   p_attribute3                 IN VARCHAR2  ,
   p_attribute4                 IN VARCHAR2  ,
   p_attribute5                 IN VARCHAR2  ,
   p_attribute6                 IN VARCHAR2  ,
   p_attribute7                 IN VARCHAR2  ,
   p_attribute8                 IN VARCHAR2  ,
   p_attribute9                 IN VARCHAR2  ,
   p_contract_id                IN NUMBER    ,
   p_qte_contract_id            IN NUMBER    ,
   p_ffm_request_id             IN NUMBER    ,
   p_invoice_to_address1        IN VARCHAR2  ,
   p_invoice_to_address2        IN VARCHAR2  ,
   p_invoice_to_address3        IN VARCHAR2  ,
   p_invoice_to_address4        IN VARCHAR2  ,
   p_invoice_to_city            IN VARCHAR2  ,
   p_invoice_to_cont_first_name IN VARCHAR2  ,
   p_invoice_to_cont_last_name  IN VARCHAR2  ,
   p_invoice_to_cont_mid_name   IN VARCHAR2  ,
   p_invoice_to_country_code    IN VARCHAR2  ,
   p_invoice_to_country         IN VARCHAR2  ,
   p_invoice_to_county          IN VARCHAR2  ,
   p_invoice_to_party_id        IN NUMBER    ,
   p_invoice_to_party_name      IN VARCHAR2  ,
   p_invoice_to_party_site_id   IN NUMBER    ,
   p_invoice_to_postal_code     IN VARCHAR2  ,
   p_invoice_to_province        IN VARCHAR2  ,
   p_invoice_to_state           IN VARCHAR2  ,
   p_invoicing_rule_id          IN NUMBER    ,
   p_marketing_source_code_id   IN NUMBER    ,
   p_marketing_source_code      IN VARCHAR2  ,
   p_marketing_source_name      IN VARCHAR2  ,
   p_orig_mktg_source_code_id   IN NUMBER    ,
   p_order_type_id              IN NUMBER    ,
   p_order_id                   IN NUMBER    ,
   p_order_number               IN NUMBER    ,
   p_order_type_name            IN VARCHAR2  ,
   p_ordered_date               IN DATE      ,
   p_resource_id                IN NUMBER    ,
   p_end_customer_party_id      IN NUMBER    ,
   p_end_customer_cust_party_id IN NUMBER    ,
   p_end_customer_party_site_id IN NUMBER    ,
   p_end_customer_cust_account_id IN NUMBER	 ,
   p_pricing_status_indicator	IN	VARCHAR2 := FND_API.G_MISS_CHAR,
   p_tax_status_indicator		IN	VARCHAR2 := FND_API.G_MISS_CHAR
)
RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
IS
   l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;

Line: 2461


   IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
      l_qte_header.last_updated_by := FND_API.G_MISS_NUM;

Line: 2464


      l_qte_header.last_updated_by := p_last_updated_by;

Line: 2466


   IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
      l_qte_header.last_update_date := FND_API.G_MISS_DATE;

Line: 2469


      l_qte_header.last_update_date := p_last_update_date;

Line: 2471


   IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
      l_qte_header.last_update_login := FND_API.G_MISS_NUM;

Line: 2474


      l_qte_header.last_update_login := p_last_update_login;

Line: 2491


   IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
      l_qte_header.program_update_date := FND_API.G_MISS_DATE;

Line: 2494


      l_qte_header.program_update_date := p_program_update_date;

Line: 2767


   p_last_updated_by          IN jtf_number_table        ,
   p_last_update_date         IN jtf_date_table          ,
   p_last_update_login        IN jtf_number_table        ,
   p_request_id               IN jtf_number_table        ,
   p_program_application_id   IN jtf_number_table        ,
   p_program_id               IN jtf_number_table        ,
   p_program_update_date      IN jtf_date_table          ,
   p_quote_line_id            IN jtf_number_table        ,
   p_quote_header_id          IN jtf_number_table        ,
   p_org_id                   IN jtf_number_table        ,
   p_line_number              IN jtf_number_table        ,
   p_line_category_code       IN jtf_varchar2_table_100  ,
   p_item_type_code           IN jtf_varchar2_table_100  ,
   p_inventory_item_id        IN jtf_number_table        ,
   p_organization_id          IN jtf_number_table        ,
   p_quantity                 IN jtf_number_table        ,
   p_uom_code                 IN jtf_varchar2_table_100  ,
   p_start_date_active        IN jtf_date_table          ,
   p_end_date_active          IN jtf_date_table          ,
   p_order_line_type_id       IN jtf_number_table        ,
   p_price_list_id            IN jtf_number_table        ,
   p_price_list_line_id       IN jtf_number_table        ,
   p_currency_code            IN jtf_varchar2_table_100  ,
   p_line_list_price          IN jtf_number_table        ,
   p_line_adjusted_amount     IN jtf_number_table        ,
   p_line_adjusted_percent    IN jtf_number_table        ,
   p_line_quote_price         IN jtf_number_table        ,
   p_related_item_id          IN jtf_number_table        ,
   p_item_relationship_type   IN jtf_varchar2_table_100  ,
   p_split_shipment_flag      IN jtf_varchar2_table_100  ,
   p_backorder_flag           IN jtf_varchar2_table_100  ,
   p_selling_price_change     IN jtf_varchar2_table_100  ,
   p_recalculate_flag         IN jtf_varchar2_table_100  ,
   p_attribute_category       IN jtf_varchar2_table_100  ,
   p_attribute1               IN jtf_varchar2_table_300  ,
   p_attribute2               IN jtf_varchar2_table_300  ,
   p_attribute3               IN jtf_varchar2_table_300  ,
   p_attribute4               IN jtf_varchar2_table_300  ,
   p_attribute5               IN jtf_varchar2_table_300  ,
   p_attribute6               IN jtf_varchar2_table_300  ,
   p_attribute7               IN jtf_varchar2_table_300  ,
   p_attribute8               IN jtf_varchar2_table_300  ,
   p_attribute9               IN jtf_varchar2_table_300  ,
   p_attribute10              IN jtf_varchar2_table_300  ,
   p_attribute11              IN jtf_varchar2_table_300  ,
   p_attribute12              IN jtf_varchar2_table_300  ,
   p_attribute13              IN jtf_varchar2_table_300  ,
   p_attribute14              IN jtf_varchar2_table_300  ,
   p_attribute15              IN jtf_varchar2_table_300  ,
   p_accounting_rule_id       IN jtf_number_table        ,
   p_ffm_content_name         IN jtf_varchar2_table_300  ,
   p_ffm_content_type         IN jtf_varchar2_table_300  ,
   p_ffm_document_type        IN jtf_varchar2_table_300  ,
   p_ffm_media_id             IN jtf_varchar2_table_300  ,
   p_ffm_media_type           IN jtf_varchar2_table_300  ,
   p_ffm_user_note            IN jtf_varchar2_table_300  ,
   p_invoice_to_party_id      IN jtf_number_table        ,
   p_invoice_to_party_site_id IN jtf_number_table        ,
   p_invoice_to_cust_acct_id  IN jtf_number_table        ,
   p_invoicing_rule_id        IN jtf_number_table        ,
   p_marketing_source_code_id IN jtf_number_table        ,
   p_commitment_id            IN jtf_number_table        ,
   p_agreement_id             IN jtf_number_table        ,
   p_minisite_id              IN jtf_number_table        ,
   p_section_id               IN jtf_number_table        ,
   p_operation_code           IN jtf_varchar2_table_100  ,
   p_end_customer_party_id        IN jtf_number_table    ,
   p_end_customer_cust_party_id   IN jtf_number_table    ,
   p_end_customer_party_site_id   IN jtf_number_table    ,
   p_end_customer_cust_account_id IN jtf_number_table
)
RETURN ASO_Quote_Pub.Qte_Line_Tbl_Type
IS
   l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;

Line: 2863


        IF ((p_last_updated_by is not null) and ((p_last_updated_by(i) is null) or  (p_last_updated_by(i)<> ROSETTA_G_MISS_NUM))) THEN
           l_qte_line_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 2867


        IF ((p_last_update_date is not null) and ((p_last_update_date(i) is null) or  (p_last_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
           l_qte_line_tbl(i).last_update_date := p_last_update_date(i);

Line: 2871


        IF ((p_last_update_login is not null) and ((p_last_update_login(i) is null) or (p_last_update_login(i) <> ROSETTA_G_MISS_NUM))) THEN
           l_qte_line_tbl(i).last_update_login := p_last_update_login(i);

Line: 2887


        IF ((p_program_update_date is not null) and ((p_program_update_date(i) is null) or  (p_program_update_date(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
           l_qte_line_tbl(i).program_update_date := p_program_update_date(i);

Line: 3155


   p_last_update_date         IN jtf_date_table           ,
   p_last_updated_by          IN jtf_number_table         ,
   p_last_update_login        IN jtf_number_table         ,
   p_request_id               IN jtf_number_table         ,
   p_program_application_id   IN jtf_number_table         ,
   p_program_id               IN jtf_number_table         ,
   p_program_update_date      IN jtf_date_table           ,
   p_quote_line_id            IN jtf_number_table         ,
   p_config_header_id         IN jtf_number_table         ,
   p_config_revision_num      IN jtf_number_table         ,
   p_config_item_id           IN jtf_number_table         ,
   p_complete_configuration   IN jtf_varchar2_table_100   ,
   p_valid_configuration_flag IN jtf_varchar2_table_100   ,
   p_component_code           IN jtf_varchar2_table_1000  ,
   p_service_coterminate_flag IN jtf_varchar2_table_100   ,
   p_service_duration         IN jtf_number_table         ,
   p_service_period           IN jtf_varchar2_table_100   ,
   p_service_unit_selling     IN jtf_number_table         ,
   p_service_unit_list        IN jtf_number_table         ,
   p_service_number           IN jtf_number_table         ,
   p_unit_percent_base_price  IN jtf_number_table         ,
   p_attribute_category       IN jtf_varchar2_table_100   ,
   p_attribute1               IN jtf_varchar2_table_200   ,
   p_attribute2               IN jtf_varchar2_table_200   ,
   p_attribute3               IN jtf_varchar2_table_200   ,
   p_attribute4               IN jtf_varchar2_table_200   ,
   p_attribute5               IN jtf_varchar2_table_200   ,
   p_attribute6               IN jtf_varchar2_table_200   ,
   p_attribute7               IN jtf_varchar2_table_200   ,
   p_attribute8               IN jtf_varchar2_table_200   ,
   p_attribute9               IN jtf_varchar2_table_200   ,
   p_attribute10              IN jtf_varchar2_table_200   ,
   p_attribute11              IN jtf_varchar2_table_200   ,
   p_attribute12              IN jtf_varchar2_table_200   ,
   p_attribute13              IN jtf_varchar2_table_200   ,
   p_attribute14              IN jtf_varchar2_table_200   ,
   p_attribute15              IN jtf_varchar2_table_200   ,
   p_service_ref_type_code    IN jtf_varchar2_table_100   ,
   p_service_ref_order_number IN jtf_number_table         ,
   p_service_ref_line_number  IN jtf_number_table         ,
   p_service_ref_qte_line_ind IN jtf_number_table         ,
   p_service_ref_line_id      IN jtf_number_table         ,
   p_service_ref_system_id    IN jtf_number_table         ,
   p_service_ref_option_numb  IN jtf_number_table         ,
   p_service_ref_shipment     IN jtf_number_table         ,
   p_return_ref_type          IN jtf_varchar2_table_100   ,
   p_return_ref_header_id     IN jtf_number_table         ,
   p_return_ref_line_id       IN jtf_number_table         ,
   p_return_attribute1        IN jtf_varchar2_table_300   ,
   p_return_attribute2        IN jtf_varchar2_table_300   ,
   p_return_attribute3        IN jtf_varchar2_table_300   ,
   p_return_attribute4        IN jtf_varchar2_table_300   ,
   p_return_attribute5        IN jtf_varchar2_table_300   ,
   p_return_attribute6        IN jtf_varchar2_table_300   ,
   p_return_attribute7        IN jtf_varchar2_table_300   ,
   p_return_attribute8        IN jtf_varchar2_table_300   ,
   p_return_attribute9        IN jtf_varchar2_table_300   ,
   p_return_attribute10       IN jtf_varchar2_table_300   ,
   p_return_attribute11       IN jtf_varchar2_table_300   ,
   p_return_attribute12       IN jtf_varchar2_table_300   ,
   p_return_attribute13       IN jtf_varchar2_table_300   ,
   p_return_attribute14       IN jtf_varchar2_table_300   ,
   p_return_attribute15       IN jtf_varchar2_table_300   ,
   p_operation_code           IN jtf_varchar2_table_100   ,
   p_qte_line_index           IN jtf_number_table         ,
   p_return_attr_category     IN jtf_varchar2_table_100   ,
   p_return_reason_code       IN jtf_varchar2_table_100
)
RETURN ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type
IS
   l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

Line: 3250


         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;

Line: 3253


            l_qte_line_dtl_tbl(i).last_update_date := p_last_update_date(i);

Line: 3255


         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;

Line: 3258


            l_qte_line_dtl_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 3260


         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;

Line: 3263


            l_qte_line_dtl_tbl(i).last_update_login := p_last_update_login(i);

Line: 3280


         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;

Line: 3283


            l_qte_line_dtl_tbl(i).program_update_date := p_program_update_date(i);

Line: 3432


   p_last_updated_by        IN jtf_number_table        ,
   p_last_update_date       IN jtf_date_table          ,
   p_last_update_login      IN jtf_number_table        ,
   p_request_id             IN jtf_number_table        ,
   p_program_application_id IN jtf_number_table        ,
   p_program_id             IN jtf_number_table        ,
   p_program_update_date    IN jtf_date_table          ,
   p_quote_line_id          IN jtf_number_table        ,
   p_related_quote_line_id  IN jtf_number_table        ,
   p_relationship_type_code IN jtf_varchar2_table_100  ,
   p_reciprocal_flag        IN jtf_varchar2_table_100  ,
   p_qte_line_index         IN jtf_number_table        ,
   p_related_qte_line_index IN jtf_number_table        ,
   p_operation_code         IN jtf_varchar2_table_100
)
RETURN ASO_Quote_Pub.Line_Rltship_Tbl_Type
IS
   l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line: 3475


         IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
            l_line_rltship_tbl(i).last_updated_by := FND_API.G_MISS_NUM;

Line: 3478


            l_line_rltship_tbl(i).last_updated_by := p_last_updated_by(i);

Line: 3480


         IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_line_rltship_tbl(i).last_update_date := FND_API.G_MISS_DATE;

Line: 3483


            l_line_rltship_tbl(i).last_update_date := p_last_update_date(i);

Line: 3485


         IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
            l_line_rltship_tbl(i).last_update_login := FND_API.G_MISS_NUM;

Line: 3488


            l_line_rltship_tbl(i).last_update_login := p_last_update_login(i);

Line: 3505


         IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
            l_line_rltship_tbl(i).program_update_date := FND_API.G_MISS_DATE;

Line: 3508


            l_line_rltship_tbl(i).program_update_date := p_program_update_date(i);

Line: 3548


   x_last_update_date             OUT NOCOPY DATE                          ,
   p_auto_update_active_quote     IN  VARCHAR2 := FND_API.G_TRUE    ,
   p_combinesameitem              IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_sharee_number                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_sharee_party_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_sharee_cust_account_id       IN  NUMBER   := FND_API.G_MISS_NUM,
   p_c_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_c_auto_version_flag          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_pricing_request_type       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_header_pricing_event       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_line_pricing_event         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_tax_flag               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_freight_charge_flag    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_price_mode		  IN  VARCHAR2 := 'ENTIRE_QUOTE'     ,  -- change line logic pricing
   p_q_quote_header_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_creation_date              IN  DATE     := FND_API.G_MISS_DATE,
   p_q_created_by                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_updated_by            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_q_last_update_login          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_request_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_application_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_update_date        IN  DATE     := FND_API.G_MISS_DATE,
   p_q_org_id                     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_version              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_status_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_source_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_expiration_date      IN  DATE     := FND_API.G_MISS_DATE,
   p_q_price_frozen_date          IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_password             IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_original_system_reference  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_cust_account_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_cust_account_id IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_org_contact_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_party_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_type                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_first_name          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_last_name           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_middle_name         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_phone_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_currency_code              IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_total_list_price           IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_amount      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_percent     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_tax                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_shipping_charge      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_surcharge                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_quote_price          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_payment_amount             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_accounting_rule_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_rate              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_type_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_exchange_rate_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_category_code        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_employee_person_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_sales_channel_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
--   p_q_salesrep_full_name         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute_category         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute1                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute10                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute11                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute12                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute13                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute14                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute15                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute16                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute17                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute18                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute19                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute2                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute20                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute3                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute4                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute5                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute6                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute7                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute8                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute9                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_contract_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_qte_contract_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_ffm_request_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_address1        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address2        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address3        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address4        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_city            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_first_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_last_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_mid_name   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country_code    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_county          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_id        IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_party_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_site_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_postal_code     IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_province        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_state           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoicing_rule_id          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_marketing_source_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_orig_mktg_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_ordered_date               IN  DATE     := FND_API.G_MISS_DATE,
   p_q_resource_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_save_type                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_minisite_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_party_id          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_cust_party_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_party_site_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_cust_account_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_pricing_status_indicator   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_tax_status_indicator   	  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_ql_creation_date            IN jtf_date_table         := NULL,
   p_ql_created_by               IN jtf_number_table       := NULL,
   p_ql_last_updated_by          IN jtf_number_table       := NULL,
   p_ql_last_update_date         IN jtf_date_table         := NULL,
   p_ql_last_update_login        IN jtf_number_table       := NULL,
   p_ql_request_id               IN jtf_number_table       := NULL,
   p_ql_program_application_id   IN jtf_number_table       := NULL,
   p_ql_program_id               IN jtf_number_table       := NULL,
   p_ql_program_update_date      IN jtf_date_table         := NULL,
   p_ql_quote_line_id            IN jtf_number_table       := NULL,
   p_ql_quote_header_id          IN jtf_number_table       := NULL,
   p_ql_org_id                   IN jtf_number_table       := NULL,
   p_ql_line_number              IN jtf_number_table       := NULL,
   p_ql_line_category_code       IN jtf_varchar2_table_100 := NULL,
   p_ql_item_type_code           IN jtf_varchar2_table_100 := NULL,
   p_ql_inventory_item_id        IN jtf_number_table       := NULL,
   p_ql_organization_id          IN jtf_number_table       := NULL,
   p_ql_quantity                 IN jtf_number_table       := NULL,
   p_ql_uom_code                 IN jtf_varchar2_table_100 := NULL,
   p_ql_start_date_active        IN jtf_date_table         := NULL,
   p_ql_end_date_active          IN jtf_date_table         := NULL,
   p_ql_order_line_type_id       IN jtf_number_table       := NULL,
   p_ql_price_list_id            IN jtf_number_table       := NULL,
   p_ql_price_list_line_id       IN jtf_number_table       := NULL,
   p_ql_currency_code            IN jtf_varchar2_table_100 := NULL,
   p_ql_line_list_price          IN jtf_number_table       := NULL,
   p_ql_line_adjusted_amount     IN jtf_number_table       := NULL,
   p_ql_line_adjusted_percent    IN jtf_number_table       := NULL,
   p_ql_line_quote_price         IN jtf_number_table       := NULL,
   p_ql_related_item_id          IN jtf_number_table       := NULL,
   p_ql_item_relationship_type   IN jtf_varchar2_table_100 := NULL,
   p_ql_split_shipment_flag      IN jtf_varchar2_table_100 := NULL,
   p_ql_backorder_flag           IN jtf_varchar2_table_100 := NULL,
   p_ql_selling_price_change     IN jtf_varchar2_table_100 := NULL,
   p_ql_recalculate_flag         IN jtf_varchar2_table_100 := NULL,
   p_ql_attribute_category       IN jtf_varchar2_table_100 := NULL,
   p_ql_attribute1               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute2               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute3               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute4               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute5               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute6               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute7               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute8               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute9               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute10              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute11              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute12              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute13              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute14              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute15              IN jtf_varchar2_table_300 := NULL,
   p_ql_accounting_rule_id       IN jtf_number_table       := NULL,
   p_ql_ffm_content_name         IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_content_type         IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_document_type        IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_media_id             IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_media_type           IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_user_note            IN jtf_varchar2_table_300 := NULL,
   p_ql_invoice_to_party_id      IN jtf_number_table       := NULL,
   p_ql_invoice_to_party_site_id IN jtf_number_table       := NULL,
   p_ql_invoice_to_cust_acct_id  IN jtf_number_table       := NULL,
   p_ql_invoicing_rule_id        IN jtf_number_table       := NULL,
   p_ql_marketing_source_code_id IN jtf_number_table       := NULL,
   p_ql_operation_code           IN jtf_varchar2_table_100 := NULL,
   p_ql_commitment_id            IN jtf_number_table       := NULL,
   p_ql_agreement_id             IN jtf_number_table       := NULL,
   p_ql_minisite_id              IN jtf_number_table       := NULL,
   p_ql_section_id               IN jtf_number_table       := NULL,
   p_ql_line_codes               IN jtf_number_table       := NULL,
   p_ql_end_cust_party_id        IN jtf_number_table       := NULL,
   p_ql_end_cust_cust_party_id   IN jtf_number_table       := NULL,
   p_ql_end_cust_party_site_id   IN jtf_number_table       := NULL,
   p_ql_end_cust_cust_account_id IN jtf_number_table       := NULL,
   p_qrl_line_relationship_id     IN  jtf_number_table := NULL,
   p_qrl_creation_date            IN  jtf_date_table   := NULL,
   p_qrl_created_by               IN  jtf_number_table := NULL,
   p_qrl_last_updated_by          IN  jtf_number_table := NULL,
   p_qrl_last_update_date         IN  jtf_date_table   := NULL,
   p_qrl_last_update_login        IN  jtf_number_table := NULL,
   p_qrl_request_id               IN  jtf_number_table := NULL,
   p_qrl_program_application_id   IN  jtf_number_table := NULL,
   p_qrl_program_id               IN  jtf_number_table := NULL,
   p_qrl_program_update_date      IN  jtf_date_table   := NULL,
   p_qrl_quote_line_id            IN  jtf_number_table := NULL,
   p_qrl_related_quote_line_id    IN  jtf_number_table := NULL,
   p_qrl_relationship_type_code   IN  jtf_varchar2_table_100 := NULL,
   p_qrl_reciprocal_flag          IN  jtf_varchar2_table_100 := NULL,
   p_qrl_qte_line_index           IN  jtf_number_table := NULL,
   p_qrl_related_qte_line_index   IN  jtf_number_table := NULL,
   p_qrl_operation_code           IN  JTF_VARCHAR2_TABLE_100 := null,
   p_qdl_quote_line_detail_id     IN jtf_number_table        := NULL,
   p_qdl_creation_date            IN jtf_date_table          := NULL,
   p_qdl_created_by               IN jtf_number_table        := NULL,
   p_qdl_last_update_date         IN jtf_date_table          := NULL,
   p_qdl_last_updated_by          IN jtf_number_table        := NULL,
   p_qdl_last_update_login        IN jtf_number_table        := NULL,
   p_qdl_request_id               IN jtf_number_table        := NULL,
   p_qdl_program_application_id   IN jtf_number_table        := NULL,
   p_qdl_program_id               IN jtf_number_table        := NULL,
   p_qdl_program_update_date      IN jtf_date_table          := NULL,
   p_qdl_quote_line_id            IN jtf_number_table        := NULL,
   p_qdl_config_header_id         IN jtf_number_table        := NULL,
   p_qdl_config_revision_num      IN jtf_number_table        := NULL,
   p_qdl_config_item_id           IN jtf_number_table        := NULL,
   p_qdl_complete_configuration   IN jtf_varchar2_table_100  := NULL,
   p_qdl_valid_configuration_flag IN jtf_varchar2_table_100  := NULL,
   p_qdl_component_code           IN jtf_varchar2_table_1000 := NULL,
   p_qdl_service_coterminate_flag IN jtf_varchar2_table_100  := NULL,
   p_qdl_service_duration         IN jtf_number_table        := NULL,
   p_qdl_service_period           IN jtf_varchar2_table_100  := NULL,
   p_qdl_service_unit_selling     IN jtf_number_table        := NULL,
   p_qdl_service_unit_list        IN jtf_number_table        := NULL,
   p_qdl_service_number           IN jtf_number_table        := NULL,
   p_qdl_unit_percent_base_price  IN jtf_number_table        := NULL,
   p_qdl_attribute_category       IN jtf_varchar2_table_100  := NULL,
   p_qdl_attribute1               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute2               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute3               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute4               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute5               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute6               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute7               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute8               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute9               IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute10              IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute11              IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute12              IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute13              IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute14              IN jtf_varchar2_table_200  := NULL,
   p_qdl_attribute15              IN jtf_varchar2_table_200  := NULL,
   p_qdl_service_ref_type_code    IN jtf_varchar2_table_100  := NULL,
   p_qdl_service_ref_order_number IN jtf_number_table        := NULL,
   p_qdl_service_ref_line_number  IN jtf_number_table        := NULL,
   p_qdl_service_ref_qte_line_ind IN jtf_number_table        := NULL,
   p_qdl_service_ref_line_id      IN jtf_number_table        := NULL,
   p_qdl_service_ref_system_id    IN jtf_number_table        := NULL,
   p_qdl_service_ref_option_numb  IN jtf_number_table        := NULL,
   p_qdl_service_ref_shipment     IN jtf_number_table        := NULL,
   p_qdl_return_ref_type          IN jtf_varchar2_table_100  := NULL,
   p_qdl_return_ref_header_id     IN jtf_number_table        := NULL,
   p_qdl_return_ref_line_id       IN jtf_number_table        := NULL,
   p_qdl_return_attribute1        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute2        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute3        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute4        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute5        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute6        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute7        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute8        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute9        IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute10       IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute11       IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute12       IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute13       IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute14       IN jtf_varchar2_table_300  := NULL,
   p_qdl_return_attribute15       IN jtf_varchar2_table_300  := NULL,
   p_qdl_operation_code           IN jtf_varchar2_table_100  := NULL,
   p_qdl_qte_line_index           IN jtf_number_table        := NULL,
   p_qdl_return_attr_category     IN jtf_varchar2_table_100  := NULL,
   p_qdl_return_reason_code       IN jtf_varchar2_table_100  := NULL,
   p_qpa_operation_code         IN jtf_varchar2_table_100 := NULL,
   p_qpa_qte_line_index         IN jtf_number_table       := NULL,
   p_qpa_price_attribute_id     IN jtf_number_table       := NULL,
   p_qpa_creation_date          IN jtf_date_table         := NULL,
   p_qpa_created_by             IN jtf_number_table       := NULL,
   p_qpa_last_update_date       IN jtf_date_table         := NULL,
   p_qpa_last_updated_by        IN jtf_number_table       := NULL,
   p_qpa_last_update_login      IN jtf_number_table       := NULL,
   p_qpa_request_id             IN jtf_number_table       := NULL,
   p_qpa_program_application_id IN jtf_number_table       := NULL,
   p_qpa_program_id             IN jtf_number_table       := NULL,
   p_qpa_program_update_date    IN jtf_date_table         := NULL,
   p_qpa_quote_header_id        IN jtf_number_table       := NULL,
   p_qpa_quote_line_id          IN jtf_number_table       := NULL,
   p_qpa_flex_title             IN jtf_varchar2_table_100 := NULL,
   p_qpa_pricing_context        IN jtf_varchar2_table_100 := NULL,
   p_qpa_pricing_attribute1     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute2     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute3     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute4     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute5     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute6     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute7     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute8     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute9     IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute10    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute11    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute12    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute13    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute14    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute15    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute16    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute17    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute18    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute19    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute20    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute21    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute22    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute23    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute24    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute25    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute26    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute27    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute28    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute29    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute30    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute31    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute32    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute33    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute34    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute35    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute36    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute37    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute38    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute39    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute40    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute41    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute42    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute43    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute44    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute45    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute46    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute47    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute48    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute49    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute50    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute51    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute52    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute53    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute54    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute55    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute56    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute57    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute58    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute59    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute60    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute61    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute62    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute63    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute64    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute65    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute66    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute67    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute68    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute69    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute70    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute71    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute72    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute73    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute74    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute75    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute76    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute77    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute78    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute79    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute80    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute81    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute82    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute83    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute84    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute85    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute86    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute87    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute88    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute89    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute90    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute91    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute92    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute93    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute94    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute95    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute96    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute97    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute98    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute99    IN jtf_varchar2_table_300 := NULL,
   p_qpa_pricing_attribute100   IN jtf_varchar2_table_300 := NULL,
   p_qpa_context                IN jtf_varchar2_table_100 := NULL,
   p_qpa_attribute1             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute2             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute3             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute4             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute5             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute6             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute7             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute8             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute9             IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute10            IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute11            IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute12            IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute13            IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute14            IN jtf_varchar2_table_300 := NULL,
   p_qpa_attribute15            IN jtf_varchar2_table_300 := NULL,
   p_qp_operation_code            IN  jtf_varchar2_table_100 := NULL,
   p_qp_qte_line_index            IN  jtf_number_table := NULL,
   p_qp_payment_id                IN  jtf_number_table := NULL,
   p_qp_creation_date             IN  jtf_date_table   := NULL,
   p_qp_created_by                IN  jtf_number_table := NULL,
   p_qp_last_update_date          IN  jtf_date_table   := NULL,
   p_qp_last_updated_by           IN  jtf_number_table := NULL,
   p_qp_last_update_login         IN  jtf_number_table := NULL,
   p_qp_request_id                IN  jtf_number_table := NULL,
   p_qp_program_application_id    IN  jtf_number_table := NULL,
   p_qp_program_id                IN  jtf_number_table := NULL,
   p_qp_program_update_date       IN  jtf_date_table   := NULL,
   p_qp_quote_header_id           IN  jtf_number_table := NULL,
   p_qp_quote_line_id             IN  jtf_number_table := NULL,
   p_qp_payment_type_code         IN  jtf_varchar2_table_100 := NULL,
   p_qp_payment_ref_number        IN  jtf_varchar2_table_300 := NULL,
   p_qp_payment_option            IN  jtf_varchar2_table_300 := NULL,
   p_qp_payment_term_id           IN  jtf_number_table := NULL,
   p_qp_credit_card_code          IN  jtf_varchar2_table_100 := NULL,
   p_qp_credit_card_holder_name   IN  jtf_varchar2_table_100 := NULL,
   p_qp_credit_card_exp_date      IN  jtf_date_table   := NULL,
   p_qp_credit_card_approval_code IN  jtf_varchar2_table_100 := NULL,
   p_qp_credit_card_approval_date IN  jtf_date_table   := NULL,
   p_qp_payment_amount            IN  jtf_number_table := NULL,
   p_qp_cust_po_number            IN  jtf_varchar2_table_100 := NULL,
   p_qp_attribute_category        IN  jtf_varchar2_table_100 := NULL,
   p_qp_attribute1                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute2                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute3                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute4                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute5                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute6                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute7                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute8                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute9                IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute10               IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute11               IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute12               IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute13               IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute14               IN  jtf_varchar2_table_200 := NULL,
   p_qp_attribute15               IN  jtf_varchar2_table_200 := NULL,
   p_qp_assignment_id             IN  jtf_number_table := NULL,
   p_qp_cvv2                      IN  jtf_varchar2_table_200 := NULL,
   p_qs_operation_code         IN jtf_varchar2_table_100  := NULL,
   p_qs_qte_line_index         IN jtf_number_table        := NULL,
   p_qs_shipment_id            IN jtf_number_table        := NULL,
   p_qs_creation_date          IN jtf_date_table          := NULL,
   p_qs_created_by             IN jtf_number_table        := NULL,
   p_qs_last_update_date       IN jtf_date_table          := NULL,
   p_qs_last_updated_by        IN jtf_number_table        := NULL,
   p_qs_last_update_login      IN jtf_number_table        := NULL,
   p_qs_request_id             IN jtf_number_table        := NULL,
   p_qs_program_application_id IN jtf_number_table        := NULL,
   p_qs_program_id             IN jtf_number_table        := NULL,
   p_qs_program_update_date    IN jtf_date_table          := NULL,
   p_qs_quote_header_id        IN jtf_number_table        := NULL,
   p_qs_quote_line_id          IN jtf_number_table        := NULL,
   p_qs_promise_date           IN jtf_date_table          := NULL,
   p_qs_request_date           IN jtf_date_table          := NULL,
   p_qs_schedule_ship_date     IN jtf_date_table          := NULL,
   p_qs_ship_to_party_site_id  IN jtf_number_table        := NULL,
   p_qs_ship_to_party_id       IN jtf_number_table        := NULL,
   p_qs_ship_to_cust_acct_id   IN jtf_number_table        := NULL,
   p_qs_ship_partial_flag      IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_set_id            IN jtf_number_table        := NULL,
   p_qs_ship_method_code       IN jtf_varchar2_table_100  := NULL,
   p_qs_freight_terms_code     IN jtf_varchar2_table_100  := NULL,
   p_qs_freight_carrier_code   IN jtf_varchar2_table_100  := NULL,
   p_qs_fob_code               IN jtf_varchar2_table_100  := NULL,
   p_qs_shipment_priority_code IN jtf_varchar2_table_100  := NULL,
   p_qs_shipping_instructions  IN jtf_varchar2_table_2000 := NULL,
   p_qs_packing_instructions   IN jtf_varchar2_table_2000 := NULL,
   p_qs_quantity               IN jtf_number_table        := NULL,
   p_qs_reserved_quantity      IN jtf_number_table        := NULL,
   p_qs_reservation_id         IN jtf_number_table        := NULL,
   p_qs_order_line_id          IN jtf_number_table        := NULL,
   p_qs_ship_to_party_name     IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_to_cont_fst_name  IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_cont_mid_name  IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_cont_lst_name  IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_address1       IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_to_address2       IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_to_address3       IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_to_address4       IN jtf_varchar2_table_300  := NULL,
   p_qs_ship_to_country_code   IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_country        IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_city           IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_postal_code    IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_state          IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_province       IN jtf_varchar2_table_100  := NULL,
   p_qs_ship_to_county         IN jtf_varchar2_table_100  := NULL,
   p_qs_attribute_category     IN jtf_varchar2_table_100  := NULL,
   p_qs_attribute1             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute2             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute3             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute4             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute5             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute6             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute7             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute8             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute9             IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute10            IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute11            IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute12            IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute13            IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute14            IN jtf_varchar2_table_200  := NULL,
   p_qs_attribute15            IN jtf_varchar2_table_200  := NULL,
   p_qt_operation_code            IN  jtf_varchar2_table_100 := NULL,
   p_qt_qte_line_index            IN  jtf_number_table := NULL,
   p_qt_shipment_index            IN  jtf_number_table := NULL,
   p_qt_tax_detail_id             IN  jtf_number_table := NULL,
   p_qt_quote_header_id           IN  jtf_number_table := NULL,
   p_qt_quote_line_id             IN  jtf_number_table := NULL,
   p_qt_quote_shipment_id         IN  jtf_number_table := NULL,
   p_qt_creation_date             IN  jtf_date_table   := NULL,
   p_qt_created_by                IN  jtf_number_table := NULL,
   p_qt_last_update_date          IN  jtf_date_table   := NULL,
   p_qt_last_updated_by           IN  jtf_number_table := NULL,
   p_qt_last_update_login         IN  jtf_number_table := NULL,
   p_qt_request_id                IN  jtf_number_table := NULL,
   p_qt_program_application_id    IN  jtf_number_table := NULL,
   p_qt_program_id                IN  jtf_number_table := NULL,
   p_qt_program_update_date       IN  jtf_date_table   := NULL,
   p_qt_orig_tax_code             IN  jtf_varchar2_table_300 := NULL,
   p_qt_tax_code                  IN  jtf_varchar2_table_100 := NULL,
   p_qt_tax_rate                  IN  jtf_number_table := NULL,
   p_qt_tax_date                  IN  jtf_date_table   := NULL,
   p_qt_tax_amount                IN  jtf_number_table := NULL,
   p_qt_tax_exempt_flag           IN  jtf_varchar2_table_100 := NULL,
   p_qt_tax_exempt_number         IN  jtf_varchar2_table_100 := NULL,
   p_qt_tax_exempt_reason_code    IN  jtf_varchar2_table_100 := NULL,
   p_qt_attribute_category        IN  jtf_varchar2_table_100 := NULL,
   p_qt_attribute1                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute2                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute3                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute4                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute5                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute6                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute7                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute8                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute9                IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute10               IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute11               IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute12               IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute13               IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute14               IN  jtf_varchar2_table_200 := NULL,
   p_qt_attribute15               IN  jtf_varchar2_table_200 := NULL,
   p_qlpa_operation_code          IN  jtf_varchar2_table_100 := NULL,
   p_qlpa_qte_line_index          IN  jtf_number_table := NULL,
   p_qlpa_price_attribute_id      IN  jtf_number_table := NULL,
   p_qlpa_creation_date           IN  jtf_date_table   := NULL,
   p_qlpa_created_by              IN  jtf_number_table := NULL,
   p_qlpa_last_update_date        IN  jtf_date_table   := NULL,
   p_qlpa_last_updated_by         IN  jtf_number_table := NULL,
   p_qlpa_last_update_login       IN  jtf_number_table := NULL,
   p_qlpa_request_id              IN  jtf_number_table := NULL,
   p_qlpa_program_application_id  IN  jtf_number_table := NULL,
   p_qlpa_program_id              IN  jtf_number_table := NULL,
   p_qlpa_program_update_date     IN  jtf_date_table   := NULL,
   p_qlpa_quote_header_id         IN  jtf_number_table := NULL,
   p_qlpa_quote_line_id           IN  jtf_number_table := NULL,
   p_qlpa_flex_title              IN  jtf_varchar2_table_100 := NULL,
   p_qlpa_pricing_context         IN  jtf_varchar2_table_100 := NULL,
   p_qlpa_pricing_attribute1      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute2      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute3      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute4      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute5      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute6      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute7      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute8      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute9      IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute10     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute11     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute12     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute13     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute14     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute15     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute16     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute17     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute18     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute19     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute20     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute21     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute22     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute23     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute24     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute25     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute26     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute27     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute28     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute29     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute30     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute31     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute32     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute33     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute34     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute35     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute36     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute37     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute38     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute39     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute40     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute41     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute42     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute43     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute44     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute45     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute46     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute47     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute48     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute49     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute50     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute51     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute52     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute53     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute54     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute55     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute56     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute57     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute58     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute59     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute60     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute61     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute62     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute63     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute64     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute65     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute66     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute67     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute68     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute69     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute70     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute71     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute72     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute73     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute74     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute75     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute76     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute77     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute78     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute79     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute80     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute81     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute82     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute83     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute84     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute85     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute86     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute87     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute88     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute89     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute90     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute91     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute92     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute93     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute94     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute95     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute96     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute97     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute98     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute99     IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_pricing_attribute100    IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_context                 IN  jtf_varchar2_table_100 := NULL,
   p_qlpa_attribute1              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute2              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute3              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute4              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute5              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute6              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute7              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute8              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute9              IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute10             IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute11             IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute12             IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute13             IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute14             IN  jtf_varchar2_table_300 := NULL,
   p_qlpa_attribute15             IN  jtf_varchar2_table_300 := NULL,
   p_qlp_operation_code           IN  jtf_varchar2_table_100 := NULL,
   p_qlp_qte_line_index           IN  jtf_number_table := NULL,
   p_qlp_payment_id               IN  jtf_number_table := NULL,
   p_qlp_creation_date            IN  jtf_date_table   := NULL,
   p_qlp_created_by               IN  jtf_number_table := NULL,
   p_qlp_last_update_date         IN  jtf_date_table   := NULL,
   p_qlp_last_updated_by          IN  jtf_number_table := NULL,
   p_qlp_last_update_login        IN  jtf_number_table := NULL,
   p_qlp_request_id               IN  jtf_number_table := NULL,
   p_qlp_program_application_id   IN  jtf_number_table := NULL,
   p_qlp_program_id               IN  jtf_number_table := NULL,
   p_qlp_program_update_date      IN  jtf_date_table   := NULL,
   p_qlp_quote_header_id          IN  jtf_number_table := NULL,
   p_qlp_quote_line_id            IN  jtf_number_table := NULL,
   p_qlp_payment_type_code        IN  jtf_varchar2_table_100 := NULL,
   p_qlp_payment_ref_number       IN  jtf_varchar2_table_300 := NULL,
   p_qlp_payment_option           IN  jtf_varchar2_table_300 := NULL,
   p_qlp_payment_term_id          IN  jtf_number_table := NULL,
   p_qlp_credit_card_code         IN  jtf_varchar2_table_100 := NULL,
   p_qlp_credit_card_holder_name  IN  jtf_varchar2_table_100 := NULL,
   p_qlp_credit_card_exp_date     IN  jtf_date_table   := NULL,
   p_qlp_credit_card_aprv_code    IN  jtf_varchar2_table_100 := NULL,
   p_qlp_credit_card_aprv_date    IN  jtf_date_table   := NULL,
   p_qlp_payment_amount           IN  jtf_number_table := NULL,
   p_qlp_cust_po_number           IN  jtf_varchar2_table_100 := NULL,
   p_qlp_attribute_category       IN  jtf_varchar2_table_100 := NULL,
   p_qlp_attribute1               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute2               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute3               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute4               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute5               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute6               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute7               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute8               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute9               IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute10              IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute11              IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute12              IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute13              IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute14              IN  jtf_varchar2_table_200 := NULL,
   p_qlp_attribute15              IN  jtf_varchar2_table_200 := NULL,
   p_qls_operation_code           IN  jtf_varchar2_table_100 := NULL,
   p_qls_qte_line_index           IN  jtf_number_table := NULL,
   p_qls_shipment_id              IN  jtf_number_table := NULL,
   p_qls_creation_date            IN  jtf_date_table   := NULL,
   p_qls_created_by               IN  jtf_number_table := NULL,
   p_qls_last_update_date         IN  jtf_date_table   := NULL,
   p_qls_last_updated_by          IN  jtf_number_table := NULL,
   p_qls_last_update_login        IN  jtf_number_table := NULL,
   p_qls_request_id               IN  jtf_number_table := NULL,
   p_qls_program_application_id   IN  jtf_number_table := NULL,
   p_qls_program_id               IN  jtf_number_table := NULL,
   p_qls_program_update_date      IN  jtf_date_table   := NULL,
   p_qls_quote_header_id          IN  jtf_number_table := NULL,
   p_qls_quote_line_id            IN  jtf_number_table := NULL,
   p_qls_promise_date             IN  jtf_date_table   := NULL,
   p_qls_request_date             IN  jtf_date_table   := NULL,
   p_qls_schedule_ship_date       IN  jtf_date_table   := NULL,
   p_qls_ship_to_party_site_id    IN  jtf_number_table := NULL,
   p_qls_ship_to_party_id         IN  jtf_number_table := NULL,
   p_qls_ship_to_cust_acct_id     IN  jtf_number_table := NULL,
   p_qls_ship_partial_flag        IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_set_id              IN  jtf_number_table := NULL,
   p_qls_ship_method_code         IN  jtf_varchar2_table_100 := NULL,
   p_qls_freight_terms_code       IN  jtf_varchar2_table_100 := NULL,
   p_qls_freight_carrier_code     IN  jtf_varchar2_table_100 := NULL,
   p_qls_fob_code                 IN  jtf_varchar2_table_100 := NULL,
   p_qls_shipment_priority_code   IN jtf_varchar2_table_100  := NULL,
   p_qls_shipping_instructions    IN  jtf_varchar2_table_2000 := NULL,
   p_qls_packing_instructions     IN  jtf_varchar2_table_2000 := NULL,
   p_qls_quantity                 IN  jtf_number_table := NULL,
   p_qls_reserved_quantity        IN  jtf_number_table := NULL,
   p_qls_reservation_id           IN  jtf_number_table := NULL,
   p_qls_order_line_id            IN  jtf_number_table := NULL,
   p_qls_ship_to_party_name       IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_to_cont_fst_name    IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_cont_mid_name    IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_cont_lst_name    IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_address1         IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_to_address2         IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_to_address3         IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_to_address4         IN  jtf_varchar2_table_300 := NULL,
   p_qls_ship_to_country_code     IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_country          IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_city             IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_postal_code      IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_state            IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_province         IN  jtf_varchar2_table_100 := NULL,
   p_qls_ship_to_county           IN  jtf_varchar2_table_100 := NULL,
   p_qls_attribute_category       IN  jtf_varchar2_table_100 := NULL,
   p_qls_attribute1               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute2               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute3               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute4               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute5               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute6               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute7               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute8               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute9               IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute10              IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute11              IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute12              IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute13              IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute14              IN  jtf_varchar2_table_200 := NULL,
   p_qls_attribute15              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_operation_code           IN  jtf_varchar2_table_100 := NULL,
   p_qlt_qte_line_index           IN  jtf_number_table := NULL,
   p_qlt_shipment_index           IN  jtf_number_table := NULL,
   p_qlt_tax_detail_id            IN  jtf_number_table := NULL,
   p_qlt_quote_header_id          IN  jtf_number_table := NULL,
   p_qlt_quote_line_id            IN  jtf_number_table := NULL,
   p_qlt_quote_shipment_id        IN  jtf_number_table := NULL,
   p_qlt_creation_date            IN  jtf_date_table   := NULL,
   p_qlt_created_by               IN  jtf_number_table := NULL,
   p_qlt_last_update_date         IN  jtf_date_table   := NULL,
   p_qlt_last_updated_by          IN  jtf_number_table := NULL,
   p_qlt_last_update_login        IN  jtf_number_table := NULL,
   p_qlt_request_id               IN  jtf_number_table := NULL,
   p_qlt_program_application_id   IN  jtf_number_table := NULL,
   p_qlt_program_id               IN  jtf_number_table := NULL,
   p_qlt_program_update_date      IN  jtf_date_table   := NULL,
   p_qlt_orig_tax_code            IN  jtf_varchar2_table_300 := NULL,
   p_qlt_tax_code                 IN  jtf_varchar2_table_100 := NULL,
   p_qlt_tax_rate                 IN  jtf_number_table := NULL,
   p_qlt_tax_date                 IN  jtf_date_table   := NULL,
   p_qlt_tax_amount               IN  jtf_number_table := NULL,
   p_qlt_tax_exempt_flag          IN  jtf_varchar2_table_100 := NULL,
   p_qlt_tax_exempt_number        IN  jtf_varchar2_table_100 := NULL,
   p_qlt_tax_exempt_reason_code   IN  jtf_varchar2_table_100 := NULL,
   p_qlt_attribute_category       IN  jtf_varchar2_table_100 := NULL,
   p_qlt_attribute1               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute2               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute3               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute4               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute5               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute6               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute7               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute8               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute9               IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute10              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute11              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute12              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute13              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute14              IN  jtf_varchar2_table_200 := NULL,
   p_qlt_attribute15              IN  jtf_varchar2_table_200 := NULL,
   p_qlpaa_operation_code         IN jtf_varchar2_table_100 := NULL,
   p_qlpaa_qte_line_index         IN jtf_number_table       := NULL,
   p_qlpaa_price_adj_index        IN jtf_number_table       := NULL,
   p_qlpaa_price_adj_attrib_id    IN jtf_number_table       := NULL,
   p_qlpaa_creation_date          IN jtf_date_table         := NULL,
   p_qlpaa_created_by             IN jtf_number_table       := NULL,
   p_qlpaa_last_update_date       IN jtf_date_table         := NULL,
   p_qlpaa_last_updated_by        IN jtf_number_table       := NULL,
   p_qlpaa_last_update_login      IN jtf_number_table       := NULL,
   p_qlpaa_program_application_id IN jtf_number_table       := NULL,
   p_qlpaa_program_id             IN jtf_number_table       := NULL,
   p_qlpaa_program_update_date    IN jtf_date_table         := NULL,
   p_qlpaa_request_id             IN jtf_number_table       := NULL,
   p_qlpaa_price_adjustment_id    IN jtf_number_table       := NULL,
   p_qlpaa_pricing_context        IN jtf_varchar2_table_100 := NULL,
   p_qlpaa_pricing_attribute      IN jtf_varchar2_table_100 := NULL,
   p_qlpaa_prc_attr_value_from    IN jtf_varchar2_table_300 := NULL,
   p_qlpaa_pricing_attr_value_to  IN jtf_varchar2_table_300 := NULL,
   p_qlpaa_comparison_operator    IN jtf_varchar2_table_100 := NULL,
   p_qlpaa_flex_title             IN jtf_varchar2_table_100 := NULL,
   p_qlpaj_operation_code         IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_qte_line_index         IN  jtf_number_table := NULL,
   p_qlpaj_price_adjustment_id    IN  jtf_number_table := NULL,
   p_qlpaj_creation_date          IN  jtf_date_table   := NULL,
   p_qlpaj_created_by             IN  jtf_number_table := NULL,
   p_qlpaj_last_update_date       IN  jtf_date_table   := NULL,
   p_qlpaj_last_updated_by        IN  jtf_number_table := NULL,
   p_qlpaj_last_update_login      IN  jtf_number_table := NULL,
   p_qlpaj_program_application_id IN  jtf_number_table := NULL,
   p_qlpaj_program_id             IN  jtf_number_table := NULL,
   p_qlpaj_program_update_date    IN  jtf_date_table   := NULL,
   p_qlpaj_request_id             IN  jtf_number_table := NULL,
   p_qlpaj_quote_header_id        IN  jtf_number_table := NULL,
   p_qlpaj_quote_line_id          IN  jtf_number_table := NULL,
   p_qlpaj_modifier_header_id     IN  jtf_number_table := NULL,
   p_qlpaj_modifier_line_id       IN  jtf_number_table := NULL,
   p_qlpaj_mod_line_type_code     IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_mod_mech_type_code     IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_modified_from          IN  jtf_number_table := NULL,
   p_qlpaj_modified_to            IN  jtf_number_table := NULL,
   p_qlpaj_operand                IN  jtf_number_table := NULL,
   p_qlpaj_arithmetic_operator    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_automatic_flag         IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_update_allowable_flag  IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_updated_flag           IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_applied_flag           IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_on_invoice_flag        IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_pricing_phase_id       IN  jtf_number_table := NULL,
   p_qlpaj_attribute_category     IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_attribute1             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute2             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute3             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute4             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute5             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute6             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute7             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute8             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute9             IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute10            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute11            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute12            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute13            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute14            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_attribute15            IN  jtf_varchar2_table_200 := NULL,
   p_qlpaj_orig_sys_discount_ref  IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_change_sequence        IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_update_allowed         IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_change_reason_code     IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_change_reason_text     IN  jtf_varchar2_table_2000 := NULL,
   p_qlpaj_cost_id                IN  jtf_number_table := NULL,
   p_qlpaj_tax_code               IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_tax_exempt_flag        IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_tax_exempt_number      IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_tax_exempt_reason_code IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_parent_adjustment_id   IN  jtf_number_table := NULL,
   p_qlpaj_invoiced_flag          IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_estimated_flag         IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_inc_in_sales_perfce    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_split_action_code      IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_adjusted_amount        IN  jtf_number_table := NULL,
   p_qlpaj_charge_type_code       IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_charge_subtype_code    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_range_break_quantity   IN  jtf_number_table := NULL,
   p_qlpaj_accrual_conv_rate      IN  jtf_number_table := NULL,
   p_qlpaj_pricing_group_sequence IN  jtf_number_table := NULL,
   p_qlpaj_accrual_flag           IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_list_line_no           IN  jtf_varchar2_table_300 := NULL,
   p_qlpaj_source_system_code     IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_benefit_qty            IN  jtf_number_table := NULL,
   p_qlpaj_benefit_uom_code       IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_print_on_invoice_flag  IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_expiration_date        IN  jtf_date_table   := NULL,
   p_qlpaj_rebate_trans_type_code IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_rebate_trans_reference IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_rebate_pay_system_code IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_redeemed_date          IN  jtf_date_table   := NULL,
   p_qlpaj_redeemed_flag          IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_modifier_level_code    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_price_break_type_code  IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_substitution_attribute IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_proration_type_code    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_include_on_ret_flag    IN  jtf_varchar2_table_100 := NULL,
   p_qlpaj_credit_or_charge_flag  IN  jtf_varchar2_table_100 := NULL,
   p_qlpar_operation_code         IN jtf_varchar2_table_100 := NULL,
   p_qlpar_adj_relationship_id    IN jtf_number_table       := NULL,
   p_qlpar_creation_date          IN jtf_date_table         := NULL,
   p_qlpar_created_by             IN jtf_number_table       := NULL,
   p_qlpar_last_update_date       IN jtf_date_table         := NULL,
   p_qlpar_last_updated_by        IN jtf_number_table       := NULL,
   p_qlpar_last_update_login      IN jtf_number_table       := NULL,
   p_qlpar_request_id             IN jtf_number_table       := NULL,
   p_qlpar_program_application_id IN jtf_number_table       := NULL,
   p_qlpar_program_id             IN jtf_number_table       := NULL,
   p_qlpar_program_update_date    IN jtf_date_table         := NULL,
   p_qlpar_quote_line_id          IN jtf_number_table       := NULL,
   p_qlpar_qte_line_index         IN jtf_number_table       := NULL,
   p_qlpar_price_adjustment_id    IN jtf_number_table       := NULL,
   p_qlpar_price_adj_index        IN jtf_number_table       := NULL,
   p_qlpar_rltd_price_adj_id      IN jtf_number_table       := NULL,
   p_qlpar_rltd_price_adj_index   IN jtf_number_table       := NULL,
   p_qlae_qte_line_index         IN jtf_number_table        := NULL,
   p_qlae_shipment_index         IN jtf_number_table        := NULL,
   p_qlae_line_attribute_id      IN jtf_number_table        := NULL,
   p_qlae_creation_date          IN jtf_date_table          := NULL,
   p_qlae_created_by             IN jtf_number_table        := NULL,
   p_qlae_last_update_date       IN jtf_date_table          := NULL,
   p_qlae_last_updated_by        IN jtf_number_table        := NULL,
   p_qlae_last_update_login      IN jtf_number_table        := NULL,
   p_qlae_request_id             IN jtf_number_table        := NULL,
   p_qlae_program_application_id IN jtf_number_table        := NULL,
   p_qlae_program_id             IN jtf_number_table        := NULL,
   p_qlae_program_update_date    IN jtf_date_table          := NULL,
   p_qlae_quote_header_id        IN jtf_number_table        := NULL,
   p_qlae_quote_line_id          IN jtf_number_table        := NULL,
   p_qlae_quote_shipment_id      IN jtf_number_table        := NULL,
   p_qlae_attribute_type_code    IN jtf_varchar2_table_100  := NULL,
   p_qlae_name                   IN jtf_varchar2_table_100  := NULL,
   p_qlae_value                  IN jtf_varchar2_table_2000 := NULL,
   p_qlae_value_type             IN jtf_varchar2_table_300  := NULL,
   p_qlae_status                 IN jtf_varchar2_table_100  := NULL,
   p_qlae_application_id         IN jtf_number_table        := NULL,
   p_qlae_start_date_active      IN jtf_date_table          := NULL,
   p_qlae_end_date_active        IN jtf_date_table          := NULL,
   p_qlae_operation_code         IN jtf_varchar2_table_100  := NULL,
   p_qfc_operation_code         IN jtf_varchar2_table_100 := NULL,
   p_qfc_qte_line_index         IN jtf_number_table       := NULL,
   p_qfc_shipment_index         IN jtf_number_table       := NULL,
   p_qfc_freight_charge_id      IN jtf_number_table       := NULL,
   p_qfc_last_update_date       IN jtf_date_table         := NULL,
   p_qfc_last_updated_by        IN jtf_number_table       := NULL,
   p_qfc_creation_date          IN jtf_date_table         := NULL,
   p_qfc_created_by             IN jtf_number_table       := NULL,
   p_qfc_last_update_login      IN jtf_number_table       := NULL,
   p_qfc_program_application_id IN jtf_number_table       := NULL,
   p_qfc_program_id             IN jtf_number_table       := NULL,
   p_qfc_program_update_date    IN jtf_date_table         := NULL,
   p_qfc_request_id             IN jtf_number_table       := NULL,
   p_qfc_quote_shipment_id      IN jtf_number_table       := NULL,
   p_qfc_quote_line_id          IN jtf_number_table       := NULL,
   p_qfc_freight_charge_type_id IN jtf_number_table       := NULL,
   p_qfc_charge_amount          IN jtf_number_table       := NULL,
   p_qfc_attribute_category     IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute1             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute2             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute3             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute4             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute5             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute6             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute7             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute8             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute9             IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute10            IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute11            IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute12            IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute13            IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute14            IN jtf_varchar2_table_200 := NULL,
   p_qfc_attribute15            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_operation_code         IN jtf_varchar2_table_100 := NULL,
   p_qlfc_qte_line_index         IN jtf_number_table       := NULL,
   p_qlfc_shipment_index         IN jtf_number_table       := NULL,
   p_qlfc_freight_charge_id      IN jtf_number_table       := NULL,
   p_qlfc_last_update_date       IN jtf_date_table         := NULL,
   p_qlfc_last_updated_by        IN jtf_number_table       := NULL,
   p_qlfc_creation_date          IN jtf_date_table         := NULL,
   p_qlfc_created_by             IN jtf_number_table       := NULL,
   p_qlfc_last_update_login      IN jtf_number_table       := NULL,
   p_qlfc_program_application_id IN jtf_number_table       := NULL,
   p_qlfc_program_id             IN jtf_number_table       := NULL,
   p_qlfc_program_update_date    IN jtf_date_table         := NULL,
   p_qlfc_request_id             IN jtf_number_table       := NULL,
   p_qlfc_quote_shipment_id      IN jtf_number_table       := NULL,
   p_qlfc_quote_line_id          IN jtf_number_table       := NULL,
   p_qlfc_freight_charge_type_id IN jtf_number_table       := NULL,
   p_qlfc_charge_amount          IN jtf_number_table       := NULL,
   p_qlfc_attribute_category     IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute1             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute2             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute3             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute4             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute5             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute6             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute7             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute8             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute9             IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute10            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute11            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute12            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute13            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute14            IN jtf_varchar2_table_200 := NULL,
   p_qlfc_attribute15            IN jtf_varchar2_table_200 := NULL
)
IS
  l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

Line: 4628


    p_c_LAST_UPDATE_DATE                   =>  p_c_LAST_UPDATE_DATE
   ,p_c_auto_version_flag                  =>  p_c_auto_version_flag
   ,p_c_pricing_request_type               =>  p_c_pricing_request_type
   ,p_c_header_pricing_event               =>  p_c_header_pricing_event
   ,p_c_line_pricing_event                 =>  p_c_line_pricing_event
   ,p_c_CAL_TAX_FLAG                       =>  p_c_CAL_TAX_FLAG
   ,p_c_CAL_FREIGHT_CHARGE_FLAG            =>  p_c_CAL_FREIGHT_CHARGE_FLAG
   ,p_c_price_mode 			   =>  p_c_price_mode		-- change line logic pricing
   ,x_control_rec                          =>  l_control_rec
  );

Line: 4643


      p_last_updated_by            => p_q_last_updated_by           ,
      p_last_update_date           => p_q_last_update_date          ,
      p_last_update_login          => p_q_last_update_login         ,
      p_request_id                 => p_q_request_id                ,
      p_program_application_id     => p_q_program_application_id    ,
      p_program_id                 => p_q_program_id                ,
      p_program_update_date        => p_q_program_update_date       ,
      p_org_id                     => p_q_org_id                    ,
      p_quote_name                 => p_q_quote_name                ,
      p_quote_number               => p_q_quote_number              ,
      p_quote_version              => p_q_quote_version             ,
      p_quote_status_id            => p_q_quote_status_id           ,
      p_quote_source_code          => p_q_quote_source_code         ,
      p_quote_expiration_date      => p_q_quote_expiration_date     ,
      p_price_frozen_date          => p_q_price_frozen_date         ,
      p_quote_password             => p_q_quote_password            ,
      p_original_system_reference  => p_q_original_system_reference ,
      p_party_id                   => p_q_party_id                  ,
      p_cust_account_id            => p_q_cust_account_id           ,
      p_invoice_to_cust_account_id => p_q_invoice_to_cust_account_id,
      p_org_contact_id             => p_q_org_contact_id            ,
      p_party_name                 => p_q_party_name                ,
      p_party_type                 => p_q_party_type                ,
      p_person_first_name          => p_q_person_first_name         ,
      p_person_last_name           => p_q_person_last_name          ,
      p_person_middle_name         => p_q_person_middle_name        ,
      p_phone_id                   => p_q_phone_id                  ,
      p_price_list_id              => p_q_price_list_id             ,
      p_price_list_name            => p_q_price_list_name           ,
      p_currency_code              => p_q_currency_code             ,
      p_total_list_price           => p_q_total_list_price          ,
      p_total_adjusted_amount      => p_q_total_adjusted_amount     ,
      p_total_adjusted_percent     => p_q_total_adjusted_percent    ,
      p_total_tax                  => p_q_total_tax                 ,
      p_total_shipping_charge      => p_q_total_shipping_charge     ,
      p_surcharge                  => p_q_surcharge                 ,
      p_total_quote_price          => p_q_total_quote_price         ,
      p_payment_amount             => p_q_payment_amount            ,
      p_accounting_rule_id         => p_q_accounting_rule_id        ,
      p_exchange_rate              => p_q_exchange_rate             ,
      p_exchange_type_code         => p_q_exchange_type_code        ,
      p_exchange_rate_date         => p_q_exchange_rate_date        ,
      p_quote_category_code        => p_q_quote_category_code       ,
      p_quote_status_code          => p_q_quote_status_code         ,
      p_quote_status               => p_q_quote_status              ,
      p_employee_person_id         => p_q_employee_person_id        ,
      p_sales_channel_code         => p_q_sales_channel_code        ,
--      p_salesrep_full_name         => p_q_salesrep_full_name        ,
      p_attribute_category         => p_q_attribute_category        ,
-- added attribute 16-20 for bug 6873117 mgiridha
      p_attribute1                 => p_q_attribute1                ,
      p_attribute10                => p_q_attribute10               ,
      p_attribute11                => p_q_attribute11               ,
      p_attribute12                => p_q_attribute12               ,
      p_attribute13                => p_q_attribute13               ,
      p_attribute14                => p_q_attribute14               ,
      p_attribute15                => p_q_attribute15               ,
      p_attribute16                => p_q_attribute16               ,
      p_attribute17                => p_q_attribute17               ,
      p_attribute18                => p_q_attribute18               ,
      p_attribute19                => p_q_attribute19               ,
      p_attribute2                 => p_q_attribute2                ,
      p_attribute20                => p_q_attribute20               ,
      p_attribute3                 => p_q_attribute3                ,
      p_attribute4                 => p_q_attribute4                ,
      p_attribute5                 => p_q_attribute5                ,
      p_attribute6                 => p_q_attribute6                ,
      p_attribute7                 => p_q_attribute7                ,
      p_attribute8                 => p_q_attribute8                ,
      p_attribute9                 => p_q_attribute9                ,
      p_contract_id                => p_q_contract_id               ,
      p_qte_contract_id            => p_q_qte_contract_id           ,
      p_ffm_request_id             => p_q_ffm_request_id            ,
      p_invoice_to_address1        => p_q_invoice_to_address1       ,
      p_invoice_to_address2        => p_q_invoice_to_address2       ,
      p_invoice_to_address3        => p_q_invoice_to_address3       ,
      p_invoice_to_address4        => p_q_invoice_to_address4       ,
      p_invoice_to_city            => p_q_invoice_to_city           ,
      p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
      p_invoice_to_cont_last_name  => p_q_invoice_to_cont_last_name ,
      p_invoice_to_cont_mid_name   => p_q_invoice_to_cont_mid_name  ,
      p_invoice_to_country_code    => p_q_invoice_to_country_code   ,
      p_invoice_to_country         => p_q_invoice_to_country        ,
      p_invoice_to_county          => p_q_invoice_to_county         ,
      p_invoice_to_party_id        => p_q_invoice_to_party_id       ,
      p_invoice_to_party_name      => p_q_invoice_to_party_name     ,
      p_invoice_to_party_site_id   => p_q_invoice_to_party_site_id  ,
      p_invoice_to_postal_code     => p_q_invoice_to_postal_code    ,
      p_invoice_to_province        => p_q_invoice_to_province       ,
      p_invoice_to_state           => p_q_invoice_to_state          ,
      p_invoicing_rule_id          => p_q_invoicing_rule_id         ,
      p_marketing_source_code_id   => p_q_marketing_source_code_id  ,
      p_marketing_source_code      => p_q_marketing_source_code     ,
      p_marketing_source_name      => p_q_marketing_source_name     ,
      p_orig_mktg_source_code_id   => p_q_orig_mktg_source_code_id  ,
      p_order_type_id              => p_q_order_type_id             ,
      p_order_id                   => p_q_order_id                  ,
      p_order_number               => p_q_order_number              ,
      p_order_type_name            => p_q_order_type_name           ,
      p_ordered_date               => p_q_ordered_date              ,
      p_resource_id                => p_q_resource_id               ,
      p_end_customer_party_id        => p_q_end_cust_party_id         ,
      p_end_customer_cust_party_id   => p_q_end_cust_cust_party_id    ,
      p_end_customer_party_site_id   => p_q_end_cust_party_site_id    ,
      p_end_customer_cust_account_id => p_q_end_cust_cust_account_id,
      p_pricing_status_indicator 	 => p_q_pricing_status_indicator,
      p_tax_status_indicator 		 => p_q_tax_status_indicator);

Line: 4757


      p_last_updated_by          => p_ql_last_updated_by         ,
      p_last_update_date         => p_ql_last_update_date        ,
      p_last_update_login        => p_ql_last_update_login       ,
      p_request_id               => p_ql_request_id              ,
      p_program_application_id   => p_ql_program_application_id  ,
      p_program_id               => p_ql_program_id              ,
      p_program_update_date      => p_ql_program_update_date     ,
      p_quote_line_id            => p_ql_quote_line_id           ,
      p_quote_header_id          => p_ql_quote_header_id         ,
      p_org_id                   => p_ql_org_id                  ,
      p_line_number              => p_ql_line_number             ,
      p_line_category_code       => p_ql_line_category_code      ,
      p_item_type_code           => p_ql_item_type_code          ,
      p_inventory_item_id        => p_ql_inventory_item_id       ,
      p_organization_id          => p_ql_organization_id         ,
      p_quantity                 => p_ql_quantity                ,
      p_uom_code                 => p_ql_uom_code                ,
      p_start_date_active        => p_ql_start_date_active       ,
      p_end_date_active          => p_ql_end_date_active         ,
      p_order_line_type_id       => p_ql_order_line_type_id      ,
      p_price_list_id            => p_ql_price_list_id           ,
      p_price_list_line_id       => p_ql_price_list_line_id      ,
      p_currency_code            => p_ql_currency_code           ,
      p_line_list_price          => p_ql_line_list_price         ,
      p_line_adjusted_amount     => p_ql_line_adjusted_amount    ,
      p_line_adjusted_percent    => p_ql_line_adjusted_percent   ,
      p_line_quote_price         => p_ql_line_quote_price        ,
      p_related_item_id          => p_ql_related_item_id         ,
      p_item_relationship_type   => p_ql_item_relationship_type  ,
      p_split_shipment_flag      => p_ql_split_shipment_flag     ,
      p_backorder_flag           => p_ql_backorder_flag          ,
      p_selling_price_change     => p_ql_selling_price_change    ,
      p_recalculate_flag         => p_ql_recalculate_flag        ,
      p_attribute_category       => p_ql_attribute_category      ,
      p_attribute1               => p_ql_attribute1              ,
      p_attribute2               => p_ql_attribute2              ,
      p_attribute3               => p_ql_attribute3              ,
      p_attribute4               => p_ql_attribute4              ,
      p_attribute5               => p_ql_attribute5              ,
      p_attribute6               => p_ql_attribute6              ,
      p_attribute7               => p_ql_attribute7              ,
      p_attribute8               => p_ql_attribute8              ,
      p_attribute9               => p_ql_attribute9              ,
      p_attribute10              => p_ql_attribute10             ,
      p_attribute11              => p_ql_attribute11             ,
      p_attribute12              => p_ql_attribute12             ,
      p_attribute13              => p_ql_attribute13             ,
      p_attribute14              => p_ql_attribute14             ,
      p_attribute15              => p_ql_attribute15             ,
      p_accounting_rule_id       => p_ql_accounting_rule_id      ,
      p_ffm_content_name         => p_ql_ffm_content_name        ,
      p_ffm_content_type         => p_ql_ffm_content_type        ,
      p_ffm_document_type        => p_ql_ffm_document_type       ,
      p_ffm_media_id             => p_ql_ffm_media_id            ,
      p_ffm_media_type           => p_ql_ffm_media_type          ,
      p_ffm_user_note            => p_ql_ffm_user_note           ,
      p_invoice_to_party_id      => p_ql_invoice_to_party_id     ,
      p_invoice_to_party_site_id => p_ql_invoice_to_party_site_id,
      p_invoice_to_cust_acct_id  => p_ql_invoice_to_cust_acct_id ,
      p_invoicing_rule_id        => p_ql_invoicing_rule_id       ,
      p_marketing_source_code_id => p_ql_marketing_source_code_id,
      p_operation_code           => p_ql_operation_code          ,
      p_commitment_id            => p_ql_commitment_id           ,
      p_agreement_id             => p_ql_agreement_id            ,
      p_minisite_id              => p_ql_minisite_id             ,
      p_section_id               => p_ql_section_id              ,
      p_end_customer_party_id        => p_ql_end_cust_party_id       ,
      p_end_customer_cust_party_id   => p_ql_end_cust_cust_party_id  ,
      p_end_customer_party_site_id   => p_ql_end_cust_party_site_id  ,
      p_end_customer_cust_account_id => p_ql_end_cust_cust_account_id);

Line: 4836


      p_last_update_date         => p_qdl_last_update_date        ,
      p_last_updated_by          => p_qdl_last_updated_by         ,
      p_last_update_login        => p_qdl_last_update_login       ,
      p_request_id               => p_qdl_request_id              ,
      p_program_application_id   => p_qdl_program_application_id  ,
      p_program_id               => p_qdl_program_id              ,
      p_program_update_date      => p_qdl_program_update_date     ,
      p_quote_line_id            => p_qdl_quote_line_id           ,
      p_config_header_id         => p_qdl_config_header_id        ,
      p_config_revision_num      => p_qdl_config_revision_num     ,
      p_config_item_id           => p_qdl_config_item_id          ,
      p_complete_configuration   => p_qdl_complete_configuration  ,
      p_valid_configuration_flag => p_qdl_valid_configuration_flag,
      p_component_code           => p_qdl_component_code          ,
      p_service_coterminate_flag => p_qdl_service_coterminate_flag,
      p_service_duration         => p_qdl_service_duration        ,
      p_service_period           => p_qdl_service_period          ,
      p_service_unit_selling     => p_qdl_service_unit_selling    ,
      p_service_unit_list        => p_qdl_service_unit_list       ,
      p_service_number           => p_qdl_service_number          ,
      p_unit_percent_base_price  => p_qdl_unit_percent_base_price ,
      p_attribute_category       => p_qdl_attribute_category      ,
      p_attribute1               => p_qdl_attribute1              ,
      p_attribute2               => p_qdl_attribute2              ,
      p_attribute3               => p_qdl_attribute3              ,
      p_attribute4               => p_qdl_attribute4              ,
      p_attribute5               => p_qdl_attribute5              ,
      p_attribute6               => p_qdl_attribute6              ,
      p_attribute7               => p_qdl_attribute7              ,
      p_attribute8               => p_qdl_attribute8              ,
      p_attribute9               => p_qdl_attribute9              ,
      p_attribute10              => p_qdl_attribute10             ,
      p_attribute11              => p_qdl_attribute11             ,
      p_attribute12              => p_qdl_attribute12             ,
      p_attribute13              => p_qdl_attribute13             ,
      p_attribute14              => p_qdl_attribute14             ,
      p_attribute15              => p_qdl_attribute15             ,
      p_service_ref_type_code    => p_qdl_service_ref_type_code   ,
      p_service_ref_order_number => p_qdl_service_ref_order_number,
      p_service_ref_line_number  => p_qdl_service_ref_line_number ,
      p_service_ref_qte_line_ind => p_qdl_service_ref_qte_line_ind,
      p_service_ref_line_id      => p_qdl_service_ref_line_id     ,
      p_service_ref_system_id    => p_qdl_service_ref_system_id   ,
      p_service_ref_option_numb  => p_qdl_service_ref_option_numb ,
      p_service_ref_shipment     => p_qdl_service_ref_shipment    ,
      p_return_ref_type          => p_qdl_return_ref_type         ,
      p_return_ref_header_id     => p_qdl_return_ref_header_id    ,
      p_return_ref_line_id       => p_qdl_return_ref_line_id      ,
      p_return_attribute1        => p_qdl_return_attribute1       ,
      p_return_attribute2        => p_qdl_return_attribute2       ,
      p_return_attribute3        => p_qdl_return_attribute3       ,
      p_return_attribute4        => p_qdl_return_attribute4       ,
      p_return_attribute5        => p_qdl_return_attribute5       ,
      p_return_attribute6        => p_qdl_return_attribute6       ,
      p_return_attribute7        => p_qdl_return_attribute7       ,
      p_return_attribute8        => p_qdl_return_attribute8       ,
      p_return_attribute9        => p_qdl_return_attribute9       ,
      p_return_attribute10       => p_qdl_return_attribute10      ,
      p_return_attribute11       => p_qdl_return_attribute11      ,
      p_return_attribute12       => p_qdl_return_attribute12      ,
      p_return_attribute13       => p_qdl_return_attribute13      ,
      p_return_attribute14       => p_qdl_return_attribute14      ,
      p_return_attribute15       => p_qdl_return_attribute15      ,
      p_operation_code           => p_qdl_operation_code          ,
      p_qte_line_index           => p_qdl_qte_line_index          ,
      p_return_attr_category     => p_qdl_return_attr_category    ,
      p_return_reason_code       => p_qdl_return_reason_code);

Line: 4913


      p_last_updated_by        => p_qrl_last_updated_by       ,
      p_last_update_date       => p_qrl_last_update_date      ,
      p_last_update_login      => p_qrl_last_update_login     ,
      p_request_id             => p_qrl_request_id            ,
      p_program_application_id => p_qrl_program_application_id,
      p_program_id             => p_qrl_program_id            ,
      p_program_update_date    => p_qrl_program_update_date   ,
      p_quote_line_id          => p_qrl_quote_line_id         ,
      p_related_quote_line_id  => p_qrl_related_quote_line_id ,
      p_relationship_type_code => p_qrl_relationship_type_code,
      p_reciprocal_flag        => p_qrl_reciprocal_flag       ,
      p_qte_line_index         => p_qrl_qte_line_index        ,
      p_related_qte_line_index => p_qrl_related_qte_line_index,
      p_operation_code         => p_qrl_operation_code);

Line: 4939


      p_last_update_date          => p_qp_last_update_date         ,
      p_last_updated_by           => p_qp_last_updated_by          ,
      p_last_update_login         => p_qp_last_update_login        ,
      p_request_id                => p_qp_request_id               ,
      p_program_application_id    => p_qp_program_application_id   ,
      p_program_id                => p_qp_program_id               ,
      p_program_update_date       => p_qp_program_update_date      ,
      p_quote_header_id           => p_qp_quote_header_id          ,
      p_quote_line_id             => p_qp_quote_line_id            ,
      p_payment_type_code         => p_qp_payment_type_code        ,
      p_payment_ref_number        => p_qp_payment_ref_number       ,
      p_payment_option            => p_qp_payment_option           ,
      p_payment_term_id           => p_qp_payment_term_id          ,
      p_credit_card_code          => p_qp_credit_card_code         ,
      p_credit_card_holder_name   => p_qp_credit_card_holder_name  ,
      p_credit_card_exp_date      => p_qp_credit_card_exp_date     ,
      p_credit_card_approval_code => p_qp_credit_card_approval_code,
      p_credit_card_approval_date => p_qp_credit_card_approval_date,
      p_payment_amount            => p_qp_payment_amount           ,
      p_cust_po_number            => p_qp_cust_po_number           ,
      p_attribute_category        => p_qp_attribute_category       ,
      p_attribute1                => p_qp_attribute1               ,
      p_attribute2                => p_qp_attribute2               ,
      p_attribute3                => p_qp_attribute3               ,
      p_attribute4                => p_qp_attribute4               ,
      p_attribute5                => p_qp_attribute5               ,
      p_attribute6                => p_qp_attribute6               ,
      p_attribute7                => p_qp_attribute7               ,
      p_attribute8                => p_qp_attribute8               ,
      p_attribute9                => p_qp_attribute9               ,
      p_attribute10               => p_qp_attribute10              ,
      p_attribute11               => p_qp_attribute11              ,
      p_attribute12               => p_qp_attribute12              ,
      p_attribute13               => p_qp_attribute13              ,
      p_attribute14               => p_qp_attribute14              ,
      p_attribute15               => p_qp_attribute15              ,
      p_assignment_id             => p_qp_assignment_id            ,
      p_cvv2                      => p_qp_cvv2                     );

Line: 4989


      p_last_update_date          => p_qlp_last_update_date       ,
      p_last_updated_by           => p_qlp_last_updated_by        ,
      p_last_update_login         => p_qlp_last_update_login      ,
      p_request_id                => p_qlp_request_id             ,
      p_program_application_id    => p_qlp_program_application_id ,
      p_program_id                => p_qlp_program_id             ,
      p_program_update_date       => p_qlp_program_update_date    ,
      p_quote_header_id           => p_qlp_quote_header_id        ,
      p_quote_line_id             => p_qlp_quote_line_id          ,
      p_payment_type_code         => p_qlp_payment_type_code      ,
      p_payment_ref_number        => p_qlp_payment_ref_number     ,
      p_payment_option            => p_qlp_payment_option         ,
      p_payment_term_id           => p_qlp_payment_term_id        ,
      p_credit_card_code          => p_qlp_credit_card_code       ,
      p_credit_card_holder_name   => p_qlp_credit_card_holder_name,
      p_credit_card_exp_date      => p_qlp_credit_card_exp_date   ,
      p_credit_card_approval_code => p_qlp_credit_card_aprv_code  ,
      p_credit_card_approval_date => p_qlp_credit_card_aprv_date  ,
      p_payment_amount            => p_qlp_payment_amount         ,
      p_cust_po_number            => p_qlp_cust_po_number          ,
      p_attribute_category        => p_qlp_attribute_category     ,
      p_attribute1                => p_qlp_attribute1             ,
      p_attribute2                => p_qlp_attribute2             ,
      p_attribute3                => p_qlp_attribute3             ,
      p_attribute4                => p_qlp_attribute4             ,
      p_attribute5                => p_qlp_attribute5             ,
      p_attribute6                => p_qlp_attribute6             ,
      p_attribute7                => p_qlp_attribute7             ,
      p_attribute8                => p_qlp_attribute8             ,
      p_attribute9                => p_qlp_attribute9             ,
      p_attribute10               => p_qlp_attribute10            ,
      p_attribute11               => p_qlp_attribute11            ,
      p_attribute12               => p_qlp_attribute12            ,
      p_attribute13               => p_qlp_attribute13            ,
      p_attribute14               => p_qlp_attribute14            ,
      p_attribute15               => p_qlp_attribute15            ,
      p_assignment_id             => null                         ,
      p_cvv2                      => null);

Line: 5043


      p_last_update_date       => p_qt_last_update_date      ,
      p_last_updated_by        => p_qt_last_updated_by       ,
      p_last_update_login      => p_qt_last_update_login     ,
      p_request_id             => p_qt_request_id            ,
      p_program_application_id => p_qt_program_application_id,
      p_program_id             => p_qt_program_id            ,
      p_program_update_date    => p_qt_program_update_date   ,
      p_orig_tax_code          => p_qt_orig_tax_code         ,
      p_tax_code               => p_qt_tax_code              ,
      p_tax_rate               => p_qt_tax_rate              ,
      p_tax_date               => p_qt_tax_date              ,
      p_tax_amount             => p_qt_tax_amount            ,
      p_tax_exempt_flag        => p_qt_tax_exempt_flag       ,
      p_tax_exempt_number      => p_qt_tax_exempt_number     ,
      p_tax_exempt_reason_code => p_qt_tax_exempt_reason_code,
      p_attribute_category     => p_qt_attribute_category    ,
      p_attribute1             => p_qt_attribute1            ,
      p_attribute2             => p_qt_attribute2            ,
      p_attribute3             => p_qt_attribute3            ,
      p_attribute4             => p_qt_attribute4            ,
      p_attribute5             => p_qt_attribute5            ,
      p_attribute6             => p_qt_attribute6            ,
      p_attribute7             => p_qt_attribute7            ,
      p_attribute8             => p_qt_attribute8            ,
      p_attribute9             => p_qt_attribute9            ,
      p_attribute10            => p_qt_attribute10           ,
      p_attribute11            => p_qt_attribute11           ,
      p_attribute12            => p_qt_attribute12           ,
      p_attribute13            => p_qt_attribute13           ,
      p_attribute14            => p_qt_attribute14           ,
      p_attribute15            => p_qt_attribute15);

Line: 5090


      p_last_update_date       => p_qlt_last_update_date      ,
      p_last_updated_by        => p_qlt_last_updated_by       ,
      p_last_update_login      => p_qlt_last_update_login     ,
      p_request_id             => p_qlt_request_id            ,
      p_program_application_id => p_qlt_program_application_id,
      p_program_id             => p_qlt_program_id            ,
      p_program_update_date    => p_qlt_program_update_date   ,
      p_orig_tax_code          => p_qlt_orig_tax_code         ,
      p_tax_code               => p_qlt_tax_code              ,
      p_tax_rate               => p_qlt_tax_rate              ,
      p_tax_date               => p_qlt_tax_date              ,
      p_tax_amount             => p_qlt_tax_amount            ,
      p_tax_exempt_flag        => p_qlt_tax_exempt_flag       ,
      p_tax_exempt_number      => p_qlt_tax_exempt_number     ,
      p_tax_exempt_reason_code => p_qlt_tax_exempt_reason_code,
      p_attribute_category     => p_qlt_attribute_category    ,
      p_attribute1             => p_qlt_attribute1            ,
      p_attribute2             => p_qlt_attribute2            ,
      p_attribute3             => p_qlt_attribute3            ,
      p_attribute4             => p_qlt_attribute4            ,
      p_attribute5             => p_qlt_attribute5            ,
      p_attribute6             => p_qlt_attribute6            ,
      p_attribute7             => p_qlt_attribute7            ,
      p_attribute8             => p_qlt_attribute8            ,
      p_attribute9             => p_qlt_attribute9            ,
      p_attribute10            => p_qlt_attribute10           ,
      p_attribute11            => p_qlt_attribute11           ,
      p_attribute12            => p_qlt_attribute12           ,
      p_attribute13            => p_qlt_attribute13           ,
      p_attribute14            => p_qlt_attribute14           ,
      p_attribute15            => p_qlt_attribute15);

Line: 5133


      p_last_update_date       => p_qs_last_update_date      ,
      p_last_updated_by        => p_qs_last_updated_by       ,
      p_last_update_login      => p_qs_last_update_login     ,
      p_request_id             => p_qs_request_id            ,
      p_program_application_id => p_qs_program_application_id,
      p_program_id             => p_qs_program_id            ,
      p_program_update_date    => p_qs_program_update_date   ,
      p_quote_header_id        => p_qs_quote_header_id       ,
      p_quote_line_id          => p_qs_quote_line_id         ,
      p_promise_date           => p_qs_promise_date          ,
      p_request_date           => p_qs_request_date          ,
      p_schedule_ship_date     => p_qs_schedule_ship_date    ,
      p_ship_to_party_site_id  => p_qs_ship_to_party_site_id ,
      p_ship_to_party_id       => p_qs_ship_to_party_id      ,
      p_ship_to_cust_acct_id   => p_qs_ship_to_cust_acct_id  ,
      p_ship_partial_flag      => p_qs_ship_partial_flag     ,
      p_ship_set_id            => p_qs_ship_set_id           ,
      p_ship_method_code       => p_qs_ship_method_code      ,
      p_freight_terms_code     => p_qs_freight_terms_code    ,
      p_freight_carrier_code   => p_qs_freight_carrier_code  ,
      p_fob_code               => p_qs_fob_code              ,
      p_shipment_priority_code => p_qs_shipment_priority_code,
      p_shipping_instructions  => p_qs_shipping_instructions ,
      p_packing_instructions   => p_qs_packing_instructions  ,
      p_quantity               => p_qs_quantity              ,
      p_reserved_quantity      => p_qs_reserved_quantity     ,
      p_reservation_id         => p_qs_reservation_id        ,
      p_order_line_id          => p_qs_order_line_id         ,
      p_ship_to_party_name     => p_qs_ship_to_party_name    ,
      p_ship_to_cont_fst_name  => p_qs_ship_to_cont_fst_name ,
      p_ship_to_cont_mid_name  => p_qs_ship_to_cont_mid_name ,
      p_ship_to_cont_lst_name  => p_qs_ship_to_cont_lst_name ,
      p_ship_to_address1       => p_qs_ship_to_address1      ,
      p_ship_to_address2       => p_qs_ship_to_address2      ,
      p_ship_to_address3       => p_qs_ship_to_address3      ,
      p_ship_to_address4       => p_qs_ship_to_address4      ,
      p_ship_to_country_code   => p_qs_ship_to_country_code  ,
      p_ship_to_country        => p_qs_ship_to_country       ,
      p_ship_to_city           => p_qs_ship_to_city          ,
      p_ship_to_postal_code    => p_qs_ship_to_postal_code   ,
      p_ship_to_state          => p_qs_ship_to_state         ,
      p_ship_to_province       => p_qs_ship_to_province      ,
      p_ship_to_county         => p_qs_ship_to_county        ,
      p_attribute_category     => p_qs_attribute_category    ,
      p_attribute1             => p_qs_attribute1            ,
      p_attribute2             => p_qs_attribute2            ,
      p_attribute3             => p_qs_attribute3            ,
      p_attribute4             => p_qs_attribute4            ,
      p_attribute5             => p_qs_attribute5            ,
      p_attribute6             => p_qs_attribute6            ,
      p_attribute7             => p_qs_attribute7            ,
      p_attribute8             => p_qs_attribute8            ,
      p_attribute9             => p_qs_attribute9            ,
      p_attribute10            => p_qs_attribute10           ,
      p_attribute11            => p_qs_attribute11           ,
      p_attribute12            => p_qs_attribute12           ,
      p_attribute13            => p_qs_attribute13           ,
      p_attribute14            => p_qs_attribute14           ,
      p_attribute15            => p_qs_attribute15);

Line: 5204


      p_last_update_date       => p_qls_last_update_date      ,
      p_last_updated_by        => p_qls_last_updated_by       ,
      p_last_update_login      => p_qls_last_update_login     ,
      p_request_id             => p_qls_request_id            ,
      p_program_application_id => p_qls_program_application_id,
      p_program_id             => p_qls_program_id            ,
      p_program_update_date    => p_qls_program_update_date   ,
      p_quote_header_id        => p_qls_quote_header_id       ,
      p_quote_line_id          => p_qls_quote_line_id         ,
      p_promise_date           => p_qls_promise_date          ,
      p_request_date           => p_qls_request_date          ,
      p_schedule_ship_date     => p_qls_schedule_ship_date    ,
      p_ship_to_party_site_id  => p_qls_ship_to_party_site_id ,
      p_ship_to_party_id       => p_qls_ship_to_party_id      ,
      p_ship_to_cust_acct_id   => p_qls_ship_to_cust_acct_id  ,
      p_ship_partial_flag      => p_qls_ship_partial_flag     ,
      p_ship_set_id            => p_qls_ship_set_id           ,
      p_ship_method_code       => p_qls_ship_method_code      ,
      p_freight_terms_code     => p_qls_freight_terms_code    ,
      p_freight_carrier_code   => p_qls_freight_carrier_code  ,
      p_fob_code               => p_qls_fob_code              ,
      p_shipment_priority_code => p_qls_shipment_priority_code,
      p_shipping_instructions  => p_qls_shipping_instructions ,
      p_packing_instructions   => p_qls_packing_instructions  ,
      p_quantity               => p_qls_quantity              ,
      p_reserved_quantity      => p_qls_reserved_quantity     ,
      p_reservation_id         => p_qls_reservation_id        ,
      p_order_line_id          => p_qls_order_line_id         ,
      p_ship_to_party_name     => p_qls_ship_to_party_name    ,
      p_ship_to_cont_fst_name  => p_qls_ship_to_cont_fst_name ,
      p_ship_to_cont_mid_name  => p_qls_ship_to_cont_mid_name ,
      p_ship_to_cont_lst_name  => p_qls_ship_to_cont_lst_name ,
      p_ship_to_address1       => p_qls_ship_to_address1      ,
      p_ship_to_address2       => p_qls_ship_to_address2      ,
      p_ship_to_address3       => p_qls_ship_to_address3      ,
      p_ship_to_address4       => p_qls_ship_to_address4      ,
      p_ship_to_country_code   => p_qls_ship_to_country_code  ,
      p_ship_to_country        => p_qls_ship_to_country       ,
      p_ship_to_city           => p_qls_ship_to_city          ,
      p_ship_to_postal_code    => p_qls_ship_to_postal_code   ,
      p_ship_to_state          => p_qls_ship_to_state         ,
      p_ship_to_province       => p_qls_ship_to_province      ,
      p_ship_to_county         => p_qls_ship_to_county        ,
      p_attribute_category     => p_qls_attribute_category    ,
      p_attribute1             => p_qls_attribute1            ,
      p_attribute2             => p_qls_attribute2            ,
      p_attribute3             => p_qls_attribute3            ,
      p_attribute4             => p_qls_attribute4            ,
      p_attribute5             => p_qls_attribute5            ,
      p_attribute6             => p_qls_attribute6            ,
      p_attribute7             => p_qls_attribute7            ,
      p_attribute8             => p_qls_attribute8            ,
      p_attribute9             => p_qls_attribute9            ,
      p_attribute10            => p_qls_attribute10           ,
      p_attribute11            => p_qls_attribute11           ,
      p_attribute12            => p_qls_attribute12           ,
      p_attribute13            => p_qls_attribute13           ,
      p_attribute14            => p_qls_attribute14           ,
      p_attribute15            => p_qls_attribute15);

Line: 5275


      p_last_update_date       => p_qpa_last_update_date      ,
      p_last_updated_by        => p_qpa_last_updated_by       ,
      p_last_update_login      => p_qpa_last_update_login     ,
      p_request_id             => p_qpa_request_id            ,
      p_program_application_id => p_qpa_program_application_id,
      p_program_id             => p_qpa_program_id            ,
      p_program_update_date    => p_qpa_program_update_date   ,
      p_quote_header_id        => p_qpa_quote_header_id       ,
      p_quote_line_id          => p_qpa_quote_line_id         ,
      p_flex_title             => p_qpa_flex_title            ,
      p_pricing_context        => p_qpa_pricing_context       ,
      p_pricing_attribute1     => p_qpa_pricing_attribute1    ,
      p_pricing_attribute2     => p_qpa_pricing_attribute2    ,
      p_pricing_attribute3     => p_qpa_pricing_attribute3    ,
      p_pricing_attribute4     => p_qpa_pricing_attribute4    ,
      p_pricing_attribute5     => p_qpa_pricing_attribute5    ,
      p_pricing_attribute6     => p_qpa_pricing_attribute6    ,
      p_pricing_attribute7     => p_qpa_pricing_attribute7    ,
      p_pricing_attribute8     => p_qpa_pricing_attribute8    ,
      p_pricing_attribute9     => p_qpa_pricing_attribute9    ,
      p_pricing_attribute10    => p_qpa_pricing_attribute10   ,
      p_pricing_attribute11    => p_qpa_pricing_attribute11   ,
      p_pricing_attribute12    => p_qpa_pricing_attribute12   ,
      p_pricing_attribute13    => p_qpa_pricing_attribute13   ,
      p_pricing_attribute14    => p_qpa_pricing_attribute14   ,
      p_pricing_attribute15    => p_qpa_pricing_attribute15   ,
      p_pricing_attribute16    => p_qpa_pricing_attribute16   ,
      p_pricing_attribute17    => p_qpa_pricing_attribute17   ,
      p_pricing_attribute18    => p_qpa_pricing_attribute18   ,
      p_pricing_attribute19    => p_qpa_pricing_attribute19   ,
      p_pricing_attribute20    => p_qpa_pricing_attribute20   ,
      p_pricing_attribute21    => p_qpa_pricing_attribute21   ,
      p_pricing_attribute22    => p_qpa_pricing_attribute22   ,
      p_pricing_attribute23    => p_qpa_pricing_attribute23   ,
      p_pricing_attribute24    => p_qpa_pricing_attribute24   ,
      p_pricing_attribute25    => p_qpa_pricing_attribute25   ,
      p_pricing_attribute26    => p_qpa_pricing_attribute26   ,
      p_pricing_attribute27    => p_qpa_pricing_attribute27   ,
      p_pricing_attribute28    => p_qpa_pricing_attribute28   ,
      p_pricing_attribute29    => p_qpa_pricing_attribute29   ,
      p_pricing_attribute30    => p_qpa_pricing_attribute30   ,
      p_pricing_attribute31    => p_qpa_pricing_attribute31   ,
      p_pricing_attribute32    => p_qpa_pricing_attribute32   ,
      p_pricing_attribute33    => p_qpa_pricing_attribute33   ,
      p_pricing_attribute34    => p_qpa_pricing_attribute34   ,
      p_pricing_attribute35    => p_qpa_pricing_attribute35   ,
      p_pricing_attribute36    => p_qpa_pricing_attribute36   ,
      p_pricing_attribute37    => p_qpa_pricing_attribute37   ,
      p_pricing_attribute38    => p_qpa_pricing_attribute38   ,
      p_pricing_attribute39    => p_qpa_pricing_attribute39   ,
      p_pricing_attribute40    => p_qpa_pricing_attribute40   ,
      p_pricing_attribute41    => p_qpa_pricing_attribute41   ,
      p_pricing_attribute42    => p_qpa_pricing_attribute42   ,
      p_pricing_attribute43    => p_qpa_pricing_attribute43   ,
      p_pricing_attribute44    => p_qpa_pricing_attribute44   ,
      p_pricing_attribute45    => p_qpa_pricing_attribute45   ,
      p_pricing_attribute46    => p_qpa_pricing_attribute46   ,
      p_pricing_attribute47    => p_qpa_pricing_attribute47   ,
      p_pricing_attribute48    => p_qpa_pricing_attribute48   ,
      p_pricing_attribute49    => p_qpa_pricing_attribute49   ,
      p_pricing_attribute50    => p_qpa_pricing_attribute50   ,
      p_pricing_attribute51    => p_qpa_pricing_attribute51   ,
      p_pricing_attribute52    => p_qpa_pricing_attribute52   ,
      p_pricing_attribute53    => p_qpa_pricing_attribute53   ,
      p_pricing_attribute54    => p_qpa_pricing_attribute54   ,
      p_pricing_attribute55    => p_qpa_pricing_attribute55   ,
      p_pricing_attribute56    => p_qpa_pricing_attribute56   ,
      p_pricing_attribute57    => p_qpa_pricing_attribute57   ,
      p_pricing_attribute58    => p_qpa_pricing_attribute58   ,
      p_pricing_attribute59    => p_qpa_pricing_attribute59   ,
      p_pricing_attribute60    => p_qpa_pricing_attribute60   ,
      p_pricing_attribute61    => p_qpa_pricing_attribute61   ,
      p_pricing_attribute62    => p_qpa_pricing_attribute62   ,
      p_pricing_attribute63    => p_qpa_pricing_attribute63   ,
      p_pricing_attribute64    => p_qpa_pricing_attribute64   ,
      p_pricing_attribute65    => p_qpa_pricing_attribute65   ,
      p_pricing_attribute66    => p_qpa_pricing_attribute66   ,
      p_pricing_attribute67    => p_qpa_pricing_attribute67   ,
      p_pricing_attribute68    => p_qpa_pricing_attribute68   ,
      p_pricing_attribute69    => p_qpa_pricing_attribute69   ,
      p_pricing_attribute70    => p_qpa_pricing_attribute70   ,
      p_pricing_attribute71    => p_qpa_pricing_attribute71   ,
      p_pricing_attribute72    => p_qpa_pricing_attribute72   ,
      p_pricing_attribute73    => p_qpa_pricing_attribute73   ,
      p_pricing_attribute74    => p_qpa_pricing_attribute74   ,
      p_pricing_attribute75    => p_qpa_pricing_attribute75   ,
      p_pricing_attribute76    => p_qpa_pricing_attribute76   ,
      p_pricing_attribute77    => p_qpa_pricing_attribute77   ,
      p_pricing_attribute78    => p_qpa_pricing_attribute78   ,
      p_pricing_attribute79    => p_qpa_pricing_attribute79   ,
      p_pricing_attribute80    => p_qpa_pricing_attribute80   ,
      p_pricing_attribute81    => p_qpa_pricing_attribute81   ,
      p_pricing_attribute82    => p_qpa_pricing_attribute82   ,
      p_pricing_attribute83    => p_qpa_pricing_attribute83   ,
      p_pricing_attribute84    => p_qpa_pricing_attribute84   ,
      p_pricing_attribute85    => p_qpa_pricing_attribute85   ,
      p_pricing_attribute86    => p_qpa_pricing_attribute86   ,
      p_pricing_attribute87    => p_qpa_pricing_attribute87   ,
      p_pricing_attribute88    => p_qpa_pricing_attribute88   ,
      p_pricing_attribute89    => p_qpa_pricing_attribute89   ,
      p_pricing_attribute90    => p_qpa_pricing_attribute90   ,
      p_pricing_attribute91    => p_qpa_pricing_attribute91   ,
      p_pricing_attribute92    => p_qpa_pricing_attribute92   ,
      p_pricing_attribute93    => p_qpa_pricing_attribute93   ,
      p_pricing_attribute94    => p_qpa_pricing_attribute94   ,
      p_pricing_attribute95    => p_qpa_pricing_attribute95   ,
      p_pricing_attribute96    => p_qpa_pricing_attribute96   ,
      p_pricing_attribute97    => p_qpa_pricing_attribute97   ,
      p_pricing_attribute98    => p_qpa_pricing_attribute98   ,
      p_pricing_attribute99    => p_qpa_pricing_attribute99   ,
      p_pricing_attribute100   => p_qpa_pricing_attribute100  ,
      p_context                => p_qpa_context               ,
      p_attribute1             => p_qpa_attribute1            ,
      p_attribute2             => p_qpa_attribute2            ,
      p_attribute3             => p_qpa_attribute3            ,
      p_attribute4             => p_qpa_attribute4            ,
      p_attribute5             => p_qpa_attribute5            ,
      p_attribute6             => p_qpa_attribute6            ,
      p_attribute7             => p_qpa_attribute7            ,
      p_attribute8             => p_qpa_attribute8            ,
      p_attribute9             => p_qpa_attribute9            ,
      p_attribute10            => p_qpa_attribute10           ,
      p_attribute11            => p_qpa_attribute11           ,
      p_attribute12            => p_qpa_attribute12           ,
      p_attribute13            => p_qpa_attribute13           ,
      p_attribute14            => p_qpa_attribute14           ,
      p_attribute15            => p_qpa_attribute15);

Line: 5414


      p_last_update_date       => p_qlpa_last_update_date      ,
      p_last_updated_by        => p_qlpa_last_updated_by       ,
      p_last_update_login      => p_qlpa_last_update_login     ,
      p_request_id             => p_qlpa_request_id            ,
      p_program_application_id => p_qlpa_program_application_id,
      p_program_id             => p_qlpa_program_id            ,
      p_program_update_date    => p_qlpa_program_update_date   ,
      p_quote_header_id        => p_qlpa_quote_header_id       ,
      p_quote_line_id          => p_qlpa_quote_line_id         ,
      p_flex_title             => p_qlpa_flex_title            ,
      p_pricing_context        => p_qlpa_pricing_context       ,
      p_pricing_attribute1     => p_qlpa_pricing_attribute1    ,
      p_pricing_attribute2     => p_qlpa_pricing_attribute2    ,
      p_pricing_attribute3     => p_qlpa_pricing_attribute3    ,
      p_pricing_attribute4     => p_qlpa_pricing_attribute4    ,
      p_pricing_attribute5     => p_qlpa_pricing_attribute5    ,
      p_pricing_attribute6     => p_qlpa_pricing_attribute6    ,
      p_pricing_attribute7     => p_qlpa_pricing_attribute7    ,
      p_pricing_attribute8     => p_qlpa_pricing_attribute8    ,
      p_pricing_attribute9     => p_qlpa_pricing_attribute9    ,
      p_pricing_attribute10    => p_qlpa_pricing_attribute10   ,
      p_pricing_attribute11    => p_qlpa_pricing_attribute11   ,
      p_pricing_attribute12    => p_qlpa_pricing_attribute12   ,
      p_pricing_attribute13    => p_qlpa_pricing_attribute13   ,
      p_pricing_attribute14    => p_qlpa_pricing_attribute14   ,
      p_pricing_attribute15    => p_qlpa_pricing_attribute15   ,
      p_pricing_attribute16    => p_qlpa_pricing_attribute16   ,
      p_pricing_attribute17    => p_qlpa_pricing_attribute17   ,
      p_pricing_attribute18    => p_qlpa_pricing_attribute18   ,
      p_pricing_attribute19    => p_qlpa_pricing_attribute19   ,
      p_pricing_attribute20    => p_qlpa_pricing_attribute20   ,
      p_pricing_attribute21    => p_qlpa_pricing_attribute21   ,
      p_pricing_attribute22    => p_qlpa_pricing_attribute22   ,
      p_pricing_attribute23    => p_qlpa_pricing_attribute23   ,
      p_pricing_attribute24    => p_qlpa_pricing_attribute24   ,
      p_pricing_attribute25    => p_qlpa_pricing_attribute25   ,
      p_pricing_attribute26    => p_qlpa_pricing_attribute26   ,
      p_pricing_attribute27    => p_qlpa_pricing_attribute27   ,
      p_pricing_attribute28    => p_qlpa_pricing_attribute28   ,
      p_pricing_attribute29    => p_qlpa_pricing_attribute29   ,
      p_pricing_attribute30    => p_qlpa_pricing_attribute30   ,
      p_pricing_attribute31    => p_qlpa_pricing_attribute31   ,
      p_pricing_attribute32    => p_qlpa_pricing_attribute32   ,
      p_pricing_attribute33    => p_qlpa_pricing_attribute33   ,
      p_pricing_attribute34    => p_qlpa_pricing_attribute34   ,
      p_pricing_attribute35    => p_qlpa_pricing_attribute35   ,
      p_pricing_attribute36    => p_qlpa_pricing_attribute36   ,
      p_pricing_attribute37    => p_qlpa_pricing_attribute37   ,
      p_pricing_attribute38    => p_qlpa_pricing_attribute38   ,
      p_pricing_attribute39    => p_qlpa_pricing_attribute39   ,
      p_pricing_attribute40    => p_qlpa_pricing_attribute40   ,
      p_pricing_attribute41    => p_qlpa_pricing_attribute41   ,
      p_pricing_attribute42    => p_qlpa_pricing_attribute42   ,
      p_pricing_attribute43    => p_qlpa_pricing_attribute43   ,
      p_pricing_attribute44    => p_qlpa_pricing_attribute44   ,
      p_pricing_attribute45    => p_qlpa_pricing_attribute45   ,
      p_pricing_attribute46    => p_qlpa_pricing_attribute46   ,
      p_pricing_attribute47    => p_qlpa_pricing_attribute47   ,
      p_pricing_attribute48    => p_qlpa_pricing_attribute48   ,
      p_pricing_attribute49    => p_qlpa_pricing_attribute49   ,
      p_pricing_attribute50    => p_qlpa_pricing_attribute50   ,
      p_pricing_attribute51    => p_qlpa_pricing_attribute51   ,
      p_pricing_attribute52    => p_qlpa_pricing_attribute52   ,
      p_pricing_attribute53    => p_qlpa_pricing_attribute53   ,
      p_pricing_attribute54    => p_qlpa_pricing_attribute54   ,
      p_pricing_attribute55    => p_qlpa_pricing_attribute55   ,
      p_pricing_attribute56    => p_qlpa_pricing_attribute56   ,
      p_pricing_attribute57    => p_qlpa_pricing_attribute57   ,
      p_pricing_attribute58    => p_qlpa_pricing_attribute58   ,
      p_pricing_attribute59    => p_qlpa_pricing_attribute59   ,
      p_pricing_attribute60    => p_qlpa_pricing_attribute60   ,
      p_pricing_attribute61    => p_qlpa_pricing_attribute61   ,
      p_pricing_attribute62    => p_qlpa_pricing_attribute62   ,
      p_pricing_attribute63    => p_qlpa_pricing_attribute63   ,
      p_pricing_attribute64    => p_qlpa_pricing_attribute64   ,
      p_pricing_attribute65    => p_qlpa_pricing_attribute65   ,
      p_pricing_attribute66    => p_qlpa_pricing_attribute66   ,
      p_pricing_attribute67    => p_qlpa_pricing_attribute67   ,
      p_pricing_attribute68    => p_qlpa_pricing_attribute68   ,
      p_pricing_attribute69    => p_qlpa_pricing_attribute69   ,
      p_pricing_attribute70    => p_qlpa_pricing_attribute70   ,
      p_pricing_attribute71    => p_qlpa_pricing_attribute71   ,
      p_pricing_attribute72    => p_qlpa_pricing_attribute72   ,
      p_pricing_attribute73    => p_qlpa_pricing_attribute73   ,
      p_pricing_attribute74    => p_qlpa_pricing_attribute74   ,
      p_pricing_attribute75    => p_qlpa_pricing_attribute75   ,
      p_pricing_attribute76    => p_qlpa_pricing_attribute76   ,
      p_pricing_attribute77    => p_qlpa_pricing_attribute77   ,
      p_pricing_attribute78    => p_qlpa_pricing_attribute78   ,
      p_pricing_attribute79    => p_qlpa_pricing_attribute79   ,
      p_pricing_attribute80    => p_qlpa_pricing_attribute80   ,
      p_pricing_attribute81    => p_qlpa_pricing_attribute81   ,
      p_pricing_attribute82    => p_qlpa_pricing_attribute82   ,
      p_pricing_attribute83    => p_qlpa_pricing_attribute83   ,
      p_pricing_attribute84    => p_qlpa_pricing_attribute84   ,
      p_pricing_attribute85    => p_qlpa_pricing_attribute85   ,
      p_pricing_attribute86    => p_qlpa_pricing_attribute86   ,
      p_pricing_attribute87    => p_qlpa_pricing_attribute87   ,
      p_pricing_attribute88    => p_qlpa_pricing_attribute88   ,
      p_pricing_attribute89    => p_qlpa_pricing_attribute89   ,
      p_pricing_attribute90    => p_qlpa_pricing_attribute90   ,
      p_pricing_attribute91    => p_qlpa_pricing_attribute91   ,
      p_pricing_attribute92    => p_qlpa_pricing_attribute92   ,
      p_pricing_attribute93    => p_qlpa_pricing_attribute93   ,
      p_pricing_attribute94    => p_qlpa_pricing_attribute94   ,
      p_pricing_attribute95    => p_qlpa_pricing_attribute95   ,
      p_pricing_attribute96    => p_qlpa_pricing_attribute96   ,
      p_pricing_attribute97    => p_qlpa_pricing_attribute97   ,
      p_pricing_attribute98    => p_qlpa_pricing_attribute98   ,
      p_pricing_attribute99    => p_qlpa_pricing_attribute99   ,
      p_pricing_attribute100   => p_qlpa_pricing_attribute100  ,
      p_context                => p_qlpa_context               ,
      p_attribute1             => p_qlpa_attribute1            ,
      p_attribute2             => p_qlpa_attribute2            ,
      p_attribute3             => p_qlpa_attribute3            ,
      p_attribute4             => p_qlpa_attribute4            ,
      p_attribute5             => p_qlpa_attribute5            ,
      p_attribute6             => p_qlpa_attribute6            ,
      p_attribute7             => p_qlpa_attribute7            ,
      p_attribute8             => p_qlpa_attribute8            ,
      p_attribute9             => p_qlpa_attribute9            ,
      p_attribute10            => p_qlpa_attribute10           ,
      p_attribute11            => p_qlpa_attribute11           ,
      p_attribute12            => p_qlpa_attribute12           ,
      p_attribute13            => p_qlpa_attribute13           ,
      p_attribute14            => p_qlpa_attribute14           ,
      p_attribute15            => p_qlpa_attribute15);

Line: 5552


      p_last_update_date       => p_qfc_last_update_date      ,
      p_last_updated_by        => p_qfc_last_updated_by       ,
      p_creation_date          => p_qfc_creation_date         ,
      p_created_by             => p_qfc_created_by            ,
      p_last_update_login      => p_qfc_last_update_login     ,
      p_program_application_id => p_qfc_program_application_id,
      p_program_id             => p_qfc_program_id            ,
      p_program_update_date    => p_qfc_program_update_date   ,
      p_request_id             => p_qfc_request_id            ,
      p_quote_shipment_id      => p_qfc_quote_shipment_id     ,
      p_quote_line_id          => p_qfc_quote_line_id         ,
      p_freight_charge_type_id => p_qfc_freight_charge_type_id,
      p_charge_amount          => p_qfc_charge_amount         ,
      p_attribute_category     => p_qfc_attribute_category    ,
      p_attribute1             => p_qfc_attribute1            ,
      p_attribute2             => p_qfc_attribute2            ,
      p_attribute3             => p_qfc_attribute3            ,
      p_attribute4             => p_qfc_attribute4            ,
      p_attribute5             => p_qfc_attribute5            ,
      p_attribute6             => p_qfc_attribute6            ,
      p_attribute7             => p_qfc_attribute7            ,
      p_attribute8             => p_qfc_attribute8            ,
      p_attribute9             => p_qfc_attribute9            ,
      p_attribute10            => p_qfc_attribute10           ,
      p_attribute11            => p_qfc_attribute11           ,
      p_attribute12            => p_qfc_attribute12           ,
      p_attribute13            => p_qfc_attribute13           ,
      p_attribute14            => p_qfc_attribute14           ,
      p_attribute15            => p_qfc_attribute15);

Line: 5592


      p_last_update_date       => p_qlfc_last_update_date      ,
      p_last_updated_by        => p_qlfc_last_updated_by       ,
      p_creation_date          => p_qlfc_creation_date         ,
      p_created_by             => p_qlfc_created_by            ,
      p_last_update_login      => p_qlfc_last_update_login     ,
      p_program_application_id => p_qlfc_program_application_id,
      p_program_id             => p_qlfc_program_id            ,
      p_program_update_date    => p_qlfc_program_update_date   ,
      p_request_id             => p_qlfc_request_id            ,
      p_quote_shipment_id      => p_qlfc_quote_shipment_id     ,
      p_quote_line_id          => p_qlfc_quote_line_id         ,
      p_freight_charge_type_id => p_qlfc_freight_charge_type_id,
      p_charge_amount          => p_qlfc_charge_amount         ,
      p_attribute_category     => p_qlfc_attribute_category    ,
      p_attribute1             => p_qlfc_attribute1            ,
      p_attribute2             => p_qlfc_attribute2            ,
      p_attribute3             => p_qlfc_attribute3            ,
      p_attribute4             => p_qlfc_attribute4            ,
      p_attribute5             => p_qlfc_attribute5            ,
      p_attribute6             => p_qlfc_attribute6            ,
      p_attribute7             => p_qlfc_attribute7            ,
      p_attribute8             => p_qlfc_attribute8            ,
      p_attribute9             => p_qlfc_attribute9            ,
      p_attribute10            => p_qlfc_attribute10           ,
      p_attribute11            => p_qlfc_attribute11           ,
      p_attribute12            => p_qlfc_attribute12           ,
      p_attribute13            => p_qlfc_attribute13           ,
      p_attribute14            => p_qlfc_attribute14           ,
      p_attribute15            => p_qlfc_attribute15);

Line: 5634


      p_last_update_date       => p_qlae_last_update_date      ,
      p_last_updated_by        => p_qlae_last_updated_by       ,
      p_last_update_login      => p_qlae_last_update_login     ,
      p_request_id             => p_qlae_request_id            ,
      p_program_application_id => p_qlae_program_application_id,
      p_program_id             => p_qlae_program_id            ,
      p_program_update_date    => p_qlae_program_update_date   ,
      p_quote_header_id        => p_qlae_quote_header_id       ,
      p_quote_line_id          => p_qlae_quote_line_id         ,
      p_quote_shipment_id      => p_qlae_quote_shipment_id     ,
      p_attribute_type_code    => p_qlae_attribute_type_code   ,
      p_name                   => p_qlae_name                  ,
      p_value                  => p_qlae_value                 ,
      p_value_type             => p_qlae_value_type            ,
      p_status                 => p_qlae_status                ,
      p_application_id         => p_qlae_application_id        ,
      p_start_date_active      => p_qlae_start_date_active     ,
      p_end_date_active        => p_qlae_end_date_active       ,
      p_operation_code         => p_qlae_operation_code);

Line: 5666


      p_last_update_date       => p_qlpaa_last_update_date      ,
      p_last_updated_by        => p_qlpaa_last_updated_by       ,
      p_last_update_login      => p_qlpaa_last_update_login     ,
      p_program_application_id => p_qlpaa_program_application_id,
      p_program_id             => p_qlpaa_program_id            ,
      p_program_update_date    => p_qlpaa_program_update_date   ,
      p_request_id             => p_qlpaa_request_id            ,
      p_price_adjustment_id    => p_qlpaa_price_adjustment_id   ,
      p_pricing_context        => p_qlpaa_pricing_context       ,
      p_pricing_attribute      => p_qlpaa_pricing_attribute     ,
      p_prc_attr_value_from    => p_qlpaa_prc_attr_value_from   ,
      p_pricing_attr_value_to  => p_qlpaa_pricing_attr_value_to ,
      p_comparison_operator    => p_qlpaa_comparison_operator   ,
      p_flex_title             => p_qlpaa_flex_title);

Line: 5692


      p_last_update_date       => p_qlpaj_last_update_date      ,
      p_last_updated_by        => p_qlpaj_last_updated_by       ,
      p_last_update_login      => p_qlpaj_last_update_login     ,
      p_program_application_id => p_qlpaj_program_application_id,
      p_program_id             => p_qlpaj_program_id            ,
      p_program_update_date    => p_qlpaj_program_update_date   ,
      p_request_id             => p_qlpaj_request_id            ,
      p_quote_header_id        => p_qlpaj_quote_header_id       ,
      p_quote_line_id          => p_qlpaj_quote_line_id         ,
      p_modifier_header_id     => p_qlpaj_modifier_header_id    ,
      p_modifier_line_id       => p_qlpaj_modifier_line_id      ,
      p_mod_line_type_code     => p_qlpaj_mod_line_type_code    ,
      p_mod_mech_type_code     => p_qlpaj_mod_mech_type_code    ,
      p_modified_from          => p_qlpaj_modified_from         ,
      p_modified_to            => p_qlpaj_modified_to           ,
      p_operand                => p_qlpaj_operand               ,
      p_arithmetic_operator    => p_qlpaj_arithmetic_operator   ,
      p_automatic_flag         => p_qlpaj_automatic_flag        ,
      p_update_allowable_flag  => p_qlpaj_update_allowable_flag ,
      p_updated_flag           => p_qlpaj_updated_flag          ,
      p_applied_flag           => p_qlpaj_applied_flag          ,
      p_on_invoice_flag        => p_qlpaj_on_invoice_flag       ,
      p_pricing_phase_id       => p_qlpaj_pricing_phase_id      ,
      p_attribute_category     => p_qlpaj_attribute_category    ,
      p_attribute1             => p_qlpaj_attribute1            ,
      p_attribute2             => p_qlpaj_attribute2            ,
      p_attribute3             => p_qlpaj_attribute3            ,
      p_attribute4             => p_qlpaj_attribute4            ,
      p_attribute5             => p_qlpaj_attribute5            ,
      p_attribute6             => p_qlpaj_attribute6            ,
      p_attribute7             => p_qlpaj_attribute7            ,
      p_attribute8             => p_qlpaj_attribute8            ,
      p_attribute9             => p_qlpaj_attribute9            ,
      p_attribute10            => p_qlpaj_attribute10           ,
      p_attribute11            => p_qlpaj_attribute11           ,
      p_attribute12            => p_qlpaj_attribute12           ,
      p_attribute13            => p_qlpaj_attribute13           ,
      p_attribute14            => p_qlpaj_attribute14           ,
      p_attribute15            => p_qlpaj_attribute15           ,
      p_orig_sys_discount_ref  => p_qlpaj_orig_sys_discount_ref ,
      p_change_sequence        => p_qlpaj_change_sequence       ,
      p_update_allowed         => p_qlpaj_update_allowed        ,
      p_change_reason_code     => p_qlpaj_change_reason_code    ,
      p_change_reason_text     => p_qlpaj_change_reason_text    ,
      p_cost_id                => p_qlpaj_cost_id               ,
      p_tax_code               => p_qlpaj_tax_code              ,
      p_tax_exempt_flag        => p_qlpaj_tax_exempt_flag       ,
      p_tax_exempt_number      => p_qlpaj_tax_exempt_number     ,
      p_tax_exempt_reason_code => p_qlpaj_tax_exempt_reason_code,
      p_parent_adjustment_id   => p_qlpaj_parent_adjustment_id  ,
      p_invoiced_flag          => p_qlpaj_invoiced_flag         ,
      p_estimated_flag         => p_qlpaj_estimated_flag        ,
      p_inc_in_sales_perfce    => p_qlpaj_inc_in_sales_perfce   ,
      p_split_action_code      => p_qlpaj_split_action_code     ,
      p_adjusted_amount        => p_qlpaj_adjusted_amount       ,
      p_charge_type_code       => p_qlpaj_charge_type_code      ,
      p_charge_subtype_code    => p_qlpaj_charge_subtype_code   ,
      p_range_break_quantity   => p_qlpaj_range_break_quantity  ,
      p_accrual_conv_rate      => p_qlpaj_accrual_conv_rate     ,
      p_pricing_group_sequence => p_qlpaj_pricing_group_sequence,
      p_accrual_flag           => p_qlpaj_accrual_flag          ,
      p_list_line_no           => p_qlpaj_list_line_no          ,
      p_source_system_code     => p_qlpaj_source_system_code    ,
      p_benefit_qty            => p_qlpaj_benefit_qty           ,
      p_benefit_uom_code       => p_qlpaj_benefit_uom_code      ,
      p_print_on_invoice_flag  => p_qlpaj_print_on_invoice_flag ,
      p_expiration_date        => p_qlpaj_expiration_date       ,
      p_rebate_trans_type_code => p_qlpaj_rebate_trans_type_code,
      p_rebate_trans_reference => p_qlpaj_rebate_trans_reference,
      p_rebate_pay_system_code => p_qlpaj_rebate_pay_system_code,
      p_redeemed_date          => p_qlpaj_redeemed_date         ,
      p_redeemed_flag          => p_qlpaj_redeemed_flag         ,
      p_modifier_level_code    => p_qlpaj_modifier_level_code   ,
      p_price_break_type_code  => p_qlpaj_price_break_type_code ,
      p_substitution_attribute => p_qlpaj_substitution_attribute,
      p_proration_type_code    => p_qlpaj_proration_type_code   ,
      p_include_on_ret_flag    => p_qlpaj_include_on_ret_flag   ,
      p_credit_or_charge_flag  => p_qlpaj_credit_or_charge_flag);

Line: 5781


      p_last_update_date       => p_qlpar_last_update_date      ,
      p_last_updated_by        => p_qlpar_last_updated_by       ,
      p_last_update_login      => p_qlpar_last_update_login     ,
      p_request_id             => p_qlpar_request_id            ,
      p_program_application_id => p_qlpar_program_application_id,
      p_program_id             => p_qlpar_program_id            ,
      p_program_update_date    => p_qlpar_program_update_date   ,
      p_quote_line_id          => p_qlpar_quote_line_id         ,
      p_qte_line_index         => p_qlpar_qte_line_index        ,
      p_price_adjustment_id    => p_qlpar_price_adjustment_id   ,
      p_price_adj_index        => p_qlpar_price_adj_index       ,
      p_rltd_price_adj_id      => p_qlpar_rltd_price_adj_id     ,
      p_rltd_price_adj_index   => p_qlpar_rltd_price_adj_index);

Line: 5845


    ,x_last_update_date         => x_last_update_date
    ,x_return_status            => x_return_status
    ,x_msg_count                => x_msg_count
    ,x_msg_data                 => x_msg_data
   );

Line: 5857


    ,p_auto_update_active_quote => p_auto_update_active_quote
    ,p_combinesameitem          => p_combinesameitem
    ,p_sharee_number            => p_sharee_number
    ,p_sharee_party_id          => p_sharee_party_id
    ,p_sharee_cust_account_id   => p_sharee_cust_account_id
    ,p_minisite_id              => p_q_minisite_id
    ,p_control_rec              => l_control_rec
    ,p_qte_header_rec           => l_qte_header_rec
    ,p_hd_price_attributes_tbl  => l_hd_price_attributes_tbl
    ,p_hd_payment_tbl           => l_hd_payment_tbl
    ,p_hd_shipment_tbl          => l_hd_shipment_tbl
    ,p_hd_freight_charge_tbl    => l_hd_freight_charge_tbl
    ,p_hd_tax_detail_tbl        => l_hd_tax_detail_tbl
    ,p_qte_line_tbl             => l_qte_line_tbl
    ,p_qte_line_dtl_tbl         => l_qte_line_dtl_tbl
    ,p_line_attr_ext_tbl        => l_line_attr_ext_tbl
    ,p_line_rltship_tbl         => l_line_rltship_tbl
    ,p_price_adjustment_tbl     => l_price_adjustment_tbl
    ,p_price_adj_attr_tbl       => l_price_adj_attr_tbl
    ,p_price_adj_rltship_tbl    => l_price_adj_rltship_tbl
    ,p_ln_price_attributes_tbl  => l_ln_price_attributes_tbl
    ,p_ln_payment_tbl           => l_ln_payment_tbl
    ,p_ln_shipment_tbl          => l_ln_shipment_tbl
    ,p_ln_freight_charge_tbl    => l_ln_freight_charge_tbl
    ,p_ln_tax_detail_tbl        => l_ln_tax_detail_tbl
    ,p_save_type                => p_q_save_type
    ,x_quote_header_id          => x_quote_header_id
    ,x_last_update_date         => x_last_update_date
    ,x_return_status            => x_return_status
    ,x_msg_count                => x_msg_count
    ,x_msg_data                 => x_msg_data
   );

Line: 5902


   p_last_update_date          IN  VARCHAR2 := FND_API.G_MISS_DATE,
   p_mode                      IN  VARCHAR2 := 'MERGE'            ,
   p_combinesameitem           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_quote_source_code         IN  VARCHAR2 := 'IStore Account'   ,
   p_currency_code             IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_price_list_id             IN  NUMBER   := FND_API.G_MISS_NUM ,
   p_c_last_update_date        IN  DATE     := FND_API.G_MISS_DATE,
   p_c_auto_version_flag       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_pricing_request_type    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_header_pricing_event    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_line_pricing_event      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_tax_flag            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_freight_charge_flag IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   x_quote_header_id           OUT NOCOPY NUMBER                  ,
   x_last_update_date          OUT NOCOPY DATE                    ,
   x_retrieval_number          OUT NOCOPY NUMBER
   )

IS
   l_control_rec ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_Miss_Control_Rec;

Line: 5924


      p_c_last_update_date        => p_c_last_update_date       ,
      p_c_auto_version_flag       => p_c_auto_version_flag      ,
      p_c_pricing_request_type    => p_c_pricing_request_type   ,
      p_c_header_pricing_event    => p_c_header_pricing_event   ,
      p_c_line_pricing_event      => p_c_line_pricing_event     ,
      p_c_cal_tax_flag            => p_c_cal_tax_flag           ,
      p_c_cal_freight_charge_flag => p_c_cal_freight_charge_flag,
      x_control_rec               => l_control_rec);

Line: 5938


      p_last_update_date   => p_last_update_date  ,
      p_mode               => p_mode              ,
      p_combinesameitem    => p_combinesameitem   ,
      p_party_id           => p_party_id          ,
      p_cust_account_id    => p_cust_account_id   ,
      p_quote_source_code  => p_quote_source_code ,
      p_currency_code      => p_currency_code     ,
      p_price_list_id      => p_price_list_id     ,
      p_control_rec        => l_control_rec       ,
      x_quote_header_id    => x_quote_header_id   ,
      x_last_update_date   => x_last_update_date  ,
      x_return_status      => x_return_status     ,
      x_msg_count          => x_msg_count         ,
      x_msg_data           => x_msg_data          ,
      x_retrieval_number   => x_retrieval_number  );

Line: 5963


   p_last_update_date   IN  DATE     := FND_API.G_MISS_DATE,
   p_sharee_number      IN  NUMBER   := FND_API.G_MISS_NUM ,
   p_sharee_party_id    IN  NUMBER   := FND_API.G_MISS_NUM ,
   p_sharee_account_id  IN  NUMBER   := FND_API.G_MISS_NUM ,
   p_sc_book_flag       IN  VARCHAR2 := FND_API.G_FALSE    ,
   p_sc_reserve_flag    IN  VARCHAR2 := FND_API.G_FALSE    ,
   p_sc_calculate_price IN  VARCHAR2 := FND_API.G_FALSE    ,
   p_sc_server_id       IN  NUMBER   := -1                 ,
   p_sc_cc_by_fax       IN  VARCHAR2 := FND_API.G_FALSE    ,

   p_customer_comments  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_reason_code        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_salesrep_email_id  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_minisite_id        IN  NUMBER   := FND_API.G_MISS_NUM ,

   x_last_update_date   OUT NOCOPY DATE                    ,
   x_order_number       OUT NOCOPY NUMBER                  ,
   x_order_header_id    OUT NOCOPY NUMBER                  ,
   x_order_request_id   OUT NOCOPY NUMBER                  ,
   x_contract_id        OUT NOCOPY NUMBER                  ,
   x_status             OUT NOCOPY VARCHAR2                ,
   --Mannamra: Added for bug 4716044
   x_hold_flag          OUT NOCOPY VARCHAR2
)
IS
   lp_Submit_control_rec ASO_Quote_Pub.Submit_Control_Rec_Type := ASO_Quote_Pub.G_MISS_Submit_Control_Rec;

Line: 6004


      p_last_update_date       => p_last_update_date   ,
      p_sharee_party_id        => p_sharee_party_id    ,
      p_sharee_cust_account_id => p_sharee_account_id  ,
      p_sharee_number          => p_sharee_number      ,
      p_submit_control_rec     => lp_submit_control_rec,

      p_customer_comments      => p_customer_comments  ,
      p_reason_code            => p_reason_code        ,
      p_salesrep_email_id      => p_salesrep_email_id  ,
      p_minisite_id            => p_minisite_id        ,

      x_order_header_rec       => lx_order_header_rec  ,
      x_return_status          => x_return_status      ,
      x_msg_count              => x_msg_count          ,
      x_msg_data               => x_msg_data           ,
      x_hold_flag              => x_hold_flag          );

Line: 6041


   x_last_update_date             OUT NOCOPY DATE                          ,
   p_combinesameitem              IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_sharee_number                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_sharee_party_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_sharee_cust_account_id       IN  NUMBER   := FND_API.G_MISS_NUM,
   p_c_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_c_auto_version_flag          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_pricing_request_type       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_header_pricing_event       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_line_pricing_event         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_tax_flag               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_freight_charge_flag    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_price_mode		  IN  VARCHAR2 := 'ENTIRE_QUOTE'     ,  -- change line logic pricing
   p_q_quote_header_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_creation_date              IN  DATE     := FND_API.G_MISS_DATE,
   p_q_created_by                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_updated_by            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_q_last_update_login          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_request_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_application_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_update_date        IN  DATE     := FND_API.G_MISS_DATE,
   p_q_org_id                     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_version              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_status_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_source_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_expiration_date      IN  DATE     := FND_API.G_MISS_DATE,
   p_q_price_frozen_date          IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_password             IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_original_system_reference  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_cust_account_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_cust_account_id IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_org_contact_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_party_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_type                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_first_name          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_last_name           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_middle_name         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_phone_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_currency_code              IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_total_list_price           IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_amount      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_percent     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_tax                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_shipping_charge      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_surcharge                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_quote_price          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_payment_amount             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_accounting_rule_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_rate              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_type_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_exchange_rate_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_category_code        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_employee_person_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_sales_channel_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
--   p_q_salesrep_full_name         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute_category         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute1                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute10                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute11                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute12                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute13                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute14                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute15                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute16                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute17                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute18                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute19                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute2                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute20                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute3                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute4                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute5                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute6                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute7                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute8                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute9                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_contract_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_qte_contract_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_ffm_request_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_address1        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address2        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address3        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address4        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_city            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_first_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_last_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_mid_name   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country_code    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_county          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_id        IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_party_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_site_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_postal_code     IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_province        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_state           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoicing_rule_id          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_marketing_source_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_orig_mktg_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_ordered_date               IN  DATE     := FND_API.G_MISS_DATE,
   p_q_resource_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_save_type                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_minisite_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_pricing_status_indicator   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_tax_status_indicator   	  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_ql_creation_date            IN jtf_date_table         := NULL,
   p_ql_created_by               IN jtf_number_table       := NULL,
   p_ql_last_updated_by          IN jtf_number_table       := NULL,
   p_ql_last_update_date         IN jtf_date_table         := NULL,
   p_ql_last_update_login        IN jtf_number_table       := NULL,
   p_ql_request_id               IN jtf_number_table       := NULL,
   p_ql_program_application_id   IN jtf_number_table       := NULL,
   p_ql_program_id               IN jtf_number_table       := NULL,
   p_ql_program_update_date      IN jtf_date_table         := NULL,
   p_ql_quote_line_id            IN jtf_number_table       := NULL,
   p_ql_quote_header_id          IN jtf_number_table       := NULL,
   p_ql_org_id                   IN jtf_number_table       := NULL,
   p_ql_line_number              IN jtf_number_table       := NULL,
   p_ql_line_category_code       IN jtf_varchar2_table_100 := NULL,
   p_ql_item_type_code           IN jtf_varchar2_table_100 := NULL,
   p_ql_inventory_item_id        IN jtf_number_table       := NULL,
   p_ql_organization_id          IN jtf_number_table       := NULL,
   p_ql_quantity                 IN jtf_number_table       := NULL,
   p_ql_uom_code                 IN jtf_varchar2_table_100 := NULL,
   p_ql_start_date_active        IN jtf_date_table         := NULL,
   p_ql_end_date_active          IN jtf_date_table         := NULL,
   p_ql_order_line_type_id       IN jtf_number_table       := NULL,
   p_ql_price_list_id            IN jtf_number_table       := NULL,
   p_ql_price_list_line_id       IN jtf_number_table       := NULL,
   p_ql_currency_code            IN jtf_varchar2_table_100 := NULL,
   p_ql_line_list_price          IN jtf_number_table       := NULL,
   p_ql_line_adjusted_amount     IN jtf_number_table       := NULL,
   p_ql_line_adjusted_percent    IN jtf_number_table       := NULL,
   p_ql_line_quote_price         IN jtf_number_table       := NULL,
   p_ql_related_item_id          IN jtf_number_table       := NULL,
   p_ql_item_relationship_type   IN jtf_varchar2_table_100 := NULL,
   p_ql_split_shipment_flag      IN jtf_varchar2_table_100 := NULL,
   p_ql_backorder_flag           IN jtf_varchar2_table_100 := NULL,
   p_ql_selling_price_change     IN jtf_varchar2_table_100 := NULL,
   p_ql_recalculate_flag         IN jtf_varchar2_table_100 := NULL,
   p_ql_attribute_category       IN jtf_varchar2_table_100 := NULL,
   p_ql_attribute1               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute2               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute3               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute4               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute5               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute6               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute7               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute8               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute9               IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute10              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute11              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute12              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute13              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute14              IN jtf_varchar2_table_300 := NULL,
   p_ql_attribute15              IN jtf_varchar2_table_300 := NULL,
   p_ql_accounting_rule_id       IN jtf_number_table       := NULL,
   p_ql_ffm_content_name         IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_content_type         IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_document_type        IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_media_id             IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_media_type           IN jtf_varchar2_table_300 := NULL,
   p_ql_ffm_user_note            IN jtf_varchar2_table_300 := NULL,
   p_ql_invoice_to_party_id      IN jtf_number_table       := NULL,
   p_ql_invoice_to_party_site_id IN jtf_number_table       := NULL,
   p_ql_invoice_to_cust_acct_id  IN jtf_number_table       := NULL,
   p_ql_invoicing_rule_id        IN jtf_number_table       := NULL,
   p_ql_marketing_source_code_id IN jtf_number_table       := NULL,
   p_ql_operation_code           IN jtf_varchar2_table_100 := NULL,
   p_ql_commitment_id            IN jtf_number_table       := NULL,
   p_ql_agreement_id             IN jtf_number_table       := NULL,
   p_ql_minisite_id              IN jtf_number_table       := NULL,
   p_ql_section_id               IN jtf_number_table       := NULL,
   p_ql_line_codes               IN jtf_number_table       := NULL
)
IS
  l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

Line: 6240


    p_c_LAST_UPDATE_DATE                   =>  p_c_LAST_UPDATE_DATE
   ,p_c_auto_version_flag                  =>  p_c_auto_version_flag
   ,p_c_pricing_request_type               =>  p_c_pricing_request_type
   ,p_c_header_pricing_event               =>  p_c_header_pricing_event
   ,p_c_line_pricing_event                 =>  p_c_line_pricing_event
   ,p_c_CAL_TAX_FLAG                       =>  p_c_CAL_TAX_FLAG
   ,p_c_CAL_FREIGHT_CHARGE_FLAG            =>  p_c_CAL_FREIGHT_CHARGE_FLAG
   ,x_control_rec                          =>  l_control_rec
  );

Line: 6254


      p_last_updated_by            => p_q_last_updated_by           ,
      p_last_update_date           => p_q_last_update_date          ,
      p_last_update_login          => p_q_last_update_login         ,
      p_request_id                 => p_q_request_id                ,
      p_program_application_id     => p_q_program_application_id    ,
      p_program_id                 => p_q_program_id                ,
      p_program_update_date        => p_q_program_update_date       ,
      p_org_id                     => p_q_org_id                    ,
      p_quote_name                 => p_q_quote_name                ,
      p_quote_number               => p_q_quote_number              ,
      p_quote_version              => p_q_quote_version             ,
      p_quote_status_id            => p_q_quote_status_id           ,
      p_quote_source_code          => p_q_quote_source_code         ,
      p_quote_expiration_date      => p_q_quote_expiration_date     ,
      p_price_frozen_date          => p_q_price_frozen_date         ,
      p_quote_password             => p_q_quote_password            ,
      p_original_system_reference  => p_q_original_system_reference ,
      p_party_id                   => p_q_party_id                  ,
      p_cust_account_id            => p_q_cust_account_id           ,
      p_invoice_to_cust_account_id => p_q_invoice_to_cust_account_id,
      p_org_contact_id             => p_q_org_contact_id            ,
      p_party_name                 => p_q_party_name                ,
      p_party_type                 => p_q_party_type                ,
      p_person_first_name          => p_q_person_first_name         ,
      p_person_last_name           => p_q_person_last_name          ,
      p_person_middle_name         => p_q_person_middle_name        ,
      p_phone_id                   => p_q_phone_id                  ,
      p_price_list_id              => p_q_price_list_id             ,
      p_price_list_name            => p_q_price_list_name           ,
      p_currency_code              => p_q_currency_code             ,
      p_total_list_price           => p_q_total_list_price          ,
      p_total_adjusted_amount      => p_q_total_adjusted_amount     ,
      p_total_adjusted_percent     => p_q_total_adjusted_percent    ,
      p_total_tax                  => p_q_total_tax                 ,
      p_total_shipping_charge      => p_q_total_shipping_charge     ,
      p_surcharge                  => p_q_surcharge                 ,
      p_total_quote_price          => p_q_total_quote_price         ,
      p_payment_amount             => p_q_payment_amount            ,
      p_accounting_rule_id         => p_q_accounting_rule_id        ,
      p_exchange_rate              => p_q_exchange_rate             ,
      p_exchange_type_code         => p_q_exchange_type_code        ,
      p_exchange_rate_date         => p_q_exchange_rate_date        ,
      p_quote_category_code        => p_q_quote_category_code       ,
      p_quote_status_code          => p_q_quote_status_code         ,
      p_quote_status               => p_q_quote_status              ,
      p_employee_person_id         => p_q_employee_person_id        ,
      p_sales_channel_code         => p_q_sales_channel_code        ,
--      p_salesrep_full_name         => p_q_salesrep_full_name        ,
      p_attribute_category         => p_q_attribute_category        ,
-- added attribute 16-20 for bug 6873117 mgiridha
      p_attribute1                 => p_q_attribute1                ,
      p_attribute10                => p_q_attribute10               ,
      p_attribute11                => p_q_attribute11               ,
      p_attribute12                => p_q_attribute12               ,
      p_attribute13                => p_q_attribute13               ,
      p_attribute14                => p_q_attribute14               ,
      p_attribute15                => p_q_attribute15               ,
      p_attribute16                => p_q_attribute16               ,
      p_attribute17                => p_q_attribute17               ,
      p_attribute18                => p_q_attribute18               ,
      p_attribute19                => p_q_attribute19               ,
      p_attribute2                 => p_q_attribute2                ,
      p_attribute20                => p_q_attribute20               ,
      p_attribute3                 => p_q_attribute3                ,
      p_attribute4                 => p_q_attribute4                ,
      p_attribute5                 => p_q_attribute5                ,
      p_attribute6                 => p_q_attribute6                ,
      p_attribute7                 => p_q_attribute7                ,
      p_attribute8                 => p_q_attribute8                ,
      p_attribute9                 => p_q_attribute9                ,
      p_contract_id                => p_q_contract_id               ,
      p_qte_contract_id            => p_q_qte_contract_id           ,
      p_ffm_request_id             => p_q_ffm_request_id            ,
      p_invoice_to_address1        => p_q_invoice_to_address1       ,
      p_invoice_to_address2        => p_q_invoice_to_address2       ,
      p_invoice_to_address3        => p_q_invoice_to_address3       ,
      p_invoice_to_address4        => p_q_invoice_to_address4       ,
      p_invoice_to_city            => p_q_invoice_to_city           ,
      p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
      p_invoice_to_cont_last_name  => p_q_invoice_to_cont_last_name ,
      p_invoice_to_cont_mid_name   => p_q_invoice_to_cont_mid_name  ,
      p_invoice_to_country_code    => p_q_invoice_to_country_code   ,
      p_invoice_to_country         => p_q_invoice_to_country        ,
      p_invoice_to_county          => p_q_invoice_to_county         ,
      p_invoice_to_party_id        => p_q_invoice_to_party_id       ,
      p_invoice_to_party_name      => p_q_invoice_to_party_name     ,
      p_invoice_to_party_site_id   => p_q_invoice_to_party_site_id  ,
      p_invoice_to_postal_code     => p_q_invoice_to_postal_code    ,
      p_invoice_to_province        => p_q_invoice_to_province       ,
      p_invoice_to_state           => p_q_invoice_to_state          ,
      p_invoicing_rule_id          => p_q_invoicing_rule_id         ,
      p_marketing_source_code_id   => p_q_marketing_source_code_id  ,
      p_marketing_source_code      => p_q_marketing_source_code     ,
      p_marketing_source_name      => p_q_marketing_source_name     ,
      p_orig_mktg_source_code_id   => p_q_orig_mktg_source_code_id  ,
      p_order_type_id              => p_q_order_type_id             ,
      p_order_id                   => p_q_order_id                  ,
      p_order_number               => p_q_order_number              ,
      p_order_type_name            => p_q_order_type_name           ,
      p_ordered_date               => p_q_ordered_date              ,
      p_resource_id                => p_q_resource_id,
      p_end_customer_party_id        => FND_API.G_MISS_NUM,
      p_end_customer_cust_party_id   => FND_API.G_MISS_NUM,
      p_end_customer_party_site_id   => FND_API.G_MISS_NUM,
      p_end_customer_cust_account_id => FND_API.G_MISS_NUM,
      p_pricing_status_indicator 	 => p_q_pricing_status_indicator,
      p_tax_status_indicator		 => p_q_tax_status_indicator
      );

Line: 6366


      p_last_updated_by            => p_ql_last_updated_by         ,
      p_last_update_date           => p_ql_last_update_date        ,
      p_last_update_login          => p_ql_last_update_login       ,
      p_request_id                 => p_ql_request_id              ,
      p_program_application_id     => p_ql_program_application_id  ,
      p_program_id                 => p_ql_program_id              ,
      p_program_update_date        => p_ql_program_update_date     ,
      p_quote_line_id              => p_ql_quote_line_id           ,
      p_quote_header_id            => p_ql_quote_header_id         ,
      p_org_id                     => p_ql_org_id                  ,
      p_line_number                => p_ql_line_number             ,
      p_line_category_code         => p_ql_line_category_code      ,
      p_item_type_code             => p_ql_item_type_code          ,
      p_inventory_item_id          => p_ql_inventory_item_id       ,
      p_organization_id            => p_ql_organization_id         ,
      p_quantity                   => p_ql_quantity                ,
      p_uom_code                   => p_ql_uom_code                ,
      p_start_date_active          => p_ql_start_date_active       ,
      p_end_date_active            => p_ql_end_date_active         ,
      p_order_line_type_id         => p_ql_order_line_type_id      ,
      p_price_list_id              => p_ql_price_list_id           ,
      p_price_list_line_id         => p_ql_price_list_line_id      ,
      p_currency_code              => p_ql_currency_code           ,
      p_line_list_price            => p_ql_line_list_price         ,
      p_line_adjusted_amount       => p_ql_line_adjusted_amount    ,
      p_line_adjusted_percent      => p_ql_line_adjusted_percent   ,
      p_line_quote_price           => p_ql_line_quote_price        ,
      p_related_item_id            => p_ql_related_item_id         ,
      p_item_relationship_type     => p_ql_item_relationship_type  ,
      p_split_shipment_flag        => p_ql_split_shipment_flag     ,
      p_backorder_flag             => p_ql_backorder_flag          ,
      p_selling_price_change       => p_ql_selling_price_change    ,
      p_recalculate_flag           => p_ql_recalculate_flag        ,
      p_attribute_category         => p_ql_attribute_category      ,
      p_attribute1                 => p_ql_attribute1              ,
      p_attribute2                 => p_ql_attribute2              ,
      p_attribute3                 => p_ql_attribute3              ,
      p_attribute4                 => p_ql_attribute4              ,
      p_attribute5                 => p_ql_attribute5              ,
      p_attribute6                 => p_ql_attribute6              ,
      p_attribute7                 => p_ql_attribute7              ,
      p_attribute8                 => p_ql_attribute8              ,
      p_attribute9                 => p_ql_attribute9              ,
      p_attribute10                => p_ql_attribute10             ,
      p_attribute11                => p_ql_attribute11             ,
      p_attribute12                => p_ql_attribute12             ,
      p_attribute13                => p_ql_attribute13             ,
      p_attribute14                => p_ql_attribute14             ,
      p_attribute15                => p_ql_attribute15             ,
      p_accounting_rule_id         => p_ql_accounting_rule_id      ,
      p_ffm_content_name           => p_ql_ffm_content_name        ,
      p_ffm_content_type           => p_ql_ffm_content_type        ,
      p_ffm_document_type          => p_ql_ffm_document_type       ,
      p_ffm_media_id               => p_ql_ffm_media_id            ,
      p_ffm_media_type             => p_ql_ffm_media_type          ,
      p_ffm_user_note              => p_ql_ffm_user_note           ,
      p_invoice_to_party_id        => p_ql_invoice_to_party_id     ,
      p_invoice_to_party_site_id   => p_ql_invoice_to_party_site_id,
      p_invoice_to_cust_acct_id    => p_ql_invoice_to_cust_acct_id ,
      p_invoicing_rule_id          => p_ql_invoicing_rule_id       ,
      p_marketing_source_code_id   => p_ql_marketing_source_code_id,
      p_operation_code             => p_ql_operation_code          ,
      p_commitment_id              => p_ql_commitment_id           ,
      p_agreement_id               => p_ql_agreement_id            ,
      p_minisite_id                => p_ql_minisite_id             ,
      p_section_id                 => p_ql_section_id,
      p_end_customer_party_id      => null,
      p_end_customer_cust_party_id => null,
      p_end_customer_party_site_id => null,
      p_end_customer_cust_account_id => null
      );

Line: 6456


    ,x_last_update_date        => x_last_update_date
    ,x_return_status            => x_return_status
    ,x_msg_count                => x_msg_count
    ,x_msg_data                 => x_msg_data
   );

Line: 6481


   p_c_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_c_auto_version_flag          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_pricing_request_type       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_header_pricing_event       IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_line_pricing_event         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_tax_flag               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_cal_freight_charge_flag    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_c_price_mode		  IN  VARCHAR2 := 'ENTIRE_QUOTE'     , -- change line logic pricing
   p_q_quote_header_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_creation_date              IN  DATE     := FND_API.G_MISS_DATE,
   p_q_created_by                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_updated_by            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_last_update_date           IN  DATE     := FND_API.G_MISS_DATE,
   p_q_last_update_login          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_request_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_application_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_id                 IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_program_update_date        IN  DATE     := FND_API.G_MISS_DATE,
   p_q_org_id                     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_version              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_status_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_quote_source_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_expiration_date      IN  DATE     := FND_API.G_MISS_DATE,
   p_q_price_frozen_date          IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_password             IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_original_system_reference  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_cust_account_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_cust_account_id IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_org_contact_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_party_name                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_party_type                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_first_name          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_last_name           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_person_middle_name         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_phone_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_price_list_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_currency_code              IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_total_list_price           IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_amount      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_adjusted_percent     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_tax                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_shipping_charge      IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_surcharge                  IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_total_quote_price          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_payment_amount             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_accounting_rule_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_rate              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_exchange_type_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_exchange_rate_date         IN  DATE     := FND_API.G_MISS_DATE,
   p_q_quote_category_code        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status_code          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_quote_status               IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_employee_person_id         IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_sales_channel_code         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute_category         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute1                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute10                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute11                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute12                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute13                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute14                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute15                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute16                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute17                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute18                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute19                IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute2                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute20                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute3                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute4                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute5                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute6                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute7                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute8                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_attribute9                 IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_contract_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_qte_contract_id            IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_ffm_request_id             IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_address1        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address2        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address3        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_address4        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_city            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_first_name IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_last_name  IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_cont_mid_name   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country_code    IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_country         IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_county          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_id        IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_party_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_party_site_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_invoice_to_postal_code     IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_province        IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoice_to_state           IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_invoicing_rule_id          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_marketing_source_code      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_marketing_source_name      IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_orig_mktg_source_code_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_id              IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_id                   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_number               IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_order_type_name            IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_ordered_date               IN  DATE     := FND_API.G_MISS_DATE,
   p_q_resource_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_minisite_id                IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_party_id          IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_cust_party_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_party_site_id     IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_end_cust_cust_account_id   IN  NUMBER   := FND_API.G_MISS_NUM,
   p_q_pricing_status_indicator   IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_q_tax_status_indicator          IN  VARCHAR2 := FND_API.G_MISS_CHAR,
   p_instance_ids                 IN  jtf_number_table       := NULL,
   x_config_line                  OUT NOCOPY ConfigCurTyp,
   x_last_update_date             OUT NOCOPY DATE,
   x_return_status                OUT NOCOPY VARCHAR2,
   x_msg_count                    OUT NOCOPY NUMBER,
   x_msg_data                     OUT NOCOPY VARCHAR2
)
IS
  l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type := ASO_Quote_Pub.G_MISS_Qte_Header_Rec;

Line: 6612


    p_c_LAST_UPDATE_DATE                   =>  p_c_LAST_UPDATE_DATE
   ,p_c_auto_version_flag                  =>  p_c_auto_version_flag
   ,p_c_pricing_request_type               =>  p_c_pricing_request_type
   ,p_c_header_pricing_event               =>  p_c_header_pricing_event
   ,p_c_line_pricing_event                 =>  p_c_line_pricing_event
   ,p_c_CAL_TAX_FLAG                       =>  p_c_CAL_TAX_FLAG
   ,p_c_CAL_FREIGHT_CHARGE_FLAG            =>  p_c_CAL_FREIGHT_CHARGE_FLAG
   ,x_control_rec                          =>  l_control_rec
  );

Line: 6626


      p_last_updated_by            => p_q_last_updated_by           ,
      p_last_update_date           => p_q_last_update_date          ,
      p_last_update_login          => p_q_last_update_login         ,
      p_request_id                 => p_q_request_id                ,
      p_program_application_id     => p_q_program_application_id    ,
      p_program_id                 => p_q_program_id                ,
      p_program_update_date        => p_q_program_update_date       ,
      p_org_id                     => p_q_org_id                    ,
      p_quote_name                 => p_q_quote_name                ,
      p_quote_number               => p_q_quote_number              ,
      p_quote_version              => p_q_quote_version             ,
      p_quote_status_id            => p_q_quote_status_id           ,
      p_quote_source_code          => p_q_quote_source_code         ,
      p_quote_expiration_date      => p_q_quote_expiration_date     ,
      p_price_frozen_date          => p_q_price_frozen_date         ,
      p_quote_password             => p_q_quote_password            ,
      p_original_system_reference  => p_q_original_system_reference ,
      p_party_id                   => p_q_party_id                  ,
      p_cust_account_id            => p_q_cust_account_id           ,
      p_invoice_to_cust_account_id => p_q_invoice_to_cust_account_id,
      p_org_contact_id             => p_q_org_contact_id            ,
      p_party_name                 => p_q_party_name                ,
      p_party_type                 => p_q_party_type                ,
      p_person_first_name          => p_q_person_first_name         ,
      p_person_last_name           => p_q_person_last_name          ,
      p_person_middle_name         => p_q_person_middle_name        ,
      p_phone_id                   => p_q_phone_id                  ,
      p_price_list_id              => p_q_price_list_id             ,
      p_price_list_name            => p_q_price_list_name           ,
      p_currency_code              => p_q_currency_code             ,
      p_total_list_price           => p_q_total_list_price          ,
      p_total_adjusted_amount      => p_q_total_adjusted_amount     ,
      p_total_adjusted_percent     => p_q_total_adjusted_percent    ,
      p_total_tax                  => p_q_total_tax                 ,
      p_total_shipping_charge      => p_q_total_shipping_charge     ,
      p_surcharge                  => p_q_surcharge                 ,
      p_total_quote_price          => p_q_total_quote_price         ,
      p_payment_amount             => p_q_payment_amount            ,
      p_accounting_rule_id         => p_q_accounting_rule_id        ,
      p_exchange_rate              => p_q_exchange_rate             ,
      p_exchange_type_code         => p_q_exchange_type_code        ,
      p_exchange_rate_date         => p_q_exchange_rate_date        ,
      p_quote_category_code        => p_q_quote_category_code       ,
      p_quote_status_code          => p_q_quote_status_code         ,
      p_quote_status               => p_q_quote_status              ,
      p_employee_person_id         => p_q_employee_person_id        ,
      p_sales_channel_code         => p_q_sales_channel_code        ,
      p_attribute_category         => p_q_attribute_category        ,
-- added attribute 16-20 for bug 6873117 mgiridha
      p_attribute1                 => p_q_attribute1                ,
      p_attribute10                => p_q_attribute10               ,
      p_attribute11                => p_q_attribute11               ,
      p_attribute12                => p_q_attribute12               ,
      p_attribute13                => p_q_attribute13               ,
      p_attribute14                => p_q_attribute14               ,
      p_attribute15                => p_q_attribute15               ,
      p_attribute16                => p_q_attribute16               ,
      p_attribute17                => p_q_attribute17               ,
      p_attribute18                => p_q_attribute18               ,
      p_attribute19                => p_q_attribute19               ,
      p_attribute2                 => p_q_attribute2                ,
      p_attribute20                 => p_q_attribute20              ,
      p_attribute3                 => p_q_attribute3                ,
      p_attribute4                 => p_q_attribute4                ,
      p_attribute5                 => p_q_attribute5                ,
      p_attribute6                 => p_q_attribute6                ,
      p_attribute7                 => p_q_attribute7                ,
      p_attribute8                 => p_q_attribute8                ,
      p_attribute9                 => p_q_attribute9                ,
      p_contract_id                => p_q_contract_id               ,
      p_qte_contract_id            => p_q_qte_contract_id           ,
      p_ffm_request_id             => p_q_ffm_request_id            ,
      p_invoice_to_address1        => p_q_invoice_to_address1       ,
      p_invoice_to_address2        => p_q_invoice_to_address2       ,
      p_invoice_to_address3        => p_q_invoice_to_address3       ,
      p_invoice_to_address4        => p_q_invoice_to_address4       ,
      p_invoice_to_city            => p_q_invoice_to_city           ,
      p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
      p_invoice_to_cont_last_name  => p_q_invoice_to_cont_last_name ,
      p_invoice_to_cont_mid_name   => p_q_invoice_to_cont_mid_name  ,
      p_invoice_to_country_code    => p_q_invoice_to_country_code   ,
      p_invoice_to_country         => p_q_invoice_to_country        ,
      p_invoice_to_county          => p_q_invoice_to_county         ,
      p_invoice_to_party_id        => p_q_invoice_to_party_id       ,
      p_invoice_to_party_name      => p_q_invoice_to_party_name     ,
      p_invoice_to_party_site_id   => p_q_invoice_to_party_site_id  ,
      p_invoice_to_postal_code     => p_q_invoice_to_postal_code    ,
      p_invoice_to_province        => p_q_invoice_to_province       ,
      p_invoice_to_state           => p_q_invoice_to_state          ,
      p_invoicing_rule_id          => p_q_invoicing_rule_id         ,
      p_marketing_source_code_id   => p_q_marketing_source_code_id  ,
      p_marketing_source_code      => p_q_marketing_source_code     ,
      p_marketing_source_name      => p_q_marketing_source_name     ,
      p_orig_mktg_source_code_id   => p_q_orig_mktg_source_code_id  ,
      p_order_type_id              => p_q_order_type_id             ,
      p_order_id                   => p_q_order_id                  ,
      p_order_number               => p_q_order_number              ,
      p_order_type_name            => p_q_order_type_name           ,
      p_ordered_date               => p_q_ordered_date              ,
      p_resource_id                => p_q_resource_id,
      p_end_customer_party_id        => FND_API.G_MISS_NUM,
      p_end_customer_cust_party_id   => FND_API.G_MISS_NUM,
      p_end_customer_party_site_id   => FND_API.G_MISS_NUM,
      p_end_customer_cust_account_id => FND_API.G_MISS_NUM
      );

Line: 6741


	,x_last_update_date  => x_last_update_date
        ,x_return_status     => x_return_status
        ,x_msg_count         => x_msg_count
        ,x_msg_data          => x_msg_data
      );