DBA Data[Home] [Help]

APPS.OKC_PAV_PVT dependencies on OKC_PRICE_ATT_VALUES_V

Line 500: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES_V

496: BEGIN
497: RETURN(get_rec(p_pav_rec, l_row_notfound));
498: END get_rec;
499: ---------------------------------------------------------------------------
500: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES_V
501: ---------------------------------------------------------------------------
502: FUNCTION get_rec (
503: p_pavv_rec IN pavv_rec_type,
504: x_no_data_found OUT NOCOPY BOOLEAN

Line 724: FROM Okc_Price_Att_Values_V

720: PROGRAM_ID,
721: PROGRAM_UPDATE_DATE,
722: REQUEST_ID,
723: OBJECT_VERSION_NUMBER
724: FROM Okc_Price_Att_Values_V
725: WHERE okc_price_att_values_v.id = p_id;
726: l_okc_pavv_pk okc_pavv_pk_csr%ROWTYPE;
727: l_pavv_rec pavv_rec_type;
728: BEGIN

Line 725: WHERE okc_price_att_values_v.id = p_id;

721: PROGRAM_UPDATE_DATE,
722: REQUEST_ID,
723: OBJECT_VERSION_NUMBER
724: FROM Okc_Price_Att_Values_V
725: WHERE okc_price_att_values_v.id = p_id;
726: l_okc_pavv_pk okc_pavv_pk_csr%ROWTYPE;
727: l_pavv_rec pavv_rec_type;
728: BEGIN
729: x_no_data_found := TRUE;

Line 963: -- FUNCTION null_out_defaults for: OKC_PRICE_ATT_VALUES_V --

959: RETURN(get_rec(p_pavv_rec, l_row_notfound));
960: END get_rec;
961:
962: ------------------------------------------------------------
963: -- FUNCTION null_out_defaults for: OKC_PRICE_ATT_VALUES_V --
964: ------------------------------------------------------------
965: FUNCTION null_out_defaults (
966: p_pavv_rec IN pavv_rec_type
967: ) RETURN pavv_rec_type IS

Line 1649: -- Validate_Attributes for:OKC_PRICE_ATT_VALUES_V --

1645: ---------------------------------------------------------------------------
1646: -- PROCEDURE Validate_Attributes
1647: ---------------------------------------------------------------------------
1648: ----------------------------------------------------
1649: -- Validate_Attributes for:OKC_PRICE_ATT_VALUES_V --
1650: ----------------------------------------------------
1651: FUNCTION Validate_Attributes (
1652: p_pavv_rec IN pavv_rec_type
1653: ) RETURN VARCHAR2 IS

Line 1660: OKC_UTIL.ADD_VIEW('OKC_PRICE_ATT_VALUES_V', l_return_status);

1656: BEGIN
1657: ---------------------------------------------------------------------------------------
1658: --Attribute Level Validation Procedure Calls Starts(Modification on TAPI generated Code.)--
1659: ---------------------------------------------------------------------------------------
1660: OKC_UTIL.ADD_VIEW('OKC_PRICE_ATT_VALUES_V', l_return_status);
1661: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1662: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
1663: x_return_status := l_return_status;
1664: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1700: -- Validate_Record for:OKC_PRICE_ATT_VALUES_V --

1696: ---------------------------------------------------------------------------
1697: -- PROCEDURE Validate_Record
1698: ---------------------------------------------------------------------------
1699: ------------------------------------------------
1700: -- Validate_Record for:OKC_PRICE_ATT_VALUES_V --
1701: ------------------------------------------------
1702: FUNCTION Validate_Record (
1703: p_pavv_rec IN pavv_rec_type
1704: ) RETURN VARCHAR2 IS

Line 2213: -- validate_row for:OKC_PRICE_ATT_VALUES_V --

2209: ---------------------------------------------------------------------------
2210: -- PROCEDURE validate_row
2211: ---------------------------------------------------------------------------
2212: ---------------------------------------------
2213: -- validate_row for:OKC_PRICE_ATT_VALUES_V --
2214: ---------------------------------------------
2215: PROCEDURE validate_row(
2216: p_api_version IN NUMBER,
2217: p_init_msg_list IN VARCHAR2 ,

Line 2874: -- insert_row for:OKC_PRICE_ATT_VALUES_V --

2870: '_PVT'
2871: );
2872: END insert_row;
2873: -------------------------------------------
2874: -- insert_row for:OKC_PRICE_ATT_VALUES_V --
2875: -------------------------------------------
2876: PROCEDURE insert_row(
2877: p_api_version IN NUMBER,
2878: p_init_msg_list IN VARCHAR2 ,

Line 2908: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --

2904: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2905: RETURN(l_pavv_rec);
2906: END fill_who_columns;
2907: -----------------------------------------------
2908: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --
2909: -----------------------------------------------
2910: FUNCTION Set_Attributes (
2911: p_pavv_rec IN pavv_rec_type,
2912: x_pavv_rec OUT NOCOPY pavv_rec_type

Line 3196: -- lock_row for:OKC_PRICE_ATT_VALUES_V --

3192: '_PVT'
3193: );
3194: END lock_row;
3195: -----------------------------------------
3196: -- lock_row for:OKC_PRICE_ATT_VALUES_V --
3197: -----------------------------------------
3198: PROCEDURE lock_row(
3199: p_api_version IN NUMBER,
3200: p_init_msg_list IN VARCHAR2 ,

Line 4534: -- update_row for:OKC_PRICE_ATT_VALUES_V --

4530: '_PVT'
4531: );
4532: END update_row;
4533: -------------------------------------------
4534: -- update_row for:OKC_PRICE_ATT_VALUES_V --
4535: -------------------------------------------
4536: PROCEDURE update_row(
4537: p_api_version IN NUMBER,
4538: p_init_msg_list IN VARCHAR2 ,

Line 5449: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --

5445: END IF;
5446: RETURN(l_return_status);
5447: END populate_new_record;
5448: -----------------------------------------------
5449: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --
5450: -----------------------------------------------
5451: FUNCTION Set_Attributes (
5452: p_pavv_rec IN pavv_rec_type,
5453: x_pavv_rec OUT NOCOPY pavv_rec_type

Line 5693: -- delete_row for:OKC_PRICE_ATT_VALUES_V --

5689: '_PVT'
5690: );
5691: END delete_row;
5692: -------------------------------------------
5693: -- delete_row for:OKC_PRICE_ATT_VALUES_V --
5694: -------------------------------------------
5695: PROCEDURE delete_row(
5696: p_api_version IN NUMBER,
5697: p_init_msg_list IN VARCHAR2 ,