561:
562: ln_step_id :=get_payrate_step_id(p_transaction_id);
563:
564: if(ln_step_id is not null) then
565: lv_status := ame_util.booleanAttributeTrue;
566: else
567: lv_status := ame_util.booleanAttributeFalse;
568: end if;
569:
563:
564: if(ln_step_id is not null) then
565: lv_status := ame_util.booleanAttributeTrue;
566: else
567: lv_status := ame_util.booleanAttributeFalse;
568: end if;
569:
570: if(hr_utility.debug_enabled) then
571: -- write debug statements
596: end if;
597:
598: ln_step_id :=get_assignment_step_id(p_transaction_id);
599: if(ln_step_id is not null) then
600: lv_status := ame_util.booleanAttributeTrue;
601: else
602: lv_status := ame_util.booleanAttributeFalse;
603: end if;
604:
598: ln_step_id :=get_assignment_step_id(p_transaction_id);
599: if(ln_step_id is not null) then
600: lv_status := ame_util.booleanAttributeTrue;
601: else
602: lv_status := ame_util.booleanAttributeFalse;
603: end if;
604:
605: if(hr_utility.debug_enabled) then
606: -- write debug statements
631: end if;
632:
633: ln_step_id := get_supeversior_Chg_step_id(p_transaction_id);
634: if(ln_step_id is not null) then
635: lv_status := ame_util.booleanAttributeTrue;
636: else
637: lv_status := ame_util.booleanAttributeFalse;
638: end if;
639:
633: ln_step_id := get_supeversior_Chg_step_id(p_transaction_id);
634: if(ln_step_id is not null) then
635: lv_status := ame_util.booleanAttributeTrue;
636: else
637: lv_status := ame_util.booleanAttributeFalse;
638: end if;
639:
640: if(hr_utility.debug_enabled) then
641: -- write debug statements
668: end if;
669:
670: ln_step_id := get_loa_step_id(p_transaction_id);
671: if(ln_step_id is not null) then
672: lv_status := ame_util.booleanAttributeTrue;
673: else
674: lv_status := ame_util.booleanAttributeFalse;
675: end if;
676:
670: ln_step_id := get_loa_step_id(p_transaction_id);
671: if(ln_step_id is not null) then
672: lv_status := ame_util.booleanAttributeTrue;
673: else
674: lv_status := ame_util.booleanAttributeFalse;
675: end if;
676:
677: if(hr_utility.debug_enabled) then
678: -- write debug statements
705: end if;
706:
707: ln_step_id :=get_termination_step_id(p_transaction_id);
708: if(ln_step_id is not null) then
709: lv_status := ame_util.booleanAttributeTrue;
710: else
711: lv_status := ame_util.booleanAttributeFalse;
712: end if;
713:
707: ln_step_id :=get_termination_step_id(p_transaction_id);
708: if(ln_step_id is not null) then
709: lv_status := ame_util.booleanAttributeTrue;
710: else
711: lv_status := ame_util.booleanAttributeFalse;
712: end if;
713:
714: if(hr_utility.debug_enabled) then
715: -- write debug statements
748: if(ln_step_id is null) then
749: ln_salary_percent_change := null;
750: else
751: -- fix for bug 4148680
752: if (is_new_change_pay (ln_step_id)= ame_util.booleanAttributeFalse)then
753: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
754: -- get number of components P_NO_OF_COMPONENTS
755:
756: ln_no_of_components :=hr_transaction_api.get_number_value
829:
830: if(ln_step_id is null) then
831: ln_salary_amt_change := null;
832: else
833: if (is_new_change_pay(ln_step_id) = ame_util.booleanAttributeFalse) then
834: -- fix for bug 4148680
835: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
836: -- get number of components P_NO_OF_COMPONENTS
837: ln_no_of_components :=hr_transaction_api.get_number_value
911: -- write debug statements
912: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step__id:'||p_transaction_step_id, 10);
913: end if;
914: if (ln_api_name='PER_SSHR_CHANGE_PAY.PROCESS_API') then
915: lv_status := ame_util.booleanAttributeTrue;
916: else
917: lv_status := ame_util.booleanAttributeFalse;
918: end if;
919: return lv_status;
913: end if;
914: if (ln_api_name='PER_SSHR_CHANGE_PAY.PROCESS_API') then
915: lv_status := ame_util.booleanAttributeTrue;
916: else
917: lv_status := ame_util.booleanAttributeFalse;
918: end if;
919: return lv_status;
920: EXCEPTION
921:
936: -- write debug statements
937: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
938: end if;
939: begin
940: select ame_util.versiondatetostring(creation_date)
941: into lv_creation_date_string
942: from hr_api_transactions
943: where transaction_id=p_transaction_id;
944: exception
980: lv_item_type := get_item_type(p_transaction_id);
981: lv_item_key := get_item_key(p_transaction_id);
982:
983: if(lv_item_key is not null) then
984: lv_effective_date_string := ame_util.versiondatetostring(wf_engine.GetItemAttrDate(itemtype => lv_item_type ,
985: itemkey => lv_item_key,
986: aname => 'CURRENT_EFFECTIVE_DATE',
987: ignore_notfound => true));
988:
1827: -- write debug statements
1828: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1829: end if;
1830:
1831: if(isMidPayPayPeriodChange(p_transaction_id)=ame_util.booleanAttributeTrue) then
1832: if(hr_utility.debug_enabled) then
1833: hr_utility.set_location('calling wf_engine.getitemattrtext ',3);
1834: end if;
1835: lv_user_name:= wf_engine.getitemattrtext(get_item_type(p_transaction_id),get_item_key(p_transaction_id),'HR_PAYROLL_CONTACT_USERNAME',true);
1909:
1910: ln_step_id := get_basic_details_step_id(p_transaction_id);
1911:
1912: if(ln_step_id is not null) then
1913: lv_status := ame_util.booleanAttributeTrue;
1914: else
1915: lv_status := ame_util.booleanAttributeFalse;
1916: end if;
1917:
1911:
1912: if(ln_step_id is not null) then
1913: lv_status := ame_util.booleanAttributeTrue;
1914: else
1915: lv_status := ame_util.booleanAttributeFalse;
1916: end if;
1917:
1918: if(hr_utility.debug_enabled) then
1919: -- write debug statements
1985:
1986: ln_step_id := get_person_address_step_id(p_transaction_id);
1987:
1988: if(ln_step_id is not null) then
1989: lv_status := ame_util.booleanAttributeTrue;
1990: else
1991: lv_status := ame_util.booleanAttributeFalse;
1992: end if;
1993:
1987:
1988: if(ln_step_id is not null) then
1989: lv_status := ame_util.booleanAttributeTrue;
1990: else
1991: lv_status := ame_util.booleanAttributeFalse;
1992: end if;
1993:
1994: if(hr_utility.debug_enabled) then
1995: -- write debug statements
2062:
2063: ln_step_id := get_person_contact_step_id(p_transaction_id);
2064:
2065: if(ln_step_id is not null) then
2066: lv_status := ame_util.booleanAttributeTrue;
2067: else
2068: lv_status := ame_util.booleanAttributeFalse;
2069: end if;
2070:
2064:
2065: if(ln_step_id is not null) then
2066: lv_status := ame_util.booleanAttributeTrue;
2067: else
2068: lv_status := ame_util.booleanAttributeFalse;
2069: end if;
2070:
2071: if(hr_utility.debug_enabled) then
2072: -- write debug statements
2137:
2138: ln_step_id := get_caed_step_id(p_transaction_id);
2139:
2140: if(ln_step_id is not null) then
2141: lv_status := ame_util.booleanAttributeTrue;
2142: else
2143: lv_status := ame_util.booleanAttributeFalse;
2144: end if;
2145:
2139:
2140: if(ln_step_id is not null) then
2141: lv_status := ame_util.booleanAttributeTrue;
2142: else
2143: lv_status := ame_util.booleanAttributeFalse;
2144: end if;
2145:
2146: if(hr_utility.debug_enabled) then
2147: -- write debug statements
2242: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2243: end if;
2244:
2245: -- check if this transaction has assignment step
2246: if(isAssignmentChange(p_transaction_id)=ame_util.booleanAttributeTrue) then
2247: -- code logic from hr_workflow_ss.check_mid_pay_period_change
2248:
2249: l_asg_txn_step_id:= get_assignment_step_id(p_transaction_id);
2250: l_effective_date := to_date(
2287: FETCH csr_check_mid_pay_period into l_pay_period_start_date
2288: ,l_pay_period_end_date;
2289: IF csr_check_mid_pay_period%NOTFOUND THEN
2290: -- That means the effective date is not in mid pay period
2291: lv_status := ame_util.booleanAttributeFalse;
2292: CLOSE csr_check_mid_pay_period;
2293: ELSE
2294: lv_status := ame_util.booleanAttributeTrue;
2295: CLOSE csr_check_mid_pay_period;
2290: -- That means the effective date is not in mid pay period
2291: lv_status := ame_util.booleanAttributeFalse;
2292: CLOSE csr_check_mid_pay_period;
2293: ELSE
2294: lv_status := ame_util.booleanAttributeTrue;
2295: CLOSE csr_check_mid_pay_period;
2296: END IF;
2297: END IF;
2298: else
2295: CLOSE csr_check_mid_pay_period;
2296: END IF;
2297: END IF;
2298: else
2299: lv_status := ame_util.booleanAttributeFalse;
2300: end if;
2301:
2302: if(hr_utility.debug_enabled) then
2303: -- write debug statements