124: l_dummy number;
125: --
126: procedure chkp is
127: begin
128: hr_api.mandatory_arg_error(g_package,'business_group_id',p_business_group_id);
129: end chkp;
130: -------------------
131: begin
132: --
222: return boolean is
223: -------------------
224: procedure chkp is
225: begin
226: hr_api.mandatory_arg_error(g_package,'p_startdate',p_startdate);
227: end chkp;
228: -------------------
229: begin
230: --
307: l_ple_exists boolean;
308:
309: procedure chkp is
310: begin
311: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
312: end chkp;
313: ------------------------
314: begin
315:
357: l_child_exists boolean;
358:
359: procedure chkp is
360: begin
361: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
362: end chkp;
363: ------------------------
364: begin
365:
420: l_tpl_exists boolean;
421: --
422: procedure chkp is
423: begin
424: hr_api.mandatory_arg_error(g_package,'p_business_group_id',p_business_group_id);
425: hr_api.mandatory_arg_error(g_package,'p_default_flag',p_default_flag);
426: end chkp;
427: --
428: begin
421: --
422: procedure chkp is
423: begin
424: hr_api.mandatory_arg_error(g_package,'p_business_group_id',p_business_group_id);
425: hr_api.mandatory_arg_error(g_package,'p_default_flag',p_default_flag);
426: end chkp;
427: --
428: begin
429: --
465: mindate date;
466:
467: procedure chkp is
468: begin
469: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
470: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
471: end chkp;
472: -----------------
473: begin
466:
467: procedure chkp is
468: begin
469: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
470: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
471: end chkp;
472: -----------------
473: begin
474: --
513: mindate date;
514:
515: procedure chkp is
516: begin
517: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
518: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
519: end chkp;
520: -----------------
521: begin
514:
515: procedure chkp is
516: begin
517: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
518: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
519: end chkp;
520: -----------------
521: begin
522: --
557: maxdate date;
558: --
559: procedure chkp is
560: begin
561: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
562: end chkp;
563: --
564: begin
565: --
611: maxdate date;
612: --
613: procedure chkp is
614: begin
615: hr_api.mandatory_arg_error(g_package,'p_tpl_id',p_tpl_id);
616: end chkp;
617: -------------------
618: begin
619: --
846: --
847: procedure chkp is
848: begin
849: --
850: hr_api.mandatory_arg_error(g_package,'old_price_list_id',p_old_tpl_id);
851: if p_proc_use = 1 then
852: if p_new_tpl_name is null or p_new_startdate is null then
853: constraint_error2('tpl_name_and_date_is_mandatory');
854: end if;
1021: --
1022: -- Call all supporting business operations
1023: insert_validate2(p_rec);
1024: --
1025: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1028: End insert_validate;
1029: --
1039: --
1040: -- Call all supporting business operations
1041: update_validate2(p_rec);
1042: --
1043: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1044: --
1045: hr_utility.set_location(' Leaving:'||l_proc, 10);
1046: End update_validate;
1047: --