APPS.OKC_SPLIT1_PAV_PVT dependencies on OKC_PRICE_ATT_VALUES

Line 4: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES

1: PACKAGE BODY OKC_SPLIT1_PAV_PVT AS
2: /* $Header: OKCSPAVSPOB.pls 120.0 2010/06/22 10:09:31 nvvaidya noship $ */
3: ---------------------------------------------------------------------------
4: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES
5: ---------------------------------------------------------------------------
6: FUNCTION get_rec (
7: p_pav_rec IN OKC_PAV_PVT.pav_rec_type,
8: x_no_data_found OUT NOCOPY BOOLEAN

Line 228: FROM Okc_Price_Att_Values

224: PROGRAM_ID,
225: PROGRAM_UPDATE_DATE,
226: REQUEST_ID,
227: OBJECT_VERSION_NUMBER
228: FROM Okc_Price_Att_Values
229: WHERE okc_price_att_values.id = p_id;
230: l_pav_pk pav_pk_csr%ROWTYPE;
231: l_pav_rec OKC_PAV_PVT.pav_rec_type;
232: BEGIN

Line 229: WHERE okc_price_att_values.id = p_id;

225: PROGRAM_UPDATE_DATE,
226: REQUEST_ID,
227: OBJECT_VERSION_NUMBER
228: FROM Okc_Price_Att_Values
229: WHERE okc_price_att_values.id = p_id;
230: l_pav_pk pav_pk_csr%ROWTYPE;
231: l_pav_rec OKC_PAV_PVT.pav_rec_type;
232: BEGIN
233: x_no_data_found := TRUE;

Line 458: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES_V

454: CLOSE pav_pk_csr;
455: RETURN(l_pav_rec);
456: END get_rec;
457: ---------------------------------------------------------------------------
458: -- FUNCTION get_rec for: OKC_PRICE_ATT_VALUES_V
459: ---------------------------------------------------------------------------
460: FUNCTION get_rec (
461: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
462: x_no_data_found OUT NOCOPY BOOLEAN

Line 682: FROM Okc_Price_Att_Values_V

678: PROGRAM_ID,
679: PROGRAM_UPDATE_DATE,
680: REQUEST_ID,
681: OBJECT_VERSION_NUMBER
682: FROM Okc_Price_Att_Values_V
683: WHERE okc_price_att_values_v.id = p_id;
684: l_okc_pavv_pk okc_pavv_pk_csr%ROWTYPE;
685: l_pavv_rec OKC_PAV_PVT.pavv_rec_type;
686: BEGIN

Line 683: WHERE okc_price_att_values_v.id = p_id;

679: PROGRAM_UPDATE_DATE,
680: REQUEST_ID,
681: OBJECT_VERSION_NUMBER
682: FROM Okc_Price_Att_Values_V
683: WHERE okc_price_att_values_v.id = p_id;
684: l_okc_pavv_pk okc_pavv_pk_csr%ROWTYPE;
685: l_pavv_rec OKC_PAV_PVT.pavv_rec_type;
686: BEGIN
687: x_no_data_found := TRUE;

Line 913: -- FUNCTION null_out_defaults for: OKC_PRICE_ATT_VALUES_V --

909: RETURN(l_pavv_rec);
910: END get_rec;
911:
912: ------------------------------------------------------------
913: -- FUNCTION null_out_defaults for: OKC_PRICE_ATT_VALUES_V --
914: ------------------------------------------------------------
915: FUNCTION null_out_defaults (
916: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type
917: ) RETURN OKC_PAV_PVT.pavv_rec_type IS