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_V

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