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.OKC_PDF_PVT dependencies on OKC_PROCESS_DEFS_V

Line 287: -- FUNCTION get_rec for: OKC_PROCESS_DEFS_V

283: BEGIN
284: RETURN(get_rec(p_pdf_rec, l_row_notfound));
285: END get_rec;
286: ---------------------------------------------------------------------------
287: -- FUNCTION get_rec for: OKC_PROCESS_DEFS_V
288: ---------------------------------------------------------------------------
289: FUNCTION get_rec (
290: p_pdfv_rec IN pdfv_rec_type,
291: x_no_data_found OUT NOCOPY BOOLEAN

Line 335: FROM Okc_Process_Defs_V

331: LAST_UPDATE_DATE,
332: LAST_UPDATE_LOGIN,
333: MESSAGE_NAME,
334: SCRIPT_NAME
335: FROM Okc_Process_Defs_V
336: WHERE okc_process_defs_v.id = p_id;
337: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
338: l_pdfv_rec pdfv_rec_type;
339: BEGIN

Line 336: WHERE okc_process_defs_v.id = p_id;

332: LAST_UPDATE_LOGIN,
333: MESSAGE_NAME,
334: SCRIPT_NAME
335: FROM Okc_Process_Defs_V
336: WHERE okc_process_defs_v.id = p_id;
337: l_okc_pdfv_pk okc_pdfv_pk_csr%ROWTYPE;
338: l_pdfv_rec pdfv_rec_type;
339: BEGIN
340: x_no_data_found := TRUE;

Line 398: -- FUNCTION null_out_defaults for: OKC_PROCESS_DEFS_V --

394: RETURN(get_rec(p_pdfv_rec, l_row_notfound));
395: END get_rec;
396:
397: --------------------------------------------------------
398: -- FUNCTION null_out_defaults for: OKC_PROCESS_DEFS_V --
399: --------------------------------------------------------
400: FUNCTION null_out_defaults (
401: p_pdfv_rec IN pdfv_rec_type
402: ) RETURN pdfv_rec_type IS

Line 530: -- Validate_Attributes for:OKC_PROCESS_DEFS_V --

526: ---------------------------------------------------------------------------
527: -- PROCEDURE Validate_Attributes
528: ---------------------------------------------------------------------------
529: ------------------------------------------------
530: -- Validate_Attributes for:OKC_PROCESS_DEFS_V --
531: ------------------------------------------------
532: FUNCTION Validate_Attributes (
533: p_pdfv_rec IN pdfv_rec_type
534: ) RETURN VARCHAR2 IS

Line 575: -- Validate_Record for:OKC_PROCESS_DEFS_V --

571: ---------------------------------------------------------------------------
572: -- PROCEDURE Validate_Record
573: ---------------------------------------------------------------------------
574: --------------------------------------------
575: -- Validate_Record for:OKC_PROCESS_DEFS_V --
576: --------------------------------------------
577: FUNCTION Validate_Record (
578: p_pdfv_rec IN pdfv_rec_type
579: ) RETURN VARCHAR2 IS

Line 592: -- Validate_Attributes for:OKC_PROCESS_DEFS_V --

588: ---------------------------------------------------------------------------
589: -- PROCEDURE Validate_Attributes
590: ---------------------------------------------------------------------------
591: ------------------------------------------------
592: -- Validate_Attributes for:OKC_PROCESS_DEFS_V --
593: ------------------------------------------------
594: -- Start of comments
595: -- Procedure Name : validate_object_version_number
596: -- Description : Check if object_version_number is null

Line 877: SELECT id FROM OKC_PROCESS_DEFS_V

873: x_return_status OUT NOCOPY VARCHAR2,
874: p_pdfv_rec IN pdfv_rec_type) IS
875:
876: CURSOR l_unq_cur(p_name VARCHAR2) IS
877: SELECT id FROM OKC_PROCESS_DEFS_V
878: WHERE name = p_name;
879:
880: l_id NUMBER := OKC_API.G_MISS_NUM;
881: BEGIN

Line 1356: -- Validate_Record for:OKC_PROCESS_DEFS_V --

1352: ---------------------------------------------------------------------------
1353: -- PROCEDURE Validate_Record
1354: ---------------------------------------------------------------------------
1355: --------------------------------------------
1356: -- Validate_Record for:OKC_PROCESS_DEFS_V --
1357: --------------------------------------------
1358: --------------------------------------------------------------------------------
1359: -- Start of comments
1360: -- Procedure Name : validate_unique_pack_proc

Line 1374: CURSOR c1(p_package_name okc_process_defs_v.package_name%TYPE,

1370: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1371: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1372: l_dummy VARCHAR2(1);
1373: l_row_found Boolean := False;
1374: CURSOR c1(p_package_name okc_process_defs_v.package_name%TYPE,
1375: p_procedure_name okc_process_defs_v.procedure_name%TYPE) is
1376: SELECT 1
1377: FROM okc_process_defs_b
1378: WHERE package_name = p_package_name

Line 1375: p_procedure_name okc_process_defs_v.procedure_name%TYPE) is

1371: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1372: l_dummy VARCHAR2(1);
1373: l_row_found Boolean := False;
1374: CURSOR c1(p_package_name okc_process_defs_v.package_name%TYPE,
1375: p_procedure_name okc_process_defs_v.procedure_name%TYPE) is
1376: SELECT 1
1377: FROM okc_process_defs_b
1378: WHERE package_name = p_package_name
1379: AND procedure_name = p_procedure_name

Line 1449: CURSOR c1(p_wf_name okc_process_defs_v.wf_name%TYPE,

1445: --l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1446: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1447: l_dummy VARCHAR2(1);
1448: l_row_found Boolean := False;
1449: CURSOR c1(p_wf_name okc_process_defs_v.wf_name%TYPE,
1450: p_wf_process_name okc_process_defs_v.wf_process_name%TYPE) is
1451: SELECT 1
1452: FROM okc_process_defs_v
1453: WHERE wf_name = p_wf_name

Line 1450: p_wf_process_name okc_process_defs_v.wf_process_name%TYPE) is

1446: --l_unq_tbl OKC_UTIL.unq_tbl_type;
1447: l_dummy VARCHAR2(1);
1448: l_row_found Boolean := False;
1449: CURSOR c1(p_wf_name okc_process_defs_v.wf_name%TYPE,
1450: p_wf_process_name okc_process_defs_v.wf_process_name%TYPE) is
1451: SELECT 1
1452: FROM okc_process_defs_v
1453: WHERE wf_name = p_wf_name
1454: AND wf_process_name = p_wf_process_name

Line 1452: FROM okc_process_defs_v

1448: l_row_found Boolean := False;
1449: CURSOR c1(p_wf_name okc_process_defs_v.wf_name%TYPE,
1450: p_wf_process_name okc_process_defs_v.wf_process_name%TYPE) is
1451: SELECT 1
1452: FROM okc_process_defs_v
1453: WHERE wf_name = p_wf_name
1454: AND wf_process_name = p_wf_process_name
1455: AND id <> nvl(p_pdfv_rec.id,-99999);
1456:

Line 2159: -- validate_row for:OKC_PROCESS_DEFS_V --

2155: ---------------------------------------------------------------------------
2156: -- PROCEDURE validate_row
2157: ---------------------------------------------------------------------------
2158: -----------------------------------------
2159: -- validate_row for:OKC_PROCESS_DEFS_V --
2160: -----------------------------------------
2161: PROCEDURE validate_row(
2162: p_api_version IN NUMBER,
2163: p_init_msg_list IN VARCHAR2,

Line 2579: -- insert_row for:OKC_PROCESS_DEFS_V --

2575: '_PVT'
2576: );
2577: END insert_row;
2578: ---------------------------------------
2579: -- insert_row for:OKC_PROCESS_DEFS_V --
2580: ---------------------------------------
2581: PROCEDURE insert_row(
2582: p_api_version IN NUMBER,
2583: p_init_msg_list IN VARCHAR2,

Line 2616: -- Set_Attributes for:OKC_PROCESS_DEFS_V --

2612: l_pdfv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2613: RETURN(l_pdfv_rec);
2614: END fill_who_columns;
2615: -------------------------------------------
2616: -- Set_Attributes for:OKC_PROCESS_DEFS_V --
2617: -------------------------------------------
2618: FUNCTION Set_Attributes (
2619: p_pdfv_rec IN pdfv_rec_type,
2620: x_pdfv_rec OUT NOCOPY pdfv_rec_type

Line 3012: -- lock_row for:OKC_PROCESS_DEFS_V --

3008: '_PVT'
3009: );
3010: END lock_row;
3011: -------------------------------------
3012: -- lock_row for:OKC_PROCESS_DEFS_V --
3013: -------------------------------------
3014: PROCEDURE lock_row(
3015: p_api_version IN NUMBER,
3016: p_init_msg_list IN VARCHAR2,

Line 3641: -- update_row for:OKC_PROCESS_DEFS_V --

3637: '_PVT'
3638: );
3639: END update_row;
3640: ---------------------------------------
3641: -- update_row for:OKC_PROCESS_DEFS_V --
3642: ---------------------------------------
3643: PROCEDURE update_row(
3644: p_api_version IN NUMBER,
3645: p_init_msg_list IN VARCHAR2,

Line 3854: -- Set_Attributes for:OKC_PROCESS_DEFS_V --

3850: END IF;
3851: RETURN(l_return_status);
3852: END populate_new_record;
3853: -------------------------------------------
3854: -- Set_Attributes for:OKC_PROCESS_DEFS_V --
3855: -------------------------------------------
3856: FUNCTION Set_Attributes (
3857: p_pdfv_rec IN pdfv_rec_type,
3858: x_pdfv_rec OUT NOCOPY pdfv_rec_type

Line 4211: -- delete_row for:OKC_PROCESS_DEFS_V --

4207: '_PVT'
4208: );
4209: END delete_row;
4210: ---------------------------------------
4211: -- delete_row for:OKC_PROCESS_DEFS_V --
4212: ---------------------------------------
4213: PROCEDURE delete_row(
4214: p_api_version IN NUMBER,
4215: p_init_msg_list IN VARCHAR2,