DBA Data[Home] [Help]

APPS.PAY_PPMV4_UTILS_SS dependencies on HR_API

Line 887: -- The HR_API defaults are used to indicate no change.

883: ,p_change in out nocopy boolean
884: ) is
885: begin
886: --
887: -- The HR_API defaults are used to indicate no change.
888: --
889: if nvl(p_value1, hr_api.g_number) <> nvl(p_value2, hr_api.g_number) then
890: p_change := true;
891: end if;

Line 889: if nvl(p_value1, hr_api.g_number) <> nvl(p_value2, hr_api.g_number) then

885: begin
886: --
887: -- The HR_API defaults are used to indicate no change.
888: --
889: if nvl(p_value1, hr_api.g_number) <> nvl(p_value2, hr_api.g_number) then
890: p_change := true;
891: end if;
892: end ch;
893: --

Line 901: -- The HR_API defaults are used to indicate no change.

897: ,p_change in out nocopy boolean
898: ) is
899: begin
900: --
901: -- The HR_API defaults are used to indicate no change.
902: --
903: if nvl(p_value1, hr_api.g_varchar2) <> nvl(p_value2, hr_api.g_varchar2) then
904: p_change := true;
905: end if;

Line 903: if nvl(p_value1, hr_api.g_varchar2) <> nvl(p_value2, hr_api.g_varchar2) then

899: begin
900: --
901: -- The HR_API defaults are used to indicate no change.
902: --
903: if nvl(p_value1, hr_api.g_varchar2) <> nvl(p_value2, hr_api.g_varchar2) then
904: p_change := true;
905: end if;
906: end ch;
907: --

Line 1116: (p_logical_priority => hr_api.g_number

1112: --
1113: -- Call private routine.
1114: --
1115: changed
1116: (p_logical_priority => hr_api.g_number
1117: ,p_amount_type => p_new_ppm.amount_type
1118: ,p_amount => p_new_ppm.amount
1119: ,p_external_account_id => p_new_ppm.external_account_id
1120: ,p_attribute_category => p_new_ppm.attribute_category

Line 1141: ,p_o_logical_priority => hr_api.g_number

1137: ,p_attribute17 => p_new_ppm.attribute17
1138: ,p_attribute18 => p_new_ppm.attribute18
1139: ,p_attribute19 => p_new_ppm.attribute19
1140: ,p_attribute20 => p_new_ppm.attribute20
1141: ,p_o_logical_priority => hr_api.g_number
1142: ,p_o_amount_type => p_saved_ppm.o_amount_type
1143: ,p_o_amount => p_saved_ppm.o_amount
1144: ,p_o_external_account_id => p_saved_ppm.o_external_account_id
1145: ,p_o_attribute_category => p_saved_ppm.o_attribute_category

Line 1234: (p_logical_priority => hr_api.g_number

1230: );
1231: p_original := l_changes;
1232: --
1233: changed
1234: (p_logical_priority => hr_api.g_number
1235: ,p_amount_type => p_new_ppm.amount_type
1236: ,p_amount => p_new_ppm.amount
1237: ,p_external_account_id => p_new_ppm.external_account_id
1238: ,p_attribute_category => p_new_ppm.attribute_category

Line 1259: ,p_o_logical_priority => hr_api.g_number

1255: ,p_attribute17 => p_new_ppm.attribute17
1256: ,p_attribute18 => p_new_ppm.attribute18
1257: ,p_attribute19 => p_new_ppm.attribute19
1258: ,p_attribute20 => p_new_ppm.attribute20
1259: ,p_o_logical_priority => hr_api.g_number
1260: ,p_o_amount_type => p_saved_ppm.amount_type
1261: ,p_o_amount => p_saved_ppm.amount
1262: ,p_o_external_account_id => p_saved_ppm.external_account_id
1263: ,p_o_attribute_category => p_saved_ppm.attribute_category

Line 1480: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)

1476: select ppm.priority priority
1477: from pay_personal_payment_methods_f ppm
1478: , pay_org_payment_methods_f opm
1479: where ppm.assignment_id = p_assignment_id
1480: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1481: and p_effective_date between
1482: ppm.effective_start_date and ppm.effective_end_date
1483: and opm.org_payment_method_id = ppm.org_payment_method_id
1484: and opm.defined_balance_id is not null

Line 1703: l_datetrack_mode := hr_api.g_insert;

1699: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
1700: seterrorstage(l_proc, 'C_STATE_NEW', 10);
1701: l_default_number := null;
1702: l_default_varchar2 := null;
1703: l_datetrack_mode := hr_api.g_insert;
1704: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1705: seterrorstage(l_proc, 'C_STATE_UPDATED', 20);
1706: l_default_number := hr_api.g_number;
1707: l_default_varchar2 := hr_api.g_varchar2;

Line 1706: l_default_number := hr_api.g_number;

1702: l_default_varchar2 := null;
1703: l_datetrack_mode := hr_api.g_insert;
1704: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1705: seterrorstage(l_proc, 'C_STATE_UPDATED', 20);
1706: l_default_number := hr_api.g_number;
1707: l_default_varchar2 := hr_api.g_varchar2;
1708: l_datetrack_mode := p_update_datetrack_mode;
1709: else
1710: --

Line 1707: l_default_varchar2 := hr_api.g_varchar2;

1703: l_datetrack_mode := hr_api.g_insert;
1704: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1705: seterrorstage(l_proc, 'C_STATE_UPDATED', 20);
1706: l_default_number := hr_api.g_number;
1707: l_default_varchar2 := hr_api.g_varchar2;
1708: l_datetrack_mode := p_update_datetrack_mode;
1709: else
1710: --
1711: -- Should not reach here.

Line 1779: hr_api.validate_bus_grp_id

1775: );
1776: fetch csr_asg_busgrp
1777: into l_business_group_id;
1778: close csr_asg_busgrp;
1779: hr_api.validate_bus_grp_id
1780: (p_business_group_id => l_business_group_id
1781: );
1782: exception
1783: when others then

Line 1803: hr_api.validate_bus_grp_id

1799: );
1800: fetch csr_ppm_busgrp
1801: into l_business_group_id;
1802: close csr_ppm_busgrp;
1803: hr_api.validate_bus_grp_id
1804: (p_business_group_id => l_business_group_id
1805: );
1806: exception
1807: when others then

Line 1832: ,p_priority => hr_api.g_number

1828: ,p_amount => l_amount
1829: ,p_comment_id => l_default_number
1830: ,p_comments => l_default_varchar2
1831: ,p_percentage => l_percentage
1832: ,p_priority => hr_api.g_number
1833: ,p_attribute_category => p_attribute_category
1834: ,p_attribute1 => p_attribute1
1835: ,p_attribute2 => p_attribute2
1836: ,p_attribute3 => p_attribute3

Line 2440: -- then setting the values to hr_api.g_number so that original values are retained

2436: l_amount := p_amount;
2437:
2438: --
2439: -- If its the C_REMAINING_PAY (i.e. lowest priority) pay method,
2440: -- then setting the values to hr_api.g_number so that original values are retained
2441: -- when date track apis enters a new record.
2442: else
2443: /* Bug 12624040 Making the chnages made in 7230549 functionality switchable */
2444: begin

Line 2458: l_percentage := hr_api.g_number;

2454: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
2455: l_percentage := 100;
2456: l_amount := null;
2457: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
2458: l_percentage := hr_api.g_number;
2459: l_amount := hr_api.g_number;
2460: end if;
2461: else
2462: l_percentage := 100;

Line 2459: l_amount := hr_api.g_number;

2455: l_percentage := 100;
2456: l_amount := null;
2457: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
2458: l_percentage := hr_api.g_number;
2459: l_amount := hr_api.g_number;
2460: end if;
2461: else
2462: l_percentage := 100;
2463: l_amount := null;

Line 2676: if p_delete_datetrack_mode = hr_api.g_zap then

2672: ,p_comment_id => l_comment_id
2673: );
2674: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_DELETED then
2675: l_object_version_number := p_delete_ovn;
2676: if p_delete_datetrack_mode = hr_api.g_zap then
2677: l_effective_date := p_effective_date;
2678: else
2679: l_effective_date := p_effective_date - 1;
2680: end if;