eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_PLE_BUS dependencies on HR_API

Line 246: hr_api.mandatory_arg_error(g_package,'p_startdate',p_startdate);

242: return boolean is
243: -------------------
244: procedure chkp is
245: begin
246: hr_api.mandatory_arg_error(g_package,'p_startdate',p_startdate);
247: end chkp;
248: -------------------
249: begin
250: hr_utility.set_location('Entering: dates_are_in_order', 5);

Line 376: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);

372: l_parent_exists boolean;
373: --
374: procedure chkp is
375: begin
376: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);
377: hr_api.mandatory_arg_error(g_package,'start_succeeds_tpl_start:p_tpl_id',p_tpl_id);
378: end chkp;
379: ------------------
380: begin

Line 377: hr_api.mandatory_arg_error(g_package,'start_succeeds_tpl_start:p_tpl_id',p_tpl_id);

373: --
374: procedure chkp is
375: begin
376: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);
377: hr_api.mandatory_arg_error(g_package,'start_succeeds_tpl_start:p_tpl_id',p_tpl_id);
378: end chkp;
379: ------------------
380: begin
381: hr_utility.set_location('Entering: start_succeeds_tpl_start', 5);

Line 426: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);

422: l_parent_exists boolean;
423: --
424: procedure chkp is
425: begin
426: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);
427: hr_api.mandatory_arg_error(g_package,'start_succeeds_tav_start:p_tav_id',p_tav_id);
428: end chkp;
429: ------------------
430: begin

Line 427: hr_api.mandatory_arg_error(g_package,'start_succeeds_tav_start:p_tav_id',p_tav_id);

423: --
424: procedure chkp is
425: begin
426: hr_api.mandatory_arg_error(g_package,'p_ple_startdate',p_ple_startdate);
427: hr_api.mandatory_arg_error(g_package,'start_succeeds_tav_start:p_tav_id',p_tav_id);
428: end chkp;
429: ------------------
430: begin
431: hr_utility.set_location('Entering: start_succeeds_tav_start', 5);

Line 480: hr_api.mandatory_arg_error(g_package,'end_precedes_tpl_end:p_tpl_id',p_tpl_id);

476: l_parent_exists boolean;
477: --
478: procedure chkp is
479: begin
480: hr_api.mandatory_arg_error(g_package,'end_precedes_tpl_end:p_tpl_id',p_tpl_id);
481: end chkp;
482: ------------------
483: begin
484: hr_utility.set_location('Entering: end_precedes_tpl_end', 5);

Line 534: hr_api.mandatory_arg_error(g_package,'end_precedes_tav_end:p_tav_id',p_tav_id);

530: l_parent_exists boolean;
531: --
532: procedure chkp is
533: begin
534: hr_api.mandatory_arg_error(g_package,'end_precedes_tav_end:p_tav_id',p_tav_id);
535: end chkp;
536: --------------
537: begin
538: --

Line 668: hr_api.mandatory_arg_error(g_package,'check_ple_overlapping:p_tpl_id',p_tpl_id);

664: l_dummy integer;
665: --
666: procedure chkp is
667: begin
668: hr_api.mandatory_arg_error(g_package,'check_ple_overlapping:p_tpl_id',p_tpl_id);
669: check_tav_and_vsp(p_tav_id,p_vsp_id);
670: check_pricebasis_attendees(p_price_basis,p_minattendees,p_maxattendees);
671: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
672: end chkp;

Line 671: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);

667: begin
668: hr_api.mandatory_arg_error(g_package,'check_ple_overlapping:p_tpl_id',p_tpl_id);
669: check_tav_and_vsp(p_tav_id,p_vsp_id);
670: check_pricebasis_attendees(p_price_basis,p_minattendees,p_maxattendees);
671: hr_api.mandatory_arg_error(g_package,'p_start_date',p_start_date);
672: end chkp;
673: -------------------------
674: begin
675: --

Line 786: hr_api.mandatory_arg_error(g_package,'old_price_list_price',p_old_price);

782: l_new_price OTA_PRICE_LIST_ENTRIES.price%TYPE;
783: --
784: procedure chkp is
785: begin
786: hr_api.mandatory_arg_error(g_package,'old_price_list_price',p_old_price);
787: if p_price_increase is null then
788: constraint_error2('increase_is_a_percent');
789: elsif p_price_increase < -100 or p_price_increase > 100 then
790: constraint_error2('increase_is_a_percent');

Line 892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)

888: ple.ple_information20
889: from ota_price_list_entries ple
890: where ple.price_list_id = p_old_tpl_id
891: and ((p_proc_use = 2
892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)
894: or nvl(ple.end_date,hr_api.g_eot)
895: < nvl(p_increase_date,hr_api.g_sot)
896: )

Line 893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)

889: from ota_price_list_entries ple
890: where ple.price_list_id = p_old_tpl_id
891: and ((p_proc_use = 2
892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)
894: or nvl(ple.end_date,hr_api.g_eot)
895: < nvl(p_increase_date,hr_api.g_sot)
896: )
897: )

Line 894: or nvl(ple.end_date,hr_api.g_eot)

890: where ple.price_list_id = p_old_tpl_id
891: and ((p_proc_use = 2
892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)
894: or nvl(ple.end_date,hr_api.g_eot)
895: < nvl(p_increase_date,hr_api.g_sot)
896: )
897: )
898: or p_proc_use <>2);

Line 895: < nvl(p_increase_date,hr_api.g_sot)

891: and ((p_proc_use = 2
892: and ple.start_date >= nvl(p_starting_from,hr_api.g_sot)
893: and not (ple.start_date > nvl(p_enddate,hr_api.g_eot)
894: or nvl(ple.end_date,hr_api.g_eot)
895: < nvl(p_increase_date,hr_api.g_sot)
896: )
897: )
898: or p_proc_use <>2);
899: --

Line 912: hr_api.mandatory_arg_error(g_package,'new_price_list_id',p_new_tpl_id);

908: procedure chkp is
909: begin
910: if p_proc_use = 1 then
911: -- Copy price list and entries with price increase function.
912: hr_api.mandatory_arg_error(g_package,'new_price_list_id',p_new_tpl_id);
913: if not (p_increase_date is null and p_starting_from is null) then
914: constraint_error2('arguments_should_be_null_1');
915: end if;
916: elsif p_proc_use = 2 then

Line 918: hr_api.mandatory_arg_error(g_package,'old_price_list_id',p_old_tpl_id);

914: constraint_error2('arguments_should_be_null_1');
915: end if;
916: elsif p_proc_use = 2 then
917: -- Copy entries with price increase function.
918: hr_api.mandatory_arg_error(g_package,'old_price_list_id',p_old_tpl_id);
919: if p_increase_date is null then
920: constraint_error2('startdate_must_be_populated');
921: end if;
922: if not(p_new_tpl_id is null and p_dates_difference is null) then

Line 927: hr_api.mandatory_arg_error(g_package,'old_price_list_id',p_old_tpl_id);

923: constraint_error2('arguments_should_be_null_2');
924: end if;
925: -- Close down price list function.
926: elsif p_proc_use = 3 then
927: hr_api.mandatory_arg_error(g_package,'old_price_list_id',p_old_tpl_id);
928: if not(p_new_tpl_id is null and p_dates_difference is null and p_increase_date is null
929: and p_starting_from is null and p_price_increase is null
930: and p_rounding_direction is null and p_rounding_factor is null) then
931: constraint_error2('arguments_should_be_null_3');

Line 978: if nvl(p_new_enddate,hr_api.g_eot) < nvl(p_old_enddate,hr_api.g_eot) then

974: l_plerec.start_date := greatest(l_plerec.start_date
975: ,p_new_startdate);
976: end if;
977: --
978: if nvl(p_new_enddate,hr_api.g_eot) < nvl(p_old_enddate,hr_api.g_eot) then
979: hr_utility.trace('New End Date < Old End Date');
980: if l_plerec.end_date is null and p_new_enddate is null then
981: l_plerec.end_date := null;
982: else

Line 983: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)

979: hr_utility.trace('New End Date < Old End Date');
980: if l_plerec.end_date is null and p_new_enddate is null then
981: l_plerec.end_date := null;
982: else
983: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)
984: ,nvl(l_plerec.end_date,hr_api.g_eot));
985: end if;
986: --
987: elsif

Line 984: ,nvl(l_plerec.end_date,hr_api.g_eot));

980: if l_plerec.end_date is null and p_new_enddate is null then
981: l_plerec.end_date := null;
982: else
983: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)
984: ,nvl(l_plerec.end_date,hr_api.g_eot));
985: end if;
986: --
987: elsif
988: nvl(p_new_enddate,hr_api.g_eot) > nvl(p_old_enddate,hr_api.g_eot) then

Line 988: nvl(p_new_enddate,hr_api.g_eot) > nvl(p_old_enddate,hr_api.g_eot) then

984: ,nvl(l_plerec.end_date,hr_api.g_eot));
985: end if;
986: --
987: elsif
988: nvl(p_new_enddate,hr_api.g_eot) > nvl(p_old_enddate,hr_api.g_eot) then
989: hr_utility.trace('New End Date > Old End Date');
990: if nvl(p_old_enddate,hr_api.g_eot) =
991: nvl(l_plerec.end_date,hr_api.g_eot) then
992: if p_new_enddate is null and l_activity_end_date is null then

Line 990: if nvl(p_old_enddate,hr_api.g_eot) =

986: --
987: elsif
988: nvl(p_new_enddate,hr_api.g_eot) > nvl(p_old_enddate,hr_api.g_eot) then
989: hr_utility.trace('New End Date > Old End Date');
990: if nvl(p_old_enddate,hr_api.g_eot) =
991: nvl(l_plerec.end_date,hr_api.g_eot) then
992: if p_new_enddate is null and l_activity_end_date is null then
993: l_plerec.end_date := null;
994: else

Line 991: nvl(l_plerec.end_date,hr_api.g_eot) then

987: elsif
988: nvl(p_new_enddate,hr_api.g_eot) > nvl(p_old_enddate,hr_api.g_eot) then
989: hr_utility.trace('New End Date > Old End Date');
990: if nvl(p_old_enddate,hr_api.g_eot) =
991: nvl(l_plerec.end_date,hr_api.g_eot) then
992: if p_new_enddate is null and l_activity_end_date is null then
993: l_plerec.end_date := null;
994: else
995: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)

Line 995: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)

991: nvl(l_plerec.end_date,hr_api.g_eot) then
992: if p_new_enddate is null and l_activity_end_date is null then
993: l_plerec.end_date := null;
994: else
995: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)
996: ,nvl(l_activity_end_date,hr_api.g_eot));
997: end if;
998: end if;
999: --

Line 996: ,nvl(l_activity_end_date,hr_api.g_eot));

992: if p_new_enddate is null and l_activity_end_date is null then
993: l_plerec.end_date := null;
994: else
995: l_plerec.end_date := least(nvl(p_new_enddate,hr_api.g_eot)
996: ,nvl(l_activity_end_date,hr_api.g_eot));
997: end if;
998: end if;
999: --
1000: end if;

Line 1003: hr_utility.trace(' End Date '||to_char(nvl(l_plerec.end_date,hr_api.g_eot)));

999: --
1000: end if;
1001: --
1002: hr_utility.trace('Start Date '||to_char(l_plerec.start_date));
1003: hr_utility.trace(' End Date '||to_char(nvl(l_plerec.end_date,hr_api.g_eot)));
1004: if l_plerec.start_date > nvl(l_plerec.end_date,hr_api.g_eot) then
1005: null;
1006: else
1007: hr_utility.trace('Inserting Entry');

Line 1004: if l_plerec.start_date > nvl(l_plerec.end_date,hr_api.g_eot) then

1000: end if;
1001: --
1002: hr_utility.trace('Start Date '||to_char(l_plerec.start_date));
1003: hr_utility.trace(' End Date '||to_char(nvl(l_plerec.end_date,hr_api.g_eot)));
1004: if l_plerec.start_date > nvl(l_plerec.end_date,hr_api.g_eot) then
1005: null;
1006: else
1007: hr_utility.trace('Inserting Entry');
1008: l_plerec.price_list_entry_id := null;

Line 1027: if nvl(p_enddate,hr_api.g_eot)

1023: hr_utility.trace('PLE Start Date '||to_char(l_plerec.start_date));
1024: hr_utility.trace('PLE End Date '||to_char(l_plerec.end_date));
1025: --
1026: if p_increase_date <= l_plerec.start_date then
1027: if nvl(p_enddate,hr_api.g_eot)
1028: >= nvl(l_plerec.end_date,hr_api.g_eot) then
1029: --
1030: hr_utility.trace('Updating the whole entry');
1031: l_plerec2 := l_plerec;

Line 1028: >= nvl(l_plerec.end_date,hr_api.g_eot) then

1024: hr_utility.trace('PLE End Date '||to_char(l_plerec.end_date));
1025: --
1026: if p_increase_date <= l_plerec.start_date then
1027: if nvl(p_enddate,hr_api.g_eot)
1028: >= nvl(l_plerec.end_date,hr_api.g_eot) then
1029: --
1030: hr_utility.trace('Updating the whole entry');
1031: l_plerec2 := l_plerec;
1032: l_plerec2.price := return_new_price(l_plerec2.price

Line 1038: else -- nvl(p_enddate,hr_api.g_eot)

1034: ,p_rounding_direction
1035: ,p_rounding_factor);
1036: ota_ple_upd.upd(l_plerec2,FALSE);
1037: --
1038: else -- nvl(p_enddate,hr_api.g_eot)
1039: -- < nvl(l_plerec.end_date,hr_api.g_eot)
1040: --
1041: hr_utility.trace('Updating the entry up until the New End Date');
1042: l_plerec2 := l_plerec;

Line 1039: -- < nvl(l_plerec.end_date,hr_api.g_eot)

1035: ,p_rounding_factor);
1036: ota_ple_upd.upd(l_plerec2,FALSE);
1037: --
1038: else -- nvl(p_enddate,hr_api.g_eot)
1039: -- < nvl(l_plerec.end_date,hr_api.g_eot)
1040: --
1041: hr_utility.trace('Updating the entry up until the New End Date');
1042: l_plerec2 := l_plerec;
1043: l_plerec2.end_date := p_enddate;

Line 1061: if nvl(p_enddate,hr_api.g_eot)

1057: end if;
1058: --
1059: else -- p_increase_date > l_plerec.start_date
1060: --
1061: if nvl(p_enddate,hr_api.g_eot)
1062: >= nvl(l_plerec.end_date,hr_api.g_eot) then
1063: --
1064: hr_utility.trace('Setting New End Date on old entry');
1065: l_plerec2 := l_plerec;

Line 1062: >= nvl(l_plerec.end_date,hr_api.g_eot) then

1058: --
1059: else -- p_increase_date > l_plerec.start_date
1060: --
1061: if nvl(p_enddate,hr_api.g_eot)
1062: >= nvl(l_plerec.end_date,hr_api.g_eot) then
1063: --
1064: hr_utility.trace('Setting New End Date on old entry');
1065: l_plerec2 := l_plerec;
1066: l_plerec2.end_date := p_increase_date - 1;

Line 1080: else -- nvl(p_enddate,hr_api.g_eot)

1076: ,p_rounding_direction
1077: ,p_rounding_factor);
1078: ota_ple_ins.ins(l_plerec2,FALSE);
1079: --
1080: else -- nvl(p_enddate,hr_api.g_eot)
1081: -- < nvl(l_plerec.end_date,hr_api.g_eot)
1082: --
1083: hr_utility.trace('Setting New End Date on old entry');
1084: l_plerec2 := l_plerec;

Line 1081: -- < nvl(l_plerec.end_date,hr_api.g_eot)

1077: ,p_rounding_factor);
1078: ota_ple_ins.ins(l_plerec2,FALSE);
1079: --
1080: else -- nvl(p_enddate,hr_api.g_eot)
1081: -- < nvl(l_plerec.end_date,hr_api.g_eot)
1082: --
1083: hr_utility.trace('Setting New End Date on old entry');
1084: l_plerec2 := l_plerec;
1085: l_plerec2.end_date := p_increase_date - 1;

Line 1123: if l_plerec.start_date >= nvl(p_new_enddate,hr_api.g_eot) or

1119: close get_activity;
1120: --
1121: -- if the entry is outside of the new dates delete the entry
1122: --
1123: if l_plerec.start_date >= nvl(p_new_enddate,hr_api.g_eot) or
1124: nvl(l_plerec.end_date,hr_api.g_eot) <= p_new_startdate then
1125: OTA_PLE_DEL.del(l_plerec,FALSE);
1126: else
1127: --

Line 1124: nvl(l_plerec.end_date,hr_api.g_eot) <= p_new_startdate then

1120: --
1121: -- if the entry is outside of the new dates delete the entry
1122: --
1123: if l_plerec.start_date >= nvl(p_new_enddate,hr_api.g_eot) or
1124: nvl(l_plerec.end_date,hr_api.g_eot) <= p_new_startdate then
1125: OTA_PLE_DEL.del(l_plerec,FALSE);
1126: else
1127: --
1128: -- if the start date is before the entry then open up the entry

Line 1149: if nvl(l_plerec.end_date,hr_api.g_eot) =

1145: --
1146: --
1147: -- if the end date is after the entry start then open up the entry
1148: --
1149: if nvl(l_plerec.end_date,hr_api.g_eot) =
1150: nvl(p_old_enddate,hr_api.g_eot)
1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --

Line 1150: nvl(p_old_enddate,hr_api.g_eot)

1146: --
1147: -- if the end date is after the entry start then open up the entry
1148: --
1149: if nvl(l_plerec.end_date,hr_api.g_eot) =
1150: nvl(p_old_enddate,hr_api.g_eot)
1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --
1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)

Line 1151: and nvl(l_plerec.end_date,hr_api.g_eot) <

1147: -- if the end date is after the entry start then open up the entry
1148: --
1149: if nvl(l_plerec.end_date,hr_api.g_eot) =
1150: nvl(p_old_enddate,hr_api.g_eot)
1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --
1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)
1155: ,nvl(p_new_enddate,hr_api.g_eot));

Line 1152: nvl(p_new_enddate,hr_api.g_eot) then

1148: --
1149: if nvl(l_plerec.end_date,hr_api.g_eot) =
1150: nvl(p_old_enddate,hr_api.g_eot)
1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --
1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)
1155: ,nvl(p_new_enddate,hr_api.g_eot));
1156: --

Line 1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)

1150: nvl(p_old_enddate,hr_api.g_eot)
1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --
1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)
1155: ,nvl(p_new_enddate,hr_api.g_eot));
1156: --
1157: --
1158: -- if the start date is after the entry start then close down the entry

Line 1155: ,nvl(p_new_enddate,hr_api.g_eot));

1151: and nvl(l_plerec.end_date,hr_api.g_eot) <
1152: nvl(p_new_enddate,hr_api.g_eot) then
1153: --
1154: l_end_date := least(nvl(l_activity_end_date,hr_api.g_eot)
1155: ,nvl(p_new_enddate,hr_api.g_eot));
1156: --
1157: --
1158: -- if the start date is after the entry start then close down the entry
1159: --

Line 1160: elsif nvl(l_plerec.end_date,hr_api.g_eot) >

1156: --
1157: --
1158: -- if the start date is after the entry start then close down the entry
1159: --
1160: elsif nvl(l_plerec.end_date,hr_api.g_eot) >
1161: nvl(p_new_enddate,hr_api.g_eot) then
1162: --
1163: l_end_date := p_new_enddate;
1164: else

Line 1161: nvl(p_new_enddate,hr_api.g_eot) then

1157: --
1158: -- if the start date is after the entry start then close down the entry
1159: --
1160: elsif nvl(l_plerec.end_date,hr_api.g_eot) >
1161: nvl(p_new_enddate,hr_api.g_eot) then
1162: --
1163: l_end_date := p_new_enddate;
1164: else
1165: l_end_date := nvl(l_plerec.end_date,hr_api.g_eot);

Line 1165: l_end_date := nvl(l_plerec.end_date,hr_api.g_eot);

1161: nvl(p_new_enddate,hr_api.g_eot) then
1162: --
1163: l_end_date := p_new_enddate;
1164: else
1165: l_end_date := nvl(l_plerec.end_date,hr_api.g_eot);
1166: end if;
1167: --
1168: if l_end_date = hr_api.g_eot then
1169: l_plerec.end_date := null;

Line 1168: if l_end_date = hr_api.g_eot then

1164: else
1165: l_end_date := nvl(l_plerec.end_date,hr_api.g_eot);
1166: end if;
1167: --
1168: if l_end_date = hr_api.g_eot then
1169: l_plerec.end_date := null;
1170: end if;
1171: --
1172: --

Line 1176: or nvl(l_plerec.end_date,hr_api.g_eot) <> l_end_date then

1172: --
1173: -- Only do the update if the Entry Start or End Dates have changed
1174: --
1175: if l_plerec.start_date <> l_start_date
1176: or nvl(l_plerec.end_date,hr_api.g_eot) <> l_end_date then
1177: if l_end_date = hr_api.g_eot then
1178: l_plerec.end_date := null;
1179: else
1180: l_plerec.end_date := l_end_date;

Line 1177: if l_end_date = hr_api.g_eot then

1173: -- Only do the update if the Entry Start or End Dates have changed
1174: --
1175: if l_plerec.start_date <> l_start_date
1176: or nvl(l_plerec.end_date,hr_api.g_eot) <> l_end_date then
1177: if l_end_date = hr_api.g_eot then
1178: l_plerec.end_date := null;
1179: else
1180: l_plerec.end_date := l_end_date;
1181: end if;