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_SGT_PVT dependencies on OKL_SGN_TRANSLATIONS

Line 97: -- FUNCTION get_rec for: OKL_SGN_TRANSLATIONS_V

93: null;
94: END api_copy;
95:
96: ---------------------------------------------------------------------------
97: -- FUNCTION get_rec for: OKL_SGN_TRANSLATIONS_V
98: ---------------------------------------------------------------------------
99: FUNCTION get_rec (
100: p_sgnv_rec IN sgnv_rec_type,
101: x_no_data_found OUT NOCOPY BOOLEAN

Line 136: FROM Okl_Sgn_Translations_V

132: CREATION_DATE,
133: LAST_UPDATED_BY,
134: LAST_UPDATE_DATE,
135: LAST_UPDATE_LOGIN
136: FROM Okl_Sgn_Translations_V
137: WHERE okl_sgn_translations_v.id = p_id;
138: l_sgnv_pk sgnv_pk_csr%ROWTYPE;
139: l_sgnv_rec sgnv_rec_type;
140: BEGIN

Line 137: WHERE okl_sgn_translations_v.id = p_id;

133: LAST_UPDATED_BY,
134: LAST_UPDATE_DATE,
135: LAST_UPDATE_LOGIN
136: FROM Okl_Sgn_Translations_V
137: WHERE okl_sgn_translations_v.id = p_id;
138: l_sgnv_pk sgnv_pk_csr%ROWTYPE;
139: l_sgnv_rec sgnv_rec_type;
140: BEGIN
141: x_no_data_found := TRUE;

Line 210: -- FUNCTION get_rec for: OKL_SGN_TRANSLATIONS

206: BEGIN
207: RETURN(get_rec(p_sgnv_rec, l_row_not_found));
208: END get_rec;
209: ---------------------------------------------------------------------------
210: -- FUNCTION get_rec for: OKL_SGN_TRANSLATIONS
211: ---------------------------------------------------------------------------
212: FUNCTION get_rec (
213: p_sgt_rec IN sgt_rec_type,
214: x_no_data_found OUT NOCOPY BOOLEAN

Line 249: FROM Okl_Sgn_Translations

245: CREATION_DATE,
246: LAST_UPDATED_BY,
247: LAST_UPDATE_DATE,
248: LAST_UPDATE_LOGIN
249: FROM Okl_Sgn_Translations
250: WHERE okl_sgn_translations.id = p_id;
251: l_sgt_pk sgt_pk_csr%ROWTYPE;
252: l_sgt_rec sgt_rec_type;
253: BEGIN

Line 250: WHERE okl_sgn_translations.id = p_id;

246: LAST_UPDATED_BY,
247: LAST_UPDATE_DATE,
248: LAST_UPDATE_LOGIN
249: FROM Okl_Sgn_Translations
250: WHERE okl_sgn_translations.id = p_id;
251: l_sgt_pk sgt_pk_csr%ROWTYPE;
252: l_sgt_rec sgt_rec_type;
253: BEGIN
254: x_no_data_found := TRUE;

Line 323: -- FUNCTION null_out_defaults for: OKL_SGN_TRANSLATIONS_V

319: BEGIN
320: RETURN(get_rec(p_sgt_rec, l_row_not_found));
321: END get_rec;
322: ---------------------------------------------------------------------------
323: -- FUNCTION null_out_defaults for: OKL_SGN_TRANSLATIONS_V
324: ---------------------------------------------------------------------------
325: FUNCTION null_out_defaults (
326: p_sgnv_rec IN sgnv_rec_type
327: ) RETURN sgnv_rec_type IS

Line 719: -- Validate_Attributes for:OKL_SGN_TRANSLATIONS_V --

715: ---------------------------------------------------------------------------
716: -- FUNCTION Validate_Attributes
717: ---------------------------------------------------------------------------
718: ----------------------------------------------------
719: -- Validate_Attributes for:OKL_SGN_TRANSLATIONS_V --
720: ----------------------------------------------------
721: FUNCTION Validate_Attributes (
722: p_sgnv_rec IN sgnv_rec_type
723: ) RETURN VARCHAR2 IS

Line 826: -- Validate Record for:OKL_SGN_TRANSLATIONS_V --

822: ---------------------------------------------------------------------------
823: -- PROCEDURE Validate_Record
824: ---------------------------------------------------------------------------
825: ------------------------------------------------
826: -- Validate Record for:OKL_SGN_TRANSLATIONS_V --
827: ------------------------------------------------
828: FUNCTION Validate_Record (
829: p_sgnv_rec IN sgnv_rec_type,
830: p_db_sgnv_rec IN sgnv_rec_type

Line 969: -- validate_row for:OKL_SGN_TRANSLATIONS_V --

965: ---------------------------------------------------------------------------
966: -- PROCEDURE validate_row
967: ---------------------------------------------------------------------------
968: ---------------------------------------------
969: -- validate_row for:OKL_SGN_TRANSLATIONS_V --
970: ---------------------------------------------
971: PROCEDURE validate_row(
972: p_api_version IN NUMBER,
973: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1046: -- PL/SQL TBL validate_row for:OKL_SGN_TRANSLATIONS_V --

1042: '_PVT'
1043: );
1044: END validate_row;
1045: --------------------------------------------------------
1046: -- PL/SQL TBL validate_row for:OKL_SGN_TRANSLATIONS_V --
1047: --------------------------------------------------------
1048: PROCEDURE validate_row(
1049: p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1142: -- PL/SQL TBL validate_row for:OKL_SGN_TRANSLATIONS_V --

1138: );
1139: END validate_row;
1140:
1141: --------------------------------------------------------
1142: -- PL/SQL TBL validate_row for:OKL_SGN_TRANSLATIONS_V --
1143: --------------------------------------------------------
1144: PROCEDURE validate_row(
1145: p_api_version IN NUMBER,
1146: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1207: -- insert_row for:OKL_SGN_TRANSLATIONS --

1203: ---------------------------------------------------------------------------
1204: -- PROCEDURE insert_row
1205: ---------------------------------------------------------------------------
1206: -----------------------------------------
1207: -- insert_row for:OKL_SGN_TRANSLATIONS --
1208: -----------------------------------------
1209: PROCEDURE insert_row(
1210: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1211: x_return_status OUT NOCOPY VARCHAR2,

Line 1223: -- Set_Attributes for:OKL_SGN_TRANSLATIONS --

1219: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1220: l_sgt_rec sgt_rec_type := p_sgt_rec;
1221: l_def_sgt_rec sgt_rec_type;
1222: ---------------------------------------------
1223: -- Set_Attributes for:OKL_SGN_TRANSLATIONS --
1224: ---------------------------------------------
1225: FUNCTION Set_Attributes (
1226: p_sgt_rec IN sgt_rec_type,
1227: x_sgt_rec OUT NOCOPY sgt_rec_type

Line 1254: INSERT INTO OKL_SGN_TRANSLATIONS(

1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_ERROR;
1253: END IF;
1254: INSERT INTO OKL_SGN_TRANSLATIONS(
1255: id,
1256: jtot_object1_code,
1257: object1_id1,
1258: object1_id2,

Line 1355: -- insert_row for :OKL_SGN_TRANSLATIONS_V --

1351: '_PVT'
1352: );
1353: END insert_row;
1354: --------------------------------------------
1355: -- insert_row for :OKL_SGN_TRANSLATIONS_V --
1356: --------------------------------------------
1357: PROCEDURE insert_row(
1358: p_api_version IN NUMBER,
1359: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1378: FROM okl_sgn_translations_v

1374: CURSOR object1_id1_csr (p_jtot_object1_code IN VARCHAR2,
1375: p_sgn_code IN VARCHAR2,
1376: p_object1_id1 IN VARCHAR2) IS
1377: SELECT '1'
1378: FROM okl_sgn_translations_v
1379: WHERE jtot_object1_code = p_jtot_object1_code
1380: AND sgn_code = p_sgn_code
1381: AND object1_id1 = p_object1_id1;
1382: /*

Line 1388: FROM okl_sgn_translations_v

1384: p_sgn_code IN VARCHAR2,
1385: p_object1_id1 IN VARCHAR2,
1386: p_value IN VARCHAR2) IS
1387: SELECT '1'
1388: FROM okl_sgn_translations_v
1389: WHERE jtot_object1_code = p_jtot_object1_code
1390: AND sgn_code = p_sgn_code
1391: AND object1_id1 = p_object1_id1
1392: AND value = p_value;

Line 1398: FROM okl_sgn_translations_v

1394: CURSOR fa_book_controls_csr (p_jtot_object1_code IN VARCHAR2,
1395: p_sgn_code IN VARCHAR2,
1396: p_object1_id1 IN VARCHAR2) IS
1397: SELECT '1'
1398: FROM okl_sgn_translations_v
1399: WHERE jtot_object1_code = p_jtot_object1_code
1400: AND sgn_code = p_sgn_code
1401: AND object1_id1 = p_object1_id1;
1402:

Line 1427: -- Set_Attributes for:OKL_SGN_TRANSLATIONS_V --

1423: l_sgnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1424: RETURN(l_sgnv_rec);
1425: END fill_who_columns;
1426: -----------------------------------------------
1427: -- Set_Attributes for:OKL_SGN_TRANSLATIONS_V --
1428: -----------------------------------------------
1429: FUNCTION Set_Attributes (
1430: p_sgnv_rec IN sgnv_rec_type,
1431: x_sgnv_rec OUT NOCOPY sgnv_rec_type

Line 1761: -- lock_row for:OKL_SGN_TRANSLATIONS --

1757: ---------------------------------------------------------------------------
1758: -- PROCEDURE lock_row
1759: ---------------------------------------------------------------------------
1760: ---------------------------------------
1761: -- lock_row for:OKL_SGN_TRANSLATIONS --
1762: ---------------------------------------
1763: PROCEDURE lock_row(
1764: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1765: x_return_status OUT NOCOPY VARCHAR2,

Line 1774: FROM OKL_SGN_TRANSLATIONS

1770: E_Resource_Busy EXCEPTION;
1771: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1772: CURSOR lock_csr (p_sgt_rec IN sgt_rec_type) IS
1773: SELECT OBJECT_VERSION_NUMBER
1774: FROM OKL_SGN_TRANSLATIONS
1775: WHERE ID = p_sgt_rec.id
1776: AND OBJECT_VERSION_NUMBER = p_sgt_rec.object_version_number
1777: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1778:

Line 1781: FROM OKL_SGN_TRANSLATIONS

1777: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1778:
1779: CURSOR lchk_csr (p_sgt_rec IN sgt_rec_type) IS
1780: SELECT OBJECT_VERSION_NUMBER
1781: FROM OKL_SGN_TRANSLATIONS
1782: WHERE ID = p_sgt_rec.id;
1783: l_api_version CONSTANT NUMBER := 1;
1784: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1786: l_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;

1782: WHERE ID = p_sgt_rec.id;
1783: l_api_version CONSTANT NUMBER := 1;
1784: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1786: l_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;
1787: lc_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;
1788: l_row_notfound BOOLEAN := FALSE;
1789: lc_row_notfound BOOLEAN := FALSE;
1790: BEGIN

Line 1787: lc_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;

1783: l_api_version CONSTANT NUMBER := 1;
1784: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1786: l_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;
1787: lc_object_version_number OKL_SGN_TRANSLATIONS.OBJECT_VERSION_NUMBER%TYPE;
1788: l_row_notfound BOOLEAN := FALSE;
1789: lc_row_notfound BOOLEAN := FALSE;
1790: BEGIN
1791: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1868: -- lock_row for: OKL_SGN_TRANSLATIONS_V --

1864: '_PVT'
1865: );
1866: END lock_row;
1867: ------------------------------------------
1868: -- lock_row for: OKL_SGN_TRANSLATIONS_V --
1869: ------------------------------------------
1870: PROCEDURE lock_row(
1871: p_api_version IN NUMBER,
1872: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2108: -- update_row for:OKL_SGN_TRANSLATIONS --

2104: ---------------------------------------------------------------------------
2105: -- PROCEDURE update_row
2106: ---------------------------------------------------------------------------
2107: -----------------------------------------
2108: -- update_row for:OKL_SGN_TRANSLATIONS --
2109: -----------------------------------------
2110: PROCEDURE update_row(
2111: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2112: x_return_status OUT NOCOPY VARCHAR2,

Line 2267: -- Set_Attributes for:OKL_SGN_TRANSLATIONS --

2263: END IF;
2264: RETURN(l_return_status);
2265: END populate_new_record;
2266: ---------------------------------------------
2267: -- Set_Attributes for:OKL_SGN_TRANSLATIONS --
2268: ---------------------------------------------
2269: FUNCTION Set_Attributes (
2270: p_sgt_rec IN sgt_rec_type,
2271: x_sgt_rec OUT NOCOPY sgt_rec_type

Line 2306: UPDATE OKL_SGN_TRANSLATIONS

2302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2303: RAISE OKL_API.G_EXCEPTION_ERROR;
2304: END IF;
2305:
2306: UPDATE OKL_SGN_TRANSLATIONS
2307: SET JTOT_OBJECT1_CODE = l_def_sgt_rec.jtot_object1_code,
2308: OBJECT1_ID1 = l_def_sgt_rec.object1_id1,
2309: OBJECT1_ID2 = l_def_sgt_rec.object1_id2,
2310: SGN_CODE = l_def_sgt_rec.sgn_code,

Line 2378: -- update_row for:OKL_SGN_TRANSLATIONS_V --

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

Line 2552: -- Set_Attributes for:OKL_SGN_TRANSLATIONS_V --

2548: END IF;
2549: RETURN(l_return_status);
2550: END populate_new_record;
2551: -----------------------------------------------
2552: -- Set_Attributes for:OKL_SGN_TRANSLATIONS_V --
2553: -----------------------------------------------
2554: FUNCTION Set_Attributes (
2555: p_sgnv_rec IN sgnv_rec_type,
2556: x_sgnv_rec OUT NOCOPY sgnv_rec_type

Line 2852: -- delete_row for:OKL_SGN_TRANSLATIONS --

2848: ---------------------------------------------------------------------------
2849: -- PROCEDURE delete_row
2850: ---------------------------------------------------------------------------
2851: -----------------------------------------
2852: -- delete_row for:OKL_SGN_TRANSLATIONS --
2853: -----------------------------------------
2854: PROCEDURE delete_row(
2855: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2856: x_return_status OUT NOCOPY VARCHAR2,

Line 2877: DELETE FROM OKL_SGN_TRANSLATIONS

2873: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2874: RAISE OKL_API.G_EXCEPTION_ERROR;
2875: END IF;
2876:
2877: DELETE FROM OKL_SGN_TRANSLATIONS
2878: WHERE ID = p_sgt_rec.id;
2879:
2880: x_return_status := l_return_status;
2881: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2915: -- delete_row for:OKL_SGN_TRANSLATIONS_V --

2911: '_PVT'
2912: );
2913: END delete_row;
2914: -------------------------------------------
2915: -- delete_row for:OKL_SGN_TRANSLATIONS_V --
2916: -------------------------------------------
2917: PROCEDURE delete_row(
2918: p_api_version IN NUMBER,
2919: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2997: -- PL/SQL TBL delete_row for:OKL_SGN_TRANSLATIONS_V --

2993: '_PVT'
2994: );
2995: END delete_row;
2996: ------------------------------------------------------
2997: -- PL/SQL TBL delete_row for:OKL_SGN_TRANSLATIONS_V --
2998: ------------------------------------------------------
2999: PROCEDURE delete_row(
3000: p_api_version IN NUMBER,
3001: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 3093: -- PL/SQL TBL delete_row for:OKL_SGN_TRANSLATIONS_V --

3089: );
3090: END delete_row;
3091:
3092: ------------------------------------------------------
3093: -- PL/SQL TBL delete_row for:OKL_SGN_TRANSLATIONS_V --
3094: ------------------------------------------------------
3095: PROCEDURE delete_row(
3096: p_api_version IN NUMBER,
3097: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,