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_UPLOAD_PROPOSAL_API dependencies on PER_PAY_PROPOSALS

Line 40: from per_pay_proposals

36: ,p_change_date in date) is
37:
38: cursor csr_next_proposal is
39: select pay_proposal_id, rowid
40: from per_pay_proposals
41: where assignment_id = p_assignment_id
42: and change_date=(
43: select min(change_date)
44: from per_pay_proposals

Line 44: from per_pay_proposals

40: from per_pay_proposals
41: where assignment_id = p_assignment_id
42: and change_date=(
43: select min(change_date)
44: from per_pay_proposals
45: where assignment_id = p_assignment_id
46: and change_date > p_change_date);
47:
48: l_last_change_date per_pay_proposals.last_change_date%TYPE;

Line 48: l_last_change_date per_pay_proposals.last_change_date%TYPE;

44: from per_pay_proposals
45: where assignment_id = p_assignment_id
46: and change_date > p_change_date);
47:
48: l_last_change_date per_pay_proposals.last_change_date%TYPE;
49: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
50: l_row_id rowid;
51: l_proc varchar2(30):= 'update_last_change_date';
52:

Line 49: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

45: where assignment_id = p_assignment_id
46: and change_date > p_change_date);
47:
48: l_last_change_date per_pay_proposals.last_change_date%TYPE;
49: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
50: l_row_id rowid;
51: l_proc varchar2(30):= 'update_last_change_date';
52:
53: begin

Line 69: update per_pay_proposals

65:
66: if csr_next_proposal%FOUND then
67: hr_utility.set_location('Cursor found:',25);
68:
69: update per_pay_proposals
70: set last_change_date = l_last_change_date
71: where rowid=l_row_id;
72: hr_utility.set_location('Updated successfuly:',35);
73: end if;

Line 108: from per_pay_proposals

104:
105: Cursor csr_prev_prop_details
106: is
107: select pay_proposal_id,date_to
108: from per_pay_proposals
109: where assignment_id = p_assignment_id
110: and change_date =(select max(change_date)
111: from per_pay_proposals
112: where assignment_id = p_assignment_id

Line 111: from per_pay_proposals

107: select pay_proposal_id,date_to
108: from per_pay_proposals
109: where assignment_id = p_assignment_id
110: and change_date =(select max(change_date)
111: from per_pay_proposals
112: where assignment_id = p_assignment_id
113: and change_date < p_date_to+1 and approved = 'N');
114:
115: l_date_to per_pay_proposals.date_to%TYPE;

Line 115: l_date_to per_pay_proposals.date_to%TYPE;

111: from per_pay_proposals
112: where assignment_id = p_assignment_id
113: and change_date < p_date_to+1 and approved = 'N');
114:
115: l_date_to per_pay_proposals.date_to%TYPE;
116: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
117: l_proc varchar2(30):= 'end_date_proposed_proposal';
118:
119: begin

Line 116: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

112: where assignment_id = p_assignment_id
113: and change_date < p_date_to+1 and approved = 'N');
114:
115: l_date_to per_pay_proposals.date_to%TYPE;
116: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
117: l_proc varchar2(30):= 'end_date_proposed_proposal';
118:
119: begin
120:

Line 135: update per_pay_proposals

131: if csr_prev_prop_details%FOUND then
132: hr_utility.set_location('Cursor found:',35);
133: if l_date_to is null OR l_date_to > p_date_to then
134: hr_utility.set_location('About to update',45);
135: update per_pay_proposals
136: set date_to = p_date_to,
137: -- added by vkodedal fix for 6831216
138: last_update_date = sysdate,
139: last_updated_by = fnd_global.user_id,

Line 174: from per_pay_proposals

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

Line 177: from per_pay_proposals

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

Line 187: from per_pay_proposals

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

Line 194: l_date_to per_pay_proposals.date_to%TYPE;

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

Line 195: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

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

Line 197: l_change_date per_pay_proposals.change_date%TYPE;

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

Line 213: update per_pay_proposals

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

Line 258: from per_pay_proposals

254: /*
255: Cursor csr_prev_prop_details
256: is
257: select pay_proposal_id,date_to
258: from per_pay_proposals
259: where assignment_id = p_assignment_id
260: and change_date =(select max(change_date)
261: from per_pay_proposals
262: where assignment_id = p_assignment_id

Line 261: from per_pay_proposals

257: select pay_proposal_id,date_to
258: from per_pay_proposals
259: where assignment_id = p_assignment_id
260: and change_date =(select max(change_date)
261: from per_pay_proposals
262: where assignment_id = p_assignment_id
263: and change_date < p_date_to+1);
264:
265: l_date_to per_pay_proposals.date_to%TYPE;

Line 265: l_date_to per_pay_proposals.date_to%TYPE;

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

Line 266: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

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

Line 269: l_approved per_pay_proposals.approved%TYPE;

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

Line 275: from per_pay_proposals

271: -- changed by schowdhu for 7673294 05-jan-08
272: Cursor chk_approved_flg
273: is
274: select approved
275: from per_pay_proposals
276: where pay_proposal_id = nvl(p_proposal_id, pay_proposal_id)
277: and assignment_id = p_assignment_id
278: and change_date = p_date_to +1 ;
279: begin

Line 296: update per_pay_proposals

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

Line 686: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

682: l_inv_next_perf_date_warning boolean;
683: l_approved_warning boolean;
684: l_payroll_warning boolean;
685: l_proposed_salary_warning boolean;
686: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
687: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
688: l_object_version_number per_pay_proposals.object_version_number%TYPE;
689: l_pyp_proposed_sal_warning boolean;
690: l_additional_comp_warning boolean;

Line 687: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

683: l_approved_warning boolean;
684: l_payroll_warning boolean;
685: l_proposed_salary_warning boolean;
686: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
687: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
688: l_object_version_number per_pay_proposals.object_version_number%TYPE;
689: l_pyp_proposed_sal_warning boolean;
690: l_additional_comp_warning boolean;
691: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal

Line 688: l_object_version_number per_pay_proposals.object_version_number%TYPE;

684: l_payroll_warning boolean;
685: l_proposed_salary_warning boolean;
686: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
687: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
688: l_object_version_number per_pay_proposals.object_version_number%TYPE;
689: l_pyp_proposed_sal_warning boolean;
690: l_additional_comp_warning boolean;
691: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal
692: l_approved VARCHAR2(1);

Line 695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

691: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal
692: l_approved VARCHAR2(1);
693: --
694: --
695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;

Line 696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;

692: l_approved VARCHAR2(1);
693: --
694: --
695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;

Line 697: l_change_date per_pay_proposals.change_date%TYPE;

693: --
694: --
695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number

Line 698: l_multiple_components per_pay_proposals.multiple_components%TYPE;

694: --
695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;

Line 699: l_pyp_approved per_pay_proposals.approved%TYPE;

695: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;
703: --

Line 700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;

696: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
697: l_change_date per_pay_proposals.change_date%TYPE;
698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;
703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;

Line 702: per_pay_proposals.object_version_number%TYPE;

698: l_multiple_components per_pay_proposals.multiple_components%TYPE;
699: l_pyp_approved per_pay_proposals.approved%TYPE;
700: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
701: l_pyp_object_version_number
702: per_pay_proposals.object_version_number%TYPE;
703: --
704: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
705: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
706: l_component_reason per_pay_proposal_components.component_reason%TYPE;

Line 723: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=

719: l_total_component_sum number (20,6):=0;
720: l_comp_update boolean := false;
721: l_prop_update boolean := false;
722: --
723: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=
724: p_pay_proposal_id;
725: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
726: p_object_version_number;
727: --

Line 725: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=

721: l_prop_update boolean := false;
722: --
723: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=
724: p_pay_proposal_id;
725: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
726: p_object_version_number;
727: --
728: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
729: p_component_id_1;

Line 801: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;

797: lt_component_id_9 number := p_component_id_9;
798: lt_ppc_ovn_9 number := p_ppc_object_version_number_9;
799: lt_component_id_10 number := p_component_id_10;
800: lt_ppc_ovn_10 number := p_ppc_object_version_number_10;
801: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;
802: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;
803: --
804: -- plsql table types
805: --

Line 802: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;

798: lt_ppc_ovn_9 number := p_ppc_object_version_number_9;
799: lt_component_id_10 number := p_component_id_10;
800: lt_ppc_ovn_10 number := p_ppc_object_version_number_10;
801: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;
802: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;
803: --
804: -- plsql table types
805: --
806: l_comp_reason_table t_of_char;

Line 815: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;

811: l_change_percentage_table t_of_number2;
812: --
813: -- elements
814: --
815: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
816:
817: l_element_type_id pay_element_types_f.element_type_id%TYPE;
818: l_input_value_id pay_input_values_f.input_value_id%TYPE;
819: l_element_link_id pay_element_links_f.element_link_id%TYPE;

Line 831: (c_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE) is

827: -- For example, if a user has more than ten components then this
828: -- business process processes the first 10 and add any additionals as well.
829: --
830: cursor csr_sum_of_components
831: (c_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE) is
832: select sum(change_amount_n)
833: from per_pay_proposal_components
834: where pay_proposal_id = c_pay_proposal_id;
835:

Line 866: from per_pay_proposals

862: -- cursor to get the last_proposed_salary which has been approved.
863: --
864: cursor csr_get_last_approved_salary is
865: select proposed_salary_n
866: from per_pay_proposals
867: where assignment_id = p_assignment_id
868: and change_date < l_trunc_date
869: order by change_date desc;
870: --

Line 880: from per_pay_proposals

876: multiple_components,
877: approved,
878: proposal_reason,
879: object_version_number
880: from per_pay_proposals
881: where assignment_id = p_assignment_id
882: and pay_proposal_id = p_pay_proposal_id
883: and business_group_id = p_business_group_id;
884: --

Line 903: from per_pay_proposals

899: -- included p_change_date as input param
900: Cursor next_change_date(p_change_date DATE)
901: IS
902: select min(change_date)
903: from per_pay_proposals
904: where assignment_id = p_assignment_id
905: and change_date > p_change_date;
906:
907: begin

Line 1446: -- per_pay_proposals table using the row_handler

1442: l_next_sal_review_date := null;
1443: end if;
1444:
1445: -- insert an unapproved single component salary proposal record in
1446: -- per_pay_proposals table using the row_handler
1447: --
1448: end_date_salary_proposal(p_assignment_id => p_assignment_id
1449: ,p_date_to => p_change_date-1);
1450: ----------vkodedal 7-mar-07