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_SCS_PVT dependencies on OKC_SUBCLASSES_V

Line 218: -- FUNCTION get_rec for: OKC_SUBCLASSES_V

214: BEGIN
215: RETURN(get_rec(p_okc_subclasses_tl_rec, l_row_notfound));
216: END get_rec;
217: ---------------------------------------------------------------------------
218: -- FUNCTION get_rec for: OKC_SUBCLASSES_V
219: ---------------------------------------------------------------------------
220: FUNCTION get_rec (
221: p_scsv_rec IN scsv_rec_type,
222: x_no_data_found OUT NOCOPY BOOLEAN

Line 241: FROM Okc_Subclasses_V

237: LAST_UPDATE_DATE,
238: LAST_UPDATE_LOGIN,
239: CREATE_OPP_YN,
240: ACCESS_LEVEL
241: FROM Okc_Subclasses_V
242: WHERE okc_subclasses_v.code = p_code;
243: l_okc_scsv_pk okc_scsv_pk_csr%ROWTYPE;
244: l_scsv_rec scsv_rec_type;
245: BEGIN

Line 242: WHERE okc_subclasses_v.code = p_code;

238: LAST_UPDATE_LOGIN,
239: CREATE_OPP_YN,
240: ACCESS_LEVEL
241: FROM Okc_Subclasses_V
242: WHERE okc_subclasses_v.code = p_code;
243: l_okc_scsv_pk okc_scsv_pk_csr%ROWTYPE;
244: l_scsv_rec scsv_rec_type;
245: BEGIN
246: x_no_data_found := TRUE;

Line 279: -- FUNCTION null_out_defaults for: OKC_SUBCLASSES_V --

275: RETURN(get_rec(p_scsv_rec, l_row_notfound));
276: END get_rec;
277:
278: ------------------------------------------------------
279: -- FUNCTION null_out_defaults for: OKC_SUBCLASSES_V --
280: ------------------------------------------------------
281: FUNCTION null_out_defaults (
282: p_scsv_rec IN scsv_rec_type
283: ) RETURN scsv_rec_type IS

Line 575: -- Validate_Attributes for:OKC_SUBCLASSES_V --

571: ---------------------------------------------------------------------------
572: -- PROCEDURE Validate_Attributes
573: ---------------------------------------------------------------------------
574: ----------------------------------------------
575: -- Validate_Attributes for:OKC_SUBCLASSES_V --
576: ----------------------------------------------
577: FUNCTION Validate_Attributes (
578: p_scsv_rec IN scsv_rec_type
579: ) RETURN VARCHAR2 IS

Line 689: -- Validate_Record for:OKC_SUBCLASSES_V --

685: ---------------------------------------------------------------------------
686: -- PROCEDURE Validate_Record
687: ---------------------------------------------------------------------------
688: ------------------------------------------
689: -- Validate_Record for:OKC_SUBCLASSES_V --
690: ------------------------------------------
691: FUNCTION Validate_Record (
692: p_scsv_rec IN scsv_rec_type
693: ) RETURN VARCHAR2 IS

Line 829: -- validate_row for:OKC_SUBCLASSES_V --

825: ---------------------------------------------------------------------------
826: -- PROCEDURE validate_row
827: ---------------------------------------------------------------------------
828: ---------------------------------------
829: -- validate_row for:OKC_SUBCLASSES_V --
830: ---------------------------------------
831: PROCEDURE validate_row(
832: p_api_version IN NUMBER,
833: p_init_msg_list IN VARCHAR2,

Line 1200: -- insert_row for:OKC_SUBCLASSES_V --

1196: '_PVT'
1197: );
1198: END insert_row;
1199: -------------------------------------
1200: -- insert_row for:OKC_SUBCLASSES_V --
1201: -------------------------------------
1202: PROCEDURE insert_row(
1203: p_api_version IN NUMBER,
1204: p_init_msg_list IN VARCHAR2,

Line 1236: -- Set_Attributes for:OKC_SUBCLASSES_V --

1232: l_scsv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1233: RETURN(l_scsv_rec);
1234: END fill_who_columns;
1235: -----------------------------------------
1236: -- Set_Attributes for:OKC_SUBCLASSES_V --
1237: -----------------------------------------
1238: FUNCTION Set_Attributes (
1239: p_scsv_rec IN scsv_rec_type,
1240: x_scsv_rec OUT NOCOPY scsv_rec_type

Line 1270: CURSOR c2 (p_code IN okc_subclasses_v.code%TYPE) IS

1266: FROM Okc_Subclasses_B
1267: WHERE cls_code = p_cls_code
1268: AND Instr(code, p_cls_code) > 0;
1269: --
1270: CURSOR c2 (p_code IN okc_subclasses_v.code%TYPE) IS
1271: SELECT 'x'
1272: FROM Okc_Subclasses_B
1273: WHERE code = p_code;
1274: --

Line 1295: -- Validate_Unique_Keys for:OKC_SUBCLASSES_V --

1291: End If;
1292: RETURN(l_scsv_rec);
1293: END Populate_Code;
1294: -----------------------------------------------
1295: -- Validate_Unique_Keys for:OKC_SUBCLASSES_V --
1296: -----------------------------------------------
1297: FUNCTION validate_unique_keys (
1298: p_scsv_rec IN scsv_rec_type
1299: ) RETURN VARCHAR2 IS

Line 1301: CURSOR c1 (p_code IN okc_subclasses_v.code%TYPE) IS

1297: FUNCTION validate_unique_keys (
1298: p_scsv_rec IN scsv_rec_type
1299: ) RETURN VARCHAR2 IS
1300: unique_key_error EXCEPTION;
1301: CURSOR c1 (p_code IN okc_subclasses_v.code%TYPE) IS
1302: SELECT 'x'
1303: FROM Okc_Subclasses_B
1304: WHERE code = p_code;
1305: CURSOR c2 (p_meaning IN okc_subclasses_v.meaning%TYPE) IS

Line 1305: CURSOR c2 (p_meaning IN okc_subclasses_v.meaning%TYPE) IS

1301: CURSOR c1 (p_code IN okc_subclasses_v.code%TYPE) IS
1302: SELECT 'x'
1303: FROM Okc_Subclasses_B
1304: WHERE code = p_code;
1305: CURSOR c2 (p_meaning IN okc_subclasses_v.meaning%TYPE) IS
1306: SELECT 'x'
1307: FROM Okc_Subclasses_V
1308: WHERE meaning = p_meaning;
1309: l_dummy VARCHAR2(1);

Line 1307: FROM Okc_Subclasses_V

1303: FROM Okc_Subclasses_B
1304: WHERE code = p_code;
1305: CURSOR c2 (p_meaning IN okc_subclasses_v.meaning%TYPE) IS
1306: SELECT 'x'
1307: FROM Okc_Subclasses_V
1308: WHERE meaning = p_meaning;
1309: l_dummy VARCHAR2(1);
1310: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1311: l_row_found BOOLEAN := FALSE;

Line 1720: -- lock_row for:OKC_SUBCLASSES_V --

1716: '_PVT'
1717: );
1718: END lock_row;
1719: -----------------------------------
1720: -- lock_row for:OKC_SUBCLASSES_V --
1721: -----------------------------------
1722: PROCEDURE lock_row(
1723: p_api_version IN NUMBER,
1724: p_init_msg_list IN VARCHAR2,

Line 2223: -- update_row for:OKC_SUBCLASSES_V --

2219: '_PVT'
2220: );
2221: END update_row;
2222: -------------------------------------
2223: -- update_row for:OKC_SUBCLASSES_V --
2224: -------------------------------------
2225: PROCEDURE update_row(
2226: p_api_version IN NUMBER,
2227: p_init_msg_list IN VARCHAR2,

Line 2340: -- Set_Attributes for:OKC_SUBCLASSES_V --

2336: END IF;
2337: RETURN(l_return_status);
2338: END populate_new_record;
2339: -----------------------------------------
2340: -- Set_Attributes for:OKC_SUBCLASSES_V --
2341: -----------------------------------------
2342: FUNCTION Set_Attributes (
2343: p_scsv_rec IN scsv_rec_type,
2344: x_scsv_rec OUT NOCOPY scsv_rec_type

Line 2688: -- delete_row for:OKC_SUBCLASSES_V --

2684: '_PVT'
2685: );
2686: END delete_row;
2687: -------------------------------------
2688: -- delete_row for:OKC_SUBCLASSES_V --
2689: -------------------------------------
2690: PROCEDURE delete_row(
2691: p_api_version IN NUMBER,
2692: p_init_msg_list IN VARCHAR2,