DBA Data[Home] [Help]

APPS.POR_CHANGE_REQUEST_PKG dependencies on POR_VIEW_REQS_PKG

Line 840: old_nonrec_tax := por_view_reqs_pkg.get_line_nonrec_tax_total(reqlineid);

836: prl.requisition_line_id = reqlineid AND
837: prl.requisition_line_id = prd.requisition_line_id;
838:
839: -- get old tax
840: old_nonrec_tax := por_view_reqs_pkg.get_line_nonrec_tax_total(reqlineid);
841:
842: changed_tax_total := nvl((old_nonrec_tax * (new_line_total / old_line_total)), 0);
843:
844: RETURN changed_tax_total;

Line 876: old_rec_tax := por_view_reqs_pkg.get_line_rec_tax_total(reqlineid);

872: prl.requisition_line_id = reqlineid AND
873: prl.requisition_line_id = prd.requisition_line_id;
874:
875: -- get old tax
876: old_rec_tax := por_view_reqs_pkg.get_line_rec_tax_total(reqlineid);
877:
878: changed_tax_total := nvl((old_rec_tax * (new_line_total / old_line_total)), 0);
879:
880: RETURN changed_tax_total;

Line 1720: old_nonrec_tax := por_view_reqs_pkg.get_line_nonrec_tax_total(reqlineid);

1716: prl.requisition_line_id = reqlineid AND
1717: prl.requisition_line_id = prd.requisition_line_id;
1718:
1719: -- get old tax
1720: old_nonrec_tax := por_view_reqs_pkg.get_line_nonrec_tax_total(reqlineid);
1721:
1722: changed_tax_total := nvl((old_nonrec_tax * (new_line_total / old_line_total)), 0);
1723:
1724: RETURN changed_tax_total;

Line 1757: old_rec_tax := por_view_reqs_pkg.get_line_rec_tax_total(reqlineid);

1753: prl.requisition_line_id = reqlineid AND
1754: prl.requisition_line_id = prd.requisition_line_id;
1755:
1756: -- get old tax
1757: old_rec_tax := por_view_reqs_pkg.get_line_rec_tax_total(reqlineid);
1758:
1759: changed_tax_total := nvl((old_rec_tax * (new_line_total / old_line_total)), 0);
1760:
1761: RETURN changed_tax_total;