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_PPC_BUS dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 196: in per_pay_proposal_components.component_id%TYPE

192: --
193: --
194: procedure chk_pay_proposal_id
195: (p_component_id
196: in per_pay_proposal_components.component_id%TYPE
197: ,p_pay_proposal_id
198: in per_pay_proposal_components.pay_proposal_id%TYPE
199: ,p_business_group_id
200: in per_pay_proposal_components.business_group_id%TYPE

Line 198: in per_pay_proposal_components.pay_proposal_id%TYPE

194: procedure chk_pay_proposal_id
195: (p_component_id
196: in per_pay_proposal_components.component_id%TYPE
197: ,p_pay_proposal_id
198: in per_pay_proposal_components.pay_proposal_id%TYPE
199: ,p_business_group_id
200: in per_pay_proposal_components.business_group_id%TYPE
201: ,p_object_version_number
202: in per_pay_proposal_components.object_version_number%TYPE

Line 200: in per_pay_proposal_components.business_group_id%TYPE

196: in per_pay_proposal_components.component_id%TYPE
197: ,p_pay_proposal_id
198: in per_pay_proposal_components.pay_proposal_id%TYPE
199: ,p_business_group_id
200: in per_pay_proposal_components.business_group_id%TYPE
201: ,p_object_version_number
202: in per_pay_proposal_components.object_version_number%TYPE
203: ,p_validation_strength in varchar2 default 'STRONG')is
204: --

Line 202: in per_pay_proposal_components.object_version_number%TYPE

198: in per_pay_proposal_components.pay_proposal_id%TYPE
199: ,p_business_group_id
200: in per_pay_proposal_components.business_group_id%TYPE
201: ,p_object_version_number
202: in per_pay_proposal_components.object_version_number%TYPE
203: ,p_validation_strength in varchar2 default 'STRONG')is
204: --
205: l_proc varchar2(72) := g_package||'chk_pay_proposal_id';
206: l_exists varchar2(1);

Line 320: in per_pay_proposal_components.component_id%TYPE

316: --
317: --
318: procedure chk_approved
319: (p_component_id
320: in per_pay_proposal_components.component_id%TYPE
321: ,p_approved
322: in per_pay_proposal_components.approved%TYPE
323: ,p_component_reason
324: in per_pay_proposal_components.component_reason%TYPE

Line 322: in per_pay_proposal_components.approved%TYPE

318: procedure chk_approved
319: (p_component_id
320: in per_pay_proposal_components.component_id%TYPE
321: ,p_approved
322: in per_pay_proposal_components.approved%TYPE
323: ,p_component_reason
324: in per_pay_proposal_components.component_reason%TYPE
325: ,p_change_amount_n
326: in per_pay_proposal_components.change_amount_n%TYPE

Line 324: in per_pay_proposal_components.component_reason%TYPE

320: in per_pay_proposal_components.component_id%TYPE
321: ,p_approved
322: in per_pay_proposal_components.approved%TYPE
323: ,p_component_reason
324: in per_pay_proposal_components.component_reason%TYPE
325: ,p_change_amount_n
326: in per_pay_proposal_components.change_amount_n%TYPE
327: ,p_change_percentage
328: in per_pay_proposal_components.change_percentage%TYPE

Line 326: in per_pay_proposal_components.change_amount_n%TYPE

322: in per_pay_proposal_components.approved%TYPE
323: ,p_component_reason
324: in per_pay_proposal_components.component_reason%TYPE
325: ,p_change_amount_n
326: in per_pay_proposal_components.change_amount_n%TYPE
327: ,p_change_percentage
328: in per_pay_proposal_components.change_percentage%TYPE
329: ,p_object_version_number
330: in per_pay_proposal_components.object_version_number%TYPE

Line 328: in per_pay_proposal_components.change_percentage%TYPE

324: in per_pay_proposal_components.component_reason%TYPE
325: ,p_change_amount_n
326: in per_pay_proposal_components.change_amount_n%TYPE
327: ,p_change_percentage
328: in per_pay_proposal_components.change_percentage%TYPE
329: ,p_object_version_number
330: in per_pay_proposal_components.object_version_number%TYPE
331: ) is
332: --

Line 330: in per_pay_proposal_components.object_version_number%TYPE

326: in per_pay_proposal_components.change_amount_n%TYPE
327: ,p_change_percentage
328: in per_pay_proposal_components.change_percentage%TYPE
329: ,p_object_version_number
330: in per_pay_proposal_components.object_version_number%TYPE
331: ) is
332: --
333: l_proc varchar2(72):= g_package||'chk_approved';
334: l_exists varchar2(1);

Line 439: (p_component_id in per_pay_proposal_components.component_id%TYPE

435: -- Internal Table Handler Use Only.
436: --
437: --
438: procedure chk_component_reason
439: (p_component_id in per_pay_proposal_components.component_id%TYPE
440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE
441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE
442: ,p_approved in per_pay_proposal_components.approved%TYPE
443: ,p_object_version_number

Line 440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE

436: --
437: --
438: procedure chk_component_reason
439: (p_component_id in per_pay_proposal_components.component_id%TYPE
440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE
441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE
442: ,p_approved in per_pay_proposal_components.approved%TYPE
443: ,p_object_version_number
444: in per_pay_proposal_components.object_version_number%TYPE

Line 441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE

437: --
438: procedure chk_component_reason
439: (p_component_id in per_pay_proposal_components.component_id%TYPE
440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE
441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE
442: ,p_approved in per_pay_proposal_components.approved%TYPE
443: ,p_object_version_number
444: in per_pay_proposal_components.object_version_number%TYPE
445: )

Line 442: ,p_approved in per_pay_proposal_components.approved%TYPE

438: procedure chk_component_reason
439: (p_component_id in per_pay_proposal_components.component_id%TYPE
440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE
441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE
442: ,p_approved in per_pay_proposal_components.approved%TYPE
443: ,p_object_version_number
444: in per_pay_proposal_components.object_version_number%TYPE
445: )
446: is

Line 444: in per_pay_proposal_components.object_version_number%TYPE

440: ,p_pay_proposal_id in per_pay_proposal_components.pay_proposal_id%TYPE
441: ,p_component_reason in per_pay_proposal_components.component_reason%TYPE
442: ,p_approved in per_pay_proposal_components.approved%TYPE
443: ,p_object_version_number
444: in per_pay_proposal_components.object_version_number%TYPE
445: )
446: is
447: --
448: l_proc varchar2(72):= g_package||'chk_component_reason';

Line 458: from per_pay_proposal_components ppc

454: -- Cursor to check that the component reason is unique.
455: --
456: cursor csr_unique_comp_reason is
457: select null
458: from per_pay_proposal_components ppc
459: where ppc.pay_proposal_id = p_pay_proposal_id
460: and ppc.component_reason = p_component_reason;
461: --
462: --

Line 621: in per_pay_proposal_components.component_id%TYPE

617: --
618: --
619: procedure chk_change_amount_percentage
620: (p_component_id
621: in per_pay_proposal_components.component_id%TYPE
622: ,p_pay_proposal_id
623: in per_pay_proposal_components.pay_proposal_id%TYPE
624: ,p_change_amount_n
625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE

Line 623: in per_pay_proposal_components.pay_proposal_id%TYPE

619: procedure chk_change_amount_percentage
620: (p_component_id
621: in per_pay_proposal_components.component_id%TYPE
622: ,p_pay_proposal_id
623: in per_pay_proposal_components.pay_proposal_id%TYPE
624: ,p_change_amount_n
625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE
626: ,p_change_percentage
627: in out nocopy per_pay_proposal_components.change_percentage%TYPE

Line 625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE

621: in per_pay_proposal_components.component_id%TYPE
622: ,p_pay_proposal_id
623: in per_pay_proposal_components.pay_proposal_id%TYPE
624: ,p_change_amount_n
625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE
626: ,p_change_percentage
627: in out nocopy per_pay_proposal_components.change_percentage%TYPE
628: ,p_approved
629: in per_pay_proposal_components.approved%TYPE

Line 627: in out nocopy per_pay_proposal_components.change_percentage%TYPE

623: in per_pay_proposal_components.pay_proposal_id%TYPE
624: ,p_change_amount_n
625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE
626: ,p_change_percentage
627: in out nocopy per_pay_proposal_components.change_percentage%TYPE
628: ,p_approved
629: in per_pay_proposal_components.approved%TYPE
630: ,p_object_version_number
631: in per_pay_proposal_components.object_version_number%TYPE

Line 629: in per_pay_proposal_components.approved%TYPE

625: in out nocopy per_pay_proposal_components.change_amount_n%TYPE
626: ,p_change_percentage
627: in out nocopy per_pay_proposal_components.change_percentage%TYPE
628: ,p_approved
629: in per_pay_proposal_components.approved%TYPE
630: ,p_object_version_number
631: in per_pay_proposal_components.object_version_number%TYPE
632: )
633: is

Line 631: in per_pay_proposal_components.object_version_number%TYPE

627: in out nocopy per_pay_proposal_components.change_percentage%TYPE
628: ,p_approved
629: in per_pay_proposal_components.approved%TYPE
630: ,p_object_version_number
631: in per_pay_proposal_components.object_version_number%TYPE
632: )
633: is
634: --
635: l_exists varchar2(1);

Line 639: per_pay_proposal_components.change_amount_n%TYPE;

635: l_exists varchar2(1);
636: l_api_updating boolean;
637: l_proposed_salary number;
638: l_change_amount_n
639: per_pay_proposal_components.change_amount_n%TYPE;
640: l_change_percentage
641: per_pay_proposal_components.change_percentage%TYPE;
642: l_date per_pay_proposals.change_date%TYPE;
643: l_assignment_id number;

Line 641: per_pay_proposal_components.change_percentage%TYPE;

637: l_proposed_salary number;
638: l_change_amount_n
639: per_pay_proposal_components.change_amount_n%TYPE;
640: l_change_percentage
641: per_pay_proposal_components.change_percentage%TYPE;
642: l_date per_pay_proposals.change_date%TYPE;
643: l_assignment_id number;
644: l_business_group_id number;
645: l_change_date date;

Line 885: in per_pay_proposal_components.component_id%TYPE

881: --
882: --
883: procedure chk_delete_component
884: (p_component_id
885: in per_pay_proposal_components.component_id%TYPE
886: ) is
887: --
888: l_exists varchar2(1);
889: l_proc varchar2(72):= g_package || 'chk_delete_component';

Line 904: from per_pay_proposal_components comp

900: -- Cursor to check that this component exists for this proposal
901: --
902: Cursor csr_comp_exists is
903: select pay_proposal_id
904: from per_pay_proposal_components comp
905: where comp.component_id = p_component_id;
906: --
907: --
908: begin

Line 1037: ,p_descflex_name => 'PER_PAY_PROPOSAL_COMPONENTS'

1033: -- b) During insert.
1034: --
1035: hr_dflex_utility.ins_or_upd_descflex_attribs
1036: (p_appl_short_name => 'PER'
1037: ,p_descflex_name => 'PER_PAY_PROPOSAL_COMPONENTS'
1038: ,p_attribute_category => p_rec.attribute_category
1039: ,p_attribute1_name => 'ATTRIBUTE1'
1040: ,p_attribute1_value => p_rec.attribute1
1041: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1350: , per_pay_proposal_components ppc

1346: --
1347: cursor csr_leg_code is
1348: select pbg.legislation_code
1349: from per_business_groups pbg
1350: , per_pay_proposal_components ppc
1351: where ppc.component_id = component_id
1352: and pbg.business_group_id = ppc.business_group_id;
1353: --
1354: -- Declare local variables