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.PER_BUDGET_VERSION_RULES_PKG dependencies on PER_BUDGET_VERSIONS

Line 18: FROM per_budget_versions pbv

14: CURSOR C_Elements is
15: SELECT pbe.Rowid
16: FROM per_budget_elements pbe
17: WHERE pbe.budget_version_id = (SELECT pbv.budget_version_id
18: FROM per_budget_versions pbv
19: WHERE pbv.Rowid = X_Rowid);
20: --
21: l_ele_rowid VARCHAR2(30);
22: l_budget_id NUMBER(15);

Line 31: FROM per_budget_versions pbv

27: hr_utility.set_location('Entering:'||l_proc, 5);
28: --
29: SELECT pbv.budget_id
30: INTO l_budget_id
31: FROM per_budget_versions pbv
32: WHERE pbv.Rowid = X_Rowid;
33: --
34: OPEN C_Elements;
35: -- Cascade delete the appropriate child budget_elements recs if

Line 56: DELETE FROM per_budget_versions

52: END IF;
53: CLOSE C_Elements;
54:
55: --now delete the version
56: DELETE FROM per_budget_versions
57: WHERE Rowid = X_Rowid;
58: --
59: hr_utility.set_location(' Leaving:'||l_proc, 10);
60: --

Line 79: FROM per_budget_versions pbv

75: hr_utility.set_location('Entering:'||l_proc, 5);
76: --
77: SELECT null
78: INTO l_result
79: FROM per_budget_versions pbv
80: WHERE pbv.budget_id = X_Budget_Id
81: AND (pbv.rowid <> X_Rowid
82: OR X_Rowid is Null);
83: If (SQL%FOUND) then

Line 108: from per_budget_versions pbv

104: -- PRIVATE FUNCTION used by Chk_Prev_Rec.
105: --
106: CURSOR Before is
107: select pbv.date_to,pbv.date_from
108: from per_budget_versions pbv
109: where pbv.budget_id = X_Budget_Id
110: and (pbv.rowid <> X_Rowid
111: OR X_Rowid is null)
112: and pbv.date_to = (select max(pbv2.date_to)

Line 113: from per_budget_versions pbv2

109: where pbv.budget_id = X_Budget_Id
110: and (pbv.rowid <> X_Rowid
111: OR X_Rowid is null)
112: and pbv.date_to = (select max(pbv2.date_to)
113: from per_budget_versions pbv2
114: where pbv2.budget_id = X_Budget_Id
115: and (pbv2.rowid <> X_Rowid
116: OR X_Rowid is null)
117: and pbv2.date_to < X_Date_From);

Line 121: from per_budget_versions pbv

117: and pbv2.date_to < X_Date_From);
118: --
119: CURSOR After is
120: select pbv.date_to,pbv.date_from
121: from per_budget_versions pbv
122: where pbv.budget_id = X_Budget_Id
123: and (pbv.rowid <> X_Rowid
124: OR X_Rowid is null)
125: and pbv.date_from = (select min(pbv2.date_from)

Line 126: from per_budget_versions pbv2

122: where pbv.budget_id = X_Budget_Id
123: and (pbv.rowid <> X_Rowid
124: OR X_Rowid is null)
125: and pbv.date_from = (select min(pbv2.date_from)
126: from per_budget_versions pbv2
127: where pbv2.budget_id = X_Budget_Id
128: and (pbv2.rowid <> X_Rowid
129: OR X_Rowid is null)
130: and pbv2.date_from > X_Date_To);

Line 193: from per_budget_versions pbv

189: X_Date_To DATE) return BOOLEAN is
190: --
191: CURSOR Before is
192: select pbv.date_to,pbv.date_from
193: from per_budget_versions pbv
194: where pbv.budget_id = X_Budget_Id
195: and (pbv.rowid <> X_Rowid
196: OR X_Rowid is null)
197: and pbv.date_to = (select max(pbv2.date_to)

Line 198: from per_budget_versions pbv2

194: where pbv.budget_id = X_Budget_Id
195: and (pbv.rowid <> X_Rowid
196: OR X_Rowid is null)
197: and pbv.date_to = (select max(pbv2.date_to)
198: from per_budget_versions pbv2
199: where pbv2.budget_id = X_Budget_Id
200: and (pbv2.rowid <> X_Rowid
201: OR X_Rowid is null)
202: and pbv2.date_from < X_Date_From);

Line 207: from per_budget_versions pbv

203: --
204: --
205: CURSOR After is
206: select pbv.date_to,pbv.date_from
207: from per_budget_versions pbv
208: where pbv.budget_id = X_Budget_Id
209: and (pbv.rowid <> X_Rowid
210: OR X_Rowid is null)
211: and pbv.date_from = (select min(pbv2.date_from)

Line 212: from per_budget_versions pbv2

208: where pbv.budget_id = X_Budget_Id
209: and (pbv.rowid <> X_Rowid
210: OR X_Rowid is null)
211: and pbv.date_from = (select min(pbv2.date_from)
212: from per_budget_versions pbv2
213: where pbv2.budget_id = X_Budget_Id
214: and (pbv2.rowid <> X_Rowid
215: OR X_Rowid is null)
216: and pbv2.date_from > X_Date_From);

Line 274: from per_budget_versions pbv1

270: ,X_Date_From DATE
271: ,X_Date_To IN OUT NOCOPY DATE) is
272: --
273: CURSOR C is select pbv1.date_from, pbv1.date_to
274: from per_budget_versions pbv1
275: where pbv1.budget_id = X_Budget_Id
276: and (pbv1.rowid <> X_Rowid
277: OR X_Rowid is NULL)
278: and pbv1.date_from = (select max(pbv2.date_from)

Line 279: from per_budget_versions pbv2

275: where pbv1.budget_id = X_Budget_Id
276: and (pbv1.rowid <> X_Rowid
277: OR X_Rowid is NULL)
278: and pbv1.date_from = (select max(pbv2.date_from)
279: from per_budget_versions pbv2
280: where pbv2.date_from < X_Date_From
281: and pbv2.budget_id = X_Budget_Id
282: and (pbv2.rowid <> X_Rowid
283: OR X_Rowid is NULL))

Line 287: from per_budget_versions pbv1

283: OR X_Rowid is NULL))
284: FOR UPDATE;
285: --
286: CURSOR C2 is select pbv1.date_from, pbv1.date_to
287: from per_budget_versions pbv1
288: where pbv1.budget_id = X_Budget_Id
289: and (pbv1.rowid <> X_Rowid
290: OR X_Rowid is NULL)
291: and pbv1.date_from = (select min(pbv2.date_from)

Line 292: from per_budget_versions pbv2

288: where pbv1.budget_id = X_Budget_Id
289: and (pbv1.rowid <> X_Rowid
290: OR X_Rowid is NULL)
291: and pbv1.date_from = (select min(pbv2.date_from)
292: from per_budget_versions pbv2
293: where pbv2.date_from > X_Date_From
294: and pbv2.budget_id = X_Budget_Id
295: and (pbv2.rowid <> X_Rowid
296: OR X_Rowid is NULL))

Line 316: UPDATE per_budget_versions

312: IF (l_date_to is null) then
313: --which runs to the end of time and commences before the new version
314: --so close the old version down on the day preceding the new version
315: --
316: UPDATE per_budget_versions
317: SET date_to = X_Date_From - 1
318: WHERE current of C;
319: --
320: End if;

Line 408: SELECT per_budget_versions_s.nextval

404: BEGIN
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: SELECT per_budget_versions_s.nextval
409: INTO X_Budget_Version_Id
410: FROM dual;
411:
412: --

Line 443: FROM per_budget_versions pbv

439: X_Rowid IN VARCHAR2) IS
440:
441: CURSOR c_bdv IS
442: SELECT null
443: FROM per_budget_versions pbv
444: WHERE pbv.budget_version_id = x_budget_version_id
445: AND (pbv.rowid <> X_ROWID or X_Rowid IS NULL);
446:
447: l_result VARCHAR2(255);

Line 500: ,p_descflex_name => 'PER_BUDGET_VERSIONS'

496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: hr_dflex_utility.ins_or_upd_descflex_attribs
499: (p_appl_short_name => 'PER'
500: ,p_descflex_name => 'PER_BUDGET_VERSIONS'
501: ,p_attribute_category => x_attribute_category
502: ,p_attribute1_name => 'ATTRIBUTE1'
503: ,p_attribute1_value => x_attribute1
504: ,p_attribute2_name => 'ATTRIBUTE2'

Line 562: FROM per_budget_versions bver

558: hr_utility.set_location('Entering:'||l_proc, 5);
559: --
560: SELECT NULL
561: INTO l_result
562: FROM per_budget_versions bver
563: WHERE UPPER(X_Version_Number) = UPPER(bver.Version_number)
564: AND X_Business_group_Id = bver.Business_Group_Id
565: AND X_Budget_Id = bver.Budget_Id
566: AND (bver.Rowid <> X_Rowid or X_Rowid is null);

Line 590: FROM PER_BUDGET_VERSIONS

586: X_Session_Date DATE,
587: X_Budget_Id NUMBER) IS
588:
589: /*CURSOR C IS SELECT MAX(DATE_FROM + 1)
590: FROM PER_BUDGET_VERSIONS
591: WHERE BUDGET_ID = X_Budget_Id
592: AND DATE_TO IS NULL;*/
593: CURSOR C is select pbv1.date_from,pbv1.date_to
594: from per_budget_versions pbv1

Line 594: from per_budget_versions pbv1

590: FROM PER_BUDGET_VERSIONS
591: WHERE BUDGET_ID = X_Budget_Id
592: AND DATE_TO IS NULL;*/
593: CURSOR C is select pbv1.date_from,pbv1.date_to
594: from per_budget_versions pbv1
595: where pbv1.budget_id = X_Budget_Id
596: and pbv1.date_from = (select max(pbv2.date_from)
597: from per_budget_versions pbv2
598: where pbv2.budget_id = X_Budget_Id);

Line 597: from per_budget_versions pbv2

593: CURSOR C is select pbv1.date_from,pbv1.date_to
594: from per_budget_versions pbv1
595: where pbv1.budget_id = X_Budget_Id
596: and pbv1.date_from = (select max(pbv2.date_from)
597: from per_budget_versions pbv2
598: where pbv2.budget_id = X_Budget_Id);
599: --
600: l_date_from DATE;
601: l_date_to DATE;

Line 666: CURSOR C1 IS SELECT rowid FROM PER_BUDGET_VERSIONS

662: ,X_Attribute19 VARCHAR2
663: ,X_Attribute20 VARCHAR2
664: ) IS
665:
666: CURSOR C1 IS SELECT rowid FROM PER_BUDGET_VERSIONS
667: WHERE budget_version_id = X_budget_version_id;
668:
669: l_proc VARCHAR2(72) := g_package||'Insert_Row';
670:

Line 712: -- validate per_budget_versions df

708: p_argument => 'date_from',
709: p_argument_value => X_Date_From);
710:
711:
712: -- validate per_budget_versions df
713: Chk_df(X_Attribute_Category,
714: X_Attribute1,
715: X_Attribute2,
716: X_Attribute3,

Line 738: INSERT INTO PER_BUDGET_VERSIONS(budget_version_id

734:
735: -- Get new budget_version_id
736: per_budget_version_rules_pkg.get_id(X_budget_version_id);
737:
738: INSERT INTO PER_BUDGET_VERSIONS(budget_version_id
739: ,business_group_id
740: ,budget_id
741: ,date_from
742: ,version_number

Line 856: FROM PER_BUDGET_VERSIONS

852: ,X_Attribute19 VARCHAR2
853: ,X_Attribute20 VARCHAR2) IS
854: CURSOR C IS
855: SELECT *
856: FROM PER_BUDGET_VERSIONS
857: WHERE rowid = X_Rowid
858: FOR UPDATE of budget_version_id NOWAIT;
859: Recinfo C%ROWTYPE;
860: l_proc VARCHAR2(72) := g_package||'Lock_Row';

Line 1108: -- validate per_budget_versions df

1104: hr_utility.set_message(800,'PER_52874_NOT_OTA_VERSION');
1105: hr_utility.raise_error;
1106: END IF;
1107:
1108: -- validate per_budget_versions df
1109: Chk_df(X_Attribute_Category,
1110: X_Attribute1,
1111: X_Attribute2,
1112: X_Attribute3,

Line 1133: UPDATE PER_BUDGET_VERSIONS

1129: X_Attribute20);
1130:
1131:
1132: -- Get new budget_version_id
1133: UPDATE PER_BUDGET_VERSIONS
1134: SET
1135: budget_version_id = X_Budget_Version_id
1136: ,business_group_id = X_Business_Group_Id
1137: ,budget_id = X_Budget_Id