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_CTC_PVT dependencies on OKC_CONTACTS

Line 53: -- FUNCTION get_rec for: OKC_CONTACTS

49:
50: END api_copy;
51:
52: ---------------------------------------------------------------------------
53: -- FUNCTION get_rec for: OKC_CONTACTS
54: ---------------------------------------------------------------------------
55: FUNCTION get_rec (
56: p_ctc_rec IN ctc_rec_type,
57: x_no_data_found OUT NOCOPY BOOLEAN

Line 96: FROM Okc_Contacts

92: ATTRIBUTE14,
93: ATTRIBUTE15,
94: START_DATE,
95: END_DATE
96: FROM Okc_Contacts
97: WHERE okc_contacts.id = p_id;
98: l_ctc_pk ctc_pk_csr%ROWTYPE;
99: l_ctc_rec ctc_rec_type;
100: BEGIN

Line 97: WHERE okc_contacts.id = p_id;

93: ATTRIBUTE15,
94: START_DATE,
95: END_DATE
96: FROM Okc_Contacts
97: WHERE okc_contacts.id = p_id;
98: l_ctc_pk ctc_pk_csr%ROWTYPE;
99: l_ctc_rec ctc_rec_type;
100: BEGIN
101:

Line 169: -- FUNCTION get_rec for: OKC_CONTACTS_V

165: RETURN(get_rec(p_ctc_rec, l_row_notfound));
166:
167: END get_rec;
168: ---------------------------------------------------------------------------
169: -- FUNCTION get_rec for: OKC_CONTACTS_V
170: ---------------------------------------------------------------------------
171: FUNCTION get_rec (
172: p_ctcv_rec IN ctcv_rec_type,
173: x_no_data_found OUT NOCOPY BOOLEAN

Line 212: FROM Okc_Contacts

208: LAST_UPDATE_DATE,
209: LAST_UPDATE_LOGIN,
210: START_DATE,
211: END_DATE
212: FROM Okc_Contacts
213: WHERE okc_contacts.id = p_id;
214: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
215: l_ctcv_rec ctcv_rec_type;
216: BEGIN

Line 213: WHERE okc_contacts.id = p_id;

209: LAST_UPDATE_LOGIN,
210: START_DATE,
211: END_DATE
212: FROM Okc_Contacts
213: WHERE okc_contacts.id = p_id;
214: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
215: l_ctcv_rec ctcv_rec_type;
216: BEGIN
217:

Line 285: -- FUNCTION null_out_defaults for: OKC_CONTACTS_V --

281:
282: END get_rec;
283:
284: ----------------------------------------------------
285: -- FUNCTION null_out_defaults for: OKC_CONTACTS_V --
286: ----------------------------------------------------
287: FUNCTION null_out_defaults (
288: p_ctcv_rec IN ctcv_rec_type
289: ) RETURN ctcv_rec_type IS

Line 1086: FROM OKC_CONTACTS ctc

1082: l_dummy varchar2(1) := '?';
1083:
1084: CURSOR l_contacts_csr IS
1085: SELECT '!'
1086: FROM OKC_CONTACTS ctc
1087: WHERE id <> NVL(p_ctcv_rec.id,-99999)
1088: AND cpl_id = p_ctcv_rec.cpl_id
1089: AND dnz_chr_id = p_ctcv_rec.dnz_chr_id
1090: AND primary_yn = 'Y'

Line 1239: -- alidate_Attributes for:OKC_CONTACTS_V --

1235: End validate_resource_class;
1236:
1237: /*+++++++++++++End of hand code +++++++++++++++++++*/
1238: --------------------------------------------
1239: -- alidate_Attributes for:OKC_CONTACTS_V --
1240: --------------------------------------------
1241: FUNCTION Validate_Attributes (
1242: p_ctcv_rec IN ctcv_rec_type
1243: ) RETURN VARCHAR2 IS

Line 1338: -- Validate_Record for:OKC_CONTACTS_V --

1334: ---------------------------------------------------------------------------
1335: -- PROCEDURE Validate_Record
1336: ---------------------------------------------------------------------------
1337: ----------------------------------------
1338: -- Validate_Record for:OKC_CONTACTS_V --
1339: ----------------------------------------
1340: FUNCTION Validate_Record (
1341: p_ctcv_rec IN ctcv_rec_type
1342: ) RETURN VARCHAR2 IS

Line 1349: -- There is an index OKC_CONTACTS_U2 on these five fields

1345: -- ------------------------------------------------------
1346: -- To check for any matching row, for unique check
1347: -- The cursor includes id check filter to handle updates
1348: -- for case K2 should not overwrite already existing K1
1349: -- There is an index OKC_CONTACTS_U2 on these five fields
1350: -- with three fields nullable. Hence NVL added around.
1351: -- ------------------------------------------------------
1352: -- Added for Bug 3177402,2900541 conditions to check for overlapping dates
1353: -- Start date has to be non-null ,end date can be Null

Line 1356: FROM okc_contacts

1352: -- Added for Bug 3177402,2900541 conditions to check for overlapping dates
1353: -- Start date has to be non-null ,end date can be Null
1354: CURSOR cur_ctcv IS
1355: SELECT 'x'
1356: FROM okc_contacts
1357: WHERE cpl_id = p_ctcv_rec.CPL_ID
1358: AND cro_code = p_ctcv_rec.CRO_CODE
1359: AND NVL(jtot_object1_code,'X') = NVL(p_ctcv_rec.JTOT_OBJECT1_CODE,'X')
1360: AND NVL(object1_id1,'X') = NVL(p_ctcv_rec.OBJECT1_ID1,'X')

Line 1463: -- uniqueness in OKC_CONTACTS table.

1459: -- ---------------------------------------------------------------------
1460: -- Bug 1636056 related changes - Shyam
1461: -- OKC_UTIL.check_comp_unique call is replaced with
1462: -- the explicit cursors above, for identical function to check
1463: -- uniqueness in OKC_CONTACTS table.
1464: -- ---------------------------------------------------------------------
1465: IF ( (p_ctcv_rec.CPL_ID IS NOT NULL)
1466: AND (p_ctcv_rec.CPL_ID <> OKC_API.G_MISS_NUM) )
1467: AND

Line 1622: -- validate_row for:OKC_CONTACTS_V --

1618: ---------------------------------------------------------------------------
1619: -- PROCEDURE validate_row
1620: ---------------------------------------------------------------------------
1621: -------------------------------------
1622: -- validate_row for:OKC_CONTACTS_V --
1623: -------------------------------------
1624: PROCEDURE validate_row(
1625: p_api_version IN NUMBER,
1626: p_init_msg_list IN VARCHAR2 ,

Line 1828: -- insert_row for:OKC_CONTACTS --

1824: ---------------------------------------------------------------------------
1825: -- PROCEDURE insert_row
1826: ---------------------------------------------------------------------------
1827: ---------------------------------
1828: -- insert_row for:OKC_CONTACTS --
1829: ---------------------------------
1830: PROCEDURE insert_row(
1831: p_init_msg_list IN VARCHAR2 ,
1832: x_return_status OUT NOCOPY VARCHAR2,

Line 1844: -- Set_Attributes for:OKC_CONTACTS --

1840: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1841: l_ctc_rec ctc_rec_type := p_ctc_rec;
1842: l_def_ctc_rec ctc_rec_type;
1843: -------------------------------------
1844: -- Set_Attributes for:OKC_CONTACTS --
1845: -------------------------------------
1846: FUNCTION Set_Attributes (
1847: p_ctc_rec IN ctc_rec_type,
1848: x_ctc_rec OUT NOCOPY ctc_rec_type

Line 1885: INSERT INTO OKC_CONTACTS(

1881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1882: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_ERROR;
1884: END IF;
1885: INSERT INTO OKC_CONTACTS(
1886: id,
1887: cpl_id,
1888: cro_code,
1889: dnz_chr_id,

Line 2018: -- insert_row for:OKC_CONTACTS_V --

2014: );
2015:
2016: END insert_row;
2017: -----------------------------------
2018: -- insert_row for:OKC_CONTACTS_V --
2019: -----------------------------------
2020: PROCEDURE insert_row(
2021: p_api_version IN NUMBER,
2022: p_init_msg_list IN VARCHAR2 ,

Line 2055: -- Set_Attributes for:OKC_CONTACTS_V --

2051: RETURN(l_ctcv_rec);
2052:
2053: END fill_who_columns;
2054: ---------------------------------------
2055: -- Set_Attributes for:OKC_CONTACTS_V --
2056: ---------------------------------------
2057: FUNCTION Set_Attributes (
2058: p_ctcv_rec IN ctcv_rec_type,
2059: x_ctcv_rec OUT NOCOPY ctcv_rec_type

Line 2300: -- lock_row for:OKC_CONTACTS --

2296: ---------------------------------------------------------------------------
2297: -- PROCEDURE lock_row
2298: ---------------------------------------------------------------------------
2299: -------------------------------
2300: -- lock_row for:OKC_CONTACTS --
2301: -------------------------------
2302: PROCEDURE lock_row(
2303: p_init_msg_list IN VARCHAR2 ,
2304: x_return_status OUT NOCOPY VARCHAR2,

Line 2313: FROM OKC_CONTACTS

2309: E_Resource_Busy EXCEPTION;
2310: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2311: CURSOR lock_csr (p_ctc_rec IN ctc_rec_type) IS
2312: SELECT OBJECT_VERSION_NUMBER
2313: FROM OKC_CONTACTS
2314: WHERE ID = p_ctc_rec.id
2315: AND OBJECT_VERSION_NUMBER = p_ctc_rec.object_version_number
2316: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2317:

Line 2320: FROM OKC_CONTACTS

2316: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2317:
2318: CURSOR lchk_csr (p_ctc_rec IN ctc_rec_type) IS
2319: SELECT OBJECT_VERSION_NUMBER
2320: FROM OKC_CONTACTS
2321: WHERE ID = p_ctc_rec.id;
2322: l_api_version CONSTANT NUMBER := 1;
2323: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2324: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2325: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;

2321: WHERE ID = p_ctc_rec.id;
2322: l_api_version CONSTANT NUMBER := 1;
2323: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2324: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2325: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2326: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2327: l_row_notfound BOOLEAN := FALSE;
2328: lc_row_notfound BOOLEAN := FALSE;
2329: BEGIN

Line 2326: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;

2322: l_api_version CONSTANT NUMBER := 1;
2323: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2324: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2325: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2326: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2327: l_row_notfound BOOLEAN := FALSE;
2328: lc_row_notfound BOOLEAN := FALSE;
2329: BEGIN
2330:

Line 2455: -- lock_row for:OKC_CONTACTS_V --

2451: );
2452:
2453: END lock_row;
2454: ---------------------------------
2455: -- lock_row for:OKC_CONTACTS_V --
2456: ---------------------------------
2457: PROCEDURE lock_row(
2458: p_api_version IN NUMBER,
2459: p_init_msg_list IN VARCHAR2 ,

Line 2665: -- update_row for:OKC_CONTACTS --

2661: ---------------------------------------------------------------------------
2662: -- PROCEDURE update_row
2663: ---------------------------------------------------------------------------
2664: ---------------------------------
2665: -- update_row for:OKC_CONTACTS --
2666: ---------------------------------
2667: PROCEDURE update_row(
2668: p_init_msg_list IN VARCHAR2 ,
2669: x_return_status OUT NOCOPY VARCHAR2,

Line 2859: -- Set_Attributes for:OKC_CONTACTS --

2855: RETURN(l_return_status);
2856:
2857: END populate_new_record;
2858: -------------------------------------
2859: -- Set_Attributes for:OKC_CONTACTS --
2860: -------------------------------------
2861: FUNCTION Set_Attributes (
2862: p_ctc_rec IN ctc_rec_type,
2863: x_ctc_rec OUT NOCOPY ctc_rec_type

Line 2905: UPDATE OKC_CONTACTS

2901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2902: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2903: RAISE OKC_API.G_EXCEPTION_ERROR;
2904: END IF;
2905: UPDATE OKC_CONTACTS
2906: SET CPL_ID = l_def_ctc_rec.cpl_id,
2907: CRO_CODE = l_def_ctc_rec.cro_code,
2908: DNZ_CHR_ID = l_def_ctc_rec.dnz_chr_id,
2909: OBJECT1_ID1 = l_def_ctc_rec.object1_id1,

Line 3002: -- update_row for:OKC_CONTACTS_V --

2998: );
2999:
3000: END update_row;
3001: -----------------------------------
3002: -- update_row for:OKC_CONTACTS_V --
3003: -----------------------------------
3004: PROCEDURE update_row(
3005: p_api_version IN NUMBER,
3006: p_init_msg_list IN VARCHAR2 ,

Line 3210: -- Set_Attributes for:OKC_CONTACTS_V --

3206: RETURN(l_return_status);
3207:
3208: END populate_new_record;
3209: ---------------------------------------
3210: -- Set_Attributes for:OKC_CONTACTS_V --
3211: ---------------------------------------
3212: FUNCTION Set_Attributes (
3213: p_ctcv_rec IN ctcv_rec_type,
3214: x_ctcv_rec OUT NOCOPY ctcv_rec_type

Line 3458: -- delete_row for:OKC_CONTACTS --

3454: ---------------------------------------------------------------------------
3455: -- PROCEDURE delete_row
3456: ---------------------------------------------------------------------------
3457: ---------------------------------
3458: -- delete_row for:OKC_CONTACTS --
3459: ---------------------------------
3460: PROCEDURE delete_row(
3461: p_init_msg_list IN VARCHAR2 ,
3462: x_return_status OUT NOCOPY VARCHAR2,

Line 3488: DELETE FROM OKC_CONTACTS

3484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3486: RAISE OKC_API.G_EXCEPTION_ERROR;
3487: END IF;
3488: DELETE FROM OKC_CONTACTS
3489: WHERE ID = l_ctc_rec.id;
3490:
3491: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3492:

Line 3550: -- delete_row for:OKC_CONTACTS_V --

3546: );
3547:
3548: END delete_row;
3549: -----------------------------------
3550: -- delete_row for:OKC_CONTACTS_V --
3551: -----------------------------------
3552: PROCEDURE delete_row(
3553: p_api_version IN NUMBER,
3554: p_init_msg_list IN VARCHAR2 ,

Line 3758: -- Procedure for mass insert in OKC_CONTACTS _B and TL tables

3754:
3755: END delete_row;
3756:
3757: ---------------------------------------------------------------
3758: -- Procedure for mass insert in OKC_CONTACTS _B and TL tables
3759: ---------------------------------------------------------------
3760: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ctcv_tbl ctcv_tbl_type) IS
3761: l_tabsize NUMBER := p_ctcv_tbl.COUNT;
3762: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 3855: INTO OKC_CONTACTS

3851: END LOOP;
3852:
3853: FORALL i in 1..l_tabsize
3854: INSERT
3855: INTO OKC_CONTACTS
3856: (
3857: id,
3858: cpl_id,
3859: cro_code,

Line 3979: INSERT INTO okc_contacts_h

3975: okc_debug.Set_Indentation('OKC_CTC_PVT');
3976: okc_debug.log('13000: Entered create_version', 2);
3977: END IF;
3978:
3979: INSERT INTO okc_contacts_h
3980: (
3981: major_version,
3982: id,
3983: cpl_id,

Line 4055: FROM okc_contacts

4051: attribute14,
4052: attribute15,
4053: start_date,
4054: end_date
4055: FROM okc_contacts
4056: WHERE dnz_chr_id = p_chr_id;
4057:
4058: IF (l_debug = 'Y') THEN
4059: okc_debug.log('13100: Exiting create_version', 2);

Line 4106: INSERT INTO okc_contacts

4102: okc_debug.Set_Indentation('OKC_CTC_PVT');
4103: okc_debug.log('13300: Entered restore_version', 2);
4104: END IF;
4105:
4106: INSERT INTO okc_contacts
4107: (
4108: id,
4109: cpl_id,
4110: cro_code,

Line 4180: FROM okc_contacts_h

4176: attribute14,
4177: attribute15,
4178: start_date,
4179: end_date
4180: FROM okc_contacts_h
4181: WHERE dnz_chr_id = p_chr_id
4182: AND major_version = p_major_version;
4183:
4184: IF (l_debug = 'Y') THEN