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_SAV_PVT dependencies on OKC_STD_ART_VERSIONS_B

Line 51: FROM OKC_STD_ART_VERSIONS_B B

47:
48: DELETE FROM OKC_STD_ART_VERSIONS_TL T
49: WHERE NOT EXISTS (
50: SELECT NULL
51: FROM OKC_STD_ART_VERSIONS_B B
52: WHERE B.SAE_ID = T.SAE_ID
53: AND B.SAV_RELEASE = T.SAV_RELEASE
54: );
55:

Line 136: -- FUNCTION get_rec for: OKC_STD_ART_VERSIONS_B

132:
133: END add_language;
134:
135: ---------------------------------------------------------------------------
136: -- FUNCTION get_rec for: OKC_STD_ART_VERSIONS_B
137: ---------------------------------------------------------------------------
138: FUNCTION get_rec (
139: p_sav_rec IN sav_rec_type,
140: x_no_data_found OUT NOCOPY BOOLEAN

Line 170: FROM Okc_Std_Art_Versions_B

166: ATTRIBUTE12,
167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: FROM Okc_Std_Art_Versions_B
171: WHERE okc_std_art_versions_b.sae_id = p_sae_id
172: AND okc_std_art_versions_b.sav_release = p_sav_release;
173: l_sav_pk sav_pk_csr%ROWTYPE;
174: l_sav_rec sav_rec_type;

Line 171: WHERE okc_std_art_versions_b.sae_id = p_sae_id

167: ATTRIBUTE13,
168: ATTRIBUTE14,
169: ATTRIBUTE15
170: FROM Okc_Std_Art_Versions_B
171: WHERE okc_std_art_versions_b.sae_id = p_sae_id
172: AND okc_std_art_versions_b.sav_release = p_sav_release;
173: l_sav_pk sav_pk_csr%ROWTYPE;
174: l_sav_rec sav_rec_type;
175: BEGIN

Line 172: AND okc_std_art_versions_b.sav_release = p_sav_release;

168: ATTRIBUTE14,
169: ATTRIBUTE15
170: FROM Okc_Std_Art_Versions_B
171: WHERE okc_std_art_versions_b.sae_id = p_sae_id
172: AND okc_std_art_versions_b.sav_release = p_sav_release;
173: l_sav_pk sav_pk_csr%ROWTYPE;
174: l_sav_rec sav_rec_type;
175: BEGIN
176: x_no_data_found := TRUE;

Line 525: l_sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;

521: Cursor l_sav_csr is select sav_release
522: from okc_std_art_versions_v sav
523: where sav.sae_id=p_savv_rec.sae_id order by date_active desc, creation_date DESC ;
524:
525: l_sav_release OKC_STD_ART_VERSIONS_B.SAV_RELEASE%TYPE := OKC_API.G_MISS_CHAR;
526:
527: BEGIN
528: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
529:

Line 1317: -- insert_row for:OKC_STD_ART_VERSIONS_B --

1313: ---------------------------------------------------------------------------
1314: -- PROCEDURE insert_row
1315: ---------------------------------------------------------------------------
1316: -------------------------------------------
1317: -- insert_row for:OKC_STD_ART_VERSIONS_B --
1318: -------------------------------------------
1319: PROCEDURE insert_row(
1320: p_init_msg_list IN VARCHAR2 ,
1321: x_return_status OUT NOCOPY VARCHAR2,

Line 1333: -- Set_Attributes for:OKC_STD_ART_VERSIONS_B --

1329: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1330: l_sav_rec sav_rec_type := p_sav_rec;
1331: l_def_sav_rec sav_rec_type;
1332: -----------------------------------------------
1333: -- Set_Attributes for:OKC_STD_ART_VERSIONS_B --
1334: -----------------------------------------------
1335: FUNCTION Set_Attributes (
1336: p_sav_rec IN sav_rec_type,
1337: x_sav_rec OUT NOCOPY sav_rec_type

Line 1364: INSERT INTO OKC_STD_ART_VERSIONS_B(

1360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1361: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1362: RAISE OKC_API.G_EXCEPTION_ERROR;
1363: END IF;
1364: INSERT INTO OKC_STD_ART_VERSIONS_B(
1365: sav_release,
1366: sae_id,
1367: date_active,
1368: object_version_number,

Line 1602: FROM okc_std_art_versions_b

1598: -- Bug 1636056 related changes - Shyam
1599: -- ------------------------------------------------------
1600: CURSOR cur_sav IS
1601: SELECT 'x'
1602: FROM okc_std_art_versions_b
1603: WHERE sae_id = l_def_savv_rec.SAE_ID
1604: AND sav_release = l_def_savv_rec.SAV_RELEASE;
1605:
1606: l_row_found BOOLEAN := FALSE;

Line 1861: -- lock_row for:OKC_STD_ART_VERSIONS_B --

1857: ---------------------------------------------------------------------------
1858: -- PROCEDURE lock_row
1859: ---------------------------------------------------------------------------
1860: -----------------------------------------
1861: -- lock_row for:OKC_STD_ART_VERSIONS_B --
1862: -----------------------------------------
1863: PROCEDURE lock_row(
1864: p_init_msg_list IN VARCHAR2 ,
1865: x_return_status OUT NOCOPY VARCHAR2,

Line 1874: FROM OKC_STD_ART_VERSIONS_B

1870: E_Resource_Busy EXCEPTION;
1871: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1872: CURSOR lock_csr (p_sav_rec IN sav_rec_type) IS
1873: SELECT OBJECT_VERSION_NUMBER
1874: FROM OKC_STD_ART_VERSIONS_B
1875: WHERE SAE_ID = p_sav_rec.sae_id
1876: AND SAV_RELEASE = p_sav_rec.sav_release
1877: AND OBJECT_VERSION_NUMBER = p_sav_rec.object_version_number
1878: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 1882: FROM OKC_STD_ART_VERSIONS_B

1878: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1879:
1880: CURSOR lchk_csr (p_sav_rec IN sav_rec_type) IS
1881: SELECT OBJECT_VERSION_NUMBER
1882: FROM OKC_STD_ART_VERSIONS_B
1883: WHERE SAE_ID = p_sav_rec.sae_id
1884: AND SAV_RELEASE = p_sav_rec.sav_release;
1885: l_api_version CONSTANT NUMBER := 1;
1886: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';

Line 1888: l_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;

1884: AND SAV_RELEASE = p_sav_rec.sav_release;
1885: l_api_version CONSTANT NUMBER := 1;
1886: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1888: l_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1889: lc_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1890: l_row_notfound BOOLEAN := FALSE;
1891: lc_row_notfound BOOLEAN := FALSE;
1892: BEGIN

Line 1889: lc_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;

1885: l_api_version CONSTANT NUMBER := 1;
1886: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1887: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1888: l_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1889: lc_object_version_number OKC_STD_ART_VERSIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1890: l_row_notfound BOOLEAN := FALSE;
1891: lc_row_notfound BOOLEAN := FALSE;
1892: BEGIN
1893: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2216: -- update_row for:OKC_STD_ART_VERSIONS_B --

2212: ---------------------------------------------------------------------------
2213: -- PROCEDURE update_row
2214: ---------------------------------------------------------------------------
2215: -------------------------------------------
2216: -- update_row for:OKC_STD_ART_VERSIONS_B --
2217: -------------------------------------------
2218: PROCEDURE update_row(
2219: p_init_msg_list IN VARCHAR2 ,
2220: x_return_status OUT NOCOPY VARCHAR2,

Line 2352: -- Set_Attributes for:OKC_STD_ART_VERSIONS_B --

2348: END IF;
2349: RETURN(l_return_status);
2350: END populate_new_record;
2351: -----------------------------------------------
2352: -- Set_Attributes for:OKC_STD_ART_VERSIONS_B --
2353: -----------------------------------------------
2354: FUNCTION Set_Attributes (
2355: p_sav_rec IN sav_rec_type,
2356: x_sav_rec OUT NOCOPY sav_rec_type

Line 2389: UPDATE OKC_STD_ART_VERSIONS_B

2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2387: RAISE OKC_API.G_EXCEPTION_ERROR;
2388: END IF;
2389: UPDATE OKC_STD_ART_VERSIONS_B
2390: SET DATE_ACTIVE = l_def_sav_rec.date_active,
2391: OBJECT_VERSION_NUMBER = l_def_sav_rec.object_version_number,
2392: CREATED_BY = l_def_sav_rec.created_by,
2393: CREATION_DATE = l_def_sav_rec.creation_date,

Line 3018: -- delete_row for:OKC_STD_ART_VERSIONS_B --

3014: ---------------------------------------------------------------------------
3015: -- PROCEDURE delete_row
3016: ---------------------------------------------------------------------------
3017: -------------------------------------------
3018: -- delete_row for:OKC_STD_ART_VERSIONS_B --
3019: -------------------------------------------
3020: PROCEDURE delete_row(
3021: p_init_msg_list IN VARCHAR2 ,
3022: x_return_status OUT NOCOPY VARCHAR2,

Line 3042: DELETE FROM OKC_STD_ART_VERSIONS_B

3038: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3039: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3040: RAISE OKC_API.G_EXCEPTION_ERROR;
3041: END IF;
3042: DELETE FROM OKC_STD_ART_VERSIONS_B
3043: WHERE SAE_ID = l_sav_rec.sae_id AND
3044: SAV_RELEASE = l_sav_rec.sav_release;
3045:
3046: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);