DBA Data[Home] [Help]

APPS.BEN_DET_WAIT_PERD_CMPLTN dependencies on BEN_COBJ_CACHE

Line 890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then

886: -- Look for waiting period attributes at the appropriate level based on the
887: -- comp object being processed.
888: if p_pgm_id is not null then
889: -- The comp object being passed in is a pgm. Get wtg data at pgm level.
890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;

Line 891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then

887: -- comp object being processed.
888: if p_pgm_id is not null then
889: -- The comp object being passed in is a pgm. Get wtg data at pgm level.
890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;

Line 894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;

890: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;

Line 895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;

891: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;

Line 896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;

892: l_wait_data_found := false;
893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;

Line 897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;

893: else
894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else

Line 898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;

894: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
895: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
896: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
897: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;

Line 902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;

898: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;

Line 903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;

899: l_wait_data_found := true;
900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;

Line 904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;

900: end if;
901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;

Line 905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;

901: else
902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;
909: end if; -- if pgm

Line 906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;

902: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
903: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
904: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
905: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
906: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
907: l_wait_data_found := true;
908: end if;
909: end if; -- if pgm
910:

Line 913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then

909: end if; -- if pgm
910:
911: if p_oipl_id is not null then
912: -- The comp object being evaluated is a OIPL. Get details at OIPL level.
913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;

Line 914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then

910:
911: if p_oipl_id is not null then
912: -- The comp object being evaluated is a OIPL. Get details at OIPL level.
913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;

Line 917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;

913: if ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd is null then
914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;

Line 918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;

914: if ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd is null then
915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;

Line 919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;

915: l_wait_data_found := false;
916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;

Line 920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;

916: else
917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else

Line 921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;

917: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_cd;
918: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_dt_to_use_rl;
919: l_wait_perd_rl := ben_cobj_cache.g_oipletpr_currow.wait_perd_rl;
920: l_wait_perd_uom := ben_cobj_cache.g_oipletpr_currow.wait_perd_uom;
921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;

Line 925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;

921: l_wait_perd_val := ben_cobj_cache.g_oipletpr_currow.wait_perd_val;
922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;

Line 926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;

922: l_wait_data_found := true;
923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;

Line 927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;

923: end if;
924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;

Line 928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;

924: else
925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;
932: end if; -- if oipl

Line 929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;

925: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_cd;
926: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_dt_to_use_rl;
927: l_wait_perd_rl := ben_cobj_cache.g_oiplprel_currow.wait_perd_rl;
928: l_wait_perd_uom := ben_cobj_cache.g_oiplprel_currow.wait_perd_uom;
929: l_wait_perd_val := ben_cobj_cache.g_oiplprel_currow.wait_perd_val;
930: l_wait_data_found := true;
931: end if;
932: end if; -- if oipl
933:

Line 940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then

936: -- The comp object being evaluated is a plan.
937: if l_envplip_id is not null then
938: -- The plan belongs to a program. Try to get anything defined at the
939: -- plip level first.
940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;

Line 941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then

937: if l_envplip_id is not null then
938: -- The plan belongs to a program. Try to get anything defined at the
939: -- plip level first.
940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;

Line 944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;

940: if ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd is null then
941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;

Line 945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;

941: if ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd is null then
942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;

Line 946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;

942: l_wait_data_found := false;
943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;

Line 947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;

943: else
944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else

Line 948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;

944: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_cd;
945: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_dt_to_use_rl;
946: l_wait_perd_rl := ben_cobj_cache.g_plipetpr_currow.wait_perd_rl;
947: l_wait_perd_uom := ben_cobj_cache.g_plipetpr_currow.wait_perd_uom;
948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;

Line 952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;

948: l_wait_perd_val := ben_cobj_cache.g_plipetpr_currow.wait_perd_val;
949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;

Line 953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;

949: l_wait_data_found := true;
950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;

Line 954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;

950: end if;
951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;

Line 955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;

951: else
952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;
959: end if; -- if plip_id is not null

Line 956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;

952: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_cd;
953: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_dt_to_use_rl;
954: l_wait_perd_rl := ben_cobj_cache.g_plipprel_currow.wait_perd_rl;
955: l_wait_perd_uom := ben_cobj_cache.g_plipprel_currow.wait_perd_uom;
956: l_wait_perd_val := ben_cobj_cache.g_plipprel_currow.wait_perd_val;
957: l_wait_data_found := true;
958: end if;
959: end if; -- if plip_id is not null
960: --

Line 964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then

960: --
961: -- If nothing was found at the PLIP level above, then search at the PL level
962: --
963: if l_wait_data_found = FALSE and (p_pl_id is not null or p_oipl_id is not null) then
964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;

Line 965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then

961: -- If nothing was found at the PLIP level above, then search at the PL level
962: --
963: if l_wait_data_found = FALSE and (p_pl_id is not null or p_oipl_id is not null) then
964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;

Line 968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;

964: if ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd is null then
965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;

Line 969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;

965: if ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd is null then
966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;

Line 970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;

966: l_wait_data_found := false;
967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;

Line 971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;

967: else
968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else

Line 972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;

968: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_cd;
969: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_dt_to_use_rl;
970: l_wait_perd_rl := ben_cobj_cache.g_pletpr_currow.wait_perd_rl;
971: l_wait_perd_uom := ben_cobj_cache.g_pletpr_currow.wait_perd_uom;
972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;

Line 976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;

972: l_wait_perd_val := ben_cobj_cache.g_pletpr_currow.wait_perd_val;
973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;

Line 977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;

973: l_wait_data_found := true;
974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;

Line 978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;

974: end if;
975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;

Line 979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;

975: else
976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;
983: end if; -- wait_data_found=false

Line 980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;

976: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_cd;
977: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_plprel_currow.wait_perd_dt_to_use_rl;
978: l_wait_perd_rl := ben_cobj_cache.g_plprel_currow.wait_perd_rl;
979: l_wait_perd_uom := ben_cobj_cache.g_plprel_currow.wait_perd_uom;
980: l_wait_perd_val := ben_cobj_cache.g_plprel_currow.wait_perd_val;
981: l_wait_data_found := true;
982: end if;
983: end if; -- wait_data_found=false
984: end if; -- if plan or oipl(and didn't find oipl level)

Line 991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then

987: -- are working with a ptip, look for ptip
988: if l_wait_data_found =FALSE and l_envptip_id is not null and
989: (p_pl_id is not null or p_oipl_id is not null or p_ptip_id is not null
990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then

Line 992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then

988: if l_wait_data_found =FALSE and l_envptip_id is not null and
989: (p_pl_id is not null or p_oipl_id is not null or p_ptip_id is not null
990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;

Line 994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then

990: or p_plip_id is not null) then
991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;

Line 995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then

991: if ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd is null then
992: if ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd is null then
993: -- Look at pgm level
994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;

Line 998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;

994: if ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd is null then
995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;

Line 999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;

995: if ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd is null then
996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;

Line 1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;

996: l_wait_data_found := false;
997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;

Line 1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;

997: else
998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else

Line 1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;

998: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_cd;
999: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_dt_to_use_rl;
1000: l_wait_perd_rl := ben_cobj_cache.g_pgmprel_currow.wait_perd_rl;
1001: l_wait_perd_uom := ben_cobj_cache.g_pgmprel_currow.wait_perd_uom;
1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;

Line 1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;

1002: l_wait_perd_val := ben_cobj_cache.g_pgmprel_currow.wait_perd_val;
1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;

Line 1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;

1003: l_wait_data_found := true;
1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;

Line 1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;

1004: end if;
1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;

Line 1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;

1005: else
1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else

Line 1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;

1006: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_cd;
1007: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_dt_to_use_rl;
1008: l_wait_perd_rl := ben_cobj_cache.g_pgmetpr_currow.wait_perd_rl;
1009: l_wait_perd_uom := ben_cobj_cache.g_pgmetpr_currow.wait_perd_uom;
1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;

Line 1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;

1010: l_wait_perd_val := ben_cobj_cache.g_pgmetpr_currow.wait_perd_val;
1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;

Line 1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;

1011: l_wait_data_found := true;
1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;

Line 1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;

1012: end if;
1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;

Line 1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;

1013: else
1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else

Line 1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;

1014: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_cd;
1015: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_dt_to_use_rl;
1016: l_wait_perd_rl := ben_cobj_cache.g_ptipetpr_currow.wait_perd_rl;
1017: l_wait_perd_uom := ben_cobj_cache.g_ptipetpr_currow.wait_perd_uom;
1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;

Line 1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;

1018: l_wait_perd_val := ben_cobj_cache.g_ptipetpr_currow.wait_perd_val;
1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;

Line 1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;

1019: l_wait_data_found := true;
1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;

Line 1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;

1020: end if;
1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;

Line 1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;

1021: else
1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;
1029:

Line 1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;

1022: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_cd;
1023: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_dt_to_use_rl;
1024: l_wait_perd_rl := ben_cobj_cache.g_ptipprel_currow.wait_perd_rl;
1025: l_wait_perd_uom := ben_cobj_cache.g_ptipprel_currow.wait_perd_uom;
1026: l_wait_perd_val := ben_cobj_cache.g_ptipprel_currow.wait_perd_val;
1027: l_wait_data_found := true;
1028: end if;
1029:
1030: end if;

Line 1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;

1059: if p_pl_id is not null or p_oipl_id is not null then /*Bug 3047147 chk for p_oipl_id also*/
1060: --
1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;

Line 1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;

1060: --
1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --

Line 1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;

1061: -- Get the plan related data from the cache.
1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.

Line 1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;

1062: --
1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.
1070: --

Line 1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;

1063: l_wait_perd_dt_to_use_cd := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_cd;
1064: l_wait_perd_dt_to_use_rl := ben_cobj_cache.g_pl_currow.mx_wtg_dt_to_use_rl;
1065: l_wait_perd_rl := ben_cobj_cache.g_pl_currow.mx_wtg_perd_rl;
1066: l_wait_perd_uom := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_uom;
1067: l_wait_perd_val := ben_cobj_cache.g_pl_currow.mx_wtg_perd_prte_val;
1068: --
1069: -- Now calculate the maximum waiting period end date if one is defined.
1070: --
1071: if l_wait_perd_dt_to_use_cd is not null then