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.HR_MAINTAIN_PROPOSAL_API dependencies on PER_PAY_PROPOSALS

Line 46: from per_pay_proposals

42: ,p_change_date in date) is
43:
44: cursor csr_next_proposal is
45: select pay_proposal_id, rowid
46: from per_pay_proposals
47: where assignment_id = p_assignment_id
48: and change_date=(
49: select min(change_date)
50: from per_pay_proposals

Line 50: from per_pay_proposals

46: from per_pay_proposals
47: where assignment_id = p_assignment_id
48: and change_date=(
49: select min(change_date)
50: from per_pay_proposals
51: where assignment_id = p_assignment_id
52: and change_date > p_change_date);
53:
54: l_last_change_date per_pay_proposals.last_change_date%TYPE;

Line 54: l_last_change_date per_pay_proposals.last_change_date%TYPE;

50: from per_pay_proposals
51: where assignment_id = p_assignment_id
52: and change_date > p_change_date);
53:
54: l_last_change_date per_pay_proposals.last_change_date%TYPE;
55: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
56: l_row_id rowid;
57: l_proc varchar2(30):= 'update_last_change_date';
58:

Line 55: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

51: where assignment_id = p_assignment_id
52: and change_date > p_change_date);
53:
54: l_last_change_date per_pay_proposals.last_change_date%TYPE;
55: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
56: l_row_id rowid;
57: l_proc varchar2(30):= 'update_last_change_date';
58:
59: begin

Line 77: update per_pay_proposals

73: hr_utility.set_location('Cursor found:',25);
74:
75: --added by schowdhu to fix 7205132
76:
77: update per_pay_proposals
78: set last_change_date = l_last_change_date,
79: last_updated_by = fnd_global.user_id,
80: last_update_login = fnd_global.login_id
81: where rowid=l_row_id;

Line 85: update per_pay_proposals

81: where rowid=l_row_id;
82:
83: -- commented out by schowdhu to fix 7205132
84: /*
85: update per_pay_proposals
86: set last_change_date = l_last_change_date
87: where rowid=l_row_id;
88: */
89: hr_utility.set_location('Updated successfuly:',35);

Line 115: from per_pay_proposals

111:
112: Cursor csr_prev_prop_details
113: is
114: select pay_proposal_id,date_to
115: from per_pay_proposals
116: where assignment_id = p_assignment_id
117: and change_date =(select max(change_date)
118: from per_pay_proposals
119: where assignment_id = p_assignment_id

Line 118: from per_pay_proposals

114: select pay_proposal_id,date_to
115: from per_pay_proposals
116: where assignment_id = p_assignment_id
117: and change_date =(select max(change_date)
118: from per_pay_proposals
119: where assignment_id = p_assignment_id
120: and change_date < p_date_to+1 and approved = 'N');
121:
122: l_date_to per_pay_proposals.date_to%TYPE;

Line 122: l_date_to per_pay_proposals.date_to%TYPE;

118: from per_pay_proposals
119: where assignment_id = p_assignment_id
120: and change_date < p_date_to+1 and approved = 'N');
121:
122: l_date_to per_pay_proposals.date_to%TYPE;
123: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
124: l_proc varchar2(30):= 'end_date_proposed_proposal';
125:
126: begin

Line 123: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

119: where assignment_id = p_assignment_id
120: and change_date < p_date_to+1 and approved = 'N');
121:
122: l_date_to per_pay_proposals.date_to%TYPE;
123: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
124: l_proc varchar2(30):= 'end_date_proposed_proposal';
125:
126: begin
127:

Line 142: update per_pay_proposals

138: if csr_prev_prop_details%FOUND then
139: hr_utility.set_location('Cursor found:',35);
140: if l_date_to is null OR l_date_to > p_date_to then
141: hr_utility.set_location('About to update',45);
142: update per_pay_proposals
143: set date_to = p_date_to,
144: -- added by vkodedal fix for 6831216
145: last_update_date = sysdate,
146: last_updated_by = fnd_global.user_id,

Line 173: from per_pay_proposals

169:
170: Cursor csr_prev_prop_details
171: is
172: select pay_proposal_id, date_to
173: from per_pay_proposals
174: where assignment_id = p_assignment_id
175: and change_date =(select max(change_date)
176: from per_pay_proposals
177: where assignment_id = p_assignment_id

Line 176: from per_pay_proposals

172: select pay_proposal_id, date_to
173: from per_pay_proposals
174: where assignment_id = p_assignment_id
175: and change_date =(select max(change_date)
176: from per_pay_proposals
177: where assignment_id = p_assignment_id
178: and change_date < p_date_to+1 and approved = 'Y');
179:
180: -- cursor added to find the proposed proposals to be deleted

Line 186: from per_pay_proposals

182:
183: cursor get_all_proposed_proposals
184: is
185: select pay_proposal_id,object_version_number, business_group_id
186: from per_pay_proposals
187: where assignment_id = p_assignment_id
188: --added for the bug 7673294 to exclude the calling proposal
189: and (p_proposal_id IS NULL OR pay_proposal_id <> p_proposal_id)
190: and change_date < p_date_to+1

Line 193: l_date_to per_pay_proposals.date_to%TYPE;

189: and (p_proposal_id IS NULL OR pay_proposal_id <> p_proposal_id)
190: and change_date < p_date_to+1
191: and approved = 'N';
192:
193: l_date_to per_pay_proposals.date_to%TYPE;
194: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
195: l_proc varchar2(30):= 'end_date_approved_proposal';
196: l_change_date per_pay_proposals.change_date%TYPE;
197: l_del_warn boolean;

Line 194: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

190: and change_date < p_date_to+1
191: and approved = 'N';
192:
193: l_date_to per_pay_proposals.date_to%TYPE;
194: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
195: l_proc varchar2(30):= 'end_date_approved_proposal';
196: l_change_date per_pay_proposals.change_date%TYPE;
197: l_del_warn boolean;
198:

Line 196: l_change_date per_pay_proposals.change_date%TYPE;

192:
193: l_date_to per_pay_proposals.date_to%TYPE;
194: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
195: l_proc varchar2(30):= 'end_date_approved_proposal';
196: l_change_date per_pay_proposals.change_date%TYPE;
197: l_del_warn boolean;
198:
199: begin
200:

Line 212: update per_pay_proposals

208: if csr_prev_prop_details%FOUND then
209: hr_utility.set_location('Cursor found:',35);
210: if l_date_to is null OR l_date_to > p_date_to then
211: hr_utility.set_location('About to update',45);
212: update per_pay_proposals
213: set date_to = p_date_to,
214: -- added by vkodedal fix for 6831216
215: last_update_date = sysdate,
216: last_updated_by = fnd_global.user_id,

Line 262: from per_pay_proposals

258: /*
259: Cursor csr_prev_prop_details
260: is
261: select pay_proposal_id,date_to
262: from per_pay_proposals
263: where assignment_id = p_assignment_id
264: and change_date =(select max(change_date)
265: from per_pay_proposals
266: where assignment_id = p_assignment_id

Line 265: from per_pay_proposals

261: select pay_proposal_id,date_to
262: from per_pay_proposals
263: where assignment_id = p_assignment_id
264: and change_date =(select max(change_date)
265: from per_pay_proposals
266: where assignment_id = p_assignment_id
267: and change_date < p_date_to+1);
268:
269: l_date_to per_pay_proposals.date_to%TYPE;

Line 269: l_date_to per_pay_proposals.date_to%TYPE;

265: from per_pay_proposals
266: where assignment_id = p_assignment_id
267: and change_date < p_date_to+1);
268:
269: l_date_to per_pay_proposals.date_to%TYPE;
270: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
271: */
272: l_proc varchar2(30):= 'end_date_salary_proposal';
273: l_approved per_pay_proposals.approved%TYPE;

Line 270: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

266: where assignment_id = p_assignment_id
267: and change_date < p_date_to+1);
268:
269: l_date_to per_pay_proposals.date_to%TYPE;
270: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
271: */
272: l_proc varchar2(30):= 'end_date_salary_proposal';
273: l_approved per_pay_proposals.approved%TYPE;
274: -- changed by schowdhu for 7673294 05-jan-08

Line 273: l_approved per_pay_proposals.approved%TYPE;

269: l_date_to per_pay_proposals.date_to%TYPE;
270: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
271: */
272: l_proc varchar2(30):= 'end_date_salary_proposal';
273: l_approved per_pay_proposals.approved%TYPE;
274: -- changed by schowdhu for 7673294 05-jan-08
275:
276: Cursor chk_approved_flg
277: is

Line 279: from per_pay_proposals

275:
276: Cursor chk_approved_flg
277: is
278: select approved
279: from per_pay_proposals
280: where pay_proposal_id = nvl(p_proposal_id, pay_proposal_id)
281: and assignment_id = p_assignment_id
282: and change_date = p_date_to +1 ;
283: begin

Line 300: update per_pay_proposals

296: if csr_prev_prop_details%FOUND then
297: hr_utility.set_location('Cursor found:',35);
298: if l_date_to is null OR l_date_to > p_date_to then
299: hr_utility.set_location('About to update',45);
300: update per_pay_proposals
301: set date_to = p_date_to,
302: -- added by vkodedal fix for 6831216
303: last_update_date = sysdate,
304: last_updated_by = fnd_global.user_id,

Line 334: from per_pay_proposals

330: Procedure extend_salary_proposal_to_date(p_pay_proposal_id in number) is
331: --
332: cursor c_pay_proposal is
333: select assignment_id, change_date, date_to,last_change_date, approved
334: from per_pay_proposals
335: where pay_proposal_id = p_pay_proposal_id;
336: --
337: cursor c_asg_pay_basis_id(p_assignment_id number, p_date date) is
338: select pay_basis_id

Line 350: l_approved per_pay_proposals.approved%TYPE;

346: l_date_to date;
347: l_last_change_date date;
348: l_curr_pay_basis_id number;
349: l_prev_pay_basis_id number;
350: l_approved per_pay_proposals.approved%TYPE;
351: --
352: begin
353: --
354:

Line 390: update per_pay_proposals

386: end if;
387: /* changed to adjust the date_to after deletion of a proposal. Bug#7386307 by schowdhu */
388: if (l_approved = 'N') then
389:
390: update per_pay_proposals
391: set date_to = l_date_to,
392: -- added by vkodedal fix for 6831216
393: last_update_date = sysdate,
394: last_updated_by = fnd_global.user_id,

Line 404: update per_pay_proposals

400: end if;
401:
402: if (l_approved = 'Y') then
403:
404: update per_pay_proposals
405: set date_to = l_date_to,
406: last_update_date = sysdate,
407: last_updated_by = fnd_global.user_id,
408: last_update_login = fnd_global.login_id

Line 412: from per_pay_proposals

408: last_update_login = fnd_global.login_id
409: where assignment_id = l_assignment_id
410: and approved = 'Y'
411: and change_date = ( select max(change_date)
412: from per_pay_proposals
413: where assignment_id = l_assignment_id
414: and change_date < l_deleted_proposal_date
415: and approved = 'Y' );
416:

Line 419: update per_pay_proposals

415: and approved = 'Y' );
416:
417: end if;
418: /*
419: update per_pay_proposals
420: set last_change_date = l_last_change_date
421: where assignment_id = l_assignment_id
422: and change_date =
423: (select min(t.change_date)

Line 424: from per_pay_proposals t

420: set last_change_date = l_last_change_date
421: where assignment_id = l_assignment_id
422: and change_date =
423: (select min(t.change_date)
424: from per_pay_proposals t
425: where t.assignment_id = l_assignment_id
426: and t.change_date > l_deleted_proposal_date
427: );
428: */

Line 503: l_next_change_date per_pay_proposals.change_date%TYPE;

499: l_dummy_v varchar2(300);
500: l_entry_value2 NUMBER;
501: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
502: l_payroll_value VARCHAR2(80);
503: l_next_change_date per_pay_proposals.change_date%TYPE;
504: l_Entry_End_Date pay_element_entries_f.effective_end_date%TYPE;
505: l_pay_basis per_pay_bases.pay_basis%TYPE;
506: --
507: --

Line 572: from per_pay_proposals

568: --
569: Cursor get_next_approved_change_date
570: IS
571: select min(change_date)
572: from per_pay_proposals
573: where assignment_id = p_assignment_id
574: and change_date > p_change_date;
575:
576: Cursor csr_element_entries

Line 602: per_pay_proposals_populate.get_payroll(p_assignment_id

598: hr_utility.set_message(801,'HR_289855_SAL_ASS_NOT_SAL_ELIG');
599: hr_utility.raise_error;
600: else
601: close csr_get_element_detail;
602: per_pay_proposals_populate.get_payroll(p_assignment_id
603: ,p_change_date
604: ,l_dummy_v
605: ,l_payroll_annualization_factor);
606: --

Line 705: UPDATE per_pay_proposals

701: CLOSE get_last_date;
702:
703: IF l_date_to > l_last_date THEN
704:
705: UPDATE per_pay_proposals
706: SET date_to = l_last_date
707: WHERE pay_proposal_id = p_pay_proposal_id;
708:
709: l_date_to := l_last_date;

Line 810: from per_pay_proposals

806:
807: Cursor next_change_date(p_change_date DATE)
808: IS
809: select min(change_date)
810: from per_pay_proposals
811: where assignment_id = p_assignment_id
812: and change_date > p_change_date
813: and approved = p_approved;
814:

Line 816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

812: and change_date > p_change_date
813: and approved = p_approved;
814:
815: l_proc varchar2(72) := g_package||'insert_salary_proposal';
816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;

Line 817: l_change_date per_pay_proposals.change_date%TYPE;

813: and approved = p_approved;
814:
815: l_proc varchar2(72) := g_package||'insert_salary_proposal';
816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;
821: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

Line 818: l_date_to per_pay_proposals.date_to%TYPE;

814:
815: l_proc varchar2(72) := g_package||'insert_salary_proposal';
816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;
821: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
822: l_inv_next_sal_date_warning boolean;

Line 819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;

815: l_proc varchar2(72) := g_package||'insert_salary_proposal';
816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;
821: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
822: l_inv_next_sal_date_warning boolean;
823: l_proposed_salary_warning boolean;

Line 820: l_object_version_number per_pay_proposals.object_version_number%TYPE;

816: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
817: l_change_date per_pay_proposals.change_date%TYPE;
818: l_date_to per_pay_proposals.date_to%TYPE;
819: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
820: l_object_version_number per_pay_proposals.object_version_number%TYPE;
821: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
822: l_inv_next_sal_date_warning boolean;
823: l_proposed_salary_warning boolean;
824: l_approved_warning boolean;

Line 828: l_next_change_date per_pay_proposals.change_date%TYPE;

824: l_approved_warning boolean;
825: l_payroll_warning boolean;
826: l_temp_element_entry_id number := p_element_entry_id;
827: l_payroll_value number;
828: l_next_change_date per_pay_proposals.change_date%TYPE;
829:
830: --
831: --
832: begin

Line 1003: per_pay_proposals_populate.GET_ELEMENT_ID(p_assignment_id => p_assignment_id,

999: -- Added by ggnanagu
1000: -- To get the element entry id, if its passed as null
1001: --
1002: if l_element_entry_id is null then
1003: per_pay_proposals_populate.GET_ELEMENT_ID(p_assignment_id => p_assignment_id,
1004: p_business_group_id => p_business_group_id,
1005: p_change_date => p_change_date,
1006: p_payroll_value => l_payroll_value,
1007: p_element_entry_id => l_element_entry_id);

Line 1284: l_change_date per_pay_proposals.change_date%TYPE;

1280: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1281: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1282: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;

Line 1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;

1281: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1282: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1289: l_inv_next_sal_date_warning boolean;

Line 1286: l_next_change_date per_pay_proposals.change_date%TYPE;

1282: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1289: l_inv_next_sal_date_warning boolean;
1290: l_proposed_salary_warning boolean;

Line 1287: l_date_to per_pay_proposals.date_to%TYPE;

1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1289: l_inv_next_sal_date_warning boolean;
1290: l_proposed_salary_warning boolean;
1291: l_approved_warning boolean;

Line 1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;

1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
1286: l_next_change_date per_pay_proposals.change_date%TYPE;
1287: l_date_to per_pay_proposals.date_to%TYPE;
1288: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1289: l_inv_next_sal_date_warning boolean;
1290: l_proposed_salary_warning boolean;
1291: l_approved_warning boolean;
1292: l_payroll_warning boolean;

Line 1293: l_assignment_id per_pay_proposals.assignment_id%TYPE;

1289: l_inv_next_sal_date_warning boolean;
1290: l_proposed_salary_warning boolean;
1291: l_approved_warning boolean;
1292: l_payroll_warning boolean;
1293: l_assignment_id per_pay_proposals.assignment_id%TYPE;
1294: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;
1295: l_temp_ovn number := p_object_version_number;
1296: --
1297: --

Line 1294: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;

1290: l_proposed_salary_warning boolean;
1291: l_approved_warning boolean;
1292: l_payroll_warning boolean;
1293: l_assignment_id per_pay_proposals.assignment_id%TYPE;
1294: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;
1295: l_temp_ovn number := p_object_version_number;
1296: --
1297: --
1298:

Line 1302: from per_pay_proposals

1298:
1299: Cursor get_assignment_id
1300: is
1301: select assignment_id
1302: from per_pay_proposals
1303: where pay_proposal_id = p_pay_proposal_id;
1304:
1305: cursor get_element IS
1306: select pee.element_entry_id

Line 1309: , per_pay_proposals pyp

1305: cursor get_element IS
1306: select pee.element_entry_id
1307: , pyp.assignment_id
1308: from pay_element_entries_f pee
1309: , per_pay_proposals pyp
1310: where pyp.pay_proposal_id=p_pay_proposal_id
1311: and pee.assignment_id=pyp.assignment_id
1312: and NVL(l_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
1313: pee.effective_start_date and pee.effective_end_date

Line 1323: from per_pay_proposals pro

1319:
1320: Cursor next_change_date(p_change_date DATE)
1321: IS
1322: select min(change_date)
1323: from per_pay_proposals pro
1324: where assignment_id = l_assignment_id
1325: and change_date > p_change_date
1326: and approved = p_approved;
1327:

Line 1519: from per_pay_proposals pyp

1515: hr_utility.set_location(l_proc,25);
1516: l_element_entry_id := null;
1517: select pyp.assignment_id
1518: into l_assignment_id
1519: from per_pay_proposals pyp
1520: where pyp.pay_proposal_id=p_pay_proposal_id;
1521: if p_proposed_salary_n = hr_api.g_number then
1522: l_proposed_salary_n:=per_pyp_shd.g_old_rec.proposed_salary_n;
1523: else

Line 1691: from per_pay_proposals

1687: --
1688: Cursor csr_date_to
1689: IS
1690: select date_to
1691: from per_pay_proposals
1692: where pay_proposal_id = p_pay_proposal_id;
1693:
1694: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;
1695:

Line 1694: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;

1690: select date_to
1691: from per_pay_proposals
1692: where pay_proposal_id = p_pay_proposal_id;
1693:
1694: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;
1695:
1696: begin
1697:
1698: OPEN csr_date_to;

Line 1763: l_change_date per_pay_proposals.change_date%TYPE;

1759: p_payroll_warning out nocopy boolean,
1760: p_error_text out nocopy varchar2) is
1761: --
1762: l_proc varchar2(72) := g_package||'approve_salary_proposal';
1763: l_change_date per_pay_proposals.change_date%TYPE;
1764: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1765: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1766: l_inv_next_sal_date_warning boolean;
1767: l_proposed_salary_warning boolean;

Line 1764: l_object_version_number per_pay_proposals.object_version_number%TYPE;

1760: p_error_text out nocopy varchar2) is
1761: --
1762: l_proc varchar2(72) := g_package||'approve_salary_proposal';
1763: l_change_date per_pay_proposals.change_date%TYPE;
1764: l_object_version_number per_pay_proposals.object_version_number%TYPE;
1765: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1766: l_inv_next_sal_date_warning boolean;
1767: l_proposed_salary_warning boolean;
1768: l_approved_warning boolean;

Line 1771: l_assignment_id per_pay_proposals.assignment_id%type;

1767: l_proposed_salary_warning boolean;
1768: l_approved_warning boolean;
1769: l_payroll_warning boolean;
1770: l_error_text varchar2(72);
1771: l_assignment_id per_pay_proposals.assignment_id%type;
1772: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;
1773: l_date_to per_pay_proposals.date_to%TYPE;
1774: l_temp_ovn number := p_object_version_number;
1775: --

Line 1772: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;

1768: l_approved_warning boolean;
1769: l_payroll_warning boolean;
1770: l_error_text varchar2(72);
1771: l_assignment_id per_pay_proposals.assignment_id%type;
1772: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;
1773: l_date_to per_pay_proposals.date_to%TYPE;
1774: l_temp_ovn number := p_object_version_number;
1775: --
1776: --

Line 1773: l_date_to per_pay_proposals.date_to%TYPE;

1769: l_payroll_warning boolean;
1770: l_error_text varchar2(72);
1771: l_assignment_id per_pay_proposals.assignment_id%type;
1772: l_proposed_salary_n per_pay_proposals.proposed_salary_n%TYPE;
1773: l_date_to per_pay_proposals.date_to%TYPE;
1774: l_temp_ovn number := p_object_version_number;
1775: --
1776: --
1777: -- cursor get_element IS

Line 1781: -- , per_pay_proposals pyp

1777: -- cursor get_element IS
1778: -- select pee.element_entry_id
1779: -- , pyp.assignment_id
1780: -- from pay_element_entries_f pee
1781: -- , per_pay_proposals pyp
1782: -- where pyp.pay_proposal_id=p_pay_proposal_id
1783: -- and pee.assignment_id=pyp.assignment_id
1784: -- and NVL(l_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
1785: -- pee.effective_start_date and pee.effective_end_date

Line 1801: from per_pay_proposals

1797:
1798: cursor csr_get_date_to
1799: is
1800: select date_to
1801: from per_pay_proposals
1802: where pay_proposal_id = p_pay_proposal_id;
1803:
1804: begin
1805: hr_utility.set_location('Entering:'||l_proc,5);

Line 2010: l_approved per_pay_proposals.approved%TYPE;

2006: l_change_date date;
2007: v_zap_entry boolean;
2008: v_delete_next_change boolean;
2009: v_zap VARCHAR2(1):='N';
2010: l_approved per_pay_proposals.approved%TYPE;
2011: l_future_element_entries number;
2012: l_assignment_id number;
2013: l_last_change_date date;
2014: --

Line 2025: from per_pay_proposals_v2 pro

2021:
2022: cursor elements is
2023: select pee.element_entry_id
2024: , pro.change_date
2025: from per_pay_proposals_v2 pro
2026: , pay_element_entries_f pee
2027: where pro.pay_proposal_id=p_pay_proposal_id
2028: and pro.assignment_id=pee.assignment_id
2029: and pee.creator_type='SP'

Line 2044: from per_pay_proposals

2040:
2041: Cursor csr_proposal_details
2042: IS
2043: select approved, last_change_date, assignment_id
2044: from per_pay_proposals
2045: where pay_proposal_id = p_pay_proposal_id;
2046:
2047:
2048: begin

Line 2840: select 1 from per_pay_proposals

2836: l_temp_ovn number := p_object_version_number;
2837: l_temp_pay_proposal_id number := p_pay_proposal_id;
2838: --
2839: cursor first_proposal is
2840: select 1 from per_pay_proposals
2841: where assignment_id=p_assignment_id;
2842: --
2843: cursor asg_type is
2844: select asg.assignment_type

Line 3155: from per_pay_proposals

3151:
3152: Cursor csr_date_to
3153: IS
3154: select date_to
3155: from per_pay_proposals
3156: where pay_proposal_id = p_pay_proposal_id;
3157:
3158: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;
3159:

Line 3158: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;

3154: select date_to
3155: from per_pay_proposals
3156: where pay_proposal_id = p_pay_proposal_id;
3157:
3158: l_date_to PER_PAY_PROPOSALS.date_to%TYPE default null;
3159:
3160: begin
3161:
3162: if p_pay_proposal_id is not null then

Line 3237: from per_pay_proposals

3233: --
3234: cursor c_del_salary_proposals( p_assignment_id in number
3235: ,p_date in date) is
3236: select pay_proposal_id, business_group_id, object_version_number
3237: from per_pay_proposals
3238: where assignment_id = p_assignment_id
3239: and change_date <
3240: (select max(change_date)
3241: from per_pay_proposals

Line 3241: from per_pay_proposals

3237: from per_pay_proposals
3238: where assignment_id = p_assignment_id
3239: and change_date <
3240: (select max(change_date)
3241: from per_pay_proposals
3242: where assignment_id = p_assignment_id
3243: and change_date <= p_date
3244: );
3245: --

Line 3289: delete per_pay_proposals

3285: where PAY_PROPOSAL_ID = r_del_sp.pay_proposal_id;
3286: --
3287: -- Delete Salary Proposal
3288: --
3289: delete per_pay_proposals
3290: where pay_proposal_id = r_del_sp.pay_proposal_id;
3291: --
3292: hr_utility.set_location(l_proc,25);
3293: --