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 45: from per_pay_proposals

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

Line 49: from per_pay_proposals

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

Line 53: l_last_change_date per_pay_proposals.last_change_date%TYPE;

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

Line 54: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

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

Line 74: update per_pay_proposals

70:
71: if csr_next_proposal%FOUND then
72: hr_utility.set_location('Cursor found:',25);
73:
74: update per_pay_proposals
75: set last_change_date = l_last_change_date
76: where rowid=l_row_id;
77: hr_utility.set_location('Updated successfuly:',35);
78: end if;

Line 113: from per_pay_proposals

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

Line 116: from per_pay_proposals

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

Line 120: l_date_to per_pay_proposals.date_to%TYPE;

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

Line 121: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

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

Line 140: update per_pay_proposals

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

Line 179: from per_pay_proposals

175:
176: Cursor csr_prev_prop_details
177: is
178: select pay_proposal_id, date_to
179: from per_pay_proposals
180: where assignment_id = p_assignment_id
181: and change_date =(select max(change_date)
182: from per_pay_proposals
183: where assignment_id = p_assignment_id

Line 182: from per_pay_proposals

178: select pay_proposal_id, date_to
179: from per_pay_proposals
180: where assignment_id = p_assignment_id
181: and change_date =(select max(change_date)
182: from per_pay_proposals
183: where assignment_id = p_assignment_id
184: and change_date < p_date_to+1 and approved = 'Y');
185:
186: -- cursor added to find the proposed proposals to be deleted

Line 192: from per_pay_proposals

188:
189: cursor get_all_proposed_proposals
190: is
191: select pay_proposal_id,object_version_number, business_group_id
192: from per_pay_proposals
193: where assignment_id = p_assignment_id
194: --added for the bug 7673294 to exclude the calling proposal
195: and (p_pay_proposal_id IS NULL OR pay_proposal_id <> p_pay_proposal_id)
196: and change_date < p_date_to+1

Line 199: l_date_to per_pay_proposals.date_to%TYPE;

195: and (p_pay_proposal_id IS NULL OR pay_proposal_id <> p_pay_proposal_id)
196: and change_date < p_date_to+1
197: and approved = 'N';
198:
199: l_date_to per_pay_proposals.date_to%TYPE;
200: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
201: l_proc varchar2(30):= 'end_date_approved_proposal';
202: l_change_date per_pay_proposals.change_date%TYPE;
203: l_del_warn boolean;

Line 200: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

196: and change_date < p_date_to+1
197: and approved = 'N';
198:
199: l_date_to per_pay_proposals.date_to%TYPE;
200: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
201: l_proc varchar2(30):= 'end_date_approved_proposal';
202: l_change_date per_pay_proposals.change_date%TYPE;
203: l_del_warn boolean;
204:

Line 202: l_change_date per_pay_proposals.change_date%TYPE;

198:
199: l_date_to per_pay_proposals.date_to%TYPE;
200: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
201: l_proc varchar2(30):= 'end_date_approved_proposal';
202: l_change_date per_pay_proposals.change_date%TYPE;
203: l_del_warn boolean;
204:
205: begin
206:

Line 218: update per_pay_proposals

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

Line 263: from per_pay_proposals

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

Line 266: from per_pay_proposals

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

Line 270: l_date_to per_pay_proposals.date_to%TYPE;

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

Line 271: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

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

Line 274: l_approved per_pay_proposals.approved%TYPE;

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

Line 280: from per_pay_proposals

276: -- changed by schowdhu for 7673294 05-jan-08
277: Cursor chk_approved_flg
278: is
279: select approved
280: from per_pay_proposals
281: where pay_proposal_id = nvl(p_proposal_id, pay_proposal_id)
282: and assignment_id = p_assignment_id
283: and change_date = p_date_to +1 ;
284: begin

Line 301: update per_pay_proposals

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

Line 714: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

710: l_inv_next_perf_date_warning boolean;
711: l_approved_warning boolean;
712: l_payroll_warning boolean;
713: l_proposed_salary_warning boolean;
714: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
715: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
716: l_object_version_number per_pay_proposals.object_version_number%TYPE;
717: l_pyp_proposed_sal_warning boolean;
718: l_additional_comp_warning boolean;

Line 715: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

711: l_approved_warning boolean;
712: l_payroll_warning boolean;
713: l_proposed_salary_warning boolean;
714: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
715: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
716: l_object_version_number per_pay_proposals.object_version_number%TYPE;
717: l_pyp_proposed_sal_warning boolean;
718: l_additional_comp_warning boolean;
719: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal

Line 716: l_object_version_number per_pay_proposals.object_version_number%TYPE;

712: l_payroll_warning boolean;
713: l_proposed_salary_warning boolean;
714: l_last_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
715: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
716: l_object_version_number per_pay_proposals.object_version_number%TYPE;
717: l_pyp_proposed_sal_warning boolean;
718: l_additional_comp_warning boolean;
719: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal
720: l_approved VARCHAR2(1);

Line 723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;

719: l_autoApprove varchar2(1); --added by vkodedal 08-Oct-2007 ER auto Approve first proposal
720: l_approved VARCHAR2(1);
721: --
722: --
723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;

Line 724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;

720: l_approved VARCHAR2(1);
721: --
722: --
723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;

Line 725: l_change_date per_pay_proposals.change_date%TYPE;

721: --
722: --
723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number

Line 726: l_multiple_components per_pay_proposals.multiple_components%TYPE;

722: --
723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;

Line 727: l_pyp_approved per_pay_proposals.approved%TYPE;

723: l_proposed_salary per_pay_proposals.proposed_salary_n%TYPE;
724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;
731: --

Line 728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;

724: l_proposed_salary_db per_pay_proposals.proposed_salary_n%TYPE;
725: l_change_date per_pay_proposals.change_date%TYPE;
726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;
731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;

Line 730: per_pay_proposals.object_version_number%TYPE;

726: l_multiple_components per_pay_proposals.multiple_components%TYPE;
727: l_pyp_approved per_pay_proposals.approved%TYPE;
728: l_proposal_reason per_pay_proposals.proposal_reason%TYPE;
729: l_pyp_object_version_number
730: per_pay_proposals.object_version_number%TYPE;
731: --
732: l_change_amount per_pay_proposal_components.change_amount_n%TYPE;
733: l_change_percentage per_pay_proposal_components.change_percentage%TYPE;
734: l_component_reason per_pay_proposal_components.component_reason%TYPE;

Line 751: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=

747: l_total_component_sum number (20,6):=0;
748: l_comp_update boolean := false;
749: l_prop_update boolean := false;
750: --
751: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=
752: p_pay_proposal_id;
753: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
754: p_object_version_number;
755: --

Line 753: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=

749: l_prop_update boolean := false;
750: --
751: l_pyp_pay_pro_id per_pay_proposals.pay_proposal_id%TYPE:=
752: p_pay_proposal_id;
753: l_pyp_ovn per_pay_proposals.object_version_number%TYPE:=
754: p_object_version_number;
755: --
756: l_component_id_1 per_pay_proposal_components.component_id%TYPE:=
757: p_component_id_1;

Line 829: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;

825: lt_component_id_9 number := p_component_id_9;
826: lt_ppc_ovn_9 number := p_ppc_object_version_number_9;
827: lt_component_id_10 number := p_component_id_10;
828: lt_ppc_ovn_10 number := p_ppc_object_version_number_10;
829: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;
830: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;
831: --
832: -- plsql table types
833: --

Line 830: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;

826: lt_ppc_ovn_9 number := p_ppc_object_version_number_9;
827: lt_component_id_10 number := p_component_id_10;
828: lt_ppc_ovn_10 number := p_ppc_object_version_number_10;
829: l_date_to PER_PAY_PROPOSALS.DATE_TO%TYPE;
830: l_next_change_date PER_PAY_PROPOSALS.CHANGE_DATE%TYPE;
831: --
832: -- plsql table types
833: --
834: l_comp_reason_table t_of_char;

Line 845: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;

841: l_change_percentage_table t_of_number2;
842: --
843: -- elements
844: --
845: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;
846:
847: l_element_type_id pay_element_types_f.element_type_id%TYPE;
848: l_input_value_id pay_input_values_f.input_value_id%TYPE;
849: l_element_link_id pay_element_links_f.element_link_id%TYPE;

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

857: -- For example, if a user has more than ten components then this
858: -- business process processes the first 10 and add any additionals as well.
859: --
860: cursor csr_sum_of_components
861: (c_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE) is
862: select sum(change_amount_n)
863: from per_pay_proposal_components
864: where pay_proposal_id = c_pay_proposal_id;
865:

Line 896: from per_pay_proposals

892: -- cursor to get the last_proposed_salary which has been approved.
893: --
894: cursor csr_get_last_approved_salary is
895: select proposed_salary_n
896: from per_pay_proposals
897: where assignment_id = p_assignment_id
898: and change_date < l_trunc_date
899: order by change_date desc;
900: --

Line 910: from per_pay_proposals

906: multiple_components,
907: approved,
908: proposal_reason,
909: object_version_number
910: from per_pay_proposals
911: where assignment_id = p_assignment_id
912: and pay_proposal_id = p_pay_proposal_id
913: and business_group_id = p_business_group_id;
914: --

Line 933: from per_pay_proposals

929: -- included p_change_date as input param
930: Cursor next_change_date(p_change_date DATE)
931: IS
932: select min(change_date)
933: from per_pay_proposals
934: where assignment_id = p_assignment_id
935: and change_date > p_change_date;
936:
937: begin

Line 1476: -- per_pay_proposals table using the row_handler

1472: l_next_sal_review_date := null;
1473: end if;
1474:
1475: -- insert an unapproved single component salary proposal record in
1476: -- per_pay_proposals table using the row_handler
1477: --
1478: end_date_salary_proposal(p_assignment_id => p_assignment_id
1479: ,p_date_to => p_change_date-1);
1480: ----------vkodedal 7-mar-07