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_V

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 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 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 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 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 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,