APPS.OKE_CLE_PVT SQL Statements

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

Line: 25

  SELECT 'x' FROM OKE_K_LINES_V
  WHERE K_LINE_ID = p_cle_rec.PARENT_LINE_ID;

Line: 85

  select 'x'
  from mtl_customer_items item
  where item.customer_item_id = p_cle_rec.customer_item_id;

Line: 90

  SELECT BUY_OR_SELL FROM
  OKC_K_HEADERS_B H, OKC_K_LINES_B L
  WHERE L.DNZ_CHR_ID = H.ID
  AND L.ID = p_cle_rec.k_line_id;

Line: 172

  select trunc(start_date)
  from okc_k_lines_b
  where id = p_cle_rec.k_line_id;

Line: 231

  SELECT 'x' FROM PA_PROJECTS_ALL
  WHERE PROJECT_ID = p_cle_rec.PROJECT_ID;

Line: 239

  SELECT DNZ_CHR_ID, CLE_ID
  FROM OKC_K_LINES_B
  WHERE ID = p_cle_rec.K_LINE_ID;

Line: 244

  SELECT KE.PROJECT_ID,KE.TASK_ID
  FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
  WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
  AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
  ORDER BY AN.LEVEL_SEQUENCE DESC;

Line: 251

  SELECT PROJECT_ID, TASK_ID
  FROM OKE_K_LINES
  WHERE K_LINE_ID = L_PARENT_LINE_ID;

Line: 262

  SELECT 'x' FROM
  (
  select p.project_id pid,p.segment1
  from pa_projects_all p
  where p.project_id in
  (select to_number(sub_project_id) project_id
  from pa_fin_structures_links_v
  start with parent_project_id = l_project_id_from
  and parent_task_id in (select task_id from pa_tasks where project_id=l_project_id_from
  and top_task_id=nvl(l_task_id_from,top_task_id) )
  connect by parent_project_id = prior sub_project_id)
  union
  select project_id pid,segment1
  from pa_projects_all
  where project_id = l_project_id_from)
  WHERE pid = p_cle_rec.PROJECT_ID;

Line: 281

  SELECT 'x' FROM
  (
  select project_id pid,segment1
  from pa_projects_all
  where project_id = l_project_id_from)
  WHERE pid = p_cle_rec.PROJECT_ID;

Line: 289

  	select 'x'
	from   pa_fin_structures_links_v
	start with ((parent_project_id =  x_proj ) and parent_task_id in
                   (select task_id from pa_tasks
                    where  project_id = x_proj
                    and    top_task_id = nvl(x_task, top_task_id)))
	connect by parent_project_id = prior sub_project_id;

Line: 301

  SELECT project_id
  from oke_k_headers
  where k_header_id = l_header_id;

Line: 429

  SELECT 'x' FROM PA_TASKS
  WHERE TASK_ID = p_cle_rec.TASK_ID;

Line: 437

  SELECT DNZ_CHR_ID, CLE_ID
  FROM OKC_K_LINES_B
  WHERE ID = p_cle_rec.K_LINE_ID;

Line: 442

  SELECT KE.PROJECT_ID,KE.TASK_ID
  FROM OKC_ANCESTRYS AN, OKE_K_LINES KE
  WHERE AN.CLE_ID=L_PARENT_LINE_ID AND KE.PROJECT_ID IS NOT NULL
  AND AN.CLE_ID_ASCENDANT = KE.K_LINE_ID
  ORDER BY AN.LEVEL_SEQUENCE DESC;

Line: 449

  SELECT PROJECT_ID, TASK_ID
  FROM OKE_K_LINES
  WHERE K_LINE_ID = L_PARENT_LINE_ID;

Line: 456

  SELECT project_id
  from oke_k_headers
  where k_header_id = l_header_id;

Line: 467

SELECT 'x' FROM (
select task_id, task_number,task_name,description from pa_tasks
where parent_task_id is null
and (( project_id <>l_project_id_from and project_id = l_project_id)
or
( project_id = l_project_id_from and project_id = l_project_id
  and task_id = nvl(l_task_id_from,task_id)))     )
WHERE task_id = p_cle_rec.Task_ID;

Line: 581

  SELECT INV_ORGANIZATION_ID FROM
  OKC_K_HEADERS_B H,OKC_K_LINES_B L
  WHERE H.ID = L.DNZ_CHR_ID
  AND L.ID = p_cle_rec.k_line_id;

Line: 587

  SELECT lse_id from okc_k_lines_b
  WHERE ID = p_cle_rec.k_line_id;

Line: 591

  SELECT 'x' FROM OKE_SYSTEM_ITEMS_V
  WHERE ORGANIZATION_ID = l_org
  AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1)
  AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND STATUS = 'A'
  AND ID1 = p_cle_rec.inventory_item_id;

Line: 599

    SELECT jo.object_code
    ,      jo.from_table
    ,      jo.where_clause
    ,      jo.order_by_clause
    ,      jo.name
    FROM   okc_line_style_sources_v ls
    ,      jtf_objects_vl jo
    WHERE  ls.lse_id = l_lse_id
    AND    jo.object_code = ls.jtot_object_code
    AND sysdate BETWEEN start_date
                    AND nvl(end_date,sysdate + 1);

Line: 693

  SELECT DNZ_CHR_ID
  FROM OKC_K_LINES_B
  WHERE ID = p_cle_rec.k_line_id;

Line: 700

  SELECT 'x' FROM OKE_K_BILLING_METHODS
  WHERE BILLING_METHOD_CODE = p_cle_rec.BILLING_METHOD_CODE
  AND K_HEADER_ID = l_header;

Line: 766

  SELECT 'x' FROM
  mtl_item_uoms_view
  where inventory_item_id = p_cle_rec.inventory_item_id
  and uom_code = p_cle_rec.uom_code;

Line: 773

  SELECT 'x' FROM
  mtl_units_of_measure_vl
  where uom_code = p_cle_rec.uom_code;

Line: 860

  SELECT 'x'  FROM OKE_PRIORITY_CODES_VL
  WHERE PRIORITY_CODE = p_cle_rec.priority_code;

Line: 914

  SELECT 'x'
  FROM FND_TERRITORIES_VL
  WHERE TERRITORY_CODE = p_cle_rec.COUNTRY_OF_ORIGIN_CODE;

Line: 2051

    SELECT 	K_LINE_ID			,
		PARENT_LINE_ID			,
		PROJECT_ID			,
		TASK_ID				,
		BILLING_METHOD_CODE		,
		INVENTORY_ITEM_ID				,
		DELIVERY_ORDER_FLAG		,
	        SPLITED_FLAG			,
		PRIORITY_CODE			,
		CUSTOMER_ITEM_ID		,
		CUSTOMER_ITEM_NUMBER		,
		LINE_QUANTITY			,
		DELIVERY_DATE			,
		PROPOSAL_DUE_DATE		,
		UNIT_PRICE			,
		UOM_CODE			,
		LINE_VALUE			,
		LINE_VALUE_TOTAL		,
		UNDEF_UNIT_PRICE		,
		UNDEF_LINE_VALUE		,
		UNDEF_LINE_VALUE_TOTAL		,
		END_DATE			,
		BILLABLE_FLAG			,
		SHIPPABLE_FLAG			,
		SUBCONTRACTED_FLAG		,
		COMPLETED_FLAG			,
		NSP_FLAG			,
		APP_CODE			,
		AS_OF_DATE			,
		AUTHORITY			,
		COUNTRY_OF_ORIGIN_CODE		,
		DROP_SHIPPED_FLAG		,
		CUSTOMER_APPROVAL_REQ_FLAG	,
		DATE_MATERIAL_REQ		,
		INSPECTION_REQ_FLAG		,
		INTERIM_RPT_REQ_FLAG		,
		SUBJ_A133_FLAG			,
		EXPORT_FLAG			,
		CFE_REQ_FLAG			,
		COP_REQUIRED_FLAG		,
		EXPORT_LICENSE_NUM		,
		EXPORT_LICENSE_RES		,
		COPIES_REQUIRED			,
		CDRL_CATEGORY			,
		DATA_ITEM_NAME			,
		DATA_ITEM_SUBTITLE		,
		DATE_OF_FIRST_SUBMISSION	,
		FREQUENCY			,
		REQUIRING_OFFICE		,
		DCAA_AUDIT_REQ_FLAG		,
		DEFINITIZED_FLAG		,
		COST_OF_MONEY			,
		BILL_UNDEFINITIZED_FLAG		,
		NSN_NUMBER			,
		NTE_WARNING_FLAG		,
		DISCOUNT_FOR_PAYMENT		,
		FINANCIAL_CTRL_FLAG		,
		C_SCS_FLAG			,
		C_SSR_FLAG			,
		PREPAYMENT_AMOUNT		,
		PREPAYMENT_PERCENTAGE		,
		PROGRESS_PAYMENT_FLAG		,
		PROGRESS_PAYMENT_LIQ_RATE	,
		PROGRESS_PAYMENT_RATE		,
		AWARD_FEE			,
		AWARD_FEE_POOL_AMOUNT		,
		BASE_FEE			,
		CEILING_COST				,
		CEILING_PRICE				,
		COST_OVERRUN_SHARE_RATIO		,
		COST_UNDERRUN_SHARE_RATIO		,
		LABOR_COST_INDEX			,
		MATERIAL_COST_INDEX			,
		CUSTOMERS_PERCENT_IN_ORDER	,
		DATE_OF_PRICE_REDETERMIN	,
		ESTIMATED_TOTAL_QUANTITY	,
		FEE_AJT_FORMULA		,
		FINAL_FEE			,
		FINAL_PFT_AJT_FORMULA		,
		FIXED_FEE			,
		FIXED_QUANTITY			,
		INITIAL_FEE			,
		INITIAL_PRICE			,
		LEVEL_OF_EFFORT_HOURS		,
		LINE_LIQUIDATION_RATE		,
		MAXIMUM_FEE			,
		MAXIMUM_QUANTITY		,
		MINIMUM_FEE			,
		MINIMUM_QUANTITY		,
		NUMBER_OF_OPTIONS		,
		REVISED_PRICE			,
		TARGET_COST			,
		TARGET_DATE_DEFINITIZE		,
		TARGET_FEE			,
		TARGET_PRICE			,
		TOTAL_ESTIMATED_COST		,
		CREATED_BY			,
		CREATION_DATE			,
		LAST_UPDATED_BY			,
		LAST_UPDATE_LOGIN		,
		LAST_UPDATE_DATE		,
		COST_OF_SALE_RATE

    FROM OKE_K_LINES
    WHERE OKE_K_LINES.K_LINE_ID = p_id;

Line: 2264

		l_cle_rec.LAST_UPDATED_BY			,
		l_cle_rec.LAST_UPDATE_LOGIN		,
		l_cle_rec.LAST_UPDATE_DATE		,
		l_cle_rec.COST_OF_SALE_RATE;

Line: 2685

    IF	l_cle_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	l_cle_rec.LAST_UPDATED_BY := NULL;

Line: 2689

    IF	l_cle_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	l_cle_rec.LAST_UPDATE_LOGIN := NULL;

Line: 2693

    IF	l_cle_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	l_cle_rec.LAST_UPDATE_DATE := NULL;

Line: 3267

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_rec                      IN cle_rec_type,
    x_cle_rec                      OUT NOCOPY cle_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3277

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 3295

      l_cle_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3296

      l_cle_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3297

      l_cle_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3400

    INSERT INTO OKE_K_LINES(
                K_LINE_ID			,
		PARENT_LINE_ID			,
		PROJECT_ID			,
		TASK_ID				,
		BILLING_METHOD_CODE		,
		INVENTORY_ITEM_ID				,
		DELIVERY_ORDER_FLAG			,
		SPLITED_FLAG			,
		PRIORITY_CODE			,
		CUSTOMER_ITEM_ID		,
		CUSTOMER_ITEM_NUMBER		,
		LINE_QUANTITY			,
		DELIVERY_DATE			,
		PROPOSAL_DUE_DATE		,
		UNIT_PRICE			,
		UOM_CODE			,
		LINE_VALUE			,
		LINE_VALUE_TOTAL		,
		UNDEF_UNIT_PRICE		,
		UNDEF_LINE_VALUE		,
		UNDEF_LINE_VALUE_TOTAL		,
		END_DATE			,
		BILLABLE_FLAG			,
		SHIPPABLE_FLAG			,
		SUBCONTRACTED_FLAG		,
		COMPLETED_FLAG			,
		NSP_FLAG			,
		APP_CODE			,
		AS_OF_DATE			,
		AUTHORITY			,
		COUNTRY_OF_ORIGIN_CODE		,
		DROP_SHIPPED_FLAG		,
		CUSTOMER_APPROVAL_REQ_FLAG	,
		DATE_MATERIAL_REQ		,
		INSPECTION_REQ_FLAG		,
		INTERIM_RPT_REQ_FLAG		,
		SUBJ_A133_FLAG			,
		EXPORT_FLAG			,
		CFE_REQ_FLAG			,
		COP_REQUIRED_FLAG		,
		EXPORT_LICENSE_NUM		,
		EXPORT_LICENSE_RES		,
		COPIES_REQUIRED			,
		CDRL_CATEGORY			,
		DATA_ITEM_NAME			,
		DATA_ITEM_SUBTITLE		,
		DATE_OF_FIRST_SUBMISSION	,
		FREQUENCY			,
		REQUIRING_OFFICE		,
		DCAA_AUDIT_REQ_FLAG		,
		DEFINITIZED_FLAG		,
		COST_OF_MONEY			,
		BILL_UNDEFINITIZED_FLAG		,
		NSN_NUMBER			,
		NTE_WARNING_FLAG		,
		DISCOUNT_FOR_PAYMENT		,
		FINANCIAL_CTRL_FLAG		,
		C_SCS_FLAG			,
		C_SSR_FLAG			,
		PREPAYMENT_AMOUNT		,
		PREPAYMENT_PERCENTAGE		,
		PROGRESS_PAYMENT_FLAG		,
		PROGRESS_PAYMENT_LIQ_RATE	,
		PROGRESS_PAYMENT_RATE		,
		AWARD_FEE			,
		AWARD_FEE_POOL_AMOUNT		,
		BASE_FEE			,
		CEILING_COST				,
		CEILING_PRICE				,
		COST_OVERRUN_SHARE_RATIO		,
		COST_UNDERRUN_SHARE_RATIO		,
		LABOR_COST_INDEX			,
		MATERIAL_COST_INDEX			,
		CUSTOMERS_PERCENT_IN_ORDER	,
		DATE_OF_PRICE_REDETERMIN	,
		ESTIMATED_TOTAL_QUANTITY	,
		FEE_AJT_FORMULA		,
		FINAL_FEE			,
		FINAL_PFT_AJT_FORMULA		,
		FIXED_FEE			,
		FIXED_QUANTITY			,
		INITIAL_FEE			,
		INITIAL_PRICE			,
		LEVEL_OF_EFFORT_HOURS		,
		LINE_LIQUIDATION_RATE		,
		MAXIMUM_FEE			,
		MAXIMUM_QUANTITY		,
		MINIMUM_FEE			,
		MINIMUM_QUANTITY		,
		NUMBER_OF_OPTIONS		,
		REVISED_PRICE			,
		TARGET_COST			,
		TARGET_DATE_DEFINITIZE		,
		TARGET_FEE			,
		TARGET_PRICE			,
		TOTAL_ESTIMATED_COST		,
		CREATED_BY			,
		CREATION_DATE			,
		LAST_UPDATED_BY			,
		LAST_UPDATE_LOGIN		,
		LAST_UPDATE_DATE		,
		COST_OF_SALE_RATE)
    VALUES(
		l_def_cle_rec.K_LINE_ID			,
		l_def_cle_rec.PARENT_LINE_ID		,
		l_def_cle_rec.PROJECT_ID			,
		l_def_cle_rec.TASK_ID			,
		l_def_cle_rec.BILLING_METHOD_CODE		,
		l_def_cle_rec.INVENTORY_ITEM_ID			,
		l_def_cle_rec.DELIVERY_ORDER_FLAG			,
                l_def_cle_rec.SPLITED_FLAG		,
		l_def_cle_rec.PRIORITY_CODE			,
		l_def_cle_rec.CUSTOMER_ITEM_ID		,
		l_def_cle_rec.CUSTOMER_ITEM_NUMBER	,
		l_def_cle_rec.LINE_QUANTITY			,
		l_def_cle_rec.DELIVERY_DATE			,
		l_def_cle_rec.PROPOSAL_DUE_DATE		,
		l_def_cle_rec.UNIT_PRICE			,
		l_def_cle_rec.UOM_CODE			,
		l_def_cle_rec.LINE_VALUE		,
		l_def_cle_rec.LINE_VALUE_TOTAL		,
		l_def_cle_rec.UNDEF_UNIT_PRICE		,
		l_def_cle_rec.UNDEF_LINE_VALUE		,
		l_def_cle_rec.UNDEF_LINE_VALUE_TOTAL	,
		l_def_cle_rec.END_DATE			,
		l_def_cle_rec.BILLABLE_FLAG			,
		l_def_cle_rec.SHIPPABLE_FLAG		,
		l_def_cle_rec.SUBCONTRACTED_FLAG		,
		l_def_cle_rec.COMPLETED_FLAG		,
		l_def_cle_rec.NSP_FLAG			,
		l_def_cle_rec.APP_CODE			,
		l_def_cle_rec.AS_OF_DATE			,
		l_def_cle_rec.AUTHORITY			,
		l_def_cle_rec.COUNTRY_OF_ORIGIN_CODE	,
		l_def_cle_rec.DROP_SHIPPED_FLAG		,
		l_def_cle_rec.CUSTOMER_APPROVAL_REQ_FLAG	,
		l_def_cle_rec.DATE_MATERIAL_REQ		,
		l_def_cle_rec.INSPECTION_REQ_FLAG		,
		l_def_cle_rec.INTERIM_RPT_REQ_FLAG		,
		l_def_cle_rec.SUBJ_A133_FLAG		,
		l_def_cle_rec.EXPORT_FLAG			,
		l_def_cle_rec.CFE_REQ_FLAG			,
		l_def_cle_rec.COP_REQUIRED_FLAG		,
		l_def_cle_rec.EXPORT_LICENSE_NUM		,
		l_def_cle_rec.EXPORT_LICENSE_RES		,
		l_def_cle_rec.COPIES_REQUIRED		,
		l_def_cle_rec.CDRL_CATEGORY			,
		l_def_cle_rec.DATA_ITEM_NAME		,
		l_def_cle_rec.DATA_ITEM_SUBTITLE		,
		l_def_cle_rec.DATE_OF_FIRST_SUBMISSION	,
		l_def_cle_rec.FREQUENCY			,
		l_def_cle_rec.REQUIRING_OFFICE		,
		l_def_cle_rec.DCAA_AUDIT_REQ_FLAG		,
		l_def_cle_rec.DEFINITIZED_FLAG		,
		l_def_cle_rec.COST_OF_MONEY			,
		l_def_cle_rec.BILL_UNDEFINITIZED_FLAG	,
		l_def_cle_rec.NSN_NUMBER			,
		l_def_cle_rec.NTE_WARNING_FLAG		,
		l_def_cle_rec.DISCOUNT_FOR_PAYMENT		,
		l_def_cle_rec.FINANCIAL_CTRL_FLAG		,
		l_def_cle_rec.C_SCS_FLAG			,
		l_def_cle_rec.C_SSR_FLAG			,
		l_def_cle_rec.PREPAYMENT_AMOUNT		,
		l_def_cle_rec.PREPAYMENT_PERCENTAGE		,
		l_def_cle_rec.PROGRESS_PAYMENT_FLAG		,
		l_def_cle_rec.PROGRESS_PAYMENT_LIQ_RATE	,
		l_def_cle_rec.PROGRESS_PAYMENT_RATE		,
		l_def_cle_rec.AWARD_FEE			,
		l_def_cle_rec.AWARD_FEE_POOL_AMOUNT	,
		l_def_cle_rec.BASE_FEE			,
		l_def_cle_rec.CEILING_COST			,
		l_def_cle_rec.CEILING_PRICE			,
		l_def_cle_rec.COST_OVERRUN_SHARE_RATIO		,
		l_def_cle_rec.COST_UNDERRUN_SHARE_RATIO		,
		l_def_cle_rec.LABOR_COST_INDEX			,
		l_def_cle_rec.MATERIAL_COST_INDEX		,
		l_def_cle_rec.CUSTOMERS_PERCENT_IN_ORDER	,
		l_def_cle_rec.DATE_OF_PRICE_REDETERMIN	,
		l_def_cle_rec.ESTIMATED_TOTAL_QUANTITY	,
		l_def_cle_rec.FEE_AJT_FORMULA		,
		l_def_cle_rec.FINAL_FEE			,
		l_def_cle_rec.FINAL_PFT_AJT_FORMULA	,
		l_def_cle_rec.FIXED_FEE			,
		l_def_cle_rec.FIXED_QUANTITY		,
		l_def_cle_rec.INITIAL_FEE			,
		l_def_cle_rec.INITIAL_PRICE			,
		l_def_cle_rec.LEVEL_OF_EFFORT_HOURS		,
		l_def_cle_rec.LINE_LIQUIDATION_RATE		,
		l_def_cle_rec.MAXIMUM_FEE			,
		l_def_cle_rec.MAXIMUM_QUANTITY		,
		l_def_cle_rec.MINIMUM_FEE			,
		l_def_cle_rec.MINIMUM_QUANTITY		,
		l_def_cle_rec.NUMBER_OF_OPTIONS		,
		l_def_cle_rec.REVISED_PRICE			,
		l_def_cle_rec.TARGET_COST			,
		l_def_cle_rec.TARGET_DATE_DEFINITIZE	,
		l_def_cle_rec.TARGET_FEE			,
		l_def_cle_rec.TARGET_PRICE			,
		l_def_cle_rec.TOTAL_ESTIMATED_COST		,
		l_def_cle_rec.CREATED_BY			,
		l_def_cle_rec.CREATION_DATE			,
		l_def_cle_rec.LAST_UPDATED_BY		,
		l_def_cle_rec.LAST_UPDATE_LOGIN		,
		l_def_cle_rec.LAST_UPDATE_DATE		,
		l_def_cle_rec.COST_OF_SALE_RATE);

Line: 3642

  END insert_row;

Line: 3644

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_tbl                      IN cle_tbl_type,
    x_cle_tbl                      OUT NOCOPY cle_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3654

    l_api_name                     CONSTANT VARCHAR2(30) := 'TBL_insert_row';

Line: 3665

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,

          p_cle_rec                      => p_cle_tbl(i),
          x_cle_rec                      => x_cle_tbl(i));

Line: 3721

  END insert_row;

Line: 3725

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_rec                      IN cle_rec_type,
    x_cle_rec                      OUT NOCOPY cle_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1.0;

Line: 3735

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 3751

      l_cle_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3752

      l_cle_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3753

      l_cle_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4171

    IF	x_cle_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	x_cle_rec.LAST_UPDATED_BY := l_cle_rec.LAST_UPDATED_BY;

Line: 4175

    IF	x_cle_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	x_cle_rec.LAST_UPDATE_LOGIN := l_cle_rec.LAST_UPDATE_LOGIN;

Line: 4179

    IF	x_cle_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	x_cle_rec.LAST_UPDATE_DATE := l_cle_rec.LAST_UPDATE_DATE;

Line: 4306

    UPDATE OKE_K_LINES
    SET
	PARENT_LINE_ID		= l_def_cle_rec.PARENT_LINE_ID,
	PROJECT_ID		= l_def_cle_rec.PROJECT_ID,
	TASK_ID			= l_def_cle_rec.TASK_ID,
	BILLING_METHOD_CODE	= l_def_cle_rec.BILLING_METHOD_CODE,
	INVENTORY_ITEM_ID	= l_def_cle_rec.INVENTORY_ITEM_ID,
	DELIVERY_ORDER_FLAG	= l_def_cle_rec.DELIVERY_ORDER_FLAG,
	SPLITED_FLAG		= l_def_cle_rec.SPLITED_FLAG,
	PRIORITY_CODE		= l_def_cle_rec.PRIORITY_CODE,
	CUSTOMER_ITEM_ID	= l_def_cle_rec.CUSTOMER_ITEM_ID,
	CUSTOMER_ITEM_NUMBER    = l_def_cle_rec.CUSTOMER_ITEM_NUMBER,
	LINE_QUANTITY		= l_def_cle_rec.LINE_QUANTITY,
	DELIVERY_DATE		= l_def_cle_rec.DELIVERY_DATE,
        PROPOSAL_DUE_DATE	= l_def_cle_rec.PROPOSAL_DUE_DATE,
	UNIT_PRICE		= l_def_cle_rec.UNIT_PRICE,
	UOM_CODE		= l_def_cle_rec.UOM_CODE,
	LINE_VALUE		= l_def_cle_rec.LINE_VALUE,
	LINE_VALUE_TOTAL	= l_def_cle_rec.LINE_VALUE_TOTAL,
	UNDEF_UNIT_PRICE	= l_def_cle_rec.UNDEF_UNIT_PRICE,
	UNDEF_LINE_VALUE	= l_def_cle_rec.UNDEF_LINE_VALUE,
	UNDEF_LINE_VALUE_TOTAL	= l_def_cle_rec.UNDEF_LINE_VALUE_TOTAL,
	END_DATE		= l_def_cle_rec.END_DATE,
	BILLABLE_FLAG		= l_def_cle_rec.BILLABLE_FLAG,
	SHIPPABLE_FLAG		= l_def_cle_rec.SHIPPABLE_FLAG,
	SUBCONTRACTED_FLAG	= l_def_cle_rec.SUBCONTRACTED_FLAG,
	COMPLETED_FLAG		= l_def_cle_rec.COMPLETED_FLAG,
	NSP_FLAG		= l_def_cle_rec.NSP_FLAG,
	APP_CODE		= l_def_cle_rec.APP_CODE,
	AS_OF_DATE		= l_def_cle_rec.AS_OF_DATE,
	AUTHORITY		= l_def_cle_rec.AUTHORITY,
	COUNTRY_OF_ORIGIN_CODE	= l_def_cle_rec.COUNTRY_OF_ORIGIN_CODE,
	DROP_SHIPPED_FLAG	= l_def_cle_rec.DROP_SHIPPED_FLAG,
	CUSTOMER_APPROVAL_REQ_FLAG = l_def_cle_rec.CUSTOMER_APPROVAL_REQ_FLAG,
	DATE_MATERIAL_REQ	= l_def_cle_rec.DATE_MATERIAL_REQ,
	INSPECTION_REQ_FLAG	= l_def_cle_rec.INSPECTION_REQ_FLAG,
	INTERIM_RPT_REQ_FLAG	= l_def_cle_rec.INTERIM_RPT_REQ_FLAG,
	SUBJ_A133_FLAG		= l_def_cle_rec.SUBJ_A133_FLAG,
	EXPORT_FLAG		= l_def_cle_rec.EXPORT_FLAG,
	CFE_REQ_FLAG		= l_def_cle_rec.CFE_REQ_FLAG,
	COP_REQUIRED_FLAG	= l_def_cle_rec.COP_REQUIRED_FLAG,
	EXPORT_LICENSE_NUM	= l_def_cle_rec.EXPORT_LICENSE_NUM,
	EXPORT_LICENSE_RES	= l_def_cle_rec.EXPORT_LICENSE_RES,
	COPIES_REQUIRED		= l_def_cle_rec.COPIES_REQUIRED,
	CDRL_CATEGORY		= l_def_cle_rec.CDRL_CATEGORY,
	DATA_ITEM_NAME		= l_def_cle_rec.DATA_ITEM_NAME,
	DATA_ITEM_SUBTITLE	= l_def_cle_rec.DATA_ITEM_SUBTITLE,
	DATE_OF_FIRST_SUBMISSION = l_def_cle_rec.DATE_OF_FIRST_SUBMISSION,
	FREQUENCY		= l_def_cle_rec.FREQUENCY,
	REQUIRING_OFFICE	= l_def_cle_rec.REQUIRING_OFFICE,
	DCAA_AUDIT_REQ_FLAG	= l_def_cle_rec.DCAA_AUDIT_REQ_FLAG,
	DEFINITIZED_FLAG	= l_def_cle_rec.DEFINITIZED_FLAG,
	COST_OF_MONEY		= l_def_cle_rec.COST_OF_MONEY,
	BILL_UNDEFINITIZED_FLAG	= l_def_cle_rec.BILL_UNDEFINITIZED_FLAG,
	NSN_NUMBER		= l_def_cle_rec.NSN_NUMBER,
	NTE_WARNING_FLAG	= l_def_cle_rec.NTE_WARNING_FLAG,
	DISCOUNT_FOR_PAYMENT	= l_def_cle_rec.DISCOUNT_FOR_PAYMENT,
	FINANCIAL_CTRL_FLAG	= l_def_cle_rec.FINANCIAL_CTRL_FLAG,
	C_SCS_FLAG		= l_def_cle_rec.C_SCS_FLAG,
	C_SSR_FLAG		= l_def_cle_rec.C_SSR_FLAG,
	PREPAYMENT_AMOUNT	= l_def_cle_rec.PREPAYMENT_AMOUNT,
	PREPAYMENT_PERCENTAGE	= l_def_cle_rec.PREPAYMENT_PERCENTAGE,
	PROGRESS_PAYMENT_FLAG	= l_def_cle_rec.PROGRESS_PAYMENT_FLAG,
	PROGRESS_PAYMENT_LIQ_RATE = l_def_cle_rec.PROGRESS_PAYMENT_LIQ_RATE,
	PROGRESS_PAYMENT_RATE	= l_def_cle_rec.PROGRESS_PAYMENT_RATE,
	AWARD_FEE		= l_def_cle_rec.AWARD_FEE,
	AWARD_FEE_POOL_AMOUNT	= l_def_cle_rec.AWARD_FEE_POOL_AMOUNT	,
	BASE_FEE		= l_def_cle_rec.BASE_FEE,
	CEILING_COST		= l_def_cle_rec.CEILING_COST,
        CEILING_PRICE	        = l_def_cle_rec.CEILING_PRICE,
        COST_OVERRUN_SHARE_RATIO = l_def_cle_rec.COST_OVERRUN_SHARE_RATIO,
        COST_UNDERRUN_SHARE_RATIO = l_def_cle_rec.COST_UNDERRUN_SHARE_RATIO,
	LABOR_COST_INDEX		= l_def_cle_rec.LABOR_COST_INDEX,
        MATERIAL_COST_INDEX	= l_def_cle_rec.MATERIAL_COST_INDEX,
	CUSTOMERS_PERCENT_IN_ORDER = l_def_cle_rec.CUSTOMERS_PERCENT_IN_ORDER,
	DATE_OF_PRICE_REDETERMIN = l_def_cle_rec.DATE_OF_PRICE_REDETERMIN,
	ESTIMATED_TOTAL_QUANTITY = l_def_cle_rec.ESTIMATED_TOTAL_QUANTITY,
	FEE_AJT_FORMULA		= l_def_cle_rec.FEE_AJT_FORMULA,
	FINAL_FEE		= l_def_cle_rec.FINAL_FEE,
	FINAL_PFT_AJT_FORMULA	= l_def_cle_rec.FINAL_PFT_AJT_FORMULA,
	FIXED_FEE		= l_def_cle_rec.FIXED_FEE,
	FIXED_QUANTITY		= l_def_cle_rec.FIXED_QUANTITY,
	INITIAL_FEE		= l_def_cle_rec.INITIAL_FEE,
	INITIAL_PRICE		= l_def_cle_rec.INITIAL_PRICE,
	LEVEL_OF_EFFORT_HOURS	= l_def_cle_rec.LEVEL_OF_EFFORT_HOURS,
	LINE_LIQUIDATION_RATE	= l_def_cle_rec.LINE_LIQUIDATION_RATE,
	MAXIMUM_FEE		= l_def_cle_rec.MAXIMUM_FEE,
	MAXIMUM_QUANTITY	= l_def_cle_rec.MAXIMUM_QUANTITY,
	MINIMUM_FEE		= l_def_cle_rec.MINIMUM_FEE,
	MINIMUM_QUANTITY	= l_def_cle_rec.MINIMUM_QUANTITY,
	NUMBER_OF_OPTIONS	= l_def_cle_rec.NUMBER_OF_OPTIONS,
	REVISED_PRICE		= l_def_cle_rec.REVISED_PRICE,
	TARGET_COST		= l_def_cle_rec.TARGET_COST,
	TARGET_DATE_DEFINITIZE	= l_def_cle_rec.TARGET_DATE_DEFINITIZE,
	TARGET_FEE		= l_def_cle_rec.TARGET_FEE,
	TARGET_PRICE		= l_def_cle_rec.TARGET_PRICE,
	TOTAL_ESTIMATED_COST	= l_def_cle_rec.TOTAL_ESTIMATED_COST,
	CREATED_BY		= l_def_cle_rec.CREATED_BY,
	CREATION_DATE		= l_def_cle_rec.CREATION_DATE,
	LAST_UPDATED_BY		= l_def_cle_rec.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN	= l_def_cle_rec.LAST_UPDATE_LOGIN,
	LAST_UPDATE_DATE	= l_def_cle_rec.LAST_UPDATE_DATE,
	COST_OF_SALE_RATE	= l_def_cle_rec.COST_OF_SALE_RATE

    WHERE K_LINE_ID = l_def_cle_rec.K_LINE_ID;

Line: 4448

  END update_row;

Line: 4451

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_tbl                     IN cle_tbl_type,
    x_cle_tbl                     OUT NOCOPY cle_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1.0;

Line: 4461

    l_api_name                     CONSTANT VARCHAR2(30) := 'TBL_update_row';

Line: 4473

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cle_rec                      => p_cle_tbl(i),
          x_cle_rec                     => x_cle_tbl(i));

Line: 4528

  END update_row;

Line: 4530

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_rec                     IN cle_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4539

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 4557

    DELETE FROM OKE_K_LINES
    WHERE K_LINE_ID = l_cle_rec.K_LINE_ID;

Line: 4593

  END delete_row;

Line: 4595

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cle_tbl                     IN cle_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4604

    l_api_name                     CONSTANT VARCHAR2(30) := 'TBL_delete_row';

Line: 4615

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKE_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cle_rec                      => p_cle_tbl(i));

Line: 4671

  END delete_row;