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_AMH_PVT dependencies on OKL_AMORT_HOLD_SETUPS

Line 94: -- FUNCTION get_rec for: OKL_AMORT_HOLD_SETUPS_V

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

Line 116: FROM OKL_AMORT_HOLD_SETUPS

112: CREATION_DATE,
113: LAST_UPDATED_BY,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM OKL_AMORT_HOLD_SETUPS
117: WHERE OKL_AMORT_HOLD_SETUPS.id = p_id;
118: l_okl_amhv_pk okl_amhv_pk_csr%ROWTYPE;
119: l_amhv_rec amhv_rec_type;
120: BEGIN

Line 117: WHERE OKL_AMORT_HOLD_SETUPS.id = p_id;

113: LAST_UPDATED_BY,
114: LAST_UPDATE_DATE,
115: LAST_UPDATE_LOGIN
116: FROM OKL_AMORT_HOLD_SETUPS
117: WHERE OKL_AMORT_HOLD_SETUPS.id = p_id;
118: l_okl_amhv_pk okl_amhv_pk_csr%ROWTYPE;
119: l_amhv_rec amhv_rec_type;
120: BEGIN
121: x_no_data_found := TRUE;

Line 174: -- FUNCTION get_rec for: OKL_AMORT_HOLD_SETUPS

170: BEGIN
171: RETURN(get_rec(p_amhv_rec, l_row_not_found));
172: END get_rec;
173: ---------------------------------------------------------------------------
174: -- FUNCTION get_rec for: OKL_AMORT_HOLD_SETUPS
175: ---------------------------------------------------------------------------
176: FUNCTION get_rec (
177: p_amh_rec IN amh_rec_type,
178: x_no_data_found OUT NOCOPY BOOLEAN

Line 196: FROM Okl_Amort_Hold_Setups

192: CREATION_DATE,
193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okl_Amort_Hold_Setups
197: WHERE okl_amort_hold_setups.id = p_id;
198: l_amh_pk amh_pk_csr%ROWTYPE;
199: l_amh_rec amh_rec_type;
200: BEGIN

Line 197: WHERE okl_amort_hold_setups.id = p_id;

193: LAST_UPDATED_BY,
194: LAST_UPDATE_DATE,
195: LAST_UPDATE_LOGIN
196: FROM Okl_Amort_Hold_Setups
197: WHERE okl_amort_hold_setups.id = p_id;
198: l_amh_pk amh_pk_csr%ROWTYPE;
199: l_amh_rec amh_rec_type;
200: BEGIN
201: x_no_data_found := TRUE;

Line 252: -- FUNCTION null_out_defaults for: OKL_AMORT_HOLD_SETUPS_V

248: BEGIN
249: RETURN(get_rec(p_amh_rec, l_row_not_found));
250: END get_rec;
251: ---------------------------------------------------------------------------
252: -- FUNCTION null_out_defaults for: OKL_AMORT_HOLD_SETUPS_V
253: ---------------------------------------------------------------------------
254: FUNCTION null_out_defaults (
255: p_amhv_rec IN amhv_rec_type
256: ) RETURN amhv_rec_type IS

Line 379: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_AMORT_HOLD_SETUPS_V'

375: END IF;
376:
377: /*
378: -- Verify the value fits the length of the column in the database
379: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_AMORT_HOLD_SETUPS_V'
380: ,p_col_name => 'category_id'
381: ,p_col_value => p_category_id
382: ,x_return_status => x_return_status);
383: -- verify that length is within allowed limits

Line 427: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_AMORT_HOLD_SETUPS_V'

423: END IF;
424:
425: -- Verify the value fits the length of the column in the database
426: /*
427: OKC_UTIL.CHECK_LENGTH( p_view_name => 'OKL_AMORT_HOLD_SETUPS_V'
428: ,p_col_name => 'book_type_code'
429: ,p_col_value => p_book_type_code
430: ,x_return_status => x_return_status);
431: -- verify that length is within allowed limits

Line 453: -- Validate_Attributes for:OKL_AMORT_HOLD_SETUPS_V --

449: ---------------------------------------------------------------------------
450: -- FUNCTION Validate_Attributes
451: ---------------------------------------------------------------------------
452: -----------------------------------------------------
453: -- Validate_Attributes for:OKL_AMORT_HOLD_SETUPS_V --
454: -----------------------------------------------------
455: FUNCTION Validate_Attributes (
456: p_amhv_rec IN amhv_rec_type
457: ) RETURN VARCHAR2 IS

Line 529: -- Validate Record for:OKL_AMORT_HOLD_SETUPS_V --

525: ---------------------------------------------------------------------------
526: -- PROCEDURE Validate_Record
527: ---------------------------------------------------------------------------
528: -------------------------------------------------
529: -- Validate Record for:OKL_AMORT_HOLD_SETUPS_V --
530: -------------------------------------------------
531: FUNCTION Validate_Record (
532: p_amhv_rec IN amhv_rec_type,
533: p_db_amhv_rec IN amhv_rec_type

Line 710: FROM OKL_AMORT_HOLD_SETUPS

706: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
707: l_dummy VARCHAR2(1) := NULL;
708: CURSOR okl_cat_book_unq_csr(p_id NUMBER, p_category_id NUMBER, p_book VARCHAR2) IS
709: SELECT 'x'
710: FROM OKL_AMORT_HOLD_SETUPS
711: WHERE category_id = p_category_id
712: AND book_type_code = p_book
713: AND id <> nvl(p_id, -99999);
714:

Line 830: -- validate_row for:OKL_AMORT_HOLD_SETUPS_V --

826: ---------------------------------------------------------------------------
827: -- PROCEDURE validate_row
828: ---------------------------------------------------------------------------
829: ----------------------------------------------
830: -- validate_row for:OKL_AMORT_HOLD_SETUPS_V --
831: ----------------------------------------------
832: PROCEDURE validate_row(
833: p_api_version IN NUMBER,
834: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 907: -- PL/SQL TBL validate_row for:OKL_AMORT_HOLD_SETUPS_V --

903: '_PVT'
904: );
905: END validate_row;
906: ---------------------------------------------------------
907: -- PL/SQL TBL validate_row for:OKL_AMORT_HOLD_SETUPS_V --
908: ---------------------------------------------------------
909: PROCEDURE validate_row(
910: p_api_version IN NUMBER,
911: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1003: -- PL/SQL TBL validate_row for:OKL_AMORT_HOLD_SETUPS_V --

999: );
1000: END validate_row;
1001:
1002: ---------------------------------------------------------
1003: -- PL/SQL TBL validate_row for:OKL_AMORT_HOLD_SETUPS_V --
1004: ---------------------------------------------------------
1005: PROCEDURE validate_row(
1006: p_api_version IN NUMBER,
1007: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1068: -- insert_row for:OKL_AMORT_HOLD_SETUPS --

1064: ---------------------------------------------------------------------------
1065: -- PROCEDURE insert_row
1066: ---------------------------------------------------------------------------
1067: ------------------------------------------
1068: -- insert_row for:OKL_AMORT_HOLD_SETUPS --
1069: ------------------------------------------
1070: PROCEDURE insert_row(
1071: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1072: x_return_status OUT NOCOPY VARCHAR2,

Line 1084: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS --

1080: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1081: l_amh_rec amh_rec_type := p_amh_rec;
1082: l_def_amh_rec amh_rec_type;
1083: ----------------------------------------------
1084: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS --
1085: ----------------------------------------------
1086: FUNCTION Set_Attributes (
1087: p_amh_rec IN amh_rec_type,
1088: x_amh_rec OUT NOCOPY amh_rec_type

Line 1115: INSERT INTO OKL_AMORT_HOLD_SETUPS(

1111: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1113: RAISE okl_api.G_EXCEPTION_ERROR;
1114: END IF;
1115: INSERT INTO OKL_AMORT_HOLD_SETUPS(
1116: id,
1117: object_version_number,
1118: hold_period_days,
1119: category_id,

Line 1184: -- insert_row for :OKL_AMORT_HOLD_SETUPS_V --

1180: '_PVT'
1181: );
1182: END insert_row;
1183: ---------------------------------------------
1184: -- insert_row for :OKL_AMORT_HOLD_SETUPS_V --
1185: ---------------------------------------------
1186: PROCEDURE insert_row(
1187: p_api_version IN NUMBER,
1188: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1218: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS_V --

1214: l_amhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1215: RETURN(l_amhv_rec);
1216: END fill_who_columns;
1217: ------------------------------------------------
1218: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS_V --
1219: ------------------------------------------------
1220: FUNCTION Set_Attributes (
1221: p_amhv_rec IN amhv_rec_type,
1222: x_amhv_rec OUT NOCOPY amhv_rec_type

Line 1507: -- lock_row for:OKL_AMORT_HOLD_SETUPS --

1503: ---------------------------------------------------------------------------
1504: -- PROCEDURE lock_row
1505: ---------------------------------------------------------------------------
1506: ----------------------------------------
1507: -- lock_row for:OKL_AMORT_HOLD_SETUPS --
1508: ----------------------------------------
1509: PROCEDURE lock_row(
1510: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1511: x_return_status OUT NOCOPY VARCHAR2,

Line 1520: FROM OKL_AMORT_HOLD_SETUPS

1516: E_Resource_Busy EXCEPTION;
1517: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1518: CURSOR lock_csr (p_amh_rec IN amh_rec_type) IS
1519: SELECT OBJECT_VERSION_NUMBER
1520: FROM OKL_AMORT_HOLD_SETUPS
1521: WHERE ID = p_amh_rec.id
1522: AND OBJECT_VERSION_NUMBER = p_amh_rec.object_version_number
1523: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1524:

Line 1527: FROM OKL_AMORT_HOLD_SETUPS

1523: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1524:
1525: CURSOR lchk_csr (p_amh_rec IN amh_rec_type) IS
1526: SELECT OBJECT_VERSION_NUMBER
1527: FROM OKL_AMORT_HOLD_SETUPS
1528: WHERE ID = p_amh_rec.id;
1529: l_api_version CONSTANT NUMBER := 1;
1530: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1531: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

Line 1532: l_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;

1528: WHERE ID = p_amh_rec.id;
1529: l_api_version CONSTANT NUMBER := 1;
1530: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1531: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1532: l_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;
1533: lc_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;
1534: l_row_notfound BOOLEAN := FALSE;
1535: lc_row_notfound BOOLEAN := FALSE;
1536: BEGIN

Line 1533: lc_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;

1529: l_api_version CONSTANT NUMBER := 1;
1530: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1531: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
1532: l_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;
1533: lc_object_version_number OKL_AMORT_HOLD_SETUPS.OBJECT_VERSION_NUMBER%TYPE;
1534: l_row_notfound BOOLEAN := FALSE;
1535: lc_row_notfound BOOLEAN := FALSE;
1536: BEGIN
1537: l_return_status := okl_api.START_ACTIVITY(l_api_name,

Line 1614: -- lock_row for: OKL_AMORT_HOLD_SETUPS_V --

1610: '_PVT'
1611: );
1612: END lock_row;
1613: -------------------------------------------
1614: -- lock_row for: OKL_AMORT_HOLD_SETUPS_V --
1615: -------------------------------------------
1616: PROCEDURE lock_row(
1617: p_api_version IN NUMBER,
1618: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 1854: -- update_row for:OKL_AMORT_HOLD_SETUPS --

1850: ---------------------------------------------------------------------------
1851: -- PROCEDURE update_row
1852: ---------------------------------------------------------------------------
1853: ------------------------------------------
1854: -- update_row for:OKL_AMORT_HOLD_SETUPS --
1855: ------------------------------------------
1856: PROCEDURE update_row(
1857: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
1858: x_return_status OUT NOCOPY VARCHAR2,

Line 1945: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS --

1941: END IF;
1942: RETURN(l_return_status);
1943: END populate_new_record;
1944: ----------------------------------------------
1945: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS --
1946: ----------------------------------------------
1947: FUNCTION Set_Attributes (
1948: p_amh_rec IN amh_rec_type,
1949: x_amh_rec OUT NOCOPY amh_rec_type

Line 1983: UPDATE OKL_AMORT_HOLD_SETUPS

1979: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
1980: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
1981: RAISE okl_api.G_EXCEPTION_ERROR;
1982: END IF;
1983: UPDATE OKL_AMORT_HOLD_SETUPS
1984: SET OBJECT_VERSION_NUMBER = l_def_amh_rec.object_version_number,
1985: HOLD_PERIOD_DAYS = l_def_amh_rec.hold_period_days,
1986: CATEGORY_ID = l_def_amh_rec.category_id,
1987: BOOK_TYPE_CODE = l_def_amh_rec.book_type_code,

Line 2036: -- update_row for:OKL_AMORT_HOLD_SETUPS_V --

2032: '_PVT'
2033: );
2034: END update_row;
2035: --------------------------------------------
2036: -- update_row for:OKL_AMORT_HOLD_SETUPS_V --
2037: --------------------------------------------
2038: PROCEDURE update_row(
2039: p_api_version IN NUMBER,
2040: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2148: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS_V --

2144: END IF;
2145: RETURN(l_return_status);
2146: END populate_new_record;
2147: ------------------------------------------------
2148: -- Set_Attributes for:OKL_AMORT_HOLD_SETUPS_V --
2149: ------------------------------------------------
2150: FUNCTION Set_Attributes (
2151: p_amhv_rec IN amhv_rec_type,
2152: x_amhv_rec OUT NOCOPY amhv_rec_type

Line 2441: -- delete_row for:OKL_AMORT_HOLD_SETUPS --

2437: ---------------------------------------------------------------------------
2438: -- PROCEDURE delete_row
2439: ---------------------------------------------------------------------------
2440: ------------------------------------------
2441: -- delete_row for:OKL_AMORT_HOLD_SETUPS --
2442: ------------------------------------------
2443: PROCEDURE delete_row(
2444: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
2445: x_return_status OUT NOCOPY VARCHAR2,

Line 2466: DELETE FROM OKL_AMORT_HOLD_SETUPS

2462: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
2463: RAISE okl_api.G_EXCEPTION_ERROR;
2464: END IF;
2465:
2466: DELETE FROM OKL_AMORT_HOLD_SETUPS
2467: WHERE ID = p_amh_rec.id;
2468:
2469: x_return_status := l_return_status;
2470: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2504: -- delete_row for:OKL_AMORT_HOLD_SETUPS_V --

2500: '_PVT'
2501: );
2502: END delete_row;
2503: --------------------------------------------
2504: -- delete_row for:OKL_AMORT_HOLD_SETUPS_V --
2505: --------------------------------------------
2506: PROCEDURE delete_row(
2507: p_api_version IN NUMBER,
2508: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2586: -- PL/SQL TBL delete_row for:OKL_AMORT_HOLD_SETUPS_V --

2582: '_PVT'
2583: );
2584: END delete_row;
2585: -------------------------------------------------------
2586: -- PL/SQL TBL delete_row for:OKL_AMORT_HOLD_SETUPS_V --
2587: -------------------------------------------------------
2588: PROCEDURE delete_row(
2589: p_api_version IN NUMBER,
2590: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,

Line 2682: -- PL/SQL TBL delete_row for:OKL_AMORT_HOLD_SETUPS_V --

2678: );
2679: END delete_row;
2680:
2681: -------------------------------------------------------
2682: -- PL/SQL TBL delete_row for:OKL_AMORT_HOLD_SETUPS_V --
2683: -------------------------------------------------------
2684: PROCEDURE delete_row(
2685: p_api_version IN NUMBER,
2686: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,