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
9: ) RETURN OKC_PAV_PVT.pav_rec_type IS
10: CURSOR pav_pk_csr (p_id IN NUMBER) IS
11: SELECT
5: ---------------------------------------------------------------------------
6: FUNCTION get_rec (
7: p_pav_rec IN OKC_PAV_PVT.pav_rec_type,
8: x_no_data_found OUT NOCOPY BOOLEAN
9: ) RETURN OKC_PAV_PVT.pav_rec_type IS
10: CURSOR pav_pk_csr (p_id IN NUMBER) IS
11: SELECT
12: ID,
13: FLEX_TITLE,
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;
234: -- Get current database values
235: OPEN pav_pk_csr (p_pav_rec.id);
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
463: ) RETURN OKC_PAV_PVT.pavv_rec_type IS
464: CURSOR okc_pavv_pk_csr (p_id IN NUMBER) IS
465: SELECT
459: ---------------------------------------------------------------------------
460: FUNCTION get_rec (
461: p_pavv_rec IN OKC_PAV_PVT.pavv_rec_type,
462: x_no_data_found OUT NOCOPY BOOLEAN
463: ) RETURN OKC_PAV_PVT.pavv_rec_type IS
464: CURSOR okc_pavv_pk_csr (p_id IN NUMBER) IS
465: SELECT
466: ID,
467: CHR_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;
688: -- Get current database values
689: OPEN okc_pavv_pk_csr (p_pavv_rec.id);
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
918: l_pavv_rec OKC_PAV_PVT.pavv_rec_type := p_pavv_rec;
919: BEGIN
920: IF (l_pavv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
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
918: l_pavv_rec OKC_PAV_PVT.pavv_rec_type := p_pavv_rec;
919: BEGIN
920: IF (l_pavv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
921: l_pavv_rec.chr_id := NULL;
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
918: l_pavv_rec OKC_PAV_PVT.pavv_rec_type := p_pavv_rec;
919: BEGIN
920: IF (l_pavv_rec.chr_id = OKC_API.G_MISS_NUM) THEN
921: l_pavv_rec.chr_id := NULL;
922: END IF;