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_CRA_PVT dependencies on OKL_CURE_REPORT_AMOUNTS

Line 94: -- FUNCTION get_rec for: OKL_CURE_REPORT_AMOUNTS_V

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

Line 142: FROM OKL_Cure_Report_Amounts

138: CREATION_DATE,
139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM OKL_Cure_Report_Amounts
143: WHERE cure_report_amount_id = p_cure_report_amount_id;
144: l_OKL_cure_report_amts_pk OKL_cure_report_amts_pk_csr%ROWTYPE;
145: l_crav_rec crav_rec_type;
146: BEGIN

Line 225: -- FUNCTION get_rec for: OKL_CURE_REPORT_AMOUNTS

221: BEGIN
222: RETURN(get_rec(p_crav_rec, l_row_not_found));
223: END get_rec;
224: ---------------------------------------------------------------------------
225: -- FUNCTION get_rec for: OKL_CURE_REPORT_AMOUNTS
226: ---------------------------------------------------------------------------
227: FUNCTION get_rec (
228: p_cra_rec IN cra_rec_type,
229: x_no_data_found OUT NOCOPY BOOLEAN

Line 273: FROM OKL_Cure_Report_Amounts

269: CREATION_DATE,
270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM OKL_Cure_Report_Amounts
274: WHERE OKL_cure_report_amounts.cure_report_amount_id = p_cure_report_amount_id;
275: l_OKL_cure_report_amount_pk OKL_cure_report_amount_pk_csr%ROWTYPE;
276: l_cra_rec cra_rec_type;
277: BEGIN

Line 274: WHERE OKL_cure_report_amounts.cure_report_amount_id = p_cure_report_amount_id;

270: LAST_UPDATED_BY,
271: LAST_UPDATE_DATE,
272: LAST_UPDATE_LOGIN
273: FROM OKL_Cure_Report_Amounts
274: WHERE OKL_cure_report_amounts.cure_report_amount_id = p_cure_report_amount_id;
275: l_OKL_cure_report_amount_pk OKL_cure_report_amount_pk_csr%ROWTYPE;
276: l_cra_rec cra_rec_type;
277: BEGIN
278: x_no_data_found := TRUE;

Line 356: -- FUNCTION null_out_defaults for: OKL_CURE_REPORT_AMOUNTS_V

352: BEGIN
353: RETURN(get_rec(p_cra_rec, l_row_not_found));
354: END get_rec;
355: ---------------------------------------------------------------------------
356: -- FUNCTION null_out_defaults for: OKL_CURE_REPORT_AMOUNTS_V
357: ---------------------------------------------------------------------------
358: FUNCTION null_out_defaults (
359: p_crav_rec IN crav_rec_type
360: ) RETURN crav_rec_type IS

Line 653: -- Validate_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --

649: ---------------------------------------------------------------------------
650: -- FUNCTION Validate_Attributes
651: ---------------------------------------------------------------------------
652: -------------------------------------------------------
653: -- Validate_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --
654: -------------------------------------------------------
655: FUNCTION Validate_Attributes (
656: p_crav_rec IN crav_rec_type
657: ) RETURN VARCHAR2 IS

Line 747: -- Validate Record for:OKL_CURE_REPORT_AMOUNTS_V --

743: ---------------------------------------------------------------------------
744: -- PROCEDURE Validate_Record
745: ---------------------------------------------------------------------------
746: ---------------------------------------------------
747: -- Validate Record for:OKL_CURE_REPORT_AMOUNTS_V --
748: ---------------------------------------------------
749: FUNCTION Validate_Record (
750: p_crav_rec IN crav_rec_type,
751: p_db_crav_rec IN crav_rec_type

Line 867: -- validate_row for:OKL_CURE_REPORT_AMOUNTS_V --

863: ---------------------------------------------------------------------------
864: -- PROCEDURE validate_row
865: ---------------------------------------------------------------------------
866: ------------------------------------------------
867: -- validate_row for:OKL_CURE_REPORT_AMOUNTS_V --
868: ------------------------------------------------
869: PROCEDURE validate_row(
870: p_api_version IN NUMBER,
871: p_init_msg_list IN VARCHAR2,

Line 944: -- PL/SQL TBL validate_row for:OKL_CURE_REPORT_AMOUNTS_V --

940: '_PVT'
941: );
942: END validate_row;
943: -----------------------------------------------------------
944: -- PL/SQL TBL validate_row for:OKL_CURE_REPORT_AMOUNTS_V --
945: -----------------------------------------------------------
946: PROCEDURE validate_row(
947: p_api_version IN NUMBER,
948: p_init_msg_list IN VARCHAR2 ,

Line 1040: -- PL/SQL TBL validate_row for:OKL_CURE_REPORT_AMOUNTS_V --

1036: );
1037: END validate_row;
1038:
1039: -----------------------------------------------------------
1040: -- PL/SQL TBL validate_row for:OKL_CURE_REPORT_AMOUNTS_V --
1041: -----------------------------------------------------------
1042: PROCEDURE validate_row(
1043: p_api_version IN NUMBER,
1044: p_init_msg_list IN VARCHAR2 ,

Line 1105: -- insert_row for:OKL_CURE_REPORT_AMOUNTS --

1101: ---------------------------------------------------------------------------
1102: -- PROCEDURE insert_row
1103: ---------------------------------------------------------------------------
1104: --------------------------------------------
1105: -- insert_row for:OKL_CURE_REPORT_AMOUNTS --
1106: --------------------------------------------
1107: PROCEDURE insert_row(
1108: p_init_msg_list IN VARCHAR2 ,
1109: x_return_status OUT NOCOPY VARCHAR2,

Line 1121: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS --

1117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1118: l_cra_rec cra_rec_type := p_cra_rec;
1119: l_def_cra_rec cra_rec_type;
1120: ------------------------------------------------
1121: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS --
1122: ------------------------------------------------
1123: FUNCTION Set_Attributes (
1124: p_cra_rec IN cra_rec_type,
1125: x_cra_rec OUT NOCOPY cra_rec_type

Line 1152: INSERT INTO OKL_CURE_REPORT_AMOUNTS(

1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: INSERT INTO OKL_CURE_REPORT_AMOUNTS(
1153: cure_report_amount_id,
1154: cure_amount_id,
1155: cure_report_id,
1156: request_type,

Line 1271: -- insert_row for :OKL_CURE_REPORT_AMOUNTS_V --

1267: '_PVT'
1268: );
1269: END insert_row;
1270: -----------------------------------------------
1271: -- insert_row for :OKL_CURE_REPORT_AMOUNTS_V --
1272: -----------------------------------------------
1273: PROCEDURE insert_row(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2 ,

Line 1305: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --

1301: l_crav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1302: RETURN(l_crav_rec);
1303: END fill_who_columns;
1304: --------------------------------------------------
1305: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --
1306: --------------------------------------------------
1307: FUNCTION Set_Attributes (
1308: p_crav_rec IN crav_rec_type,
1309: x_crav_rec OUT NOCOPY crav_rec_type

Line 1581: -- lock_row for:OKL_CURE_REPORT_AMOUNTS --

1577: ---------------------------------------------------------------------------
1578: -- PROCEDURE lock_row
1579: ---------------------------------------------------------------------------
1580: ------------------------------------------
1581: -- lock_row for:OKL_CURE_REPORT_AMOUNTS --
1582: ------------------------------------------
1583: PROCEDURE lock_row(
1584: p_init_msg_list IN VARCHAR2 ,
1585: x_return_status OUT NOCOPY VARCHAR2,

Line 1594: FROM OKL_CURE_REPORT_AMOUNTS

1590: E_Resource_Busy EXCEPTION;
1591: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1592: CURSOR lock_csr (p_cra_rec IN cra_rec_type) IS
1593: SELECT OBJECT_VERSION_NUMBER
1594: FROM OKL_CURE_REPORT_AMOUNTS
1595: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id
1596: AND OBJECT_VERSION_NUMBER = p_cra_rec.object_version_number
1597: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1598:

Line 1601: FROM OKL_CURE_REPORT_AMOUNTS

1597: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1598:
1599: CURSOR lchk_csr (p_cra_rec IN cra_rec_type) IS
1600: SELECT OBJECT_VERSION_NUMBER
1601: FROM OKL_CURE_REPORT_AMOUNTS
1602: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;
1603: l_api_version CONSTANT NUMBER := 1;
1604: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1606: l_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;

1602: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;
1603: l_api_version CONSTANT NUMBER := 1;
1604: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1606: l_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1607: lc_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1608: l_row_notfound BOOLEAN := FALSE;
1609: lc_row_notfound BOOLEAN := FALSE;
1610: BEGIN

Line 1607: lc_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;

1603: l_api_version CONSTANT NUMBER := 1;
1604: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1606: l_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1607: lc_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1608: l_row_notfound BOOLEAN := FALSE;
1609: lc_row_notfound BOOLEAN := FALSE;
1610: BEGIN
1611: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1688: -- lock_row for: OKL_CURE_REPORT_AMOUNTS_V --

1684: '_PVT'
1685: );
1686: END lock_row;
1687: ---------------------------------------------
1688: -- lock_row for: OKL_CURE_REPORT_AMOUNTS_V --
1689: ---------------------------------------------
1690: PROCEDURE lock_row(
1691: p_api_version IN NUMBER,
1692: p_init_msg_list IN VARCHAR2 ,

Line 1928: -- update_row for:OKL_CURE_REPORT_AMOUNTS --

1924: ---------------------------------------------------------------------------
1925: -- PROCEDURE update_row
1926: ---------------------------------------------------------------------------
1927: --------------------------------------------
1928: -- update_row for:OKL_CURE_REPORT_AMOUNTS --
1929: --------------------------------------------
1930: PROCEDURE update_row(
1931: p_init_msg_list IN VARCHAR2,
1932: x_return_status OUT NOCOPY VARCHAR2,

Line 2123: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS --

2119: END IF;
2120: RETURN(l_return_status);
2121: END populate_new_record;
2122: ------------------------------------------------
2123: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS --
2124: ------------------------------------------------
2125: FUNCTION Set_Attributes (
2126: p_cra_rec IN cra_rec_type,
2127: x_cra_rec OUT NOCOPY cra_rec_type

Line 2161: UPDATE OKL_CURE_REPORT_AMOUNTS

2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2159: RAISE OKL_API.G_EXCEPTION_ERROR;
2160: END IF;
2161: UPDATE OKL_CURE_REPORT_AMOUNTS
2162: SET CURE_AMOUNT_ID = l_def_cra_rec.cure_amount_id,
2163: CURE_REPORT_ID = l_def_cra_rec.cure_report_id,
2164: REQUEST_TYPE = l_def_cra_rec.request_type,
2165: CURES_IN_POSSESSION = l_def_cra_rec.cures_in_possession,

Line 2239: -- update_row for:OKL_CURE_REPORT_AMOUNTS_V --

2235: '_PVT'
2236: );
2237: END update_row;
2238: ----------------------------------------------
2239: -- update_row for:OKL_CURE_REPORT_AMOUNTS_V --
2240: ----------------------------------------------
2241: PROCEDURE update_row(
2242: p_api_version IN NUMBER,
2243: p_init_msg_list IN VARCHAR2,

Line 2447: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --

2443: END IF;
2444: RETURN(l_return_status);
2445: END populate_new_record;
2446: --------------------------------------------------
2447: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS_V --
2448: --------------------------------------------------
2449: FUNCTION Set_Attributes (
2450: p_crav_rec IN crav_rec_type,
2451: x_crav_rec OUT NOCOPY crav_rec_type

Line 2739: -- delete_row for:OKL_CURE_REPORT_AMOUNTS --

2735: ---------------------------------------------------------------------------
2736: -- PROCEDURE delete_row
2737: ---------------------------------------------------------------------------
2738: --------------------------------------------
2739: -- delete_row for:OKL_CURE_REPORT_AMOUNTS --
2740: --------------------------------------------
2741: PROCEDURE delete_row(
2742: p_init_msg_list IN VARCHAR2,
2743: x_return_status OUT NOCOPY VARCHAR2,

Line 2764: DELETE FROM OKL_CURE_REPORT_AMOUNTS

2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2761: RAISE OKL_API.G_EXCEPTION_ERROR;
2762: END IF;
2763:
2764: DELETE FROM OKL_CURE_REPORT_AMOUNTS
2765: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;
2766:
2767: x_return_status := l_return_status;
2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2802: -- delete_row for:OKL_CURE_REPORT_AMOUNTS_V --

2798: '_PVT'
2799: );
2800: END delete_row;
2801: ----------------------------------------------
2802: -- delete_row for:OKL_CURE_REPORT_AMOUNTS_V --
2803: ----------------------------------------------
2804: PROCEDURE delete_row(
2805: p_api_version IN NUMBER,
2806: p_init_msg_list IN VARCHAR2,

Line 2884: -- PL/SQL TBL delete_row for:OKL_CURE_REPORT_AMOUNTS_V --

2880: '_PVT'
2881: );
2882: END delete_row;
2883: ---------------------------------------------------------
2884: -- PL/SQL TBL delete_row for:OKL_CURE_REPORT_AMOUNTS_V --
2885: ---------------------------------------------------------
2886: PROCEDURE delete_row(
2887: p_api_version IN NUMBER,
2888: p_init_msg_list IN VARCHAR2,

Line 2980: -- PL/SQL TBL delete_row for:OKL_CURE_REPORT_AMOUNTS_V --

2976: );
2977: END delete_row;
2978:
2979: ---------------------------------------------------------
2980: -- PL/SQL TBL delete_row for:OKL_CURE_REPORT_AMOUNTS_V --
2981: ---------------------------------------------------------
2982: PROCEDURE delete_row(
2983: p_api_version IN NUMBER,
2984: p_init_msg_list IN VARCHAR2,