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.HR_LEGISLATION dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 189: -- pay_legislative_field_info

185: -- 115.31 RThirlby 11-APR-2000 Added call to translate_ca_ele_dev_df
186: -- for transferrind CA balance type ids
187: -- stored in the Element Developer DF.
188: -- 115.32 tbattoo 12-APr-2000 Added new columns to install
189: -- pay_legislative_field_info
190: -- 115.33 tbattoo 18-Apr-2000 Added updatable_flag column to
191: -- install_report_mappings
192: -- 115.34 tbattoo 25-Apr-2000 Added support for pay_report_format_items_f
193: -- 115.35 mreid 19-Jun-2000 Added to update_sequence in case

Line 4076: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATIVE FIELD INFO

4072:
4073: END install_ass_info;
4074:
4075: --****************************************************************************
4076: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATIVE FIELD INFO
4077: --****************************************************************************
4078:
4079: PROCEDURE install_leg_field (phase IN number)
4080: ---------------------------------------------

Line 4120: l_prompt pay_legislative_field_info.prompt%type;

4116: IS
4117: -- Check if a delivered row is needed and insert into the
4118: -- live tables if it is.
4119:
4120: l_prompt pay_legislative_field_info.prompt%type;
4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;

Line 4121: l_val_type pay_legislative_field_info.validation_type%type;

4117: -- Check if a delivered row is needed and insert into the
4118: -- live tables if it is.
4119:
4120: l_prompt pay_legislative_field_info.prompt%type;
4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;

Line 4122: l_rule_mode pay_legislative_field_info.rule_mode%type;

4118: -- live tables if it is.
4119:
4120: l_prompt pay_legislative_field_info.prompt%type;
4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;

Line 4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;

4119:
4120: l_prompt pay_legislative_field_info.prompt%type;
4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;

Line 4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;

4120: l_prompt pay_legislative_field_info.prompt%type;
4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;
4128: l_target_location pay_legislative_field_info.target_location%type;

Line 4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;

4121: l_val_type pay_legislative_field_info.validation_type%type;
4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;
4128: l_target_location pay_legislative_field_info.target_location%type;
4129: l_rowid rowid;

Line 4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;

4122: l_rule_mode pay_legislative_field_info.rule_mode%type;
4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;
4128: l_target_location pay_legislative_field_info.target_location%type;
4129: l_rowid rowid;
4130: BEGIN

Line 4127: l_category pay_legislative_field_info.category%type;

4123: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;
4128: l_target_location pay_legislative_field_info.target_location%type;
4129: l_rowid rowid;
4130: BEGIN
4131:

Line 4128: l_target_location pay_legislative_field_info.target_location%type;

4124: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
4125: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
4126: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
4127: l_category pay_legislative_field_info.category%type;
4128: l_target_location pay_legislative_field_info.target_location%type;
4129: l_rowid rowid;
4130: BEGIN
4131:
4132: BEGIN

Line 4153: from pay_legislative_field_info

4149: , l_BUBBLE_TIP_MESSAGE
4150: , l_category
4151: , l_target_location
4152: , l_rowid
4153: from pay_legislative_field_info
4154: where field_name = stu_rec.field_name
4155: and legislation_code = stu_rec.legislation_code
4156: and rule_type = stu_rec.rule_type
4157: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')

Line 4161: hr_utility.trace('sel pay_legislative_field_info TMR');

4157: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')
4158: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
4159: EXCEPTION WHEN TOO_MANY_ROWS THEN
4160: hrrunprc_trace_on;
4161: hr_utility.trace('sel pay_legislative_field_info TMR');
4162: hr_utility.trace('field_name ' ||
4163: stu_rec.field_name);
4164: hr_utility.trace('rule_type ' ||
4165: stu_rec.rule_type);

Line 4190: update pay_legislative_field_info

4186:
4187: IF phase = 1 THEN return; END IF;
4188:
4189:
4190: update pay_legislative_field_info
4191: set
4192: prompt = stu_rec.prompt
4193: , validation_name = stu_rec.validation_name
4194: , validation_type = stu_rec.validation_type

Line 4216: insert into pay_legislative_field_info

4212: IF phase = 1 THEN return; END IF;
4213:
4214:
4215: BEGIN
4216: insert into pay_legislative_field_info
4217: (field_name
4218: ,legislation_code
4219: ,prompt
4220: ,validation_name