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.BEN_EXT_WHERE_CLAUSE_API dependencies on BEN_EXT_WHERE_CLAUSE

Line 1: Package Body ben_ext_where_clause_api as

1: Package Body ben_ext_where_clause_api as
2: /* $Header: bexwcapi.pkb 120.2 2005/10/11 06:44:36 rbingi noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ben_ext_where_clause_api.';

2: /* $Header: bexwcapi.pkb 120.2 2005/10/11 06:44:36 rbingi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_ext_where_clause_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ext_where_clause >----------------------|
10: -- ----------------------------------------------------------------------------

Line 32: l_ext_where_clause_id ben_ext_where_clause.ext_where_clause_id%TYPE;

28: ) is
29: --
30: -- Declare cursors and local variables
31: --
32: l_ext_where_clause_id ben_ext_where_clause.ext_where_clause_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_ext_where_clause';
34: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;
35: --
36: begin

Line 34: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;

30: -- Declare cursors and local variables
31: --
32: l_ext_where_clause_id ben_ext_where_clause.ext_where_clause_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_ext_where_clause';
34: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 52: ben_ext_where_clause_bk1.create_ext_where_clause_b

48: begin
49: --
50: -- Start of API User Hook for the before hook of create_ext_where_clause
51: --
52: ben_ext_where_clause_bk1.create_ext_where_clause_b
53: (
54: p_seq_num => p_seq_num
55: ,p_oper_cd => p_oper_cd
56: ,p_val => p_val

Line 101: ben_ext_where_clause_bk1.create_ext_where_clause_a

97: begin
98: --
99: -- Start of API User Hook for the after hook of create_ext_where_clause
100: --
101: ben_ext_where_clause_bk1.create_ext_where_clause_a
102: (
103: p_ext_where_clause_id => l_ext_where_clause_id
104: ,p_seq_num => p_seq_num
105: ,p_oper_cd => p_oper_cd

Line 196: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;

192: --
193: -- Declare cursors and local variables
194: --
195: l_proc varchar2(72) := g_package||'update_ext_where_clause';
196: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;
197: --
198: begin
199: --
200: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 216: ben_ext_where_clause_bk2.update_ext_where_clause_b

212: begin
213: --
214: -- Start of API User Hook for the before hook of update_ext_where_clause
215: --
216: ben_ext_where_clause_bk2.update_ext_where_clause_b
217: (
218: p_ext_where_clause_id => p_ext_where_clause_id
219: ,p_seq_num => p_seq_num
220: ,p_oper_cd => p_oper_cd

Line 266: ben_ext_where_clause_bk2.update_ext_where_clause_a

262: begin
263: --
264: -- Start of API User Hook for the after hook of update_ext_where_clause
265: --
266: ben_ext_where_clause_bk2.update_ext_where_clause_a
267: (
268: p_ext_where_clause_id => p_ext_where_clause_id
269: ,p_seq_num => p_seq_num
270: ,p_oper_cd => p_oper_cd

Line 346: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;

342: --
343: -- Declare cursors and local variables
344: --
345: l_proc varchar2(72) := g_package||'update_ext_where_clause';
346: l_object_version_number ben_ext_where_clause.object_version_number%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 367: ben_ext_where_clause_bk3.delete_ext_where_clause_b

363: begin
364: --
365: -- Start of API User Hook for the before hook of delete_ext_where_clause
366: --
367: ben_ext_where_clause_bk3.delete_ext_where_clause_b
368: (
369: p_ext_where_clause_id => p_ext_where_clause_id
370: ,p_legislation_code => p_legislation_code
371: ,p_object_version_number => p_object_version_number

Line 397: ben_ext_where_clause_bk3.delete_ext_where_clause_a

393: begin
394: --
395: -- Start of API User Hook for the after hook of delete_ext_where_clause
396: --
397: ben_ext_where_clause_bk3.delete_ext_where_clause_a
398: (
399: p_ext_where_clause_id => p_ext_where_clause_id
400: ,p_legislation_code => p_legislation_code
401: ,p_object_version_number => l_object_version_number

Line 495: FROM ben_ext_where_clause xwc

491: l_proc varchar2(72) := 'insert_validate';
492: --
493: cursor c_xwc is
494: SELECT seq_num, and_or_cd
495: FROM ben_ext_where_clause xwc
496: WHERE ( business_group_id is null
497: or business_group_id = p_business_group_id )
498: and (legislation_code is null
499: or legislation_code = p_legislation_code )

Line 535: end ben_ext_where_clause_api;

531: End if;
532: --
533: End multi_rows_edit;
534: --
535: end ben_ext_where_clause_api;