APPS.PAY_NL_GENERAL dependencies on PAY_LEGISLATION_RULES

Line 551: -- Creates a Row in Pay_Legislation_Rules

547: END get_sit_type_name;
548:
549: ---------------------------------------------------------------------------
550: -- Procedure : insert_leg_rule
551: -- Creates a Row in Pay_Legislation_Rules
552: ---------------------------------------------------------------------------
553: /* Procedure to insert legislation rule via concurrent program*/
554:
555: PROCEDURE insert_leg_rule(errbuf out nocopy varchar2, retcode out nocopy varchar2,p_retropay_method IN number) is

Line 558: SELECT 'Y' FROM pay_legislation_rules

554:
555: PROCEDURE insert_leg_rule(errbuf out nocopy varchar2, retcode out nocopy varchar2,p_retropay_method IN number) is
556:
557: CURSOR c_leg_rule(p_rule_type varchar2) is
558: SELECT 'Y' FROM pay_legislation_rules
559: WHERE legislation_code='NL'
560: AND rule_type=p_rule_type;
561:
562: l_rule_found varchar2(10):='N';

Line 581: insert into pay_legislation_rules(legislation_code,rule_type,rule_mode) values ('NL','RETRO_COMP_DFLT_OVERRIDE','Y');

577:
578:
579:
580: if (p_retropay_method = 1 AND l_rule_found = 'N') then /* Replacement Method */
581: insert into pay_legislation_rules(legislation_code,rule_type,rule_mode) values ('NL','RETRO_COMP_DFLT_OVERRIDE','Y');
582: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Added,Retropay method is now REPLACEMENT');
583: else /*Standard Method*/
584: IF (p_retropay_method = 0 AND l_rule_found = 'Y') then
585: delete from pay_legislation_rules

Line 585: delete from pay_legislation_rules

581: insert into pay_legislation_rules(legislation_code,rule_type,rule_mode) values ('NL','RETRO_COMP_DFLT_OVERRIDE','Y');
582: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Added,Retropay method is now REPLACEMENT');
583: else /*Standard Method*/
584: IF (p_retropay_method = 0 AND l_rule_found = 'Y') then
585: delete from pay_legislation_rules
586: where legislation_code='NL'
587: and rule_type='RETRO_COMP_DFLT_OVERRIDE';
588: fnd_file.put_line(FND_FILE.LOG,'Legislation Rule Removed,Retropay method is now STANDARD');
589: END if;

Line 606: SELECT 'Y' FROM pay_legislation_rules

602: RETURN NUMBER
603: is
604:
605: CURSOR c_leg_rule(p_rule_type varchar2) is
606: SELECT 'Y' FROM pay_legislation_rules
607: WHERE legislation_code='NL'
608: AND rule_type=p_rule_type;
609:
610: CURSOR c_std_retro_definition

Line 801: from pay_legislation_rules

797: -- declare cursor 0 for retrieving each legislation using this flex num
798: --
799: cursor c0 is
800: select legislation_code
801: from pay_legislation_rules
802: where rule_type = 'S'
803: and rule_mode = to_char (p_id_flex_num);
804: l_created_by number;
805: l_last_login number;

Line 806: l_legislation_code pay_legislation_rules.legislation_code%type;

802: where rule_type = 'S'
803: and rule_mode = to_char (p_id_flex_num);
804: l_created_by number;
805: l_last_login number;
806: l_legislation_code pay_legislation_rules.legislation_code%type;
807: --
808: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
809: -- create_scl_flex +
810: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++