DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT dependencies on BEN_ENV_OBJECT

Line 751: l_env ben_env_object.g_global_env_rec_type;

747: --
748: l_proc varchar2(80) := g_package||'get_object pgm';
749: l_index pls_integer;
750: --l_not_hash_found boolean;
751: l_env ben_env_object.g_global_env_rec_type;
752: --l_rec ben_pgm_f%rowtype;
753: --
754: begin
755: --

Line 800: ben_env_object.get(p_rec => l_env);

796: exception
797: --
798: when no_data_found then
799: --
800: ben_env_object.get(p_rec => l_env);
801: --
802: set_object(p_pgm_id => p_pgm_id,
803: p_business_group_id => l_env.business_group_id,
804: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 819: l_env ben_env_object.g_global_env_rec_type;

815: --
816: l_proc varchar2(80) := g_package||'get_object pln';
817: l_index pls_integer;
818: --l_not_hash_found boolean;
819: l_env ben_env_object.g_global_env_rec_type;
820: --l_rec ben_pl_f%rowtype;
821: --
822: begin
823: --

Line 868: ben_env_object.get(p_rec => l_env);

864: exception
865: --
866: when no_data_found then
867: --
868: ben_env_object.get(p_rec => l_env);
869: --
870: set_object(p_pl_id => p_pl_id ,
871: p_business_group_id => l_env.business_group_id,
872: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 889: l_env ben_env_object.g_global_env_rec_type;

885: --
886: l_proc varchar2(80) := g_package||'get_object oipl';
887: l_index pls_integer;
888: --l_not_hash_found boolean;
889: l_env ben_env_object.g_global_env_rec_type;
890: --l_rec ben_oipl_f%rowtype;
891: --
892: begin
893: --

Line 938: ben_env_object.get(p_rec => l_env);

934: exception
935: --
936: when no_data_found then
937: --
938: ben_env_object.get(p_rec => l_env);
939: --
940: set_object(p_oipl_id => p_oipl_id,
941: p_business_group_id => l_env.business_group_id,
942: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 957: l_env ben_env_object.g_global_env_rec_type;

953: --
954: l_proc varchar2(80) := g_package||'get_object plip';
955: l_index pls_integer;
956: --l_not_hash_found boolean;
957: l_env ben_env_object.g_global_env_rec_type;
958: --l_rec ben_plip_f%rowtype;
959: --
960: begin
961: --

Line 1006: ben_env_object.get(p_rec => l_env);

1002: exception
1003: --
1004: when no_data_found then
1005: --
1006: ben_env_object.get(p_rec => l_env);
1007: --
1008: set_object(p_plip_id => p_plip_id,
1009: p_business_group_id => l_env.business_group_id,
1010: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 1025: l_env ben_env_object.g_global_env_rec_type;

1021: --
1022: l_proc varchar2(80) := g_package||'get_object ptip';
1023: l_index pls_integer;
1024: --l_not_hash_found boolean;
1025: l_env ben_env_object.g_global_env_rec_type;
1026: --l_rec ben_ptip_f%rowtype;
1027: --
1028: begin
1029: --

Line 1074: ben_env_object.get(p_rec => l_env);

1070: exception
1071: --
1072: when no_data_found then
1073: --
1074: ben_env_object.get(p_rec => l_env);
1075: --
1076: set_object(p_ptip_id => p_ptip_id,
1077: p_business_group_id => l_env.business_group_id,
1078: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 1093: l_env ben_env_object.g_global_env_rec_type;

1089: --
1090: l_proc varchar2(80) := g_package||'get_object opt';
1091: l_index pls_integer;
1092: --l_not_hash_found boolean;
1093: l_env ben_env_object.g_global_env_rec_type;
1094: --l_rec ben_opt_f%rowtype;
1095: --
1096: begin
1097: --

Line 1142: ben_env_object.get(p_rec => l_env);

1138: exception
1139: --
1140: when no_data_found then
1141: --
1142: ben_env_object.get(p_rec => l_env);
1143: --
1144: set_object(p_opt_id => p_opt_id,
1145: p_business_group_id => l_env.business_group_id,
1146: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 1162: l_env ben_env_object.g_global_env_rec_type;

1158: --
1159: l_proc varchar2(80) := g_package||'get_object oiplip';
1160: l_index pls_integer;
1161: --l_not_hash_found boolean;
1162: l_env ben_env_object.g_global_env_rec_type;
1163: --l_rec ben_oiplip_f%rowtype;
1164: --
1165: begin
1166: --

Line 1211: ben_env_object.get(p_rec => l_env);

1207: exception
1208: --
1209: when no_data_found then
1210: --
1211: ben_env_object.get(p_rec => l_env);
1212: --
1213: set_object(p_oiplip_id => p_oiplip_id,
1214: p_business_group_id => l_env.business_group_id,
1215: p_effective_date => nvl(l_env.lf_evt_ocrd_dt,

Line 1236: l_env ben_env_object.g_global_env_rec_type;

1232: --l_not_hash_found boolean;
1233: l_results_table g_cache_pl_rec_table;
1234: l_rec ben_cache.g_cache_lookup;
1235: l_num_recs number;
1236: l_env ben_env_object.g_global_env_rec_type;
1237: l_business_group_id number;
1238: l_lf_evt_ocrd_dt date;
1239: --
1240: cursor c1 is -- changed the sql for performance bug 3662774

Line 1345: ben_env_object.get(p_rec => l_env);

1341: -- hr_utility.set_location('Entering '||l_proc,10);
1342: --
1343: -- Grab environment information
1344: --
1345: ben_env_object.get(p_rec => l_env);
1346: --
1347: -- This is a special case as we are attempting to get all the plans in
1348: -- program for a COBRA program . We need to only hash the PGM_ID as the
1349: -- plans will be stored in an consecutive indexed table.