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_CGM_PVT dependencies on OKL_CNTX_GRP_PRMTRS

Line 36: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS

32: null;
33: END api_copy;
34:
35: ---------------------------------------------------------------------------
36: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS
37: ---------------------------------------------------------------------------
38: FUNCTION get_rec (
39: p_cgm_rec IN cgm_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN

Line 42: CURSOR okl_cntx_grp_prmtrs_b_pk_csr (p_id IN NUMBER) IS

38: FUNCTION get_rec (
39: p_cgm_rec IN cgm_rec_type,
40: x_no_data_found OUT NOCOPY BOOLEAN
41: ) RETURN cgm_rec_type IS
42: CURSOR okl_cntx_grp_prmtrs_b_pk_csr (p_id IN NUMBER) IS
43: SELECT
44: ID,
45: CGR_ID,
46: PMR_ID,

Line 53: FROM Okl_Cntx_Grp_Prmtrs

49: CREATION_DATE,
50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN
53: FROM Okl_Cntx_Grp_Prmtrs
54: WHERE okl_cntx_grp_prmtrs.id = p_id;
55: l_okl_cntx_grp_prmtrs_b_pk okl_cntx_grp_prmtrs_b_pk_csr%ROWTYPE;
56: l_cgm_rec cgm_rec_type;
57: BEGIN

Line 54: WHERE okl_cntx_grp_prmtrs.id = p_id;

50: LAST_UPDATED_BY,
51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN
53: FROM Okl_Cntx_Grp_Prmtrs
54: WHERE okl_cntx_grp_prmtrs.id = p_id;
55: l_okl_cntx_grp_prmtrs_b_pk okl_cntx_grp_prmtrs_b_pk_csr%ROWTYPE;
56: l_cgm_rec cgm_rec_type;
57: BEGIN
58: x_no_data_found := TRUE;

Line 55: l_okl_cntx_grp_prmtrs_b_pk okl_cntx_grp_prmtrs_b_pk_csr%ROWTYPE;

51: LAST_UPDATE_DATE,
52: LAST_UPDATE_LOGIN
53: FROM Okl_Cntx_Grp_Prmtrs
54: WHERE okl_cntx_grp_prmtrs.id = p_id;
55: l_okl_cntx_grp_prmtrs_b_pk okl_cntx_grp_prmtrs_b_pk_csr%ROWTYPE;
56: l_cgm_rec cgm_rec_type;
57: BEGIN
58: x_no_data_found := TRUE;
59: -- Get current database values

Line 60: OPEN okl_cntx_grp_prmtrs_b_pk_csr (p_cgm_rec.id);

56: l_cgm_rec cgm_rec_type;
57: BEGIN
58: x_no_data_found := TRUE;
59: -- Get current database values
60: OPEN okl_cntx_grp_prmtrs_b_pk_csr (p_cgm_rec.id);
61: FETCH okl_cntx_grp_prmtrs_b_pk_csr INTO
62: l_cgm_rec.ID,
63: l_cgm_rec.CGR_ID,
64: l_cgm_rec.PMR_ID,

Line 61: FETCH okl_cntx_grp_prmtrs_b_pk_csr INTO

57: BEGIN
58: x_no_data_found := TRUE;
59: -- Get current database values
60: OPEN okl_cntx_grp_prmtrs_b_pk_csr (p_cgm_rec.id);
61: FETCH okl_cntx_grp_prmtrs_b_pk_csr INTO
62: l_cgm_rec.ID,
63: l_cgm_rec.CGR_ID,
64: l_cgm_rec.PMR_ID,
65: l_cgm_rec.OBJECT_VERSION_NUMBER,

Line 71: x_no_data_found := okl_cntx_grp_prmtrs_b_pk_csr%NOTFOUND;

67: l_cgm_rec.CREATION_DATE,
68: l_cgm_rec.LAST_UPDATED_BY,
69: l_cgm_rec.LAST_UPDATE_DATE,
70: l_cgm_rec.LAST_UPDATE_LOGIN;
71: x_no_data_found := okl_cntx_grp_prmtrs_b_pk_csr%NOTFOUND;
72: CLOSE okl_cntx_grp_prmtrs_b_pk_csr;
73: RETURN(l_cgm_rec);
74: END get_rec;
75:

Line 72: CLOSE okl_cntx_grp_prmtrs_b_pk_csr;

68: l_cgm_rec.LAST_UPDATED_BY,
69: l_cgm_rec.LAST_UPDATE_DATE,
70: l_cgm_rec.LAST_UPDATE_LOGIN;
71: x_no_data_found := okl_cntx_grp_prmtrs_b_pk_csr%NOTFOUND;
72: CLOSE okl_cntx_grp_prmtrs_b_pk_csr;
73: RETURN(l_cgm_rec);
74: END get_rec;
75:
76: FUNCTION get_rec (

Line 84: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS_V

80: BEGIN
81: RETURN(get_rec(p_cgm_rec, l_row_notfound));
82: END get_rec;
83: ---------------------------------------------------------------------------
84: -- FUNCTION get_rec for: OKL_CNTX_GRP_PRMTRS_V
85: ---------------------------------------------------------------------------
86: FUNCTION get_rec (
87: p_cgmv_rec IN cgmv_rec_type,
88: x_no_data_found OUT NOCOPY BOOLEAN

Line 101: FROM Okl_Cntx_Grp_Prmtrs_V

97: CREATION_DATE,
98: LAST_UPDATED_BY,
99: LAST_UPDATE_DATE,
100: LAST_UPDATE_LOGIN
101: FROM Okl_Cntx_Grp_Prmtrs_V
102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;
103: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
104: l_cgmv_rec cgmv_rec_type;
105: BEGIN

Line 102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;

98: LAST_UPDATED_BY,
99: LAST_UPDATE_DATE,
100: LAST_UPDATE_LOGIN
101: FROM Okl_Cntx_Grp_Prmtrs_V
102: WHERE okl_cntx_grp_prmtrs_v.id = p_id;
103: l_okl_cgmv_pk okl_cgmv_pk_csr%ROWTYPE;
104: l_cgmv_rec cgmv_rec_type;
105: BEGIN
106: x_no_data_found := TRUE;

Line 133: -- FUNCTION null_out_defaults for: OKL_CNTX_GRP_PRMTRS_V --

129: RETURN(get_rec(p_cgmv_rec, l_row_notfound));
130: END get_rec;
131:
132: -----------------------------------------------------------
133: -- FUNCTION null_out_defaults for: OKL_CNTX_GRP_PRMTRS_V --
134: -----------------------------------------------------------
135: FUNCTION null_out_defaults (
136: p_cgmv_rec IN cgmv_rec_type
137: ) RETURN cgmv_rec_type IS

Line 173: -- Validate_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

169: ---------------------------------------------------------------------------
170: -- PROCEDURE Validate_Attributes
171: ---------------------------------------------------------------------------
172: ---------------------------------------------------
173: -- Validate_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
174: ---------------------------------------------------
175: FUNCTION Validate_Attributes (
176: p_cgmv_rec IN cgmv_rec_type
177: ) RETURN VARCHAR2 IS

Line 208: -- Validate_Record for:OKL_CNTX_GRP_PRMTRS_V --

204: ---------------------------------------------------------------------------
205: -- PROCEDURE Validate_Record
206: ---------------------------------------------------------------------------
207: -----------------------------------------------
208: -- Validate_Record for:OKL_CNTX_GRP_PRMTRS_V --
209: -----------------------------------------------
210: FUNCTION Validate_Record (
211: p_cgmv_rec IN cgmv_rec_type
212: ) RETURN VARCHAR2 IS

Line 297: CURSOR okl_pmrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.pmr_id%TYPE) IS

293: l_dummy VARCHAR2(1) := '?';
294: l_row_not_found Boolean := False;
295:
296: -- Cursor For OKL_CGM_PMR_FK - Foreign Key Constraint
297: CURSOR okl_pmrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.pmr_id%TYPE) IS
298: SELECT '1'
299: FROM OKL_PARAMETERS_V
300: WHERE OKL_PARAMETERS_V.id = p_id;
301:

Line 369: CURSOR okl_cgrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.cgr_id%TYPE) IS

365: l_dummy VARCHAR2(1) := '?';
366: l_row_not_found Boolean := False;
367:
368: -- Cursor For OKL_CGM_CGR_FK - Foreign Key Constraint
369: CURSOR okl_cgrv_pk_csr (p_id IN OKL_CNTX_GRP_PRMTRS_V.cgr_id%TYPE) IS
370: SELECT '1'
371: FROM OKL_CONTEXT_GROUPS_V
372: WHERE OKL_CONTEXT_GROUPS_V.id = p_id;
373:

Line 555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE

551: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
552: l_unq_tbl OKC_UTIL.unq_tbl_type;
553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v

Line 556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE

552: l_unq_tbl OKC_UTIL.unq_tbl_type;
553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id

Line 557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is

553: l_dummy VARCHAR2(1);
554: l_row_found Boolean := False;
555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id
561: and p_pmr_id = pmr_id

Line 559: FROM okl_cntx_grp_prmtrs_v

555: CURSOR c1( p_cgr_id okl_cntx_grp_prmtrs_v.cgr_id%TYPE
556: , p_pmr_id okl_cntx_grp_prmtrs_v.pmr_id%TYPE
557: , p_id okl_cntx_grp_prmtrs_v.id%TYPE ) is
558: SELECT 1
559: FROM okl_cntx_grp_prmtrs_v
560: WHERE p_cgr_id = cgr_id
561: and p_pmr_id = pmr_id
562: and id <> nvl( p_cgmv_rec.id, -9999 );
563:

Line 574: OKC_API.set_message( G_APP_NAME, G_UNQS, G_TABLE_TOKEN, 'Okl_Cntx_Grp_Prmtrs_V' );

570: FETCH c1 into l_dummy;
571: l_row_found := c1%FOUND;
572: CLOSE c1;
573: IF l_row_found then
574: OKC_API.set_message( G_APP_NAME, G_UNQS, G_TABLE_TOKEN, 'Okl_Cntx_Grp_Prmtrs_V' );
575: x_return_status := OKC_API.G_RET_STS_ERROR;
576: END IF;
577:
578: EXCEPTION

Line 696: -- validate_row for:OKL_CNTX_GRP_PRMTRS_V --

692: ---------------------------------------------------------------------------
693: -- PROCEDURE validate_row
694: ---------------------------------------------------------------------------
695: --------------------------------------------
696: -- validate_row for:OKL_CNTX_GRP_PRMTRS_V --
697: --------------------------------------------
698: PROCEDURE validate_row(
699: p_api_version IN NUMBER,
700: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 851: -- insert_row for:OKL_CNTX_GRP_PRMTRS --

847: ---------------------------------------------------------------------------
848: -- PROCEDURE insert_row
849: ---------------------------------------------------------------------------
850: ----------------------------------------
851: -- insert_row for:OKL_CNTX_GRP_PRMTRS --
852: ----------------------------------------
853: PROCEDURE insert_row(
854: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
855: x_return_status OUT NOCOPY VARCHAR2,

Line 867: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS --

863: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
864: l_cgm_rec cgm_rec_type := p_cgm_rec;
865: l_def_cgm_rec cgm_rec_type;
866: --------------------------------------------
867: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS --
868: --------------------------------------------
869: FUNCTION Set_Attributes (
870: p_cgm_rec IN cgm_rec_type,
871: x_cgm_rec OUT NOCOPY cgm_rec_type

Line 898: INSERT INTO OKL_CNTX_GRP_PRMTRS(

894: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
895: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
896: RAISE OKC_API.G_EXCEPTION_ERROR;
897: END IF;
898: INSERT INTO OKL_CNTX_GRP_PRMTRS(
899: id,
900: cgr_id,
901: pmr_id,
902: object_version_number,

Line 954: -- insert_row for:OKL_CNTX_GRP_PRMTRS_V --

950: '_PVT'
951: );
952: END insert_row;
953: ------------------------------------------
954: -- insert_row for:OKL_CNTX_GRP_PRMTRS_V --
955: ------------------------------------------
956: PROCEDURE insert_row(
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 988: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

984: l_cgmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
985: RETURN(l_cgmv_rec);
986: END fill_who_columns;
987: ----------------------------------------------
988: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
989: ----------------------------------------------
990: FUNCTION Set_Attributes (
991: p_cgmv_rec IN cgmv_rec_type,
992: x_cgmv_rec OUT NOCOPY cgmv_rec_type

Line 1179: -- lock_row for:OKL_CNTX_GRP_PRMTRS --

1175: ---------------------------------------------------------------------------
1176: -- PROCEDURE lock_row
1177: ---------------------------------------------------------------------------
1178: --------------------------------------
1179: -- lock_row for:OKL_CNTX_GRP_PRMTRS --
1180: --------------------------------------
1181: PROCEDURE lock_row(
1182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1183: x_return_status OUT NOCOPY VARCHAR2,

Line 1192: FROM OKL_CNTX_GRP_PRMTRS

1188: E_Resource_Busy EXCEPTION;
1189: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1190: CURSOR lock_csr (p_cgm_rec IN cgm_rec_type) IS
1191: SELECT OBJECT_VERSION_NUMBER
1192: FROM OKL_CNTX_GRP_PRMTRS
1193: WHERE ID = p_cgm_rec.id
1194: AND OBJECT_VERSION_NUMBER = p_cgm_rec.object_version_number
1195: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1196:

Line 1199: FROM OKL_CNTX_GRP_PRMTRS

1195: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1196:
1197: CURSOR lchk_csr (p_cgm_rec IN cgm_rec_type) IS
1198: SELECT OBJECT_VERSION_NUMBER
1199: FROM OKL_CNTX_GRP_PRMTRS
1200: WHERE ID = p_cgm_rec.id;
1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'PRMTRS_lock_row';
1203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1204: l_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;

1200: WHERE ID = p_cgm_rec.id;
1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'PRMTRS_lock_row';
1203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1204: l_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;
1205: lc_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;
1206: l_row_notfound BOOLEAN := FALSE;
1207: lc_row_notfound BOOLEAN := FALSE;
1208: BEGIN

Line 1205: lc_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;

1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'PRMTRS_lock_row';
1203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1204: l_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;
1205: lc_object_version_number OKL_CNTX_GRP_PRMTRS.OBJECT_VERSION_NUMBER%TYPE;
1206: l_row_notfound BOOLEAN := FALSE;
1207: lc_row_notfound BOOLEAN := FALSE;
1208: BEGIN
1209: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1285: -- lock_row for:OKL_CNTX_GRP_PRMTRS_V --

1281: '_PVT'
1282: );
1283: END lock_row;
1284: ----------------------------------------
1285: -- lock_row for:OKL_CNTX_GRP_PRMTRS_V --
1286: ----------------------------------------
1287: PROCEDURE lock_row(
1288: p_api_version IN NUMBER,
1289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1444: -- update_row for:OKL_CNTX_GRP_PRMTRS --

1440: ---------------------------------------------------------------------------
1441: -- PROCEDURE update_row
1442: ---------------------------------------------------------------------------
1443: ----------------------------------------
1444: -- update_row for:OKL_CNTX_GRP_PRMTRS --
1445: ----------------------------------------
1446: PROCEDURE update_row(
1447: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1448: x_return_status OUT NOCOPY VARCHAR2,

Line 1516: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS --

1512: END IF;
1513: RETURN(l_return_status);
1514: END populate_new_record;
1515: --------------------------------------------
1516: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS --
1517: --------------------------------------------
1518: FUNCTION Set_Attributes (
1519: p_cgm_rec IN cgm_rec_type,
1520: x_cgm_rec OUT NOCOPY cgm_rec_type

Line 1553: UPDATE OKL_CNTX_GRP_PRMTRS

1549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1551: RAISE OKC_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: UPDATE OKL_CNTX_GRP_PRMTRS
1554: SET CGR_ID = l_def_cgm_rec.cgr_id,
1555: PMR_ID = l_def_cgm_rec.pmr_id,
1556: OBJECT_VERSION_NUMBER = l_def_cgm_rec.object_version_number,
1557: CREATED_BY = l_def_cgm_rec.created_by,

Line 1599: -- update_row for:OKL_CNTX_GRP_PRMTRS_V --

1595: '_PVT'
1596: );
1597: END update_row;
1598: ------------------------------------------
1599: -- update_row for:OKL_CNTX_GRP_PRMTRS_V --
1600: ------------------------------------------
1601: PROCEDURE update_row(
1602: p_api_version IN NUMBER,
1603: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1686: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --

1682: END IF;
1683: RETURN(l_return_status);
1684: END populate_new_record;
1685: ----------------------------------------------
1686: -- Set_Attributes for:OKL_CNTX_GRP_PRMTRS_V --
1687: ----------------------------------------------
1688: FUNCTION Set_Attributes (
1689: p_cgmv_rec IN cgmv_rec_type,
1690: x_cgmv_rec OUT NOCOPY cgmv_rec_type

Line 1880: -- delete_row for:OKL_CNTX_GRP_PRMTRS --

1876: ---------------------------------------------------------------------------
1877: -- PROCEDURE delete_row
1878: ---------------------------------------------------------------------------
1879: ----------------------------------------
1880: -- delete_row for:OKL_CNTX_GRP_PRMTRS --
1881: ----------------------------------------
1882: PROCEDURE delete_row(
1883: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1884: x_return_status OUT NOCOPY VARCHAR2,

Line 1904: DELETE FROM OKL_CNTX_GRP_PRMTRS

1900: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1901: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1902: RAISE OKC_API.G_EXCEPTION_ERROR;
1903: END IF;
1904: DELETE FROM OKL_CNTX_GRP_PRMTRS
1905: WHERE ID = l_cgm_rec.id;
1906:
1907: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1908: EXCEPTION

Line 1941: -- delete_row for:OKL_CNTX_GRP_PRMTRS_V --

1937: '_PVT'
1938: );
1939: END delete_row;
1940: ------------------------------------------
1941: -- delete_row for:OKL_CNTX_GRP_PRMTRS_V --
1942: ------------------------------------------
1943: PROCEDURE delete_row(
1944: p_api_version IN NUMBER,
1945: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2123: from OKL_CNTX_GRP_PRMTRS

2119: f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);
2120: BEGIN
2121: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
2122: into id, db_luby, db_ludate
2123: from OKL_CNTX_GRP_PRMTRS
2124: where ID = p_cntx_grp_prmtr_id;
2125:
2126: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2127: db_ludate, '')) then

Line 2128: UPDATE OKL_CNTX_GRP_PRMTRS

2124: where ID = p_cntx_grp_prmtr_id;
2125:
2126: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2127: db_ludate, '')) then
2128: UPDATE OKL_CNTX_GRP_PRMTRS
2129: SET
2130: cgr_id = TO_NUMBER(p_cgr_id),
2131: pmr_id = TO_NUMBER(p_pmr_id),
2132: object_version_number = TO_NUMBER(p_object_version_number),

Line 2141: INSERT INTO OKL_CNTX_GRP_PRMTRS

2137: END IF;
2138: END;
2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN
2141: INSERT INTO OKL_CNTX_GRP_PRMTRS
2142: (
2143: ID,
2144: CGR_ID,
2145: PMR_ID,