56: ,l_budget_justification
57: ,l_location_code
58: ,1
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
62: ,fnd_global.user_id
63: ,fnd_global.login_id);
64:
58: ,1
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
62: ,fnd_global.user_id
63: ,fnd_global.login_id);
64:
65: END create_budget_detail;
66:
59: ,sysdate
60: ,fnd_global.user_id
61: ,sysdate
62: ,fnd_global.user_id
63: ,fnd_global.login_id);
64:
65: END create_budget_detail;
66:
67: PROCEDURE create_budget_personnel_amts (
93: ,l_calculated_cost
94: ,l_calculated_cost_sharing
95: ,1
96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id);
101: END create_budget_personnel_amts;
95: ,1
96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id);
101: END create_budget_personnel_amts;
102:
103: PROCEDURE create_budget_detail_amts (p_proposal_id NUMBER
96: ,sysdate
97: ,fnd_global.user_id
98: ,sysdate
99: ,fnd_global.user_id
100: ,fnd_global.login_id);
101: END create_budget_personnel_amts;
102:
103: PROCEDURE create_budget_detail_amts (p_proposal_id NUMBER
104: ,p_version_id NUMBER
137: ,p_calculated_cost
138: ,p_calculated_cost_sharing
139: ,1
140: ,sysdate
141: ,fnd_global.user_id
142: ,sysdate
143: ,fnd_global.user_id
144: ,fnd_global.login_id);
145: END;
139: ,1
140: ,sysdate
141: ,fnd_global.user_id
142: ,sysdate
143: ,fnd_global.user_id
144: ,fnd_global.login_id);
145: END;
146:
147: --------------------------------------------------------------------------------------------
140: ,sysdate
141: ,fnd_global.user_id
142: ,sysdate
143: ,fnd_global.user_id
144: ,fnd_global.login_id);
145: END;
146:
147: --------------------------------------------------------------------------------------------
148: /* Lines are not generated for expenditure types/categories with
518: ,l_apply_rate_flag_oh
519: ,nvl(l_oh_value_ov,0)
520: ,nvl(l_calculated_cost_share_ov,0)
521: ,sysdate
522: ,fnd_global.user_id
523: ,sysdate
524: ,fnd_global.user_id
525: ,fnd_global.login_id);
526: end if;
520: ,nvl(l_calculated_cost_share_ov,0)
521: ,sysdate
522: ,fnd_global.user_id
523: ,sysdate
524: ,fnd_global.user_id
525: ,fnd_global.login_id);
526: end if;
527: l_input_amount := l_base_amount;
528: END LOOP;
521: ,sysdate
522: ,fnd_global.user_id
523: ,sysdate
524: ,fnd_global.user_id
525: ,fnd_global.login_id);
526: end if;
527: l_input_amount := l_base_amount;
528: END LOOP;
529:
631: ,l_apply_rate_flag_oh
632: ,0
633: ,0
634: ,sysdate
635: ,fnd_global.user_id
636: ,sysdate
637: ,fnd_global.user_id
638: ,fnd_global.login_id);
639: end if;
633: ,0
634: ,sysdate
635: ,fnd_global.user_id
636: ,sysdate
637: ,fnd_global.user_id
638: ,fnd_global.login_id);
639: end if;
640:
641: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
634: ,sysdate
635: ,fnd_global.user_id
636: ,sysdate
637: ,fnd_global.user_id
638: ,fnd_global.login_id);
639: end if;
640:
641: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
642: insert into igw_budget_details_cal_amts (
664: ,l_apply_rate_flag_eb
665: ,0
666: ,0
667: ,sysdate
668: ,fnd_global.user_id
669: ,sysdate
670: ,fnd_global.user_id
671: ,fnd_global.login_id);
672: end if;
666: ,0
667: ,sysdate
668: ,fnd_global.user_id
669: ,sysdate
670: ,fnd_global.user_id
671: ,fnd_global.login_id);
672: end if;
673:
674: if l_dummy_value is null then
667: ,sysdate
668: ,fnd_global.user_id
669: ,sysdate
670: ,fnd_global.user_id
671: ,fnd_global.login_id);
672: end if;
673:
674: if l_dummy_value is null then
675: for rec_budget_personnel in c_budget_personnel
881: ,rec_budget_personnel.cost_sharing_percent
882: ,rec_budget_personnel.cost_sharing_percent/100 *l_inflated_salary_ov
883: ,l_oh_value_ov - l_oh_value
884: ,sysdate
885: ,fnd_global.user_id
886: ,sysdate
887: ,fnd_global.user_id
888: ,fnd_global.login_id);
889:
883: ,l_oh_value_ov - l_oh_value
884: ,sysdate
885: ,fnd_global.user_id
886: ,sysdate
887: ,fnd_global.user_id
888: ,fnd_global.login_id);
889:
890: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
891: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
884: ,sysdate
885: ,fnd_global.user_id
886: ,sysdate
887: ,fnd_global.user_id
888: ,fnd_global.login_id);
889:
890: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
891: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
892: create_budget_personnel_amts (
1392: ,l_apply_rate_flag_oh
1393: ,l_oh_value
1394: ,l_calculated_cost_share
1395: ,sysdate
1396: ,fnd_global.user_id
1397: ,sysdate
1398: ,fnd_global.user_id
1399: ,fnd_global.login_id);
1400:
1394: ,l_calculated_cost_share
1395: ,sysdate
1396: ,fnd_global.user_id
1397: ,sysdate
1398: ,fnd_global.user_id
1399: ,fnd_global.login_id);
1400:
1401: end if;
1402: END LOOP;
1395: ,sysdate
1396: ,fnd_global.user_id
1397: ,sysdate
1398: ,fnd_global.user_id
1399: ,fnd_global.login_id);
1400:
1401: end if;
1402: END LOOP;
1403: elsif rec_budget_details.personnel_attached_flag = 'Y' then
1529: ,'Y'
1530: ,0
1531: ,0
1532: ,sysdate
1533: ,fnd_global.user_id
1534: ,sysdate
1535: ,fnd_global.user_id
1536: ,fnd_global.login_id);
1537: end if;
1531: ,0
1532: ,sysdate
1533: ,fnd_global.user_id
1534: ,sysdate
1535: ,fnd_global.user_id
1536: ,fnd_global.login_id);
1537: end if;
1538:
1539: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
1532: ,sysdate
1533: ,fnd_global.user_id
1534: ,sysdate
1535: ,fnd_global.user_id
1536: ,fnd_global.login_id);
1537: end if;
1538:
1539: if l_rate_class_id_eb is not null and l_rate_type_id_eb is not null then
1540: insert into igw_budget_details_cal_amts (
1562: ,'Y'
1563: ,0
1564: ,0
1565: ,sysdate
1566: ,fnd_global.user_id
1567: ,sysdate
1568: ,fnd_global.user_id
1569: ,fnd_global.login_id);
1570: end if;
1564: ,0
1565: ,sysdate
1566: ,fnd_global.user_id
1567: ,sysdate
1568: ,fnd_global.user_id
1569: ,fnd_global.login_id);
1570: end if;
1571:
1572:
1565: ,sysdate
1566: ,fnd_global.user_id
1567: ,sysdate
1568: ,fnd_global.user_id
1569: ,fnd_global.login_id);
1570: end if;
1571:
1572:
1573: if l_dummy_value is null then
1731: ,rec_budget_personnel.cost_sharing_percent
1732: ,rec_budget_personnel.cost_sharing_percent/100 * l_inflated_salary
1733: ,rec_budget_personnel.underrecovery_amount
1734: ,sysdate
1735: ,fnd_global.user_id
1736: ,sysdate
1737: ,fnd_global.user_id
1738: ,fnd_global.login_id);
1739:
1733: ,rec_budget_personnel.underrecovery_amount
1734: ,sysdate
1735: ,fnd_global.user_id
1736: ,sysdate
1737: ,fnd_global.user_id
1738: ,fnd_global.login_id);
1739:
1740: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
1741: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
1734: ,sysdate
1735: ,fnd_global.user_id
1736: ,sysdate
1737: ,fnd_global.user_id
1738: ,fnd_global.login_id);
1739:
1740: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
1741: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
1742: create_budget_personnel_amts (