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_TRY_PVT dependencies on OKL_TRX_TYPES_B

Line 43: from OKL_TRX_TYPES_B B --fixed bug 3321017 by kmotepal

39: begin
40: delete from OKL_TRX_TYPES_TL T
41: where not exists (
42: select null
43: from OKL_TRX_TYPES_B B --fixed bug 3321017 by kmotepal
44: where B.ID = T.ID
45: );
46:
47: update OKL_TRX_TYPES_TL T set (

Line 117: -- FUNCTION get_rec for: OKL_TRX_TYPES_B

113:
114: end add_language;
115:
116: ---------------------------------------------------------------------------
117: -- FUNCTION get_rec for: OKL_TRX_TYPES_B
118: ---------------------------------------------------------------------------
119: function get_rec (
120: p_try_rec in try_rec_type,
121: x_no_data_found out NOCOPY boolean

Line 123: cursor okl_trx_types_b_pk_csr (p_id in number) is

119: function get_rec (
120: p_try_rec in try_rec_type,
121: x_no_data_found out NOCOPY boolean
122: ) return try_rec_type is
123: cursor okl_trx_types_b_pk_csr (p_id in number) is
124: select
125: ID,
126: TRY_ID,
127: TRY_ID_FOR,

Line 148: from Okl_Trx_Types_B

144: --Bug 4386433 - End of Changes
145: --Bug 5707866 dpsingh
146: FORMULA_YN,
147: ACCOUNTING_EVENT_CLASS_CODE
148: from Okl_Trx_Types_B
149: where okl_trx_types_b.id = p_id;
150: l_okl_trx_types_b_pk okl_trx_types_b_pk_csr%rowtype;
151: l_try_rec try_rec_type;
152: begin

Line 149: where okl_trx_types_b.id = p_id;

145: --Bug 5707866 dpsingh
146: FORMULA_YN,
147: ACCOUNTING_EVENT_CLASS_CODE
148: from Okl_Trx_Types_B
149: where okl_trx_types_b.id = p_id;
150: l_okl_trx_types_b_pk okl_trx_types_b_pk_csr%rowtype;
151: l_try_rec try_rec_type;
152: begin
153: x_no_data_found := true;

Line 150: l_okl_trx_types_b_pk okl_trx_types_b_pk_csr%rowtype;

146: FORMULA_YN,
147: ACCOUNTING_EVENT_CLASS_CODE
148: from Okl_Trx_Types_B
149: where okl_trx_types_b.id = p_id;
150: l_okl_trx_types_b_pk okl_trx_types_b_pk_csr%rowtype;
151: l_try_rec try_rec_type;
152: begin
153: x_no_data_found := true;
154: -- Get current database values

Line 155: open okl_trx_types_b_pk_csr (p_try_rec.id);

151: l_try_rec try_rec_type;
152: begin
153: x_no_data_found := true;
154: -- Get current database values
155: open okl_trx_types_b_pk_csr (p_try_rec.id);
156: fetch okl_trx_types_b_pk_csr into
157: l_try_rec.ID,
158: l_try_rec.TRY_ID,
159: l_try_rec.TRY_ID_FOR,

Line 156: fetch okl_trx_types_b_pk_csr into

152: begin
153: x_no_data_found := true;
154: -- Get current database values
155: open okl_trx_types_b_pk_csr (p_try_rec.id);
156: fetch okl_trx_types_b_pk_csr into
157: l_try_rec.ID,
158: l_try_rec.TRY_ID,
159: l_try_rec.TRY_ID_FOR,
160: l_try_rec.ILC_ID,

Line 180: x_no_data_found := okl_trx_types_b_pk_csr%notfound;

176: --Bug 4386433 - End of Changes
177: --Bug 5707866 dpsingh
178: l_try_rec.FORMULA_YN,
179: l_try_rec.ACCOUNTING_EVENT_CLASS_CODE;
180: x_no_data_found := okl_trx_types_b_pk_csr%notfound;
181: close okl_trx_types_b_pk_csr;
182: return(l_try_rec);
183: end get_rec;
184:

Line 181: close okl_trx_types_b_pk_csr;

177: --Bug 5707866 dpsingh
178: l_try_rec.FORMULA_YN,
179: l_try_rec.ACCOUNTING_EVENT_CLASS_CODE;
180: x_no_data_found := okl_trx_types_b_pk_csr%notfound;
181: close okl_trx_types_b_pk_csr;
182: return(l_try_rec);
183: end get_rec;
184:
185: function get_rec (

Line 2199: -- insert_row for:OKL_TRX_TYPES_B --

2195: ---------------------------------------------------------------------------
2196: -- PROCEDURE insert_row
2197: ---------------------------------------------------------------------------
2198: ------------------------------------
2199: -- insert_row for:OKL_TRX_TYPES_B --
2200: ------------------------------------
2201: procedure insert_row(
2202: p_init_msg_list in varchar2,
2203: x_return_status out NOCOPY varchar2,

Line 2215: -- Set_Attributes for:OKL_TRX_TYPES_B --

2211: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2212: l_try_rec try_rec_type := p_try_rec;
2213: l_def_try_rec try_rec_type;
2214: ----------------------------------------
2215: -- Set_Attributes for:OKL_TRX_TYPES_B --
2216: ----------------------------------------
2217: function Set_Attributes (
2218: p_try_rec in try_rec_type,
2219: x_try_rec out NOCOPY try_rec_type

Line 2246: insert into OKL_TRX_TYPES_B(

2242: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2243: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
2244: raise Okc_Api.G_EXCEPTION_ERROR;
2245: end if;
2246: insert into OKL_TRX_TYPES_B(
2247: id,
2248: try_id,
2249: try_id_for,
2250: ilc_id,

Line 2704: -- lock_row for:OKL_TRX_TYPES_B --

2700: ---------------------------------------------------------------------------
2701: -- PROCEDURE lock_row
2702: ---------------------------------------------------------------------------
2703: ----------------------------------
2704: -- lock_row for:OKL_TRX_TYPES_B --
2705: ----------------------------------
2706: procedure lock_row(
2707: p_init_msg_list in varchar2,
2708: x_return_status out NOCOPY varchar2,

Line 2717: from OKL_TRX_TYPES_B

2713: E_Resource_Busy exception;
2714: pragma exception_init(E_Resource_Busy, -00054);
2715: cursor lock_csr (p_try_rec in try_rec_type) is
2716: select OBJECT_VERSION_NUMBER
2717: from OKL_TRX_TYPES_B
2718: where ID = p_try_rec.id
2719: and OBJECT_VERSION_NUMBER = p_try_rec.object_version_number
2720: for update of OBJECT_VERSION_NUMBER nowait;
2721:

Line 2724: from OKL_TRX_TYPES_B

2720: for update of OBJECT_VERSION_NUMBER nowait;
2721:
2722: cursor lchk_csr (p_try_rec in try_rec_type) is
2723: select OBJECT_VERSION_NUMBER
2724: from OKL_TRX_TYPES_B
2725: where ID = p_try_rec.id;
2726: l_api_version constant number := 1;
2727: l_api_name constant varchar2(30) := 'B_lock_row';
2728: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2729: l_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;

2725: where ID = p_try_rec.id;
2726: l_api_version constant number := 1;
2727: l_api_name constant varchar2(30) := 'B_lock_row';
2728: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2729: l_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;
2730: lc_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;
2731: l_row_notfound boolean := false;
2732: lc_row_notfound boolean := false;
2733: begin

Line 2730: lc_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;

2726: l_api_version constant number := 1;
2727: l_api_name constant varchar2(30) := 'B_lock_row';
2728: l_return_status varchar2(1) := Okc_Api.G_RET_STS_SUCCESS;
2729: l_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;
2730: lc_object_version_number OKL_TRX_TYPES_B.OBJECT_VERSION_NUMBER%type;
2731: l_row_notfound boolean := false;
2732: lc_row_notfound boolean := false;
2733: begin
2734: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 3066: -- update_row for:OKL_TRX_TYPES_B --

3062: ---------------------------------------------------------------------------
3063: -- PROCEDURE update_row
3064: ---------------------------------------------------------------------------
3065: ------------------------------------
3066: -- update_row for:OKL_TRX_TYPES_B --
3067: ------------------------------------
3068: procedure update_row(
3069: p_init_msg_list in varchar2,
3070: x_return_status out NOCOPY varchar2,

Line 3182: -- Set_Attributes for:OKL_TRX_TYPES_B --

3178: end if;
3179: return(l_return_status);
3180: end populate_new_record;
3181: ----------------------------------------
3182: -- Set_Attributes for:OKL_TRX_TYPES_B --
3183: ----------------------------------------
3184: function Set_Attributes (
3185: p_try_rec in try_rec_type,
3186: x_try_rec out NOCOPY try_rec_type

Line 3219: update OKL_TRX_TYPES_B

3215: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3216: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3217: raise Okc_Api.G_EXCEPTION_ERROR;
3218: end if;
3219: update OKL_TRX_TYPES_B
3220: set TRY_ID = l_def_try_rec.try_id,
3221: TRY_ID_FOR = l_def_try_rec.try_id_for,
3222: ILC_ID = l_def_try_rec.ilc_id,
3223: AEP_CODE = l_def_try_rec.aep_code,

Line 3821: -- delete_row for:OKL_TRX_TYPES_B --

3817: ---------------------------------------------------------------------------
3818: -- PROCEDURE delete_row
3819: ---------------------------------------------------------------------------
3820: ------------------------------------
3821: -- delete_row for:OKL_TRX_TYPES_B --
3822: ------------------------------------
3823: procedure delete_row(
3824: p_init_msg_list in varchar2,
3825: x_return_status out NOCOPY varchar2,

Line 3845: delete from OKL_TRX_TYPES_B

3841: raise Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3842: elsif (l_return_status = Okc_Api.G_RET_STS_ERROR) then
3843: raise Okc_Api.G_EXCEPTION_ERROR;
3844: end if;
3845: delete from OKL_TRX_TYPES_B
3846: where ID = l_try_rec.id;
3847:
3848: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3849: exception

Line 4200: FROM OKL_TRX_TYPES_B

4196:
4197: BEGIN
4198: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
4199: INTO id, db_luby, db_ludate
4200: FROM OKL_TRX_TYPES_B
4201: where ID = p_tryv_rec.id;
4202:
4203: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
4204: db_ludate, '')) then

Line 4206: UPDATE OKL_TRX_TYPES_B

4202:
4203: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
4204: db_ludate, '')) then
4205: --Update _b
4206: UPDATE OKL_TRX_TYPES_B
4207: SET
4208: OBJECT_VERSION_NUMBER = p_tryv_rec.object_version_number,
4209: TRY_ID = p_tryv_rec.try_id,
4210: TRY_ID_FOR = p_tryv_rec.try_id_for,

Line 4284: INSERT INTO OKL_TRX_TYPES_B

4280: END;
4281: EXCEPTION
4282: when no_data_found then
4283: --Insert Into b
4284: INSERT INTO OKL_TRX_TYPES_B
4285: (
4286: ID,
4287: TRY_ID,
4288: TRY_ID_FOR,