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_FMA_PVT dependencies on OKL_FORMULAE_B

Line 43: FROM OKL_FORMULAE_B B --fixed bug 3321017 by kmotepal

39: BEGIN
40: DELETE FROM OKL_FORMULAE_TL T
41: WHERE NOT EXISTS (
42: SELECT NULL
43: FROM OKL_FORMULAE_B B --fixed bug 3321017 by kmotepal
44: WHERE B.ID = T.ID
45: );
46:
47: UPDATE OKL_FORMULAE_TL T SET (

Line 102: -- FUNCTION get_rec for: OKL_FORMULAE_B

98:
99: END add_language;
100:
101: ---------------------------------------------------------------------------
102: -- FUNCTION get_rec for: OKL_FORMULAE_B
103: ---------------------------------------------------------------------------
104: FUNCTION get_rec (
105: p_fma_rec IN fma_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN

Line 108: CURSOR okl_formulae_b_pk_csr (p_id IN NUMBER) IS

104: FUNCTION get_rec (
105: p_fma_rec IN fma_rec_type,
106: x_no_data_found OUT NOCOPY BOOLEAN
107: ) RETURN fma_rec_type IS
108: CURSOR okl_formulae_b_pk_csr (p_id IN NUMBER) IS
109: SELECT
110: ID,
111: NAME,
112: ORG_ID,

Line 142: FROM Okl_Formulae_B

138: CREATION_DATE,
139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM Okl_Formulae_B
143: WHERE okl_formulae_b.id = p_id;
144: l_okl_formulae_b_pk okl_formulae_b_pk_csr%ROWTYPE;
145: l_fma_rec fma_rec_type;
146: BEGIN

Line 143: WHERE okl_formulae_b.id = p_id;

139: LAST_UPDATED_BY,
140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM Okl_Formulae_B
143: WHERE okl_formulae_b.id = p_id;
144: l_okl_formulae_b_pk okl_formulae_b_pk_csr%ROWTYPE;
145: l_fma_rec fma_rec_type;
146: BEGIN
147: x_no_data_found := TRUE;

Line 144: l_okl_formulae_b_pk okl_formulae_b_pk_csr%ROWTYPE;

140: LAST_UPDATE_DATE,
141: LAST_UPDATE_LOGIN
142: FROM Okl_Formulae_B
143: WHERE okl_formulae_b.id = p_id;
144: l_okl_formulae_b_pk okl_formulae_b_pk_csr%ROWTYPE;
145: l_fma_rec fma_rec_type;
146: BEGIN
147: x_no_data_found := TRUE;
148: -- Get current database values

Line 149: OPEN okl_formulae_b_pk_csr (p_fma_rec.id);

145: l_fma_rec fma_rec_type;
146: BEGIN
147: x_no_data_found := TRUE;
148: -- Get current database values
149: OPEN okl_formulae_b_pk_csr (p_fma_rec.id);
150: FETCH okl_formulae_b_pk_csr INTO
151: l_fma_rec.ID,
152: l_fma_rec.NAME,
153: l_fma_rec.ORG_ID,

Line 150: FETCH okl_formulae_b_pk_csr INTO

146: BEGIN
147: x_no_data_found := TRUE;
148: -- Get current database values
149: OPEN okl_formulae_b_pk_csr (p_fma_rec.id);
150: FETCH okl_formulae_b_pk_csr INTO
151: l_fma_rec.ID,
152: l_fma_rec.NAME,
153: l_fma_rec.ORG_ID,
154: l_fma_rec.THERE_CAN_BE_ONLY_ONE_YN,

Line 183: x_no_data_found := okl_formulae_b_pk_csr%NOTFOUND;

179: l_fma_rec.CREATION_DATE,
180: l_fma_rec.LAST_UPDATED_BY,
181: l_fma_rec.LAST_UPDATE_DATE,
182: l_fma_rec.LAST_UPDATE_LOGIN;
183: x_no_data_found := okl_formulae_b_pk_csr%NOTFOUND;
184: CLOSE okl_formulae_b_pk_csr;
185: RETURN(l_fma_rec);
186: END get_rec;
187:

Line 184: CLOSE okl_formulae_b_pk_csr;

180: l_fma_rec.LAST_UPDATED_BY,
181: l_fma_rec.LAST_UPDATE_DATE,
182: l_fma_rec.LAST_UPDATE_LOGIN;
183: x_no_data_found := okl_formulae_b_pk_csr%NOTFOUND;
184: CLOSE okl_formulae_b_pk_csr;
185: RETURN(l_fma_rec);
186: END get_rec;
187:
188: FUNCTION get_rec (

Line 1906: -- insert_row for:OKL_FORMULAE_B --

1902: ---------------------------------------------------------------------------
1903: -- PROCEDURE insert_row
1904: ---------------------------------------------------------------------------
1905: -----------------------------------
1906: -- insert_row for:OKL_FORMULAE_B --
1907: -----------------------------------
1908: PROCEDURE insert_row(
1909: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1910: x_return_status OUT NOCOPY VARCHAR2,

Line 1922: -- Set_Attributes for:OKL_FORMULAE_B --

1918: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1919: l_fma_rec fma_rec_type := p_fma_rec;
1920: l_def_fma_rec fma_rec_type;
1921: ---------------------------------------
1922: -- Set_Attributes for:OKL_FORMULAE_B --
1923: ---------------------------------------
1924: FUNCTION Set_Attributes (
1925: p_fma_rec IN fma_rec_type,
1926: x_fma_rec OUT NOCOPY fma_rec_type

Line 1953: INSERT INTO OKL_FORMULAE_B(

1949: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1950: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1951: RAISE OKC_API.G_EXCEPTION_ERROR;
1952: END IF;
1953: INSERT INTO OKL_FORMULAE_B(
1954: id,
1955: name,
1956: org_id,
1957: there_can_be_only_one_yn,

Line 2412: -- lock_row for:OKL_FORMULAE_B --

2408: ---------------------------------------------------------------------------
2409: -- PROCEDURE lock_row
2410: ---------------------------------------------------------------------------
2411: ---------------------------------
2412: -- lock_row for:OKL_FORMULAE_B --
2413: ---------------------------------
2414: PROCEDURE lock_row(
2415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2416: x_return_status OUT NOCOPY VARCHAR2,

Line 2425: FROM OKL_FORMULAE_B

2421: E_Resource_Busy EXCEPTION;
2422: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2423: CURSOR lock_csr (p_fma_rec IN fma_rec_type) IS
2424: SELECT OBJECT_VERSION_NUMBER
2425: FROM OKL_FORMULAE_B
2426: WHERE ID = p_fma_rec.id
2427: AND OBJECT_VERSION_NUMBER = p_fma_rec.object_version_number
2428: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2429:

Line 2432: FROM OKL_FORMULAE_B

2428: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2429:
2430: CURSOR lchk_csr (p_fma_rec IN fma_rec_type) IS
2431: SELECT OBJECT_VERSION_NUMBER
2432: FROM OKL_FORMULAE_B
2433: WHERE ID = p_fma_rec.id;
2434: l_api_version CONSTANT NUMBER := 1;
2435: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 2437: l_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;

2433: WHERE ID = p_fma_rec.id;
2434: l_api_version CONSTANT NUMBER := 1;
2435: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2437: l_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;
2438: lc_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;
2439: l_row_notfound BOOLEAN := FALSE;
2440: lc_row_notfound BOOLEAN := FALSE;
2441: BEGIN

Line 2438: lc_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;

2434: l_api_version CONSTANT NUMBER := 1;
2435: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
2436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2437: l_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;
2438: lc_object_version_number OKL_FORMULAE_B.OBJECT_VERSION_NUMBER%TYPE;
2439: l_row_notfound BOOLEAN := FALSE;
2440: lc_row_notfound BOOLEAN := FALSE;
2441: BEGIN
2442: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2776: -- update_row for:OKL_FORMULAE_B --

2772: ---------------------------------------------------------------------------
2773: -- PROCEDURE update_row
2774: ---------------------------------------------------------------------------
2775: -----------------------------------
2776: -- update_row for:OKL_FORMULAE_B --
2777: -----------------------------------
2778: PROCEDURE update_row(
2779: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2780: x_return_status OUT NOCOPY VARCHAR2,

Line 2940: -- Set_Attributes for:OKL_FORMULAE_B --

2936: END IF;
2937: RETURN(l_return_status);
2938: END populate_new_record;
2939: ---------------------------------------
2940: -- Set_Attributes for:OKL_FORMULAE_B --
2941: ---------------------------------------
2942: FUNCTION Set_Attributes (
2943: p_fma_rec IN fma_rec_type,
2944: x_fma_rec OUT NOCOPY fma_rec_type

Line 2977: UPDATE OKL_FORMULAE_B

2973: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2974: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2975: RAISE OKC_API.G_EXCEPTION_ERROR;
2976: END IF;
2977: UPDATE OKL_FORMULAE_B
2978: SET NAME = l_def_fma_rec.name,
2979: ORG_ID = l_def_fma_rec.org_id,
2980: THERE_CAN_BE_ONLY_ONE_YN = l_def_fma_rec.there_can_be_only_one_yn,
2981: CGR_ID = l_def_fma_rec.cgr_id,

Line 3610: -- delete_row for:OKL_FORMULAE_B --

3606: ---------------------------------------------------------------------------
3607: -- PROCEDURE delete_row
3608: ---------------------------------------------------------------------------
3609: -----------------------------------
3610: -- delete_row for:OKL_FORMULAE_B --
3611: -----------------------------------
3612: PROCEDURE delete_row(
3613: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3614: x_return_status OUT NOCOPY VARCHAR2,

Line 3634: DELETE FROM OKL_FORMULAE_B

3630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3631: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3632: RAISE OKC_API.G_EXCEPTION_ERROR;
3633: END IF;
3634: DELETE FROM OKL_FORMULAE_B
3635: WHERE ID = l_fma_rec.id;
3636:
3637: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
3638: EXCEPTION

Line 3988: FROM OKL_FORMULAE_B

3984:
3985: BEGIN
3986: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
3987: INTO id, db_luby, db_ludate
3988: FROM OKL_FORMULAE_B
3989: where ID = p_fmav_rec.id;
3990:
3991: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3992: db_ludate, '')) then

Line 3994: UPDATE OKL_FORMULAE_B

3990:
3991: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3992: db_ludate, '')) then
3993: --Update _b
3994: UPDATE OKL_FORMULAE_B
3995: SET
3996: ORG_ID = TO_NUMBER(p_fmav_rec.ORG_ID),
3997: THERE_CAN_BE_ONLY_ONE_YN = p_fmav_rec.THERE_CAN_BE_ONLY_ONE_YN,
3998: CGR_ID = TO_NUMBER(p_fmav_rec.CGR_ID),

Line 4076: INSERT INTO OKL_FORMULAE_B

4072: END;
4073: EXCEPTION
4074: when no_data_found then
4075:
4076: INSERT INTO OKL_FORMULAE_B
4077: (
4078: ID,
4079: NAME,
4080: ORG_ID,

Line 4146: from OKL_FORMULAE_B

4142: f_ludate,
4143: 0
4144: FROM DUAL
4145: WHERE NOT EXISTS (SELECT 1
4146: from OKL_FORMULAE_B
4147: where ( ID = TO_NUMBER(p_fmav_rec.id) OR
4148: (NAME = p_fmav_rec.NAME AND VERSION = p_fmav_rec.VERSION)));
4149:
4150: INSERT INTO OKL_FORMULAE_TL