DBA Data[Home] [Help]

APPS.OKL_SIT_PVT dependencies on OKL_SIF_STREAM_TYPES_V

Line 90: -- FUNCTION get_rec for: OKL_SIF_STREAM_TYPES_V

86: BEGIN
87: RETURN(get_rec(p_sit_rec, l_row_notfound));
88: END get_rec;
89: ---------------------------------------------------------------------------
90: -- FUNCTION get_rec for: OKL_SIF_STREAM_TYPES_V
91: ---------------------------------------------------------------------------
92: FUNCTION get_rec (
93: p_sitv_rec IN sitv_rec_type,
94: x_no_data_found OUT NOCOPY BOOLEAN

Line 110: FROM Okl_Sif_Stream_Types_V

106: CREATION_DATE,
107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Sif_Stream_Types_V
111: WHERE okl_sif_stream_types_v.id = p_id;
112: l_sitv_pk sitv_pk_csr%ROWTYPE;
113: l_sitv_rec sitv_rec_type;
114: BEGIN

Line 111: WHERE okl_sif_stream_types_v.id = p_id;

107: LAST_UPDATED_BY,
108: LAST_UPDATE_DATE,
109: LAST_UPDATE_LOGIN
110: FROM Okl_Sif_Stream_Types_V
111: WHERE okl_sif_stream_types_v.id = p_id;
112: l_sitv_pk sitv_pk_csr%ROWTYPE;
113: l_sitv_rec sitv_rec_type;
114: BEGIN
115: x_no_data_found := TRUE;

Line 145: -- FUNCTION null_out_defaults for: OKL_SIF_STREAM_TYPES_V --

141: RETURN(get_rec(p_sitv_rec, l_row_notfound));
142: END get_rec;
143:
144: ------------------------------------------------------------
145: -- FUNCTION null_out_defaults for: OKL_SIF_STREAM_TYPES_V --
146: ------------------------------------------------------------
147: FUNCTION null_out_defaults (
148: p_sitv_rec IN sitv_rec_type
149: ) RETURN sitv_rec_type IS

Line 195: -- Validate_Attributes for:OKL_SIF_STREAM_TYPES_V --

191: ---------------------------------------------------------------------------
192: -- PROCEDURE Validate_Attributes
193: ---------------------------------------------------------------------------
194: ----------------------------------------------------
195: -- Validate_Attributes for:OKL_SIF_STREAM_TYPES_V --
196: ----------------------------------------------------
197: FUNCTION Validate_Attributes (
198: p_sitv_rec IN sitv_rec_type
199: ) RETURN VARCHAR2 IS

Line 430: CURSOR okl_styv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.sty_id%TYPE) IS

426: l_dummy VARCHAR2(1) := '?';
427: l_row_not_found BOOLEAN := FALSE;
428:
429: -- Cursor For OKL_SIt_STY_FK;
430: CURSOR okl_styv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.sty_id%TYPE) IS
431: SELECT '1'
432: FROM OKL_STRM_TYPE_V
433: WHERE OKL_STRM_TYPE_V.id = p_id;
434:

Line 504: CURSOR okl_silv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.Sil_id%TYPE) IS

500: l_dummy VARCHAR2(1) := '?';
501: l_row_not_found BOOLEAN := FALSE;
502:
503: -- Cursor For OKL_SIT_SIL_FK;
504: CURSOR okl_silv_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.Sil_id%TYPE) IS
505: SELECT '1'
506: FROM OKL_SIF_LINES_V
507: WHERE OKL_SIF_LINES_V.id = p_id;
508:

Line 572: CURSOR okl_sfev_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.sfe_id%TYPE) IS

568: l_dummy VARCHAR2(1) := '?';
569: l_row_not_found BOOLEAN := FALSE;
570:
571: -- Cursor For OKL_SIT_Sfe_FK;
572: CURSOR okl_sfev_pk_csr (p_id IN OKL_SIF_STREAM_TYPES_V.sfe_id%TYPE) IS
573: SELECT '1'
574: FROM OKL_SIF_FEES_V
575: WHERE OKL_SIF_FEES_V.id = p_id;
576:

Line 745: -- Validate_Record for:OKL_SIF_STREAM_TYPES_V --

741: ---------------------------------------------------------------------------
742: -- PROCEDURE Validate_Record
743: ---------------------------------------------------------------------------
744: ------------------------------------------------
745: -- Validate_Record for:OKL_SIF_STREAM_TYPES_V --
746: ------------------------------------------------
747: FUNCTION Validate_Record (
748: p_sitv_rec IN sitv_rec_type
749: ) RETURN VARCHAR2 IS

Line 801: -- validate_row for:OKL_SIF_STREAM_TYPES_V --

797: ---------------------------------------------------------------------------
798: -- PROCEDURE validate_row
799: ---------------------------------------------------------------------------
800: ---------------------------------------------
801: -- validate_row for:OKL_SIF_STREAM_TYPES_V --
802: ---------------------------------------------
803: PROCEDURE validate_row(
804: p_api_version IN NUMBER,
805: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1070: -- insert_row for:OKL_SIF_STREAM_TYPES_V --

1066: '_PVT'
1067: );
1068: END insert_row;
1069: -------------------------------------------
1070: -- insert_row for:OKL_SIF_STREAM_TYPES_V --
1071: -------------------------------------------
1072: PROCEDURE insert_row(
1073: p_api_version IN NUMBER,
1074: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1104: -- Set_Attributes for:OKL_SIF_STREAM_TYPES_V --

1100: l_sitv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1101: RETURN(l_sitv_rec);
1102: END fill_who_columns;
1103: -----------------------------------------------
1104: -- Set_Attributes for:OKL_SIF_STREAM_TYPES_V --
1105: -----------------------------------------------
1106: FUNCTION Set_Attributes (
1107: p_sitv_rec IN sitv_rec_type,
1108: x_sitv_rec OUT NOCOPY sitv_rec_type

Line 1406: -- lock_row for:OKL_SIF_STREAM_TYPES_V --

1402: '_PVT'
1403: );
1404: END lock_row;
1405: -----------------------------------------
1406: -- lock_row for:OKL_SIF_STREAM_TYPES_V --
1407: -----------------------------------------
1408: PROCEDURE lock_row(
1409: p_api_version IN NUMBER,
1410: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1740: -- update_row for:OKL_SIF_STREAM_TYPES_V --

1736: '_PVT'
1737: );
1738: END update_row;
1739: -------------------------------------------
1740: -- update_row for:OKL_SIF_STREAM_TYPES_V --
1741: -------------------------------------------
1742: PROCEDURE update_row(
1743: p_api_version IN NUMBER,
1744: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1839: -- Set_Attributes for:OKL_SIF_STREAM_TYPES_V --

1835: END IF;
1836: RETURN(l_return_status);
1837: END populate_new_record;
1838: -----------------------------------------------
1839: -- Set_Attributes for:OKL_SIF_STREAM_TYPES_V --
1840: -----------------------------------------------
1841: FUNCTION Set_Attributes (
1842: p_sitv_rec IN sitv_rec_type,
1843: x_sitv_rec OUT NOCOPY sitv_rec_type

Line 2099: -- delete_row for:OKL_SIF_STREAM_TYPES_V --

2095: '_PVT'
2096: );
2097: END delete_row;
2098: -------------------------------------------
2099: -- delete_row for:OKL_SIF_STREAM_TYPES_V --
2100: -------------------------------------------
2101: PROCEDURE delete_row(
2102: p_api_version IN NUMBER,
2103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,