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 81: UPDATE OKC_CONTACTS SET dnz_ste_code=l_ste_code WHERE DNZ_CHR_ID=p_chr_id;

77: IF l_ste_code is null then
78: RAISE OKC_API.G_EXCEPTION_ERROR;
79: END IF;
80:
81: UPDATE OKC_CONTACTS SET dnz_ste_code=l_ste_code WHERE DNZ_CHR_ID=p_chr_id;
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.Set_Indentation('OKC_CTC_PVT');
85: okc_debug.log('110: Exiting update_contact_stecode', 2);

Line 110: -- FUNCTION get_rec for: OKC_CONTACTS

106: /*bugfix for 6882512*/
107:
108:
109: ---------------------------------------------------------------------------
110: -- FUNCTION get_rec for: OKC_CONTACTS
111: ---------------------------------------------------------------------------
112: FUNCTION get_rec (
113: p_ctc_rec IN ctc_rec_type,
114: x_no_data_found OUT NOCOPY BOOLEAN

Line 153: FROM Okc_Contacts

149: ATTRIBUTE14,
150: ATTRIBUTE15,
151: START_DATE,
152: END_DATE
153: FROM Okc_Contacts
154: WHERE okc_contacts.id = p_id;
155: l_ctc_pk ctc_pk_csr%ROWTYPE;
156: l_ctc_rec ctc_rec_type;
157: BEGIN

Line 154: WHERE okc_contacts.id = p_id;

150: ATTRIBUTE15,
151: START_DATE,
152: END_DATE
153: FROM Okc_Contacts
154: WHERE okc_contacts.id = p_id;
155: l_ctc_pk ctc_pk_csr%ROWTYPE;
156: l_ctc_rec ctc_rec_type;
157: BEGIN
158:

Line 226: -- FUNCTION get_rec for: OKC_CONTACTS_V

222: RETURN(get_rec(p_ctc_rec, l_row_notfound));
223:
224: END get_rec;
225: ---------------------------------------------------------------------------
226: -- FUNCTION get_rec for: OKC_CONTACTS_V
227: ---------------------------------------------------------------------------
228: FUNCTION get_rec (
229: p_ctcv_rec IN ctcv_rec_type,
230: x_no_data_found OUT NOCOPY BOOLEAN

Line 269: FROM Okc_Contacts

265: LAST_UPDATE_DATE,
266: LAST_UPDATE_LOGIN,
267: START_DATE,
268: END_DATE
269: FROM Okc_Contacts
270: WHERE okc_contacts.id = p_id;
271: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
272: l_ctcv_rec ctcv_rec_type;
273: BEGIN

Line 270: WHERE okc_contacts.id = p_id;

266: LAST_UPDATE_LOGIN,
267: START_DATE,
268: END_DATE
269: FROM Okc_Contacts
270: WHERE okc_contacts.id = p_id;
271: l_okc_ctcv_pk okc_ctcv_pk_csr%ROWTYPE;
272: l_ctcv_rec ctcv_rec_type;
273: BEGIN
274:

Line 342: -- FUNCTION null_out_defaults for: OKC_CONTACTS_V --

338:
339: END get_rec;
340:
341: ----------------------------------------------------
342: -- FUNCTION null_out_defaults for: OKC_CONTACTS_V --
343: ----------------------------------------------------
344: FUNCTION null_out_defaults (
345: p_ctcv_rec IN ctcv_rec_type
346: ) RETURN ctcv_rec_type IS

Line 1143: FROM OKC_CONTACTS ctc

1139: l_dummy varchar2(1) := '?';
1140:
1141: CURSOR l_contacts_csr IS
1142: SELECT '!'
1143: FROM OKC_CONTACTS ctc
1144: WHERE id <> NVL(p_ctcv_rec.id,-99999)
1145: AND cpl_id = p_ctcv_rec.cpl_id
1146: AND dnz_chr_id = p_ctcv_rec.dnz_chr_id
1147: AND primary_yn = 'Y'

Line 1296: -- alidate_Attributes for:OKC_CONTACTS_V --

1292: End validate_resource_class;
1293:
1294: /*+++++++++++++End of hand code +++++++++++++++++++*/
1295: --------------------------------------------
1296: -- alidate_Attributes for:OKC_CONTACTS_V --
1297: --------------------------------------------
1298: FUNCTION Validate_Attributes (
1299: p_ctcv_rec IN ctcv_rec_type
1300: ) RETURN VARCHAR2 IS

Line 1395: -- Validate_Record for:OKC_CONTACTS_V --

1391: ---------------------------------------------------------------------------
1392: -- PROCEDURE Validate_Record
1393: ---------------------------------------------------------------------------
1394: ----------------------------------------
1395: -- Validate_Record for:OKC_CONTACTS_V --
1396: ----------------------------------------
1397: FUNCTION Validate_Record (
1398: p_ctcv_rec IN ctcv_rec_type
1399: ) RETURN VARCHAR2 IS

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

1402: -- ------------------------------------------------------
1403: -- To check for any matching row, for unique check
1404: -- The cursor includes id check filter to handle updates
1405: -- for case K2 should not overwrite already existing K1
1406: -- There is an index OKC_CONTACTS_U2 on these five fields
1407: -- with three fields nullable. Hence NVL added around.
1408: -- ------------------------------------------------------
1409: -- Added for Bug 3177402,2900541 conditions to check for overlapping dates
1410: -- Start date has to be non-null ,end date can be Null

Line 1413: FROM okc_contacts

1409: -- Added for Bug 3177402,2900541 conditions to check for overlapping dates
1410: -- Start date has to be non-null ,end date can be Null
1411: CURSOR cur_ctcv IS
1412: SELECT 'x'
1413: FROM okc_contacts
1414: WHERE cpl_id = p_ctcv_rec.CPL_ID
1415: AND cro_code = p_ctcv_rec.CRO_CODE
1416: AND NVL(jtot_object1_code,'X') = NVL(p_ctcv_rec.JTOT_OBJECT1_CODE,'X')
1417: AND NVL(object1_id1,'X') = NVL(p_ctcv_rec.OBJECT1_ID1,'X')

Line 1520: -- uniqueness in OKC_CONTACTS table.

1516: -- ---------------------------------------------------------------------
1517: -- Bug 1636056 related changes - Shyam
1518: -- OKC_UTIL.check_comp_unique call is replaced with
1519: -- the explicit cursors above, for identical function to check
1520: -- uniqueness in OKC_CONTACTS table.
1521: -- ---------------------------------------------------------------------
1522: IF ( (p_ctcv_rec.CPL_ID IS NOT NULL)
1523: AND (p_ctcv_rec.CPL_ID <> OKC_API.G_MISS_NUM) )
1524: AND

Line 1679: -- validate_row for:OKC_CONTACTS_V --

1675: ---------------------------------------------------------------------------
1676: -- PROCEDURE validate_row
1677: ---------------------------------------------------------------------------
1678: -------------------------------------
1679: -- validate_row for:OKC_CONTACTS_V --
1680: -------------------------------------
1681: PROCEDURE validate_row(
1682: p_api_version IN NUMBER,
1683: p_init_msg_list IN VARCHAR2 ,

Line 1885: -- insert_row for:OKC_CONTACTS --

1881: ---------------------------------------------------------------------------
1882: -- PROCEDURE insert_row
1883: ---------------------------------------------------------------------------
1884: ---------------------------------
1885: -- insert_row for:OKC_CONTACTS --
1886: ---------------------------------
1887: PROCEDURE insert_row(
1888: p_init_msg_list IN VARCHAR2 ,
1889: x_return_status OUT NOCOPY VARCHAR2,

Line 1901: -- Set_Attributes for:OKC_CONTACTS --

1897: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1898: l_ctc_rec ctc_rec_type := p_ctc_rec;
1899: l_def_ctc_rec ctc_rec_type;
1900: -------------------------------------
1901: -- Set_Attributes for:OKC_CONTACTS --
1902: -------------------------------------
1903: FUNCTION Set_Attributes (
1904: p_ctc_rec IN ctc_rec_type,
1905: x_ctc_rec OUT NOCOPY ctc_rec_type

Line 1942: INSERT INTO OKC_CONTACTS(

1938: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1940: RAISE OKC_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: INSERT INTO OKC_CONTACTS(
1943: id,
1944: cpl_id,
1945: cro_code,
1946: dnz_chr_id,

Line 2083: -- insert_row for:OKC_CONTACTS_V --

2079: );
2080:
2081: END insert_row;
2082: -----------------------------------
2083: -- insert_row for:OKC_CONTACTS_V --
2084: -----------------------------------
2085: PROCEDURE insert_row(
2086: p_api_version IN NUMBER,
2087: p_init_msg_list IN VARCHAR2 ,

Line 2120: -- Set_Attributes for:OKC_CONTACTS_V --

2116: RETURN(l_ctcv_rec);
2117:
2118: END fill_who_columns;
2119: ---------------------------------------
2120: -- Set_Attributes for:OKC_CONTACTS_V --
2121: ---------------------------------------
2122: FUNCTION Set_Attributes (
2123: p_ctcv_rec IN ctcv_rec_type,
2124: x_ctcv_rec OUT NOCOPY ctcv_rec_type

Line 2365: -- lock_row for:OKC_CONTACTS --

2361: ---------------------------------------------------------------------------
2362: -- PROCEDURE lock_row
2363: ---------------------------------------------------------------------------
2364: -------------------------------
2365: -- lock_row for:OKC_CONTACTS --
2366: -------------------------------
2367: PROCEDURE lock_row(
2368: p_init_msg_list IN VARCHAR2 ,
2369: x_return_status OUT NOCOPY VARCHAR2,

Line 2378: FROM OKC_CONTACTS

2374: E_Resource_Busy EXCEPTION;
2375: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2376: CURSOR lock_csr (p_ctc_rec IN ctc_rec_type) IS
2377: SELECT OBJECT_VERSION_NUMBER
2378: FROM OKC_CONTACTS
2379: WHERE ID = p_ctc_rec.id
2380: AND OBJECT_VERSION_NUMBER = p_ctc_rec.object_version_number
2381: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2382:

Line 2385: FROM OKC_CONTACTS

2381: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2382:
2383: CURSOR lchk_csr (p_ctc_rec IN ctc_rec_type) IS
2384: SELECT OBJECT_VERSION_NUMBER
2385: FROM OKC_CONTACTS
2386: WHERE ID = p_ctc_rec.id;
2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2390: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;

2386: WHERE ID = p_ctc_rec.id;
2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2391: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2392: l_row_notfound BOOLEAN := FALSE;
2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN

Line 2391: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;

2387: l_api_version CONSTANT NUMBER := 1;
2388: l_api_name CONSTANT VARCHAR2(30) := 'CONTACTS_lock_row';
2389: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2390: l_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2391: lc_object_version_number OKC_CONTACTS.OBJECT_VERSION_NUMBER%TYPE;
2392: l_row_notfound BOOLEAN := FALSE;
2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN
2395:

Line 2520: -- lock_row for:OKC_CONTACTS_V --

2516: );
2517:
2518: END lock_row;
2519: ---------------------------------
2520: -- lock_row for:OKC_CONTACTS_V --
2521: ---------------------------------
2522: PROCEDURE lock_row(
2523: p_api_version IN NUMBER,
2524: p_init_msg_list IN VARCHAR2 ,

Line 2730: -- update_row for:OKC_CONTACTS --

2726: ---------------------------------------------------------------------------
2727: -- PROCEDURE update_row
2728: ---------------------------------------------------------------------------
2729: ---------------------------------
2730: -- update_row for:OKC_CONTACTS --
2731: ---------------------------------
2732: PROCEDURE update_row(
2733: p_init_msg_list IN VARCHAR2 ,
2734: x_return_status OUT NOCOPY VARCHAR2,

Line 2936: -- Set_Attributes for:OKC_CONTACTS --

2932: RETURN(l_return_status);
2933:
2934: END populate_new_record;
2935: -------------------------------------
2936: -- Set_Attributes for:OKC_CONTACTS --
2937: -------------------------------------
2938: FUNCTION Set_Attributes (
2939: p_ctc_rec IN ctc_rec_type,
2940: x_ctc_rec OUT NOCOPY ctc_rec_type

Line 2987: UPDATE OKC_CONTACTS

2983: OPEN get_k_status(l_def_ctc_rec.dnz_chr_id);
2984: FETCH get_k_status INTO l_ste_code;
2985: CLOSE get_k_status;
2986: /*bugfix for 6882512*/
2987: UPDATE OKC_CONTACTS
2988: SET CPL_ID = l_def_ctc_rec.cpl_id,
2989: CRO_CODE = l_def_ctc_rec.cro_code,
2990: DNZ_CHR_ID = l_def_ctc_rec.dnz_chr_id,
2991: OBJECT1_ID1 = l_def_ctc_rec.object1_id1,

Line 3085: -- update_row for:OKC_CONTACTS_V --

3081: );
3082:
3083: END update_row;
3084: -----------------------------------
3085: -- update_row for:OKC_CONTACTS_V --
3086: -----------------------------------
3087: PROCEDURE update_row(
3088: p_api_version IN NUMBER,
3089: p_init_msg_list IN VARCHAR2 ,

Line 3293: -- Set_Attributes for:OKC_CONTACTS_V --

3289: RETURN(l_return_status);
3290:
3291: END populate_new_record;
3292: ---------------------------------------
3293: -- Set_Attributes for:OKC_CONTACTS_V --
3294: ---------------------------------------
3295: FUNCTION Set_Attributes (
3296: p_ctcv_rec IN ctcv_rec_type,
3297: x_ctcv_rec OUT NOCOPY ctcv_rec_type

Line 3541: -- delete_row for:OKC_CONTACTS --

3537: ---------------------------------------------------------------------------
3538: -- PROCEDURE delete_row
3539: ---------------------------------------------------------------------------
3540: ---------------------------------
3541: -- delete_row for:OKC_CONTACTS --
3542: ---------------------------------
3543: PROCEDURE delete_row(
3544: p_init_msg_list IN VARCHAR2 ,
3545: x_return_status OUT NOCOPY VARCHAR2,

Line 3571: DELETE FROM OKC_CONTACTS

3567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3568: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3569: RAISE OKC_API.G_EXCEPTION_ERROR;
3570: END IF;
3571: DELETE FROM OKC_CONTACTS
3572: WHERE ID = l_ctc_rec.id;
3573:
3574: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3575:

Line 3633: -- delete_row for:OKC_CONTACTS_V --

3629: );
3630:
3631: END delete_row;
3632: -----------------------------------
3633: -- delete_row for:OKC_CONTACTS_V --
3634: -----------------------------------
3635: PROCEDURE delete_row(
3636: p_api_version IN NUMBER,
3637: p_init_msg_list IN VARCHAR2 ,

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

3837:
3838: END delete_row;
3839:
3840: ---------------------------------------------------------------
3841: -- Procedure for mass insert in OKC_CONTACTS _B and TL tables
3842: ---------------------------------------------------------------
3843: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_ctcv_tbl ctcv_tbl_type) IS
3844: l_tabsize NUMBER := p_ctcv_tbl.COUNT;
3845: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 3956: INTO OKC_CONTACTS

3952: END LOOP;
3953:
3954: FORALL i in 1..l_tabsize
3955: INSERT
3956: INTO OKC_CONTACTS
3957: (
3958: id,
3959: cpl_id,
3960: cro_code,

Line 4082: INSERT INTO okc_contacts_h

4078: okc_debug.Set_Indentation('OKC_CTC_PVT');
4079: okc_debug.log('13000: Entered create_version', 2);
4080: END IF;
4081:
4082: INSERT INTO okc_contacts_h
4083: (
4084: major_version,
4085: id,
4086: cpl_id,

Line 4158: FROM okc_contacts

4154: attribute14,
4155: attribute15,
4156: start_date,
4157: end_date
4158: FROM okc_contacts
4159: WHERE dnz_chr_id = p_chr_id;
4160:
4161: IF (l_debug = 'Y') THEN
4162: okc_debug.log('13100: Exiting create_version', 2);

Line 4209: INSERT INTO okc_contacts

4205: okc_debug.Set_Indentation('OKC_CTC_PVT');
4206: okc_debug.log('13300: Entered restore_version', 2);
4207: END IF;
4208:
4209: INSERT INTO okc_contacts
4210: (
4211: id,
4212: cpl_id,
4213: cro_code,

Line 4283: FROM okc_contacts_h

4279: attribute14,
4280: attribute15,
4281: start_date,
4282: end_date
4283: FROM okc_contacts_h
4284: WHERE dnz_chr_id = p_chr_id
4285: AND major_version = p_major_version;
4286:
4287: /* Bug fix for 6882512*/