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.PQH_BGT_BUS dependencies on HR_API

Line 51: and nvl(p_budget_id,hr_api.g_number)

47: (p_budget_id => p_budget_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_id,hr_api.g_number)
52: <> pqh_bgt_shd.g_old_rec.budget_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 129: and nvl(p_budget_unit3_id,hr_api.g_number)

125: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change
126: -- UOM for FROZEN budgets
127: --
128: if (l_api_updating
129: and nvl(p_budget_unit3_id,hr_api.g_number)
130: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)) then
131:
132: -- UOM is changed
133: --

Line 130: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)) then

126: -- UOM for FROZEN budgets
127: --
128: if (l_api_updating
129: and nvl(p_budget_unit3_id,hr_api.g_number)
130: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)) then
131:
132: -- UOM is changed
133: --
134: if NVL(p_status,'X') = 'FROZEN' then

Line 144: and nvl(p_budget_unit3_id,hr_api.g_number)

140:
141: end if;
142: --
143: if (l_api_updating
144: and nvl(p_budget_unit3_id,hr_api.g_number)
145: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)
146: or not l_api_updating) and
147: p_budget_unit3_id is not null then
148: --

Line 145: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)

141: end if;
142: --
143: if (l_api_updating
144: and nvl(p_budget_unit3_id,hr_api.g_number)
145: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)
146: or not l_api_updating) and
147: p_budget_unit3_id is not null then
148: --
149: -- check if budget_unit3_id value exists in per_shared_types table

Line 224: and nvl(p_budget_unit2_id,hr_api.g_number)

220: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change
221: -- UOM for FROZEN budgets
222: --
223: if (l_api_updating
224: and nvl(p_budget_unit2_id,hr_api.g_number)
225: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)) then
226:
227: -- UOM is changed
228: --

Line 225: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)) then

221: -- UOM for FROZEN budgets
222: --
223: if (l_api_updating
224: and nvl(p_budget_unit2_id,hr_api.g_number)
225: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)) then
226:
227: -- UOM is changed
228: --
229: --

Line 242: and nvl(p_budget_unit2_id,hr_api.g_number)

238: end if;
239:
240: --
241: if (l_api_updating
242: and nvl(p_budget_unit2_id,hr_api.g_number)
243: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)
244: or not l_api_updating) and
245: p_budget_unit2_id is not null then
246: --

Line 243: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)

239:
240: --
241: if (l_api_updating
242: and nvl(p_budget_unit2_id,hr_api.g_number)
243: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)
244: or not l_api_updating) and
245: p_budget_unit2_id is not null then
246: --
247: -- check if budget_unit2_id value exists in per_shared_types table

Line 322: and nvl(p_budget_unit1_id,hr_api.g_number)

318: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change
319: -- UOM for FROZEN budgets
320: --
321: if (l_api_updating
322: and nvl(p_budget_unit1_id,hr_api.g_number)
323: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)) then
324:
325: -- UOM is changed
326: --

Line 323: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)) then

319: -- UOM for FROZEN budgets
320: --
321: if (l_api_updating
322: and nvl(p_budget_unit1_id,hr_api.g_number)
323: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)) then
324:
325: -- UOM is changed
326: --
327: --

Line 340: and nvl(p_budget_unit1_id,hr_api.g_number)

336: end if;
337:
338: --
339: if (l_api_updating
340: and nvl(p_budget_unit1_id,hr_api.g_number)
341: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)
342: or not l_api_updating) and
343: p_budget_unit1_id is not null then
344: --

Line 341: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)

337:
338: --
339: if (l_api_updating
340: and nvl(p_budget_unit1_id,hr_api.g_number)
341: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)
342: or not l_api_updating) and
343: p_budget_unit1_id is not null then
344: --
345: -- check if budget_unit1_id value exists in per_shared_types table

Line 528: and nvl(p_period_set_name,hr_api.g_varchar2)

524: (p_budget_id => p_budget_id,
525: p_object_version_number => p_object_version_number);
526: --
527: if (l_api_updating
528: and nvl(p_period_set_name,hr_api.g_varchar2)
529: <> nvl(pqh_bgt_shd.g_old_rec.period_set_name,hr_api.g_varchar2)
530: or not l_api_updating) then
531: --
532: -- check if period_set_name value exists in pay_calendars table

Line 529: <> nvl(pqh_bgt_shd.g_old_rec.period_set_name,hr_api.g_varchar2)

525: p_object_version_number => p_object_version_number);
526: --
527: if (l_api_updating
528: and nvl(p_period_set_name,hr_api.g_varchar2)
529: <> nvl(pqh_bgt_shd.g_old_rec.period_set_name,hr_api.g_varchar2)
530: or not l_api_updating) then
531: --
532: -- check if period_set_name value exists in pay_calendars table
533: --

Line 631: and p_transfer_to_gl_flag <> nvl(pqh_bgt_shd.g_old_rec.transfer_to_gl_flag,hr_api.g_varchar2)

627: (p_budget_id => p_budget_id,
628: p_object_version_number => p_object_version_number);
629:
630: if (l_api_updating
631: and p_transfer_to_gl_flag <> nvl(pqh_bgt_shd.g_old_rec.transfer_to_gl_flag,hr_api.g_varchar2)
632: or not l_api_updating)
633: and p_transfer_to_gl_flag is not null then
634: --
635: -- check if value of lookup falls within lookup type.

Line 637: if hr_api.not_exists_in_hr_lookups

633: and p_transfer_to_gl_flag is not null then
634: --
635: -- check if value of lookup falls within lookup type.
636: --
637: if hr_api.not_exists_in_hr_lookups
638: (p_lookup_type => 'YES_NO',
639: p_lookup_code => p_transfer_to_gl_flag,
640: p_effective_date => p_effective_date) then
641: --

Line 761: <> nvl(pqh_bgt_shd.g_old_rec.transfer_to_grants_flag,hr_api.g_varchar2)

757: p_object_version_number => p_object_version_number);
758: --
759: if (l_api_updating
760: and p_transfer_to_grants_flag
761: <> nvl(pqh_bgt_shd.g_old_rec.transfer_to_grants_flag,hr_api.g_varchar2)
762: or not l_api_updating)
763: and p_transfer_to_grants_flag is not null then
764: --
765: -- check if value of lookup falls within lookup type.

Line 767: if hr_api.not_exists_in_hr_lookups

763: and p_transfer_to_grants_flag is not null then
764: --
765: -- check if value of lookup falls within lookup type.
766: --
767: if hr_api.not_exists_in_hr_lookups
768: (p_lookup_type => 'YES_NO',
769: p_lookup_code => p_transfer_to_grants_flag,
770: p_effective_date => p_effective_date) then
771: --

Line 815: <> nvl(pqh_bgt_shd.g_old_rec.status,hr_api.g_varchar2)

811: p_object_version_number => p_object_version_number);
812: --
813: if (l_api_updating
814: and p_status
815: <> nvl(pqh_bgt_shd.g_old_rec.status,hr_api.g_varchar2)
816: or not l_api_updating)
817: and p_status is not null then
818: --
819: -- check if value of lookup falls within lookup type.

Line 880: <> nvl(pqh_bgt_shd.g_old_rec.budget_style_cd,hr_api.g_varchar2)

876: p_object_version_number => p_object_version_number);
877: --
878: if (l_api_updating
879: and p_budget_style_cd
880: <> nvl(pqh_bgt_shd.g_old_rec.budget_style_cd,hr_api.g_varchar2)
881: or not l_api_updating) then
882: --
883: -- check if value of lookup falls within lookup type.
884: --

Line 886: if hr_api.not_exists_in_hr_lookups

882: --
883: -- check if value of lookup falls within lookup type.
884: --
885: --
886: if hr_api.not_exists_in_hr_lookups
887: (p_lookup_type => 'PQH_BUDGET_STYLE',
888: p_lookup_code => p_budget_style_cd,
889: p_effective_date => p_effective_date) then
890: --

Line 948: <> nvl(pqh_bgt_shd.g_old_rec.budgeted_entity_cd,hr_api.g_varchar2)

944: p_object_version_number => p_object_version_number);
945: --
946: if (l_api_updating
947: and p_budgeted_entity_cd
948: <> nvl(pqh_bgt_shd.g_old_rec.budgeted_entity_cd,hr_api.g_varchar2)
949: or not l_api_updating)
950: and p_budgeted_entity_cd is not null then
951: --
952: -- check if value of lookup falls within lookup type.

Line 954: if hr_api.not_exists_in_hr_lookups

950: and p_budgeted_entity_cd is not null then
951: --
952: -- check if value of lookup falls within lookup type.
953: --
954: if hr_api.not_exists_in_hr_lookups
955: (p_lookup_type => 'PQH_BUDGET_ENTITY',
956: p_lookup_code => p_budgeted_entity_cd,
957: p_effective_date => p_effective_date) then
958: --

Line 1064: <> nvl(pqh_bgt_shd.g_old_rec.budget_start_date,hr_api.g_date)

1060: p_object_version_number => p_object_version_number);
1061: --
1062: if (l_api_updating
1063: and p_budget_start_date
1064: <> nvl(pqh_bgt_shd.g_old_rec.budget_start_date,hr_api.g_date)
1065: or not l_api_updating)
1066: and p_budget_start_date is not null then
1067: --
1068: -- check if value of lookup falls within lookup type.

Line 1242: <> nvl(pqh_bgt_shd.g_old_rec.budget_end_date,hr_api.g_date)

1238: p_object_version_number => p_object_version_number);
1239: --
1240: if (l_api_updating
1241: and p_budget_end_date
1242: <> nvl(pqh_bgt_shd.g_old_rec.budget_end_date,hr_api.g_date)
1243: or not l_api_updating)
1244: and p_budget_end_date is not null then
1245: --
1246: -- check if value of lookup falls within lookup type.

Line 1541: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_aggregate,hr_api.g_varchar2)

1537: if (l_api_updating
1538: and
1539: (
1540: p_budget_unit1_aggregate
1541: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_aggregate,hr_api.g_varchar2)
1542: or
1543: p_budget_unit1_id
1544: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)
1545: )

Line 1544: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)

1540: p_budget_unit1_aggregate
1541: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_aggregate,hr_api.g_varchar2)
1542: or
1543: p_budget_unit1_id
1544: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit1_id,hr_api.g_number)
1545: )
1546: or not l_api_updating) then
1547: --
1548: -- check if value of lookup falls within lookup type.

Line 1551: if hr_api.not_exists_in_hr_lookups

1547: --
1548: -- check if value of lookup falls within lookup type.
1549: --
1550: --
1551: if hr_api.not_exists_in_hr_lookups
1552: (p_lookup_type => 'PQH_BGT_UOM_AGGREGATE',
1553: p_lookup_code => p_budget_unit1_aggregate,
1554: p_effective_date => p_effective_date) then
1555: --

Line 1636: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_aggregate,hr_api.g_varchar2)

1632: if (l_api_updating
1633: and
1634: (
1635: p_budget_unit2_aggregate
1636: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_aggregate,hr_api.g_varchar2)
1637: or
1638: p_budget_unit2_id
1639: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)
1640: )

Line 1639: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)

1635: p_budget_unit2_aggregate
1636: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_aggregate,hr_api.g_varchar2)
1637: or
1638: p_budget_unit2_id
1639: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit2_id,hr_api.g_number)
1640: )
1641: or ( not l_api_updating and p_budget_unit2_aggregate IS NOT NULL)) then
1642: --
1643: -- check if value of lookup falls within lookup type.

Line 1646: if hr_api.not_exists_in_hr_lookups

1642: --
1643: -- check if value of lookup falls within lookup type.
1644: --
1645: --
1646: if hr_api.not_exists_in_hr_lookups
1647: (p_lookup_type => 'PQH_BGT_UOM_AGGREGATE',
1648: p_lookup_code => p_budget_unit2_aggregate,
1649: p_effective_date => p_effective_date) then
1650: --

Line 1735: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_aggregate,hr_api.g_varchar2)

1731: if (l_api_updating
1732: and
1733: (
1734: p_budget_unit3_aggregate
1735: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_aggregate,hr_api.g_varchar2)
1736: or
1737: p_budget_unit3_id
1738: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)
1739: )

Line 1738: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)

1734: p_budget_unit3_aggregate
1735: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_aggregate,hr_api.g_varchar2)
1736: or
1737: p_budget_unit3_id
1738: <> nvl(pqh_bgt_shd.g_old_rec.budget_unit3_id,hr_api.g_number)
1739: )
1740: or ( not l_api_updating and p_budget_unit3_aggregate IS NOT NULL)) then
1741: --
1742: -- check if value of lookup falls within lookup type.

Line 1745: if hr_api.not_exists_in_hr_lookups

1741: --
1742: -- check if value of lookup falls within lookup type.
1743: --
1744: --
1745: if hr_api.not_exists_in_hr_lookups
1746: (p_lookup_type => 'PQH_BGT_UOM_AGGREGATE',
1747: p_lookup_code => p_budget_unit3_aggregate,
1748: p_effective_date => p_effective_date) then
1749: --

Line 1822: <> nvl(pqh_bgt_shd.g_old_rec.position_control_flag,hr_api.g_varchar2)

1818: p_object_version_number => p_object_version_number);
1819: --
1820: if (l_api_updating
1821: and p_position_control_flag
1822: <> nvl(pqh_bgt_shd.g_old_rec.position_control_flag,hr_api.g_varchar2)
1823: or not l_api_updating)
1824: and p_position_control_flag is not null then
1825: --
1826: -- check if value of lookup falls within lookup type.

Line 1828: if hr_api.not_exists_in_hr_lookups

1824: and p_position_control_flag is not null then
1825: --
1826: -- check if value of lookup falls within lookup type.
1827: --
1828: if hr_api.not_exists_in_hr_lookups
1829: (p_lookup_type => 'YES_NO',
1830: p_lookup_code => p_position_control_flag,
1831: p_effective_date => p_effective_date) then
1832: --

Line 1896: and nvl(p_currency_code,hr_api.g_varchar2)

1892: (p_budget_id => p_budget_id,
1893: p_object_version_number => p_object_version_number);
1894: --
1895: if (l_api_updating
1896: and nvl(p_currency_code,hr_api.g_varchar2)
1897: <> nvl(pqh_bgt_shd.g_old_rec.currency_code,hr_api.g_varchar2)
1898: or not l_api_updating) and
1899: p_currency_code is not null then
1900: --

Line 1897: <> nvl(pqh_bgt_shd.g_old_rec.currency_code,hr_api.g_varchar2)

1893: p_object_version_number => p_object_version_number);
1894: --
1895: if (l_api_updating
1896: and nvl(p_currency_code,hr_api.g_varchar2)
1897: <> nvl(pqh_bgt_shd.g_old_rec.currency_code,hr_api.g_varchar2)
1898: or not l_api_updating) and
1899: p_currency_code is not null then
1900: --
1901: -- check if currency_code value exists in fnd_currencies table

Line 1972: and (p_psb_budget_flag <> nvl(pqh_bgt_shd.g_old_rec.psb_budget_flag,hr_api.g_varchar2)

1968: (p_budget_id => p_budget_id,
1969: p_object_version_number => p_object_version_number);
1970: --
1971: if (l_api_updating
1972: and (p_psb_budget_flag <> nvl(pqh_bgt_shd.g_old_rec.psb_budget_flag,hr_api.g_varchar2)
1973: or p_gl_budget_name <> nvl(pqh_bgt_shd.g_old_rec.gl_budget_name,hr_api.g_varchar2))
1974: or not l_api_updating)
1975: and p_psb_budget_flag is not null then
1976: hr_utility.set_location('check is being fired'||l_proc, 7);

Line 1973: or p_gl_budget_name <> nvl(pqh_bgt_shd.g_old_rec.gl_budget_name,hr_api.g_varchar2))

1969: p_object_version_number => p_object_version_number);
1970: --
1971: if (l_api_updating
1972: and (p_psb_budget_flag <> nvl(pqh_bgt_shd.g_old_rec.psb_budget_flag,hr_api.g_varchar2)
1973: or p_gl_budget_name <> nvl(pqh_bgt_shd.g_old_rec.gl_budget_name,hr_api.g_varchar2))
1974: or not l_api_updating)
1975: and p_psb_budget_flag is not null then
1976: hr_utility.set_location('check is being fired'||l_proc, 7);
1977: --

Line 1980: if hr_api.not_exists_in_hr_lookups

1976: hr_utility.set_location('check is being fired'||l_proc, 7);
1977: --
1978: -- check if value of lookup falls within lookup type.
1979: --
1980: if hr_api.not_exists_in_hr_lookups
1981: (p_lookup_type => 'YES_NO',
1982: p_lookup_code => p_psb_budget_flag,
1983: p_effective_date => p_effective_date) then
1984: --

Line 2157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2153: p_effective_date => p_effective_date,
2154: p_object_version_number => p_rec.object_version_number);
2155:
2156: --
2157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2158: --
2159: hr_utility.set_location(' Leaving:'||l_proc, 10);
2160: End insert_validate;
2161: --

Line 2313: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2309: p_effective_date => p_effective_date,
2310: p_object_version_number => p_rec.object_version_number);
2311: --
2312:
2313: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2314: --
2315: hr_utility.set_location(' Leaving:'||l_proc, 10);
2316: End update_validate;
2317: --

Line 2362: hr_api.mandatory_arg_error(p_api_name => l_proc,

2358: hr_utility.set_location('Entering:'|| l_proc, 10);
2359: --
2360: -- Ensure that all the mandatory parameter are not null
2361: --
2362: hr_api.mandatory_arg_error(p_api_name => l_proc,
2363: p_argument => 'budget_id',
2364: p_argument_value => p_budget_id);
2365: --
2366: open csr_leg_code;