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.PQH_SEED_BEN_CRITERIA dependencies on BEN_ELIGY_CRITERIA

Line 30: l_created_by ben_eligy_criteria.created_by%type;

26: ,p_last_update_date in varchar2
27: ) is
28:
29: l_ovn number := 1;
30: l_created_by ben_eligy_criteria.created_by%type;
31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;

Line 31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;

27: ) is
28:
29: l_ovn number := 1;
30: l_created_by ben_eligy_criteria.created_by%type;
31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:

Line 32: l_creation_date ben_eligy_criteria.creation_date%type;

28:
29: l_ovn number := 1;
30: l_created_by ben_eligy_criteria.created_by%type;
31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;

Line 33: l_last_update_date ben_eligy_criteria.last_update_date%type;

29: l_ovn number := 1;
30: l_created_by ben_eligy_criteria.created_by%type;
31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;

Line 34: l_last_update_login ben_eligy_criteria.last_update_login%type;

30: l_created_by ben_eligy_criteria.created_by%type;
31: l_last_updated_by ben_eligy_criteria.last_updated_by%type;
32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
38:

Line 36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;

32: l_creation_date ben_eligy_criteria.creation_date%type;
33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
38:
39: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
40:

Line 37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;

33: l_last_update_date ben_eligy_criteria.last_update_date%type;
34: l_last_update_login ben_eligy_criteria.last_update_login%type;
35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
38:
39: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
40:
41:

Line 39: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;

35:
36: l_col1_value_set_id ben_eligy_criteria.col1_value_set_id%type;
37: l_col2_value_set_id ben_eligy_criteria.col2_value_set_id%type;
38:
39: l_eligy_criteria_id ben_eligy_criteria.eligy_criteria_id%type;
40:
41:
42: cursor csr_fvs(p_valset_name in varchar2) is
43: select flex_value_set_id

Line 49: from ben_eligy_criteria

45: where flex_value_set_name = p_valset_name;
46: --
47: cursor csr_bec is
48: select eligy_criteria_id
49: from ben_eligy_criteria
50: where short_code = p_short_code and business_group_id is null and criteria_type='STD';
51: --
52: cursor csr_bg_bec is
53: select eligy_criteria_id

Line 54: from ben_eligy_criteria

50: where short_code = p_short_code and business_group_id is null and criteria_type='STD';
51: --
52: cursor csr_bg_bec is
53: select eligy_criteria_id
54: from ben_eligy_criteria
55: where short_code = p_short_code and business_group_id is not null and criteria_type='STD';
56: --
57: l_data_migrator_mode varchar2(10);
58: --

Line 88: update ben_eligy_criteria set

84: close csr_fvs;
85:
86: if l_eligy_criteria_id is not null then
87: --
88: update ben_eligy_criteria set
89: name = p_name,
90: description = p_description,
91: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
92: crit_col1_datatype = p_crit_col1_datatype,

Line 118: update ben_eligy_criteria set

114: -- Update any BG specific rows that were created.
115: --
116: For bg_crit_rec in csr_bg_bec loop
117: --
118: update ben_eligy_criteria set
119: name = p_name,
120: description = p_description,
121: crit_col1_val_type_cd = p_crit_col1_val_type_cd,
122: crit_col1_datatype = p_crit_col1_datatype,

Line 147: insert into ben_eligy_criteria

143: End loop;
144:
145: else
146: --
147: insert into ben_eligy_criteria
148: (
149: eligy_criteria_id,
150: short_code,
151: name,

Line 180: ben_eligy_criteria_s.nextval,

176: object_version_number
177: )
178: values
179: (
180: ben_eligy_criteria_s.nextval,
181: p_short_code,
182: p_name,
183: p_description,
184: p_crit_col1_val_type_cd,