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.OKS_MOD_PVT dependencies on OKS_MSCHG_OPERATIONS_DTLS

Line 94: -- FUNCTION get_rec for: OKS_MSCHG_OPERATIONS_DTLS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_MSCHG_OPERATIONS_DTLS_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 131: FROM Oks_Mschg_Operations_Dtls_V

127: ATTRIBUTE12,
128: ATTRIBUTE13,
129: ATTRIBUTE14,
130: ATTRIBUTE15
131: FROM Oks_Mschg_Operations_Dtls_V
132: WHERE oks_mschg_operations_dtls_v.id = p_id;
133: l_oks_modv_pk oks_modv_pk_csr%ROWTYPE;
134: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType;
135: BEGIN

Line 132: WHERE oks_mschg_operations_dtls_v.id = p_id;

128: ATTRIBUTE13,
129: ATTRIBUTE14,
130: ATTRIBUTE15
131: FROM Oks_Mschg_Operations_Dtls_V
132: WHERE oks_mschg_operations_dtls_v.id = p_id;
133: l_oks_modv_pk oks_modv_pk_csr%ROWTYPE;
134: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType;
135: BEGIN
136: x_no_data_found := TRUE;

Line 203: -- FUNCTION get_rec for: OKS_MSCHG_OPERATIONS_DTLS

199: BEGIN
200: RETURN(get_rec(p_OksMschgOperationsDtlsVRec, l_row_not_found));
201: END get_rec;
202: ---------------------------------------------------------------------------
203: -- FUNCTION get_rec for: OKS_MSCHG_OPERATIONS_DTLS
204: ---------------------------------------------------------------------------
205: FUNCTION get_rec (
206: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,
207: x_no_data_found OUT NOCOPY BOOLEAN

Line 239: FROM Oks_Mschg_Operations_Dtls

235: ATTRIBUTE12,
236: ATTRIBUTE13,
237: ATTRIBUTE14,
238: ATTRIBUTE15
239: FROM Oks_Mschg_Operations_Dtls
240: WHERE oks_mschg_operations_dtls.id = p_id;
241: l_oks_mschg_operations_dtls_pk oks_mschg_operation1%ROWTYPE;
242: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
243: BEGIN

Line 240: WHERE oks_mschg_operations_dtls.id = p_id;

236: ATTRIBUTE13,
237: ATTRIBUTE14,
238: ATTRIBUTE15
239: FROM Oks_Mschg_Operations_Dtls
240: WHERE oks_mschg_operations_dtls.id = p_id;
241: l_oks_mschg_operations_dtls_pk oks_mschg_operation1%ROWTYPE;
242: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
243: BEGIN
244: x_no_data_found := TRUE;

Line 241: l_oks_mschg_operations_dtls_pk oks_mschg_operation1%ROWTYPE;

237: ATTRIBUTE14,
238: ATTRIBUTE15
239: FROM Oks_Mschg_Operations_Dtls
240: WHERE oks_mschg_operations_dtls.id = p_id;
241: l_oks_mschg_operations_dtls_pk oks_mschg_operation1%ROWTYPE;
242: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
243: BEGIN
244: x_no_data_found := TRUE;
245: -- Get current database values

Line 310: -- FUNCTION null_out_defaults for: OKS_MSCHG_OPERATIONS_DTLS_V

306: BEGIN
307: RETURN(get_rec(p_oks_mschg_operati2, l_row_not_found));
308: END get_rec;
309: ---------------------------------------------------------------------------
310: -- FUNCTION null_out_defaults for: OKS_MSCHG_OPERATIONS_DTLS_V
311: ---------------------------------------------------------------------------
312: FUNCTION null_out_defaults (
313: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType
314: ) RETURN OksMschgOperationsDtlsVRecType IS

Line 437: -- Validate_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --

433: ---------------------------------------------------------------------------
434: -- FUNCTION Validate_Attributes
435: ---------------------------------------------------------------------------
436: ---------------------------------------------------------
437: -- Validate_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --
438: ---------------------------------------------------------
439: FUNCTION Validate_Attributes (
440: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType
441: ) RETURN VARCHAR2 IS

Line 475: -- Validate Record for:OKS_MSCHG_OPERATIONS_DTLS_V --

471: ---------------------------------------------------------------------------
472: -- PROCEDURE Validate_Record
473: ---------------------------------------------------------------------------
474: -----------------------------------------------------
475: -- Validate Record for:OKS_MSCHG_OPERATIONS_DTLS_V --
476: -----------------------------------------------------
477: FUNCTION Validate_Record (
478: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
479: p_db_OksMschgOperat41 IN OksMschgOperationsDtlsVRecType

Line 571: -- validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

567: ---------------------------------------------------------------------------
568: -- PROCEDURE validate_row
569: ---------------------------------------------------------------------------
570: --------------------------------------------------
571: -- validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
572: --------------------------------------------------
573: PROCEDURE validate_row(
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 648: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

644: '_PVT'
645: );
646: END validate_row;
647: -------------------------------------------------------------
648: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
649: -------------------------------------------------------------
650: PROCEDURE validate_row(
651: p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 744: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

740: );
741: END validate_row;
742:
743: -------------------------------------------------------------
744: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
745: -------------------------------------------------------------
746: PROCEDURE validate_row(
747: p_api_version IN NUMBER,
748: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 809: -- insert_row for:OKS_MSCHG_OPERATIONS_DTLS --

805: ---------------------------------------------------------------------------
806: -- PROCEDURE insert_row
807: ---------------------------------------------------------------------------
808: ----------------------------------------------
809: -- insert_row for:OKS_MSCHG_OPERATIONS_DTLS --
810: ----------------------------------------------
811: PROCEDURE insert_row(
812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
813: x_return_status OUT NOCOPY VARCHAR2,

Line 825: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS --

821: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
822: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType := p_oks_mschg_operati2;
823: LDefOksMschgOperationsDtlsRec OksMschgOperationsDtlsRecType;
824: --------------------------------------------------
825: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS --
826: --------------------------------------------------
827: FUNCTION Set_Attributes (
828: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,
829: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType

Line 856: INSERT INTO OKS_MSCHG_OPERATIONS_DTLS(

852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856: INSERT INTO OKS_MSCHG_OPERATIONS_DTLS(
857: id,
858: mrd_id,
859: oie_id,
860: ole_id,

Line 959: -- insert_row for :OKS_MSCHG_OPERATIONS_DTLS_V --

955: '_PVT'
956: );
957: END insert_row;
958: -------------------------------------------------
959: -- insert_row for :OKS_MSCHG_OPERATIONS_DTLS_V --
960: -------------------------------------------------
961: PROCEDURE insert_row(
962: p_api_version IN NUMBER,
963: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 993: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --

989: l_OksMschgOperationsDtlsVRec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
990: RETURN(l_OksMschgOperationsDtlsVRec);
991: END fill_who_columns;
992: ----------------------------------------------------
993: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --
994: ----------------------------------------------------
995: FUNCTION Set_Attributes (
996: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
997: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType

Line 1269: -- lock_row for:OKS_MSCHG_OPERATIONS_DTLS --

1265: ---------------------------------------------------------------------------
1266: -- PROCEDURE lock_row
1267: ---------------------------------------------------------------------------
1268: --------------------------------------------
1269: -- lock_row for:OKS_MSCHG_OPERATIONS_DTLS --
1270: --------------------------------------------
1271: PROCEDURE lock_row(
1272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1273: x_return_status OUT NOCOPY VARCHAR2,

Line 1282: FROM OKS_MSCHG_OPERATIONS_DTLS

1278: E_Resource_Busy EXCEPTION;
1279: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1280: CURSOR lock_csr (p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType) IS
1281: SELECT OBJECT_VERSION_NUMBER
1282: FROM OKS_MSCHG_OPERATIONS_DTLS
1283: WHERE ID = p_oks_mschg_operati2.id
1284: AND OBJECT_VERSION_NUMBER = p_oks_mschg_operati2.object_version_number
1285: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1286:

Line 1289: FROM OKS_MSCHG_OPERATIONS_DTLS

1285: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1286:
1287: CURSOR lchk_csr (p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType) IS
1288: SELECT OBJECT_VERSION_NUMBER
1289: FROM OKS_MSCHG_OPERATIONS_DTLS
1290: WHERE ID = p_oks_mschg_operati2.id;
1291: l_api_version CONSTANT NUMBER := 1;
1292: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1293: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1294: l_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1290: WHERE ID = p_oks_mschg_operati2.id;
1291: l_api_version CONSTANT NUMBER := 1;
1292: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1293: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1294: l_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1295: lc_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1296: l_row_notfound BOOLEAN := FALSE;
1297: lc_row_notfound BOOLEAN := FALSE;
1298: BEGIN

Line 1295: lc_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;

1291: l_api_version CONSTANT NUMBER := 1;
1292: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1293: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1294: l_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1295: lc_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1296: l_row_notfound BOOLEAN := FALSE;
1297: lc_row_notfound BOOLEAN := FALSE;
1298: BEGIN
1299: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1376: -- lock_row for: OKS_MSCHG_OPERATIONS_DTLS_V --

1372: '_PVT'
1373: );
1374: END lock_row;
1375: -----------------------------------------------
1376: -- lock_row for: OKS_MSCHG_OPERATIONS_DTLS_V --
1377: -----------------------------------------------
1378: PROCEDURE lock_row(
1379: p_api_version IN NUMBER,
1380: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1616: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS --

1612: ---------------------------------------------------------------------------
1613: -- PROCEDURE update_row
1614: ---------------------------------------------------------------------------
1615: ----------------------------------------------
1616: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS --
1617: ----------------------------------------------
1618: PROCEDURE update_row(
1619: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1620: x_return_status OUT NOCOPY VARCHAR2,

Line 1763: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS --

1759: END IF;
1760: RETURN(l_return_status);
1761: END populate_new_record;
1762: --------------------------------------------------
1763: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS --
1764: --------------------------------------------------
1765: FUNCTION Set_Attributes (
1766: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,
1767: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType

Line 1801: UPDATE OKS_MSCHG_OPERATIONS_DTLS

1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1798: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1799: RAISE OKC_API.G_EXCEPTION_ERROR;
1800: END IF;
1801: UPDATE OKS_MSCHG_OPERATIONS_DTLS
1802: SET MRD_ID = LDefOksMschgOperationsDtlsRec.mrd_id,
1803: OIE_ID = LDefOksMschgOperationsDtlsRec.oie_id,
1804: OLE_ID = LDefOksMschgOperationsDtlsRec.ole_id,
1805: MSCHG_TYPE = LDefOksMschgOperationsDtlsRec.mschg_type,

Line 1867: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

1863: '_PVT'
1864: );
1865: END update_row;
1866: ------------------------------------------------
1867: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
1868: ------------------------------------------------
1869: PROCEDURE update_row(
1870: p_api_version IN NUMBER,
1871: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2031: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --

2027: END IF;
2028: RETURN(l_return_status);
2029: END populate_new_record;
2030: ----------------------------------------------------
2031: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS_V --
2032: ----------------------------------------------------
2033: FUNCTION Set_Attributes (
2034: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
2035: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType

Line 2323: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS --

2319: ---------------------------------------------------------------------------
2320: -- PROCEDURE delete_row
2321: ---------------------------------------------------------------------------
2322: ----------------------------------------------
2323: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS --
2324: ----------------------------------------------
2325: PROCEDURE delete_row(
2326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2327: x_return_status OUT NOCOPY VARCHAR2,

Line 2348: DELETE FROM OKS_MSCHG_OPERATIONS_DTLS

2344: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_ERROR;
2346: END IF;
2347:
2348: DELETE FROM OKS_MSCHG_OPERATIONS_DTLS
2349: WHERE ID = p_oks_mschg_operati2.id;
2350:
2351: x_return_status := l_return_status;
2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2386: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

2382: '_PVT'
2383: );
2384: END delete_row;
2385: ------------------------------------------------
2386: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2387: ------------------------------------------------
2388: PROCEDURE delete_row(
2389: p_api_version IN NUMBER,
2390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2468: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

2464: '_PVT'
2465: );
2466: END delete_row;
2467: -----------------------------------------------------------
2468: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2469: -----------------------------------------------------------
2470: PROCEDURE delete_row(
2471: p_api_version IN NUMBER,
2472: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2564: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --

2560: );
2561: END delete_row;
2562:
2563: -----------------------------------------------------------
2564: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2565: -----------------------------------------------------------
2566: PROCEDURE delete_row(
2567: p_api_version IN NUMBER,
2568: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,