APPS.OKL_LAT_PVT dependencies on OKL_LEASEAPP_TEMPLATES

Line 353: FROM Okl_Leaseapp_Templates LATV

349: l_check_tmplt_combination VARCHAR2(1);
350: --Declare Cursor Definations
351: CURSOR c_chk_tmlt_number IS
352: SELECT 'x'
353: FROM Okl_Leaseapp_Templates LATV
354: WHERE LATV.name = p_latv_rec.name
355: AND LATV.id <> nvl(p_latv_rec.id,-99999);
356: BEGIN
357: l_return_status := G_RET_STS_SUCCESS;

Line 421: INSERT INTO okl_leaseapp_templates (

417: BEGIN
418:
419: l_prog_name := G_PKG_NAME||'.insert_row (B)';
420:
421: INSERT INTO okl_leaseapp_templates (
422: id
423: ,object_version_number
424: ,attribute_category
425: ,attribute1

Line 742: FROM OKL_LEASEAPP_TEMPLATES

738: PRAGMA EXCEPTION_INIT (E_Resource_Busy, -00054);
739:
740: CURSOR lock_csr IS
741: SELECT OBJECT_VERSION_NUMBER
742: FROM OKL_LEASEAPP_TEMPLATES
743: WHERE ID = p_lat_rec.id
744: AND OBJECT_VERSION_NUMBER = p_lat_rec.object_version_number
745: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
746:

Line 749: FROM OKL_LEASEAPP_TEMPLATES

745: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
746:
747: CURSOR lchk_csr IS
748: SELECT OBJECT_VERSION_NUMBER
749: FROM OKL_LEASEAPP_TEMPLATES
750: WHERE ID = p_lat_rec.id;
751:
752: l_object_version_number NUMBER;
753: lc_object_version_number NUMBER;

Line 849: UPDATE okl_leaseapp_templates

845: ELSIF l_return_status = G_RET_STS_ERROR THEN
846: RAISE OKL_API.G_EXCEPTION_ERROR;
847: END IF;
848:
849: UPDATE okl_leaseapp_templates
850: SET
851: object_version_number = p_lat_rec.object_version_number+1
852: ,attribute_category = p_lat_rec.attribute_category
853: ,attribute1 = p_lat_rec.attribute1