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_CRJ_PVT dependencies on OKC_K_REL_OBJS

Line 46: -- FUNCTION get_rec for: OKC_K_REL_OBJS

42: null;
43: END api_copy;
44:
45: ---------------------------------------------------------------------------
46: -- FUNCTION get_rec for: OKC_K_REL_OBJS
47: ---------------------------------------------------------------------------
48: FUNCTION get_rec (
49: p_crj_rec IN crj_rec_type,
50: x_no_data_found OUT NOCOPY BOOLEAN

Line 83: FROM Okc_K_Rel_Objs

79: ATTRIBUTE12,
80: ATTRIBUTE13,
81: ATTRIBUTE14,
82: ATTRIBUTE15
83: FROM Okc_K_Rel_Objs
84: WHERE okc_k_rel_objs.id = p_id;
85: l_crj_pk crj_pk_csr%ROWTYPE;
86: l_crj_rec crj_rec_type;
87: BEGIN

Line 84: WHERE okc_k_rel_objs.id = p_id;

80: ATTRIBUTE13,
81: ATTRIBUTE14,
82: ATTRIBUTE15
83: FROM Okc_K_Rel_Objs
84: WHERE okc_k_rel_objs.id = p_id;
85: l_crj_pk crj_pk_csr%ROWTYPE;
86: l_crj_rec crj_rec_type;
87: BEGIN
88: x_no_data_found := TRUE;

Line 134: -- FUNCTION get_rec for: OKC_K_REL_OBJS_V

130: BEGIN
131: RETURN(get_rec(p_crj_rec, l_row_notfound));
132: END get_rec;
133: ---------------------------------------------------------------------------
134: -- FUNCTION get_rec for: OKC_K_REL_OBJS_V
135: ---------------------------------------------------------------------------
136: FUNCTION get_rec (
137: p_crjv_rec IN crjv_rec_type,
138: x_no_data_found OUT NOCOPY BOOLEAN

Line 171: FROM Okc_K_Rel_Objs

167: CREATION_DATE,
168: LAST_UPDATED_BY,
169: LAST_UPDATE_DATE,
170: LAST_UPDATE_LOGIN
171: FROM Okc_K_Rel_Objs
172: WHERE okc_k_rel_objs.id = p_id;
173: l_okc_crjv_pk okc_crjv_pk_csr%ROWTYPE;
174: l_crjv_rec crjv_rec_type;
175: BEGIN

Line 172: WHERE okc_k_rel_objs.id = p_id;

168: LAST_UPDATED_BY,
169: LAST_UPDATE_DATE,
170: LAST_UPDATE_LOGIN
171: FROM Okc_K_Rel_Objs
172: WHERE okc_k_rel_objs.id = p_id;
173: l_okc_crjv_pk okc_crjv_pk_csr%ROWTYPE;
174: l_crjv_rec crjv_rec_type;
175: BEGIN
176: x_no_data_found := TRUE;

Line 223: -- FUNCTION null_out_defaults for: OKC_K_REL_OBJS_V --

219: RETURN(get_rec(p_crjv_rec, l_row_notfound));
220: END get_rec;
221:
222: ------------------------------------------------------
223: -- FUNCTION null_out_defaults for: OKC_K_REL_OBJS_V --
224: ------------------------------------------------------
225: FUNCTION null_out_defaults (
226: p_crjv_rec IN crjv_rec_type
227: ) RETURN crjv_rec_type IS

Line 999: okc_k_rel_objs o

995: ) IS
996: SELECT --replaced the SQL for Bug 3094073
997: id
998: FROM
999: okc_k_rel_objs o
1000: WHERE ( nvl(o.chr_id, -99) = nvl(p_crjv_rec.chr_id, -99)
1001: and (-- lines same (or both null)
1002: o.cle_id = p_crjv_rec.cle_id
1003: or (-- both null

Line 1083: okc_k_rel_objs o

1079: ) IS
1080: SELECT
1081: id
1082: FROM
1083: okc_k_rel_objs o
1084: WHERE (-- all data same
1085: (-- headers same (or both null)
1086: o.chr_id = p_crjv_rec.chr_id
1087: or (-- both null

Line 1113: okc_k_rel_objs o

1109: ) IS
1110: SELECT
1111: id
1112: FROM
1113: okc_k_rel_objs o
1114: WHERE (-- all data same
1115: o.rty_code = p_crjv_rec.rty_code
1116: -- and o.rty_code <> 'CONTRACTNEGOTIATESQUOTE' Bug# 1255862
1117: and o.rty_code not in ('CONTRACTNEGOTIATESQUOTE', 'CONTRACTSERVICESORDER')

Line 1197: -- Validate_Attributes for:OKC_K_REL_OBJS_V --

1193:
1194: /* end added code
1195: */
1196: ----------------------------------------------
1197: -- Validate_Attributes for:OKC_K_REL_OBJS_V --
1198: ----------------------------------------------
1199: FUNCTION Validate_Attributes
1200: (
1201: p_crjv_rec IN crjv_rec_type

Line 1462: -- validate_row for:OKC_K_REL_OBJS_V --

1458: ---------------------------------------------------------------------------
1459: -- PROCEDURE validate_row
1460: ---------------------------------------------------------------------------
1461: ---------------------------------------
1462: -- validate_row for:OKC_K_REL_OBJS_V --
1463: ---------------------------------------
1464: PROCEDURE validate_row(
1465: p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 ,

Line 1600: -- insert_row for:OKC_K_REL_OBJS --

1596: ---------------------------------------------------------------------------
1597: -- PROCEDURE insert_row
1598: ---------------------------------------------------------------------------
1599: -----------------------------------
1600: -- insert_row for:OKC_K_REL_OBJS --
1601: -----------------------------------
1602: PROCEDURE insert_row(
1603: p_init_msg_list IN VARCHAR2 ,
1604: x_return_status OUT NOCOPY VARCHAR2,

Line 1616: -- Set_Attributes for:OKC_K_REL_OBJS --

1612: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1613: l_crj_rec crj_rec_type := p_crj_rec;
1614: l_def_crj_rec crj_rec_type;
1615: ---------------------------------------
1616: -- Set_Attributes for:OKC_K_REL_OBJS --
1617: ---------------------------------------
1618: FUNCTION Set_Attributes (
1619: p_crj_rec IN crj_rec_type,
1620: x_crj_rec OUT NOCOPY crj_rec_type

Line 1652: INSERT INTO OKC_K_REL_OBJS(

1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651:
1652: INSERT INTO OKC_K_REL_OBJS(
1653: id,
1654: cle_id,
1655: chr_id,
1656: rty_code,

Line 1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');

1709: l_crj_rec.attribute13,
1710: l_crj_rec.attribute14,
1711: l_crj_rec.attribute15);
1712: IF (l_debug = 'Y') THEN
1713: okc_util.print_trace(5, 'Insertion into OKC_K_REL_OBJS:');
1714: okc_util.print_trace(5, '==============================');
1715: okc_util.print_trace(6, 'Id = '||l_crj_rec.id);
1716: okc_util.print_trace(6, 'Contract Id = '||l_crj_rec.chr_id);
1717: okc_util.print_trace(6, 'Contract Line Id = '||l_crj_rec.cle_id);

Line 1772: -- insert_row for:OKC_K_REL_OBJS_V --

1768: '_PVT'
1769: );
1770: END insert_row;
1771: -------------------------------------
1772: -- insert_row for:OKC_K_REL_OBJS_V --
1773: -------------------------------------
1774: PROCEDURE insert_row(
1775: p_api_version IN NUMBER,
1776: p_init_msg_list IN VARCHAR2 ,

Line 1807: -- Set_Attributes for:OKC_K_REL_OBJS_V --

1803: l_crjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1804: RETURN(l_crjv_rec);
1805: END fill_who_columns;
1806: -----------------------------------------
1807: -- Set_Attributes for:OKC_K_REL_OBJS_V --
1808: -----------------------------------------
1809: FUNCTION Set_Attributes (
1810: p_crjv_rec IN crjv_rec_type,
1811: x_crjv_rec OUT NOCOPY crjv_rec_type

Line 2013: -- lock_row for:OKC_K_REL_OBJS --

2009: ---------------------------------------------------------------------------
2010: -- PROCEDURE lock_row
2011: ---------------------------------------------------------------------------
2012: ---------------------------------
2013: -- lock_row for:OKC_K_REL_OBJS --
2014: ---------------------------------
2015: PROCEDURE lock_row(
2016: p_init_msg_list IN VARCHAR2 ,
2017: x_return_status OUT NOCOPY VARCHAR2,

Line 2026: FROM OKC_K_REL_OBJS

2022: E_Resource_Busy EXCEPTION;
2023: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2024: CURSOR lock_csr (p_crj_rec IN crj_rec_type) IS
2025: SELECT OBJECT_VERSION_NUMBER
2026: FROM OKC_K_REL_OBJS
2027: WHERE ID = p_crj_rec.id
2028: AND OBJECT_VERSION_NUMBER = p_crj_rec.object_version_number
2029: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2030:

Line 2033: FROM OKC_K_REL_OBJS

2029: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2030:
2031: CURSOR lchk_csr (p_crj_rec IN crj_rec_type) IS
2032: SELECT OBJECT_VERSION_NUMBER
2033: FROM OKC_K_REL_OBJS
2034: WHERE ID = p_crj_rec.id;
2035: l_api_version CONSTANT NUMBER := 1;
2036: l_api_name CONSTANT VARCHAR2(30) := 'OBJS_lock_row';
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2038: l_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;

2034: WHERE ID = p_crj_rec.id;
2035: l_api_version CONSTANT NUMBER := 1;
2036: l_api_name CONSTANT VARCHAR2(30) := 'OBJS_lock_row';
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2038: l_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;
2039: lc_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;
2040: l_row_notfound BOOLEAN := FALSE;
2041: lc_row_notfound BOOLEAN := FALSE;
2042: BEGIN

Line 2039: lc_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;

2035: l_api_version CONSTANT NUMBER := 1;
2036: l_api_name CONSTANT VARCHAR2(30) := 'OBJS_lock_row';
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2038: l_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;
2039: lc_object_version_number OKC_K_REL_OBJS.OBJECT_VERSION_NUMBER%TYPE;
2040: l_row_notfound BOOLEAN := FALSE;
2041: lc_row_notfound BOOLEAN := FALSE;
2042: BEGIN
2043: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2119: -- lock_row for:OKC_K_REL_OBJS_V --

2115: '_PVT'
2116: );
2117: END lock_row;
2118: -----------------------------------
2119: -- lock_row for:OKC_K_REL_OBJS_V --
2120: -----------------------------------
2121: PROCEDURE lock_row(
2122: p_api_version IN NUMBER,
2123: p_init_msg_list IN VARCHAR2 ,

Line 2267: -- update_row for:OKC_K_REL_OBJS --

2263: ---------------------------------------------------------------------------
2264: -- PROCEDURE update_row
2265: ---------------------------------------------------------------------------
2266: -----------------------------------
2267: -- update_row for:OKC_K_REL_OBJS --
2268: -----------------------------------
2269: PROCEDURE update_row(
2270: p_init_msg_list IN VARCHAR2 ,
2271: x_return_status OUT NOCOPY VARCHAR2,

Line 2419: -- Set_Attributes for:OKC_K_REL_OBJS --

2415: END IF;
2416: RETURN(l_return_status);
2417: END populate_new_record;
2418: ---------------------------------------
2419: -- Set_Attributes for:OKC_K_REL_OBJS --
2420: ---------------------------------------
2421: FUNCTION Set_Attributes (
2422: p_crj_rec IN crj_rec_type,
2423: x_crj_rec OUT NOCOPY crj_rec_type

Line 2456: UPDATE OKC_K_REL_OBJS

2452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_ERROR;
2455: END IF;
2456: UPDATE OKC_K_REL_OBJS
2457: SET CLE_ID = l_def_crj_rec.cle_id,
2458: CHR_ID = l_def_crj_rec.chr_id,
2459: RTY_CODE = l_def_crj_rec.rty_code,
2460: OBJECT1_ID1 = l_def_crj_rec.object1_id1,

Line 2522: -- update_row for:OKC_K_REL_OBJS_V --

2518: '_PVT'
2519: );
2520: END update_row;
2521: -------------------------------------
2522: -- update_row for:OKC_K_REL_OBJS_V --
2523: -------------------------------------
2524: PROCEDURE update_row(
2525: p_api_version IN NUMBER,
2526: p_init_msg_list IN VARCHAR2 ,

Line 2689: -- Set_Attributes for:OKC_K_REL_OBJS_V --

2685: END IF;
2686: RETURN(l_return_status);
2687: END populate_new_record;
2688: -----------------------------------------
2689: -- Set_Attributes for:OKC_K_REL_OBJS_V --
2690: -----------------------------------------
2691: FUNCTION Set_Attributes (
2692: p_crjv_rec IN crjv_rec_type,
2693: x_crjv_rec OUT NOCOPY crjv_rec_type

Line 2866: -- delete_row for:OKC_K_REL_OBJS --

2862: ---------------------------------------------------------------------------
2863: -- PROCEDURE delete_row
2864: ---------------------------------------------------------------------------
2865: -----------------------------------
2866: -- delete_row for:OKC_K_REL_OBJS --
2867: -----------------------------------
2868: PROCEDURE delete_row(
2869: p_init_msg_list IN VARCHAR2 ,
2870: x_return_status OUT NOCOPY VARCHAR2,

Line 2890: DELETE FROM OKC_K_REL_OBJS

2886: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2887: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2888: RAISE OKC_API.G_EXCEPTION_ERROR;
2889: END IF;
2890: DELETE FROM OKC_K_REL_OBJS
2891: WHERE ID = l_crj_rec.id;
2892:
2893: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2894: EXCEPTION

Line 2927: -- delete_row for:OKC_K_REL_OBJS_V --

2923: '_PVT'
2924: );
2925: END delete_row;
2926: -------------------------------------
2927: -- delete_row for:OKC_K_REL_OBJS_V --
2928: -------------------------------------
2929: PROCEDURE delete_row(
2930: p_api_version IN NUMBER,
2931: p_init_msg_list IN VARCHAR2 ,

Line 3106: okc_k_rel_objs o

3102: ) IS
3103: SELECT
3104: id
3105: FROM
3106: okc_k_rel_objs o
3107: WHERE (
3108: o.rty_code = 'QUOTERENEWSCONTRACT'
3109: and o.jtot_object1_code = 'OKX_QUOTEHEAD'
3110: and o.object1_id1 = p_crjv_rec.object1_id1

Line 3129: okc_k_rel_objs o

3125: ) IS
3126: SELECT
3127: id
3128: FROM
3129: okc_k_rel_objs o
3130: WHERE (-- object with right type and relationship codes
3131: o.rty_code = 'QUOTERENEWSCONTRACT'
3132: and o.jtot_object1_code = 'OKX_QUOTEHEAD'
3133: and exists (-- another quote (or same) with same number as object

Line 3286: okc_k_rel_objs o

3282: ) IS
3283: SELECT
3284: id
3285: FROM
3286: okc_k_rel_objs o
3287: WHERE (
3288: o.rty_code = 'ORDERRENEWSCONTRACT'
3289: and o.jtot_object1_code = 'OKX_ORDERHEAD'
3290: and o.object1_id1 = p_crjv_rec.object1_id1

Line 3473: okc_k_rel_objs o

3469: ) IS
3470: SELECT
3471: id
3472: FROM
3473: okc_k_rel_objs o
3474: WHERE (-- object with right type and relationship codes
3475: o.rty_code = 'QUOTESUBJECTCONTRACT'
3476: and o.jtot_object1_code = 'OKX_QUOTEHEAD'
3477: and exists (-- another quote (or same) with same number as object

Line 3629: okc_k_rel_objs o

3625: ) IS
3626: SELECT
3627: id
3628: FROM
3629: okc_k_rel_objs o
3630: WHERE (
3631: o.rty_code = 'ORDERSUBJECTCONTRACT'
3632: and o.jtot_object1_code = 'OKX_ORDERHEAD'
3633: and o.object1_id1 = p_crjv_rec.object1_id1

Line 3814: okc_k_rel_objs o

3810: SELECT
3811: id
3812: ,chr_id
3813: FROM
3814: okc_k_rel_objs o
3815: WHERE (-- object with right type and relationship codes
3816: o.rty_code = 'QUOTERENEWSCONTRACT'
3817: and o.jtot_object1_code = 'OKX_QUOTEHEAD'
3818: and exists (-- another quote (or same) with same number as object

Line 3863: okc_k_rel_objs o

3859: SELECT
3860: object1_id1
3861: ,object1_id2
3862: FROM
3863: okc_k_rel_objs o
3864: WHERE
3865: (
3866: o.chr_id = r_renew_rel_for_quote.chr_id
3867: and o.rty_code = 'CONTRACTSERVICESORDER'

Line 4120: -- Procedure for mass insert in OKC_K_REL_OBJS _B and TL tables

4116: );
4117: end GET_OBJ_FROM_JTFV;
4118:
4119: ---------------------------------------------------------------
4120: -- Procedure for mass insert in OKC_K_REL_OBJS _B and TL tables
4121: ---------------------------------------------------------------
4122: PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_crjv_tbl crjv_tbl_type) IS
4123: l_tabsize NUMBER := p_crjv_tbl.COUNT;
4124: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 4212: INTO OKC_K_REL_OBJS

4208: END LOOP;
4209:
4210: FORALL i in 1..l_tabsize
4211: INSERT
4212: INTO OKC_K_REL_OBJS
4213: (
4214: id,
4215: cle_id,
4216: chr_id,