DBA Data[Home] [Help]

APPS.IGS_SC_BULK_ASSIGN dependencies on IGS_GE_DATE

Line 568: --l_Inf_date := igs_ge_date.igsdate(igs_ge_date.igschar('4712/12/31')) ; -- cannonical format is rrrr/mm/dd ;

564: FOR i IN 1..l_usrroles_array.COUNT
565: LOOP
566: IF l_enddate_array(i) IS NULL THEN
567: l_Inf_date := null ; --remove the logic for infinite date.
568: --l_Inf_date := igs_ge_date.igsdate(igs_ge_date.igschar('4712/12/31')) ; -- cannonical format is rrrr/mm/dd ;
569: ELSE
570: l_Inf_date :=igs_ge_date.igsdate((l_enddate_array(i) ));
571: END IF;
572:

Line 570: l_Inf_date :=igs_ge_date.igsdate((l_enddate_array(i) ));

566: IF l_enddate_array(i) IS NULL THEN
567: l_Inf_date := null ; --remove the logic for infinite date.
568: --l_Inf_date := igs_ge_date.igsdate(igs_ge_date.igschar('4712/12/31')) ; -- cannonical format is rrrr/mm/dd ;
569: ELSE
570: l_Inf_date :=igs_ge_date.igsdate((l_enddate_array(i) ));
571: END IF;
572:
573: IF l_enddate_array(i) IS NOT NULL THEN
574: l_start_date:=igs_ge_date.igsdate((l_startdate_array(i) ));

Line 574: l_start_date:=igs_ge_date.igsdate((l_startdate_array(i) ));

570: l_Inf_date :=igs_ge_date.igsdate((l_enddate_array(i) ));
571: END IF;
572:
573: IF l_enddate_array(i) IS NOT NULL THEN
574: l_start_date:=igs_ge_date.igsdate((l_startdate_array(i) ));
575: END IF;
576:
577: -- IMP: FND_USER has cust_id , person_party_id and emp_id. If person is from HZ the cust = pp_id
578: -- If person is from HR then cust is null and emp_id is not null