[Home] [Help]
585: p_msg_name => G_NO_PARENT_RECORD,
586: p_token1 => G_COL_NAME_TOKEN,
587: p_token1_value => 'art_id',
588: p_token2 => G_CHILD_TABLE_TOKEN,
589: p_token2_value => 'OKL_REMARKTNG_COSTS_V',
590: p_token3 => G_PARENT_TABLE_TOKEN,
591: p_token3_value => 'OKL_ASSET_RETURNS_V');
592:
593: -- notify caller of an error
639:
640: IF (p_rfcv_rec.amount IS NOT NULL)
641: AND (p_rfcv_rec.amount <> OKC_API.G_MISS_NUM) THEN
642:
643: okl_am_util_pvt.add_view ('Okl_Remarktng_Costs_V', l_return_status);
644:
645: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
646: okl_am_util_pvt.check_length (
647: 'Okl_Remarktng_Costs_V', 'Amount', p_rfcv_rec.amount, l_return_status);
643: okl_am_util_pvt.add_view ('Okl_Remarktng_Costs_V', l_return_status);
644:
645: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
646: okl_am_util_pvt.check_length (
647: 'Okl_Remarktng_Costs_V', 'Amount', p_rfcv_rec.amount, l_return_status);
648: END IF;
649:
650: x_return_status := l_return_status;
651:
939: BEGIN
940: RETURN(get_rec(p_okl_remarktng_costs_tl_rec, l_row_notfound));
941: END get_rec;
942: ---------------------------------------------------------------------------
943: -- FUNCTION get_rec for: OKL_REMARKTNG_COSTS_V
944: ---------------------------------------------------------------------------
945: -- Start of comments
946: --
947: -- Function Name : get_rec
944: ---------------------------------------------------------------------------
945: -- Start of comments
946: --
947: -- Function Name : get_rec
948: -- Description : for: OKL_REMARKTNG_COSTS_V
949: -- Business Rules :
950: -- Parameters :
951: -- Version : 1.0
952: -- History : RABHUPAT 17-DEC-2002 2667636
997: CURRENCY_CONVERSION_TYPE,
998: CURRENCY_CONVERSION_RATE,
999: CURRENCY_CONVERSION_DATE
1000: -- RABHUPAT - 2667636 - End
1001: FROM Okl_Remarktng_Costs_V
1002: WHERE okl_remarktng_costs_v.id = p_id;
1003: l_okl_rfcv_pk okl_rfcv_pk_csr%ROWTYPE;
1004: l_rfcv_rec rfcv_rec_type;
1005: BEGIN
998: CURRENCY_CONVERSION_RATE,
999: CURRENCY_CONVERSION_DATE
1000: -- RABHUPAT - 2667636 - End
1001: FROM Okl_Remarktng_Costs_V
1002: WHERE okl_remarktng_costs_v.id = p_id;
1003: l_okl_rfcv_pk okl_rfcv_pk_csr%ROWTYPE;
1004: l_rfcv_rec rfcv_rec_type;
1005: BEGIN
1006: x_no_data_found := TRUE;
1060: RETURN(get_rec(p_rfcv_rec, l_row_notfound));
1061: END get_rec;
1062:
1063: -----------------------------------------------------------
1064: -- FUNCTION null_out_defaults for: OKL_REMARKTNG_COSTS_V --
1065: -----------------------------------------------------------
1066: -- Start of comments
1067: --
1068: -- Function Name : null_out_defaults
1065: -----------------------------------------------------------
1066: -- Start of comments
1067: --
1068: -- Function Name : null_out_defaults
1069: -- Description : for: OKL_REMARKTNG_COSTS_V
1070: -- Business Rules :
1071: -- Parameters :
1072: -- Version : 1.0
1073: -- History : RABHUPAT 17-DEC-2002 2667636
1200: ---------------------------------------------------------------------------
1201: -- PROCEDURE Validate_Attributes
1202: ---------------------------------------------------------------------------
1203: ---------------------------------------------------
1204: -- Validate_Attributes for:OKL_REMARKTNG_COSTS_V --
1205: ---------------------------------------------------
1206: -- Start of comments
1207: --
1208: -- Procedure Name : validate_attributes
1205: ---------------------------------------------------
1206: -- Start of comments
1207: --
1208: -- Procedure Name : validate_attributes
1209: -- Description : for:OKL_REMARKTNG_COSTS_V
1210: -- Business Rules :
1211: -- Parameters :
1212: -- Version : 1.0
1213: -- History : Modified by : Guru Kadarkaraisamy
1328: ---------------------------------------------------------------------------
1329: -- PROCEDURE Validate_Record
1330: ---------------------------------------------------------------------------
1331: -----------------------------------------------
1332: -- Validate_Record for:OKL_REMARKTNG_COSTS_V --
1333: -----------------------------------------------
1334: -- Start of comments
1335: --
1336: -- Function Name : Validate_Record
1333: -----------------------------------------------
1334: -- Start of comments
1335: --
1336: -- Function Name : Validate_Record
1337: -- Description : for:OKL_REMARKTNG_COSTS_V
1338: -- Business Rules :
1339: -- Parameters :
1340: -- Version : 1.0
1341: -- History : RABHUPAT 17-DEC-2002 2667636
1506: ---------------------------------------------------------------------------
1507: -- PROCEDURE validate_row
1508: ---------------------------------------------------------------------------
1509: --------------------------------------------
1510: -- validate_row for:OKL_REMARKTNG_COSTS_V --
1511: --------------------------------------------
1512: PROCEDURE validate_row(
1513: p_api_version IN NUMBER,
1514: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1958: '_PVT'
1959: );
1960: END insert_row;
1961: ------------------------------------------
1962: -- insert_row for:OKL_REMARKTNG_COSTS_V --
1963: ------------------------------------------
1964: -- Start of comments
1965: --
1966: -- Procedure Name : insert_row
1963: ------------------------------------------
1964: -- Start of comments
1965: --
1966: -- Procedure Name : insert_row
1967: -- Description : for OKL_REMARKTNG_COSTS_V
1968: -- Business Rules :
1969: -- Parameters :
1970: -- Version : 1.0
1971: -- History : RABHUPAT 17-DEC-2002 2667636
2004: l_rfcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2005: RETURN(l_rfcv_rec);
2006: END fill_who_columns;
2007: ----------------------------------------------
2008: -- Set_Attributes for:OKL_REMARKTNG_COSTS_V --
2009: ----------------------------------------------
2010: FUNCTION Set_Attributes (
2011: p_rfcv_rec IN rfcv_rec_type,
2012: x_rfcv_rec OUT NOCOPY rfcv_rec_type
2453: '_PVT'
2454: );
2455: END lock_row;
2456: ----------------------------------------
2457: -- lock_row for:OKL_REMARKTNG_COSTS_V --
2458: ----------------------------------------
2459: PROCEDURE lock_row(
2460: p_api_version IN NUMBER,
2461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3121: '_PVT'
3122: );
3123: END update_row;
3124: ------------------------------------------
3125: -- update_row for:OKL_REMARKTNG_COSTS_V --
3126: ------------------------------------------
3127: -- Start of comments
3128: --
3129: -- Procedure Name : update_row
3126: ------------------------------------------
3127: -- Start of comments
3128: --
3129: -- Procedure Name : update_row
3130: -- Description : for OKL_REMARKTNG_COSTS_V
3131: -- Business Rules :
3132: -- Parameters :
3133: -- Version : 1.0
3134: -- History : RABHUPAT 17-DEC-2002 2667636
3338: -- RABHUPAT - 2667636 - End
3339: RETURN(l_return_status);
3340: END populate_new_record;
3341: ----------------------------------------------
3342: -- Set_Attributes for:OKL_REMARKTNG_COSTS_V --
3343: ----------------------------------------------
3344: FUNCTION Set_Attributes (
3345: p_rfcv_rec IN rfcv_rec_type,
3346: x_rfcv_rec OUT NOCOPY rfcv_rec_type
3711: '_PVT'
3712: );
3713: END delete_row;
3714: ------------------------------------------
3715: -- delete_row for:OKL_REMARKTNG_COSTS_V --
3716: ------------------------------------------
3717: PROCEDURE delete_row(
3718: p_api_version IN NUMBER,
3719: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,