159: l_otp_object_version_number ben_optip_f.object_version_number%type;
160:
161: begin
162: --
163: hr_utility.set_location('Entering:'|| l_proc, 10);
164: --
165: -- Issue a savepoint if operating in validation only mode
166: --
167: savepoint create_Plan_Type_In_Program;
165: -- Issue a savepoint if operating in validation only mode
166: --
167: savepoint create_Plan_Type_In_Program;
168: --
169: hr_utility.set_location(l_proc, 20);
170: --
171: -- Process Logic
172: --
173: begin
519: --
520: end;
521: --
522: -- bug 1285336
523: hr_utility.set_location(l_proc, 60);
524: --
525: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
526: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
527:
521: --
522: -- bug 1285336
523: hr_utility.set_location(l_proc, 60);
524: --
525: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
526: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
527:
528: FOR l_otp IN c_otp( l_ptip_id ) LOOP
529: --
522: -- bug 1285336
523: hr_utility.set_location(l_proc, 60);
524: --
525: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
526: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
527:
528: FOR l_otp IN c_otp( l_ptip_id ) LOOP
529: --
530: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
526: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
527:
528: FOR l_otp IN c_otp( l_ptip_id ) LOOP
529: --
530: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
531: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
532: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
533: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
534: --
527:
528: FOR l_otp IN c_otp( l_ptip_id ) LOOP
529: --
530: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
531: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
532: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
533: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
534: --
535: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
528: FOR l_otp IN c_otp( l_ptip_id ) LOOP
529: --
530: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
531: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
532: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
533: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
534: --
535: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
536: (p_validate => false
529: --
530: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
531: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
532: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
533: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
534: --
535: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
536: (p_validate => false
537: ,p_optip_id =>l_optip_id
545: -- ,p_cmbn_ptip_opt_id =>p_cmbn_ptip_opt_id
546: ,p_object_version_number =>l_otp_object_version_number
547: ,p_effective_date =>p_effective_date
548: );
549: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 66);
550: END LOOP ;
551:
552:
553: -- When in validation only mode raise the Validate_Enabled exception
562: p_effective_start_date := l_effective_start_date;
563: p_effective_end_date := l_effective_end_date;
564: p_object_version_number := l_object_version_number;
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 70);
567: --
568: exception
569: --
570: when hr_api.validate_enabled then
581: p_ptip_id := null;
582: p_effective_start_date := null;
583: p_effective_end_date := null;
584: p_object_version_number := null;
585: hr_utility.set_location(' Leaving:'||l_proc, 80);
586: --
587: when others then
588: --
589: -- A validation or unexpected error has occured
717: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
718: --
719: begin
720: --
721: hr_utility.set_location('Entering:'|| l_proc, 10);
722: --
723: -- Issue a savepoint if operating in validation only mode
724: --
725: savepoint update_Plan_Type_In_Program;
723: -- Issue a savepoint if operating in validation only mode
724: --
725: savepoint update_Plan_Type_In_Program;
726: --
727: hr_utility.set_location(l_proc, 20);
728: --
729: -- Process Logic
730: --
731: l_object_version_number := p_object_version_number;
1082: -- End of API User Hook for the after hook of update_Plan_Type_In_Program
1083: --
1084: end;
1085: --
1086: hr_utility.set_location(l_proc, 60);
1087: --
1088: -- When in validation only mode raise the Validate_Enabled exception
1089: --
1090: if p_validate then
1096: p_object_version_number := l_object_version_number;
1097: p_effective_start_date := l_effective_start_date;
1098: p_effective_end_date := l_effective_end_date;
1099: --
1100: hr_utility.set_location(' Leaving:'||l_proc, 70);
1101: --
1102: exception
1103: --
1104: when hr_api.validate_enabled then
1113: -- when validation only mode is being used.)
1114: --
1115: p_effective_start_date := null;
1116: p_effective_end_date := null;
1117: hr_utility.set_location(' Leaving:'||l_proc, 80);
1118: --
1119: when others then
1120: --
1121: -- A validation or unexpected error has occured
1148: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1149: --
1150: begin
1151: --
1152: hr_utility.set_location('Entering:'|| l_proc, 10);
1153: --
1154: -- Issue a savepoint if operating in validation only mode
1155: --
1156: savepoint delete_Plan_Type_In_Program;
1154: -- Issue a savepoint if operating in validation only mode
1155: --
1156: savepoint delete_Plan_Type_In_Program;
1157: --
1158: hr_utility.set_location(l_proc, 20);
1159: --
1160: -- Process Logic
1161: --
1162: l_object_version_number := p_object_version_number;
1217: -- End of API User Hook for the after hook of delete_Plan_Type_In_Program
1218: --
1219: end;
1220: --
1221: hr_utility.set_location(l_proc, 60);
1222: --
1223: -- When in validation only mode raise the Validate_Enabled exception
1224: --
1225: if p_validate then
1225: if p_validate then
1226: raise hr_api.validate_enabled;
1227: end if;
1228: --
1229: hr_utility.set_location(' Leaving:'||l_proc, 70);
1230: --
1231: exception
1232: --
1233: when hr_api.validate_enabled then
1277: l_validation_end_date date;
1278: --
1279: begin
1280: --
1281: hr_utility.set_location('Entering:'|| l_proc, 10);
1282: --
1283: ben_ctp_shd.lck
1284: (
1285: p_ptip_id => p_ptip_id
1289: ,p_effective_date => p_effective_date
1290: ,p_datetrack_mode => p_datetrack_mode
1291: );
1292: --
1293: hr_utility.set_location(' Leaving:'||l_proc, 70);
1294: --
1295: end lck;
1296: --
1297: end ben_Plan_Type_In_Program_api;