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_RSC_PVT dependencies on OKC_ROLE_SOURCES

Line 45: -- FUNCTION get_rec for: OKC_ROLE_SOURCES

41: null;
42: END api_copy;
43:
44: ---------------------------------------------------------------------------
45: -- FUNCTION get_rec for: OKC_ROLE_SOURCES
46: ---------------------------------------------------------------------------
47: FUNCTION get_rec (
48: p_rsc_rec IN rsc_rec_type,
49: x_no_data_found OUT NOCOPY BOOLEAN

Line 67: FROM Okc_Role_Sources

63: LAST_UPDATED_BY,
64: LAST_UPDATE_DATE,
65: LAST_UPDATE_LOGIN,
66: ACCESS_LEVEL
67: FROM Okc_Role_Sources
68: WHERE okc_role_sources.rle_code = p_rle_code
69: AND okc_role_sources.buy_or_sell = p_buy_or_sell
70: AND okc_role_sources.start_date = p_start_date;
71: l_rsc_pk rsc_pk_csr%ROWTYPE;

Line 68: WHERE okc_role_sources.rle_code = p_rle_code

64: LAST_UPDATE_DATE,
65: LAST_UPDATE_LOGIN,
66: ACCESS_LEVEL
67: FROM Okc_Role_Sources
68: WHERE okc_role_sources.rle_code = p_rle_code
69: AND okc_role_sources.buy_or_sell = p_buy_or_sell
70: AND okc_role_sources.start_date = p_start_date;
71: l_rsc_pk rsc_pk_csr%ROWTYPE;
72: l_rsc_rec rsc_rec_type;

Line 69: AND okc_role_sources.buy_or_sell = p_buy_or_sell

65: LAST_UPDATE_LOGIN,
66: ACCESS_LEVEL
67: FROM Okc_Role_Sources
68: WHERE okc_role_sources.rle_code = p_rle_code
69: AND okc_role_sources.buy_or_sell = p_buy_or_sell
70: AND okc_role_sources.start_date = p_start_date;
71: l_rsc_pk rsc_pk_csr%ROWTYPE;
72: l_rsc_rec rsc_rec_type;
73: BEGIN

Line 70: AND okc_role_sources.start_date = p_start_date;

66: ACCESS_LEVEL
67: FROM Okc_Role_Sources
68: WHERE okc_role_sources.rle_code = p_rle_code
69: AND okc_role_sources.buy_or_sell = p_buy_or_sell
70: AND okc_role_sources.start_date = p_start_date;
71: l_rsc_pk rsc_pk_csr%ROWTYPE;
72: l_rsc_rec rsc_rec_type;
73: BEGIN
74: x_no_data_found := TRUE;

Line 105: -- FUNCTION get_rec for: OKC_ROLE_SOURCES_V

101: BEGIN
102: RETURN(get_rec(p_rsc_rec, l_row_notfound));
103: END get_rec;
104: ---------------------------------------------------------------------------
105: -- FUNCTION get_rec for: OKC_ROLE_SOURCES_V
106: ---------------------------------------------------------------------------
107: FUNCTION get_rec (
108: p_rscv_rec IN rscv_rec_type,
109: x_no_data_found OUT NOCOPY BOOLEAN

Line 127: FROM Okc_Role_Sources

123: LAST_UPDATED_BY,
124: LAST_UPDATE_DATE,
125: LAST_UPDATE_LOGIN,
126: ACCESS_LEVEL
127: FROM Okc_Role_Sources
128: WHERE okc_role_sources.rle_code = p_rle_code
129: AND okc_role_sources.buy_or_sell = p_buy_or_sell
130: AND okc_role_sources.start_date = p_start_date;
131: l_okc_rscv_pk okc_rscv_pk_csr%ROWTYPE;

Line 128: WHERE okc_role_sources.rle_code = p_rle_code

124: LAST_UPDATE_DATE,
125: LAST_UPDATE_LOGIN,
126: ACCESS_LEVEL
127: FROM Okc_Role_Sources
128: WHERE okc_role_sources.rle_code = p_rle_code
129: AND okc_role_sources.buy_or_sell = p_buy_or_sell
130: AND okc_role_sources.start_date = p_start_date;
131: l_okc_rscv_pk okc_rscv_pk_csr%ROWTYPE;
132: l_rscv_rec rscv_rec_type;

Line 129: AND okc_role_sources.buy_or_sell = p_buy_or_sell

125: LAST_UPDATE_LOGIN,
126: ACCESS_LEVEL
127: FROM Okc_Role_Sources
128: WHERE okc_role_sources.rle_code = p_rle_code
129: AND okc_role_sources.buy_or_sell = p_buy_or_sell
130: AND okc_role_sources.start_date = p_start_date;
131: l_okc_rscv_pk okc_rscv_pk_csr%ROWTYPE;
132: l_rscv_rec rscv_rec_type;
133: BEGIN

Line 130: AND okc_role_sources.start_date = p_start_date;

126: ACCESS_LEVEL
127: FROM Okc_Role_Sources
128: WHERE okc_role_sources.rle_code = p_rle_code
129: AND okc_role_sources.buy_or_sell = p_buy_or_sell
130: AND okc_role_sources.start_date = p_start_date;
131: l_okc_rscv_pk okc_rscv_pk_csr%ROWTYPE;
132: l_rscv_rec rscv_rec_type;
133: BEGIN
134: x_no_data_found := TRUE;

Line 166: -- FUNCTION null_out_defaults for: OKC_ROLE_SOURCES_V --

162: RETURN(get_rec(p_rscv_rec, l_row_notfound));
163: END get_rec;
164:
165: --------------------------------------------------------
166: -- FUNCTION null_out_defaults for: OKC_ROLE_SOURCES_V --
167: --------------------------------------------------------
168: FUNCTION null_out_defaults (
169: p_rscv_rec IN rscv_rec_type
170: ) RETURN rscv_rec_type IS

Line 410: -- Validate_Attributes for:OKC_ROLE_SOURCES_V --

406:
407: /*+++++++++++++End of hand code +++++++++++++++++++*/
408:
409: ------------------------------------------------
410: -- Validate_Attributes for:OKC_ROLE_SOURCES_V --
411: ------------------------------------------------
412: FUNCTION Validate_Attributes (
413: p_rscv_rec IN rscv_rec_type
414: ) RETURN VARCHAR2 IS

Line 519: -- Validate_Record for:OKC_ROLE_SOURCES_V --

515: ---------------------------------------------------------------------------
516: -- PROCEDURE Validate_Record
517: ---------------------------------------------------------------------------
518: --------------------------------------------
519: -- Validate_Record for:OKC_ROLE_SOURCES_V --
520: --------------------------------------------
521: FUNCTION Validate_Record (
522: p_rscv_rec IN rscv_rec_type
523: --+++++++++++++++Start handcode +++++++++++++++++++++++++++++++++++

Line 536: select '!' from okc_role_sources

532: ---------------End of the commented code-----------*/
533: /*+++++++++++++Start of hand code +++++++++++++++++*/
534: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
535: cursor pk_csr is
536: select '!' from okc_role_sources
537: where rle_code = p_rscv_rec.rle_code
538: and buy_or_sell = p_rscv_rec.buy_or_sell
539: and start_date = p_rscv_rec.start_date;
540: l_dummy varchar2(1) := '?';

Line 623: -- validate_row for:OKC_ROLE_SOURCES_V --

619: ---------------------------------------------------------------------------
620: -- PROCEDURE validate_row
621: ---------------------------------------------------------------------------
622: -----------------------------------------
623: -- validate_row for:OKC_ROLE_SOURCES_V --
624: -----------------------------------------
625: PROCEDURE validate_row(
626: p_api_version IN NUMBER,
627: p_init_msg_list IN VARCHAR2,

Line 767: -- insert_row for:OKC_ROLE_SOURCES --

763: ---------------------------------------------------------------------------
764: -- PROCEDURE insert_row
765: ---------------------------------------------------------------------------
766: -------------------------------------
767: -- insert_row for:OKC_ROLE_SOURCES --
768: -------------------------------------
769: PROCEDURE insert_row(
770: p_init_msg_list IN VARCHAR2,
771: x_return_status OUT NOCOPY VARCHAR2,

Line 783: -- Set_Attributes for:OKC_ROLE_SOURCES --

779: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
780: l_rsc_rec rsc_rec_type := p_rsc_rec;
781: l_def_rsc_rec rsc_rec_type;
782: -----------------------------------------
783: -- Set_Attributes for:OKC_ROLE_SOURCES --
784: -----------------------------------------
785: FUNCTION Set_Attributes (
786: p_rsc_rec IN rsc_rec_type,
787: x_rsc_rec OUT NOCOPY rsc_rec_type

Line 814: INSERT INTO OKC_ROLE_SOURCES(

810: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
811: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
812: RAISE OKC_API.G_EXCEPTION_ERROR;
813: END IF;
814: INSERT INTO OKC_ROLE_SOURCES(
815: rle_code,
816: buy_or_sell,
817: start_date,
818: end_date,

Line 876: -- insert_row for:OKC_ROLE_SOURCES_V --

872: '_PVT'
873: );
874: END insert_row;
875: ---------------------------------------
876: -- insert_row for:OKC_ROLE_SOURCES_V --
877: ---------------------------------------
878: PROCEDURE insert_row(
879: p_api_version IN NUMBER,
880: p_init_msg_list IN VARCHAR2,

Line 910: -- Set_Attributes for:OKC_ROLE_SOURCES_V --

906: l_rscv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
907: RETURN(l_rscv_rec);
908: END fill_who_columns;
909: -------------------------------------------
910: -- Set_Attributes for:OKC_ROLE_SOURCES_V --
911: -------------------------------------------
912: FUNCTION Set_Attributes (
913: p_rscv_rec IN rscv_rec_type,
914: x_rscv_rec OUT NOCOPY rscv_rec_type

Line 1093: -- lock_row for:OKC_ROLE_SOURCES --

1089: ---------------------------------------------------------------------------
1090: -- PROCEDURE lock_row
1091: ---------------------------------------------------------------------------
1092: -----------------------------------
1093: -- lock_row for:OKC_ROLE_SOURCES --
1094: -----------------------------------
1095: PROCEDURE lock_row(
1096: p_init_msg_list IN VARCHAR2,
1097: x_return_status OUT NOCOPY VARCHAR2,

Line 1106: FROM OKC_ROLE_SOURCES

1102: E_Resource_Busy EXCEPTION;
1103: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1104: CURSOR lock_csr (p_rsc_rec IN rsc_rec_type) IS
1105: SELECT OBJECT_VERSION_NUMBER
1106: FROM OKC_ROLE_SOURCES
1107: WHERE RLE_CODE = p_rsc_rec.rle_code
1108: AND BUY_OR_SELL = p_rsc_rec.buy_or_sell
1109: AND START_DATE = p_rsc_rec.start_date
1110: AND OBJECT_VERSION_NUMBER = p_rsc_rec.object_version_number

Line 1115: FROM OKC_ROLE_SOURCES

1111: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1112:
1113: CURSOR lchk_csr (p_rsc_rec IN rsc_rec_type) IS
1114: SELECT OBJECT_VERSION_NUMBER
1115: FROM OKC_ROLE_SOURCES
1116: WHERE RLE_CODE = p_rsc_rec.rle_code
1117: AND BUY_OR_SELL = p_rsc_rec.buy_or_sell
1118: AND START_DATE = p_rsc_rec.start_date;
1119: l_api_version CONSTANT NUMBER := 1;

Line 1122: l_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1118: AND START_DATE = p_rsc_rec.start_date;
1119: l_api_version CONSTANT NUMBER := 1;
1120: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1121: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: l_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1123: lc_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1124: l_row_notfound BOOLEAN := FALSE;
1125: lc_row_notfound BOOLEAN := FALSE;
1126: BEGIN

Line 1123: lc_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1119: l_api_version CONSTANT NUMBER := 1;
1120: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1121: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1122: l_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1123: lc_object_version_number OKC_ROLE_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1124: l_row_notfound BOOLEAN := FALSE;
1125: lc_row_notfound BOOLEAN := FALSE;
1126: BEGIN
1127: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1203: -- lock_row for:OKC_ROLE_SOURCES_V --

1199: '_PVT'
1200: );
1201: END lock_row;
1202: -------------------------------------
1203: -- lock_row for:OKC_ROLE_SOURCES_V --
1204: -------------------------------------
1205: PROCEDURE lock_row(
1206: p_api_version IN NUMBER,
1207: p_init_msg_list IN VARCHAR2,

Line 1351: -- update_row for:OKC_ROLE_SOURCES --

1347: ---------------------------------------------------------------------------
1348: -- PROCEDURE update_row
1349: ---------------------------------------------------------------------------
1350: -------------------------------------
1351: -- update_row for:OKC_ROLE_SOURCES --
1352: -------------------------------------
1353: PROCEDURE update_row(
1354: p_init_msg_list IN VARCHAR2,
1355: x_return_status OUT NOCOPY VARCHAR2,

Line 1435: -- Set_Attributes for:OKC_ROLE_SOURCES --

1431: END IF;
1432: RETURN(l_return_status);
1433: END populate_new_record;
1434: -----------------------------------------
1435: -- Set_Attributes for:OKC_ROLE_SOURCES --
1436: -----------------------------------------
1437: FUNCTION Set_Attributes (
1438: p_rsc_rec IN rsc_rec_type,
1439: x_rsc_rec OUT NOCOPY rsc_rec_type

Line 1472: UPDATE OKC_ROLE_SOURCES

1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: UPDATE OKC_ROLE_SOURCES
1473: SET END_DATE = l_def_rsc_rec.end_date,
1474: JTOT_OBJECT_CODE = l_def_rsc_rec.JTOT_OBJECT_CODE,
1475: OBJECT_VERSION_NUMBER = l_def_rsc_rec.object_version_number,
1476: CREATED_BY = l_def_rsc_rec.created_by,

Line 1521: -- update_row for:OKC_ROLE_SOURCES_V --

1517: '_PVT'
1518: );
1519: END update_row;
1520: ---------------------------------------
1521: -- update_row for:OKC_ROLE_SOURCES_V --
1522: ---------------------------------------
1523: PROCEDURE update_row(
1524: p_api_version IN NUMBER,
1525: p_init_msg_list IN VARCHAR2,

Line 1620: -- Set_Attributes for:OKC_ROLE_SOURCES_V --

1616: END IF;
1617: RETURN(l_return_status);
1618: END populate_new_record;
1619: -------------------------------------------
1620: -- Set_Attributes for:OKC_ROLE_SOURCES_V --
1621: -------------------------------------------
1622: FUNCTION Set_Attributes (
1623: p_rscv_rec IN rscv_rec_type,
1624: x_rscv_rec OUT NOCOPY rscv_rec_type

Line 1803: -- delete_row for:OKC_ROLE_SOURCES --

1799: ---------------------------------------------------------------------------
1800: -- PROCEDURE delete_row
1801: ---------------------------------------------------------------------------
1802: -------------------------------------
1803: -- delete_row for:OKC_ROLE_SOURCES --
1804: -------------------------------------
1805: PROCEDURE delete_row(
1806: p_init_msg_list IN VARCHAR2,
1807: x_return_status OUT NOCOPY VARCHAR2,

Line 1827: DELETE FROM OKC_ROLE_SOURCES

1823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1825: RAISE OKC_API.G_EXCEPTION_ERROR;
1826: END IF;
1827: DELETE FROM OKC_ROLE_SOURCES
1828: WHERE RLE_CODE = l_rsc_rec.rle_code AND
1829: BUY_OR_SELL = l_rsc_rec.buy_or_sell AND
1830: START_DATE = l_rsc_rec.start_date;
1831:

Line 1866: -- delete_row for:OKC_ROLE_SOURCES_V --

1862: '_PVT'
1863: );
1864: END delete_row;
1865: ---------------------------------------
1866: -- delete_row for:OKC_ROLE_SOURCES_V --
1867: ---------------------------------------
1868: PROCEDURE delete_row(
1869: p_api_version IN NUMBER,
1870: p_init_msg_list IN VARCHAR2,