DBA Data[Home] [Help]

APPS.OKL_SIY_PVT dependencies on OKL_SIF_YIELDS_V

Line 102: -- FUNCTION get_rec for: OKL_SIF_YIELDS_V

98: BEGIN
99: RETURN(get_rec(p_siy_rec, l_row_notfound));
100: END get_rec;
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKL_SIF_YIELDS_V
103: ---------------------------------------------------------------------------
104: FUNCTION get_rec (
105: p_siyv_rec IN siyv_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN

Line 128: FROM Okl_Sif_Yields_V

124: LAST_UPDATED_BY,
125: CREATION_DATE,
126: LAST_UPDATE_DATE,
127: LAST_UPDATE_LOGIN
128: FROM Okl_Sif_Yields_V
129: WHERE okl_sif_yields_v.id = p_id;
130: l_siyv_pk siyv_pk_csr%ROWTYPE;
131: l_siyv_rec siyv_rec_type;
132: BEGIN

Line 129: WHERE okl_sif_yields_v.id = p_id;

125: CREATION_DATE,
126: LAST_UPDATE_DATE,
127: LAST_UPDATE_LOGIN
128: FROM Okl_Sif_Yields_V
129: WHERE okl_sif_yields_v.id = p_id;
130: l_siyv_pk siyv_pk_csr%ROWTYPE;
131: l_siyv_rec siyv_rec_type;
132: BEGIN
133: x_no_data_found := TRUE;

Line 169: -- FUNCTION null_out_defaults for: OKL_SIF_YIELDS_V --

165: RETURN(get_rec(p_siyv_rec, l_row_notfound));
166: END get_rec;
167:
168: ------------------------------------------------------
169: -- FUNCTION null_out_defaults for: OKL_SIF_YIELDS_V --
170: ------------------------------------------------------
171: FUNCTION null_out_defaults (
172: p_siyv_rec IN siyv_rec_type
173: ) RETURN siyv_rec_type IS

Line 284: -- Validate_Attributes for:OKL_SIF_YIELDS_V --

280: ---------------------------------------------------------------------------
281: -- PROCEDURE Validate_Attributes
282: ---------------------------------------------------------------------------
283: ----------------------------------------------
284: -- Validate_Attributes for:OKL_SIF_YIELDS_V --
285: ----------------------------------------------
286: FUNCTION Validate_Attributes (
287: p_siyv_rec IN siyv_rec_type
288: ) RETURN VARCHAR2 IS

Line 497: CURSOR okl_sifv_pk_csr (p_id IN OKL_SIF_YIELDS_V.sif_id%TYPE) IS

493: l_dummy VARCHAR2(1) := '?';
494: l_row_not_found BOOLEAN := FALSE;
495:
496: -- Cursor For OKL_SIF_FK;
497: CURSOR okl_sifv_pk_csr (p_id IN OKL_SIF_YIELDS_V.sif_id%TYPE) IS
498: SELECT '1'
499: FROM OKL_STREAM_INTERFACES_V
500: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
501:

Line 948: -- Validate_Record for:OKL_SIF_YIELDS_V --

944: ---------------------------------------------------------------------------
945: -- PROCEDURE Validate_Record
946: ---------------------------------------------------------------------------
947: ------------------------------------------
948: -- Validate_Record for:OKL_SIF_YIELDS_V --
949: ------------------------------------------
950: FUNCTION Validate_Record (
951: p_siyv_rec IN siyv_rec_type
952: ) RETURN VARCHAR2 IS

Line 1054: -- validate_row for:OKL_SIF_YIELDS_V --

1050: ---------------------------------------------------------------------------
1051: -- PROCEDURE validate_row
1052: ---------------------------------------------------------------------------
1053: ---------------------------------------
1054: -- validate_row for:OKL_SIF_YIELDS_V --
1055: ---------------------------------------
1056: PROCEDURE validate_row(
1057: p_api_version IN NUMBER,
1058: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1367: -- insert_row for:OKL_SIF_YIELDS_V --

1363: '_PVT'
1364: );
1365: END insert_row;
1366: -------------------------------------
1367: -- insert_row for:OKL_SIF_YIELDS_V --
1368: -------------------------------------
1369: PROCEDURE insert_row(
1370: p_api_version IN NUMBER,
1371: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1401: -- Set_Attributes for:OKL_SIF_YIELDS_V --

1397: l_siyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1398: RETURN(l_siyv_rec);
1399: END fill_who_columns;
1400: -----------------------------------------
1401: -- Set_Attributes for:OKL_SIF_YIELDS_V --
1402: -----------------------------------------
1403: FUNCTION Set_Attributes (
1404: p_siyv_rec IN siyv_rec_type,
1405: x_siyv_rec OUT NOCOPY siyv_rec_type

Line 1704: -- lock_row for:OKL_SIF_YIELDS_V --

1700: '_PVT'
1701: );
1702: END lock_row;
1703: -----------------------------------
1704: -- lock_row for:OKL_SIF_YIELDS_V --
1705: -----------------------------------
1706: PROCEDURE lock_row(
1707: p_api_version IN NUMBER,
1708: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2152: -- update_row for:OKL_SIF_YIELDS_V --

2148: '_PVT'
2149: );
2150: END update_row;
2151: -------------------------------------
2152: -- update_row for:OKL_SIF_YIELDS_V --
2153: -------------------------------------
2154: PROCEDURE update_row(
2155: p_api_version IN NUMBER,
2156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2339: -- Set_Attributes for:OKL_SIF_YIELDS_V --

2335: END IF;
2336: RETURN(l_return_status);
2337: END populate_new_record;
2338: -----------------------------------------
2339: -- Set_Attributes for:OKL_SIF_YIELDS_V --
2340: -----------------------------------------
2341: FUNCTION Set_Attributes (
2342: p_siyv_rec IN siyv_rec_type,
2343: x_siyv_rec OUT NOCOPY siyv_rec_type

Line 2600: -- delete_row for:OKL_SIF_YIELDS_V --

2596: '_PVT'
2597: );
2598: END delete_row;
2599: -------------------------------------
2600: -- delete_row for:OKL_SIF_YIELDS_V --
2601: -------------------------------------
2602: PROCEDURE delete_row(
2603: p_api_version IN NUMBER,
2604: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,