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_REP_PVT dependencies on OKL_REPORTS_B

Line 66: CURSOR c_pk_csr IS SELECT okl_reports_b_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_reports_b_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 107: FROM OKL_REPORTS_B B

103: BEGIN
104: DELETE FROM OKL_REPORTS_TL T
105: WHERE NOT EXISTS (
106: SELECT NULL
107: FROM OKL_REPORTS_B B
108: WHERE B.REPORT_ID =T.REPORT_ID
109: );
110:
111: UPDATE OKL_REPORTS_TL T SET(

Line 175: CURSOR okl_reports_v_pk_csr(p_report_id okl_reports_b.report_id%type) IS

171: FUNCTION get_rec (
172: p_repv_rec IN repv_rec_type,
173: x_no_data_found OUT NOCOPY BOOLEAN
174: ) RETURN repv_rec_type IS
175: CURSOR okl_reports_v_pk_csr(p_report_id okl_reports_b.report_id%type) IS
176: SELECT
177: REPORT_ID,
178: NAME,
179: CHART_OF_ACCOUNTS_ID,

Line 259: -- FUNCTION get_rec for: OKL_REPORTS_B

255: BEGIN
256: RETURN(get_rec(p_repv_rec, l_row_not_found));
257: END get_rec;
258: ---------------------------------------------------------------------------
259: -- FUNCTION get_rec for: OKL_REPORTS_B
260: ---------------------------------------------------------------------------
261: FUNCTION get_rec (
262: p_rep_rec IN rep_rec_type,
263: x_no_data_found OUT NOCOPY BOOLEAN

Line 265: CURSOR okl_reports_b_pk_csr (p_report_id IN NUMBER) IS

261: FUNCTION get_rec (
262: p_rep_rec IN rep_rec_type,
263: x_no_data_found OUT NOCOPY BOOLEAN
264: ) RETURN rep_rec_type IS
265: CURSOR okl_reports_b_pk_csr (p_report_id IN NUMBER) IS
266: SELECT
267: REPORT_ID,
268: NAME,
269: CHART_OF_ACCOUNTS_ID,

Line 283: FROM Okl_Reports_B

279: CREATION_DATE,
280: LAST_UPDATED_BY,
281: LAST_UPDATE_DATE,
282: LAST_UPDATE_LOGIN
283: FROM Okl_Reports_B
284: WHERE okl_reports_b.report_id = p_report_id;
285: l_okl_reports_b_pk okl_reports_b_pk_csr%ROWTYPE;
286: l_rep_rec rep_rec_type;
287: BEGIN

Line 284: WHERE okl_reports_b.report_id = p_report_id;

280: LAST_UPDATED_BY,
281: LAST_UPDATE_DATE,
282: LAST_UPDATE_LOGIN
283: FROM Okl_Reports_B
284: WHERE okl_reports_b.report_id = p_report_id;
285: l_okl_reports_b_pk okl_reports_b_pk_csr%ROWTYPE;
286: l_rep_rec rep_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;

Line 285: l_okl_reports_b_pk okl_reports_b_pk_csr%ROWTYPE;

281: LAST_UPDATE_DATE,
282: LAST_UPDATE_LOGIN
283: FROM Okl_Reports_B
284: WHERE okl_reports_b.report_id = p_report_id;
285: l_okl_reports_b_pk okl_reports_b_pk_csr%ROWTYPE;
286: l_rep_rec rep_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values

Line 290: OPEN okl_reports_b_pk_csr (p_rep_rec.report_id);

286: l_rep_rec rep_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_reports_b_pk_csr (p_rep_rec.report_id);
291: FETCH okl_reports_b_pk_csr INTO
292: l_rep_rec.report_id,
293: l_rep_rec.name,
294: l_rep_rec.chart_of_accounts_id,

Line 291: FETCH okl_reports_b_pk_csr INTO

287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_reports_b_pk_csr (p_rep_rec.report_id);
291: FETCH okl_reports_b_pk_csr INTO
292: l_rep_rec.report_id,
293: l_rep_rec.name,
294: l_rep_rec.chart_of_accounts_id,
295: l_rep_rec.book_classification_code,

Line 308: x_no_data_found := okl_reports_b_pk_csr%NOTFOUND;

304: l_rep_rec.creation_date,
305: l_rep_rec.last_updated_by,
306: l_rep_rec.last_update_date,
307: l_rep_rec.last_update_login;
308: x_no_data_found := okl_reports_b_pk_csr%NOTFOUND;
309: CLOSE okl_reports_b_pk_csr;
310: RETURN(l_rep_rec);
311: END get_rec;
312:

Line 309: CLOSE okl_reports_b_pk_csr;

305: l_rep_rec.last_updated_by,
306: l_rep_rec.last_update_date,
307: l_rep_rec.last_update_login;
308: x_no_data_found := okl_reports_b_pk_csr%NOTFOUND;
309: CLOSE okl_reports_b_pk_csr;
310: RETURN(l_rep_rec);
311: END get_rec;
312:
313: ------------------------------------------------------------------

Line 608: CURSOR c_is_valid_coa_id(p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE) IS

604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: l_test_value NUMBER := 0;
606:
607: -- cursor to validate chart of accounts id
608: CURSOR c_is_valid_coa_id(p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE) IS
609: SELECT 1
610: FROM FND_ID_FLEX_STRUCTURES
611: WHERE ID_FLEX_NUM = p_coa_id;
612:

Line 614: CURSOR c_is_valid_ledger_id(p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE) IS

610: FROM FND_ID_FLEX_STRUCTURES
611: WHERE ID_FLEX_NUM = p_coa_id;
612:
613: -- cursor to validate ledger id
614: CURSOR c_is_valid_ledger_id(p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE) IS
615: SELECT 1
616: FROM GL_LEDGERS
617: WHERE LEDGER_ID = p_ledger_id;
618:

Line 621: p_report_name OKL_REPORTS_B.NAME%TYPE

617: WHERE LEDGER_ID = p_ledger_id;
618:
619: -- cursor to validate uniqueness of name, book classification, chart of accounts id and ledger_id
620: CURSOR c_is_combination_exists(
621: p_report_name OKL_REPORTS_B.NAME%TYPE
622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS

Line 622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE

618:
619: -- cursor to validate uniqueness of name, book classification, chart of accounts id and ledger_id
620: CURSOR c_is_combination_exists(
621: p_report_name OKL_REPORTS_B.NAME%TYPE
622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS
626: SELECT 1

Line 623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE

619: -- cursor to validate uniqueness of name, book classification, chart of accounts id and ledger_id
620: CURSOR c_is_combination_exists(
621: p_report_name OKL_REPORTS_B.NAME%TYPE
622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS
626: SELECT 1
627: FROM OKL_REPORTS_B

Line 624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE

620: CURSOR c_is_combination_exists(
621: p_report_name OKL_REPORTS_B.NAME%TYPE
622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS
626: SELECT 1
627: FROM OKL_REPORTS_B
628: WHERE NAME = p_report_name

Line 625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS

621: p_report_name OKL_REPORTS_B.NAME%TYPE
622: ,p_coa_id OKL_REPORTS_B.CHART_OF_ACCOUNTS_ID%TYPE
623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS
626: SELECT 1
627: FROM OKL_REPORTS_B
628: WHERE NAME = p_report_name
629: AND CHART_OF_ACCOUNTS_ID = p_coa_id

Line 627: FROM OKL_REPORTS_B

623: ,p_bcc_value OKL_REPORTS_B.BOOK_CLASSIFICATION_CODE%TYPE
624: ,p_ledger_id OKL_REPORTS_B.LEDGER_ID%TYPE
625: ,p_report_id OKL_REPORTS_B.REPORT_ID%TYPE) IS
626: SELECT 1
627: FROM OKL_REPORTS_B
628: WHERE NAME = p_report_name
629: AND CHART_OF_ACCOUNTS_ID = p_coa_id
630: AND BOOK_CLASSIFICATION_CODE = p_bcc_value
631: AND LEDGER_ID = p_ledger_id

Line 635: CURSOR c_is_valid_rpt_categ_code(p_rpt_categ_code OKL_REPORTS_B.REPORT_CATEGORY_CODE%TYPE) IS

631: AND LEDGER_ID = p_ledger_id
632: AND REPORT_ID <> p_report_id;
633:
634: -- cursor to validate report category code
635: CURSOR c_is_valid_rpt_categ_code(p_rpt_categ_code OKL_REPORTS_B.REPORT_CATEGORY_CODE%TYPE) IS
636: SELECT 1
637: FROM FND_LOOKUPS
638: WHERE LOOKUP_TYPE = 'OKL_REPORT_CATEGORIES'
639: AND LOOKUP_CODE = p_rpt_categ_code;

Line 642: CURSOR c_is_valid_rpt_type_code(p_rpt_type_code OKL_REPORTS_B.REPORT_TYPE_CODE%TYPE) IS

638: WHERE LOOKUP_TYPE = 'OKL_REPORT_CATEGORIES'
639: AND LOOKUP_CODE = p_rpt_categ_code;
640:
641: -- cursor to validate report type code
642: CURSOR c_is_valid_rpt_type_code(p_rpt_type_code OKL_REPORTS_B.REPORT_TYPE_CODE%TYPE) IS
643: SELECT 1
644: FROM FND_LOOKUPS
645: WHERE LOOKUP_TYPE = 'OKL_REPORT_TYPES'
646: AND LOOKUP_CODE = p_rpt_type_code;

Line 649: CURSOR c_is_valid_rpt_status_code(p_rpt_status_code OKL_REPORTS_B.STATUS_CODE%TYPE) IS

645: WHERE LOOKUP_TYPE = 'OKL_REPORT_TYPES'
646: AND LOOKUP_CODE = p_rpt_type_code;
647:
648: -- cursor to validate report status code
649: CURSOR c_is_valid_rpt_status_code(p_rpt_status_code OKL_REPORTS_B.STATUS_CODE%TYPE) IS
650: SELECT 1
651: FROM FND_LOOKUPS
652: WHERE LOOKUP_TYPE = 'OKL_RECON_REPORT_STATUSES'
653: AND LOOKUP_CODE = p_rpt_status_code;

Line 1018: -- insert_row for:OKL_REPORTS_B --

1014: ---------------------------------------------------------------------------
1015: -- PROCEDURE insert_row
1016: ---------------------------------------------------------------------------
1017: ----------------------------------
1018: -- insert_row for:OKL_REPORTS_B --
1019: ----------------------------------
1020: PROCEDURE insert_row(
1021: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1022: x_return_status OUT NOCOPY VARCHAR2,

Line 1034: -- Set_Attributes for:OKL_REPORTS_B --

1030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1031: l_rep_rec rep_rec_type := p_rep_rec;
1032: l_def_rep_rec rep_rec_type;
1033: --------------------------------------
1034: -- Set_Attributes for:OKL_REPORTS_B --
1035: --------------------------------------
1036: FUNCTION Set_Attributes (
1037: p_rep_rec IN rep_rec_type,
1038: x_rep_rec OUT NOCOPY rep_rec_type

Line 1066: INSERT INTO OKL_REPORTS_B(

1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: INSERT INTO OKL_REPORTS_B(
1067: report_id,
1068: name,
1069: chart_of_accounts_id,
1070: book_classification_code,

Line 1254: -- insert_row for :OKL_REPORTS_B --

1250: '_PVT'
1251: );
1252: END insert_row;
1253: -----------------------------------
1254: -- insert_row for :OKL_REPORTS_B --
1255: -----------------------------------
1256: PROCEDURE insert_row(
1257: p_api_version IN NUMBER,
1258: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1290: -- Set_Attributes for:OKL_REPORTS_B --

1286: l_repv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1287: RETURN(l_repv_rec);
1288: END fill_who_columns;
1289: --------------------------------------
1290: -- Set_Attributes for:OKL_REPORTS_B --
1291: --------------------------------------
1292: FUNCTION Set_Attributes (
1293: p_repv_rec IN repv_rec_type,
1294: x_repv_rec OUT NOCOPY repv_rec_type

Line 1606: -- lock_row for:OKL_REPORTS_B --

1602: ---------------------------------------------------------------------------
1603: -- PROCEDURE lock_row
1604: ---------------------------------------------------------------------------
1605: --------------------------------
1606: -- lock_row for:OKL_REPORTS_B --
1607: --------------------------------
1608: PROCEDURE lock_row(
1609: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1610: x_return_status OUT NOCOPY VARCHAR2,

Line 1619: FROM OKL_REPORTS_B

1615: E_Resource_Busy EXCEPTION;
1616: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1617: CURSOR lock_csr (p_rep_rec IN rep_rec_type) IS
1618: SELECT *
1619: FROM OKL_REPORTS_B
1620: WHERE REPORT_ID = p_rep_rec.report_id
1621: FOR UPDATE NOWAIT;
1622:
1623: l_api_version CONSTANT NUMBER := 1;

Line 2037: -- update_row for:OKL_REPORTS_B --

2033: ---------------------------------------------------------------------------
2034: -- PROCEDURE update_row
2035: ---------------------------------------------------------------------------
2036: ----------------------------------
2037: -- update_row for:OKL_REPORTS_B --
2038: ----------------------------------
2039: PROCEDURE update_row(
2040: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2041: x_return_status OUT NOCOPY VARCHAR2,

Line 2120: -- Set_Attributes for:OKL_REPORTS_B --

2116: END IF;
2117: RETURN(l_return_status);
2118: END populate_new_record;
2119: --------------------------------------
2120: -- Set_Attributes for:OKL_REPORTS_B --
2121: --------------------------------------
2122: FUNCTION Set_Attributes (
2123: p_rep_rec IN rep_rec_type,
2124: x_rep_rec OUT NOCOPY rep_rec_type

Line 2157: UPDATE OKL_REPORTS_B

2153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2155: RAISE OKL_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: UPDATE OKL_REPORTS_B
2158: SET NAME = l_def_rep_rec.name,
2159: CHART_OF_ACCOUNTS_ID = l_def_rep_rec.chart_of_accounts_id,
2160: BOOK_CLASSIFICATION_CODE = l_def_rep_rec.book_classification_code,
2161: LEDGER_ID = l_def_rep_rec.ledger_id,

Line 2792: -- delete_row for:OKL_REPORTS_B --

2788: ---------------------------------------------------------------------------
2789: -- PROCEDURE delete_row
2790: ---------------------------------------------------------------------------
2791: ----------------------------------
2792: -- delete_row for:OKL_REPORTS_B --
2793: ----------------------------------
2794: PROCEDURE delete_row(
2795: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2796: x_return_status OUT NOCOPY VARCHAR2,

Line 2817: DELETE FROM OKL_REPORTS_B

2813: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_ERROR;
2815: END IF;
2816:
2817: DELETE FROM OKL_REPORTS_B
2818: WHERE REPORT_ID = p_rep_rec.report_id;
2819:
2820: x_return_status := l_return_status;
2821: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);