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_AVL_PVT dependencies on OKL_AE_TEMPLATES

Line 685: FROM OKL_AE_TEMPLATES

681:
682: CURSOR c1 IS
683: SELECT start_date,
684: end_date
685: FROM OKL_AE_TEMPLATES
686: WHERE try_id = p_avlv_rec.try_id
687: AND nvl(org_id,-99) = nvl(p_avlv_rec.org_id,-99)
688: AND sty_id = p_avlv_rec.sty_id
689: AND aes_id = p_avlv_rec.aes_id

Line 697: CURSOR avl_csr(v_name OKL_AE_TEMPLATES.NAME%TYPE,

693: AND nvl(factoring_synd_flag,'N') = nvl(p_Avlv_rec.factoring_synd_flag,'N')
694: AND id <> p_avlv_rec.ID;
695:
696:
697: CURSOR avl_csr(v_name OKL_AE_TEMPLATES.NAME%TYPE,
698: v_version OKL_AE_TEMPLATES.version%TYPE,
699: v_aes_id OKL_AE_TEMPLATES.aes_id%TYPE ) IS
700: SELECT '1'
701: FROM OKL_AE_TEMPLATES

Line 698: v_version OKL_AE_TEMPLATES.version%TYPE,

694: AND id <> p_avlv_rec.ID;
695:
696:
697: CURSOR avl_csr(v_name OKL_AE_TEMPLATES.NAME%TYPE,
698: v_version OKL_AE_TEMPLATES.version%TYPE,
699: v_aes_id OKL_AE_TEMPLATES.aes_id%TYPE ) IS
700: SELECT '1'
701: FROM OKL_AE_TEMPLATES
702: WHERE name = v_name

Line 699: v_aes_id OKL_AE_TEMPLATES.aes_id%TYPE ) IS

695:
696:
697: CURSOR avl_csr(v_name OKL_AE_TEMPLATES.NAME%TYPE,
698: v_version OKL_AE_TEMPLATES.version%TYPE,
699: v_aes_id OKL_AE_TEMPLATES.aes_id%TYPE ) IS
700: SELECT '1'
701: FROM OKL_AE_TEMPLATES
702: WHERE name = v_name
703: AND version = v_version

Line 701: FROM OKL_AE_TEMPLATES

697: CURSOR avl_csr(v_name OKL_AE_TEMPLATES.NAME%TYPE,
698: v_version OKL_AE_TEMPLATES.version%TYPE,
699: v_aes_id OKL_AE_TEMPLATES.aes_id%TYPE ) IS
700: SELECT '1'
701: FROM OKL_AE_TEMPLATES
702: WHERE name = v_name
703: AND version = v_version
704: AND aes_id = v_aes_id
705: AND ID <> p_avlv_rec.ID;

Line 1027: -- FUNCTION get_rec for: OKL_AE_TEMPLATES

1023: NULL;
1024: END api_copy;
1025:
1026: ---------------------------------------------------------------------------
1027: -- FUNCTION get_rec for: OKL_AE_TEMPLATES
1028: ---------------------------------------------------------------------------
1029: FUNCTION get_rec (
1030: p_avl_rec IN avl_rec_type,
1031: x_no_data_found OUT NOCOPY BOOLEAN

Line 1033: CURSOR okl_ae_templates_pk_csr (p_id IN NUMBER) IS

1029: FUNCTION get_rec (
1030: p_avl_rec IN avl_rec_type,
1031: x_no_data_found OUT NOCOPY BOOLEAN
1032: ) RETURN avl_rec_type IS
1033: CURSOR okl_ae_templates_pk_csr (p_id IN NUMBER) IS
1034: SELECT
1035: ID,
1036: NAME,
1037: SET_OF_BOOKS_ID,

Line 1079: FROM Okl_Ae_Templates

1075: LAST_UPDATE_DATE,
1076: LAST_UPDATE_LOGIN,
1077: -- Added by HKPATEL for securitization changes
1078: INV_CODE
1079: FROM Okl_Ae_Templates
1080: WHERE okl_ae_templates.id = p_id;
1081: l_okl_ae_templates_pk okl_ae_templates_pk_csr%ROWTYPE;
1082: l_avl_rec avl_rec_type;
1083: BEGIN

Line 1080: WHERE okl_ae_templates.id = p_id;

1076: LAST_UPDATE_LOGIN,
1077: -- Added by HKPATEL for securitization changes
1078: INV_CODE
1079: FROM Okl_Ae_Templates
1080: WHERE okl_ae_templates.id = p_id;
1081: l_okl_ae_templates_pk okl_ae_templates_pk_csr%ROWTYPE;
1082: l_avl_rec avl_rec_type;
1083: BEGIN
1084: x_no_data_found := TRUE;

Line 1081: l_okl_ae_templates_pk okl_ae_templates_pk_csr%ROWTYPE;

1077: -- Added by HKPATEL for securitization changes
1078: INV_CODE
1079: FROM Okl_Ae_Templates
1080: WHERE okl_ae_templates.id = p_id;
1081: l_okl_ae_templates_pk okl_ae_templates_pk_csr%ROWTYPE;
1082: l_avl_rec avl_rec_type;
1083: BEGIN
1084: x_no_data_found := TRUE;
1085: -- Get current database values

Line 1086: OPEN okl_ae_templates_pk_csr (p_avl_rec.id);

1082: l_avl_rec avl_rec_type;
1083: BEGIN
1084: x_no_data_found := TRUE;
1085: -- Get current database values
1086: OPEN okl_ae_templates_pk_csr (p_avl_rec.id);
1087: FETCH okl_ae_templates_pk_csr INTO
1088: l_avl_rec.ID,
1089: l_avl_rec.NAME,
1090: l_avl_rec.SET_OF_BOOKS_ID,

Line 1087: FETCH okl_ae_templates_pk_csr INTO

1083: BEGIN
1084: x_no_data_found := TRUE;
1085: -- Get current database values
1086: OPEN okl_ae_templates_pk_csr (p_avl_rec.id);
1087: FETCH okl_ae_templates_pk_csr INTO
1088: l_avl_rec.ID,
1089: l_avl_rec.NAME,
1090: l_avl_rec.SET_OF_BOOKS_ID,
1091: l_avl_rec.STY_ID,

Line 1132: x_no_data_found := okl_ae_templates_pk_csr%NOTFOUND;

1128: l_avl_rec.LAST_UPDATE_DATE,
1129: l_avl_rec.LAST_UPDATE_LOGIN,
1130: -- Added by HKPATEL for securitization changes
1131: l_avl_rec.INV_CODE;
1132: x_no_data_found := okl_ae_templates_pk_csr%NOTFOUND;
1133: CLOSE okl_ae_templates_pk_csr;
1134: RETURN(l_avl_rec);
1135: END get_rec;
1136:

Line 1133: CLOSE okl_ae_templates_pk_csr;

1129: l_avl_rec.LAST_UPDATE_LOGIN,
1130: -- Added by HKPATEL for securitization changes
1131: l_avl_rec.INV_CODE;
1132: x_no_data_found := okl_ae_templates_pk_csr%NOTFOUND;
1133: CLOSE okl_ae_templates_pk_csr;
1134: RETURN(l_avl_rec);
1135: END get_rec;
1136:
1137: FUNCTION get_rec (

Line 1145: -- FUNCTION get_rec for: OKL_AE_TEMPLATES_V

1141: BEGIN
1142: RETURN(get_rec(p_avl_rec, l_row_notfound));
1143: END get_rec;
1144: ---------------------------------------------------------------------------
1145: -- FUNCTION get_rec for: OKL_AE_TEMPLATES_V
1146: ---------------------------------------------------------------------------
1147: FUNCTION get_rec (
1148: p_avlv_rec IN avlv_rec_type,
1149: x_no_data_found OUT NOCOPY BOOLEAN

Line 1197: FROM OKL_AE_TEMPLATES

1193: LAST_UPDATE_DATE,
1194: LAST_UPDATE_LOGIN,
1195: -- Added by HKPATEL for securitization changes
1196: INV_CODE
1197: FROM OKL_AE_TEMPLATES
1198: WHERE OKL_AE_TEMPLATES.id = p_id;
1199: l_okl_avlv_pk okl_avlv_pk_csr%ROWTYPE;
1200: l_avlv_rec avlv_rec_type;
1201: BEGIN

Line 1198: WHERE OKL_AE_TEMPLATES.id = p_id;

1194: LAST_UPDATE_LOGIN,
1195: -- Added by HKPATEL for securitization changes
1196: INV_CODE
1197: FROM OKL_AE_TEMPLATES
1198: WHERE OKL_AE_TEMPLATES.id = p_id;
1199: l_okl_avlv_pk okl_avlv_pk_csr%ROWTYPE;
1200: l_avlv_rec avlv_rec_type;
1201: BEGIN
1202: x_no_data_found := TRUE;

Line 1264: -- FUNCTION null_out_defaults for: OKL_AE_TEMPLATES_V --

1260: RETURN(get_rec(p_avlv_rec, l_row_notfound));
1261: END get_rec;
1262:
1263: --------------------------------------------------------
1264: -- FUNCTION null_out_defaults for: OKL_AE_TEMPLATES_V --
1265: --------------------------------------------------------
1266: FUNCTION null_out_defaults (
1267: p_avlv_rec IN avlv_rec_type
1268: ) RETURN avlv_rec_type IS

Line 1404: -- Validate_Attributes for:OKL_AE_TEMPLATES_V --

1400: ---------------------------------------------------------------------------
1401: -- PROCEDURE Validate_Attributes
1402: ---------------------------------------------------------------------------
1403: ------------------------------------------------
1404: -- Validate_Attributes for:OKL_AE_TEMPLATES_V --
1405: ------------------------------------------------
1406: FUNCTION Validate_Attributes (
1407: p_avlv_rec IN avlv_rec_type
1408: ) RETURN VARCHAR2 IS

Line 1577: -- Validate_Record for:OKL_AE_TEMPLATES_V --

1573: ---------------------------------------------------------------------------
1574: -- PROCEDURE Validate_Record
1575: ---------------------------------------------------------------------------
1576: --------------------------------------------
1577: -- Validate_Record for:OKL_AE_TEMPLATES_V --
1578: --------------------------------------------
1579: FUNCTION Validate_Record (
1580: p_avlv_rec IN avlv_rec_type
1581: ) RETURN VARCHAR2 IS

Line 1726: -- validate_row for:OKL_AE_TEMPLATES_V --

1722: ---------------------------------------------------------------------------
1723: -- PROCEDURE validate_row
1724: ---------------------------------------------------------------------------
1725: -----------------------------------------
1726: -- validate_row for:OKL_AE_TEMPLATES_V --
1727: -----------------------------------------
1728: PROCEDURE validate_row(
1729: p_api_version IN NUMBER,
1730: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1877: -- insert_row for:OKL_AE_TEMPLATES --

1873: ---------------------------------------------------------------------------
1874: -- PROCEDURE insert_row
1875: ---------------------------------------------------------------------------
1876: -------------------------------------
1877: -- insert_row for:OKL_AE_TEMPLATES --
1878: -------------------------------------
1879: PROCEDURE insert_row(
1880: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1881: x_return_status OUT NOCOPY VARCHAR2,

Line 1893: -- Set_Attributes for:OKL_AE_TEMPLATES --

1889: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1890: l_avl_rec avl_rec_type := p_avl_rec;
1891: l_def_avl_rec avl_rec_type;
1892: -----------------------------------------
1893: -- Set_Attributes for:OKL_AE_TEMPLATES --
1894: -----------------------------------------
1895: FUNCTION Set_Attributes (
1896: p_avl_rec IN avl_rec_type,
1897: x_avl_rec OUT NOCOPY avl_rec_type

Line 1928: INSERT INTO OKL_AE_TEMPLATES(

1924: /* Fixed Bug # 5707866 ssdeshpa start
1925: --Insert NULL Value for following Columns
1926: -- SET_OF_BOOKS_ID,POST_TO_GL,VERSION,ACCRUAL_YN
1927: --Since This Column are no longer Used */
1928: INSERT INTO OKL_AE_TEMPLATES(
1929: id,
1930: name,
1931: set_of_books_id,
1932: sty_id,

Line 2059: -- insert_row for:OKL_AE_TEMPLATES_V --

2055: '_PVT'
2056: );
2057: END insert_row;
2058: ---------------------------------------
2059: -- insert_row for:OKL_AE_TEMPLATES_V --
2060: ---------------------------------------
2061: PROCEDURE insert_row(
2062: p_api_version IN NUMBER,
2063: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2094: -- Set_Attributes for:OKL_AE_TEMPLATES_V --

2090: l_avlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2091: RETURN(l_avlv_rec);
2092: END fill_who_columns;
2093: -------------------------------------------
2094: -- Set_Attributes for:OKL_AE_TEMPLATES_V --
2095: -------------------------------------------
2096: FUNCTION Set_Attributes (
2097: p_avlv_rec IN avlv_rec_type,
2098: x_avlv_rec OUT NOCOPY avlv_rec_type

Line 2297: -- lock_row for:OKL_AE_TEMPLATES --

2293: ---------------------------------------------------------------------------
2294: -- PROCEDURE lock_row
2295: ---------------------------------------------------------------------------
2296: -----------------------------------
2297: -- lock_row for:OKL_AE_TEMPLATES --
2298: -----------------------------------
2299: PROCEDURE lock_row(
2300: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2301: x_return_status OUT NOCOPY VARCHAR2,

Line 2310: FROM OKL_AE_TEMPLATES

2306: E_Resource_Busy EXCEPTION;
2307: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2308: CURSOR lock_csr (p_avl_rec IN avl_rec_type) IS
2309: SELECT OBJECT_VERSION_NUMBER
2310: FROM OKL_AE_TEMPLATES
2311: WHERE ID = p_avl_rec.id
2312: AND OBJECT_VERSION_NUMBER = p_avl_rec.object_version_number
2313: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2314:

Line 2317: FROM OKL_AE_TEMPLATES

2313: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2314:
2315: CURSOR lchk_csr (p_avl_rec IN avl_rec_type) IS
2316: SELECT OBJECT_VERSION_NUMBER
2317: FROM OKL_AE_TEMPLATES
2318: WHERE ID = p_avl_rec.id;
2319: l_api_version CONSTANT NUMBER := 1;
2320: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
2321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2322: l_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;

2318: WHERE ID = p_avl_rec.id;
2319: l_api_version CONSTANT NUMBER := 1;
2320: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
2321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2322: l_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
2323: lc_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
2324: l_row_notfound BOOLEAN := FALSE;
2325: lc_row_notfound BOOLEAN := FALSE;
2326: BEGIN

Line 2323: lc_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;

2319: l_api_version CONSTANT NUMBER := 1;
2320: l_api_name CONSTANT VARCHAR2(30) := 'TEMPLATES_lock_row';
2321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2322: l_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
2323: lc_object_version_number OKL_AE_TEMPLATES.OBJECT_VERSION_NUMBER%TYPE;
2324: l_row_notfound BOOLEAN := FALSE;
2325: lc_row_notfound BOOLEAN := FALSE;
2326: BEGIN
2327: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2403: -- lock_row for:OKL_AE_TEMPLATES_V --

2399: '_PVT'
2400: );
2401: END lock_row;
2402: -------------------------------------
2403: -- lock_row for:OKL_AE_TEMPLATES_V --
2404: -------------------------------------
2405: PROCEDURE lock_row(
2406: p_api_version IN NUMBER,
2407: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2558: -- update_row for:OKL_AE_TEMPLATES --

2554: ---------------------------------------------------------------------------
2555: -- PROCEDURE update_row
2556: ---------------------------------------------------------------------------
2557: -------------------------------------
2558: -- update_row for:OKL_AE_TEMPLATES --
2559: -------------------------------------
2560: PROCEDURE update_row(
2561: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2562: x_return_status OUT NOCOPY VARCHAR2,

Line 2767: -- Set_Attributes for:OKL_AE_TEMPLATES --

2763: END IF;
2764: RETURN(l_return_status);
2765: END populate_new_record;
2766: -----------------------------------------
2767: -- Set_Attributes for:OKL_AE_TEMPLATES --
2768: -----------------------------------------
2769: FUNCTION Set_Attributes (
2770: p_avl_rec IN avl_rec_type,
2771: x_avl_rec OUT NOCOPY avl_rec_type

Line 2804: UPDATE OKL_AE_TEMPLATES

2800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2801: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2802: RAISE OKC_API.G_EXCEPTION_ERROR;
2803: END IF;
2804: UPDATE OKL_AE_TEMPLATES
2805: SET NAME = l_def_avl_rec.name,
2806: SET_OF_BOOKS_ID = l_def_avl_rec.set_of_books_id,
2807: STY_ID = l_def_avl_rec.sty_id,
2808: TRY_ID = l_def_avl_rec.try_id,

Line 2885: -- update_row for:OKL_AE_TEMPLATES_V --

2881: '_PVT'
2882: );
2883: END update_row;
2884: ---------------------------------------
2885: -- update_row for:OKL_AE_TEMPLATES_V --
2886: ---------------------------------------
2887: PROCEDURE update_row(
2888: p_api_version IN NUMBER,
2889: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 3109: -- Set_Attributes for:OKL_AE_TEMPLATES_V --

3105: END IF;
3106: RETURN(l_return_status);
3107: END populate_new_record;
3108: -------------------------------------------
3109: -- Set_Attributes for:OKL_AE_TEMPLATES_V --
3110: -------------------------------------------
3111: FUNCTION Set_Attributes (
3112: p_avlv_rec IN avlv_rec_type,
3113: x_avlv_rec OUT NOCOPY avlv_rec_type

Line 3316: -- delete_row for:OKL_AE_TEMPLATES --

3312: ---------------------------------------------------------------------------
3313: -- PROCEDURE delete_row
3314: ---------------------------------------------------------------------------
3315: -------------------------------------
3316: -- delete_row for:OKL_AE_TEMPLATES --
3317: -------------------------------------
3318: PROCEDURE delete_row(
3319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3320: x_return_status OUT NOCOPY VARCHAR2,

Line 3340: DELETE FROM OKL_AE_TEMPLATES

3336: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3338: RAISE OKC_API.G_EXCEPTION_ERROR;
3339: END IF;
3340: DELETE FROM OKL_AE_TEMPLATES
3341: WHERE ID = l_avl_rec.id;
3342:
3343: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3344: EXCEPTION

Line 3377: -- delete_row for:OKL_AE_TEMPLATES_V --

3373: '_PVT'
3374: );
3375: END delete_row;
3376: ---------------------------------------
3377: -- delete_row for:OKL_AE_TEMPLATES_V --
3378: ---------------------------------------
3379: PROCEDURE delete_row(
3380: p_api_version IN NUMBER,
3381: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,