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_CPS_PVT dependencies on OKC_K_PROCESSES

Line 13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PROCESSES_V';

9: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13: G_VIEW CONSTANT VARCHAR2(200) := 'OKC_K_PROCESSES_V';
14: G_EXCEPTION_HALT_VALIDATION exception;
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16:
17: -- Start of comments

Line 411: -- FUNCTION get_rec for: OKC_K_PROCESSES

407: null;
408: END api_copy;
409:
410: ---------------------------------------------------------------------------
411: -- FUNCTION get_rec for: OKC_K_PROCESSES
412: ---------------------------------------------------------------------------
413: FUNCTION get_rec (
414: p_cps_rec IN cps_rec_type,
415: x_no_data_found OUT NOCOPY BOOLEAN

Line 448: FROM Okc_K_Processes

444: ATTRIBUTE12,
445: ATTRIBUTE13,
446: ATTRIBUTE14,
447: ATTRIBUTE15
448: FROM Okc_K_Processes
449: WHERE okc_k_processes.id = p_id;
450: l_cps_pk cps_pk_csr%ROWTYPE;
451: l_cps_rec cps_rec_type;
452: BEGIN

Line 449: WHERE okc_k_processes.id = p_id;

445: ATTRIBUTE13,
446: ATTRIBUTE14,
447: ATTRIBUTE15
448: FROM Okc_K_Processes
449: WHERE okc_k_processes.id = p_id;
450: l_cps_pk cps_pk_csr%ROWTYPE;
451: l_cps_rec cps_rec_type;
452: BEGIN
453: x_no_data_found := TRUE;

Line 499: -- FUNCTION get_rec for: OKC_K_PROCESSES_V

495: BEGIN
496: RETURN(get_rec(p_cps_rec, l_row_notfound));
497: END get_rec;
498: ---------------------------------------------------------------------------
499: -- FUNCTION get_rec for: OKC_K_PROCESSES_V
500: ---------------------------------------------------------------------------
501: FUNCTION get_rec (
502: p_cpsv_rec IN cpsv_rec_type,
503: x_no_data_found OUT NOCOPY BOOLEAN

Line 536: FROM Okc_K_Processes_V

532: CREATION_DATE,
533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,
535: LAST_UPDATE_LOGIN
536: FROM Okc_K_Processes_V
537: WHERE okc_k_processes_v.id = p_id;
538: l_okc_cpsv_pk okc_cpsv_pk_csr%ROWTYPE;
539: l_cpsv_rec cpsv_rec_type;
540: BEGIN

Line 537: WHERE okc_k_processes_v.id = p_id;

533: LAST_UPDATED_BY,
534: LAST_UPDATE_DATE,
535: LAST_UPDATE_LOGIN
536: FROM Okc_K_Processes_V
537: WHERE okc_k_processes_v.id = p_id;
538: l_okc_cpsv_pk okc_cpsv_pk_csr%ROWTYPE;
539: l_cpsv_rec cpsv_rec_type;
540: BEGIN
541: x_no_data_found := TRUE;

Line 588: -- FUNCTION null_out_defaults for: OKC_K_PROCESSES_V --

584: RETURN(get_rec(p_cpsv_rec, l_row_notfound));
585: END get_rec;
586:
587: -------------------------------------------------------
588: -- FUNCTION null_out_defaults for: OKC_K_PROCESSES_V --
589: -------------------------------------------------------
590: FUNCTION null_out_defaults (
591: p_cpsv_rec IN cpsv_rec_type
592: ) RETURN cpsv_rec_type IS

Line 685: -- Validate_Attributes for:OKC_K_PROCESSES_V --

681: ---------------------------------------------------------------------------
682: -- PROCEDURE Validate_Attributes
683: ---------------------------------------------------------------------------
684: -----------------------------------------------
685: -- Validate_Attributes for:OKC_K_PROCESSES_V --
686: -----------------------------------------------
687: FUNCTION Validate_Attributes (
688: p_cpsv_rec IN cpsv_rec_type
689: ) RETURN VARCHAR2 IS

Line 788: -- Validate_Record for:OKC_K_PROCESSES_V --

784: ---------------------------------------------------------------------------
785: -- PROCEDURE Validate_Record
786: ---------------------------------------------------------------------------
787: -------------------------------------------
788: -- Validate_Record for:OKC_K_PROCESSES_V --
789: -------------------------------------------
790: FUNCTION Validate_Record (
791: p_cpsv_rec IN cpsv_rec_type
792: ) RETURN VARCHAR2 IS

Line 798: from okc_k_processes cps, okc_process_defs_b pdfb

794: -- l_unq_tbl OKC_UTIL.unq_tbl_type;
795:
796: Cursor l_cps_csr Is
797: select count(1)
798: from okc_k_processes cps, okc_process_defs_b pdfb
799: where cps.pdf_id = pdfb.id
800: and cps.chr_id = p_cpsv_rec.chr_id
801: and pdfb.usage='APPROVE' and pdfb.pdf_type='WPS'
802: and cps.id <> p_cpsv_rec.id;

Line 812: FROM okc_k_processes cps

808: -- for case K2 should not overwrite already existing K1
809: -- ------------------------------------------------------
810: CURSOR cur_pdf_1 IS
811: SELECT 'x'
812: FROM okc_k_processes cps
813: WHERE chr_id = p_cpsv_rec.CHR_ID
814: AND crt_id IS NULL
815: AND pdf_id = p_cpsv_rec.PDF_ID
816: AND id <> NVL(p_cpsv_rec.ID,-9999);

Line 825: FROM okc_k_processes cps

821: -- for case K2 should not overwrite already existing K1
822: -- ------------------------------------------------------
823: CURSOR cur_pdf_2 IS
824: SELECT 'x'
825: FROM okc_k_processes cps
826: WHERE chr_id IS NULL
827: AND crt_id = p_cpsv_rec.CRT_ID
828: AND pdf_id = p_cpsv_rec.PDF_ID
829: AND id <> NVL(p_cpsv_rec.ID,-9999);

Line 972: -- validate_row for:OKC_K_PROCESSES_V --

968: ---------------------------------------------------------------------------
969: -- PROCEDURE validate_row
970: ---------------------------------------------------------------------------
971: ----------------------------------------
972: -- validate_row for:OKC_K_PROCESSES_V --
973: ----------------------------------------
974: PROCEDURE validate_row(
975: p_api_version IN NUMBER,
976: p_init_msg_list IN VARCHAR2 ,

Line 1127: -- insert_row for:OKC_K_PROCESSES --

1123: ---------------------------------------------------------------------------
1124: -- PROCEDURE insert_row
1125: ---------------------------------------------------------------------------
1126: ------------------------------------
1127: -- insert_row for:OKC_K_PROCESSES --
1128: ------------------------------------
1129: PROCEDURE insert_row(
1130: p_init_msg_list IN VARCHAR2 ,
1131: x_return_status OUT NOCOPY VARCHAR2,

Line 1143: -- Set_Attributes for:OKC_K_PROCESSES --

1139: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1140: l_cps_rec cps_rec_type := p_cps_rec;
1141: l_def_cps_rec cps_rec_type;
1142: ----------------------------------------
1143: -- Set_Attributes for:OKC_K_PROCESSES --
1144: ----------------------------------------
1145: FUNCTION Set_Attributes (
1146: p_cps_rec IN cps_rec_type,
1147: x_cps_rec OUT NOCOPY cps_rec_type

Line 1174: INSERT INTO OKC_K_PROCESSES(

1170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1172: RAISE OKC_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: INSERT INTO OKC_K_PROCESSES(
1175: id,
1176: pdf_id,
1177: chr_id,
1178: user_id,

Line 1270: -- insert_row for:OKC_K_PROCESSES_V --

1266: '_PVT'
1267: );
1268: END insert_row;
1269: --------------------------------------
1270: -- insert_row for:OKC_K_PROCESSES_V --
1271: --------------------------------------
1272: PROCEDURE insert_row(
1273: p_api_version IN NUMBER,
1274: p_init_msg_list IN VARCHAR2 ,

Line 1305: -- Set_Attributes for:OKC_K_PROCESSES_V --

1301: l_cpsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1302: RETURN(l_cpsv_rec);
1303: END fill_who_columns;
1304: ------------------------------------------
1305: -- Set_Attributes for:OKC_K_PROCESSES_V --
1306: ------------------------------------------
1307: FUNCTION Set_Attributes (
1308: p_cpsv_rec IN cpsv_rec_type,
1309: x_cpsv_rec OUT NOCOPY cpsv_rec_type

Line 1500: -- lock_row for:OKC_K_PROCESSES --

1496: ---------------------------------------------------------------------------
1497: -- PROCEDURE lock_row
1498: ---------------------------------------------------------------------------
1499: ----------------------------------
1500: -- lock_row for:OKC_K_PROCESSES --
1501: ----------------------------------
1502: PROCEDURE lock_row(
1503: p_init_msg_list IN VARCHAR2 ,
1504: x_return_status OUT NOCOPY VARCHAR2,

Line 1513: FROM OKC_K_PROCESSES

1509: E_Resource_Busy EXCEPTION;
1510: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1511: CURSOR lock_csr (p_cps_rec IN cps_rec_type) IS
1512: SELECT OBJECT_VERSION_NUMBER
1513: FROM OKC_K_PROCESSES
1514: WHERE ID = p_cps_rec.id
1515: AND OBJECT_VERSION_NUMBER in (p_cps_rec.object_version_number,
1516: OKC_API.G_MISS_NUM)
1517: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1521: FROM OKC_K_PROCESSES

1517: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1518:
1519: CURSOR lchk_csr (p_cps_rec IN cps_rec_type) IS
1520: SELECT OBJECT_VERSION_NUMBER
1521: FROM OKC_K_PROCESSES
1522: WHERE ID = p_cps_rec.id;
1523: l_api_version CONSTANT NUMBER := 1;
1524: l_api_name CONSTANT VARCHAR2(30) := 'PROCESSES_lock_row';
1525: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1526: l_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;

1522: WHERE ID = p_cps_rec.id;
1523: l_api_version CONSTANT NUMBER := 1;
1524: l_api_name CONSTANT VARCHAR2(30) := 'PROCESSES_lock_row';
1525: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1526: l_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;
1527: lc_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;
1528: l_row_notfound BOOLEAN := FALSE;
1529: lc_row_notfound BOOLEAN := FALSE;
1530: BEGIN

Line 1527: lc_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;

1523: l_api_version CONSTANT NUMBER := 1;
1524: l_api_name CONSTANT VARCHAR2(30) := 'PROCESSES_lock_row';
1525: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1526: l_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;
1527: lc_object_version_number OKC_K_PROCESSES.OBJECT_VERSION_NUMBER%TYPE;
1528: l_row_notfound BOOLEAN := FALSE;
1529: lc_row_notfound BOOLEAN := FALSE;
1530: BEGIN
1531: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1607: -- lock_row for:OKC_K_PROCESSES_V --

1603: '_PVT'
1604: );
1605: END lock_row;
1606: ------------------------------------
1607: -- lock_row for:OKC_K_PROCESSES_V --
1608: ------------------------------------
1609: PROCEDURE lock_row(
1610: p_api_version IN NUMBER,
1611: p_init_msg_list IN VARCHAR2 ,

Line 1766: -- update_row for:OKC_K_PROCESSES --

1762: ---------------------------------------------------------------------------
1763: -- PROCEDURE update_row
1764: ---------------------------------------------------------------------------
1765: ------------------------------------
1766: -- update_row for:OKC_K_PROCESSES --
1767: ------------------------------------
1768: PROCEDURE update_row(
1769: p_init_msg_list IN VARCHAR2 ,
1770: x_return_status OUT NOCOPY VARCHAR2,

Line 1918: -- Set_Attributes for:OKC_K_PROCESSES --

1914: END IF;
1915: RETURN(l_return_status);
1916: END populate_new_record;
1917: ----------------------------------------
1918: -- Set_Attributes for:OKC_K_PROCESSES --
1919: ----------------------------------------
1920: FUNCTION Set_Attributes (
1921: p_cps_rec IN cps_rec_type,
1922: x_cps_rec OUT NOCOPY cps_rec_type

Line 1955: UPDATE OKC_K_PROCESSES

1951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1953: RAISE OKC_API.G_EXCEPTION_ERROR;
1954: END IF;
1955: UPDATE OKC_K_PROCESSES
1956: SET PDF_ID = l_def_cps_rec.pdf_id,
1957: CHR_ID = l_def_cps_rec.chr_id,
1958: USER_ID = l_def_cps_rec.user_id,
1959: CRT_ID = l_def_cps_rec.crt_id,

Line 2021: -- update_row for:OKC_K_PROCESSES_V --

2017: '_PVT'
2018: );
2019: END update_row;
2020: --------------------------------------
2021: -- update_row for:OKC_K_PROCESSES_V --
2022: --------------------------------------
2023: PROCEDURE update_row(
2024: p_api_version IN NUMBER,
2025: p_init_msg_list IN VARCHAR2 ,

Line 2188: -- Set_Attributes for:OKC_K_PROCESSES_V --

2184: END IF;
2185: RETURN(l_return_status);
2186: END populate_new_record;
2187: ------------------------------------------
2188: -- Set_Attributes for:OKC_K_PROCESSES_V --
2189: ------------------------------------------
2190: FUNCTION Set_Attributes (
2191: p_cpsv_rec IN cpsv_rec_type,
2192: x_cpsv_rec OUT NOCOPY cpsv_rec_type

Line 2385: -- delete_row for:OKC_K_PROCESSES --

2381: ---------------------------------------------------------------------------
2382: -- PROCEDURE delete_row
2383: ---------------------------------------------------------------------------
2384: ------------------------------------
2385: -- delete_row for:OKC_K_PROCESSES --
2386: ------------------------------------
2387: PROCEDURE delete_row(
2388: p_init_msg_list IN VARCHAR2 ,
2389: x_return_status OUT NOCOPY VARCHAR2,

Line 2409: DELETE FROM OKC_K_PROCESSES

2405: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2407: RAISE OKC_API.G_EXCEPTION_ERROR;
2408: END IF;
2409: DELETE FROM OKC_K_PROCESSES
2410: WHERE ID = l_cps_rec.id;
2411:
2412: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2413: EXCEPTION

Line 2446: -- delete_row for:OKC_K_PROCESSES_V --

2442: '_PVT'
2443: );
2444: END delete_row;
2445: --------------------------------------
2446: -- delete_row for:OKC_K_PROCESSES_V --
2447: --------------------------------------
2448: PROCEDURE delete_row(
2449: p_api_version IN NUMBER,
2450: p_init_msg_list IN VARCHAR2 ,

Line 2603: -- Procedure for mass insert in OKC_K_PROCESSES table

2599: );
2600: END delete_row;
2601:
2602: ---------------------------------------------------------------
2603: -- Procedure for mass insert in OKC_K_PROCESSES table
2604: ---------------------------------------------------------------
2605: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_cpsv_tbl cpsv_tbl_type) IS
2606: l_tabsize NUMBER := p_cpsv_tbl.COUNT;
2607: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 2699: INTO OKC_K_PROCESSES

2695: END LOOP;
2696:
2697: FORALL i in 1..l_tabsize
2698: INSERT
2699: INTO OKC_K_PROCESSES
2700: (
2701: id,
2702: pdf_id,
2703: chr_id,

Line 2791: INSERT INTO okc_k_processes_h

2787:
2788: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2789:
2790: BEGIN
2791: INSERT INTO okc_k_processes_h
2792: (
2793: major_version,
2794: id,
2795: pdf_id,

Line 2855: FROM okc_k_processes

2851: attribute12,
2852: attribute13,
2853: attribute14,
2854: attribute15
2855: FROM okc_k_processes
2856: WHERE chr_id = p_chr_id;
2857:
2858: RETURN l_return_status;
2859: EXCEPTION

Line 2887: INSERT INTO okc_k_processes

2883:
2884: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2885:
2886: BEGIN
2887: INSERT INTO okc_k_processes
2888: (
2889: id,
2890: pdf_id,
2891: chr_id,

Line 2949: FROM okc_k_processes_h

2945: attribute12,
2946: attribute13,
2947: attribute14,
2948: attribute15
2949: FROM okc_k_processes_h
2950: WHERE chr_id = p_chr_id
2951: AND major_version = p_major_version;
2952:
2953: RETURN l_return_status;