DBA Data[Home] [Help]

APPS.OKL_STM_PVT dependencies on OKL_STREAMS_V

Line 132: -- FUNCTION get_rec for: OKL_STREAMS_V

128: BEGIN
129: RETURN(get_rec(p_stm_rec, l_row_notfound));
130: END get_rec;
131: ---------------------------------------------------------------------------
132: -- FUNCTION get_rec for: OKL_STREAMS_V
133: ---------------------------------------------------------------------------
134: FUNCTION get_rec (
135: p_stmv_rec IN stmv_rec_type,
136: x_no_data_found OUT NOCOPY BOOLEAN

Line 173: FROM Okl_Streams_V

169: SOURCE_TABLE,
170: -- Added by rgooty: 4212626
171: TRX_ID,
172: LINK_HIST_STREAM_ID
173: FROM Okl_Streams_V
174: WHERE okl_streams_v.id = p_id;
175: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
176: l_stmv_rec stmv_rec_type;
177: BEGIN

Line 174: WHERE okl_streams_v.id = p_id;

170: -- Added by rgooty: 4212626
171: TRX_ID,
172: LINK_HIST_STREAM_ID
173: FROM Okl_Streams_V
174: WHERE okl_streams_v.id = p_id;
175: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
176: l_stmv_rec stmv_rec_type;
177: BEGIN
178: x_no_data_found := TRUE;

Line 229: -- FUNCTION null_out_defaults for: OKL_STREAMS_V --

225: RETURN(get_rec(p_stmv_rec, l_row_notfound));
226: END get_rec;
227:
228: ---------------------------------------------------
229: -- FUNCTION null_out_defaults for: OKL_STREAMS_V --
230: ---------------------------------------------------
231: FUNCTION null_out_defaults (
232: p_stmv_rec IN stmv_rec_type
233: ) RETURN stmv_rec_type IS

Line 338: -- Validate_Attributes for:OKL_STREAMS_V --

334: ---------------------------------------------------------------------------
335: -- PROCEDURE Validate_Attributes
336: ---------------------------------------------------------------------------
337: -------------------------------------------
338: -- Validate_Attributes for:OKL_STREAMS_V --
339: -------------------------------------------
340: FUNCTION Validate_Attributes (
341: p_stmv_rec IN stmv_rec_type
342: ) RETURN VARCHAR2 IS

Line 383: -- Validate_Record for:OKL_STREAMS_V --

379: ---------------------------------------------------------------------------
380: -- PROCEDURE Validate_Record
381: ---------------------------------------------------------------------------
382: ---------------------------------------
383: -- Validate_Record for:OKL_STREAMS_V --
384: ---------------------------------------
385: FUNCTION Validate_Record (
386: p_stmv_rec IN stmv_rec_type
387: ) RETURN VARCHAR2 IS

Line 1378: FROM okl_streams_v

1374:
1375: -- Cursor for stm Unique Key
1376: CURSOR okl_stm_uk_csr(p_rec stmv_rec_type) IS
1377: SELECT '1'
1378: FROM okl_streams_v
1379: WHERE sty_id = p_rec.sty_id
1380: AND khr_id = p_rec.khr_id
1381: AND kle_id = p_rec.kle_id
1382: AND transaction_number = p_rec.transaction_number

Line 1557: -- validate_row for:OKL_STREAMS_V --

1553: ---------------------------------------------------------------------------
1554: -- PROCEDURE validate_row
1555: ---------------------------------------------------------------------------
1556: ------------------------------------
1557: -- validate_row for:OKL_STREAMS_V --
1558: ------------------------------------
1559:
1560: PROCEDURE validate_row(
1561: p_api_version IN NUMBER,

Line 1888: -- insert_row for:OKL_STREAMS_V --

1884: '_PVT'
1885: );
1886: END insert_row;
1887: ----------------------------------
1888: -- insert_row for:OKL_STREAMS_V --
1889: ----------------------------------
1890: PROCEDURE insert_row(
1891: p_api_version IN NUMBER,
1892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1922: -- Set_Attributes for:OKL_STREAMS_V --

1918: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1919: RETURN(l_stmv_rec);
1920: END fill_who_columns;
1921: --------------------------------------
1922: -- Set_Attributes for:OKL_STREAMS_V --
1923: --------------------------------------
1924: FUNCTION Set_Attributes (
1925: p_stmv_rec IN stmv_rec_type,
1926: x_stmv_rec OUT NOCOPY stmv_rec_type

Line 2445: -- lock_row for:OKL_STREAMS_V --

2441: '_PVT'
2442: );
2443: END lock_row;
2444: --------------------------------
2445: -- lock_row for:OKL_STREAMS_V --
2446: --------------------------------
2447: PROCEDURE lock_row(
2448: p_api_version IN NUMBER,
2449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2915: -- update_row for:OKL_STREAMS_V --

2911: '_PVT'
2912: );
2913: END update_row;
2914: ----------------------------------
2915: -- update_row for:OKL_STREAMS_V --
2916: ----------------------------------
2917: PROCEDURE update_row(
2918: p_api_version IN NUMBER,
2919: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3125: -- Set_Attributes for:OKL_STREAMS_V --

3121: RETURN(l_return_status);
3122:
3123: END populate_new_record;
3124: --------------------------------------
3125: -- Set_Attributes for:OKL_STREAMS_V --
3126: --------------------------------------
3127: FUNCTION Set_Attributes (
3128: p_stmv_rec IN stmv_rec_type,
3129: x_stmv_rec OUT NOCOPY stmv_rec_type

Line 3423: -- delete_row for:OKL_STREAMS_V --

3419: '_PVT'
3420: );
3421: END delete_row;
3422: ----------------------------------
3423: -- delete_row for:OKL_STREAMS_V --
3424: ----------------------------------
3425: PROCEDURE delete_row(
3426: p_api_version IN NUMBER,
3427: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,