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_CGC_PVT dependencies on OKC_K_GRPINGS

Line 41: -- FUNCTION get_rec for: OKC_K_GRPINGS

37: null;
38: END api_copy;
39:
40: ---------------------------------------------------------------------------
41: -- FUNCTION get_rec for: OKC_K_GRPINGS
42: ---------------------------------------------------------------------------
43: FUNCTION get_rec (
44: p_cgc_rec IN cgc_rec_type,
45: x_no_data_found OUT NOCOPY BOOLEAN

Line 60: FROM Okc_K_Grpings

56: CREATION_DATE,
57: LAST_UPDATED_BY,
58: LAST_UPDATE_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okc_K_Grpings
61: WHERE okc_K_grpings.id = p_id;
62: l_cgc_pk cgc_pk_csr%ROWTYPE;
63: l_cgc_rec cgc_rec_type;
64: BEGIN

Line 61: WHERE okc_K_grpings.id = p_id;

57: LAST_UPDATED_BY,
58: LAST_UPDATE_DATE,
59: LAST_UPDATE_LOGIN
60: FROM Okc_K_Grpings
61: WHERE okc_K_grpings.id = p_id;
62: l_cgc_pk cgc_pk_csr%ROWTYPE;
63: l_cgc_rec cgc_rec_type;
64: BEGIN
65: x_no_data_found := TRUE;

Line 93: -- FUNCTION get_rec for: OKC_K_GRPINGS_V

89: BEGIN
90: RETURN(get_rec(p_cgc_rec, l_row_notfound));
91: END get_rec;
92: ---------------------------------------------------------------------------
93: -- FUNCTION get_rec for: OKC_K_GRPINGS_V
94: ---------------------------------------------------------------------------
95: FUNCTION get_rec (
96: p_cgcv_rec IN cgcv_rec_type,
97: x_no_data_found OUT NOCOPY BOOLEAN

Line 112: FROM Okc_K_Grpings_V

108: CREATION_DATE,
109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okc_K_Grpings_V
113: WHERE okc_K_grpings_v.id = p_id;
114: l_okc_cgcv_pk okc_cgcv_pk_csr%ROWTYPE;
115: l_cgcv_rec cgcv_rec_type;
116: BEGIN

Line 113: WHERE okc_K_grpings_v.id = p_id;

109: LAST_UPDATED_BY,
110: LAST_UPDATE_DATE,
111: LAST_UPDATE_LOGIN
112: FROM Okc_K_Grpings_V
113: WHERE okc_K_grpings_v.id = p_id;
114: l_okc_cgcv_pk okc_cgcv_pk_csr%ROWTYPE;
115: l_cgcv_rec cgcv_rec_type;
116: BEGIN
117: x_no_data_found := TRUE;

Line 146: -- FUNCTION null_out_defaults for: OKC_K_GRPINGS_V --

142: RETURN(get_rec(p_cgcv_rec, l_row_notfound));
143: END get_rec;
144:
145: ------------------------------------------------------------
146: -- FUNCTION null_out_defaults for: OKC_K_GRPINGS_V --
147: ------------------------------------------------------------
148: FUNCTION null_out_defaults (
149: p_cgcv_rec IN cgcv_rec_type
150: ) RETURN cgcv_rec_type IS

Line 264: -- Validate_Attributes for:OKC_K_GRPINGS_V --

260: ---------------------------------------------------------------------------
261: -- PROCEDURE Validate_Attributes
262: ---------------------------------------------------------------------------
263: ----------------------------------------------------
264: -- Validate_Attributes for:OKC_K_GRPINGS_V --
265: ----------------------------------------------------
266: FUNCTION Validate_Attributes (
267: p_cgcv_rec IN cgcv_rec_type
268: ) RETURN VARCHAR2 IS

Line 309: -- Validate_Record for:OKC_K_GRPINGS_V --

305: ---------------------------------------------------------------------------
306: -- PROCEDURE Validate_Record
307: ---------------------------------------------------------------------------
308: ------------------------------------------------
309: -- Validate_Record for:OKC_K_GRPINGS_V --
310: ------------------------------------------------
311: FUNCTION Validate_Record (
312: p_cgcv_rec IN cgcv_rec_type
313: ) RETURN VARCHAR2 IS

Line 381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,

377: FUNCTION validate_unique_keys (
378: p_cgcv_rec IN cgcv_rec_type
379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V

Line 382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,

378: p_cgcv_rec IN cgcv_rec_type
379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

Line 383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS

379: ) RETURN VARCHAR2 IS
380: unique_key_error EXCEPTION;
381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id

Line 385: FROM Okc_K_Grpings_V

381: CURSOR okc_chr_csr (p_id IN okc_k_grpings_v.id%TYPE,
382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL

Line 386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

382: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));

Line 387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id

383: p_included_chr_id IN okc_k_grpings_v.included_chr_id%TYPE) IS
384: SELECT 'x'
385: FROM Okc_K_Grpings_V
386: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,

Line 391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,

387: AND okc_K_grpings_v.included_chr_id = p_included_chr_id
388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V

Line 392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,

388: AND ((p_id IS NULL)
389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

Line 393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS

389: OR (p_id IS NOT NULL
390: AND id <> p_id));
391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id

Line 395: FROM Okc_K_Grpings_V

391: CURSOR okc_cgp_csr (p_id IN okc_k_grpings_v.id%TYPE,
392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL

Line 396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id

392: p_cgp_parent_id IN okc_k_grpings_v.cgp_parent_id%TYPE,
393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL
400: AND id <> p_id));

Line 397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id

393: p_included_cgp_id IN okc_k_grpings_v.included_cgp_id%TYPE) IS
394: SELECT 'x'
395: FROM Okc_K_Grpings_V
396: WHERE okc_K_grpings_v.cgp_parent_id = p_cgp_parent_id
397: AND okc_K_grpings_v.included_cgp_id = p_included_cgp_id
398: AND ((p_id IS NULL)
399: OR (p_id IS NOT NULL
400: AND id <> p_id));
401: l_okc_cgp_dummy VARCHAR2(1);

Line 547: -- validate_row for:OKC_K_GRPINGS_V --

543: ---------------------------------------------------------------------------
544: -- PROCEDURE validate_row
545: ---------------------------------------------------------------------------
546: ---------------------------------------------
547: -- validate_row for:OKC_K_GRPINGS_V --
548: ---------------------------------------------
549: PROCEDURE validate_row(
550: p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 ,

Line 691: -- insert_row for:OKC_K_GRPINGS --

687: ---------------------------------------------------------------------------
688: -- PROCEDURE insert_row
689: ---------------------------------------------------------------------------
690: -----------------------------------------
691: -- insert_row for:OKC_K_GRPINGS --
692: -----------------------------------------
693: PROCEDURE insert_row(
694: p_init_msg_list IN VARCHAR2 ,
695: x_return_status OUT NOCOPY VARCHAR2,

Line 707: -- Set_Attributes for:OKC_K_GRPINGS --

703: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
704: l_cgc_rec cgc_rec_type := p_cgc_rec;
705: l_def_cgc_rec cgc_rec_type;
706: ---------------------------------------------
707: -- Set_Attributes for:OKC_K_GRPINGS --
708: ---------------------------------------------
709: FUNCTION Set_Attributes (
710: p_cgc_rec IN cgc_rec_type,
711: x_cgc_rec OUT NOCOPY cgc_rec_type

Line 738: INSERT INTO OKC_K_GRPINGS(

734: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
736: RAISE OKC_API.G_EXCEPTION_ERROR;
737: END IF;
738: INSERT INTO OKC_K_GRPINGS(
739: id,
740: cgp_parent_id,
741: included_cgp_id,
742: included_chr_id,

Line 798: -- insert_row for:OKC_K_GRPINGS_V --

794: '_PVT'
795: );
796: END insert_row;
797: -------------------------------------------
798: -- insert_row for:OKC_K_GRPINGS_V --
799: -------------------------------------------
800: PROCEDURE insert_row(
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 ,

Line 832: -- Set_Attributes for:OKC_K_GRPINGS_V --

828: l_cgcv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
829: RETURN(l_cgcv_rec);
830: END fill_who_columns;
831: -----------------------------------------------
832: -- Set_Attributes for:OKC_K_GRPINGS_V --
833: -----------------------------------------------
834: FUNCTION Set_Attributes (
835: p_cgcv_rec IN cgcv_rec_type,
836: x_cgcv_rec OUT NOCOPY cgcv_rec_type

Line 1019: -- lock_row for:OKC_K_GRPINGS --

1015: ---------------------------------------------------------------------------
1016: -- PROCEDURE lock_row
1017: ---------------------------------------------------------------------------
1018: ---------------------------------------
1019: -- lock_row for:OKC_K_GRPINGS --
1020: ---------------------------------------
1021: PROCEDURE lock_row(
1022: p_init_msg_list IN VARCHAR2 ,
1023: x_return_status OUT NOCOPY VARCHAR2,

Line 1032: FROM OKC_K_GRPINGS

1028: E_Resource_Busy EXCEPTION;
1029: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1030: CURSOR lock_csr (p_cgc_rec IN cgc_rec_type) IS
1031: SELECT OBJECT_VERSION_NUMBER
1032: FROM OKC_K_GRPINGS
1033: WHERE ID = p_cgc_rec.id
1034: AND OBJECT_VERSION_NUMBER = p_cgc_rec.object_version_number
1035: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1036:

Line 1039: FROM OKC_K_GRPINGS

1035: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1036:
1037: CURSOR lchk_csr (p_cgc_rec IN cgc_rec_type) IS
1038: SELECT OBJECT_VERSION_NUMBER
1039: FROM OKC_K_GRPINGS
1040: WHERE ID = p_cgc_rec.id;
1041: l_api_version CONSTANT NUMBER := 1;
1042: l_api_name CONSTANT VARCHAR2(30) := 'GRPINGS_lock_row';
1043: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1044: l_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;

1040: WHERE ID = p_cgc_rec.id;
1041: l_api_version CONSTANT NUMBER := 1;
1042: l_api_name CONSTANT VARCHAR2(30) := 'GRPINGS_lock_row';
1043: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1044: l_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;
1045: lc_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;
1046: l_row_notfound BOOLEAN := FALSE;
1047: lc_row_notfound BOOLEAN := FALSE;
1048: BEGIN

Line 1045: lc_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;

1041: l_api_version CONSTANT NUMBER := 1;
1042: l_api_name CONSTANT VARCHAR2(30) := 'GRPINGS_lock_row';
1043: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1044: l_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;
1045: lc_object_version_number OKC_K_GRPINGS.OBJECT_VERSION_NUMBER%TYPE;
1046: l_row_notfound BOOLEAN := FALSE;
1047: lc_row_notfound BOOLEAN := FALSE;
1048: BEGIN
1049: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1125: -- lock_row for:OKC_K_GRPINGS_V --

1121: '_PVT'
1122: );
1123: END lock_row;
1124: -----------------------------------------
1125: -- lock_row for:OKC_K_GRPINGS_V --
1126: -----------------------------------------
1127: PROCEDURE lock_row(
1128: p_api_version IN NUMBER,
1129: p_init_msg_list IN VARCHAR2 ,

Line 1273: -- update_row for:OKC_K_GRPINGS --

1269: ---------------------------------------------------------------------------
1270: -- PROCEDURE update_row
1271: ---------------------------------------------------------------------------
1272: -----------------------------------------
1273: -- update_row for:OKC_K_GRPINGS --
1274: -----------------------------------------
1275: PROCEDURE update_row(
1276: p_init_msg_list IN VARCHAR2 ,
1277: x_return_status OUT NOCOPY VARCHAR2,

Line 1353: -- Set_Attributes for:OKC_K_GRPINGS --

1349: END IF;
1350: RETURN(l_return_status);
1351: END populate_new_record;
1352: ---------------------------------------------
1353: -- Set_Attributes for:OKC_K_GRPINGS --
1354: ---------------------------------------------
1355: FUNCTION Set_Attributes (
1356: p_cgc_rec IN cgc_rec_type,
1357: x_cgc_rec OUT NOCOPY cgc_rec_type

Line 1390: UPDATE OKC_K_GRPINGS

1386: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1388: RAISE OKC_API.G_EXCEPTION_ERROR;
1389: END IF;
1390: UPDATE OKC_K_GRPINGS
1391: SET CGP_PARENT_ID = l_def_cgc_rec.cgp_parent_id,
1392: INCLUDED_CGP_ID = l_def_cgc_rec.included_cgp_id,
1393: INCLUDED_CHR_ID = l_def_cgc_rec.included_chr_id,
1394: SCS_CODE = l_def_cgc_rec.scs_code,

Line 1438: -- update_row for:OKC_K_GRPINGS_V --

1434: '_PVT'
1435: );
1436: END update_row;
1437: -------------------------------------------
1438: -- update_row for:OKC_K_GRPINGS_V --
1439: -------------------------------------------
1440: PROCEDURE update_row(
1441: p_api_version IN NUMBER,
1442: p_init_msg_list IN VARCHAR2 ,

Line 1533: -- Set_Attributes for:OKC_K_GRPINGS_V --

1529: END IF;
1530: RETURN(l_return_status);
1531: END populate_new_record;
1532: -----------------------------------------------
1533: -- Set_Attributes for:OKC_K_GRPINGS_V --
1534: -----------------------------------------------
1535: FUNCTION Set_Attributes (
1536: p_cgcv_rec IN cgcv_rec_type,
1537: x_cgcv_rec OUT NOCOPY cgcv_rec_type

Line 1723: -- delete_row for:OKC_K_GRPINGS --

1719: ---------------------------------------------------------------------------
1720: -- PROCEDURE delete_row
1721: ---------------------------------------------------------------------------
1722: -----------------------------------------
1723: -- delete_row for:OKC_K_GRPINGS --
1724: -----------------------------------------
1725: PROCEDURE delete_row(
1726: p_init_msg_list IN VARCHAR2 ,
1727: x_return_status OUT NOCOPY VARCHAR2,

Line 1747: DELETE FROM OKC_K_GRPINGS

1743: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1745: RAISE OKC_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: DELETE FROM OKC_K_GRPINGS
1748: WHERE ID = l_cgc_rec.id;
1749:
1750: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1751: EXCEPTION

Line 1784: -- delete_row for:OKC_K_GRPINGS_V --

1780: '_PVT'
1781: );
1782: END delete_row;
1783: -------------------------------------------
1784: -- delete_row for:OKC_K_GRPINGS_V --
1785: -------------------------------------------
1786: PROCEDURE delete_row(
1787: p_api_version IN NUMBER,
1788: p_init_msg_list IN VARCHAR2 ,

Line 1982: INSERT INTO OKC_K_GRPINGS (

1978: i := p_cgcv_tbl.NEXT(i);
1979: END LOOP;
1980:
1981: FORALL i in 1..l_tabsize
1982: INSERT INTO OKC_K_GRPINGS (
1983: id,
1984: object_version_number,
1985: cgp_parent_id,
1986: included_chr_id,

Line 2049: ' and chrv.id not in (select included_chr_id from okc_k_grpings' ||

2045: l_qry := 'select chrv.id, chrv.contract_number || ' ||
2046: 'decode(chrv.contract_number_modifier, null, null,' ||
2047: ''' ('' || chrv.contract_number_modifier || '')'') contract_number' ||
2048: ' from okc_k_headers_v chrv where ' || g_qry_clause ||
2049: ' and chrv.id not in (select included_chr_id from okc_k_grpings' ||
2050: ' where cgp_parent_id = :1' ||
2051: ' and included_chr_id is not null)' ||
2052: ' order by 2';
2053: END IF;