1322: ,p_object_version_number out nocopy number
1323: ,p_effective_date in date
1324: ) is
1325:
1326: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;
1327: l_effective_start_date ben_elig_obj_f.effective_start_date%type;
1328: l_effective_end_date ben_elig_obj_f.effective_end_date%type;
1329: l_object_version_number ben_elig_obj_f.object_version_number%type;
1330:
1323: ,p_effective_date in date
1324: ) is
1325:
1326: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;
1327: l_effective_start_date ben_elig_obj_f.effective_start_date%type;
1328: l_effective_end_date ben_elig_obj_f.effective_end_date%type;
1329: l_object_version_number ben_elig_obj_f.object_version_number%type;
1330:
1331: begin
1324: ) is
1325:
1326: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;
1327: l_effective_start_date ben_elig_obj_f.effective_start_date%type;
1328: l_effective_end_date ben_elig_obj_f.effective_end_date%type;
1329: l_object_version_number ben_elig_obj_f.object_version_number%type;
1330:
1331: begin
1332:
1325:
1326: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;
1327: l_effective_start_date ben_elig_obj_f.effective_start_date%type;
1328: l_effective_end_date ben_elig_obj_f.effective_end_date%type;
1329: l_object_version_number ben_elig_obj_f.object_version_number%type;
1330:
1331: begin
1332:
1333: ben_elig_obj_api.create_ELIG_OBJ
1392: ,p_effective_date in date
1393: ,p_datetrack_mode in varchar2
1394: ) is
1395:
1396: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1397: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1398: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1399:
1400: begin
1393: ,p_datetrack_mode in varchar2
1394: ) is
1395:
1396: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1397: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1398: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1399:
1400: begin
1401:
1394: ) is
1395:
1396: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1397: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1398: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1399:
1400: begin
1401:
1402: l_object_version_number := p_object_version_number;
1458: ,p_effective_date in date
1459: ,p_datetrack_mode in varchar2
1460: ) is
1461:
1462: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1463: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1464: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1465:
1466: begin
1459: ,p_datetrack_mode in varchar2
1460: ) is
1461:
1462: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1463: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1464: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1465:
1466: begin
1467:
1460: ) is
1461:
1462: l_object_version_number ben_elig_obj_f.object_version_number%TYPE;
1463: l_effective_start_date ben_elig_obj_f.effective_start_date%TYPE;
1464: l_effective_end_date ben_elig_obj_f.effective_end_date%TYPE;
1465:
1466: begin
1467:
1468: l_object_version_number := p_object_version_number;