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_RSP_PVT dependencies on OKL_REPORT_STREAM_PARAMS

Line 66: CURSOR c_pk_csr IS SELECT okl_report_stream_params_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_report_stream_params_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 100: -- FUNCTION get_rec for: OKL_REPORT_STREAM_PARAMS

96: null;
97: END api_copy;
98:
99: ---------------------------------------------------------------------------
100: -- FUNCTION get_rec for: OKL_REPORT_STREAM_PARAMS
101: ---------------------------------------------------------------------------
102: FUNCTION get_rec (
103: p_rps_rec IN rps_rec_type,
104: x_no_data_found OUT NOCOPY BOOLEAN

Line 117: FROM Okl_Report_Stream_Params

113: CREATION_DATE,
114: LAST_UPDATED_BY,
115: LAST_UPDATE_DATE,
116: LAST_UPDATE_LOGIN
117: FROM Okl_Report_Stream_Params
118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;
119: l_okl_report_stream_params_pk okl_report_stream_p1%ROWTYPE;
120: l_rps_rec rps_rec_type;
121: BEGIN

Line 118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;

114: LAST_UPDATED_BY,
115: LAST_UPDATE_DATE,
116: LAST_UPDATE_LOGIN
117: FROM Okl_Report_Stream_Params
118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;
119: l_okl_report_stream_params_pk okl_report_stream_p1%ROWTYPE;
120: l_rps_rec rps_rec_type;
121: BEGIN
122: x_no_data_found := TRUE;

Line 119: l_okl_report_stream_params_pk okl_report_stream_p1%ROWTYPE;

115: LAST_UPDATE_DATE,
116: LAST_UPDATE_LOGIN
117: FROM Okl_Report_Stream_Params
118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;
119: l_okl_report_stream_params_pk okl_report_stream_p1%ROWTYPE;
120: l_rps_rec rps_rec_type;
121: BEGIN
122: x_no_data_found := TRUE;
123: -- Get current database values

Line 169: -- FUNCTION null_out_defaults for: OKL_REPORT_STREAM_PARAMS

165: BEGIN
166: RETURN(get_rec(p_rps_rec, l_row_not_found));
167: END get_rec;
168: ---------------------------------------------------------------------------
169: -- FUNCTION null_out_defaults for: OKL_REPORT_STREAM_PARAMS
170: ---------------------------------------------------------------------------
171: FUNCTION null_out_defaults (
172: p_rps_rec IN rps_rec_type
173: ) RETURN rps_rec_type IS

Line 288: CURSOR c_is_valid_rpt_act_code(p_rpt_act_code OKL_REPORT_STREAM_PARAMS.ACTIVITY_CODE%TYPE) IS

284: x_return_status OUT NOCOPY VARCHAR2,
285: p_activity_code IN VARCHAR2) IS
286:
287: -- cursor to validate report activity
288: CURSOR c_is_valid_rpt_act_code(p_rpt_act_code OKL_REPORT_STREAM_PARAMS.ACTIVITY_CODE%TYPE) IS
289: SELECT 1
290: FROM FND_LOOKUPS
291: WHERE LOOKUP_TYPE = 'OKL_REPORT_ACTIVITY'
292: AND LOOKUP_CODE = p_rpt_act_code;

Line 336: -- Validate_Attributes for:OKL_REPORT_STREAM_PARAMS --

332: ---------------------------------------------------------------------------
333: -- FUNCTION Validate_Attributes
334: ---------------------------------------------------------------------------
335: ------------------------------------------------------
336: -- Validate_Attributes for:OKL_REPORT_STREAM_PARAMS --
337: ------------------------------------------------------
338: FUNCTION Validate_Attributes (
339: p_rps_rec IN rps_rec_type
340: ) RETURN VARCHAR2 IS

Line 348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE

344: l_test_value NUMBER := 0;
345:
346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(
348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS

Line 349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE

345:
346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(
348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS
353: WHERE REPORT_ID = p_report_id

Line 350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS

346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(
348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS
353: WHERE REPORT_ID = p_report_id
354: AND STY_ID = p_sty_id

Line 352: FROM OKL_REPORT_STREAM_PARAMS

348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS
353: WHERE REPORT_ID = p_report_id
354: AND STY_ID = p_sty_id
355: AND STREAM_PARAMETER_ID <> p_stream_param_id;
356:

Line 428: -- Validate Record for:OKL_REPORT_STREAM_PARAMS --

424: ---------------------------------------------------------------------------
425: -- PROCEDURE Validate_Record
426: ---------------------------------------------------------------------------
427: --------------------------------------------------
428: -- Validate Record for:OKL_REPORT_STREAM_PARAMS --
429: --------------------------------------------------
430: FUNCTION Validate_Record (
431: p_rps_rec IN rps_rec_type,
432: p_db_rps_rec IN rps_rec_type

Line 456: -- validate_row for:OKL_REPORT_STREAM_PARAMS --

452: ---------------------------------------------------------------------------
453: -- PROCEDURE validate_row
454: ---------------------------------------------------------------------------
455: -----------------------------------------------
456: -- validate_row for:OKL_REPORT_STREAM_PARAMS --
457: -----------------------------------------------
458: PROCEDURE validate_row(
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 531: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --

527: '_PVT'
528: );
529: END validate_row;
530: ----------------------------------------------------------
531: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --
532: ----------------------------------------------------------
533: PROCEDURE validate_row(
534: p_api_version IN NUMBER,
535: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 627: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --

623: );
624: END validate_row;
625:
626: ----------------------------------------------------------
627: -- PL/SQL TBL validate_row for:OKL_REPORT_STREAM_PARAMS --
628: ----------------------------------------------------------
629: PROCEDURE validate_row(
630: p_api_version IN NUMBER,
631: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 692: -- insert_row for:OKL_REPORT_STREAM_PARAMS --

688: ---------------------------------------------------------------------------
689: -- PROCEDURE insert_row
690: ---------------------------------------------------------------------------
691: ---------------------------------------------
692: -- insert_row for:OKL_REPORT_STREAM_PARAMS --
693: ---------------------------------------------
694: PROCEDURE insert_row(
695: p_api_version IN NUMBER,
696: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 724: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --

720: l_rps_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
721: RETURN(l_rps_rec);
722: END fill_who_columns;
723: -------------------------------------------------
724: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --
725: -------------------------------------------------
726: FUNCTION Set_Attributes (
727: p_rps_rec IN rps_rec_type,
728: x_rps_rec OUT NOCOPY rps_rec_type

Line 776: INSERT INTO OKL_REPORT_STREAM_PARAMS(

772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
774: RAISE OKL_API.G_EXCEPTION_ERROR;
775: END IF;
776: INSERT INTO OKL_REPORT_STREAM_PARAMS(
777: stream_parameter_id,
778: report_id,
779: sty_id,
780: activity_code,

Line 997: -- lock_row for:OKL_REPORT_STREAM_PARAMS --

993: ---------------------------------------------------------------------------
994: -- PROCEDURE lock_row
995: ---------------------------------------------------------------------------
996: -------------------------------------------
997: -- lock_row for:OKL_REPORT_STREAM_PARAMS --
998: -------------------------------------------
999: PROCEDURE lock_row(
1000: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,

Line 1010: FROM OKL_REPORT_STREAM_PARAMS

1006: E_Resource_Busy EXCEPTION;
1007: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1008: CURSOR lock_csr (p_rps_rec IN rps_rec_type) IS
1009: SELECT *
1010: FROM OKL_REPORT_STREAM_PARAMS
1011: WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id
1012: FOR UPDATE NOWAIT;
1013:
1014: l_api_version CONSTANT NUMBER := 1;

Line 1088: -- lock_row for: OKL_REPORT_STREAM_PARAMS --

1084: '_PVT'
1085: );
1086: END lock_row;
1087: --------------------------------------------
1088: -- lock_row for: OKL_REPORT_STREAM_PARAMS --
1089: --------------------------------------------
1090: PROCEDURE lock_row(
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1327: -- update_row for:OKL_REPORT_STREAM_PARAMS --

1323: ---------------------------------------------------------------------------
1324: -- PROCEDURE update_row
1325: ---------------------------------------------------------------------------
1326: ---------------------------------------------
1327: -- update_row for:OKL_REPORT_STREAM_PARAMS --
1328: ---------------------------------------------
1329: PROCEDURE update_row(
1330: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1331: x_return_status OUT NOCOPY VARCHAR2,

Line 1389: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --

1385: END IF;
1386: RETURN(l_return_status);
1387: END populate_new_record;
1388: -------------------------------------------------
1389: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --
1390: -------------------------------------------------
1391: FUNCTION Set_Attributes (
1392: p_rps_rec IN rps_rec_type,
1393: x_rps_rec OUT NOCOPY rps_rec_type

Line 1427: UPDATE OKL_REPORT_STREAM_PARAMS

1423: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1424: RAISE OKL_API.G_EXCEPTION_ERROR;
1425: END IF;
1426:
1427: UPDATE OKL_REPORT_STREAM_PARAMS
1428: SET REPORT_ID = l_def_rps_rec.report_id,
1429: STY_ID = l_def_rps_rec.sty_id,
1430: ACTIVITY_CODE = l_def_rps_rec.activity_code,
1431: CREATED_BY = l_def_rps_rec.created_by,

Line 1474: -- update_row for:OKL_REPORT_STREAM_PARAMS --

1470: '_PVT'
1471: );
1472: END update_row;
1473: ---------------------------------------------
1474: -- update_row for:OKL_REPORT_STREAM_PARAMS --
1475: ---------------------------------------------
1476: PROCEDURE update_row(
1477: p_api_version IN NUMBER,
1478: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1552: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --

1548: END IF;
1549: RETURN(l_return_status);
1550: END populate_new_record;
1551: -------------------------------------------------
1552: -- Set_Attributes for:OKL_REPORT_STREAM_PARAMS --
1553: -------------------------------------------------
1554: FUNCTION Set_Attributes (
1555: p_rps_rec IN rps_rec_type,
1556: x_rps_rec OUT NOCOPY rps_rec_type

Line 1843: -- delete_row for:OKL_REPORT_STREAM_PARAMS --

1839: ---------------------------------------------------------------------------
1840: -- PROCEDURE delete_row
1841: ---------------------------------------------------------------------------
1842: ---------------------------------------------
1843: -- delete_row for:OKL_REPORT_STREAM_PARAMS --
1844: ---------------------------------------------
1845: PROCEDURE delete_row(
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,

Line 1868: DELETE FROM OKL_REPORT_STREAM_PARAMS

1864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1865: RAISE OKL_API.G_EXCEPTION_ERROR;
1866: END IF;
1867:
1868: DELETE FROM OKL_REPORT_STREAM_PARAMS
1869: WHERE STREAM_PARAMETER_ID = p_rps_rec.stream_parameter_id;
1870:
1871: x_return_status := l_return_status;
1872: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1906: -- delete_row for:OKL_REPORT_STREAM_PARAMS --

1902: '_PVT'
1903: );
1904: END delete_row;
1905: ---------------------------------------------
1906: -- delete_row for:OKL_REPORT_STREAM_PARAMS --
1907: ---------------------------------------------
1908: PROCEDURE delete_row(
1909: p_api_version IN NUMBER,
1910: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1986: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --

1982: '_PVT'
1983: );
1984: END delete_row;
1985: --------------------------------------------------------
1986: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --
1987: --------------------------------------------------------
1988: PROCEDURE delete_row(
1989: p_api_version IN NUMBER,
1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2082: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --

2078: );
2079: END delete_row;
2080:
2081: --------------------------------------------------------
2082: -- PL/SQL TBL delete_row for:OKL_REPORT_STREAM_PARAMS --
2083: --------------------------------------------------------
2084: PROCEDURE delete_row(
2085: p_api_version IN NUMBER,
2086: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,