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_WPR_BUS dependencies on PER_TIME_PERIODS

Line 111: from per_time_periods a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from per_time_periods a
112: where a.time_period_id = p_end_time_period_id;
113: --
114: Begin
115: --

Line 127: -- check if end_time_period_id value exists in per_time_periods table

123: and nvl(p_end_time_period_id,hr_api.g_number)
124: <> nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if end_time_period_id value exists in per_time_periods table
128: --
129: open c1;
130: --
131: fetch c1 into l_dummy;

Line 136: -- raise error as FK does not relate to PK in per_time_periods

132: if c1%notfound then
133: --
134: close c1;
135: --
136: -- raise error as FK does not relate to PK in per_time_periods
137: -- table.
138: --
139: pqh_wpr_shd.constraint_error('PQH_WORKSHEET_PERIODS_FK3');
140: --

Line 186: from per_time_periods a

182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from per_time_periods a
187: where a.time_period_id = p_start_time_period_id;
188: --
189: Begin
190: --

Line 202: -- check if start_time_period_id value exists in per_time_periods table

198: and nvl(p_start_time_period_id,hr_api.g_number)
199: <> nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if start_time_period_id value exists in per_time_periods table
203: --
204: open c1;
205: --
206: fetch c1 into l_dummy;

Line 211: -- raise error as FK does not relate to PK in per_time_periods

207: if c1%notfound then
208: --
209: close c1;
210: --
211: -- raise error as FK does not relate to PK in per_time_periods
212: -- table.
213: --
214: pqh_wpr_shd.constraint_error('PQH_WORKSHEET_PERIODS_FK2');
215: --

Line 689: l_start_date per_time_periods.start_date%type;

685: l_proc varchar2(72) := g_package||'chk_invalid_time_periods';
686: l_api_updating boolean;
687: l_dummy varchar2(1);
688: --
689: l_start_date per_time_periods.start_date%type;
690: l_end_date per_time_periods.end_date%type;
691: l_budget_start_date pqh_budgets.budget_start_date%type;
692: l_budget_end_date pqh_budgets.budget_end_date%type;
693: --

Line 690: l_end_date per_time_periods.end_date%type;

686: l_api_updating boolean;
687: l_dummy varchar2(1);
688: --
689: l_start_date per_time_periods.start_date%type;
690: l_end_date per_time_periods.end_date%type;
691: l_budget_start_date pqh_budgets.budget_start_date%type;
692: l_budget_end_date pqh_budgets.budget_end_date%type;
693: --
694: cursor c1 is

Line 696: from per_time_periods a

692: l_budget_end_date pqh_budgets.budget_end_date%type;
693: --
694: cursor c1 is
695: select start_date
696: from per_time_periods a
697: where a.time_period_id = p_start_time_period_id;
698: --
699: --
700: cursor c2 is

Line 702: from per_time_periods a

698: --
699: --
700: cursor c2 is
701: select end_date
702: from per_time_periods a
703: where a.time_period_id = p_end_time_period_id;
704: --
705: Cursor c3 is
706: Select bdt.BUDGET_START_DATE,bdt.BUDGET_END_DATE

Line 724: -- raise error as FK does not relate to PK in per_time_periods

720: if c1%notfound then
721: --
722: close c1;
723: --
724: -- raise error as FK does not relate to PK in per_time_periods
725: -- table.
726: --
727: pqh_wpr_shd.constraint_error('PQH_WORKSHEET_PERIODS_FK2');
728: --

Line 738: -- raise error as FK does not relate to PK in per_time_periods

734: if c2%notfound then
735: --
736: close c1;
737: --
738: -- raise error as FK does not relate to PK in per_time_periods
739: -- table.
740: --
741: pqh_wpr_shd.constraint_error('PQH_WORKSHEET_PERIODS_FK3');
742: --

Line 774: -- raise error as FK does not relate to PK in per_time_periods

770: if c3%notfound then
771: --
772: close c3;
773: --
774: -- raise error as FK does not relate to PK in per_time_periods
775: -- table.
776: --
777: hr_utility.set_message(8302,'PQH_BUDGET_DATE_NOT_FOUND');
778: hr_utility.raise_error;