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_CSO_PVT dependencies on OKC_CONTACT_SOURCES

Line 45: -- FUNCTION get_rec for: OKC_CONTACT_SOURCES

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

Line 70: FROM Okc_Contact_Sources

66: LAST_UPDATE_DATE,
67: CONSTRAINED_YN,
68: LAST_UPDATE_LOGIN,
69: ACCESS_LEVEL
70: FROM Okc_Contact_Sources
71: WHERE okc_contact_sources.cro_code = p_cro_code
72: AND okc_contact_sources.rle_code = p_rle_code
73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
74: AND okc_contact_sources.start_date = p_start_date;

Line 71: WHERE okc_contact_sources.cro_code = p_cro_code

67: CONSTRAINED_YN,
68: LAST_UPDATE_LOGIN,
69: ACCESS_LEVEL
70: FROM Okc_Contact_Sources
71: WHERE okc_contact_sources.cro_code = p_cro_code
72: AND okc_contact_sources.rle_code = p_rle_code
73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
74: AND okc_contact_sources.start_date = p_start_date;
75: l_cso_pk cso_pk_csr%ROWTYPE;

Line 72: AND okc_contact_sources.rle_code = p_rle_code

68: LAST_UPDATE_LOGIN,
69: ACCESS_LEVEL
70: FROM Okc_Contact_Sources
71: WHERE okc_contact_sources.cro_code = p_cro_code
72: AND okc_contact_sources.rle_code = p_rle_code
73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
74: AND okc_contact_sources.start_date = p_start_date;
75: l_cso_pk cso_pk_csr%ROWTYPE;
76: l_cso_rec cso_rec_type;

Line 73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell

69: ACCESS_LEVEL
70: FROM Okc_Contact_Sources
71: WHERE okc_contact_sources.cro_code = p_cro_code
72: AND okc_contact_sources.rle_code = p_rle_code
73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
74: AND okc_contact_sources.start_date = p_start_date;
75: l_cso_pk cso_pk_csr%ROWTYPE;
76: l_cso_rec cso_rec_type;
77: BEGIN

Line 74: AND okc_contact_sources.start_date = p_start_date;

70: FROM Okc_Contact_Sources
71: WHERE okc_contact_sources.cro_code = p_cro_code
72: AND okc_contact_sources.rle_code = p_rle_code
73: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
74: AND okc_contact_sources.start_date = p_start_date;
75: l_cso_pk cso_pk_csr%ROWTYPE;
76: l_cso_rec cso_rec_type;
77: BEGIN
78: x_no_data_found := TRUE;

Line 112: -- FUNCTION get_rec for: OKC_CONTACT_SOURCES_V

108: BEGIN
109: RETURN(get_rec(p_cso_rec, l_row_notfound));
110: END get_rec;
111: ---------------------------------------------------------------------------
112: -- FUNCTION get_rec for: OKC_CONTACT_SOURCES_V
113: ---------------------------------------------------------------------------
114: FUNCTION get_rec (
115: p_csov_rec IN csov_rec_type,
116: x_no_data_found OUT NOCOPY BOOLEAN

Line 137: FROM Okc_Contact_Sources

133: LAST_UPDATED_BY,
134: LAST_UPDATE_DATE,
135: LAST_UPDATE_LOGIN,
136: ACCESS_LEVEL
137: FROM Okc_Contact_Sources
138: WHERE okc_contact_sources.rle_code = p_rle_code
139: AND okc_contact_sources.cro_code = p_cro_code
140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
141: AND okc_contact_sources.start_date = p_start_date;

Line 138: WHERE okc_contact_sources.rle_code = p_rle_code

134: LAST_UPDATE_DATE,
135: LAST_UPDATE_LOGIN,
136: ACCESS_LEVEL
137: FROM Okc_Contact_Sources
138: WHERE okc_contact_sources.rle_code = p_rle_code
139: AND okc_contact_sources.cro_code = p_cro_code
140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
141: AND okc_contact_sources.start_date = p_start_date;
142: l_okc_csov_pk okc_csov_pk_csr%ROWTYPE;

Line 139: AND okc_contact_sources.cro_code = p_cro_code

135: LAST_UPDATE_LOGIN,
136: ACCESS_LEVEL
137: FROM Okc_Contact_Sources
138: WHERE okc_contact_sources.rle_code = p_rle_code
139: AND okc_contact_sources.cro_code = p_cro_code
140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
141: AND okc_contact_sources.start_date = p_start_date;
142: l_okc_csov_pk okc_csov_pk_csr%ROWTYPE;
143: l_csov_rec csov_rec_type;

Line 140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell

136: ACCESS_LEVEL
137: FROM Okc_Contact_Sources
138: WHERE okc_contact_sources.rle_code = p_rle_code
139: AND okc_contact_sources.cro_code = p_cro_code
140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
141: AND okc_contact_sources.start_date = p_start_date;
142: l_okc_csov_pk okc_csov_pk_csr%ROWTYPE;
143: l_csov_rec csov_rec_type;
144: BEGIN

Line 141: AND okc_contact_sources.start_date = p_start_date;

137: FROM Okc_Contact_Sources
138: WHERE okc_contact_sources.rle_code = p_rle_code
139: AND okc_contact_sources.cro_code = p_cro_code
140: AND okc_contact_sources.buy_or_sell = p_buy_or_sell
141: AND okc_contact_sources.start_date = p_start_date;
142: l_okc_csov_pk okc_csov_pk_csr%ROWTYPE;
143: l_csov_rec csov_rec_type;
144: BEGIN
145: x_no_data_found := TRUE;

Line 180: -- FUNCTION null_out_defaults for: OKC_CONTACT_SOURCES_V --

176: RETURN(get_rec(p_csov_rec, l_row_notfound));
177: END get_rec;
178:
179: -----------------------------------------------------------
180: -- FUNCTION null_out_defaults for: OKC_CONTACT_SOURCES_V --
181: -----------------------------------------------------------
182: FUNCTION null_out_defaults (
183: p_csov_rec IN csov_rec_type
184: ) RETURN csov_rec_type IS

Line 504: -- Validate_Attributes for:OKC_CONTACT_SOURCES_V --

500: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
501: end validate_JTOT_OBJECT_CODE;
502: /*+++++++++++++End of hand code +++++++++++++++++++*/
503: ---------------------------------------------------
504: -- Validate_Attributes for:OKC_CONTACT_SOURCES_V --
505: ---------------------------------------------------
506: FUNCTION Validate_Attributes (
507: p_csov_rec IN csov_rec_type
508: ) RETURN VARCHAR2 IS

Line 647: -- Validate_Record for:OKC_CONTACT_SOURCES_V --

643: ---------------------------------------------------------------------------
644: -- PROCEDURE Validate_Record
645: ---------------------------------------------------------------------------
646: -----------------------------------------------
647: -- Validate_Record for:OKC_CONTACT_SOURCES_V --
648: -----------------------------------------------
649: FUNCTION Validate_Record (
650: p_csov_rec IN csov_rec_type
651: --+++++++++++++++Start handcode +++++++++++++++++++++++++++++++++++

Line 722: select '!' from okc_contact_sources

718: ---------------End of the commented code-----------*/
719: /*+++++++++++++Start of hand code +++++++++++++++++*/
720: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
721: cursor pk_csr is
722: select '!' from okc_contact_sources
723: where rle_code = p_csov_rec.rle_code
724: and cro_code = p_csov_rec.cro_code
725: and buy_or_sell = p_csov_rec.buy_or_sell
726: and start_date = p_csov_rec.start_date;

Line 815: -- validate_row for:OKC_CONTACT_SOURCES_V --

811: ---------------------------------------------------------------------------
812: -- PROCEDURE validate_row
813: ---------------------------------------------------------------------------
814: --------------------------------------------
815: -- validate_row for:OKC_CONTACT_SOURCES_V --
816: --------------------------------------------
817: PROCEDURE validate_row(
818: p_api_version IN NUMBER,
819: p_init_msg_list IN VARCHAR2 ,

Line 959: -- insert_row for:OKC_CONTACT_SOURCES --

955: ---------------------------------------------------------------------------
956: -- PROCEDURE insert_row
957: ---------------------------------------------------------------------------
958: ----------------------------------------
959: -- insert_row for:OKC_CONTACT_SOURCES --
960: ----------------------------------------
961: PROCEDURE insert_row(
962: p_init_msg_list IN VARCHAR2 ,
963: x_return_status OUT NOCOPY VARCHAR2,

Line 975: -- Set_Attributes for:OKC_CONTACT_SOURCES --

971: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
972: l_cso_rec cso_rec_type := p_cso_rec;
973: l_def_cso_rec cso_rec_type;
974: --------------------------------------------
975: -- Set_Attributes for:OKC_CONTACT_SOURCES --
976: --------------------------------------------
977: FUNCTION Set_Attributes (
978: p_cso_rec IN cso_rec_type,
979: x_cso_rec OUT NOCOPY cso_rec_type

Line 1006: INSERT INTO OKC_CONTACT_SOURCES(

1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_ERROR;
1005: END IF;
1006: INSERT INTO OKC_CONTACT_SOURCES(
1007: cro_code,
1008: rle_code,
1009: buy_or_sell,
1010: start_date,

Line 1072: -- insert_row for:OKC_CONTACT_SOURCES_V --

1068: '_PVT'
1069: );
1070: END insert_row;
1071: ------------------------------------------
1072: -- insert_row for:OKC_CONTACT_SOURCES_V --
1073: ------------------------------------------
1074: PROCEDURE insert_row(
1075: p_api_version IN NUMBER,
1076: p_init_msg_list IN VARCHAR2 ,

Line 1106: -- Set_Attributes for:OKC_CONTACT_SOURCES_V --

1102: l_csov_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1103: RETURN(l_csov_rec);
1104: END fill_who_columns;
1105: ----------------------------------------------
1106: -- Set_Attributes for:OKC_CONTACT_SOURCES_V --
1107: ----------------------------------------------
1108: FUNCTION Set_Attributes (
1109: p_csov_rec IN csov_rec_type,
1110: x_csov_rec OUT NOCOPY csov_rec_type

Line 1289: -- lock_row for:OKC_CONTACT_SOURCES --

1285: ---------------------------------------------------------------------------
1286: -- PROCEDURE lock_row
1287: ---------------------------------------------------------------------------
1288: --------------------------------------
1289: -- lock_row for:OKC_CONTACT_SOURCES --
1290: --------------------------------------
1291: PROCEDURE lock_row(
1292: p_init_msg_list IN VARCHAR2 ,
1293: x_return_status OUT NOCOPY VARCHAR2,

Line 1302: FROM OKC_CONTACT_SOURCES

1298: E_Resource_Busy EXCEPTION;
1299: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1300: CURSOR lock_csr (p_cso_rec IN cso_rec_type) IS
1301: SELECT OBJECT_VERSION_NUMBER
1302: FROM OKC_CONTACT_SOURCES
1303: WHERE CRO_CODE = p_cso_rec.cro_code
1304: AND RLE_CODE = p_cso_rec.rle_code
1305: AND BUY_OR_SELL = p_cso_rec.buy_or_sell
1306: AND START_DATE = p_cso_rec.start_date

Line 1312: FROM OKC_CONTACT_SOURCES

1308: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1309:
1310: CURSOR lchk_csr (p_cso_rec IN cso_rec_type) IS
1311: SELECT OBJECT_VERSION_NUMBER
1312: FROM OKC_CONTACT_SOURCES
1313: WHERE CRO_CODE = p_cso_rec.cro_code
1314: AND RLE_CODE = p_cso_rec.rle_code
1315: AND BUY_OR_SELL = p_cso_rec.buy_or_sell
1316: AND START_DATE = p_cso_rec.start_date;

Line 1320: l_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1316: AND START_DATE = p_cso_rec.start_date;
1317: l_api_version CONSTANT NUMBER := 1;
1318: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1319: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1320: l_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1321: lc_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1322: l_row_notfound BOOLEAN := FALSE;
1323: lc_row_notfound BOOLEAN := FALSE;
1324: BEGIN

Line 1321: lc_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;

1317: l_api_version CONSTANT NUMBER := 1;
1318: l_api_name CONSTANT VARCHAR2(30) := 'SOURCES_lock_row';
1319: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1320: l_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1321: lc_object_version_number OKC_CONTACT_SOURCES.OBJECT_VERSION_NUMBER%TYPE;
1322: l_row_notfound BOOLEAN := FALSE;
1323: lc_row_notfound BOOLEAN := FALSE;
1324: BEGIN
1325: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1401: -- lock_row for:OKC_CONTACT_SOURCES_V --

1397: '_PVT'
1398: );
1399: END lock_row;
1400: ----------------------------------------
1401: -- lock_row for:OKC_CONTACT_SOURCES_V --
1402: ----------------------------------------
1403: PROCEDURE lock_row(
1404: p_api_version IN NUMBER,
1405: p_init_msg_list IN VARCHAR2 ,

Line 1549: -- update_row for:OKC_CONTACT_SOURCES --

1545: ---------------------------------------------------------------------------
1546: -- PROCEDURE update_row
1547: ---------------------------------------------------------------------------
1548: ----------------------------------------
1549: -- update_row for:OKC_CONTACT_SOURCES --
1550: ----------------------------------------
1551: PROCEDURE update_row(
1552: p_init_msg_list IN VARCHAR2 ,
1553: x_return_status OUT NOCOPY VARCHAR2,

Line 1641: -- Set_Attributes for:OKC_CONTACT_SOURCES --

1637: END IF;
1638: RETURN(l_return_status);
1639: END populate_new_record;
1640: --------------------------------------------
1641: -- Set_Attributes for:OKC_CONTACT_SOURCES --
1642: --------------------------------------------
1643: FUNCTION Set_Attributes (
1644: p_cso_rec IN cso_rec_type,
1645: x_cso_rec OUT NOCOPY cso_rec_type

Line 1678: UPDATE OKC_CONTACT_SOURCES

1674: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1675: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1676: RAISE OKC_API.G_EXCEPTION_ERROR;
1677: END IF;
1678: UPDATE OKC_CONTACT_SOURCES
1679: SET END_DATE = l_def_cso_rec.end_date,
1680: JTOT_OBJECT_CODE = l_def_cso_rec.JTOT_OBJECT_CODE,
1681: OBJECT_VERSION_NUMBER = l_def_cso_rec.object_version_number,
1682: CREATED_BY = l_def_cso_rec.created_by,

Line 1729: -- update_row for:OKC_CONTACT_SOURCES_V --

1725: '_PVT'
1726: );
1727: END update_row;
1728: ------------------------------------------
1729: -- update_row for:OKC_CONTACT_SOURCES_V --
1730: ------------------------------------------
1731: PROCEDURE update_row(
1732: p_api_version IN NUMBER,
1733: p_init_msg_list IN VARCHAR2 ,

Line 1836: -- Set_Attributes for:OKC_CONTACT_SOURCES_V --

1832: END IF;
1833: RETURN(l_return_status);
1834: END populate_new_record;
1835: ----------------------------------------------
1836: -- Set_Attributes for:OKC_CONTACT_SOURCES_V --
1837: ----------------------------------------------
1838: FUNCTION Set_Attributes (
1839: p_csov_rec IN csov_rec_type,
1840: x_csov_rec OUT NOCOPY csov_rec_type

Line 2019: -- delete_row for:OKC_CONTACT_SOURCES --

2015: ---------------------------------------------------------------------------
2016: -- PROCEDURE delete_row
2017: ---------------------------------------------------------------------------
2018: ----------------------------------------
2019: -- delete_row for:OKC_CONTACT_SOURCES --
2020: ----------------------------------------
2021: PROCEDURE delete_row(
2022: p_init_msg_list IN VARCHAR2 ,
2023: x_return_status OUT NOCOPY VARCHAR2,

Line 2043: DELETE FROM OKC_CONTACT_SOURCES

2039: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2040: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2041: RAISE OKC_API.G_EXCEPTION_ERROR;
2042: END IF;
2043: DELETE FROM OKC_CONTACT_SOURCES
2044: WHERE CRO_CODE = l_cso_rec.cro_code AND
2045: RLE_CODE = l_cso_rec.rle_code AND
2046: BUY_OR_SELL = l_cso_rec.buy_or_sell AND
2047: START_DATE = l_cso_rec.start_date;

Line 2083: -- delete_row for:OKC_CONTACT_SOURCES_V --

2079: '_PVT'
2080: );
2081: END delete_row;
2082: ------------------------------------------
2083: -- delete_row for:OKC_CONTACT_SOURCES_V --
2084: ------------------------------------------
2085: PROCEDURE delete_row(
2086: p_api_version IN NUMBER,
2087: p_init_msg_list IN VARCHAR2 ,