DBA Data[Home] [Help]

APPS.OKL_REP_PVT dependencies on OKL_REPORTS_V

Line 169: -- FUNCTION get_rec for: OKL_REPORTS_V

165: );
166: END add_language;
167:
168: ---------------------------------------------------------------------------
169: -- FUNCTION get_rec for: OKL_REPORTS_V
170: ---------------------------------------------------------------------------
171: FUNCTION get_rec (
172: p_repv_rec IN repv_rec_type,
173: x_no_data_found OUT NOCOPY BOOLEAN

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 197: FROM Okl_Reports_V

193: LAST_UPDATE_LOGIN,
194: LANGUAGE,
195: SOURCE_LANG,
196: SFWT_FLAG
197: FROM Okl_Reports_V
198: WHERE report_id = p_report_id;
199: l_okl_reports_v_pk okl_reports_v_pk_csr%ROWTYPE;
200: l_repv_rec repv_rec_type;
201: BEGIN

Line 199: l_okl_reports_v_pk okl_reports_v_pk_csr%ROWTYPE;

195: SOURCE_LANG,
196: SFWT_FLAG
197: FROM Okl_Reports_V
198: WHERE report_id = p_report_id;
199: l_okl_reports_v_pk okl_reports_v_pk_csr%ROWTYPE;
200: l_repv_rec repv_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values

Line 204: OPEN okl_reports_v_pk_csr(p_repv_rec.report_id);

200: l_repv_rec repv_rec_type;
201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN okl_reports_v_pk_csr(p_repv_rec.report_id);
205: FETCH okl_reports_v_pk_csr INTO
206: l_repv_rec.report_id,
207: l_repv_rec.name,
208: l_repv_rec.chart_of_accounts_id,

Line 205: FETCH okl_reports_v_pk_csr INTO

201: BEGIN
202: x_no_data_found := TRUE;
203: -- Get current database values
204: OPEN okl_reports_v_pk_csr(p_repv_rec.report_id);
205: FETCH okl_reports_v_pk_csr INTO
206: l_repv_rec.report_id,
207: l_repv_rec.name,
208: l_repv_rec.chart_of_accounts_id,
209: l_repv_rec.book_classification_code,

Line 226: x_no_data_found := okl_reports_v_pk_csr%NOTFOUND;

222: l_repv_rec.last_update_login,
223: l_repv_rec.language,
224: l_repv_rec.source_lang,
225: l_repv_rec.sfwt_flag;
226: x_no_data_found := okl_reports_v_pk_csr%NOTFOUND;
227: CLOSE okl_reports_v_pk_csr;
228: RETURN(l_repv_rec);
229: END get_rec;
230:

Line 227: CLOSE okl_reports_v_pk_csr;

223: l_repv_rec.language,
224: l_repv_rec.source_lang,
225: l_repv_rec.sfwt_flag;
226: x_no_data_found := okl_reports_v_pk_csr%NOTFOUND;
227: CLOSE okl_reports_v_pk_csr;
228: RETURN(l_repv_rec);
229: END get_rec;
230:
231: ------------------------------------------------------------------

Line 419: -- FUNCTION null_out_defaults for: OKL_REPORTS_V

415: BEGIN
416: RETURN(get_rec(p_okl_reports_tl_rec, l_row_not_found));
417: END get_rec;
418: ---------------------------------------------------------------------------
419: -- FUNCTION null_out_defaults for: OKL_REPORTS_V
420: ---------------------------------------------------------------------------
421: FUNCTION null_out_defaults (
422: p_repv_rec IN repv_rec_type
423: ) RETURN repv_rec_type IS

Line 492: -- Validate Record for:OKL_REPORTS_V --

488: ---------------------------------------------------------------------------
489: -- PROCEDURE Validate_Record
490: ---------------------------------------------------------------------------
491: ---------------------------------------
492: -- Validate Record for:OKL_REPORTS_V --
493: ---------------------------------------
494: FUNCTION Validate_Record (
495: p_repv_rec IN repv_rec_type,
496: p_db_repv_rec IN repv_rec_type

Line 598: -- validate_attributes for:OKL_REPORTS_V --

594: ---------------------------------------------------------------------------
595: -- PROCEDURE validate_attributes
596: ---------------------------------------------------------------------------
597: ------------------------------------
598: -- validate_attributes for:OKL_REPORTS_V --
599: ------------------------------------
600: FUNCTION validate_attributes(
601: p_repv_rec IN repv_rec_type
602: ) RETURN VARCHAR2 IS

Line 780: -- validate_row for:OKL_REPORTS_V --

776: ---------------------------------------------------------------------------
777: -- PROCEDURE validate_row
778: ---------------------------------------------------------------------------
779: ------------------------------------
780: -- validate_row for:OKL_REPORTS_V --
781: ------------------------------------
782: PROCEDURE validate_row(
783: p_api_version IN NUMBER,
784: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 857: -- PL/SQL TBL validate_row for:OKL_REPORTS_V --

853: '_PVT'
854: );
855: END validate_row;
856: -----------------------------------------------
857: -- PL/SQL TBL validate_row for:OKL_REPORTS_V --
858: -----------------------------------------------
859: PROCEDURE validate_row(
860: p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 953: -- PL/SQL TBL validate_row for:OKL_REPORTS_V --

949: );
950: END validate_row;
951:
952: -----------------------------------------------
953: -- PL/SQL TBL validate_row for:OKL_REPORTS_V --
954: -----------------------------------------------
955: PROCEDURE validate_row(
956: p_api_version IN NUMBER,
957: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1783: -- lock_row for: OKL_REPORTS_V --

1779: '_PVT'
1780: );
1781: END lock_row;
1782: ---------------------------------
1783: -- lock_row for: OKL_REPORTS_V --
1784: ---------------------------------
1785: PROCEDURE lock_row(
1786: p_api_version IN NUMBER,
1787: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2370: -- update_row for:OKL_REPORTS_V --

2366: '_PVT'
2367: );
2368: END update_row;
2369: ----------------------------------
2370: -- update_row for:OKL_REPORTS_V --
2371: ----------------------------------
2372: PROCEDURE update_row(
2373: p_api_version IN NUMBER,
2374: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2484: -- Set_Attributes for:OKL_REPORTS_V --

2480: END IF;
2481: RETURN(l_return_status);
2482: END populate_new_record;
2483: --------------------------------------
2484: -- Set_Attributes for:OKL_REPORTS_V --
2485: --------------------------------------
2486: FUNCTION Set_Attributes (
2487: p_repv_rec IN repv_rec_type,
2488: x_repv_rec OUT NOCOPY repv_rec_type

Line 2918: -- delete_row for:OKL_REPORTS_V --

2914: '_PVT'
2915: );
2916: END delete_row;
2917: ----------------------------------
2918: -- delete_row for:OKL_REPORTS_V --
2919: ----------------------------------
2920: PROCEDURE delete_row(
2921: p_api_version IN NUMBER,
2922: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3014: -- PL/SQL TBL delete_row for:OKL_REPORTS_V --

3010: '_PVT'
3011: );
3012: END delete_row;
3013: ---------------------------------------------
3014: -- PL/SQL TBL delete_row for:OKL_REPORTS_V --
3015: ---------------------------------------------
3016: PROCEDURE delete_row(
3017: p_api_version IN NUMBER,
3018: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3110: -- PL/SQL TBL delete_row for:OKL_REPORTS_V --

3106: );
3107: END delete_row;
3108:
3109: ---------------------------------------------
3110: -- PL/SQL TBL delete_row for:OKL_REPORTS_V --
3111: ---------------------------------------------
3112: PROCEDURE delete_row(
3113: p_api_version IN NUMBER,
3114: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,