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.OKL_TMG_PVT dependencies on OKL_TRX_MSGS

Line 94: -- FUNCTION get_rec for: OKL_TRX_MSGS_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_TRX_MSGS_V
95: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
96: ---------------------------------------------------------------------------
97: FUNCTION get_rec (
98: p_tmgv_rec IN tmgv_rec_type,

Line 123: FROM Okl_Trx_Msgs_V

119: LAST_UPDATED_BY,
120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN,
122: TMG_RUN -- RMUNJULU 3018641 Added Column
123: FROM Okl_Trx_Msgs_V
124: WHERE okl_trx_msgs_v.id = p_id;
125: l_okl_tmgv_pk okl_tmgv_pk_csr%ROWTYPE;
126: l_tmgv_rec tmgv_rec_type;
127: BEGIN

Line 124: WHERE okl_trx_msgs_v.id = p_id;

120: LAST_UPDATE_DATE,
121: LAST_UPDATE_LOGIN,
122: TMG_RUN -- RMUNJULU 3018641 Added Column
123: FROM Okl_Trx_Msgs_V
124: WHERE okl_trx_msgs_v.id = p_id;
125: l_okl_tmgv_pk okl_tmgv_pk_csr%ROWTYPE;
126: l_tmgv_rec tmgv_rec_type;
127: BEGIN
128: x_no_data_found := TRUE;

Line 190: -- FUNCTION get_rec for: OKL_TRX_MSGS

186: BEGIN
187: RETURN(get_rec(p_tmgv_rec, l_row_not_found));
188: END get_rec;
189: ---------------------------------------------------------------------------
190: -- FUNCTION get_rec for: OKL_TRX_MSGS
191: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
192: ---------------------------------------------------------------------------
193: FUNCTION get_rec (
194: p_tmg_rec IN tmg_rec_type,

Line 197: CURSOR okl_trx_msgs_pk_csr (p_id IN NUMBER) IS

193: FUNCTION get_rec (
194: p_tmg_rec IN tmg_rec_type,
195: x_no_data_found OUT NOCOPY BOOLEAN
196: ) RETURN tmg_rec_type IS
197: CURSOR okl_trx_msgs_pk_csr (p_id IN NUMBER) IS
198: SELECT
199: ID,
200: SEQUENCE_NUMBER,
201: TRX_ID,

Line 219: FROM Okl_Trx_Msgs

215: LAST_UPDATED_BY,
216: LAST_UPDATE_DATE,
217: LAST_UPDATE_LOGIN,
218: TMG_RUN -- RMUNJULU 3018641 Added Column
219: FROM Okl_Trx_Msgs
220: WHERE okl_trx_msgs.id = p_id;
221: l_okl_trx_msgs_pk okl_trx_msgs_pk_csr%ROWTYPE;
222: l_tmg_rec tmg_rec_type;
223: BEGIN

Line 220: WHERE okl_trx_msgs.id = p_id;

216: LAST_UPDATE_DATE,
217: LAST_UPDATE_LOGIN,
218: TMG_RUN -- RMUNJULU 3018641 Added Column
219: FROM Okl_Trx_Msgs
220: WHERE okl_trx_msgs.id = p_id;
221: l_okl_trx_msgs_pk okl_trx_msgs_pk_csr%ROWTYPE;
222: l_tmg_rec tmg_rec_type;
223: BEGIN
224: x_no_data_found := TRUE;

Line 221: l_okl_trx_msgs_pk okl_trx_msgs_pk_csr%ROWTYPE;

217: LAST_UPDATE_LOGIN,
218: TMG_RUN -- RMUNJULU 3018641 Added Column
219: FROM Okl_Trx_Msgs
220: WHERE okl_trx_msgs.id = p_id;
221: l_okl_trx_msgs_pk okl_trx_msgs_pk_csr%ROWTYPE;
222: l_tmg_rec tmg_rec_type;
223: BEGIN
224: x_no_data_found := TRUE;
225: -- Get current database values

Line 226: OPEN okl_trx_msgs_pk_csr (p_tmg_rec.id);

222: l_tmg_rec tmg_rec_type;
223: BEGIN
224: x_no_data_found := TRUE;
225: -- Get current database values
226: OPEN okl_trx_msgs_pk_csr (p_tmg_rec.id);
227: FETCH okl_trx_msgs_pk_csr INTO
228: l_tmg_rec.id,
229: l_tmg_rec.sequence_number,
230: l_tmg_rec.trx_id,

Line 227: FETCH okl_trx_msgs_pk_csr INTO

223: BEGIN
224: x_no_data_found := TRUE;
225: -- Get current database values
226: OPEN okl_trx_msgs_pk_csr (p_tmg_rec.id);
227: FETCH okl_trx_msgs_pk_csr INTO
228: l_tmg_rec.id,
229: l_tmg_rec.sequence_number,
230: l_tmg_rec.trx_id,
231: l_tmg_rec.trx_source_table,

Line 248: x_no_data_found := okl_trx_msgs_pk_csr%NOTFOUND;

244: l_tmg_rec.last_updated_by,
245: l_tmg_rec.last_update_date,
246: l_tmg_rec.last_update_login,
247: l_tmg_rec.tmg_run; -- RMUNJULU 3018641 Added Column
248: x_no_data_found := okl_trx_msgs_pk_csr%NOTFOUND;
249: CLOSE okl_trx_msgs_pk_csr;
250: RETURN(l_tmg_rec);
251: END get_rec;
252:

Line 249: CLOSE okl_trx_msgs_pk_csr;

245: l_tmg_rec.last_update_date,
246: l_tmg_rec.last_update_login,
247: l_tmg_rec.tmg_run; -- RMUNJULU 3018641 Added Column
248: x_no_data_found := okl_trx_msgs_pk_csr%NOTFOUND;
249: CLOSE okl_trx_msgs_pk_csr;
250: RETURN(l_tmg_rec);
251: END get_rec;
252:
253: ------------------------------------------------------------------

Line 285: -- FUNCTION null_out_defaults for: OKL_TRX_MSGS_V

281: BEGIN
282: RETURN(get_rec(p_tmg_rec, l_row_not_found));
283: END get_rec;
284: ---------------------------------------------------------------------------
285: -- FUNCTION null_out_defaults for: OKL_TRX_MSGS_V
286: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_tmgv_rec IN tmgv_rec_type

Line 376: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_TRX_MSGS_V'

372: END IF;
373:
374: /*Bug 4603850 :Commented
375: -- Verify the value fits the length of the column in the database
376: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_TRX_MSGS_V'
377: ,p_col_name => 'id'
378: ,p_col_value => p_id
379: ,x_return_status => x_return_status);
380: -- verify that length is within allowed limits

Line 416: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_TRX_MSGS_V'

412: END IF;
413: /*Bug 4603850 :Commented
414:
415: -- Verify the value fits the length of the column in the database
416: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_TRX_MSGS_V'
417: ,p_col_name => 'object_version_number'
418: ,p_col_value => p_object_version_number
419: ,x_return_status => x_return_status);
420: -- verify that length is within allowed limits

Line 443: -- Validate_Attributes for:OKL_TRX_MSGS_V --

439: ---------------------------------------------------------------------------
440: -- FUNCTION Validate_Attributes
441: ---------------------------------------------------------------------------
442: --------------------------------------------
443: -- Validate_Attributes for:OKL_TRX_MSGS_V --
444: --------------------------------------------
445: FUNCTION Validate_Attributes (
446: p_tmgv_rec IN tmgv_rec_type
447: ) RETURN VARCHAR2 IS

Line 453: OKC_UTIL.ADD_VIEW('OKL_TRX_MSGS_V', x_return_status);

449: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
450: BEGIN
451: /*Bug 4603850 :Commented
452: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
453: OKC_UTIL.ADD_VIEW('OKL_TRX_MSGS_V', x_return_status);
454: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
455: l_return_status := x_return_status;
456: RAISE G_EXCEPTION_HALT_VALIDATION;
457: END IF;

Line 498: -- Validate Record for:OKL_TRX_MSGS_V --

494: ---------------------------------------------------------------------------
495: -- PROCEDURE Validate_Record
496: ---------------------------------------------------------------------------
497: ----------------------------------------
498: -- Validate Record for:OKL_TRX_MSGS_V --
499: ----------------------------------------
500: FUNCTION Validate_Record (
501: p_tmgv_rec IN tmgv_rec_type,
502: p_db_tmgv_rec IN tmgv_rec_type

Line 653: -- validate_row for:OKL_TRX_MSGS_V --

649: ---------------------------------------------------------------------------
650: -- PROCEDURE validate_row
651: ---------------------------------------------------------------------------
652: -------------------------------------
653: -- validate_row for:OKL_TRX_MSGS_V --
654: -------------------------------------
655: PROCEDURE validate_row(
656: p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 730: -- PL/SQL TBL validate_row for:OKL_TRX_MSGS_V --

726: '_PVT'
727: );
728: END validate_row;
729: ------------------------------------------------
730: -- PL/SQL TBL validate_row for:OKL_TRX_MSGS_V --
731: ------------------------------------------------
732: PROCEDURE validate_row(
733: p_api_version IN NUMBER,
734: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 826: -- PL/SQL TBL validate_row for:OKL_TRX_MSGS_V --

822: );
823: END validate_row;
824:
825: ------------------------------------------------
826: -- PL/SQL TBL validate_row for:OKL_TRX_MSGS_V --
827: ------------------------------------------------
828: PROCEDURE validate_row(
829: p_api_version IN NUMBER,
830: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 892: -- insert_row for:OKL_TRX_MSGS --

888: -- PROCEDURE insert_row
889: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
890: ---------------------------------------------------------------------------
891: ---------------------------------
892: -- insert_row for:OKL_TRX_MSGS --
893: ---------------------------------
894: PROCEDURE insert_row(
895: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
896: x_return_status OUT NOCOPY VARCHAR2,

Line 908: -- Set_Attributes for:OKL_TRX_MSGS --

904: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
905: l_tmg_rec tmg_rec_type := p_tmg_rec;
906: l_def_tmg_rec tmg_rec_type;
907: -------------------------------------
908: -- Set_Attributes for:OKL_TRX_MSGS --
909: -------------------------------------
910: FUNCTION Set_Attributes (
911: p_tmg_rec IN tmg_rec_type,
912: x_tmg_rec OUT NOCOPY tmg_rec_type

Line 939: INSERT INTO OKL_TRX_MSGS(

935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939: INSERT INTO OKL_TRX_MSGS(
940: id,
941: sequence_number,
942: trx_id,
943: trx_source_table,

Line 1020: -- insert_row for :OKL_TRX_MSGS_V --

1016: '_PVT'
1017: );
1018: END insert_row;
1019: ------------------------------------
1020: -- insert_row for :OKL_TRX_MSGS_V --
1021: ------------------------------------
1022: PROCEDURE insert_row(
1023: p_api_version IN NUMBER,
1024: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1054: -- Set_Attributes for:OKL_TRX_MSGS_V --

1050: l_tmgv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1051: RETURN(l_tmgv_rec);
1052: END fill_who_columns;
1053: ---------------------------------------
1054: -- Set_Attributes for:OKL_TRX_MSGS_V --
1055: ---------------------------------------
1056: FUNCTION Set_Attributes (
1057: p_tmgv_rec IN tmgv_rec_type,
1058: x_tmgv_rec OUT NOCOPY tmgv_rec_type

Line 1330: -- lock_row for:OKL_TRX_MSGS --

1326: ---------------------------------------------------------------------------
1327: -- PROCEDURE lock_row
1328: ---------------------------------------------------------------------------
1329: -------------------------------
1330: -- lock_row for:OKL_TRX_MSGS --
1331: -------------------------------
1332: PROCEDURE lock_row(
1333: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1334: x_return_status OUT NOCOPY VARCHAR2,

Line 1343: FROM OKL_TRX_MSGS

1339: E_Resource_Busy EXCEPTION;
1340: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1341: CURSOR lock_csr (p_tmg_rec IN tmg_rec_type) IS
1342: SELECT OBJECT_VERSION_NUMBER
1343: FROM OKL_TRX_MSGS
1344: WHERE ID = p_tmg_rec.id
1345: AND OBJECT_VERSION_NUMBER = p_tmg_rec.object_version_number
1346: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1347:

Line 1350: FROM OKL_TRX_MSGS

1346: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1347:
1348: CURSOR lchk_csr (p_tmg_rec IN tmg_rec_type) IS
1349: SELECT OBJECT_VERSION_NUMBER
1350: FROM OKL_TRX_MSGS
1351: WHERE ID = p_tmg_rec.id;
1352: l_api_version CONSTANT NUMBER := 1;
1353: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1354: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1355: l_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;

1351: WHERE ID = p_tmg_rec.id;
1352: l_api_version CONSTANT NUMBER := 1;
1353: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1354: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1355: l_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;
1356: lc_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;
1357: l_row_notfound BOOLEAN := FALSE;
1358: lc_row_notfound BOOLEAN := FALSE;
1359: BEGIN

Line 1356: lc_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;

1352: l_api_version CONSTANT NUMBER := 1;
1353: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1354: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1355: l_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;
1356: lc_object_version_number OKL_TRX_MSGS.OBJECT_VERSION_NUMBER%TYPE;
1357: l_row_notfound BOOLEAN := FALSE;
1358: lc_row_notfound BOOLEAN := FALSE;
1359: BEGIN
1360: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1437: -- lock_row for: OKL_TRX_MSGS_V --

1433: '_PVT'
1434: );
1435: END lock_row;
1436: ----------------------------------
1437: -- lock_row for: OKL_TRX_MSGS_V --
1438: ----------------------------------
1439: PROCEDURE lock_row(
1440: p_api_version IN NUMBER,
1441: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1678: -- update_row for:OKL_TRX_MSGS --

1674: -- PROCEDURE update_row
1675: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
1676: ---------------------------------------------------------------------------
1677: ---------------------------------
1678: -- update_row for:OKL_TRX_MSGS --
1679: ---------------------------------
1680: PROCEDURE update_row(
1681: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1682: x_return_status OUT NOCOPY VARCHAR2,

Line 1796: -- Set_Attributes for:OKL_TRX_MSGS --

1792: END IF;
1793: RETURN(l_return_status);
1794: END populate_new_record;
1795: -------------------------------------
1796: -- Set_Attributes for:OKL_TRX_MSGS --
1797: -------------------------------------
1798: FUNCTION Set_Attributes (
1799: p_tmg_rec IN tmg_rec_type,
1800: x_tmg_rec OUT NOCOPY tmg_rec_type

Line 1834: UPDATE OKL_TRX_MSGS

1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: UPDATE OKL_TRX_MSGS
1835: SET SEQUENCE_NUMBER = l_def_tmg_rec.sequence_number,
1836: TRX_ID = l_def_tmg_rec.trx_id,
1837: TRX_SOURCE_TABLE = l_def_tmg_rec.trx_source_table,
1838: BCH_ID = l_def_tmg_rec.bch_id,

Line 1892: -- update_row for:OKL_TRX_MSGS_V --

1888: '_PVT'
1889: );
1890: END update_row;
1891: -----------------------------------
1892: -- update_row for:OKL_TRX_MSGS_V --
1893: -- RMUNJULU 3018641 Added Code for New Column TMG_RUN
1894: -----------------------------------
1895: PROCEDURE update_row(
1896: p_api_version IN NUMBER,

Line 2024: -- Set_Attributes for:OKL_TRX_MSGS_V --

2020: END IF;
2021: RETURN(l_return_status);
2022: END populate_new_record;
2023: ---------------------------------------
2024: -- Set_Attributes for:OKL_TRX_MSGS_V --
2025: ---------------------------------------
2026: FUNCTION Set_Attributes (
2027: p_tmgv_rec IN tmgv_rec_type,
2028: x_tmgv_rec OUT NOCOPY tmgv_rec_type

Line 2316: -- delete_row for:OKL_TRX_MSGS --

2312: ---------------------------------------------------------------------------
2313: -- PROCEDURE delete_row
2314: ---------------------------------------------------------------------------
2315: ---------------------------------
2316: -- delete_row for:OKL_TRX_MSGS --
2317: ---------------------------------
2318: PROCEDURE delete_row(
2319: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2320: x_return_status OUT NOCOPY VARCHAR2,

Line 2341: DELETE FROM OKL_TRX_MSGS

2337: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2338: RAISE OKL_API.G_EXCEPTION_ERROR;
2339: END IF;
2340:
2341: DELETE FROM OKL_TRX_MSGS
2342: WHERE ID = p_tmg_rec.id;
2343:
2344: x_return_status := l_return_status;
2345: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2379: -- delete_row for:OKL_TRX_MSGS_V --

2375: '_PVT'
2376: );
2377: END delete_row;
2378: -----------------------------------
2379: -- delete_row for:OKL_TRX_MSGS_V --
2380: -----------------------------------
2381: PROCEDURE delete_row(
2382: p_api_version IN NUMBER,
2383: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2461: -- PL/SQL TBL delete_row for:OKL_TRX_MSGS_V --

2457: '_PVT'
2458: );
2459: END delete_row;
2460: ----------------------------------------------
2461: -- PL/SQL TBL delete_row for:OKL_TRX_MSGS_V --
2462: ----------------------------------------------
2463: PROCEDURE delete_row(
2464: p_api_version IN NUMBER,
2465: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2557: -- PL/SQL TBL delete_row for:OKL_TRX_MSGS_V --

2553: );
2554: END delete_row;
2555:
2556: ----------------------------------------------
2557: -- PL/SQL TBL delete_row for:OKL_TRX_MSGS_V --
2558: ----------------------------------------------
2559: PROCEDURE delete_row(
2560: p_api_version IN NUMBER,
2561: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,