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_OIN_PVT dependencies on OKL_OPEN_INT

Line 94: -- FUNCTION get_rec for: OKL_OPEN_INT_V

90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKL_OPEN_INT_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oinv_rec IN oinv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN

Line 100: CURSOR OKL_OPEN_INT_pk_csr (p_id IN NUMBER) IS

96: FUNCTION get_rec (
97: p_oinv_rec IN oinv_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oinv_rec_type AS
100: CURSOR OKL_OPEN_INT_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: PARTY_ID,
104: PARTY_NAME,

Line 184: FROM OKL_OPEN_INT

180: CREATION_DATE,
181: LAST_UPDATED_BY,
182: LAST_UPDATE_DATE,
183: LAST_UPDATE_LOGIN
184: FROM OKL_OPEN_INT
185: WHERE OKL_OPEN_INT.id = p_id;
186: l_OKL_OPEN_INT_pk OKL_OPEN_INT_pk_csr%ROWTYPE;
187: l_oinv_rec oinv_rec_type;
188: BEGIN

Line 185: WHERE OKL_OPEN_INT.id = p_id;

181: LAST_UPDATED_BY,
182: LAST_UPDATE_DATE,
183: LAST_UPDATE_LOGIN
184: FROM OKL_OPEN_INT
185: WHERE OKL_OPEN_INT.id = p_id;
186: l_OKL_OPEN_INT_pk OKL_OPEN_INT_pk_csr%ROWTYPE;
187: l_oinv_rec oinv_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;

Line 186: l_OKL_OPEN_INT_pk OKL_OPEN_INT_pk_csr%ROWTYPE;

182: LAST_UPDATE_DATE,
183: LAST_UPDATE_LOGIN
184: FROM OKL_OPEN_INT
185: WHERE OKL_OPEN_INT.id = p_id;
186: l_OKL_OPEN_INT_pk OKL_OPEN_INT_pk_csr%ROWTYPE;
187: l_oinv_rec oinv_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values

Line 191: OPEN OKL_OPEN_INT_pk_csr (p_oinv_rec.id);

187: l_oinv_rec oinv_rec_type;
188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN OKL_OPEN_INT_pk_csr (p_oinv_rec.id);
192: FETCH OKL_OPEN_INT_pk_csr INTO
193: l_oinv_rec.id,
194: l_oinv_rec.party_id,
195: l_oinv_rec.party_name,

Line 192: FETCH OKL_OPEN_INT_pk_csr INTO

188: BEGIN
189: x_no_data_found := TRUE;
190: -- Get current database values
191: OPEN OKL_OPEN_INT_pk_csr (p_oinv_rec.id);
192: FETCH OKL_OPEN_INT_pk_csr INTO
193: l_oinv_rec.id,
194: l_oinv_rec.party_id,
195: l_oinv_rec.party_name,
196: l_oinv_rec.party_type,

Line 275: x_no_data_found := OKL_OPEN_INT_pk_csr%NOTFOUND;

271: l_oinv_rec.creation_date,
272: l_oinv_rec.last_updated_by,
273: l_oinv_rec.last_update_date,
274: l_oinv_rec.last_update_login;
275: x_no_data_found := OKL_OPEN_INT_pk_csr%NOTFOUND;
276: CLOSE OKL_OPEN_INT_pk_csr;
277: RETURN(l_oinv_rec);
278: END get_rec;
279:

Line 276: CLOSE OKL_OPEN_INT_pk_csr;

272: l_oinv_rec.last_updated_by,
273: l_oinv_rec.last_update_date,
274: l_oinv_rec.last_update_login;
275: x_no_data_found := OKL_OPEN_INT_pk_csr%NOTFOUND;
276: CLOSE OKL_OPEN_INT_pk_csr;
277: RETURN(l_oinv_rec);
278: END get_rec;
279:
280: ------------------------------------------------------------------

Line 309: -- FUNCTION get_rec for: OKL_OPEN_INT

305: BEGIN
306: RETURN(get_rec(p_oinv_rec, l_row_not_found));
307: END get_rec;
308: ---------------------------------------------------------------------------
309: -- FUNCTION get_rec for: OKL_OPEN_INT
310: ---------------------------------------------------------------------------
311: FUNCTION get_rec (
312: p_oin_rec IN oin_rec_type,
313: x_no_data_found OUT NOCOPY BOOLEAN

Line 399: FROM Okl_Open_Int

395: CREATION_DATE,
396: LAST_UPDATED_BY,
397: LAST_UPDATE_DATE,
398: LAST_UPDATE_LOGIN
399: FROM Okl_Open_Int
400: WHERE okl_open_int.id = p_id;
401: l_oin_b_pk oin_b_pk_csr%ROWTYPE;
402: l_oin_rec oin_rec_type;
403: BEGIN

Line 400: WHERE okl_open_int.id = p_id;

396: LAST_UPDATED_BY,
397: LAST_UPDATE_DATE,
398: LAST_UPDATE_LOGIN
399: FROM Okl_Open_Int
400: WHERE okl_open_int.id = p_id;
401: l_oin_b_pk oin_b_pk_csr%ROWTYPE;
402: l_oin_rec oin_rec_type;
403: BEGIN
404: x_no_data_found := TRUE;

Line 524: -- FUNCTION null_out_defaults for: OKL_OPEN_INT_V

520: BEGIN
521: RETURN(get_rec(p_oin_rec, l_row_not_found));
522: END get_rec;
523: ---------------------------------------------------------------------------
524: -- FUNCTION null_out_defaults for: OKL_OPEN_INT_V
525: ---------------------------------------------------------------------------
526: FUNCTION null_out_defaults (
527: p_oinv_rec IN oinv_rec_type
528: ) RETURN oinv_rec_type AS

Line 1072: -- Validate_Attributes for:OKL_OPEN_INT_V --

1068: ---------------------------------------------------------------------------
1069: -- FUNCTION Validate_Attributes
1070: ---------------------------------------------------------------------------
1071: --------------------------------------------
1072: -- Validate_Attributes for:OKL_OPEN_INT_V --
1073: --------------------------------------------
1074: FUNCTION Validate_Attributes (
1075: p_oinv_rec IN oinv_rec_type
1076: ) RETURN VARCHAR2 AS

Line 1242: -- Validate Record for:OKL_OPEN_INT_V --

1238: ---------------------------------------------------------------------------
1239: -- PROCEDURE Validate_Record
1240: ---------------------------------------------------------------------------
1241: ----------------------------------------
1242: -- Validate Record for:OKL_OPEN_INT_V --
1243: ----------------------------------------
1244: FUNCTION Validate_Record (
1245: p_oinv_rec IN oinv_rec_type,
1246: p_db_oinv_rec IN oinv_rec_type

Line 1446: -- validate_row for:OKL_OPEN_INT_V --

1442: ---------------------------------------------------------------------------
1443: -- PROCEDURE validate_row
1444: ---------------------------------------------------------------------------
1445: -------------------------------------
1446: -- validate_row for:OKL_OPEN_INT_V --
1447: -------------------------------------
1448: PROCEDURE validate_row(
1449: p_api_version IN NUMBER,
1450: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1523: -- PL/SQL TBL validate_row for:OKL_OPEN_INT_V --

1519: '_PVT'
1520: );
1521: END validate_row;
1522: ------------------------------------------------
1523: -- PL/SQL TBL validate_row for:OKL_OPEN_INT_V --
1524: ------------------------------------------------
1525: PROCEDURE validate_row(
1526: p_api_version IN NUMBER,
1527: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1619: -- PL/SQL TBL validate_row for:OKL_OPEN_INT_V --

1615: );
1616: END validate_row;
1617:
1618: ------------------------------------------------
1619: -- PL/SQL TBL validate_row for:OKL_OPEN_INT_V --
1620: ------------------------------------------------
1621: PROCEDURE validate_row(
1622: p_api_version IN NUMBER,
1623: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1684: -- insert_row for:OKL_OPEN_INT --

1680: ---------------------------------------------------------------------------
1681: -- PROCEDURE insert_row
1682: ---------------------------------------------------------------------------
1683: ---------------------------------
1684: -- insert_row for:OKL_OPEN_INT --
1685: ---------------------------------
1686: PROCEDURE insert_row(
1687: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1688: x_return_status OUT NOCOPY VARCHAR2,

Line 1700: -- Set_Attributes for:OKL_OPEN_INT --

1696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1697: l_oin_rec oin_rec_type := p_oin_rec;
1698: l_def_oin_rec oin_rec_type;
1699: -------------------------------------
1700: -- Set_Attributes for:OKL_OPEN_INT --
1701: -------------------------------------
1702: FUNCTION Set_Attributes (
1703: p_oin_rec IN oin_rec_type,
1704: x_oin_rec OUT NOCOPY oin_rec_type

Line 1731: INSERT INTO OKL_OPEN_INT(

1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: INSERT INTO OKL_OPEN_INT(
1732: id,
1733: party_id,
1734: party_name,
1735: party_type,

Line 1934: -- insert_row for :OKL_OPEN_INT_V --

1930: '_PVT'
1931: );
1932: END insert_row;
1933: ------------------------------------
1934: -- insert_row for :OKL_OPEN_INT_V --
1935: ------------------------------------
1936: PROCEDURE insert_row(
1937: p_api_version IN NUMBER,
1938: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1968: -- Set_Attributes for:OKL_OPEN_INT_V --

1964: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1965: RETURN(l_oinv_rec);
1966: END fill_who_columns;
1967: ---------------------------------------
1968: -- Set_Attributes for:OKL_OPEN_INT_V --
1969: ---------------------------------------
1970: FUNCTION Set_Attributes (
1971: p_oinv_rec IN oinv_rec_type,
1972: x_oinv_rec OUT NOCOPY oinv_rec_type

Line 2261: -- lock_row for:OKL_OPEN_INT --

2257: ---------------------------------------------------------------------------
2258: -- PROCEDURE lock_row
2259: ---------------------------------------------------------------------------
2260: -------------------------------
2261: -- lock_row for:OKL_OPEN_INT --
2262: -------------------------------
2263: PROCEDURE lock_row(
2264: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2265: x_return_status OUT NOCOPY VARCHAR2,

Line 2274: FROM OKL_OPEN_INT

2270: E_Resource_Busy EXCEPTION;
2271: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2272: CURSOR lock_csr (p_oin_rec IN oin_rec_type) IS
2273: SELECT OBJECT_VERSION_NUMBER
2274: FROM OKL_OPEN_INT
2275: WHERE ID = p_oin_rec.id
2276: AND OBJECT_VERSION_NUMBER = p_oin_rec.object_version_number
2277: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2278:

Line 2281: FROM OKL_OPEN_INT

2277: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2278:
2279: CURSOR lchk_csr (p_oin_rec IN oin_rec_type) IS
2280: SELECT OBJECT_VERSION_NUMBER
2281: FROM OKL_OPEN_INT
2282: WHERE ID = p_oin_rec.id;
2283: l_api_version CONSTANT NUMBER := 1;
2284: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2285: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2286: l_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;

2282: WHERE ID = p_oin_rec.id;
2283: l_api_version CONSTANT NUMBER := 1;
2284: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2285: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2286: l_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;
2287: lc_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;
2288: l_row_notfound BOOLEAN := FALSE;
2289: lc_row_notfound BOOLEAN := FALSE;
2290: BEGIN

Line 2287: lc_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;

2283: l_api_version CONSTANT NUMBER := 1;
2284: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2285: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2286: l_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;
2287: lc_object_version_number OKL_OPEN_INT.OBJECT_VERSION_NUMBER%TYPE;
2288: l_row_notfound BOOLEAN := FALSE;
2289: lc_row_notfound BOOLEAN := FALSE;
2290: BEGIN
2291: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2368: -- lock_row for: OKL_OPEN_INT_V --

2364: '_PVT'
2365: );
2366: END lock_row;
2367: ----------------------------------
2368: -- lock_row for: OKL_OPEN_INT_V --
2369: ----------------------------------
2370: PROCEDURE lock_row(
2371: p_api_version IN NUMBER,
2372: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2608: -- update_row for:OKL_OPEN_INT --

2604: ---------------------------------------------------------------------------
2605: -- PROCEDURE update_row
2606: ---------------------------------------------------------------------------
2607: ---------------------------------
2608: -- update_row for:OKL_OPEN_INT --
2609: ---------------------------------
2610: PROCEDURE update_row(
2611: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2612: x_return_status OUT NOCOPY VARCHAR2,

Line 2971: -- Set_Attributes for:OKL_OPEN_INT --

2967: END IF;
2968: RETURN(l_return_status);
2969: END populate_new_record;
2970: -------------------------------------
2971: -- Set_Attributes for:OKL_OPEN_INT --
2972: -------------------------------------
2973: FUNCTION Set_Attributes (
2974: p_oin_rec IN oin_rec_type,
2975: x_oin_rec OUT NOCOPY oin_rec_type

Line 3009: UPDATE OKL_OPEN_INT

3005: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3006: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3007: RAISE OKC_API.G_EXCEPTION_ERROR;
3008: END IF;
3009: UPDATE OKL_OPEN_INT
3010: SET PARTY_ID = l_def_oin_rec.party_id,
3011: PARTY_NAME = l_def_oin_rec.party_name,
3012: PARTY_TYPE = l_def_oin_rec.party_type,
3013: DATE_OF_BIRTH = l_def_oin_rec.date_of_birth,

Line 3129: -- update_row for:OKL_OPEN_INT_V --

3125: '_PVT'
3126: );
3127: END update_row;
3128: -----------------------------------
3129: -- update_row for:OKL_OPEN_INT_V --
3130: -----------------------------------
3131: PROCEDURE update_row(
3132: p_api_version IN NUMBER,
3133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3509: -- Set_Attributes for:OKL_OPEN_INT_V --

3505: END IF;
3506: RETURN(l_return_status);
3507: END populate_new_record;
3508: ---------------------------------------
3509: -- Set_Attributes for:OKL_OPEN_INT_V --
3510: ---------------------------------------
3511: FUNCTION Set_Attributes (
3512: p_oinv_rec IN oinv_rec_type,
3513: x_oinv_rec OUT NOCOPY oinv_rec_type

Line 3819: -- delete_row for:OKL_OPEN_INT --

3815: ---------------------------------------------------------------------------
3816: -- PROCEDURE delete_row
3817: ---------------------------------------------------------------------------
3818: ---------------------------------
3819: -- delete_row for:OKL_OPEN_INT --
3820: ---------------------------------
3821: PROCEDURE delete_row(
3822: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3823: x_return_status OUT NOCOPY VARCHAR2,

Line 3844: DELETE FROM OKL_OPEN_INT

3840: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3841: RAISE OKC_API.G_EXCEPTION_ERROR;
3842: END IF;
3843:
3844: DELETE FROM OKL_OPEN_INT
3845: WHERE ID = p_oin_rec.id;
3846:
3847: x_return_status := l_return_status;
3848: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3882: -- delete_row for:OKL_OPEN_INT_V --

3878: '_PVT'
3879: );
3880: END delete_row;
3881: -----------------------------------
3882: -- delete_row for:OKL_OPEN_INT_V --
3883: -----------------------------------
3884: PROCEDURE delete_row(
3885: p_api_version IN NUMBER,
3886: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3964: -- PL/SQL TBL delete_row for:OKL_OPEN_INT_V --

3960: '_PVT'
3961: );
3962: END delete_row;
3963: ----------------------------------------------
3964: -- PL/SQL TBL delete_row for:OKL_OPEN_INT_V --
3965: ----------------------------------------------
3966: PROCEDURE delete_row(
3967: p_api_version IN NUMBER,
3968: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 4060: -- PL/SQL TBL delete_row for:OKL_OPEN_INT_V --

4056: );
4057: END delete_row;
4058:
4059: ----------------------------------------------
4060: -- PL/SQL TBL delete_row for:OKL_OPEN_INT_V --
4061: ----------------------------------------------
4062: PROCEDURE delete_row(
4063: p_api_version IN NUMBER,
4064: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,