DBA Data[Home] [Help]

APPS.OKE_VERSION_COMPARISON_PKG SQL Statements

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

Line: 58

     SELECT line_number
      FROM OKC_K_LINES_BH
      WHERE major_version = vVersion
      CONNECT BY PRIOR cle_id=id
      START WITH id= vk_line_id AND major_version = vVersion;
Line: 83

     SELECT line_number
      FROM OKC_K_LINES_B
      CONNECT BY PRIOR cle_id=id
      START WITH id= vk_line_id;
Line: 109

         SELECT MEANING
         FROM FND_LOOKUPS
         WHERE LOOKUP_TYPE ='OKC_SUBJECT'
         AND LOOKUP_CODE = p_sbt_code;
Line: 140

      SELECT Nvl(display_name,article_title) NAME ,ARTICLE_TYPE
         FROM OKC_ARTICLES_V
      WHERE article_id = p_id;
Line: 177

PROCEDURE insert_comp_result(vHeader_id IN NUMBER,vVersion1 IN NUMBER, vVersion2 IN NUMBER)
  IS
    CREATED_BY NUMBER;
Line: 181

    LAST_UPDATE_DATE DATE;
Line: 182

    LAST_UPDATE_BY NUMBER;
Line: 183

    LAST_UPDATE_LOGIN NUMBER;
Line: 187

    SELECT o.attribute_name
    FROM   oke_object_attributes_vl o
    WHERE  o.attribute_code = l_prompt
    AND    o.database_object_name=L_Attribute_Object_Name;
Line: 198

        LAST_UPDATE_DATE :=SYSDATE;
Line: 199

        LAST_UPDATE_BY :=FND_GLOBAL.USER_ID;
Line: 200

        LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 210

        INSERT INTO OKE_VERSION_COMPARE_RESULTS
        (k_header_id,
         version1,
	 version2,
         object_type,
         object_id,
	 object_name,
         sequence,
	 prompt,
	 v1data,
	 v2data,
	 current_flag,
	 creation_date,
	 created_by,
	 last_update_date,
         last_update_by,
	 last_update_login)
        VALUES
         (vHeader_id,
          vVersion1,
          vVersion2,
          l_object_type,
          null,
          l_object_name,
          l_no_sequence,
          L_PROMPT_MULTI,
          l_data1,
          l_data2,
          l_current_flag,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_BY,
          LAST_UPDATE_LOGIN);
Line: 253

  END insert_comp_result;
Line: 268

        SELECT MAX(MAJOR_VERSION)
        FROM OKE_K_HEADERS_H
        WHERE K_HEADER_ID=p_header_id;
Line: 273

        SELECT MAX(version1)
        FROM oke_version_compare_results
        WHERE k_header_id=p_header_id;
Line: 297

      DELETE FROM oke_version_compare_results;
Line: 398

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 425

          SELECT k_type,
                 buy_or_sell,
		 boa_number,
                 program_number,
                 product_line,
                 status,
                 project_name,
                 line_value_total,
                 undef_line_value_total,
                 k_value,
                 k_alias,
                 currency_code,
                 priority_rating,
                 major_version,
                 award_date,
                 start_date,
                 end_date,
                 prime_k_number,
                 prime_k_alias,
                 authoring_org,
                 --item_master_org,
                 owning_organization,
                 short_description,
                 description,
                 authorize_date,
                 date_issued,
                 date_received,
                 award_cancel_date,
                 date_negotiated,
                 date_approved,
                 sic_code,
                 date_sign_by_customer,
                 date_sign_by_contractor,
                 faa_approve_date,
                 customer_po_number,
                 no_competition_authorize,
                 export_flag,
                 classified_flag,
                 penalty_clause_flag,
                 reporting_flag,
                 sb_plan_req_flag,
                 sb_report_flag,
                 cqa_flag,
                 cfe_flag,
                 prop_delivery_location,
                 prop_due_date_time,
                 prop_expire_date,
                 copies_required,
                 --billing_methods,
                 --billing_methods_button,
                 country_of_origin_code,
                 vat_code,
                 cost_of_sale_rate,
                 nte_amount,
                 date_definitized,
                 tech_data_wh_rate,
                 financial_ctrl_verified_flag,
                 nte_warning_flag,
                 cas_flag,
                 dcaa_audit_req_flag,
                 interim_rpt_req_flag,
                 cost_of_money,
                 oh_rates_final_flag,
                 progress_payment_flag,
                 progress_payment_rate,
                 progress_payment_liq_rate,
                 alternate_liquidation_rate,
                 cost_share_flag,
                 definitized_flag,
                 bill_without_def_flag,
                 comments

                 INTO r_header_1
                 FROM OKE_K_HEADERS_SECURE_V
                 WHERE K_HEADER_ID=vHeader_id;
Line: 502

           SELECT k_type,
                 buy_or_sell,
                 boa_number,
                 program_number,
                 product_line,
                 status,
                 project_name,
                 line_value_total,
                 undef_line_value_total,
                 k_value,
                 k_alias,
                 currency_code,
                 priority_rating,
                 major_version,
                 award_date,
                 start_date,
                 end_date,
                 prime_k_number,
                 prime_k_alias,
                 authoring_org,
                 --item_master_org,
                 owning_organization,
                 short_description,
                 description,
                 authorize_date,
                 date_issued,
                 date_received,
                 award_cancel_date,
                 date_negotiated,
                 date_approved,
                 sic_code,
                 date_sign_by_customer,
                 date_sign_by_contractor,
                 faa_approve_date,
                 customer_po_number,
                 no_competition_authorize,
                 export_flag,
                 classified_flag,
                 penalty_clause_flag,
                 reporting_flag,
                 sb_plan_req_flag,
                 sb_report_flag,
                 cqa_flag,
                 cfe_flag,
                 prop_delivery_location,
                 prop_due_date_time,
                 prop_expire_date,
                 copies_required,
                 --billing_methods,
                 --billing_methods_button,
                 country_of_origin_code,
                 vat_code,
                 cost_of_sale_rate,
                 nte_amount,
                 date_definitized,
                 tech_data_wh_rate,
                 financial_ctrl_verified_flag,
                 nte_warning_flag,
                 cas_flag,
                 dcaa_audit_req_flag,
                 interim_rpt_req_flag,
                 cost_of_money,
                 oh_rates_final_flag,
                 progress_payment_flag,
                 progress_payment_rate,
                 progress_payment_liq_rate,
                 alternate_liquidation_rate,
                 cost_share_flag,
                 definitized_flag,
                 bill_without_def_flag,
                 comments

                 INTO r_header_1
                 FROM OKE_K_HEADERS_SECURE_HV
                 WHERE K_HEADER_ID=vHeader_id
                 AND MAJOR_VERSION=vVersion1;
Line: 581

        SELECT k_type,
                 buy_or_sell,
                 boa_number,
                 program_number,
                 product_line,
                 status,
                 project_name,
                 line_value_total,
                 undef_line_value_total,
                 k_value,
                 k_alias,
                 currency_code,
                 priority_rating,
                 major_version,
                 award_date,
                 start_date,
                 end_date,
                 prime_k_number,
                 prime_k_alias,
                 authoring_org,
    --           item_master_org,
                 owning_organization,
                 short_description,
                 description,
                 authorize_date,
                 date_issued,
                 date_received,
                 award_cancel_date,
                 date_negotiated,
                 date_approved,
                 sic_code,
                 date_sign_by_customer,
                 date_sign_by_contractor,
                 faa_approve_date,
                 customer_po_number,
                 no_competition_authorize,
                 export_flag,
                 classified_flag,
                 penalty_clause_flag,
                 reporting_flag,
                 sb_plan_req_flag,
                 sb_report_flag,
                 cqa_flag,
                 cfe_flag,
                 prop_delivery_location,
                 prop_due_date_time,
                 prop_expire_date,
                 copies_required,
                 --billing_methods,
                 --billing_methods_button,
                 country_of_origin_code,
                 vat_code,
                 cost_of_sale_rate,
                 nte_amount,
                 date_definitized,
                 tech_data_wh_rate,
                 financial_ctrl_verified_flag,
                 nte_warning_flag,
                 cas_flag,
                 dcaa_audit_req_flag,
                 interim_rpt_req_flag,
                 cost_of_money,
                 oh_rates_final_flag,
                 progress_payment_flag,
                 progress_payment_rate,
                 progress_payment_liq_rate,
                 alternate_liquidation_rate,
                 cost_share_flag,
                 definitized_flag,
                 bill_without_def_flag,
                 comments

              INTO r_header_2
              FROM OKE_K_HEADERS_SECURE_HV
              WHERE K_HEADER_ID=vHeader_id
              AND MAJOR_VERSION=vVersion2;
Line: 665

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 676

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 686

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 696

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 706

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 714

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 724

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 732

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 741

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 748

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 756

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 766

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 776

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 784

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 794

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 804

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 815

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 825

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 835

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 845

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 853

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 864

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 872

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 882

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 892

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 902

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 912

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 922

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 932

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 943

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 953

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 963

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 974

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 985

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 995

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1005

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1014

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1023

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1032

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1041

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1050

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1059

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1068

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1077

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1087

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1097

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1107

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1117

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1127

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1137

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1147

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1157

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1167

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1177

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1187

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1197

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1206

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1215

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1224

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1233

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1242

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1252

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1261

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1270

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1280

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1290

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1300

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1309

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1318

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1327

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1337

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1470

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND MAJOR_VERSION=vVersion1
         AND CLE_ID IS NULL
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID IS NULL
         AND MAJOR_VERSION=vVersion2)
         ORDER BY LINE_NUMBER;
Line: 1484

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_B a
         WHERE DNZ_CHR_ID=vHeader_id
         AND CLE_ID IS NULL
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID IS NULL
         AND MAJOR_VERSION=vVersion2)
         ORDER BY LINE_NUMBER;
Line: 1497

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND MAJOR_VERSION=vVersion2
         AND CLE_ID IS NULL
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID IS NULL
         AND MAJOR_VERSION=vVersion1)
         ORDER BY LINE_NUMBER;
Line: 1511

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND MAJOR_VERSION=vVersion2
         AND CLE_ID IS NULL
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_B b
         WHERE b.ID=a.ID
         AND CLE_ID IS NULL)
         ORDER BY LINE_NUMBER;
Line: 1524

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 1558

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1573

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1578

        SELECT a.ID K_LINE_ID
         FROM  OKC_K_LINES_BH A, OKC_K_LINES_BH B
         WHERE a.DNZ_CHR_ID=vHeader_id
           AND a.MAJOR_VERSION=vVersion1
           AND a.CLE_ID IS NULL
           AND a.ID = b.ID
           AND b.CLE_ID IS NULL
           AND b.MAJOR_VERSION=vVersion2
         ORDER BY a.LINE_NUMBER
      ;
Line: 1603

         insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1618

         insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 1623

         SELECT a.ID K_LINE_ID
          FROM  OKC_K_LINES_B A, OKC_K_LINES_BH B
          WHERE a.DNZ_CHR_ID=vHeader_id
            AND a.CLE_ID IS NULL
            AND a.ID = b.ID
            AND b.CLE_ID IS NULL
            AND MAJOR_VERSION=vVersion2
          ORDER BY a.LINE_NUMBER
       ;
Line: 1654

           SELECT
               major_version,
               line_number,
               status,
               line_style,
               project_number,
               task_number,
               start_date,
               end_date,
               delivery_date,
               proposal_due_date,
               item_number,
               --item_description,
               line_description,
               customer_item_number,
               nsn_number,
               nsp_flag,
               line_quantity,
               uom_code,
               unit_price,
               undef_unit_price,
               line_value,
               undef_line_value,
               line_value_total,
               undef_line_value_total,
               --line_value_copy,
               billable_flag,
               shippable_flag,
               subcontracted_flag,
               drop_shipped_flag,
               completed_flag,
               comments,
               target_date_definitize,
               discount_for_payment,
               cost_of_sale_rate,
               financial_ctrl_flag,
               definitized_flag,
               bill_undefinitized_flag,
               dcaa_audit_req_flag,
               cost_of_money,
               interim_rpt_req_flag,
               nte_warning_flag,
               c_ssr_flag,
               c_scs_flag,
               prepayment_amount,
               prepayment_percentage,
               progress_payment_flag,
               progress_payment_rate,
		progress_payment_liq_rate,
		line_liquidation_rate,
		boe_description,
		billing_method,
		total_estimated_cost,
		customer_percent_in_order,
		ceiling_cost,
		level_of_effort_hours,
		award_fee,
		base_fee,
		minimum_fee,
		maximum_fee,
		award_fee_pool_amount,
		fixed_fee,
		initial_fee,
		final_fee,
		fee_ajt_formula,
		target_cost,
		target_fee,
		target_price,
		ceiling_price,
		cost_overrun_share_ratio,
		cost_underrun_share_ratio,
		final_pft_ajt_formula,
		fixed_quantity,
		minimum_quantity,
		maximum_quantity,
		estimated_total_quantity,
		number_of_options,
		initial_price,
		revised_price,
		material_cost_index,
		labor_cost_index,
		date_of_price_redetermin,
		country_of_origin_code,
		export_flag,
		export_license_num,
		export_license_res,
		cop_required_flag,
		inspection_req_flag,
		subj_a133_flag,
		cfe_flag,
		customer_approval_req_flag,
		data_item_name,
		data_item_subtitle,
		cdrl_category,
		requiring_office,
		date_of_first_submission,
		frequency,
		copies_required

           INTO r_line_1
           FROM OKE_K_LINES_SECURE_V
           WHERE K_LINE_ID=c_top_node;
Line: 1776

           SELECT

		major_version,
		line_number,
		status,
		line_style,
		project_number,
		task_number,
		start_date,
		end_date,
		delivery_date,
		proposal_due_date,
		item_number,
		--item_description,
		line_description,
		customer_item_number,
		nsn_number,
		nsp_flag,
		line_quantity,
		uom_code,
		unit_price,
		undef_unit_price,
		line_value,
		undef_line_value,
		line_value_total,
		undef_line_value_total,
		--line_value_copy,
		billable_flag,
		shippable_flag,
		subcontracted_flag,
		drop_shipped_flag,
		completed_flag,
		comments,
		target_date_definitize,
		discount_for_payment,
		cost_of_sale_rate,
		financial_ctrl_flag,
		definitized_flag,
		bill_undefinitized_flag,
		dcaa_audit_req_flag,
		cost_of_money,
		interim_rpt_req_flag,
		nte_warning_flag,
		c_ssr_flag,
		c_scs_flag,
		prepayment_amount,
		prepayment_percentage,
		progress_payment_flag,
		progress_payment_rate,
		progress_payment_liq_rate,
		line_liquidation_rate,
		boe_description,
		billing_method,
		total_estimated_cost,
		customer_percent_in_order,
		ceiling_cost,
		level_of_effort_hours,
		award_fee,
		base_fee,
		minimum_fee,
		maximum_fee,
		award_fee_pool_amount,
		fixed_fee,
		initial_fee,
		final_fee,
		fee_ajt_formula,
		target_cost,
		target_fee,
		target_price,
		ceiling_price,
		cost_overrun_share_ratio,
		cost_underrun_share_ratio,
		final_pft_ajt_formula,
		fixed_quantity,
		minimum_quantity,
		maximum_quantity,
		estimated_total_quantity,
		number_of_options,
		initial_price,
		revised_price,
		material_cost_index,
		labor_cost_index,
		date_of_price_redetermin,
		country_of_origin_code,
		export_flag,
		export_license_num,
		export_license_res,
		cop_required_flag,
		inspection_req_flag,
		subj_a133_flag,
		cfe_flag,
		customer_approval_req_flag,
		data_item_name,
		data_item_subtitle,
		cdrl_category,
		requiring_office,
		date_of_first_submission,
		frequency,
		copies_required

        INTO r_line_1
        from oke_k_lineS_SECURE_hv
        where k_line_id=nCurrent_line_id
	and major_version=vVersion1;
Line: 1886

        SELECT

		major_version,
		line_number,
		status,
		line_style,
		project_number,
		task_number,
		start_date,
		end_date,
		delivery_date,
		proposal_due_date,
		item_number,
		--item_description,
		line_description,
		customer_item_number,
		nsn_number,
		nsp_flag,
		line_quantity,
		uom_code,
		unit_price,
		undef_unit_price,
		line_value,
		undef_line_value,
		line_value_total,
		undef_line_value_total,
		--line_value_copy,
		billable_flag,
		shippable_flag,
		subcontracted_flag,
		drop_shipped_flag,
		completed_flag,
		comments,
		target_date_definitize,
		discount_for_payment,
		cost_of_sale_rate,
		financial_ctrl_flag,
		definitized_flag,
		bill_undefinitized_flag,
		dcaa_audit_req_flag,
		cost_of_money,
		interim_rpt_req_flag,
		nte_warning_flag,
		c_ssr_flag,
		c_scs_flag,
		prepayment_amount,
		prepayment_percentage,
		progress_payment_flag,
		progress_payment_rate,
		progress_payment_liq_rate,
		line_liquidation_rate,
		boe_description,
		billing_method,
		total_estimated_cost,
		customer_percent_in_order,
		ceiling_cost,
		level_of_effort_hours,
		award_fee,
		base_fee,
		minimum_fee,
		maximum_fee,
		award_fee_pool_amount,
		fixed_fee,
		initial_fee,
		final_fee,
		fee_ajt_formula,
		target_cost,
		target_fee,
		target_price,
		ceiling_price,
		cost_overrun_share_ratio,
		cost_underrun_share_ratio,
		final_pft_ajt_formula,
		fixed_quantity,
		minimum_quantity,
		maximum_quantity,
		estimated_total_quantity,
		number_of_options,
		initial_price,
		revised_price,
		material_cost_index,
		labor_cost_index,
		date_of_price_redetermin,
		country_of_origin_code,
		export_flag,
		export_license_num,
		export_license_res,
		cop_required_flag,
		inspection_req_flag,
		subj_a133_flag,
		cfe_flag,
		customer_approval_req_flag,
		data_item_name,
		data_item_subtitle,
		cdrl_category,
		requiring_office,
		date_of_first_submission,
		frequency,
		copies_required

        INTO r_line_2
        FROM OKE_K_LINES_SECURE_HV
        WHERE K_LINE_ID=nCurrent_line_id
        AND MAJOR_VERSION= vVersion2;
Line: 1997

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2008

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2017

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2027

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2037

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2047

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2056

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2066

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2076

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2086

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2095

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2103

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2112

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2123

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2133

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2141

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2149

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2159

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2167

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2175

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2183

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2191

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2199

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2207

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2216

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2225

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2234

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2243

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2253

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2264

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2274

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2283

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2292

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2302

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2312

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2321

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2331

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2341

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2351

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2360

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2370

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2378

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2388

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2397

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2407

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2418

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2428

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2437

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2447

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2457

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2467

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2476

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2486

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2497

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2507

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2516

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2526

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2536

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2546

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2555

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2565

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2575

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2585

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2594

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2602

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2610

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2620

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2630

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2639

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2649

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2660

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2670

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2679

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2689

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2697

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2705

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2714

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2724

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2734

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2744

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2753

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2763

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2773

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2783

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2792

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2802

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2813

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2823

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2832

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2842

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2852

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2862

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2871

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2881

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2891

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 2901

           SELECT count(*)
           INTO nDeliverables
      	   from oke_k_deliverables_bh
     	   where k_header_id=vHeader_id
      	   and k_line_id=nCurrent_line_id
      	   and major_version=vVersion1;
Line: 2908

           SELECT count(*)
           INTO nSublines
           FROM okc_k_lines_bh
           WHERE CLE_ID=nCurrent_line_id
           AND MAJOR_VERSION= vVersion1;
Line: 2915

           SELECT count(*)
           INTO nDeliverables
      	   from oke_k_deliverables_b
     	   where k_header_id=vHeader_id
      	   and k_line_id=nCurrent_line_id;
Line: 2921

           SELECT  count(*)
           INTO nSublines
           FROM okc_k_lines_b
           WHERE CLE_ID=nCurrent_line_id;
Line: 3066

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion1
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion2)
         ORDER BY LINE_NUMBER;
Line: 3080

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_B a
         WHERE DNZ_CHR_ID=vHeader_id
         AND CLE_ID=vParentLineId
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion2)
         ORDER BY LINE_NUMBER;
Line: 3093

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion2
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_BH b
         WHERE b.ID=a.ID
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion1)
         ORDER BY LINE_NUMBER;
Line: 3107

         SELECT ID K_LINE_ID
         FROM OKC_K_LINES_BH a
         WHERE DNZ_CHR_ID=vHeader_id
         AND CLE_ID=vParentLineId
         AND MAJOR_VERSION=vVersion2
         AND NOT EXISTS
       ( SELECT 'x'
         FROM OKC_K_LINES_B b
         WHERE b.ID=a.ID
         AND CLE_ID=vParentLineId)
         ORDER BY LINE_NUMBER;
Line: 3120

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 3155

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3172

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3177

              SELECT a.ID K_LINE_ID
               FROM  OKC_K_LINES_BH A, OKC_K_LINES_BH B
               WHERE a.DNZ_CHR_ID=vHeader_id
                 AND a.MAJOR_VERSION=vVersion1
                 AND a.CLE_ID=vParentLineId
                 AND a.ID = b.ID
                 AND b.CLE_ID=vParentLineId
                 AND b.MAJOR_VERSION=vVersion2
               ORDER BY a.LINE_NUMBER
            ;
Line: 3202

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3218

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3223

               SELECT a.ID K_LINE_ID
                FROM  OKC_K_LINES_B A, OKC_K_LINES_BH B
                WHERE a.DNZ_CHR_ID=vHeader_id
                  AND a.CLE_ID=vParentLineId
                  AND a.ID = b.ID
                  AND b.CLE_ID=vParentLineId
                  AND MAJOR_VERSION=vVersion2
                ORDER BY a.LINE_NUMBER
             ;
Line: 3253

                 SELECT
			major_version,
			line_number,
			status,
			line_style,
			project_number,
			task_number,
			start_date,
			end_date,
			delivery_date,
			proposal_due_date,
			item_number,
			--item_description,
			line_description,
			customer_item_number,
			nsn_number,
			nsp_flag,
			line_quantity,
			uom_code,
			unit_price,
			undef_unit_price,
			line_value,
			undef_line_value,
			line_value_total,
			undef_line_value_total,
                        --line_value_copy,
			billable_flag,
			shippable_flag,
			subcontracted_flag,
			drop_shipped_flag,
			completed_flag,
			comments,
			target_date_definitize,
			discount_for_payment,
			cost_of_sale_rate,
			financial_ctrl_flag,
			definitized_flag,
			bill_undefinitized_flag,
			dcaa_audit_req_flag,
			cost_of_money,
			interim_rpt_req_flag,
			nte_warning_flag,
			c_ssr_flag,
			c_scs_flag,
			prepayment_amount,
			prepayment_percentage,
			progress_payment_flag,
			progress_payment_rate,
			progress_payment_liq_rate,
			line_liquidation_rate,
			boe_description,
			billing_method,
			total_estimated_cost,
			customer_percent_in_order,
			ceiling_cost,
			level_of_effort_hours,
			award_fee,
			base_fee,
			minimum_fee,
			maximum_fee,
			award_fee_pool_amount,
			fixed_fee,
			initial_fee,
			final_fee,
			fee_ajt_formula,
			target_cost,
			target_fee,
			target_price,
			ceiling_price,
			cost_overrun_share_ratio,
			cost_underrun_share_ratio,
			final_pft_ajt_formula,
			fixed_quantity,
			minimum_quantity,
			maximum_quantity,
			estimated_total_quantity,
			number_of_options,
			initial_price,
			revised_price,
			material_cost_index,
			labor_cost_index,
			date_of_price_redetermin,
			country_of_origin_code,
			export_flag,
			export_license_num,
			export_license_res,
			cop_required_flag,
			inspection_req_flag,
			subj_a133_flag,
			cfe_flag,
			customer_approval_req_flag,
			data_item_name,
			data_item_subtitle,
			cdrl_category,
			requiring_office,
			date_of_first_submission,
			frequency,
			copies_required


        INTO r_current_line_1
        FROM OKE_K_LINES_SECURE_HV
        WHERE K_LINE_ID=c_sub_node
        AND MAJOR_VERSION= vVersion1;
Line: 3367

	 	 SELECT
			major_version,
			line_number,
			status,
			line_style,
			project_number,
			task_number,
			start_date,
			end_date,
			delivery_date,
			proposal_due_date,
			item_number,
			--item_description,
			line_description,
			customer_item_number,
			nsn_number,
			nsp_flag,
			line_quantity,
			uom_code,
			unit_price,
			undef_unit_price,
			line_value,
			undef_line_value,
			line_value_total,
			undef_line_value_total,
			--line_value_copy,
			billable_flag,
			shippable_flag,
			subcontracted_flag,
			drop_shipped_flag,
			completed_flag,
			comments,
			target_date_definitize,
			discount_for_payment,
			cost_of_sale_rate,
			financial_ctrl_flag,
			definitized_flag,
			bill_undefinitized_flag,
			dcaa_audit_req_flag,
			cost_of_money,
			interim_rpt_req_flag,
			nte_warning_flag,
			c_ssr_flag,
			c_scs_flag,
			prepayment_amount,
			prepayment_percentage,
			progress_payment_flag,
			progress_payment_rate,
			progress_payment_liq_rate,
			line_liquidation_rate,
			boe_description,
			billing_method,
			total_estimated_cost,
			customer_percent_in_order,
			ceiling_cost,
			level_of_effort_hours,
			award_fee,
			base_fee,
			minimum_fee,
			maximum_fee,
			award_fee_pool_amount,
			fixed_fee,
			initial_fee,
			final_fee,
			fee_ajt_formula,
			target_cost,
			target_fee,
			target_price,
			ceiling_price,
			cost_overrun_share_ratio,
			cost_underrun_share_ratio,
			final_pft_ajt_formula,
			fixed_quantity,
			minimum_quantity,
			maximum_quantity,
			estimated_total_quantity,
			number_of_options,
			initial_price,
			revised_price,
			material_cost_index,
			labor_cost_index,
			date_of_price_redetermin,
			country_of_origin_code,
			export_flag,
			export_license_num,
			export_license_res,
			cop_required_flag,
			inspection_req_flag,
			subj_a133_flag,
			cfe_flag,
			customer_approval_req_flag,
			data_item_name,
			data_item_subtitle,
			cdrl_category,
			requiring_office,
			date_of_first_submission,
			frequency,
			copies_required


        INTO r_current_line_1
        FROM OKE_K_LINES_SECURE_V
        WHERE K_LINE_ID=c_sub_node;
Line: 3476

        SELECT
			major_version,
			line_number,
			status,
			line_style,
			project_number,
			task_number,
			start_date,
			end_date,
			delivery_date,
			proposal_due_date,
			item_number,
			--item_description,
			line_description,
			customer_item_number,
			nsn_number,
			nsp_flag,
			line_quantity,
			uom_code,
			unit_price,
			undef_unit_price,
			line_value,
			undef_line_value,
			line_value_total,
			undef_line_value_total,
			--line_value_copy,
			billable_flag,
			shippable_flag,
			subcontracted_flag,
			drop_shipped_flag,
			completed_flag,
			comments,
			target_date_definitize,
			discount_for_payment,
			cost_of_sale_rate,
			financial_ctrl_flag,
			definitized_flag,
			bill_undefinitized_flag,
			dcaa_audit_req_flag,
			cost_of_money,
			interim_rpt_req_flag,
			nte_warning_flag,
			c_ssr_flag,
			c_scs_flag,
			prepayment_amount,
			prepayment_percentage,
			progress_payment_flag,
			progress_payment_rate,
			progress_payment_liq_rate,
			line_liquidation_rate,
			boe_description,
			billing_method,
			total_estimated_cost,
			customer_percent_in_order,
			ceiling_cost,
			level_of_effort_hours,
			award_fee,
			base_fee,
			minimum_fee,
			maximum_fee,
			award_fee_pool_amount,
			fixed_fee,
			initial_fee,
			final_fee,
			fee_ajt_formula,
			target_cost,
			target_fee,
			target_price,
			ceiling_price,
			cost_overrun_share_ratio,
			cost_underrun_share_ratio,
			final_pft_ajt_formula,
			fixed_quantity,
			minimum_quantity,
			maximum_quantity,
			estimated_total_quantity,
			number_of_options,
			initial_price,
			revised_price,
			material_cost_index,
			labor_cost_index,
			date_of_price_redetermin,
			country_of_origin_code,
			export_flag,
			export_license_num,
			export_license_res,
			cop_required_flag,
			inspection_req_flag,
			subj_a133_flag,
			cfe_flag,
			customer_approval_req_flag,
			data_item_name,
			data_item_subtitle,
			cdrl_category,
			requiring_office,
			date_of_first_submission,
			frequency,
			copies_required

        INTO r_current_line_2
        FROM OKE_K_LINES_SECURE_HV
        WHERE K_LINE_ID=c_sub_node
        AND MAJOR_VERSION= vVersion2;
Line: 3587

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3596

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3606

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3616

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3626

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3635

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3645

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3655

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3665

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3674

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3682

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3692

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3703

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3713

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3721

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3731

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3741

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3749

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3757

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3765

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3773

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3781

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3790

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3799

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3808

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3817

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3826

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3836

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3847

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3856

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3865

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3874

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3884

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3894

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3903

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3913

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3923

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3933

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3942

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3952

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3960

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3970

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3979

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 3989

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4000

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4010

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4019

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4029

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4040

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4050

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4059

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4069

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4080

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4090

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4099

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4109

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4119

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4129

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4138

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4148

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4158

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4168

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4177

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4185

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4193

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4203

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4213

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4222

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4232

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4243

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4253

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4262

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4272

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4280

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4288

          insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4297

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4307

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4317

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4327

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4336

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4346

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4356

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4366

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4376

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4385

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4396

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4406

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4415

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4425

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4435

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4445

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4454

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4464

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4474

        insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 4484

           SELECT count(*)
           INTO nDeliverables
      	   from oke_k_deliverables_bh
     	   where k_header_id=vHeader_id
      	   and k_line_id=nCurrent_line_id
           AND MAJOR_VERSION=vVersion1;
Line: 4491

          SELECT count(*)
          INTO l_numOfSublines
          FROM OKC_K_LINES_BH
          WHERE DNZ_CHR_ID=vHeader_id
          AND CLE_ID=nCurrent_line_id
          AND MAJOR_VERSION=vVersion1;
Line: 4499

           SELECT count(*)
           INTO nDeliverables
      	   from oke_k_deliverables_b
     	   where k_header_id=vHeader_id
      	   and k_line_id=nCurrent_line_id;
Line: 4505

	  SELECT count(*)
          INTO l_numOfSublines
          FROM OKC_K_LINES_B
          WHERE DNZ_CHR_ID=vHeader_id
          AND CLE_ID=nCurrent_line_id;
Line: 4538

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_hv
             where k_header_id=vHeader_id
             and k_line_id is null
             and major_version=vVersion_1;
Line: 4551

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_v
             where k_header_id=vHeader_id
             and k_line_id is null;
Line: 4563

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_hv
             where k_header_id=vHeader_id
             and k_line_id is null
             and major_version=vVersion_2;
Line: 4576

     	     SELECT meaning
       	     FROM   fnd_lookup_values_vl
             WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
             AND    lookup_code = l_Object
             AND    view_application_id=777;
Line: 4613

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4638

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4674

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4699

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4718

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_hv
             where k_header_id=vHeader_id
             and k_line_id = vLine_id
             and major_version=vVersion_1;
Line: 4731

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_v
             where k_header_id=vHeader_id
             and k_line_id = vLine_id;
Line: 4743

             SELECT
             major_version,
             term_code,
             term_value_pk1,
             term_value_pk2,
             term_name,
             term_value
             from oke_k_all_terms_hv
             where k_header_id=vHeader_id
             and k_line_id = vLine_id
             and major_version=vVersion_2;
Line: 4756

     	     SELECT meaning
       	     FROM   fnd_lookup_values_vl
             WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
             AND    lookup_code = l_Object
             AND    view_application_id=777;
Line: 4793

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4818

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4844

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4869

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 4890

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_hv
     WHERE chr_id=vHeader_id
     AND   dnz_chr_id=vHeader_id
     AND major_version=vVersion_1;
Line: 4904

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_hv
     WHERE chr_id=vHeader_id
     AND   dnz_chr_id=vHeader_id
     AND major_version=vVersion_2;
Line: 4920

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_v
     WHERE chr_id=vHeader_id
     AND   dnz_chr_id=vHeader_id;
Line: 4932

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 4980

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5011

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5043

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5072

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5091

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_hv
     WHERE dnz_chr_id=vHeader_id
     AND cle_id = vLine_id
     AND major_version=vVersion_1;
Line: 5105

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_hv
     WHERE dnz_chr_id=vHeader_id
     AND cle_id = vLine_id
     AND major_version=vVersion_2;
Line: 5121

     SELECT
        role,
        cognomen,
        alias,
        object1_id1,
        object1_id2,
        jtot_object1_code
     FROM  okc_k_party_roles_v
     WHERE dnz_chr_id=vHeader_id
     AND cle_id = vLine_id;
Line: 5133

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 5178

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5208

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5242

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5272

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 5376

         SELECT deliverable_id
         from oke_k_deliverables_bh
         where k_header_id=vHeader_id
         and k_line_id=vCurrentLineId
         and major_version=vVersion2
         ORDER BY deliverable_num;
Line: 5390

            SELECT meaning
            FROM   fnd_lookup_values_vl
            WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
            AND    lookup_code = l_Object
            AND    view_application_id=777;
Line: 5397

	    SELECT name
            FROM OKE_SYSTEM_ITEMS_V
            WHERE id1=v_item_id;
Line: 5402

            SELECT buy_or_sell
            FROM OKE_K_HEADERS_V
            WHERE k_header_id = v_header_id;
Line: 5407

  	select name from hr_organization_units
  	where organization_id = p_id;
Line: 5411

  	select name from okx_vendors_v
  	where id1 = p_id;
Line: 5415

  	select name from okx_customer_accounts_v
  	where id1 = p_id;
Line: 5419

  	select name from okx_vendors_v
 	where id1 = p_id;
Line: 5423

  	select name from okx_organization_defs_v
  	where id1 = p_id;
Line: 5427

  	select name from okx_customer_accounts_v
  	where id1 = p_id;
Line: 5432

            SELECT name
            from OKX_LOCATIONS_V
            where id1 = v_ship_to_location_id;
Line: 5438

            SELECT name
            from OKE_CUST_SITE_USES_V
            where id1 = v_ship_to_location_id
            and site_use_code = 'SHIP_TO';
Line: 5445

            SELECT name
            from okx_locations_v
            where id1 = v_ship_from_location_id;
Line: 5451

            SELECT name
            from OKE_CUST_SITE_USES_V
            where id1 = v_ship_from_location_id
            and site_use_code = 'SHIP_TO';
Line: 5458

            SELECT name
            from OKE_VENDOR_SITES_V
            where id1 = v_ship_from_location_id;
Line: 5463

            SELECT name
            FROM pa_organizations_expend_v
            WHERE organization_id=v_org_id;
Line: 5485

      	 SELECT deliverable_id
      	 from oke_k_deliverables_bh
     	 where k_header_id=vHeader_id
      	 and k_line_id=vCurrentLineId
         and major_version=vVersion1
         ORDER BY deliverable_num;
Line: 5493

      	 SELECT deliverable_id
      	 from oke_k_deliverables_b
     	 where k_header_id=vHeader_id
      	 and k_line_id=vCurrentLineId
         ORDER BY deliverable_num;
Line: 5517

           SELECT deliverable_num
           INTO current_deliverable_num
           from oke_k_deliverables_bh
           where k_header_id=vHeader_id
           and k_line_id=vCurrentLineId
           and major_version=vVersion1
           and deliverable_id=current_deliverable_1;
Line: 5528

	   SELECT deliverable_num
           INTO current_deliverable_num
           from oke_k_deliverables_b
           where k_header_id=vHeader_id
           and k_line_id=vCurrentLineId
           and deliverable_id=current_deliverable_1;
Line: 5552

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5561

              SELECT
		deliverable_num,
		item_id,
                description,
		project_number,
		project_name,
		task_number,
		delivery_date,
		status_code,
		parent_deliverable_id,
		direction,
		ship_to_org_id,
		ship_to_location_id,
		ship_from_org_id,
		ship_from_location_id,
		start_date,
		end_date,
		need_by_date,
		priority_code,
		currency_code,
		unit_price,
		uom_code,
		quantity,
		country_of_origin_code,
		subcontracted_flag,
		dependency_flag,
		billable_flag,
		billing_event_id,
		drop_shipped_flag,
		completed_flag,
		available_for_ship_flag,
		create_demand,
		ready_to_bill,
		ready_to_procure,
		mps_transaction_id,
		shipping_request_id,
		unit_number,
		ndb_schedule_designator,
		shippable_flag,
		cfe_req_flag,
		inspection_req_flag,
		interim_rpt_req_flag,
		lot_applies_flag,
		customer_approval_req_flag,
		date_of_first_submission,
		frequency,
		acq_doc_number,
		submission_flag,
		data_item_subtitle,
		total_num_of_copies,
		cdrl_category,
		data_item_name,
		export_flag,
		export_license_num,
		export_license_res,
		comments,
		sfwt_flag,
		status,
		volume,
		volume_uom_code,
		weight,
		weight_uom_code,
		expenditure_type,
		expenditure_organization_id,
		expenditure_item_date,
		destination_type_code,
		rate_type,
		rate_date,
		exchange_rate,
		expected_shipment_date,
		initiate_shipment_date,
		promised_shipment_date


           INTO r_deliverable_1
           FROM oke_k_deliverables_vlh
           WHERE deliverable_id=current_deliverable_1
           AND major_version=vVersion1;
Line: 5644

           SELECT
		deliverable_num,
		item_id,
                description,
                project_number,
		project_name,
		task_number,
		delivery_date,
		status_code,
		parent_deliverable_id,
		direction,
		ship_to_org_id,
		ship_to_location_id,
		ship_from_org_id,
		ship_from_location_id,
		start_date,
		end_date,
		need_by_date,
		priority_code,
		currency_code,
		unit_price,
		uom_code,
		quantity,
		country_of_origin_code,
		subcontracted_flag,
		dependency_flag,
		billable_flag,
		billing_event_id,
		drop_shipped_flag,
		completed_flag,
		available_for_ship_flag,
		create_demand,
		ready_to_bill,
		ready_to_procure,
		mps_transaction_id,
		shipping_request_id,
		unit_number,
		ndb_schedule_designator,
		shippable_flag,
		cfe_req_flag,
		inspection_req_flag,
		interim_rpt_req_flag,
		lot_applies_flag,
		customer_approval_req_flag,
		date_of_first_submission,
		frequency,
		acq_doc_number,
		submission_flag,
		data_item_subtitle,
		total_num_of_copies,
		cdrl_category,
		data_item_name,
		export_flag,
		export_license_num,
		export_license_res,
		comments,
		sfwt_flag,
		status,
		volume,
		volume_uom_code,
		weight,
		weight_uom_code,
		expenditure_type,
		expenditure_organization_id,
		expenditure_item_date,
		destination_type_code,
		rate_type,
		rate_date,
		exchange_rate,
		expected_shipment_date,
		initiate_shipment_date,
		promised_shipment_date

           INTO r_deliverable_1
           FROM oke_k_deliverables_vl
           WHERE deliverable_id=current_deliverable_1
           AND major_version=vVersion1;
Line: 5725

           SELECT
		deliverable_num,
		item_id,
                description,
                project_number,
		project_name,
		task_number,
		delivery_date,
		status_code,
		parent_deliverable_id,
		direction,
		ship_to_org_id,
		ship_to_location_id,
		ship_from_org_id,
		ship_from_location_id,
		start_date,
		end_date,
		need_by_date,
		priority_code,
		currency_code,
		unit_price,
		uom_code,
		quantity,
		country_of_origin_code,
		subcontracted_flag,
		dependency_flag,
		billable_flag,
		billing_event_id,
		drop_shipped_flag,
		completed_flag,
		available_for_ship_flag,
		create_demand,
		ready_to_bill,
		ready_to_procure,
		mps_transaction_id,
		shipping_request_id,
		unit_number,
		ndb_schedule_designator,
		shippable_flag,
		cfe_req_flag,
		inspection_req_flag,
		interim_rpt_req_flag,
		lot_applies_flag,
		customer_approval_req_flag,
		date_of_first_submission,
		frequency,
		acq_doc_number,
		submission_flag,
		data_item_subtitle,
		total_num_of_copies,
		cdrl_category,
		data_item_name,
		export_flag,
		export_license_num,
		export_license_res,
		comments,
		sfwt_flag,
		status,
		volume,
		volume_uom_code,
		weight,
		weight_uom_code,
		expenditure_type,
		expenditure_organization_id,
		expenditure_item_date,
		destination_type_code,
		rate_type,
		rate_date,
		exchange_rate,
		expected_shipment_date,
		initiate_shipment_date,
		promised_shipment_date


           INTO r_deliverable_2
           FROM oke_k_deliverables_vlh
           WHERE deliverable_id=current_deliverable_1
           AND major_version=vVersion2;
Line: 5811

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5827

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5835

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5845

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5855

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5865

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5876

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5886

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5896

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5923

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5952

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 5992

               insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6032

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6042

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6054

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6064

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6074

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6083

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6093

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6102

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6111

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6120

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6129

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6138

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6148

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6158

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6167

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6177

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6187

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6197

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6206

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6216

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6226

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6236

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6247

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6257

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6267

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6276

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6286

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6296

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6305

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6314

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6323

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6333

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6343

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6352

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6362

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6372

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6382

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6392

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6401

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6411

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6421

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6431

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6441

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6451

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6461

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6471

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6481

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6497

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6507

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6517

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6527

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6537

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6548

              insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6581

           SELECT deliverable_num
           INTO current_deliverable_num
           from oke_k_deliverables_bh
           where k_header_id=vHeader_id
           and k_line_id=vCurrentLineId
           and major_version=vVersion2
           and deliverable_id=c_deliverable_2.deliverable_id;
Line: 6592

           insert_comp_result(vHeader_id,vVersion1,vVersion2);
Line: 6607

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
        --SAV_SAE_ID,
       (SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_hv h
     WHERE dnz_chr_id=vHeader_id
     AND cle_id is null
     AND major_version=vVersion_1;
Line: 6627

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
--        SAV_SAE_ID,
        (SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_hv h
     WHERE dnz_chr_id=vHeader_id
     AND cle_id is null
     AND major_version=vVersion_2;
Line: 6648

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
--        SAV_SAE_ID,
        (SELECT sav_sae_id FROM okc_k_articles_b WHERE id=k.id) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_v k
     WHERE dnz_chr_id=vHeader_id
     AND cle_id is null;
Line: 6666

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 6732

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 6776

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 6821

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 6865

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 6883

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
        -- SAV_SAE_ID,
        (SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_hv h
     WHERE dnz_chr_id=vHeader_id
     AND cle_id =vLine_id
     AND major_version=vVersion_1;
Line: 6903

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
        -- SAV_SAE_ID,
        (SELECT sav_sae_id FROM okc_k_articles_bh WHERE id=h.id AND major_version=h.major_version) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_hv h
     WHERE dnz_chr_id=vHeader_id
     AND cle_id = vLine_id
     AND major_version=vVersion_2;
Line: 6924

     SELECT
        CHR_ID,
        CLE_ID,
        CAT_ID,
        CAT_TYPE,
        SFWT_FLAG,
        -- SAV_SAE_ID,
        (SELECT sav_sae_id FROM okc_k_articles_b WHERE id=k.id) SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        COMMENTS,
        NAME,
        TEXT
     FROM  okc_k_articles_v k
     WHERE dnz_chr_id=vHeader_id
     AND cle_id =vLine_id;
Line: 6942

       SELECT meaning
       FROM   fnd_lookup_values_vl
       WHERE  lookup_type = 'VER_COMP_OBJECT_TYPE'
       AND    lookup_code = l_Object
       AND    view_application_id=777;
Line: 7006

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 7049

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 7096

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);
Line: 7138

                     insert_comp_result(vHeader_id,vVersion_1,vVersion_2);