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 PQH_BGT_SHD

Line 46: l_api_updating := pqh_bgt_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bgt_shd.api_updating
47: (p_budget_id => p_budget_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_bgt_shd.g_old_rec.budget_id) then

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: --
56: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');

Line 56: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');

52: <> pqh_bgt_shd.g_old_rec.budget_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');

62: if p_budget_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_bgt_shd.constraint_error('PQH_BUDGETS_PK');
67: --
68: end if;
69: --
70: end if;

Line 121: l_api_updating := pqh_bgt_shd.api_updating

117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc,5);
120: --
121: l_api_updating := pqh_bgt_shd.api_updating
122: (p_budget_id => p_budget_id,
123: p_object_version_number => p_object_version_number);
124: --
125: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change

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 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 161: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK4');

157: --
158: -- raise error as FK does not relate to PK in per_shared_types
159: -- table.
160: --
161: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK4');
162: --
163: end if;
164: --
165: close c1;

Line 216: l_api_updating := pqh_bgt_shd.api_updating

212: Begin
213: --
214: hr_utility.set_location('Entering:'||l_proc,5);
215: --
216: l_api_updating := pqh_bgt_shd.api_updating
217: (p_budget_id => p_budget_id,
218: p_object_version_number => p_object_version_number);
219: --
220: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change

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 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 259: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK3');

255: --
256: -- raise error as FK does not relate to PK in per_shared_types
257: -- table.
258: --
259: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK3');
260: --
261: end if;
262: --
263: close c1;

Line 314: l_api_updating := pqh_bgt_shd.api_updating

310: Begin
311: --
312: hr_utility.set_location('Entering:'||l_proc,5);
313: --
314: l_api_updating := pqh_bgt_shd.api_updating
315: (p_budget_id => p_budget_id,
316: p_object_version_number => p_object_version_number);
317: --
318: -- If STATUS = FROZEN and UOM is changed then ERROR as you cannot change

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 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 357: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK2');

353: --
354: -- raise error as FK does not relate to PK in per_shared_types
355: -- table.
356: --
357: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK2');
358: --
359: end if;
360: --
361: close c1;

Line 523: l_api_updating := pqh_bgt_shd.api_updating

519: Begin
520: --
521: hr_utility.set_location('Entering:'||l_proc,5);
522: --
523: l_api_updating := pqh_bgt_shd.api_updating
524: (p_budget_id => p_budget_id,
525: p_object_version_number => p_object_version_number);
526: --
527: if (l_api_updating

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 544: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK1');

540: --
541: -- raise error as FK does not relate to PK in pay_calendars
542: -- table.
543: --
544: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK1');
545: --
546: end if;
547: --
548: close c1;

Line 626: l_api_updating := pqh_bgt_shd.api_updating

622: similar to GL budget name for transfering to GL. A controll Bugdted can be transfered
623: to any GL budget provided that controll budget falls with in GL budget date range.
624: As a result of this we will not be using transfer_to_gl_flag
625:
626: l_api_updating := pqh_bgt_shd.api_updating
627: (p_budget_id => p_budget_id,
628: p_object_version_number => p_object_version_number);
629:
630: if (l_api_updating

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 755: l_api_updating := pqh_bgt_shd.api_updating

751: Begin
752: --
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: --
755: l_api_updating := pqh_bgt_shd.api_updating
756: (p_budget_id => p_budget_id,
757: p_object_version_number => p_object_version_number);
758: --
759: if (l_api_updating

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 809: l_api_updating := pqh_bgt_shd.api_updating

805: Begin
806: --
807: hr_utility.set_location('Entering:'||l_proc, 5);
808: --
809: l_api_updating := pqh_bgt_shd.api_updating
810: (p_budget_id => p_budget_id,
811: p_object_version_number => p_object_version_number);
812: --
813: if (l_api_updating

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 874: l_api_updating := pqh_bgt_shd.api_updating

870: Begin
871: --
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: l_api_updating := pqh_bgt_shd.api_updating
875: (p_budget_id => p_budget_id,
876: p_object_version_number => p_object_version_number);
877: --
878: if (l_api_updating

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 942: l_api_updating := pqh_bgt_shd.api_updating

938: Begin
939: --
940: hr_utility.set_location('Entering:'||l_proc, 5);
941: --
942: l_api_updating := pqh_bgt_shd.api_updating
943: (p_budget_id => p_budget_id,
944: p_object_version_number => p_object_version_number);
945: --
946: if (l_api_updating

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 1058: l_api_updating := pqh_bgt_shd.api_updating

1054: --
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: --
1057:
1058: l_api_updating := pqh_bgt_shd.api_updating
1059: (p_budget_id => p_budget_id,
1060: p_object_version_number => p_object_version_number);
1061: --
1062: if (l_api_updating

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 1236: l_api_updating := pqh_bgt_shd.api_updating

1232: --
1233: hr_utility.set_location('Entering:'||l_proc, 5);
1234: --
1235:
1236: l_api_updating := pqh_bgt_shd.api_updating
1237: (p_budget_id => p_budget_id,
1238: p_object_version_number => p_object_version_number);
1239: --
1240: if (l_api_updating

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 1533: l_api_updating := pqh_bgt_shd.api_updating

1529: Begin
1530: --
1531: hr_utility.set_location('Entering:'||l_proc, 5);
1532: --
1533: l_api_updating := pqh_bgt_shd.api_updating
1534: (p_budget_id => p_budget_id,
1535: p_object_version_number => p_object_version_number);
1536: --
1537: if (l_api_updating

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 1628: l_api_updating := pqh_bgt_shd.api_updating

1624: Begin
1625: --
1626: hr_utility.set_location('Entering:'||l_proc, 5);
1627: --
1628: l_api_updating := pqh_bgt_shd.api_updating
1629: (p_budget_id => p_budget_id,
1630: p_object_version_number => p_object_version_number);
1631: --
1632: if (l_api_updating

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 1727: l_api_updating := pqh_bgt_shd.api_updating

1723: Begin
1724: --
1725: hr_utility.set_location('Entering:'||l_proc, 5);
1726: --
1727: l_api_updating := pqh_bgt_shd.api_updating
1728: (p_budget_id => p_budget_id,
1729: p_object_version_number => p_object_version_number);
1730: --
1731: if (l_api_updating

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 1816: l_api_updating := pqh_bgt_shd.api_updating

1812: Begin
1813: --
1814: hr_utility.set_location('Entering:'||l_proc, 5);
1815: --
1816: l_api_updating := pqh_bgt_shd.api_updating
1817: (p_budget_id => p_budget_id,
1818: p_object_version_number => p_object_version_number);
1819: --
1820: if (l_api_updating

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 1891: l_api_updating := pqh_bgt_shd.api_updating

1887: Begin
1888: --
1889: hr_utility.set_location('Entering:'||l_proc,5);
1890: --
1891: l_api_updating := pqh_bgt_shd.api_updating
1892: (p_budget_id => p_budget_id,
1893: p_object_version_number => p_object_version_number);
1894: --
1895: if (l_api_updating

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 1913: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK5');

1909: --
1910: -- raise error as FK does not relate to PK in fnd_currencies
1911: -- table.
1912: --
1913: pqh_bgt_shd.constraint_error('PQH_BUDGETS_FK5');
1914: --
1915: end if;
1916: --
1917: --

Line 1967: l_api_updating := pqh_bgt_shd.api_updating

1963: Begin
1964: --
1965: hr_utility.set_location('Entering:'||l_proc, 5);
1966: --
1967: l_api_updating := pqh_bgt_shd.api_updating
1968: (p_budget_id => p_budget_id,
1969: p_object_version_number => p_object_version_number);
1970: --
1971: if (l_api_updating

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 2010: Procedure insert_validate(p_rec in pqh_bgt_shd.g_rec_type

2006: --
2007: -- ----------------------------------------------------------------------------
2008: -- |---------------------------< insert_validate >----------------------------|
2009: -- ----------------------------------------------------------------------------
2010: Procedure insert_validate(p_rec in pqh_bgt_shd.g_rec_type
2011: ,p_effective_date in date) is
2012: --
2013: l_proc varchar2(72) := g_package||'insert_validate';
2014: --

Line 2165: Procedure update_validate(p_rec in pqh_bgt_shd.g_rec_type

2161: --
2162: -- ----------------------------------------------------------------------------
2163: -- |---------------------------< update_validate >----------------------------|
2164: -- ----------------------------------------------------------------------------
2165: Procedure update_validate(p_rec in pqh_bgt_shd.g_rec_type
2166: ,p_effective_date in date) is
2167: --
2168: l_proc varchar2(72) := g_package||'update_validate';
2169: --

Line 2321: Procedure delete_validate(p_rec in pqh_bgt_shd.g_rec_type

2317: --
2318: -- ----------------------------------------------------------------------------
2319: -- |---------------------------< delete_validate >----------------------------|
2320: -- ----------------------------------------------------------------------------
2321: Procedure delete_validate(p_rec in pqh_bgt_shd.g_rec_type
2322: ,p_effective_date in date) is
2323: --
2324: l_proc varchar2(72) := g_package||'delete_validate';
2325: --