DBA Data[Home] [Help]

APPS.OKS_CDT_PVT SQL Statements

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

Line: 45

    SELECT
            ID,
            CDT_TYPE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            SEGMENT_ID1,
            SEGMENT_ID2,
            JTOT_OBJECT_CODE,
            PDF_ID,
            QCL_ID,
            CGP_NEW_ID,
            CGP_RENEW_ID,
            PRICE_LIST_ID1,
            PRICE_LIST_ID2,
            RENEWAL_TYPE,
            PO_REQUIRED_YN,
            RENEWAL_PRICING_TYPE,
            MARKUP_PERCENT,
            RLE_CODE,
            START_DATE,
            END_DATE,
            --SECURITY_GROUP_ID,
            REVENUE_ESTIMATED_PERCENT,
            REVENUE_ESTIMATED_DURATION,
            REVENUE_ESTIMATED_PERIOD,
            TEMPLATE_SET_ID,
            THRESHOLD_CURRENCY,
            THRESHOLD_AMOUNT,
            EMAIL_ADDRESS,
            BILLING_PROFILE_ID,
            USER_ID,
            THRESHOLD_ENABLED_YN,
            GRACE_PERIOD,
            GRACE_DURATION,
            PAYMENT_TERMS_ID1,
            PAYMENT_TERMS_ID2,
            EVERGREEN_THRESHOLD_CURR,
            EVERGREEN_THRESHOLD_AMT,
            PAYMENT_METHOD,
            PAYMENT_THRESHOLD_CURR,
            PAYMENT_THRESHOLD_AMT,
            INTERFACE_PRICE_BREAK,
            CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start
            BASE_CURRENCY,
            APPROVAL_TYPE,
            EVERGREEN_APPROVAL_TYPE,
            ONLINE_APPROVAL_TYPE,
            PURCHASE_ORDER_FLAG,
            CREDIT_CARD_FLAG,
            WIRE_FLAG,
            COMMITMENT_NUMBER_FLAG,
            CHECK_FLAG,
            PERIOD_TYPE,
            PERIOD_START,
            PRICE_UOM,
            TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
      FROM Oks_K_Defaults
     WHERE oks_k_defaults.id    = p_id;
Line: 120

              l_cdt_rec.LAST_UPDATED_BY,
              l_cdt_rec.LAST_UPDATE_DATE,
              l_cdt_rec.SEGMENT_ID1,
              l_cdt_rec.SEGMENT_ID2,
              l_cdt_rec.JTOT_OBJECT_CODE,
              l_cdt_rec.PDF_ID,
              l_cdt_rec.QCL_ID,
              l_cdt_rec.CGP_NEW_ID,
              l_cdt_rec.CGP_RENEW_ID,
              l_cdt_rec.PRICE_LIST_ID1,
              l_cdt_rec.PRICE_LIST_ID2,
              l_cdt_rec.RENEWAL_TYPE,
              l_cdt_rec.PO_REQUIRED_YN,
              l_cdt_rec.RENEWAL_PRICING_TYPE,
              l_cdt_rec.MARKUP_PERCENT,
              l_cdt_rec.RLE_CODE,
              l_cdt_rec.START_DATE,
              l_cdt_rec.END_DATE,
              --l_cdt_rec.SECURITY_GROUP_ID,
              l_cdt_rec.REVENUE_ESTIMATED_PERCENT,
              l_cdt_rec.REVENUE_ESTIMATED_DURATION,
              l_cdt_rec.REVENUE_ESTIMATED_PERIOD,
              l_cdt_rec.TEMPLATE_SET_ID,
              l_cdt_rec.THRESHOLD_CURRENCY,
              l_cdt_rec.THRESHOLD_AMOUNT,
              l_cdt_rec.EMAIL_ADDRESS,
              l_cdt_rec.BILLING_PROFILE_ID,
              l_cdt_rec.USER_ID,
              l_cdt_rec.THRESHOLD_ENABLED_YN,
              l_cdt_rec.GRACE_PERIOD,
              l_cdt_rec.GRACE_DURATION,
              l_cdt_rec.PAYMENT_TERMS_ID1,
              l_cdt_rec.PAYMENT_TERMS_ID2,
              l_cdt_rec.EVERGREEN_THRESHOLD_CURR,
              l_cdt_rec.EVERGREEN_THRESHOLD_AMT,
              l_cdt_rec.PAYMENT_METHOD,
              l_cdt_rec.PAYMENT_THRESHOLD_CURR,
              l_cdt_rec.PAYMENT_THRESHOLD_AMT,
              l_cdt_rec.INTERFACE_PRICE_BREAK,
              l_cdt_rec.CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start
              l_cdt_rec.BASE_CURRENCY,
              l_cdt_rec.APPROVAL_TYPE,
              l_cdt_rec.EVERGREEN_APPROVAL_TYPE,
              l_cdt_rec.ONLINE_APPROVAL_TYPE,
              l_cdt_rec.PURCHASE_ORDER_FLAG,
              l_cdt_rec.CREDIT_CARD_FLAG,
              l_cdt_rec.WIRE_FLAG,
              l_cdt_rec.COMMITMENT_NUMBER_FLAG,
              l_cdt_rec.CHECK_FLAG,
              l_cdt_rec.PERIOD_TYPE,
              l_cdt_rec.PERIOD_START,
              l_cdt_rec.PRICE_UOM,
              l_cdt_rec.TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
;
Line: 197

    SELECT
            ID,
            CDT_TYPE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            SEGMENT_ID1,
            SEGMENT_ID2,
            JTOT_OBJECT_CODE,
            PDF_ID,
            QCL_ID,
            CGP_NEW_ID,
            CGP_RENEW_ID,
            PRICE_LIST_ID1,
            PRICE_LIST_ID2,
            RENEWAL_TYPE,
            PO_REQUIRED_YN,
            RENEWAL_PRICING_TYPE,
            MARKUP_PERCENT,
            RLE_CODE,
            START_DATE,
            END_DATE,
            REVENUE_ESTIMATED_PERCENT,
            REVENUE_ESTIMATED_DURATION,
            REVENUE_ESTIMATED_PERIOD,
            TEMPLATE_SET_ID,
            THRESHOLD_CURRENCY,
            THRESHOLD_AMOUNT,
            EMAIL_ADDRESS,
            BILLING_PROFILE_ID,
            USER_ID,
            THRESHOLD_ENABLED_YN,
            GRACE_PERIOD,
            GRACE_DURATION,
            PAYMENT_TERMS_ID1,
            PAYMENT_TERMS_ID2,
            EVERGREEN_THRESHOLD_CURR,
            EVERGREEN_THRESHOLD_AMT,
            PAYMENT_METHOD,
            PAYMENT_THRESHOLD_CURR,
            PAYMENT_THRESHOLD_AMT,
            INTERFACE_PRICE_BREAK,
            CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start  /* mmadhavi 4485150 : add other columns */
            PERIOD_TYPE,
            PERIOD_START,
            PRICE_UOM,
            BASE_CURRENCY,
            APPROVAL_TYPE,
            EVERGREEN_APPROVAL_TYPE,
            ONLINE_APPROVAL_TYPE,
            PURCHASE_ORDER_FLAG,
            CREDIT_CARD_FLAG,
            WIRE_FLAG,
            COMMITMENT_NUMBER_FLAG,
            CHECK_FLAG,
            TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
      FROM Oks_K_Defaults_V
     WHERE oks_k_defaults_v.id  = p_id;
Line: 271

              l_cdtv_rec.LAST_UPDATED_BY,
              l_cdtv_rec.LAST_UPDATE_DATE,
              l_cdtv_rec.SEGMENT_ID1,
              l_cdtv_rec.SEGMENT_ID2,
              l_cdtv_rec.JTOT_OBJECT_CODE,
              l_cdtv_rec.PDF_ID,
              l_cdtv_rec.QCL_ID,
              l_cdtv_rec.CGP_NEW_ID,
              l_cdtv_rec.CGP_RENEW_ID,
              l_cdtv_rec.PRICE_LIST_ID1,
              l_cdtv_rec.PRICE_LIST_ID2,
              l_cdtv_rec.RENEWAL_TYPE,
              l_cdtv_rec.PO_REQUIRED_YN,
              l_cdtv_rec.RENEWAL_PRICING_TYPE,
              l_cdtv_rec.MARKUP_PERCENT,
              l_cdtv_rec.RLE_CODE,
              l_cdtv_rec.START_DATE,
              l_cdtv_rec.END_DATE,
              l_cdtv_rec.REVENUE_ESTIMATED_PERCENT,
              l_cdtv_rec.REVENUE_ESTIMATED_DURATION,
              l_cdtv_rec.REVENUE_ESTIMATED_PERIOD,
              l_cdtv_rec.template_set_id,
              l_cdtv_rec.THRESHOLD_CURRENCY,
              l_cdtv_rec.THRESHOLD_AMOUNT,
              l_cdtv_rec.EMAIL_ADDRESS,
              l_cdtv_rec.BILLING_PROFILE_ID,
              l_cdtv_rec.USER_ID,
              l_cdtv_rec.THRESHOLD_ENABLED_YN,
              l_cdtv_rec.GRACE_PERIOD,
              l_cdtv_rec.GRACE_DURATION,
              l_cdtv_rec.PAYMENT_TERMS_ID1,
              l_cdtv_rec.PAYMENT_TERMS_ID2,
              l_cdtv_rec.EVERGREEN_THRESHOLD_CURR,
              l_cdtv_rec.EVERGREEN_THRESHOLD_AMT,
              l_cdtv_rec.PAYMENT_METHOD,
              l_cdtv_rec.PAYMENT_THRESHOLD_CURR,
              l_cdtv_rec.PAYMENT_THRESHOLD_AMT,
              l_cdtv_rec.INTERFACE_PRICE_BREAK,
              l_cdtv_rec.CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start   /* mmadhavi 4485150 : add other columns */
              l_cdtv_rec.PERIOD_TYPE,
              l_cdtv_rec.PERIOD_START,
              l_cdtv_rec.PRICE_UOM,
              l_cdtv_rec.BASE_CURRENCY,
              l_cdtv_rec.APPROVAL_TYPE,
              l_cdtv_rec.EVERGREEN_APPROVAL_TYPE,
              l_cdtv_rec.ONLINE_APPROVAL_TYPE,
              l_cdtv_rec.PURCHASE_ORDER_FLAG,
              l_cdtv_rec.CREDIT_CARD_FLAG,
              l_cdtv_rec.WIRE_FLAG,
              l_cdtv_rec.COMMITMENT_NUMBER_FLAG,
              l_cdtv_rec.CHECK_FLAG,
              l_cdtv_rec.TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End

;
Line: 360

    IF (l_cdtv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_cdtv_rec.last_updated_by := NULL;
Line: 363

    IF (l_cdtv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_cdtv_rec.last_update_date := NULL;
Line: 806

  		select 'x'
		from FND_CURRENCIES_VL
		where currency_code = p_currency_code
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
		and enabled_flag = 'Y';
Line: 910

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_approval_type ---- Check Up
                and (lookup_type = 'OKS_REN_ONLINE_APPROVAL'
     		  or lookup_type = 'OKS_REN_MANUAL_APPROVAL')
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 1005

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_evergreen_approval_type
                and (lookup_type = 'OKS_REN_MANUAL_APPROVAL')
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 1099

  		select 'x'
		from FND_LOOKUPS
		where lookup_code = p_online_approval_type
                and (lookup_type = 'OKS_REN_ONLINE_APPROVAL')
		and sysdate between nvl(start_date_active,sysdate)
					 and nvl(end_date_active,sysdate)
                and enabled_flag = 'Y';
Line: 1433

    p_to.last_updated_by := p_from.last_updated_by;
Line: 1434

    p_to.last_update_date := p_from.last_update_date;
Line: 1498

    p_to.last_updated_by := p_from.last_updated_by;
Line: 1499

    p_to.last_update_date := p_from.last_update_date;
Line: 1705

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdt_rec                      IN cdt_rec_type,
    x_cdt_rec                      OUT NOCOPY cdt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1714

    l_api_name                     CONSTANT VARCHAR2(30) := 'DEFAULTS_insert_row';
Line: 1750

    INSERT INTO OKS_K_DEFAULTS(
        id,
        cdt_type,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        segment_id1,
        segment_id2,
        jtot_object_code,
        pdf_id,
        qcl_id,
        cgp_new_id,
        cgp_renew_id,
        price_list_id1,
        price_list_id2,
        renewal_type,
        po_required_yn,
        renewal_pricing_type,
        markup_percent,
        rle_code,
        start_date,
        end_date,
        --security_group_id,
        revenue_estimated_percent,
        revenue_estimated_duration,
        revenue_estimated_period,
        template_set_id,
        THRESHOLD_CURRENCY,
        THRESHOLD_AMOUNT,
        EMAIL_ADDRESS,
        BILLING_PROFILE_ID,
        USER_ID,
        THRESHOLD_ENABLED_YN,
        GRACE_PERIOD,
        GRACE_DURATION,
        PAYMENT_TERMS_ID1,
        PAYMENT_TERMS_ID2,
        EVERGREEN_THRESHOLD_CURR,
        EVERGREEN_THRESHOLD_AMT,
        PAYMENT_METHOD,
        PAYMENT_THRESHOLD_CURR,
        PAYMENT_THRESHOLD_AMT,
        INTERFACE_PRICE_BREAK,
        CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start
        BASE_CURRENCY	,
        APPROVAL_TYPE	,
        EVERGREEN_APPROVAL_TYPE	,
        ONLINE_APPROVAL_TYPE	,
        PURCHASE_ORDER_FLAG	,
        CREDIT_CARD_FLAG	,
        WIRE_FLAG	,
        COMMITMENT_NUMBER_FLAG	,
        CHECK_FLAG	,
        PERIOD_TYPE	,
        PERIOD_START	,
        PRICE_UOM	,
        TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
        ) VALUES (
        l_cdt_rec.id,
        l_cdt_rec.cdt_type,
        l_cdt_rec.object_version_number,
        l_cdt_rec.created_by,
        l_cdt_rec.creation_date,
        l_cdt_rec.last_updated_by,
        l_cdt_rec.last_update_date,
        l_cdt_rec.segment_id1,
        l_cdt_rec.segment_id2,
        l_cdt_rec.jtot_object_code,
        l_cdt_rec.pdf_id,
        l_cdt_rec.qcl_id,
        l_cdt_rec.cgp_new_id,
        l_cdt_rec.cgp_renew_id,
        l_cdt_rec.price_list_id1,
        l_cdt_rec.price_list_id2,
        l_cdt_rec.renewal_type,
        l_cdt_rec.po_required_yn,
        l_cdt_rec.renewal_pricing_type,
        l_cdt_rec.markup_percent,
        l_cdt_rec.rle_code,
        l_cdt_rec.start_date,
        l_cdt_rec.end_date,
        --l_cdt_rec.security_group_id,
        l_cdt_rec.revenue_estimated_percent,
        l_cdt_rec.revenue_estimated_duration,
        l_cdt_rec.revenue_estimated_period,
        l_cdt_rec.template_set_id,
        l_cdt_rec.THRESHOLD_CURRENCY,
        l_cdt_rec.THRESHOLD_AMOUNT,
        l_cdt_rec.EMAIL_ADDRESS,
        l_cdt_rec.BILLING_PROFILE_ID,
        l_cdt_rec.USER_ID,
        l_cdt_rec.THRESHOLD_ENABLED_YN,
        l_cdt_rec.GRACE_PERIOD,
        l_cdt_rec.GRACE_DURATION,
        l_cdt_rec.PAYMENT_TERMS_ID1,
        l_cdt_rec.PAYMENT_TERMS_ID2,
        l_cdt_rec.EVERGREEN_THRESHOLD_CURR,
        l_cdt_rec.EVERGREEN_THRESHOLD_AMT,
        l_cdt_rec.PAYMENT_METHOD,
        l_cdt_rec.PAYMENT_THRESHOLD_CURR,
        l_cdt_rec.PAYMENT_THRESHOLD_AMT,
        l_cdt_rec.INTERFACE_PRICE_BREAK,
        l_cdt_rec.CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start
        l_cdt_rec.BASE_CURRENCY	,
        l_cdt_rec.APPROVAL_TYPE	,
        l_cdt_rec.EVERGREEN_APPROVAL_TYPE	,
        l_cdt_rec.ONLINE_APPROVAL_TYPE	,
        l_cdt_rec.PURCHASE_ORDER_FLAG	,
        l_cdt_rec.CREDIT_CARD_FLAG	,
        l_cdt_rec.WIRE_FLAG	,
        l_cdt_rec.COMMITMENT_NUMBER_FLAG	,
        l_cdt_rec.CHECK_FLAG	,
        l_cdt_rec.PERIOD_TYPE	,
        l_cdt_rec.PERIOD_START	,
        l_cdt_rec.PRICE_UOM	,
        l_cdt_rec.TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
);
Line: 1907

  END insert_row;
Line: 1911

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_rec                     IN cdtv_rec_type,
    x_cdtv_rec                     OUT NOCOPY cdtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1921

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1937

      l_cdtv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1938

      l_cdtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2002

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cdt_rec,
      lx_cdt_rec
    );
Line: 2050

  END insert_row;
Line: 2054

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_tbl                     IN cdtv_tbl_type,
    x_cdtv_tbl                     OUT NOCOPY cdtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2064

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 2073

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cdtv_rec                     => p_cdtv_tbl(i),
          x_cdtv_rec                     => x_cdtv_tbl(i));
Line: 2116

  END insert_row;
Line: 2134

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_K_DEFAULTS
     WHERE ID = p_cdt_rec.id
       AND OBJECT_VERSION_NUMBER = p_cdt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2141

    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_K_DEFAULTS
    WHERE ID = p_cdt_rec.id;
Line: 2182

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 2191

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2378

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdt_rec                      IN cdt_rec_type,
    x_cdt_rec                      OUT NOCOPY cdt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2387

    l_api_name                     CONSTANT VARCHAR2(30) := 'DEFAULTS_update_row';
Line: 2429

      IF (x_cdt_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cdt_rec.last_updated_by := l_cdt_rec.last_updated_by;
Line: 2433

      IF (x_cdt_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cdt_rec.last_update_date := l_cdt_rec.last_update_date;
Line: 2659

    UPDATE  OKS_K_DEFAULTS
    SET CDT_TYPE = l_def_cdt_rec.cdt_type,
        OBJECT_VERSION_NUMBER = l_def_cdt_rec.object_version_number,
        CREATED_BY = l_def_cdt_rec.created_by,
        CREATION_DATE = l_def_cdt_rec.creation_date,
        LAST_UPDATED_BY = l_def_cdt_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cdt_rec.last_update_date,
        SEGMENT_ID1 = l_def_cdt_rec.segment_id1,
        SEGMENT_ID2 = l_def_cdt_rec.segment_id2,
        JTOT_OBJECT_CODE = l_def_cdt_rec.jtot_object_code,
        PDF_ID = l_def_cdt_rec.pdf_id,
        QCL_ID = l_def_cdt_rec.qcl_id,
        CGP_NEW_ID = l_def_cdt_rec.cgp_new_id,
        CGP_RENEW_ID = l_def_cdt_rec.cgp_renew_id,
        PRICE_LIST_ID1 = l_def_cdt_rec.price_list_id1,
        PRICE_LIST_ID2 = l_def_cdt_rec.price_list_id2,
        RENEWAL_TYPE = l_def_cdt_rec.renewal_type,
        PO_REQUIRED_YN = l_def_cdt_rec.po_required_yn,
        RENEWAL_PRICING_TYPE = l_def_cdt_rec.renewal_pricing_type,
        MARKUP_PERCENT = l_def_cdt_rec.markup_percent,
        RLE_CODE= l_def_cdt_rec.rle_code,
        START_DATE = l_def_cdt_rec.start_date,
        END_DATE = l_def_cdt_rec.end_date,
        --SECURITY_GROUP_ID = l_def_cdt_rec.security_group_id,
        REVENUE_ESTIMATED_PERCENT = l_def_cdt_rec.revenue_estimated_percent,
        REVENUE_ESTIMATED_DURATION = l_def_cdt_rec.revenue_estimated_duration,
        REVENUE_ESTIMATED_PERIOD = l_def_cdt_rec.revenue_estimated_period,
        TEMPLATE_SET_ID = l_def_cdt_rec.template_set_id,
        THRESHOLD_CURRENCY = l_def_cdt_rec.THRESHOLD_CURRENCY,
        THRESHOLD_AMOUNT = l_def_cdt_rec.THRESHOLD_AMOUNT,
        EMAIL_ADDRESS = l_def_cdt_rec.EMAIL_ADDRESS,
        BILLING_PROFILE_ID = l_def_cdt_rec.BILLING_PROFILE_ID,
        USER_ID = l_def_cdt_rec.USER_ID,
        THRESHOLD_ENABLED_YN = l_def_cdt_rec.THRESHOLD_ENABLED_YN,
        GRACE_PERIOD = l_def_cdt_rec.GRACE_PERIOD,
        GRACE_DURATION = l_def_cdt_rec.GRACE_DURATION,
        PAYMENT_TERMS_ID1 = l_def_cdt_rec.PAYMENT_TERMS_ID1,
        PAYMENT_TERMS_ID2 = l_def_cdt_rec.PAYMENT_TERMS_ID2,
        EVERGREEN_THRESHOLD_CURR = l_def_cdt_rec.EVERGREEN_THRESHOLD_CURR,
        EVERGREEN_THRESHOLD_AMT = l_def_cdt_rec.EVERGREEN_THRESHOLD_AMT,
        PAYMENT_METHOD = l_def_cdt_rec.PAYMENT_METHOD,
        PAYMENT_THRESHOLD_CURR = l_def_cdt_rec.PAYMENT_THRESHOLD_CURR,
        PAYMENT_THRESHOLD_AMT = l_def_cdt_rec.PAYMENT_THRESHOLD_AMT,
        INTERFACE_PRICE_BREAK = l_def_cdt_rec.INTERFACE_PRICE_BREAK,
        CREDIT_AMOUNT = l_def_cdt_rec.CREDIT_AMOUNT,
-- R12 Data Model Changes 4485150 Start
        BASE_CURRENCY = l_def_cdt_rec.BASE_CURRENCY,
        APPROVAL_TYPE = l_def_cdt_rec.APPROVAL_TYPE,
        EVERGREEN_APPROVAL_TYPE	= l_def_cdt_rec.EVERGREEN_APPROVAL_TYPE,
        ONLINE_APPROVAL_TYPE	= l_def_cdt_rec.ONLINE_APPROVAL_TYPE,
        PURCHASE_ORDER_FLAG	= l_def_cdt_rec.PURCHASE_ORDER_FLAG,
        CREDIT_CARD_FLAG	= l_def_cdt_rec.CREDIT_CARD_FLAG,
        WIRE_FLAG	= l_def_cdt_rec.WIRE_FLAG,
        COMMITMENT_NUMBER_FLAG	= l_def_cdt_rec.COMMITMENT_NUMBER_FLAG,
        CHECK_FLAG	= l_def_cdt_rec.CHECK_FLAG,
        PERIOD_TYPE	= l_def_cdt_rec.PERIOD_TYPE,
        PERIOD_START	= l_def_cdt_rec.PERIOD_START,
        PRICE_UOM	= l_def_cdt_rec.PRICE_UOM,
        TEMPLATE_LANGUAGE	= l_def_cdt_rec.TEMPLATE_LANGUAGE
-- R12 Data Model Changes 4485150 End
    WHERE ID = l_def_cdt_rec.id;
Line: 2754

  END update_row;
Line: 2758

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_rec                     IN cdtv_rec_type,
    x_cdtv_rec                     OUT NOCOPY cdtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2768

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2782

      l_cdtv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2783

      l_cdtv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2823

      IF (x_cdtv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cdtv_rec.last_updated_by := l_cdtv_rec.last_updated_by;
Line: 2827

      IF (x_cdtv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cdtv_rec.last_update_date := l_cdtv_rec.last_update_date;
Line: 3071

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cdt_rec,
      lx_cdt_rec
    );
Line: 3118

  END update_row;
Line: 3122

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_tbl                     IN cdtv_tbl_type,
    x_cdtv_tbl                     OUT NOCOPY cdtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3132

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 3141

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cdtv_rec                     => p_cdtv_tbl(i),
          x_cdtv_rec                     => x_cdtv_tbl(i));
Line: 3184

  END update_row;
Line: 3192

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdt_rec                      IN cdt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3200

    l_api_name                     CONSTANT VARCHAR2(30) := 'DEFAULTS_delete_row';
Line: 3214

    DELETE FROM OKS_K_DEFAULTS
     WHERE ID = l_cdt_rec.id;
Line: 3249

  END delete_row;
Line: 3253

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_rec                     IN cdtv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3262

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 3286

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cdt_rec
    );
Line: 3330

  END delete_row;
Line: 3334

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cdtv_tbl                     IN cdtv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3343

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 3352

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_cdtv_rec                     => p_cdtv_tbl(i));
Line: 3394

  END delete_row;