eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STM_PVT dependencies on OKL_STREAMS

Line 36: -- FUNCTION get_rec for: OKL_STREAMS

32: NULL;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_STREAMS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_stm_rec IN stm_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_streams_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_stm_rec IN stm_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN stm_rec_type IS
42: CURSOR okl_streams_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: STY_ID,
46: KHR_ID,

Line 77: FROM Okl_Streams

73: SOURCE_TABLE,
74: -- Added by rgooty: 4212626
75: TRX_ID,
76: LINK_HIST_STREAM_ID
77: FROM Okl_Streams
78: WHERE okl_streams.id = p_id;
79: l_okl_streams_pk okl_streams_pk_csr%ROWTYPE;
80: l_stm_rec stm_rec_type;
81: BEGIN

Line 78: WHERE okl_streams.id = p_id;

74: -- Added by rgooty: 4212626
75: TRX_ID,
76: LINK_HIST_STREAM_ID
77: FROM Okl_Streams
78: WHERE okl_streams.id = p_id;
79: l_okl_streams_pk okl_streams_pk_csr%ROWTYPE;
80: l_stm_rec stm_rec_type;
81: BEGIN
82: x_no_data_found := TRUE;

Line 79: l_okl_streams_pk okl_streams_pk_csr%ROWTYPE;

75: TRX_ID,
76: LINK_HIST_STREAM_ID
77: FROM Okl_Streams
78: WHERE okl_streams.id = p_id;
79: l_okl_streams_pk okl_streams_pk_csr%ROWTYPE;
80: l_stm_rec stm_rec_type;
81: BEGIN
82: x_no_data_found := TRUE;
83: -- Get current database values

Line 84: OPEN okl_streams_pk_csr (p_stm_rec.id);

80: l_stm_rec stm_rec_type;
81: BEGIN
82: x_no_data_found := TRUE;
83: -- Get current database values
84: OPEN okl_streams_pk_csr (p_stm_rec.id);
85: FETCH okl_streams_pk_csr INTO
86: l_stm_rec.ID,
87: l_stm_rec.STY_ID,
88: l_stm_rec.KHR_ID,

Line 85: FETCH okl_streams_pk_csr INTO

81: BEGIN
82: x_no_data_found := TRUE;
83: -- Get current database values
84: OPEN okl_streams_pk_csr (p_stm_rec.id);
85: FETCH okl_streams_pk_csr INTO
86: l_stm_rec.ID,
87: l_stm_rec.STY_ID,
88: l_stm_rec.KHR_ID,
89: l_stm_rec.KLE_ID,

Line 119: x_no_data_found := okl_streams_pk_csr%NOTFOUND;

115: l_stm_rec.SOURCE_TABLE,
116: -- Added by rgooty: 4212626
117: l_stm_rec.TRX_ID,
118: l_stm_rec.LINK_HIST_STREAM_ID;
119: x_no_data_found := okl_streams_pk_csr%NOTFOUND;
120: CLOSE okl_streams_pk_csr;
121: RETURN(l_stm_rec);
122: END get_rec;
123:

Line 120: CLOSE okl_streams_pk_csr;

116: -- Added by rgooty: 4212626
117: l_stm_rec.TRX_ID,
118: l_stm_rec.LINK_HIST_STREAM_ID;
119: x_no_data_found := okl_streams_pk_csr%NOTFOUND;
120: CLOSE okl_streams_pk_csr;
121: RETURN(l_stm_rec);
122: END get_rec;
123:
124: FUNCTION get_rec (

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 737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');

733: l_row_notfound :=l_khrid_csr%NOTFOUND;
734: CLOSE l_khrid_csr;
735:
736: IF(l_row_notfound ) THEN
737: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KHR_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_HEADERS_V');
738:
739: x_return_status := Okc_Api.G_RET_STS_ERROR;
740: -- raise the exception as there's no matching foreign key value
741:

Line 813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');

809: CLOSE l_kleid_csr;
810:
811: IF(l_row_notfound ) THEN
812:
813: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'KLE_ID',G_CHILD_TABLE_TOKEN,'OKL_STREAMS',G_PARENT_TABLE_TOKEN,'OKL_K_LINES_V');
814:
815: x_return_status := Okc_Api.G_RET_STS_ERROR;
816: -- raise the exception as there's no matching foreign key value
817:

Line 993: FROM okl_streams

989:
990: CURSOR stm_csr (p_stm_id NUMBER)
991: IS
992: SELECT ID
993: FROM okl_streams
994: WHERE id = p_stm_id;
995:
996: l_stm_id NUMBER := NULL;
997:

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 1727: -- insert_row for:OKL_STREAMS --

1723: ---------------------------------------------------------------------------
1724: -- PROCEDURE insert_row
1725: ---------------------------------------------------------------------------
1726: --------------------------------
1727: -- insert_row for:OKL_STREAMS --
1728: --------------------------------
1729: PROCEDURE insert_row(
1730: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1731: x_return_status OUT NOCOPY VARCHAR2,

Line 1743: -- Set_Attributes for:OKL_STREAMS --

1739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1740: l_stm_rec stm_rec_type := p_stm_rec;
1741: l_def_stm_rec stm_rec_type;
1742: ------------------------------------
1743: -- Set_Attributes for:OKL_STREAMS --
1744: ------------------------------------
1745: FUNCTION Set_Attributes (
1746: p_stm_rec IN stm_rec_type,
1747: x_stm_rec OUT NOCOPY stm_rec_type

Line 1779: INSERT INTO OKL_STREAMS(

1775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: INSERT INTO OKL_STREAMS(
1780: id,
1781: sty_id,
1782: khr_id,
1783: kle_id,

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 2167: in_id Okl_Streams_Util.NumberTabTyp;

2163: p_stmv_tbl IN stmv_tbl_type,
2164: x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
2165:
2166: l_tabsize NUMBER := p_stmv_tbl.COUNT;
2167: in_id Okl_Streams_Util.NumberTabTyp;
2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;

Line 2168: in_sty_id Okl_Streams_Util.NumberTabTyp;

2164: x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
2165:
2166: l_tabsize NUMBER := p_stmv_tbl.COUNT;
2167: in_id Okl_Streams_Util.NumberTabTyp;
2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;

Line 2169: in_khr_id Okl_Streams_Util.NumberTabTyp;

2165:
2166: l_tabsize NUMBER := p_stmv_tbl.COUNT;
2167: in_id Okl_Streams_Util.NumberTabTyp;
2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;

Line 2170: in_kle_id Okl_Streams_Util.NumberTabTyp;

2166: l_tabsize NUMBER := p_stmv_tbl.COUNT;
2167: in_id Okl_Streams_Util.NumberTabTyp;
2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;

Line 2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;

2167: in_id Okl_Streams_Util.NumberTabTyp;
2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;

Line 2172: in_say_code Okl_Streams_Util.Var30TabTyp;

2168: in_sty_id Okl_Streams_Util.NumberTabTyp;
2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;

Line 2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;

2169: in_khr_id Okl_Streams_Util.NumberTabTyp;
2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;

Line 2174: in_active_yn Okl_Streams_Util.Var3TabTyp;

2170: in_kle_id Okl_Streams_Util.NumberTabTyp;
2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;

Line 2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;

2171: in_sgn_code Okl_Streams_Util.Var30TabTyp;
2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;

Line 2176: in_created_by Okl_Streams_Util.Number15TabTyp;

2172: in_say_code Okl_Streams_Util.Var30TabTyp;
2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;

Line 2177: in_creation_date Okl_Streams_Util.DateTabTyp;

2173: in_transaction_number Okl_Streams_Util.NumberTabTyp;
2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;

Line 2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;

2174: in_active_yn Okl_Streams_Util.Var3TabTyp;
2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;

Line 2179: in_last_update_date Okl_Streams_Util.DateTabTyp;

2175: in_object_version_number Okl_Streams_Util.Number9TabTyp;
2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;

Line 2180: in_date_current Okl_Streams_Util.DateTabTyp;

2176: in_created_by Okl_Streams_Util.Number15TabTyp;
2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;

Line 2181: in_date_working Okl_Streams_Util.DateTabTyp;

2177: in_creation_date Okl_Streams_Util.DateTabTyp;
2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;

Line 2182: in_date_history Okl_Streams_Util.DateTabTyp;

2178: in_last_updated_by Okl_Streams_Util.Number15TabTyp;
2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;

Line 2183: in_comments Okl_Streams_Util.Var1995TabTyp;

2179: in_last_update_date Okl_Streams_Util.DateTabTyp;
2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;

Line 2184: in_program_id Okl_Streams_Util.Number15TabTyp;

2180: in_date_current Okl_Streams_Util.DateTabTyp;
2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;

Line 2185: in_request_id Okl_Streams_Util.Number15TabTyp;

2181: in_date_working Okl_Streams_Util.DateTabTyp;
2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;

Line 2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;

2182: in_date_history Okl_Streams_Util.DateTabTyp;
2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;

Line 2187: in_program_update_date Okl_Streams_Util.DateTabTyp;

2183: in_comments Okl_Streams_Util.Var1995TabTyp;
2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;

Line 2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;

2184: in_program_id Okl_Streams_Util.Number15TabTyp;
2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;

Line 2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;

2185: in_request_id Okl_Streams_Util.Number15TabTyp;
2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;

Line 2190: in_stm_id Okl_Streams_Util.NumberTabTyp;

2186: in_program_application_id Okl_Streams_Util.Number15TabTyp;
2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;
2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;

Line 2191: in_source_id Okl_Streams_Util.NumberTabTyp;

2187: in_program_update_date Okl_Streams_Util.DateTabTyp;
2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;
2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;
2195: --Declaring the local variables used

Line 2192: in_source_table Okl_Streams_Util.Var30TabTyp;

2188: in_last_update_login Okl_Streams_Util.Number15TabTyp;
2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;
2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;
2195: --Declaring the local variables used
2196: l_created_by NUMBER;

Line 2193: in_trx_id Okl_Streams_Util.NumberTabTyp;

2189: in_purpose_code Okl_Streams_Util.Var30TabTyp;
2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;
2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;
2195: --Declaring the local variables used
2196: l_created_by NUMBER;
2197: l_last_updated_by NUMBER;

Line 2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;

2190: in_stm_id Okl_Streams_Util.NumberTabTyp;
2191: in_source_id Okl_Streams_Util.NumberTabTyp;
2192: in_source_table Okl_Streams_Util.Var30TabTyp;
2193: in_trx_id Okl_Streams_Util.NumberTabTyp;
2194: in_link_hist_stream_id Okl_Streams_Util.NumberTabTyp;
2195: --Declaring the local variables used
2196: l_created_by NUMBER;
2197: l_last_updated_by NUMBER;
2198: l_creation_date DATE;

Line 2271: INSERT INTO okl_streams(id,

2267: i:= p_stmv_tbl.next(i);
2268: END LOOP;
2269:
2270: FORALL i in 1..l_tabsize
2271: INSERT INTO okl_streams(id,
2272: sty_id,
2273: khr_id,
2274: kle_id,
2275: sgn_code,

Line 2337: -- lock_row for:OKL_STREAMS --

2333: ---------------------------------------------------------------------------
2334: -- PROCEDURE lock_row
2335: ---------------------------------------------------------------------------
2336: ------------------------------
2337: -- lock_row for:OKL_STREAMS --
2338: ------------------------------
2339: PROCEDURE lock_row(
2340: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2341: x_return_status OUT NOCOPY VARCHAR2,

Line 2350: FROM OKL_STREAMS

2346: E_Resource_Busy EXCEPTION;
2347: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2348: CURSOR lock_csr (p_stm_rec IN stm_rec_type) IS
2349: SELECT OBJECT_VERSION_NUMBER
2350: FROM OKL_STREAMS
2351: WHERE ID = p_stm_rec.id
2352: AND OBJECT_VERSION_NUMBER = p_stm_rec.object_version_number
2353: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2354:

Line 2357: FROM OKL_STREAMS

2353: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2354:
2355: CURSOR lchk_csr (p_stm_rec IN stm_rec_type) IS
2356: SELECT OBJECT_VERSION_NUMBER
2357: FROM OKL_STREAMS
2358: WHERE ID = p_stm_rec.id;
2359: l_api_version CONSTANT NUMBER := 1;
2360: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_lock_row';
2361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2362: l_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;

2358: WHERE ID = p_stm_rec.id;
2359: l_api_version CONSTANT NUMBER := 1;
2360: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_lock_row';
2361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2362: l_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2363: lc_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2364: l_row_notfound BOOLEAN := FALSE;
2365: lc_row_notfound BOOLEAN := FALSE;
2366: BEGIN

Line 2363: lc_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;

2359: l_api_version CONSTANT NUMBER := 1;
2360: l_api_name CONSTANT VARCHAR2(30) := 'STREAMS_lock_row';
2361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2362: l_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2363: lc_object_version_number OKL_STREAMS.OBJECT_VERSION_NUMBER%TYPE;
2364: l_row_notfound BOOLEAN := FALSE;
2365: lc_row_notfound BOOLEAN := FALSE;
2366: BEGIN
2367: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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 2611: -- update_row for:OKL_STREAMS --

2607: ---------------------------------------------------------------------------
2608: -- PROCEDURE update_row
2609: ---------------------------------------------------------------------------
2610: --------------------------------
2611: -- update_row for:OKL_STREAMS --
2612: --------------------------------
2613: PROCEDURE update_row(
2614: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2615: x_return_status OUT NOCOPY VARCHAR2,

Line 2802: -- Set_Attributes for:OKL_STREAMS --

2798:
2799: RETURN(l_return_status);
2800: END populate_new_record;
2801: ------------------------------------
2802: -- Set_Attributes for:OKL_STREAMS --
2803: ------------------------------------
2804: FUNCTION Set_Attributes (
2805: p_stm_rec IN stm_rec_type,
2806: x_stm_rec OUT NOCOPY stm_rec_type

Line 2845: UPDATE OKL_STREAMS

2841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2843: RAISE OKC_API.G_EXCEPTION_ERROR;
2844: END IF;
2845: UPDATE OKL_STREAMS
2846: SET STY_ID = l_def_stm_rec.sty_id,
2847: KHR_ID = l_def_stm_rec.khr_id,
2848: KLE_ID = l_def_stm_rec.kle_id,
2849: SGN_CODE = l_def_stm_rec.sgn_code,

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 3362: -- delete_row for:OKL_STREAMS --

3358: ---------------------------------------------------------------------------
3359: -- PROCEDURE delete_row
3360: ---------------------------------------------------------------------------
3361: --------------------------------
3362: -- delete_row for:OKL_STREAMS --
3363: --------------------------------
3364: PROCEDURE delete_row(
3365: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3366: x_return_status OUT NOCOPY VARCHAR2,

Line 3386: DELETE FROM OKL_STREAMS

3382: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3383: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3384: RAISE OKC_API.G_EXCEPTION_ERROR;
3385: END IF;
3386: DELETE FROM OKL_STREAMS
3387: WHERE ID = l_stm_rec.id;
3388:
3389: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3390: EXCEPTION

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,