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_ASE_PVT dependencies on OKL_ACCT_SOURCES

Line 39: -- FUNCTION get_rec for: OKL_ACCT_SOURCES_V

35: NULL;
36: END api_copy;
37:
38: ---------------------------------------------------------------------------
39: -- FUNCTION get_rec for: OKL_ACCT_SOURCES_V
40: ---------------------------------------------------------------------------
41: FUNCTION get_rec (
42: p_asev_rec IN asev_rec_type,
43: x_no_data_found OUT NOCOPY BOOLEAN

Line 92: FROM OKL_ACCT_SOURCES

88: CREATION_DATE,
89: LAST_UPDATED_BY,
90: LAST_UPDATE_DATE,
91: LAST_UPDATE_LOGIN
92: FROM OKL_ACCT_SOURCES
93: WHERE OKL_ACCT_SOURCES.id = p_id;
94: l_okl_asev_pk okl_asev_pk_csr%ROWTYPE;
95: l_asev_rec asev_rec_type;
96: BEGIN

Line 93: WHERE OKL_ACCT_SOURCES.id = p_id;

89: LAST_UPDATED_BY,
90: LAST_UPDATE_DATE,
91: LAST_UPDATE_LOGIN
92: FROM OKL_ACCT_SOURCES
93: WHERE OKL_ACCT_SOURCES.id = p_id;
94: l_okl_asev_pk okl_asev_pk_csr%ROWTYPE;
95: l_asev_rec asev_rec_type;
96: BEGIN
97: x_no_data_found := TRUE;

Line 180: -- FUNCTION get_rec for: OKL_ACCT_SOURCES

176: BEGIN
177: RETURN(get_rec(p_asev_rec, l_row_not_found));
178: END get_rec;
179: ---------------------------------------------------------------------------
180: -- FUNCTION get_rec for: OKL_ACCT_SOURCES
181: ---------------------------------------------------------------------------
182: FUNCTION get_rec (
183: p_ase_rec IN ase_rec_type,
184: x_no_data_found OUT NOCOPY BOOLEAN

Line 186: CURSOR okl_acct_sources_pk_csr (p_id IN NUMBER) IS

182: FUNCTION get_rec (
183: p_ase_rec IN ase_rec_type,
184: x_no_data_found OUT NOCOPY BOOLEAN
185: ) RETURN ase_rec_type IS
186: CURSOR okl_acct_sources_pk_csr (p_id IN NUMBER) IS
187: SELECT
188: ID,
189: SOURCE_TABLE,
190: SOURCE_ID,

Line 233: FROM OKL_ACCT_SOURCES

229: CREATION_DATE,
230: LAST_UPDATED_BY,
231: LAST_UPDATE_DATE,
232: LAST_UPDATE_LOGIN
233: FROM OKL_ACCT_SOURCES
234: WHERE OKL_ACCT_SOURCES.id = p_id;
235: l_okl_acct_sources_pk okl_acct_sources_pk_csr%ROWTYPE;
236: l_ase_rec ase_rec_type;
237: BEGIN

Line 234: WHERE OKL_ACCT_SOURCES.id = p_id;

230: LAST_UPDATED_BY,
231: LAST_UPDATE_DATE,
232: LAST_UPDATE_LOGIN
233: FROM OKL_ACCT_SOURCES
234: WHERE OKL_ACCT_SOURCES.id = p_id;
235: l_okl_acct_sources_pk okl_acct_sources_pk_csr%ROWTYPE;
236: l_ase_rec ase_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;

Line 235: l_okl_acct_sources_pk okl_acct_sources_pk_csr%ROWTYPE;

231: LAST_UPDATE_DATE,
232: LAST_UPDATE_LOGIN
233: FROM OKL_ACCT_SOURCES
234: WHERE OKL_ACCT_SOURCES.id = p_id;
235: l_okl_acct_sources_pk okl_acct_sources_pk_csr%ROWTYPE;
236: l_ase_rec ase_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values

Line 240: OPEN okl_acct_sources_pk_csr (p_ase_rec.id);

236: l_ase_rec ase_rec_type;
237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values
240: OPEN okl_acct_sources_pk_csr (p_ase_rec.id);
241: FETCH okl_acct_sources_pk_csr INTO
242: l_ase_rec.id,
243: l_ase_rec.source_table,
244: l_ase_rec.source_id,

Line 241: FETCH okl_acct_sources_pk_csr INTO

237: BEGIN
238: x_no_data_found := TRUE;
239: -- Get current database values
240: OPEN okl_acct_sources_pk_csr (p_ase_rec.id);
241: FETCH okl_acct_sources_pk_csr INTO
242: l_ase_rec.id,
243: l_ase_rec.source_table,
244: l_ase_rec.source_id,
245: l_ase_rec.pdt_id,

Line 287: x_no_data_found := okl_acct_sources_pk_csr%NOTFOUND;

283: l_ase_rec.creation_date,
284: l_ase_rec.last_updated_by,
285: l_ase_rec.last_update_date,
286: l_ase_rec.last_update_login;
287: x_no_data_found := okl_acct_sources_pk_csr%NOTFOUND;
288: CLOSE okl_acct_sources_pk_csr;
289: RETURN(l_ase_rec);
290: END get_rec;
291:

Line 288: CLOSE okl_acct_sources_pk_csr;

284: l_ase_rec.last_updated_by,
285: l_ase_rec.last_update_date,
286: l_ase_rec.last_update_login;
287: x_no_data_found := okl_acct_sources_pk_csr%NOTFOUND;
288: CLOSE okl_acct_sources_pk_csr;
289: RETURN(l_ase_rec);
290: END get_rec;
291:
292: ------------------------------------------------------------------

Line 321: -- FUNCTION null_out_defaults for: OKL_ACCT_SOURCES_V

317: BEGIN
318: RETURN(get_rec(p_ase_rec, l_row_not_found));
319: END get_rec;
320: ---------------------------------------------------------------------------
321: -- FUNCTION null_out_defaults for: OKL_ACCT_SOURCES_V
322: ---------------------------------------------------------------------------
323: FUNCTION null_out_defaults (
324: p_asev_rec IN asev_rec_type
325: ) RETURN asev_rec_type IS

Line 955: (p_lookup_type => 'OKL_ACCT_SOURCES_STATUS',

951: RAISE G_EXCEPTION_HALT_VALIDATION;
952: END IF;
953:
954: l_dummy := Okl_Accounting_Util.VALIDATE_LOOKUP_CODE
955: (p_lookup_type => 'OKL_ACCT_SOURCES_STATUS',
956: p_lookup_code => p_asev_rec.internal_status);
957:
958: IF (l_dummy = Okl_Api.G_FALSE) THEN
959: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1025: (p_lookup_type => 'OKL_ACCT_SOURCES_CUSTOM_STATUS',

1021: RAISE G_EXCEPTION_HALT_VALIDATION;
1022: END IF;
1023:
1024: l_dummy := Okl_Accounting_Util.VALIDATE_LOOKUP_CODE
1025: (p_lookup_type => 'OKL_ACCT_SOURCES_CUSTOM_STATUS',
1026: p_lookup_code => p_asev_rec.custom_status);
1027:
1028: IF (l_dummy = Okl_Api.G_FALSE) THEN
1029: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1095: (p_lookup_type => 'OKL_ACCT_SOURCES_INDICATOR',

1091: RAISE G_EXCEPTION_HALT_VALIDATION;
1092: END IF;
1093:
1094: l_dummy := Okl_Accounting_Util.VALIDATE_LOOKUP_CODE
1095: (p_lookup_type => 'OKL_ACCT_SOURCES_INDICATOR',
1096: p_lookup_code => p_asev_rec.source_indicator_flag);
1097:
1098: IF (l_dummy = Okl_Api.G_FALSE) THEN
1099: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1231: -- Validate_Attributes for:OKL_ACCT_SOURCES_V --

1227: ---------------------------------------------------------------------------
1228: -- FUNCTION Validate_Attributes
1229: ---------------------------------------------------------------------------
1230: ------------------------------------------------
1231: -- Validate_Attributes for:OKL_ACCT_SOURCES_V --
1232: ------------------------------------------------
1233: FUNCTION Validate_Attributes (
1234: p_asev_rec IN asev_rec_type
1235: ) RETURN VARCHAR2 IS

Line 1437: -- Validate Record for:OKL_ACCT_SOURCES_V --

1433: ---------------------------------------------------------------------------
1434: -- PROCEDURE Validate_Record
1435: ---------------------------------------------------------------------------
1436: --------------------------------------------
1437: -- Validate Record for:OKL_ACCT_SOURCES_V --
1438: --------------------------------------------
1439:
1440: -- bug 4049781
1441: /*

Line 1571: -- validate_row for:OKL_ACCT_SOURCES_V --

1567: ---------------------------------------------------------------------------
1568: -- PROCEDURE validate_row
1569: ---------------------------------------------------------------------------
1570: -----------------------------------------
1571: -- validate_row for:OKL_ACCT_SOURCES_V --
1572: -----------------------------------------
1573: PROCEDURE validate_row(
1574: p_api_version IN NUMBER,
1575: p_init_msg_list IN VARCHAR2,

Line 1648: -- PL/SQL TBL validate_row for:OKL_ACCT_SOURCES_V --

1644: '_PVT'
1645: );
1646: END validate_row;
1647: ----------------------------------------------------
1648: -- PL/SQL TBL validate_row for:OKL_ACCT_SOURCES_V --
1649: ----------------------------------------------------
1650: PROCEDURE validate_row(
1651: p_api_version IN NUMBER,
1652: p_init_msg_list IN VARCHAR2,

Line 1726: -- insert_row for:OKL_ACCT_SOURCES --

1722: ---------------------------------------------------------------------------
1723: -- PROCEDURE insert_row
1724: ---------------------------------------------------------------------------
1725: -------------------------------------
1726: -- insert_row for:OKL_ACCT_SOURCES --
1727: -------------------------------------
1728: PROCEDURE insert_row(
1729: p_init_msg_list IN VARCHAR2,
1730: x_return_status OUT NOCOPY VARCHAR2,

Line 1742: -- Set_Attributes for:OKL_ACCT_SOURCES --

1738: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1739: l_ase_rec ase_rec_type := p_ase_rec;
1740: l_def_ase_rec ase_rec_type;
1741: -----------------------------------------
1742: -- Set_Attributes for:OKL_ACCT_SOURCES --
1743: -----------------------------------------
1744: FUNCTION Set_Attributes (
1745: p_ase_rec IN ase_rec_type,
1746: x_ase_rec OUT NOCOPY ase_rec_type

Line 1773: INSERT INTO OKL_ACCT_SOURCES(

1769: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1771: RAISE Okc_Api.G_EXCEPTION_ERROR;
1772: END IF;
1773: INSERT INTO OKL_ACCT_SOURCES(
1774: id,
1775: source_table,
1776: source_id,
1777: pdt_id,

Line 1902: -- insert_row for :OKL_ACCT_SOURCES_V --

1898: '_PVT'
1899: );
1900: END insert_row;
1901: ----------------------------------------
1902: -- insert_row for :OKL_ACCT_SOURCES_V --
1903: ----------------------------------------
1904: PROCEDURE insert_row(
1905: p_api_version IN NUMBER,
1906: p_init_msg_list IN VARCHAR2,

Line 1936: -- Set_Attributes for:OKL_ACCT_SOURCES_V --

1932: l_asev_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1933: RETURN(l_asev_rec);
1934: END fill_who_columns;
1935: -------------------------------------------
1936: -- Set_Attributes for:OKL_ACCT_SOURCES_V --
1937: -------------------------------------------
1938: FUNCTION Set_Attributes (
1939: p_asev_rec IN asev_rec_type,
1940: x_asev_rec OUT NOCOPY asev_rec_type

Line 2082: --The id column in the Okl_Acct_Sources table is VARCHAR2(240)

2078: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2079:
2080: l_tabsize NUMBER := p_asev_tbl.COUNT;
2081: --Modified by kthiruva on 07-Oct-2005
2082: --The id column in the Okl_Acct_Sources table is VARCHAR2(240)
2083: in_id Okl_Streams_Util.Var240TabTyp;
2084: in_source_table Okl_Streams_Util.Var30TabTyp;
2085: in_source_id Okl_Streams_Util.NumberTabTyp;
2086: in_pdt_id Okl_Streams_Util.NumberTabTyp;

Line 2220: INSERT INTO okl_acct_sources(id

2216: i:= p_asev_tbl.next(i);
2217: END LOOP;
2218:
2219: FORALL i in 1..l_tabsize
2220: INSERT INTO okl_acct_sources(id
2221: ,source_table
2222: ,source_id
2223: ,pdt_id
2224: ,try_id

Line 2430: -- lock_row for:OKL_ACCT_SOURCES --

2426: ---------------------------------------------------------------------------
2427: -- PROCEDURE lock_row
2428: ---------------------------------------------------------------------------
2429: -----------------------------------
2430: -- lock_row for:OKL_ACCT_SOURCES --
2431: -----------------------------------
2432: PROCEDURE lock_row(
2433: p_init_msg_list IN VARCHAR2,
2434: x_return_status OUT NOCOPY VARCHAR2,

Line 2443: FROM OKL_ACCT_SOURCES

2439: E_Resource_Busy EXCEPTION;
2440: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2441: CURSOR lock_csr (p_ase_rec IN ase_rec_type) IS
2442: SELECT *
2443: FROM OKL_ACCT_SOURCES
2444: WHERE ID = p_ase_rec.id
2445: FOR UPDATE NOWAIT;
2446:
2447: l_api_version CONSTANT NUMBER := 1;

Line 2697: -- lock_row for: OKL_ACCT_SOURCES_V --

2693: '_PVT'
2694: );
2695: END lock_row;
2696: --------------------------------------
2697: -- lock_row for: OKL_ACCT_SOURCES_V --
2698: --------------------------------------
2699: PROCEDURE lock_row(
2700: p_api_version IN NUMBER,
2701: p_init_msg_list IN VARCHAR2,

Line 2854: -- update_row for:OKL_ACCT_SOURCES --

2850: ---------------------------------------------------------------------------
2851: -- PROCEDURE update_row
2852: ---------------------------------------------------------------------------
2853: -------------------------------------
2854: -- update_row for:OKL_ACCT_SOURCES --
2855: -------------------------------------
2856: PROCEDURE update_row(
2857: p_init_msg_list IN VARCHAR2,
2858: x_return_status OUT NOCOPY VARCHAR2,

Line 3070: -- Set_Attributes for:OKL_ACCT_SOURCES --

3066: END IF;
3067: RETURN(l_return_status);
3068: END populate_new_record;
3069: -----------------------------------------
3070: -- Set_Attributes for:OKL_ACCT_SOURCES --
3071: -----------------------------------------
3072: FUNCTION Set_Attributes (
3073: p_ase_rec IN ase_rec_type,
3074: x_ase_rec OUT NOCOPY ase_rec_type

Line 3107: UPDATE OKL_ACCT_SOURCES

3103: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3104: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3105: RAISE Okc_Api.G_EXCEPTION_ERROR;
3106: END IF;
3107: UPDATE OKL_ACCT_SOURCES
3108: SET SOURCE_TABLE = l_def_ase_rec.source_table,
3109: SOURCE_ID = l_def_ase_rec.source_id,
3110: PDT_ID = l_def_ase_rec.pdt_id,
3111: TRY_ID = l_def_ase_rec.try_id,

Line 3190: -- update_row for:OKL_ACCT_SOURCES_V --

3186: '_PVT'
3187: );
3188: END update_row;
3189: ---------------------------------------
3190: -- update_row for:OKL_ACCT_SOURCES_V --
3191: ---------------------------------------
3192: PROCEDURE update_row(
3193: p_api_version IN NUMBER,
3194: p_init_msg_list IN VARCHAR2,

Line 3423: -- Set_Attributes for:OKL_ACCT_SOURCES_V --

3419: END IF;
3420: RETURN(l_return_status);
3421: END populate_new_record;
3422: -------------------------------------------
3423: -- Set_Attributes for:OKL_ACCT_SOURCES_V --
3424: -------------------------------------------
3425: FUNCTION Set_Attributes (
3426: p_asev_rec IN asev_rec_type,
3427: x_asev_rec OUT NOCOPY asev_rec_type

Line 3652: -- delete_row for:OKL_ACCT_SOURCES --

3648: ---------------------------------------------------------------------------
3649: -- PROCEDURE delete_row
3650: ---------------------------------------------------------------------------
3651: -------------------------------------
3652: -- delete_row for:OKL_ACCT_SOURCES --
3653: -------------------------------------
3654: PROCEDURE delete_row(
3655: p_init_msg_list IN VARCHAR2,
3656: x_return_status OUT NOCOPY VARCHAR2,

Line 3677: DELETE FROM OKL_ACCT_SOURCES

3673: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3674: RAISE Okc_Api.G_EXCEPTION_ERROR;
3675: END IF;
3676:
3677: DELETE FROM OKL_ACCT_SOURCES
3678: WHERE ID = p_ase_rec.id;
3679:
3680: x_return_status := l_return_status;
3681: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3715: -- delete_row for:OKL_ACCT_SOURCES_V --

3711: '_PVT'
3712: );
3713: END delete_row;
3714: ---------------------------------------
3715: -- delete_row for:OKL_ACCT_SOURCES_V --
3716: ---------------------------------------
3717: PROCEDURE delete_row(
3718: p_api_version IN NUMBER,
3719: p_init_msg_list IN VARCHAR2,

Line 3797: -- PL/SQL TBL delete_row for:OKL_ACCT_SOURCES_V --

3793: '_PVT'
3794: );
3795: END delete_row;
3796: --------------------------------------------------
3797: -- PL/SQL TBL delete_row for:OKL_ACCT_SOURCES_V --
3798: --------------------------------------------------
3799: PROCEDURE delete_row(
3800: p_api_version IN NUMBER,
3801: p_init_msg_list IN VARCHAR2,