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 3830: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATIVE FIELD INFO

3826:
3827: END install_ass_info;
3828:
3829: --****************************************************************************
3830: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATIVE FIELD INFO
3831: --****************************************************************************
3832:
3833: PROCEDURE install_leg_field (phase IN number)
3834: ---------------------------------------------

Line 3874: l_prompt pay_legislative_field_info.prompt%type;

3870: IS
3871: -- Check if a delivered row is needed and insert into the
3872: -- live tables if it is.
3873:
3874: l_prompt pay_legislative_field_info.prompt%type;
3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;

Line 3875: l_val_type pay_legislative_field_info.validation_type%type;

3871: -- Check if a delivered row is needed and insert into the
3872: -- live tables if it is.
3873:
3874: l_prompt pay_legislative_field_info.prompt%type;
3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;

Line 3876: l_rule_mode pay_legislative_field_info.rule_mode%type;

3872: -- live tables if it is.
3873:
3874: l_prompt pay_legislative_field_info.prompt%type;
3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;

Line 3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;

3873:
3874: l_prompt pay_legislative_field_info.prompt%type;
3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;

Line 3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;

3874: l_prompt pay_legislative_field_info.prompt%type;
3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;
3882: l_target_location pay_legislative_field_info.target_location%type;

Line 3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;

3875: l_val_type pay_legislative_field_info.validation_type%type;
3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;
3882: l_target_location pay_legislative_field_info.target_location%type;
3883: l_rowid rowid;

Line 3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;

3876: l_rule_mode pay_legislative_field_info.rule_mode%type;
3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;
3882: l_target_location pay_legislative_field_info.target_location%type;
3883: l_rowid rowid;
3884: BEGIN

Line 3881: l_category pay_legislative_field_info.category%type;

3877: l_PROMPT_MESSAGE pay_legislative_field_info.PROMPT_MESSAGE%type;
3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;
3882: l_target_location pay_legislative_field_info.target_location%type;
3883: l_rowid rowid;
3884: BEGIN
3885:

Line 3882: l_target_location pay_legislative_field_info.target_location%type;

3878: l_IN_LINE_MESSAGE pay_legislative_field_info.IN_LINE_MESSAGE%type;
3879: l_QUICK_TIP_MESSAGE pay_legislative_field_info.QUICK_TIP_MESSAGE%type;
3880: l_BUBBLE_TIP_MESSAGE pay_legislative_field_info.BUBBLE_TIP_MESSAGE%type;
3881: l_category pay_legislative_field_info.category%type;
3882: l_target_location pay_legislative_field_info.target_location%type;
3883: l_rowid rowid;
3884: BEGIN
3885:
3886: BEGIN

Line 3907: from pay_legislative_field_info

3903: , l_BUBBLE_TIP_MESSAGE
3904: , l_category
3905: , l_target_location
3906: , l_rowid
3907: from pay_legislative_field_info
3908: where field_name = stu_rec.field_name
3909: and legislation_code = stu_rec.legislation_code
3910: and rule_type = stu_rec.rule_type
3911: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')

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

3911: and nvl(target_location,'~') = nvl(stu_rec.target_location,'~')
3912: and nvl(validation_name,'~') = nvl(stu_rec.validation_name,'~');
3913: EXCEPTION WHEN TOO_MANY_ROWS THEN
3914: hrrunprc_trace_on;
3915: hr_utility.trace('sel pay_legislative_field_info TMR');
3916: hr_utility.trace('field_name ' ||
3917: stu_rec.field_name);
3918: hr_utility.trace('rule_type ' ||
3919: stu_rec.rule_type);

Line 3944: update pay_legislative_field_info

3940:
3941: IF phase = 1 THEN return; END IF;
3942:
3943:
3944: update pay_legislative_field_info
3945: set
3946: prompt = stu_rec.prompt
3947: , validation_name = stu_rec.validation_name
3948: , validation_type = stu_rec.validation_type

Line 3970: insert into pay_legislative_field_info

3966: IF phase = 1 THEN return; END IF;
3967:
3968:
3969: BEGIN
3970: insert into pay_legislative_field_info
3971: (field_name
3972: ,legislation_code
3973: ,prompt
3974: ,validation_name