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

Line 358: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

354: Change made by abhshriv
355: */
356:
357: procedure chk_assignment_id_change_date
358: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
361: ,p_change_date in per_pay_proposals.change_date%TYPE
362: ,p_payroll_warning out nocopy boolean

Line 359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE

355: */
356:
357: procedure chk_assignment_id_change_date
358: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
361: ,p_change_date in per_pay_proposals.change_date%TYPE
362: ,p_payroll_warning out nocopy boolean
363: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

Line 360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE

356:
357: procedure chk_assignment_id_change_date
358: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
361: ,p_change_date in per_pay_proposals.change_date%TYPE
362: ,p_payroll_warning out nocopy boolean
363: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
364: )

Line 361: ,p_change_date in per_pay_proposals.change_date%TYPE

357: procedure chk_assignment_id_change_date
358: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
361: ,p_change_date in per_pay_proposals.change_date%TYPE
362: ,p_payroll_warning out nocopy boolean
363: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
364: )
365: is

Line 363: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

359: ,p_business_group_id in per_pay_proposals.business_group_id%TYPE
360: ,p_assignment_id in per_pay_proposals.assignment_id%TYPE
361: ,p_change_date in per_pay_proposals.change_date%TYPE
362: ,p_payroll_warning out nocopy boolean
363: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
364: )
365: is
366: --
367: l_exists varchar2(1);

Line 369: l_change_date per_pay_proposals.change_date%TYPE;

365: is
366: --
367: l_exists varchar2(1);
368: l_proc varchar2(72) := g_package||'chk_assignment_id_change_date';
369: l_change_date per_pay_proposals.change_date%TYPE;
370:
371: --
372: -- Cursor to check the latest proposal change_date for the assignment.
373: --

Line 376: from per_pay_proposals

372: -- Cursor to check the latest proposal change_date for the assignment.
373: --
374: cursor csr_last_change_date is
375: select max(change_date)
376: from per_pay_proposals
377: where assignment_id = p_assignment_id
378: and business_group_id + 0 = p_business_group_id
379: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
380: --

Line 385: from per_pay_proposals

381: -- Cursor to check whether other proposals exist.
382: --
383: Cursor csr_other_proposals_exist is
384: select null
385: from per_pay_proposals
386: where assignment_id = p_assignment_id
387: and approved = 'N'
388: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
389: --

Line 451: (p_assignment_id in per_pay_proposals.assignment_id%TYPE

447: Change made by abhshriv
448: */
449:
450: procedure chk_pay_basis_change_date
451: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
452: ,p_change_date in per_pay_proposals.change_date%TYPE
453: ) is
454: --
455: -- Cursor to check that whether there are any pay_basis changes after

Line 452: ,p_change_date in per_pay_proposals.change_date%TYPE

448: */
449:
450: procedure chk_pay_basis_change_date
451: (p_assignment_id in per_pay_proposals.assignment_id%TYPE
452: ,p_change_date in per_pay_proposals.change_date%TYPE
453: ) is
454: --
455: -- Cursor to check that whether there are any pay_basis changes after
456: -- the change_date

Line 514: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE

510: This need to be restriced for the old Salary Form.
511: Change made by abhshriv
512: */
513: procedure chk_del_pay_proposal
514: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
515: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
516: ,p_salary_warning out nocopy boolean
517: ) is
518: --

Line 515: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE

511: Change made by abhshriv
512: */
513: procedure chk_del_pay_proposal
514: (p_pay_proposal_id in per_pay_proposals.pay_proposal_id%TYPE
515: ,p_object_version_number in per_pay_proposals.object_version_number%TYPE
516: ,p_salary_warning out nocopy boolean
517: ) is
518: --
519: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';

Line 521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

517: ) is
518: --
519: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
520: l_exists varchar2(1);
521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;

Line 522: l_last_change_date per_pay_proposals.change_date%TYPE;

518: --
519: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
520: l_exists varchar2(1);
521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;

Line 523: l_assignment_id per_pay_proposals.assignment_id%TYPE;

519: l_proc varchar2(72):= g_package||'chk_del_pay_proposal';
520: l_exists varchar2(1);
521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;
527: l_multiple_components per_pay_proposals.multiple_components%TYPE;

Line 524: l_business_group_id per_pay_proposals.business_group_id%TYPE;

520: l_exists varchar2(1);
521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;
527: l_multiple_components per_pay_proposals.multiple_components%TYPE;
528: --

Line 525: l_change_date per_pay_proposals.change_date%TYPE;

521: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;
527: l_multiple_components per_pay_proposals.multiple_components%TYPE;
528: --
529: --

Line 526: l_approved per_pay_proposals.approved%TYPE;

522: l_last_change_date per_pay_proposals.change_date%TYPE;
523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;
527: l_multiple_components per_pay_proposals.multiple_components%TYPE;
528: --
529: --
530: -- Define a cursor to get the proposals change date

Line 527: l_multiple_components per_pay_proposals.multiple_components%TYPE;

523: l_assignment_id per_pay_proposals.assignment_id%TYPE;
524: l_business_group_id per_pay_proposals.business_group_id%TYPE;
525: l_change_date per_pay_proposals.change_date%TYPE;
526: l_approved per_pay_proposals.approved%TYPE;
527: l_multiple_components per_pay_proposals.multiple_components%TYPE;
528: --
529: --
530: -- Define a cursor to get the proposals change date
531: --

Line 535: from per_pay_proposals

531: --
532: cursor csr_get_pro_detail is
533: select assignment_id,business_group_id,change_date,
534: multiple_components,approved
535: from per_pay_proposals
536: where pay_proposal_id = p_pay_proposal_id
537: and object_version_number = p_object_version_number;
538: --
539: -- Define a cursor which gets the latest approved salary_proposal.

Line 543: from per_pay_proposals

539: -- Define a cursor which gets the latest approved salary_proposal.
540: --
541: Cursor csr_is_latest_proposal is
542: select max(change_date)
543: from per_pay_proposals
544: where assignment_id = l_assignment_id;
545: --
546: begin
547: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 557: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');

553: l_change_date,l_multiple_components, l_approved;
554: if csr_get_pro_detail%notfound then
555: close csr_get_pro_detail;
556: hr_utility.set_location(l_proc, 2);
557: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');
558: end if;
559: close csr_get_pro_detail;
560:
561: -- Check that, this is the latest salary proposal

Line 599: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

595: ) is
596: --
597: l_exists varchar2(1);
598: l_proc varchar2(72):= g_package || 'chk_delete_component';
599: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
600: --
601: -- Cursor to check the status of the per_pay-proposal apprved flag.
602: --
603: cursor csr_proposal_status is

Line 605: from per_pay_proposals pro

601: -- Cursor to check the status of the per_pay-proposal apprved flag.
602: --
603: cursor csr_proposal_status is
604: select null
605: from per_pay_proposals pro
606: where pro.pay_proposal_id = l_pay_proposal_id
607: and pro.approved = 'Y';
608: --
609: -- Cursor to check that this component exists for this proposal

Line 792: from per_pay_proposals_v2

788: ,l_error OUT NOCOPY BOOLEAN) IS
789:
790: cursor unaproved IS
791: select null
792: from per_pay_proposals_v2
793: where assignment_id=p_assignment_id
794: and approved='N';
795:
796: l_dummy NUMBER;