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_NL_EXTRA_ASG_RULES dependencies on HR_API

Line 122: IF p_tax_code= hr_api.g_varchar2 THEN

118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;
124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;

Line 125: IF p_tax_red_apply= hr_api.g_varchar2 THEN

121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;
124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;
127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;

Line 128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN

124: END IF;
125: IF p_tax_red_apply= hr_api.g_varchar2 THEN
126: l_tax_red_apply := NVL(tax_details_rec.tax_red,'N') ;
127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;
130: END IF;
131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN
132: l_add_sr_tax_apply := NVL(tax_details_rec.add_sr_tax,'N') ;

Line 131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN

127: END IF;
128: IF p_labour_tax_apply= hr_api.g_varchar2 THEN
129: l_labour_tax_apply := NVL(tax_details_rec.labour_tax,'N') ;
130: END IF;
131: IF p_add_sr_tax_apply= hr_api.g_varchar2 THEN
132: l_add_sr_tax_apply := NVL(tax_details_rec.add_sr_tax,'N') ;
133: END IF;
134: END IF;
135: /*

Line 331: IF p_special_indicators = hr_api.g_varchar2 THEN

327:
328: BEGIN
329: hr_utility.trace('Entering validate_spl_indicators');
330: --
331: IF p_special_indicators = hr_api.g_varchar2 THEN
332: open csr_get_spl_indicator_details(p_assignment_id,p_effective_date);
333: fetch csr_get_spl_indicator_details into l_special_indicators2;
334: l_special_indicators := l_special_indicators2.special_indicator;
335: close csr_get_spl_indicator_details;

Line 498: IF p_employment_type= hr_api.g_varchar2 THEN

494:
495: OPEN csr_get_asg_oth_details(p_assignment_id,p_effective_date);
496: FETCH csr_get_asg_oth_details INTO oth_details_rec;
497: IF csr_get_asg_oth_details%FOUND THEN
498: IF p_employment_type= hr_api.g_varchar2 THEN
499: l_emp_type := oth_details_rec.emp_type ;
500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;

Line 501: IF p_employment_subtype= hr_api.g_varchar2 THEN

497: IF csr_get_asg_oth_details%FOUND THEN
498: IF p_employment_type= hr_api.g_varchar2 THEN
499: l_emp_type := oth_details_rec.emp_type ;
500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;
503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;

Line 504: IF p_commencing_from= hr_api.g_date THEN

500: END IF;
501: IF p_employment_subtype= hr_api.g_varchar2 THEN
502: l_emp_sub_type := oth_details_rec.emp_sub_type ;
503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;
506: END IF;
507: IF p_date_ending= hr_api.g_date THEN
508: l_date_ending := oth_details_rec.date_ending ;

Line 507: IF p_date_ending= hr_api.g_date THEN

503: END IF;
504: IF p_commencing_from= hr_api.g_date THEN
505: l_commencing_from := oth_details_rec.commencing_from ;
506: END IF;
507: IF p_date_ending= hr_api.g_date THEN
508: l_date_ending := oth_details_rec.date_ending ;
509: END IF;
510:
511:

Line 575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)

571: -- Message Text -
572: -- "You are attempting to save this record without submitting all of the
573: -- mandatory information. Please enter a value in Frequency."
574:
575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)
576: AND p_frequency IS null) THEN
577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
578: hr_utility.set_message_token('FIELD', 'Frequency');
579: hr_utility.raise_error;

Line 613: IF (p_ind_perc <> hr_api.g_number) THEN

609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
610: hr_utility.raise_error;
611: END IF;
612:
613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR
615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN
616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');
617: hr_utility.raise_error;

Line 621: IF (p_percentage <> hr_api.g_number) THEN

617: hr_utility.raise_error;
618: END IF;
619: END IF;
620:
621: IF (p_percentage <> hr_api.g_number) THEN
622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');

Line 729: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then

725: l_frequency:=p_frequency;
726:
727: IF p_scl_segment28 IS NULL then
728: l_ind_working_hrs := NULL;
729: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then
730: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);
731: ELSE
732: l_ind_working_hrs := hr_api.g_number;
733: END if;

Line 732: l_ind_working_hrs := hr_api.g_number;

728: l_ind_working_hrs := NULL;
729: ELSIF p_scl_segment28 <> hr_api.g_varchar2 then
730: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment28),2);
731: ELSE
732: l_ind_working_hrs := hr_api.g_number;
733: END if;
734:
735: validate_tax_code_combinations(p_person_id
736: ,null ,p_payroll_id ,p_effective_date

Line 747: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then

743:
744:
745: IF p_scl_segment21 IS NULL then
746: l_commencing_date := NULL;
747: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
748: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
749: ELSE
750: l_commencing_date := hr_api.g_date;
751: END if;

Line 750: l_commencing_date := hr_api.g_date;

746: l_commencing_date := NULL;
747: ELSIF p_scl_segment21 <> hr_api.g_varchar2 then
748: l_commencing_date:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment21);
749: ELSE
750: l_commencing_date := hr_api.g_date;
751: END if;
752:
753: IF p_scl_segment23 IS NULL then
754: l_date_ending := NULL;

Line 755: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then

751: END if;
752:
753: IF p_scl_segment23 IS NULL then
754: l_date_ending := NULL;
755: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
756: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
757: ELSE
758: l_date_ending := hr_api.g_date;
759: END if;

Line 758: l_date_ending := hr_api.g_date;

754: l_date_ending := NULL;
755: ELSIF p_scl_segment23 <> hr_api.g_varchar2 then
756: l_date_ending:=FND_DATE.CANONICAL_TO_DATE(p_scl_segment23);
757: ELSE
758: l_date_ending := hr_api.g_date;
759: END if;
760:
761: IF p_scl_segment29 IS NULL then
762: l_percentage := NULL;

Line 763: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then

759: END if;
760:
761: IF p_scl_segment29 IS NULL then
762: l_percentage := NULL;
763: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then
764: l_percentage:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment29),2);
765: ELSE
766: l_percentage := hr_api.g_number;
767: END if;

Line 766: l_percentage := hr_api.g_number;

762: l_percentage := NULL;
763: ELSIF p_scl_segment29 <> hr_api.g_varchar2 then
764: l_percentage:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment29),2);
765: ELSE
766: l_percentage := hr_api.g_number;
767: END if;
768:
769: IF p_scl_segment20 IS NULL then
770: l_ind_perc := NULL;

Line 771: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then

767: END if;
768:
769: IF p_scl_segment20 IS NULL then
770: l_ind_perc := NULL;
771: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then
772: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment20);
773: ELSE
774: l_ind_perc := hr_api.g_number;
775: END if;

Line 774: l_ind_perc := hr_api.g_number;

770: l_ind_perc := NULL;
771: ELSIF p_scl_segment20 <> hr_api.g_varchar2 then
772: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_scl_segment20);
773: ELSE
774: l_ind_perc := hr_api.g_number;
775: END if;
776:
777:
778: other_validations(null ,p_effective_date

Line 917: ELSIF p_frequency =hr_api.g_varchar2 then

913: END IF;
914: l_frequency:=p_frequency;
915: IF p_frequency IS NULL then
916: l_frequency := NULL;
917: ELSIF p_frequency =hr_api.g_varchar2 then
918: open csr_freq;
919: fetch csr_freq into l_frequency ;
920: close csr_freq;
921: END if;

Line 929: IF p_segment21 = hr_api.g_varchar2 THEN

925: ,p_segment11 ,p_segment4 ,p_segment7 ,p_segment9);
926:
927: validate_spl_indicators(p_segment10,p_assignment_id,p_effective_date);
928:
929: IF p_segment21 = hr_api.g_varchar2 THEN
930: open csr_get_date_details(p_assignment_id,p_effective_date);
931: hr_utility.trace('DATE1');
932: fetch csr_get_date_details into date_details_rec;
933: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);

Line 939: IF p_segment23 = hr_api.g_varchar2 THEN

935: ELSE
936: l_commencing_date := fnd_date.canonical_to_date(p_segment21);
937: END IF;
938:
939: IF p_segment23 = hr_api.g_varchar2 THEN
940: open csr_get_date_details(p_assignment_id,p_effective_date);
941: fetch csr_get_date_details into date_details_rec;
942: l_date_ending := fnd_date.canonical_to_date(date_details_rec.date_ending);
943: close csr_get_date_details;

Line 950: ELSIF p_segment28 <> hr_api.g_varchar2 then

946: END IF;
947:
948: IF p_segment28 IS NULL THEN
949: l_ind_working_hrs := NULL;
950: ELSIF p_segment28 <> hr_api.g_varchar2 then
951: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_segment28),2);
952: ELSE
953: l_ind_working_hrs := hr_api.g_number;
954: END if;

Line 953: l_ind_working_hrs := hr_api.g_number;

949: l_ind_working_hrs := NULL;
950: ELSIF p_segment28 <> hr_api.g_varchar2 then
951: l_ind_working_hrs:=round(FND_NUMBER.CANONICAL_TO_NUMBER(p_segment28),2);
952: ELSE
953: l_ind_working_hrs := hr_api.g_number;
954: END if;
955:
956: IF p_segment29 IS NULL THEN
957: l_percentage := NULL;

Line 958: ELSIF p_segment29 <> hr_api.g_varchar2 THEN

954: END if;
955:
956: IF p_segment29 IS NULL THEN
957: l_percentage := NULL;
958: ELSIF p_segment29 <> hr_api.g_varchar2 THEN
959: l_percentage := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment29);
960: ELSE
961: l_percentage := hr_api.g_number;
962: END IF;

Line 961: l_percentage := hr_api.g_number;

957: l_percentage := NULL;
958: ELSIF p_segment29 <> hr_api.g_varchar2 THEN
959: l_percentage := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment29);
960: ELSE
961: l_percentage := hr_api.g_number;
962: END IF;
963:
964: IF p_segment20 IS NULL THEN
965: l_ind_perc := NULL;

Line 966: ELSIF p_segment20 <> hr_api.g_varchar2 THEN

962: END IF;
963:
964: IF p_segment20 IS NULL THEN
965: l_ind_perc := NULL;
966: ELSIF p_segment20 <> hr_api.g_varchar2 THEN
967: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment20);
968: ELSE
969: l_ind_perc := hr_api.g_number;
970: END IF;

Line 969: l_ind_perc := hr_api.g_number;

965: l_ind_perc := NULL;
966: ELSIF p_segment20 <> hr_api.g_varchar2 THEN
967: l_ind_perc := FND_NUMBER.CANONICAL_TO_NUMBER(p_segment20);
968: ELSE
969: l_ind_perc := hr_api.g_number;
970: END IF;
971:
972:
973: other_validations(p_assignment_id