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_CLD_PVT dependencies on OKL_CHECKLIST_DETAILS

Line 94: -- FUNCTION get_rec for: OKL_CHECKLIST_DETAILS_V

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

Line 145: FROM OKL_CHECKLIST_DETAILS

141: INST_CHECKLIST_TYPE
142: -- end: Apr 25, 2005 cklee: Modification for okl.h
143: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
144: ,APPEAL_FLAG
145: FROM OKL_CHECKLIST_DETAILS
146: WHERE OKL_CHECKLIST_DETAILS.id = p_id;
147: l_okl_cldv_pk okl_cldv_pk_csr%ROWTYPE;
148: l_cldv_rec cldv_rec_type;
149: BEGIN

Line 146: WHERE OKL_CHECKLIST_DETAILS.id = p_id;

142: -- end: Apr 25, 2005 cklee: Modification for okl.h
143: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
144: ,APPEAL_FLAG
145: FROM OKL_CHECKLIST_DETAILS
146: WHERE OKL_CHECKLIST_DETAILS.id = p_id;
147: l_okl_cldv_pk okl_cldv_pk_csr%ROWTYPE;
148: l_cldv_rec cldv_rec_type;
149: BEGIN
150: x_no_data_found := TRUE;

Line 232: -- FUNCTION get_rec for: OKL_CHECKLIST_DETAILS

228: BEGIN
229: RETURN(get_rec(p_cldv_rec, l_row_not_found));
230: END get_rec;
231: ---------------------------------------------------------------------------
232: -- FUNCTION get_rec for: OKL_CHECKLIST_DETAILS
233: ---------------------------------------------------------------------------
234: FUNCTION get_rec (
235: p_cld_rec IN cld_rec_type,
236: x_no_data_found OUT NOCOPY BOOLEAN

Line 238: CURSOR okl_checklist_details_pk_csr (p_id IN NUMBER) IS

234: FUNCTION get_rec (
235: p_cld_rec IN cld_rec_type,
236: x_no_data_found OUT NOCOPY BOOLEAN
237: ) RETURN cld_rec_type IS
238: CURSOR okl_checklist_details_pk_csr (p_id IN NUMBER) IS
239: SELECT
240: ID,
241: OBJECT_VERSION_NUMBER,
242: CKL_ID,

Line 283: FROM Okl_Checklist_Details

279: INST_CHECKLIST_TYPE
280: -- end: Apr 25, 2005 cklee: Modification for okl.h
281: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
282: ,APPEAL_FLAG
283: FROM Okl_Checklist_Details
284: WHERE okl_checklist_details.id = p_id;
285: l_okl_checklist_details_pk okl_checklist_details_pk_csr%ROWTYPE;
286: l_cld_rec cld_rec_type;
287: BEGIN

Line 284: WHERE okl_checklist_details.id = p_id;

280: -- end: Apr 25, 2005 cklee: Modification for okl.h
281: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
282: ,APPEAL_FLAG
283: FROM Okl_Checklist_Details
284: WHERE okl_checklist_details.id = p_id;
285: l_okl_checklist_details_pk okl_checklist_details_pk_csr%ROWTYPE;
286: l_cld_rec cld_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;

Line 285: l_okl_checklist_details_pk okl_checklist_details_pk_csr%ROWTYPE;

281: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
282: ,APPEAL_FLAG
283: FROM Okl_Checklist_Details
284: WHERE okl_checklist_details.id = p_id;
285: l_okl_checklist_details_pk okl_checklist_details_pk_csr%ROWTYPE;
286: l_cld_rec cld_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values

Line 290: OPEN okl_checklist_details_pk_csr (p_cld_rec.id);

286: l_cld_rec cld_rec_type;
287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_checklist_details_pk_csr (p_cld_rec.id);
291: FETCH okl_checklist_details_pk_csr INTO
292: l_cld_rec.id,
293: l_cld_rec.object_version_number,
294: l_cld_rec.ckl_id,

Line 291: FETCH okl_checklist_details_pk_csr INTO

287: BEGIN
288: x_no_data_found := TRUE;
289: -- Get current database values
290: OPEN okl_checklist_details_pk_csr (p_cld_rec.id);
291: FETCH okl_checklist_details_pk_csr INTO
292: l_cld_rec.id,
293: l_cld_rec.object_version_number,
294: l_cld_rec.ckl_id,
295: l_cld_rec.todo_item_code,

Line 336: x_no_data_found := okl_checklist_details_pk_csr%NOTFOUND;

332: -- end: Apr 25, 2005 cklee: Modification for okl.h
333: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
334: ,l_cld_rec.APPEAL_FLAG
335: ;
336: x_no_data_found := okl_checklist_details_pk_csr%NOTFOUND;
337: CLOSE okl_checklist_details_pk_csr;
338: RETURN(l_cld_rec);
339: END get_rec;
340:

Line 337: CLOSE okl_checklist_details_pk_csr;

333: --Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
334: ,l_cld_rec.APPEAL_FLAG
335: ;
336: x_no_data_found := okl_checklist_details_pk_csr%NOTFOUND;
337: CLOSE okl_checklist_details_pk_csr;
338: RETURN(l_cld_rec);
339: END get_rec;
340:
341: ------------------------------------------------------------------

Line 370: -- FUNCTION null_out_defaults for: OKL_CHECKLIST_DETAILS_V

366: BEGIN
367: RETURN(get_rec(p_cld_rec, l_row_not_found));
368: END get_rec;
369: ---------------------------------------------------------------------------
370: -- FUNCTION null_out_defaults for: OKL_CHECKLIST_DETAILS_V
371: ---------------------------------------------------------------------------
372: FUNCTION null_out_defaults (
373: p_cldv_rec IN cldv_rec_type
374: ) RETURN cldv_rec_type IS

Line 597: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type)

593:
594: l_dummy number;
595: l_row_not_found boolean := false;
596:
597: CURSOR c_todo (p_todo_item_code okl_checklist_details.todo_item_code%type)
598: IS
599: SELECT 1
600: FROM fnd_lookups lok
601: WHERE lok.lookup_type = 'OKL_TODO_ITEMS'

Line 647: -- Validate_Attributes for:OKL_CHECKLIST_DETAILS_V --

643: ---------------------------------------------------------------------------
644: -- FUNCTION Validate_Attributes
645: ---------------------------------------------------------------------------
646: -----------------------------------------------------
647: -- Validate_Attributes for:OKL_CHECKLIST_DETAILS_V --
648: -----------------------------------------------------
649: FUNCTION Validate_Attributes (
650: p_cldv_rec IN cldv_rec_type
651: ) RETURN VARCHAR2 IS

Line 703: -- Validate Record for:OKL_CHECKLIST_DETAILS_V --

699: ---------------------------------------------------------------------------
700: -- PROCEDURE Validate_Record
701: ---------------------------------------------------------------------------
702: -------------------------------------------------
703: -- Validate Record for:OKL_CHECKLIST_DETAILS_V --
704: -------------------------------------------------
705: FUNCTION Validate_Record (
706: p_cldv_rec IN cldv_rec_type,
707: p_db_cldv_rec IN cldv_rec_type

Line 829: -- validate_row for:OKL_CHECKLIST_DETAILS_V --

825: ---------------------------------------------------------------------------
826: -- PROCEDURE validate_row
827: ---------------------------------------------------------------------------
828: ----------------------------------------------
829: -- validate_row for:OKL_CHECKLIST_DETAILS_V --
830: ----------------------------------------------
831: PROCEDURE validate_row(
832: p_api_version IN NUMBER,
833: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 906: -- PL/SQL TBL validate_row for:OKL_CHECKLIST_DETAILS_V --

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

Line 1002: -- PL/SQL TBL validate_row for:OKL_CHECKLIST_DETAILS_V --

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

Line 1067: -- insert_row for:OKL_CHECKLIST_DETAILS --

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

Line 1083: -- Set_Attributes for:OKL_CHECKLIST_DETAILS --

1079: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1080: l_cld_rec cld_rec_type := p_cld_rec;
1081: l_def_cld_rec cld_rec_type;
1082: ----------------------------------------------
1083: -- Set_Attributes for:OKL_CHECKLIST_DETAILS --
1084: ----------------------------------------------
1085: FUNCTION Set_Attributes (
1086: p_cld_rec IN cld_rec_type,
1087: x_cld_rec OUT NOCOPY cld_rec_type

Line 1114: INSERT INTO OKL_CHECKLIST_DETAILS(

1110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1112: RAISE OKL_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: INSERT INTO OKL_CHECKLIST_DETAILS(
1115: id,
1116: object_version_number,
1117: ckl_id,
1118: todo_item_code,

Line 1241: -- insert_row for :OKL_CHECKLIST_DETAILS_V --

1237: '_PVT'
1238: );
1239: END insert_row;
1240: ---------------------------------------------
1241: -- insert_row for :OKL_CHECKLIST_DETAILS_V --
1242: ---------------------------------------------
1243: PROCEDURE insert_row(
1244: p_api_version IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1275: -- Set_Attributes for:OKL_CHECKLIST_DETAILS_V --

1271: l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1272: RETURN(l_cldv_rec);
1273: END fill_who_columns;
1274: ------------------------------------------------
1275: -- Set_Attributes for:OKL_CHECKLIST_DETAILS_V --
1276: ------------------------------------------------
1277: FUNCTION Set_Attributes (
1278: p_cldv_rec IN cldv_rec_type,
1279: x_cldv_rec OUT NOCOPY cldv_rec_type

Line 1564: -- lock_row for:OKL_CHECKLIST_DETAILS --

1560: ---------------------------------------------------------------------------
1561: -- PROCEDURE lock_row
1562: ---------------------------------------------------------------------------
1563: ----------------------------------------
1564: -- lock_row for:OKL_CHECKLIST_DETAILS --
1565: ----------------------------------------
1566: PROCEDURE lock_row(
1567: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1568: x_return_status OUT NOCOPY VARCHAR2,

Line 1577: FROM OKL_CHECKLIST_DETAILS

1573: E_Resource_Busy EXCEPTION;
1574: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1575: CURSOR lock_csr (p_cld_rec IN cld_rec_type) IS
1576: SELECT OBJECT_VERSION_NUMBER
1577: FROM OKL_CHECKLIST_DETAILS
1578: WHERE ID = p_cld_rec.id
1579: AND OBJECT_VERSION_NUMBER = p_cld_rec.object_version_number
1580: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1581:

Line 1584: FROM OKL_CHECKLIST_DETAILS

1580: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1581:
1582: CURSOR lchk_csr (p_cld_rec IN cld_rec_type) IS
1583: SELECT OBJECT_VERSION_NUMBER
1584: FROM OKL_CHECKLIST_DETAILS
1585: WHERE ID = p_cld_rec.id;
1586: l_api_version CONSTANT NUMBER := 1;
1587: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1588: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1589: l_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;

1585: WHERE ID = p_cld_rec.id;
1586: l_api_version CONSTANT NUMBER := 1;
1587: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1588: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1589: l_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
1590: lc_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
1591: l_row_notfound BOOLEAN := FALSE;
1592: lc_row_notfound BOOLEAN := FALSE;
1593: BEGIN

Line 1590: lc_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;

1586: l_api_version CONSTANT NUMBER := 1;
1587: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1588: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1589: l_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
1590: lc_object_version_number OKL_CHECKLIST_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
1591: l_row_notfound BOOLEAN := FALSE;
1592: lc_row_notfound BOOLEAN := FALSE;
1593: BEGIN
1594: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1671: -- lock_row for: OKL_CHECKLIST_DETAILS_V --

1667: '_PVT'
1668: );
1669: END lock_row;
1670: -------------------------------------------
1671: -- lock_row for: OKL_CHECKLIST_DETAILS_V --
1672: -------------------------------------------
1673: PROCEDURE lock_row(
1674: p_api_version IN NUMBER,
1675: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 1911: -- update_row for:OKL_CHECKLIST_DETAILS --

1907: ---------------------------------------------------------------------------
1908: -- PROCEDURE update_row
1909: ---------------------------------------------------------------------------
1910: ------------------------------------------
1911: -- update_row for:OKL_CHECKLIST_DETAILS --
1912: ------------------------------------------
1913: PROCEDURE update_row(
1914: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1915: x_return_status OUT NOCOPY VARCHAR2,

Line 2110: -- Set_Attributes for:OKL_CHECKLIST_DETAILS --

2106: END IF;
2107: RETURN(l_return_status);
2108: END populate_new_record;
2109: ----------------------------------------------
2110: -- Set_Attributes for:OKL_CHECKLIST_DETAILS --
2111: ----------------------------------------------
2112: FUNCTION Set_Attributes (
2113: p_cld_rec IN cld_rec_type,
2114: x_cld_rec OUT NOCOPY cld_rec_type

Line 2148: UPDATE OKL_CHECKLIST_DETAILS

2144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2145: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2146: RAISE OKL_API.G_EXCEPTION_ERROR;
2147: END IF;
2148: UPDATE OKL_CHECKLIST_DETAILS
2149: SET OBJECT_VERSION_NUMBER = l_def_cld_rec.object_version_number,
2150: CKL_ID = l_def_cld_rec.ckl_id,
2151: TODO_ITEM_CODE = l_def_cld_rec.todo_item_code,
2152: ATTRIBUTE_CATEGORY = l_def_cld_rec.attribute_category,

Line 2229: -- update_row for:OKL_CHECKLIST_DETAILS_V --

2225: '_PVT'
2226: );
2227: END update_row;
2228: --------------------------------------------
2229: -- update_row for:OKL_CHECKLIST_DETAILS_V --
2230: --------------------------------------------
2231: PROCEDURE update_row(
2232: p_api_version IN NUMBER,
2233: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2441: -- Set_Attributes for:OKL_CHECKLIST_DETAILS_V --

2437: END IF;
2438: RETURN(l_return_status);
2439: END populate_new_record;
2440: ------------------------------------------------
2441: -- Set_Attributes for:OKL_CHECKLIST_DETAILS_V --
2442: ------------------------------------------------
2443: FUNCTION Set_Attributes (
2444: p_cldv_rec IN cldv_rec_type,
2445: x_cldv_rec OUT NOCOPY cldv_rec_type

Line 2733: -- delete_row for:OKL_CHECKLIST_DETAILS --

2729: ---------------------------------------------------------------------------
2730: -- PROCEDURE delete_row
2731: ---------------------------------------------------------------------------
2732: ------------------------------------------
2733: -- delete_row for:OKL_CHECKLIST_DETAILS --
2734: ------------------------------------------
2735: PROCEDURE delete_row(
2736: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2737: x_return_status OUT NOCOPY VARCHAR2,

Line 2758: DELETE FROM OKL_CHECKLIST_DETAILS

2754: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2755: RAISE OKL_API.G_EXCEPTION_ERROR;
2756: END IF;
2757:
2758: DELETE FROM OKL_CHECKLIST_DETAILS
2759: WHERE ID = p_cld_rec.id;
2760:
2761: x_return_status := l_return_status;
2762: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2796: -- delete_row for:OKL_CHECKLIST_DETAILS_V --

2792: '_PVT'
2793: );
2794: END delete_row;
2795: --------------------------------------------
2796: -- delete_row for:OKL_CHECKLIST_DETAILS_V --
2797: --------------------------------------------
2798: PROCEDURE delete_row(
2799: p_api_version IN NUMBER,
2800: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2878: -- PL/SQL TBL delete_row for:OKL_CHECKLIST_DETAILS_V --

2874: '_PVT'
2875: );
2876: END delete_row;
2877: -------------------------------------------------------
2878: -- PL/SQL TBL delete_row for:OKL_CHECKLIST_DETAILS_V --
2879: -------------------------------------------------------
2880: PROCEDURE delete_row(
2881: p_api_version IN NUMBER,
2882: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 2974: -- PL/SQL TBL delete_row for:OKL_CHECKLIST_DETAILS_V --

2970: );
2971: END delete_row;
2972:
2973: -------------------------------------------------------
2974: -- PL/SQL TBL delete_row for:OKL_CHECKLIST_DETAILS_V --
2975: -------------------------------------------------------
2976: PROCEDURE delete_row(
2977: p_api_version IN NUMBER,
2978: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,